private function _get_user_coupons($ids)
{
global $ids_check;
$ids_check = $ids;
$coupons = Coupon::leftJoin("clients", "coupons.client_id", "=", "clients.id")->where("clients.user_id", "=", Auth::user()->id)->get("coupons.id");
$user_coupons = array_map(function ($object) {
global $ids_check;
return in_array($object->id, $ids_check) ? $object->id : false;
}, $coupons);
return $user_coupons;
}
/**
* coupon function.
*
* @access public
* @param int $limit (default: 10)
* @description Devuelve los datos de un cupon
* @return void
*/
public function getCoupon($id = 0)
{
$coupon = Coupon::leftJoin('categories', 'coupons.category_id', '=', 'categories.id')->leftJoin('coupons_premium', 'coupons_premium.coupon_id', '=', 'coupons.id')->where('coupons.id', '=', $id)->get(array('coupons.id', 'coupons.title', 'categories.name as category', 'coupons.description', 'coupons.restriction', 'coupons.latitude', 'coupons.longitude', DB::raw('IF(coupons_premium.coupon_id, 1, 0) AS premium')))->toArray();
if (count($coupon) == 0) {
return Response::json(array());
}
$coupon = $coupon[0];
$coupon['ratings'] = (double) Rating::where("coupon_id", "=", $coupon['id'])->avg('value');
$coupon['redems'] = (double) Scan::where("coupon_id", "=", $coupon['id'])->count();
$coupon['comments'] = (double) Comment::where("coupon_id", "=", $coupon['id'])->where("disabled", "=", 0)->count();
return Response::json($coupon);
}
