def command(self):
config=load_config(self.args)
filconadobj=FilconadObj(config,self.options.etl)
if self.options.store:
filconadobj.store_files()
if self.options.write:
filconadobj.write_out()
def command(self):
config=load_config(self.args)
b2bobj=B2bObj(config)
if self.options.write:
b2bobj.write_out()
if self.options.export:
b2bobj.export()
def command(self):
config=load_config(self.args)
if self.options.export:
f = open(config.get('starlogic.out'),'w')
fs = open(config.get('starlogic.sincro'))
sincro = 0
for i in fs.readlines():
sincro = i.strip()
sincro = int(sincro)
fs.close()
ps = DBSession.query(Eanprodotti)
if not self.options.all:
ps = ps.filter(Eanprodotti.sincrofield>sincro)
ps = ps.order_by(Eanprodotti.sincrofield).all()
for p in ps:
codart = p.prodotto.eans[0].ean
desc = p.prodotto.prodotto.encode('ascii', 'ignore')
prezzo = p.prodotto.prezzo
sincro = p.sincrofield
print >> f, "%s;%s;%s;%s;%s"%(codart, p.ean, desc, prezzo,0)
if len(p.aliases)>0:
for alias in p.aliases:
print >> f, "%s;%s;%s;%s;%s"%(codart, alias.alias, desc, prezzo,1)
f.close()
f = open(config.get('starlogic.sincro'),'w')
print >> f, sincro
f.close()
def command(self):
config = load_config(self.args)
self.options.etl = "zucchetti"
zucchettiobj = ZucchettiObj(config, self.options.etl)
if self.options.store:
zucchettiobj.store_files()
if self.options.write:
zucchettiobj.write_out()
def command(self):
config=load_config(self.args)
if self.options.export:
cfs = DBSession.query(Clientifid).filter(Clientifid.email!=' ').all()
output = []
for c in cfs:
output.append('"%s %s" <%s>'%(c.nome, c.cognome, c.email))
f = open(self.options.export, 'w')
for o in output:
print >> f, o.encode('utf-8')
f.close()
def command(self):
config=load_config(self.args)
if self.options.export:
mistralobj=Db2Mistral(config)
mistralobj.write_out2()
mistralobj.write_out()
def command(self):
config=load_config(self.args)
from ebetl.lib.views import get_dailytotals,get_dailymenuitems, sync_do, sync_dmi, sync_lilliput, print_fact_dmi
if self.options.fromd:
fromd = dt.strptime(self.options.fromd, "%Y%m%d")
if self.options.tod:
tod = dt.strptime(self.options.tod, "%Y%m%d") + td(days=1)
else:
try:
tod = fromd + td(days=1)
except:
pass
if self.options.items:
#(u'000351', 1, u'351 ARQUATA', 2014, 1, 2, 1, u'PANETTERIA', 17, u'PANETTERIA', 207.73120000000006, 8.308799999999996, 216.03999999999996)
retly_tmp = get_dailymenuitems(fromd - rd(years=1), tod - rd(years=1))
retly = []
for r in retly_tmp:
row = list(r)
row[3] = row[3]+1
retly.append(row)
maply = get_map(retly)
ret = get_dailymenuitems(fromd, tod)
mapcy = get_map(ret)
results = []
for k in ret:
pdv = k[0]
y = k[3]
m = k[4]
d = k[5]
acc_num=k[6]
rep_num=k[8]
try:
ly = maply[pdv][y][m][d][acc_num][rep_num]
ly = ly[10:]
except:
ly = ["0","0","0"]
results.append(list(k)+list(ly))
for k in retly:
pdv = k[0]
y = k[3]
m = k[4]
d = k[5]
acc_num=k[6]
rep_num=k[8]
try:
mapcy[pdv][y][m][d][acc_num][rep_num]
except:
results.append(k[0:10]+["0","0","0"]+k[10:])
#for i in results:
# p = [str(j).replace('.',',') for j in i]
# print "|".join(p)
sync_dmi(results)
elif not self.options.sync and not self.options.printr:
# (u'000297', 2013, 1, 8, 396, 14.901287878787729, 5396.611399999985, 504.2985999999985, 5900.909999999941)
retly_tmp = get_dailytotals(fromd - rd(years=1), tod - rd(years=1))
retly = []
for r in retly_tmp:
row = list(r)
row[1] = row[1]+1
retly.append(row)
maply = get_map_do(retly)
ret = get_dailytotals(fromd, tod)
mapcy = get_map_do(ret)
results = []
for k in ret:
pdv = k[0]
y = k[1]
m = k[2]
d = k[3]
try:
ly = maply[pdv][y][m][d]
ly = ly[4:]
except:
ly = ["0","0","0","0","0"]
results.append(list(k)+list(ly))
for k in retly:
pdv = k[0]
y = k[1]
m = k[2]
d = k[3]
try:
mapcy[pdv][y][m][d]
except:
results.append(k[0:4]+["0","0","0","0","0"]+k[4:])
#for i in results:
# p = [str(j).replace('.',',') for j in i]
# print "|".join(p)
sync_do(results)
#print results
if self.options.sync:
sync_lilliput()
if self.options.printr:
from prettytable import PrettyTable
ret, tot = print_fact_dmi('000351', fromd, tod)
print tot
x = PrettyTable(["Famiglia", "Tot AC", "Tot AP", "Diff"])
x.align["Famiglia"] = "l"
x.align["Tot"] = "r"
x.align["Tot AC"] = "r"
x.align["Tot AP"] = "r"
x.align["Diff"] = "r"
x.padding_width = 1 # One space between column edges and contents (default)
x.float_format = '.2'
for r in ret:
x.add_row(r)
for t in tot:
t_lst = ['TOTALE'] + [i for i in t]
x.add_row(t_lst)
print x
