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 create_charge(self, charge_time=None): try: vm = ChargeViewModel() vm.tran_date = DateTime.malaysia_today() vm.attendant_code = '1' vm.lot_no = '1' vm.car_reg_no = 'WKG4952' vm.comm_per = 2 app_service = ChargeAppService() app_service.create(vm, charge_time) self.response.write("create_charge OK.") except Exception, ex: self.response.write("create_charge failed. %s" % str(ex))
def create_charge(self, charge_time=None): try: vm = ChargeViewModel() vm.tran_date = DateTime.malaysia_today() vm.attendant_code = '1' vm.lot_no = '1' vm.car_reg_no = 'WKG4952' vm.comm_per = 2 app_service = ChargeAppService() app_service.create(vm, charge_time) self.response.write("create_charge OK.") except Exception, ex: self.response.write("create_charge failed. %s" % 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 create_deposit(self): try: vm = DepositViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.amt = 100 vm.payment_date = vm.tran_date vm.payment_type = 1 vm.payment_ref_no = '2' app_service = DepositAppService() app_service.create(vm) self.response.write("create_deposit OK.") except Exception, ex: self.response.write("create_deposit failed. %s" % str(ex))
def create_deposit(self): try: vm = DepositViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.amt = 100 vm.payment_date = vm.tran_date vm.payment_type = 1 vm.payment_ref_no = '2' app_service = DepositAppService() app_service.create(vm) self.response.write("create_deposit OK.") except Exception, ex: self.response.write("create_deposit 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_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): # 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 create_top_up(self): try: vm = TopUpViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.car_reg_no = 'WKG4952' vm.sub_total = 20 vm.comm_per = 5 vm.cal_comm_amt() vm.cal_amt() app_service = TopUpAppService() app_service.create(vm) self.response.write("create_top_up OK.") except Exception, ex: self.response.write("create_top_up failed. %s" % str(ex))
def create_top_up(self): try: vm = TopUpViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.car_reg_no = 'WKG4952' vm.sub_total = 20 vm.comm_per = 5 vm.cal_comm_amt() vm.cal_amt() app_service = TopUpAppService() app_service.create(vm) self.response.write("create_top_up OK.") except Exception, ex: self.response.write("create_top_up failed. %s" % str(ex))
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_charge_summary_by_month(self): try: charge_app = ChargeSummary() values = charge_app.get_by_month(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_month_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_month OK.") except Exception, ex: self.response.write("get_charge_summary_by_month failed. %s" % str(ex))
def create_closing(self): try: closing = Closing.query().get() if closing: self.response.write("closing already exist.") self.response.write("<br />") return vm = ClosingViewModel() vm.closing_date = DateTime.malaysia_today() - datetime.timedelta(days=1) app_service = ClosingAppService() app_service.create(vm) self.response.write("create_closing OK.") except Exception, ex: self.response.write("create_closing 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_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))
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 create_closing(self): try: closing = Closing.query().get() if closing: self.response.write("closing already exist.") self.response.write("<br />") return vm = ClosingViewModel() vm.closing_date = DateTime.malaysia_today() - datetime.timedelta( days=1) app_service = ClosingAppService() app_service.create(vm) self.response.write("create_closing OK.") except Exception, ex: self.response.write("create_closing failed. %s" % str(ex))
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, 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 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_month(self): try: profit_app = Profit() values = profit_app.get_by_month(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_month_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_month OK.") except Exception, ex: self.response.write("get_profit_by_month failed. %s" % 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_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 create_register(self): try: vm = RegisterViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.car_reg_no = 'WKG4952' vm.customer_name = 'Edward' vm.customer_ic = '1' vm.customer_address = 'TB' vm.customer_tel = '1' vm.customer_hp = '2' vm.customer_email = '3' vm.tag_code = 'XYZ' app_service = RegisterAppService() app_service.create(vm) self.response.write("create_register OK.") except Exception, ex: self.response.write("create_register failed. %s" % str(ex))
def get(self, agent_code): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() register = Register.query(Register.agent_code==agent_code).get() agent = Agent.query(Agent.code==agent_code).get() template_values = { 'title': 'Detail Register List', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'register': register, 'agent': agent } template = JINJA_ENVIRONMENT.get_template('register/detail.html') self.response.write(template.render(template_values))
def create_register(self): try: vm = RegisterViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.car_reg_no = 'WKG4952' vm.customer_name = 'Edward' vm.customer_ic = '1' vm.customer_address = 'TB' vm.customer_tel = '1' vm.customer_hp = '2' vm.customer_email = '3' vm.tag_code = 'XYZ' app_service = RegisterAppService() app_service.create(vm) self.response.write("create_register OK.") except Exception, ex: self.response.write("create_register failed. %s" % str(ex))
def get(self, reg_no): # validate agent is logined or not # if not redirect to login page if self.authenticate() == False: return current_user = self.current_user() car = Car.query(Car.reg_no==reg_no).get() customer = Customer.query(Customer.ic==car.customer_ic).get() template_values = { 'title': 'Detail of Register Car', 'today': DateTime.to_date_string(DateTime.malaysia_today()), 'current_user': current_user, 'car': car, 'customer': customer } template = JINJA_ENVIRONMENT.get_template('register/cardetail.html') self.response.write(template.render(template_values))
def create_buy(self): try: vm = BuyViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.qty = 10 vm.unit_price = 10 vm.comm_per = 5 vm.cal_sub_total() vm.cal_comm_amt() vm.payment_date = vm.tran_date vm.payment_type = 1 vm.payment_ref_no = '1' vm.cal_amt() app_service = BuyAppService() app_service.create(vm) self.response.write("create_buy OK.") except Exception, ex: self.response.write("create_buy failed. %s" % str(ex))
def create_buy(self): try: vm = BuyViewModel() vm.tran_date = DateTime.malaysia_today() vm.agent_code = '1' vm.qty = 10 vm.unit_price = 10 vm.comm_per = 5 vm.cal_sub_total() vm.cal_comm_amt() vm.payment_date = vm.tran_date vm.payment_type = 1 vm.payment_ref_no = '1' vm.cal_amt() app_service = BuyAppService() app_service.create(vm) self.response.write("create_buy OK.") except Exception, ex: self.response.write("create_buy failed. %s" % str(ex))
def post(self, reg_no): json_values = {} try: reg_no = self.request.get('reg_no') cars = Car.query(Car.reg_no == reg_no).fetch() car = cars[0] today_date = DateTime.malaysia_today() trans = Tran.query(Tran.car_reg_no == reg_no, Tran.tran_date == today_date).order( Tran.seq).fetch() registers = Register.query( Register.car_reg_no == reg_no, Register.tran_date == today_date).fetch() topups = TopUp.query(TopUp.car_reg_no == reg_no, TopUp.tran_date == today_date).fetch() charges = Charge.query(Charge.car_reg_no == car.reg_no, Charge.tran_date == today_date).fetch() # group by tran_code register_tran_codes = {} for register in registers: register_tran_codes[register.tran_code] = register topup_tran_codes = {} for topup in topups: topup_tran_codes[topup.tran_code] = topup charge_tran_codes = {} for charge in charges: charge_tran_codes[charge.tran_code] = charge # create json data = [] bal_amt = 0 for tran in trans: if register_tran_codes.has_key(tran.tran_code): register = register_tran_codes[tran.tran_code] bal_amt += register.sub_total bal_amt = round(bal_amt, 2) data.append({ 'carRegNo': car.reg_no, 'date': DateTime.to_date_string(register.tran_date), 'description': register.tran_code, 'dbAmt': register.sub_total, 'crAmt': 0, 'balAmt': bal_amt }) elif topup_tran_codes.has_key(tran.tran_code): topup = topup_tran_codes[tran.tran_code] bal_amt += topup.sub_total bal_amt = round(bal_amt, 2) data.append({ 'carRegNo': car.reg_no, 'date': DateTime.to_date_string(topup.tran_date), 'description': topup.tran_code, 'dbAmt': topup.sub_total, 'crAmt': 0, 'balAmt': bal_amt }) elif charge_tran_codes.has_key(tran.tran_code): charge = charge_tran_codes[tran.tran_code] bal_amt -= charge.sub_total bal_amt = round(bal_amt, 2) data.append({ 'carRegNo': car.reg_no, 'date': DateTime.to_date_string(charge.tran_date), 'description': charge.tran_code, 'dbAmt': 0, 'crAmt': charge.sub_total, 'balAmt': bal_amt }) json_values['returnStatus'] = True json_values['data'] = data except Exception, ex: json_values['returnStatus'] = False json_values['returnMessage'] = str(ex)
def __create_closing(self): vm = ClosingViewModel() vm.closing_date = DateTime.malaysia_today() - timedelta(days=1) app = ClosingAppService() app.create(vm)