| Line 19... |
Line 19... |
| 19 |
fi
|
19 |
fi
|
| 20 |
done
|
20 |
done
|
| 21 |
|
21 |
|
| 22 |
# Get standard environment variables
|
22 |
# Get standard environment variables
|
| 23 |
PRGDIR=`dirname $(readlink -f "$PRG")`
|
23 |
PRGDIR=`dirname $(readlink -f "$PRG")`
|
| 24 |
PYTHON_DIR="${PRGDIR}/../PyProj/src/shop2020/utils"
|
24 |
PYTHON_DIR="${PRGDIR}/../PyProj/src"
|
| 25 |
DATE=`date +%Y-%b-%d`
|
25 |
DATE=`date +%Y-%b-%d`
|
| 26 |
|
26 |
|
| 27 |
#Email the two report files.
|
27 |
#Email the two report files.
|
| 28 |
|
28 |
|
| 29 |
FROM=$1
|
29 |
FROM=$1
|
| Line 36... |
Line 36... |
| 36 |
do
|
36 |
do
|
| 37 |
TO_LIST="${TO_LIST} -t $1"
|
37 |
TO_LIST="${TO_LIST} -t $1"
|
| 38 |
shift
|
38 |
shift
|
| 39 |
done
|
39 |
done
|
| 40 |
|
40 |
|
| 41 |
HOST="192.168.190.114"
|
- |
|
| 42 |
#HOST="localhost"
|
41 |
cd ${PYTHON_DIR}
|
| - |
|
42 |
./shop2020/model/v1/catalog/script/InventoryStockReportGenerator.py /tmp/pending-orders-inventory.csv
|
| 43 |
|
43 |
|
| 44 |
mysql -uroot -pshop2020 -h ${HOST} catalog -e "select i.brand as 'Brand', (case i.model_name when null then ' ' else i.model_name end) as 'Model Name', i.model_number as 'Model Number', (case i.color when null then ' ' else i.color end) as 'Color', sum(c.availibility) as 'Available', sum(c.reserved) as 'Pending', sum(c.reserved) - sum(c.availibility) as 'Required' from currentinventorysnapshot c, item i where c.item_id = i.id and c.reserved > 0 group by i.id order by i.brand, i.model_name, i.model_number, i.color" > /tmp/pending-orders.csv
|
44 |
${PYTHON_DIR}/shop2020/utils/CsvToXlsConvertor.py -o /tmp/inventory-stock-required.${DATE}.xls /tmp/pending-orders-inventory.csv
|
| 45 |
|
45 |
|
| 46 |
${PYTHON_DIR}/CsvToXlsConvertor.py -o /tmp/inventory-stock-required.${DATE}.xls /tmp/pending-orders.csv
|
46 |
python ${PYTHON_DIR}/shop2020/utils/EmailAttachmentSender.py -f ${FROM} -p ${PASSWD} ${TO_LIST} -s "Inventory Stock required by Spice Online Retail" -a /tmp/inventory-stock-required.${DATE}.xls
|
| 47 |
|
47 |
|
| 48 |
python ${PYTHON_DIR}/EmailAttachmentSender.py -f ${FROM} -p ${PASSWD} ${TO_LIST} -s "Inventory Stock required by Spice Online Retail" -a /tmp/inventory-stock-required.${DATE}.xls
|
- |
|
| 49 |
|
- |
|
| 50 |
rm /tmp/inventory-stock-required.${DATE}.xls
|
48 |
rm /tmp/inventory-stock-required.${DATE}.xls /tmp/pending-orders-inventory.csv
|