public static function boot() { parent::boot(); static::creating(function ($model) { if ($model->carsubmodelid == 0) { CommissionFinaceCar::where('commissionfinaceid', $model->commissionfinaceid)->where('carmodelid', $model->carmodelid)->delete(); } $model->createdby = Auth::user()->id; $model->createddate = date("Y-m-d H:i:s"); $model->modifiedby = Auth::user()->id; $model->modifieddate = date("Y-m-d H:i:s"); }); static::created(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Add', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); }); static::updating(function ($model) { if ($model->carsubmodelid == 0) { CommissionFinaceCar::where('id', '!=', $model->id)->where('commissionfinaceid', $model->commissionfinaceid)->where('carmodelid', $model->carmodelid)->delete(); } $model->modifiedby = Auth::user()->id; $model->modifieddate = date("Y-m-d H:i:s"); }); static::updated(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Update', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); }); static::deleted(function ($model) { Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Delete', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]); }); }
public function check_dup_carsubmodel(Request $request) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $input = $request->only('id', 'commissionfinaceid', 'carmodelid', 'carsubmodelid'); $model = CommissionFinaceCar::where('id', '!=', $input['id'])->where('commissionfinaceid', $input['commissionfinaceid'])->where('carmodelid', $input['carmodelid'])->where('carsubmodelid', 0)->first(); if ($model != null) { return "แบบรถนี้ ทุกรุ่น มีอยู่ในระบบแล้ว"; } if ($input['carsubmodelid'] != 0) { $model = CommissionFinaceCar::where('id', '!=', $input['id'])->where('commissionfinaceid', $input['commissionfinaceid'])->where('carmodelid', $input['carmodelid'])->where('carsubmodelid', $input['carsubmodelid'])->first(); if ($model != null) { return "แบบรถนี้ รุ่น " + $model->carsubmodel->name + " มีอยู่ในระบบแล้ว"; } } }