A PHP Error was encountered

Severity: Warning

Message: unlink(/tmp/ci_sessione92419110b58d48aec64fa2fb4d7a09cd5181f3c): 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_session5365a467c54870c53ff9872d0d69bb995a37f2b9): 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_session192c4fea43546ff7c6662d97174cdf78d370c933): 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_session19c843dc418ba49fc329369dea40a58575b6475f): 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_sessionf75b3931e32b06f02f3cb29d2fe6c40ae8547af2): 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_session4346243640a61d831ba6f074cd433d9e2fd99113): 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_session634b060aae32709b23f7081e98d505b31946b5d8): 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_session38496a345befe747b46a565ad209d7e21647f92c): 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_sessiona4be9cd449139ad67d635105c845cbab0922ac2e): 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_session67afe952be4d74c44e58f91800a9dda0adbf036e): 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_session26e3de457c62cbb2b4861db404f65f6046fc7eff): 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_session5dd45405dd9f3d0a22e6bb1f29ffe35fc345173a): 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_sessiona9a96526c76da46db65d08b08b488d4abf7f2194): 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_session22a8fad3290510ca2a3b8e2b5e6fee6b4e08f899): 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_session7afab31fabc906d9cacedd9dd3ebcf9490a603cc): 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_session9daea73632a22c55623657ea2eda8c453f6b0c8e): 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_sessione80e6d703debbf6dbe770b115e6151319602532c): 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_sessione9583178e78187c570884dc0457fd460f78fbc9f): 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_session8aa0f44fd63ff6318c0365cbc1d3ea830d5c3080): 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