/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($xe_id)
{
$data = Cars::where('xe_id', $xe_id)->get()->first();
$brands = Brand::all();
$taixedaxepxe = Cars::select('tai_xe_id')->get();
foreach ($taixedaxepxe as $key => $taixe) {
if ($taixe->tai_xe_id != null) {
$taixearray[$key] = $taixe->tai_xe_id;
}
}
$taixehientai = TaiXe::where('taixe_id', $data->tai_xe_id)->get()->first();
//dd($taixearray);
$taixe = TaiXe::whereNotIN('taixe_id', $taixearray)->get();
//dd($taixe);
return view('backend.cars.suaxe', compact('data', 'taixehientai', 'taixe', 'brands'));
}
public function getChiTiet($id)
{
$brands = $this->brands;
$socho = $this->sochoxe;
$tintucs = $this->tintucs;
$binhluans = Comment::where('xe_id', $id)->orderBy('id', 'desc')->paginate(3);
foreach ($binhluans as $key => $value) {
if ($value->nguoidung_id != NULL) {
$user = User::where('nguoidung_id', $value->nguoidung_id)->get()->first();
$value->nguoidung_id = $user->tendaydu;
}
}
//dd($binhluans);
// xe hiện tại
$xe = Cars::where('xe_id', $id)->get()->first();
// tên lái xe theo xe
$tenlaixe = TaiXe::where('taixe_id', $xe->tai_xe_id)->get()->first();
$xekhac = Cars::whereNotIn('xe_id', [$id])->where(function ($query) use($xe) {
$query->where('socho_xe', $xe->socho_xe)->orWhere('hang_id', $xe->hang_id);
})->get();
//dd($xekhac);
//dd($xe); die();
$vote_id = Vote::where('cars_id', $id)->get()->first();
if ($vote_id->sovotes != 0) {
$roundVote = round($vote_id->tongdiem / $vote_id->sovotes, 1);
} else {
$roundVote = 0;
}
//dd($vote_id);
return view('frontend.pages.chitiet', compact('vote_id', 'binhluans', 'xe', 'socho', 'brands', 'tintucs', 'tenlaixe', 'xekhac', 'roundVote'));
}
public function xoataixe($id)
{
$tai = TaiXe::findOrFail($id);
$tai->delete();
return redirect()->route('dstaixe');
}
