def inputorder(inputID, inputDate, inputlat, inputlong, inputAmt, crt, ep, bag,
rem):
sqlquery = "EXEC SelectOrder @uid = '" + str(
inputID) + "', @date = '" + str(inputDate) + "', @lat = '" + str(
inputlat) + "', @long = '" + str(inputlong) + "', @amt= " + str(
inputAmt) + ", @crt= " + str(crt) + ", @ep= " + str(
ep) + ", @bag= " + str(bag) + ", @rem='" + str(rem) + "'"
return fn.getlistdata(sqlquery)
def ipdealerorder(inputSID, inputID, inputDate, inputloc, inputAmt, crt, ep,
bag, basket, rem):
sqlquery = "EXEC InsertDealerOrder @sid='" + str(
inputSID) + "', @uid = '" + str(inputID) + "', @date = '" + str(
inputDate) + "', @loc = '" + str(inputloc) + "', @amt=" + str(
inputAmt) + ", @crt= " + str(crt) + ", @ep= " + str(
ep) + ", @bag= " + str(bag) + ", @basket=" + str(
basket) + ", @rem='" + str(rem) + "'"
return fn.getlistdata(sqlquery)
def register(pre, uname, mobile, aadhar, fname, fstatus, p1, p2, dname,
oaddress, ostate, opin, gaddress, gstate, gpin, gst, pan, fssai,
fsdate, dcode):
sqlquery = "EXEC RegisterUser @pre='" + str(pre) + "', @uname='" + str(
uname) + "', @mobile=" + str(mobile) + ", @aadhar='" + str(
aadhar
) + "', @fname='" + str(fname) + "', @fstatus='" + str(
fstatus
) + "', @p1='" + str(p1) + "', @p2='" + str(p2) + "', @dname='" + str(
dname) + "', @oaddress='" + str(oaddress) + "', @ostate='" + str(
ostate) + "', @opin=" + str(opin) + ", @gaddress='" + str(
gaddress
) + "', @gstate='" + str(gstate) + "', @gpin=" + str(
gpin) + ", @gst='" + str(gst) + "', @pan='" + str(
pan) + "', @fssai='" + str(
fssai) + "', @fsdate='" + str(
fsdate) + "', @devicecode='" + str(dcode) + "'"
return fn.getlistdata(sqlquery)
def getohmenu(inpID):
sqlquery = "EXEC SelectOHMenu @id='" + str(inpID) + "'"
return fn.getlistdata(sqlquery)
def getledger(ipId):
sqlquery = "EXEC GetLedgerDetails @uid = '" + str(ipId) + "'"
return fn.getlistdata(sqlquery)
def getflavor(inpID):
sqlquery = "EXEC GetFlavours @uid='" + str(inpID) + "'"
return fn.getlistdata(sqlquery)
def checksubdate(id, date):
sqlquery = "EXEC checkSubOrder @date='" + str(date) + "', @id='" + str(
id) + "'"
return fn.getlistdata(sqlquery)
def getacceptedorders(ipID, list, option, date):
sqlquery = "EXEC SelectAcceptedOrder @uid='" + str(
ipID) + "', @list='" + str(list) + "', @option='" + str(
option) + "', @date='" + str(date) + "'"
return fn.getlistdata(sqlquery)
def getUsersToAuth(ipID, option, date):
sqlquery = "EXEC SelectSubToBeAuthAlt @uid='" + str(
ipID) + "', @option='" + str(option) + "', @date='" + str(date) + "'"
return fn.getlistdata(sqlquery)
def getfestival(date):
sqlquery = "EXEC SelectFestival @date='" + str(date) + "'"
return fn.getlistdata(sqlquery)
def getavailableflavour(inpID):
sqlquery = "EXEC SelectAvailableFlavours @uid='" + str(inpID) + "'"
return fn.getlistdata(sqlquery)
def getgroupname():
sqlquery = "EXEC SelectGroupNames"
return fn.getlistdata(sqlquery)
def getpkgdetails(ipId):
sqlquery = "EXEC SelectPackageDetails @uid = '" + str(ipId) + "'"
return fn.getlistdata(sqlquery)
def getupperid(ipID):
sqlquery = "EXEC SelectUpperID @dealer='" + str(ipID) + "'"
return fn.getlistdata(sqlquery)
def getorderhistorymenu(inpID):
sqlquery = "EXEC SelectOrderHistoryMenu @id='" + str(inpID) + "'"
return fn.getlistdata(sqlquery)
def countord(id, date):
sqlquery = "EXEC CountOrders @uid='" + str(id) + "', @date='" + str(
date) + "'"
return fn.getlistdata(sqlquery)
def getorderdetails(oid):
sqlquery = "EXEC SelectOrderDetails @oid='" + str(oid) + "'"
return fn.getlistdata(sqlquery)
def returnLogin(input):
sqlquery = 'EXEC SelectUser @Mobile = ' + str(input)
return fn.getlistdata(sqlquery)
def loginuser(mode, value):
sqlquery = "EXEC LoginUser @mode=" + str(mode) + ", @value='" + str(
value) + "'"
return fn.getlistdata(sqlquery)
def getSuperID(ipID):
sqlquery = "EXEC SelectSuper @dealer='" + str(ipID) + "'"
return fn.getlistdata(sqlquery)
def directorder(id, start, end):
sqlquery = "EXEC SelectDirectOrdersHistory @id='" + str(
id) + "', @start='" + str(start) + "', @end='" + str(end) + "'"
return fn.getlistdata(sqlquery)
def getdealersforss(ipID):
sqlquery = "EXEC SelectDealersForSuper @id='" + str(ipID) + "'"
return fn.getlistdata(sqlquery)
def getordersforauth(ipID, list, option):
sqlquery = "EXEC SelectOrderForAuthorize @uid='" + str(
ipID) + "', @list='" + str(list) + "', @option='" + str(option) + "'"
return fn.getlistdata(sqlquery)
def getsupername(ipID):
sqlquery = "EXEC SelectSuperNames @id='" + str(ipID) + "'"
return fn.getlistdata(sqlquery)
def superorder(id, start, end, option):
sqlquery = "EXEC SelectSuperOrdersHistory @id='" + str(
id) + "', @start='" + str(start) + "', @end='" + str(
end) + "', @option='" + str(option) + "'"
return fn.getlistdata(sqlquery)
def getusermenu(ipId, ipOpt):
sqlquery = "EXEC SelectMainMenu @Uid = '" + str(ipId) + "', @Opt = " + str(
ipOpt)
return fn.getlistdata(sqlquery)
def getpkgname(ipId):
sqlquery = "EXEC GetPackage @uid = '" + str(ipId) + "'"
return fn.getlistdata(sqlquery)
