| Line 131... |
Line 131... |
| 131 |
default_format = xlwt.XFStyle()
|
131 |
default_format = xlwt.XFStyle()
|
| 132 |
|
132 |
|
| 133 |
shipped_headers=['Counter', 'Product', 'Quantity', 'Value']
|
133 |
shipped_headers=['Counter', 'Product', 'Quantity', 'Value']
|
| 134 |
tertiary_headers=shipped_headers
|
134 |
tertiary_headers=shipped_headers
|
| 135 |
pending_headers=shipped_headers
|
135 |
pending_headers=shipped_headers
|
| 136 |
ageing_headers=['Counter','Product','QtyDelivered','QtySold','QtyInStock','ValueInStock', 'QtyPending', 'ValuePending', 'QtyShipped','ValueShipped']
|
136 |
ageing_headers=['Counter','Product','Qty Delivered','Qty Sold','Qty In Stock','Value In Stock', 'Qty Pending', 'Value Pending', 'Qty Shipped','Value Shipped']
|
| 137 |
mis_headers=['Counter','Last Day Qty', 'Last Day Value','MTD Qty', 'MTD Value']
|
137 |
mis_headers=['Counter','Last Day Qty', 'Last Day Value','MTD Qty', 'MTD Value']
|
| 138 |
mis_headers_prod=['Product','Last Day Qty', 'Last Day Value','MTD Qty', 'MTD Value']
|
138 |
mis_headers_prod=['Product','Last Day Qty', 'Last Day Value','MTD Qty', 'MTD Value']
|
| 139 |
|
139 |
|
| 140 |
report_map['shipped'] = {'title':'Shipped Orders Report', 'query' : SHIPPED_ORDER_GROUP_SQL, 'group':2, 'headers':shipped_headers}
|
140 |
report_map['shipped'] = {'title':'Shipped Orders Report', 'query' : SHIPPED_ORDER_GROUP_SQL, 'group':2, 'headers':shipped_headers}
|
| 141 |
report_map['tertiary'] = {'title':'Tertiary Report', 'query' : SOLD_OUT_GROUP_SQL, 'group':2, 'headers':tertiary_headers}
|
141 |
report_map['tertiary'] = {'title':'Tertiary Report', 'query' : SOLD_OUT_GROUP_SQL, 'group':2, 'headers':tertiary_headers}
|