bantenprov /
wilayah-indonesia
| @@ 127-152 (lines=26) @@ | ||
| 124 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 125 | ) |
|
| 126 | ->paginate($page); |
|
| 127 | }elseif($provinsi == 'desa'){ |
|
| 128 | $data = $this->provinsi |
|
| 129 | ->select( |
|
| 130 | 'indonesia_provinces.id as province_id', |
|
| 131 | 'indonesia_provinces.name as province_name', |
|
| 132 | 'indonesia_cities.id as city_id', |
|
| 133 | 'indonesia_cities.name as city_name', |
|
| 134 | 'indonesia_districts.id as district_id', |
|
| 135 | 'indonesia_districts.name as district_name', |
|
| 136 | 'indonesia_villages.id as village_id', |
|
| 137 | 'indonesia_villages.name as village_name' |
|
| 138 | ) |
|
| 139 | ->join( |
|
| 140 | 'indonesia_cities', |
|
| 141 | 'indonesia_provinces.id','=','indonesia_cities.province_id' |
|
| 142 | ) |
|
| 143 | ->join( |
|
| 144 | 'indonesia_districts', |
|
| 145 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 146 | ) |
|
| 147 | ->join( |
|
| 148 | 'indonesia_villages', |
|
| 149 | 'indonesia_districts.id','=','indonesia_villages.district_id' |
|
| 150 | ) |
|
| 151 | ->paginate($page); |
|
| 152 | }else{ |
|
| 153 | $string = array('%20','+','-'); |
|
| 154 | foreach($string as $val){ |
|
| 155 | $provinsi = strtoupper(str_replace($val,' ',$provinsi)); |
|
| @@ 294-319 (lines=26) @@ | ||
| 291 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 292 | ) |
|
| 293 | ->paginate($page); |
|
| 294 | }elseif($provinsi == 'desa'){ |
|
| 295 | $data = $this->provinsi |
|
| 296 | ->select( |
|
| 297 | 'indonesia_provinces.id as province_id', |
|
| 298 | 'indonesia_provinces.name as province_name', |
|
| 299 | 'indonesia_cities.id as city_id', |
|
| 300 | 'indonesia_cities.name as city_name', |
|
| 301 | 'indonesia_districts.id as district_id', |
|
| 302 | 'indonesia_districts.name as district_name', |
|
| 303 | 'indonesia_villages.id as village_id', |
|
| 304 | 'indonesia_villages.name as village_name' |
|
| 305 | ) |
|
| 306 | ->join( |
|
| 307 | 'indonesia_cities', |
|
| 308 | 'indonesia_provinces.id','=','indonesia_cities.province_id' |
|
| 309 | ) |
|
| 310 | ->join( |
|
| 311 | 'indonesia_districts', |
|
| 312 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 313 | ) |
|
| 314 | ->join( |
|
| 315 | 'indonesia_villages', |
|
| 316 | 'indonesia_districts.id','=','indonesia_villages.district_id' |
|
| 317 | ) |
|
| 318 | ->paginate($page); |
|
| 319 | }else{ |
|
| 320 | $string = array('%20','+','-'); |
|
| 321 | foreach($string as $val){ |
|
| 322 | $provinsi = strtoupper(str_replace($val,' ',$provinsi)); |
|
| @@ 472-497 (lines=26) @@ | ||
| 469 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 470 | ) |
|
| 471 | ->paginate($page); |
|
| 472 | }elseif($provinsi == 'desa'){ |
|
| 473 | $data = $this->provinsi |
|
| 474 | ->select( |
|
| 475 | 'indonesia_provinces.id as province_id', |
|
| 476 | 'indonesia_provinces.name as province_name', |
|
| 477 | 'indonesia_cities.id as city_id', |
|
| 478 | 'indonesia_cities.name as city_name', |
|
| 479 | 'indonesia_districts.id as district_id', |
|
| 480 | 'indonesia_districts.name as district_name', |
|
| 481 | 'indonesia_villages.id as village_id', |
|
| 482 | 'indonesia_villages.name as village_name' |
|
| 483 | ) |
|
| 484 | ->join( |
|
| 485 | 'indonesia_cities', |
|
| 486 | 'indonesia_provinces.id','=','indonesia_cities.province_id' |
|
| 487 | ) |
|
| 488 | ->join( |
|
| 489 | 'indonesia_districts', |
|
| 490 | 'indonesia_cities.id','=','indonesia_districts.city_id' |
|
| 491 | ) |
|
| 492 | ->join( |
|
| 493 | 'indonesia_villages', |
|
| 494 | 'indonesia_districts.id','=','indonesia_villages.district_id' |
|
| 495 | ) |
|
| 496 | ->paginate($page); |
|
| 497 | }else{ |
|
| 498 | $string = array('%20','+','-'); |
|
| 499 | foreach($string as $val){ |
|
| 500 | $provinsi = strtoupper(str_replace($val,' ',$provinsi)); |
|
