Subversion Repositories SmartDukaan

Rev

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

Rev 5137 Rev 5268
Line 5... Line 5...
5 
for i in 1 2 5;
 5 
for i in 1 2 5;
6 
do
 6 
do
7 
	mysql -uroot -pshop2020 -h192.168.190.114 catalog -e "select concat(item.id, ',', item.product_group, ',', item.brand, ',', item.model_number, ',', item.color, ',', s.availibility) as 'Id, Product Group, Brand, Model, Color, Availability' from currentinventorysnapshot as s, item where s.item_id = item.id and item.color is not null and s.warehouse_id = $i" > ${REPORT_DIR}/inventory-report-$today-$i.csv
 7 
	mysql -uroot -pshop2020 -h192.168.190.114 catalog -e "select concat(item.id, ',', item.product_group, ',', item.brand, ',', item.model_number, ',', item.color, ',', s.availibility) as 'Id, Product Group, Brand, Model, Color, Availability' from currentinventorysnapshot as s, item where s.item_id = item.id and item.color is not null and s.warehouse_id = $i" > ${REPORT_DIR}/inventory-report-$today-$i.csv
8 
done
 8 
done
9 
mysql -uroot -pshop2020 -h192.168.190.114 catalog --batch -e "select item_key, item_id from vendoritemmapping v join item i on (item_id = i.id) where i.product_group = 'Handsets'" > ${REPORT_DIR}/vendor-mapping-1.csv
 9 
mysql -uroot -pshop2020 -h192.168.190.114 catalog --batch -e "select item_key, item_id from vendoritemmapping v join item i on (item_id = i.id) where i.product_group = 'Handsets'" > ${REPORT_DIR}/vendor-mapping-1.csv
10 
mysql -uroot -pshop2020 -h192.168.190.114 catalog --batch -e "select item_key, item_id from vendoritemmapping v join item i on (item_id = i.id) where i.product_group != 'Handsets'" > ${REPORT_DIR}/vendor-mapping-2.csv
 10 
mysql -uroot -pshop2020 -h192.168.190.114 catalog --batch -e "select item_key, item_id from vendoritemmapping v join item i on (item_id = i.id)" > ${REPORT_DIR}/vendor-mapping-2.csv
11 
 
 - 
 
12 

            11