public function searching($term)
{
$condition = array("New" => 1, "Perfect" => 2, "Good" => 3, "Blemist" => 4);
$cond_prod_ids = array();
$product_ids = array();
$pro_ids = array();
$brand_prod_ids = array();
$cat_prod_ids = array();
$tag_prod_ids = array();
//Search by product condition
if (in_array($term, $condition)) {
$cond_prod_ids = Product::where("condition", "=", $condition[$term])->lists('products_id');
}
//Search by product attribute name
$product_values_ids = ProductsOptionsValues::where('products_options_values_name', 'LIKE', '%' . $term . '%')->lists('products_options_values_id');
if ($product_values_ids) {
$product_ids = DB::table('bn_products_attributes')->whereIn('options_values_id', $product_values_ids)->lists('products_id');
}
//Search by product name or description
$pro_ids = ProductsDescription::where('products_name', 'LIKE', '%' . $term . '%')->orWhere('products_description', 'LIKE', '%' . $term . '%')->lists('products_id');
//Search by product brand
$brand_ids = Brands::where('brand_name', 'LIKE', '%' . $term . '%')->lists('brands_id');
if ($brand_ids) {
$brand_prod_ids = Product::whereIn("brand", $brand_ids)->lists('products_id');
}
//Search product by category
$cat_ids = Categories::where('title', 'LIKE', '%' . $term . '%')->lists('categories_id');
if ($cat_ids) {
$cat_prod_ids = DB::table('bn_products_to_categories')->whereIn('categories_id', $cat_ids)->lists('products_id');
}
//Search product by tags
$tag_ids = Tags::where('title', 'LIKE', '%' . $term . '%')->lists('tags_id');
if ($tag_ids) {
$tag_prod_ids = DB::table('bn_products_to_tags')->whereIn('tags_id', $tag_ids)->lists('products_id');
}
$result_prod_ids = array_merge($product_ids, $cond_prod_ids, $pro_ids, $brand_prod_ids, $cat_prod_ids, $tag_prod_ids);
$products = Product::whereIn('products_id', $result_prod_ids)->where('products_status', '1')->paginate(15);
//->get();
if ($products) {
$products = $this->product_add_detail($products);
return $this->response(array('statusCode' => 100, 'statusDescription' => 'Success', 'products' => json_decode($products->toJson(), true)));
} else {
return $this->response(array('statusCode' => 400, 'statusDescription' => 'Not Found'));
}
}
public function destroy($id)
{
Brands::where('brands_id', '=', $id)->delete();
return $this->response(array('statusCode' => 100, 'statusDescription' => 'Success', 'message' => "Brands Deleted Successfully"));
}
