You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
662 lines
59 KiB
662 lines
59 KiB
11 months ago
|
CRITICAL - 2024-04-21 11:34:19 --> ErrorException: Undefined variable $totwpsof
|
||
|
|
in APPPATH\Views\kanwil\vseksiar.php on line 1481.
|
||
|
|
1 APPPATH\Views\kanwil\vseksiar.php(1481): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined variable $totwpsof', 'C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\vseksiar.php', 1481)
|
||
|
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\vseksiar.php')
|
||
|
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}()
|
||
|
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/vseksiar', [], true)
|
||
|
|
5 APPPATH\Controllers\Seksiar.php(85): view('kanwil/vseksiar', [...])
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Seksiar->index()
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Seksiar))
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
ERROR - 2024-04-21 16:04:55 --> ErrorException: oci_execute(): ORA-00942: table or view does not exist in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199
|
||
|
|
Stack trace:
|
||
|
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199)
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #171, 32)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...')
|
||
|
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#10 {main}
|
||
|
|
CRITICAL - 2024-04-21 16:04:55 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\BaseConnection.php on line 647.
|
||
|
|
1 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:04:55 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211.
|
||
|
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
3 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:04:55 --> [Caused by] ErrorException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00942: table or view does not exist', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199)
|
||
|
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32)
|
||
|
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
5 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
INFO - 2024-04-21 16:05:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
ERROR - 2024-04-21 16:05:27 --> ErrorException: oci_execute(): ORA-00942: table or view does not exist in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199
|
||
|
|
Stack trace:
|
||
|
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199)
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #191, 32)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...')
|
||
|
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#10 {main}
|
||
|
|
CRITICAL - 2024-04-21 16:05:27 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\BaseConnection.php on line 647.
|
||
|
|
1 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:05:27 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211.
|
||
|
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
3 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:05:27 --> [Caused by] ErrorException: oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00942: table or view does not exist', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199)
|
||
|
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32)
|
||
|
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
5 APPPATH\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_WP_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:05:27 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33
|
||
|
|
Stack trace:
|
||
|
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include()
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}()
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(CodeIgniter\Database\Exceptions\DatabaseException), 500, 'C:\\xampp\\htdocs...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(157): CodeIgniter\Debug\ExceptionHandler->handle(Object(CodeIgniter\Database\Exceptions\DatabaseException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 8)
|
||
|
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(CodeIgniter\Database\Exceptions\DatabaseException))
|
||
|
|
#5 {main}
|
||
|
|
thrown
|
||
|
|
【Previous Exception】
|
||
|
|
CodeIgniter\Database\Exceptions\DatabaseException
|
||
|
|
oci_execute(): ORA-00942: table or view does not exist
|
||
|
|
#0 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(379): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#1 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#4 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#5 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#6 {main}
|
||
|
|
in APPPATH\Views\errors\html\error_exception.php on line 33.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
||
|
|
INFO - 2024-04-21 16:06:11 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:06:13 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
CRITICAL - 2024-04-21 16:06:13 --> CodeIgniter\HTTP\Exceptions\HTTPException: Request URI segment is out of range: "9"
|
||
|
|
in SYSTEMPATH\HTTP\URI.php on line 562.
|
||
|
|
1 SYSTEMPATH\HTTP\URI.php(562): CodeIgniter\HTTP\Exceptions\HTTPException::forURISegmentOutOfRange(9)
|
||
|
|
2 APPPATH\Controllers\Home.php(214): CodeIgniter\HTTP\URI->getSegment(9)
|
||
|
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->grafMAPKJS('170', 'SEMUA', 'SEMUA', 'SEMUA', '2024')
|
||
|
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
INFO - 2024-04-21 16:06:43 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:06:49 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:45:44 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
ERROR - 2024-04-21 16:45:44 --> ErrorException: oci_execute(): ORA-00904: "KD_MAP": invalid identifier in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199
|
||
|
|
Stack trace:
|
||
|
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199)
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #192, 32)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...')
|
||
|
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#10 {main}
|
||
|
|
CRITICAL - 2024-04-21 16:45:44 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "KD_MAP": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\BaseConnection.php on line 647.
|
||
|
|
1 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:45:44 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "KD_MAP": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211.
|
||
|
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
3 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:45:44 --> [Caused by] ErrorException: oci_execute(): ORA-00904: "KD_MAP": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00904: "KD_MAP": invalid identifier', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199)
|
||
|
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32)
|
||
|
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
5 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\' ) POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KPPADM = \'509\' AND KODESIE = \'01\' AND NIP = \'060107302\' AND KD_MAP = \'411121\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:45:44 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33
|
||
|
|
Stack trace:
|
||
|
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include()
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}()
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(CodeIgniter\Database\Exceptions\DatabaseException), 500, 'C:\\xampp\\htdocs...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(157): CodeIgniter\Debug\ExceptionHandler->handle(Object(CodeIgniter\Database\Exceptions\DatabaseException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 8)
|
||
|
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(CodeIgniter\Database\Exceptions\DatabaseException))
|
||
|
|
#5 {main}
|
||
|
|
thrown
|
||
|
|
【Previous Exception】
|
||
|
|
CodeIgniter\Database\Exceptions\DatabaseException
|
||
|
|
oci_execute(): ORA-00904: "KD_MAP": invalid identifier
|
||
|
|
#0 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#1 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#4 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#5 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#6 {main}
|
||
|
|
in APPPATH\Views\errors\html\error_exception.php on line 33.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
||
|
|
INFO - 2024-04-21 16:56:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
CRITICAL - 2024-04-21 16:56:59 --> ErrorException: Undefined property: stdClass::$WPBYRN
|
||
|
|
in APPPATH\Views\ppm\gmapkjs.php on line 221.
|
||
|
|
1 APPPATH\Views\ppm\gmapkjs.php(221): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined property: stdClass::$WPBYRN', 'C:\\xampp\\htdocs\\engineN\\app\\Views\\ppm\\gmapkjs.php', 221)
|
||
|
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\ppm\\gmapkjs.php')
|
||
|
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}()
|
||
|
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('ppm/gmapkjs', [], true)
|
||
|
|
5 APPPATH\Controllers\Home.php(195): view('ppm/gmapkjs', [...])
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 16:56:59 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33
|
||
|
|
Stack trace:
|
||
|
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include()
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}()
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(ErrorException), 500, 'C:\\xampp\\htdocs...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(157): CodeIgniter\Debug\ExceptionHandler->handle(Object(ErrorException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 1)
|
||
|
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(ErrorException))
|
||
|
|
#5 {main}
|
||
|
|
thrown
|
||
|
|
【Previous Exception】
|
||
|
|
ErrorException
|
||
|
|
Undefined property: stdClass::$WPBYRN
|
||
|
|
#0 C:\xampp\htdocs\engineN\app\Views\ppm\gmapkjs.php(221): CodeIgniter\Debug\Exceptions->errorHandler(2, 'Undefined prope...', 'C:\\xampp\\htdocs...', 221)
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\View\View.php(228): include('C:\\xampp\\htdocs...')
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}()
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Common.php(1178): CodeIgniter\View\View->render('ppm/gmapkjs', Array, true)
|
||
|
|
#4 C:\xampp\htdocs\engineN\app\Controllers\Home.php(195): view('ppm/gmapkjs', Array)
|
||
|
|
#5 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#8 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#9 {main}
|
||
|
|
in APPPATH\Views\errors\html\error_exception.php on line 33.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
||
|
|
INFO - 2024-04-21 16:57:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:57:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:58:14 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:58:32 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 16:59:42 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:00:00 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:02:40 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
CRITICAL - 2024-04-21 17:04:41 --> ErrorException: Maximum execution time of 120 seconds exceeded
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
||
|
|
INFO - 2024-04-21 17:07:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:08:12 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:08:31 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:09:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
ERROR - 2024-04-21 17:09:16 --> ErrorException: oci_execute(): ORA-00904: "KJS": invalid identifier in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199
|
||
|
|
Stack trace:
|
||
|
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199)
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #191, 32)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...')
|
||
|
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#10 {main}
|
||
|
|
CRITICAL - 2024-04-21 17:09:16 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "KJS": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\BaseConnection.php on line 647.
|
||
|
|
1 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 17:09:16 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00904: "KJS": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211.
|
||
|
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
3 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 17:09:16 --> [Caused by] ErrorException: oci_execute(): ORA-00904: "KJS": invalid identifier
|
||
|
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00904: "KJS": invalid identifier', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199)
|
||
|
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32)
|
||
|
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
5 APPPATH\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT
|
||
|
|
BLNBYR,
|
||
|
|
(SELECT COUNT(1)POPULASI FROM KEWAJIBAN_FLAG
|
||
|
|
WHERE NPWP IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\') POPULASI,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW,
|
||
|
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST
|
||
|
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS
|
||
|
|
WHERE BLNBYR IS NOT NULL AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\'
|
||
|
|
GROUP BY NPWP,THNBYR,BLNBYR
|
||
|
|
)
|
||
|
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC
|
||
|
|
')
|
||
|
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...])
|
||
|
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
|
||
|
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
CRITICAL - 2024-04-21 17:09:16 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33
|
||
|
|
Stack trace:
|
||
|
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include()
|
||
|
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}()
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(CodeIgniter\Database\Exceptions\DatabaseException), 500, 'C:\\xampp\\htdocs...')
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(157): CodeIgniter\Debug\ExceptionHandler->handle(Object(CodeIgniter\Database\Exceptions\DatabaseException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 8)
|
||
|
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(CodeIgniter\Database\Exceptions\DatabaseException))
|
||
|
|
#5 {main}
|
||
|
|
thrown
|
||
|
|
【Previous Exception】
|
||
|
|
CodeIgniter\Database\Exceptions\DatabaseException
|
||
|
|
oci_execute(): ORA-00904: "KJS": invalid identifier
|
||
|
|
#0 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(380): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...')
|
||
|
|
#1 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array)
|
||
|
|
#2 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs()
|
||
|
|
#3 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home))
|
||
|
|
#4 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
|
||
|
|
#5 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run()
|
||
|
|
#6 {main}
|
||
|
|
in APPPATH\Views\errors\html\error_exception.php on line 33.
|
||
|
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
||
|
|
INFO - 2024-04-21 17:09:18 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:19:56 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:20:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:21:33 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:21:59 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:33:22 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:33:39 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:43:05 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:43:26 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:44:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:45:10 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:47:29 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:47:45 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:52:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|
||
|
|
INFO - 2024-04-21 17:52:25 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver.
|