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)