public function buildShopsListQuery()
{
$this->qry = ShopDetails::Select('shop_name', 'shop_details.url_slug', 'shop_details.id', 'shop_city', 'shop_state', 'shop_country', 'users.first_name', 'users.last_name', 'shop_details.user_id', 'users_shop_details.total_products')->join('users', function ($join) {
$join->on('users.id', '=', 'shop_details.user_id');
});
$this->qry->join('users_shop_details', function ($join2) {
$join2->on('users_shop_details.user_id', '=', 'shop_details.user_id');
});
if ($this->getSrchVal("owner_name") != "") {
$name_arr = explode(" ", $this->getSrchVal('owner_name'));
if (count($name_arr) > 0) {
foreach ($name_arr as $names) {
$this->qry->whereRaw("( users.first_name LIKE '%" . addslashes($names) . "%' OR users.last_name LIKE '%" . addslashes($names) . "%')");
}
}
}
if ($this->getSrchVal("shop_name") != "") {
$shop_name = $this->getSrchVal("shop_name");
//Input::get("shop_name"); //edited by mohamed_158at11
$s_name_arr = explode(" ", $shop_name);
if (count($s_name_arr) > 0) {
foreach ($s_name_arr as $names) {
$this->qry->WhereRaw("(shop_name LIKE '%" . addslashes($names) . "%')");
}
}
}
//$this->qry->Where('users.shop_status', 1);
//$this->qry->Where('users.is_shop_owner', 'Yes');
$this->qry->groupBy('shop_details.id');
$this->qry->orderBy('users_shop_details.total_products', 'DESC');
return $this->qry;
}
public function updateShopFeaturedByAdmin($shop_id, $action)
{
$shop = ShopDetails::where("id", $shop_id)->first();
if ($shop) {
if (strtolower($action) == 'setfeatured') {
ShopDetails::where("id", $shop_id)->update(array('is_featured_shop' => 'Yes'));
$success_msg = trans('webshoppack::admin/manageShops.shoplist_set_featured_suc_msg');
} else {
ShopDetails::where("id", $shop_id)->update(array('is_featured_shop' => 'No'));
$success_msg = trans('webshoppack::admin/manageShops.shoplist_remove_featured_suc_msg');
}
}
return $success_msg;
}
public function getProductShopURL($id, $shop_details = array())
{
$url_slug = '';
if (isset($shop_details['url_slug'])) {
$url_slug = $shop_details['url_slug'];
} else {
$s_details = ShopDetails::where('id', $id)->first(array('url_slug'));
if (count($s_details) > 0) {
$url_slug = $s_details['url_slug'];
}
}
if ($url_slug != '') {
$view_url = \URL::to(\Config::get('webshoppack::shop_uri') . '/' . $url_slug);
return $view_url;
}
return '';
}
