A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessionf7bbf2585c40b19cb7559eeb5366066e7066be04): 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_sessioncd8aca1e58257f5b93ef1263477560efd36b7e86): 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_session1b76e11cbce85bedf4c8566532c6372057c095c7): 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_sessiona4f57878472a409503ee1334039ed5d56356ac50): 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_session985b7058f26073d5b21339e6d2445c40f1d64484): 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_session12966f307eca0c6fc8db11bcdd96dfba914935ee): 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_session98bc048de326b301d3b52ffec1584ddad9924c85): 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_session035a7c976bcca38d61cb0eb78a6c64d6d7516a06): 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_session0011d518059dc4e618020e54fb1e9c81b800ed6c): 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_session1a01c3dd2e5c57ec96821c1a23c10bbbb06773f2): 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_session45b07993b090a230e2531874024a5de6e34b1c11): 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_sessioncb2c2efe2a86c58c2221a1f14e44649826914369): 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_sessione1ec342ab51fca25f2f8bc592910bb093245060c): 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_sessione805582670c282afc8495b706206367c7fa5691e): 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_sessione7be3d5e5fac9c5a7475e59111ad38ffca87d3e4): 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_sessionf9a5f790fd0581747b87a8698f9aa03b244a40ba): 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_session5539d6d315157040dd40bdd92b3b218e66bb3c38): 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_session8a8e8bb6833c0ae60b2dc7adfa9b2e4d2e284d43): 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_session40294addeb7837fc6368583f01e211a2814dcdcb): 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-07') 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