/**
* 获取店铺店铺街中的店铺
*/
function get_all_supplier()
{
global $tpl;
$is_search = 0;
//是否是搜索过来的
$filter['id'] = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
$filter['keywords'] = isset($_REQUEST['keywords']) ? trim(addslashes(htmlspecialchars($_REQUEST['keywords']))) : '';
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'sort_order' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'ASC' : trim($_REQUEST['sort_order']);
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 13;
}
$filter['start'] = ($filter['page'] - 1) * $filter['page_size'];
$where = " where status=1 and is_show=1 ";
if ($filter['id']) {
$where .= ' and supplier_type=' . $filter['id'];
}
if ($filter['keywords'] && $filter['keywords'] != '请输入关键词') {
$is_search = 1;
$tpl = 'search_store.dwt';
$GLOBALS['smarty']->assign('search_keywords', stripslashes(htmlspecialchars_decode($_REQUEST['keywords'])));
$where .= " and supplier_id in(SELECT DISTINCT supplier_id\n\t\t\t\tFROM " . $GLOBALS['ecs']->table('supplier_shop_config') . " AS ssc\n\t\t\t\tWHERE (\n\t\t\t\tcode = 'shop_name'\n\t\t\t\tAND value LIKE '%" . $filter['keywords'] . "%'\n\t\t\t\t)\n\t\t\t\tOR (\n\t\t\t\tcode = 'shop_keywords'\n\t\t\t\tAND value LIKE '%" . $filter['keywords'] . "%'\n\t\t\t\t))";
}
$GLOBALS['smarty']->assign('issearch', $is_search);
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('supplier_street') . " {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table('supplier_street') . " {$where}" . " ORDER BY {$filter['sort_by']} {$filter['sort_order']} " . " LIMIT " . $filter['start'] . ",{$filter['page_size']}";
$arr = $GLOBALS['db']->getAll($sql);
foreach ($arr as $key => $val) {
$arr[$key]['address'] = "";
//地址
$shopinfo = $GLOBALS['db']->getAll("select code,value from " . $GLOBALS['ecs']->table('supplier_shop_config') . " where supplier_id=" . $val['supplier_id'] . " and code in('shop_closed','shop_name','shop_keywords','shop_province','shop_city','shop_address','qq','ww')");
foreach ($shopinfo as $k => $v) {
if ($is_search) {
$v['value'] = str_replace($filter['keywords'], "<font color=red>" . $filter['keywords'] . "</font>", $v['value']);
}
$arr[$key][$v['code']] = $v['value'];
}
//所在地
if (!empty($arr[$key]['shop_address'])) {
$arr[$key]['address'] = ',' . $arr[$key]['shop_address'];
}
if (!empty($arr[$key]['shop_city'])) {
$arr[$key]['address'] = ',' . get_region_info($arr[$key]['shop_city']) . $arr[$key]['address'];
}
if (!empty($arr[$key]['shop_province'])) {
$arr[$key]['address'] = get_region_info($arr[$key]['shop_province']) . $arr[$key]['address'];
}
$arr[$key]['address'] = trim($arr[$key]['address'], ',');
//店铺中有多少商品
$goodsInfo = get_street_goods_info($val['supplier_id']);
$arr[$key]['goods_number'] = $goodsInfo['num'];
$arr[$key]['goods_info'] = $goodsInfo['info'];
}
return array('shops' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
/**
* 获取品牌品牌街中的品牌
*/
function get_all_supplier()
{
global $tpl;
$is_search = 0;
//是否是搜索过来的
$filter['id'] = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
$filter['keywords'] = isset($_REQUEST['keywords']) ? trim(addslashes(htmlspecialchars($_REQUEST['keywords']))) : '';
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'sort_order' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'ASC' : trim($_REQUEST['sort_order']);
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 13;
}
$filter['start'] = ($filter['page'] - 1) * $filter['page_size'];
$where = " where is_show=1 ";
if ($filter['id']) {
$where .= ' and brand_cat=' . $filter['id'];
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('brand') . " {$where}";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
$sql = "SELECT * " . " FROM " . $GLOBALS['ecs']->table('brand') . " {$where}" . " ORDER BY rand() " . " LIMIT " . $filter['start'] . ",{$filter['page_size']}";
$arr = $GLOBALS['db']->getAll($sql);
foreach ($arr as $key => $val) {
$arr[$key]['address'] = "";
//地址
//所在地
$arr[$key]['brand_name'] = trim($arr[$key]['brand_name'], ',');
//品牌中有多少商品
$goodsInfo = get_street_goods_info($val['brand_id'], $val['rand_date'], $val['rand_ids']);
$arr[$key]['goods_number'] = $goodsInfo['num'];
$arr[$key]['goods_info'] = $goodsInfo['info'];
}
return array('shops' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}
