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)
