| Line 763... |
Line 763... |
| 763 |
sh1.write(row, inc(), 'Catalog Id', boldStyle)
|
763 |
sh1.write(row, inc(), 'Catalog Id', boldStyle)
|
| 764 |
sh1.write(row, inc(), 'Brand', boldStyle)
|
764 |
sh1.write(row, inc(), 'Brand', boldStyle)
|
| 765 |
sh1.write(row, inc(), 'Model', boldStyle)
|
765 |
sh1.write(row, inc(), 'Model', boldStyle)
|
| 766 |
sh1.write(row, inc(), 'Category', boldStyle)
|
766 |
sh1.write(row, inc(), 'Category', boldStyle)
|
| 767 |
sh1.write(row, inc(), 'Deal Rank', boldStyle)
|
767 |
sh1.write(row, inc(), 'Deal Rank', boldStyle)
|
| - |
|
768 |
sh1.write(row, inc(), 'Max Nlc', boldStyle)
|
| - |
|
769 |
sh1.write(row, inc(), 'Min Nlc', boldStyle)
|
| - |
|
770 |
sh1.write(row, inc(), 'DP', boldStyle)
|
| - |
|
771 |
sh1.write(row, inc(), 'Item status', boldStyle)
|
| 768 |
sh1.write(row, inc(), 'City', boldStyle)
|
772 |
sh1.write(row, inc(), 'City', boldStyle)
|
| 769 |
sh1.write(row, inc(), 'State', boldStyle)
|
773 |
sh1.write(row, inc(), 'State', boldStyle)
|
| 770 |
sh1.write(row, inc(), 'Pincode', boldStyle)
|
774 |
sh1.write(row, inc(), 'Pincode', boldStyle)
|
| 771 |
i =-1
|
775 |
i =-1
|
| 772 |
sh2.write(row, inc(), 'User Id', boldStyle)
|
776 |
sh2.write(row, inc(), 'User Id', boldStyle)
|
| Line 816... |
Line 820... |
| 816 |
sh1.write(row3, inc(), skuData.get("skuBundleId"))
|
820 |
sh1.write(row3, inc(), skuData.get("skuBundleId"))
|
| 817 |
sh1.write(row3, inc(), skuData.get("brand"))
|
821 |
sh1.write(row3, inc(), skuData.get("brand"))
|
| 818 |
sh1.write(row3, inc(), skuData.get("model_name"))
|
822 |
sh1.write(row3, inc(), skuData.get("model_name"))
|
| 819 |
sh1.write(row3, inc(), skuData.get("category"))
|
823 |
sh1.write(row3, inc(), skuData.get("category"))
|
| 820 |
sh1.write(row3, inc(), subOrder.get("dealRank"))
|
824 |
sh1.write(row3, inc(), subOrder.get("dealRank"))
|
| - |
|
825 |
sh1.write(row3, inc(), subOrder.get("maxNlc"))
|
| - |
|
826 |
sh1.write(row3, inc(), subOrder.get("minNlc"))
|
| - |
|
827 |
sh1.write(row3, inc(), subOrder.get("dp"))
|
| - |
|
828 |
sh1.write(row3, inc(), subOrder.get("itemStatus"))
|
| 821 |
else:
|
829 |
else:
|
| 822 |
sh1.write(row3, inc(), None)
|
830 |
sh1.write(row3, inc(), None)
|
| 823 |
sh1.write(row3, inc(), None)
|
831 |
sh1.write(row3, inc(), None)
|
| 824 |
sh1.write(row3, inc(), None)
|
832 |
sh1.write(row3, inc(), None)
|
| 825 |
sh1.write(row3, inc(), None)
|
833 |
sh1.write(row3, inc(), None)
|
| 826 |
sh1.write(row3, inc(), None)
|
834 |
sh1.write(row3, inc(), None)
|
| - |
|
835 |
sh1.write(row3, inc(), None)
|
| - |
|
836 |
sh1.write(row3, inc(), None)
|
| - |
|
837 |
sh1.write(row3, inc(), None)
|
| - |
|
838 |
sh1.write(row3, inc(), None)
|
| 827 |
sh1.write(row3, inc(), result[10])
|
839 |
sh1.write(row3, inc(), result[10])
|
| 828 |
sh1.write(row3, inc(), result[11])
|
840 |
sh1.write(row3, inc(), result[11])
|
| 829 |
sh1.write(row3, inc(), result[12])
|
841 |
sh1.write(row3, inc(), result[12])
|
| 830 |
|
842 |
|
| 831 |
#removed filter as requested by Rajneesh
|
843 |
#removed filter as requested by Rajneesh
|