Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:8080/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production 2025-06-10T07:34:47.111Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:34:47.184Z - GET /favicon.ico 2025-06-10T07:34:49.087Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:36:27.548Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:37:03.311Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:38:23.580Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:39:40.563Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:40:01.305Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:40:05.946Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDehs 2025-06-10T07:40:10.588Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDehss 2025-06-10T07:40:12.962Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:09.799Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:10.597Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:17.875Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:18.539Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:18.684Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:26.550Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:26.904Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:27.721Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:41:35.632Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:42:37.231Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:44:28.111Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:45:36.285Z - GET /CMMS_Vermicelli_api/health 2025-06-10T07:47:04.311Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:47:49.792Z - GET /CMMS_Vermicelli_api/api/ 2025-06-10T07:47:53.582Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:47:55.673Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:48:50.256Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:49:49.327Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:49:57.827Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:50:44.751Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:52:14.705Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:53:50.142Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:55:11.690Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:55:52.595Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:00.668Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:02.915Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:09.703Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:10.904Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:14.223Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:49.617Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:56:57.659Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:57:02.945Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:57:06.710Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:57:10.955Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:57:16.852Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T07:58:36.765Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:59:24.543Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:59:34.828Z - GET /CMMS_Vermicelli_api/api 2025-06-10T07:59:34.914Z - GET /favicon.ico 2025-06-10T08:04:16.549Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:20:16.106Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T08:20:23.442Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:21:19.858Z - GET /CMMS_Vermicelli_api/health 2025-06-10T08:21:25.300Z - GET /CMMS_Vermicelli_api/api/users 2025-06-10T08:21:31.464Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T08:21:43.721Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T08:21:57.164Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:22:34.772Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:27:27.415Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:33:00.479Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:33:14.116Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T08:38:12.391Z - GET /CMMS_Vermicelli_api/api 2025-06-10T08:38:15.788Z - GET /CMMS_Vermicelli_api/health 2025-06-10T09:03:10.450Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T09:09:23.317Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T09:09:31.383Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T09:10:35.433Z - GET /CMMS_Vermicelli_api/api 2025-06-10T09:10:44.370Z - GET /CMMS_Vermicelli_api/ 2025-06-10T09:10:53.418Z - GET /CMMS_Vermicelli_api/api 2025-06-10T09:11:09.156Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T09:11:40.443Z - GET /CMMS_Vermicelli_api/ 2025-06-10T09:11:50.209Z - GET /CMMS_Vermicelli_api/api 2025-06-10T09:12:02.717Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T10:46:05.169Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T10:46:09.894Z - GET /CMMS_Vermicelli_api/api 2025-06-10T10:46:39.179Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T10:46:48.317Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T10:47:11.428Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDehh 2025-06-10T10:47:14.850Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T10:48:34.496Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T11:00:47.718Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T11:01:11.439Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T11:01:44.759Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T11:01:56.964Z - GET /CMMS_Vermicelli_api/api 2025-06-10T11:02:04.649Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T11:02:07.307Z - GET /CMMS_Vermicelli_api/api 2025-06-10T11:03:24.197Z - GET /CMMS_Vermicelli_api/api 2025-06-10T11:03:39.092Z - GET /CMMS_Vermicelli_api/api 2025-06-10T11:03:45.791Z - GET /CMMS_Vermicelli_api/api 2025-06-10T11:04:20.366Z - GET /CMMS_Vermicelli_api/api 2025-06-10T17:31:40.433Z - GET /CMMS_Vermicelli_api/api 2025-06-10T17:31:49.284Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T17:32:14.255Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T17:35:18.258Z - GET /CMMS_Vermicelli_api/api 2025-06-10T17:35:22.495Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-10T17:37:47.053Z - GET /CMMS_Vermicelli_api/productionLineMixAndDeh 2025-06-10T17:37:59.920Z - GET /CMMS_Vermicelli_api/api 2025-06-10T17:38:08.198Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T17:38:11.594Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T17:40:18.894Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production 2025-06-10T17:56:24.980Z - GET /CMMS_Vermicelli_api/api 2025-06-10T17:57:47.314Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T17:58:13.643Z - GET /CMMS_Vermicelli_api/api/auth 2025-06-10T17:58:15.953Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T17:58:37.753Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:03:53.689Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:03:59.253Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:05:42.281Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:05:50.954Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:06:40.459Z - GET /CMMS_Vermicelli_api/ 2025-06-10T18:09:19.400Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:09:24.331Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:09:45.078Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:09:57.717Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:10:40.352Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:13:13.425Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-10T18:15:29.264Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-10T18:15:44.093Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:12:05.429Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:14:46.271Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:15:49.566Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:16:11.095Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T01:20:41.264Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:21:06.323Z - GET /CMMS_Vermicelli_api/api/productionlineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:21:29.524Z - GET /CMMS_Vermicelli_api/api/productionlineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:33:31.487Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T01:34:37.378Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T02:59:40.107Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T02:59:48.825Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:02:41.586Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:02.119Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:03:07.812Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:08.616Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:09.159Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:09.608Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:10.520Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:03:11.114Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:16:05.998Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:18:26.394Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:34.848Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:35.589Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:45.403Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:46.050Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:46.483Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:19:46.962Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:20:04.387Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:23:49.715Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:23:54.065Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:26:34.328Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:28:36.139Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:28:44.066Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:28:48.981Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:30:01.395Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:34:48.622Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:34:49.936Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:34:51.237Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:35:40.264Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:35:42.489Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:40:29.079Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:41:02.362Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:44:16.072Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:44:22.689Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:44:50.367Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:44:51.670Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:44:52.540Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:44:55.249Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:44:57.509Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T03:45:08.551Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:46:26.902Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:46:27.718Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T03:47:09.727Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production 2025-06-11T03:50:48.209Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail 2025-06-11T03:50:56.010Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T03:53:15.986Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T03:53:17.607Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T03:53:52.755Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T03:53:56.306Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail 2025-06-11T03:57:23.608Z - GET /CMMS_Vermicelli_api/api 2025-06-11T03:57:23.679Z - GET /favicon.ico 2025-06-11T03:57:35.866Z - GET /CMMS_Vermicelli_api/api 2025-06-11T03:57:53.378Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T04:15:00.603Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh 2025-06-11T04:15:12.766Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa Executing (default): SELECT 1+1 AS result SQL Server Connected successfully ✅ Database schema synchronized 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production 2025-06-11T04:19:35.903Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T04:19:39.936Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T04:19:45.999Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T04:34:49.907Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T05:18:50.820Z - GET /CMMS_Vermicelli_api/api 2025-06-11T05:20:15.421Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:20:15.423Z - GET /CMMS_Vermicelli_api/api/auth/me 2025-06-11T05:20:15.431Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:25:16.885Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; 2025-06-11T05:26:37.491Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:26:37.492Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:26:37.752Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:26:37.753Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:26:37.758Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:26:37.765Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:26:38.175Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:26:38.177Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:26:52.598Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:26:52.628Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:26:53.488Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:26:53.490Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:27:12.388Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:27:17.205Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:27:17.211Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:27:38.840Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:27:41.700Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:27:41.707Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:27:57.142Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:28:00.046Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:28:00.050Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:29:11.116Z - POST /CMMS_Vermicelli_api/api/auth/register 2025-06-11T05:29:35.623Z - POST /CMMS_Vermicelli_api/api/auth/register 2025-06-11T05:29:57.725Z - POST /CMMS_Vermicelli_api/api/auth/register Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE ([User].[email] = N'test123@gmail.com' OR [User].[username] = N'test123') ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): INSERT INTO [Users] ([username],[email],[password],[firstName],[lastName],[role],[isActive],[createdAt],[updatedAt]) OUTPUT INSERTED.[id],INSERTED.[username],INSERTED.[email],INSERTED.[password],INSERTED.[firstName],INSERTED.[lastName],INSERTED.[role],INSERTED.[isActive],INSERTED.[lastLogin],INSERTED.[refreshTokens],INSERTED.[createdAt],INSERTED.[updatedAt] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8); Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[updatedAt]=@1 WHERE [id] = @2 2025-06-11T05:30:09.146Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T05:30:09.548Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:09.559Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:30:09.560Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:09.561Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:10.668Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:30:10.669Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:30:10.669Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:30:10.800Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:10.800Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:30:10.801Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:10.811Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:30:16.468Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T05:30:16.472Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T05:30:37.565Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa Executing (default): SELECT 1+1 AS result SQL Server Connected successfully ✅ Database schema synchronized 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa Executing (default): SELECT 1+1 AS result SQL Server Connected successfully ✅ Database schema synchronized 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3005/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3005/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production 2025-06-11T05:37:22.632Z - GET /CMMS_Vermicelli_api/api/auth/me 2025-06-11T05:37:22.639Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:37:22.641Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:37:22.877Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:37:22.878Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:37:22.879Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:37:22.879Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T05:37:22.884Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T05:37:22.889Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:37:27.921Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [] 2025-06-11T05:37:27.959Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/start-cycle/2025-07-12 Starting cycle for date: 2025-07-12 Executing (default): SELECT [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12'; Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Created master records: [ { RowID: 1, line: 'A', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 2, line: 'B', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 3, line: 'C', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 4, line: 'D', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 5, line: 'E', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 6, line: 'F', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 7, line: 'G', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 8, line: 'H', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 9, line: 'I', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 10, line: 'J', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' } ] 2025-06-11T05:38:12.062Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:38:16.557Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:38:16.561Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:38:53.067Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T05:38:53.443Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:38:53.445Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:38:53.446Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:38:53.450Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:39:00.374Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T05:39:00.376Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T05:40:53.632Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:40:53.642Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:40:53.643Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:41:14.327Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T05:42:48.971Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T05:45:38.931Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:45:38.931Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:45:38.932Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:45:55.741Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:47:19.966Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T05:47:21.834Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:21.841Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:47:21.842Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:21.843Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:22.678Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T05:47:22.683Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:47:22.684Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:47:22.762Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T05:47:22.763Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:22.764Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:22.768Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T05:47:25.751Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T05:47:25.755Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T05:47:53.033Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:51:37.789Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:51:53.450Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:51:53.451Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:52:00.308Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T05:54:58.578Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:54:58.578Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:57:21.981Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T05:57:21.983Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T05:57:25.494Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T06:01:01.982Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:01:01.982Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:01:02.045Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:01:02.045Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:01:07.466Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T06:01:13.576Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:01:13.577Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:02:53.518Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:02:53.518Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:04:15.342Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:04:15.343Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:04:19.448Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T06:04:31.456Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@example.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; 2025-06-11T06:04:53.961Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T06:04:54.384Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:04:54.384Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T06:04:54.387Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:04:54.391Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:11:35.895Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:11:35.895Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:11:53.775Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T06:11:55.877Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:11:55.879Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:11:55.879Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:11:55.948Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:11:55.948Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:11:55.949Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:11:55.951Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:12:03.029Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:12:03.031Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:12:06.939Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:12:14.606Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-11 Fetching detail data for date: 2025-07-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:12:14.607Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-11 Fetching master data for date: 2025-07-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:12:18.913Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:12:18.915Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:25:54.965Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:25:56.883Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:26:30.210Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:26:30.210Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:26:30.211Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:26:30.392Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:26:30.392Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:26:30.393Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:26:30.418Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:26:30.418Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:26:30.419Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:26:52.983Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-11 Fetching master data for date: 2025-07-11 2025-06-11T06:26:52.986Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-11 Fetching detail data for date: 2025-07-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:26:53.805Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:27:08.891Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 2025-06-11T06:27:08.895Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:27:15.339Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 1, status: 'running', start_batch_date: '2025-06-11T14:27:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:31:21.081Z - GET /CMMS_Vermicelli_api/api/auth/me 2025-06-11T06:31:21.085Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:31:21.086Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:31:21.361Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:31:21.363Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:31:21.363Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:31:21.446Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:31:21.451Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:31:21.452Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:31:30.203Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [] 2025-06-11T06:31:30.260Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/start-cycle/2025-07-12 Starting cycle for date: 2025-07-12 Executing (default): SELECT [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12'; Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Executing (default): INSERT INTO [mix_deh_mst] ([cycleDate],[line],[status],[cycle_status],[cycle_end_date],[startDate],[endDate]) OUTPUT INSERTED.[RowID],INSERTED.[cycleDate],INSERTED.[line],INSERTED.[status],INSERTED.[cycle_status],INSERTED.[cycle_end_date],INSERTED.[startDate],INSERTED.[endDate] VALUES (@0,@1,@2,@3,@4,@5,@6); Created master records: [ { RowID: 11, line: 'A', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 12, line: 'B', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 13, line: 'C', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 14, line: 'D', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 15, line: 'E', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 16, line: 'F', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 17, line: 'G', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 18, line: 'H', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 19, line: 'I', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' }, { RowID: 20, line: 'J', cycleDate: '2025-07-12', status: 'active', cycle_status: 'active' } ] 2025-06-11T06:31:38.731Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:31:38.755Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:31:38.766Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:31:38.955Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:31:38.956Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:31:38.958Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:31:39.005Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:31:39.006Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:31:39.007Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:31:46.314Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 11, status: 'running', start_batch_date: '2025-06-11T14:31:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:31:55.579Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 15, status: 'running', start_batch_date: '2025-06-11T14:31:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:37:40.267Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T06:37:53.719Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:37:53.721Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:37:53.723Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:37:53.904Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:37:53.907Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:37:53.908Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:37:53.909Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:37:53.910Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:37:53.915Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:37:54.154Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=CPI&empl_id=sekhar_log 2025-06-11T06:37:54.156Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=CPI 2025-06-11T06:37:54.159Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:37:54.270Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:37:54.270Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:37:54.271Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:37:54.297Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=331 2025-06-11T06:37:54.298Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=CPI&emp_mst_empl_id=SEKHAR_EMP 2025-06-11T06:37:54.298Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=CPI&emp_mst_empl_id=sekhar_log 2025-06-11T06:38:42.596Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] ORDER BY [AssetDetailMixAndDeh].[RowID] ASC; 2025-06-11T06:39:56.807Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:39:56.842Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:40:36.658Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T06:40:38.963Z - GET /CMMS_Vermicelli_api/api/get_cf_user_access_data.php?site_cd=null&empl_id=null 2025-06-11T06:40:38.987Z - GET /CMMS_Vermicelli_api/api/get_default_popup_close_data.php?site_cd=null 2025-06-11T06:40:38.994Z - GET /CMMS_Vermicelli_api/api/auth/me Executing (default): SELECT [id], [username], [email], [firstName], [lastName], [role], [isActive], [lastLogin], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[id] = 1; 2025-06-11T06:40:39.082Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:40:39.084Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T06:40:39.086Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:41:01.257Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:41:01.282Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:41:09.202Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:41:09.235Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:41:25.032Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-05 Fetching master data for date: 2025-06-05 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-05' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:41:25.052Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-05 Fetching detail data for date: 2025-06-05 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-05' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:41:34.210Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-10 Fetching master data for date: 2025-06-10 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-10' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:41:34.367Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-10 Fetching detail data for date: 2025-06-10 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-10' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:41:37.197Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:41:37.200Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:41:49.494Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:41:56.264Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:42:03.625Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:42:07.364Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-12 Fetching master data for date: 2025-06-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:07.392Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-12 Fetching detail data for date: 2025-06-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:16.234Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-05-09 Fetching master data for date: 2025-05-09 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-05-09' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:16.255Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-05-09 Fetching detail data for date: 2025-05-09 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-05-09' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:19.424Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-05-10 Fetching detail data for date: 2025-05-10 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-05-10' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:19.426Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-05-10 Fetching master data for date: 2025-05-10 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-05-10' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:21.527Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:21.531Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:23.394Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-12 Fetching master data for date: 2025-06-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:23.399Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-12 Fetching detail data for date: 2025-06-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:25.823Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-13 Fetching master data for date: 2025-06-13 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-13' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:25.827Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-13 Fetching detail data for date: 2025-06-13 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-13' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:27.099Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-12 Fetching master data for date: 2025-06-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:27.103Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-12 Fetching detail data for date: 2025-06-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:27.944Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-11 Fetching master data for date: 2025-06-11 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:27.949Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-11 Fetching detail data for date: 2025-06-11 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-11' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:29.666Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:42:33.407Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-06-12 Fetching master data for date: 2025-06-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:33.412Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-06-12 Fetching detail data for date: 2025-06-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-06-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; 2025-06-11T06:42:36.090Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/check-active-cycles Executing (default): SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC; Found active cycles: [ { cycleDate: '2025-07-12', status: 'active', cycle_status: 'active', cycle_end_date: null } ] 2025-06-11T06:42:48.804Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:42:48.831Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:43:23.728Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 12, status: 'running', start_batch_date: '2025-06-11T14:43:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:44:00.034Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 19, status: 'running', start_batch_date: '2025-06-11T14:43:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 2, rec_corn_bag_qty: 2, rec_corn_sco_qty: 5, rec_tapioca_bag_qty: 1, rec_tapioca_sco_qty: 3, rec_wheat_sco_qty: 1, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:44:21.359Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 14, status: 'running', start_batch_date: '2025-06-11T14:44:00', batch_no: 1, product: 'vermi', method: 'dehydrationmixing', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:45:21.863Z - POST /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail Creating batch record: { mst_RowID: 13, status: 'running', start_batch_date: '2025-06-11T14:45:00', batch_no: 1, product: 'sbl', method: 'dehydration', rec_sago_sco_qty: 0, rec_corn_bag_qty: 0, rec_corn_sco_qty: 0, rec_tapioca_bag_qty: 0, rec_tapioca_sco_qty: 0, rec_wheat_sco_qty: 0, rec_recycle_pail_qty: 0, dryness_status: null, mixed_status: null, rice: null, remarks: null } Executing (default): INSERT INTO [mix_deh_dtl] ([mst_RowID],[start_batch_date],[batch_no],[product],[method],[status],[rec_sago_sco_qty],[rec_corn_bag_qty],[rec_corn_sco_qty],[rec_tapioca_bag_qty],[rec_tapioca_sco_qty],[rec_wheat_sco_qty],[rec_recycle_pail_qty],[dryness_status],[mixed_status],[rice],[remarks]) OUTPUT INSERTED.[RowID],INSERTED.[mst_RowID],INSERTED.[start_batch_date],INSERTED.[end_batch_date],INSERTED.[batch_no],INSERTED.[product],INSERTED.[method],INSERTED.[status],INSERTED.[rec_sago_sco_qty],INSERTED.[rec_corn_bag_qty],INSERTED.[rec_corn_sco_qty],INSERTED.[rec_tapioca_bag_qty],INSERTED.[rec_tapioca_sco_qty],INSERTED.[rec_wheat_sco_qty],INSERTED.[rec_recycle_pail_qty],INSERTED.[dryness_status],INSERTED.[mixed_status],INSERTED.[time_change_rice_cloth],INSERTED.[rice],INSERTED.[remarks] VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16); 2025-06-11T06:47:17.269Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; 2025-06-11T06:47:17.300Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; 2025-06-11T06:49:25.126Z - POST /CMMS_Vermicelli_api/api/auth/login Executing (default): SELECT [id], [username], [email], [password], [firstName], [lastName], [role], [isActive], [lastLogin], [refreshTokens], [createdAt], [updatedAt] FROM [Users] AS [User] WHERE [User].[email] = N'test123@gmail.com' ORDER BY [User].[id] OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY; Executing (default): UPDATE [Users] SET [refreshTokens]=@0,[lastLogin]=@1,[updatedAt]=@2 WHERE [id] = @3 2025-06-11T06:49:26.979Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:49:26.982Z - GET /CMMS_Vermicelli_api/api/get_emp_status.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:49:26.983Z - GET /CMMS_Vermicelli_api/api/UserProfileFetch.php?RowID=null 2025-06-11T06:49:26.987Z - GET /CMMS_Vermicelli_api/api/get_side_bar_menu_list.php?site_cd=null&emp_mst_empl_id=null 2025-06-11T06:49:47.125Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/asset-detail/2025-07-12 Fetching detail data for date: 2025-07-12 2025-06-11T06:49:47.126Z - GET /CMMS_Vermicelli_api/api/productionLineMixAndDeh/master-data/2025-07-12 Fetching master data for date: 2025-07-12 Executing (default): SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC; Executing (default): SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC; Executing (default): SELECT [RowID], [mst_RowID], [start_batch_date], [end_batch_date], [batch_no], [product], [method], [status], [rec_sago_sco_qty], [rec_corn_bag_qty], [rec_corn_sco_qty], [rec_tapioca_bag_qty], [rec_tapioca_sco_qty], [rec_wheat_sco_qty], [rec_recycle_pail_qty], [dryness_status], [mixed_status], [time_change_rice_cloth], [rice], [remarks] FROM [mix_deh_dtl] AS [AssetDetailMixAndDeh] WHERE [AssetDetailMixAndDeh].[mst_RowID] IN (11, 12, 13, 14, 15, 16, 17, 18, 19, 20) ORDER BY [AssetDetailMixAndDeh].[mst_RowID] ASC, [AssetDetailMixAndDeh].[batch_no] ASC; Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa Executing (default): SELECT 1+1 AS result SQL Server Connected successfully ✅ Database schema synchronized 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production Running file: C:\wamp64\www\CMMS_Vermicelli_api\config\database.js Attempting to connect to SQL Server... Host: zakaria Database: vermi_production Username: sa 🚀 CMMS Vermicelli API Server running on http://127.0.0.1:3006/CMMS_Vermicelli_api/api 🌐 External access: http://evantage.ddns.net:4000/CMMS_Vermicelli_api/api 💊 Health check: http://127.0.0.1:3006/CMMS_Vermicelli_api/health 📊 Database: SQL Server 🏗️ ORM: Sequelize 🔧 Environment: production