def showMedicine(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 print(root) if request.method == 'GET': # sql = 'select * from medicine;' sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode;' medicine_list = sqlUse.get_list(sql, []) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root}) else: typeChoose = request.POST.get('type') typeValue = request.POST.get('value') c1 = '%%'+typeValue+'%%' if(typeChoose == '1'): sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode where belong.Mname like %s' medicine_list = sqlUse.get_list(sql, [c1, ]) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root}) elif(typeChoose == '2'): sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode where belong.Mlot like %s' medicine_list = sqlUse.get_list(sql, [c1, ]) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root}) elif (typeChoose == '3'): sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode where belong.Firmcode like %s' medicine_list = sqlUse.get_list(sql, [c1, ]) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root}) else: sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode where belong.Belongcode like %s' medicine_list = sqlUse.get_list(sql, [c1, ]) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root})
def editMedicine(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql1 = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode;' sql2 = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode where belong.Mname=%s and belong.Mlot=%s and belong.Firmcode=%s and belong.Belongcode=%s;' Mname = request.GET.get('Mname') Mlot = request.GET.get('Mlot') Belongcode = request.GET.get('Belongcode') Firmcode = request.GET.get('Firmcode') current_medicine = sqlUse.get_one(sql2, [Mname, Mlot, Firmcode, Belongcode, ]) medicine_list = sqlUse.get_list(sql1, []) return render(request, 'editMedicine.html', {'medicine_list': medicine_list, 'current_medicine': current_medicine, 'root': root}) else: Mname = request.POST.get('Mname') Mlot = request.POST.get('Mlot') Firmcode = request.POST.get('Firmcode') Mmoney = request.POST.get('Mmoney') Mcount = request.POST.get('Mcount') Cdate = request.POST.get('Cdate') Sdate = request.POST.get('Sdate') Belongcode = request.POST.get('Belongcode') Belongnum = request.POST.get('Belongnum') sql = 'update medicine set Mname=%s, Mlot=%s, Firmcode=%s, Mmoney=%s, Mcount=%s, Cdate=%s, Sdate=%s ' \ 'where Mname=%s and Mlot=%s and Firmcode=%s; ' sqlUse.modify(sql, [Mname, Mlot, Firmcode, Mmoney, Mcount, Cdate, Sdate, Mname, Mlot, Firmcode, ]) sql = 'update belong set Mname=%s, Mlot=%s, Firmcode=%s, Belongcode=%s, Belongnum=%s where Mname=%s and Mlot=%s and Firmcode=%s and Belongcode=%s;' sqlUse.modify(sql, [Mname, Mlot, Firmcode, Belongcode, Belongnum, Mname, Mlot, Firmcode, Belongcode, ]) sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode;' medicine_list = sqlUse.get_list(sql, []) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root})
def editShop(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql1 = 'select * from shop' sql2 = 'select * from shop where Shopcode=%s' Shopcode = request.GET.get('Shopcode') current_shop = sqlUse.get_one(sql2, [ Shopcode, ]) shop_list = sqlUse.get_list(sql1, []) return render(request, 'editShop.html', { 'shop_list': shop_list, 'current_shop': current_shop, 'root': root }) else: Shopcode = request.POST.get('Shopcode') Shopname = request.POST.get('Shopname') Shoptype = request.POST.get('Shoptype') Shopregion = request.POST.get('Shopregion') Shopadress = request.POST.get('Shopadress') Shoparea = request.POST.get('Shoparea') Shoplat = request.POST.get('Shoplat') Shoplng = request.POST.get('Shoplng') Doarea = request.POST.get('Doarea') Housearea = request.POST.get('Housearea') Shopphone = request.POST.get('Shopphone') Wcode = request.POST.get('Wcode') sql = 'update shop set Shopcode=%s, Shopname=%s, Shoptype=%s, Shopregion=%s, Shopadress=%s, shoparea=%s, shoplat=%s, shoplng=%s, Doarea=%s, Housearea=%s, Shopphone=%s, Wcode=%s where Shopcode=%s ;' sqlUse.modify(sql, [ Shopcode, Shopname, Shoptype, Shopregion, Shopadress, Shoparea, Shoplat, Shoplng, Doarea, Housearea, Shopphone, Wcode, Shopcode, ]) sql = 'select * from shop;' shop_list = sqlUse.get_list(sql, []) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root })
def addPharmacist(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': return render(request, 'addPharmacist.html', {'root': root}) else: Phcode = request.POST.get('Phcode') Phname = request.POST.get('Phname') Phsex = request.POST.get('Phsex') Phage = request.POST.get('Phage') Phtitle = request.POST.get('Phtitle') Shopcode = request.POST.get('Shopcode') Phphone = request.POST.get('Phphone') Phcor = request.POST.get('Phcor') sql = 'insert into pharmacist values(%s,%s,%s,%s,%s,%s,%s,%s);' sqlUse.modify(sql, [ Phcode, Phname, Phsex, Phage, Phtitle, Shopcode, Phphone, Phcor, ]) sql = 'select * from pharmacist;' pharmacist_list = sqlUse.get_list(sql, []) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root })
def addWorker(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': return render(request, 'addWorker.html', {'root': root}) else: Wcode = request.POST.get('Wcode') Wname = request.POST.get('Wname') Wsex = request.POST.get('Wsex') Wage = request.POST.get('Wage') Wposition = request.POST.get('Wposition') Wphone = request.POST.get('Wphone') sql = 'insert into worker values(%s,%s,%s,%s,%s,%s);' sqlUse.modify(sql, [ Wcode, Wname, Wsex, Wage, Wposition, Wphone, ]) sql = 'select * from worker;' worker_list = sqlUse.get_list(sql, []) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root })
def addFirm(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': return render(request, 'addFirm.html', {'root': root}) else: Firmcode = request.POST.get('Firmcode') Firmname = request.POST.get('Firmname') Firmregion = request.POST.get('Firmregion') Firmadress = request.POST.get('Firmadress') Firmlat = request.POST.get('Firmlat') Firmlng = request.POST.get('Firmlng') Firmphone = request.POST.get('Firmphone') Wcode = request.POST.get('Wcode') sql = 'insert into firm values(%s,%s,%s,%s,%s,%s,%s,%s);' sqlUse.modify(sql, [ Firmcode, Firmname, Firmregion, Firmadress, Firmlat, Firmlng, Firmphone, Wcode, ]) sql = 'select * from firm;' firm_list = sqlUse.get_list(sql, []) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root })
def editFirm(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql1 = 'select * from firm' sql2 = 'select * from firm where Firmcode=%s' Firmcode = request.GET.get('Firmcode') current_firm = sqlUse.get_one(sql2, [ Firmcode, ]) firm_list = sqlUse.get_list(sql1, []) return render(request, 'editFirm.html', { 'firm_list': firm_list, 'current_firm': current_firm, 'root': root }) else: Firmcode = request.POST.get('Firmcode') Firmname = request.POST.get('Firmname') Firmregion = request.POST.get('Firmregion') Firmadress = request.POST.get('Firmadress') Firmlat = request.POST.get('Firmlat') Firmlng = request.POST.get('Firmlng') Firmphone = request.POST.get('Firmphone') Wcode = request.POST.get('Wcode') sql = 'update firm set Firmcode=%s, Firmname=%s, Firmregion=%s, Firmadress=%s, Firmlat=%s, Firmlng=%s, Firmphone=%s, Wcode=%s where Firmcode=%s ;' sqlUse.modify(sql, [ Firmcode, Firmname, Firmregion, Firmadress, Firmlat, Firmlng, Firmphone, Wcode, Firmcode, ]) sql = 'select * from firm;' firm_list = sqlUse.get_list(sql, []) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root })
def showFirm(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql = 'select * from firm;' firm_list = sqlUse.get_list(sql, []) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root }) else: typeChoose = request.POST.get('type') typeValue = request.POST.get('value') c1 = '%%' + typeValue + '%%' if (typeChoose == '1'): sql = 'select * from firm where Firmcode like %s' firm_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root }) elif (typeChoose == '2'): sql = 'select * from firm where Firmname like %s' firm_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root }) else: sql = 'select * from firm where Firmregion like %s' firm_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root })
def showWorker(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql = 'select * from worker;' worker_list = sqlUse.get_list(sql, []) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root }) else: typeChoose = request.POST.get('type') typeValue = request.POST.get('value') c1 = '%%' + typeValue + '%%' if (typeChoose == '1'): sql = 'select * from worker where Wcode like %s' worker_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root }) elif (typeChoose == '2'): sql = 'select * from worker where Wname like %s' worker_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root }) else: sql = 'select * from worker where Wposition like %s' worker_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root })
def editWorker(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql1 = 'select * from worker' sql2 = 'select * from worker where Wcode=%s' Wcode = request.GET.get('Wcode') current_worker = sqlUse.get_one(sql2, [ Wcode, ]) worker_list = sqlUse.get_list(sql1, []) return render( request, 'editWorker.html', { 'worker_list': worker_list, 'current_worker': current_worker, 'root': root }) else: Wcode = request.POST.get('Wcode') Wname = request.POST.get('Wname') Wsex = request.POST.get('Wsex') Wage = request.POST.get('Wage') Wposition = request.POST.get('Wposition') Wphone = request.POST.get('Wphone') sql = 'update worker set Wcode=%s, Wname=%s, Wsex=%s, Wage=%s, Wposition=%s, Wphone=%s where Wcode=%s ;' sqlUse.modify(sql, [ Wcode, Wname, Wsex, Wage, Wposition, Wphone, Wcode, ]) sql = 'select * from worker;' worker_list = sqlUse.get_list(sql, []) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root })
def deleteFirm(request): root = request.GET.get('root') Firmcode = request.GET.get('Firmcode') sql = 'delete from firm where Firmcode=%s' sqlUse.modify(sql, [ Firmcode, ]) sql = 'select * from firm;' firm_list = sqlUse.get_list(sql, []) return render(request, 'showFirm.html', { 'firm_list': firm_list, 'root': root })
def editPharmacist(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql1 = 'select * from pharmacist' sql2 = 'select * from pharmacist where Phcode=%s' Phcode = request.GET.get('Phcode') current_pharmacist = sqlUse.get_one(sql2, [ Phcode, ]) pharmacist_list = sqlUse.get_list(sql1, []) return render( request, 'editPharmacist.html', { 'pharmacist_list': pharmacist_list, 'current_pharmacist': current_pharmacist, 'root': root }) else: Phcode = request.POST.get('Phcode') Phname = request.POST.get('Phname') Phsex = request.POST.get('Phsex') Phage = request.POST.get('Phage') Phtitle = request.POST.get('Phtitle') Shopcode = request.POST.get('Shopcode') Phphone = request.POST.get('Phphone') Phcor = request.POST.get('Phcor') sql = 'update pharmacist set Phcode=%s, Phname=%s, Phsex=%s, Phage=%s, Phtitle=%s, Shopcode=%s, Phphone=%s, Phcor=%s where Phcode=%s ;' sqlUse.modify(sql, [ Phcode, Phname, Phsex, Phage, Phtitle, Shopcode, Phphone, Phcor, Phcode ]) sql = 'select * from pharmacist;' pharmacist_list = sqlUse.get_list(sql, []) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root })
def deleteWorker(request): root = request.GET.get('root') Wcode = request.GET.get('Wcode') sql = 'delete from worker where Wcode=%s' sqlUse.modify(sql, [ Wcode, ]) sql = 'select * from worker;' worker_list = sqlUse.get_list(sql, []) return render(request, 'showWorker.html', { 'worker_list': worker_list, 'root': root })
def deletePharmacist(request): root = request.GET.get('root') Phcode = request.GET.get('Phcode') sql = 'delete from pharmacist where Phcode=%s' sqlUse.modify(sql, [ Phcode, ]) sql = 'select * from pharmacist;' pharmacist_list = sqlUse.get_list(sql, []) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root })
def deleteMedicine(request): root = request.GET.get('root') Mname = request.GET.get('Mname') Mlot = request.GET.get('Mlot') Belongcode = request.GET.get('Belongcode') Firmcode = request.GET.get('Firmcode') sql = 'delete from medicine where Mname=%s and Mlot=%s and Firmcode=%s;' sqlUse.modify(sql, [Mname, Mlot, Firmcode, ]) sql = 'delete from belong where Mname=%s and Mlot=%s and Firmcode=%s and Belongcode=%s;' sqlUse.modify(sql, [Mname, Mlot, Firmcode, Belongcode, ]) sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode;' medicine_list = sqlUse.get_list(sql, []) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root})
def deleteShop(request): root = request.GET.get('root') Shopcode = request.GET.get('Shopcode') sql = 'delete from shop where Shopcode=%s' sqlUse.modify(sql, [ Shopcode, ]) sql = 'select * from shop;' shop_list = sqlUse.get_list(sql, []) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root })
def addShop(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': return render(request, 'addShop.html', {'root': root}) else: Shopcode = request.POST.get('Shopcode') Shopname = request.POST.get('Shopname') Shoptype = request.POST.get('Shoptype') Shopregion = request.POST.get('Shopregion') Shopadress = request.POST.get('Shopadress') Shoparea = request.POST.get('Shoparea') Shoplat = request.POST.get('Shoplat') Shoplng = request.POST.get('Shoplng') Doarea = request.POST.get('Doarea') Housearea = request.POST.get('Housearea') Shopphone = request.POST.get('Shopphone') Wcode = request.POST.get('Wcode') sql = 'insert into shop values(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);' sqlUse.modify(sql, [ Shopcode, Shopname, Shoptype, Shopregion, Shopadress, Shoparea, Shoplat, Shoplng, Doarea, Housearea, Shopphone, Wcode, ]) sql = 'select * from shop;' shop_list = sqlUse.get_list(sql, []) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root })
def addMedicine(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': return render(request, 'addMedicine.html', {'root': root}) else: Mname = request.POST.get('Mname') Mlot = request.POST.get('Mlot') Firmcode = request.POST.get('Firmcode') Mmoney = request.POST.get('Mmoney') Mcount = request.POST.get('Mcount') Cdate = request.POST.get('Cdate') Sdate = request.POST.get('Sdate') Belongcode = request.POST.get('Belongcode') Belongnum = request.POST.get('Belongnum') sql = 'insert into medicine values(%s,%s,%s,%s,%s,%s,%s);' sqlUse.modify(sql, [Mname, Mlot, Firmcode, Mmoney, Mcount, Cdate, Sdate, ]) sql = 'insert into belong values(%s, %s, %s, %s, %s);' sqlUse.modify(sql, [Mname, Mlot, Firmcode, Belongcode, Belongnum, ]) sql = 'SELECT * FROM medicine INNER JOIN belong on medicine.Mname = belong.Mname AND medicine.Mlot = belong.Mlot AND medicine.Firmcode = belong.Firmcode;' medicine_list = sqlUse.get_list(sql, []) return render(request, 'showMedicine.html', {'medicine_list': medicine_list, 'root': root})
def showPharmacist(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql = 'select * from pharmacist;' pharmacist_list = sqlUse.get_list(sql, []) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root }) else: typeChoose = request.POST.get('type') typeValue = request.POST.get('value') c1 = '%%' + typeValue + '%%' if (typeChoose == '1'): sql = 'select * from pharmacist where Phcode like %s' pharmacist_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root }) elif (typeChoose == '2'): sql = 'select * from pharmacist where Phname like %s' pharmacist_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root }) elif (typeChoose == '3'): sql = 'select * from pharmacist where Phtitle like %s' pharmacist_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root }) elif (typeChoose == '4'): sql = 'select * from pharmacist where Shopcode like %s' pharmacist_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root }) else: sql = 'select * from pharmacist where Phcor like %s' pharmacist_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showPharmacist.html', { 'pharmacist_list': pharmacist_list, 'root': root })
def showShop(request): root = request.GET.get('root') root2 = request.POST.get('root2') if root is None: root = root2 if request.method == 'GET': sql = 'select * from shop;' shop_list = sqlUse.get_list(sql, []) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root }) else: typeChoose = request.POST.get('type') typeValue = request.POST.get('value') c1 = '%%' + typeValue + '%%' if (typeChoose == '1'): sql = 'select * from shop where Shopcode like %s' shop_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root }) elif (typeChoose == '2'): sql = 'select * from shop where Shopname like %s' shop_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root }) elif (typeChoose == '3'): sql = 'select * from shop where Shoptype like %s' shop_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root }) elif (typeChoose == '4'): sql = 'select * from shop where Shopregion like %s' shop_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root }) else: sql = 'select * from shop where Wcode like %s' shop_list = sqlUse.get_list(sql, [ c1, ]) return render(request, 'showShop.html', { 'shop_list': shop_list, 'root': root })