def insertOpdDiagnosis():
result = ''
tablename = "opdDiagnosis"
rowno = len(request.form.getlist('diagnosisId'))
diaId = request.form.getlist('diagnosisId') #Has Multiple Value
diaType = request.form.getlist('diagnosisType') #Has Multiple Value
try:
if request.method == 'POST':
for i in range(rowno):
dbcolumn = []
htmlcolumn = []
#Name of database Attribute
dbcolumn.append('opdid')
dbcolumn.append('regno')
dbcolumn.append('diagnosisId')
dbcolumn.append('diagnosisType')
dbcolumn.append('diagnosisDate')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(request.form['opdid'])
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(diaId[i])
htmlcolumn.append(diaType[i])
htmlcolumn.append(request.form['diagnosisDate'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertopdbillingdetail(opmid):
result = ''
tablename = "opdbillingdetail"
row = len(request.form.getlist('invtype'))
invtype = request.form.getlist('invtype') #Has Multiple Value
invname = request.form.getlist('invname') #Has Multiple Value
amnt = request.form.getlist('amnt') #Has Multiple Value
try:
if request.method == 'POST':
for i in range(row):
dbcolumn = []
htmlcolumn = []
#Name of database Attribute
dbcolumn.append('opmid')
dbcolumn.append('invtype')
dbcolumn.append('invname')
dbcolumn.append('amnt')
htmlcolumn.append(str(opmid))
htmlcolumn.append(invtype[i])
htmlcolumn.append(invname[i])
htmlcolumn.append(amnt[i])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertOpdConsultRefer():
dbcolumn = []
htmlcolumn = []
result = ''
tablename = "opdreferInfo"
try:
if request.method == 'POST':
#Name of database Attribute
dbcolumn.append('opdid')
dbcolumn.append('regno')
dbcolumn.append('reason')
dbcolumn.append('refdate')
dbcolumn.append('hname')
dbcolumn.append('referby')
dbcolumn.append('referto')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(request.form['opdid'])
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(request.form['reason'])
htmlcolumn.append(request.form['refdate'])
htmlcolumn.append(request.form['hname'])
htmlcolumn.append(request.form['referby'])
htmlcolumn.append(request.form['referto'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def newSample():
#regno = request.form['regno']
#pclass= request.form['pclass']
dbcolumn = []
htmlcolumn = []
tablename = "add_sample"
result = ''
try:
if request.method == 'POST':
dbcolumn.append('test_type')
dbcolumn.append('test_name')
dbcolumn.append('Male_Range')
dbcolumn.append('Female_Range')
dbcolumn.append('Unit')
htmlcolumn.append(request.form['test_type'])
htmlcolumn.append(request.form['test_name'])
htmlcolumn.append(request.form['Male_Range'])
htmlcolumn.append(request.form['Female_Range'])
htmlcolumn.append(request.form['Unit'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def newTest():
#regno = request.form['regno']
#pclass= request.form['pclass']
dbcolumn = []
htmlcolumn = []
tablename = "admin_addtest"
result = ''
try:
if request.method == 'POST':
dbcolumn.append('sid')
dbcolumn.append('pid')
dbcolumn.append('test_name')
dbcolumn.append('Male_Range_min')
dbcolumn.append('Male_Range_max')
dbcolumn.append('Female_Range_min')
dbcolumn.append('Female_Range_max')
dbcolumn.append('Unit')
dbcolumn.append('amount')
htmlcolumn.append(request.form['sample'])
htmlcolumn.append(request.form['panel'])
htmlcolumn.append(request.form['test_name'])
htmlcolumn.append(request.form['Male_Range_min'])
htmlcolumn.append(request.form['Male_Range_max'])
htmlcolumn.append(request.form['Female_Range_min'])
htmlcolumn.append(request.form['Female_Range_max'])
htmlcolumn.append(request.form['Unit'])
htmlcolumn.append(request.form['amount'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertOpdConsultRefer():
dbcolumn = []
htmlcolumn = []
result=''
tablename = "opdreferInfo"
try:
if request.method == 'POST':
sql ="SELECT conid from opdconsultmain where regno='{}' order by condate DESC LIMIT 1".format(request.form['regno']);
cursor.execute(sql)
conid = str(cursor.fetchall()[0][0])
#Name of database Attribute
dbcolumn.append('conid')
dbcolumn.append('reason')
dbcolumn.append('hname')
dbcolumn.append('referby')
dbcolumn.append('referto')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(conid)
htmlcolumn.append(request.form['reason'])
htmlcolumn.append(request.form['hname'])
htmlcolumn.append(request.form['referby'])
htmlcolumn.append(request.form['referto'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
return result
except Exception as e:
return str(e)
def insertNurseryTherapy():
dbcolumn = []
htmlcolumn = []
result = ''
tablename = "ward_nursery_therapy"
try:
if request.method == 'POST':
dbcolumn.append('wrd_id')
dbcolumn.append('therapy_date')
dbcolumn.append('therapy_givenby')
dbcolumn.append('therapy_name')
dbcolumn.append('therapy_starttime')
dbcolumn.append('therapy_endtime')
dbcolumn.append('therapy_duration')
dbcolumn.append('therapy_amount')
htmlcolumn.append(request.form['wrd_id'])
htmlcolumn.append(request.form['therapy_date'])
htmlcolumn.append(request.form['therapy_givenby'])
htmlcolumn.append(request.form['tname'])
htmlcolumn.append(request.form['therapy_starttime'])
htmlcolumn.append(request.form['therapy_endtime'])
htmlcolumn.append(request.form['therapy_duration'])
htmlcolumn.append(request.form[str('therapy_amount')])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertopdbillingmain():
dbcolumn = []
htmlcolumn = []
result = ''
tablename = "opdbillingmain"
regno = request.form['regno']
opdid = request.form['opdid']
try:
if request.method == 'POST':
dbcolumn.append('regno')
dbcolumn.append('opdid')
dbcolumn.append('date')
dbcolumn.append('payment_status')
dbcolumn.append('totalamount')
dbcolumn.append('recievedby')
htmlcolumn.append(regno)
htmlcolumn.append(opdid)
htmlcolumn.append(request.form['date'])
htmlcolumn.append(request.form['payment_status'])
htmlcolumn.append(request.form['totalamount'])
htmlcolumn.append(request.form['recievedby'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
if result == 1:
sql = "select opmid from opdbillingmain order by opmid desc limit 1;"
cursor.execute(sql)
opmid = cursor.fetchall()
result1 = insertopdbillingdetail(opmid[0][0])
print("i am none", result1)
return result1
except Exception as e:
return str(e)
def insertOpdConsultHistory():
dbcolumn = []
htmlcolumn = []
result = ''
tablename = "opdClinicalHistory"
try:
if request.method == 'POST':
#Name of database Attribute
dbcolumn.append('opdid')
dbcolumn.append('regno')
dbcolumn.append('hiscli')
dbcolumn.append('hcdate')
dbcolumn.append('docid')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(request.form['opdid'])
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(request.form['hiscli'])
htmlcolumn.append(request.form['hcdate'])
htmlcolumn.append(request.form['docid'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertOpdDiagnosis():
result=''
tablename = "opdDiagnosis"
rowno=len(request.form.getlist('diagnosisId'))
diaId = request.form.getlist('diagnosisId') #Has Multiple Value
diaType = request.form.getlist('diagnosisType') #Has Multiple Value
try:
if request.method == 'POST':
sql ="SELECT conid from opdconsultmain where regno='{}' order by condate DESC LIMIT 1".format(request.form['regno']);
print("i am diagno sql",sql)
cursor.execute(sql)
conid = str(cursor.fetchall()[0][0])
for i in range(rowno):
dbcolumn = []
htmlcolumn = []
#Name of database Attribute
dbcolumn.append('conid')
dbcolumn.append('diagnosisId')
dbcolumn.append('diagnosisType')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(conid)
htmlcolumn.append(diaId[i])
htmlcolumn.append(diaType[i])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
return result
except Exception as e:
return str(e)
def insertXrayDetail(uploadloc):
result=''
tablename = "xray"
regno = request.form['regno']
row=len(request.form.getlist('xtype'))
xdate = request.form.getlist('xdate') #Has Multiple Value
xt = request.form.getlist('xtype') #Has Multiple Value
st = request.form.getlist('stype') #Has Multiple Value
amt = request.form.getlist('amount') #Has Multiple Value
upld= request.files.getlist('upload') #Has Multiple Value
print(upld)
try:
if request.method == 'POST':
for i in range(row):
dbcolumn = []
htmlcolumn = []
#Name of database Attribute
dbcolumn.append('regno')
dbcolumn.append('xdate')
dbcolumn.append('pid')
dbcolumn.append('xtype')
dbcolumn.append('stype')
dbcolumn.append('amount')
dbcolumn.append('upload')
dbcolumn.append('location')
htmlcolumn.append(regno)
htmlcolumn.append(xdate[i])
htmlcolumn.append(request.form['pid'])
htmlcolumn.append(xt[i])
htmlcolumn.append(st[i])
htmlcolumn.append(amt[i])
fname,fileext = os.path.splitext(upld[i].filename)
filename=secure_filename(regno+'_'+'{0:%d-%m-%Y %H:%M:%S}'.format(datetime.datetime.now())+'_'+fname+fileext)
dst_path=os.path.join(uploadloc, filename)
upld[i].save(dst_path)
htmlcolumn.append(filename)
htmlcolumn.append(request.form['location'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
print(result)
return result
except Exception as e:
return str(e)
def InsertNewCompany():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_company'
dbcolumn.append('cname')
htmlcolumn.append(request.form['cname'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewDeliveryMsg():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_delmsg'
dbcolumn.append('delmsg')
htmlcolumn.append(request.form['delmsg'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewGovSchemeData():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_govsch'
dbcolumn.append('gsname')
htmlcolumn.append(request.form['gsname'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewDeathReasonData():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_deathreason'
dbcolumn.append('deathreason')
htmlcolumn.append(request.form['deathreason'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewDiagnosisData():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_diagno'
dbcolumn.append('diagnosis')
htmlcolumn.append(request.form['diagnosis'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertOpdConsultHistory():
dbcolumn = []
htmlcolumn = []
result=''
tablename = "opdconsultmain"
try:
if request.method == 'POST':
#Name of database Attribute
dbcolumn.append('opdid')
dbcolumn.append('regno')
dbcolumn.append('condate')
dbcolumn.append('docid')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(request.form['opdid'])
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(request.form['consdate'])
htmlcolumn.append(request.form['docid'])
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
if result == 1:
dbcolumn=[]
htmlcolumn=[]
tablename='opdClinicalHistory'
sql = "SELECT conid from opdconsultmain where regno='{}' order by condate DESC LIMIT 1".format(request.form['regno'])
cursor.execute(sql)
conid = str(cursor.fetchall()[0][0])
dbcolumn.append('conid')
dbcolumn.append('hiscli')
htmlcolumn.append(conid)
htmlcolumn.append(request.form['hiscli'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
return result
except Exception as e:
return str(e)
def insertWardIntakeData():
result = ''
wrd_id = request.form['wrd_id']
idate = request.form['idate']
igivenby = request.form['igivenby']
rowno = len(request.form.getlist('med_id'))
itime = request.form.getlist('intime')
iintaketype = request.form.getlist('intaketype')
meddet_id = request.form.getlist('med_id')
idose = request.form.getlist('idose')
iunit = request.form.getlist('iunit')
iamount = request.form.getlist('iamount')
remqty = request.form.getlist('remqty')
try:
if request.method == 'POST':
for i in range(rowno):
dbcolumn = []
htmlcolumn = []
tablename = "ward_intake_chart"
dbcolumn.append('wrd_id')
dbcolumn.append('idate')
dbcolumn.append('itime')
dbcolumn.append('iintaketype')
dbcolumn.append('meddet_id')
dbcolumn.append('idose')
dbcolumn.append('iunit')
dbcolumn.append('igivenby')
dbcolumn.append('iamount')
htmlcolumn.append(wrd_id)
htmlcolumn.append(idate)
htmlcolumn.append(itime[i])
htmlcolumn.append(iintaketype[i])
htmlcolumn.append(meddet_id[i])
htmlcolumn.append(idose[i])
htmlcolumn.append(iunit[i])
htmlcolumn.append(igivenby)
htmlcolumn.append(iamount[i])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
if result == 1:
dbcolumn = []
htmlcolumn = []
tablename = "medicine_outward_detail"
dbcolumn.append('issued_qty')
dbcolumn.append('meddet_id')
htmlcolumn.append(str(remqty[i]))
htmlcolumn.append(meddet_id[i])
result = up.UpdateData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewDressingData():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_dressing'
dbcolumn.append('drsname')
dbcolumn.append('drsamount')
htmlcolumn.append(request.form['drsname'])
htmlcolumn.append(request.form['drsamount'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def InsertNewTherapyData():
try:
dbcolumn = []
htmlcolumn = []
tablename = 'admin_therapy'
dbcolumn.append('adm_therapyname')
dbcolumn.append('adm_therapyamount')
htmlcolumn.append(request.form['adm_therapyname'])
htmlcolumn.append(request.form['adm_therapyamount'])
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertWardSugarData():
result = ''
wrd_id = request.form['wrd_id']
sdate = request.form['sdate']
stime = request.form['stime']
sugarlevel = request.form['sugarlevel']
sinsuline = request.form['med_id']
sdose = request.form['sdose']
sunit = request.form['sunit']
sgivenby = request.form['givenby']
samount = request.form['sprice']
remqty = request.form['remqty']
try:
if request.method == 'POST':
dbcolumn = []
htmlcolumn = []
tablename = "ward_sugar_chart"
dbcolumn.append('wrd_id')
dbcolumn.append('sdate')
dbcolumn.append('stime')
dbcolumn.append('sugarlevel')
dbcolumn.append('sinsuline')
dbcolumn.append('sdose')
dbcolumn.append('sunit')
dbcolumn.append('sgivenby')
dbcolumn.append('samount')
htmlcolumn.append(wrd_id)
htmlcolumn.append(sdate)
htmlcolumn.append(stime)
htmlcolumn.append(sugarlevel)
htmlcolumn.append(sinsuline)
htmlcolumn.append(sdose)
htmlcolumn.append(sunit)
htmlcolumn.append(sgivenby)
htmlcolumn.append(samount)
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
if result == 1:
dbcolumn = []
htmlcolumn = []
tablename = "medicine_outward_detail"
dbcolumn.append('issued_qty')
dbcolumn.append('meddet_id')
htmlcolumn.append(str(remqty))
htmlcolumn.append(sinsuline)
result = up.UpdateData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertWardPoisonData():
result = ''
wrd_id = request.form['wrd_id']
pdate = request.form['pdate']
ptime = request.form['ptime']
pinjection = request.form['pmed_id']
pdose = request.form['pdose']
punit = request.form['punit']
pgivenby = request.form['pgivenby']
pamount = request.form['pprice']
remqty = request.form['remqty']
try:
if request.method == 'POST':
dbcolumn = []
htmlcolumn = []
tablename = "ward_poision_chart"
dbcolumn.append('wrd_id')
dbcolumn.append('pdate')
dbcolumn.append('ptime')
dbcolumn.append('pinjection')
dbcolumn.append('pdose')
dbcolumn.append('punit')
dbcolumn.append('pgivenby')
dbcolumn.append('pamount')
htmlcolumn.append(wrd_id)
htmlcolumn.append(pdate)
htmlcolumn.append(ptime)
htmlcolumn.append(pinjection)
htmlcolumn.append(pdose)
htmlcolumn.append(punit)
htmlcolumn.append(pgivenby)
htmlcolumn.append(pamount)
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
if result == 1:
dbcolumn = []
htmlcolumn = []
tablename = "medicine_outward_detail"
dbcolumn.append('issued_qty')
dbcolumn.append('meddet_id')
htmlcolumn.append(str(remqty))
htmlcolumn.append(pinjection)
result = up.UpdateData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertOpdDocUpload(uploadloc):
result = ''
tablename = "opdDocument"
rowno = len(request.form.getlist('doc_name'))
print(rowno)
regno = request.form['regno']
docname = request.form.getlist('doc_name') #Has Multiple Value
docdate = request.form.getlist('doc_date') #Has Multiple Value
docloc = request.files.getlist('doc_file') #Has Multiple Value
docfrom = request.form.getlist('doc_from') #Has Multiple Value
entrydate = request.form['entrydate']
print(docname, docdate)
try:
if request.method == 'POST':
for i in range(rowno):
dbcolumn = []
htmlcolumn = []
#Name of database Attribute
dbcolumn.append('regno')
dbcolumn.append('doc_name')
dbcolumn.append('doc_date')
dbcolumn.append('doc_file_loc')
dbcolumn.append('doc_from')
dbcolumn.append('entry_date')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(regno)
htmlcolumn.append(docname[i])
htmlcolumn.append(docdate[i])
fname, fileext = os.path.splitext(docloc[i].filename)
filename = secure_filename(
regno + '_' +
'{0:%d-%m-%Y %H:%M:%S}'.format(datetime.datetime.now()) +
'_' + fname + fileext)
dst_path = os.path.join(uploadloc, filename)
docloc[i].save(dst_path)
htmlcolumn.append(filename)
htmlcolumn.append(docfrom[i])
htmlcolumn.append(entrydate)
#print(request.form['opdid'],diaId[i],diaType[i],request.form['diagnosisDate'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def newXrayPart():
xrayname = request.form['xrayname']
dbcolumn = []
htmlcolumn = []
tablename = "admin_xname"
result = ''
try:
if request.method == 'POST':
dbcolumn.append('xrayname')
htmlcolumn.append(request.form['xrayname'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertTPRdata():
result = ''
tablename = "ward_tpr_chart"
row = len(request.form.getlist('temp'))
ttime = request.form.getlist('tprtime')
ttemp = request.form.getlist('temp')
tpulse = request.form.getlist('pulse')
tsystolic = request.form.getlist('systolic')
tdiastolic = request.form.getlist('diastolic')
trespiration = request.form.getlist('respiration')
tfhs = request.form.getlist('fhs')
tspo2 = request.form.getlist('spo2')
try:
if request.method == 'POST':
for i in range(row):
dbcolumn = []
htmlcolumn = []
dbcolumn.append('wrd_id')
dbcolumn.append('tdate')
dbcolumn.append('ttime')
dbcolumn.append('ttemp')
dbcolumn.append('tpulse')
dbcolumn.append('tsystolic')
dbcolumn.append('tdiastolic')
dbcolumn.append('trespiration')
dbcolumn.append('tfhs')
dbcolumn.append('tspo2')
dbcolumn.append('tgivenby')
htmlcolumn.append(request.form['wrd_id'])
htmlcolumn.append(request.form['tdate'])
htmlcolumn.append(ttime[i])
htmlcolumn.append(ttemp[i])
htmlcolumn.append(tpulse[i])
htmlcolumn.append(tsystolic[i])
htmlcolumn.append(tdiastolic[i])
htmlcolumn.append(trespiration[i])
htmlcolumn.append(tfhs[i])
htmlcolumn.append(tspo2[i])
htmlcolumn.append(request.form['tgivenby'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertWardConsumeData():
result = ''
wrd_id = request.form['wrd_id']
wccdate = request.form['cdate']
givenby = request.form['cgivenby']
row = len(request.form.getlist('conmed_id'))
wcctime = request.form.getlist('contime')
conname = request.form.getlist('conmed_id')
cqty = request.form.getlist('conqty')
camount = request.form.getlist('conprice')
remqty = request.form.getlist('remqty')
try:
if request.method == 'POST':
for i in range(row):
dbcolumn = []
htmlcolumn = []
tablename = "ward_consume_chart"
dbcolumn.append('wrd_id')
dbcolumn.append('wccdate')
dbcolumn.append('wcctime')
dbcolumn.append('cgivenby')
dbcolumn.append('conname')
dbcolumn.append('cqty')
dbcolumn.append('camount')
htmlcolumn.append(wrd_id)
htmlcolumn.append(wccdate)
htmlcolumn.append(wcctime[i])
htmlcolumn.append(givenby)
htmlcolumn.append(conname[i])
htmlcolumn.append(cqty[i])
htmlcolumn.append(str(float(cqty[i]) * float(camount[i])))
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
if result == 1:
dbcolumn = []
htmlcolumn = []
tablename = "medicine_outward_detail"
dbcolumn.append('issued_qty')
dbcolumn.append('meddet_id')
htmlcolumn.append(str(remqty[i]))
htmlcolumn.append(conname[i])
result = up.UpdateData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def newPanel():
#regno = request.form['regno']
#pclass= request.form['pclass']
dbcolumn = []
htmlcolumn = []
tablename = "admin_addpanel"
result = ''
try:
if request.method == 'POST':
dbcolumn.append('sid')
dbcolumn.append('panel_name')
htmlcolumn.append(request.form['panel'])
htmlcolumn.append(request.form['panel_name'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def insertNurseryTPRChart():
result = ''
tablename = "ward_nursery_tprchart"
row = len(request.form.getlist('tpr_temp'))
ttime = request.form.getlist('tpr_time')
ttemp = request.form.getlist('tpr_temp')
trespiration = request.form.getlist('tpr_respiration')
turine = request.form.getlist('tpr_urine')
tstool = request.form.getlist('tpr_stool')
tspo2 = request.form.getlist('tpr_spo2')
tweight = request.form.getlist('tpr_weight')
try:
if request.method == 'POST':
for i in range(row):
dbcolumn = []
htmlcolumn = []
dbcolumn.append('wrd_id')
dbcolumn.append('tpr_date')
dbcolumn.append('tpr_givenby')
dbcolumn.append('tpr_time')
dbcolumn.append('tpr_temp')
dbcolumn.append('tpr_respiration')
dbcolumn.append('tpr_urine')
dbcolumn.append('tpr_stool')
dbcolumn.append('tpr_spo2')
dbcolumn.append('tpr_weight')
htmlcolumn.append(request.form['wrd_id'])
htmlcolumn.append(request.form['tpr_date'])
htmlcolumn.append(request.form['tpr_givenby'])
htmlcolumn.append(ttime[i])
htmlcolumn.append(ttemp[i])
htmlcolumn.append(trespiration[i])
htmlcolumn.append(turine[i])
htmlcolumn.append(tstool[i])
htmlcolumn.append(tspo2[i])
htmlcolumn.append(tweight[i])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
def visitIpd():
gscheme=request.form['gscheme']
dbcolumn = []
htmlcolumn = []
result=''
tablename = "ipdvisit"
try:
if request.method == 'POST':
dbcolumn.append('regno')
dbcolumn.append('complaint')
dbcolumn.append('patientfrom')
dbcolumn.append('ipddate')
dbcolumn.append('ipdtime')
dbcolumn.append('ptype')
dbcolumn.append('govscheme')
dbcolumn.append('urnno')
dbcolumn.append('advmoney')
dbcolumn.append('moneyreceivedby')
dbcolumn.append('wardid')
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(request.form['complaint'])
htmlcolumn.append(request.form['patientfrom'])
htmlcolumn.append(request.form['ipddate'])
htmlcolumn.append(request.form['ipdtime'])
htmlcolumn.append(request.form['ptype'])
if gscheme == 'eligible':
htmlcolumn.append(request.form['govscheme'])
else:
htmlcolumn.append(str(request.form['gscheme']))
htmlcolumn.append(request.form['urnno'])
htmlcolumn.append(request.form['advmoney'])
htmlcolumn.append(request.form['moneyreceivedby'])
htmlcolumn.append(request.form['wardid'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn,htmlcolumn,tablename)
return result
except Exception as e:
return str(e)
def visitOpdInsert():
dbcolumn = []
htmlcolumn = []
result = ''
tablename = "opdvisit"
try:
if request.method == 'POST':
#Name of database Attribute
dbcolumn.append('regno')
dbcolumn.append('ptype')
dbcolumn.append('vdate')
dbcolumn.append('vtime')
dbcolumn.append('height')
dbcolumn.append('weight')
dbcolumn.append('bmi')
dbcolumn.append('temp')
dbcolumn.append('pulse')
dbcolumn.append('rrate')
dbcolumn.append('systolic')
dbcolumn.append('diastolic')
dbcolumn.append('complaint')
#Name of html component e.g request.form['nameofcomponenet']
htmlcolumn.append(request.form['regno'])
htmlcolumn.append(request.form['ptype'])
htmlcolumn.append(request.form['vdate'])
htmlcolumn.append(request.form['vtime'])
htmlcolumn.append(request.form['height'])
htmlcolumn.append(request.form['weight'])
htmlcolumn.append(request.form['bmi'])
htmlcolumn.append(request.form['temp'])
htmlcolumn.append(request.form['pulse'])
htmlcolumn.append(request.form['rrate'])
htmlcolumn.append(request.form['systolic'])
htmlcolumn.append(request.form['diastolic'])
htmlcolumn.append(request.form['complaint'])
# Here we are calling InsertData that have a common code for insert record.
result = ins.InsertData(dbcolumn, htmlcolumn, tablename)
return result
except Exception as e:
return str(e)
