def CancelReceipt(request):
if request.method == 'POST':
jsondata = json.loads(request.body.decode('utf-8'))
obj = mSales.Sales_Model()
obj.action = jsondata.get('Action')
obj.type = jsondata.get('Type')
obj.sub_type = jsondata.get('Sub_Type')
obj.group = jsondata.get('Group')
obj.employee_id = json.dumps(jsondata.get('Employee_Gid'))
params = {
'Action': "" + obj.action + "",
'Type': "" + obj.type + "",
'Sub_Type': "" + obj.sub_type + "",
'Group': "" + obj.group + "",
'Employee_Gid': "" + obj.employee_id + ""
}
headers = {
"content-type": "application/json",
"Authorization": "" + token + ""
}
datas = json.dumps(jsondata.get('data'))
resp = requests.post("" + ip + "/Receipt_Process_API",
params=params,
data=datas,
headers=headers,
verify=False)
response = resp.content.decode("utf-8")
return HttpResponse(response)
def performance_excel(request):
if request.method == 'GET':
jsondata = json.loads(request.GET['Main'])
jsondata1 = json.loads(request.GET['Sub'])
obj_totalsales = mSales.Sales_Model()
obj_totalsales.type = jsondata.get('Type')
obj_totalsales.sub_type = jsondata.get('Sub_Type')
obj_totalsales.jsonData = json.dumps(
jsondata1.get('Params').get('FILTER'))
obj_totalsales.json_classification = \
json.dumps(jsondata1.get('Params').get('CLASSIFICATION'))
XLSX_MIME = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
response = HttpResponse(content_type=XLSX_MIME)
response[
'Content-Disposition'] = 'attachment; filename="PythonExport.xlsx"'
writer = pd.ExcelWriter(response, engine='xlsxwriter')
df_view = obj_totalsales.get_sales()
df_view['CUSTOMER_NAME'] = df_view['customer_name']
df_view['EMPLOYEE_NAME'] = df_view['employee_name']
df_view['BRANCH_NAME'] = df_view['branch_name']
df_view['DEPARTMENT_NAME'] = df_view['dept_name']
df_view['LOCATION_NAME'] = df_view['location_name']
df_view['MONTH_WISE'] = df_view['mntdate']
df_view['SALES'] = df_view['invtot']
df_view['RECEIPT'] = df_view['reptamt']
df_view['CREDIT'] = df_view['cramt']
df_view['OUTSTANDING'] = df_view['oss']
final = df_view[[
'CUSTOMER_NAME', 'EMPLOYEE_NAME', 'BRANCH_NAME', 'DEPARTMENT_NAME',
'LOCATION_NAME', 'MONTH_WISE', 'SALES', 'RECEIPT', 'CREDIT',
'OUTSTANDING'
]]
final.to_excel(writer, 'Sheet1')
writer.save()
return response
def stock_sales_order_get(request):
if request.method == 'POST':
obj_salesget = mSales.Sales_Model()
jsondata = json.loads(request.body.decode('utf-8'))
obj_salesget.action = jsondata.get('parms').get('action')
obj_salesget.customer_gid = jsondata.get('parms').get('custid')
obj_salesget.employee_gid = 0
obj_salesget.date = common.convertdbDate(request.session['date'])
obj_salesget.jsonData = json.dumps({
"Entity_Gid": [request.session['Entity_gid']],
"Client_Gid": [jsondata.get('parms').get('Cname')]
})
if jsondata.get('parms').get('filter') == '{}':
obj_salesget.jsondata = '{}'
else:
obj_salesget.jsondata = jsondata.get('parms').get('filter')
obj_salesget.limit = 30
setsales_order = obj_salesget.get_sales_order()
jdata = setsales_order.to_json(orient='records')
return JsonResponse(json.loads(jdata), safe=False)
def ReceiptSummary(request):
if request.method == 'POST':
jsondata = json.loads(request.body.decode('utf-8'))
obj = mSales.Sales_Model()
obj.grp = jsondata.get('Group')
obj.typ = jsondata.get('Type')
obj.sbtyp = jsondata.get('Sub_Type')
params = {
'Group': "" + obj.grp + "",
'Type': "" + obj.typ + "",
'Sub_Type': "" + obj.sbtyp + ""
}
headers = {
"content-type": "application/json",
"Authorization": "" + token + ""
}
datas = json.dumps(jsondata.get('data'))
resp = requests.post("" + ip + "/Receipt_AR",
params=params,
data=datas,
headers=headers,
verify=False)
response = resp.content.decode("utf-8")
return HttpResponse(response)
def excelgen(request):
if request.method == 'POST' and request.FILES['file']:
try:
current_month = datetime.now().strftime('%m')
current_day = datetime.now().strftime('%d')
current_year_full = datetime.now().strftime('%Y')
save_path = str(settings.MEDIA_ROOT) + '/Bank_Recon/' + str(
current_year_full) + '/' + str(current_month) + '/' + str(
current_day) + '/' + str(request.POST['name'])
path = default_storage.save(str(save_path),
ContentFile('new content'))
path = default_storage.save(str(save_path), request.FILES['file'])
obj = mSales.Sales_Model()
obj.grp = request.POST['Group']
obj.actn = request.POST['Action']
obj.typ = request.POST['Type']
obj.empgid = request.POST['Employee_Gid']
obj.gid = request.POST['Gid']
obj.filepath = path
obj.name = request.POST['name']
f = request.FILES['file']
df = pd.read_excel(f,
skiprows=[0, 1, 2, 3, 4, 5],
sheetname='OpTransactionHistoryUX3')
no = df['No.']
id = df['Transaction ID']
date = df['Value Date']
txndate = df['Txn Posted Date']
des = df['Description']
crdr = df['Cr/Dr']
chenum = df['ChequeNo.']
amnt = df['Transaction Amount(INR)']
availbal = df['Available Balance(INR)']
df = pd.DataFrame({
'SNo': no,
'Tran_Id': id,
'Value_Date': date,
'Posted_Date': txndate,
'Cheque_No': chenum,
'Description': des,
'CR_DR': crdr,
'Transaction_Amount': amnt,
'Status': 'RECEIVED',
'Balance_Amount': availbal
})
# dd = df.set_index('SNo').T.to_dict('list')
ff = df.to_dict('records')
sd = {
"params": {
"DATA": {
"Bank_Gid": "" + obj.gid + "",
"BANK_STMT": ff
},
"FILE": {
"FILE": {
"File_Gid": "0",
"File_Name": obj.name,
"File_Path": obj.filepath
}
},
"CLASSIFICATION": {
"entity_gid": [request.session['Entity_gid']],
"client_gid": []
}
}
}
datas = json.dumps(sd)
resp = requests.post("" + ip + "/BankUpload_API?Group=" + obj.grp +
"&Action=" + obj.actn + "&Type=" + obj.typ +
"&Employee_Gid=" + obj.empgid + "",
data=datas,
headers={
"content-type":
"application/json",
"Authorization":
"Token 7111797114100105971106449505132"
},
verify=False)
response = resp.content.decode("utf-8")
return HttpResponse(response)
except Exception as e:
return JsonResponse(e, safe=False)
def excel(request):
if request.method == 'POST' and request.FILES['file']:
try:
dd = base64.b64encode(request.FILES['file'].read())
ress = dd.decode("utf-8")
obj = mSales.Sales_Model()
obj.grp = request.POST['Group']
obj.actn = request.POST['Action']
obj.typ = request.POST['Type']
obj.sub_typ = request.POST['Sub_Type']
obj.empgid = request.POST['Create_by']
obj.name = request.POST['name']
# obj.employee_gid = json.dumps(request.session['Emp_gid'])
obj.entity_gid = json.dumps(request.session['Entity_gid'])
f = request.FILES['file']
df = pd.read_excel(f)
batchno = df['BATCHNO']
manual_weight = df['WGT']
#delivery_date = pd.to_datetime(df['DLVD_DATE'])
#print(delivery_date)
#DAT = df['DLVD_DATE']
df['DLVD_DATE'] = df['DLVD_DATE'].astype(str)
#df['new_date_column'] = df['DLVD_DATE1'].dt.date
# print (delivery_date)
# pd.to_datetime(df[0]).apply(lambda x:x.strftime('%d/%m/%Y'))
# x=str(datetime.datetime(delivery_date))
# y=x.strftime("%d-%m-%Y")
# date=pd.to_datetime(delivery_date)
# newf=json.dumps(date.dt.date);
# strr=delivery_date.strftime("%d-%m-%Y")
# if len(batchno)==0:
# return HttpResponse({"MESSAGE":"NOT FOUND"})
awbno = df['AWB_NO']
status = df['STATUS']
df1 = pd.DataFrame({
'System_AWB_No': batchno,
'POD_AWB_NO': awbno,
'Delivery_Status': status,
'Delivery_Date': df['DLVD_DATE'],
'Manual_Weight': manual_weight
})
ff = df1.to_dict('records')
# gf=pd.to_datetime(ff);
# print(gf)
dataa = {
"Params": {
"HEADER":
ff,
"File": [{
"File_Name": obj.name,
"File_Extension": request.POST['file_extension'],
"File_Base64data": ress
}],
"DETAILS": {},
"CLASSIFICATION": {
"Entity_Gid": [int(obj.entity_gid)]
}
}
}
dta = json.dumps(dataa)
params = {
'Group': "" + obj.grp + "",
'Action': "" + obj.actn + "",
'Type': "" + obj.typ + "",
'Sub_Type': "" + obj.sub_typ + "",
'Create_by': "" + obj.empgid + ""
}
headers = {
"content-type": "application/json",
"Authorization": "" + token + ""
}
resp = requests.post("" + ip + "/DispatchProcess_Set",
params=params,
data=dta,
headers=headers,
verify=False)
response = resp.content.decode("utf-8")
return HttpResponse(response)
except Exception as e:
return HttpResponse(e)