def post(self, agent_code): json_values = {} try: #get agent_code = self.request.get('agentCode') deposits = Deposit.query(Deposit.agent_code == agent_code).fetch() # create json data = [] for deposit in deposits: data.append({ 'tranDate': DateTime.to_date_string(deposit.tran_date), 'amount': deposit.amt, 'paymentDate': DateTime.to_date_string(deposit.payment_date), 'refNo': deposit.payment_ref_no, 'paymentType': deposit.payment_type, 'tranCode': deposit.tran_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: #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, agent_code): json_values = {} try: #get agent_code = self.request.get('agentCode') topups = TopUp.query(TopUp.agent_code == agent_code).fetch() data = [] for topup in topups: data.append({ 'carPlate': topup.car_reg_no, 'tranDate': DateTime.to_date_string(topup.tran_date), 'subTotal': topup.sub_total, 'commission': topup.comm_amt, 'amount': topup.amt, 'tranCode': topup.tran_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') 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 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: #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, reg_no): json_values = {} try: #get car_reg_no = self.request.get('reg_no') tran_date = DateTime.malaysia_today() customer_statement = customerStatement() values = customer_statement.get(car_reg_no, 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: #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, agent_code): json_values = {} try: #get agent_code = self.request.get('agentCode') registers = Register.query(Register.agent_code==agent_code).fetch() # create json data = [] for register in registers: data.append({ 'carPlate': register.car_reg_no, 'tranDate': DateTime.to_date_string(register.tran_date), '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, 'tranCode': register.tran_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 = 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') 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, agent_code): json_values = {} try: #get agent_code = self.request.get('agentCode') buys = Buy.query(Buy.agent_code == agent_code).fetch() # create json data = [] for buy in buys: data.append({ '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, 'tranCode': buy.tran_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") 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 = 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 get(self): # validate admin is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() template_values = { 'title': 'Create Attendant', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user } template = JINJA_ENVIRONMENT.get_template('/attendant/create.html') self.response.write(template.render(template_values))
def get(self): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_agent = self.current_agent() template_values = { 'title': 'Register List', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_agent': current_agent } template = JINJA_ENVIRONMENT.get_template('register/index.html') self.response.write(template.render(template_values))
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 get_charge_summary_by_day(self): try: charge_app = ChargeSummary() values = charge_app.get_by_day(DateTime.malaysia_today(), None) self.response.write("<table border='1'>") for value in values: self.response.write("<tr>") self.response.write("<td>%s</td>" % DateTime.to_date_string(value.tran_date)) self.response.write("<td>%s</td>" % value.sub_total) self.response.write("<td>%s</td>" % value.comm_amt) self.response.write("<td>%s</td>" % value.amt) self.response.write("</tr>") self.response.write("</table>") self.response.write("get_charge_summary_by_day OK.") except Exception, ex: self.response.write("get_charge_summary_by_day failed. %s" % str(ex))
def get(self): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_agent = self.current_agent() agents = Agent.query().fetch() template_values = { 'title': 'Statement', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_agent': current_agent, 'agents': agents } template = JINJA_ENVIRONMENT.get_template('statement/index.html') self.response.write(template.render(template_values))
def get(self): # validate admin is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() users = User.query().fetch() template_values = { 'title': 'Buy Transaction', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'users': users, } template = JINJA_ENVIRONMENT.get_template('buy/transaction.html') self.response.write(template.render(template_values))
def get(self): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() users = User.query().fetch() template_values = { 'title': 'Agent Daily Sale', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'users': users } template = JINJA_ENVIRONMENT.get_template('report/salebyday.html') self.response.write(template.render(template_values))
def get(self, tran_code): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_agent = self.current_agent() registers = Register.query(Register.tran_code == tran_code).get() template_values = { 'title': 'Borneo Ixora Co', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_agent': current_agent, 'registers': registers } template = JINJA_ENVIRONMENT.get_template('register/receipt.html') self.response.write(template.render(template_values))
def get(self, reg_no): # validate admin is logined or not # if not redirect to login page if self.authenticate() == False: return current_customer = self.current_customer() register = Register.query(Register.car_reg_no == reg_no).get() template_values = { 'title': 'Statement', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_customer': current_customer, 'register': register } template = JINJA_ENVIRONMENT.get_template('statement/index.html') self.response.write(template.render(template_values))
def get(self, ic): # validate admin is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() customer = Customer.query(Customer.ic == ic).get() template_values = { 'title': 'Update Customer', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'customer': customer } template = JINJA_ENVIRONMENT.get_template('customer/update.html') self.response.write(template.render(template_values))
def get(self, code): # validate admin is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() agent = Agent.query(Agent.code==code).get() template_values = { 'title': 'Update Agent', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'agent': agent } template = JINJA_ENVIRONMENT.get_template('agent/update.html') self.response.write(template.render(template_values))
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: #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 get_car_statement(self): try: statement = CarStatement() values = statement.get('WKG4952', DateTime.malaysia_today()) self.response.write("<table border='1'>") for value in values: self.response.write("<tr>") self.response.write("<td>%s</td>" % DateTime.to_date_string(value.tran_date)) self.response.write("<td>%s</td>" % value.tran_code) self.response.write("<td>%s</td>" % value.description) self.response.write("<td>%s</td>" % value.db_amt) self.response.write("<td>%s</td>" % value.cr_amt) self.response.write("<td>%s</td>" % value.bal_amt) self.response.write("</tr>") self.response.write("</table>") self.response.write("get_car_statement OK.") except Exception, ex: self.response.write("get_car_statement failed. %s" % str(ex))
def get_profit_by_day(self): try: profit_app = Profit() values = profit_app.get_by_day(DateTime.malaysia_today(), None) self.response.write("<table border='1'>") for value in values: self.response.write("<tr>") self.response.write("<td>%s</td>" % DateTime.to_date_string(value.tran_date)) self.response.write("<td>%s</td>" % value.charge_sub_total) self.response.write("<td>%s</td>" % value.charge_comm_amt) self.response.write("<td>%s</td>" % value.top_up_comm_amt) self.response.write("<td>%s</td>" % value.amt) self.response.write("</tr>") self.response.write("</table>") self.response.write("get_profit_by_day OK.") except Exception, ex: self.response.write("get_profit_by_day failed. %s" % str(ex))