LOGS (72)
------------
[22-08-17 09:32:47]: Will start again after 3321443 ms
[22-08-17 09:32:47]: Updated adjustments: {
'20220802': 20220802,
'20220809': 20220809,
'20220811': 20220811,
'20220813': 20220813,
'20220814': 20220814,
'20220815': 20220815,
'20220816': 20220816
}
[22-08-17 09:32:47]: Updated sales: {
'20220802': 20220802,
'20220809': 20220809,
'20220811': 20220811,
'20220813': 20220813,
'20220814': 20220814,
'20220815': 20220815,
'20220816': 20220816
}
[22-08-17 09:32:47]: Updated orders: {
'20220802': 20220802,
'20220809': 20220809,
'20220811': 20220811,
'20220813': 20220813,
'20220814': 20220814,
'20220815': 20220815,
'20220816': 20220816
}
[22-08-17 09:32:46]: SELECT DISTINCT
[고객] AS customer_name
,[거래처분류] AS etype
,[마감일자] AS deadline
,[거래구분] AS transaction_class
,[환종] AS foreign_currency
,[품번] AS sku
,[품명] AS product_name
,[수량] AS quantity
,[외화단가] AS unitprice_foreign_currency
,[외화금액] AS foreign_currency_amount
,[단가] AS unit_price
,[원화금액] AS won_Amount
,[프로젝트] AS project
,[제품그룹] AS product_group
,[대분류] AS main_category
,[중분류] AS middle_classification
,[소분류] AS subcategory
FROM [DZICUBE].[dbo].[VIEW_LSALECLS] as Sales
WHERE ([거래처분류] = 'DISTY' OR [거래처분류] = 'OEM' OR [거래처분류] = 'ODM')
AND ([마감일자] >= 20220808 AND [마감일자] <= 20220817 )
ORDER BY [마감일자] DESC
OFFSET 0 ROWS
FETCH NEXT 1000 ROWS ONLY
[22-08-17 09:32:46]: ERP :: sale :: Transaction 0 :: offset = 0 and limit = 1000
[22-08-17 09:32:46]: ERP :: sale :: Start date after conversion ... 20220808
[22-08-17 09:32:46]: SELECT DISTINCT
[고객] AS customer_name
,[거래처분류] AS etype
,[출고일자] AS deadline
,[거래구분] AS transaction_class
,[환종] AS foreign_currency
,[품번] AS sku
,[품명] AS product_name
,[수량] AS quantity
,[외화단가] AS unitprice_foreign_currency
,[외화금액] AS foreign_currency_amount
,[단가] AS unit_price
,[원화금액] AS won_Amount
,[프로젝트] AS project
,[제품그룹] AS product_group
,[대분류] AS main_category
,[중분류] AS middle_classification
,[소분류] AS subcategory
FROM [DZICUBE].[dbo].[VIEW_LDELIVER] AS DLVRY
WHERE ([거래처분류] = 'DISTY' OR [거래처분류] = 'OEM' OR [거래처분류] = 'ODM')
AND ([출고일자] >= 20220808 AND [출고일자] <= 20220817 )
ORDER BY [출고일자] DESC
OFFSET 0 ROWS
FETCH NEXT 1000 ROWS ONLY
[22-08-17 09:32:46]: ERP :: order :: Transaction 0 :: offset = 0 and limit = 1000
[22-08-17 09:32:46]: ERP :: order :: Start date after conversion ... 20220808
[22-08-17 09:32:46]: Fetching from ERP System
[22-08-17 09:32:45]: MSSQL Connection ERROR ::
[22-08-17 09:32:44]: lastSeqNumber :: 1659917966186
[22-08-17 09:32:44]: fetchSalesFromERPSystem :: initiated ::
[22-08-17 09:32:44]: mConfig.lastFetchTime :: 0
[22-08-17 09:32:43]: connecting to shopify ::
[22-08-17 09:32:43]: Done for Wed Aug 17 2022 03:52:44 GMT+0000
[22-08-17 09:32:42]: 0
[22-08-17 09:32:24]: Sales for: amazon_na 2022-08-17T03:52:44.442Z 2022-08-17T04:00:51.245Z
[22-08-17 09:32:24]: Done for Wed Aug 17 2022 03:52:42 GMT+0000
[22-08-17 09:32:23]: 0
[22-08-17 09:32:26]: Sales for: amazon_au 2022-08-17T03:52:42.314Z 2022-08-17T04:00:49.261Z
[22-08-17 09:32:25]: Done for Wed Aug 17 2022 03:52:40 GMT+0000
[22-08-17 09:32:24]: 0
[22-08-17 09:32:14]: Sales for: amazon_sg 2022-08-17T03:52:40.210Z 2022-08-17T04:00:47.146Z
[22-08-17 09:32:14]: Done for Wed Aug 17 2022 03:52:38 GMT+0000
[22-08-17 09:32:13]: 0
[22-08-17 09:32:16]: Sales for: amazon_jp 2022-08-17T03:52:38.096Z 2022-08-17T04:00:45.163Z
[22-08-17 09:32:16]: ERROR: Error: Invalid Input
[22-08-17 09:32:88]: Sales for: amazon_in 2022-07-08T05:40:42.392Z 2022-07-15T05:40:42.392Z
[22-08-17 09:32:88]: Done for Wed Aug 17 2022 03:52:29 GMT+0000
[22-08-17 09:32:87]: 0
[22-08-17 09:32:22]: Sales for: amazon_eu 2022-08-17T03:52:29.323Z 2022-08-17T04:00:37.221Z
[22-08-17 09:32:20]: Done fetch from EZAdmin
[22-08-17 09:32:16]: Last sequence number from DB: 353166, from EZ: 345163
[22-08-17 09:32:16]: Orders received: 7748/7748
[22-08-17 09:32:92]: action=get_order_info&date_type=order_date&limit=1000&page=8&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:83]: action=get_order_info&date_type=order_date&limit=1000&page=7&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:45]: action=get_order_info&date_type=order_date&limit=1000&page=6&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:32:37]: action=get_order_info&date_type=order_date&limit=1000&page=5&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:52]: action=get_order_info&date_type=order_date&limit=1000&page=4&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:60]: action=get_order_info&date_type=order_date&limit=1000&page=3&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:17]: action=get_order_info&date_type=order_date&limit=1000&page=2&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:62]: action=get_order_info&date_type=order_date&limit=1000&page=1&start_date=2022-07-30&end_date=2022-08-17
[22-08-17 09:31:62]: Fetching from ezadmin
[22-08-17 09:31:62]: Done for: amazon_na 2022-08-17T03:52:59.820Z 2022-08-17T04:01:07.885Z
[22-08-17 09:31:50]: 14
[22-08-17 09:31:26]: { reportId: '269760019221' }
[22-08-17 09:31:88]: Fetching: amazon_na 2022-08-17T03:52:59.820Z 2022-08-17T04:01:07.885Z
[22-08-17 09:31:88]: Done for: amazon_au 2022-08-17T03:52:25.773Z 2022-08-17T04:00:34.097Z
[22-08-17 09:31:87]: 0
[22-08-17 09:30:17]: { reportId: '60369019221' }
[22-08-17 09:30:09]: Fetching: amazon_au 2022-08-17T03:52:25.773Z 2022-08-17T04:00:34.097Z
[22-08-17 09:30:09]: Done for: amazon_sg 2022-08-17T03:51:51.797Z 2022-08-17T04:00:00.159Z
[22-08-17 09:30:08]: 0
[22-08-17 09:30:42]: { reportId: '60703019221' }
[22-08-17 09:30:15]: Fetching: amazon_sg 2022-08-17T03:51:51.797Z 2022-08-17T04:00:00.159Z
[22-08-17 09:30:15]: Done for: amazon_jp 2022-08-17T03:51:17.757Z 2022-08-17T03:59:26.091Z
[22-08-17 09:30:14]: 0
[22-08-17 09:29:42]: { reportId: '138406019221' }
[22-08-17 09:29:09]: Fetching: amazon_jp 2022-08-17T03:51:17.757Z 2022-08-17T03:59:26.091Z
[22-08-17 09:29:08]: Done for: amazon_in 2022-08-17T03:50:42.474Z 2022-08-17T03:58:50.695Z
[22-08-17 09:29:07]: 0
[22-08-17 09:28:17]: { reportId: '104093019221' }
[22-08-17 09:28:69]: Fetching: amazon_in 2022-08-17T03:50:42.474Z 2022-08-17T03:58:50.695Z
[22-08-17 09:28:69]: Done for: amazon_eu 2022-08-17T03:50:06.482Z 2022-08-17T03:58:14.945Z
[22-08-17 09:28:64]: 2
[22-08-17 09:28:73]: { reportId: '290757019221' }
[22-08-17 09:28:94]: Fetching: amazon_eu 2022-08-17T03:50:06.482Z 2022-08-17T03:58:14.945Z
[22-08-17 09:28:93]: Exchange rates {
USD: 1302.380384,
EUR: 1336.70016,
JPY: 9.760301,
INR: 16.355319,
SGD: 949.900448,
AUD: 928.163162,
CAD: 1019.355811,
MXN: 65.683038,
BRL: 256.555691,
CNY: 193.148287,
GBP: 1581.3177,
CHF: 1383.171473,
SEK: 127.622537,
NZD: 840.627919
}
[22-08-17 09:28:91]: Starting service at Wed Aug 17 2022 03:58:13 GMT+0000
[22-08-17 09:28:91]: USING PORT: 8080