| Line 142... |
Line 142... |
| 142 |
worksheet.write(row, inc(), aff[0]['saleAmount'])
|
142 |
worksheet.write(row, inc(), aff[0]['saleAmount'])
|
| 143 |
worksheet1.write(anotherrow, i, aff[0]['saleAmount'])
|
143 |
worksheet1.write(anotherrow, i, aff[0]['saleAmount'])
|
| 144 |
worksheet.write(row, inc(), aff[0]['payOut'])
|
144 |
worksheet.write(row, inc(), aff[0]['payOut'])
|
| 145 |
worksheet1.write(anotherrow, i, aff[0]['payOut'])
|
145 |
worksheet1.write(anotherrow, i, aff[0]['payOut'])
|
| 146 |
k = i
|
146 |
k = i
|
| - |
|
147 |
row -= 1
|
| - |
|
148 |
anotherrow -= 1
|
| 147 |
for subOrder in order['subOrders']:
|
149 |
for subOrder in order['subOrders']:
|
| 148 |
i = k
|
150 |
i = k
|
| 149 |
row += 1
|
151 |
row += 1
|
| 150 |
anotherrow += 1
|
152 |
anotherrow += 1
|
| 151 |
worksheet.write(row, inc(), subOrder['productTitle'])
|
153 |
worksheet.write(row, inc(), subOrder['productTitle'])
|
| Line 158... |
Line 160... |
| 158 |
worksheet1.write(anotherrow, i, subOrder['status'])
|
160 |
worksheet1.write(anotherrow, i, subOrder['status'])
|
| 159 |
worksheet.write(row, inc(), subOrder['cashBackStatus'])
|
161 |
worksheet.write(row, inc(), subOrder['cashBackStatus'])
|
| 160 |
worksheet1.write(anotherrow, i, subOrder['cashBackStatus'])
|
162 |
worksheet1.write(anotherrow, i, subOrder['cashBackStatus'])
|
| 161 |
worksheet.write(row, inc(), subOrder['cashBackAmount'])
|
163 |
worksheet.write(row, inc(), subOrder['cashBackAmount'])
|
| 162 |
worksheet1.write(anotherrow, i, subOrder['cashBackAmount'])
|
164 |
worksheet1.write(anotherrow, i, subOrder['cashBackAmount'])
|
| - |
|
165 |
row += 1
|
| - |
|
166 |
anotherrow += 1
|
| - |
|
167 |
|
| 163 |
else:
|
168 |
else:
|
| 164 |
i=-1
|
169 |
i=-1
|
| 165 |
worksheet1.write(anotherrow, inc(), orderId)
|
170 |
worksheet1.write(anotherrow, inc(), orderId)
|
| 166 |
worksheet1.write(anotherrow, inc(), row1[1])
|
171 |
worksheet1.write(anotherrow, inc(), row1[1])
|
| 167 |
worksheet1.write(anotherrow, inc(), row1[-1])
|
172 |
worksheet1.write(anotherrow, inc(), row1[-1])
|
| Line 177... |
Line 182... |
| 177 |
worksheet1.write(anotherrow, inc(), 'Amoun Paid', boldStyle)
|
182 |
worksheet1.write(anotherrow, inc(), 'Amoun Paid', boldStyle)
|
| 178 |
worksheet1.write(anotherrow, inc(), 'Status', boldStyle)
|
183 |
worksheet1.write(anotherrow, inc(), 'Status', boldStyle)
|
| 179 |
worksheet1.write(anotherrow, inc(), 'Cashback Status', boldStyle)
|
184 |
worksheet1.write(anotherrow, inc(), 'Cashback Status', boldStyle)
|
| 180 |
worksheet1.write(anotherrow, inc(), 'CashBack', boldStyle)
|
185 |
worksheet1.write(anotherrow, inc(), 'CashBack', boldStyle)
|
| 181 |
k = i
|
186 |
k = i
|
| - |
|
187 |
anotherrow -= 1
|
| 182 |
for subOrder in order['subOrders']:
|
188 |
for subOrder in order['subOrders']:
|
| 183 |
anotherrow += 1
|
189 |
anotherrow += 1
|
| 184 |
i = k
|
190 |
i = k
|
| 185 |
worksheet.write(anotherrow, inc(), subOrder['productTitle'])
|
191 |
worksheet.write(anotherrow, inc(), subOrder['productTitle'])
|
| 186 |
worksheet.write(anotherrow, inc(), subOrder['amountPaid'])
|
192 |
worksheet.write(anotherrow, inc(), subOrder['amountPaid'])
|
| 187 |
worksheet.write(anotherrow, inc(), subOrder['quantity'])
|
193 |
worksheet.write(anotherrow, inc(), subOrder['quantity'])
|
| 188 |
worksheet.write(anotherrow, inc(), subOrder['status'])
|
194 |
worksheet.write(anotherrow, inc(), subOrder['status'])
|
| 189 |
worksheet.write(anotherrow, inc(), subOrder['cashBackStatus'])
|
195 |
worksheet.write(anotherrow, inc(), subOrder['cashBackStatus'])
|
| 190 |
worksheet.write(anotherrow, inc(), subOrder['cashBackAmount'])
|
196 |
worksheet.write(anotherrow, inc(), subOrder['cashBackAmount'])
|
| - |
|
197 |
anotherrow += 1
|
| 191 |
|
198 |
|
| 192 |
|
199 |
|
| 193 |
workbook.save(XLS_FILENAME)
|
200 |
workbook.save(XLS_FILENAME)
|
| 194 |
|
201 |
|
| 195 |
def sendmail(email, message, title):
|
202 |
def sendmail(email, message, title):
|