Object : Dashboard Function : SQL 2 Date : 22/11/2024 04:43:33 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 04:43:33 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 11 Object : Order Function : orderSave Date : 22/11/2024 07:33:55 {"items": [{"product_id":927,"qty":"5"},{"product_id":1444,"qty":"4"},{"product_id":296,"qty":"8"},{"product_id":425,"qty":"8"},{"product_id":1047,"qty":"8"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 07:33:55 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 07:33:55 toUid : 51 Object : Order Function : orderSave Date : 22/11/2024 09:42:00 {"items": [{"product_id":1585,"qty":"20"},{"product_id":845,"qty":"20"},{"product_id":785,"qty":"20"},{"product_id":1846,"qty":"20"},{"product_id":1850,"qty":"20"},{"product_id":299,"qty":"20"},{"product_id":47,"qty":"20"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 09:42:00 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 09:42:00 toUid : 453 Object : Order Function : orderSave Date : 22/11/2024 09:44:48 {"items": [{"product_id":279,"qty":"50"},{"product_id":849,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 09:44:48 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 09:44:48 toUid : 453 Object : Order Function : orderSave Date : 22/11/2024 09:50:51 {"items": [{"product_id":696,"qty":"8"},{"product_id":45,"qty":"8"},{"product_id":791,"qty":"12"},{"product_id":35,"qty":"8"},{"product_id":927,"qty":"12"},{"product_id":700,"qty":"8"},{"product_id":773,"qty":"12"},{"product_id":1444,"qty":"12"},{"product_id":720,"qty":"8"},{"product_id":904,"qty":"20"},{"product_id":779,"qty":"12"},{"product_id":36,"qty":"4"},{"product_id":1562,"qty":"12"},{"product_id":1357,"qty":"8"},{"product_id":825,"qty":"12"},{"product_id":41,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 09:50:51 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 09:50:51 toUid : 453 Object : Order Function : orderSave Date : 22/11/2024 09:52:27 {"items": [{"product_id":1000,"qty":"50"},{"product_id":182,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 09:52:27 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 09:52:27 toUid : 453 Object : Order Function : orderSave Date : 22/11/2024 09:53:25 {"items": [{"product_id":980,"qty":"30"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 09:53:25 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 09:53:25 toUid : 453 Object : Order Function : orderSave Date : 22/11/2024 10:03:01 {"items": [{"product_id":922,"qty":"4"},{"product_id":396,"qty":"4"},{"product_id":790,"qty":"4"},{"product_id":843,"qty":"4"},{"product_id":1867,"qty":"4"},{"product_id":603,"qty":"4"},{"product_id":839,"qty":"4"},{"product_id":422,"qty":"4"},{"product_id":402,"qty":"4"},{"product_id":605,"qty":"4"},{"product_id":559,"qty":"8"},{"product_id":537,"qty":"8"},{"product_id":392,"qty":"8"},{"product_id":825,"qty":"8"},{"product_id":699,"qty":"8"},{"product_id":904,"qty":"8"},{"product_id":2,"qty":"8"},{"product_id":732,"qty":"8"},{"product_id":713,"qty":"8"},{"product_id":772,"qty":"8"},{"product_id":16,"qty":"8"},{"product_id":7,"qty":"8"},{"product_id":37,"qty":"8"},{"product_id":1445,"qty":"8"},{"product_id":925,"qty":"8"},{"product_id":810,"qty":"8"},{"product_id":700,"qty":"8"},{"product_id":1051,"qty":"8"},{"product_id":773,"qty":"8"},{"product_id":29,"qty":"8"},{"product_id":35,"qty":"8"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:03:01 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:03:01 toUid : 453 Date : 22/11/2024 10:03:56 settokendevice Date : 22/11/2024 10:03:56 legend088 - 773c0838c678d946e70ab5d9ca176442357b928f - dDNXrhMTTXaAX_VX84-Ao2:APA91bHDKQyx-JWdcwUjqFJ3G_BoEqPwaXulCCY8nMLxKBYCt00WwmD6TfbFvesnkihe-76AhHOvDTvMiFOVNiDA98a49bzkYp43C56718Clcu4O0YrCtNetjN8p2MFl6fXids2QHu35 Date : 22/11/2024 10:04:56 settokendevice Date : 22/11/2024 10:04:56 ewako095 - 12a6a90861c57f28d996bb3177bd6ec4149e76ee - dDNXrhMTTXaAX_VX84-Ao2:APA91bHDKQyx-JWdcwUjqFJ3G_BoEqPwaXulCCY8nMLxKBYCt00WwmD6TfbFvesnkihe-76AhHOvDTvMiFOVNiDA98a49bzkYp43C56718Clcu4O0YrCtNetjN8p2MFl6fXids2QHu35 Object : Order Function : orderSave Date : 22/11/2024 10:11:22 {"items": [{"product_id":771,"qty":"50"},{"product_id":548,"qty":"30"},{"product_id":1868,"qty":"50"},{"product_id":301,"qty":"50"},{"product_id":543,"qty":"30"},{"product_id":1240,"qty":"20"},{"product_id":1602,"qty":"8"},{"product_id":283,"qty":"16"},{"product_id":662,"qty":"8"},{"product_id":1678,"qty":"8"},{"product_id":422,"qty":"16"},{"product_id":555,"qty":"8"},{"product_id":242,"qty":"20"},{"product_id":825,"qty":"8"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:11:22 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:11:22 toUid : 53 Object : Order Function : orderSave Date : 22/11/2024 10:15:44 {"items": [{"product_id":548,"qty":"30"},{"product_id":792,"qty":"30"},{"product_id":809,"qty":"20"},{"product_id":29,"qty":"12"},{"product_id":815,"qty":"8"},{"product_id":877,"qty":"20"},{"product_id":927,"qty":"8"},{"product_id":994,"qty":"12"},{"product_id":1868,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:15:44 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:15:44 toUid : 53 Object : Order Function : orderSave Date : 22/11/2024 10:19:01 {"items": [{"product_id":1113,"qty":"40"},{"product_id":797,"qty":"60"},{"product_id":1414,"qty":"40"},{"product_id":950,"qty":"20"},{"product_id":543,"qty":"40"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:19:01 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:19:01 toUid : 53 Object : Order Function : orderSave Date : 22/11/2024 10:25:16 {"items": [{"product_id":118,"qty":"20"},{"product_id":1108,"qty":"20"},{"product_id":174,"qty":"50"},{"product_id":1028,"qty":"50"},{"product_id":280,"qty":"100"},{"product_id":294,"qty":"50"},{"product_id":299,"qty":"50"},{"product_id":795,"qty":"50"},{"product_id":281,"qty":"50"},{"product_id":523,"qty":"50"},{"product_id":121,"qty":"50"},{"product_id":181,"qty":"50"},{"product_id":849,"qty":"50"},{"product_id":381,"qty":"25"},{"product_id":1752,"qty":"25"},{"product_id":879,"qty":"25"},{"product_id":242,"qty":"25"},{"product_id":179,"qty":"20"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:25:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:25:16 toUid : 53 Object : Order Function : orderSave Date : 22/11/2024 10:29:26 {"items": [{"product_id":1000,"qty":"50"},{"product_id":182,"qty":"50"},{"product_id":417,"qty":"50"},{"product_id":845,"qty":"50"},{"product_id":858,"qty":"50"},{"product_id":1585,"qty":"50"},{"product_id":1617,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:29:26 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:29:26 toUid : 53 Date : 22/11/2024 10:30:20 settokendevice Date : 22/11/2024 10:30:20 goldengate017 - b1cc86023f9e26e130a2a9eba39ee94f77456a9e - dDNXrhMTTXaAX_VX84-Ao2:APA91bHDKQyx-JWdcwUjqFJ3G_BoEqPwaXulCCY8nMLxKBYCt00WwmD6TfbFvesnkihe-76AhHOvDTvMiFOVNiDA98a49bzkYp43C56718Clcu4O0YrCtNetjN8p2MFl6fXids2QHu35 Object : Order Function : orderSave Date : 22/11/2024 10:44:16 {"items": [{"product_id":301,"qty":"3"},{"product_id":294,"qty":"4"},{"product_id":279,"qty":"10"},{"product_id":293,"qty":"3"},{"product_id":174,"qty":"12"},{"product_id":283,"qty":"4"},{"product_id":167,"qty":"2"},{"product_id":804,"qty":"3"},{"product_id":836,"qty":"3"},{"product_id":402,"qty":"2"},{"product_id":776,"qty":"15"},{"product_id":825,"qty":"2"},{"product_id":113,"qty":"16"},{"product_id":115,"qty":"1"},{"product_id":118,"qty":"4"},{"product_id":1047,"qty":"3"},{"product_id":831,"qty":"3"},{"product_id":182,"qty":"4"},{"product_id":299,"qty":"4"},{"product_id":169,"qty":"2"},{"product_id":1868,"qty":"9"},{"product_id":786,"qty":"4"},{"product_id":1469,"qty":"4"},{"product_id":117,"qty":"5"},{"product_id":165,"qty":"1"},{"product_id":802,"qty":"2"},{"product_id":768,"qty":"1"},{"product_id":1065,"qty":"2"},{"product_id":432,"qty":"4"},{"product_id":292,"qty":"2"},{"product_id":1451,"qty":"1"},{"product_id":1220,"qty":"6"},{"product_id":395,"qty":"3"},{"product_id":783,"qty":"4"},{"product_id":302,"qty":"2"},{"product_id":1867,"qty":"6"},{"product_id":1130,"qty":"3"},{"product_id":896,"qty":"4"},{"product_id":425,"qty":"2"},{"product_id":532,"qty":"1"},{"product_id":1671,"qty":"2"},{"product_id":1070,"qty":"2"},{"product_id":767,"qty":"2"},{"product_id":1028,"qty":"4"},{"product_id":562,"qty":"1"},{"product_id":158,"qty":"2"},{"product_id":120,"qty":"2"},{"product_id":237,"qty":"2"},{"product_id":1232,"qty":"1"},{"product_id":181,"qty":"1"},{"product_id":281,"qty":"2"},{"product_id":771,"qty":"2"},{"product_id":849,"qty":"1"},{"product_id":1657,"qty":"6"},{"product_id":119,"qty":"3"},{"product_id":1139,"qty":"4"},{"product_id":879,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 10:44:17 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:44:17 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:45:26 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:45:26 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:45:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:45:38 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:45:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:45:49 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:46:01 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:46:01 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:46:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:46:16 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:46:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:46:34 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:46:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:46:49 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:47:06 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:47:06 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:47:19 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:47:19 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:47:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:47:33 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:47:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:47:45 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:48:03 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:48:03 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:48:24 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:48:24 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:48:36 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:48:36 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:48:56 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:48:56 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:49:13 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:49:13 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:49:27 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:49:27 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:49:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:49:41 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:49:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:49:57 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:50:13 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:50:13 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:50:27 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:50:27 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:50:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:50:41 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:51:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:51:05 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:51:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:51:21 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:51:54 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:51:54 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:52:15 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:52:15 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:52:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:52:30 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:52:51 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:52:51 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:53:10 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:53:10 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:53:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:53:30 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:53:52 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:53:52 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:54:12 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:54:12 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:54:36 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:54:36 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:54:55 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:54:55 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:55:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:55:16 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:55:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:55:38 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:55:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:55:57 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:56:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:56:16 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:56:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:56:38 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:57:02 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:57:02 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:57:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:57:21 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:57:42 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:57:42 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:58:07 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:58:07 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:58:37 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:58:37 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:59:03 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:59:03 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:59:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:59:34 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 10:59:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 10:59:49 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:00:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:00:11 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:00:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:00:29 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:00:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:00:47 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:01:10 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:01:10 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:01:31 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:01:31 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:01:48 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:01:48 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:02:07 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:02:07 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:02:28 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:02:28 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:02:46 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:02:46 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:03:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:03:05 toUid : 39 Object : Order Function : orderSave Date : 22/11/2024 11:10:38 {"items": [{"product_id":113,"qty":"1"},{"product_id":174,"qty":"2"},{"product_id":175,"qty":"15"},{"product_id":786,"qty":"4"},{"product_id":312,"qty":"10"},{"product_id":1657,"qty":"2"},{"product_id":766,"qty":"2"},{"product_id":1462,"qty":"4"},{"product_id":425,"qty":"25"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 11:10:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:10:38 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:11:22 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:11:22 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:11:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:11:29 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:11:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:11:38 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:11:46 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:11:46 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:11:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:11:53 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:12:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:12:04 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:12:14 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:12:14 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:12:22 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:12:22 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:12:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:12:30 toUid : 39 Object : Order Function : orderSave Date : 22/11/2024 11:16:07 {"items": [{"product_id":604,"qty":"1"},{"product_id":1140,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 11:16:08 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:16:08 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:17:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:17:29 toUid : 39 Object : Fcm Function : sendNotification Date : 22/11/2024 11:17:39 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:17:39 toUid : 39 Object : Order Function : orderSave Date : 22/11/2024 11:36:49 {"items": [{"product_id":302,"qty":"19"},{"product_id":303,"qty":"2"},{"product_id":175,"qty":"3"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 11:36:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:36:49 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:36:49 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:36:49 {"multicast_id":2239397203537241202,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:06 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:38:06 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:38:06 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:06 {"multicast_id":6934379553794485991,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:38:11 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:38:11 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:11 {"multicast_id":5332562772351296,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:19 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:38:19 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:38:19 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:38:19 {"multicast_id":6691894695209807033,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Order Function : orderSave Date : 22/11/2024 11:39:57 {"items": [{"product_id":302,"qty":"8"},{"product_id":167,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 11:39:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:39:57 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:39:57 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:39:57 {"multicast_id":7818913365299343763,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:41:01 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:41:01 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:41:01 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:41:01 {"multicast_id":4432191460907453413,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:41:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:41:05 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:41:05 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:41:06 {"multicast_id":6390025224896080391,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Order Function : orderSave Date : 22/11/2024 11:54:23 {"items": [{"product_id":175,"qty":"3"},{"product_id":1452,"qty":"4"},{"product_id":302,"qty":"12"},{"product_id":396,"qty":"4"},{"product_id":179,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 11:54:23 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:54:23 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:54:23 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:54:24 {"multicast_id":5855792838343189157,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:27 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:56:27 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:56:27 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:27 {"multicast_id":718910381927460094,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:56:47 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:56:47 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:47 {"multicast_id":7126848319579672697,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:56:57 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:56:57 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:56:57 {"multicast_id":1276367358473499909,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:57:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:57:04 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:57:04 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:57:04 {"multicast_id":1814728040934193363,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 11:57:10 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 11:57:10 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 11:57:10 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 11:57:10 {"multicast_id":2945652623418266112,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Order Function : orderSave Date : 22/11/2024 12:00:22 {"items": [{"product_id":824,"qty":"4"},{"product_id":858,"qty":"2"},{"product_id":1867,"qty":"4"},{"product_id":167,"qty":"3"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 12:00:22 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 12:00:22 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 12:00:22 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 12:00:22 {"multicast_id":8345859962760562752,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:12 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 12:01:12 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 12:01:12 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:12 {"multicast_id":447084668674966996,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 12:01:16 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 12:01:16 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:16 {"multicast_id":104273952780349602,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:20 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 12:01:20 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 12:01:20 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:20 {"multicast_id":5730862616799041391,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:26 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 12:01:26 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 12:01:26 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 12:01:26 {"multicast_id":5468813875491978626,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Order Function : orderSave Date : 22/11/2024 13:17:11 {"items": [{"product_id":809,"qty":"1"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 13:17:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 13:17:11 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 13:18:08 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 13:18:08 toUid : 12 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:12:55 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 328 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:12:55 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 328 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:24:13 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 248 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:24:13 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 248 and idprog = 11 Object : Order Function : orderSave Date : 22/11/2024 14:27:53 {"items": [{"product_id":301,"qty":"30"},{"product_id":962,"qty":"10"},{"product_id":1130,"qty":"30"},{"product_id":302,"qty":"10"},{"product_id":1000,"qty":"10"},{"product_id":1352,"qty":"10"},{"product_id":1235,"qty":"10"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 14:27:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:27:53 toUid : 209 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:28:27 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:28:27 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 11 Object : Order Function : orderSave Date : 22/11/2024 14:29:21 {"items": [{"product_id":167,"qty":"20"},{"product_id":776,"qty":"23"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 14:29:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:29:21 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:29:46 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:29:46 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:29:52 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:29:52 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:29:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:29:57 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:03 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:03 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:09 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:41 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:46 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:46 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:54 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:54 toUid : 209 Object : Fcm Function : sendNotification Date : 22/11/2024 14:30:59 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 14:30:59 toUid : 209 Object : Dashboard Function : SQL 2 Date : 22/11/2024 14:31:11 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 248 and idprog = 11 Object : Order Function : orderSave Date : 22/11/2024 15:05:55 {"items": [{"product_id":776,"qty":"4"},{"product_id":301,"qty":"6"},{"product_id":294,"qty":"2"},{"product_id":299,"qty":"2"},{"product_id":279,"qty":"1"},{"product_id":432,"qty":"2"},{"product_id":849,"qty":"2"},{"product_id":809,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 15:05:55 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:05:55 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:33:28 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:33:28 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:33:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:33:41 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:33:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:33:53 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:34:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:34:05 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:34:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:34:29 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:34:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:34:45 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:34:58 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:34:58 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 15:35:14 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 15:35:14 toUid : 12 Object : Dashboard Function : SQL 2 Date : 22/11/2024 15:44:55 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 304 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 15:44:55 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 304 and idprog = 11 Object : Order Function : orderSave Date : 22/11/2024 16:13:44 {"items": [{"product_id":303,"qty":"3"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 16:13:44 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 16:13:44 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 16:13:44 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 16:13:45 {"multicast_id":8304142036836157372,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Fcm Function : sendNotification Date : 22/11/2024 16:14:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 16:14:05 toUid : 149 Object : Fcm Function : sendNotification Loop 2 Date : 22/11/2024 16:14:05 toFcmUid : f9Crk7pOQc2057M9Xc-2yX:APA91bHUFDgFHBWZrY6RtNCKH0a0KJChmaXMPIzU284DlmlYpwimKdF4H7ACx82ouSiHO1VvcOpANXOj9UmSko3uOlb7jgZgCYMba4MRbN13kfyTObrdSggI6alhdmWvhH_Chv5movtt Object : Fcm Function : sendNotification Date : 22/11/2024 16:14:05 {"multicast_id":90593434564626211,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"DeprecatedApi"}]} Object : Order Function : orderSave Date : 22/11/2024 16:29:20 {"items": [{"product_id":425,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 16:29:20 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 16:29:20 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 16:38:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 16:38:18 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 17:25:49 {"items": [{"product_id":1646,"qty":"12"},{"product_id":425,"qty":"3"},{"product_id":546,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 17:25:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:25:49 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:26:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:26:11 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:26:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:26:29 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:26:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:26:34 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 17:33:39 {"items": [{"product_id":293,"qty":"1"},{"product_id":1646,"qty":"6"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 17:33:39 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:33:39 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:34:31 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:34:31 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:34:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:34:38 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 17:50:15 {"items": [{"product_id":985,"qty":"4"},{"product_id":1537,"qty":"4"},{"product_id":174,"qty":"3"},{"product_id":299,"qty":"2"},{"product_id":292,"qty":"2"},{"product_id":1445,"qty":"4"},{"product_id":1240,"qty":"4"},{"product_id":1749,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 17:50:15 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:50:15 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:50:39 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:50:39 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:50:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:50:45 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:50:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:50:49 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:51:01 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:51:01 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:51:07 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:51:07 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:51:15 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:51:15 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:53:12 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:53:12 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:53:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:53:18 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 17:54:56 {"items": [{"product_id":299,"qty":"10"},{"product_id":776,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 17:54:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:54:57 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:58:44 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:58:44 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 17:59:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 17:59:04 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 18:00:25 {"items": [{"product_id":41,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 18:00:25 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:00:25 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 18:03:25 {"items": [{"product_id":802,"qty":"2"},{"product_id":117,"qty":"4"},{"product_id":1047,"qty":"4"},{"product_id":809,"qty":"3"},{"product_id":174,"qty":"5"},{"product_id":120,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 18:03:25 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:03:25 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:04:28 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:04:28 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:04:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:04:45 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:04:51 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:04:51 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:04:56 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:04:56 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:05:02 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:05:02 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:05:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:05:11 toUid : 49 Object : Fcm Function : sendNotification Date : 22/11/2024 18:05:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:05:16 toUid : 49 Object : Order Function : orderSave Date : 22/11/2024 18:29:32 {"items": [{"product_id":113,"qty":"2"},{"product_id":1565,"qty":"2"},{"product_id":181,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 22/11/2024 18:29:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:29:33 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 18:30:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:30:05 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 18:30:12 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:30:12 toUid : 12 Object : Fcm Function : sendNotification Date : 22/11/2024 18:30:19 sendNotification Object : Fcm Function : sendNotification Loop Date : 22/11/2024 18:30:19 toUid : 12 Object : Dashboard Function : SQL 2 Date : 22/11/2024 19:05:23 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 328 and idprog = 11 Object : Dashboard Function : SQL 2 Date : 22/11/2024 19:08:56 select program_name, periode, criteria1, criteria2, criteria3, ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1, ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2, ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 304 and idprog = 11