/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
# returns a list of products in decreasing order by date created
$products = Product::select('*')->orderBy('created_at', 'desc')->paginate(5);
return view('skins/skin_b/product/index', ['products' => $products]);
# return response()->json( Product::all() );
}
public function postDetail()
{
$return['success'] = 0;
if (Input::has('id')) {
$product = Product::select('name_en', 'name_id', 'price', 'masked_price', 'promo_label_en', 'promo_label_id', 'image', 'type', 'created_at as cdate')->find(Input::get('id'));
if ($product !== null) {
$return['success'] = 1;
$data['name_en'] = $product->name_en;
$data['name_id'] = $product->name_id;
$data['price'] = $product->price;
$data['image'] = $product->image;
$data['type'] = $product->type;
$data['promo_label_en'] = $product->promo_label_en;
$data['promo_label_id'] = $product->promo_label_id;
$data['masked_price'] = $product->masked_price;
$data['created_at'] = $product->cdate;
$return['data'] = $data;
}
}
echo json_encode($return);
}
public function ajaxProduct_enable(Request $request)
{
$feedId = Input::get('feedid');
$products = Product::select(array('products.id', 'products.name', 'products.description', 'products.image'))->where('feed_id', Input::get('feedid'));
return Datatables::of($products)->addColumn('active', function ($products) {
return '<input type="checkbox" name="disable[]" value="' . $products->id . '">';
}, 0)->editColumn('image', '<img src="{!! $image !!}" height="50" width="50">')->make();
}
public function getProductsByFullText($rawQuery, $fields, $orderBy, $paginate = false, $pageSize = 25)
{
$arrTerms = $this->prepareFullTextSearchQuery($rawQuery);
$terms = implode(' ', $arrTerms);
$query = "MATCH (name, description, gtin, mpc, brand, ingredient_deck) AGAINST ('{$terms}' IN BOOLEAN MODE)";
if ($paginate) {
$products = Product::select($fields)->whereRaw($query)->orderBy($orderBy)->paginate($pageSize);
} else {
$products = Product::select($fields)->whereRaw($query)->orderBy($orderBy)->get();
}
return $products;
}
