def load_values(self):
db = connect()
cursor = db.cursor()
cursor.execute(QUERY, (self.ix, ))
cbdate, ref, descr, code, dntid, amt = cursor.fetchone()
cursor.close()
self.serialno_le.setText(ref)
self.patient_le.setText(descr)
self.date_edit.setDate(cbdate)
self.dentist_cb.setCurrentIndex(0)
try:
pos = localsettings.activedent_ixs.index(dntid)
except ValueError:
pos = -1
self.dentist_cb.setCurrentIndex(pos)
code_str = cashbookCodesDict.get(code)
self.code_cb.setCurrentIndex(self.codestrings.index(code_str))
pounds = amt // 100
pence = amt % 100
double_val = float("%s.%s" % (pounds, pence))
self.amount_sb.setValue(double_val)
self.check_enable()
def load_values(self):
db = connect()
cursor = db.cursor()
cursor.execute(QUERY, (self.ix,))
cbdate, ref, descr, code, dntid, amt = cursor.fetchone()
cursor.close()
self.serialno_le.setText(ref)
self.patient_le.setText(descr)
self.date_edit.setDate(cbdate)
self.dentist_cb.setCurrentIndex(0)
try:
pos = localsettings.activedent_ixs.index(dntid)
except ValueError:
pos = -1
self.dentist_cb.setCurrentIndex(pos)
code_str = cashbookCodesDict.get(code)
self.code_cb.setCurrentIndex(self.codestrings.index(code_str))
pounds = amt // 100
pence = amt % 100
double_val = float("%s.%s" % (pounds, pence))
self.amount_sb.setValue(double_val)
self.check_enable()
def summary_details(sno, start_date):
values = (localsettings.OM_DATE_FORMAT, "%06d"% sno, start_date)
db = connect()
cursor = db.cursor()
cursor.execute(SUMMARY_QUERY, values)
rows = cursor.fetchall()
cursor.close()
claimNo = len(rows)
if claimNo==0:
return "No Payments Found"
retarg = '<table width="100%" border="1">'
retarg += '<tr class="table_header">'
for header in HEADERS[:3] + HEADERS[8:]:
retarg += "<th>%s</th>"% header
retarg += '</tr>'
total = 0
for i, row in enumerate(rows):
if i %2 == 0:
retarg+='<tr bgcolor="#eeeeee">'
else:
retarg+='<tr>'
#-- a row is (date,sno,dnt,patient,code,amount)
retarg += '<td>%s</td>'% (row[0])
retarg += '<td>%s</td>'% localsettings.ops.get(row[1])
CODE = cashbookCodesDict.get(row[2], "UNKNOWN")
retarg += '<td>%s</td>'% CODE
amt = row[3]
retarg += '<td align="right">%s</td>'% localsettings.formatMoney(amt)
retarg += '</tr>\n'
total += amt
retarg += '''<tr class="table_header">
<td colspan="3" align="right"><b>TOTAL</b></td>
<td align="right"><b>%s</b></td></tr>'''% (
localsettings.formatMoney(total))
retarg += '</table>'
return retarg
def summary_details(sno, start_date):
values = (localsettings.OM_DATE_FORMAT, "%06d" % sno, start_date)
db = connect()
cursor = db.cursor()
cursor.execute(SUMMARY_QUERY, values)
rows = cursor.fetchall()
cursor.close()
claimNo = len(rows)
if claimNo == 0:
return "No Payments Found"
retarg = '<table width="100%" border="1">'
retarg += '<tr class="table_header">'
for header in HEADERS[:3] + HEADERS[8:]:
retarg += "<th>%s</th>" % header
retarg += '</tr>'
total = 0
for i, row in enumerate(rows):
if i % 2 == 0:
retarg += '<tr bgcolor="#eeeeee">'
else:
retarg += '<tr>'
#-- a row is (date,sno,dnt,patient,code,amount)
retarg += '<td>%s</td>' % (row[0])
retarg += '<td>%s</td>' % localsettings.ops.get(row[1])
CODE = cashbookCodesDict.get(row[2], "UNKNOWN")
retarg += '<td>%s</td>' % CODE
amt = row[3]
retarg += '<td align="right">%s</td>' % localsettings.formatMoney(amt)
retarg += '</tr>\n'
total += amt
retarg += '''<tr class="table_header">
<td colspan="3" align="right"><b>TOTAL</b></td>
<td align="right"><b>%s</b></td></tr>''' % (
localsettings.formatMoney(total))
retarg += '</table>'
return retarg
def details(sno):
'''
returns an html page showing pt's payment History
'''
values = (localsettings.OM_DATE_FORMAT, "%06d"% sno)
db = connect()
cursor = db.cursor()
cursor.execute(QUERY, values)
rows = cursor.fetchall()
cursor.close()
claimNo = len(rows)
if claimNo==0:
return "<h2>No Payments Found</h2>"
retarg = '<html><body><table width="100%" border="1">'
retarg += '<tr>'
for header in HEADERS:
retarg += "<th>%s</th>"% header
retarg += '</tr>'
odd = True
total, cashTOT, chequeTOT, cardTOT, otherTOT = 0, 0, 0, 0, 0
for row in rows:
if odd:
retarg+='<tr bgcolor="#eeeeee">'
odd = False
else:
retarg+='<tr>'
odd = True
#-- a row is (date,sno,dnt,patient,code,amount)
retarg += '<td>%s</td>'%(row[0])
retarg += '<td>%s</td>'%localsettings.ops.get(row[1])
retarg += '<td>%s</td>'%row[2]
CODE = cashbookCodesDict.get(row[3], "UNKNOWN")
retarg += '<td>%s</td>'%CODE
amt = row[4]
amt_str = localsettings.formatMoney(amt)
if "CASH" in CODE:
retarg += '<td align="right">%s</td>'% amt_str
cashTOT += amt
retarg += "<td> </td>"*3
elif "CHEQUE" in CODE:
retarg += '<td> </td><td align="right">%s</td>'% amt_str
chequeTOT += amt
retarg += "<td> </td>"*2
elif "CARD" in CODE:
retarg += "<td> </td>"*2
retarg += '<td align="right">%s</td>'% amt_str
cardTOT += amt
retarg += "<td> </td>"
else:
retarg += "<td> </td>"*3
retarg += '<td align="right">%s</td>'% amt_str
otherTOT += amt
retarg += '<td align="right">%s</td>'% amt_str
retarg += '</tr>\n'
total += amt
retarg += '''<tr><td colspan="3"></td>
<td><b>TOTAL</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td></tr>'''% (
localsettings.formatMoney(cashTOT),
localsettings.formatMoney(chequeTOT),
localsettings.formatMoney(cardTOT),
localsettings.formatMoney(otherTOT),
localsettings.formatMoney(total))
retarg += '</table></body></html>'
return retarg
def details(sno):
'''
returns an html page showing pt's payment History
'''
values = (localsettings.OM_DATE_FORMAT, "%06d" % sno)
db = connect()
cursor = db.cursor()
cursor.execute(QUERY, values)
rows = cursor.fetchall()
cursor.close()
claimNo = len(rows)
if claimNo == 0:
return "<h2>No Payments Found</h2>"
retarg = '<html><body><table width="100%" border="1">'
retarg += '<tr>'
for header in HEADERS:
retarg += "<th>%s</th>" % header
retarg += '</tr>'
odd = True
total, cashTOT, chequeTOT, cardTOT, otherTOT = 0, 0, 0, 0, 0
for row in rows:
if odd:
retarg += '<tr bgcolor="#eeeeee">'
odd = False
else:
retarg += '<tr>'
odd = True
#-- a row is (date,sno,dnt,patient,code,amount)
retarg += '<td>%s</td>' % (row[0])
retarg += '<td>%s</td>' % localsettings.ops.get(row[1])
retarg += '<td>%s</td>' % row[2]
CODE = cashbookCodesDict.get(row[3], "UNKNOWN")
retarg += '<td>%s</td>' % CODE
amt = row[4]
amt_str = localsettings.formatMoney(amt)
if "CASH" in CODE:
retarg += '<td align="right">%s</td>' % amt_str
cashTOT += amt
retarg += "<td> </td>" * 3
elif "CHEQUE" in CODE:
retarg += '<td> </td><td align="right">%s</td>' % amt_str
chequeTOT += amt
retarg += "<td> </td>" * 2
elif "CARD" in CODE:
retarg += "<td> </td>" * 2
retarg += '<td align="right">%s</td>' % amt_str
cardTOT += amt
retarg += "<td> </td>"
else:
retarg += "<td> </td>" * 3
retarg += '<td align="right">%s</td>' % amt_str
otherTOT += amt
retarg += '<td align="right">%s</td>' % amt_str
retarg += '</tr>\n'
total += amt
retarg += '''<tr><td colspan="3"></td>
<td><b>TOTAL</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td>
<td align="right"><b>%s</b></td></tr>''' % (
localsettings.formatMoney(cashTOT),
localsettings.formatMoney(chequeTOT),
localsettings.formatMoney(cardTOT),
localsettings.formatMoney(otherTOT), localsettings.formatMoney(total))
retarg += '</table></body></html>'
return retarg
