Subversion Repositories SmartDukaan

Rev

Rev 7253 | Rev 7277 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7253 Rev 7276
Line 212... Line 212...
212 
        session.commit()
 212 
        session.commit()
213 
 
 213 
 
214 
        maildata += "<tr><td>" + store.hotspotId + "</td><td>" + str(data[2]) + "</td><td>" + str(data[3]) + "</td><td>" + str(data[4]) + "</td></tr>"
 214 
        maildata += "<tr><td>" + store.hotspotId + "</td><td>" + str(data[2]) + "</td><td>" + str(data[3]) + "</td><td>" + str(data[4]) + "</td></tr>"
215 
        trecharge +=  data[2]
 215 
        trecharge +=  data[2]
216 
 
 216 
 
- 
 
 217 
    dit = session.query(func.sum(RechargeCollection.grossAmount)).one()
- 
 
 218 
    dit2 = session.query(func.sum(WalletHistoryForCompany.amount)).filter(WalletHistoryForCompany.amount >= 100000).one()
- 
 
 219 
    wamt = int(dit2[0])- int(dit[0])
- 
 
 220 
    wallet.amount = wamt
- 
 
 221 
    session.commit()
- 
 
 222 
 
217 
    maildata += "</tbody></table></body></html>"
 223 
    maildata += "</tbody></table></body></html>"
218 
    mail_html("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in", "Ashwani.Kumar@spiceretail.co.in","parveen.mittal@spiceretail.co.in","pardeep.panwar@spiceretail.co.in","gagan.sharma@spiceretail.co.in","j.p.gupta@shop2020.in", "rajneesh.arora@shop2020.in"], "MIS   (Date - " + todate.strftime("%d-%m-%Y") + ")   (Wallet Amount - " + str(wallet.amount) + ")    (Total Recharge - " + str(trecharge) + ")", maildata, [])
 224 
    mail_html("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in", "Ashwani.Kumar@spiceretail.co.in","parveen.mittal@spiceretail.co.in","pardeep.panwar@spiceretail.co.in","gagan.sharma@spiceretail.co.in","j.p.gupta@shop2020.in", "rajneesh.arora@shop2020.in"], "MIS   (Date - " + todate.strftime("%d-%m-%Y") + ")   (Wallet Amount - " + str(wallet.amount) + ")    (Total Recharge - " + str(trecharge) + ")", maildata, [])
219
225
220 
    try:
 226 
    try:
221 
        push_recharge_collection_to_ocr()
 227 
        push_recharge_collection_to_ocr()