{
$query = 'SELECT count(*) cantidad FROM `' . DB_INSTAGRAM_PREFIX . 'record` WHERE `date` = date_format(NOW(), \'%Y-%m-%d\');';
$que = db_query($query, array());
if ($fila = mysql_fetch_assoc($que)) {
return $fila['cantidad'];
}
}
$total_country = get_total_items('country');
$total_age = get_total_items('age');
$total_language = get_total_items('language');
$total_generation = get_total_items('generation');
$total_relationship = get_total_items('relationship');
$total_comportamiento = get_total_items('comportamiento');
$total_interest = get_total_items('interest');
$total_region = get_total_items('region');
$total_city = get_total_items('city');
?>
<!DOCTYPE html>
<html lang="es">
<head>
<title>Owloo</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<meta name="viewport" content="width=100%; initial-scale=1; maximum-scale=1; minimum-scale=1; user-scalable=no;">
<style>
body, html{
font-family: Arial;
}
td, th {
padding: 5px;
vertical-align: middle;
border-left: 1px solid #ddd;
//$smarty->assign('ads_num',$ads_num);
$smarty->assign('provinces_list', get_regions(1, 1));
//获取省份列表
$smarty->assign('root_path', ROOT_PATH);
assign_template();
$smarty->display('special_product.dwt');
} elseif ($act == 'province_special') {
//echo $act;
$province_id = isset($_REQUEST['province_id']) ? intval($_REQUEST['province_id']) : 0;
$current_pages = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
if ($province_id) {
$result = array();
$sql_province_name = "SELECT region_name FROM " . $GLOBALS['ecs']->table('region') . " WHERE region_type=1 AND region_id={$province_id} ";
$province_name = $GLOBALS['db']->getOne($sql_province_name);
$result['province'] = array('province_id' => $province_id, 'province_name' => $province_name);
$total_items = get_total_items($province_id);
//获取用户所在省份的特产商品总数
$page_str = $total_items > $page_items ? get_page_str($province_id, $total_items, $page_items, $current_pages) : '';
$result['page_str'] = $page_str;
//获取分页列表
$begin_item = ($current_pages - 1) * $page_items;
$condition = array();
//获取特产商品的条件
$condition = array('province_id' => $province_id, 'begin_item' => $begin_item, 'end_item' => $page_items);
$result['special_goods'] = get_special_goods($condition);
//获取特产商品列表
//$result[''] = get_special_goods($province_id);
//dump($result);
echo $json->encode($result);
} else {
echo "<script>alert('你所所选择的省份不存在！')</script>";
