# lhk 1
## sql 1
```
```sql
select * from FILTERDATA f
where TVUNITKERJA_KD like '16%' and PEG_NIP not in (
select PEG_NIP from NON_AKTIF dna
)
/---- AGAMA ----/
select MAGAMA_NAMA as label , jml from MS_AGAMA ma
left join (
select MAGAMA_KODE, count(*) as jml from FILTERDATA f
where TVUNITKERJA_KD like '16%' and PEG_NIP not in (
select PEG_NIP from NON_AKTIF dna
)
group by MAGAMA_KODE
) b on b.MAGAMA_KODE = ma.MAGAMA_KODE
/*--- JENIS KELAMIN */
select PEG_JNS_SEX as label, count(*) as jml from FILTERDATA f
where TVUNITKERJA_KD like '16%' and PEG_NIP not in (
select PEG_NIP from NON_AKTIF dna
)
group by PEG_JNS_SEX
/*--- PENDIDIKAN */
select MDIKFORMALALIAS, count(*) from filterdata f
join FILTER_BARU_PENDIDIKAN fbp on f.PEG_NIP = fbp.PEG_NIP
where f.TVUNITKERJA_KD like '16%' and f.PEG_NIP not in (
select PEG_NIP from NON_AKTIF dna
)
group by fbp.MDIKFORMALALIAS
-- ASAL KESATUAN
select MJENIS_NAMA , jml from MS_JENIS_PEGAWAI mjp
left join (
select MJENIS_PEG , count(*) as jml from FILTERDATA f
where f.TVUNITKERJA_KD like '16%' and f.PEG_NIP not in (
select PEG_NIP from NON_AKTIF dna
)
group by MJENIS_PEG
) b on b.MJENIS_PEG = mjp.MJENIS_PEG
```
```
writable / err logs
## 1
```
root@lhkasn-01-g1:/home/vendor/pj-dock/src/lhkan# cat writable/logs/log-2024-01*.log | grep "CRIT" | tail -n 20
CRITICAL - 2024-01-29 13:19:04 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:19:04 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:19:22 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:19:22 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:22:17 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:22:45 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-29 13:25:17 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-30 01:14:57 --> Null result @56. Plz make sure auth service is running & respond appropriately!
CRITICAL - 2024-01-30 01:15:04 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-30 01:15:20 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-30 01:15:34 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-30 01:21:29 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dataLHKASN.dbo.DATA_SPT'.
CRITICAL - 2024-01-30 06:23:17 --> Could not move file "phpOYTbTD" to "/var/www/html/public/uploads/spt/". Reason: Directive 'allow_url_include' is deprecated
CRITICAL - 2024-01-30 06:23:22 --> Could not move file "phpZxiZOQ" to "/var/www/html/public/uploads/spt/". Reason: Directive 'allow_url_include' is deprecated
CRITICAL - 2024-01-30 06:39:45 --> Could not move file "phpcUdoeo" to "/var/www/html/public/uploads/spt/". Reason: Directive 'allow_url_include' is deprecated
CRITICAL - 2024-01-30 06:42:50 --> Could not move file "php9T0zpF" to "/var/www/html/public/uploads/spt/". Reason: Directive 'track_errors' is deprecated
CRITICAL - 2024-01-30 06:42:53 --> Could not move file "phpvdrU1O" to "/var/www/html/public/uploads/spt/". Reason: Directive 'track_errors' is deprecated
CRITICAL - 2024-01-30 06:43:46 --> Could not move file "php7Mqcx2" to "/var/www/html/public/uploads/spt/". Reason: Directive 'track_errors' is deprecated
CRITICAL - 2024-01-30 06:47:20 --> Could not move file "phpGSaao5" to "/var/www/html/public/uploads/spt/". Reason: Directive 'track_errors' is deprecated
CRITICAL - 2024-01-30 06:49:06 --> Could not move file "phpuMQy2D" to "/var/www/html/public/uploads/spt/". Reason: Module 'sqlsrv' already loaded
```
## 2
```
root@lhkasn-01-g1:/home/vendor/pj-dock/src/lhkan# cat writable/logs/log-2024-02*.log | grep "CRIT" | tail -n 20
CRITICAL - 2024-02-29 07:02:05 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:02:37 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:02:39 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:02:44 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:03:37 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:03:48 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:03:54 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 07:07:07 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 08:20:58 --> Undefined index:
CRITICAL - 2024-02-29 08:21:43 --> Undefined index:
CRITICAL - 2024-02-29 08:22:11 --> Undefined index:
CRITICAL - 2024-02-29 08:23:13 --> Undefined index:
CRITICAL - 2024-02-29 08:29:15 --> Undefined index:
CRITICAL - 2024-02-29 08:29:22 --> Undefined index:
CRITICAL - 2024-02-29 08:29:32 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 08:29:40 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 08:29:45 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 08:29:52 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 08:35:27 --> Undefined index:
CRITICAL - 2024-02-29 08:35:42 --> Undefined index:
```
## err crit
```
ERROR - 2024-02-29 02:05:00 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
CRITICAL - 2024-02-29 02:05:00 --> [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type varchar to float.
in SYSTEMPATH/Database/BaseConnection.php on line 647.
1 SYSTEMPATH/Database/BaseBuilder.php(2308): CodeIgniter\Database\BaseConnection->query('INSERT INTO "dataLHKASN"."dbo"."DATA_HARTA_BERGERAK" ("JENIS_HB_ID","MEREK","MODEL","TAHUN_PEMBUATAN","NO_REGISTRASI","JENIS_BUKTI_HB_ID","NOMOR_BUKTI","ATAS_NAMA","MATA_UANG","NILAI_PEROLEHAN","NILAI_SAAT_PELAPORAN","id_laporan","status") VALUES (:JENIS_HB_ID:, :MEREK:, :MODEL:, :TAHUN_PEMBUATAN:, :NO_REGISTRASI:, :JENIS_BUKTI_HB_ID:, :NOMOR_BUKTI:, :ATAS_NAMA:, :MATA_UANG:, :NILAI_PEROLEHAN:, :NILAI_SAAT_PELAPORAN:, :id_laporan:, :status:)', [...], false)
2 APPPATH/Models/LaporanModel.php(126): CodeIgniter\Database\BaseBuilder->insert([...])
3 APPPATH/Controllers/Laporan.php(132): App\Models\LaporanModel->insert_data('DATA_HARTA_BERGERAK', [...], 'ID_DHB')
4 SYSTEMPATH/CodeIgniter.php(942): App\Controllers\Laporan->save_form('AlatTransportasi')
5 SYSTEMPATH/CodeIgniter.php(502): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Laporan))
6 SYSTEMPATH/CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false)
7 FCPATH/index.php(82): CodeIgniter\CodeIgniter->run()
```
Sign in with Wallet
Connect another wallet