| Line 185... |
Line 185... |
| 185 |
|
185 |
|
| 186 |
wallet = WalletForCompany.query.filter(WalletForCompany.id == 1).one()
|
186 |
wallet = WalletForCompany.query.filter(WalletForCompany.id == 1).one()
|
| 187 |
|
187 |
|
| 188 |
dt = session.query(func.sum(RechargeTransaction.amount)).filter(RechargeTransaction.status.in_([RechargeOrderStatus.RECHARGE_SUCCESSFUL])).one()
|
188 |
dt = session.query(func.sum(RechargeTransaction.amount)).filter(RechargeTransaction.status.in_([RechargeOrderStatus.RECHARGE_SUCCESSFUL])).one()
|
| 189 |
|
189 |
|
| 190 |
if int(dt[0]) != wallet.amount:
|
190 |
# if int(dt[0]) != wallet.amount:
|
| 191 |
mail("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in"], "Wallet amount: " + str(wallet.amount) + " does not match with transaction amount: " + str(int(dt[0])) , "", [], [], [])
|
191 |
# mail("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in"], "Wallet amount: " + str(wallet.amount) + " does not match with transaction amount: " + str(int(dt[0])) , "", [], [], [])
|
| 192 |
|
192 |
|
| 193 |
maildata = "<html><body><table border='1'><thead><th>StoreId</th><th>Gross</th><th>Discount</th><th>Net</th></thead><tbody>"
|
193 |
maildata = "<html><body><table border='1'><thead><th>StoreId</th><th>Gross</th><th>Discount</th><th>Net</th></thead><tbody>"
|
| 194 |
trecharge = 0
|
194 |
trecharge = 0
|
| 195 |
for storeId in storeData.keys():
|
195 |
for storeId in storeData.keys():
|
| 196 |
store = HotspotStore.get_by(id = storeId)
|
196 |
store = HotspotStore.get_by(id = storeId)
|
| Line 219... |
Line 219... |
| 219 |
wamt = int(dit2[0])- int(dit[0])
|
219 |
wamt = int(dit2[0])- int(dit[0])
|
| 220 |
wallet.amount = wamt
|
220 |
wallet.amount = wamt
|
| 221 |
session.commit()
|
221 |
session.commit()
|
| 222 |
|
222 |
|
| 223 |
maildata += "</tbody></table></body></html>"
|
223 |
maildata += "</tbody></table></body></html>"
|
| 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", "amit.tyagi@spiceretail.co.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", "amit.tyagi@spiceretail.co.in"], "MIS (Date - " + todate.strftime("%d-%m-%Y") + ") (Wallet Amount - " + str(wallet.amount) + ") (Total Recharge - " + str(trecharge) + ")", maildata, [])
|
| 225 |
|
- |
|
| 226 |
try:
|
225 |
try:
|
| 227 |
push_recharge_collection_to_ocr()
|
226 |
push_recharge_collection_to_ocr()
|
| 228 |
except:
|
227 |
except:
|
| 229 |
mail_html("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in", "rajneesh.arora@shop2020.in"], "Problem while pushing recharge collection to OCR", "", [])
|
228 |
mail_html("cnc.center@shop2020.in", "5h0p2o2o", ["rajveer.singh@shop2020.in", "anupam.singh@shop2020.in", "rajneesh.arora@shop2020.in"], "Problem while pushing recharge collection to OCR", "", [])
|
| 230 |
|
229 |
|