Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for ($i = 0; $i < 7; $i++) {
- $dim_nikah = Dim_Pernikahan::from('dim_pernikahan AS pnk')
- ->join('fact_kependudukan AS pdk', 'pnk.nik_suami', '=', 'pdk.nik')
- ->select('pnk.sk', 'pnk.id_nikah', 'pdk.desa', 'pnk.last_update')
- ->where('pdk.desa', '=', $this->desa[$i])
- ->orderBy('pnk.sk', 'asc')
- ->get();
- $result = $this->getSourceData($this->url[$i], 'pernikahan');
- if ($dim_nikah->isEmpty()) {
- if ($this->flag == 0) {
- Dim_Pernikahan::create([
- 'id_nikah' => 0,
- 'nik_suami' => 'Not Available',
- 'nik_istri' => 'Not Available',
- ]);
- $this->flag = 1;
- }
- $this->handle_data_pernikahan(null, $result, 'insert');
- } else {
- $dwh = array_map(function ($nikah) {
- return $nikah['id_nikah'];
- }, $dim_nikah->toArray());
- $sumber = array_map(function ($nikah) {
- return $nikah['id_pernikahan'];
- }, $result);
- $this->cdc($dim_nikah, $result, $dwh, $sumber, 'pernikahan');
- }
- }
- $this->flag = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement