WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/getdata.py



        cur.execute("select name, c.* from store left join (select a.*, b.mtdamount,b.mtdquantity, b.mtdorders from  (select store_id, sum(amount_paid), count(*),  count(distinct order_id)  from allorder where date(created_on)=curdate()-interval 1 day group by store_id) a join (select store_id, sum(amount_paid) mtdamount, count(*) mtdquantity,  count(distinct order_id) mtdorders  from allorder where created_on >= CURDATE() -  interval DAY(CURDATE()-INTERVAL 1 day) day group by store_id) b on a.store_id=b.store_id) as c on name = c.store_id")
        rows = cur.fetchall()
        tbody =[]
        rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td></tr>"
        for data in rows:
            tbody.append(rowtemplate.format(data[0],data[2] if data[2] else "-",data[3] if data[3] else "-",data[4] if data[4] else "-",
                                            data[5] if data[5] else "-",data[6] if data[6] else "-",data[7] if data[7] else "-"))
                        
        # book.save("/home/manish/Desktop/Summary.xls")
        
        mailBodyTemplate="""
                <html>

Rev 17154	Rev 17155
Line 223...	Line 223...
223	cur.execute("select name, c.* from store left join (select a., b.mtdamount,b.mtdquantity, b.mtdorders from (select store_id, sum(amount_paid), count(), count(distinct order_id) from allorder where date(created_on)=curdate()-interval 1 day group by store_id) a join (select store_id, sum(amount_paid) mtdamount, count(*) mtdquantity, count(distinct order_id) mtdorders from allorder where created_on >= CURDATE() - interval DAY(CURDATE()-INTERVAL 1 day) day group by store_id) b on a.store_id=b.store_id) as c on name = c.store_id")	223	cur.execute("select name, c.* from store left join (select a., b.mtdamount,b.mtdquantity, b.mtdorders from (select store_id, sum(amount_paid), count(), count(distinct order_id) from allorder where date(created_on)=curdate()-interval 1 day group by store_id) a join (select store_id, sum(amount_paid) mtdamount, count(*) mtdquantity, count(distinct order_id) mtdorders from allorder where created_on >= CURDATE() - interval DAY(CURDATE()-INTERVAL 1 day) day group by store_id) b on a.store_id=b.store_id) as c on name = c.store_id")
224	`rows = cur.fetchall()`	224	`rows = cur.fetchall()`
225	`tbody =[]`	225	`tbody =[]`
226	`rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td></tr>"`	226	`rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td></tr>"`
227	`for data in rows:`	227	`for data in rows:`
228	`tbody.append(rowtemplate.format(data[0],data[2],data[3],data[4],data[5],data[6],data[7]))`	228	`tbody.append(rowtemplate.format(data[0],data[2] if data[2] else "-",data[3] if data[3] else "-",data[4] if data[4] else "-",`
-		229	`data[5] if data[5] else "-",data[6] if data[6] else "-",data[7] if data[7] else "-"))`
229		230
230	`# book.save("/home/manish/Desktop/Summary.xls")`	231	`# book.save("/home/manish/Desktop/Summary.xls")`
231		232
232	`mailBodyTemplate="""`	233	`mailBodyTemplate="""`
233	`<html>`	234	`<html>`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/getdata.py – Rev 17154 → 17155