A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session2c59bfc6b16c681424d57d3c5017b054cc9635ce): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session913daacec7362daa6b5b00f564ffefd606c25cb2): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session7a64b77c295cb94419cb4efb6a07e62978cd368b): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session1fa791c808d3d03d20f59476a87acae7b836fc3f): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessiond881e0888cee473a1cb0318ef4c5e39299af249e): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessionec5abed79554128ac99c04f8f932e7d34fac6fcc): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessiond35171c045ecfdf0d74fb3583563a92af9f37f16): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessiond529978b67c2a181501af217d65ca85f7ac18b61): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session9ed6b275b2daa356bf31e66bc4cbbad21414b96a): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session82a27cda0845904824da3019166f89adc6983d39): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session03c3f5bd9ce7a8ae7bda81ecc9124acb6416d361): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session826c14612bedddfd5c51fe7e46a225023ad3e5ba): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session6f6310b03d398e3963b9485bb32ee37907318fdb): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessionf8f4cf14d4d638fcad705d2a40178d4b3380a73b): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessiond00508c1946a02d389f59c012f3de9310e043803): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session85c5039388dbec051ee29412563364959b3de8a1): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessionbb749929460e16aee0f2c0a9ddff9f40b889e28e): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session91a9263ab9a560a3c3952c9b34e0a404939c67df): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session94f234d73504084f63ba4878656f7beb718e94d9): Operation not permitted

Filename: drivers/Session_files_driver.php

Line Number: 393

Backtrace:

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 173
Function: _ci_load_library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 192
Function: library

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 153
Function: libraries

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Loader.php
Line: 65
Function: initialize

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 55
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Base.php
Line: 60
Function: __construct

File: /home/pnsiak/public_html/evakip/application/third_party/MX/Controller.php
Line: 4
Function: require

File: /home/pnsiak/public_html/evakip/application/core/MY_Controller.php
Line: 7
Function: require

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/pnsiak/public_html/evakip/system/core/Exceptions.php:272)

Filename: core/Common.php

Line Number: 565

Backtrace:

File: /home/pnsiak/public_html/evakip/application/modules/evakip/models/M_monev_sakip.php
Line: 777
Function: query

File: /home/pnsiak/public_html/evakip/application/modules/evakip/controllers/Evaluasi.php
Line: 252
Function: getPerkaraTepatWaktu

File: /home/pnsiak/public_html/evakip/index.php
Line: 315
Function: require_once

A Database Error Occurred

Error Number: 1305

FUNCTION pnsiak_sipp1.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