public function getTodayVotessCountAttribute()
{
$order = Order::today();
if ($order == null) {
return '0';
}
return Vote::where('order_id', '=', $order->id)->where('place_id', '=', $this->id)->count();
}
public static function canVote($photo_id)
{
$canVote = true;
$oneHourAgo = date('Y-m-d H:i:s', time() - 60 * 60);
$votes = Vote::where('user_id', \Auth::user()->id)->where('photo_id', $photo_id)->where('created_at', '>', $oneHourAgo)->get();
if ($votes->count() > 0) {
$canVote = false;
}
return $canVote;
}
public function postVoteDream(Request $req)
{
$dream = $req->input('dream');
if (Vote::where('id_dream', $dream)->where('cookie', $this->userService->cookie())->count() > 0) {
return response()->json(['status' => 'ERROR', 'data' => '', 'messages' => 'Ati votat deja.']);
}
$vote = new Vote();
$vote->id_dream = $dream;
$vote->cookie = $this->userService->cookie();
$vote->save();
$dream = Dream::find($dream);
$dream->votes += 1;
$dream->save();
return response()->json(['status' => 'OK', 'data' => $dream->votes, 'messages' => 'Proiect votat.']);
}
public function count()
{
return Vote::where('order_id', '=', $this->order_id)->count();
}
public function getCountVotesAttribute()
{
return Vote::where('order_id', '=', $this->id)->get();
}
public static function myVote($me)
{
return Vote::where('user_id', '=', $me->id)->where('order_id', '=', Order::today()->id)->first();
}
public function getAllPhotos()
{
$rankings = isset($this->rankings) ? $this->rankings : \Input::get('rankings');
$friends = isset($this->friends) ? $this->friends : null;
$photo_id = \Input::get('photo_id');
$photos = $this->queryPhotos($rankings, $friends);
if ($photo_id) {
$found = false;
while (!$found) {
$photos->each(function ($photo) use(&$found, $photo_id) {
if ($photo->id == $photo_id) {
$found = true;
}
});
if (!$found) {
$isLastPage = $photos->currentPage() == $photos->lastPage();
$input = \Input::all();
$input['page'] = $isLastPage ? 1 : $photos->currentPage() + 1;
\Input::replace($input);
$photos = $this->queryPhotos($rankings, $friends);
$found = $isLastPage ? true : $found;
}
}
}
$photos->each(function ($photo) {
// get photo votes
$photo->votes_count = new \stdClass();
$photo->votes_count->aggregate = Vote::where('photo_id', $photo->id)->count();
$photo->votes_count->photo_id = $photo->id;
});
$photos = $this->formatPhotoCollection($photos);
if ($rankings) {
$p = $photos->all();
usort($p, function ($a, $b) {
if ($a['votes_count']->aggregate == $b['votes_count']->aggregate) {
return 0;
}
return $a['votes_count']->aggregate > $b['votes_count']->aggregate ? -1 : 1;
});
$photos->splice(0, $photos->count());
foreach ($p as $element) {
$photos->push($element);
}
$photos->splice(10, $photos->count() - 10);
$p = $photos;
unset($photos);
$photos['data'] = $p;
}
return $photos;
}
public function getVotes($ip = NULL, $id = NULL)
{
return $id == NULL ? Vote::all() : Vote::where('ip_address', '=', $ip)->where('id_post', '=', $id)->get();
}
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'));
}
