def V_GetStationData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_V_Station傳入作查詢
StoreData = grid.dynamic_query_order(M_V_Station)
#將StoreData傳入作後端分頁
object_list = grid.dynamic_query_order_paginator(StoreData)
#資料總筆數
count = len(StoreData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'StoreID': Store.StoreID,
'StoreName': Store.StoreName,
'StationID': Store.StationID,
'StationName': Store.StationName,
'pk': Store.pk
} for Store in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetPenaltyData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_Penalty傳入作查詢
PenaltyData = grid.dynamic_query_order(M_Penalty)
#將PenaltyData傳入作後端分頁
object_list = grid.dynamic_query_order_paginator(PenaltyData)
#資料總筆數
count = len(PenaltyData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'PenaltyID': penalty.PenaltyID,
'PenaltyName': penalty.PenaltyName,
'Remark': penalty.Remark,
'pk': penalty.pk
} for penalty in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetDealDetailData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
grid = GridCS(request)
DetailData = grid.dynamic_query_order(M_DealDetail)
count = len(DetailData)
data = [{
'FeeID': Detail.FeeID.FeeID,
'FeeName': Detail.FeeID.FeeName,
'Amount': Detail.Amount,
'Qty': Detail.Qty,
'TotalAmount': Detail.TotalAmount,
'Remark': Detail.Remark,
'MasterID': Detail.MasterID.pk
} for Detail in DetailData]
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetCheckoutData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_Checkout傳入作查詢
CheckoutData = grid.dynamic_query_order(M_Checkout)
#將CheckoutData資料作後端分頁
object_list = grid.dynamic_query_order_paginator(CheckoutData)
#資料總筆數
count = len(CheckoutData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'CloseDate':
Checkout.CloseDate,
'Editor':
Checkout.Editor.username,
'RecordTime': (Checkout.RecordTime +
timedelta(hours=8)).strftime('%Y-%m-%d %H:%M:%S'),
'pk':
Checkout.pk
} for Checkout in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetEntryData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_V_entry傳入作查詢
EntryData = grid.dynamic_query_order(M_V_entry)
#將EntryData傳入作後端分頁
object_list = grid.dynamic_query_order_paginator(EntryData)
#資料總筆數
count = len(EntryData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'DealDate': (Enrty.DealDate + timedelta(hours=8)).strftime('%Y-%m-%d'),
'CashierName':
Enrty.last_name,
'CashierID':
Enrty.username,
'StationID':
Enrty.StationID,
'FeeID':
Enrty.FeeID,
'FeeName':
Enrty.FeeName,
'beginno':
Enrty.beginno,
'PayType':
[val for key, val in M_DealMaster.PayTypeList if key == Enrty.PayType],
'Amount':
Enrty.Amount,
'Qty':
Enrty.Qty,
'TotalAmount':
Enrty.TotalAmount,
'Status': [
val for key, val in M_DealMaster.DealStatusList
if key == Enrty.Status
],
'IsCheckout':
Enrty.IsCheckout,
'IsOutsidePay':
Enrty.IsOutsidePay,
'LotNo':
Enrty.LotNo
} for Enrty in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetFeeItemReport(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_V_FeeItemReport傳入作查詢
FeeItemData = grid.dynamic_query_order(M_V_FeeItemReport)
#將FeeItemData傳入作分頁
object_list = grid.dynamic_query_order_paginator(FeeItemData)
#資料總筆數
count = len(FeeItemData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'StationID':
FeeItem.StationID,
'DealDate':
(FeeItem.DealDate + timedelta(hours=8)).strftime('%Y-%m-%d'),
'DealTime': (FeeItem.DealDate + timedelta(hours=8)).strftime('%H:%M'),
'InvoiceNo':
FeeItem.InvoiceNo,
'Status': [
val for key, val in M_DealMaster.DealStatusList
if key == FeeItem.Status
],
'PayType': [
val for key, val in M_DealMaster.PayTypeList
if key == FeeItem.PayType
],
'FeeID':
FeeItem.FeeID,
'FeeName':
FeeItem.FeeName,
'Amount':
FeeItem.Amount,
'cAmount':
FeeItem.Amount,
'Qty':
FeeItem.Qty
} for FeeItem in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetDealMasterData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
grid = GridCS(request)
MasterData = grid.dynamic_query_order(M_DealMaster)
if (request.POST.get('FeeID', '') != ''):
filterFee = request.POST.get('FeeID', '')
FeeDetailData = M_DealDetail.objects.filter(
FeeID=filterFee).values_list('MasterID')
MasterData = MasterData.filter(id__in=FeeDetailData)
object_list = grid.dynamic_query_order_paginator(MasterData)
count = len(MasterData)
data = [{
'StationID':
Master.StationID.StationName,
'DealDate':
(Master.DealDate + timedelta(hours=8)).strftime("%Y-%m-%d %H:%M"),
'Cashier':
Master.Cashier.last_name,
'InvoiceNo':
Master.InvoiceNo.InvoiceNo,
'Amount':
Master.Amount,
'PayType': [
val for key, val in M_DealMaster.PayTypeList
if key == Master.PayType
],
'Status': [
val for key, val in M_DealMaster.DealStatusList
if key == Master.Status
],
'pk':
Master.pk
} for Master in object_list]
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetInvoiceData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
grid = GridCS(request)
InvoiceData = grid.dynamic_query_order(M_V_Invoice)
object_list = grid.dynamic_query_order_paginator(InvoiceData)
count = len(InvoiceData)
data = [{
'MaxInvoice':
Invoice.MaxInvoice,
'MinInvoice':
Invoice.MinInvoice,
'TotalInvoice':
Invoice.TotalInvoice,
'TotalAmount':
Invoice.TotalAmount,
'StationID':
Invoice.StationID,
'StationName':
Invoice.StationName,
'FeeID':
Invoice.FeeID,
'FeeName':
Invoice.FeeName,
'Status': [
val for key, val in M_Invoice.InvoiceStatusList
if key == Invoice.Status
]
} for Invoice in object_list]
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetFeeItemData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_FeeItem傳入作查詢
FeeItemData = grid.dynamic_query_order(M_FeeItem)
#將FeeItemData傳入作後端分頁
object_list = grid.dynamic_query_order_paginator(FeeItemData)
#資料總筆數
count = len(FeeItemData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'FeeID':
FeeItem.FeeID,
'FeeName':
FeeItem.FeeName,
'Remark':
FeeItem.Remark,
'FeeAmount':
FeeItem.FeeAmount,
'FeeType':
[val for key, val in M_FeeItem.FeeTypeList if key == FeeItem.FeeType],
'Status':
[val for key, val in M_FeeItem.FeeStatusList if key == FeeItem.Status],
'OrderBy':
FeeItem.OrderBy,
'pk':
FeeItem.pk
} for FeeItem in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetPenaltyReport(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_V_PenaltyReport傳入作查詢
PenaltyData = grid.dynamic_query_order(M_V_PenaltyReport)
#將FeeItemData傳入作分頁
object_list = grid.dynamic_query_order_paginator(PenaltyData)
#資料總筆數
count = len(PenaltyData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'DealDate':
(Penalty.DealDate + timedelta(hours=8)).strftime('%Y-%m-%d'),
'PenaltyID':
Penalty.PenaltyID,
'PenaltyName':
Penalty.PenaltyName,
'TermID':
Penalty.TermID,
'TermName':
Penalty.TermName,
'Qty':
Penalty.qty,
'TotalAmount':
Penalty.totalamount,
'Remark':
Penalty.Remark
} for Penalty in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')
def V_GetPrintData(request):
draw = int(request.POST.get('draw')) # 記錄操作次數
#將前端request物件傳入GridCS內做處理
grid = GridCS(request)
#將Model M_Penalty傳入作查詢
PrintData = grid.dynamic_query_order(M_PrintData)
#將PenaltyData傳入作後端分頁
object_list = grid.dynamic_query_order_paginator(PrintData)
#資料總筆數
count = len(PrintData)
#拼出teplate JQGRID 欄位JSON資料流
data = [{
'EnableDate':
(Print.EnableDate + timedelta(hours=8)).strftime("%Y-%m-%d"),
'Salesman':
Print.Salesman,
'Accounting':
Print.Accounting,
'Chief':
Print.Chief,
'Tel':
Print.Tel,
'Fax':
Print.Fax,
'pk':
Print.pk
} for Print in object_list]
#JQGRID API
dic = {
'draw': draw,
'recordsTotal': count,
'recordsFiltered': count,
'data': data,
}
return HttpResponse(json.dumps(dic, cls=DjangoJSONEncoder),
content_type='application/json')