A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_session8dc2cd11c028dff744d7c259f966e93524279266): 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_sessionc4d4a55919a48771c56643d94fceb7f07e00883c): 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_sessione6ccb0277a9b659216ce603e2cf849b0a975ae0b): 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_session9d6b7a6ea4913e6b8d65cd93ad051870b829ace1): 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_session44b14e19fe0a7df983e76c43147af133b7fe7c48): 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_sessione159e7a342c329e92e4f2e0043a625ea5cab9355): 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_session1d24cc45a31f2efc5e983f988e83ec6429d7589b): 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_session8d710db5473d6a9a799bac9b91488b22d0bc0457): 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_session648a42d641fd3ffaecf54857177d7e38aefad587): 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_sessione627dcad9b9e6fe52c91582a194761dd319756a2): 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_sessionc26c03bc5905d4c0b614032bb4cf4e0901ff9a29): 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_session125e403a560fbe4164146202393a946378ea566e): 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_sessionbc2514ff850bb911c1ec4cc0e7aa72ff8aa9a7c2): 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_sessionea962159c4f225f1a91b58bcab03da8ca7a1c367): 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_session14d3a1400102cf3a73caa39b839fb0dedc907587): 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_session932f7d52116998e9916d48e4a87c96841d90704b): 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_sessioneb139e7aff88408ff8ff28d6059a25e1a0788507): 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_sessionf295545558cb072f4bb5b8dc7b02c29bb74726e9): 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_session3f55736c0989fa7441cc576fcac8efe073be9296): 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