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();
}
