Severity: Warning
Message: unlink(/tmp/ci_sessionc761c4913debd2e99dfa7bdfcf9b827ef67b90a9): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session5906017d643c925c458fb090c0c538774e3a8344): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session4a95b210961eb99477d7687b29709d0d12629494): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session477fc41682c8a987ed1e4a059b6c0a8a68b1682b): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session9c9c217a495ec11c18461f7ba4d3496b38112b62): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session52181590c51dbfd83ec6de1aa933325d1b1150e5): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session982835411fbc0a5b282777e81b3359e08e47ad63): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_sessiona0948a3a82a3b14c9bb9b13d35a7cf17054c43b3): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_sessionff21d118364bc952c66dde474ca2fd7b6d73507f): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session5e96deaee038c3ed373fc38f8f975d191ed7013a): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session8481222d221e350f2951b9e4ba2a870981077909): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session08d804ced773e537c7d199316c69f10ec9e5f7bd): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_sessiona9993a4949ee3f55c82afb7a900f10023445dd94): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session58c5ed0ac8f77502a3fe6a4e7040d441e7ca4b0d): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_sessiond53bf5354b233f1f2348287dea263d5710647236): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session8992e6b0e8d69aa2c0d6ca9ca3cdc41941ce78f9): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session6dac44bac38feba42e9e200814e229535cd84eda): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session007afdc7b08be2c0600ffcef677cee184e5adc4f): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session5752e270b70e5896a98b9d0c3961a6794099627c): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: unlink(/tmp/ci_session461a00de271374ac1d9701820ec22e67cdf97479): Operation not permitted
Filename: drivers/Session_files_driver.php
Line Number: 393
Backtrace:
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries
File: /home/pntbh/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct
File: /home/pntbh/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require
File: /home/pntbh/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/pntbh/public_html/evakip/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 565
Backtrace:
File: /home/pntbh/public_html/evakip/application/modules/evakip/models/M_monev_sakip.php
Line: 777
Function: query
File: /home/pntbh/public_html/evakip/application/modules/evakip/controllers/Evaluasi.php
Line: 252
Function: getPerkaraTepatWaktu
File: /home/pntbh/public_html/evakip/index.php
Line: 315
Function: require_once
Error Number: 1305
FUNCTION pntbh_sipp.getWeekendDays does not exist
SELECT aa.klasifikasiPerkara, aa.namaalur, SUM(CASE WHEN aa.klasifikasiPerkara in ("1","2","3","4","5","7","8","18") THEN 1 ELSE 0 END) AS totalperkara, SUM(CASE WHEN IF(aa.klasifikasiPerkara IN (8),aa.umurperkara <= 25,aa.umurperkara/30 <= 5) THEN 1 ELSE 0 END) AS totaltepatwaktu, SUM(CASE WHEN IF(aa.klasifikasiPerkara IN (8),aa.umurperkara > 25,aa.umurperkara/30 > 5) THEN 1 ELSE 0 END) AS totaltidaktepatwaktu FROM (SELECT a.klasifikasiPerkara, e.nama as namaalur, IF(a.klasifikasiPerkara IN (1,2,3,4,5,7,18), IF(c.jenisHasilMediasi IS NULL, IF(d.tglCabut IS NULL, DATEDIFF(a.tglPutusan,b.tglSidangPertama), DATEDIFF(a.tglPutusan,a.tglPendaftaran) ), DATEDIFF(a.tglPutusan, c.tglLaporan) ), IF(a.klasifikasiPerkara IN (8),IF(b.tglSidangPertama IS NOT NULL,DATEDIFF(a.tglPutusan,b.tglSidangPertama),DATEDIFF(d.tglPutusan,a.tglPendaftaran)) - getWeekendDays(b.tglSidangPertama,a.tglPutusan) - getLiburNas(b.tglSidangPertama,a.tglPutusan), DATEDIFF(a.tglPutusan, a.tglPendaftaran)) ) AS umurperkara FROM dataumumweb a LEFT JOIN sidangpertamaweb b ON a.IDPerkara=b.IDPerkara LEFT JOIN mediasiweb c ON a.IDPerkara=c.IDPerkara LEFT JOIN perkaraputusanweb d ON a.IDPerkara=d.IDPerkara LEFT JOIN alurperkaraweb e on a.klasifikasiPerkara = e.id WHERE (LEFT(a.tglPutusan, 7) >= '2025-01' AND LEFT(a.tglPutusan, 7) <= '2025-06') AND a.klasifikasiPerkara in ("1","2","3","4","5","7","8","18") ) aa group by aa.klasifikasiPerkara ;
Filename: modules/evakip/models/M_monev_sakip.php
Line Number: 777