function draw() { global $display; $item_ids = ''; $item_news = array(); $configs = @CGlobal::$configs['ItemNew']['conf_val']; if ($configs) { $configs = unserialize(stripslashes($configs)); $title_new = $configs['title']; $item_ids = $configs['item_ids']; } else { $title_new = "SẢN PHẨM MỚI"; $item_ids = ''; } if ($item_ids) { $re = DB::query("SELECT * FROM item WHERE id IN({$item_ids}) AND status = 1 ORDER BY find_in_set(id,'{$item_ids}')"); if ($re) { while ($product = mysql_fetch_assoc($re)) { if ($product['img_url']) { $product['image'] = AZLib::getImageThumb($product['img_url'], 160, 150, 0, $product['img_server']); } else { $product['image'] = ""; //"style/images/no-images-35x35.gif"; } if (isset(CGlobal::$allCategories[$product['category_id']])) { $product['url'] = WEB_DIR . CGlobal::$allCategories[$product['category_id']]['nice_name'] . "/p{$product['id']}/" . AZLib::safe_title($product['name']) . ".html"; } else { $product['url'] = WEB_DIR . "p{$product['id']}/" . AZLib::safe_title($product['name']) . ".html"; } $product['name'] = stripslashes($product['name']); if ($product['list_brief'] == '') { $product['list_brief'] = $product['brief']; } $product['list_brief'] = AZLib::remove_4_js(AZLib::plainText(AZLib::parseBBCode(html_entity_decode($product['list_brief'], ENT_QUOTES, "UTF-8")))); $product['list_brief'] = preg_replace("/\\[([\\s]*[0-9]{1,2}[\\s]*)\\]/eis", " ", $product['list_brief']); $product['list_brief'] = str_replace(array("'", "\""), array("", " "), $product['list_brief']); $product['list_brief'] = AZLib::word_limit($product['list_brief'], 50, ''); $product['list_brief'] = '<b>' . str_replace(array("'", "\""), array("", " "), $product['name']) . '</b><br />' . $product['list_brief']; $product['price_num'] = $product['price']; $product['price'] = AZLib::getPrice($product['price'], $product['currency_id']); $item_news[$product['id']] = $product; } } } if (User::is_admin()) { $display->add("is_admin", 1); $display->add("msg", $this->showFormErrorMessages(1)); $display->add('begin_form', $this->beginForm(true, 'post', false, false, 1)); $display->add('end_form', $this->endForm(true)); } $display->add('title_new', $title_new); $display->add('item_ids', $item_ids); $display->add('item_news', $item_news); $display->output("ItemNew"); }
static function getWebsiteLogo($delcache = false) { if (CGlobal::$websiteLogo === false || is_array(CGlobal::$websiteLogo) && !count(CGlobal::$websiteLogo) || $delcache) { if (AZArrCache::is_not_cached('websiteLogo', 0, '', $delcache)) { if (!$delcache) { CGlobal::$websiteLogo['current'] = array('id' => 0, 'img_src' => 'style/img/header_new/logo.png', 'title' => 'Trang chủ', 'expired' => ''); // For logo management $re = DB::query("SELECT * FROM website_logo ORDER BY start_date DESC, end_date DESC"); if ($re) { $logos = array(); $active = false; while ($row = mysql_fetch_assoc($re)) { if (isset(CGlobal::$img_server[$row['img_server']])) { $row['img_src'] = CGlobal::$img_server[$row['img_server']] . UP_FOLDER . '/' . $row['image']; if ($row['status']) { $row['active'] = "Active"; } if ($row['start_date']) { $row['startDate'] = date('d-m-Y', $row['start_date']); } if ($row['end_date']) { $row['endDate'] = date('d-m-Y', $row['end_date']); } $logos[$row['id']] = $row; // Chọn logo theo sự kiện, hoạt động nào đó của AnhNghĩa if ($row['status'] && !$active) { // Nếu trạng thái của logo là đang active và chưa có logo nào được chọn if (!$row['start_date'] || $row['start_date'] < TIME_NOW) { if (!$row['end_date'] || $row['end_date'] >= TIME_NOW) { $active = true; } } if ($active) { CGlobal::$websiteLogo['current'] = array('id' => $row['id'], 'img_src' => CGlobal::$img_server[$row['img_server']] . UP_FOLDER . '/' . $row['image'], 'title' => AZLib::remove_4_js(AZLib::trimSpace(AZLib::plainText(addslashes($row['title'])))), 'expired' => $row['end_date']); DB::query("UPDATE website_logo SET status = 0 WHERE id <> " . $row['id']); } } } } CGlobal::$websiteLogo['logos'] = $logos; AZArrCache::set(array('websiteLogo' => CGlobal::$websiteLogo)); } } } else { CGlobal::$websiteLogo = AZArrCache::$arr_cache['websiteLogo']; AZArrCache::$arr_cache = array(); } } }
function draw() { $this->beginForm(); global $display; $display->add('created_time_from', Url::get('created_time_from')); $display->add('created_time_to', Url::get('created_time_to')); $display->add('sender_user_name', Url::get('sender_user_name')); $display->add('processed', Url::get('processed')); //search theo ngay thang nam $created_time_from = 0; $created_time_to = 0; if (Url::get('created_time_from')) { $date_arr = explode('-', Url::get('created_time_from')); if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) { $created_time_from = mktime(0, 0, 0, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]); } } if (Url::get('created_time_to')) { $date_arr = explode('-', Url::get('created_time_to')); if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) { $created_time_to = mktime(23, 59, 59, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]); } } $search_value = ' 1 '; if ($created_time_from) { $search_value .= ' AND time_post >= ' . $created_time_from; } if ($created_time_to) { $search_value .= ' AND time_post <= ' . $created_time_to; } // search ô textbox if (Url::get('sender_user_name') != '') { $search_value .= ' AND b.user_name like "%' . Url::get('sender_user_name') . '%" '; } if (Url::get('processed') == 1) { $search_value .= ' AND b.status = 0'; } $item_per_page = 50; $sql_count = 'SELECT COUNT(*) AS total_item FROM `bad_content` AS b WHERE b.type = 1 AND ' . $search_value; $total = DB::fetch($sql_count, 'total_item', 0); $items = array(); if ($total) { $limit = ''; $paging = AZPagging::pagingSE($limit, $total, $item_per_page, 10, 'page_no', true, 'Phản hồi', 'Trang'); $sql = 'SELECT i.name,i.transaction_type,i.category_id, b.id, b.admin_name, b.status, b.type,b.id_item, b.reason,b.user_id,b.user_name, b.note, b.time_post FROM `bad_content` b LEFT JOIN item i ON i.id = b.id_item WHERE b.type = 1 AND ' . $search_value . ' ORDER BY b.status, b.time_post DESC, b.type ASC ' . $limit; $result = DB::query($sql); if ($result) { while ($row = mysql_fetch_assoc($result)) { $row['content'] = $row['name']; $row['time_post'] = date('d/m/y H:i', $row['time_post']); $row['content_tooltip'] = AZLib::remove_4_js(AZLib::filter_title($row['content'])); $row['content'] = AZLib::word_limit($row['content'], 12, '...'); $row['reason_tooltip'] = AZLib::remove_4_js(AZLib::filter_title($row['reason'])); $row['reason'] = AZLib::word_limit($row['reason'], 12, '...'); $row['note_tooltip'] = AZLib::remove_4_js(AZLib::filter_title($row['note'])); $row['note'] = AZLib::word_limit($row['note'], 12, '...'); $row['href'] = WEB_DIR . AZRewrite::formatUrl('?page=item_detail&id=' . $row['id_item'] . '&ebname=' . AZLib::safe_title($row['name'])); $row['del_link'] = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id'), 'cmd=delete&id=' . $row['id']); $items[$row['id']] = $row; } } } else { $paging = ''; } $display->add('items', $items); $display->add('paging', $paging); $display->output('list'); $this->endForm(); }
function item_history() { $itemids = Url::get('itemids'); $item_history = array(); if ($itemids) { $re = DB::query("SELECT id, name, price, currency_id, img_url, img_server, status, state FROM item WHERE id IN({$itemids}) ORDER BY find_in_set(id, '{$itemids}')"); if ($re) { while ($fitem = mysql_fetch_assoc($re)) { if ($fitem['status'] == 1 && $fitem['state'] == 0) { $item['item_id'] = $fitem['id']; $item['item_url'] = "p" . $fitem['id'] . "/" . AZLib::safe_title($fitem['name']) . ".html"; $item['item_title'] = ucfirst(AZLib::remove_4_js($fitem['name'])); // $item['price'] = $fitem['price']?number_format($fitem['price'],0,',','.'):'Liên hệ'; $item['price'] = $fitem['price'] ? number_format(AZLib::convertCurrency($fitem['price'], $fitem['currency_id']), 0, ',', '.') : 'Liên hệ'; //$item['item_image'] = ($fitem['img_url']) ? AZLib::getImageThumbIn($fitem['img_url'],150,120,$fitem['img_server']) : ''; $item['item_image'] = $fitem['img_url'] ? AZLib::getImageThumb($fitem['img_url'], 120, 105, 0, $fitem['img_server']) : ''; $item_history[] = $item; } } } } echo json_encode($item_history); }
function draw() { global $display; AZLib::getCats(); $this->beginForm(false, 'post', false, Url::build_current()); $created_time_from = 0; $created_time_to = 0; $time_from = ""; $time_to = ""; $phrase_checked = ""; $free_cat_checked = ""; $up_checked = ""; $pagging = ""; $limit = ""; $lock_checked = ''; $select_subcat_checked = ''; $items = array(); $id_search = (int) Url::get("id_search"); $censor = Url::get("censor", 1); $user_name = AZLib::getParam("user_name"); $zone_id = Url::get("zone_id"); $searchByCat = Url::get("searchByCat"); $searchByCatType = Url::get("searchByCatType", 0); $searchBySubCat = Url::get("searchBySubCat"); $searchBySubCatType = Url::get("searchBySubCatType", 0); $sort_type = Url::get("sort_type", 1); $keywords = Url::get("keywords"); $have_img = Url::get("have_img", 0); $lock_item = Url::get("lock"); $phrase_selected = Url::get("phrase"); $free_cat_selected = Url::get("free_cat"); $up = Url::get("up"); $select_subcat = Url::get("select_subcat", ""); $opt_have_img = AZLib::getOption(array(0 => "-Tìm theo ảnh-", 1 => "-Có ảnh-", 2 => "-Không ảnh-"), $have_img); if (isset($_REQUEST["created_time"]) && $_REQUEST["created_time"]) { $time_from = Url::get("created_time"); } if (isset($_REQUEST["created_time_to"]) && $_REQUEST["created_time_to"]) { $time_to = Url::get("created_time_to"); } if ($time_from) { $date_arr = explode("-", $time_from); if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) { $created_time_from = mktime(0, 0, 0, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]); } } if ($time_to) { $date_arr = explode("-", $time_to); if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) { $created_time_to = mktime(23, 59, 59, (int) $date_arr[1], (int) $date_arr[0], (int) $date_arr[2]); } } $search_value = ""; $where = ""; //$order_by = "ORDER BY del_time DESC"; $order_by = ""; $total_item = 0; if ($keywords) { $search_value = ($search_value == "" ? " WHERE " : " AND ") . "id IN (0)"; } if ($sort_type == 1) { $order_by = "ORDER BY id DESC"; } elseif ($sort_type == 2) { $order_by = "ORDER BY modify_time DESC"; } elseif ($sort_type == 3) { $order_by = "ORDER BY item_order ASC"; } if ($free_cat_selected) { $free_cat_checked = "checked"; $catids = implode(",", array_keys(CGlobal::$allCategories)); $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "category_id NOT IN({$catids})"; $order_by = $order_by != "" ? $order_by : "ORDER BY id DESC"; } else { if ($searchBySubCat) { if ($searchBySubCatType) { // Nếu chỉ tìm trong danh mục con của danh mục cấp 2 $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "level_2_catid = " . $searchBySubCat; // Lọc những item có trường level_2_catid là danh mục cấp 2 } else { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "category_id = " . $searchBySubCat; // Ngược lại, lấy các bản ghi thuộc chính danh mục cấp 2 } } elseif ($searchByCat) { // Nếu chỉ tìm trong danh mục con của danh mục cấp 1 if ($searchByCatType) { // Lọc những item có trường level_1_catid là danh mục cấp 1 $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "level_1_catid = " . $searchByCat; } else { // Ngược lại, lấy các bản ghi thuộc chính danh mục cấp 1 $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "category_id = " . $searchByCat; } } } if ($censor != 9) { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "status=" . $censor; } if ($user_name != "") { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "user_name ='{$user_name}'"; } if ($select_subcat) { $select_subcat_checked = "checked"; } if ($up) { if ($created_time_from) { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "created_time >= " . $created_time_from; } if ($created_time_to) { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "created_time <= " . $created_time_to; } $up_checked = "checked"; } else { if ($created_time_from) { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "modify_time >= " . $created_time_from; } if ($created_time_to) { $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "modify_time <= " . $created_time_to; } } if ($have_img == 1) { //có ảnh $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "have_image=1"; } elseif ($have_img == 2) { //ko có ảnh $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "have_image=0"; } if ($id_search) { //ID sản phẩm $search_value .= ($search_value == "" ? " WHERE " : " AND ") . "id={$id_search}"; } if (Url::get("up")) { $order_by = $order_by != "" ? $order_by : "ORDER BY created_time DESC"; } else { $order_by = $order_by != "" ? $order_by : "ORDER BY modify_time DESC"; } $sql = "SELECT * FROM item {$search_value} {$order_by}"; $sql_count = "SELECT count(*) AS total_row FROM item {$search_value}"; $total_item = (int) DB::fetch($sql_count, "total_row"); if ($total_item) { $pagging = AZPagging::pagingSE($limit, $total_item, 50, 10, 'page_no', true, 'Sản phẩm', 'Trang'); $sql .= $limit; } $re = DB::query($sql); if ($re) { $index_temp = 0; while ($item = mysql_fetch_assoc($re)) { //trạng thái sản phẩm: if ($item['status'] == -1) { $item['bgcolor'] = "bgcolor=\"#FF6633\""; } elseif ($index_temp) { $item['bgcolor'] = "bgcolor=\"#EFEFEF\""; } else { $item['bgcolor'] = ""; } $index_temp = 1 - $index_temp; $item['created_time'] = 'Đăng: <b>' . date("d/m/Y H:i", $item['created_time']) . '</b>'; if ($item['del_time'] && $item['del_user'] && $item['status'] == -1) { $item['del_time'] = '<br /><font color=red>Xoá: <b>' . date("d/m/Y H:i", $item['del_time']) . '</font></b> ( <a target="_blank" href="' . WEB_DIR . $item['del_user'] . '"><strong>' . $item['del_user'] . '</strong></a>)'; } else { $item['del_time'] = ''; } if ($item['modify_user_name'] && $item['status'] != -1) { $item['is_modify'] = '<br><font color=gray>Sửa: <b>' . date("d/m/Y H:i", $item['modify_time']) . '</font></b>'; $item['is_modify'] .= ' ( <a target="_blank" href="' . WEB_DIR . $item['modify_user_name'] . '"><strong>' . $item['modify_user_name'] . '</strong></a>)'; } else { $item['is_modify'] = ''; } $item['name'] = AZLib::filter_title($item['name']); $item['description'] = AZLib::remove_4_js(AZLib::plainText($item['description'])); $item['price'] = number_format($item['price'], 0, ',', '.'); $item['price_out'] = number_format($item['price_out'], 0, ',', '.'); $item['currency_option'] = AZLib::getOption(array(1 => "VNĐ", 2 => "\$"), $item['currency_id']); //$item['price'] = "Giá bán: ".AZLib::priceFomart($item['price'],$item['currency_id']); //$item['price_out'] = "<br /><font color='#999999'>Giá TT: ".AZLib::priceFomart($item['price_out'],$item['currency_id']).'</font>'; if ($item['level_1_catid'] > 0) { if (isset(CGlobal::$allCategories[$item['level_1_catid']])) { $item['cat_name'] = '<b>' . CGlobal::$allCategories[$item['level_1_catid']]['name'] . ' (' . $item['level_1_catid'] . ')</b>'; } else { $item['cat_name'] = '<b><font color=red>(' . $item['level_1_catid'] . ')</font></b>'; } if ($item['category_id'] > 0 && $item['category_id'] != $item['level_1_catid'] || $item['cat_name'] == '') { if (isset(CGlobal::$allCategories[$item['category_id']])) { $item['cat_name'] .= ' - <i>' . CGlobal::$allCategories[$item['category_id']]['name'] . ' (' . $item['category_id'] . ')</i>'; } else { $item['cat_name'] .= ' - <i><b><font color=red>(' . $item['category_id'] . ')</font></b></i>'; } } } if ($item['img_url']) { $item['image_src'] = 'http://' . CGlobal::$img_server[$item['img_server']] . $item['img_url']; $item['image'] = AZLib::getImageThumb($item['img_url'], 110, 0, 1, $item["img_server"]); } else { $item['image_src'] = ''; $item['image'] = ''; } $item['href'] = WEB_DIR . AZRewrite::formatUrl('?page=item_detail&id=' . $item['id'] . '&ebname=' . AZLib::safe_title($item['name'])); $item['edit'] = Url::build('post_item', array('cmd' => 'edit', 'id' => $item['id'])); if ($item['status'] == -1) { $item['del_link'] = Url::build_all(array('cmd', 'id'), 'cmd=del_forever&id=' . $item['id']); $item['re_post'] = Url::build_all(array('cmd', 'id'), 'cmd=re_post&id=' . $item['id']); } elseif ($item['status'] == 2) { $item['del_link'] = Url::build_all(array('cmd', 'id'), 'cmd=delete&id=' . $item['id']); $item['show_link'] = Url::build_all(array('cmd', 'id'), 'cmd=show&id=' . $item['id']); } else { $item['del_link'] = Url::build_all(array('cmd', 'id'), 'cmd=delete&id=' . $item['id']); $item['hide_link'] = Url::build_all(array('cmd', 'id'), 'cmd=hide&id=' . $item['id']); } $item['del_cache'] = Url::build_all(array('cmd', 'id'), 'cmd=del_cache&id=' . $item['id']); $items[$item['id']] = $item; } } $display->add('items', $items); $type_arr = array(1 => "-Sản phẩm không ẩn-", 2 => "-Sản phẩm ẩn-"); if (User::have_permit(ADMIN_DEL_ITEM)) { $type_arr[-1] = "-Sản phẩm đã xoá-"; $type_arr[9] = "-Tất cả các sản phẩm (Cả sản phẩm xóa)-"; } $option_censor = AZLib::getOption($type_arr, Url::get('censor', 1)); $display->add('censor', $censor); $display->add('option_censor', $option_censor); $display->add('have_img_option', $opt_have_img); $display->add('lock_checked', $lock_checked); $display->add('user_name', $user_name); $display->add('created_time', $time_from); $display->add('created_time_to', $time_to); $display->add('phrase_checked', $phrase_checked); $display->add('free_cat_checked', $free_cat_checked); $display->add('up_checked', $up_checked); $display->add('select_subcat_checked', $select_subcat_checked); $display->add('id_search', $id_search); $item_cat_search = $this->GetCatTree(); $display->add('list_top_cat_js', AZLib::getOption(AZLib::getTopCats(), 999999999)); $display->add('IS_ADMIN', User::is_admin()); $display->add('page_no', Url::get('page_no')); $display->add('paging', $pagging); $display->add('total_item', $total_item); $display->add('item_cat', AZLib::getOption($this->getOtionCats(), Url::get('id_cats'))); $display->add('category_tree', json_encode($item_cat_search)); $display->add('catSelected', Url::get('searchByCat', 0)); $display->add('catSelectedType', Url::get('searchByCatType', 0)); $display->add('subCatSelected', Url::get('searchBySubCat', 0)); $display->add('subCatSelectedType', Url::get('searchBySubCatType', 0)); $display->add('keywords', $keywords); $display->add('sort_type', $sort_type); $display->output('ManageItem'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, "POST", false, Url::build_current()); $key_word = Url::get('key_word'); $condition = " status=1"; $display->add('key_word', $key_word); if ($key_word) { $key_word_s = ''; $arr = explode(' ', $key_word); if ($arr) { foreach ($arr as $key) { $key = trim($key); if ($key != '') { $key_word_s .= ($key_word_s == '' ? '+' : ' +') . "{$key}"; } } } if ($key_word_s != '') { $condition .= " AND MATCH(title, des) AGAINST ('{$key_word_s}' IN BOOLEAN MODE)"; } //$condition .= ' AND (title LIKE "%'.$key_word.'%" OR des LIKE "%'.$key_word.'%")'; } $total_item = DB::count('document', $condition); $limit = ''; $paging = AZPagging::paging_list($limit, $total_item, 10, 10, 'page_no', '', true, 'Tài liệu', 'Trang'); $display->add('paging', $paging); $condition = 'WHERE' . $condition; $documents = array(); $sql = 'SELECT * FROM document ' . $condition . ' ORDER BY id DESC ' . $limit; $re = DB::query($sql); if ($re) { $i = 1; while ($row = mysql_fetch_assoc($re)) { $row['title'] = stripslashes($row['title']); $row['des'] = AZLib::remove_4_js(AZLib::plainText(html_entity_decode($row['des'], ENT_QUOTES, "UTF-8"))); $row['des'] = str_replace(array("'", "\""), array("", " "), $row['des']); $row['des'] = AZLib::word_limit($row['des'], 200, ''); if (++$i % 2) { $row['bgcolor'] = "#FFFFFF"; } else { $row['bgcolor'] = "#D9D9D9"; } $row['time_m'] = $row['time_m'] ? date("d/m/Y", $row['time_m']) : ''; if (User::is_admin()) { $row['change'] = AZLib::button(Url::build_current(array('cmd' => 'change', 'id' => $row['id'], "href" => urlencode(Url::build_all()))), 'style/images/unexam.gif', 'Disable'); $row['edit'] = AZLib::button(Url::build('document', array('cmd' => 'edit', 'id' => $row['id'], "href" => urlencode(Url::build_all()))), 'style/images/edit.gif', 'Sửa tài liệu'); $row['delete'] = AZLib::buttonDel(Url::build_current(array('cmd' => 'delete', 'id' => $row['id'], "href" => urlencode('?' . $_SERVER['QUERY_STRING']))), 'style/images/delete.gif', 'Sửa tài liệu'); } if ($row['url']) { $row['document_detail'] = $row['url']; } else { $row['document_detail'] = WEB_DIR . "download-{$row['id']}/" . AZLib::safe_title($row['title']) . ".html"; } $documents[$row['id']] = $row; } } $display->add('documents', $documents); if (User::is_admin()) { $display->add("is_admin", 1); } $display->output('DocumentList'); $this->endForm(); }
function draw() { global $display; $items = array(); $bcats = array(); $filter_groups = array(); if (Build::$bcatid) { $filter_ids = trim(DB::fetch("SELECT GROUP_CONCAT(filter_ids SEPARATOR ',') AS filter_ids FROM (SELECT filter_ids FROM item WHERE " . CGlobal::$item_condition . " AND filter_ids != '') AS filter", 'filter_ids', '')); $pf_array = array(); if ($filter_ids != '') { $f_array = array_count_values(explode(',', $filter_ids)); foreach ($f_array as $fid => $count) { if (isset(CGlobal::$allFilters[$fid])) { $fgid = CGlobal::$allFilters[$fid]['fgid']; if (isset(CGlobal::$all_gfilters[$fgid])) { $pf_array[$fgid][$fid] = $count; } } } } //Tạo Menu Filter if ($this->filter_groups) { foreach ($this->filter_groups as $fgid => $gfilter) { if (isset($pf_array[$fgid])) { if ($gfilter['filters']) { $group_filter = array(); foreach ($gfilter['filters'] as $fid => $filter) { if (isset($pf_array[$fgid][$fid])) { if (!$group_filter) { $group_filter = array('name' => CGlobal::$all_gfilters[$fgid]['name'], 'filters' => array()); } $link = AZRewrite::formatUrl(Url::build_all(array('min', 'max', 'filter', 'page_no'))); if ($this->filter_get) { foreach ($this->filter_get as $get_gid => $get_fid) { if ($get_gid != $fgid) { $link .= "&filter[{$get_gid}]={$get_fid}"; } } } if (isset($this->filter_get[$fgid]) && $this->filter_get[$fgid] == $filter['id']) { if ($this->min) { $link .= "&min=" . $this->min; } if ($this->max) { $link .= "&max=" . $this->max; } $group_filter['filters'] = array($fid => array('link' => $link, 'name' => $filter['name'], 'count' => $pf_array[$fgid][$fid], 'remove' => 1)); break; } else { $link .= "&filter[{$fgid}]={$filter['id']}"; //$link = str_replace(array('?filter=&','?filter=','&filter='),array('?','',''),$link); if ($this->min) { $link .= "&min=" . $this->min; } if ($this->max) { $link .= "&max=" . $this->max; } } $group_filter['filters'][$fid] = array('link' => $link, 'name' => $filter['name'], 'count' => $pf_array[$fgid][$fid]); } } if ($group_filter) { $filter_groups[$fgid] = $group_filter; } } } } } $display->add('url_filter', Url::build_current(array('mode', 'bcatid' => Build::$bcatid))); $display->add('cat_name', CGlobal::$allCategories[Build::$bcatid]['name']); if (isset(Build::$cats[Build::$bcatid]['next_id']) && Build::$cats[Build::$bcatid]['next_id']) { $display->add('next_url', Url::build_current(array('mode', 'bcatid' => Build::$cats[Build::$bcatid]['next_id']))); } else { $display->add('next_url', Url::build_current()); } $display->add('recomend', str_replace(chr(13) . chr(10), "<br />", CGlobal::$allCategories[Build::$bcatid]['recomend'])); $display->add('filter_groups', $filter_groups); $display->add('filter_price', $this->filter_price); $sql = 'SELECT * FROM item WHERE '; $where = ''; $sql .= CGlobal::$item_condition . " ORDER BY price ASC"; $total_row = DB::count("item", CGlobal::$item_condition); ####################################################################################### #Paging $filter_get = Url::get('filter'); $min = Url::get('min'); $max = Url::get('max'); $order = Url::get('order'); $paging = AZPagging::paging_list($limit, $total_row, 10, 10, 'page_no', '', true, 'Linh kiện', 'Trang'); $sql .= $limit; #Paging ####################################################################################### $re = DB::query($sql); if ($re) { while ($item = mysql_fetch_assoc($re)) { if (isset(CGlobal::$allCategories[$item['category_id']])) { $item['href'] = WEB_DIR . CGlobal::$allCategories[$item['category_id']]['nice_name'] . "/p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } else { $item['href'] = WEB_DIR . "p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } $item['price'] = AZLib::convertCurrency($item['price'], $item['currency_id']); if ($item['price']) { $item['price'] = number_format($item['price'], 0, ',', '.') . " VNĐ"; } else { $item['price'] = 'Liên hệ'; } if ($item['list_brief'] == '') { $item['list_brief'] = $item['brief']; } $item['list_brief'] = AZLib::remove_4_js(AZLib::plainText(AZLib::parseBBCode(html_entity_decode($item['list_brief'], ENT_QUOTES, "UTF-8")))); $item['list_brief'] = preg_replace("/\\[([\\s]*[0-9]{1,2}[\\s]*)\\]/eis", " ", $item['list_brief']); $item['list_brief'] = str_replace(array("'", "\""), array("", " "), $item['list_brief']); $item['list_brief'] = AZLib::word_limit($item['list_brief'], 50, ''); $item['select'] = Url::build_current(array('bcatid' => $item['category_id'], 'mode', 'item_id' => $item['id'])); $items[$item['id']] = $item; } } $display->add('items', $items); $display->add('paging', $paging); } $display->add('bcats', Build::$cats); if (Build::$price) { $display->add('total_price', number_format(Build::$price, 0, ',', '.') . " VNĐ"); } $display->add('bitems', Build::$items); $display->add('bcatid', Build::$bcatid); $display->add('cur_url', $_SERVER['REQUEST_URI']); $display->add("print_link", Url::open_popup(Url::build('build_print'), 1000, 800, false, false, false, false, false, 1, 1)); $build_catids = @CGlobal::$configs['BuildCatIDs']['conf_val']; $display->add('build_catids', $build_catids); $display->add('is_admin', User::is_admin()); $display->add('begin_form', $this->beginForm(false, 'post', false, false, 1)); $display->add('end_form', $this->endForm(1)); $display->output('Build'); }
function processItem($item, $admin_item) { if (isset(CGlobal::$allCategories[$item['category_id']])) { $item['href'] = WEB_DIR . CGlobal::$allCategories[$item['category_id']]['nice_name'] . "/p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } else { $item['href'] = WEB_DIR . "p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } $item['modify_time'] = date('H:i | d.m.y', $item['modify_time']); $item['price'] = AZLib::convertCurrency($item['price'], $item['currency_id']); $item['price_out'] = AZLib::convertCurrency($item['price_out'], $item['currency_id']); $item['currency_id'] = 1; $item['price_num'] = (int) $item['price']; if ($item['price']) { $item['price'] = number_format($item['price'], 0, ',', '.'); } else { $item['price'] = ''; } $item['price_title'] = 'Giá bán'; if ($item['price_out'] > 0) { $item['price_out'] = number_format($item['price_out'], 0, ',', '.') . ($item['currency_id'] == ' ' ? ' ' . CGlobal::$currency[$item['currency_id']] : ''); } else { $item['price_out'] = '0'; } //$item['price'] = AZLib::convertCurrency($item['price'], $item['currency_id']); //$item['price_out'] = AZLib::convertCurrency($item['price_out'], $item['currency_id']); if ($admin_item) { $item['description'] = AZLib::remove_4_js(AZLib::plainText(AZLib::parseBBCode(html_entity_decode($item['description'], ENT_QUOTES, "UTF-8")))); $item['description'] = preg_replace("/\\[([\\s]*[0-9]{1,2}[\\s]*)\\]/eis", " ", $item['description']); $item['description'] = str_replace(array("'", "\""), array("", " "), $item['description']); $item['description'] = AZLib::word_limit($item['description'], 200, ''); } $item['name'] = AZLib::filter_title($item['name']); if ($item['img_url']) { $item['img_thumb_wl'] = AZLib::getImageThumb($item['img_url'], 180, 0, 1, $item['img_server']); } else { $item['img_url'] = ''; } if (!CGlobal::$curLevel2Cat) { if (isset(CGlobal::$allCategories[$item['category_id']])) { $item['cat_name'] = CGlobal::$allCategories[$item['category_id']]['name']; } else { $item['cat_name'] = "ID: {$item['category_id']}"; } } return $item; }
function load_shop_label() { if (!CGlobal::$user_profile) { User::check_get_user(); } if (CGlobal::$user_profile) { $mode_default = 'comment'; if (!CGlobal::$shop_setting) { if (CGlobal::$user_profile['shop_setting']) { CGlobal::$shop_setting = unserialize(stripslashes(CGlobal::$user_profile['shop_setting'])); } if (!CGlobal::$shop_setting) { CGlobal::$shop_setting = array('shop_name' => CGlobal::$user_profile['full_name'] ? CGlobal::$user_profile['full_name'] : CGlobal::$user_profile['user_name'], 'default_mode' => 1, 'default_layout' => 1, 'item_list_mode' => 0, 'adv_banner' => ''); } } if (CGlobal::$shop_setting && !isset(CGlobal::$shop_setting['default_layout'])) { CGlobal::$shop_setting['default_layout'] = 1; } if (Url::get("mode") == "comment" || CGlobal::$shop_setting['default_mode'] == 2) { CGlobal::$website_title = 'Lưu bút - Shop ' . CGlobal::$user_profile['user_name']; } if (!CGlobal::$shop_setting['default_mode']) { if (Url::get('mode') == 'shop' || DB::select('item', 'user_id=' . CGlobal::$user_profile['id'] . ' AND status=1')) { //Nếu có sp, mặc định là vào shop CGlobal::$shop_setting['default_mode'] = 1; $mode_default = 'shop'; } else { //Nếu ko có sản phẩm, mặc định vào lưu bút CGlobal::$shop_setting['default_mode'] = 2; $mode_default = 'comment'; } } else { if (CGlobal::$shop_setting['default_mode'] == 1) { $mode_default = 'shop'; } else { $mode_default = 'comment'; } } } if (CGlobal::$shop_label) { CGlobal::$website_title .= ' | ' . CGlobal::$shop_label['name']; $this->label_id = CGlobal::$shop_label['id']; } else { $this->label_id = (int) Url::get('label_id', 0); if ($this->label_id) { CGlobal::$shop_label = DB::select("label", "id=" . $this->label_id); } if (!CGlobal::$shop_label) { $this->label_id = 0; } } $page_shop_item = (int) Url::get('page_shop_item', 1); $label_id = (int) Url::get("label_id", 0); $list_type = (int) Url::get("list_type", 0); global $display; $display->add('top_level_id', $label_id); $display->add('list_type', $list_type); $display->add('can_edit', User::have_permit(ADMIN_ITEM) || User::id() == CGlobal::$user_profile['id']); $status_check = User::id() == CGlobal::$user_profile['id'] || User::have_permit(ADMIN_ITEM) ? ' status IN(0,1,2,3,4,5)' : ' status =1'; if ($label_id) { $total_item = DB::fetch('SELECT count(*) AS total_row FROM label_item AS L JOIN item AS I ON L.item_id=I.id AND I.' . $status_check . ' AND I.user_id=' . CGlobal::$user_profile['id'] . ' WHERE L.user_id=' . CGlobal::$user_profile['id'] . ' AND L.label_id=' . $label_id, 'total_row', 0); } else { $total_item = DB::fetch('SELECT count(*) AS total_row FROM item WHERE ' . $status_check . ' AND user_id=' . CGlobal::$user_profile['id'], 'total_row', 0); } $pagging = ''; $items = array(); $divID = 'shop_item'; $item_per_page = 0; if ($total_item) { $item_per_page = 9; $limit = ''; $url_path = WEB_DIR . 'ajax.php?act=shop&code=load_shop_label&user_id=' . CGlobal::$user_profile['id'] . '&label_id=' . $label_id . (!$list_type ? '' : '&list_type=' . $list_type); $pagging = AZPagging::AjaxPaging($limit, $total_item, $item_per_page, 5, 'page_shop_item', '', false, false, $url_path, $divID, true); if ($label_id) { $display->add('label_name', CGlobal::$shop_label['name']); $select = 'SELECT I.id, I.name,I.sapo, I.user_name, I.user_id,I.description,I.category_id, I.read_count, I.reply_count, I.currency_id, I.price, I.province_id, I.up_time,I.price_out, I.brief, I.img_url, I.status, I.state, I.img_server FROM label_item AS L JOIN item AS I ON L.item_id=I.id AND I.' . $status_check . ' AND I.user_id=' . CGlobal::$user_profile['id'] . ' WHERE L.user_id=' . CGlobal::$user_profile['id'] . ' AND L.label_id=' . $label_id . ' ORDER BY shop_order, up_time DESC' . $limit; } else { $select = 'SELECT id, name, sapo, user_name, user_id, description, category_id, read_count, reply_count, currency_id, price, brief, img_url, province_id, up_time, price_out, status, state, img_server,sticky FROM item WHERE ' . $status_check . ' AND user_id=' . CGlobal::$user_profile['id'] . ' ORDER BY shop_order, up_time DESC' . $limit; } $re = DB::query($select); if (User::is_login()) { $wids = User::get_wishlist('wish_list_items'); $w_items = array(); if ($wids) { $w_items = explode(',', $wids); } } if ($re) { AZLib::getProvinces(); AZLib::getCats(); $item_ids = ''; while ($item = mysql_fetch_assoc($re)) { $item['price'] = AZLib::convertCurrency($item['price'], $item['currency_id']); $item['price_out'] = AZLib::convertCurrency($item['price_out'], $item['currency_id']); $item['currency_id'] = 1; if ($item['img_url']) { $item['image_url'] = AZLib::getImageThumb($item['img_url'], 200, 200, 0, $item['img_server']); } if (isset(CGlobal::$allCategories[$item['category_id']])) { $item['href'] = WEB_DIR . AZRewrite::formatUrl('?page=item_detail&id=' . $item['id'] . '&ebname=' . AZLib::safe_title(AZLib::word_limit($item['name'], 12, '')) . '&nice_name=' . CGlobal::$allCategories[$item['category_id']]['nice_name']); } else { $item['href'] = WEB_DIR . AZRewrite::formatUrl('?page=item_detail&id=' . $item['id'] . '&ebname=' . AZLib::safe_title(AZLib::word_limit($item['name'], 12, ''))); } $tooltip = ''; $tooltip .= 'Xem: ' . $item['read_count'] . ' - Phản hồi: ' . $item['reply_count']; $item['time_label'] = ''; $up_time = date('H:i | ', $item['up_time']); if (date('d.m.y', $item['up_time']) == date('d.m.y', TIME_NOW)) { $up_time .= '<font color="green">Hôm nay</font>'; } else { $up_time .= date('d.m.y', $item['up_time']); } //$item['created_time'] = 'đăng '.AZLib::duration_time($item['up_time']); $item['created_time'] = $up_time; if ($item['price']) { $item['price'] = number_format($item['price'], 0, ',', '.'); $item['currency_id'] = CGlobal::$currency[$item['currency_id']]; } else { $item['price'] = ''; $item['currency_id'] = ''; } $item['price_title'] = 'Giá bán'; if ($item['price_out'] > 0) { $item['price_out'] = number_format($item['price_out'], 0, ',', '.') . ($item['currency_id'] == ' ' ? ' ' . CGlobal::$currency[$item['currency_id']] : ''); } else { $item['price_out'] = '0'; } $item['no_base_source'] = AZLib::remove_4_js(str_replace(array("<br>", "<br />"), '', $item['brief'])); $item['description'] = AZLib::plainText(AZLib::parseBBCode(html_entity_decode($item['description'], ENT_QUOTES, "UTF-8"))); $item['description'] = preg_replace("/\\[([\\s]*[0-9]{1,2}[\\s]*)\\]/eis", " ", $item['description']); $item['description'] = str_replace(array("'", "\""), array("", " "), $item['description']); $item['description'] = AZLib::word_limit($item['description'], 250, ''); /* if($item['sapo']!=''){ $item['brief'] = $item['sapo']; $item['brief'] = AZLib::subString(AZLib::filter_title($item['brief']),0,255,true); $item['brief'] = AZLib::word_limit($item['brief'],30,''); } else{ $item['brief'] = String::display_sort_title($item['description'],30); } */ $item['brief'] = ''; $item['parent_name'] = ''; if (isset(CGlobal::$allCategories[$item['category_id']]) && CGlobal::$allCategories[$item['category_id']]['parent_id']) { $parent_id = CGlobal::$allCategories[$item['category_id']]['parent_id']; if (isset(CGlobal::$allCategories[$parent_id])) { $item['parent_name'] = CGlobal::$allCategories[$parent_id]['name'] . ' - '; } } if (isset(CGlobal::$allCategories[$item['category_id']]['name'])) { $item['category_name'] = $item['parent_name'] . CGlobal::$allCategories[$item['category_id']]['name']; } else { $item['category'] = ''; $item['category_name'] = ''; } $item['safe_title'] = AZLib::safe_title($item['parent_name'] . $item['category_name']); $item['category_href'] = WEB_DIR . AZRewrite::formatUrl('?page=list_detail&category_id=' . $item['category_id'] . '&ebname=' . $item['safe_title']); $item['name'] = AZLib::subString(AZLib::filter_title($item['name']), 0, 115, true); $item['name'] = AZLib::word_limit($item['name'], 12, ''); $item['user_name'] = $item['user_name']; $item['profile_url'] = WEB_DIR . $item['user_name']; $item['city'] = CGlobal::$provinces[$item['province_id']]['name']; if ($item['img_url']) { $item['img_url'] = AZLib::getImageThumb($item['img_url'], 110, 0, 1, $item['img_server']); } else { $item['img_url'] = 'style/images/no-images-69x53.jpg'; } if (isset($_GET['ebname'])) { $item['up_url'] = Url::build_current(array('action' => 'up', 'id' => $item['id'], 'category_id' => CGlobal::$curCategory, 'type' => Url::get('type'), 'ebname' => $_GET['ebname'])); $item['down_url'] = Url::build_current(array('action' => 'down', 'id' => $item['id'], 'category_id' => CGlobal::$curCategory, 'type' => Url::get('type'), 'ebname' => $_GET['ebname'])); } else { $item['up_url'] = Url::build_current(array('action' => 'up', 'id' => $item['id'], 'category_id' => CGlobal::$curCategory, 'type' => Url::get('type'))); $item['down_url'] = Url::build_current(array('action' => 'down', 'id' => $item['id'], 'category_id' => CGlobal::$curCategory, 'type' => Url::get('type'))); } $item['in_wish_list'] = false; if (User::is_login()) { if (in_array($item['id'], $w_items)) { $item['in_wish_list'] = true; } else { $item['in_wish_list'] = false; } } else { if (isset($_COOKIE['wish_list_item_ids'])) { $arr = explode(',', $_COOKIE['wish_list_item_ids']); foreach ($arr as $k => $v) { if ($v == $item['id']) { $item['in_wish_list'] = true; } } } } if (CGlobal::$user_profile['id'] == User::id()) { $tooltip .= ' - <strong>ID tin: ' . $item['id'] . '</strong>'; } $item['invalid'] = ''; if ($item['status'] == 2) { $tooltip .= '<div style=\\\'color:red\\\'>(Đang kiểm duyệt)</div>'; $item['invalid'] = '<font color="red">(Đang kiểm duyệt)</font>'; } elseif ($item['status'] == 3) { $tooltip .= '<div style=\\\'color:red\\\'>(Tin theo dõi lừa đảo)</div>'; $item['invalid'] = '<font color="red">(Theo dõi lừa đảo)</font>'; } elseif ($item['status'] == 0) { $tooltip .= '<div style=\\\'color:red\\\'>(Đang ẩn)</div>'; $item['invalid'] = '<font color="red">(Đang ẩn)</font>'; } elseif ($item['status'] == 5) { $tooltip .= '<div style=\\\'color:red\\\'>(Đang kiểm duyệt chờ chứng thực)</div>'; $item['invalid'] = '<font color="red">(KD chờ chứng thực)</font>'; } elseif ($item['status'] == 4) { $tooltip .= '<div style=\\\'color:red\\\'>(Tin trùng)</div>'; $item['invalid'] = '<font color="red">(Tin trùng)</font>'; } elseif ($item['state'] == 1) { $tooltip .= '<div style=\\\'color:red\\\'>(Đang khóa)</div>'; $item['invalid'] = '<font color="red">(Đang khóa)</font>'; } $item['tooltip'] = $tooltip; $item['lids'] = ''; $item_ids .= ($item_ids != '' ? ',' : '') . $item['id']; $items[$item['id']] = $item; } } if ($item_ids) { $item_labels = array(); //Label của tất cả sp đang đc hiển thị $re = DB::query("SELECT id, label_id, item_id FROM label_item WHERE item_id IN({$item_ids})"); if ($re) { while ($l_item = mysql_fetch_assoc($re)) { if (isset($items[$l_item['item_id']])) { $items[$l_item['item_id']]['lids'] .= ($items[$l_item['item_id']]['lids'] != '' ? ',' : '') . $l_item['label_id']; } } } } } $display->add('loading_ajax', true); $display->add('is_admin', (int) User::have_permit(ADMIN_ITEM)); $display->add('cur_id', (int) User::id()); $display->add('total_sp', (int) $total_item); $display->add('items', $items); $display->add('paging', $pagging); $display->add('item_per_page', $item_per_page); $display->add('page_num', $page_shop_item); $display->add('shop_user_id', CGlobal::$user_profile['id']); $display->add('shop_user_name', CGlobal::$user_profile['user_name']); $display->output($list_type != 1 ? 'ShopItem' : 'ShopItemListDetail', false, 'Shop'); }