Object : Dashboard Function : SQL 2 Date : 15/05/2025 04:40: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 = 429 and idprog = 13 Object : Dashboard Function : SQL 2 Date : 15/05/2025 04:40: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 = 429 and idprog = 13 Object : Order Function : orderSave Date : 15/05/2025 10:04:09 {"items": [{"product_id":45,"qty":"2"},{"product_id":296,"qty":"20"},{"product_id":432,"qty":"10"},{"product_id":1028,"qty":"2"},{"product_id":776,"qty":"5"},{"product_id":299,"qty":"10"},{"product_id":279,"qty":"5"},{"product_id":182,"qty":"4"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 10:04:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:04:09 toUid : 39 Object : Order Function : orderSave Date : 15/05/2025 10:05:54 {"items": [{"product_id":1671,"qty":"10"},{"product_id":849,"qty":"4"},{"product_id":695,"qty":"1"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 10:05:54 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:05:54 toUid : 39 Object : Apiimport Function : import Date : 15/05/2025 10:26:32 {"tableid":"ep0105", "key1":"45F5B594A2D3C91AD07D614031DCE609AD1792BF","key2":"1787158353", "details":[{"autonumber":"775", "description":"265/40 ZR21 105Y XL FORCEUM PENTA", "rim_id":"10", "dimension_id":"109", "pattern_id":"40", "brand_id":"2", "discountinue":"NO", "price_tk":"2070750", "price_tm":"2070750", "price_dt":"1784880", "record_status":""}]} Object : Apiimport Function : import Date : 15/05/2025 10:27:31 {"tableid":"ep0105", "key1":"873173D30D540CE471E98FF4F7384DD2895C1348","key2":"8582474713", "details":[{"autonumber":"86", "description":"275/45 ZR22 112W XL ACCELERA IOTA-ST68", "rim_id":"11", "dimension_id":"121", "pattern_id":"60", "brand_id":"1", "discountinue":"NO", "price_tk":"1867250", "price_tm":"1867250", "price_dt":"1609500", "record_status":""},{"autonumber":"825", "description":"265/50 R20 111V XL ACCELERA IOTA-ST68", "rim_id":"9", "dimension_id":"111", "pattern_id":"60", "brand_id":"1", "discountinue":"NO", "price_tk":"1393150", "price_tm":"1393150", "price_dt":"1201020", "record_status":""},{"autonumber":"849", "description":"205/65 R16 95H ACCELERA ECO PLUSH", "rim_id":"5", "dimension_id":"47", "pattern_id":"18", "brand_id":"1", "discountinue":"NO", "price_tk":"635250", "price_tm":"635250", "price_dt":"567210", "record_status":""},{"autonumber":"894", "description":"215/70 R15 98H ACCELERA ECO PLUSH", "rim_id":"4", "dimension_id":"58", "pattern_id":"18", "brand_id":"1", "discountinue":"NO", "price_tk":"681450", "price_tm":"681450", "price_dt":"624930", "record_status":""},{"autonumber":"799", "description":"275/60 R20 115H ZEETEX SU1000", "rim_id":"9", "dimension_id":"124", "pattern_id":"75", "brand_id":"3", "discountinue":"NO", "price_tk":"1724250", "price_tm":"1724250", "price_dt":"1486290", "record_status":""}]} Object : Apiimport Function : import Date : 15/05/2025 10:28:31 {"tableid":"ep0105", "key1":"F23A3937400D991E2DCE89B73FD0AEB7F3C55C73","key2":"4319101976", "details":[{"autonumber":"549", "description":"225/55 ZR17 101W XL ACCELERA PHI-R (STA)", "rim_id":"6", "dimension_id":"66", "pattern_id":"57", "brand_id":"1", "discountinue":"NO", "price_tk":"790900", "price_tm":"790900", "price_dt":"681540", "record_status":""},{"autonumber":"664", "description":"245/35 ZR18 92Y XL ACCELERA PHI-R (STA)", "rim_id":"7", "dimension_id":"85", "pattern_id":"57", "brand_id":"1", "discountinue":"NO", "price_tk":"1169300", "price_tm":"1169300", "price_dt":"1007880", "record_status":""},{"autonumber":"843", "description":"205/55 R17 95V XL ACCELERA PHI-R (STA)", "rim_id":"6", "dimension_id":"45", "pattern_id":"57", "brand_id":"1", "discountinue":"NO", "price_tk":"792000", "price_tm":"792000", "price_dt":"682650", "record_status":""},{"autonumber":"1576", "description":"275/35 ZR22 104Y XL ACCELERA IOTA-ST68", "rim_id":"11", "dimension_id":"119", "pattern_id":"60", "brand_id":"1", "discountinue":"NO", "price_tk":"2014100", "price_tm":"2014100", "price_dt":"1736040", "record_status":""},{"autonumber":"811", "description":"305/40 ZR22 114W XL FORCEUM HEPTAGON SUV", "rim_id":"11", "dimension_id":"144", "pattern_id":"81", "brand_id":"2", "discountinue":"NO", "price_tk":"2479950", "price_tm":"2479950", "price_dt":"2137860", "record_status":""}]} Object : Apiimport Function : import Date : 15/05/2025 10:29:27 {"tableid":"ep0105", "key1":"0C40A25CB379F5707A90A51CED078D4A7DB4D7D6","key2":"3528539183", "details":[{"autonumber":"1266", "description":"245/25 ZR21 86Y XL ACCELERA PHI", "rim_id":"10", "dimension_id":"83", "pattern_id":"41", "brand_id":"1", "discountinue":"NO", "price_tk":"2165900", "price_tm":"2165900", "price_dt":"1867020", "record_status":""},{"autonumber":"1629", "description":"315/40 ZR21 115W XL ACCELERA IOTA-ST68", "rim_id":"10", "dimension_id":"150", "pattern_id":"60", "brand_id":"1", "discountinue":"NO", "price_tk":"3973200", "price_tm":"3973200", "price_dt":"3425460", "record_status":""},{"autonumber":"302", "description":"195/50 R15 82V FORCEUM HENA (NE) (NON GSO)", "rim_id":"4", "dimension_id":"34", "pattern_id":"23", "brand_id":"2", "discountinue":"NO", "price_tk":"558250", "price_tm":"558250", "price_dt":"511710", "record_status":""}]} Object : Fcm Function : sendNotification Date : 15/05/2025 10:54:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:54:49 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 10:55:03 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:55:03 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 10:55:13 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:55:13 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 10:55:23 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:55:23 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 10:55:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:55:33 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 10:55:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 10:55:53 toUid : 39 Date : 15/05/2025 11:32:25 settokendevice Date : 15/05/2025 11:32:25 sukses025 - 8b4c36ef0280537f05c2232ba693d71f3c13bcd8 - f0uAP4mAREGbqjkkYjHPiN:APA91bGjTrsPXw5acL6x56DaW4Xd1OMWdBBibhX5cwFKzKfAQwarS1Quc5KRNH-zlO8KApPiorS--ZelDZt_X9USG6TCMj-C4hB2l5hXAJlSVzx7r1DoqbNVSly3VgfcdmOzFScZyvse Object : Fcm Function : sendNotification Date : 15/05/2025 11:33:42 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:33:42 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 11:33:54 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:33:54 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 11:34:06 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:34:06 toUid : 19 Object : Order Function : orderSave Date : 15/05/2025 11:35:33 {"items": [{"product_id":325,"qty":"4"},{"product_id":438,"qty":"3"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 11:35:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:35:33 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 11:36:30 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:36:30 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 11:36:42 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:36:42 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 11:49:28 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:49:28 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:49:38 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:49:38 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:50:00 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:50:00 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:50:11 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:50:11 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:50:20 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:50:20 toUid : 39 Object : Order Function : orderSave Date : 15/05/2025 11:51:33 {"items": [{"product_id":293,"qty":"1"},{"product_id":294,"qty":"1"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 11:51:33 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:51:33 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:53:19 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:53:19 toUid : 39 Object : Fcm Function : sendNotification Date : 15/05/2025 11:53:32 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 11:53:32 toUid : 39 Object : Order Function : orderSave Date : 15/05/2025 12:06:52 {"items": [{"product_id":1672,"qty":"2"},{"product_id":279,"qty":"5"},{"product_id":786,"qty":"1"},{"product_id":293,"qty":"1"},{"product_id":167,"qty":"2"},{"product_id":299,"qty":"1"},{"product_id":123,"qty":"1"},{"product_id":653,"qty":"4"},{"product_id":1803,"qty":"2"},{"product_id":325,"qty":"4"},{"product_id":438,"qty":"3"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 12:06:52 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:06:52 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:10:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:10:21 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:10:36 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:10:36 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:10:47 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:10:47 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:11:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:11:29 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:12:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:12:21 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:12:36 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:12:36 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:12:49 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:12:49 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:27:40 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:27:40 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:27:54 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:27:54 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:28:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:28:09 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:28:23 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:28:23 toUid : 19 Object : Order Function : orderSave Date : 15/05/2025 12:37:29 {"items": [{"product_id":1325,"qty":"2"},{"product_id":121,"qty":"2"},{"product_id":299,"qty":"4"},{"product_id":786,"qty":"2"},{"product_id":1025,"qty":"2"},{"product_id":179,"qty":"2"},{"product_id":831,"qty":"1"},{"product_id":535,"qty":"2"},{"product_id":438,"qty":"2"},{"product_id":291,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 12:37:29 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:37:29 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:38:17 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:38:17 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:38:31 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:38:31 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:38:53 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:38:53 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:39:09 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:39:09 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:39:21 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:39:21 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:39:36 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:39:36 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:39:52 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:39:52 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:40:05 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:40:05 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:40:22 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:40:22 toUid : 19 Object : Fcm Function : sendNotification Date : 15/05/2025 12:40:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:40:34 toUid : 19 Object : Order Function : orderSave Date : 15/05/2025 12:40:34 {"items": [{"product_id":243,"qty":"2"}] } Object : Fcm Function : sendNotification Date : 15/05/2025 12:40:34 sendNotification Object : Fcm Function : sendNotification Loop Date : 15/05/2025 12:40:34 toUid : 11 Object : Fcm Function : sendNotification Loop 2 Date : 15/05/2025 12:40:34 toFcmUid : ccz4ogTAQ56RLlXabw4n8U:APA91bExy0VCqtCLPDARDGUmpxNlSxFa4k1DN4tnrcxGEKcA3B7LrZsj4TEVwChiMKRo_FjqrVyFyfqBaFHv8aq0uh3X49I4lKZD5KWzDgBYOjx1XDeZfuTO7sOdS2ReT9U7o1WeHah- Object : Fcm Function : sendNotification Loop 2 Date : 15/05/2025 12:40:34 toFcmUid : d2CrUPAKTSum3Y5f6nDr8I:APA91bFORQGu64LsNMjBAKEEGjeE5-roBBLjPY7oDQIEEqintgJFL2AqLn_frGFrR8tAEPAGQ51ASrUVyUWE_PNxNkLrMf_SwQMjWmGyfTm__DLDyqEaOcGjlkEGQ6aBhu3CJRY-6Qwg Object : Fcm Function : sendNotification Date : 15/05/2025 12:40:34