Compare commits
29 Commits
feat/uploa
...
feat/recre
| Author | SHA1 | Date | |
|---|---|---|---|
|
59cc102c5a | ||
|
|
df70a47bd1 | ||
|
|
e71dd7d213 | ||
|
|
f2eb998ac5 | ||
|
|
fc54e20fa4 | ||
|
|
6946fa7074 | ||
|
|
236b6f9bfc | ||
|
|
285ff46c2b | ||
|
|
a8b02afad9 | ||
|
|
a0666e78d2 | ||
|
|
799e409ce2 | ||
|
|
780ba60224 | ||
|
|
baed8cc487 | ||
|
|
e17f5beaf0 | ||
|
|
766e1a430c | ||
|
|
6677c320fc | ||
|
|
9437eb949f | ||
|
|
6f77120c33 | ||
|
|
f8d0573e5c | ||
|
|
ca74d0143f | ||
|
|
34e082c31b | ||
|
|
c4d865bf2b | ||
|
|
a103b38265 | ||
|
|
9aa3d32b6e | ||
|
|
99e2c214b6 | ||
|
|
501a76bc81 | ||
|
|
460267992e | ||
|
|
becc368069 | ||
|
|
2618ac06d0 |
0
.editorconfig
Executable file → Normal file
0
.editorconfig
Executable file → Normal file
0
.env.example
Executable file → Normal file
0
.env.example
Executable file → Normal file
76
.env.local.backup
Normal file
76
.env.local.backup
Normal file
@@ -0,0 +1,76 @@
|
||||
APP_NAME=SIBEDAS-PBG
|
||||
APP_ENV=local
|
||||
APP_KEY=base64:xqCpwixWKqgu1Ca22gFizoOt44p7h+cgTOKuhS/P0Jw=
|
||||
APP_DEBUG=true
|
||||
APP_TIMEZONE=Asia/Jakarta
|
||||
APP_URL=http://localhost:8000
|
||||
|
||||
API_URL=http://localhost:8000
|
||||
|
||||
APP_LOCALE=en
|
||||
APP_FALLBACK_LOCALE=en
|
||||
APP_FAKER_LOCALE=en_US
|
||||
|
||||
APP_MAINTENANCE_DRIVER=file
|
||||
# APP_MAINTENANCE_STORE=database
|
||||
|
||||
PHP_CLI_SERVER_WORKERS=4
|
||||
|
||||
BCRYPT_ROUNDS=12
|
||||
|
||||
LOG_CHANNEL=stack
|
||||
LOG_STACK=single
|
||||
LOG_DEPRECATIONS_CHANNEL=null
|
||||
LOG_LEVEL=debug
|
||||
|
||||
DB_CONNECTION=mariadb
|
||||
DB_HOST=db
|
||||
DB_PORT=3306
|
||||
DB_DATABASE=sibedas_db
|
||||
DB_USERNAME=root
|
||||
DB_PASSWORD=root
|
||||
|
||||
SESSION_DRIVER=database
|
||||
SESSION_LIFETIME=120
|
||||
SESSION_ENCRYPT=false
|
||||
SESSION_PATH=/
|
||||
SESSION_DOMAIN=null
|
||||
|
||||
BROADCAST_CONNECTION=log
|
||||
FILESYSTEM_DISK=local
|
||||
QUEUE_CONNECTION=database
|
||||
|
||||
CACHE_STORE=database
|
||||
CACHE_PREFIX=
|
||||
|
||||
MEMCACHED_HOST=127.0.0.1
|
||||
|
||||
REDIS_CLIENT=phpredis
|
||||
REDIS_HOST=127.0.0.1
|
||||
REDIS_PASSWORD=null
|
||||
REDIS_PORT=6379
|
||||
|
||||
MAIL_MAILER=log
|
||||
MAIL_HOST=127.0.0.1
|
||||
MAIL_PORT=2525
|
||||
MAIL_USERNAME=null
|
||||
MAIL_PASSWORD=null
|
||||
MAIL_ENCRYPTION=null
|
||||
MAIL_FROM_ADDRESS="hello@example.com"
|
||||
MAIL_FROM_NAME="${APP_NAME}"
|
||||
|
||||
AWS_ACCESS_KEY_ID=
|
||||
AWS_SECRET_ACCESS_KEY=
|
||||
AWS_DEFAULT_REGION=us-east-1
|
||||
AWS_BUCKET=
|
||||
AWS_USE_PATH_STYLE_ENDPOINT=false
|
||||
|
||||
VITE_APP_NAME="${APP_NAME}"
|
||||
|
||||
SIMBG_HOST="https://simbg.pu.go.id/"
|
||||
SIMBG_EMAIL="dputr@bandungkab.go.id"
|
||||
SIMBG_PASSWORD="Simbg123"
|
||||
|
||||
API_KEY_GOOGLE="AIzaSyBxfEShFkKmykkc7RJR3lVzkQ_xGHK3qr0"
|
||||
SPREAD_SHEET_ID="1QoXzuLdEX3MK70Yrfigz0Qj5rAt4T819jX85vubBNdY"
|
||||
OPENAI_API_KEY="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"
|
||||
0
.gitattributes
vendored
Executable file → Normal file
0
.gitattributes
vendored
Executable file → Normal file
0
.gitignore
vendored
Executable file → Normal file
0
.gitignore
vendored
Executable file → Normal file
42
Data_2025___Estimasi_Jumlah_Lantai.csv
Executable file
42
Data_2025___Estimasi_Jumlah_Lantai.csv
Executable file
@@ -0,0 +1,42 @@
|
||||
no,pemohon,alamat,activities,luas_lahan,bcr_kawasan,area,no_tapak,no_skkl,no_ukl,fungsi_bangunan,sub_fungsi_bangunan,jumlah_lantai
|
||||
01/222,PT CIPTA INDAH PERTIWI No Telpon : 082217633434,Jl Salam No 51 Desa/Kel. Cihapit Kec. Bandung wetan Kota Bandung,PERUMAHAN LA LA TOWN,16629,0.2449,4072.4421,648.11./222 - SP /TR 07 Januari 2025;644.2./207 - SP /TR 02 Januari 2025,500.10.29.15/631-REKTEK/TR Tanggal 14 Februari 2023;500.10.29.15/2837-REKTEK/Bid. Taru Tanggal 25 Juli 2024,14022310313204030 Tanggal 14 Februari 2023;500.10.29.7/Kep.618-DLH/2024 Tanggal 13 Desember 2024;161023087545 Tanggal 16 Oktober2023,Fungsi Hunian,Fungsi Hunian,1
|
||||
03/481,MUHAMAD GUNTUR JULIADI No Telpon : 081223334486,Cangkuang Residence RT 004/003 Ds Cangkuang Wetan Kec. Dayeuhkolot Kab. Bandung,PERUMAHAN CANGKUANG RESIDENCE 2,2360,0.5924,1398.064,648.11./481 - SP /TR 15 Januari 2025;647./226 - SP /TR 07 Januari 2025;647/225 - SP /TR 07 Januari 2025;644/221 - SP /TR 07 Januari 2025;645.4/557 - SP /TR 20 Januari 2025,500.10.29.15/2894-REKTEK/Bid. Taru Tanggal 08 Agustus 2024;400.7.22/4927-KRK/04/Bid.Taru Tanggal 06 Desember 2024;500.10.29.15/2619-REKTEK/Bid. Taru Tanggal 10 Juli 2024;500.10.29.15/4155-REKTEK/Bid. Taru Tanggal 18 Nopember 2024;503/123/III-DPMPTSP/2020 Tanggal 24 MAret 2020,167240099471 Tanggal 16 Juli 2024;9120111161314 Tanggal 11 Nopember 2019;8120312190151 Tanggal 04 Desember 2023;500.10.29.7/Kep.614-DLH/2024 Tanggal 20 Nopember 2024;2910240290118 Tanggal 29 Oktober 2024;8120001992981 Tanggal 12 Juli 2024;SK.294/Menlhk/Setjen/PLA.4/5/2021 Tanggal 31 Mei 2021,Fungsi Hunian,Fungsi Hunian,1
|
||||
08/480,PT SURYA KHARISMA PARAHYANGAN No Telpon : 081394461006 ,Jalan Cibaligo No 48 Desa /Kel. Cigugur tengah Kec. Cimahi tengah kota Cimahi ,PERUMAHAN PARAHYANGAN GARDEN CITY,116360,0.5164,60088.304,648.11./480 - SP /TR 15 Januari 2025,500.10.29.15/603-REKTEK/TR Tanggal 05 Desember 2023,1810220245722 Tanggal 18 Oktober 2022;500.10.29.7/Kep.632-DLH/2024 Tanggal 24 Desember 2024,Fungsi Hunian,Fungsi Hunian,2
|
||||
09/223,PT CLARICHEM INDONESIA No Telpon : 081315399694,Kawasan pergudangan taman tekno sektor XI blok L2 No 30 Ds/Kel. Setu Kec. Setu kota Tangerag Banten ,PERGUDANGAN DAN PENYIMPANAN,1586,0.7017,1112.8962,644./223 - SP /TR 07 Januari 2025,400.7.22/4427-KRK/03/Bid.Taru Tanggal 06 Desember 2024,9120008832767 Tanggal 26 Nopember 2024,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
10/657,PT HALKA GITA No Telpon : 0816734374,Jl Raya Majalaya KM 2 RT 02/09 Desa Hegarmanah Kec. Cikancung Kab. Bandung,REVISI 1 KOMPLEK PERGUDANGAN,19100,0.699,13350.9,644./657 - SP /TR 23 Januari 2025,500.10.29.15/6750-REKTEK/TR Tanggal 21 Desember 2023,9120300510839 Tanggal 16 Desember 2023;500.10.29.7/Kep.609-DLH/2024 Tanggal 12 Nopember 2024,Usaha Besar (Non-Mikro),Fungsi Usaha,2
|
||||
11/658,PT SURYA TIRTA KENCANA No Telpon : 08986155493,Kutawaringin Industrial Park Kav. 276-277 Desa Jelegong Kec. Kutawaringin Kab. Bandung,PERGUDANGAN DAN PENYIMPANAN BAHAN KIMIA,3932,0.6995,2750.434,644./658 - SP /TR 23 Januari 2025;640/540 - SP /TR 20 Januari 2025,10112410113204010 Tanggal 10 Nopember 2024;591.4/031/IX-DPMPTSP/2020 Tanggal 03 Sseptember 2020,8120017120594 Tanggal 31 Agustus 2018;600.4.5/056/6838-Ktr/TL Tanggal 24 Desember 2024;0220305221438 Tanggal 20 Nopember 2021;500.10.29.7/4295/TL Tanggal 21 September 2024,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
13 / 550,PT BERKAH SEPUH JAYA No Telpon : 082118781624,Ruko komplek dewaadru blok R3 RT 005 ds/kec. Bojongsoang kab. Bandung,REVISI 1 PERUMAHAN VILLA CEMARA ASRI,17379,0.5476,9516.7404,648.11/550 - SP/TR 20 Januari 2025,150223101113204049 Tanggal 15 Februari 2023,1233000451657 Tanggal 5 Mei 2023;500.10.29.7/kep.392-DLH/2025 Tgl. 2 Januari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
14 / 655,PT RISKI ANUGERAH SEDJAHTERA No Telpon : 082118781624,Griya permata asri blok C2 No 18 Ds Lengkong Kec. Bojongsoang Kab. Bandung,REVISI 1 PERUMAHAN TAMAN KATAPANG INDAH,28425,0.6532,18567.21,648.11 /655 - SP /TR 23 Januari 2025,500.10.29.15/2333-REKTEK/TR Tanggal 22 Mei 2024;500.10.29.15/3811-REKTEK/Bid. Taru Tanggal 10 Oktober 2024,1205000302875 Tanggal 02 April 2024;500.10.29.7/Kep.408-DLH/2025 Tanggal 10 Januari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
15 / 551,PT BUMI SUWARNA SEJAHTERA No Telpon : 082118781624,Jl Ciwastra no 73 Kel. Mekarmulya kec. Rancasari kota bandung,REVISI 1 PERUMAHAN BUMI KARA RESIDENCE,29711,0.5424,16115.2464,648.11/551-SP/TR 20 Januari 2025,500.10.29.15/6097-REKTEK/TR Tanggal 27 Nopember 2023,1311230078306 Tgl 13 Nopember 2023;500.10.29.7/Kep.493-DLH/2024 Tanggal 20 Maret 2024,Fungsi Hunian,Fungsi Hunian,2
|
||||
16 / 656,PT AMBER HASYA No Telpon : 081312411661,Jl Sarijadi raya No 111 Kel. Sarijadi Kec. Sukasarii kota bandung,REVISI 1 PERUMAHAN GREEN HARMONI RESIDENCE ,39520,0.2726,10773.152,648.11/656-SP/TR 23 Januari 2025,500.10.29.15/2732-REKTEK/Bid. Taru Tanggal 19 Juli 2024,9120004882226 Tgl 22 Agustus 2019;500.10.29.7/Kep.617-DLH/2024 Tanggal 4 Desember 2024,Fungsi Hunian,Fungsi Hunian,2
|
||||
17 / 224,PT KARYA UTAMA SEJATI JAYA No Telpon : 081320772222,Kp. Andir DS/Kel. Manggahang Kec. Baleendah Kab. Bandung,PERUMAHAN GRAND CIPARAY RESIDENCE,12045,0.5945,7160.7525,648.11/224-SP/TR 07 Januari 2025;644/822-SP/TR 13 Februari 2025;640/524-SP/TR 17 Januari 2025;642/763-SP/TR 11 Februari 2025,500/5300-PERTEKTR/2022/TR Tanggal 04 Agustus 2022;400.7.22/4872-KRK/25/Bid.TR Tanggal 24 Desember 2024;Pu.650/7580-REKTEK/TR Tanggal 20 Desember 2022;01112410113204120 Tanggal 1 November 2024,1801220061544 Tgl 05 September 2022;600.4.5/052/1722-Ktr/TL Tanggal 20 Mei 2024;9120401971173 Tgl 11 Desember 2024;1406220076826 Tgl 15 November 2022;8120103802893 Tgl 29 Agustus 2018,Fungsi Hunian,Fungsi Hunian,2
|
||||
21 / 688,PT PRAKARSA FAJAR PROPERTINDO No Telpon : 082315094712,Jl. Otto Iskandardinata No 429 Kel. Pungkur Kec. Regol Kota Bandung,PERUMAHAN ALAM BUMI CIPARAY,17417,0.6793,11831.3681,648.11/688-SP/TR 03 Februari 2025,500.10.29.15/1075-REKTEK/TR Tanggal 04 Maret 2024,9120007841259 Tgl 15 Agustus 2019;500.10.29.7/Kep.405-DLH/2025 Tanggal 06 Januari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
22 / 767,PT CITRA SENTOSA JAYATAMA No Telpon : 087825393706,Jl. Nyengseret No 29 RT 01 Kel. Pelindung hewaqn Kota Bandung,PERUMAHAN CITRA ASRI RESIDENCE,28900,0.692,19998.8,648.11/767-SP/TR 12 Februari 2025,500.10.29.15/2617-REKTEK/Bid. Taru Tanggal 10 Juli 2024,9120107971097 Tgl 19 September 2019;500.10.29.7/Kep.612-DLH/2024 Tanggal 18 November 2024,Fungsi Hunian,Fungsi Hunian,2
|
||||
23/ 641,PT PESONA MITRA KEMBAR MAS No Telpon : 081220763283,Jl Kembar mas IV No 2A RT 05/09 Kel. Pasirluyu Kec. Regol Kota Bandung,REVISI 5 PERUMAHAN PODOMORO PARK,1160011,0.6691,776163.3601,648.11/641- SP/TR 22 Januari 2025,591/057-DPMPTSP/2017 Tanggal 28 Desember 2017,650/Kep.628-DLH/2018 Tanggal 30 Nopember 2018,Fungsi Hunian,Fungsi Hunian,2
|
||||
24 / 659,PT PAVITRA PARA ARTHA No Telpon : 081809063866,Jl . Kubang Beureum No 39 RT 007 / 011 Kelurahan Sekejati Kecamatan Buahbatu,REVISI 4 PERUMAHAN PRIVATE VILLAGE,88245,0.5819,51349.7655,648.11/659 - SP/TR 23 Januari 2025;645/932 - SP/TR 21 Februari 2025;645/552-SP/TR 20 Januari 2025;647/640-SP/TR 22 Januari 2025;647/930-SP/TR 21 Februari 2025,591.4/001-BPMP/2014 Tanggal 06 Januari 2014;591.4/031-DPMPTSP/2019 Tanggal 10 Juli 2019;503/104/XII-DPMPTSP/2019- Tgl 20 Desember 2019;400.1.22/4521-KRK/15/Bid.Taru Tgl 16 Desember 2024;650/2597-KRTR/2021/TR Tgl 9 Desember 2021;500.10.29.15/2839-REKTEK/Bid.TAru Tgl 2 Agustus 2024,500.10.29.6/4898/TL Tanggal 08 Nopember 2023;667/2995/TL Tanggal 11 Agustus 2020;9120000431996 Tanggal 20 Oktober 2021;500.10.29.7/Kep.629-DLH/2024;9120605793306 Tanggal 9 Mei 2023;1601240112040181 Tanggal 16 Januari 2024;8120215192631 Tanggal 3 Januari 2022;34/LH.01.06.05/DLH Tanggal 3 Januari 2025;9120101841825 Tanggal 18 Oktober 2023,Fungsi Hunian,Fungsi Hunian,2
|
||||
29 / 931,PT KARYA HAFANA INTAN MANDIRI No Telpon : 082120002925 ,Kp./Desa Ciluluk Kecamatan Cikancung Kabupaten Bandung,PERUMAHAN GRIYA CIHANYIR PERMAI,24432.33,0.5945,14525.02019,648.11/931 - SP/TR 21 Februari 2025,400.7.22/4840-KRK/21/Bid.Taru Tgl. 18 Desember 2024,2908210007625 Tanggal 06 Mei 2024;500.10.29.7/Kep.414-DLH/2025 Tanggal 30 Januari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
30 / 933,PT ARUM JAYA PROPERTI No Telpon : 085100942672,Perumahan Banyu Arum Residence Blok A Kp. Tegal Tengah RT 003/013 Desa Cangkuang Kec. Rancaekek,REVISI 1 PERUMAHAN BUMI ARUM REGENCY,58899,0.4838,28495.3362,648.11/933 - SP/PR 21 FEBRUARI 2025,591.4/026-DPMPTSP/2018 Tgl 24 September 2018,667/7210/TL Tanggal 16 Nopember 2018;500.10.29.6/Kep.420-DLH/2025 Tanmggal 3 Februari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
31 / 762,SANDY SALMAN No Telpon : 082118781624,Jl Kembar VIII No 26 RT 005/010 Kel Cigereleng Kec. Regol Kota Bandung 40253,REVISI 1 PERUMAHAN D HEUVEL WIWAHA PADASUKA,3095,0.4295,1329.3025,648.11/ 762 - SP / PR 11 Februari 2025;648/523-SP/TR 17 Januari 2025;647/1140-SP/TR 27 Februari 2025;647/934-SP/TR 21 Februari 2025;647/1233-SP/TR 06 Maret 2025,"650/5689-PETEKTR/2022/TR Tanggal 30 Agustus 2022;650/2748-KRTR/2021/TR Tgl 21 Desember 2021;593.SK.93-BKPMD/90 Tanggal 11 April 1990;593/SK.225-BKPMD/1991 Tanggal 28 Juni 1991;591,4/009-BPMP/2014 Tanggal 27 Maret 2014;500.10.29.15/711-REKTEK/TR Tanggal 15 Februari 2024;500.10.29.15/2877-REKTEK/Bid.Taru Tanggal 19 Agustus 2024 ",LH.01.04/5866-SPPL/TL Tanggal 27 Desember 2022;1402220064386 Tanggal 04 Februari 2022;500.10.29.7/Kep.593-DLH/2024 Tanggal 27 September 2024;667/3257/BPLH Tanggal 06 Oktober 2014;2711230388253 Tanggal 27 Nopember 2023;500.10.29.7/Kep.630-DLH/2024 Tanggal 20 Desember 2024;9120312050674 Tanggal 07 Oktober 2019;500.10.29.7/Kep.426-DLH/2025 Tanggal 14 Februari 2025,Fungsi Hunian,Fungsi Hunian,1
|
||||
36/ 1141,HANDRIAWAN No Telpon : 081313350382,Jalan Taman Holis Indah E-5 No 4-5 RT 03/06 Ds/Kel. Cigondewah Kec. Bandung kulon. Kota Bandung,TOKO DAN GUDANG,2025,0.7848,1589.22,647/1141-SP/TR 27 Februari 2025;647/1211-SP/TR 04 Maret 2025;648.2/1091-SP/TR 25 Februari 2025,400.7.22/559-KRK/14/Bid.Taru Tanggal 17 Januari 2025;400.7.22/859-KRK/38/Bid.Taru Tanggal 17 Februari 2025;500.10.29.15/4064 - REKTEK/Bid.Taru Tanggal 25 Nopember 2024,1401250067962 Tanggal 14 Januari 2025;1812240057832 Tanggal 18 Desember 2024;1611210013009 Tanggal 16 Nopember 2021,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
39/ 1232,JOHANSJAH SUGIANTO No Telpon : 081314974495,Jalan Kepodang VI/6 blok k2 Rengas Kec. Ciputat timur kota Tangerang selatan,TOKO,2490,21.9,54531,644.2/1232-SP/TR 06 Maret 2025;644.2/1234-SP/TR 06 Maret 2025,400.7.22/1089 - KRK/45//Bid.Taru Tanggal 24 Februari 2025;503/0017-PKKPRNB/DPMPTSP/II/2025 Tanggal 12 Februari 2025,3101250002573 Tanggal 31 Januari 2025;2107230112343 Tanggal 21 Juli 2023,Tidak Diketahui,Tidak Diketahui,3
|
||||
41 / 1090,TIM AD HOC PERUMAHAN SUKAWANGI RESIDENCE No Telpon : 08112255770,Kp. Cihalimun RT 02/04 Ds. Cibeureum Kec. Kertasari Kab. Bandung,PERUMAHAN SUKAWANGI RESIDENCE,,1,,648.11/ 1090 - SP / PR 25 Februari 2025,,,Fungsi Hunian,Fungsi Hunian,2
|
||||
42 / 1298,PT TIGA REKAN INDONESIA No Telpon : 08122444717,Jl Gradiul No 40 RT 04/07 Kel. Rancaekek Kencana Kec. Rancaekek Kab. Bandung,PERUMAHAN GREEN HILL VILLAGE,16548,0.5917,9791.4516,648.11/1298 - SP/TR 17 Maret 2025,50.10.29.15/2742-REKTEK/Bid. Taru Tanggal 24 Juli 2024,2505240130006 Tanggal 25 Mei 2024;600.4.5/061/832-Ktr/Bid. TL/2025 Tgl. 19 Februari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
43 / 1322,PT UNILOA ARDIYANTO INVESTAMA No Telpon : 081220180480,Jl Raya Ebah 103 Desa Sukamantri Kecamatan Paseh Kab. Bandung,PERUMAHAN MARISON CIPAKU,19209,0.6146,11805.8514,648.11/1322 - SP/TR 18 Maret 2025,24042410313204051 Tanggal 24 JApril 2024,0238010110358 Tanggal 11 Januari 2024;500.10.29.7/Kep. 451-DLH/2025 Tgl. 13 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
44 / 1323,PT RADINAKA KRAMAT ABADI No Telpon : 082118781624,Jl. Sukamukti RT 01/06 Desa Sukamukti Kec. Katapang Kab. Bandung,PERUMAHAN GAHARU PALEDANG RESIDENCE,14665,0.68003,9972.63995,648.11/1323 - SP/TR 18 Maret 2025,02032510213204087 Tanggal 02 Maret 2025,0238010110358 Tanggal 11 Januari 2024;600.4.5/064/1165-Ktr/Bid. TL/2025 Tgl. 12 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
45 / 1361,PT SANGKURIANG KRAMAT ABADI No Telpon : 082118781624,Kampung rancakasiat Desa Rancamulya Kec. Pameungpeuk Kab. Bandung,PERUMAHAN PONDOK ASRI SUKAMUKTI,20451,0.6806,13918.9506,648.11/1361 - SP/TR 24 Maret 2025,500.10.29.15/3451-REKTEK/Bid.Taru Tanggal 26 September 2024,0811230037204 Tanggal 08 Nopember 2023;500.10.29.7/Kep.460-DLH/2025 Tgl. 21 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
46 / 1360,PT AUF ABDURACCHMAN JAYA No Telpon : 082118781624,Jl. Rancabungur rancakasiat Desa Malakasari Kec. Baleendah Kab. Bandung,PERUMAHAN BUMI SHANGRILA RESIDENCE,12846,0.6412,8236.8552,648.11/1360 - SP/TR 24 Maret 2025,400.7.22/093/1390-KRK/Bid.Taru Tanggal 17 Maret 2025,0603250028082 Tanggal 06 Maret 2025;600.4.5/072/1270-Ktr/Bid.TL/2025 Tgl. 21 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
47 / 1142,ANTO DWI HARTANTO No Telpon : 082126215611,Jl. Elang V No 8 RT 08/01 Kel. Garuda Kec. Andir Kota Bandung,PERGUDANGAN DAN PENYIMPANAN,1307,0.5616,734.0112,647/1142 - SP/TR 27 Februari 2025;648.11/823 - SP/TR 13 Februari 2025;644.2/1389 - SP/TR 26 Maret 2025;644.2/1388 - SP/TR 26 Maret 2025,500.10.29.15/3827-REKTEK/Bid.Taru Tanggal 17 Oktober 2024;500.10.29.15/3944-REKTEK/Bid.Taru Tanggal 28 Oktober 2024;503/0072-DPMPTSP/XI/2023 Tanggal 29 November 2023;400.7.22/1046-KRK/Bid.Taru Tanggal 21 Februari 2025,2009240075774 Tanggal 20 September 2024 2025;2009240075774 Tanggal 20 September 2025;500.10.29.7/Hep-461-DLH/2025 Tanggal 21 Maret 2025;0298000921888 Tanggal 24 Januari 2022,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
51 / 1161,PT INGRIA PRATAMA CAPITALINDO Tbk No Telpon : 087722361043,Ruko Pondok Cabe Mutiara Jl Pondok cabe No 27 Kel. Pamulang Kec. Pamulang Kota Tangerang Selatan,REVISI 2 PERUMAHAN BUKIT ESMA CICALENGKA 2 ,74300,0.6292,46749.56,648.11/1161 - SP/TR 28 Februari 2025,50.10.29.15/2927-REKTEK/Bid. Taru Tanggal 14 Agustus 2024,591.4/005/IX-DPMPTSP/2019 Tanggal 09 September 2019;500.10.29.7/Kep.613-DLH/2024 Tgl. 18 November 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
52 / 1441 ,PT ABADI MUKTI KIRANA No Telpon : 087821848944,Jl Terusan jamika No 88 Kel. Jamika Kec. Bojongloa kaler Kota Bandung, PERUMAHAN KOTA BARU ARJASARI,222816,1,222816,648.11/1441 - SP/TR 11 April 2025,400.7.28/1710/TR Tanggal 23 April 2024,9120108201236 Tanggal 13 Februari 2019;500.10.29.7/Kep.419-DLH/2025 Tgl. 03 Februari 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
53 / 1566,PT MAKMUR INDAH DAMAI No Telpon : 081394722234,Jl. Podomoro Boulevard utara I Desa Lengkong Kec. Bojongsoang Kab. Bandung,PERUMAHAN BAROS INDAH RESIDENCE,17513,1,17513,647/1566 - SP/TR 25 April 2025,50.10.29.15/2507-REKTEK/Bid. Taru Tanggal 25 Juni 2024,2106240023693 Tanggal 21 Juni 2024;500.10.29.7/Kep.447-DLH/2024 Tgl. 10 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
54 / 1343,PT KARYA BUMI BESTARI No Telpon : 08156080428,Kembar Mas IV No 2A RT 05/09 Kel. Pasirluyu Kec. Regol Kota Bandung,PERUMAHAN BESTARI MAS,26134,1,26134,648.11/1343 - SP/TR 20 Maret 2025;647/1565 - SP/TR 25 April 2025;648.1/1543 - SP/TR 17 April 2025,12042310213204004 Tanggal 12 April 2023;23122410113204057 Tanggal 23 Desember 2024;400.7.22/1047-KRK/42/Bid.Taru Tanggal 21 Februari 2025,1204230043635 Tanggal 12 April 2023;500.10.29.7/964/Bid. TL/2025 Tgl. 19 Februari 2025;9120304390956 Tanggal 05 Desember 2023;0307230050445 Tanggal 03 Juli 2023,Fungsi Hunian,Fungsi Hunian,2
|
||||
57 / 1372,TENNI DIANA No Telpon : 082116106640,Cikaahuripan RT 002/005 Kec. Neglasari Kota Tangerang,PERADAGANGAN KHUSUS KARPET PERMADANI DAN PENUTUP DINDING DN LANTAI DI TOKO,1290,1,1290,644/1372 - SP/TR 26 Maret 2025;647/1557 - SP/TR 22 April 2025;640/1559 - SP/TR 22 April 2025;644/1371 - SP/TR 26 Maret 2025;644/1375 - SP/TR 26 Maret 2025;644/1373 - SP/TR 26 Maret 2025,500.10.29.15/4355-REKTEK/TR Tanggal 25 Agustus 2023;500.10.29.15/1073-REKTEK/TR Tanggal 04 Maret 2024;400.7.22/759-KRK/34/Bid.Taru Tanggal 11 Februari 2025;500.10.29.15/4654-REKTEK/Bid. Taru Tanggal 08 September 2023;500.10.29.15/4160-REKTEK/Bid. Taru Tanggal 15 Nopember 2024;500.10.29.15/2500-REKTEK/Bid. Taru Tanggal 19 Juni 2024,9120306652149 Tanggal 26 Juni 2019;0220107462528 Tanggal 08 September 2022;1283000240318 Tanggal 01 Februari 2021;600.4.5/071-KTR/Bid.TL/2025 Tgl. 05 Mei 2025;0220301251224 Tanggal 11 Agustus 2023;1263000210596 Tanggal 09 Februari 2021;1405240295325 5 Mei 2024,Tidak Diketahui,Tidak Diketahui,1
|
||||
63 / 1567,Ir. BERSIH TARIGANT No Telpon : 081322777581,Jl Multatuli No 3 rt 001/001 Ds/Kel. Lebakgede Kec. Coblong Kota Bandung,PERUMAHAN TUSCANY HILL,23796,0.2428,5777.6688,648.11/1567 - SP/TR 25 April 2025,50.10.29.15/3829-REKTEK/Bid. Taru Tanggal 15 Oktober 2024,2007220014068 Tanggal 20 Juli 2025;500.10.29.7/Kep.429-DLH/2025 Tgl. 10 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
64 / 1682,PT CIPTA BERKAT PROPERTI No Telpon : 081910661980,Ruko Matahari Cigado No 25 Jalan Anggadireja Kel. Baleendah Kec. Baleendah Kab. Bandung,PERUMAHAN GARDEN VIEW CICALENGKA,45666,1,45666,648.11/1682 - SP/TR 06 Mei 2025,50.10.29.15/3156-REKTEK/Bid. Taru Tanggal 05 September 2024,2310210017936 Tanggal 23 Oktober 2021;500.10.29.7/Kep.477-DLH/2025 Tgl. 17 April 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
64 / 1682,PT CIPTA BERKAT PROPERTI No Telpon : 081910661980,Ruko Matahari Cigado No 25 Jalan Anggadireja Kel. Baleendah Kec. Baleendah Kab. Bandung,C. KWT PERUMAHAN,0,1,0,,,,Fungsi Hunian,Fungsi Hunian,1
|
||||
65 / 1644,PT ARGUNA JAYA PROPERTY No Telpon : 081214211164,Jl Pidada IV/4 Denpasar BR/Link Sedana metra Kel. Ubung Kec. Denpasar Utara Kota Denpasar,REVISI 1 PERUMAHAN ARGUNA SINDANGPANON,8553,0.53,4533.09,648.11/1644 - SP/TR 29 April 2025;644/1558 - SP/TR 22 April 2025,503/009/II-DPMPTSP/2020 Tanggal 25 Februari 2020;50.10.29.15/4063-REKTEK/Bid. Taru Tanggal 25 Nopember 2025,9120004890734 Tanggal 03 Agustus 2019;667/2081/TL Tgl. 08 Juni 2020;0609240042720001 Tanggal 06 September 2024,Fungsi Hunian,Fungsi Hunian,1
|
||||
67/ 1370,NENENG FATIMAH No Telpon : 08977980040,Jalan Batu Indah I No 26 RT 002/003 Kel. Batununggal Kec. Bandung Kidul Kota Bandung,PERGUDANGAN DAN PENYIMPANAN,2034,1,2034,644/1370 - SP/TR 26 Maret 2025,50.10.29.15/3340-REKTEK/Bid. Taru Tanggal 18 September 2025,1009240038601 Tanggal 10 September 2024,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
68/ 1374,LILI JOJON No Telpon : 082219855556,Kp. Cibisoro RT 004/008 Desa Nanjung Kec. Mrgaasih Kab. Bandung,PERGUDANGAN DAN PENYIMPANAN,1654,1,1654,644/1374 - SP/TR 26 Maret 2025;644.2/1683 - SP/TR 06 Mei 2025;645/1730 - SP/TR 07 Mei 2025,50.10.29.15/3210-REKTEK/Bid. Taru Tanggal 10 September 2024;400.7.22/1254-KRK/58/Bid. Taru Tanggal 10 Maret 2025;50.10.29.15/3443-REKTEK/Bid. Taru Tanggal 26 September 2024,1220000361065 Tanggal 16 Maret 2021;1712240056863 Tanggal 17 Desember 2024;0103230081544 Tanggal 01 Maret 2023;600.4.5/071/1503-Ktr/Bid. TL/2025 Tanggal 17 April 2025,Usaha Besar (Non-Mikro),Fungsi Usaha,1
|
||||
71/ 1845,PT SANGKURIANG KRAMAT ABADI No Telpon : 082116602145,Kp. Rancakasiat Desa Rancamulya Kec. Pameungpeuk Kab. Bandung,PERUMAHAN CLUSTER GAHARU EMERALD,19889,1,19889,648.11 /1845 - SP/TR 19 Mei 2025,400.7.22/1526-KRK/96/Bid. Taru Tanggal 22 April 2025,0811230037204 Tanggal 08 Nopember 2023;500.10.29.7/Kep. 489-DLH/2025 Tanggal 15 Mei 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
72/ 1731,PT MARGA TIRTA KENCANA No Telpon : 082130000146,Jlan BKR Lingkar selatan No 140 Kota Bandung,PERUMAHAN TAMAN CIBADUYUT INDAH 2 DAN 3,205344,1,205344,648.11 /1731 - SP/TR 07 Mei 2025;648.11 /1946 - SP/TR 22 Mei 2025;643 /1881 - SP/TR 20 Mei 2025;644 /1684 - SP/TR 06 Mei 2025;648.12 /1825 - SP/TR 16 Mei 2025,591.4/002-BPMP/2010 Tanggal 10 Januari 2010;500.10.29.15/3108-REKTEK/Bid.taru Tanggal 29 Agustus 2024;500.10.29.15/3319-REKTEK/TR Tanggal 14 Juli 2023;12092410313204101 Tanggal 12 September 2024;400.7.22/1231-KRK/Bid.Taru Tanggal 06 Maret 2025,667/3803/DLH Tanggal 22 Desember 2016;9120204202309 Tanggal 20 Februari 2019;2002230028317 Tanggal 20 Februari 2023;600.4.5/073/1562-Ktr/Bid.TL/2025 Tanggal 23 April 2025;8120006931402 Tanggal 28 September 2022;12710006324580004 Tanggal 05 Maret 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
77/ 1879,PT PUTRA RAHMAN PRADANA No Telpon : 081312214962,Perum Cemerlang Permai Blok C No 16 Kel. Sukakarya Kec. Warudoyongf Kota Sukabumi,REVISI 1 PERUMAHAN BUKIT PINUS BANIARAN,90711,1,90711,648.11 /1879 - SP/TR 20 Mei 2025,22122310313204009 Tanggal 22 Desember 2023,500.10.29.7/Kep.482-DLH/2025 Tanggal 24 April 2025,Fungsi Hunian,Fungsi Hunian,2
|
||||
|
56
Dockerfile
Normal file
56
Dockerfile
Normal file
@@ -0,0 +1,56 @@
|
||||
FROM node:18 AS node-base
|
||||
|
||||
# Development stage
|
||||
FROM node-base AS development
|
||||
WORKDIR /var/www
|
||||
COPY package*.json ./
|
||||
RUN npm install
|
||||
COPY . .
|
||||
EXPOSE 5173
|
||||
CMD ["npm", "run", "dev", "--", "--host", "0.0.0.0"]
|
||||
|
||||
# Production stage
|
||||
FROM php:8.2-fpm AS production
|
||||
WORKDIR /var/www
|
||||
|
||||
# Install PHP extensions
|
||||
RUN apt-get update && apt-get install -y \
|
||||
git curl zip unzip libpng-dev libonig-dev libxml2-dev libzip-dev \
|
||||
&& docker-php-ext-install pdo_mysql mbstring exif pcntl bcmath gd zip
|
||||
|
||||
# Install Node.js
|
||||
RUN curl -fsSL https://deb.nodesource.com/setup_18.x | bash - \
|
||||
&& apt-get install -y nodejs
|
||||
|
||||
# Install Composer
|
||||
COPY --from=composer:latest /usr/bin/composer /usr/bin/composer
|
||||
|
||||
# Copy application files
|
||||
COPY . .
|
||||
|
||||
# Install dependencies
|
||||
RUN composer install --no-dev --optimize-autoloader
|
||||
|
||||
# Install and build frontend assets
|
||||
RUN npm install \
|
||||
&& npm run build \
|
||||
&& ls -la public/build \
|
||||
&& mkdir -p public/assets \
|
||||
&& cp -r public/build/* public/assets/ \
|
||||
&& ls -la public/assets \
|
||||
&& rm -rf node_modules \
|
||||
&& rm -rf public/build
|
||||
|
||||
# Laravel caches
|
||||
RUN php artisan config:clear \
|
||||
&& php artisan route:clear \
|
||||
&& php artisan view:clear \
|
||||
&& php artisan optimize
|
||||
|
||||
RUN php artisan storage:link
|
||||
|
||||
# Permissions
|
||||
RUN chown -R www-data:www-data /var/www && chmod -R 755 /var/www/storage /var/www/public
|
||||
|
||||
EXPOSE 9000
|
||||
CMD ["php-fpm"]
|
||||
288
app/Console/Commands/CalculateRetributionProposalsCommand.php
Normal file
288
app/Console/Commands/CalculateRetributionProposalsCommand.php
Normal file
@@ -0,0 +1,288 @@
|
||||
<?php
|
||||
|
||||
namespace App\Console\Commands;
|
||||
|
||||
use Illuminate\Console\Command;
|
||||
use App\Models\SpatialPlanning;
|
||||
use App\Models\RetributionProposal;
|
||||
use App\Services\RetributionProposalService;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Exception;
|
||||
|
||||
class CalculateRetributionProposalsCommand extends Command
|
||||
{
|
||||
/**
|
||||
* The name and signature of the console command.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $signature = 'retribution:calculate-proposals
|
||||
{--force : Force recalculate existing proposals}
|
||||
{--limit= : Limit number of spatial plannings to process}
|
||||
{--skip-existing : Skip spatial plannings that already have proposals}
|
||||
{--dry-run : Show what would be processed without actually creating proposals}';
|
||||
|
||||
/**
|
||||
* The console command description.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $description = 'Calculate retribution proposals for all spatial plannings';
|
||||
|
||||
protected RetributionProposalService $proposalService;
|
||||
|
||||
public function __construct(RetributionProposalService $proposalService)
|
||||
{
|
||||
parent::__construct();
|
||||
$this->proposalService = $proposalService;
|
||||
}
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
public function handle()
|
||||
{
|
||||
$this->info('🧮 Starting Retribution Proposal Calculation...');
|
||||
$this->newLine();
|
||||
|
||||
try {
|
||||
// Get processing options
|
||||
$force = $this->option('force');
|
||||
$limit = $this->option('limit') ? (int) $this->option('limit') : null;
|
||||
$skipExisting = $this->option('skip-existing');
|
||||
$dryRun = $this->option('dry-run');
|
||||
|
||||
// Build query for spatial plannings
|
||||
$query = SpatialPlanning::query();
|
||||
|
||||
if ($skipExisting && !$force) {
|
||||
$query->whereDoesntHave('retributionProposals');
|
||||
}
|
||||
|
||||
if ($limit) {
|
||||
$query->limit($limit);
|
||||
}
|
||||
|
||||
$spatialPlannings = $query->get();
|
||||
$totalCount = $spatialPlannings->count();
|
||||
|
||||
if ($totalCount === 0) {
|
||||
$this->warn('No spatial plannings found to process.');
|
||||
return 0;
|
||||
}
|
||||
|
||||
// Show processing summary
|
||||
$this->info("📊 PROCESSING SUMMARY:");
|
||||
$this->info(" Total Spatial Plannings: {$totalCount}");
|
||||
$this->info(" Force Recalculate: " . ($force ? 'Yes' : 'No'));
|
||||
$this->info(" Skip Existing: " . ($skipExisting ? 'Yes' : 'No'));
|
||||
$this->info(" Dry Run: " . ($dryRun ? 'Yes' : 'No'));
|
||||
$this->newLine();
|
||||
|
||||
if ($dryRun) {
|
||||
$this->showDryRunPreview($spatialPlannings);
|
||||
return 0;
|
||||
}
|
||||
|
||||
// Confirm processing
|
||||
if (!$this->confirm("Process {$totalCount} spatial plannings?")) {
|
||||
$this->info('Operation cancelled.');
|
||||
return 0;
|
||||
}
|
||||
|
||||
// Process spatial plannings
|
||||
$this->processRetributionCalculations($spatialPlannings, $force);
|
||||
|
||||
return 0;
|
||||
|
||||
} catch (Exception $e) {
|
||||
$this->error('Error during retribution calculation: ' . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Show dry run preview
|
||||
*/
|
||||
private function showDryRunPreview($spatialPlannings)
|
||||
{
|
||||
$this->info('🔍 DRY RUN PREVIEW:');
|
||||
$this->newLine();
|
||||
|
||||
$processable = 0;
|
||||
$withProposals = 0;
|
||||
$withoutFunction = 0;
|
||||
$withoutArea = 0;
|
||||
|
||||
foreach ($spatialPlannings as $spatial) {
|
||||
$hasProposals = $spatial->retributionProposals()->exists();
|
||||
$buildingFunction = $this->proposalService->detectBuildingFunction($spatial->getBuildingFunctionText());
|
||||
$area = $spatial->getCalculationArea();
|
||||
|
||||
if ($hasProposals) {
|
||||
$withProposals++;
|
||||
}
|
||||
|
||||
if (!$buildingFunction) {
|
||||
$withoutFunction++;
|
||||
}
|
||||
|
||||
if ($area <= 0) {
|
||||
$withoutArea++;
|
||||
}
|
||||
|
||||
if ($buildingFunction && $area > 0) {
|
||||
$processable++;
|
||||
}
|
||||
}
|
||||
|
||||
$this->table(
|
||||
['Status', 'Count', 'Description'],
|
||||
[
|
||||
['✅ Processable', $processable, 'Can create retribution proposals'],
|
||||
['🔄 With Existing Proposals', $withProposals, 'Already have proposals (will skip unless --force)'],
|
||||
['❌ Missing Building Function', $withoutFunction, 'Cannot detect building function'],
|
||||
['❌ Missing Area', $withoutArea, 'Area is zero or missing'],
|
||||
]
|
||||
);
|
||||
|
||||
$this->newLine();
|
||||
$this->info("💡 To process: php artisan retribution:calculate-proposals");
|
||||
$this->info("💡 To force recalculate: php artisan retribution:calculate-proposals --force");
|
||||
}
|
||||
|
||||
/**
|
||||
* Process retribution calculations
|
||||
*/
|
||||
private function processRetributionCalculations($spatialPlannings, $force)
|
||||
{
|
||||
$progressBar = $this->output->createProgressBar($spatialPlannings->count());
|
||||
$progressBar->start();
|
||||
|
||||
$stats = [
|
||||
'processed' => 0,
|
||||
'skipped' => 0,
|
||||
'errors' => 0,
|
||||
'created_proposals' => 0
|
||||
];
|
||||
|
||||
foreach ($spatialPlannings as $spatial) {
|
||||
try {
|
||||
$result = $this->processSingleSpatialPlanning($spatial, $force);
|
||||
|
||||
if ($result['status'] === 'processed') {
|
||||
$stats['processed']++;
|
||||
$stats['created_proposals'] += $result['proposals_created'];
|
||||
} elseif ($result['status'] === 'skipped') {
|
||||
$stats['skipped']++;
|
||||
} else {
|
||||
$stats['errors']++;
|
||||
}
|
||||
|
||||
} catch (Exception $e) {
|
||||
$stats['errors']++;
|
||||
$this->newLine();
|
||||
$this->error("Error processing spatial planning ID {$spatial->id}: " . $e->getMessage());
|
||||
}
|
||||
|
||||
$progressBar->advance();
|
||||
}
|
||||
|
||||
$progressBar->finish();
|
||||
$this->newLine(2);
|
||||
|
||||
// Show final statistics
|
||||
$this->showFinalStatistics($stats);
|
||||
}
|
||||
|
||||
/**
|
||||
* Process single spatial planning
|
||||
*/
|
||||
private function processSingleSpatialPlanning(SpatialPlanning $spatial, $force)
|
||||
{
|
||||
// Check if already has proposals
|
||||
if (!$force && $spatial->retributionProposals()->exists()) {
|
||||
return ['status' => 'skipped', 'reason' => 'already_has_proposals'];
|
||||
}
|
||||
|
||||
// Detect building function
|
||||
$buildingFunction = $this->proposalService->detectBuildingFunction($spatial->getBuildingFunctionText());
|
||||
if (!$buildingFunction) {
|
||||
return ['status' => 'error', 'reason' => 'no_building_function'];
|
||||
}
|
||||
|
||||
// Get area
|
||||
$totalArea = $spatial->getCalculationArea();
|
||||
if ($totalArea <= 0) {
|
||||
return ['status' => 'error', 'reason' => 'no_area'];
|
||||
}
|
||||
|
||||
// Get number of floors
|
||||
$numberOfFloors = max(1, $spatial->number_of_floors ?? 1);
|
||||
|
||||
// Delete existing proposals if force mode
|
||||
if ($force) {
|
||||
$spatial->retributionProposals()->delete();
|
||||
}
|
||||
|
||||
$proposalsCreated = 0;
|
||||
|
||||
// Create proposals for each floor
|
||||
for ($floor = 1; $floor <= $numberOfFloors; $floor++) {
|
||||
// Calculate floor area (distribute total area across floors)
|
||||
$floorArea = $totalArea / $numberOfFloors;
|
||||
|
||||
// Create retribution proposal
|
||||
$proposal = $this->proposalService->createProposalForSpatialPlanning(
|
||||
$spatial,
|
||||
$buildingFunction->id,
|
||||
$floor,
|
||||
$floorArea,
|
||||
$totalArea,
|
||||
"Auto-generated from spatial planning calculation"
|
||||
);
|
||||
|
||||
if ($proposal) {
|
||||
$proposalsCreated++;
|
||||
}
|
||||
}
|
||||
|
||||
return [
|
||||
'status' => 'processed',
|
||||
'proposals_created' => $proposalsCreated
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Show final statistics
|
||||
*/
|
||||
private function showFinalStatistics($stats)
|
||||
{
|
||||
$this->info('✅ CALCULATION COMPLETED!');
|
||||
$this->newLine();
|
||||
|
||||
$this->table(
|
||||
['Metric', 'Count'],
|
||||
[
|
||||
['Processed Successfully', $stats['processed']],
|
||||
['Skipped (Already Exists)', $stats['skipped']],
|
||||
['Errors', $stats['errors']],
|
||||
['Total Proposals Created', $stats['created_proposals']],
|
||||
]
|
||||
);
|
||||
|
||||
if ($stats['errors'] > 0) {
|
||||
$this->newLine();
|
||||
$this->warn("⚠️ {$stats['errors']} spatial plannings had errors:");
|
||||
$this->warn(" • Missing building function detection");
|
||||
$this->warn(" • Missing or zero area");
|
||||
$this->warn(" • Other calculation errors");
|
||||
}
|
||||
|
||||
if ($stats['processed'] > 0) {
|
||||
$this->newLine();
|
||||
$this->info("🎉 Successfully created {$stats['created_proposals']} retribution proposals!");
|
||||
$this->info("💡 You can view them using: php artisan retribution:list-proposals");
|
||||
}
|
||||
}
|
||||
}
|
||||
317
app/Console/Commands/InitSpatialPlanningDatas.php
Normal file
317
app/Console/Commands/InitSpatialPlanningDatas.php
Normal file
@@ -0,0 +1,317 @@
|
||||
<?php
|
||||
|
||||
namespace App\Console\Commands;
|
||||
|
||||
use App\Models\SpatialPlanning;
|
||||
use Illuminate\Console\Command;
|
||||
use Maatwebsite\Excel\Facades\Excel;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Exception;
|
||||
|
||||
class InitSpatialPlanningDatas extends Command
|
||||
{
|
||||
/**
|
||||
* The name and signature of the console command.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $signature = 'spatial:init {file? : Path to the CSV/Excel file} {--truncate : Clear existing data before import} {--safe-truncate : Clear only spatial plannings without retribution proposals} {--force-truncate : Force truncate by disabling foreign key checks}';
|
||||
|
||||
/**
|
||||
* The console command description.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $description = 'Import spatial planning data from CSV/Excel file for retribution';
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
public function handle()
|
||||
{
|
||||
$filePath = $this->argument('file') ?? 'public/templates/Data_2025___Estimasi_Jumlah_Lantai.csv';
|
||||
$fullPath = storage_path('app/' . $filePath);
|
||||
|
||||
// Check if file exists
|
||||
if (!file_exists($fullPath)) {
|
||||
$this->error("File not found: {$fullPath}");
|
||||
$this->info("Available files in templates:");
|
||||
$this->listAvailableFiles();
|
||||
return 1;
|
||||
}
|
||||
|
||||
// Handle truncate options
|
||||
if (($this->option('truncate') && $this->option('safe-truncate')) ||
|
||||
($this->option('truncate') && $this->option('force-truncate')) ||
|
||||
($this->option('safe-truncate') && $this->option('force-truncate'))) {
|
||||
$this->error('Cannot use multiple truncate options together. Choose only one.');
|
||||
return 1;
|
||||
}
|
||||
|
||||
// Confirm truncate if requested
|
||||
if ($this->option('truncate')) {
|
||||
if ($this->confirm('This will delete all existing spatial planning data and related retribution proposals. Continue?')) {
|
||||
$this->info('Truncating tables...');
|
||||
|
||||
try {
|
||||
// First delete retribution proposals that reference spatial plannings
|
||||
$deletedProposals = DB::table('retribution_proposals')
|
||||
->whereNotNull('spatial_planning_id')
|
||||
->count();
|
||||
|
||||
if ($deletedProposals > 0) {
|
||||
DB::table('retribution_proposals')
|
||||
->whereNotNull('spatial_planning_id')
|
||||
->delete();
|
||||
$this->info("Deleted {$deletedProposals} retribution proposals linked to spatial plannings.");
|
||||
}
|
||||
|
||||
// Method 1: Try truncate with disabled foreign key checks
|
||||
try {
|
||||
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
|
||||
DB::table('spatial_plannings')->truncate();
|
||||
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
|
||||
$this->info('Spatial plannings table truncated successfully.');
|
||||
} catch (\Exception $truncateError) {
|
||||
// Method 2: Fallback to delete if truncate fails
|
||||
$this->warn('Truncate failed, using delete method...');
|
||||
$deletedSpatial = DB::table('spatial_plannings')->delete();
|
||||
$this->info("Deleted {$deletedSpatial} spatial planning records.");
|
||||
|
||||
// Reset auto increment
|
||||
DB::statement('ALTER TABLE spatial_plannings AUTO_INCREMENT = 1');
|
||||
}
|
||||
|
||||
} catch (\Exception $e) {
|
||||
$this->error('Failed to truncate tables: ' . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
} else {
|
||||
$this->info('Operation cancelled.');
|
||||
return 0;
|
||||
}
|
||||
}
|
||||
|
||||
// Force truncate - disable foreign key checks and truncate everything
|
||||
if ($this->option('force-truncate')) {
|
||||
if ($this->confirm('This will FORCE truncate ALL spatial planning data by disabling foreign key checks. This is risky! Continue?')) {
|
||||
$this->info('Force truncating with disabled foreign key checks...');
|
||||
|
||||
try {
|
||||
DB::beginTransaction();
|
||||
|
||||
// Disable foreign key checks
|
||||
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
|
||||
|
||||
// Truncate both tables
|
||||
DB::table('retribution_proposals')->truncate();
|
||||
DB::table('spatial_plannings')->truncate();
|
||||
|
||||
// Re-enable foreign key checks
|
||||
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
|
||||
|
||||
$this->info('Force truncate completed successfully.');
|
||||
|
||||
DB::commit();
|
||||
|
||||
} catch (\Exception $e) {
|
||||
DB::rollBack();
|
||||
// Make sure to re-enable foreign key checks even on error
|
||||
try {
|
||||
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
|
||||
} catch (\Exception $fkError) {
|
||||
$this->error('Failed to re-enable foreign key checks: ' . $fkError->getMessage());
|
||||
}
|
||||
$this->error('Failed to force truncate: ' . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
} else {
|
||||
$this->info('Operation cancelled.');
|
||||
return 0;
|
||||
}
|
||||
}
|
||||
|
||||
// Safe truncate - only delete spatial plannings without retribution proposals
|
||||
if ($this->option('safe-truncate')) {
|
||||
if ($this->confirm('This will delete only spatial planning data that have no retribution proposals. Continue?')) {
|
||||
$this->info('Safe truncating spatial plannings...');
|
||||
|
||||
try {
|
||||
DB::beginTransaction();
|
||||
|
||||
// Count spatial plannings with retribution proposals
|
||||
$withProposals = DB::table('spatial_plannings')
|
||||
->whereExists(function ($query) {
|
||||
$query->select(DB::raw(1))
|
||||
->from('retribution_proposals')
|
||||
->whereColumn('retribution_proposals.spatial_planning_id', 'spatial_plannings.id');
|
||||
})
|
||||
->count();
|
||||
|
||||
// Delete spatial plannings without retribution proposals
|
||||
$deletedCount = DB::table('spatial_plannings')
|
||||
->whereNotExists(function ($query) {
|
||||
$query->select(DB::raw(1))
|
||||
->from('retribution_proposals')
|
||||
->whereColumn('retribution_proposals.spatial_planning_id', 'spatial_plannings.id');
|
||||
})
|
||||
->delete();
|
||||
|
||||
$this->info("Deleted {$deletedCount} spatial plannings without retribution proposals.");
|
||||
$this->info("Kept {$withProposals} spatial plannings that have retribution proposals.");
|
||||
|
||||
DB::commit();
|
||||
|
||||
} catch (\Exception $e) {
|
||||
DB::rollBack();
|
||||
$this->error('Failed to safe truncate: ' . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
} else {
|
||||
$this->info('Operation cancelled.');
|
||||
return 0;
|
||||
}
|
||||
}
|
||||
|
||||
$this->info("Starting import from: {$filePath}");
|
||||
$this->info("Full path: {$fullPath}");
|
||||
|
||||
try {
|
||||
DB::beginTransaction();
|
||||
|
||||
$data = Excel::toArray([], $fullPath);
|
||||
|
||||
if (empty($data) || empty($data[0])) {
|
||||
$this->error('No data found in the file.');
|
||||
return 1;
|
||||
}
|
||||
|
||||
$rows = $data[0]; // Get first sheet
|
||||
$headers = array_shift($rows); // Remove header row
|
||||
|
||||
$this->info("Found " . count($rows) . " data rows to import.");
|
||||
$this->info("Headers: " . implode(', ', $headers));
|
||||
|
||||
$progressBar = $this->output->createProgressBar(count($rows));
|
||||
$progressBar->start();
|
||||
|
||||
$imported = 0;
|
||||
$skipped = 0;
|
||||
|
||||
foreach ($rows as $index => $row) {
|
||||
try {
|
||||
// Skip empty rows
|
||||
if (empty(array_filter($row))) {
|
||||
$skipped++;
|
||||
$progressBar->advance();
|
||||
continue;
|
||||
}
|
||||
|
||||
// Map CSV columns to model attributes
|
||||
$spatialData = [
|
||||
'name' => $this->cleanString($row[1] ?? ''), // pemohon
|
||||
'location' => $this->cleanString($row[2] ?? ''), // alamat
|
||||
'activities' => $this->cleanString($row[3] ?? ''), // activities
|
||||
'land_area' => $this->cleanNumber($row[4] ?? 0), // luas_lahan
|
||||
'site_bcr' => $this->cleanNumber($row[5] ?? 0), // bcr_kawasan
|
||||
'area' => $this->cleanNumber($row[6] ?? 0), // area
|
||||
'no_tapak' => $this->cleanString($row[7] ?? ''), // no_tapak
|
||||
'no_skkl' => $this->cleanString($row[8] ?? ''), // no_skkl
|
||||
'no_ukl' => $this->cleanString($row[9] ?? ''), // no_ukl
|
||||
'building_function' => $this->cleanString($row[10] ?? ''), // fungsi_bangunan
|
||||
'sub_building_function' => $this->cleanString($row[11] ?? ''), // sub_fungsi_bangunan
|
||||
'number_of_floors' => $this->cleanNumber($row[12] ?? 1), // jumlah_lantai
|
||||
'number' => $this->cleanString($row[0] ?? ''), // no
|
||||
'date' => now(), // Set current date
|
||||
'kbli' => null, // Not in CSV, set as null
|
||||
];
|
||||
|
||||
// Validate required fields
|
||||
if (empty($spatialData['name']) && empty($spatialData['activities'])) {
|
||||
$skipped++;
|
||||
$progressBar->advance();
|
||||
continue;
|
||||
}
|
||||
|
||||
SpatialPlanning::create($spatialData);
|
||||
$imported++;
|
||||
|
||||
} catch (Exception $e) {
|
||||
$this->newLine();
|
||||
$this->error("Error importing row " . ($index + 2) . ": " . $e->getMessage());
|
||||
$skipped++;
|
||||
}
|
||||
|
||||
$progressBar->advance();
|
||||
}
|
||||
|
||||
$progressBar->finish();
|
||||
$this->newLine(2);
|
||||
|
||||
DB::commit();
|
||||
|
||||
$this->info("Import completed successfully!");
|
||||
$this->info("Imported: {$imported} records");
|
||||
$this->info("Skipped: {$skipped} records");
|
||||
|
||||
return 0;
|
||||
|
||||
} catch (Exception $e) {
|
||||
DB::rollBack();
|
||||
$this->error("Import failed: " . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Clean string data
|
||||
*/
|
||||
private function cleanString($value)
|
||||
{
|
||||
if (is_null($value)) return null;
|
||||
return trim(str_replace(["\n", "\r", "\t"], ' ', $value));
|
||||
}
|
||||
|
||||
/**
|
||||
* Clean numeric data
|
||||
*/
|
||||
private function cleanNumber($value)
|
||||
{
|
||||
if (is_null($value) || $value === '') return 0;
|
||||
|
||||
// Remove non-numeric characters except decimal point
|
||||
$cleaned = preg_replace('/[^0-9.]/', '', $value);
|
||||
|
||||
return is_numeric($cleaned) ? (float) $cleaned : 0;
|
||||
}
|
||||
|
||||
/**
|
||||
* List available template files
|
||||
*/
|
||||
private function listAvailableFiles()
|
||||
{
|
||||
$templatesPath = storage_path('app/public/templates');
|
||||
if (is_dir($templatesPath)) {
|
||||
$this->info("Files in storage/app/public/templates:");
|
||||
$extensions = ['csv', 'xlsx', 'xls'];
|
||||
foreach ($extensions as $ext) {
|
||||
$files = glob($templatesPath . '/*.' . $ext);
|
||||
foreach ($files as $file) {
|
||||
$this->line(' - ' . basename($file));
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
$publicTemplatesPath = public_path('templates');
|
||||
if (is_dir($publicTemplatesPath)) {
|
||||
$this->info("Files in public/templates:");
|
||||
$extensions = ['csv', 'xlsx', 'xls'];
|
||||
foreach ($extensions as $ext) {
|
||||
$files = glob($publicTemplatesPath . '/*.' . $ext);
|
||||
foreach ($files as $file) {
|
||||
$this->line(' - ' . basename($file));
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,321 @@
|
||||
<?php
|
||||
|
||||
namespace App\Console\Commands;
|
||||
|
||||
use Illuminate\Console\Command;
|
||||
use App\Models\SpatialPlanning;
|
||||
use App\Models\RetributionProposal;
|
||||
use App\Services\RetributionProposalService;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Exception;
|
||||
|
||||
class ProcessSpatialPlanningRetributionCommand extends Command
|
||||
{
|
||||
/**
|
||||
* The name and signature of the console command.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $signature = 'spatial:process-retribution
|
||||
{--all : Process all spatial plannings}
|
||||
{--new-only : Process only spatial plannings without retribution proposals}
|
||||
{--force : Force recalculate existing retribution proposals}';
|
||||
|
||||
/**
|
||||
* The console command description.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $description = 'Process and save retribution calculations for spatial plannings';
|
||||
|
||||
protected RetributionProposalService $proposalService;
|
||||
|
||||
public function __construct(RetributionProposalService $proposalService)
|
||||
{
|
||||
parent::__construct();
|
||||
$this->proposalService = $proposalService;
|
||||
}
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
public function handle()
|
||||
{
|
||||
$this->info('🏗️ Processing Spatial Planning Retribution Calculations...');
|
||||
$this->newLine();
|
||||
|
||||
try {
|
||||
// Get options
|
||||
$processAll = $this->option('all');
|
||||
$newOnly = $this->option('new-only');
|
||||
$force = $this->option('force');
|
||||
|
||||
// Build query
|
||||
$query = SpatialPlanning::query();
|
||||
|
||||
if ($newOnly || (!$processAll && !$force)) {
|
||||
$query->whereDoesntHave('retributionProposals');
|
||||
$this->info('📋 Mode: Processing only spatial plannings WITHOUT retribution proposals');
|
||||
} elseif ($processAll) {
|
||||
$this->info('📋 Mode: Processing ALL spatial plannings');
|
||||
}
|
||||
|
||||
$spatialPlannings = $query->get();
|
||||
$totalCount = $spatialPlannings->count();
|
||||
|
||||
if ($totalCount === 0) {
|
||||
$this->warn('❌ No spatial plannings found to process.');
|
||||
$this->info('💡 Try running: php artisan spatial:init first');
|
||||
return 0;
|
||||
}
|
||||
|
||||
$this->info("📊 Found {$totalCount} spatial plannings to process");
|
||||
$this->newLine();
|
||||
|
||||
// Show preview of what will be processed
|
||||
$this->showProcessingPreview($spatialPlannings);
|
||||
|
||||
// Confirm processing
|
||||
if (!$this->confirm("Process {$totalCount} spatial plannings and create retribution proposals?")) {
|
||||
$this->info('Operation cancelled.');
|
||||
return 0;
|
||||
}
|
||||
|
||||
// Process all spatial plannings
|
||||
$this->processAllSpatialPlannings($spatialPlannings, $force);
|
||||
|
||||
return 0;
|
||||
|
||||
} catch (Exception $e) {
|
||||
$this->error('❌ Error during processing: ' . $e->getMessage());
|
||||
return 1;
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Show processing preview
|
||||
*/
|
||||
private function showProcessingPreview($spatialPlannings)
|
||||
{
|
||||
$this->info('🔍 PREVIEW:');
|
||||
|
||||
$canProcess = 0;
|
||||
$cannotProcess = 0;
|
||||
$hasExisting = 0;
|
||||
|
||||
$sampleData = [];
|
||||
$errorReasons = [];
|
||||
|
||||
foreach ($spatialPlannings->take(5) as $spatial) {
|
||||
$buildingFunction = $this->proposalService->detectBuildingFunction($spatial->getBuildingFunctionText());
|
||||
$area = $spatial->getCalculationArea();
|
||||
$floors = max(1, $spatial->number_of_floors ?? 1);
|
||||
$hasProposals = $spatial->retributionProposals()->exists();
|
||||
|
||||
if ($hasProposals) {
|
||||
$hasExisting++;
|
||||
}
|
||||
|
||||
if ($buildingFunction && $area > 0) {
|
||||
$canProcess++;
|
||||
$sampleData[] = [
|
||||
'ID' => $spatial->id,
|
||||
'Name' => substr($spatial->name ?? 'N/A', 0, 30),
|
||||
'Function' => $buildingFunction->name ?? 'N/A',
|
||||
'Area' => number_format($area, 2),
|
||||
'Floors' => $floors,
|
||||
'Status' => $hasProposals ? '🔄 Has Proposals' : '✅ Ready'
|
||||
];
|
||||
} else {
|
||||
$cannotProcess++;
|
||||
if (!$buildingFunction) {
|
||||
$errorReasons[] = 'Missing building function';
|
||||
}
|
||||
if ($area <= 0) {
|
||||
$errorReasons[] = 'Missing/zero area';
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
// Show sample data table
|
||||
if (!empty($sampleData)) {
|
||||
$this->table(
|
||||
['ID', 'Name', 'Function', 'Area (m²)', 'Floors', 'Status'],
|
||||
$sampleData
|
||||
);
|
||||
}
|
||||
|
||||
// Show summary
|
||||
$this->newLine();
|
||||
$this->info("📈 SUMMARY:");
|
||||
$this->info(" ✅ Can Process: {$canProcess}");
|
||||
$this->info(" ❌ Cannot Process: {$cannotProcess}");
|
||||
$this->info(" 🔄 Has Existing Proposals: {$hasExisting}");
|
||||
|
||||
if ($cannotProcess > 0) {
|
||||
$this->warn(" ⚠️ Common Issues: " . implode(', ', array_unique($errorReasons)));
|
||||
}
|
||||
|
||||
$this->newLine();
|
||||
}
|
||||
|
||||
/**
|
||||
* Process all spatial plannings
|
||||
*/
|
||||
private function processAllSpatialPlannings($spatialPlannings, $force)
|
||||
{
|
||||
$this->info('🚀 Starting processing...');
|
||||
$this->newLine();
|
||||
|
||||
$progressBar = $this->output->createProgressBar($spatialPlannings->count());
|
||||
$progressBar->start();
|
||||
|
||||
$stats = [
|
||||
'processed' => 0,
|
||||
'skipped' => 0,
|
||||
'errors' => 0,
|
||||
'total_proposals' => 0,
|
||||
'total_amount' => 0
|
||||
];
|
||||
|
||||
$errors = [];
|
||||
|
||||
foreach ($spatialPlannings as $spatial) {
|
||||
try {
|
||||
$result = $this->processSingleSpatialPlanning($spatial, $force);
|
||||
|
||||
if ($result['success']) {
|
||||
$stats['processed']++;
|
||||
$stats['total_proposals'] += $result['proposals_count'];
|
||||
$stats['total_amount'] += $result['total_amount'];
|
||||
} elseif ($result['skipped']) {
|
||||
$stats['skipped']++;
|
||||
} else {
|
||||
$stats['errors']++;
|
||||
$errors[] = "ID {$spatial->id}: " . $result['error'];
|
||||
}
|
||||
|
||||
} catch (Exception $e) {
|
||||
$stats['errors']++;
|
||||
$errors[] = "ID {$spatial->id}: " . $e->getMessage();
|
||||
}
|
||||
|
||||
$progressBar->advance();
|
||||
}
|
||||
|
||||
$progressBar->finish();
|
||||
$this->newLine(2);
|
||||
|
||||
// Show final results
|
||||
$this->showFinalResults($stats, $errors);
|
||||
}
|
||||
|
||||
/**
|
||||
* Process single spatial planning
|
||||
*/
|
||||
private function processSingleSpatialPlanning(SpatialPlanning $spatial, $force)
|
||||
{
|
||||
// Check if already has proposals
|
||||
if (!$force && $spatial->retributionProposals()->exists()) {
|
||||
return ['success' => false, 'skipped' => true];
|
||||
}
|
||||
|
||||
// Detect building function
|
||||
$buildingFunction = $this->proposalService->detectBuildingFunction($spatial->getBuildingFunctionText());
|
||||
if (!$buildingFunction) {
|
||||
return ['success' => false, 'skipped' => false, 'error' => 'Cannot detect building function from: ' . $spatial->getBuildingFunctionText()];
|
||||
}
|
||||
|
||||
// Get area
|
||||
$totalArea = $spatial->getCalculationArea();
|
||||
if ($totalArea <= 0) {
|
||||
return ['success' => false, 'skipped' => false, 'error' => 'Area is zero or missing'];
|
||||
}
|
||||
|
||||
// Get number of floors
|
||||
$numberOfFloors = max(1, $spatial->number_of_floors ?? 1);
|
||||
|
||||
// Delete existing proposals if force mode
|
||||
if ($force) {
|
||||
$spatial->retributionProposals()->delete();
|
||||
}
|
||||
|
||||
$proposalsCount = 0;
|
||||
$totalAmount = 0;
|
||||
|
||||
// Create single proposal for the spatial planning (not per floor to prevent duplicates)
|
||||
// Use the highest floor for IP ketinggian calculation (worst case scenario)
|
||||
$highestFloor = $numberOfFloors;
|
||||
|
||||
$proposal = $this->proposalService->createProposalForSpatialPlanning(
|
||||
$spatial,
|
||||
$buildingFunction->id,
|
||||
$highestFloor, // Use highest floor for calculation
|
||||
$totalArea, // Use total area, not divided by floors
|
||||
$totalArea,
|
||||
"Auto-calculated from spatial planning data (floors: {$numberOfFloors})"
|
||||
);
|
||||
|
||||
if ($proposal) {
|
||||
$proposalsCount = 1;
|
||||
$totalAmount = $proposal->total_retribution_amount;
|
||||
}
|
||||
|
||||
return [
|
||||
'success' => true,
|
||||
'skipped' => false,
|
||||
'proposals_count' => $proposalsCount,
|
||||
'total_amount' => $totalAmount
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Show final results
|
||||
*/
|
||||
private function showFinalResults($stats, $errors)
|
||||
{
|
||||
$this->info('🎉 PROCESSING COMPLETED!');
|
||||
$this->newLine();
|
||||
|
||||
// Main statistics table
|
||||
$this->table(
|
||||
['Metric', 'Count'],
|
||||
[
|
||||
['✅ Successfully Processed', $stats['processed']],
|
||||
['⏭️ Skipped (Already Has Proposals)', $stats['skipped']],
|
||||
['❌ Errors', $stats['errors']],
|
||||
['📄 Total Proposals Created', $stats['total_proposals']],
|
||||
['💰 Total Retribution Amount', 'Rp ' . number_format($stats['total_amount'], 2)],
|
||||
]
|
||||
);
|
||||
|
||||
// Show success message
|
||||
if ($stats['processed'] > 0) {
|
||||
$this->newLine();
|
||||
$this->info("🎊 SUCCESS!");
|
||||
$this->info(" 📊 Created {$stats['total_proposals']} retribution proposals");
|
||||
$this->info(" 💵 Total calculated amount: Rp " . number_format($stats['total_amount'], 2));
|
||||
$this->info(" 📋 Processed {$stats['processed']} spatial plannings");
|
||||
}
|
||||
|
||||
// Show errors if any
|
||||
if ($stats['errors'] > 0) {
|
||||
$this->newLine();
|
||||
$this->warn("⚠️ ERRORS ENCOUNTERED:");
|
||||
foreach (array_slice($errors, 0, 10) as $error) {
|
||||
$this->warn(" • {$error}");
|
||||
}
|
||||
|
||||
if (count($errors) > 10) {
|
||||
$this->warn(" ... and " . (count($errors) - 10) . " more errors");
|
||||
}
|
||||
}
|
||||
|
||||
// Show next steps
|
||||
$this->newLine();
|
||||
$this->info("📋 NEXT STEPS:");
|
||||
$this->info(" • View proposals: php artisan spatial:check-constraints");
|
||||
$this->info(" • Check database: SELECT COUNT(*) FROM retribution_proposals;");
|
||||
$this->info(" • Access via API: GET /api/retribution-proposals");
|
||||
}
|
||||
}
|
||||
@@ -42,54 +42,4 @@ class ScrapingData extends Command
|
||||
|
||||
$this->info("Scraping job dispatched successfully");
|
||||
}
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
// public function handle()
|
||||
// {
|
||||
|
||||
// try {
|
||||
// // Create a record with "processing" status
|
||||
// $import_datasource = ImportDatasource::create([
|
||||
// 'message' => 'Initiating scraping...',
|
||||
// 'response_body' => null,
|
||||
// 'status' => 'processing',
|
||||
// 'start_time' => now()
|
||||
// ]);
|
||||
|
||||
// // Run the service
|
||||
// $service_google_sheet = new ServiceGoogleSheet();
|
||||
// $service_google_sheet->run_service();
|
||||
|
||||
// // Run the ServicePbgTask with injected Guzzle Client
|
||||
// $this->service_pbg_task->run_service();
|
||||
|
||||
// // run the service pbg task assignments
|
||||
// $this->service_tab_pbg_task->run_service();
|
||||
|
||||
// // Update the record status to "success" after completion
|
||||
// $import_datasource->update([
|
||||
// 'status' => 'success',
|
||||
// 'message' => 'Scraping completed successfully.',
|
||||
// 'finish_time' => now()
|
||||
// ]);
|
||||
|
||||
// } catch (\Exception $e) {
|
||||
|
||||
// // Log the error for debugging
|
||||
// Log::error('Scraping failed: ' . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
|
||||
|
||||
// // Handle errors by updating the status to "failed"
|
||||
// if (isset($import_datasource)) {
|
||||
// $import_datasource->update([
|
||||
// 'status' => 'failed',
|
||||
// 'response_body' => 'Error: ' . $e->getMessage(),
|
||||
// 'finish_time' => now()
|
||||
// ]);
|
||||
// }
|
||||
// }
|
||||
// }
|
||||
|
||||
|
||||
}
|
||||
|
||||
33
app/Console/Commands/ScrapingLeaderData.php
Normal file
33
app/Console/Commands/ScrapingLeaderData.php
Normal file
@@ -0,0 +1,33 @@
|
||||
<?php
|
||||
|
||||
namespace App\Console\Commands;
|
||||
|
||||
use App\Services\ServiceGoogleSheet;
|
||||
use Illuminate\Console\Command;
|
||||
|
||||
class ScrapingLeaderData extends Command
|
||||
{
|
||||
/**
|
||||
* The name and signature of the console command.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $signature = 'app:scraping-leader-data';
|
||||
|
||||
/**
|
||||
* The console command description.
|
||||
*
|
||||
* @var string
|
||||
*/
|
||||
protected $description = 'Scraping leader data from google spreadsheet and save to database';
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
public function handle()
|
||||
{
|
||||
$service_google_sheet = app(ServiceGoogleSheet::class);
|
||||
$service_google_sheet->sync_leader_data();
|
||||
$this->info('Leader data synced successfully');
|
||||
}
|
||||
}
|
||||
125
app/Console/Commands/TestExcelFormulaCommand.php
Normal file
125
app/Console/Commands/TestExcelFormulaCommand.php
Normal file
@@ -0,0 +1,125 @@
|
||||
<?php
|
||||
|
||||
namespace App\Console\Commands;
|
||||
|
||||
use Illuminate\Console\Command;
|
||||
use App\Services\DynamicRetributionCalculationService;
|
||||
|
||||
class TestExcelFormulaCommand extends Command
|
||||
{
|
||||
/**
|
||||
* The name and signature of the console command.
|
||||
*/
|
||||
protected $signature = 'test:excel-formula';
|
||||
|
||||
/**
|
||||
* The console command description.
|
||||
*/
|
||||
protected $description = 'Test Excel formula implementation for PBG retribution calculation';
|
||||
|
||||
/**
|
||||
* Execute the console command.
|
||||
*/
|
||||
public function handle()
|
||||
{
|
||||
$service = new DynamicRetributionCalculationService();
|
||||
|
||||
$this->info('=== TESTING RUNDOWN 4 IMPLEMENTATION ===');
|
||||
$this->info('Formula: =ROUNDDOWN(($E13*($F13+$G13+(0.5*I$3))),4)');
|
||||
$this->newLine();
|
||||
|
||||
// Test 1: Hunian Sederhana
|
||||
$this->info('1. HUNIAN SEDERHANA (1 Lantai, 100 m²)');
|
||||
|
||||
$result1 = $service->calculateRetribution(
|
||||
buildingFunctionId: 10, // HUNIAN_SEDERHANA
|
||||
floorLevel: 1,
|
||||
luasBangunan: 100,
|
||||
indeksLokasi: 'sedang',
|
||||
includeInfrastructure: true
|
||||
);
|
||||
|
||||
if ($result1['success']) {
|
||||
$rundown4 = $result1['calculation_breakdown']['rundown_4_calculation'];
|
||||
$retribution = $result1['calculation_breakdown']['retribution_calculation'];
|
||||
|
||||
$this->info(' ✓ Before ROUNDDOWN: ' . $rundown4['before_rounddown']);
|
||||
$this->info(' ✓ After ROUNDDOWN(4): ' . $rundown4['after_rounddown']);
|
||||
$this->info(' ✓ Basic Retribution: Rp ' . number_format($retribution['basic_amount']));
|
||||
$this->info(' ✓ Infrastructure: Rp ' . number_format($retribution['infrastructure_amount']));
|
||||
$this->info(' 💰 TOTAL: Rp ' . number_format($retribution['total_amount']));
|
||||
} else {
|
||||
$this->error(' ❌ Error: ' . $result1['error']);
|
||||
}
|
||||
$this->newLine();
|
||||
|
||||
// Test 2: Usaha Besar
|
||||
$this->info('2. USAHA BESAR (3 Lantai, 200 m²)');
|
||||
|
||||
$result2 = $service->calculateRetribution(
|
||||
buildingFunctionId: 9, // USAHA_BESAR
|
||||
floorLevel: 3,
|
||||
luasBangunan: 200,
|
||||
indeksLokasi: 'tinggi',
|
||||
includeInfrastructure: true
|
||||
);
|
||||
|
||||
if ($result2['success']) {
|
||||
$rundown4 = $result2['calculation_breakdown']['rundown_4_calculation'];
|
||||
$retribution = $result2['calculation_breakdown']['retribution_calculation'];
|
||||
|
||||
$this->info(' ✓ Rundown 4 Result: ' . $rundown4['after_rounddown']);
|
||||
$this->info(' ✓ Basic: Rp ' . number_format($retribution['basic_amount']));
|
||||
$this->info(' ✓ Infrastructure: Rp ' . number_format($retribution['infrastructure_amount']));
|
||||
$this->info(' 💰 TOTAL: Rp ' . number_format($retribution['total_amount']));
|
||||
}
|
||||
$this->newLine();
|
||||
|
||||
// Test 3: Keagamaan (Free)
|
||||
$this->info('3. KEAGAMAAN (2 Lantai, 150 m²) - BEBAS RETRIBUSI');
|
||||
|
||||
$result3 = $service->calculateRetribution(
|
||||
buildingFunctionId: 1, // KEAGAMAAN
|
||||
floorLevel: 2,
|
||||
luasBangunan: 150,
|
||||
indeksLokasi: 'sedang',
|
||||
includeInfrastructure: true
|
||||
);
|
||||
|
||||
if ($result3['success']) {
|
||||
$this->info(' ✓ Rundown 4 Result: ' . $result3['results']['h5_rundown4']);
|
||||
$this->info(' 💸 RETRIBUSI BEBAS: Rp ' . number_format($result3['results']['total_retribution']));
|
||||
}
|
||||
$this->newLine();
|
||||
|
||||
// Test 4: Multi-Floor Calculation
|
||||
$this->info('4. CAMPURAN BESAR - Multi Lantai (1-4 Lantai, 300 m²)');
|
||||
|
||||
$result4 = $service->calculateMultiFloorRetribution(
|
||||
buildingFunctionId: 7, // CAMPURAN_BESAR
|
||||
floors: [1, 2, 3, 4],
|
||||
luasBangunan: 300,
|
||||
indeksLokasi: 'tinggi'
|
||||
);
|
||||
|
||||
if ($result4['success']) {
|
||||
$this->info(' ✓ Per Floor Calculations:');
|
||||
foreach ($result4['floor_details'] as $floor => $detail) {
|
||||
$this->info(" Lantai {$floor}: H5={$detail['h5_rundown4']}, Total=Rp " . number_format($detail['total_retribution']));
|
||||
}
|
||||
$this->info(' 💰 TOTAL SEMUA LANTAI: Rp ' . number_format($result4['total_retribution']));
|
||||
}
|
||||
$this->newLine();
|
||||
|
||||
$this->info('=== RUNDOWN 4 VERIFICATION ===');
|
||||
$this->info('✅ Formula: =ROUNDDOWN(($E13*($F13+$G13+(0.5*I$3))),4)');
|
||||
$this->info('✅ ROUNDDOWN function with 4 decimal precision');
|
||||
$this->info('✅ Tarif Dasar: Rp 7.035.000');
|
||||
$this->info('✅ Infrastructure calculation: O3 * basic');
|
||||
$this->info('✅ Code simplified - unused formulas removed');
|
||||
$this->newLine();
|
||||
$this->info('🎉 RUNDOWN 4 Implementation is CLEAN and VERIFIED!');
|
||||
|
||||
return Command::SUCCESS;
|
||||
}
|
||||
}
|
||||
22
app/Enums/PbgTaskFilterData.php
Normal file
22
app/Enums/PbgTaskFilterData.php
Normal file
@@ -0,0 +1,22 @@
|
||||
<?php
|
||||
|
||||
namespace App\Enums;
|
||||
|
||||
enum PbgTaskFilterData : string
|
||||
{
|
||||
case non_business = 'non-business';
|
||||
case business = 'business';
|
||||
case verified = 'verified';
|
||||
case non_verified = 'non-verified';
|
||||
case all = 'all';
|
||||
|
||||
public static function getAllOptions() : array {
|
||||
return [
|
||||
self::all->value => 'Potensi Berkas',
|
||||
self::business->value => 'Usaha',
|
||||
self::non_business->value => 'Bukan Usaha',
|
||||
self::verified->value => 'Terverifikasi',
|
||||
self::non_verified->value => 'Belum Terverifikasi',
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -25,12 +25,13 @@ class BigDataResumeController extends Controller
|
||||
$filterDate = $request->get("filterByDate");
|
||||
|
||||
if (!$filterDate || $filterDate === "latest") {
|
||||
$big_data_resume = BigdataResume::where('year', now()->year)->latest()->first();
|
||||
$big_data_resume = BigdataResume::where('year', 'leader')->latest()->first();
|
||||
if (!$big_data_resume) {
|
||||
return $this->response_empty_resume();
|
||||
}
|
||||
} else {
|
||||
$big_data_resume = BigdataResume::whereDate('created_at', $filterDate)
|
||||
$big_data_resume = BigdataResume::where('year', 'leader')
|
||||
->whereDate('created_at', $filterDate)
|
||||
->orderBy('id', 'desc')
|
||||
->first();
|
||||
|
||||
|
||||
91
app/Http/Controllers/Api/GrowthReportAPIController.php
Normal file
91
app/Http/Controllers/Api/GrowthReportAPIController.php
Normal file
@@ -0,0 +1,91 @@
|
||||
<?php
|
||||
|
||||
namespace App\Http\Controllers\Api;
|
||||
|
||||
use App\Http\Controllers\Controller;
|
||||
use App\Models\BigdataResume;
|
||||
use Carbon\Carbon;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
class GrowthReportAPIController extends Controller
|
||||
{
|
||||
/**
|
||||
* Display a listing of the resource.
|
||||
*/
|
||||
public function index(Request $request)
|
||||
{
|
||||
// Get current date
|
||||
$today = Carbon::today();
|
||||
|
||||
// Define default range: 1 month back from today
|
||||
$defaultStart = $today->copy()->subMonth();
|
||||
$defaultEnd = $today;
|
||||
|
||||
// Use request values if provided, else use defaults
|
||||
// $startDate = $request->input('start_date', $defaultStart->toDateString());
|
||||
// $endDate = $request->input('end_date', $defaultEnd->toDateString());
|
||||
|
||||
// Optional year filter (used if specified)
|
||||
$year = $request->input('year', now()->year);
|
||||
|
||||
// $query = BigdataResume::selectRaw("
|
||||
// DATE(created_at) as date,
|
||||
// SUM(potention_sum) as potention_sum,
|
||||
// SUM(verified_sum) as verified_sum,
|
||||
// SUM(non_verified_sum) as non_verified_sum
|
||||
// ")
|
||||
// ->whereBetween('created_at', [$startDate, $endDate]);
|
||||
$query = BigdataResume::selectRaw("
|
||||
DATE(created_at) as date,
|
||||
SUM(potention_sum) as potention_sum,
|
||||
SUM(verified_sum) as verified_sum,
|
||||
SUM(non_verified_sum) as non_verified_sum
|
||||
");
|
||||
|
||||
$query->whereNotNull('year')
|
||||
->where('year', '!=', 'all');
|
||||
|
||||
$data = $query->groupBy(DB::raw('DATE(created_at)'))
|
||||
->orderBy(DB::raw('DATE(created_at)'))
|
||||
->get()
|
||||
->map(function ($item) {
|
||||
$item->date = Carbon::parse($item->date)->format('d M Y');
|
||||
return $item;
|
||||
});
|
||||
|
||||
return response()->json($data);
|
||||
}
|
||||
|
||||
/**
|
||||
* Store a newly created resource in storage.
|
||||
*/
|
||||
public function store(Request $request)
|
||||
{
|
||||
//
|
||||
}
|
||||
|
||||
/**
|
||||
* Display the specified resource.
|
||||
*/
|
||||
public function show(string $id)
|
||||
{
|
||||
//
|
||||
}
|
||||
|
||||
/**
|
||||
* Update the specified resource in storage.
|
||||
*/
|
||||
public function update(Request $request, string $id)
|
||||
{
|
||||
//
|
||||
}
|
||||
|
||||
/**
|
||||
* Remove the specified resource from storage.
|
||||
*/
|
||||
public function destroy(string $id)
|
||||
{
|
||||
//
|
||||
}
|
||||
}
|
||||
@@ -17,12 +17,16 @@ class LackOfPotentialController extends Controller
|
||||
$total_reklame = Advertisement::count();
|
||||
$total_pdam = Customer::count();
|
||||
$total_tata_ruang = SpatialPlanning::count();
|
||||
$total_tata_ruang_usaha = SpatialPlanning::where('building_function','like', '%usaha%')->count();
|
||||
$total_tata_ruang_non_usaha = SpatialPlanning::where('building_function','like', '%hunian%')->count();
|
||||
$data_report_tourism = TourismBasedKBLI::all();
|
||||
|
||||
return response()->json([
|
||||
'total_reklame' => $total_reklame,
|
||||
'total_pdam' => $total_pdam,
|
||||
'total_tata_ruang' => $total_tata_ruang,
|
||||
'total_tata_ruang_usaha' => $total_tata_ruang_usaha,
|
||||
'total_tata_ruang_non_usaha' => $total_tata_ruang_non_usaha,
|
||||
'data_report' => $data_report_tourism,
|
||||
], 200);
|
||||
}catch(\Exception $e){
|
||||
|
||||
@@ -8,7 +8,7 @@ use App\Http\Resources\RequestAssignmentResouce;
|
||||
use App\Models\PbgTask;
|
||||
use App\Models\PbgTaskGoogleSheet;
|
||||
use Barryvdh\DomPDF\Facade\Pdf;
|
||||
use DB;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Exception;
|
||||
use Illuminate\Http\Request;
|
||||
use Log;
|
||||
@@ -21,15 +21,48 @@ class RequestAssignmentController extends Controller
|
||||
*/
|
||||
public function index(Request $request)
|
||||
{
|
||||
$query = PbgTask::with(['attachments' => function ($q) {
|
||||
$q->whereIn('pbg_type', ['berita_acara', 'bukti_bayar']);
|
||||
}])->orderBy('id', 'desc');
|
||||
$query = PbgTask::with([
|
||||
'attachments' => function ($q) {
|
||||
$q->whereIn('pbg_type', ['berita_acara', 'bukti_bayar']);
|
||||
},
|
||||
'googleSheet'
|
||||
])->orderBy('id', 'desc');
|
||||
|
||||
if ($request->has('filter') && !empty($request->get('filter'))) {
|
||||
$filter = strtolower($request->get('filter'));
|
||||
|
||||
switch ($filter) {
|
||||
case 'non-business':
|
||||
$query->whereRaw("LOWER(function_type) != ?", ['sebagai tempat usaha'])->orWhereNull('function_type');
|
||||
break;
|
||||
|
||||
case 'business':
|
||||
$query->whereRaw("LOWER(function_type) = ?", ['sebagai tempat usaha']);
|
||||
break;
|
||||
|
||||
case 'verified':
|
||||
$query->whereHas('googleSheet', function ($q) {
|
||||
$q->whereRaw("LOWER(status_verifikasi) = ?", ['selesai verifikasi']);
|
||||
});
|
||||
break;
|
||||
|
||||
case 'non-verified':
|
||||
$query->where(function ($q) {
|
||||
$q->whereDoesntHave('googleSheet')
|
||||
->orWhereHas('googleSheet', function ($q2) {
|
||||
$q2->whereRaw("LOWER(status_verifikasi) != ?", ['selesai verifikasi'])->orWhereNull('status_verifikasi');
|
||||
});
|
||||
});
|
||||
break;
|
||||
}
|
||||
}
|
||||
|
||||
if ($request->has('search') && !empty($request->get("search"))) {
|
||||
$query->where(function ($q) use ($request) {
|
||||
$q->where('name', 'LIKE', '%' . $request->get('search') . '%')
|
||||
->orWhere('registration_number', 'LIKE', '%' . $request->get('search') . '%')
|
||||
->orWhere('document_number', 'LIKE', '%' . $request->get('search') . '%');
|
||||
$search = $request->get('search');
|
||||
$query->where(function ($q) use ($search) {
|
||||
$q->where('name', 'LIKE', "%$search%")
|
||||
->orWhere('registration_number', 'LIKE', "%$search%")
|
||||
->orWhere('document_number', 'LIKE', "%$search%");
|
||||
});
|
||||
}
|
||||
|
||||
|
||||
59
app/Http/Controllers/Auth/AuthenticatedSessionController.php
Executable file → Normal file
59
app/Http/Controllers/Auth/AuthenticatedSessionController.php
Executable file → Normal file
@@ -36,13 +36,68 @@ class AuthenticatedSessionController extends Controller
|
||||
// Ambil user yang sedang login
|
||||
$user = Auth::user();
|
||||
|
||||
// Buat token untuk API
|
||||
$token = $user->createToken(env('APP_KEY'))->plainTextToken;
|
||||
// Hapus token lama jika ada
|
||||
$user->tokens()->delete();
|
||||
|
||||
// Buat token untuk API dengan scope dan expiration
|
||||
$tokenName = config('app.name', 'Laravel') . '-' . $user->id . '-' . time();
|
||||
|
||||
// Token dengan scope (opsional)
|
||||
$token = $user->createToken($tokenName, ['*'], now()->addDays(30))->plainTextToken;
|
||||
|
||||
// Simpan token di session untuk digunakan di frontend
|
||||
session(['api_token' => $token]);
|
||||
|
||||
return redirect()->intended(RouteServiceProvider::HOME);
|
||||
}
|
||||
|
||||
/**
|
||||
* Generate API token for authenticated user
|
||||
*
|
||||
* @param \Illuminate\Http\Request $request
|
||||
* @return \Illuminate\Http\JsonResponse
|
||||
*/
|
||||
public function generateApiToken(Request $request)
|
||||
{
|
||||
$user = Auth::user();
|
||||
|
||||
if (!$user) {
|
||||
return response()->json(['error' => 'Unauthorized'], 401);
|
||||
}
|
||||
|
||||
// Delete existing tokens
|
||||
$user->tokens()->delete();
|
||||
|
||||
// Generate new token
|
||||
$tokenName = config('app.name', 'Laravel') . '-' . $user->id . '-' . time();
|
||||
$token = $user->createToken($tokenName, ['*'], now()->addDays(30))->plainTextToken;
|
||||
|
||||
return response()->json([
|
||||
'token' => $token,
|
||||
'token_type' => 'Bearer',
|
||||
'expires_in' => 30 * 24 * 60 * 60, // 30 days in seconds
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Revoke API token for authenticated user
|
||||
*
|
||||
* @param \Illuminate\Http\Request $request
|
||||
* @return \Illuminate\Http\JsonResponse
|
||||
*/
|
||||
public function revokeApiToken(Request $request)
|
||||
{
|
||||
$user = Auth::user();
|
||||
|
||||
if (!$user) {
|
||||
return response()->json(['error' => 'Unauthorized'], 401);
|
||||
}
|
||||
|
||||
$user->tokens()->delete();
|
||||
|
||||
return response()->json(['message' => 'All tokens revoked successfully']);
|
||||
}
|
||||
|
||||
/**
|
||||
* Destroy an authenticated session.
|
||||
*
|
||||
|
||||
0
app/Http/Controllers/Auth/ConfirmablePasswordController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/ConfirmablePasswordController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/EmailVerificationNotificationController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/EmailVerificationNotificationController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/EmailVerificationPromptController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/EmailVerificationPromptController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/NewPasswordController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/NewPasswordController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/PasswordResetLinkController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/PasswordResetLinkController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/RegisteredUserController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/RegisteredUserController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/VerifyEmailController.php
Executable file → Normal file
0
app/Http/Controllers/Auth/VerifyEmailController.php
Executable file → Normal file
0
app/Http/Controllers/Controller.php
Executable file → Normal file
0
app/Http/Controllers/Controller.php
Executable file → Normal file
@@ -4,6 +4,7 @@ namespace App\Http\Controllers\Dashboards;
|
||||
|
||||
use App\Http\Controllers\Controller;
|
||||
use App\Models\ImportDatasource;
|
||||
use App\Models\Menu;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class BigDataController extends Controller
|
||||
@@ -12,11 +13,21 @@ class BigDataController extends Controller
|
||||
$latest_import_datasource = ImportDatasource::latest()->first();
|
||||
$latest_created = $latest_import_datasource ?
|
||||
$latest_import_datasource->created_at->format("j F Y H:i:s") : null;
|
||||
return view('dashboards.bigdata', compact('latest_created'));
|
||||
$menus = Menu::all();
|
||||
return view('dashboards.bigdata', compact('latest_created', 'menus'));
|
||||
}
|
||||
|
||||
public function pbg()
|
||||
{
|
||||
return view('dashboards.pbg');
|
||||
}
|
||||
|
||||
public function leader()
|
||||
{
|
||||
$latest_import_datasource = ImportDatasource::latest()->first();
|
||||
$latest_created = $latest_import_datasource ?
|
||||
$latest_import_datasource->created_at->format("j F Y H:i:s") : null;
|
||||
$menus = Menu::all();
|
||||
return view('dashboards.leader', compact('latest_created', 'menus'));
|
||||
}
|
||||
}
|
||||
|
||||
@@ -3,12 +3,14 @@
|
||||
namespace App\Http\Controllers\Dashboards;
|
||||
|
||||
use App\Http\Controllers\Controller;
|
||||
use App\Models\Menu;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class PotentialsController extends Controller
|
||||
{
|
||||
public function inside_system(){
|
||||
return view('dashboards.potentials.inside_system');
|
||||
$menus = Menu::all();
|
||||
return view('dashboards.potentials.inside_system', compact('menus'));
|
||||
}
|
||||
public function outside_system(){
|
||||
return view('dashboards.potentials.outside_system');
|
||||
|
||||
87
app/Http/Controllers/QuickSearchController.php
Normal file
87
app/Http/Controllers/QuickSearchController.php
Normal file
@@ -0,0 +1,87 @@
|
||||
<?php
|
||||
|
||||
namespace App\Http\Controllers;
|
||||
|
||||
use App\Enums\PbgTaskApplicationTypes;
|
||||
use App\Enums\PbgTaskStatus;
|
||||
use App\Http\Resources\TaskAssignmentsResource;
|
||||
use App\Models\PbgTask;
|
||||
use App\Models\TaskAssignment;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class QuickSearchController extends Controller
|
||||
{
|
||||
public function index(){
|
||||
return view("quick-search.index");
|
||||
}
|
||||
|
||||
public function search_result(Request $request){
|
||||
$keyword = $request->get("keyword");
|
||||
|
||||
return view('quick-search.result', compact('keyword'));
|
||||
}
|
||||
|
||||
public function quick_search_datatable(Request $request)
|
||||
{
|
||||
try {
|
||||
$query = PbgTask::orderBy('id', 'desc');
|
||||
|
||||
if ($request->filled('search')) {
|
||||
$search = $request->get('search');
|
||||
$query->where(function ($q) use ($search) {
|
||||
$q->where('name', 'LIKE', "%$search%")
|
||||
->orWhere('registration_number', 'LIKE', "%$search%")
|
||||
->orWhere('address', 'LIKE', "%$search%")
|
||||
->orWhere('document_number', 'LIKE', "%$search%");
|
||||
});
|
||||
}
|
||||
|
||||
return response()->json($query->paginate());
|
||||
} catch (\Throwable $e) {
|
||||
\Log::error("Error fetching datatable data: " . $e->getMessage());
|
||||
return response()->json([
|
||||
'message' => 'Terjadi kesalahan saat mengambil data.',
|
||||
'error' => $e->getMessage(),
|
||||
], 500);
|
||||
}
|
||||
}
|
||||
|
||||
public function show($id)
|
||||
{
|
||||
try {
|
||||
$data = PbgTask::with([
|
||||
'pbg_task_retributions',
|
||||
'pbg_task_index_integrations',
|
||||
'pbg_task_retributions.pbg_task_prasarana'
|
||||
])->findOrFail($id);
|
||||
|
||||
$statusOptions = PbgTaskStatus::getStatuses();
|
||||
$applicationTypes = PbgTaskApplicationTypes::labels();
|
||||
|
||||
return view("quick-search.detail", compact("data", 'statusOptions', 'applicationTypes'));
|
||||
} catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) {
|
||||
\Log::warning("PbgTask with ID {$id} not found.");
|
||||
return redirect()->route('quick-search.index')->with('error', 'Data tidak ditemukan.');
|
||||
} catch (\Throwable $e) {
|
||||
\Log::error("Error in QuickSearchController@show: " . $e->getMessage());
|
||||
return response()->view('pages.404', [], 500); // Optional: create `resources/views/errors/500.blade.php`
|
||||
}
|
||||
}
|
||||
|
||||
public function task_assignments(Request $request, $uuid){
|
||||
try{
|
||||
$query = TaskAssignment::query()
|
||||
->where('pbg_task_uid', $uuid)
|
||||
->orderBy('id', 'desc');
|
||||
|
||||
if ($request->filled('search')) {
|
||||
$query->where('name', 'like', "%{$request->get('search')}%")
|
||||
->orWhere('email', 'like', "%{$request->get('search')}%");
|
||||
}
|
||||
|
||||
return TaskAssignmentsResource::collection($query->paginate(config('app.paginate_per_page', 50)));
|
||||
}catch(\Exception $exception){
|
||||
return response()->json(['message' => $exception->getMessage()], 500);
|
||||
}
|
||||
}
|
||||
}
|
||||
14
app/Http/Controllers/Report/GrowthReportsController.php
Normal file
14
app/Http/Controllers/Report/GrowthReportsController.php
Normal file
@@ -0,0 +1,14 @@
|
||||
<?php
|
||||
|
||||
namespace App\Http\Controllers\Report;
|
||||
|
||||
use App\Http\Controllers\Controller;
|
||||
use App\Models\Menu;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class GrowthReportsController extends Controller
|
||||
{
|
||||
public function index(){
|
||||
return view('report.growth-report.index');
|
||||
}
|
||||
}
|
||||
@@ -3,6 +3,7 @@
|
||||
namespace App\Http\Controllers\RequestAssignment;
|
||||
|
||||
use App\Enums\PbgTaskApplicationTypes;
|
||||
use App\Enums\PbgTaskFilterData;
|
||||
use App\Http\Controllers\Controller;
|
||||
use App\Models\PbgTask;
|
||||
use Illuminate\Http\Request;
|
||||
@@ -17,27 +18,21 @@ class PbgTaskController extends Controller
|
||||
*/
|
||||
public function index(Request $request)
|
||||
{
|
||||
$menuId = $request->query('menu_id');
|
||||
$user = Auth::user();
|
||||
$userId = $user->id;
|
||||
$menuId = $request->query('menu_id') ?? $request->input('menu_id');
|
||||
$filter = $request->query('filter');
|
||||
|
||||
// Ambil role_id yang dimiliki user
|
||||
$roleIds = DB::table('user_role')
|
||||
->where('user_id', $userId)
|
||||
->pluck('role_id');
|
||||
$permissions = $this->permissions[$menuId]?? []; // Avoid undefined index error
|
||||
$creator = $permissions['allow_create'] ?? 0;
|
||||
$updater = $permissions['allow_update'] ?? 0;
|
||||
$destroyer = $permissions['allow_destroy'] ?? 0;
|
||||
|
||||
// Ambil data akses berdasarkan role_id dan menu_id
|
||||
$roleAccess = DB::table('role_menu')
|
||||
->whereIn('role_id', $roleIds)
|
||||
->where('menu_id', $menuId)
|
||||
->first();
|
||||
|
||||
// Pastikan roleAccess tidak null sebelum mengakses properti
|
||||
$creator = $roleAccess->allow_create ?? 0;
|
||||
$updater = $roleAccess->allow_update ?? 0;
|
||||
$destroyer = $roleAccess->allow_destroy ?? 0;
|
||||
|
||||
return view('pbg_task.index', compact('creator', 'updater', 'destroyer'));
|
||||
return view('pbg_task.index', [
|
||||
'creator' => $creator,
|
||||
'updater' => $updater,
|
||||
'destroyer' => $destroyer,
|
||||
'filter' => $filter,
|
||||
'filterOptions' => PbgTaskFilterData::getAllOptions(),
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
|
||||
295
app/Http/Controllers/RetributionProposalController.php
Normal file
295
app/Http/Controllers/RetributionProposalController.php
Normal file
@@ -0,0 +1,295 @@
|
||||
<?php
|
||||
|
||||
namespace App\Http\Controllers;
|
||||
|
||||
use App\Models\RetributionProposal;
|
||||
use App\Models\SpatialPlanning;
|
||||
use App\Models\BuildingFunction;
|
||||
use App\Services\RetributionProposalService;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\JsonResponse;
|
||||
|
||||
class RetributionProposalController extends Controller
|
||||
{
|
||||
protected RetributionProposalService $proposalService;
|
||||
|
||||
public function __construct(RetributionProposalService $proposalService)
|
||||
{
|
||||
$this->proposalService = $proposalService;
|
||||
}
|
||||
|
||||
/**
|
||||
* Display a listing of retribution proposals
|
||||
*/
|
||||
public function index(Request $request): JsonResponse
|
||||
{
|
||||
$query = RetributionProposal::with(['spatialPlanning', 'buildingFunction', 'retributionFormula']);
|
||||
|
||||
// Filtering
|
||||
if ($request->has('building_function_id')) {
|
||||
$query->where('building_function_id', $request->building_function_id);
|
||||
}
|
||||
|
||||
if ($request->has('spatial_planning_id')) {
|
||||
$query->where('spatial_planning_id', $request->spatial_planning_id);
|
||||
}
|
||||
|
||||
if ($request->has('floor_number')) {
|
||||
$query->where('floor_number', $request->floor_number);
|
||||
}
|
||||
|
||||
if ($request->has('has_spatial_planning')) {
|
||||
if ($request->boolean('has_spatial_planning')) {
|
||||
$query->whereNotNull('spatial_planning_id');
|
||||
} else {
|
||||
$query->whereNull('spatial_planning_id');
|
||||
}
|
||||
}
|
||||
|
||||
// Search
|
||||
if ($request->has('search')) {
|
||||
$search = $request->search;
|
||||
$query->where(function ($q) use ($search) {
|
||||
$q->where('proposal_number', 'like', "%{$search}%")
|
||||
->orWhere('notes', 'like', "%{$search}%")
|
||||
->orWhereHas('spatialPlanning', function ($sq) use ($search) {
|
||||
$sq->where('name', 'like', "%{$search}%");
|
||||
})
|
||||
->orWhereHas('buildingFunction', function ($bq) use ($search) {
|
||||
$bq->where('name', 'like', "%{$search}%");
|
||||
});
|
||||
});
|
||||
}
|
||||
|
||||
// Sorting
|
||||
$sortBy = $request->get('sort_by', 'created_at');
|
||||
$sortOrder = $request->get('sort_order', 'desc');
|
||||
$query->orderBy($sortBy, $sortOrder);
|
||||
|
||||
// Pagination
|
||||
$perPage = $request->get('per_page', 15);
|
||||
$proposals = $query->paginate($perPage);
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'data' => $proposals,
|
||||
'meta' => [
|
||||
'total_amount' => RetributionProposal::sum('total_retribution_amount'),
|
||||
'total_proposals' => RetributionProposal::count(),
|
||||
'formatted_total_amount' => 'Rp ' . number_format(RetributionProposal::sum('total_retribution_amount'), 0, ',', '.')
|
||||
]
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Store a new retribution proposal
|
||||
*/
|
||||
public function store(Request $request): JsonResponse
|
||||
{
|
||||
$request->validate([
|
||||
'spatial_planning_id' => 'nullable|exists:spatial_plannings,id',
|
||||
'building_function_id' => 'required|exists:building_functions,id',
|
||||
'floor_number' => 'required|integer|min:1|max:10',
|
||||
'floor_area' => 'required|numeric|min:0.01',
|
||||
'total_building_area' => 'nullable|numeric|min:0.01',
|
||||
'notes' => 'nullable|string|max:1000'
|
||||
]);
|
||||
|
||||
try {
|
||||
if ($request->spatial_planning_id) {
|
||||
$spatialPlanning = SpatialPlanning::findOrFail($request->spatial_planning_id);
|
||||
$proposal = $this->proposalService->createProposalForSpatialPlanning(
|
||||
$spatialPlanning,
|
||||
$request->building_function_id,
|
||||
$request->floor_number,
|
||||
$request->floor_area,
|
||||
$request->total_building_area,
|
||||
$request->notes
|
||||
);
|
||||
} else {
|
||||
$proposal = $this->proposalService->createStandaloneProposal(
|
||||
$request->building_function_id,
|
||||
$request->floor_number,
|
||||
$request->floor_area,
|
||||
$request->total_building_area,
|
||||
$request->notes
|
||||
);
|
||||
}
|
||||
|
||||
$proposal->load(['spatialPlanning', 'buildingFunction', 'retributionFormula']);
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'message' => 'Retribution proposal created successfully',
|
||||
'data' => $proposal
|
||||
], 201);
|
||||
|
||||
} catch (\Exception $e) {
|
||||
return response()->json([
|
||||
'success' => false,
|
||||
'message' => 'Failed to create retribution proposal',
|
||||
'error' => $e->getMessage()
|
||||
], 400);
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Display the specified retribution proposal
|
||||
*/
|
||||
public function show(int $id): JsonResponse
|
||||
{
|
||||
$proposal = RetributionProposal::with(['spatialPlanning', 'buildingFunction', 'retributionFormula'])
|
||||
->findOrFail($id);
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'data' => $proposal
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Update the specified retribution proposal
|
||||
*/
|
||||
public function update(Request $request, int $id): JsonResponse
|
||||
{
|
||||
$proposal = RetributionProposal::findOrFail($id);
|
||||
|
||||
$request->validate([
|
||||
'notes' => 'nullable|string|max:1000'
|
||||
]);
|
||||
|
||||
$proposal->update($request->only(['notes']));
|
||||
|
||||
$proposal->load(['spatialPlanning', 'buildingFunction', 'retributionFormula']);
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'message' => 'Retribution proposal updated successfully',
|
||||
'data' => $proposal
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Remove the specified retribution proposal
|
||||
*/
|
||||
public function destroy(int $id): JsonResponse
|
||||
{
|
||||
$proposal = RetributionProposal::findOrFail($id);
|
||||
$proposal->delete();
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'message' => 'Retribution proposal deleted successfully'
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Get retribution proposal statistics
|
||||
*/
|
||||
public function statistics(): JsonResponse
|
||||
{
|
||||
$stats = $this->proposalService->getStatistics();
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'data' => $stats
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Get total sum of all retribution proposals
|
||||
*/
|
||||
public function totalSum(): JsonResponse
|
||||
{
|
||||
$totalAmount = RetributionProposal::sum('total_retribution_amount');
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'data' => [
|
||||
'total_amount' => $totalAmount,
|
||||
'formatted_total_amount' => 'Rp ' . number_format($totalAmount, 0, ',', '.'),
|
||||
'total_proposals' => RetributionProposal::count()
|
||||
]
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Get building functions list
|
||||
*/
|
||||
public function buildingFunctions(): JsonResponse
|
||||
{
|
||||
$buildingFunctions = BuildingFunction::whereNotNull('parent_id')
|
||||
->with(['parameter'])
|
||||
->orderBy('name')
|
||||
->get();
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'data' => $buildingFunctions
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Auto-detect building function and create proposal
|
||||
*/
|
||||
public function autoCreateProposal(Request $request): JsonResponse
|
||||
{
|
||||
$request->validate([
|
||||
'spatial_planning_id' => 'nullable|exists:spatial_plannings,id',
|
||||
'building_function_text' => 'required|string',
|
||||
'floor_number' => 'required|integer|min:1|max:10',
|
||||
'floor_area' => 'required|numeric|min:0.01',
|
||||
'total_building_area' => 'nullable|numeric|min:0.01',
|
||||
'notes' => 'nullable|string|max:1000'
|
||||
]);
|
||||
|
||||
try {
|
||||
// Auto-detect building function
|
||||
$buildingFunction = $this->proposalService->detectBuildingFunction($request->building_function_text);
|
||||
|
||||
if (!$buildingFunction) {
|
||||
return response()->json([
|
||||
'success' => false,
|
||||
'message' => 'Could not detect building function from text',
|
||||
'suggestion' => 'Please specify building function manually'
|
||||
], 400);
|
||||
}
|
||||
|
||||
if ($request->spatial_planning_id) {
|
||||
$spatialPlanning = SpatialPlanning::findOrFail($request->spatial_planning_id);
|
||||
$proposal = $this->proposalService->createProposalForSpatialPlanning(
|
||||
$spatialPlanning,
|
||||
$buildingFunction->id,
|
||||
$request->floor_number,
|
||||
$request->floor_area,
|
||||
$request->total_building_area,
|
||||
$request->notes
|
||||
);
|
||||
} else {
|
||||
$proposal = $this->proposalService->createStandaloneProposal(
|
||||
$buildingFunction->id,
|
||||
$request->floor_number,
|
||||
$request->floor_area,
|
||||
$request->total_building_area,
|
||||
$request->notes
|
||||
);
|
||||
}
|
||||
|
||||
$proposal->load(['spatialPlanning', 'buildingFunction', 'retributionFormula']);
|
||||
|
||||
return response()->json([
|
||||
'success' => true,
|
||||
'message' => 'Retribution proposal created successfully with auto-detected building function',
|
||||
'data' => $proposal,
|
||||
'detected_building_function' => $buildingFunction->name
|
||||
], 201);
|
||||
|
||||
} catch (\Exception $e) {
|
||||
return response()->json([
|
||||
'success' => false,
|
||||
'message' => 'Failed to create retribution proposal',
|
||||
'error' => $e->getMessage()
|
||||
], 400);
|
||||
}
|
||||
}
|
||||
}
|
||||
0
app/Http/Controllers/RoutingController.php
Executable file → Normal file
0
app/Http/Controllers/RoutingController.php
Executable file → Normal file
0
app/Http/Requests/Auth/LoginRequest.php
Executable file → Normal file
0
app/Http/Requests/Auth/LoginRequest.php
Executable file → Normal file
@@ -19,8 +19,8 @@ class DataSettingResource extends JsonResource
|
||||
'key' => $this->key,
|
||||
'value' => $this->value,
|
||||
'type' => $this->type,
|
||||
'created_at' => $this->created_at->toDateTimeString(),
|
||||
'updated_at' => $this->updated_at->toDateTimeString(),
|
||||
'created_at' => $this->created_at ? $this->created_at->toDateTimeString() : null,
|
||||
'updated_at' => $this->updated_at ? $this->updated_at->toDateTimeString() : null,
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
@@ -60,10 +60,10 @@ class ScrapingDataJob implements ShouldQueue
|
||||
throw $e;
|
||||
}
|
||||
|
||||
$data_setting_result = $service_google_sheet->get_big_resume_data();
|
||||
// $data_setting_result = $service_google_sheet->get_big_resume_data();
|
||||
|
||||
BigdataResume::generateResumeData($import_datasource->id, "all", $data_setting_result);
|
||||
BigdataResume::generateResumeData($import_datasource->id, now()->year, $data_setting_result);
|
||||
// BigdataResume::generateResumeData($import_datasource->id, "all", $data_setting_result);
|
||||
// BigdataResume::generateResumeData($import_datasource->id, now()->year, $data_setting_result);
|
||||
|
||||
// Update status to success
|
||||
$import_datasource->update([
|
||||
@@ -79,7 +79,7 @@ class ScrapingDataJob implements ShouldQueue
|
||||
if (isset($import_datasource)) {
|
||||
$import_datasource->update([
|
||||
'status' => 'failed',
|
||||
'response_body' => 'Error: ' . $e->getMessage(),
|
||||
'response_body' => 'Terjadi kesalahan, Syncronize tidak selesai',
|
||||
'finish_time' => now(),
|
||||
'failed_uuid' => $failed_uuid,
|
||||
]);
|
||||
|
||||
167
app/Models/BuildingFunction.php
Normal file
167
app/Models/BuildingFunction.php
Normal file
@@ -0,0 +1,167 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\HasOne;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
|
||||
class BuildingFunction extends Model
|
||||
{
|
||||
protected $table = 'building_functions';
|
||||
|
||||
protected $fillable = [
|
||||
'code',
|
||||
'name',
|
||||
'description',
|
||||
'parent_id',
|
||||
'level',
|
||||
'sort_order',
|
||||
'base_tariff'
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'level' => 'integer',
|
||||
'sort_order' => 'integer',
|
||||
'base_tariff' => 'decimal:2'
|
||||
];
|
||||
|
||||
/**
|
||||
* Parent relationship (self-referencing)
|
||||
*/
|
||||
public function parent(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class, 'parent_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Children relationship (self-referencing)
|
||||
*/
|
||||
public function children(): HasMany
|
||||
{
|
||||
return $this->hasMany(BuildingFunction::class, 'parent_id')
|
||||
->orderBy('sort_order');
|
||||
}
|
||||
|
||||
/**
|
||||
* Parameters relationship (1:1)
|
||||
*/
|
||||
public function parameter(): HasOne
|
||||
{
|
||||
return $this->hasOne(BuildingFunctionParameter::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Formulas relationship (1:n) - multiple formulas for different floor numbers
|
||||
*/
|
||||
public function formulas(): HasMany
|
||||
{
|
||||
return $this->hasMany(RetributionFormula::class)->orderBy('floor_number');
|
||||
}
|
||||
|
||||
/**
|
||||
* Get appropriate formula based on floor number
|
||||
*/
|
||||
public function getFormulaForFloor(int $floorNumber): ?RetributionFormula
|
||||
{
|
||||
return $this->formulas()
|
||||
->where('floor_number', $floorNumber)
|
||||
->first();
|
||||
}
|
||||
|
||||
/**
|
||||
* Retribution proposals relationship (1:n)
|
||||
*/
|
||||
public function retributionProposals(): HasMany
|
||||
{
|
||||
return $this->hasMany(RetributionProposal::class, 'building_function_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: Parent functions only
|
||||
*/
|
||||
public function scopeParents($query)
|
||||
{
|
||||
return $query->whereNull('parent_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: Children functions only
|
||||
*/
|
||||
public function scopeChildren($query)
|
||||
{
|
||||
return $query->whereNotNull('parent_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: By level
|
||||
*/
|
||||
public function scopeByLevel($query, int $level)
|
||||
{
|
||||
return $query->where('level', $level);
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if building function has complete setup (parameters + at least one formula)
|
||||
*/
|
||||
public function hasCompleteSetup(): bool
|
||||
{
|
||||
return $this->parameter()->exists() && $this->formulas()->exists();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get building function with all related data
|
||||
*/
|
||||
public function getCompleteData(): array
|
||||
{
|
||||
return [
|
||||
'id' => $this->id,
|
||||
'code' => $this->code,
|
||||
'name' => $this->name,
|
||||
'description' => $this->description,
|
||||
'level' => $this->level,
|
||||
'sort_order' => $this->sort_order,
|
||||
'base_tariff' => $this->base_tariff,
|
||||
'parameters' => $this->parameter?->getParametersArray(),
|
||||
'formulas' => $this->formulas->map(function ($formula) {
|
||||
return [
|
||||
'id' => $formula->id,
|
||||
'name' => $formula->name,
|
||||
'expression' => $formula->formula_expression,
|
||||
'floor_number' => $formula->floor_number,
|
||||
'floor_description' => $this->getFloorDescription($formula->floor_number)
|
||||
];
|
||||
})->toArray(),
|
||||
'has_complete_setup' => $this->hasCompleteSetup()
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Get floor description
|
||||
*/
|
||||
public function getFloorDescription(?int $floorNumber): string
|
||||
{
|
||||
if ($floorNumber === null || $floorNumber === 0) {
|
||||
return 'Semua lantai';
|
||||
}
|
||||
|
||||
return "Lantai {$floorNumber}";
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if this is a parent function
|
||||
*/
|
||||
public function isParent(): bool
|
||||
{
|
||||
return $this->parent_id === null;
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if this is a child function
|
||||
*/
|
||||
public function isChild(): bool
|
||||
{
|
||||
return $this->parent_id !== null;
|
||||
}
|
||||
}
|
||||
110
app/Models/BuildingFunctionFormulaConfig.php
Normal file
110
app/Models/BuildingFunctionFormulaConfig.php
Normal file
@@ -0,0 +1,110 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
|
||||
class BuildingFunctionFormulaConfig extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected $fillable = [
|
||||
'building_function_id',
|
||||
'formula_id',
|
||||
'floor_level',
|
||||
'min_floor',
|
||||
'max_floor',
|
||||
'multiplier',
|
||||
'is_active',
|
||||
'priority',
|
||||
'notes',
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'multiplier' => 'decimal:4',
|
||||
'is_active' => 'boolean',
|
||||
'min_floor' => 'integer',
|
||||
'max_floor' => 'integer',
|
||||
'floor_level' => 'integer',
|
||||
'priority' => 'integer',
|
||||
];
|
||||
|
||||
/**
|
||||
* Relationship to BuildingFunction
|
||||
*/
|
||||
public function buildingFunction()
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class, 'building_function_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship to MasterFormula
|
||||
*/
|
||||
public function formula()
|
||||
{
|
||||
return $this->belongsTo(MasterFormula::class, 'formula_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope untuk konfigurasi aktif
|
||||
*/
|
||||
public function scopeActive($query)
|
||||
{
|
||||
return $query->where('is_active', true);
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope untuk mencari berdasarkan building function dan floor level
|
||||
*/
|
||||
public function scopeForBuildingAndFloor($query, $buildingFunctionId, $floorLevel)
|
||||
{
|
||||
return $query->where('building_function_id', $buildingFunctionId)
|
||||
->where(function($q) use ($floorLevel) {
|
||||
$q->where('floor_level', $floorLevel)
|
||||
->orWhere('floor_level', 0) // 0 = berlaku untuk semua lantai
|
||||
->orWhere(function($qq) use ($floorLevel) {
|
||||
$qq->whereNotNull('min_floor')
|
||||
->whereNotNull('max_floor')
|
||||
->where('min_floor', '<=', $floorLevel)
|
||||
->where('max_floor', '>=', $floorLevel);
|
||||
});
|
||||
})
|
||||
->orderBy('priority', 'desc')
|
||||
->orderBy('floor_level', 'desc'); // Prioritas: spesifik floor > range > semua lantai
|
||||
}
|
||||
|
||||
/**
|
||||
* Method untuk mendapatkan formula yang tepat untuk building function dan floor tertentu
|
||||
*/
|
||||
public static function getFormulaForBuildingAndFloor($buildingFunctionId, $floorLevel)
|
||||
{
|
||||
return self::active()
|
||||
->forBuildingAndFloor($buildingFunctionId, $floorLevel)
|
||||
->with('formula')
|
||||
->first();
|
||||
}
|
||||
|
||||
/**
|
||||
* Method untuk check apakah floor level masuk dalam range
|
||||
*/
|
||||
public function isFloorInRange($floorLevel)
|
||||
{
|
||||
// Jika floor_level = 0, berlaku untuk semua lantai
|
||||
if ($this->floor_level == 0) {
|
||||
return true;
|
||||
}
|
||||
|
||||
// Jika ada specific floor level
|
||||
if ($this->floor_level == $floorLevel) {
|
||||
return true;
|
||||
}
|
||||
|
||||
// Jika ada range min-max
|
||||
if (!is_null($this->min_floor) && !is_null($this->max_floor)) {
|
||||
return $floorLevel >= $this->min_floor && $floorLevel <= $this->max_floor;
|
||||
}
|
||||
|
||||
return false;
|
||||
}
|
||||
}
|
||||
134
app/Models/BuildingFunctionParameter.php
Normal file
134
app/Models/BuildingFunctionParameter.php
Normal file
@@ -0,0 +1,134 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
|
||||
class BuildingFunctionParameter extends Model
|
||||
{
|
||||
protected $fillable = [
|
||||
'building_function_id',
|
||||
'fungsi_bangunan',
|
||||
'ip_permanen',
|
||||
'ip_kompleksitas',
|
||||
'indeks_lokalitas',
|
||||
'asumsi_prasarana',
|
||||
'koefisien_dasar',
|
||||
'faktor_penyesuaian',
|
||||
'custom_parameters',
|
||||
'parameter_notes'
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'fungsi_bangunan' => 'decimal:6',
|
||||
'ip_permanen' => 'decimal:6',
|
||||
'ip_kompleksitas' => 'decimal:6',
|
||||
'indeks_lokalitas' => 'decimal:6',
|
||||
'asumsi_prasarana' => 'decimal:6',
|
||||
'koefisien_dasar' => 'decimal:6',
|
||||
'faktor_penyesuaian' => 'decimal:6',
|
||||
'custom_parameters' => 'array'
|
||||
];
|
||||
|
||||
/**
|
||||
* Building function relationship (1:1)
|
||||
*/
|
||||
public function buildingFunction(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: Active parameters only
|
||||
*/
|
||||
public function scopeActive($query)
|
||||
{
|
||||
return $query->where('is_active', true);
|
||||
}
|
||||
|
||||
/**
|
||||
* Get all parameter values as array
|
||||
*/
|
||||
public function getParametersArray(): array
|
||||
{
|
||||
return [
|
||||
'fungsi_bangunan' => $this->fungsi_bangunan,
|
||||
'ip_permanen' => $this->ip_permanen,
|
||||
'ip_kompleksitas' => $this->ip_kompleksitas,
|
||||
'indeks_lokalitas' => $this->indeks_lokalitas,
|
||||
'asumsi_prasarana' => $this->asumsi_prasarana,
|
||||
'koefisien_dasar' => $this->koefisien_dasar,
|
||||
'faktor_penyesuaian' => $this->faktor_penyesuaian,
|
||||
'custom_parameters' => $this->custom_parameters
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Get formatted parameters for display
|
||||
*/
|
||||
public function getFormattedParameters(): array
|
||||
{
|
||||
return [
|
||||
'Fungsi Bangunan' => $this->fungsi_bangunan,
|
||||
'IP Permanen' => $this->ip_permanen,
|
||||
'IP Kompleksitas' => $this->ip_kompleksitas,
|
||||
'Indeks Lokalitas' => $this->indeks_lokalitas,
|
||||
'Asumsi Prasarana' => $this->asumsi_prasarana,
|
||||
'Koefisien Dasar' => $this->koefisien_dasar,
|
||||
'Faktor Penyesuaian' => $this->faktor_penyesuaian
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Calculate floor result using the main formula
|
||||
*/
|
||||
public function calculateFloorResult(float $ipKetinggian): float
|
||||
{
|
||||
return $this->fungsi_bangunan * (
|
||||
$this->ip_permanen +
|
||||
$this->ip_kompleksitas +
|
||||
(0.5 * $ipKetinggian)
|
||||
);
|
||||
}
|
||||
|
||||
/**
|
||||
* Calculate full retribution for given building area and floor result
|
||||
*/
|
||||
public function calculateRetribution(float $luasBangunan, float $floorResult): float
|
||||
{
|
||||
$baseValue = 70350; // Base retribution value
|
||||
$mainCalculation = 1 * $luasBangunan * ($this->indeks_lokalitas * $baseValue * $floorResult * 1);
|
||||
$additionalCalculation = 0.5 * $mainCalculation;
|
||||
|
||||
return $mainCalculation + $additionalCalculation;
|
||||
}
|
||||
|
||||
/**
|
||||
* Apply custom parameters if available
|
||||
*/
|
||||
public function getParameterValue(string $key, $default = null)
|
||||
{
|
||||
// First check if it's a standard parameter
|
||||
if (property_exists($this, $key) && $this->$key !== null) {
|
||||
return $this->$key;
|
||||
}
|
||||
|
||||
// Then check custom parameters
|
||||
if ($this->custom_parameters && is_array($this->custom_parameters)) {
|
||||
return $this->custom_parameters[$key] ?? $default;
|
||||
}
|
||||
|
||||
return $default;
|
||||
}
|
||||
|
||||
/**
|
||||
* Set custom parameter
|
||||
*/
|
||||
public function setCustomParameter(string $key, $value): void
|
||||
{
|
||||
$customParams = $this->custom_parameters ?? [];
|
||||
$customParams[$key] = $value;
|
||||
$this->custom_parameters = $customParams;
|
||||
}
|
||||
}
|
||||
56
app/Models/FloorHeightIndex.php
Normal file
56
app/Models/FloorHeightIndex.php
Normal file
@@ -0,0 +1,56 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
|
||||
class FloorHeightIndex extends Model
|
||||
{
|
||||
protected $fillable = [
|
||||
'floor_number',
|
||||
'ip_ketinggian',
|
||||
'description'
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'floor_number' => 'integer',
|
||||
'ip_ketinggian' => 'decimal:6'
|
||||
];
|
||||
|
||||
/**
|
||||
* Get IP ketinggian by floor number
|
||||
*/
|
||||
public static function getIpKetinggianByFloor(int $floorNumber): float
|
||||
{
|
||||
$index = self::where('floor_number', $floorNumber)->first();
|
||||
return $index ? (float) $index->ip_ketinggian : 1.0;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get all IP ketinggian mapping as array
|
||||
*/
|
||||
public static function getAllMapping(): array
|
||||
{
|
||||
return self::orderBy('floor_number')
|
||||
->pluck('ip_ketinggian', 'floor_number')
|
||||
->toArray();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get available floor numbers
|
||||
*/
|
||||
public static function getAvailableFloors(): array
|
||||
{
|
||||
return self::orderBy('floor_number')
|
||||
->pluck('floor_number')
|
||||
->toArray();
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: By floor number
|
||||
*/
|
||||
public function scopeByFloor($query, int $floorNumber)
|
||||
{
|
||||
return $query->where('floor_number', $floorNumber);
|
||||
}
|
||||
}
|
||||
32
app/Models/FormulaParameter.php
Normal file
32
app/Models/FormulaParameter.php
Normal file
@@ -0,0 +1,32 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
|
||||
class FormulaParameter extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected $fillable = [
|
||||
'formula_id',
|
||||
'parameter_id',
|
||||
];
|
||||
|
||||
/**
|
||||
* Relationship to MasterFormula
|
||||
*/
|
||||
public function formula()
|
||||
{
|
||||
return $this->belongsTo(MasterFormula::class, 'formula_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship to MasterParameter
|
||||
*/
|
||||
public function parameter()
|
||||
{
|
||||
return $this->belongsTo(MasterParameter::class, 'parameter_id');
|
||||
}
|
||||
}
|
||||
81
app/Models/MasterFormula.php
Normal file
81
app/Models/MasterFormula.php
Normal file
@@ -0,0 +1,81 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
|
||||
class MasterFormula extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected $fillable = [
|
||||
'formula_code',
|
||||
'formula_name',
|
||||
'formula_expression',
|
||||
'formula_category',
|
||||
'description',
|
||||
'usage_notes',
|
||||
];
|
||||
|
||||
/**
|
||||
* Relationship to FormulaParameter (Many-to-Many dengan MasterParameter)
|
||||
*/
|
||||
public function formulaParameters()
|
||||
{
|
||||
return $this->hasMany(FormulaParameter::class, 'formula_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship to MasterParameter through FormulaParameter
|
||||
*/
|
||||
public function parameters()
|
||||
{
|
||||
return $this->belongsToMany(MasterParameter::class, 'formula_parameters', 'formula_id', 'parameter_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship to BuildingFunctionFormulaConfig
|
||||
*/
|
||||
public function buildingConfigs()
|
||||
{
|
||||
return $this->hasMany(BuildingFunctionFormulaConfig::class, 'formula_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope untuk mencari berdasarkan kategori
|
||||
*/
|
||||
public function scopeByCategory($query, $category)
|
||||
{
|
||||
return $query->where('formula_category', $category);
|
||||
}
|
||||
|
||||
/**
|
||||
* Method untuk mendapatkan parameter yang diperlukan formula ini
|
||||
*/
|
||||
public function getRequiredParameters()
|
||||
{
|
||||
return $this->parameters()->get();
|
||||
}
|
||||
|
||||
/**
|
||||
* Method untuk evaluate formula dengan parameter values
|
||||
*/
|
||||
public function evaluateFormula($parameterValues = [])
|
||||
{
|
||||
$expression = $this->formula_expression;
|
||||
|
||||
// Replace parameter codes dengan nilai actual
|
||||
foreach ($parameterValues as $parameterCode => $value) {
|
||||
$expression = str_replace('{' . $parameterCode . '}', $value, $expression);
|
||||
}
|
||||
|
||||
// Evaluasi mathematical expression (hati-hati dengan security!)
|
||||
// Untuk production, gunakan library yang aman seperti SymfonyExpressionLanguage
|
||||
try {
|
||||
return eval("return $expression;");
|
||||
} catch (Exception $e) {
|
||||
throw new \Exception("Error evaluating formula: " . $e->getMessage());
|
||||
}
|
||||
}
|
||||
}
|
||||
55
app/Models/MasterParameter.php
Normal file
55
app/Models/MasterParameter.php
Normal file
@@ -0,0 +1,55 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
|
||||
class MasterParameter extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected $fillable = [
|
||||
'parameter_code',
|
||||
'parameter_name',
|
||||
'default_value',
|
||||
'unit',
|
||||
'description',
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'default_value' => 'decimal:6',
|
||||
];
|
||||
|
||||
/**
|
||||
* Relationship to FormulaParameter
|
||||
*/
|
||||
public function formulaParameters()
|
||||
{
|
||||
return $this->hasMany(FormulaParameter::class, 'parameter_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship to MasterFormula through FormulaParameter
|
||||
*/
|
||||
public function formulas()
|
||||
{
|
||||
return $this->belongsToMany(MasterFormula::class, 'formula_parameters', 'parameter_id', 'formula_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope untuk mencari berdasarkan parameter code
|
||||
*/
|
||||
public function scopeByCode($query, $code)
|
||||
{
|
||||
return $query->where('parameter_code', $code);
|
||||
}
|
||||
|
||||
/**
|
||||
* Method untuk mendapatkan nilai parameter dengan fallback ke default
|
||||
*/
|
||||
public function getValue($customValue = null)
|
||||
{
|
||||
return $customValue !== null ? $customValue : $this->default_value;
|
||||
}
|
||||
}
|
||||
@@ -38,6 +38,10 @@ class PbgTask extends Model
|
||||
return $this->hasOne(PbgTaskIndexIntegrations::class, 'pbg_task_uid', 'uuid');
|
||||
}
|
||||
|
||||
public function pbg_task_detail(){
|
||||
return $this->hasOne(PbgTaskDetail::class, 'pbg_task_uid', 'uuid');
|
||||
}
|
||||
|
||||
public function googleSheet(){
|
||||
return $this->hasOne(PbgTaskGoogleSheet::class, 'no_registrasi', 'registration_number');
|
||||
}
|
||||
|
||||
252
app/Models/PbgTaskDetail.php
Normal file
252
app/Models/PbgTaskDetail.php
Normal file
@@ -0,0 +1,252 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class PbgTaskDetail extends Model
|
||||
{
|
||||
protected $table = 'pbg_task_details';
|
||||
|
||||
protected $fillable = [
|
||||
'pbg_task_uid',
|
||||
'uid',
|
||||
'nik',
|
||||
'type_card',
|
||||
'ownership',
|
||||
'owner_name',
|
||||
'ward_id',
|
||||
'ward_name',
|
||||
'district_id',
|
||||
'district_name',
|
||||
'regency_id',
|
||||
'regency_name',
|
||||
'province_id',
|
||||
'province_name',
|
||||
'address',
|
||||
'owner_email',
|
||||
'owner_phone',
|
||||
'user',
|
||||
'name',
|
||||
'email',
|
||||
'phone',
|
||||
'user_nik',
|
||||
'user_province_id',
|
||||
'user_province_name',
|
||||
'user_regency_id',
|
||||
'user_regency_name',
|
||||
'user_district_id',
|
||||
'user_district_name',
|
||||
'user_address',
|
||||
'status',
|
||||
'status_name',
|
||||
'slf_status',
|
||||
'slf_status_name',
|
||||
'sppst_status',
|
||||
'sppst_file',
|
||||
'sppst_status_name',
|
||||
'file_pbg',
|
||||
'file_pbg_date',
|
||||
'due_date',
|
||||
'start_date',
|
||||
'document_number',
|
||||
'registration_number',
|
||||
'function_type',
|
||||
'application_type',
|
||||
'application_type_name',
|
||||
'consultation_type',
|
||||
'condition',
|
||||
'prototype',
|
||||
'permanency',
|
||||
'building_type',
|
||||
'building_type_name',
|
||||
'building_purpose',
|
||||
'building_use',
|
||||
'occupancy',
|
||||
'name_building',
|
||||
'total_area',
|
||||
'area',
|
||||
'area_type',
|
||||
'height',
|
||||
'floor',
|
||||
'floor_area',
|
||||
'basement',
|
||||
'basement_height',
|
||||
'basement_area',
|
||||
'unit',
|
||||
'prev_retribution',
|
||||
'prev_pbg',
|
||||
'prev_total_area',
|
||||
'koefisien_dasar_bangunan',
|
||||
'koefisien_lantai_bangunan',
|
||||
'koefisien_lantai_hijau',
|
||||
'koefisien_tapak_basement',
|
||||
'ketinggian_bangunan',
|
||||
'jalan_arteri',
|
||||
'jalan_kolektor',
|
||||
'jalan_bangunan',
|
||||
'gsb',
|
||||
'kkr_number',
|
||||
'unit_data',
|
||||
'is_mbr',
|
||||
'code',
|
||||
'building_ward_id',
|
||||
'building_ward_name',
|
||||
'building_district_id',
|
||||
'building_district_name',
|
||||
'building_regency_id',
|
||||
'building_regency_name',
|
||||
'building_province_id',
|
||||
'building_province_name',
|
||||
'building_address',
|
||||
'latitude',
|
||||
'longitude',
|
||||
'building_photo',
|
||||
'pbg_parent',
|
||||
'api_created_at',
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'unit_data' => 'array',
|
||||
'is_mbr' => 'boolean',
|
||||
'total_area' => 'decimal:2',
|
||||
'area' => 'decimal:2',
|
||||
'height' => 'decimal:2',
|
||||
'floor_area' => 'decimal:2',
|
||||
'basement_height' => 'decimal:2',
|
||||
'basement_area' => 'decimal:2',
|
||||
'prev_retribution' => 'decimal:2',
|
||||
'prev_total_area' => 'decimal:2',
|
||||
'koefisien_dasar_bangunan' => 'decimal:4',
|
||||
'koefisien_lantai_bangunan' => 'decimal:4',
|
||||
'koefisien_lantai_hijau' => 'decimal:4',
|
||||
'koefisien_tapak_basement' => 'decimal:4',
|
||||
'ketinggian_bangunan' => 'decimal:2',
|
||||
'gsb' => 'decimal:2',
|
||||
'latitude' => 'decimal:8',
|
||||
'longitude' => 'decimal:8',
|
||||
'file_pbg_date' => 'date',
|
||||
'due_date' => 'date',
|
||||
'start_date' => 'date',
|
||||
'api_created_at' => 'datetime',
|
||||
];
|
||||
|
||||
/**
|
||||
* Get the PBG task that owns this detail
|
||||
*/
|
||||
public function pbgTask(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(PbgTask::class, 'pbg_task_uid', 'uuid');
|
||||
}
|
||||
|
||||
/**
|
||||
* Create or update PbgTaskDetail from API response
|
||||
*/
|
||||
public static function createFromApiResponse(array $data, string $pbgTaskUuid): self
|
||||
{
|
||||
$detailData = [
|
||||
'pbg_task_uid' => $pbgTaskUuid,
|
||||
'uid' => $data['uid'] ?? null,
|
||||
'nik' => $data['nik'] ?? null,
|
||||
'type_card' => $data['type_card'] ?? null,
|
||||
'ownership' => $data['ownership'] ?? null,
|
||||
'owner_name' => $data['owner_name'] ?? null,
|
||||
'ward_id' => $data['ward_id'] ?? null,
|
||||
'ward_name' => $data['ward_name'] ?? null,
|
||||
'district_id' => $data['district_id'] ?? null,
|
||||
'district_name' => $data['district_name'] ?? null,
|
||||
'regency_id' => $data['regency_id'] ?? null,
|
||||
'regency_name' => $data['regency_name'] ?? null,
|
||||
'province_id' => $data['province_id'] ?? null,
|
||||
'province_name' => $data['province_name'] ?? null,
|
||||
'address' => $data['address'] ?? null,
|
||||
'owner_email' => $data['owner_email'] ?? null,
|
||||
'owner_phone' => $data['owner_phone'] ?? null,
|
||||
'user' => $data['user'] ?? null,
|
||||
'name' => $data['name'] ?? null,
|
||||
'email' => $data['email'] ?? null,
|
||||
'phone' => $data['phone'] ?? null,
|
||||
'user_nik' => $data['user_nik'] ?? null,
|
||||
'user_province_id' => $data['user_province_id'] ?? null,
|
||||
'user_province_name' => $data['user_province_name'] ?? null,
|
||||
'user_regency_id' => $data['user_regency_id'] ?? null,
|
||||
'user_regency_name' => $data['user_regency_name'] ?? null,
|
||||
'user_district_id' => $data['user_district_id'] ?? null,
|
||||
'user_district_name' => $data['user_district_name'] ?? null,
|
||||
'user_address' => $data['user_address'] ?? null,
|
||||
'status' => $data['status'] ?? null,
|
||||
'status_name' => $data['status_name'] ?? null,
|
||||
'slf_status' => $data['slf_status'] ?? null,
|
||||
'slf_status_name' => $data['slf_status_name'] ?? null,
|
||||
'sppst_status' => $data['sppst_status'] ?? null,
|
||||
'sppst_file' => $data['sppst_file'] ?? null,
|
||||
'sppst_status_name' => $data['sppst_status_name'] ?? null,
|
||||
'file_pbg' => $data['file_pbg'] ?? null,
|
||||
'file_pbg_date' => isset($data['file_pbg_date']) ? Carbon::parse($data['file_pbg_date'])->format('Y-m-d') : null,
|
||||
'due_date' => isset($data['due_date']) ? Carbon::parse($data['due_date'])->format('Y-m-d') : null,
|
||||
'start_date' => isset($data['start_date']) ? Carbon::parse($data['start_date'])->format('Y-m-d') : null,
|
||||
'document_number' => $data['document_number'] ?? null,
|
||||
'registration_number' => $data['registration_number'] ?? null,
|
||||
'function_type' => $data['function_type'] ?? null,
|
||||
'application_type' => $data['application_type'] ?? null,
|
||||
'application_type_name' => $data['application_type_name'] ?? null,
|
||||
'consultation_type' => $data['consultation_type'] ?? null,
|
||||
'condition' => $data['condition'] ?? null,
|
||||
'prototype' => $data['prototype'] ?? null,
|
||||
'permanency' => $data['permanency'] ?? null,
|
||||
'building_type' => $data['building_type'] ?? null,
|
||||
'building_type_name' => $data['building_type_name'] ?? null,
|
||||
'building_purpose' => $data['building_purpose'] ?? null,
|
||||
'building_use' => $data['building_use'] ?? null,
|
||||
'occupancy' => $data['occupancy'] ?? null,
|
||||
'name_building' => $data['name_building'] ?? null,
|
||||
'total_area' => $data['total_area'] ?? null,
|
||||
'area' => $data['area'] ?? null,
|
||||
'area_type' => $data['area_type'] ?? null,
|
||||
'height' => $data['height'] ?? null,
|
||||
'floor' => $data['floor'] ?? null,
|
||||
'floor_area' => $data['floor_area'] ?? null,
|
||||
'basement' => $data['basement'] ?? null,
|
||||
'basement_height' => $data['basement_height'] ?? null,
|
||||
'basement_area' => $data['basement_area'] ?? null,
|
||||
'unit' => $data['unit'] ?? null,
|
||||
'prev_retribution' => $data['prev_retribution'] ?? null,
|
||||
'prev_pbg' => $data['prev_pbg'] ?? null,
|
||||
'prev_total_area' => $data['prev_total_area'] ?? null,
|
||||
'koefisien_dasar_bangunan' => $data['koefisien_dasar_bangunan'] ?? null,
|
||||
'koefisien_lantai_bangunan' => $data['koefisien_lantai_bangunan'] ?? null,
|
||||
'koefisien_lantai_hijau' => $data['koefisien_lantai_hijau'] ?? null,
|
||||
'koefisien_tapak_basement' => $data['koefisien_tapak_basement'] ?? null,
|
||||
'ketinggian_bangunan' => $data['ketinggian_bangunan'] ?? null,
|
||||
'jalan_arteri' => $data['jalan_arteri'] ?? null,
|
||||
'jalan_kolektor' => $data['jalan_kolektor'] ?? null,
|
||||
'jalan_bangunan' => $data['jalan_bangunan'] ?? null,
|
||||
'gsb' => $data['gsb'] ?? null,
|
||||
'kkr_number' => $data['kkr_number'] ?? null,
|
||||
'unit_data' => $data['unit_data'] ?? null,
|
||||
'is_mbr' => $data['is_mbr'] ?? false,
|
||||
'code' => $data['code'] ?? null,
|
||||
'building_ward_id' => $data['building_ward_id'] ?? null,
|
||||
'building_ward_name' => $data['building_ward_name'] ?? null,
|
||||
'building_district_id' => $data['building_district_id'] ?? null,
|
||||
'building_district_name' => $data['building_district_name'] ?? null,
|
||||
'building_regency_id' => $data['building_regency_id'] ?? null,
|
||||
'building_regency_name' => $data['building_regency_name'] ?? null,
|
||||
'building_province_id' => $data['building_province_id'] ?? null,
|
||||
'building_province_name' => $data['building_province_name'] ?? null,
|
||||
'building_address' => $data['building_address'] ?? null,
|
||||
'latitude' => $data['latitude'] ?? null,
|
||||
'longitude' => $data['longitude'] ?? null,
|
||||
'building_photo' => $data['building_photo'] ?? null,
|
||||
'pbg_parent' => $data['pbg_parent'] ?? null,
|
||||
'api_created_at' => isset($data['created_at']) ? Carbon::parse($data['created_at'])->format('Y-m-d H:i:s') : null,
|
||||
];
|
||||
|
||||
return static::updateOrCreate(
|
||||
['uid' => $data['uid']],
|
||||
$detailData
|
||||
);
|
||||
}
|
||||
}
|
||||
227
app/Models/RetributionFormula.php
Normal file
227
app/Models/RetributionFormula.php
Normal file
@@ -0,0 +1,227 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
|
||||
class RetributionFormula extends Model
|
||||
{
|
||||
protected $fillable = [
|
||||
'building_function_id',
|
||||
'name',
|
||||
'floor_number',
|
||||
'formula_expression'
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'floor_number' => 'integer'
|
||||
];
|
||||
|
||||
/**
|
||||
* Building function relationship (n:1)
|
||||
*/
|
||||
public function buildingFunction(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Retribution proposals relationship (1:n)
|
||||
*/
|
||||
public function retributionProposals(): HasMany
|
||||
{
|
||||
return $this->hasMany(RetributionProposal::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: By floor number
|
||||
*/
|
||||
public function scopeByFloor($query, int $floorNumber)
|
||||
{
|
||||
return $query->where('floor_number', $floorNumber);
|
||||
}
|
||||
|
||||
/**
|
||||
* Execute formula calculation with parameters and IP ketinggian
|
||||
*/
|
||||
public function calculate(float $luasBangunan, array $parameters, float $ipKetinggian): float
|
||||
{
|
||||
// Extract parameters
|
||||
$fungsi_bangunan = $parameters['fungsi_bangunan'] ?? 0;
|
||||
$ip_permanen = $parameters['ip_permanen'] ?? 0;
|
||||
$ip_kompleksitas = $parameters['ip_kompleksitas'] ?? 0;
|
||||
$indeks_lokalitas = $parameters['indeks_lokalitas'] ?? 0;
|
||||
|
||||
// Calculate H13 (floor coefficient) using Excel formula
|
||||
$h13 = $fungsi_bangunan * ($ip_permanen + $ip_kompleksitas + (0.5 * $ipKetinggian));
|
||||
|
||||
// Calculate full retribution using Excel formula
|
||||
$baseValue = 70350;
|
||||
$additionalFactor = 0.5;
|
||||
|
||||
// Main calculation: (1*D13*(N13*70350*H13*1))
|
||||
$mainCalculation = 1 * $luasBangunan * ($indeks_lokalitas * $baseValue * $h13 * 1);
|
||||
|
||||
// Additional calculation: ($O$3*(1*D13*(N13*70350*H13*1)))
|
||||
$additionalCalculation = $additionalFactor * $mainCalculation;
|
||||
|
||||
// Total: main + additional
|
||||
return $mainCalculation + $additionalCalculation;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get formula with parameter placeholders replaced for display
|
||||
*/
|
||||
public function getDisplayFormula(array $parameters = []): string
|
||||
{
|
||||
$formula = $this->formula_expression;
|
||||
|
||||
if (!empty($parameters)) {
|
||||
foreach ($parameters as $key => $value) {
|
||||
$formula = str_replace($key, "({$key}={$value})", $formula);
|
||||
}
|
||||
}
|
||||
|
||||
return $formula;
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if this formula applies to given floor number
|
||||
*/
|
||||
public function appliesTo(int $floorNumber): bool
|
||||
{
|
||||
// If floor_number is 0, formula applies to all floors
|
||||
if ($this->floor_number === 0) {
|
||||
return true;
|
||||
}
|
||||
|
||||
// Otherwise, exact match required
|
||||
return $this->floor_number == $floorNumber;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get human readable floor description
|
||||
*/
|
||||
public function getFloorDescription(): string
|
||||
{
|
||||
if ($this->floor_number === 0) {
|
||||
return 'Semua lantai';
|
||||
}
|
||||
|
||||
return "Lantai {$this->floor_number}";
|
||||
}
|
||||
|
||||
/**
|
||||
* Get default formula expression
|
||||
*/
|
||||
public static function getDefaultFormula(): string
|
||||
{
|
||||
return '(fungsi_bangunan * (ip_permanen + ip_kompleksitas + (0.5 * ip_ketinggian)))';
|
||||
}
|
||||
|
||||
/**
|
||||
* Validate formula expression syntax
|
||||
*/
|
||||
public function validateFormula(): bool
|
||||
{
|
||||
// Basic validation - check if formula contains required variables
|
||||
$requiredVariables = ['fungsi_bangunan', 'ip_permanen', 'ip_kompleksitas', 'ip_ketinggian'];
|
||||
|
||||
foreach ($requiredVariables as $variable) {
|
||||
if (strpos($this->formula_expression, $variable) === false) {
|
||||
return false;
|
||||
}
|
||||
}
|
||||
|
||||
return true;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get calculation breakdown for debugging
|
||||
*/
|
||||
public function getCalculationBreakdown(float $luasBangunan, array $parameters, float $ipKetinggian): array
|
||||
{
|
||||
// Extract parameters
|
||||
$fungsi_bangunan = $parameters['fungsi_bangunan'] ?? 0;
|
||||
$ip_permanen = $parameters['ip_permanen'] ?? 0;
|
||||
$ip_kompleksitas = $parameters['ip_kompleksitas'] ?? 0;
|
||||
$indeks_lokalitas = $parameters['indeks_lokalitas'] ?? 0;
|
||||
|
||||
// Calculate H13 (floor coefficient)
|
||||
$h13 = $fungsi_bangunan * ($ip_permanen + $ip_kompleksitas + (0.5 * $ipKetinggian));
|
||||
|
||||
// Calculate components
|
||||
$baseValue = 70350;
|
||||
$additionalFactor = 0.5;
|
||||
$mainCalculation = 1 * $luasBangunan * ($indeks_lokalitas * $baseValue * $h13 * 1);
|
||||
$additionalCalculation = $additionalFactor * $mainCalculation;
|
||||
$totalCalculation = $mainCalculation + $additionalCalculation;
|
||||
|
||||
return [
|
||||
'input_parameters' => [
|
||||
'luas_bangunan' => $luasBangunan,
|
||||
'fungsi_bangunan' => $fungsi_bangunan,
|
||||
'ip_permanen' => $ip_permanen,
|
||||
'ip_kompleksitas' => $ip_kompleksitas,
|
||||
'ip_ketinggian' => $ipKetinggian,
|
||||
'indeks_lokalitas' => $indeks_lokalitas,
|
||||
'base_value' => $baseValue,
|
||||
'additional_factor' => $additionalFactor
|
||||
],
|
||||
'calculation_steps' => [
|
||||
'h13_calculation' => [
|
||||
'formula' => 'fungsi_bangunan * (ip_permanen + ip_kompleksitas + (0.5 * ip_ketinggian))',
|
||||
'calculation' => "{$fungsi_bangunan} * ({$ip_permanen} + {$ip_kompleksitas} + (0.5 * {$ipKetinggian}))",
|
||||
'result' => $h13
|
||||
],
|
||||
'main_calculation' => [
|
||||
'formula' => '1 * luas_bangunan * (indeks_lokalitas * base_value * h13 * 1)',
|
||||
'calculation' => "1 * {$luasBangunan} * ({$indeks_lokalitas} * {$baseValue} * {$h13} * 1)",
|
||||
'result' => $mainCalculation
|
||||
],
|
||||
'additional_calculation' => [
|
||||
'formula' => 'additional_factor * main_calculation',
|
||||
'calculation' => "{$additionalFactor} * {$mainCalculation}",
|
||||
'result' => $additionalCalculation
|
||||
],
|
||||
'total_calculation' => [
|
||||
'formula' => 'main_calculation + additional_calculation',
|
||||
'calculation' => "{$mainCalculation} + {$additionalCalculation}",
|
||||
'result' => $totalCalculation
|
||||
]
|
||||
],
|
||||
'formatted_results' => [
|
||||
'h13' => number_format($h13, 6),
|
||||
'main_calculation' => 'Rp ' . number_format($mainCalculation, 2),
|
||||
'additional_calculation' => 'Rp ' . number_format($additionalCalculation, 2),
|
||||
'total_calculation' => 'Rp ' . number_format($totalCalculation, 2)
|
||||
]
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if this formula has been used in any proposals
|
||||
*/
|
||||
public function hasProposals(): bool
|
||||
{
|
||||
return $this->retributionProposals()->exists();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get total amount calculated using this formula
|
||||
*/
|
||||
public function getTotalCalculatedAmount(): float
|
||||
{
|
||||
return $this->retributionProposals()->sum('total_retribution_amount');
|
||||
}
|
||||
|
||||
/**
|
||||
* Get count of proposals using this formula
|
||||
*/
|
||||
public function getProposalCount(): int
|
||||
{
|
||||
return $this->retributionProposals()->count();
|
||||
}
|
||||
}
|
||||
187
app/Models/RetributionProposal.php
Normal file
187
app/Models/RetributionProposal.php
Normal file
@@ -0,0 +1,187 @@
|
||||
<?php
|
||||
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
|
||||
class RetributionProposal extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected $fillable = [
|
||||
'spatial_planning_id',
|
||||
'building_function_id',
|
||||
'retribution_formula_id',
|
||||
'proposal_number',
|
||||
'floor_number',
|
||||
'floor_area',
|
||||
'total_building_area',
|
||||
'ip_ketinggian',
|
||||
'floor_retribution_amount',
|
||||
'total_retribution_amount',
|
||||
'calculation_parameters',
|
||||
'calculation_breakdown',
|
||||
'notes',
|
||||
'calculated_at'
|
||||
];
|
||||
|
||||
protected $casts = [
|
||||
'floor_area' => 'decimal:6',
|
||||
'total_building_area' => 'decimal:6',
|
||||
'ip_ketinggian' => 'decimal:6',
|
||||
'floor_retribution_amount' => 'decimal:2',
|
||||
'total_retribution_amount' => 'decimal:2',
|
||||
'calculation_parameters' => 'array',
|
||||
'calculation_breakdown' => 'array',
|
||||
'calculated_at' => 'datetime'
|
||||
];
|
||||
|
||||
|
||||
|
||||
/**
|
||||
* Relationship with SpatialPlanning
|
||||
*/
|
||||
public function spatialPlanning(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(SpatialPlanning::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship with BuildingFunction
|
||||
*/
|
||||
public function buildingFunction(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Relationship with RetributionFormula
|
||||
*/
|
||||
public function retributionFormula(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(RetributionFormula::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Generate proposal number
|
||||
*/
|
||||
public static function generateProposalNumber(): string
|
||||
{
|
||||
$year = now()->format('Y');
|
||||
$month = now()->format('m');
|
||||
|
||||
// Use max ID + 1 to avoid duplicates when records are deleted
|
||||
$maxId = static::whereYear('created_at', now()->year)
|
||||
->whereMonth('created_at', now()->month)
|
||||
->max('id') ?? 0;
|
||||
$nextNumber = $maxId + 1;
|
||||
|
||||
// Fallback: if still duplicate, use timestamp
|
||||
$proposalNumber = sprintf('RP-%s%s-%04d', $year, $month, $nextNumber);
|
||||
|
||||
// Check if exists and increment until unique
|
||||
$counter = $nextNumber;
|
||||
while (static::where('proposal_number', $proposalNumber)->exists()) {
|
||||
$counter++;
|
||||
$proposalNumber = sprintf('RP-%s%s-%04d', $year, $month, $counter);
|
||||
}
|
||||
|
||||
return $proposalNumber;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get formatted floor retribution amount
|
||||
*/
|
||||
public function getFormattedFloorAmountAttribute(): string
|
||||
{
|
||||
return 'Rp ' . number_format($this->floor_retribution_amount, 0, ',', '.');
|
||||
}
|
||||
|
||||
/**
|
||||
* Get formatted total retribution amount
|
||||
*/
|
||||
public function getFormattedTotalAmountAttribute(): string
|
||||
{
|
||||
return 'Rp ' . number_format($this->total_retribution_amount, 0, ',', '.');
|
||||
}
|
||||
|
||||
/**
|
||||
* Get calculation breakdown for specific parameter
|
||||
*/
|
||||
public function getCalculationBreakdownFor(string $parameter)
|
||||
{
|
||||
return $this->calculation_breakdown[$parameter] ?? null;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get parameter value
|
||||
*/
|
||||
public function getParameterValue(string $parameter)
|
||||
{
|
||||
return $this->calculation_parameters[$parameter] ?? null;
|
||||
}
|
||||
|
||||
|
||||
|
||||
|
||||
|
||||
/**
|
||||
* Scope for filtering by building function
|
||||
*/
|
||||
public function scopeByBuildingFunction($query, int $buildingFunctionId)
|
||||
{
|
||||
return $query->where('building_function_id', $buildingFunctionId);
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope for filtering by spatial planning
|
||||
*/
|
||||
public function scopeBySpatialPlanning($query, int $spatialPlanningId)
|
||||
{
|
||||
return $query->where('spatial_planning_id', $spatialPlanningId);
|
||||
}
|
||||
|
||||
/**
|
||||
* Get total retribution amount for multiple proposals
|
||||
*/
|
||||
public static function getTotalAmount($proposals = null): float
|
||||
{
|
||||
if ($proposals) {
|
||||
return $proposals->sum('total_retribution_amount');
|
||||
}
|
||||
|
||||
return static::sum('total_retribution_amount');
|
||||
}
|
||||
|
||||
/**
|
||||
* Get basic statistics
|
||||
*/
|
||||
public static function getBasicStats(): array
|
||||
{
|
||||
return [
|
||||
'total_count' => static::count(),
|
||||
'total_amount' => static::sum('total_retribution_amount'),
|
||||
'average_amount' => static::avg('total_retribution_amount'),
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Boot method to generate proposal number
|
||||
*/
|
||||
protected static function boot()
|
||||
{
|
||||
parent::boot();
|
||||
|
||||
static::creating(function ($model) {
|
||||
if (empty($model->proposal_number)) {
|
||||
$model->proposal_number = static::generateProposalNumber();
|
||||
}
|
||||
|
||||
if (empty($model->calculated_at)) {
|
||||
$model->calculated_at = now();
|
||||
}
|
||||
});
|
||||
}
|
||||
}
|
||||
@@ -3,6 +3,9 @@
|
||||
namespace App\Models;
|
||||
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\HasOne;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
|
||||
/**
|
||||
* Class SpatialPlanning
|
||||
@@ -31,7 +34,87 @@ class SpatialPlanning extends Model
|
||||
*
|
||||
* @var array<int, string>
|
||||
*/
|
||||
protected $fillable = ['name', 'kbli', 'activities', 'area', 'location', 'number', 'date'];
|
||||
protected $fillable = ['name', 'kbli', 'activities', 'area', 'location', 'number', 'date', 'no_tapak', 'no_skkl', 'no_ukl', 'building_function', 'sub_building_function', 'number_of_floors', 'land_area', 'site_bcr'];
|
||||
|
||||
protected $casts = [
|
||||
'area' => 'decimal:6',
|
||||
'land_area' => 'decimal:6',
|
||||
'site_bcr' => 'decimal:6',
|
||||
'number_of_floors' => 'integer',
|
||||
'date' => 'date'
|
||||
];
|
||||
|
||||
/**
|
||||
* Retribution proposals relationship (1:many)
|
||||
*/
|
||||
public function retributionProposals(): HasMany
|
||||
{
|
||||
return $this->hasMany(RetributionProposal::class);
|
||||
}
|
||||
|
||||
/**
|
||||
* Building function relationship (if building_function becomes FK in future)
|
||||
*/
|
||||
public function buildingFunctionRelation(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(BuildingFunction::class, 'building_function_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* Check if spatial planning has retribution proposals
|
||||
*/
|
||||
public function hasRetributionProposals(): bool
|
||||
{
|
||||
return $this->retributionProposals()->exists();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get latest retribution proposal
|
||||
*/
|
||||
public function getLatestRetributionProposal()
|
||||
{
|
||||
return $this->retributionProposals()->latest()->first();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get all retribution proposals
|
||||
*/
|
||||
public function getAllRetributionProposals()
|
||||
{
|
||||
return $this->retributionProposals()->get();
|
||||
}
|
||||
|
||||
/**
|
||||
* Get building function text for detection
|
||||
*/
|
||||
public function getBuildingFunctionText(): string
|
||||
{
|
||||
return $this->building_function ?? $this->activities ?? '';
|
||||
}
|
||||
|
||||
/**
|
||||
* Get area for calculation (prioritize area, fallback to land_area)
|
||||
*/
|
||||
public function getCalculationArea(): float
|
||||
{
|
||||
return (float) ($this->area ?? $this->land_area ?? 0);
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: Without retribution proposals
|
||||
*/
|
||||
public function scopeWithoutRetributionProposals($query)
|
||||
{
|
||||
return $query->whereDoesntHave('retributionProposals');
|
||||
}
|
||||
|
||||
/**
|
||||
* Scope: With retribution proposals
|
||||
*/
|
||||
public function scopeWithRetributionProposals($query)
|
||||
{
|
||||
return $query->whereHas('retributionProposals');
|
||||
}
|
||||
|
||||
|
||||
}
|
||||
|
||||
0
app/Models/User.php
Executable file → Normal file
0
app/Models/User.php
Executable file → Normal file
0
app/Providers/AppServiceProvider.php
Executable file → Normal file
0
app/Providers/AppServiceProvider.php
Executable file → Normal file
0
app/Providers/AuthServiceProvider.php
Executable file → Normal file
0
app/Providers/AuthServiceProvider.php
Executable file → Normal file
0
app/Providers/BroadcastServiceProvider.php
Executable file → Normal file
0
app/Providers/BroadcastServiceProvider.php
Executable file → Normal file
0
app/Providers/EventServiceProvider.php
Executable file → Normal file
0
app/Providers/EventServiceProvider.php
Executable file → Normal file
0
app/Providers/RouteServiceProvider.php
Executable file → Normal file
0
app/Providers/RouteServiceProvider.php
Executable file → Normal file
180
app/Services/DynamicRetributionCalculationService.php
Normal file
180
app/Services/DynamicRetributionCalculationService.php
Normal file
@@ -0,0 +1,180 @@
|
||||
<?php
|
||||
|
||||
namespace App\Services;
|
||||
|
||||
use App\Models\BuildingFunction;
|
||||
use App\Models\MasterParameter;
|
||||
|
||||
/**
|
||||
* Retribution Calculation Service - Rundown 4 Implementation
|
||||
*
|
||||
* Implementasi rumus Excel Rundown 4:
|
||||
* =ROUNDDOWN(($E13*($F13+$G13+(0.5*I$3))),4)
|
||||
* Retribusi = (1*D5*(N5*7035000*H5*1))+($O$3*(1*D5*(N5*7035000*H5*1)))
|
||||
*/
|
||||
class DynamicRetributionCalculationService
|
||||
{
|
||||
/**
|
||||
* Calculate retribution using Rundown 4 formula
|
||||
*/
|
||||
public function calculateRetribution($buildingFunctionId, $floorLevel, $luasBangunan, $indeksLokasi = 'sedang', $includeInfrastructure = true)
|
||||
{
|
||||
try {
|
||||
// Get parameters for this building function
|
||||
$parameters = $this->getParameterValues($buildingFunctionId, $floorLevel, $indeksLokasi);
|
||||
|
||||
// Step 1: Calculate Rundown 4 per floor value
|
||||
$h5 = $this->calculateRundown4($parameters);
|
||||
|
||||
// Step 2: Calculate basic retribution
|
||||
$basicRetribution = $parameters['koefisien_dasar'] * $luasBangunan *
|
||||
($parameters['indeks_lokalitas'] * $parameters['tarif_dasar'] * $h5 * $parameters['koefisien_dasar']);
|
||||
|
||||
// Step 3: Calculate infrastructure (optional)
|
||||
$infrastructureAmount = 0;
|
||||
$totalRetribution = $basicRetribution;
|
||||
|
||||
if ($includeInfrastructure) {
|
||||
$infrastructureAmount = $parameters['asumsi_prasarana'] * $basicRetribution;
|
||||
$totalRetribution = $basicRetribution + $infrastructureAmount;
|
||||
}
|
||||
|
||||
return [
|
||||
'success' => true,
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'floor_level' => $floorLevel,
|
||||
'luas_bangunan' => $luasBangunan,
|
||||
'indeks_lokalitas_type' => $indeksLokasi,
|
||||
'calculation_breakdown' => [
|
||||
'rundown_4_calculation' => [
|
||||
'excel_formula' => '=ROUNDDOWN(($E13*($F13+$G13+(0.5*I$3))),4)',
|
||||
'fungsi_bangunan' => $parameters['fungsi'],
|
||||
'ip_permanen' => $parameters['ip_permanen'],
|
||||
'ip_kompleksitas' => $parameters['ip_kompleksitas'],
|
||||
'multiplier_ketinggian' => $parameters['multiplier_ketinggian'],
|
||||
'ip_ketinggian' => $parameters['ip_ketinggian'],
|
||||
'before_rounddown' => $parameters['fungsi'] * ($parameters['ip_permanen'] + $parameters['ip_kompleksitas'] + ($parameters['multiplier_ketinggian'] * $parameters['ip_ketinggian'])),
|
||||
'after_rounddown' => $h5,
|
||||
'precision' => 4
|
||||
],
|
||||
'retribution_calculation' => [
|
||||
'basic_formula' => '1 * D5 * (N5 * 7035000 * H5 * 1)',
|
||||
'infrastructure_formula' => 'O3 * basic_retribution',
|
||||
'basic_amount' => $basicRetribution,
|
||||
'infrastructure_amount' => $infrastructureAmount,
|
||||
'total_amount' => $totalRetribution
|
||||
]
|
||||
],
|
||||
'results' => [
|
||||
'h5_rundown4' => $h5,
|
||||
'basic_retribution' => $basicRetribution,
|
||||
'infrastructure_amount' => $infrastructureAmount,
|
||||
'total_retribution' => $totalRetribution
|
||||
]
|
||||
];
|
||||
|
||||
} catch (\Exception $e) {
|
||||
return [
|
||||
'success' => false,
|
||||
'error' => $e->getMessage(),
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'floor_level' => $floorLevel
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
/**
|
||||
* Calculate multiple floors retribution
|
||||
*/
|
||||
public function calculateMultiFloorRetribution($buildingFunctionId, array $floors, $luasBangunan, $indeksLokasi = 'sedang')
|
||||
{
|
||||
$floorDetails = [];
|
||||
$totalRetribution = 0;
|
||||
|
||||
foreach ($floors as $floor) {
|
||||
$result = $this->calculateRetribution($buildingFunctionId, $floor, $luasBangunan, $indeksLokasi, true);
|
||||
|
||||
if ($result['success']) {
|
||||
$floorDetails[$floor] = $result['results'];
|
||||
$totalRetribution += $result['results']['total_retribution'];
|
||||
}
|
||||
}
|
||||
|
||||
return [
|
||||
'success' => true,
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'floors' => $floors,
|
||||
'luas_bangunan' => $luasBangunan,
|
||||
'indeks_lokalitas_type' => $indeksLokasi,
|
||||
'floor_details' => $floorDetails,
|
||||
'total_retribution' => $totalRetribution,
|
||||
'average_per_floor' => count($floors) > 0 ? $totalRetribution / count($floors) : 0
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Calculate Rundown 4 per-floor value with ROUNDDOWN
|
||||
* Formula: =ROUNDDOWN(($E13*($F13+$G13+(0.5*I$3))),4)
|
||||
*/
|
||||
private function calculateRundown4($parameters)
|
||||
{
|
||||
$calculation = $parameters['fungsi'] *
|
||||
($parameters['ip_permanen'] + $parameters['ip_kompleksitas'] +
|
||||
($parameters['multiplier_ketinggian'] * $parameters['ip_ketinggian']));
|
||||
|
||||
// Apply ROUNDDOWN with 4 decimal places
|
||||
return floor($calculation * 10000) / 10000;
|
||||
}
|
||||
|
||||
/**
|
||||
* Get parameter values for calculation
|
||||
*/
|
||||
private function getParameterValues($buildingFunctionId, $floorLevel, $indeksLokasi)
|
||||
{
|
||||
$buildingFunction = BuildingFunction::find($buildingFunctionId);
|
||||
if (!$buildingFunction) {
|
||||
throw new \Exception("Building function not found: {$buildingFunctionId}");
|
||||
}
|
||||
|
||||
$functionCode = strtolower($buildingFunction->code);
|
||||
|
||||
$lokalitasMapping = [
|
||||
'rendah' => 'indeks_lokalitas_rendah',
|
||||
'sedang' => 'indeks_lokalitas_sedang',
|
||||
'tinggi' => 'indeks_lokalitas_tinggi'
|
||||
];
|
||||
|
||||
$lokalitasParamCode = $lokalitasMapping[$indeksLokasi] ?? 'indeks_lokalitas_sedang';
|
||||
|
||||
$parameterCodes = [
|
||||
'tarif_dasar',
|
||||
'koefisien_dasar',
|
||||
'multiplier_ketinggian',
|
||||
'asumsi_prasarana',
|
||||
$lokalitasParamCode,
|
||||
"ip_ketinggian_{$floorLevel}",
|
||||
"fungsi_{$functionCode}",
|
||||
"ip_permanen_{$functionCode}",
|
||||
"ip_kompleksitas_{$functionCode}"
|
||||
];
|
||||
|
||||
$parameters = MasterParameter::whereIn('parameter_code', $parameterCodes)->get();
|
||||
|
||||
$values = [];
|
||||
foreach ($parameters as $param) {
|
||||
$values[$param->parameter_code] = $param->default_value;
|
||||
}
|
||||
|
||||
return [
|
||||
'tarif_dasar' => $values['tarif_dasar'] ?? 7035000,
|
||||
'koefisien_dasar' => $values['koefisien_dasar'] ?? 1,
|
||||
'multiplier_ketinggian' => $values['multiplier_ketinggian'] ?? 0.5,
|
||||
'asumsi_prasarana' => $values['asumsi_prasarana'] ?? 0.5,
|
||||
'indeks_lokalitas' => $values[$lokalitasParamCode] ?? 0.004,
|
||||
'ip_ketinggian' => $values["ip_ketinggian_{$floorLevel}"] ?? 1.0,
|
||||
'fungsi' => $values["fungsi_{$functionCode}"] ?? 0,
|
||||
'ip_permanen' => $values["ip_permanen_{$functionCode}"] ?? 0,
|
||||
'ip_kompleksitas' => $values["ip_kompleksitas_{$functionCode}"] ?? 0
|
||||
];
|
||||
}
|
||||
}
|
||||
294
app/Services/RetributionProposalService.php
Normal file
294
app/Services/RetributionProposalService.php
Normal file
@@ -0,0 +1,294 @@
|
||||
<?php
|
||||
|
||||
namespace App\Services;
|
||||
|
||||
use App\Models\SpatialPlanning;
|
||||
use App\Models\BuildingFunction;
|
||||
use App\Models\RetributionProposal;
|
||||
use App\Models\RetributionFormula;
|
||||
use App\Models\FloorHeightIndex;
|
||||
use App\Models\BuildingFunctionParameter;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class RetributionProposalService
|
||||
{
|
||||
/**
|
||||
* Create retribution proposal for spatial planning
|
||||
*/
|
||||
public function createProposalForSpatialPlanning(
|
||||
SpatialPlanning $spatialPlanning,
|
||||
int $buildingFunctionId,
|
||||
int $floorNumber,
|
||||
float $floorArea,
|
||||
float $totalBuildingArea = null,
|
||||
string $notes = null
|
||||
): RetributionProposal {
|
||||
// Get building function and its parameters
|
||||
$buildingFunction = BuildingFunction::with('parameter')->findOrFail($buildingFunctionId);
|
||||
$parameters = $buildingFunction->parameter;
|
||||
|
||||
if (!$parameters) {
|
||||
throw new \Exception("Building function parameters not found for ID: {$buildingFunctionId}");
|
||||
}
|
||||
|
||||
// Get floor height index
|
||||
$floorHeightIndex = FloorHeightIndex::where('floor_number', $floorNumber)->first();
|
||||
if (!$floorHeightIndex) {
|
||||
throw new \Exception("Floor height index not found for floor: {$floorNumber}");
|
||||
}
|
||||
|
||||
// Get retribution formula
|
||||
$retributionFormula = RetributionFormula::where('building_function_id', $buildingFunctionId)
|
||||
->where('floor_number', $floorNumber)
|
||||
->first();
|
||||
|
||||
if (!$retributionFormula) {
|
||||
throw new \Exception("Retribution formula not found for building function ID: {$buildingFunctionId}, floor: {$floorNumber}");
|
||||
}
|
||||
|
||||
// Calculate retribution using Excel formula
|
||||
$calculationResult = $this->calculateRetribution(
|
||||
$floorArea,
|
||||
$parameters,
|
||||
$floorHeightIndex->ip_ketinggian
|
||||
);
|
||||
|
||||
// Create retribution proposal
|
||||
return RetributionProposal::create([
|
||||
'spatial_planning_id' => $spatialPlanning->id,
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'retribution_formula_id' => $retributionFormula->id,
|
||||
'floor_number' => $floorNumber,
|
||||
'floor_area' => $floorArea,
|
||||
'total_building_area' => $totalBuildingArea ?? $floorArea,
|
||||
'ip_ketinggian' => $floorHeightIndex->ip_ketinggian,
|
||||
'floor_retribution_amount' => $calculationResult['total_retribution'],
|
||||
'total_retribution_amount' => $calculationResult['total_retribution'],
|
||||
'calculation_parameters' => $calculationResult['parameters'],
|
||||
'calculation_breakdown' => $calculationResult['breakdown'],
|
||||
'notes' => $notes,
|
||||
'calculated_at' => Carbon::now()
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Create proposal without spatial planning
|
||||
*/
|
||||
public function createStandaloneProposal(
|
||||
int $buildingFunctionId,
|
||||
int $floorNumber,
|
||||
float $floorArea,
|
||||
float $totalBuildingArea = null,
|
||||
string $notes = null
|
||||
): RetributionProposal {
|
||||
// Get building function and its parameters
|
||||
$buildingFunction = BuildingFunction::with('parameter')->findOrFail($buildingFunctionId);
|
||||
$parameters = $buildingFunction->parameter;
|
||||
|
||||
if (!$parameters) {
|
||||
throw new \Exception("Building function parameters not found for ID: {$buildingFunctionId}");
|
||||
}
|
||||
|
||||
// Get floor height index
|
||||
$floorHeightIndex = FloorHeightIndex::where('floor_number', $floorNumber)->first();
|
||||
if (!$floorHeightIndex) {
|
||||
throw new \Exception("Floor height index not found for floor: {$floorNumber}");
|
||||
}
|
||||
|
||||
// Get retribution formula
|
||||
$retributionFormula = RetributionFormula::where('building_function_id', $buildingFunctionId)
|
||||
->where('floor_number', $floorNumber)
|
||||
->first();
|
||||
|
||||
if (!$retributionFormula) {
|
||||
throw new \Exception("Retribution formula not found for building function ID: {$buildingFunctionId}, floor: {$floorNumber}");
|
||||
}
|
||||
|
||||
// Calculate retribution using Excel formula
|
||||
$calculationResult = $this->calculateRetribution(
|
||||
$floorArea,
|
||||
$parameters,
|
||||
$floorHeightIndex->ip_ketinggian
|
||||
);
|
||||
|
||||
// Create retribution proposal
|
||||
return RetributionProposal::create([
|
||||
'spatial_planning_id' => null,
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'retribution_formula_id' => $retributionFormula->id,
|
||||
'floor_number' => $floorNumber,
|
||||
'floor_area' => $floorArea,
|
||||
'total_building_area' => $totalBuildingArea ?? $floorArea,
|
||||
'ip_ketinggian' => $floorHeightIndex->ip_ketinggian,
|
||||
'floor_retribution_amount' => $calculationResult['total_retribution'],
|
||||
'total_retribution_amount' => $calculationResult['total_retribution'],
|
||||
'calculation_parameters' => $calculationResult['parameters'],
|
||||
'calculation_breakdown' => $calculationResult['breakdown'],
|
||||
'notes' => $notes,
|
||||
'calculated_at' => Carbon::now()
|
||||
]);
|
||||
}
|
||||
|
||||
/**
|
||||
* Calculate retribution using Excel formula
|
||||
*/
|
||||
protected function calculateRetribution(
|
||||
float $floorArea,
|
||||
BuildingFunctionParameter $parameters,
|
||||
float $ipKetinggian
|
||||
): array {
|
||||
// Excel formula parameters
|
||||
$fungsi_bangunan = $parameters->fungsi_bangunan;
|
||||
$ip_permanen = $parameters->ip_permanen;
|
||||
$ip_kompleksitas = $parameters->ip_kompleksitas;
|
||||
$indeks_lokalitas = $parameters->indeks_lokalitas;
|
||||
$base_value = 70350;
|
||||
$additional_factor = 0.5;
|
||||
|
||||
// Step 1: Calculate H13 (floor coefficient)
|
||||
$h13 = $fungsi_bangunan * ($ip_permanen + $ip_kompleksitas + (0.5 * $ipKetinggian));
|
||||
|
||||
// Step 2: Main calculation
|
||||
$main_calculation = 1 * $floorArea * ($indeks_lokalitas * $base_value * $h13 * 1);
|
||||
|
||||
// Step 3: Additional (50%)
|
||||
$additional_calculation = $additional_factor * $main_calculation;
|
||||
|
||||
// Step 4: Total
|
||||
$total_retribution = $main_calculation + $additional_calculation;
|
||||
|
||||
return [
|
||||
'total_retribution' => $total_retribution,
|
||||
'parameters' => [
|
||||
'fungsi_bangunan' => $fungsi_bangunan,
|
||||
'ip_permanen' => $ip_permanen,
|
||||
'ip_kompleksitas' => $ip_kompleksitas,
|
||||
'ip_ketinggian' => $ipKetinggian,
|
||||
'indeks_lokalitas' => $indeks_lokalitas,
|
||||
'base_value' => $base_value,
|
||||
'additional_factor' => $additional_factor,
|
||||
'floor_area' => $floorArea
|
||||
],
|
||||
'breakdown' => [
|
||||
'h13_calculation' => [
|
||||
'formula' => 'fungsi_bangunan * (ip_permanen + ip_kompleksitas + (0.5 * ip_ketinggian))',
|
||||
'calculation' => "{$fungsi_bangunan} * ({$ip_permanen} + {$ip_kompleksitas} + (0.5 * {$ipKetinggian}))",
|
||||
'result' => $h13
|
||||
],
|
||||
'main_calculation' => [
|
||||
'formula' => '1 * floor_area * (indeks_lokalitas * base_value * h13 * 1)',
|
||||
'calculation' => "1 * {$floorArea} * ({$indeks_lokalitas} * {$base_value} * {$h13} * 1)",
|
||||
'result' => $main_calculation
|
||||
],
|
||||
'additional_calculation' => [
|
||||
'formula' => 'additional_factor * main_calculation',
|
||||
'calculation' => "{$additional_factor} * {$main_calculation}",
|
||||
'result' => $additional_calculation
|
||||
],
|
||||
'total_calculation' => [
|
||||
'formula' => 'main_calculation + additional_calculation',
|
||||
'calculation' => "{$main_calculation} + {$additional_calculation}",
|
||||
'result' => $total_retribution
|
||||
]
|
||||
]
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Get proposal statistics
|
||||
*/
|
||||
public function getStatistics(): array
|
||||
{
|
||||
return [
|
||||
'total_proposals' => RetributionProposal::count(),
|
||||
'total_amount' => RetributionProposal::sum('total_retribution_amount'),
|
||||
'average_amount' => RetributionProposal::avg('total_retribution_amount'),
|
||||
'proposals_with_spatial_planning' => RetributionProposal::whereNotNull('spatial_planning_id')->count(),
|
||||
'proposals_without_spatial_planning' => RetributionProposal::whereNull('spatial_planning_id')->count(),
|
||||
'by_building_function' => RetributionProposal::with('buildingFunction')
|
||||
->selectRaw('building_function_id, COUNT(*) as count, SUM(total_retribution_amount) as total_amount')
|
||||
->groupBy('building_function_id')
|
||||
->orderBy('total_amount', 'desc')
|
||||
->get()
|
||||
->map(function ($item) {
|
||||
return [
|
||||
'building_function_id' => $item->building_function_id,
|
||||
'building_function_name' => $item->buildingFunction->name ?? 'Unknown',
|
||||
'count' => $item->count,
|
||||
'total_amount' => $item->total_amount,
|
||||
'formatted_amount' => 'Rp ' . number_format($item->total_amount, 0, ',', '.')
|
||||
];
|
||||
})->toArray()
|
||||
];
|
||||
}
|
||||
|
||||
/**
|
||||
* Detect building function from text
|
||||
*/
|
||||
public function detectBuildingFunction(string $text): ?BuildingFunction
|
||||
{
|
||||
$text = strtolower($text);
|
||||
|
||||
// Detection patterns - order matters (more specific first)
|
||||
$patterns = [
|
||||
'HUNIAN_TIDAK_SEDERHANA' => [
|
||||
'hunian mewah', 'villa', 'apartemen', 'kondominium', 'townhouse'
|
||||
],
|
||||
'HUNIAN_SEDERHANA' => [
|
||||
'hunian sederhana', 'hunian', 'rumah', 'perumahan', 'residential', 'fungsi hunian'
|
||||
],
|
||||
'USAHA_BESAR' => [
|
||||
'usaha besar', 'pabrik', 'industri', 'mall', 'hotel', 'restoran', 'supermarket',
|
||||
'plaza', 'gedung perkantoran', 'non-mikro', 'non mikro'
|
||||
],
|
||||
'USAHA_KECIL' => [
|
||||
'usaha kecil', 'umkm', 'warung', 'toko', 'mikro', 'kios'
|
||||
],
|
||||
'CAMPURAN_BESAR' => [
|
||||
'campuran besar', 'mixed use besar'
|
||||
],
|
||||
'CAMPURAN_KECIL' => [
|
||||
'campuran kecil', 'ruko', 'mixed use', 'campuran'
|
||||
],
|
||||
'SOSIAL_BUDAYA' => [
|
||||
'sekolah', 'rumah sakit', 'masjid', 'gereja', 'puskesmas', 'klinik',
|
||||
'universitas', 'perpustakaan', 'museum'
|
||||
],
|
||||
'AGAMA' => [
|
||||
'tempat ibadah', 'masjid', 'mushola', 'gereja', 'pura', 'vihara', 'klenteng'
|
||||
]
|
||||
];
|
||||
|
||||
// Try to find exact matches first
|
||||
foreach ($patterns as $functionCode => $keywords) {
|
||||
foreach ($keywords as $keyword) {
|
||||
if (strpos($text, $keyword) !== false) {
|
||||
$buildingFunction = BuildingFunction::where('code', $functionCode)->first();
|
||||
if ($buildingFunction) {
|
||||
return $buildingFunction;
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
// Debug: Log what we're trying to match
|
||||
\Illuminate\Support\Facades\Log::info("Building function detection failed for text: '{$text}'");
|
||||
|
||||
// If no exact match, try to find by name similarity
|
||||
$allFunctions = BuildingFunction::whereNotNull('parent_id')->get(); // Only child functions
|
||||
|
||||
foreach ($allFunctions as $function) {
|
||||
$functionName = strtolower($function->name);
|
||||
|
||||
// Check if any word from the function name appears in the text
|
||||
$words = explode(' ', $functionName);
|
||||
foreach ($words as $word) {
|
||||
if (strlen($word) > 3 && strpos($text, $word) !== false) {
|
||||
return $function;
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
return null;
|
||||
}
|
||||
}
|
||||
@@ -1,14 +1,17 @@
|
||||
<?php
|
||||
|
||||
namespace App\Services;
|
||||
|
||||
use App\Models\BigdataResume;
|
||||
use App\Models\DataSetting;
|
||||
use App\Models\ImportDatasource;
|
||||
use App\Models\PbgTaskGoogleSheet;
|
||||
use App\Models\RetributionProposal;
|
||||
use Carbon\Carbon;
|
||||
use Exception;
|
||||
use Google_Client;
|
||||
use Google_Service_Sheets;
|
||||
use Log;
|
||||
use Google\Client as Google_Client;
|
||||
use Google\Service\Sheets as Google_Service_Sheets;
|
||||
use Illuminate\Support\Facades\Log;
|
||||
class ServiceGoogleSheet
|
||||
{
|
||||
protected $client;
|
||||
@@ -107,7 +110,7 @@ class ServiceGoogleSheet
|
||||
'tanggal_skrd' => $this->convertToDate($cleanValue($row[33] ?? null)),
|
||||
'ptsp' => $cleanValue($row[34] ?? null),
|
||||
'selesai_terbit' => $cleanValue($row[35] ?? null),
|
||||
'tanggal_pembayaran' => $cleanValue($row[36] ?? null),
|
||||
'tanggal_pembayaran' => $this->convertToDate($cleanValue($row[36] ?? null)),
|
||||
'format_sts' => $cleanValue($row[37] ?? null),
|
||||
'tahun_terbit' => (int) $cleanValue($row[38] ?? null),
|
||||
'tahun_berjalan' => (int) $cleanValue($row[39] ?? null),
|
||||
@@ -210,6 +213,110 @@ class ServiceGoogleSheet
|
||||
}
|
||||
}
|
||||
|
||||
public function sync_leader_data(){
|
||||
$import_datasource = ImportDatasource::create([
|
||||
'message' => 'Processing leader data',
|
||||
'status' => 'processing',
|
||||
'start_time' => now(),
|
||||
'failed_uuid' => null
|
||||
]);
|
||||
try {
|
||||
$sections = [
|
||||
'TARGET_PAD' => "TARGET PAD 2024",
|
||||
'KEKURANGAN_POTENSI' => "DEVIASI TARGET DENGAN POTENSI TOTAL BERKAS",
|
||||
'TOTAL_POTENSI_BERKAS' => "•TOTAL BERKAS 2025",
|
||||
'BELUM_TERVERIFIKASI' => "•BERKAS AKTUAL BELUM TERVERIFIKASI (POTENSI):",
|
||||
'TERVERIFIKASI' => "•BERKAS AKTUAL TERVERIFIKASI DINAS TEKNIS 2025:",
|
||||
'NON_USAHA' => "•NON USAHA: HUNIAN, SOSBUD, KEAGAMAAN",
|
||||
'USAHA' => "•USAHA: USAHA, CAMPURAN, KOLEKTIF, PRASARANA",
|
||||
'PROSES_DINAS_TEKNIS' => "•TERPROSES DI DPUTR: belum selesai rekomtek'",
|
||||
'WAITING_KLIK_DPMPTSP' => "•TERPROSES DI PTSP: Pengiriman SKRD/ Validasi di PTSP",
|
||||
'REALISASI_TERBIT_PBG' => "•BERKAS YANG TERBIT PBG 2025:"
|
||||
];
|
||||
|
||||
$result = [];
|
||||
|
||||
foreach ($sections as $key => $identifier) {
|
||||
$values = $this->get_values_from_section(2, $identifier, [10, 11]);
|
||||
|
||||
if (!empty($values)) {
|
||||
$result[$key] = [
|
||||
'identifier' => $identifier,
|
||||
'total' => $values[0] ?? null, // index 0 untuk total/jumlah
|
||||
'nominal' => $values[1] ?? null // index 1 untuk nominal
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
BigdataResume::create([
|
||||
'import_datasource_id' => $import_datasource->id,
|
||||
'year' => 'leader',
|
||||
// USAHA
|
||||
'business_count' => $this->convertToInteger($result['USAHA']['total'] ?? null) ?? 0,
|
||||
'business_sum' => $this->convertToDecimal($result['USAHA']['nominal'] ?? null) ?? 0,
|
||||
// NON USAHA
|
||||
'non_business_count' => $this->convertToInteger($result['NON_USAHA']['total'] ?? null) ?? 0,
|
||||
'non_business_sum' => $this->convertToDecimal($result['NON_USAHA']['nominal'] ?? null) ?? 0,
|
||||
// TERVERIFIKASI
|
||||
'verified_count' => $this->convertToInteger($result['TERVERIFIKASI']['total'] ?? null) ?? 0,
|
||||
'verified_sum' => $this->convertToDecimal($result['TERVERIFIKASI']['nominal'] ?? null) ?? 0,
|
||||
// BELUM TERVERIFIKASI
|
||||
'non_verified_count' => $this->convertToInteger($result['BELUM_TERVERIFIKASI']['total'] ?? null) ?? 0,
|
||||
'non_verified_sum' => $this->convertToDecimal($result['BELUM_TERVERIFIKASI']['nominal'] ?? null) ?? 0,
|
||||
// TOTAL POTENSI BERKAS
|
||||
'potention_count' => $this->convertToInteger($result['TOTAL_POTENSI_BERKAS']['total'] ?? null) ?? 0,
|
||||
'potention_sum' => $this->convertToDecimal($result['TOTAL_POTENSI_BERKAS']['nominal'] ?? null) ?? 0,
|
||||
// REALISASI TERBIT PBG
|
||||
'issuance_realization_pbg_count' => $this->convertToInteger($result['REALISASI_TERBIT_PBG']['total'] ?? null) ?? 0,
|
||||
'issuance_realization_pbg_sum' => $this->convertToDecimal($result['REALISASI_TERBIT_PBG']['nominal'] ?? null) ?? 0,
|
||||
// WAITING KLIK DPMPTSP
|
||||
'waiting_click_dpmptsp_count' => $this->convertToInteger($result['WAITING_KLIK_DPMPTSP']['total'] ?? null) ?? 0,
|
||||
'waiting_click_dpmptsp_sum' => $this->convertToDecimal($result['WAITING_KLIK_DPMPTSP']['nominal'] ?? null) ?? 0,
|
||||
// PROSES DINAS TEKNIS
|
||||
'process_in_technical_office_count' => $this->convertToInteger($result['PROSES_DINAS_TEKNIS']['total'] ?? null) ?? 0,
|
||||
'process_in_technical_office_sum' => $this->convertToDecimal($result['PROSES_DINAS_TEKNIS']['nominal'] ?? null) ?? 0,
|
||||
// TATA RUANG
|
||||
'spatial_count' => RetributionProposal::count(),
|
||||
'spatial_sum' => RetributionProposal::sum('total_retribution_amount'),
|
||||
]);
|
||||
|
||||
// Save data settings
|
||||
$dataSettings = [
|
||||
'TARGET_PAD' => $result['TARGET_PAD']['nominal'] ?? null,
|
||||
'KEKURANGAN_POTENSI' => $result['KEKURANGAN_POTENSI']['nominal'] ?? null,
|
||||
'REALISASI_TERBIT_PBG_COUNT' => $result['REALISASI_TERBIT_PBG']['total'] ?? null,
|
||||
'REALISASI_TERBIT_PBG_SUM' => $result['REALISASI_TERBIT_PBG']['nominal'] ?? null,
|
||||
'MENUNGGU_KLIK_DPMPTSP_COUNT' => $result['WAITING_KLIK_DPMPTSP']['total'] ?? null,
|
||||
'MENUNGGU_KLIK_DPMPTSP_SUM' => $result['WAITING_KLIK_DPMPTSP']['nominal'] ?? null,
|
||||
'PROSES_DINAS_TEKNIS_COUNT' => $result['PROSES_DINAS_TEKNIS']['total'] ?? null,
|
||||
'PROSES_DINAS_TEKNIS_SUM' => $result['PROSES_DINAS_TEKNIS']['nominal'] ?? null,
|
||||
];
|
||||
|
||||
foreach ($dataSettings as $key => $value) {
|
||||
DataSetting::updateOrInsert(
|
||||
['key' => $key],
|
||||
['value' => $this->convertToInteger($value) ?? 0]
|
||||
);
|
||||
}
|
||||
|
||||
$import_datasource->update([
|
||||
'status' => 'success',
|
||||
'response_body' => json_encode($result),
|
||||
'message' => 'Leader data synced',
|
||||
'finish_time' => now()
|
||||
]);
|
||||
return $result;
|
||||
} catch (\Exception $e) {
|
||||
Log::error("Error syncing leader data", ['error' => $e->getMessage()]);
|
||||
$import_datasource->update([
|
||||
'status' => 'failed',
|
||||
'message' => 'Leader data sync failed',
|
||||
'finish_time' => now()
|
||||
]);
|
||||
throw $e;
|
||||
}
|
||||
}
|
||||
|
||||
public function get_big_resume_data(){
|
||||
try {
|
||||
$sheet_big_data = $this->get_data_by_sheet();
|
||||
@@ -261,9 +368,71 @@ class ServiceGoogleSheet
|
||||
return!empty($values)? $values : [];
|
||||
}
|
||||
|
||||
/**
|
||||
* Get specific values from a row that contains a specific text/section identifier
|
||||
* @param int $no_sheet Sheet number (0-based)
|
||||
* @param string $section_identifier Text to search for in the row
|
||||
* @param array $column_indices Array of column indices to extract values from
|
||||
* @return array Array of values from specified columns, or empty array if section not found
|
||||
*/
|
||||
private function get_values_from_section($no_sheet = 1, $section_identifier, $column_indices = []) {
|
||||
try {
|
||||
$sheet_data = $this->get_data_by_sheet($no_sheet);
|
||||
|
||||
if (empty($sheet_data)) {
|
||||
Log::warning("No data found in sheet", ['sheet' => $no_sheet]);
|
||||
return [];
|
||||
}
|
||||
|
||||
// Search for the row containing the section identifier
|
||||
$target_row = null;
|
||||
foreach ($sheet_data as $row_index => $row) {
|
||||
if (is_array($row)) {
|
||||
foreach ($row as $cell) {
|
||||
if (is_string($cell) && strpos($cell, $section_identifier) !== false) {
|
||||
$target_row = $row;
|
||||
break 2; // Break out of both loops
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
if ($target_row === null) {
|
||||
Log::warning("Section not found", ['section_identifier' => $section_identifier]);
|
||||
return [];
|
||||
}
|
||||
|
||||
// Extract values from specified column indices
|
||||
$extracted_values = [];
|
||||
foreach ($column_indices as $col_index) {
|
||||
if (isset($target_row[$col_index])) {
|
||||
$value = trim($target_row[$col_index]);
|
||||
$extracted_values[] = $value !== '' ? $value : null;
|
||||
} else {
|
||||
$extracted_values[] = null;
|
||||
}
|
||||
}
|
||||
|
||||
Log::info("Values extracted from section", [
|
||||
'section_identifier' => $section_identifier,
|
||||
'column_indices' => $column_indices,
|
||||
'extracted_values' => $extracted_values
|
||||
]);
|
||||
|
||||
return $extracted_values;
|
||||
} catch (\Exception $e) {
|
||||
Log::error("Error getting values from section", [
|
||||
'error' => $e->getMessage(),
|
||||
'section_identifier' => $section_identifier,
|
||||
'sheet' => $no_sheet
|
||||
]);
|
||||
return [];
|
||||
}
|
||||
}
|
||||
|
||||
private function convertToInteger($value) {
|
||||
// Check if the value is an empty string, and return null if true
|
||||
if (trim($value) === "") {
|
||||
// Check if the value is null or empty string, and return null if true
|
||||
if ($value === null || trim($value) === "") {
|
||||
return null;
|
||||
}
|
||||
|
||||
|
||||
@@ -4,6 +4,7 @@ namespace App\Services;
|
||||
|
||||
use App\Models\GlobalSetting;
|
||||
use App\Models\PbgTask;
|
||||
use App\Models\PbgTaskDetail;
|
||||
use App\Models\PbgTaskIndexIntegrations;
|
||||
use App\Models\PbgTaskPrasarana;
|
||||
use App\Models\PbgTaskRetributions;
|
||||
@@ -53,6 +54,7 @@ class ServiceTabPbgTask
|
||||
}
|
||||
try{
|
||||
$this->current_uuid = $pbg_task->uuid;
|
||||
$this->scraping_task_details($pbg_task->uuid);
|
||||
$this->scraping_task_assignments($pbg_task->uuid);
|
||||
$this->scraping_task_retributions($pbg_task->uuid);
|
||||
$this->scraping_task_integrations($pbg_task->uuid);
|
||||
@@ -71,6 +73,75 @@ class ServiceTabPbgTask
|
||||
return $this->current_uuid;
|
||||
}
|
||||
|
||||
private function scraping_task_details($uuid)
|
||||
{
|
||||
$url = "{$this->simbg_host}/api/pbg/v1/detail/{$uuid}/";
|
||||
$options = [
|
||||
'headers' => [
|
||||
'Authorization' => "Bearer {$this->user_token}",
|
||||
'Content-Type' => 'application/json'
|
||||
]
|
||||
];
|
||||
|
||||
$maxRetries = 3;
|
||||
$initialDelay = 1;
|
||||
$retriedAfter401 = false;
|
||||
|
||||
for ($retryCount = 0; $retryCount < $maxRetries; $retryCount++) {
|
||||
try {
|
||||
$response = $this->client->get($url, $options);
|
||||
$responseData = json_decode($response->getBody()->getContents(), true, 512, JSON_THROW_ON_ERROR);
|
||||
|
||||
if (empty($responseData['data']) || !is_array($responseData['data'])) {
|
||||
return true;
|
||||
}
|
||||
|
||||
$data = $responseData['data'];
|
||||
|
||||
// Use the static method from PbgTaskDetail model to create/update
|
||||
PbgTaskDetail::createFromApiResponse($data, $uuid);
|
||||
|
||||
return $responseData;
|
||||
} catch (\GuzzleHttp\Exception\ClientException $e) {
|
||||
if ($e->getCode() === 401 && !$retriedAfter401) {
|
||||
Log::warning("401 Unauthorized - Refreshing token and retrying...");
|
||||
try{
|
||||
$this->refreshToken();
|
||||
$options['headers']['Authorization'] = "Bearer {$this->user_token}";
|
||||
$retriedAfter401 = true;
|
||||
continue;
|
||||
}catch(\Exception $refreshError){
|
||||
Log::error("Token refresh and login failed: " . $refreshError->getMessage());
|
||||
return false;
|
||||
}
|
||||
}
|
||||
|
||||
return false;
|
||||
} catch (\GuzzleHttp\Exception\ServerException | \GuzzleHttp\Exception\ConnectException $e) {
|
||||
if ($e->getCode() === 502) {
|
||||
Log::warning("502 Bad Gateway - Retrying in {$initialDelay} seconds...");
|
||||
} else {
|
||||
Log::error("Network error ({$e->getCode()}) - Retrying in {$initialDelay} seconds...");
|
||||
}
|
||||
|
||||
sleep($initialDelay);
|
||||
$initialDelay *= 2;
|
||||
} catch (\GuzzleHttp\Exception\RequestException $e) {
|
||||
Log::error("Request error ({$e->getCode()}): " . $e->getMessage());
|
||||
return false;
|
||||
} catch (\JsonException $e) {
|
||||
Log::error("JSON decoding error: " . $e->getMessage());
|
||||
return false;
|
||||
} catch (\Throwable $e) {
|
||||
Log::critical("Unhandled error: " . $e->getMessage(), ['trace' => $e->getTraceAsString()]);
|
||||
return false;
|
||||
}
|
||||
}
|
||||
|
||||
Log::error("Failed to fetch task details for UUID {$uuid} after {$maxRetries} retries.");
|
||||
throw new \Exception("Failed to fetch task details for UUID {$uuid} after retries.");
|
||||
}
|
||||
|
||||
private function scraping_task_assignments($uuid)
|
||||
{
|
||||
$url = "{$this->simbg_host}/api/pbg/v1/list-tim-penilai/{$uuid}/?page=1&size=10";
|
||||
|
||||
@@ -13,13 +13,15 @@ class Circle extends Component
|
||||
public $document_type;
|
||||
public $document_id;
|
||||
public $visible_small_circle;
|
||||
public function __construct($document_id = "",$document_title = "", $document_type = "", $document_color = "#020c5c", $visible_small_circle = true)
|
||||
public $document_url;
|
||||
public function __construct($document_id = "",$document_title = "", $document_type = "", $document_color = "#020c5c", $visible_small_circle = true, $document_url = "#")
|
||||
{
|
||||
$this->document_title = $document_title;
|
||||
$this->document_color = $document_color;
|
||||
$this->document_type = $document_type;
|
||||
$this->document_id = $document_id;
|
||||
$this->visible_small_circle = $visible_small_circle;
|
||||
$this->document_url = $document_url;
|
||||
}
|
||||
|
||||
/**
|
||||
|
||||
0
bootstrap/app.php
Executable file → Normal file
0
bootstrap/app.php
Executable file → Normal file
0
bootstrap/providers.php
Executable file → Normal file
0
bootstrap/providers.php
Executable file → Normal file
34
build-and-zip.sh
Executable file
34
build-and-zip.sh
Executable file
@@ -0,0 +1,34 @@
|
||||
#!/bin/bash
|
||||
|
||||
# Build and Zip Script for Laravel Vite Project
|
||||
echo "🚀 Starting build process..."
|
||||
|
||||
# Clean previous build
|
||||
echo "🧹 Cleaning previous build..."
|
||||
rm -rf public/build
|
||||
rm -f build.zip
|
||||
|
||||
# Run npm build
|
||||
echo "📦 Building assets with Vite..."
|
||||
npm run build
|
||||
|
||||
# Check if build was successful
|
||||
if [ $? -eq 0 ]; then
|
||||
echo "✅ Build completed successfully!"
|
||||
|
||||
# Create zip file
|
||||
echo "📁 Creating build.zip..."
|
||||
cd public && zip -r ../build.zip build/
|
||||
cd ..
|
||||
|
||||
echo "✅ build.zip created successfully!"
|
||||
echo "📊 Build folder size:"
|
||||
du -sh public/build
|
||||
echo "📊 Zip file size:"
|
||||
du -sh build.zip
|
||||
|
||||
echo "🎉 Process completed! You can now upload build.zip to your server."
|
||||
else
|
||||
echo "❌ Build failed! Please check the errors above."
|
||||
exit 1
|
||||
fi
|
||||
0
composer.json
Executable file → Normal file
0
composer.json
Executable file → Normal file
0
config/app.php
Executable file → Normal file
0
config/app.php
Executable file → Normal file
0
config/auth.php
Executable file → Normal file
0
config/auth.php
Executable file → Normal file
0
config/cache.php
Executable file → Normal file
0
config/cache.php
Executable file → Normal file
0
config/database.php
Executable file → Normal file
0
config/database.php
Executable file → Normal file
0
config/filesystems.php
Executable file → Normal file
0
config/filesystems.php
Executable file → Normal file
0
config/logging.php
Executable file → Normal file
0
config/logging.php
Executable file → Normal file
0
config/mail.php
Executable file → Normal file
0
config/mail.php
Executable file → Normal file
0
config/queue.php
Executable file → Normal file
0
config/queue.php
Executable file → Normal file
0
config/services.php
Executable file → Normal file
0
config/services.php
Executable file → Normal file
0
config/session.php
Executable file → Normal file
0
config/session.php
Executable file → Normal file
0
database/.gitignore
vendored
Executable file → Normal file
0
database/.gitignore
vendored
Executable file → Normal file
0
database/factories/UserFactory.php
Executable file → Normal file
0
database/factories/UserFactory.php
Executable file → Normal file
0
database/migrations/0001_01_01_000000_create_users_table.php
Executable file → Normal file
0
database/migrations/0001_01_01_000000_create_users_table.php
Executable file → Normal file
0
database/migrations/0001_01_01_000001_create_cache_table.php
Executable file → Normal file
0
database/migrations/0001_01_01_000001_create_cache_table.php
Executable file → Normal file
0
database/migrations/0001_01_01_000002_create_jobs_table.php
Executable file → Normal file
0
database/migrations/0001_01_01_000002_create_jobs_table.php
Executable file → Normal file
@@ -0,0 +1,26 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('pbg_task', function(Blueprint $table){
|
||||
$table->text('address')->nullable()->change();
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
//
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,44 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('spatial_plannings', function (Blueprint $table) {
|
||||
$table->text('no_tapak')->nullable();
|
||||
$table->text('no_skkl')->nullable();
|
||||
$table->text('no_ukl')->nullable();
|
||||
$table->string('building_function')->nullable();
|
||||
$table->string('sub_building_function')->nullable();
|
||||
$table->integer('number_of_floors')->default(1);
|
||||
$table->decimal('land_area', 18, 6)->nullable();
|
||||
$table->decimal('site_bcr', 10, 6)->nullable();
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('spatial_plannings', function (Blueprint $table) {
|
||||
$table->dropColumn([
|
||||
'no_tapak',
|
||||
'no_skkl',
|
||||
'no_ukl',
|
||||
'building_function',
|
||||
'sub_building_function',
|
||||
'number_of_floors',
|
||||
'land_area',
|
||||
'site_bcr',
|
||||
]);
|
||||
});
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,39 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('building_functions', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->string('code')->unique()->comment('Kode unik fungsi bangunan');
|
||||
$table->string('name', 255)->comment('Nama fungsi bangunan');
|
||||
$table->text('description')->nullable()->comment('Deskripsi detail fungsi bangunan');
|
||||
$table->unsignedBigInteger('parent_id')->nullable()->comment('ID parent untuk hierarki');
|
||||
$table->foreign('parent_id')->references('id')->on('building_functions')->onDelete('cascade');
|
||||
$table->integer('level')->default(0)->comment('Level hierarki (0=root, 1=child, dst)');
|
||||
$table->integer('sort_order')->default(0)->comment('Urutan tampilan');
|
||||
$table->decimal('base_tariff', 15, 2)->nullable()->comment('Tarif dasar per m2');
|
||||
|
||||
// Indexes untuk performa
|
||||
$table->index(['parent_id', 'level']);
|
||||
$table->index(['level', 'sort_order']);
|
||||
$table->timestamps();
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('building_functions');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,34 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('floor_height_indices', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->integer('floor_number')->comment('Nomor lantai');
|
||||
$table->decimal('ip_ketinggian', 10, 6)->comment('Indeks ketinggian per lantai');
|
||||
$table->text('description')->nullable()->comment('Deskripsi indeks ketinggian');
|
||||
$table->timestamps();
|
||||
|
||||
// Unique constraint untuk floor_number
|
||||
$table->unique('floor_number');
|
||||
$table->index('floor_number');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('floor_height_indices');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,37 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('building_function_parameters', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->foreignId('building_function_id')->constrained('building_functions')->onDelete('cascade');
|
||||
$table->decimal('fungsi_bangunan', 10, 6)->nullable()->comment('Parameter fungsi bangunan');
|
||||
$table->decimal('ip_permanen', 10, 6)->nullable()->comment('Parameter IP permanen');
|
||||
$table->decimal('ip_kompleksitas', 10, 6)->nullable()->comment('Parameter IP kompleksitas');
|
||||
$table->decimal('indeks_lokalitas', 10, 6)->nullable()->comment('Parameter indeks lokalitas');
|
||||
$table->decimal('asumsi_prasarana', 8, 6)->nullable()->comment('Parameter asumsi prasarana untuk perhitungan retribusi');
|
||||
$table->decimal('koefisien_dasar', 15, 6)->nullable()->comment('Koefisien dasar perhitungan');
|
||||
$table->timestamps();
|
||||
|
||||
// Unique constraint untuk 1:1 relationship
|
||||
$table->unique('building_function_id');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('building_function_parameters');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,34 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('retribution_formulas', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->foreignId('building_function_id')->constrained('building_functions')->onDelete('cascade');
|
||||
$table->string('name', 255)->comment('Nama formula');
|
||||
$table->integer('floor_number')->comment('Nomor lantai (1, 2, 3, dst, 0=semua lantai)');
|
||||
$table->text('formula_expression')->comment('Rumus matematika untuk perhitungan');
|
||||
$table->timestamps();
|
||||
|
||||
// Indexes untuk performa
|
||||
$table->index(['building_function_id', 'floor_number'], 'idx_building_floor');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('retribution_formulas');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,46 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('retribution_proposals', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->foreignId('spatial_planning_id')->nullable()->constrained('spatial_plannings')->onDelete('cascade');
|
||||
$table->foreignId('building_function_id')->constrained('building_functions')->onDelete('cascade');
|
||||
$table->foreignId('retribution_formula_id')->constrained('retribution_formulas')->onDelete('cascade');
|
||||
$table->string('proposal_number')->unique()->comment('Nomor usulan retribusi');
|
||||
$table->integer('floor_number')->comment('Nomor lantai (1, 2, 3, dst)');
|
||||
$table->decimal('floor_area', 15, 6)->comment('Luas lantai ini (m2)');
|
||||
$table->decimal('total_building_area', 15, 6)->comment('Total luas bangunan (m2)');
|
||||
$table->decimal('ip_ketinggian', 10, 6)->comment('IP ketinggian untuk lantai ini');
|
||||
$table->decimal('floor_retribution_amount', 15, 2)->comment('Jumlah retribusi untuk lantai ini');
|
||||
$table->decimal('total_retribution_amount', 15, 2)->comment('Total retribusi keseluruhan');
|
||||
$table->json('calculation_parameters')->nullable()->comment('Parameter yang digunakan dalam perhitungan');
|
||||
$table->json('calculation_breakdown')->nullable()->comment('Breakdown detail perhitungan');
|
||||
$table->text('notes')->nullable()->comment('Catatan tambahan');
|
||||
$table->datetime('calculated_at')->comment('Waktu perhitungan dilakukan');
|
||||
$table->timestamps();
|
||||
|
||||
// Indexes untuk performa
|
||||
$table->index(['spatial_planning_id', 'floor_number'], 'idx_spatial_floor');
|
||||
$table->index(['building_function_id'], 'idx_function');
|
||||
$table->index('calculated_at');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('retribution_proposals');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,166 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('pbg_task_details', function (Blueprint $table) {
|
||||
$table->id();
|
||||
|
||||
// Foreign key relationship
|
||||
$table->string('pbg_task_uid')->index();
|
||||
|
||||
// Basic information
|
||||
$table->string('uid')->unique();
|
||||
$table->string('nik');
|
||||
$table->string('type_card');
|
||||
$table->string('ownership')->nullable();
|
||||
$table->string('owner_name');
|
||||
|
||||
// Owner location information
|
||||
$table->bigInteger('ward_id');
|
||||
$table->string('ward_name');
|
||||
$table->integer('district_id');
|
||||
$table->string('district_name');
|
||||
$table->integer('regency_id');
|
||||
$table->string('regency_name');
|
||||
$table->integer('province_id');
|
||||
$table->string('province_name');
|
||||
$table->text('address');
|
||||
|
||||
// Owner contact information
|
||||
$table->string('owner_email');
|
||||
$table->string('owner_phone');
|
||||
|
||||
// User information
|
||||
$table->integer('user');
|
||||
$table->string('name');
|
||||
$table->string('email');
|
||||
$table->string('phone');
|
||||
$table->string('user_nik');
|
||||
|
||||
// User location information
|
||||
$table->integer('user_province_id');
|
||||
$table->string('user_province_name');
|
||||
$table->integer('user_regency_id');
|
||||
$table->string('user_regency_name');
|
||||
$table->integer('user_district_id');
|
||||
$table->string('user_district_name');
|
||||
$table->text('user_address');
|
||||
|
||||
// Status information
|
||||
$table->integer('status');
|
||||
$table->string('status_name');
|
||||
$table->integer('slf_status')->nullable();
|
||||
$table->string('slf_status_name')->nullable();
|
||||
$table->integer('sppst_status');
|
||||
$table->string('sppst_file')->nullable();
|
||||
$table->string('sppst_status_name');
|
||||
|
||||
// Files and documents
|
||||
$table->string('file_pbg')->nullable();
|
||||
$table->date('file_pbg_date')->nullable();
|
||||
$table->date('due_date')->nullable();
|
||||
$table->date('start_date');
|
||||
$table->string('document_number')->nullable();
|
||||
$table->string('registration_number');
|
||||
|
||||
// Application information
|
||||
$table->string('function_type')->nullable();
|
||||
$table->string('application_type')->nullable();
|
||||
$table->string('application_type_name')->nullable();
|
||||
$table->string('consultation_type')->nullable();
|
||||
$table->string('condition')->nullable();
|
||||
$table->string('prototype')->nullable();
|
||||
$table->string('permanency')->nullable();
|
||||
|
||||
// Building information
|
||||
$table->integer('building_type')->nullable();
|
||||
$table->string('building_type_name')->nullable();
|
||||
$table->string('building_purpose')->nullable();
|
||||
$table->string('building_use')->nullable();
|
||||
$table->string('occupancy')->nullable();
|
||||
$table->string('name_building')->nullable();
|
||||
|
||||
// Building dimensions and specifications
|
||||
$table->decimal('total_area', 10, 2);
|
||||
$table->decimal('area', 10, 2)->nullable();
|
||||
$table->string('area_type')->nullable();
|
||||
$table->decimal('height', 8, 2);
|
||||
$table->integer('floor');
|
||||
$table->decimal('floor_area', 10, 2)->nullable();
|
||||
$table->integer('basement');
|
||||
$table->decimal('basement_height', 8, 2)->nullable();
|
||||
$table->decimal('basement_area', 10, 2);
|
||||
$table->integer('unit')->nullable();
|
||||
|
||||
// Previous information
|
||||
$table->decimal('prev_retribution', 15, 2)->nullable();
|
||||
$table->string('prev_pbg')->nullable();
|
||||
$table->decimal('prev_total_area', 10, 2)->nullable();
|
||||
|
||||
// Coefficients
|
||||
$table->decimal('koefisien_dasar_bangunan', 8, 4)->nullable();
|
||||
$table->decimal('koefisien_lantai_bangunan', 8, 4)->nullable();
|
||||
$table->decimal('koefisien_lantai_hijau', 8, 4)->nullable();
|
||||
$table->decimal('koefisien_tapak_basement', 8, 4)->nullable();
|
||||
$table->decimal('ketinggian_bangunan', 8, 2)->nullable();
|
||||
|
||||
// Road information
|
||||
$table->string('jalan_arteri')->nullable();
|
||||
$table->string('jalan_kolektor')->nullable();
|
||||
$table->string('jalan_bangunan')->nullable();
|
||||
$table->decimal('gsb', 8, 2)->nullable();
|
||||
$table->string('kkr_number')->nullable();
|
||||
|
||||
// Unit data as JSON
|
||||
$table->json('unit_data')->nullable();
|
||||
|
||||
// Additional flags
|
||||
$table->boolean('is_mbr')->default(false);
|
||||
$table->string('code');
|
||||
|
||||
// Building location information
|
||||
$table->bigInteger('building_ward_id');
|
||||
$table->string('building_ward_name');
|
||||
$table->integer('building_district_id');
|
||||
$table->string('building_district_name');
|
||||
$table->integer('building_regency_id');
|
||||
$table->string('building_regency_name');
|
||||
$table->integer('building_province_id');
|
||||
$table->string('building_province_name');
|
||||
$table->text('building_address');
|
||||
|
||||
// Coordinates
|
||||
$table->decimal('latitude', 10, 8)->nullable();
|
||||
$table->decimal('longitude', 11, 8)->nullable();
|
||||
|
||||
// Additional files
|
||||
$table->string('building_photo')->nullable();
|
||||
$table->string('pbg_parent')->nullable();
|
||||
|
||||
// Original created_at from API
|
||||
$table->timestamp('api_created_at')->nullable();
|
||||
|
||||
$table->timestamps();
|
||||
|
||||
// Add foreign key constraint
|
||||
$table->foreign('pbg_task_uid')->references('uuid')->on('pbg_task')->onDelete('cascade');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('pbg_task_details');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,35 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('master_parameters', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->string('parameter_code', 255)->unique()->comment('Kode unik parameter');
|
||||
$table->string('parameter_name', 255)->comment('Nama parameter');
|
||||
$table->decimal('default_value', 15, 6)->default(0.000000)->comment('Nilai default parameter');
|
||||
$table->string('unit', 50)->nullable()->comment('Satuan parameter');
|
||||
$table->text('description')->nullable()->comment('Deskripsi parameter');
|
||||
$table->timestamps();
|
||||
|
||||
// Add indexes for better performance
|
||||
$table->index('parameter_name', 'idx_master_parameters_name');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('master_parameters');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,36 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('master_formulas', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->string('formula_code', 255)->unique()->comment('Kode unik formula');
|
||||
$table->string('formula_name', 255)->comment('Nama formula');
|
||||
$table->text('formula_expression')->comment('Formula matematika');
|
||||
$table->string('formula_category', 255)->nullable()->comment('Kategori formula');
|
||||
$table->text('description')->nullable()->comment('Deskripsi formula');
|
||||
$table->text('usage_notes')->nullable()->comment('Catatan penggunaan');
|
||||
$table->timestamps();
|
||||
|
||||
// Add indexes for better performance
|
||||
$table->index('formula_category', 'idx_master_formulas_category');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('master_formulas');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,36 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('formula_parameters', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->foreignId('formula_id')->constrained('master_formulas')->onDelete('cascade')->comment('ID formula');
|
||||
$table->foreignId('parameter_id')->constrained('master_parameters')->onDelete('cascade')->comment('ID parameter');
|
||||
$table->timestamps();
|
||||
|
||||
// Composite unique constraint to prevent duplicate relations
|
||||
$table->unique(['formula_id', 'parameter_id'], 'unique_formula_parameter');
|
||||
|
||||
// Indexes for better performance
|
||||
$table->index('formula_id', 'idx_formula_parameters_formula');
|
||||
$table->index('parameter_id', 'idx_formula_parameters_parameter');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('formula_parameters');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,45 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
/**
|
||||
* Run the migrations.
|
||||
*/
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('building_function_formula_configs', function (Blueprint $table) {
|
||||
$table->id();
|
||||
$table->foreignId('building_function_id')->constrained('building_functions')->onDelete('cascade')->comment('ID fungsi bangunan');
|
||||
$table->foreignId('formula_id')->constrained('master_formulas')->onDelete('cascade')->comment('ID formula yang digunakan');
|
||||
$table->integer('floor_level')->comment('Level lantai (1, 2, 3, dst. 0 untuk semua lantai)');
|
||||
$table->integer('min_floor')->nullable()->comment('Minimum lantai yang berlaku (opsional)');
|
||||
$table->integer('max_floor')->nullable()->comment('Maximum lantai yang berlaku (opsional)');
|
||||
$table->decimal('multiplier', 8, 4)->default(1.0000)->comment('Pengali khusus untuk lantai ini');
|
||||
$table->boolean('is_active')->default(true)->comment('Status aktif konfigurasi');
|
||||
$table->integer('priority')->default(0)->comment('Prioritas jika ada konflik (angka lebih besar = prioritas lebih tinggi)');
|
||||
$table->text('notes')->nullable()->comment('Catatan konfigurasi');
|
||||
$table->timestamps();
|
||||
|
||||
// Composite unique constraint untuk mencegah duplikasi konfigurasi
|
||||
$table->unique(['building_function_id', 'formula_id', 'floor_level'], 'unique_building_formula_floor');
|
||||
|
||||
// Indexes untuk performa
|
||||
$table->index(['building_function_id', 'floor_level'], 'idx_building_floor');
|
||||
$table->index(['building_function_id', 'is_active'], 'idx_building_active');
|
||||
$table->index(['floor_level', 'is_active'], 'idx_floor_active');
|
||||
$table->index('priority', 'idx_priority');
|
||||
});
|
||||
}
|
||||
|
||||
/**
|
||||
* Reverse the migrations.
|
||||
*/
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('building_function_formula_configs');
|
||||
}
|
||||
};
|
||||
216
database/seeders/BuildingFunctionFormulaConfigSeeder.php
Normal file
216
database/seeders/BuildingFunctionFormulaConfigSeeder.php
Normal file
@@ -0,0 +1,216 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\BuildingFunctionFormulaConfig;
|
||||
use App\Models\BuildingFunction;
|
||||
use App\Models\MasterFormula;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class BuildingFunctionFormulaConfigSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$now = Carbon::now();
|
||||
|
||||
// Mapping Building Function Codes to IDs (sesuai dengan BuildingFunctionSeeder)
|
||||
$buildingFunctionMapping = [
|
||||
'AGAMA' => 1, // Fungsi Keagamaan
|
||||
'SOSIAL_BUDAYA' => 2, // Fungsi Sosial Budaya
|
||||
'CAMPURAN_KECIL' => 6, // Campuran Kecil
|
||||
'CAMPURAN_BESAR' => 7, // Campuran Besar
|
||||
'USAHA_KECIL' => 8, // UMKM
|
||||
'USAHA_BESAR' => 9, // Usaha Besar (Non-Mikro)
|
||||
'HUNIAN_SEDERHANA' => 10, // Hunian Sederhana <100
|
||||
'HUNIAN_TIDAK_SEDERHANA' => 11, // Hunian Tidak Sederhana >100
|
||||
];
|
||||
|
||||
// Get Formula IDs (akan dibuat di MasterFormulaSeeder)
|
||||
$formulaMapping = [
|
||||
'BEBAS' => 'RETRIBUSI_BEBAS',
|
||||
'DASAR' => 'RETRIBUSI_DASAR',
|
||||
'LENGKAP' => 'RETRIBUSI_DENGAN_PRASARANA'
|
||||
];
|
||||
|
||||
// Configurations per Building Function dan Floor Level
|
||||
$configs = [];
|
||||
|
||||
// 1. FUNGSI KEAGAMAAN - Bebas Retribusi (semua lantai)
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['AGAMA'],
|
||||
'formula_code' => 'RETRIBUSI_BEBAS',
|
||||
'floor_level' => 0, // Berlaku untuk semua lantai
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => 'Bangunan keagamaan bebas retribusi untuk semua lantai'
|
||||
];
|
||||
|
||||
// 2. FUNGSI SOSIAL BUDAYA - Formula dengan parameter khusus
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['SOSIAL_BUDAYA'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Sosial budaya lantai {$floor} - menggunakan parameter khusus sosial budaya"
|
||||
];
|
||||
}
|
||||
|
||||
// 3. CAMPURAN KECIL - Formula per lantai
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['CAMPURAN_KECIL'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Campuran kecil lantai {$floor} - parameter fungsi 0.6"
|
||||
];
|
||||
}
|
||||
|
||||
// 4. CAMPURAN BESAR - Formula per lantai
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['CAMPURAN_BESAR'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Campuran besar lantai {$floor} - parameter fungsi 0.8"
|
||||
];
|
||||
}
|
||||
|
||||
// 5. UMKM - Formula per lantai
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['USAHA_KECIL'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "UMKM lantai {$floor} - parameter fungsi 0.5"
|
||||
];
|
||||
}
|
||||
|
||||
// 6. USAHA BESAR - Formula per lantai
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['USAHA_BESAR'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Usaha besar lantai {$floor} - parameter fungsi 0.7"
|
||||
];
|
||||
}
|
||||
|
||||
// 7. HUNIAN SEDERHANA - Formula khusus dengan IP Kompleksitas 0.3
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['HUNIAN_SEDERHANA'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Hunian sederhana lantai {$floor} - parameter fungsi 0.15, IP kompleksitas 0.3"
|
||||
];
|
||||
}
|
||||
|
||||
// 8. HUNIAN TIDAK SEDERHANA - Formula standar
|
||||
for ($floor = 1; $floor <= 6; $floor++) {
|
||||
$configs[] = [
|
||||
'building_function_id' => $buildingFunctionMapping['HUNIAN_TIDAK_SEDERHANA'],
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'floor_level' => $floor,
|
||||
'min_floor' => null,
|
||||
'max_floor' => null,
|
||||
'multiplier' => 1.0000,
|
||||
'is_active' => true,
|
||||
'priority' => 1,
|
||||
'notes' => "Hunian tidak sederhana lantai {$floor} - parameter fungsi 0.17"
|
||||
];
|
||||
}
|
||||
|
||||
// Insert configurations
|
||||
foreach ($configs as $config) {
|
||||
// Get formula ID
|
||||
$formula = DB::table('master_formulas')
|
||||
->where('formula_code', $config['formula_code'])
|
||||
->first();
|
||||
|
||||
if ($formula) {
|
||||
DB::table('building_function_formula_configs')->updateOrInsert(
|
||||
[
|
||||
'building_function_id' => $config['building_function_id'],
|
||||
'formula_id' => $formula->id,
|
||||
'floor_level' => $config['floor_level']
|
||||
],
|
||||
[
|
||||
'min_floor' => $config['min_floor'],
|
||||
'max_floor' => $config['max_floor'],
|
||||
'multiplier' => $config['multiplier'],
|
||||
'is_active' => $config['is_active'],
|
||||
'priority' => $config['priority'],
|
||||
'notes' => $config['notes'],
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
]
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
$this->command->info('Building Function Formula Configurations seeded successfully!');
|
||||
$this->command->info('=== CONFIGURATION SUMMARY ===');
|
||||
$this->command->info('Total configurations created: ' . count($configs));
|
||||
|
||||
// Summary per building function
|
||||
$summary = [];
|
||||
foreach ($configs as $config) {
|
||||
$buildingFunctionId = $config['building_function_id'];
|
||||
if (!isset($summary[$buildingFunctionId])) {
|
||||
$summary[$buildingFunctionId] = 0;
|
||||
}
|
||||
$summary[$buildingFunctionId]++;
|
||||
}
|
||||
|
||||
foreach ($buildingFunctionMapping as $code => $id) {
|
||||
$count = $summary[$id] ?? 0;
|
||||
$this->command->info("{$code}: {$count} configurations");
|
||||
}
|
||||
|
||||
$this->command->info('=== KEY FEATURES ===');
|
||||
$this->command->info('✓ Fungsi Keagamaan: Bebas retribusi semua lantai');
|
||||
$this->command->info('✓ Setiap fungsi bangunan memiliki parameter berbeda');
|
||||
$this->command->info('✓ Setiap lantai memiliki IP ketinggian berbeda');
|
||||
$this->command->info('✓ Hunian sederhana: IP kompleksitas khusus 0.3');
|
||||
$this->command->info('✓ Formula dapat disesuaikan per fungsi dan lantai');
|
||||
}
|
||||
}
|
||||
148
database/seeders/BuildingFunctionParameterSeeder.php
Normal file
148
database/seeders/BuildingFunctionParameterSeeder.php
Normal file
@@ -0,0 +1,148 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\BuildingFunction;
|
||||
use App\Models\BuildingFunctionParameter;
|
||||
|
||||
class BuildingFunctionParameterSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$parameters = [
|
||||
// Fungsi Keagamaan
|
||||
[
|
||||
'building_function_code' => 'AGAMA',
|
||||
'fungsi_bangunan' => 0,
|
||||
'ip_permanen' => 0,
|
||||
'ip_kompleksitas' => 0,
|
||||
'indeks_lokalitas' => 0,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk fungsi keagamaan'
|
||||
],
|
||||
|
||||
// Fungsi Sosial Budaya
|
||||
[
|
||||
'building_function_code' => 'SOSIAL_BUDAYA',
|
||||
'fungsi_bangunan' => 0.3,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.3,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk fungsi sosial budaya'
|
||||
],
|
||||
|
||||
// Fungsi Campuran Kecil
|
||||
[
|
||||
'building_function_code' => 'CAMPURAN_KECIL',
|
||||
'fungsi_bangunan' => 0.6,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.5,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk fungsi campuran kecil'
|
||||
],
|
||||
|
||||
// Fungsi Campuran Besar
|
||||
[
|
||||
'building_function_code' => 'CAMPURAN_BESAR',
|
||||
'fungsi_bangunan' => 0.8,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.5,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk fungsi campuran besar'
|
||||
],
|
||||
|
||||
// UMKM (Usaha Kecil)
|
||||
[
|
||||
'building_function_code' => 'USAHA_KECIL',
|
||||
'fungsi_bangunan' => 0.5,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.4,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk UMKM'
|
||||
],
|
||||
|
||||
// Usaha Besar (Non-Mikro)
|
||||
[
|
||||
'building_function_code' => 'USAHA_BESAR',
|
||||
'fungsi_bangunan' => 0.7,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.5,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk usaha besar (non-mikro)'
|
||||
],
|
||||
|
||||
// Hunian Sederhana < 100 m2
|
||||
[
|
||||
'building_function_code' => 'HUNIAN_KECIL',
|
||||
'fungsi_bangunan' => 0.15,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.3,
|
||||
'indeks_lokalitas' => 0.4,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk hunian sederhana < 100 m2'
|
||||
],
|
||||
|
||||
// Hunian Sederhana > 100 m2
|
||||
[
|
||||
'building_function_code' => 'HUNIAN_BESAR',
|
||||
'fungsi_bangunan' => 0.17,
|
||||
'ip_permanen' => 0.4,
|
||||
'ip_kompleksitas' => 0.6,
|
||||
'indeks_lokalitas' => 0.4,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk hunian sederhana > 100 m2'
|
||||
],
|
||||
|
||||
// MBR (Masyarakat Berpenghasilan Rendah)
|
||||
[
|
||||
'building_function_code' => 'HUNIAN_MBR',
|
||||
'fungsi_bangunan' => 0,
|
||||
'ip_permanen' => 0,
|
||||
'ip_kompleksitas' => 0,
|
||||
'indeks_lokalitas' => 0,
|
||||
'asumsi_prasarana' => 0.5,
|
||||
'is_active' => true,
|
||||
'notes' => 'Parameter untuk MBR (tarif lebih rendah)'
|
||||
]
|
||||
];
|
||||
|
||||
foreach ($parameters as $parameterData) {
|
||||
$buildingFunction = BuildingFunction::where('code', $parameterData['building_function_code'])->first();
|
||||
|
||||
if ($buildingFunction) {
|
||||
// Remove building_function_code from parameter data
|
||||
$parameterData['building_function_id'] = $buildingFunction->id;
|
||||
unset($parameterData['building_function_code']);
|
||||
|
||||
BuildingFunctionParameter::updateOrCreate(
|
||||
['building_function_id' => $buildingFunction->id],
|
||||
$parameterData
|
||||
);
|
||||
|
||||
$this->command->info("Created/Updated parameter for: {$buildingFunction->name}");
|
||||
} else {
|
||||
$this->command->warn("Building function not found: {$parameterData['building_function_code']}");
|
||||
}
|
||||
}
|
||||
|
||||
$this->command->info('Building Function Parameters seeding completed!');
|
||||
}
|
||||
}
|
||||
156
database/seeders/BuildingFunctionSeeder.php
Normal file
156
database/seeders/BuildingFunctionSeeder.php
Normal file
@@ -0,0 +1,156 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\BuildingFunction;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class BuildingFunctionSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$now = Carbon::now();
|
||||
|
||||
// 1. Building Functions Data - Fixed structure with proper parent-child relationships
|
||||
$buildingFunctions = [
|
||||
// Parent Categories
|
||||
['id' => 1, 'code' => 'AGAMA', 'name' => 'Bangunan Keagamaan', 'parent_id' => null, 'level' => 0, 'sort_order' => 1, 'base_tariff' => 0.00],
|
||||
['id' => 2, 'code' => 'SOSIAL_BUDAYA', 'name' => 'Bangunan Sosial Budaya', 'parent_id' => null, 'level' => 0, 'sort_order' => 2, 'base_tariff' => 30000.00],
|
||||
['id' => 3, 'code' => 'CAMPURAN', 'name' => 'Bangunan Campuran', 'parent_id' => null, 'level' => 0, 'sort_order' => 3, 'base_tariff' => 70000.00],
|
||||
['id' => 4, 'code' => 'USAHA', 'name' => 'Bangunan Usaha', 'parent_id' => null, 'level' => 0, 'sort_order' => 4, 'base_tariff' => 60000.00],
|
||||
['id' => 5, 'code' => 'HUNIAN', 'name' => 'Bangunan Hunian', 'parent_id' => null, 'level' => 0, 'sort_order' => 5, 'base_tariff' => 40000.00],
|
||||
|
||||
// Sub Categories - Campuran
|
||||
['id' => 6, 'code' => 'CAMPURAN_KECIL', 'name' => 'Bangunan Campuran Kecil', 'parent_id' => 3, 'level' => 1, 'sort_order' => 1, 'base_tariff' => 60000.00],
|
||||
['id' => 7, 'code' => 'CAMPURAN_BESAR', 'name' => 'Bangunan Campuran Besar', 'parent_id' => 3, 'level' => 1, 'sort_order' => 2, 'base_tariff' => 80000.00],
|
||||
|
||||
// Sub Categories - Usaha
|
||||
['id' => 8, 'code' => 'USAHA_KECIL', 'name' => 'Bangunan Usaha Kecil (UMKM)', 'parent_id' => 4, 'level' => 1, 'sort_order' => 1, 'base_tariff' => 50000.00],
|
||||
['id' => 9, 'code' => 'USAHA_BESAR', 'name' => 'Bangunan Usaha Besar', 'parent_id' => 4, 'level' => 1, 'sort_order' => 2, 'base_tariff' => 70000.00],
|
||||
|
||||
// Sub Categories - Hunian
|
||||
['id' => 10, 'code' => 'HUNIAN_SEDERHANA', 'name' => 'Hunian Sederhana', 'parent_id' => 5, 'level' => 1, 'sort_order' => 1, 'base_tariff' => 35000.00],
|
||||
['id' => 11, 'code' => 'HUNIAN_TIDAK_SEDERHANA', 'name' => 'Hunian Tidak Sederhana', 'parent_id' => 5, 'level' => 1, 'sort_order' => 2, 'base_tariff' => 45000.00],
|
||||
['id' => 12, 'code' => 'MBR', 'name' => 'Hunian MBR (Masyarakat Berpenghasilan Rendah)', 'parent_id' => 5, 'level' => 1, 'sort_order' => 3, 'base_tariff' => 0.00],
|
||||
];
|
||||
|
||||
foreach ($buildingFunctions as $function) {
|
||||
DB::table('building_functions')->updateOrInsert(
|
||||
['id' => $function['id']],
|
||||
array_merge($function, [
|
||||
'description' => 'Deskripsi untuk ' . $function['name'],
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
])
|
||||
);
|
||||
}
|
||||
|
||||
// 2. Building Function Parameters
|
||||
$parameters = [
|
||||
// AGAMA - No charge
|
||||
['building_function_id' => 1, 'fungsi_bangunan' => 0, 'ip_permanen' => 0, 'ip_kompleksitas' => 0, 'indeks_lokalitas' => 0, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// SOSIAL_BUDAYA
|
||||
['building_function_id' => 2, 'fungsi_bangunan' => 0.3, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.3, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// CAMPURAN_KECIL
|
||||
['building_function_id' => 6, 'fungsi_bangunan' => 0.6, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.5, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// CAMPURAN_BESAR
|
||||
['building_function_id' => 7, 'fungsi_bangunan' => 0.8, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.5, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// USAHA_KECIL
|
||||
['building_function_id' => 8, 'fungsi_bangunan' => 0.5, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.4, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// USAHA_BESAR
|
||||
['building_function_id' => 9, 'fungsi_bangunan' => 0.7, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.5, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// HUNIAN_SEDERHANA
|
||||
['building_function_id' => 10, 'fungsi_bangunan' => 0.15, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.3, 'indeks_lokalitas' => 0.4, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// HUNIAN_TIDAK_SEDERHANA
|
||||
['building_function_id' => 11, 'fungsi_bangunan' => 0.17, 'ip_permanen' => 0.4, 'ip_kompleksitas' => 0.6, 'indeks_lokalitas' => 0.4, 'asumsi_prasarana' => 0.5],
|
||||
|
||||
// MBR - No charge
|
||||
['building_function_id' => 12, 'fungsi_bangunan' => 0, 'ip_permanen' => 0, 'ip_kompleksitas' => 0, 'indeks_lokalitas' => 0, 'asumsi_prasarana' => 0.5],
|
||||
];
|
||||
|
||||
foreach ($parameters as $param) {
|
||||
DB::table('building_function_parameters')->updateOrInsert(
|
||||
['building_function_id' => $param['building_function_id']],
|
||||
array_merge($param, [
|
||||
'koefisien_dasar' => 1.0,
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
])
|
||||
);
|
||||
}
|
||||
|
||||
// 3. Floor Height Indices (IP Ketinggian per lantai)
|
||||
$floorHeightIndices = [
|
||||
['floor_number' => 1, 'ip_ketinggian' => 1.000000, 'description' => 'IP ketinggian untuk lantai 1'],
|
||||
['floor_number' => 2, 'ip_ketinggian' => 1.090000, 'description' => 'IP ketinggian untuk lantai 2'],
|
||||
['floor_number' => 3, 'ip_ketinggian' => 1.120000, 'description' => 'IP ketinggian untuk lantai 3'],
|
||||
['floor_number' => 4, 'ip_ketinggian' => 1.350000, 'description' => 'IP ketinggian untuk lantai 4'],
|
||||
['floor_number' => 5, 'ip_ketinggian' => 1.620000, 'description' => 'IP ketinggian untuk lantai 5'],
|
||||
['floor_number' => 6, 'ip_ketinggian' => 1.197000, 'description' => 'IP ketinggian untuk lantai 6'],
|
||||
];
|
||||
|
||||
foreach ($floorHeightIndices as $heightIndex) {
|
||||
DB::table('floor_height_indices')->updateOrInsert(
|
||||
['floor_number' => $heightIndex['floor_number']],
|
||||
array_merge($heightIndex, [
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
])
|
||||
);
|
||||
}
|
||||
|
||||
// Formula Templates removed - not used in current system
|
||||
|
||||
// 5. Retribution Formulas per Floor (for child building functions only)
|
||||
$childBuildingFunctionIds = [1, 2, 6, 7, 8, 9, 10, 11, 12]; // All leaf nodes
|
||||
$formulaExpression = '(1 * luas_bangunan * (indeks_lokalitas * 70350 * ((fungsi_bangunan * (ip_permanen + ip_kompleksitas + (0.5 * ip_ketinggian)))) * 1)) + (0.5 * (1 * luas_bangunan * (indeks_lokalitas * 70350 * ((fungsi_bangunan * (ip_permanen + ip_kompleksitas + (0.5 * ip_ketinggian)))) * 1)))';
|
||||
|
||||
foreach ($childBuildingFunctionIds as $buildingFunctionId) {
|
||||
$buildingFunction = DB::table('building_functions')->where('id', $buildingFunctionId)->first();
|
||||
|
||||
if ($buildingFunction) {
|
||||
// Create formulas for floors 1-5
|
||||
for ($floorNumber = 1; $floorNumber <= 5; $floorNumber++) {
|
||||
DB::table('retribution_formulas')->updateOrInsert(
|
||||
[
|
||||
'building_function_id' => $buildingFunctionId,
|
||||
'floor_number' => $floorNumber
|
||||
],
|
||||
[
|
||||
'name' => "{$buildingFunction->name} - Lantai {$floorNumber}",
|
||||
'formula_expression' => $formulaExpression,
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
]
|
||||
);
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
$this->command->info('Building Function data seeded successfully!');
|
||||
$this->command->info('Building Function Parameters seeded successfully!');
|
||||
$this->command->info('Floor Height Indices seeded successfully!');
|
||||
$this->command->info('Retribution Formulas with IP Ketinggian seeded successfully!');
|
||||
|
||||
// Display summary
|
||||
$this->command->info('=== SUMMARY ===');
|
||||
$this->command->info('Parent Functions: ' . DB::table('building_functions')->whereNull('parent_id')->count());
|
||||
$this->command->info('Child Functions: ' . DB::table('building_functions')->whereNotNull('parent_id')->count());
|
||||
$this->command->info('Parameters: ' . DB::table('building_function_parameters')->count());
|
||||
$this->command->info('Floor Height Indices: ' . DB::table('floor_height_indices')->count());
|
||||
$this->command->info('Retribution Formulas: ' . DB::table('retribution_formulas')->count());
|
||||
}
|
||||
}
|
||||
5
database/seeders/DatabaseSeeder.php
Executable file → Normal file
5
database/seeders/DatabaseSeeder.php
Executable file → Normal file
@@ -50,6 +50,11 @@ class DatabaseSeeder extends Seeder
|
||||
MenuSeeder::class,
|
||||
UsersRoleMenuSeeder::class,
|
||||
GlobalSettingSeeder::class,
|
||||
BuildingFunctionSeeder::class,
|
||||
BuildingFunctionParameterSeeder::class,
|
||||
FloorHeightIndexSeeder::class,
|
||||
RetributionFormulaSeeder::class,
|
||||
RetributionProposalSeeder::class,
|
||||
]);
|
||||
}
|
||||
}
|
||||
|
||||
62
database/seeders/FloorHeightIndexSeeder.php
Normal file
62
database/seeders/FloorHeightIndexSeeder.php
Normal file
@@ -0,0 +1,62 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\FloorHeightIndex;
|
||||
|
||||
class FloorHeightIndexSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$indices = [
|
||||
[
|
||||
'floor_number' => 1,
|
||||
'ip_ketinggian' => 1.000000,
|
||||
'description' => 'IP ketinggian untuk lantai 1'
|
||||
],
|
||||
[
|
||||
'floor_number' => 2,
|
||||
'ip_ketinggian' => 1.090000,
|
||||
'description' => 'IP ketinggian untuk lantai 2'
|
||||
],
|
||||
[
|
||||
'floor_number' => 3,
|
||||
'ip_ketinggian' => 1.120000,
|
||||
'description' => 'IP ketinggian untuk lantai 3'
|
||||
],
|
||||
[
|
||||
'floor_number' => 4,
|
||||
'ip_ketinggian' => 1.350000,
|
||||
'description' => 'IP ketinggian untuk lantai 4'
|
||||
],
|
||||
[
|
||||
'floor_number' => 5,
|
||||
'ip_ketinggian' => 1.620000,
|
||||
'description' => 'IP ketinggian untuk lantai 5'
|
||||
],
|
||||
[
|
||||
'floor_number' => 6,
|
||||
'ip_ketinggian' => 1.197000,
|
||||
'description' => 'IP ketinggian untuk lantai 6'
|
||||
]
|
||||
];
|
||||
|
||||
foreach ($indices as $index) {
|
||||
FloorHeightIndex::updateOrCreate(
|
||||
['floor_number' => $index['floor_number']],
|
||||
$index
|
||||
);
|
||||
}
|
||||
|
||||
$this->command->info('Floor Height Index seeding completed!');
|
||||
$this->command->info('IP Ketinggian values:');
|
||||
foreach ($indices as $index) {
|
||||
$this->command->info("Lantai {$index['floor_number']}: {$index['ip_ketinggian']}");
|
||||
}
|
||||
}
|
||||
}
|
||||
106
database/seeders/MasterFormulaSeeder.php
Normal file
106
database/seeders/MasterFormulaSeeder.php
Normal file
@@ -0,0 +1,106 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\MasterFormula;
|
||||
use App\Models\MasterParameter;
|
||||
use App\Models\FormulaParameter;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class MasterFormulaSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$now = Carbon::now();
|
||||
|
||||
// 1. Master Formulas
|
||||
$formulas = [
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_DASAR',
|
||||
'formula_name' => 'Formula Retribusi Dasar',
|
||||
'formula_expression' => '{koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_bangunan} * ({ip_permanen} + {ip_kompleksitas} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})',
|
||||
'formula_category' => 'basic',
|
||||
'description' => 'Formula dasar untuk perhitungan retribusi PBG tanpa prasarana',
|
||||
'usage_notes' => 'Menggunakan rumus: 1*D5*(N5*tarif_dasar*H5*1) dimana H5=E5*(F5+G5+(0.5*H3))'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_DENGAN_PRASARANA',
|
||||
'formula_name' => 'Formula Retribusi dengan Prasarana',
|
||||
'formula_expression' => '({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_bangunan} * ({ip_permanen} + {ip_kompleksitas} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})) + ({asumsi_prasarana} * ({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_bangunan} * ({ip_permanen} + {ip_kompleksitas} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})))',
|
||||
'formula_category' => 'complete',
|
||||
'description' => 'Formula lengkap retribusi PBG termasuk prasarana',
|
||||
'usage_notes' => 'Formula utama: (dasar) + (prasarana * dasar). Sesuai rumus Excel yang diberikan'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_BEBAS',
|
||||
'formula_name' => 'Formula Retribusi Bebas',
|
||||
'formula_expression' => '0',
|
||||
'formula_category' => 'free',
|
||||
'description' => 'Formula untuk bangunan yang bebas retribusi',
|
||||
'usage_notes' => 'Digunakan untuk bangunan keagamaan dan MBR'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_PER_LANTAI',
|
||||
'formula_name' => 'Formula Perhitungan per Lantai (H5)',
|
||||
'formula_expression' => '{fungsi_bangunan} * ({ip_permanen} + {ip_kompleksitas} + ({multiplier_ketinggian} * {ip_ketinggian}))',
|
||||
'formula_category' => 'component',
|
||||
'description' => 'Formula untuk menghitung nilai per lantai (H5 dalam Excel)',
|
||||
'usage_notes' => 'Rumus: E5*(F5+G5+(0.5*H3)) - komponen perhitungan per lantai'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_HUNIAN_SEDERHANA',
|
||||
'formula_name' => 'Formula Retribusi Hunian Sederhana',
|
||||
'formula_expression' => '({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_hunian_sederhana} * ({ip_permanen_hunian_sederhana} + {ip_kompleksitas_hunian_sederhana} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})) + ({asumsi_prasarana} * ({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_hunian_sederhana} * ({ip_permanen_hunian_sederhana} + {ip_kompleksitas_hunian_sederhana} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})))',
|
||||
'formula_category' => 'residential',
|
||||
'description' => 'Formula khusus untuk hunian sederhana dengan IP kompleksitas 0.3',
|
||||
'usage_notes' => 'Menggunakan parameter khusus hunian sederhana'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_HUNIAN_TIDAK_SEDERHANA',
|
||||
'formula_name' => 'Formula Retribusi Hunian Tidak Sederhana',
|
||||
'formula_expression' => '({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_hunian_tidak_sederhana} * ({ip_permanen_hunian_tidak_sederhana} + {ip_kompleksitas_hunian_tidak_sederhana} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})) + ({asumsi_prasarana} * ({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_hunian_tidak_sederhana} * ({ip_permanen_hunian_tidak_sederhana} + {ip_kompleksitas_hunian_tidak_sederhana} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})))',
|
||||
'formula_category' => 'residential',
|
||||
'description' => 'Formula khusus untuk hunian tidak sederhana',
|
||||
'usage_notes' => 'Menggunakan parameter khusus hunian tidak sederhana'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_SOSIAL_BUDAYA',
|
||||
'formula_name' => 'Formula Retribusi Sosial Budaya',
|
||||
'formula_expression' => '({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_sosial_budaya} * ({ip_permanen_sosial_budaya} + {ip_kompleksitas_sosial_budaya} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})) + ({asumsi_prasarana} * ({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_sosial_budaya} * ({ip_permanen_sosial_budaya} + {ip_kompleksitas_sosial_budaya} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})))',
|
||||
'formula_category' => 'social',
|
||||
'description' => 'Formula khusus untuk bangunan sosial budaya',
|
||||
'usage_notes' => 'Menggunakan parameter fungsi sosial budaya'
|
||||
],
|
||||
[
|
||||
'formula_code' => 'RETRIBUSI_USAHA',
|
||||
'formula_name' => 'Formula Retribusi Usaha',
|
||||
'formula_expression' => '({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_usaha_besar} * ({ip_permanen_usaha_besar} + {ip_kompleksitas_usaha_besar} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})) + ({asumsi_prasarana} * ({koefisien_dasar} * {luas_bangunan} * ({indeks_lokalitas} * {tarif_dasar} * ({fungsi_usaha_besar} * ({ip_permanen_usaha_besar} + {ip_kompleksitas_usaha_besar} + ({multiplier_ketinggian} * {ip_ketinggian}))) * {koefisien_dasar})))',
|
||||
'formula_category' => 'commercial',
|
||||
'description' => 'Formula khusus untuk bangunan usaha',
|
||||
'usage_notes' => 'Menggunakan parameter fungsi usaha besar'
|
||||
]
|
||||
];
|
||||
|
||||
foreach ($formulas as $formula) {
|
||||
DB::table('master_formulas')->updateOrInsert(
|
||||
['formula_code' => $formula['formula_code']],
|
||||
array_merge($formula, [
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
])
|
||||
);
|
||||
}
|
||||
|
||||
$this->command->info('Master Formulas seeded successfully!');
|
||||
$this->command->info('=== FORMULA SUMMARY ===');
|
||||
foreach ($formulas as $formula) {
|
||||
$this->command->info($formula['formula_code'] . ': ' . $formula['formula_name']);
|
||||
}
|
||||
}
|
||||
}
|
||||
387
database/seeders/MasterParameterSeeder.php
Normal file
387
database/seeders/MasterParameterSeeder.php
Normal file
@@ -0,0 +1,387 @@
|
||||
<?php
|
||||
|
||||
namespace Database\Seeders;
|
||||
|
||||
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
||||
use Illuminate\Database\Seeder;
|
||||
use App\Models\MasterParameter;
|
||||
use App\Models\BuildingFunction;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Carbon\Carbon;
|
||||
|
||||
class MasterParameterSeeder extends Seeder
|
||||
{
|
||||
/**
|
||||
* Run the database seeds.
|
||||
*/
|
||||
public function run(): void
|
||||
{
|
||||
$now = Carbon::now();
|
||||
|
||||
// 1. General Parameters (Parameter Umum)
|
||||
$generalParameters = [
|
||||
[
|
||||
'parameter_code' => 'luas_bangunan',
|
||||
'parameter_name' => 'Luas Bangunan',
|
||||
'default_value' => 0.000000,
|
||||
'unit' => 'm²',
|
||||
'description' => 'Luas total bangunan dalam meter persegi'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'tarif_dasar',
|
||||
'parameter_name' => 'Tarif Dasar',
|
||||
'default_value' => 7035000.000000,
|
||||
'unit' => 'Rupiah',
|
||||
'description' => 'Tarif dasar retribusi per meter persegi (7.035.000)'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'koefisien_dasar',
|
||||
'parameter_name' => 'Koefisien Dasar',
|
||||
'default_value' => 1.000000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Koefisien dasar perhitungan'
|
||||
]
|
||||
];
|
||||
|
||||
// 2. IP Ketinggian Parameters per Lantai (Data dari tabel)
|
||||
$floorHeightParameters = [
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_1',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 1',
|
||||
'default_value' => 1.000000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 1'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_2',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 2',
|
||||
'default_value' => 1.090000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 2'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_3',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 3',
|
||||
'default_value' => 1.120000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 3'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_4',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 4',
|
||||
'default_value' => 1.135000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 4'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_5',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 5',
|
||||
'default_value' => 1.162000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 5'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_ketinggian_6',
|
||||
'parameter_name' => 'IP Ketinggian Lantai 6',
|
||||
'default_value' => 1.197000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks ketinggian untuk lantai 6'
|
||||
]
|
||||
];
|
||||
|
||||
// 3. Building Function Specific Parameters (Data dari tabel)
|
||||
$buildingFunctionParameters = [
|
||||
// FUNGSI KEAGAMAAN - Bebas retribusi
|
||||
[
|
||||
'parameter_code' => 'fungsi_keagamaan',
|
||||
'parameter_name' => 'Fungsi Bangunan Keagamaan',
|
||||
'default_value' => 0.000000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan keagamaan (bebas retribusi)'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_keagamaan',
|
||||
'parameter_name' => 'IP Permanen Keagamaan',
|
||||
'default_value' => 0.000000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan keagamaan'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_keagamaan',
|
||||
'parameter_name' => 'IP Kompleksitas Keagamaan',
|
||||
'default_value' => 0.000000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan keagamaan'
|
||||
],
|
||||
|
||||
// FUNGSI SOSIAL BUDAYA - 0.3
|
||||
[
|
||||
'parameter_code' => 'fungsi_sosial_budaya',
|
||||
'parameter_name' => 'Fungsi Bangunan Sosial Budaya',
|
||||
'default_value' => 0.300000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan sosial budaya'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_sosial_budaya',
|
||||
'parameter_name' => 'IP Permanen Sosial Budaya',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan sosial budaya'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_sosial_budaya',
|
||||
'parameter_name' => 'IP Kompleksitas Sosial Budaya',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan sosial budaya'
|
||||
],
|
||||
|
||||
// CAMPURAN KECIL - 0.6
|
||||
[
|
||||
'parameter_code' => 'fungsi_campuran_kecil',
|
||||
'parameter_name' => 'Fungsi Bangunan Campuran Kecil',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan campuran kecil'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_campuran_kecil',
|
||||
'parameter_name' => 'IP Permanen Campuran Kecil',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan campuran kecil'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_campuran_kecil',
|
||||
'parameter_name' => 'IP Kompleksitas Campuran Kecil',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan campuran kecil'
|
||||
],
|
||||
|
||||
// CAMPURAN BESAR - 0.8
|
||||
[
|
||||
'parameter_code' => 'fungsi_campuran_besar',
|
||||
'parameter_name' => 'Fungsi Bangunan Campuran Besar',
|
||||
'default_value' => 0.800000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan campuran besar'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_campuran_besar',
|
||||
'parameter_name' => 'IP Permanen Campuran Besar',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan campuran besar'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_campuran_besar',
|
||||
'parameter_name' => 'IP Kompleksitas Campuran Besar',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan campuran besar'
|
||||
],
|
||||
|
||||
// UMKM - 0.5
|
||||
[
|
||||
'parameter_code' => 'fungsi_umkm',
|
||||
'parameter_name' => 'Fungsi Bangunan UMKM',
|
||||
'default_value' => 0.500000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan UMKM'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_umkm',
|
||||
'parameter_name' => 'IP Permanen UMKM',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan UMKM'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_umkm',
|
||||
'parameter_name' => 'IP Kompleksitas UMKM',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan UMKM'
|
||||
],
|
||||
|
||||
// USAHA BESAR - 0.7
|
||||
[
|
||||
'parameter_code' => 'fungsi_usaha_besar',
|
||||
'parameter_name' => 'Fungsi Bangunan Usaha Besar',
|
||||
'default_value' => 0.700000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi bangunan usaha besar'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_usaha_besar',
|
||||
'parameter_name' => 'IP Permanen Usaha Besar',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk bangunan usaha besar'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_usaha_besar',
|
||||
'parameter_name' => 'IP Kompleksitas Usaha Besar',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk bangunan usaha besar'
|
||||
],
|
||||
|
||||
// HUNIAN SEDERHANA - 0.15
|
||||
[
|
||||
'parameter_code' => 'fungsi_hunian_sederhana',
|
||||
'parameter_name' => 'Fungsi Hunian Sederhana',
|
||||
'default_value' => 0.150000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi hunian sederhana'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_hunian_sederhana',
|
||||
'parameter_name' => 'IP Permanen Hunian Sederhana',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk hunian sederhana'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_hunian_sederhana',
|
||||
'parameter_name' => 'IP Kompleksitas Hunian Sederhana',
|
||||
'default_value' => 0.300000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk hunian sederhana (0.3)'
|
||||
],
|
||||
|
||||
// HUNIAN TIDAK SEDERHANA - 0.17
|
||||
[
|
||||
'parameter_code' => 'fungsi_hunian_tidak_sederhana',
|
||||
'parameter_name' => 'Fungsi Hunian Tidak Sederhana',
|
||||
'default_value' => 0.170000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Parameter fungsi hunian tidak sederhana'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_permanen_hunian_tidak_sederhana',
|
||||
'parameter_name' => 'IP Permanen Hunian Tidak Sederhana',
|
||||
'default_value' => 0.400000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Permanen untuk hunian tidak sederhana'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'ip_kompleksitas_hunian_tidak_sederhana',
|
||||
'parameter_name' => 'IP Kompleksitas Hunian Tidak Sederhana',
|
||||
'default_value' => 0.600000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'IP Kompleksitas untuk hunian tidak sederhana'
|
||||
]
|
||||
];
|
||||
|
||||
// 4. Indeks Lokalitas Parameters
|
||||
$localityParameters = [
|
||||
[
|
||||
'parameter_code' => 'indeks_lokalitas_03',
|
||||
'parameter_name' => 'Indeks Lokalitas 0.3%',
|
||||
'default_value' => 0.003000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks lokalitas 0.3% (untuk bangunan tertentu)'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'indeks_lokalitas_04',
|
||||
'parameter_name' => 'Indeks Lokalitas 0.4%',
|
||||
'default_value' => 0.004000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks lokalitas 0.4% (untuk hunian sederhana dan tidak sederhana)'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'indeks_lokalitas_05',
|
||||
'parameter_name' => 'Indeks Lokalitas 0.5%',
|
||||
'default_value' => 0.005000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Indeks lokalitas 0.5% (untuk bangunan komersial)'
|
||||
]
|
||||
];
|
||||
|
||||
// 5. Multiplier Parameters
|
||||
$multiplierParameters = [
|
||||
[
|
||||
'parameter_code' => 'multiplier_prasarana',
|
||||
'parameter_name' => 'Multiplier Prasarana',
|
||||
'default_value' => 0.500000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Multiplier untuk perhitungan prasarana (50%)'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'multiplier_ketinggian',
|
||||
'parameter_name' => 'Multiplier Ketinggian',
|
||||
'default_value' => 0.500000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Multiplier untuk indeks ketinggian dalam formula (0.5)'
|
||||
]
|
||||
];
|
||||
|
||||
// 4. Additional Parameters (Parameter Tambahan)
|
||||
$additionalParameters = [
|
||||
[
|
||||
'parameter_code' => 'asumsi_prasarana',
|
||||
'parameter_name' => 'Asumsi Prasarana',
|
||||
'default_value' => 0.500000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Persentase asumsi prasarana dalam perhitungan retribusi'
|
||||
],
|
||||
[
|
||||
'parameter_code' => 'multiplier_ketinggian',
|
||||
'parameter_name' => 'Multiplier Ketinggian',
|
||||
'default_value' => 0.500000,
|
||||
'unit' => 'decimal',
|
||||
'description' => 'Multiplier untuk perhitungan ketinggian (0.5 dalam rumus Excel)'
|
||||
]
|
||||
];
|
||||
|
||||
// Combine all parameters
|
||||
$allParameters = array_merge(
|
||||
$generalParameters,
|
||||
$floorHeightParameters,
|
||||
$buildingFunctionParameters,
|
||||
$localityParameters,
|
||||
$multiplierParameters,
|
||||
$additionalParameters
|
||||
);
|
||||
|
||||
// Insert parameters
|
||||
foreach ($allParameters as $param) {
|
||||
DB::table('master_parameters')->updateOrInsert(
|
||||
['parameter_code' => $param['parameter_code']],
|
||||
array_merge($param, [
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now
|
||||
])
|
||||
);
|
||||
}
|
||||
|
||||
// Summary output
|
||||
$this->command->info('Master Parameters seeded successfully!');
|
||||
$this->command->info('=== SUMMARY ===');
|
||||
$this->command->info('General Parameters: ' . count($generalParameters));
|
||||
$this->command->info('Floor Height Parameters: ' . count($floorHeightParameters));
|
||||
$this->command->info('Building Function Parameters: ' . count($buildingFunctionParameters));
|
||||
$this->command->info('Locality Parameters: ' . count($localityParameters));
|
||||
$this->command->info('Multiplier Parameters: ' . count($multiplierParameters));
|
||||
$this->command->info('Additional Parameters: ' . count($additionalParameters));
|
||||
$this->command->info('Total Parameters: ' . count($allParameters));
|
||||
|
||||
// Display parameter mapping
|
||||
$this->command->info('=== BUILDING FUNCTION PARAMETER MAPPING ===');
|
||||
$this->command->info('KEAGAMAAN: Fungsi=0.000, IP_Permanen=0.000, IP_Kompleksitas=0.000');
|
||||
$this->command->info('SOSIAL_BUDAYA: Fungsi=0.300, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
$this->command->info('CAMPURAN_KECIL: Fungsi=0.600, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
$this->command->info('CAMPURAN_BESAR: Fungsi=0.800, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
$this->command->info('UMKM: Fungsi=0.500, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
$this->command->info('USAHA_BESAR: Fungsi=0.700, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
$this->command->info('HUNIAN_SEDERHANA: Fungsi=0.150, IP_Permanen=0.400, IP_Kompleksitas=0.300');
|
||||
$this->command->info('HUNIAN_TIDAK_SEDERHANA: Fungsi=0.170, IP_Permanen=0.400, IP_Kompleksitas=0.600');
|
||||
|
||||
$this->command->info('=== IP KETINGGIAN PER LANTAI ===');
|
||||
$this->command->info('Lantai 1: 1.000, Lantai 2: 1.090, Lantai 3: 1.120');
|
||||
$this->command->info('Lantai 4: 1.135, Lantai 5: 1.162, Lantai 6: 1.197');
|
||||
}
|
||||
}
|
||||
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user