def post(self): json_values = {} try: agent_code = self.session['agent_code'] # get post data date = DateTime.to_date(self.request.get("date")) amt = float(self.request.get("amount")) payment_date = DateTime.to_date(self.request.get("paymentDate")) ref_no = self.request.get("refNo") #save data to view model class vm = DepositViewModel() vm.tran_date = date vm.amt = amt vm.agent_code = agent_code vm.payment_date = payment_date vm.payment_ref_no = ref_no vm.payment_type = 1 app_service = DepositAppService() app_service.create(vm) json_values['returnStatus'] = True json_values['tranCode'] = vm.tran_code except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = DateTime.to_date(self.request.get('dateFrom')) date_to = DateTime.to_date(self.request.get('dateTo')) sale_by_day = SaleByDay() values = sale_by_day.get(date_from, date_to) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'tranCode': value.tran_code, 'description': value.description, 'dbAmt': value.db_amt, 'crAmt': value.cr_amt, 'balAmt': value.bal_amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = DateTime.to_date(self.request.get('dateFrom')) date_to = DateTime.to_date(self.request.get('dateTo')) attendant_code = self.request.get('attendantCode') charge_by_month = ChargeSummary() values = charge_by_month.get_by_month_and_attendant(date_from, date_to, attendant_code) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'attendantCode': value.attendant_code, 'subTotal': value.sub_total, 'chargeComm': value.comm_amt, 'total': value.amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = DateTime.to_date(self.request.get('dateFrom')) date_to = DateTime.to_date(self.request.get('dateTo')) topup_by_month = TopUpSummaryByMonth() values = topup_by_month.get(date_from, date_to) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'agentCode': value.agent_code, 'topupAmt': value.sub_total, 'topupComm': value.comm_amt, 'total': value.amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: agent_code = self.session['agent_code'] # get post data date = DateTime.to_date(self.request.get("date")) quantity = int(self.request.get("quantity")) payment_date = DateTime.to_date(self.request.get("paymentDate")) ref_no = self.request.get("refNo") #save data to view model class vm = BuyViewModel() vm.tran_date = date vm.agent_code = agent_code vm.qty = quantity vm.unit_price = 10 vm.sub_total = 0 vm.comm_per = 5 vm.comm_amt = 0 vm.payment_date = payment_date vm.payment_ref_no = ref_no vm.payment_type = 1 app_service = BuyAppService() app_service.create(vm) json_values['returnStatus'] = True json_values['tranCode'] = vm.tran_code except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = DateTime.to_date(self.request.get('dateFrom')) date_to = DateTime.to_date(self.request.get('dateTo')) profit_by_month = Profit() values = profit_by_month.get_by_day(date_from, date_to) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'chargeAmt': value.charge_sub_total, 'chargeComm': value.charge_comm_amt, 'topupComm': value.top_up_comm_amt, 'total': value.amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) if (not date_from and date_to): raise Exception('You must enter a Date.') topup_by_day = TopUpSummaryByDay() values = topup_by_day.get(date_from, date_to) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'agentCode': value.agent_code, 'topupAmt': value.sub_total, 'topupComm': value.comm_amt, 'total': value.amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') agent_code = self.request.get('agentCode') q = Register.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) if agent_code: q = q.filter(Register.agent_code == agent_code) if (not date_from and date_to): raise Exception('You must enter a Date.') registers = q.fetch() # create json data = [] for register in registers: data.append({ 'tranCode': register.tran_code, 'carPlate': register.car_reg_no, 'tranDate': DateTime.to_date_string(register.tran_date), 'agentCode': register.agent_code, 'ic': register.customer_ic, 'name': register.customer_name, 'address': register.customer_address, 'tel': register.customer_tel, 'hp': register.customer_hp, 'email': register.customer_email, 'tagNo': register.tag_code, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: date_from = self.request.get('dateFrom') date_to = self.request.get("dateTo") current_agent = self.current_agent() agent_code = current_agent.code q = Buy.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) q = q.filter(Buy.tran_date >= date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) q = q.filter(Buy.tran_date <= date_to) if (not date_from and date_to): q = q.filter(Buy.agent_code == agent_code) buys = q.fetch() # create json data = [] for buy in buys: data.append({ 'agentCode': buy.agent_code, 'tranCode': buy.tran_code, 'date': DateTime.to_date_string(buy.tran_date), 'qty': buy.qty, 'unitPrice': buy.unit_price, 'subTotal': buy.sub_total, 'commission': buy.comm_amt, 'amount': buy.amt, 'paymentDate': DateTime.to_date_string(buy.payment_date), 'refNo': buy.payment_ref_no, 'paymentType': buy.payment_type, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: date_from = self.request.get('dateFrom') date_to = self.request.get("dateTo") carPlate = self.request.get('carPlate') current_agent = self.current_agent() code = current_agent.code q = Register.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) q = q.filter(Register.tran_date >= date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) q = q.filter(Register.tran_date <= date_to) if carPlate: q = q.filter(Register.car_reg_no == carPlate) if (not date_from and date_to and carPlate): q = q.filter(Register.agent_code == code) registers = q.fetch() # create json data = [] for register in registers: data.append({ 'agentCode': register.agent_code, 'tranCode': register.tran_code, 'date': DateTime.to_date_string(register.tran_date), 'carPlate': register.car_reg_no, 'name': register.customer_name, 'ic': register.customer_ic, 'address': register.customer_address, 'tel': register.customer_tel, 'hp': register.customer_hp, 'email': register.customer_email, 'tagNo': register.tag_code }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') agent_code = self.request.get('agentCode') q = Deposit.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) if agent_code: q = q.filter(Deposit.agent_code == agent_code) if (not date_from and date_to): raise Exception('You must enter a Date.') deposits = q.fetch() # create json data = [] for deposit in deposits: data.append({ 'tranCode': deposit.tran_code, 'tranDate': DateTime.to_date_string(deposit.tran_date), 'agentCode': deposit.agent_code, 'amount': deposit.amt, 'paymentDate': DateTime.to_date_string(deposit.payment_date), 'refNo': deposit.payment_ref_no, 'paymentType': deposit.payment_type, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') agent_code = self.request.get('agentCode') q = TopUp.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) if agent_code: q = q.filter(TopUp.agent_code == agent_code) if (not date_from and date_to): raise Exception('You must enter a Date.') topups = q.fetch() data = [] for topup in topups: data.append({ 'tranCode': topup.tran_code, 'carPlate': topup.car_reg_no, 'tranDate': DateTime.to_date_string(topup.tran_date), 'agentCode': topup.agent_code, 'subTotal': topup.sub_total, 'commission': topup.comm_amt, 'amount': topup.amt, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: date_from = self.request.get('dateFrom') date_to = self.request.get("dateTo") lot_no = self.request.get("lotNo") car_reg_no = self.request.get("carPlate") current_attendant = self.current_attendant() attendant_code = current_attendant.code q = Charge.query(Charge.attendant_code == attendant_code) if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) q = q.filter(Charge.tran_date >= date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) q = q.filter(Charge.tran_date <= date_to) if lot_no: q = q.filter(Charge.lot_no == lot_no) if car_reg_no: q = q.filter(Charge.car_reg_no == car_reg_no) if (not date_from and date_to and lot_no and car_reg_no): q = q.filter(Charge.attendant_code == attendant_code) charges = q.fetch() # create json data = [] for charge in charges: data.append({ 'attendantCode': charge.attendant_code, 'tranCode': charge.tran_code, 'date': DateTime.to_date_string(charge.tran_date), 'lotNo': charge.lot_no, 'carPlate': charge.car_reg_no, 'amount': charge.sub_total, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: agent_code = self.session['agent_code'] # get post data date = DateTime.to_date(self.request.get("date")) carPlate = self.request.get("carPlate") amount = float(self.request.get("amount")) #save data to view model class vm = TopUpViewModel() vm.tran_date = date vm.agent_code = agent_code vm.car_reg_no = carPlate vm.sub_total = amount vm.comm_per = 5 app_service = TopUpAppService() app_service.create(vm) json_values['returnStatus'] = True json_values['tranCode'] = vm.tran_code except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get current_agent = self.current_agent() agent_code = current_agent.code tran_date = DateTime.to_date(self.request.get('date')) agent_statement = AgentStatement() values = agent_statement.get(agent_code, tran_date) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'tranCode': value.tran_code, 'description': value.description, 'dbAmt': value.db_amt, 'crAmt': value.cr_amt, 'balAmt': value.bal_amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: attendant_code = self.session['attendant_code'] # get post data date = DateTime.to_date(self.request.get("date")) lot_no = self.request.get("lotNo") car_reg_no = self.request.get("carPlate") #save data to view model class vm = ChargeViewModel() vm.tran_date = date vm.attendant_code = attendant_code vm.lot_no = lot_no vm.car_reg_no = car_reg_no app_service = ChargeAppService() app_service.create(vm) json_values['returnStatus'] = True except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: date_from = self.request.get('dateFrom') date_to = self.request.get("dateTo") carPlate = self.request.get('carPlate') current_agent = self.current_agent() agent_code = current_agent.code q = TopUp.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) q = q.filter(TopUp.tran_date >= date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) q = q.filter(TopUp.tran_date <= date_to) if carPlate: q = q.filter(TopUp.car_reg_no == carPlate) if (not date_from and date_to and carPlate): q = q.filter(TopUp.agent_code == agent_code) topUps = q.fetch() # create json data = [] for topUp in topUps: data.append({ 'agentCode': topUp.agent_code, 'tranCode': topUp.tran_code, 'carPlate': topUp.car_reg_no, 'date': DateTime.to_date_string(topUp.tran_date), 'subTotal': topUp.sub_total, 'commission': topUp.comm_amt, 'amount': topUp.amt, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') agent_code = self.request.get('agentCode') q = Buy.query() if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) q = q.filter(Buy.tran_date >= date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) q = q.filter(Buy.tran_date <= date_to) if agent_code: q = q.filter(Buy.agent_code == agent_code) if (not date_from and date_to and agent_code): raise Exception('You must enter a Date or Agent Code.') buys = q.fetch() # create json data = [] for buy in buys: data.append({ 'agentCode': buy.agent_code, 'tranDate': DateTime.to_date_string(buy.tran_date), 'quantity': buy.qty, 'amt': buy.sub_total, }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: #get date_from = self.request.get('dateFrom') date_to = self.request.get('dateTo') attendant_code = self.request.get('attendantCode') if date_from and len(date_from) > 0: date_from = DateTime.to_date(date_from) if date_to and len(date_to) > 0: date_to = DateTime.to_date(date_to) if (not date_from and date_to): raise Exception('You must enter a Date.') charge_by_day = ChargeSummary() values = charge_by_day.get_by_day_and_attendant( date_from, date_to, attendant_code) data = [] for value in values: data.append({ 'tranDate': DateTime.to_date_string(value.tran_date), 'attendantCode': value.attendant_code, 'subTotal': value.sub_total, 'chargeComm': value.comm_amt, 'total': value.amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def post(self): json_values = {} try: agent_code = self.session['agent_code'] # get post data date = DateTime.to_date(self.request.get("date")) carPlate = self.request.get("carPlate") name = self.request.get("name") ic = self.request.get("ic") address = self.request.get("address") tel = self.request.get("tel") hp = self.request.get("hp") email = self.request.get("email") tagNo = self.request.get("tagNo") #save data to view model class vm = RegisterViewModel() vm.tran_date = date vm.agent_code = agent_code vm.car_reg_no = carPlate vm.customer_name = name vm.customer_ic = ic vm.customer_address = address vm.customer_tel = tel vm.customer_hp = hp vm.customer_email = email vm.tag_code = tagNo app_service = RegisterAppService() app_service.create(vm) json_values['returnStatus'] = True json_values['tranCode'] = vm.tran_code except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)