Object : Fcm Function : sendNotification Date : 04/07/2024 07:50:42 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:50:42 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 07:50:58 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:50:58 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 07:51:44 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 07:51:44 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:51:44 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 07:51:49 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 07:51:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:51:49 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 07:52:03 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 07:52:03 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:52:03 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 07:52:04 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 07:52:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 07:52:04 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 08:20:55 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 08:20:56 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:20:56 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 08:21:05 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 08:21:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:21:05 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 08:21:13 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 08:21:13 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:21:13 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 08:21:16 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 08:21:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:21:16 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 08:21:23 {"items": [{"product_id":548,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 08:21:23 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:21:23 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 08:21:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 08:21:47 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 09:49:43 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:49:43 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 09:50:10 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:50:10 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 09:50:25 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:50:25 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 09:51:45 {"items": [{"product_id":1028,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 09:51:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:51:45 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 09:51:59 {"items": [{"product_id":1028,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 09:51:59 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:51:59 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 09:52:04 {"items": [{"product_id":1028,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 09:52:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:52:04 toUid : 51 Object : Order Function : orderSave Date : 04/07/2024 09:52:05 {"items": [{"product_id":1028,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 09:52:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:52:05 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 09:52:28 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:52:28 toUid : 51 Object : Fcm Function : sendNotification Date : 04/07/2024 09:52:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 09:52:53 toUid : 51 Date : 04/07/2024 11:16:55 settokendevice Date : 04/07/2024 11:16:55 Louisban - 1396e046971cf09e5cde28e740905aefc5e2f18c - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Dashboard Function : SQL 2 Date : 04/07/2024 11:16:58 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 = 474 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 11:16:58 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 = 474 and idprog = 10 Object : Order Function : orderSave Date : 04/07/2024 11:23:00 {"items": [{"product_id":118,"qty":"9"},{"product_id":1573,"qty":"10"},{"product_id":117,"qty":"5"},{"product_id":1047,"qty":"4"},{"product_id":831,"qty":"4"},{"product_id":299,"qty":"10"},{"product_id":292,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 11:23:00 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:23:00 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:23:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:23:53 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:24:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:24:45 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:24:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:24:53 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:25:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:25:09 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:25:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:25:18 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:26:08 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:26:08 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:26:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:26:18 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:27:26 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:27:26 toUid : 210 Object : Chat Function : Trace 1 Date : 04/07/2024 11:27:26 select autonumber, from_id, to_id from ep0640 where document_no = 'SO-ST/2407/000132' and from_userid = 'LOUISBAN' and to_userid = 'K0311' and date_format(dop,'%Y-%m-%d %H:%i:%s') = '2024-07-04 11:27:26' and sync_status = 0 Object : Chat Function : Trace 2 Date : 04/07/2024 11:27:26 859 : 859 : 474 : 210 Object : Chat Function : Trace 3 Date : 04/07/2024 11:27:26 {"code":"1", "message":""} Object : Order Function : orderSave Date : 04/07/2024 11:31:39 {"items": [{"product_id":279,"qty":"4"},{"product_id":180,"qty":"4"},{"product_id":845,"qty":"4"},{"product_id":301,"qty":"6"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 11:31:39 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:31:39 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:31:56 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:31:56 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:32:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:32:04 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:32:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:32:09 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 11:32:16 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:32:16 toUid : 210 Date : 04/07/2024 11:34:51 settokendevice Date : 04/07/2024 11:34:51 K0355 - 8c5cde161fa8e808c97079bfb6cd7ed5fa6ed65d - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Date : 04/07/2024 11:38:21 settokendevice Date : 04/07/2024 11:38:21 Louisban - ac11140b27b845c28156873d02f3e67b91d1c207 - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Dashboard Function : SQL 2 Date : 04/07/2024 11:38:24 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 = 474 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 11:38:24 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 = 474 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 11:40: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 = 474 and idprog = 10 Date : 04/07/2024 11:40:55 settokendevice Date : 04/07/2024 11:40:55 K0355 - b023e7985ec1d5fd94296424f7b8df80992c69de - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Order Function : orderSave Date : 04/07/2024 11:59:04 {"items": [{"product_id":1352,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 11:59:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 11:59:04 toUid : 11 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 11:59:04 toFcmUid : ccz4ogTAQ56RLlXabw4n8U:APA91bExy0VCqtCLPDARDGUmpxNlSxFa4k1DN4tnrcxGEKcA3B7LrZsj4TEVwChiMKRo_FjqrVyFyfqBaFHv8aq0uh3X49I4lKZD5KWzDgBYOjx1XDeZfuTO7sOdS2ReT9U7o1WeHah- Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 11:59:04 toFcmUid : d2CrUPAKTSum3Y5f6nDr8I:APA91bFORQGu64LsNMjBAKEEGjeE5-roBBLjPY7oDQIEEqintgJFL2AqLn_frGFrR8tAEPAGQ51ASrUVyUWE_PNxNkLrMf_SwQMjWmGyfTm__DLDyqEaOcGjlkEGQ6aBhu3CJRY-6Qwg Object : Fcm Function : sendNotification Date : 04/07/2024 11:59:04 {"multicast_id":5111165982008222025,"success":1,"failure":1,"canonical_ids":0,"results":[{"message_id":"0:1720069144545376%b3c48fe1b3c48fe1"},{"error":"NotRegistered"}]} Object : Fcm Function : sendNotification Date : 04/07/2024 12:00:20 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 12:00:20 toUid : 11 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 12:00:20 toFcmUid : ccz4ogTAQ56RLlXabw4n8U:APA91bExy0VCqtCLPDARDGUmpxNlSxFa4k1DN4tnrcxGEKcA3B7LrZsj4TEVwChiMKRo_FjqrVyFyfqBaFHv8aq0uh3X49I4lKZD5KWzDgBYOjx1XDeZfuTO7sOdS2ReT9U7o1WeHah- Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 12:00:20 toFcmUid : d2CrUPAKTSum3Y5f6nDr8I:APA91bFORQGu64LsNMjBAKEEGjeE5-roBBLjPY7oDQIEEqintgJFL2AqLn_frGFrR8tAEPAGQ51ASrUVyUWE_PNxNkLrMf_SwQMjWmGyfTm__DLDyqEaOcGjlkEGQ6aBhu3CJRY-6Qwg Object : Fcm Function : sendNotification Date : 04/07/2024 12:00:21 {"multicast_id":1077555066119636245,"success":1,"failure":1,"canonical_ids":0,"results":[{"message_id":"0:1720069221302812%b3c48fe1b3c48fe1"},{"error":"NotRegistered"}]} Date : 04/07/2024 13:23:42 settokendevice Date : 04/07/2024 13:23:42 dominion080 - cd549a6bb0b1e779d95f1773954eb49f0a75db69 - fQYmEZ0JSRCo52BZP3V9m9:APA91bFYCBZjL4fdW7ib2RETceq2aabpRJLFKLS3isDLcfly33NRRS6htLRtZX6OurexYXYfwpvSvXEbUeao3vxZqM6kOc00moRghuzlvFVSF1q64319Pvdej7Zmj6kTzSElsbfRfaFe Object : Order Function : orderSave Date : 04/07/2024 13:51:47 {"items": [{"product_id":118,"qty":"25"},{"product_id":1108,"qty":"25"},{"product_id":776,"qty":"50"},{"product_id":1450,"qty":"50"},{"product_id":1710,"qty":"50"},{"product_id":174,"qty":"100"},{"product_id":786,"qty":"150"},{"product_id":175,"qty":"100"},{"product_id":1028,"qty":"50"},{"product_id":1679,"qty":"50"},{"product_id":294,"qty":"50"},{"product_id":280,"qty":"50"},{"product_id":299,"qty":"50"},{"product_id":795,"qty":"50"},{"product_id":281,"qty":"50"},{"product_id":292,"qty":"50"},{"product_id":999,"qty":"75"},{"product_id":301,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 13:51:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 13:51:47 toUid : 44 Date : 04/07/2024 14:32:46 settokendevice Date : 04/07/2024 14:32:46 Rodaban - 65e3e3bc58b9a81a74f3d794c3c53383e9c4508f - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Dashboard Function : SQL 2 Date : 04/07/2024 14:32:49 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 = 475 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 14:32:49 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 = 475 and idprog = 10 Object : Order Function : orderSave Date : 04/07/2024 14:36:45 {"items": [{"product_id":299,"qty":"5"},{"product_id":294,"qty":"5"},{"product_id":292,"qty":"5"},{"product_id":417,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 14:36:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:36:45 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 14:36:56 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:36:56 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 14:37:04 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:37:04 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 14:37:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:37:09 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 14:37:15 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:37:15 toUid : 210 Date : 04/07/2024 14:38:01 settokendevice Date : 04/07/2024 14:38:01 K0355 - 978e98370049db9cac9d68bd641c087c65da8ad1 - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Order Function : orderSave Date : 04/07/2024 14:42:02 {"items": [{"product_id":296,"qty":"25"},{"product_id":830,"qty":"50"},{"product_id":400,"qty":"50"},{"product_id":425,"qty":"50"},{"product_id":392,"qty":"100"},{"product_id":1671,"qty":"50"},{"product_id":402,"qty":"25"},{"product_id":395,"qty":"100"},{"product_id":396,"qty":"50"},{"product_id":548,"qty":"25"},{"product_id":531,"qty":"25"},{"product_id":113,"qty":"25"},{"product_id":119,"qty":"25"},{"product_id":181,"qty":"50"},{"product_id":293,"qty":"25"},{"product_id":252,"qty":"25"},{"product_id":906,"qty":"25"},{"product_id":424,"qty":"50"},{"product_id":849,"qty":"50"},{"product_id":824,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 14:42:02 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:42:02 toUid : 44 Object : Order Function : orderSave Date : 04/07/2024 14:48:30 {"items": [{"product_id":296,"qty":"4"},{"product_id":1028,"qty":"6"},{"product_id":294,"qty":"7"},{"product_id":299,"qty":"4"},{"product_id":849,"qty":"2"},{"product_id":532,"qty":"4"},{"product_id":767,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 14:48:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:48:30 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:49:19 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:49:19 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:49:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:49:33 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:49:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:49:45 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:50:00 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:50:00 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:50:13 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:50:13 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:50:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:50:29 toUid : 12 Object : Fcm Function : sendNotification Date : 04/07/2024 14:50:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 14:50:41 toUid : 12 Object : Order Function : orderSave Date : 04/07/2024 15:07:05 {"items": [{"product_id":154,"qty":"2"},{"product_id":392,"qty":"2"},{"product_id":179,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:07:05 toUid : 211 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:07:05 toFcmUid : esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:10 {"multicast_id":2932002466824321138,"success":1,"failure":0,"canonical_ids":0,"results":[{"message_id":"0:1720080430579420%b3c48fe1b3c48fe1"}]} Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:07:34 toUid : 211 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:07:34 toFcmUid : esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:35 {"multicast_id":312611882194710669,"success":1,"failure":0,"canonical_ids":0,"results":[{"message_id":"0:1720080455167993%b3c48fe1b3c48fe1"}]} Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:41 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:07:41 toUid : 211 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:07:41 toFcmUid : esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:41 {"multicast_id":1166098610209807578,"success":1,"failure":0,"canonical_ids":0,"results":[{"message_id":"0:1720080461369457%b3c48fe1b3c48fe1"}]} Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:07:47 toUid : 211 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:07:47 toFcmUid : esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Fcm Function : sendNotification Date : 04/07/2024 15:07:47 {"multicast_id":7069805810776305225,"success":1,"failure":0,"canonical_ids":0,"results":[{"message_id":"0:1720080467222614%b3c48fe1b3c48fe1"}]} Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:10:36 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 = 409 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:10:36 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 = 409 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:10:39 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 = 409 and idprog = 9 Date : 04/07/2024 15:11:03 settokendevice Date : 04/07/2024 15:11:03 OtoFashion - d5d4eab97c32b49af7e9be2d7fb5065e325a0f3d - dXqMFl4zQ_SIKSfe7cIzQN:APA91bFOdZfuYkS-ue7CN7Ss2zrnfugJ3N9LrYyZm_NTVL_6MNag8sqBaNoxTx4gD2J0SP2ZoSFaQT9_uND-zbEruv_oCadUuqbZKfy8hh4we04CYPkD-FvL1GMHQIEDXoEtPPV3EwLL Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:07 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:07 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:09 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 = 464 and idprog = 9 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:35 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:37 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 = 464 and idprog = 9 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:41 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 = 464 and idprog = 9 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:45 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:11:49 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 = 464 and idprog = 9 Object : Order Function : orderSave Date : 04/07/2024 15:12:18 {"items": [{"product_id":182,"qty":"8"},{"product_id":279,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:12:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:12:18 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:12:18 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:12:19 {"multicast_id":349079727028070571,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:12:52 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 = 464 and idprog = 9 Date : 04/07/2024 15:14:26 settokendevice Date : 04/07/2024 15:14:26 Eronban169 - 22c475367e5b2f1a771fbc7cd4df21be7bd47dbe - esEJ6FtJQnWeYWPDQ0Brcc:APA91bFKl_b14syabpFGz1s7hYvaPOhfGRXFDAKe7yhpmzBFJgA9sQOJhtF-REIeYJrf8_WmEcjwwFs4BYfFUqXJDHiTtGhr3uqxf2aU1Q49t0mctcNXIeLR6EpoVceCn-kRU6VnmbBX Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:14:30 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 = 390 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:14:30 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 = 390 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:14:35 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 = 390 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:15:01 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 = 390 and idprog = 10 Object : Order Function : orderSave Date : 04/07/2024 15:17:43 {"items": [{"product_id":425,"qty":"2"},{"product_id":174,"qty":"4"},{"product_id":1233,"qty":"1"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:17:43 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:17:43 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 15:17:52 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:17:52 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 15:17:58 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:17:58 toUid : 210 Object : Fcm Function : sendNotification Date : 04/07/2024 15:18:07 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:18:07 toUid : 210 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:18:08 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:18:08 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 = 464 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:18:12 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 = 464 and idprog = 9 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:18: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 = 390 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:18: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 = 390 and idprog = 10 Object : Order Function : orderSave Date : 04/07/2024 15:19:57 {"items": [{"product_id":1671,"qty":"12"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:19:57 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:19:57 toUid : 12 Date : 04/07/2024 15:20:11 settokendevice Date : 04/07/2024 15:20:11 PAMORBAN - 3296c2f1a042de5625634be6f823fe01b9c220a7 - f0uAP4mAREGbqjkkYjHPiN:APA91bGjTrsPXw5acL6x56DaW4Xd1OMWdBBibhX5cwFKzKfAQwarS1Quc5KRNH-zlO8KApPiorS--ZelDZt_X9USG6TCMj-C4hB2l5hXAJlSVzx7r1DoqbNVSly3VgfcdmOzFScZyvse Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:20:44 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 = 460 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:20:44 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 = 460 and idprog = 10 Object : Fcm Function : sendNotification Date : 04/07/2024 15:20:45 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:20:45 toUid : 12 Object : Dashboard Function : SQL 2 Date : 04/07/2024 15:20:48 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 = 460 and idprog = 9 Object : Order Function : orderSave Date : 04/07/2024 15:29:30 {"items": [{"product_id":174,"qty":"15"},{"product_id":299,"qty":"20"},{"product_id":292,"qty":"5"},{"product_id":301,"qty":"5"},{"product_id":849,"qty":"8"},{"product_id":545,"qty":"4"},{"product_id":554,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:29:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:29:30 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:29:30 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:29:31 {"multicast_id":766794022379798396,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Object : Order Function : orderSave Date : 04/07/2024 15:30:09 {"items": [{"product_id":1028,"qty":"10"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:30:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:30:09 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:30:09 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:30:10 {"multicast_id":2335296743764911560,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Object : Order Function : orderSave Date : 04/07/2024 15:32:46 {"items": [{"product_id":118,"qty":"10"},{"product_id":279,"qty":"10"},{"product_id":776,"qty":"8"},{"product_id":546,"qty":"1"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:32:46 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:32:46 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:32:46 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:32:46 {"multicast_id":2674826795432941998,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Date : 04/07/2024 15:33:55 settokendevice Date : 04/07/2024 15:33:55 istanaban176 - 6c110195e242ca5143f972c727e3edde5e3176e1 - eaI0IW1aQauMRivl_WmAPo:APA91bFNu1QQ6cVWKTe4ziDCRWQk5Qy6e824GxGvBNgobQJ0i87CNLvVUMXv56LPDTb1IpHF00bwe3dR6re8aB3UmNiGhNC4AP4rK-KRqBKN2M675ogizam5jbFgUkFHdcBabbMHJrHg Object : Order Function : orderSave Date : 04/07/2024 15:38:02 {"items": [{"product_id":523,"qty":"10"},{"product_id":1065,"qty":"10"},{"product_id":809,"qty":"10"},{"product_id":1028,"qty":"10"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:38:02 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:38:02 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:38:02 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:38:02 {"multicast_id":7800794565598817984,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Object : Order Function : orderSave Date : 04/07/2024 15:38:49 {"items": [{"product_id":182,"qty":"20"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:38:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:38:49 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:38:49 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:38:49 {"multicast_id":4910751293412740494,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Date : 04/07/2024 15:39:28 settokendevice Date : 04/07/2024 15:39:28 istanaban175 - 76f2437d560b03c3f8d2016cd5ed942db60e47f2 - eaI0IW1aQauMRivl_WmAPo:APA91bFNu1QQ6cVWKTe4ziDCRWQk5Qy6e824GxGvBNgobQJ0i87CNLvVUMXv56LPDTb1IpHF00bwe3dR6re8aB3UmNiGhNC4AP4rK-KRqBKN2M675ogizam5jbFgUkFHdcBabbMHJrHg Object : Order Function : orderSave Date : 04/07/2024 15:42:32 {"items": [{"product_id":417,"qty":"50"},{"product_id":858,"qty":"50"},{"product_id":605,"qty":"100"},{"product_id":549,"qty":"50"},{"product_id":917,"qty":"25"},{"product_id":1680,"qty":"25"},{"product_id":785,"qty":"50"},{"product_id":879,"qty":"25"},{"product_id":242,"qty":"25"},{"product_id":1046,"qty":"20"},{"product_id":179,"qty":"25"},{"product_id":1240,"qty":"30"},{"product_id":810,"qty":"20"},{"product_id":290,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:42:32 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:42:32 toUid : 44 Object : Order Function : orderSave Date : 04/07/2024 15:49:07 {"items": [{"product_id":537,"qty":"50"},{"product_id":554,"qty":"50"},{"product_id":559,"qty":"50"},{"product_id":545,"qty":"50"},{"product_id":831,"qty":"30"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:49:07 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:49:07 toUid : 44 Object : Order Function : orderSave Date : 04/07/2024 15:49:18 {"items": [{"product_id":113,"qty":"10"},{"product_id":118,"qty":"10"},{"product_id":117,"qty":"10"},{"product_id":174,"qty":"10"},{"product_id":182,"qty":"5"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:49:18 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:49:18 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:49:18 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:49:18 {"multicast_id":8686519763922267886,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Date : 04/07/2024 15:50:48 settokendevice Date : 04/07/2024 15:50:48 kickoff034 - 23a51a91e525e13f48337cd47c9c31db64d39689 - fQYmEZ0JSRCo52BZP3V9m9:APA91bFYCBZjL4fdW7ib2RETceq2aabpRJLFKLS3isDLcfly33NRRS6htLRtZX6OurexYXYfwpvSvXEbUeao3vxZqM6kOc00moRghuzlvFVSF1q64319Pvdej7Zmj6kTzSElsbfRfaFe Object : Order Function : orderSave Date : 04/07/2024 15:54:14 {"items": [{"product_id":836,"qty":"10"},{"product_id":1657,"qty":"10"},{"product_id":395,"qty":"20"},{"product_id":424,"qty":"10"},{"product_id":1674,"qty":"10"},{"product_id":792,"qty":"6"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 15:54:14 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 15:54:14 toUid : 36 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 15:54:14 toFcmUid : dqlR9wsBTzaCRtmUN2plAu:APA91bF_5LAANOYfyzrnnyEdpgAj7GpYLRJFiqZweustawXlJQGXPNPuhFn67mTLWr1fYdCN2ncCumhYYGjY55EtEhVKRk-x6HESg1-D_v3xCFVMHmY4luhLq1eax5OS4cz5PZ9Fz12X Object : Fcm Function : sendNotification Date : 04/07/2024 15:54:15 {"multicast_id":1279171155730452904,"success":0,"failure":1,"canonical_ids":0,"results":[{"error":"NotRegistered"}]} Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:05:16 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 = 460 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:05:16 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 = 460 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:05:21 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 = 460 and idprog = 9 Date : 04/07/2024 16:08:27 settokendevice Date : 04/07/2024 16:08:27 unsmulya162 - 1145025cd56258f358ac05c43e2706eca8f5c7ce - f0uAP4mAREGbqjkkYjHPiN:APA91bGjTrsPXw5acL6x56DaW4Xd1OMWdBBibhX5cwFKzKfAQwarS1Quc5KRNH-zlO8KApPiorS--ZelDZt_X9USG6TCMj-C4hB2l5hXAJlSVzx7r1DoqbNVSly3VgfcdmOzFScZyvse Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:08: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 = 440 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:08: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 = 440 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:08:36 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 = 440 and idprog = 9 Object : Order Function : orderSave Date : 04/07/2024 16:11:48 {"items": [{"product_id":118,"qty":"50"},{"product_id":1108,"qty":"50"},{"product_id":175,"qty":"50"},{"product_id":1679,"qty":"75"},{"product_id":294,"qty":"50"},{"product_id":280,"qty":"50"},{"product_id":795,"qty":"100"},{"product_id":292,"qty":"50"},{"product_id":301,"qty":"50"},{"product_id":296,"qty":"25"},{"product_id":302,"qty":"25"},{"product_id":279,"qty":"50"},{"product_id":830,"qty":"50"},{"product_id":400,"qty":"50"},{"product_id":392,"qty":"100"},{"product_id":475,"qty":"50"},{"product_id":1671,"qty":"75"},{"product_id":402,"qty":"50"}] } Object : Fcm Function : sendNotification Date : 04/07/2024 16:11:48 sendNotification Object : Fcm Function : sendNotification Loop Date : 04/07/2024 16:11:48 toUid : 20 Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 16:11:48 toFcmUid : cCtGuQHrSuO0GIMPAfPxhI:APA91bF1giu06Q2xzCJDobBMOYbQpYe6r55ALxyPozZP_jp1AW9horpfpObujiyD361iUNlWrp1jnuBs-aTWjzpFExEu3eggcvksS0v-ijD3OrxWySq-ehEa3rqk3PudX3AfG9ba5m0q Object : Fcm Function : sendNotification Loop 2 Date : 04/07/2024 16:11:48 toFcmUid : emtiVguCRWGxJ_exl8NqkN:APA91bFIa-Quk0vXEAXUxtlaF34Z2l9Lb2VeEgC3FBCMKRLp_MRYMW8Bxro3ZWggMNYeXPi8LaPq9JQCeWb1dOq9_M2wWtoTVMIaQozNBFz5tkaEVymPiGgQowlsv98MH-B1eAVGle06 Object : Fcm Function : sendNotification Date : 04/07/2024 16:11:50 {"multicast_id":5732496510003844675,"success":0,"failure":2,"canonical_ids":0,"results":[{"error":"NotRegistered"},{"error":"NotRegistered"}]} Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:26:12 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 = 440 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:26:12 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 = 440 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:26:18 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 = 440 and idprog = 9 Date : 04/07/2024 16:26:42 settokendevice Date : 04/07/2024 16:26:42 rafijaya103 - 4390bb33372a086a5e8451344aa207bbf8b225d8 - f0uAP4mAREGbqjkkYjHPiN:APA91bGjTrsPXw5acL6x56DaW4Xd1OMWdBBibhX5cwFKzKfAQwarS1Quc5KRNH-zlO8KApPiorS--ZelDZt_X9USG6TCMj-C4hB2l5hXAJlSVzx7r1DoqbNVSly3VgfcdmOzFScZyvse Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:26:45 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 = 326 and idprog = 10 Object : Dashboard Function : SQL 2 Date : 04/07/2024 16:26:45 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 = 326 and idprog = 10