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)
