function draw()
{
global $display;
$arrVar = array();
$this->beginForm(1);
$options = "";
EClassApi::getCats();
$where = '';
$group_id = Url::get('group_id', '');
$group_name = Url::get('group_name', '');
if ($group_id) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " id = '{$group_id}' ";
$arrVar['group_id'] = $group_id;
}
if ($group_name) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " name = '{$group_name}' ";
$arrVar['group_name'] = $group_name;
}
$item_per_page = 50;
$limit = '';
$sql_count = "SELECT COUNT(*) AS total FROM products_extra_fields_group {$where}";
$total = DB::fetch($sql_count, 'total', 0);
if ($total) {
require_once ROOT_PATH . 'core/ECPagging.php';
$paging = ECPagging::pagingSE($limit, $total, $item_per_page, 10, 'page_no', true, 'Nhóm trường', 'Trang');
$re = DB::query("SELECT * FROM products_extra_fields_group {$where} order by id desc {$limit}");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$products_extra_fields_group[$row['id']] = $row;
}
}
}
$categories = eb_memcache::do_get('categories_new');
if (!is_array($categories)) {
//if($total){
require_once ROOT_PATH . 'core/ECPagging.php';
$re = DB::query("SELECT * FROM products_category order by orders");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$categories[$row['parent_id']][$row['id']] = $row;
}
}
eb_memcache::do_put('categories_new', $categories);
}
print_category($categories, 0, $options);
//}
$arrVar['options'] = $options;
$arrVar['zones'] = CGlobal::$allZones;
$arrVar['paging'] = $paging;
$arrVar['products_extra_fields_group'] = $products_extra_fields_group;
$display->templateAdvance = TRUE;
$display->setTemplate('ManageFilterAdd', $arrVar);
$this->endForm();
}
function draw()
{
global $display;
$arrVar = array();
$this->beginForm(0);
EClassApi::getCats();
$categories = eb_memcache::do_get('categories_new');
if (!is_array($categories)) {
//if($total){
require_once ROOT_PATH . 'core/ECPagging.php';
$re = DB::query("SELECT * FROM products_category order by orders");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$categories[$row['parent_id']][$row['id']] = $row;
}
}
eb_memcache::do_put('categories_new', $categories);
}
$arrVar['zones'] = CGlobal::$allZones;
$display->templateAdvance = TRUE;
$display->setTemplate('ManageFilterSync', $arrVar);
$this->endForm();
}
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;
}
function build_rss()
{
$arr_cat = array(293);
// dinh nghia mang cho cac danh muc co so luong tin nhieu
$limit = 100;
// mac dinh ban dau
$limits = 200;
// so luong ban ghi cho danh muc co nhieu tin
$category_name = EClassApi::getParam('ebname');
$category_id = EClassApi::getParam('cat_id');
EClassApi::getCats();
if ($category_name != "" && $category_id == "") {
foreach (CGlobal::$allCategories as $cat) {
if ($cat['parent_id'] == 0 && EClassApi::safe_title($cat['name']) == $category_name) {
$category = $cat;
break;
}
}
header("Location:" . WEB_ROOT . "rss/c" . $category['id'] . "_" . $category_name . ".rss");
}
foreach (CGlobal::$allCategories as $cat) {
if ($cat['parent_id'] == 0 && $cat['id'] == $category_id) {
$category = $cat;
break;
}
}
if ($category) {
$cat_id = $category['id'];
$cat_name = trim(XMLLib::_xml_encode_attribute($category['name']));
$subDir = 'rss1';
$cachefile = 'rss1_' . $cat_id;
header("content-type: text/xml");
if (StaticCache::notExistCache($cachefile, 3600, false, $subDir)) {
if (in_array($cat_id, $arr_cat)) {
$limit = $limits;
}
StaticCache::startCache();
$rss = $this->build_rss_cat($cat_id, $cat_name, $limit);
echo $rss;
StaticCache::endCache();
}
//echo 'a';
} else {
REWRITE_ON ? header("Location:" . WEB_ROOT . "rss/") : header("Location:" . WEB_ROOT . "?page=rss");
}
System::halt();
}
function draw()
{
global $display;
$arrVar = array();
$this->beginForm();
EClassApi::getCats();
$where = '';
$filter_id = Url::get('filter_id', '');
$filter_name = Url::get('filter_name', '');
$cat_product_id = Url::get('cat_product_id', '');
$zone_id = Url::get('zone_id', '');
$arrVar['zone_id'] = $zone_id;
$arrVar['cat_product_id'] = $cat_product_id;
if ($filter_id) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " id = '{$filter_id}' ";
$arrVar['filter_id'] = $filter_id;
}
if ($filter_name) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " filter_name = '{$filter_name}' ";
$arrVar['filter_name'] = $filter_name;
}
if ($cat_product_id) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " cat_product_id = '{$cat_product_id}' ";
} else {
if ($zone_id) {
$where .= ($where != '' ? ' AND ' : 'WHERE ') . " zone_id = '{$zone_id}' ";
}
}
$item_per_page = 50;
$limit = '';
$item_vips = array();
$sql_count = "SELECT COUNT(*) AS total FROM products_filter {$where} ";
$total = DB::fetch($sql_count, 'total', 0);
$paging = '';
$filters = array();
if ($total) {
require_once ROOT_PATH . 'core/ECPagging.php';
$paging = ECPagging::pagingSE($limit, $total, $item_per_page, 20, 'page_no', true);
$re = DB::query("SELECT * FROM products_filter {$where} order by orders {$limit}");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$filters[$row['id']] = $row;
}
}
}
$categories = eb_memcache::do_get('categories_new');
if (!is_array($categories)) {
//if($total){
require_once ROOT_PATH . 'core/ECPagging.php';
$re = DB::query("SELECT * FROM products_category order by orders");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$categories[$row['parent_id']][$row['id']] = $row;
}
}
eb_memcache::do_put('categories_new', $categories);
}
print_category($categories, 0, $options, $zone_id, $cat_product_id);
$arrVar['options'] = $options;
$arrVar['zones'] = CGlobal::$allZones;
$arrVar['filters'] = $filters;
$arrVar['paging'] = $paging;
$display->templateAdvance = TRUE;
$display->setTemplate('ManageFilter', $arrVar);
$this->endForm();
}
function fn_del_tag_search()
{
if (!User::have_permit(ADMIN_TAG_SEARCH)) {
echo "no_perm";
exit;
}
EClassApi::getCats();
$id = (int) Url::get('id', 0);
$cat_id = (int) Url::get('cat_id', 0);
$cat_parent_id = CGlobal::$allCategories[$cat_id]["parent_id"];
if ($id > 0) {
require_once 'modules/ItemDetail/forms/ItemDetail.php';
$id_del = DB::query("DELETE FROM tag_search WHERE id=" . $id);
if ($id_del) {
ItemDetailForm::get_tag_search($cat_id, $cat_parent_id, 1, 0);
echo $id;
exit;
}
}
}
function draw()
{
global $display;
$arrVar = array();
$this->beginForm(1);
$arrVar['id'] = Url::get('id', 0);
$options = "";
if ($arrVar['id'] == 0) {
Url::redirect_current();
}
EClassApi::getCats();
$where = '';
$filter = DB::fetch_all_array("select * from products_filter where id={$arrVar['id']}");
$filte_value = json_decode($filter[0]['filter_value']);
$arrVar['filter'] = $filter[0];
$arrVar['filter_value'] = $filte_value;
$item_per_page = 50;
$limit = '';
$sql_count = "SELECT COUNT(*) AS total FROM products_extra_fields_group {$where}";
$total = DB::fetch($sql_count, 'total', 0);
if ($total) {
require_once ROOT_PATH . 'core/ECPagging.php';
$paging = ECPagging::pagingSE($limit, $total, $item_per_page, 10, 'page_no', true, 'Nhóm trường', 'Trang');
$re = DB::query("SELECT * FROM products_extra_fields_group {$where} order by id desc {$limit}");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$products_extra_fields_group[$row['id']] = $row;
}
}
}
$filter_count = 0;
foreach ($filte_value as $key => $val) {
if ($filter_count < $val->order) {
$filter_count = $val->order;
}
}
if (count($filte_value) > $filter_count) {
$filter_count = count($filte_value);
}
$categories = eb_memcache::do_get('categories_new');
if (!is_array($categories)) {
//if($total){
require_once ROOT_PATH . 'core/ECPagging.php';
$re = DB::query("SELECT * FROM products_category order by orders");
if ($re) {
while ($row = mysql_fetch_assoc($re)) {
$categories[$row['parent_id']][$row['id']] = $row;
}
}
eb_memcache::do_put('categories_new', $categories);
}
print_category($categories, 0, $options, $filter[0]['zone_id'], $filter[0]['cat_product_id']);
$arrVar['options'] = $options;
$arrVar['filter_count'] = $filter_count;
$arrVar['zones'] = CGlobal::$allZones;
$arrVar['paging'] = $paging;
$arrVar['products_extra_fields_group'] = $products_extra_fields_group;
$display->templateAdvance = TRUE;
$display->setTemplate('ManageFilterEdit', $arrVar);
$this->endForm();
}
function show_all_notify()
{
global $display;
EClassApi::getCats();
$feed_follows = array();
//hoạt động của các thành viên mà mình theo đuôi
$follow_ids = '';
//hoạt động của các thành viên mà mình theo đuôi
$action = Url::get('action');
$num_per_page = 20;
$ajax_mod = (int) (Url::get('act') == 'shop_giaodich');
$page_no = 1;
$cur_group = 0;
$all_feeds = array();
//Lưu mảng tất cả các cập nhật
$all_feed_ars = array();
//mảng các cập nhật đã đc sắp xếp, xử lý
$user_arr = array();
//Mảng các user
$item_arr = array();
//Mảng các Giao dịch
$entry_arr = array();
//Mảng các Bài viết
$item_ids_ar = array();
//Mảng id các Giao dịch
$user_ids_ar = array();
//Mảng id các user
$entry_ids_ar = array();
//Mảng id các Bài viết
$item_comment_ids = "";
//Id các phản hồi giao dịch
$item_comment_arr = array();
//các phản hồi giao dịch
$user_comment_ids = "";
//Id các lưu bút
$user_comment_arr = array();
//các lưu bút
$pm_ids = "";
//Id các tin nhắn
$pm_arr = array();
//các tin nhắn
$entry_comment_ids = "";
//Id các bài viết
$entry_comment_arr = array();
//các bài viết
$this->show_more = false;
//các bài viết
$where = "WHERE user_id = " . User::id();
$limit = " LIMIT " . $num_per_page * ($page_no - 1) . "," . ($num_per_page + 1);
$where .= " AND type IN(1,2,3,4,5,6)";
$total_unread = 0;
$sql = "SELECT * FROM feed {$where} ORDER BY time DESC {$limit}";
$re = DB::query($sql);
$stt = 0;
if ($re) {
while ($feed = mysql_fetch_assoc($re)) {
if ($stt < $num_per_page) {
if ($feed['type'] == 1 || $feed['type'] == 2) {
$item_comment_ids .= ($item_comment_ids != '' ? ',' : '') . $feed['ref_id'];
if (!in_array($feed['item_id'], $item_ids_ar)) {
$item_ids_ar[$feed['item_id']] = $feed['item_id'];
}
} elseif ($feed['type'] == 3) {
$user_comment_ids .= ($user_comment_ids != '' ? ',' : '') . $feed['ref_id'];
} elseif ($feed['type'] == 4) {
$pm_ids .= ($pm_ids != '' ? ',' : '') . $feed['ref_id'];
} elseif ($feed['type'] == 5 || $feed['type'] == 6) {
$entry_comment_ids .= ($entry_comment_ids != '' ? ',' : '') . $feed['ref_id'];
if ($feed['item_id']) {
$entry_ids_ar[$feed['item_id']] = $feed['item_id'];
}
}
if ($feed['act_user_id'] && !in_array($feed['act_user_id'], $user_ids_ar)) {
$user_ids_ar[$feed['act_user_id']] = $feed['act_user_id'];
}
$all_feeds[$feed['id']] = $feed;
$stt++;
} else {
$this->show_more = true;
}
}
}
if ($item_ids_ar) {
$item_ids = implode(',', $item_ids_ar);
if ($item_ids != '') {
$re = DB::query("SELECT id, name ,up_time, status, state, currency_id, category_id, img_server, original_image_url AS image_url FROM item WHERE id IN({$item_ids})");
if ($re) {
while ($item = mysql_fetch_assoc($re)) {
if (isset(CGlobal::$allCategories[$item['category_id']])) {
$item['link_view'] = Url::build('item_detail', array('id' => $item['id'], 'ebname' => EClassApi::safe_title($item['name']), 'nice_name' => CGlobal::$allCategories[$item['category_id']]['nice_name']));
} else {
$item['link_view'] = Url::build('item_detail', array('id' => $item['id'], 'ebname' => EClassApi::safe_title($item['name'])));
}
if (!$item['status']) {
$total_unread++;
}
$item_arr[$item['id']] = $item;
}
}
}
}
if (!empty($entry_ids_ar)) {
$entry_ids = implode(',', $entry_ids_ar);
if ($entry_ids != '') {
$re = DB::query("SELECT id, title, status, user_name, time_modify, image_url FROM user_entry WHERE id IN({$entry_ids})");
if ($re) {
while ($entry = mysql_fetch_assoc($re)) {
$entry['link_view'] = WEB_DIR . ECRewrite::formatUrl('?page=user_entry&user_name=' . $entry['user_name'] . '&cmd_entry=view&entry_id=' . $entry['id'] . '&ebname=' . EClassApi::safe_title($entry['title']));
if (!$entry['status']) {
$total_unread++;
}
$entry_arr[$entry['id']] = $entry;
}
}
}
}
if ($user_ids_ar) {
$user_ids = implode(',', $user_ids_ar);
if ($user_ids != '') {
$re = DB::query("SELECT id, user_name, blast, avatar_url,img_server FROM account WHERE id IN({$user_ids})");
if ($re) {
while ($user = mysql_fetch_assoc($re)) {
if ($user['avatar_url']) {
$user['avatar_url'] = 'http://' . CGlobal::$img_server[$user['img_server']] . 'thumb/50_50/' . $user['avatar_url'];
} else {
$user['avatar_url'] = 'style/images/54x54.gif';
}
$user_arr[$user['id']] = $user;
}
}
}
}
//Phản hồi giao dịch
if ($item_comment_ids != '') {
$re = DB::query("SELECT * FROM comment WHERE id IN({$item_comment_ids})");
if ($re) {
while ($comment = mysql_fetch_assoc($re)) {
$comment['content'] = EClassApi::parseBBCode(stripslashes($comment['content']));
$comment['s_content'] = EClassApi::plainText($comment['content']);
if (strlen($comment['s_content']) > 20) {
$comment['s_content'] = EClassApi::word_limit($comment['s_content'], 10, '..');
}
$comment['time'] = EClassApi::duration_time($comment['time']);
if (!$comment['status']) {
$total_unread++;
}
$item_comment_arr[$comment['id']] = $comment;
}
}
}
//Lưu bút
if ($user_comment_ids != '') {
$re = DB::query("SELECT * FROM comment_user WHERE id IN({$user_comment_ids})");
if ($re) {
while ($comment = mysql_fetch_assoc($re)) {
$comment['content'] = EClassApi::parseBBCode(stripslashes($comment['content']));
$comment['s_content'] = EClassApi::plainText($comment['content']);
if (strlen($comment['s_content']) > 20) {
$comment['s_content'] = EClassApi::word_limit($comment['s_content'], 10, '..');
}
$comment['time'] = EClassApi::duration_time($comment['time']);
if (!$comment['status']) {
$total_unread++;
}
$user_comment_arr[$comment['id']] = $comment;
}
}
}
if ($pm_ids != '' && $pm_ids != 0) {
//Tin nhắn
$re = DB::query("SELECT mt.*, msg.msg_post as content FROM (SELECT mt_id AS id, mt_msg_id, mt_title, mt_ref_id , mt_from_id AS sender_user_id, mt_date AS time, mt_read AS status FROM message_topics WHERE mt_id IN({$pm_ids})) AS mt LEFT JOIN message_text AS msg ON mt.mt_msg_id = msg.msg_id");
if ($re) {
while ($comment = mysql_fetch_assoc($re)) {
$comment['content'] = EClassApi::parseBBCode(stripslashes($comment['content']));
$comment['s_content'] = EClassApi::plainText($comment['content']);
if (strlen($comment['s_content']) > 20) {
$comment['s_content'] = EClassApi::word_limit($comment['s_content'], 10, '..');
}
$comment['time'] = EClassApi::duration_time($comment['time']);
if (!$comment['status']) {
$total_unread++;
}
$pm_arr[$comment['id']] = $comment;
}
}
}
if ($entry_comment_ids != '') {
//Phản hồi bài viết
$re = DB::query("SELECT id, entry_id, content, time, sender_user_id, sender_user_name, sender_email, status FROM user_entry_comment WHERE id IN({$entry_comment_ids})");
if ($re) {
while ($comment = mysql_fetch_assoc($re)) {
$comment['content'] = EClassApi::parseBBCode(stripslashes($comment['content']));
$comment['s_content'] = EClassApi::plainText($comment['content']);
if (strlen($comment['s_content']) > 20) {
$comment['s_content'] = EClassApi::word_limit($comment['s_content'], 10, '..');
}
$comment['time'] = EClassApi::duration_time($comment['time']);
if (!$comment['status']) {
$total_unread++;
}
$entry_comment_arr[$comment['id']] = $comment;
}
}
}
$item_ids_ar = array();
//Mảng item_id cập nhật bỏ qua cho các feed chủ thể tương ứng khi giao dịch bị xoá hoặc khoá!
$item_ids_ar2 = array();
//Mảng item_id cập nhật bỏ qua cho các feed khách thể tương ứng khi giao dịch bị xoá hoặc khoá!
$entry_ids_ar = array();
$entry_ids_ar2 = array();
$c_user_ids_ar = array();
$pm_ids_ar = array();
$unread_feed_ids = '';
$del_feed_ids = '';
if ($all_feeds) {
foreach ($all_feeds as $feed) {
if ($feed['type'] == 4) {
//Tin nhắn
if (isset($user_arr[$feed['act_user_id']])) {
$feed['sender_user_name'] = $user_arr[$feed['act_user_id']]['user_name'];
} else {
$feed['sender_user_name'] = '';
}
}
if ($feed['type'] == 1 || $feed['type'] == 2) {
//Phản hồi giao dịch hoặc Trả lời phản hồi giao dịch
if (isset($item_comment_arr[$feed['ref_id']])) {
$feed['item_id'] = $item_comment_arr[$feed['ref_id']]['item_id'];
$feed['content'] = $item_comment_arr[$feed['ref_id']]['content'];
$feed['s_content'] = $item_comment_arr[$feed['ref_id']]['s_content'];
$feed['time'] = $item_comment_arr[$feed['ref_id']]['time'];
$feed['sender_user_id'] = $item_comment_arr[$feed['ref_id']]['sender_user_id'];
$feed['sender_user_name'] = $item_comment_arr[$feed['ref_id']]['sender_user_name'];
$feed['sender_email'] = $item_comment_arr[$feed['ref_id']]['sender_email'];
$status = $feed['status'];
if ($feed['type'] == 1) {
$feed['status'] = $item_comment_arr[$feed['ref_id']]['status'];
} else {
$feed['status'] = $item_comment_arr[$feed['ref_id']]['replied_status'];
}
if ($feed['status'] == 0 || $status == 0) {
$unread_feed_ids .= ($unread_feed_ids != '' ? ',' : '') . $feed['id'];
if ($feed['type'] == 1 && $feed['status'] == 0) {
//Mảng item_id cập nhật bỏ qua cho các feed chủ thể tương ứng khi giao dịch bị xoá hoặc khoá!
$item_ids_ar[$feed['item_id']] = $feed['item_id'];
} elseif ($feed['type'] == 2 && $feed['status'] == 0) {
//Mảng item_id cập nhật bỏ qua cho các feed khách thể tương ứng khi giao dịch bị xoá hoặc khoá!
$item_ids_ar2[$feed['item_id']] = $feed['item_id'];
}
}
if (isset($item_arr[$feed['item_id']]) && $item_arr[$feed['item_id']]['state'] == 0 && $item_arr[$feed['item_id']]['status'] != -1) {
$feed['item'] = $item_arr[$feed['item_id']];
$all_feed_ars[$feed['id']] = $feed;
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
} elseif ($feed['type'] == 3) {
//Lưu bút
if (isset($user_comment_arr[$feed['ref_id']])) {
$feed['content'] = $user_comment_arr[$feed['ref_id']]['content'];
$feed['s_content'] = $user_comment_arr[$feed['ref_id']]['s_content'];
$feed['time'] = $user_comment_arr[$feed['ref_id']]['time'];
$feed['sender_user_id'] = $user_comment_arr[$feed['ref_id']]['sender_user_id'];
$feed['sender_user_name'] = $user_comment_arr[$feed['ref_id']]['sender_user_name'];
$status = $feed['status'];
$feed['status'] = $user_comment_arr[$feed['ref_id']]['status'];
if ($feed['status'] == 0 || $status == 0) {
$unread_feed_ids .= ($unread_feed_ids != '' ? ',' : '') . $feed['id'];
if ($feed['status'] == 0) {
//
$c_user_ids_ar[$feed['ref_id']] = $feed['ref_id'];
}
}
$all_feed_ars[$feed['id']] = $feed;
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
} elseif ($feed['type'] == 4) {
//Tin nhắn
if (isset($pm_arr[$feed['ref_id']])) {
$feed['content'] = $pm_arr[$feed['ref_id']]['content'];
$feed['s_content'] = $pm_arr[$feed['ref_id']]['s_content'];
$feed['time'] = $pm_arr[$feed['ref_id']]['time'];
$feed['sender_user_id'] = $pm_arr[$feed['ref_id']]['sender_user_id'];
$feed['mt_title'] = $pm_arr[$feed['ref_id']]['mt_title'];
$id = $pm_arr[$feed['ref_id']]['mt_ref_id'] ? $pm_arr[$feed['ref_id']]['mt_ref_id'] : $pm_arr[$feed['ref_id']]['id'];
$feed['mt_title_link'] = "message.html?tab=gt#inbox/{$id}";
$status = $feed['status'];
$feed['status'] = $pm_arr[$feed['ref_id']]['status'];
if ($feed['status'] == 0 || $status == 0) {
$unread_feed_ids .= ($unread_feed_ids != '' ? ',' : '') . $feed['id'];
if ($feed['status'] == 0) {
//
$pm_ids_ar[$feed['ref_id']] = $feed['ref_id'];
}
}
$all_feed_ars[$feed['id']] = $feed;
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
} elseif ($feed['type'] == 5 || $feed['type'] == 6) {
//Phản hồi Bài viết
if (isset($entry_comment_arr[$feed['ref_id']])) {
$feed['entry_id'] = $entry_comment_arr[$feed['ref_id']]['entry_id'];
$feed['content'] = $entry_comment_arr[$feed['ref_id']]['content'];
$feed['s_content'] = $entry_comment_arr[$feed['ref_id']]['s_content'];
$feed['time'] = $entry_comment_arr[$feed['ref_id']]['time'];
$feed['sender_user_id'] = $entry_comment_arr[$feed['ref_id']]['sender_user_id'];
$feed['sender_user_name'] = $entry_comment_arr[$feed['ref_id']]['sender_user_name'];
$feed['sender_email'] = $entry_comment_arr[$feed['ref_id']]['sender_email'];
$status = $feed['status'];
if ($feed['type'] == 5) {
$feed['status'] = $entry_comment_arr[$feed['ref_id']]['status'];
} else {
$feed['status'] = $entry_comment_arr[$feed['ref_id']]['replied_status'];
}
if ($feed['status'] == 0 || $status == 0) {
$unread_feed_ids .= ($unread_feed_ids != '' ? ',' : '') . $feed['id'];
if ($feed['type'] == 5 && $feed['status'] == 0) {
//Mảng entrry_id cập nhật bỏ qua cho các feed chủ thể tương ứng khi giao dịch bị xoá hoặc khoá!
$entry_ids_ar[$feed['entry_id']] = $feed['entry_id'];
}
if ($feed['type'] == 6 && $feed['status'] == 0) {
//Mảng entrry_id cập nhật bỏ qua cho các feed khách thể tương ứng khi giao dịch bị xoá hoặc khoá!
$entry_ids_ar2[$feed['entry_id']] = $feed['entry_id'];
}
}
if (isset($entry_arr[$feed['entry_id']])) {
$feed['entry'] = $entry_arr[$feed['entry_id']];
$all_feed_ars[$feed['id']] = $feed;
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
} else {
$del_feed_ids .= ($del_feed_ids != '' ? ',' : '') . $feed['id'];
}
}
}
}
$display->add('all_feed_ars', $all_feed_ars);
$display->add('image_path', 'http://' . IMAGE_PATH);
$display->add('get_page', EClass::$page['name']);
$display->add('get_cmd', Url::get('cmd', 'office'));
$display->add('get_act', $action);
$display->add('user_name', User::user_name());
$this->total_group = count($all_feed_ars);
$display->add('total_group', $this->total_group);
$display->add('cur_group', $cur_group);
$display->add('show_more', $this->show_more);
$display->add('cur_user_name', User::user_name());
$display->add('more_notify', WEB_DIR . ECRewrite::formatUrl('?page=personal'));
$transact_office = $display->output('tbl_notify_ajax', true, 'Personal');
$display->add('transact_office', $transact_office);
$display->add('total_comment_user', User::$current->data['total_comment_user']);
$display->add('total_new_comment', User::$current->data['total_new_comment']);
$display->add('total_pm', User::$current->data['total_pm']);
$display->add('can_edit_blast', User::is_admin() || !User::is_block());
$blast = User::$current->data['blast'];
$avatar_link = '';
$avatar_url = 'style/images/no_avatar_item.gif';
if (User::$current->data['avatar_url'] != '') {
$avatar_link = "http://" . CGlobal::$img_server[User::$current->data['img_server']] . User::$current->data['avatar_url'];
$avatar_url = EClassApi::getImageThumb(User::$current->data['avatar_url'], 80, 80, 0, User::$current->data['img_server']);
}
if ($blast == '') {
$blast = '...';
} else {
$blast = ' ' . $blast;
if (strpos($blast, 'http://')) {
$user_blast = $blast;
while (strpos($user_blast, 'http://')) {
$tmp = substr($user_blast, strpos($user_blast, 'http://'));
if (strpos($tmp, ' ') || strpos($tmp, '<')) {
if (strpos($tmp, ' ') && strpos($tmp, '<') && strpos($tmp, ' ') > strpos($tmp, '<')) {
$blast_url = substr($tmp, 0, strpos($tmp, '<'));
} else {
$blast_url = substr($tmp, 0, strpos($tmp, ' '));
}
} else {
$blast_url = $tmp;
}
$user_blast = str_replace($blast_url, '', $user_blast);
}
$new_blast_url = ' <a rel="nofollow" href="' . $blast_url . '" target="_blank">Click here</a>';
$blast = substr($user_blast . $new_blast_url, 1);
}
}
$display->add('avatar_link', $avatar_link);
$display->add('avatar_url', $avatar_url);
$display->add('blast', $blast);
$display->add('user_id', User::id());
//Cập nhật sách theo đuôi
if (isset($user_arr[$feed['act_user_id']]) && $user_arr[$feed['act_user_id']]['avatar_url']) {
$feed['avatar_url'] = $user_arr[$feed['act_user_id']]['avatar_url'];
} else {
$feed['avatar_url'] = 'style/images/54x54.gif';
}
if ($feed_follows) {
$tmp_feed_follows = $feed_follows;
$feed_follows = array();
foreach ($tmp_feed_follows as $feed) {
if (isset($user_arr[$feed['user_id']])) {
if ($user_arr[$feed['user_id']]['avatar_url']) {
$avatar_url = $user_arr[$feed['user_id']]['avatar_url'];
} else {
$avatar_url = 'style/images/54x54.gif';
}
$user_name = $user_arr[$feed['user_id']]['user_name'];
if ($feed['type'] == 7) {
//entry
if (isset($entry_arr[$feed['item_id']])) {
$feed_follows[$feed['user_id']]['user_name'] = $user_name;
$feed_follows[$feed['user_id']]['avatar_url'] = $avatar_url;
$feed['entry_name'] = $entry_arr[$feed['item_id']]['title'];
$feed['entry_link'] = WEB_DIR . ECRewrite::formatUrl('?page=user_entry&user_name=' . $user_name . '&cmd_entry=view&entry_id=' . $feed['item_id'] . '&ebname=' . EClassApi::safe_title($feed['entry_name']));
$feed['time'] = date('H:i d/m/Y', $feed['time']);
$feed_follows[$feed['user_id']]['feeds'][$feed['id']] = $feed;
}
} else {
$feed_follows[$feed['user_id']]['user_name'] = $user_name;
$feed_follows[$feed['user_id']]['avatar_url'] = $avatar_url;
$feed['blast'] = $user_arr[$feed['user_id']]['blast'];
$feed['time'] = date('H:i d/m/Y', $feed['time']);
$feed_follows[$feed['user_id']]['feeds'][$feed['id']] = $feed;
}
}
}
}
$json = array();
$active_notify = array();
$active_notify['item_ids_ar'] = $item_ids_ar;
$active_notify['item_ids_ar2'] = $item_ids_ar2;
$active_notify['c_user_ids_ar'] = $c_user_ids_ar;
$active_notify['pm_ids_ar'] = $pm_ids_ar;
$json['active_notify'] = $active_notify;
$json['total_unread'] = $total_unread;
$json['total_notify'] = User::$current->data['total_comment_user'] + User::$current->data['total_new_comment'] + User::$current->data['total_pm'];
$json['content'] = $display->output('tb_notify', true, 'Personal');
echo json_encode($json);
exit;
}
function get_feed_notify_bar()
{
EClassApi::getCats();
$json = "";
if (!User::is_login()) {
$json = '({"msg":"no_login"})';
echo $json;
exit;
}
$item_comment_ids = "";
//Id các phản hồi giao dịch
$user_comment_ids = "";
//Id các lưu bút
$entry_comment_ids = "";
//Id các bài viết
/*$follow_ids = "";//Id các theo đuôi*/
$blast_user_ids = "";
// Id các balst
$arr_data = array();
$user = User::getUser(User::id());
if ($user["total_pm"]) {
// neu co PM moi
$arr_data = array("new_pm" => $user["total_pm"]);
}
$where = "WHERE user_id = " . User::id();
$limit = " LIMIT 20";
$sql = "SELECT * FROM feed {$where} ORDER BY time DESC {$limit}";
$re = DB::query($sql);
if ($re) {
while ($feed = mysql_fetch_assoc($re)) {
if ($feed['type'] == 1 || $feed['type'] == 2) {
// phan hoi
$item_comment_ids .= ($item_comment_ids != '' ? ',' : '') . $feed['ref_id'];
} elseif ($feed['type'] == 3) {
// luu but
$user_comment_ids .= ($user_comment_ids != '' ? ',' : '') . $feed['ref_id'];
} elseif ($feed['type'] == 5 || $feed['type'] == 6) {
// bai viet
$entry_comment_ids .= ($entry_comment_ids != '' ? ',' : '') . $feed['ref_id'];
}
/*elseif($feed['type']==7){// theo duoi
$follow_ids.=($follow_ids!=''?',':'').$feed['ref_id'];
}*/
}
}
//Phản hồi giao dịch
$item_comment_arr = array();
if ($item_comment_ids != '') {
$item_ids = "";
$re = DB::query("SELECT time, item_id, parent_id, COUNT(item_id) AS total_comment FROM comment WHERE id IN({$item_comment_ids}) GROUP BY item_id");
if ($re) {
while ($comment = mysql_fetch_assoc($re)) {
$item_ids .= ($item_ids != '' ? ',' : '') . $comment['item_id'];
$comment['time'] = EClassApi::duration_time($comment['time']);
$item_comment_arr[$comment['item_id']] = $comment;
}
if ($item_comment_arr && $item_ids) {
// Query de lay ID va Tieu de tin
$re = DB::query("SELECT id, name, level_1_category_id FROM item WHERE id IN({$item_ids})");
while ($item = mysql_fetch_assoc($re)) {
if ($item["id"] == $item_comment_arr[$item["id"]]["item_id"]) {
$item_comment_arr[$item["id"]]["item_name"] = EClassApi::word_limit($item["name"], 7, '...');
$ebname = EClassApi::safe_title($item['name']);
if (isset(CGlobal::$allCategories[$item['level_1_category_id']])) {
$cat_name = CGlobal::$allCategories[$item['level_1_category_id']]['name'];
$item_comment_arr[$item["id"]]["url_link"] = WEB_DIR . EClassApi::safe_title($cat_name) . "/p{$item['id']}/{$ebname}.html";
} else {
$item_comment_arr[$item["id"]]["url_link"] = WEB_DIR . "/p{$item['id']}/{$ebname}.html";
}
}
}
}
}
if ($item_comment_arr) {
$item_comment_arrs["comment"] = $item_comment_arr;
$arr_data += $item_comment_arrs;
}
}
// End Phan hoi giao dich
//Luu but
$total_comment_arr = array();
if ($user_comment_ids != '') {
$re = DB::query("SELECT time, COUNT(id) AS total_comment_user FROM comment_user WHERE id IN({$user_comment_ids}) GROUP BY receiver_user_id ORDER BY time DESC");
if ($re) {
$comment_user = mysql_fetch_assoc($re);
$total_comment_arr["total"] = $comment_user["total_comment_user"];
$total_comment_arr['time'] = EClassApi::duration_time($comment_user['time']);
$total_comment_arr["url_link"] = WEB_DIR . 'Shop/' . User::user_name() . '/Luu-but';
}
if ($total_comment_arr) {
$total_comment_arrs["comment_user"] = $total_comment_arr;
$arr_data += $total_comment_arrs;
}
}
//End Luu but
// Theo duoi
/*$follow_arr = array();
if($follow_ids!=''){
$re = DB::query("SELECT id, follower_name, time FROM follow WHERE id IN($follow_ids) ORDER BY time DESC");
if($re){
while ($follow = mysql_fetch_assoc($re)){
$follow['time'] = EClassApi::duration_time($follow['time']);
$follow["url_link"] = WEB_DIR.$follow['follower_name'];
$follow_arr[$follow['id']] = $follow;
}
}
if($follow_arr){
$follow_arrs["follow"] = $follow_arr;
$arr_data += $follow_arrs;
}
}*/
// end Theo duoi
// Phản hồi bài viết
$entry_comment_arr = array();
if ($entry_comment_ids != '') {
$entry_ids = "";
$re = DB::query("SELECT time, entry_id, parent_id FROM user_entry_comment WHERE id IN({$entry_comment_ids})");
if ($re) {
while ($comment_entry = mysql_fetch_assoc($re)) {
$entry_ids .= ($entry_ids != '' ? ',' : '') . $comment_entry['entry_id'];
$comment_entry['time'] = EClassApi::duration_time($comment_entry['time']);
$comment_entry['total_comment_entry'] = count(explode(',', $entry_comment_ids));
$entry_comment_arr[$comment_entry['entry_id']] = $comment_entry;
}
if ($entry_comment_arr && $entry_ids) {
// Query de lay ID va Tieu de bai viet
$re = DB::query("SELECT id, title FROM user_entry WHERE id IN({$entry_ids})");
while ($entry = mysql_fetch_assoc($re)) {
if ($entry["id"] == $entry_comment_arr[$entry["id"]]["entry_id"]) {
$entry_comment_arr[$entry["id"]]["title"] = EClassApi::word_limit($entry["title"], 7, '...');
$ebname = EClassApi::safe_title($entry['title']);
$entry_comment_arr[$entry["id"]]["url_link"] = WEB_DIR . "Bai-viet/" . User::user_name() . "/e{$entry['id']}/{$ebname}";
}
}
}
}
if ($entry_comment_arr) {
$item_comment_arrs["entry"] = $entry_comment_arr;
$arr_data += $item_comment_arrs;
}
}
// End Phan hoi bài viết
$json = json_encode($arr_data);
echo $json;
exit;
}
