bantenprov /
zona
| @@ 216-262 (lines=47) @@ | ||
| 213 | 'user_id' => "required|exists:{$this->user->getTable()},id", |
|
| 214 | ]); |
|
| 215 | ||
| 216 | if ($validator->fails()) { |
|
| 217 | $error = true; |
|
| 218 | $message = $validator->errors()->first(); |
|
| 219 | } else { |
|
| 220 | $nomor_un = $request->input('nomor_un'); |
|
| 221 | $siswa = $this->siswa->where('nomor_un', $nomor_un)->with(['sekolah'])->first(); |
|
| 222 | $zona_siswa = substr($siswa->village_id, 0, 6); |
|
| 223 | $zona_sekolah = substr($siswa->sekolah->village_id, 0, 6); |
|
| 224 | $lokasi_siswa = $siswa->village_id; |
|
| 225 | $lokasi_sekolah = $siswa->sekolah->village_id; |
|
| 226 | ||
| 227 | $zona->nomor_un = $nomor_un; |
|
| 228 | $zona->sekolah_id = $siswa->sekolah->id; |
|
| 229 | $zona->zona_siswa = $zona_siswa; |
|
| 230 | $zona->zona_sekolah = $zona_sekolah; |
|
| 231 | $zona->lokasi_siswa = $lokasi_siswa; |
|
| 232 | $zona->lokasi_sekolah = $lokasi_sekolah; |
|
| 233 | $zona->nilai = $this->zona->nilai($lokasi_siswa, $lokasi_sekolah); |
|
| 234 | $zona->user_id = $request->input('user_id'); |
|
| 235 | ||
| 236 | $nilai = $this->nilai->updateOrCreate( |
|
| 237 | [ |
|
| 238 | 'nomor_un' => $zona->nomor_un, |
|
| 239 | ], |
|
| 240 | [ |
|
| 241 | 'nomor_un' => $zona->nomor_un, |
|
| 242 | 'zona' => $zona->nilai, |
|
| 243 | 'total' => null, |
|
| 244 | 'user_id' => $zona->user_id, |
|
| 245 | ] |
|
| 246 | ); |
|
| 247 | ||
| 248 | DB::beginTransaction(); |
|
| 249 | ||
| 250 | if ($zona->save() && $nilai->save()) |
|
| 251 | { |
|
| 252 | DB::commit(); |
|
| 253 | ||
| 254 | $error = false; |
|
| 255 | $message = 'Success'; |
|
| 256 | } else { |
|
| 257 | DB::rollBack(); |
|
| 258 | ||
| 259 | $error = true; |
|
| 260 | $message = 'Failed'; |
|
| 261 | } |
|
| 262 | } |
|
| 263 | ||
| 264 | $response['zona'] = $zona; |
|
| 265 | $response['error'] = $error; |
|
| @@ 366-412 (lines=47) @@ | ||
| 363 | 'user_id' => "required|exists:{$this->user->getTable()},id", |
|
| 364 | ]); |
|
| 365 | ||
| 366 | if ($validator->fails()) { |
|
| 367 | $error = true; |
|
| 368 | $message = $validator->errors()->first(); |
|
| 369 | } else { |
|
| 370 | $nomor_un = $zona->nomor_un; // $request->input('nomor_un'); |
|
| 371 | $siswa = $this->siswa->where('nomor_un', $nomor_un)->with(['sekolah'])->first(); |
|
| 372 | $zona_siswa = substr($siswa->village_id, 0, 6); |
|
| 373 | $zona_sekolah = substr($siswa->sekolah->village_id, 0, 6); |
|
| 374 | $lokasi_siswa = $siswa->village_id; |
|
| 375 | $lokasi_sekolah = $siswa->sekolah->village_id; |
|
| 376 | ||
| 377 | $zona->nomor_un = $nomor_un; |
|
| 378 | $zona->sekolah_id = $siswa->sekolah->id; |
|
| 379 | $zona->zona_siswa = $zona_siswa; |
|
| 380 | $zona->zona_sekolah = $zona_sekolah; |
|
| 381 | $zona->lokasi_siswa = $lokasi_siswa; |
|
| 382 | $zona->lokasi_sekolah = $lokasi_sekolah; |
|
| 383 | $zona->nilai = $this->zona->nilai($lokasi_siswa, $lokasi_sekolah); |
|
| 384 | $zona->user_id = $request->input('user_id'); |
|
| 385 | ||
| 386 | $nilai = $this->nilai->updateOrCreate( |
|
| 387 | [ |
|
| 388 | 'nomor_un' => $zona->nomor_un, |
|
| 389 | ], |
|
| 390 | [ |
|
| 391 | 'nomor_un' => $zona->nomor_un, |
|
| 392 | 'zona' => $zona->nilai, |
|
| 393 | 'total' => null, |
|
| 394 | 'user_id' => $zona->user_id, |
|
| 395 | ] |
|
| 396 | ); |
|
| 397 | ||
| 398 | DB::beginTransaction(); |
|
| 399 | ||
| 400 | if ($zona->save() && $nilai->save()) |
|
| 401 | { |
|
| 402 | DB::commit(); |
|
| 403 | ||
| 404 | $error = false; |
|
| 405 | $message = 'Success'; |
|
| 406 | } else { |
|
| 407 | DB::rollBack(); |
|
| 408 | ||
| 409 | $error = true; |
|
| 410 | $message = 'Failed'; |
|
| 411 | } |
|
| 412 | } |
|
| 413 | ||
| 414 | $response['zona'] = $zona; |
|
| 415 | $response['error'] = $error; |
|
