function getItemVipCat()
{
EClassApi::getCities();
EClassApi::getCats();
//get ID VIP CAT
if (MEMCACHE_ON) {
$category_id = CGlobal::$curCategory;
$id_vip_cat = eb_memcache::do_get("id_vip_cat:{$category_id}");
if (!$id_vip_cat || $id_vip_cat['ex_time'] < TIME_NOW) {
$id_vip_cat = $this->getIdVipCat();
eb_memcache::do_put("id_vip_cat:{$category_id}", $id_vip_cat);
}
} else {
$id_vip_cat = $this->getIdVipCat();
}
$str_item_id = '';
if (isset($id_vip_cat['id'])) {
foreach ($id_vip_cat['id'] as $val) {
$str_item_id .= $str_item_id != '' ? ",{$val}" : "{$val}";
}
}
$items = array();
if ($str_item_id != '') {
$sql = 'SELECT id, name, up_time, created_time, user_id, user_name, description, city_id, category_id, currency_id, price, original_image_url, img_server FROM item WHERE';
$where = '';
$where .= ($where != '' ? " AND " : "") . " id IN({$str_item_id})";
$where .= ($where != '' ? " AND " : "") . " (status=1 OR status = 2)";
$sql .= "{$where} ORDER BY up_time DESC";
$items = array();
$re = DB::query($sql);
if ($re) {
while ($value = mysql_fetch_assoc($re)) {
$value['price'] = EClassApi::convertCurrency($value['price'], $value['currency_id']);
$value['currency_id'] = 1;
if (isset(CGlobal::$allCategories[$value['category_id']])) {
$value['href'] = WEB_DIR . ECRewrite::formatUrl('?page=item_detail&id=' . $value['id'] . '&ebname=' . EClassApi::safe_title($value['name']) . '&nice_name=' . CGlobal::$allCategories[$value['category_id']]['nice_name']);
} else {
$value['href'] = WEB_DIR . ECRewrite::formatUrl('?page=item_detail&id=' . $value['id'] . '&ebname=' . EClassApi::safe_title($value['name']));
}
$value['item_time'] = date('h:i | d.m', $value['created_time']);
$value['price_name'] = 'Giá bán';
$value['item_type'] = 'Giao dịch bán';
$value['name'] = strip_tags(EClassApi::filter_title($value['name']));
if ($value['price'] && $value['price'] > 0) {
$value['price'] = number_format($value['price'], 0, ',', '.');
$value['currency_id'] = CGlobal::$currency[$value['currency_id']];
} else {
$value['price'] = 'Liên hệ';
$value['currency_id'] = '';
}
if ($value['original_image_url']) {
$value['original_image_url'] = EClassApi::getImageThumb($value['original_image_url'], 80, 80, 0, $value['img_server']);
} else {
$value['original_image_url'] = 'style/images/no-images-69x53.jpg';
}
$value['profile_url'] = WEB_DIR . $value['user_name'];
$value['user_name_title'] = $value['user_name'];
$value['user_name'] = strlen($value['user_name']) > 10 ? substr($value['user_name'], 0, 10) . '...' : $value['user_name'];
if (isset(CGlobal::$cities[$value['city_id']])) {
$value['city'] = CGlobal::$cities[$value['city_id']]['name'];
} else {
$value['city'] = "Toàn quốc";
}
$value['vip_cat_img'] = "style/images/item-list/item_vip.gif";
$value['can_buy'] = 0;
$items[$value['id']] = $value;
}
}
}
// $items['str_item_id'] = $str_item_id;
return $items;
}
