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))
