A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session5f0a8c8ed2f83f942b24b5734dd5bf254152d987): 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_session4d63a402a23498e5db7f62a97c57ffed8a649676): 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_session0ed75691cdd8606e86362450f6b1d89a73cab2d6): 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_sessiond4d9cf271c52ba674668f32ebac7e36dd576a10c): 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_sessiona96d1aa90acadd65780355a6560febc2e62aa7fc): 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_session461bab45f9bed3c960b48a939a81c80ec93007d9): 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_session66e9ef9abd0fd516814b8a27ce12678f609848f5): 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_session9d63e4271260d78bde95859f324b82ec5e5cebbf): 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_session5092d2d94c91f8203763e88f41f10d8c75de5b7b): 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_session36a4332dde0212018a8af3dcd35edccfad4dc789): 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_session37755ba938f96937d02762be510a54a19faa2fe4): 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_session3bbe18bcdee969c11a625a0e9977cd117e2ffad1): 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_session933d381e7e8aaa3ee1546faa0f4073c317b6dd16): 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_session0921da532beeb0ae901d0f4d311eef8418d07e15): 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_session377f8530854661ce50f2141ffe1534bf790f8369): 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_session7f0f0c2750f8d71c7bbfb435ee3a2d7a2c85d922): 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_sessiond10ab8d1be8ac4e025dd2ba78c287f00f737d612): 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_session517abd4d0c9ea4c2da8394dd6a641698ead2e0e4): 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_session4fda8e74ecd74796b82146ef56538637cb4b7732): 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