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)