2024-12-05 07:11:07 0.033147 173967 debug OUTPUT: 
2024-12-05 07:11:07 0.037731 173732 debug OUTPUT: 
2024-12-05 07:11:09 0.023388 173604 debug QUERY:SELECT a.* FROM sso_core_user a WHERE a.user_name='mario' AND a.user_password='1cbbde7b44a64c94384c3496f697425f' ROWS:1
2024-12-05 07:11:09 0.494484 173604 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'verify auth', 'success', 1) ROWS:1
2024-12-05 07:11:09 0.495562 173604 debug QUERY:INSERT INTO tbl_login_location (username, location, create_date) VALUES('mario','Jakarta, Jakarta, Indonesia', NOW()) ROWS:1
2024-12-05 07:11:09 0.011177 173834 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:09 0.012697 173834 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2024-12-05 07:11:09 0.015012 173834 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:09 0.015632 173834 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2024-12-05 07:11:09 0.015795 173834 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 07:11:09 0.016411 173834 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'view dashboard', 'success', 1) ROWS:1
2024-12-05 07:11:09 0.027973 173834 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=43) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:32
2024-12-05 07:11:09 0.051093 173834 debug QUERY:SELECT SUM(Pjh_BayarCash) as tot_bayar , SUM(Pjh_BayarTempo) as tot_sisa , SUM(Pjh_Total) as tot_total, COUNT(id) as total_order FROM tbltrans_penjualan_h WHERE YEAR(Pjh_Date) = '2024' AND MONTH(Pjh_Date) = '12' ROWS:[{"tot_bayar":null,"tot_sisa":null,"tot_total":null,"total_order":"0"}]
2024-12-05 07:11:09 0.09562 173834 debug OUTPUT: 
2024-12-05 07:11:09 0.009146 173283 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:09 0.00973 173283 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND group_id=1 ROWS:0
2024-12-05 07:11:09 0.008906 173652 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:09 0.009639 173652 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND group_id=1 ROWS:0
2024-12-05 07:11:09 0.012044 173652 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:09 0.012868 173652 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND group_id=1 ROWS:1
2024-12-05 07:11:09 0.013017 173652 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 07:11:09 0.060328 173652 debug QUERY:SELECT b.brg_name , sum(d.Pjd_Qty) as total_qty FROM tbltrans_penjualan_d d LEFT JOIN tblmaster_barang b ON b.brg_id = d.Pjd_KdBarang WHERE YEAR(d.Pjd_Date) = '2024' AND MONTH(d.Pjd_Date) = '12' GROUP BY b.brg_name ORDER BY sum(d.Pjd_Qty) DESC LIMIT 5 ROWS:[]
2024-12-05 07:11:11 0.007686 173551 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:11 0.008637 173551 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND group_id=1 ROWS:1
2024-12-05 07:11:11 0.01134 173551 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:11 0.012029 173551 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND group_id=1 ROWS:1
2024-12-05 07:11:11 0.012165 173551 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 07:11:11 0.012774 173551 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'view trans penjualan page', 'success', 1) ROWS:1
2024-12-05 07:11:11 0.019998 173551 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=43) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:32
2024-12-05 07:11:11 0.033004 173551 debug QUERY Get Supplier:SELECT code,name FROM tblmaster_customer WHERE status = 1 ROWS:349
2024-12-05 07:11:11 0.034678 173551 debug QUERY Get Master Bank:SELECT * FROM tblmaster_bank WHERE status=1 ROWS:3
2024-12-05 07:11:11 0.035506 173551 debug QUERY Get Master Vehicle:SELECT nopol FROM tblmaster_truck WHERE status=1 ROWS:8
2024-12-05 07:11:11 0.036464 173551 debug QUERY Get Master DriverHelper:SELECT nik , nama FROM tblmaster_employee WHERE jabatan = '6' AND status=1 ROWS:6
2024-12-05 07:11:11 0.036835 173551 debug QUERY Get Master DriverHelper:SELECT nik , nama FROM tblmaster_employee WHERE jabatan = '7' AND status=1 ROWS:7
2024-12-05 07:11:11 0.077618 173551 debug OUTPUT: 
2024-12-05 07:11:11 0.008104 173182 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/datagrid%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:11 0.008917 173182 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/datagrid%' AND group_id=1 ROWS:0
2024-12-05 07:11:12 -0.96963 173182 debug QUERY:SELECT a.id,a.Pjh_NoBPJ,a.Pjh_Date,b.name as nama_customer,CASE WHEN a.Pjh_Type = 1 then 'Langsung' ELSE 'Delivery' END as type_penjualan,a.Pjh_Total,a.Pjh_BayarTempo,case when a.Pjh_BayarTempo > 0 THEN 'Belum Lunas' else 'Lunas' END as sts_bayar,a.Pjh_Type,a.Pjh_Status FROM tbltrans_penjualan_h a LEFT JOIN tblmaster_customer b ON a.Pjh_KdCustomer=b.code WHERE 1=1 AND a.Pjh_Date BETWEEN CAST('2024-12-05' AS DATE) AND CAST('2024-12-31' AS DATE) ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 07:11:13 0.011384 173902 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/getNoBPB%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:13 0.012524 173902 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/getNoBPB%' AND group_id=1 ROWS:0
2024-12-05 07:11:13 0.019244 173902 debug QUERY Running Number BPB:SELECT max(pjh_nobpj) AS last FROM tbltrans_penjualan_h WHERE pjh_nobpj LIKE 'BPJ/24/12%' ROWS:1
2024-12-05 07:11:17 0.03565 173519 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:17 0.064201 173519 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND group_id=1 ROWS:0
2024-12-05 07:11:17 0.147713 173519 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST009' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 07:11:17 0.006967 173653 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND a.user_id=43 ROWS:0
2024-12-05 07:11:17 0.007715 173653 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND group_id=1 ROWS:0
2024-12-05 07:11:17 0.01337 173653 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST009' ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 07:56:18 0.014325 173635 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND a.user_id=43 ROWS:0
2024-12-05 07:56:18 0.017272 173635 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND group_id=1 ROWS:0
2024-12-05 07:56:18 0.167261 173635 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST054' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 07:56:18 0.008792 173417 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND a.user_id=43 ROWS:0
2024-12-05 07:56:18 0.009428 173417 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND group_id=1 ROWS:0
2024-12-05 07:56:18 0.014821 173417 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST054' ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 10:48:07 0.071386 173966 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST127' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 10:48:08 0.008197 173188 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(0, NOW() ,'', 'auth failed', 0) ROWS:1
2024-12-05 10:48:08 0.013593 173188 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST127' ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 10:48:08 0.032445 173231 debug OUTPUT: 
2024-12-05 11:25:46 0.064141 173673 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST023' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 11:25:46 0.008939 173254 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(0, NOW() ,'', 'auth failed', 0) ROWS:1
2024-12-05 11:25:46 0.015535 173254 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST023' ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 11:25:47 -0.96522 173995 debug OUTPUT: 
2024-12-05 17:36:23 0.037618 173261 debug OUTPUT: 
2024-12-05 17:36:24 0.028458 173525 debug OUTPUT: 
2024-12-05 17:36:25 0.01212 173812 debug QUERY:SELECT a.* FROM sso_core_user a WHERE a.user_name='mario' AND a.user_password='1cbbde7b44a64c94384c3496f697425f' ROWS:1
2024-12-05 17:36:25 0.478609 173812 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'verify auth', 'success', 1) ROWS:1
2024-12-05 17:36:25 0.479849 173812 debug QUERY:INSERT INTO tbl_login_location (username, location, create_date) VALUES('mario','Jakarta, Jakarta, Indonesia', NOW()) ROWS:1
2024-12-05 17:36:25 0.011591 173564 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:25 0.013852 173564 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2024-12-05 17:36:25 0.016562 173564 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:25 0.017197 173564 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2024-12-05 17:36:25 0.017381 173564 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 17:36:25 0.018041 173564 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'view dashboard', 'success', 1) ROWS:1
2024-12-05 17:36:25 0.025762 173564 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=43) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:32
2024-12-05 17:36:25 0.044096 173564 debug QUERY:SELECT SUM(Pjh_BayarCash) as tot_bayar , SUM(Pjh_BayarTempo) as tot_sisa , SUM(Pjh_Total) as tot_total, COUNT(id) as total_order FROM tbltrans_penjualan_h WHERE YEAR(Pjh_Date) = '2024' AND MONTH(Pjh_Date) = '12' ROWS:[{"tot_bayar":null,"tot_sisa":null,"tot_total":null,"total_order":"0"}]
2024-12-05 17:36:26 -0.91599 173564 debug OUTPUT: 
2024-12-05 17:36:26 0.008998 173795 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:26 0.009859 173795 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND group_id=1 ROWS:0
2024-12-05 17:36:26 0.013923 173205 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:26 0.014842 173205 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND group_id=1 ROWS:0
2024-12-05 17:36:26 0.01758 173205 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:26 0.01851 173205 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND group_id=1 ROWS:1
2024-12-05 17:36:26 0.01868 173205 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 17:36:26 0.06488 173205 debug QUERY:SELECT b.brg_name , sum(d.Pjd_Qty) as total_qty FROM tbltrans_penjualan_d d LEFT JOIN tblmaster_barang b ON b.brg_id = d.Pjd_KdBarang WHERE YEAR(d.Pjd_Date) = '2024' AND MONTH(d.Pjd_Date) = '12' GROUP BY b.brg_name ORDER BY sum(d.Pjd_Qty) DESC LIMIT 5 ROWS:[]
2024-12-05 17:36:28 0.008731 173847 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:28 0.009992 173847 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND group_id=1 ROWS:1
2024-12-05 17:36:28 0.012535 173847 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:28 0.013195 173847 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan%' AND group_id=1 ROWS:1
2024-12-05 17:36:28 0.013382 173847 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2024-12-05 17:36:28 0.014065 173847 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(43, NOW() ,'view trans penjualan page', 'success', 1) ROWS:1
2024-12-05 17:36:28 0.021516 173847 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=43) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:32
2024-12-05 17:36:28 0.031444 173847 debug QUERY Get Supplier:SELECT code,name FROM tblmaster_customer WHERE status = 1 ROWS:349
2024-12-05 17:36:28 0.033076 173847 debug QUERY Get Master Bank:SELECT * FROM tblmaster_bank WHERE status=1 ROWS:3
2024-12-05 17:36:28 0.034062 173847 debug QUERY Get Master Vehicle:SELECT nopol FROM tblmaster_truck WHERE status=1 ROWS:8
2024-12-05 17:36:28 0.035176 173847 debug QUERY Get Master DriverHelper:SELECT nik , nama FROM tblmaster_employee WHERE jabatan = '6' AND status=1 ROWS:6
2024-12-05 17:36:28 0.03567 173847 debug QUERY Get Master DriverHelper:SELECT nik , nama FROM tblmaster_employee WHERE jabatan = '7' AND status=1 ROWS:7
2024-12-05 17:36:28 0.087021 173847 debug OUTPUT: 
2024-12-05 17:36:28 0.009088 173468 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/datagrid%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:28 0.00993 173468 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/datagrid%' AND group_id=1 ROWS:0
2024-12-05 17:36:28 0.02762 173468 debug QUERY:SELECT a.id,a.Pjh_NoBPJ,a.Pjh_Date,b.name as nama_customer,CASE WHEN a.Pjh_Type = 1 then 'Langsung' ELSE 'Delivery' END as type_penjualan,a.Pjh_Total,a.Pjh_BayarTempo,case when a.Pjh_BayarTempo > 0 THEN 'Belum Lunas' else 'Lunas' END as sts_bayar,a.Pjh_Type,a.Pjh_Status FROM tbltrans_penjualan_h a LEFT JOIN tblmaster_customer b ON a.Pjh_KdCustomer=b.code WHERE 1=1 AND a.Pjh_Date BETWEEN CAST('2024-12-05' AS DATE) AND CAST('2024-12-31' AS DATE) ORDER BY a.id desc LIMIT 0,10 ROWS:0
2024-12-05 17:36:29 0.01093 173813 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/getNoBPB%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:29 0.011708 173813 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/getNoBPB%' AND group_id=1 ROWS:0
2024-12-05 17:36:29 0.017496 173813 debug QUERY Running Number BPB:SELECT max(pjh_nobpj) AS last FROM tbltrans_penjualan_h WHERE pjh_nobpj LIKE 'BPJ/24/12%' ROWS:1
2024-12-05 17:36:35 0.010619 173822 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:35 0.011981 173822 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND group_id=1 ROWS:0
2024-12-05 17:36:35 0.091436 173822 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST021' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 17:36:35 0.007629 173109 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND a.user_id=43 ROWS:0
2024-12-05 17:36:35 0.008333 173109 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND group_id=1 ROWS:0
2024-12-05 17:36:35 0.014005 173109 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST021' ORDER BY a.id desc LIMIT 0,10 ROWS:1
2024-12-05 17:36:35 0.014677 173109 debug QUERY:SELECT count(a.pjtemp_kdbarang) totRecord, sum(a.pjtemp_subtotal) as total_order FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST021' ROWS:1
2024-12-05 17:39:19 0.011087 173722 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND a.user_id=43 ROWS:0
2024-12-05 17:39:19 0.01249 173722 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/ListBarang%' AND group_id=1 ROWS:0
2024-12-05 17:39:19 0.066037 173722 debug QUERY Get Produkv2:SELECT a.brg_id , b.brg_name , a.harga_jual, b.hpp as harga_beli FROM tblbarang_customer a LEFT JOIN tblmaster_barang b ON b.brg_id = a.brg_id WHERE a.cust_id = 'CST049' ORDER BY a.brg_id ASC ROWS:173
2024-12-05 17:39:19 0.009043 173425 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND a.user_id=43 ROWS:0
2024-12-05 17:39:19 0.009805 173425 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%trans/penjualan/gridso%' AND group_id=1 ROWS:0
2024-12-05 17:39:19 0.015122 173425 debug QUERY:SELECT a.id,a.pjtemp_kdbarang,b.brg_name,a.pjtemp_hrgbeli,a.pjtemp_hrgjual,a.pjtemp_qty,a.pjtemp_discount_rp,a.pjtemp_subtotal,a.create_date FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST049' ORDER BY a.id desc LIMIT 0,10 ROWS:1
2024-12-05 17:39:19 0.015794 173425 debug QUERY:SELECT count(a.pjtemp_kdbarang) totRecord, sum(a.pjtemp_subtotal) as total_order FROM tbltemp_penjualan a INNER JOIN tblmaster_barang b ON a.pjtemp_kdbarang=b.brg_id WHERE a.pjtemp_kdcustomer = 'CST049' ROWS:1