def ShowItem(self, ibar=1): return sq.wxsqltxt( 'Menu.db', """select mitem.id,mitem.itemid,mitem.mbarid,mitem.itemname,mitem.handler from mitem where mitem.mbarid = %d """ % ibar)
def ShwAcc2(self): return sq.wxsqltxt( 'Molk.db', """ select Account.Acc,Account.name,Account.phone,Respon.Resname from Account,Respon where Account.Res = Respon.Res """)
def gAAcod(self, code=u''): return sq.wxsqltxt( 'Archive.db', """ select Account.Acc,Account.name,Account.phone,Account.Spc from Account where Account.Acc = '%s' """ % code)
def gLBac(self): return sq.wxsqltxt( 'ABR.db', """ select distinct B.Rev,Backup.Bacfile,Backup.Bacdir,Backup.Bacdate,Backup.Bactime from B,Backup where B.Bac = Backup.Bac """)
def gSpcy(self, code=u''): return sq.wxsqltxt( 'Main.db', """ select Specify.Spcfy,Titels.titel,Specify.tit from Specify,Titels where Specify.Spc = '%s' and Specify.tit = Titels.tit """ % code)
def gLRes(self): return sq.wxsqltxt( 'ABR.db', """ select distinct R.Rev,Restor.Resfile,Restor.Resdir,Restor.Resdate,Restor.Restime from R,Restor where R.Res = Restor.Res """)
def ShwRes2(self): return sq.wxsqltxt( 'Molk.db', """ select * from Respon where substr(Res ,1,1) >= '0' and substr(Res,2,1) = '' """)
def SumBil(self, code=u''): return sq.wxsqltxt( 'Main.db', """select distinct Document.Acc,Account.name,sum(Document.Cr),sum(Document.Dr) from Document,Account where Document.Acc = '%s' and Document.Acc = Account.Acc """ % code)
def ShwKol(self, code=u''): return sq.wxsqltxt( 'Main.db', """select distinct Document.no,Document.date,Account.name,Document.Cr,Document.Dr from Document,Account where substr( Document.Acc,1,2) = '%s' and Document.Acc = Account.Acc """ % code)
def ShwBil2(self, code=u'', no=u''): return sq.wxsqltxt( 'Main.db', """select distinct Document.no,Document.date,Document.Cr,Document.Dr from Document where Document.Acc = '%s' and Document.no = '%s' """ % (code, no))
def toDDoc(self, date=u''): return sq.wxsqltxt( 'Main.db', """select distinct Descript.Descrpt,Document.date,Document.no from Document,Descript where Document.date <= '%s' and Document.Des = Descript.Des order by Document.date """ % date)
def ShowDoc(self, date=u''): return sq.wxsqltxt( 'Main.db', """select distinct Document.date,Document.no,Account.name,Descript.Descrpt,Document.Cr,Document.Dr from Document,Descript,Account where Document.date = '%s' and Document.Acc = Account.Acc and Document.Des = Descript.Des """ % date)
def ShwDoc(self, num=u''): return sq.wxsqltxt( 'Main.db', """select distinct Document.no,Document.date,Document.Acc,Account.name,Descript.Descrpt,Document.Cr,Document.Dr from Document,Descript,Account where Document.no = '%s' and Document.Acc = Account.Acc and Document.Des = Descript.Des order by Document.Cr desc """ % num)
def ShwMlks2(self, code=u''): return sq.wxsqltxt( 'Molk.db', """ select Date,name,phone,Aname,Addrss,Mname,M1,M2,M3,M4,Spcfy,Amunt1,Amunt2,dscrpt from Molks inner join MSpcify on Molks.MSpc = MSpcify.MSpc inner join Descript on Molks.des = Descript.des inner join Account on Molks.Acc = Account.Acc inner join Mntgh on Molks.Area = Mntgh.Area where Mcode = %s """ % code)
def gMolks2(self, newsql): sql = self.SQL2 + newsql return sq.wxsqltxt('Molk.db', sql)
def Amlak22(self, newsql=u''): return sq.wxsqltxt('Molk.db', self.SQL32 + newsql)
def lsrev(self, code=u''): return sq.wxsqltxt( 'Company.db', """select distinct Revenue.Reven,Company.Dir from Company,Revenue where Revenue.Rev = Company.Rev and Company.id = '%s'""" % code)
def gAMtgCk(self, name=u''): return sq.wxsqltxt( 'Archive.db', """ select Mntgh.Area,Mntgh.Aname from Mntgh where Mntgh.Aname = '%s' """ % name)
def gAlstMlk(self): return sq.wxsqltxt( 'Archive.db', """ select Mcode from Molks order by Mcode """)
def gMolks(self): return sq.wxsqltxt('Molk.db', self.SQL2)
def gRevnm(self, name=u''): return sq.wxsqltxt( 'Main.db', """select Revenue.Reven ,Revenue.fdate,Revenue.ldate from Revenue where Revenue.Reven = '%s'""" % name)
def gRevnu(self, code=u''): return sq.wxsqltxt( 'Main.db', """select Revenue.Reven ,Revenue.fdate,Revenue.ldate from Revenue where Revenue.Rev = '%s'""" % code)
def Amlak(self): return sq.wxsqltxt('Molk.db', self.SQL1)
def gLstac(self, code=u''): return sq.wxsqltxt( 'Main.db', """select Account.Acc from Account where Account.Acg = '%s' """ % code)
def gAMntgh(self): return sq.wxsqltxt( 'Archive.db', """ select Mntgh.Area,Mntgh.Aname from Mntgh """)
def Amlak4(self, newsql=u''): sql = self.SQL4 + newsql return sq.wxsqltxt('Molk.db', sql)
def ShwMlks(self, code=u''): return sq.wxsqltxt('Molk.db', """ select * from Molks where Mcode = %s """ % code)
def Amlak11(self, newsql): sql = self.SQL1 + newsql #print sql return sq.wxsqltxt('Molk.db', sql)
def gItem(self, mbar=1): return sq.wxsqltxt( "Menu.db", """select mitem.itemname,mitem.itemid from mitem where mitem.mbarid = %d """ % mbar)
def gASpc(self, code=u''): return sq.wxsqltxt( 'Molk.db', """ select * from Specify where Specify.Spc = '%s' """ % code)