| 25 |
mysql -uroot -pshop2020 -h 192.168.190.114 inventory -e "update currentinventorysnapshot c, warehouse w set availability = 0 where w.id = c.warehouse_id and isAvailabilityMonitored = 0 and vendor_id = 1 and availability < 0"
|
25 |
mysql -uroot -pshop2020 -h 192.168.190.114 inventory -e "update currentinventorysnapshot c, warehouse w set availability = 0 where w.id = c.warehouse_id and isAvailabilityMonitored = 0 and vendor_id = 1 and availability < 0"
|
| 27 |
mysql -uroot -pshop2020 -h 192.168.190.114 inventory -e "select w.displayName, c.item_id, c.availability, c.reserved from currentinventorysnapshot c, warehouse w where w.id = c.warehouse_id and isAvailabilityMonitored = 0 and vendor_id = 1 and availability > 0" > /tmp/NegativeInventory.${DATE}.tsv
|
27 |
mysql -uroot -pshop2020 -h 192.168.190.114 inventory -e "select w.displayName, c.item_id, c.availability, c.reserved from currentinventorysnapshot c, warehouse w where w.id = c.warehouse_id and isAvailabilityMonitored = 0 and vendor_id = 1 and availability > 0" > /tmp/NegativeInventory.${DATE}.tsv
|
| 29 |
python ${PYTHON_DIR}/shop2020/utils/EmailAttachmentSender.py -f ${FROM} -p ${PASSWD} -t sandeep.sachdeva@shop2020.in -t khushal.bhatia@shop2020.in -t rajveer.singh@shop2020.in -s "Additional Inventory in Hotspot warehouses" -a /tmp/NegativeInventory.${DATE}.tsv
|
29 |
python ${PYTHON_DIR}/shop2020/utils/EmailAttachmentSender.py -f ${FROM} -p ${PASSWD} -t sandeep.sachdeva@shop2020.in -t khushal.bhatia@shop2020.in -t anikendra.das@shop2020.in amit.gupta@shop2020.in -s "Additional Inventory in Hotspot warehouses" -a /tmp/NegativeInventory.${DATE}.tsv
|