public function index()
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
if (Auth::user()->isadmin) {
$redlabels = RedLabel::get(['id', 'no']);
} else {
$redlabels = RedLabel::where('provinceid', Auth::user()->provinceid)->get(['id', 'no']);
}
$redlabelselectlist = array();
foreach ($redlabels as $item) {
array_push($redlabelselectlist, $item->id . ':' . $item->no);
}
if (Auth::user()->isadmin) {
$carpayments = CarPayment::whereHas('carpreemption', function ($q) {
$q->whereHas('redlabelhistories', function ($q2) {
$q2->whereNotNull('returndate');
});
})->with('carpreemption.buyerCustomer', 'car')->get();
} else {
$carpayments = CarPayment::where('provinceid', Auth::user()->provinceid)->whereHas('carpreemption', function ($q) {
$q->whereHas('redlabelhistories', function ($q2) {
$q2->whereNotNull('returndate');
});
})->with('carpreemption.buyerCustomer', 'car')->get();
}
$carselectlist = array();
$customerselectlist = array();
$cashpledgeselectlist = array();
foreach ($carpayments as $item) {
array_push($carselectlist, $item->carpreemption->id . ':' . $item->car->engineno . '/' . $item->car->chassisno);
array_push($customerselectlist, $item->carpreemption->id . ':' . $item->carpreemption->buyerCustomer->title . $item->carpreemption->buyerCustomer->firstname . ' ' . $item->carpreemption->buyerCustomer->lastname);
array_push($cashpledgeselectlist, $item->carpreemption->id . ':' . $item->carpreemption->cashpledgeredlabel);
}
return view('returncashpledgeredlabel', ['redlabelselectlist' => implode(";", $redlabelselectlist), 'carselectlist' => implode(";", $carselectlist), 'customerselectlist' => implode(";", $customerselectlist), 'cashpledgeselectlist' => implode(";", $cashpledgeselectlist)]);
}
public static function boot()
{
parent::boot();
static::creating(function ($model) {
$model->issuedate = date('Y-m-d', strtotime($model->issuedate));
$model->returndate = null;
$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) {
$carpreemption = CarPreemption::find($model->carpreemptionid);
$redlabel = RedLabel::find($model->redlabelid);
$redlabel->customerid = $carpreemption->buyercustomerid;
$redlabel->deposit = $carpreemption->cashpledgeredlabel;
$redlabel->save();
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) {
$model->issuedate = date('Y-m-d', strtotime($model->issuedate));
if ($model->returndate != null && $model->returndate != '') {
$model->returndate = date('Y-m-d', strtotime($model->returndate));
} else {
$model->returndate = null;
}
$model->modifiedby = Auth::user()->id;
$model->modifieddate = date("Y-m-d H:i:s");
});
static::updated(function ($model) {
$maxid = Redlabelhistory::where('redlabelid', $model->redlabelid)->max('id');
if ($model->returndate != null && $model->returndate != '') {
if ($model->id == $maxid) {
$redlabel = RedLabel::find($model->redlabelid);
$redlabel->customerid = null;
$redlabel->carid = null;
$redlabel->deposit = null;
$redlabel->save();
}
} else {
if ($model->id == $maxid) {
$carpreemption = CarPreemption::find($model->carpreemptionid);
$redlabel = RedLabel::find($model->redlabelid);
$redlabel->customerid = $carpreemption->buyercustomerid;
$redlabel->deposit = $carpreemption->cashpledgeredlabel;
$redlabel->save();
}
}
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()]);
$maxid = Redlabelhistory::where('redlabelid', $model->redlabelid)->max('id');
if ($maxid == null || $maxid == '' || $model->id > $maxid) {
$redlabel = RedLabel::find($model->redlabelid);
$redlabel->customerid = null;
$redlabel->carid = null;
$redlabel->deposit = null;
$redlabel->save();
}
});
}
