def post(self,request):
try:
if self.request.query_params.get("Group") == "CUST_GROUP_GET":
obj_custgroup = mMasters.Masters()
obj_custgroup.custgrp_gid = self.request.query_params.get("Cust_Group_Gid")
obj_custgroup.custgrp_code = self.request.query_params.get("Cust_Group_Code")
obj_custgroup.custgrp_name = self.request.query_params.get("Cust_Group_Name")
obj_custgroup.entity_gid = self.request.query_params.get("Entity_Gid")
obj_custgroup.mysql_limit = self.request.query_params.get("Query_Limit")
df_out_message = obj_custgroup.get_custgrp()
if df_out_message.empty == False:
json_data = json.loads(df_out_message.to_json(orient='records'))
return Response({"MESSAGE": "FOUND", "DATA": json_data})
else:
return Response({"MESSAGE": "NOT_FOUND"})
elif self.request.query_params.get("Group") == "CUST_GET":
obj_cust = mMasters.Masters()
obj_cust.customer_gid = 0;
obj_cust.jsonData = json.loads(request.body.decode('utf-8')).get('params').get('FILTER')
obj_cust.customer_code = 0;
obj_cust.customer_name = '';
obj_cust.entity_gid = self.request.query_params.get("Entity_Gid")
obj_cust.jsonData = json.dumps(obj_cust.jsonData)
df_out_message = obj_cust.get_customer()
if df_out_message.empty == False:
json_data = json.loads(df_out_message.to_json(orient='records'))
return Response({"MESSAGE": "FOUND", "DATA": json_data})
else:
return Response({"MESSAGE": "NOT_FOUND"})
except Exception as e:
return Response({"MESSAGE":"ERROR","DATA":str(e)})
def get_categorygroup(request):
if request.method == 'GET':
obj_cat = mMasters.Masters()
obj_cat.table_name = 'custcategory'
obj_cat.entity_gid = request.session['Entity_gid']
dict_custgrp = obj_cat.get_Masters()
return JsonResponse(json.dumps(dict_custgrp), safe=False)
def post(self, request):
try:
if self.request.query_params.get("Group") == "BRANCH_SALES":
jsondata = json.loads(request.body.decode('utf-8'))
obj_classification = mMasters.Masters()
obj_classification.type = self.request.query_params.get("Type")
obj_classification.sub_type = self.request.query_params.get(
"Sub_Type")
obj_classification.jsonData = json.dumps(
jsondata.get('Params').get('FILTER'))
obj_classification.json_classification = json.dumps(
jsondata.get('Params').get('CLASSIFICATION'))
ld_out_message = obj_classification.get_classification_summary(
)
if ld_out_message.get("MESSAGE") == 'FOUND':
ld_dict = {
"DATA":
json.loads(
ld_out_message.get("DATA").to_json(
orient='records')),
"MESSAGE":
"FOUND"
}
elif ld_out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": ld_out_message.get("MESSAGE")}
else:
ld_dict = {
"MESSAGE":
'ERROR_OCCURED.' + ld_out_message.get("MESSAGE")
}
return Response(ld_dict)
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def pendingsmry(request):
if request.method == 'GET':
obj_pendingsmry = mMasters.Masters()
obj_pendingsmry.action = 'Pendingsummary'
obj_pendingsmry.customer_gid = request.GET['cust_gid']
result_ent = obj_pendingsmry.get_pendingsummary_get()
jdata = result_ent.to_json(orient='records')
return JsonResponse(jdata, safe=False)
def get_metadata(request):
if request.method == 'GET':
obj_custdata = mMasters.Masters()
obj_custdata.table_name = request.GET['tablename']
obj_custdata.column_name = request.GET['columnname']
obj_custdata.entity_gid = request.session['Entity_gid']
dict_custdata = obj_custdata.getmetadata()
jdata = dict_custdata.to_json(orient='records')
return JsonResponse(jdata, safe=False)
def setDayroute(request):
if request.method == 'GET':
jsondata = json.loads(request.GET['day'])
obj_position = mMasters.Masters()
obj_position.action = request.GET['action']
obj_position.jsonData = jsondata
obj_position.entity_gid = request.session['Entity_gid']
obj_position.create_by = request.session['Emp_gid']
df_position = obj_position.dayrouteset()
return JsonResponse(df_position, safe=False)
def employedaymap(request):
if request.method == 'POST':
obj_setroute = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8')).get('parms')
obj_setroute.action = jsondata.get('action')
obj_setroute.json_employee_gid = json.dumps(jsondata.get('emp_det'))
obj_setroute.create_by = request.session['Emp_gid']
obj_setroute.entity_gid = request.session['Entity_gid']
out_message = mcommon.outputReturn(obj_setroute.setRouteDtl(), 1)
return JsonResponse(out_message, safe=False)
def routedaymap(request):
if request.method == 'GET':
objenti = mMasters.Masters()
objenti.action = 'ROUTE_DAYS'
objenti.json_employee_gid = ' {"routeemp_gid": ' + request.GET[
'emp_gid'] + '}'
objenti.entity_gid = request.session['Entity_gid']
result_ent = objenti.getRouteDtl()
jdata = result_ent.to_json(orient='records')
return JsonResponse(jdata, safe=False)
def getproposed(request):
if request.method == 'GET':
objenti = mMasters.Masters()
objenti.action = 'proposedbill'
objenti.type = ""
objenti.jsonData = ' {"customer_gid": ' + request.GET[
'cust_gid'] + ',"soheader_gid":' + request.GET['soheader_gid'] + '}'
objenti.entity_gid = request.session['Entity_gid']
result_ent = objenti.getcreditapprv()
jdata = result_ent.to_json(orient='records')
return JsonResponse(jdata, safe=False)
def get(self,request):
try:
common = mMasters.Masters()
common.table_name = self.request.query_params.get("table_name")
common.gid = self.request.query_params.get("search_gid")
common.name = self.request.query_params.get("search_name")
common.entity_gid = self.request.query_params.get("entity_gid")
output = common.get_ddl()
return Response({"MESSAGE": "FOUND","DATA":json.loads(output.to_json(orient='records'))})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def get_mappedcustomer(request):
if request.method == 'POST':
objexe = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
data = jsondata.get('params').get('Emp_gid')
if jsondata.get('params').get('Emp_gid') == None:
objexe.employee_gid = request.session['Emp_gid']
else:
objexe.employee_gid = 0
objexe.action = ''
objexe.entity_gid = request.session['Entity_gid']
df_executive = objexe.getexecmapping()
jdata = df_executive.to_json(orient='records')
return JsonResponse(json.loads(jdata), safe=False)
def getdayroute(request):
if request.method == 'GET':
obj_dayrouteget = mMasters.Masters()
obj_dayrouteget.action = request.GET['action']
obj_dayrouteget.employee_gid = request.GET['emp_gid']
obj_dayrouteget.from_date = request.GET['date']
if request.GET['todate'] == '':
obj_dayrouteget.to_date = ''
else:
obj_dayrouteget.to_date = request.GET['todate']
obj_dayrouteget.entity_gid = request.session['Entity_gid']
df_dayroute = obj_dayrouteget.dayrouteget()
# df_position.rename(columns={'latlong_latitude': 'tesse', 'oldName2': 'newName2'}, inplace=True)
jdata = df_dayroute.to_json(orient='records')
return JsonResponse(json.loads(jdata), safe=False)
def post(self, request):
try:
obj_State = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
obj_State.type = self.request.query_params.get("Type")
obj_State.sub_type = self.request.query_params.get("Subtype")
obj_State.create_by = self.request.query_params.get("Emp_Gid")
obj_State.json_classification = json.dumps(
jsondata.get('Parms').get('Classification'))
obj_State.json_filters = json.dumps(
jsondata.get('Parms').get('Filter'))
out_message = obj_State.get_StatePrice()
if len(out_message) > 0:
return Response({"MESSAGE": "FOUND", "DATA": out_message})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
obj_values = mMasters.Masters()
obj_values.action = ''
obj_values.jsonData = request.body.decode('utf-8')
obj_values.entity_gid = self.request.query_params.get("Entity_Gid")
out_message = obj_values.get_alltablevalue()
if out_message.empty == False:
json_data = json.loads(out_message.to_json(orient='records'))
return Response({"MESSAGE": "FOUND", "DATA": json_data})
else:
return Response({"MESSAGE": "NOT_FOUND"})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get(
"Group"
) == "Product_Category" or "Product_Type" or "Product_Carton_Map" or "insert_data" or "":
jsondata = json.loads(request.body.decode('utf-8'))
obj_prodcat = mMasters.Masters()
obj_prodcat.action = self.request.query_params.get("Action")
obj_prodcat.type = self.request.query_params.get("Type")
obj_prodcat.jsonData = json.dumps(jsondata)
out_message = obj_prodcat.Set_Productcat()
if out_message[0] == "SUCCESS" or "SUCCESSFULLY UPDATED":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({
"MESSAGE": "FAIL",
"DATA": str(out_message[0])
})
except Exception as e:
return Response({"MESSAGE": "ERROR", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "CLUSTER_EMPMAP_FLAG":
jsondata = json.loads(request.body.decode('utf-8'))
obj_cluster = mMasters.Masters()
obj_cluster.action = self.request.query_params.get("Group")
obj_cluster.jsondata = json.dumps(
jsondata.get('Classification'))
ldf_cluster = obj_cluster.get_cluster()
if ldf_cluster.empty == False:
return Response({
"MESSAGE":
"FOUND",
"DATA":
json.loads(ldf_cluster.to_json(orient='records'))
})
else:
return Response({"MESSAGE": "NOT_FOUND"})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "Product_Get":
jsondata = json.loads(request.body.decode('utf-8'))
obj_product = mFET.FET_model()
obj_product.type = self.request.query_params.get("Type")
obj_product.subtype = self.request.query_params.get("SubType")
obj_product.jsondata = json.dumps(jsondata.get('Filters'))
out_message = obj_product.getsmry_product()
if out_message.get("MESSAGE") == 'FOUND':
ld_dict = {
"DATA":
json.loads(
out_message.get("DATA").to_json(orient='records')),
"MESSAGE":
"FOUND"
}
elif out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": out_message.get("MESSAGE")}
else:
ld_dict = {
"MESSAGE":
'ERROR_OCCURED.' + out_message.get("MESSAGE")
}
return Response(ld_dict)
elif self.request.query_params.get("Group") == "Product_Set":
jsondata = json.loads(request.body.decode('utf-8'))
obj_product_set = mMasters.Masters()
obj_product_set.action = self.request.query_params.get(
"Action")
obj_product_set.type = self.request.query_params.get("Type")
obj_product_set.jsonData = json.dumps(jsondata.get("data"))
out_message = obj_product_set.Set_Productcat()
if out_message[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({"MESSAGE": str(out_message[0])})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "CAMPAIGN_GET":
obj_campaign = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
obj_campaign.type = self.request.query_params.get("Type")
obj_campaign.sub_type = self.request.query_params.get(
"Subtype")
obj_campaign.jsonData = json.dumps(
jsondata.get('Parms').get('Filter'))
obj_campaign.json_classification = json.dumps(
jsondata.get('Parms').get('Classification'))
df_outmessage = obj_campaign.get_campaign()
if df_outmessage.empty == False:
json_data = json.loads(
df_outmessage.to_json(orient='records'))
return Response({"MESSAGE": "FOUND", "DATA": json_data})
else:
return Response({"MESSAGE": "NOT_FOUND"})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "CCBS_MASTER":
obj_campaign = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
obj_campaign.type = self.request.query_params.get("Type")
obj_campaign.sub_type = self.request.query_params.get(
"Sub_type")
obj_campaign.jsonData = json.dumps(
jsondata.get('Params').get('FILTER'))
obj_campaign.json_classification = json.dumps(
jsondata.get('Params').get('CLASSIFICATION'))
df_outmessage = obj_campaign.get_CCBS_Master()
if df_outmessage.empty == False:
json_data = json.loads(
df_outmessage.to_json(orient='records'))
return Response({"MESSAGE": "FOUND", "DATA": json_data})
else:
return Response({"MESSAGE": "NOT_FOUND"})
if self.request.query_params. \
get("Group") == "SET_CATEGORY_AND_SUBCATEGORY_MASTER":
obj_campaign = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
obj_campaign.type = self.request.query_params.get("Type")
obj_campaign.sub_type = self.request.query_params.get(
"Sub_type")
obj_campaign.jsonData = json.dumps(
jsondata.get('Params').get('FILTER'))
obj_campaign.json_classification = json.dumps(
jsondata.get('Params').get('CLASSIFICATION'))
df_outmessage = obj_campaign.set_cat_subcat_Master()
if df_outmessage[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({"MESSAGE": str(df_outmessage[0])})
if self.request.query_params.get("Group") == "SET_CCBS_MASTER":
obj_campaign = mMasters.Masters()
jsondata = json.loads(request.body.decode('utf-8'))
obj_campaign.type = self.request.query_params.get("Type")
obj_campaign.sub_type = self.request.query_params.get(
"Sub_type")
obj_campaign.jsonData = json.dumps(
jsondata.get('Params').get('FILTER'))
obj_campaign.json_classification = json.dumps(
jsondata.get('Params').get('CLASSIFICATION'))
df_outmessage = obj_campaign.set_CCBS_Master()
if df_outmessage[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({"MESSAGE": str(df_outmessage[0])})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "Supplier_Get":
jsondata = json.loads(request.body.decode('utf-8'))
obj_supplier = mMasters.Masters()
obj_supplier.type = self.request.query_params.get("Type")
obj_supplier.sub_type = self.request.query_params.get(
"SubType")
obj_supplier.json_supplier = json.dumps(
jsondata.get('Params').get('Details'))
obj_supplier.json_classification = json.dumps(
jsondata.get('Params').get('Classification'))
out_message = obj_supplier.get_Supplier()
if out_message.get("MESSAGE") == 'FOUND':
ld_dict = {
"DATA":
json.loads(
out_message.get("DATA").to_json(orient='records')),
"MESSAGE":
"FOUND"
}
elif out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": out_message.get("MESSAGE")}
else:
ld_dict = {
"MESSAGE":
'ERROR_OCCURED.' + out_message.get("MESSAGE")
}
return Response(ld_dict)
if self.request.query_params.get("Group") == "Supplier_Set":
jsondata = json.loads(request.body.decode('utf-8'))
obj_supplier = mMasters.Masters()
obj_supplier.action = self.request.query_params.get("Action")
obj_supplier.json_supplier = json.dumps(
jsondata.get('Params').get('Supplier'))
obj_supplier.json_address = json.dumps(
jsondata.get('Params').get('Address'))
obj_supplier.json_contact = json.dumps(
jsondata.get('Params').get('Contact'))
obj_supplier.json_clasfication = json.dumps(
jsondata.get('Params').get('Classification'))
out_message = obj_supplier.set_Supplier()
if out_message[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({
"MESSAGE": "FAIL",
"DATA": str(out_message[0])
})
elif self.request.query_params.get("Group") == "Supplier_Update":
jsondata = json.loads(request.body.decode('utf-8'))
obj_supplier = mMasters.Masters()
obj_supplier.action = self.request.query_params.get("Action")
obj_supplier.json_supplier = json.dumps(
jsondata.get('Params').get('Supplier'))
obj_supplier.json_address = json.dumps(
jsondata.get('Params').get('Address'))
obj_supplier.json_contact = json.dumps(
jsondata.get('Params').get('Contact'))
obj_supplier.json_clasfication = json.dumps(
jsondata.get('Params').get('Classification'))
out_message = obj_supplier.set_Supplier()
if out_message[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({
"MESSAGE": "FAIL",
"DATA": str(out_message[0])
})
elif self.request.query_params.get(
"Group") == "Active_INactive_supplier":
jsondata = json.loads(request.body.decode('utf-8'))
obj_supplier = mMasters.Masters()
obj_supplier.action = self.request.query_params.get("Action")
obj_supplier.json_supplier = json.dumps(
jsondata.get('parms').get('supplier'))
obj_supplier.json_address = '{}'
obj_supplier.json_contact = '{}'
obj_supplier.json_clasfication = json.dumps(
jsondata.get('parms').get('classification'))
out_message = obj_supplier.set_Supplier()
if out_message[0] == "SUCCESS":
return Response({"MESSAGE": "SUCCESS"})
else:
return Response({
"MESSAGE": "FAIL",
"DATA": str(out_message[0])
})
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
def post(self, request):
try:
if self.request.query_params.get("Group") == "CUST_All_GROUP_GET":
obj_allcustomer = mMasters.Masters()
obj_allcustomer.type = self.request.query_params.get("Type")
obj_allcustomer.sub_type = self.request.query_params.get("Sub_Type")
obj_allcustomer.jsonData = json.loads(request.body.decode('utf-8')).get('Params').get('FILTER')
obj_allcustomer.jsonData = json.dumps(obj_allcustomer.jsonData)
obj_allcustomer.limit = self.request.query_params.get("Limit")
obj_allcustomer.json_classification = json.loads(request.body.decode('utf-8')).get('Params').get('CLASSIFICATION')
obj_allcustomer.json_classification = json.dumps(obj_allcustomer.json_classification)
ld_out_message = obj_allcustomer.get_AllCustomer()
if ld_out_message.get("MESSAGE") == 'FOUND':
ld_dict = {"DATA": json.loads(ld_out_message.get("DATA").to_json(orient='records')),
"MESSAGE": "FOUND"}
elif ld_out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": ld_out_message.get("MESSAGE")}
else:
ld_dict = {"MESSAGE": 'ERROR_OCCURED.' + ld_out_message.get("MESSAGE")}
return Response(ld_dict)
elif self.request.query_params.get("Group") == "CUST_All_GET":
obj_allproduct = mMasters.Masters()
obj_allproduct.type = self.request.query_params.get("Type")
obj_allproduct.sub_type = self.request.query_params.get("Sub_Type")
obj_allproduct.jsonData = json.loads(request.body.decode('utf-8')).get('Params').get('FILTER')
obj_allproduct.jsonData = json.dumps(obj_allproduct.jsonData)
obj_allproduct.limit = self.request.query_params.get("Limit")
obj_allproduct.json_classification = json.loads(request.body.decode('utf-8')).get('Params').get('CLASSIFICATION')
obj_allproduct.json_classification = json.dumps(obj_allproduct.json_classification)
ld_out_message = obj_allproduct.get_AllCustomer()
if ld_out_message.get("MESSAGE") == 'FOUND':
ld_dict = {"DATA": json.loads(ld_out_message.get("DATA").to_json(orient='records')),
"MESSAGE": "FOUND"}
elif ld_out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": ld_out_message.get("MESSAGE")}
else:
ld_dict = {"MESSAGE": 'ERROR_OCCURED.' + ld_out_message.get("MESSAGE")}
return Response(ld_dict)
elif self.request.query_params.get("Group") == "CUSTOMER_ADDRESS":
obj_allproduct = mMasters.Masters()
obj_allproduct.type = self.request.query_params.get("Type")
obj_allproduct.sub_type = self.request.query_params.get("Sub_Type")
obj_allproduct.jsonData = json.loads(request.body.decode('utf-8')).get('Params').get('FILTER')
obj_allproduct.jsonData = json.dumps(obj_allproduct.jsonData)
obj_allproduct.limit = self.request.query_params.get("Limit")
obj_allproduct.json_classification = json.loads(request.body.decode('utf-8')).get('Params').get('CLASSIFICATION')
obj_allproduct.json_classification = json.dumps(obj_allproduct.json_classification)
ld_out_message = obj_allproduct.get_AllCustomer()
if ld_out_message.get("MESSAGE") == 'FOUND':
ld_dict = {"DATA": json.loads(ld_out_message.get("DATA").to_json(orient='records')),
"MESSAGE": "FOUND"}
elif ld_out_message.get("MESSAGE") == 'NOT_FOUND':
ld_dict = {"MESSAGE": ld_out_message.get("MESSAGE")}
else:
ld_dict = {"MESSAGE": 'ERROR_OCCURED.' + ld_out_message.get("MESSAGE")}
return Response(ld_dict)
except Exception as e:
return Response({"MESSAGE": "ERROR_OCCURED", "DATA": str(e)})
