public static function getFeaturedService() { $deals = Deal::select(array('deals.id', 'deals.title', 'deals.amount', 'deals.discount', 'images.image_path'))->leftJoin('services', 'services.id', '=', 'deals.service_id')->leftJoin('images', function ($join) { $join->on('images.ref_id', '=', 'services.id')->where('images.image_type', '=', 'service'); })->where('featured', 1)->get(); return $deals; }
public function getDataDeal() { $deals = Deal::select(array('id', 'title', 'amount', 'discount', 'featured', 'status', DB::raw('date_format(time_slot,"%m/%d/%Y") AS time_slot'))); // if ( $outletId ) // { // $services->where( 'outlet_id', $outletId ); // } return Datatables::of($deals)->edit_column('featured', '{{{ $featured == 1 ? "Yes":"No" }}}')->add_column('actions', '<a href="{{{ URL::to(\'admin/deals/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a> <a href="{{{ URL::to(\'admin/deals/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a> <a href="javascript:void(0)" id="{{{ $id }}}" class="btn btn-xs btn-success active {{{ $status==\'active\'? \'disabled\':\'\'}}}">Active</a> <a href="javascript:void(0)" id="{{{ $id }}}" class="btn btn-xs btn-primary featured {{{ $featured==1? \'disabled\':\'\'}}}">Featured</a> ')->remove_column('id')->make(); }