def searchResourcesMatchesByRegion(self, args):
rname = args['rname']
dao = DashBoardsDAO()
result_list = []
if len(args) == 1 and rname:
need_list = dao.getResourcesMatchesByRegion(rname)
else:
return jsonify(Error="Malformed Query String"), 400
if len(need_list) == 2:
for row in need_list:
if (row == need_list[0]):
result = self.build_available_dictR(row)
elif (row == need_list[1]):
result = self.build_need_dictR(row)
else:
result = self.build_need_dictR(row)
result_list.append(result)
else:
result = self.build_available_dictR(need_list[0])
result_list.append(result)
result = self.build_need_dictR(need_list[0])
result_list.append(result)
if not result_list:
return jsonify(Error="Result Not Found"), 404
else:
if result_list[0].get('value') == 0 and result_list[1].get(
'value') == 0:
result_list[0]['value'] = 50
result_list[1]['value'] = 50
return jsonify(chart=self.build_theme_matchR(rname),
data=result_list), 200
def getResourcesMatchesWeekly(self):
dao = DashBoardsDAO()
need_list = dao.getResourcesMatchesWeekly(
) # Select cid, card_number, security_code, cname, exp_date from Credit_Card
result_list = []
if len(need_list) == 2:
for row in need_list:
if (row == need_list[0]):
result = self.build_available_dict(row)
elif (row == need_list[1]):
result = self.build_need_dict(row)
else:
result = self.build_need_dict(row)
result_list.append(result)
else:
result = self.build_available_dict(need_list[0])
result_list.append(result)
result = self.build_need_dict(need_list[0])
result_list.append(result)
if not result_list:
return jsonify(Error="Result Not Found"), 404
else:
if result_list[0].get('value') == 0 and result_list[1].get(
'value') == 0:
result_list[0]['value'] = 50
result_list[1]['value'] = 50
return jsonify(chart=self.build_theme_matchW(),
data=result_list), 200
def getResourcesAvailablesByRegion(self):
dao = DashBoardsDAO()
need_list = dao.getResourcesAvailablesByRegion(
) #Select cid, card_number, security_code, cname, exp_date from Credit_Card
result_list = []
for row in need_list:
result = self.build_region_dict(row)
result_list.append(result)
if not result_list:
return jsonify(Error="Result Not Found"), 404
else:
return jsonify(chart=self.build_theme_availableR(),
data=result_list), 200