function draw() { global $display; $this->beginForm(false, "POST", false, Url::build_current()); //search theo ngay thang nam $display->add('created_time_from', Url::get('created_time_from')); $display->add('created_time_to', Url::get('created_time_to')); $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 = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0); } } 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 = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1); } } $search_value = 1; $last_log = (int) Url::get('last_log'); if ($last_log) { if ($created_time_from) { $search_value .= ' AND last_login >= ' . $created_time_from; } if ($created_time_to) { $search_value .= ' AND last_login <= ' . $created_time_to; } } else { if ($created_time_from) { $search_value .= ' AND create_time >= ' . $created_time_from; } if ($created_time_to) { $search_value .= ' AND create_time <= ' . $created_time_to; } } $display->add('last_log', $last_log); if (Url::get('active') == 1) { $search_value .= ' AND (is_active=1)'; $display->add('active_checked', 'checked'); } else { $display->add('active_checked', ''); } if (Url::get('tracking') == 1) { $search_value .= ' AND (tracking=1)'; $display->add('tracking_checked', 'checked'); } else { $display->add('tracking_checked', ''); } if (Url::get('invalid') == 1) { $search_value .= ' AND (invalid_time > 0 OR invalid_time = -1)'; $order_by = ' ORDER BY invalid_time DESC '; $display->add('invalid_checked', 'checked'); } else { //$search_value .= ' AND invalid_time = 0'; $order_by = ' ORDER BY id DESC '; $display->add('invalid_checked', ''); } if (Url::get('block') == 1) { $search_value .= ' AND (block_time >= ' . TIME_NOW . ' OR block_time = -1)'; $order_by = ' ORDER BY block_time DESC '; $display->add('block_checked', 'checked'); } else { //$search_value .= ' AND block_time!=-1 AND block_time <= '.TIME_NOW; $display->add('block_checked', ''); } $od_by = Url::get('order_by'); $od_dir = Url::get('order_dir', 'DESC'); if ($od_by == 'name') { $order_by = ' ORDER BY user_name ' . $od_dir; } elseif ($od_by == 'id') { $order_by = ' ORDER BY id ' . $od_dir; } elseif ($od_by == 'time') { $order_by = ' ORDER BY create_time ' . $od_dir; } elseif ($last_log) { $order_by = ' ORDER BY last_login ' . $od_dir; } if (Url::get('ava')) { $search_value .= ' AND avatar_url != ""'; $display->add('ava_checked', 'checked'); } else { $display->add('ava_checked', ''); } // search ô textbox ID $id_search = (int) Url::get('id_search', 0); if ($id_search) { $search_value .= ' AND id=' . $id_search; } if ($id_search == 0) { $id_search = ''; } $display->add('id_search', $id_search); // search ô textbox tài khoản if (Url::get('text_value') != '') { $text_value = trim(Url::get('text_value')); $display->add('text_value', $text_value); $str_search = str_replace("'", '"', $text_value); $str_search = str_replace("'", '"', $str_search); $str_search = str_replace(""", '"', $str_search); $s_user = User::getByUserName($str_search, true); if ($s_user) { $search_value .= " AND id='{$s_user['id']}' "; } else { $search_value .= " AND 0 "; } } $cid = 0; if (Url::get('cid') != 0) { $cid = trim(Url::get('cid')); $search_value .= ' AND (CONCAT(",", class_id, ",") LIKE "%,' . $cid . ',%") '; } $display->add('id_phone', Url::get('id_phone')); $item_per_page = Url::get('item_per_page', 50); $sql_count = 'SELECT COUNT(id) AS total_item FROM account WHERE ' . $search_value; $total = DB::fetch($sql_count, 'total_item', 0); $items = array(); $str_id = ''; $uids = ''; if ($total) { $limit = ''; require_once ROOT_PATH . 'core/ECPagging.php'; $paging = ECPagging::pagingSE($limit, $total, $item_per_page, 10, 'page_no', true, 'Thành viên', 'Trang'); $sql = 'SELECT * FROM account WHERE ' . $search_value . ' ' . $order_by . $limit; $result = DB::query($sql); if ($result) { while ($row = mysql_fetch_assoc($result)) { $row['create_time'] = date('d/m/y H:i', $row['create_time']); if ($row['last_login']) { $row['last_login'] = date('d/m/y H:i', $row['last_login']); } else { $row['last_login'] = false; } if ($row['block_time'] > TIME_NOW || $row['block_time'] == -1) { if ($row['block_time'] != -1) { $row['status'] = "<font color=red><b>" . date('H:i d/m/y', $row['block_time']) . '</b></font>'; } else { $row['status'] = '<font color=red><b>Khóa vĩnh viễn</b></font>'; } $row['bgcolor'] = 'bgcolor="#CCCCCC"'; $row['is_block'] = true; $display->add('type_reason', 'Khóa'); } else { $row['status'] = ""; $row['bgcolor'] = ''; $row['is_block'] = false; } $row['gender'] = ''; $row['unban_nick'] = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'cmd=unban_nick&id=' . $row['id']); if (User::is_root()) { $row['del_link'] = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'cmd=del_user&id=' . $row['id']); } $row['detail'] = Url::build_current(array('cmd' => 'edit', 'id' => $row['id'])); $row['openids'] = array(); $row['del_cache'] = Url::build_all(array('cmd', 'id'), 'cmd=del_cache&id=' . $row['id']); $uids .= ($uids ? ',' : '') . $row['id']; $items[$row['id']] = $row; } } } else { $paging = ''; } // // if($uids){ // $re = DB::query("SELECT openid_url,user_id FROM openid WHERE user_id IN($uids)"); // // if($re){ // while ($oid = mysql_fetch_assoc($re)) { // $items[$oid['user_id']]['openids'][] = $oid['openid_url']; // } // } // } //lay ly do khoa nicks hoac kiem duyet nick $arr_reason = array(); if ($str_id) { $where = ''; if (Url::get('block') == 1) { $where = ' AND type IN (0,1) '; } else { if (Url::get('invalid') == 1) { $where = ' AND type = 2 '; } } $sql = 'SELECT user_id, time, note, type,admin_id, admin_name FROM acc_lock WHERE user_id IN(' . $str_id . ') ' . $where . ' ORDER BY id ASC'; $result = DB::query($sql); while ($row = mysql_fetch_assoc($result)) { $arr_reason[$row['user_id']] = $row; } } foreach ($items as $value) { if (isset($arr_reason[$value['id']]['user_id']) && $value['id'] == $arr_reason[$value['id']]['user_id']) { $items[$value['id']]['lock_reason'] = EClassApi::filter_title($arr_reason[$value['id']]['note']); $items[$value['id']]['lock_type'] = $arr_reason[$value['id']]['type']; $items[$value['id']]['time_lock'] = date("d/m/y H:i", $arr_reason[$value['id']]['time']); $items[$value['id']]['create_time_lock'] = $arr_reason[$value['id']]['time']; $items[$value['id']]['admin_name'] = $arr_reason[$value['id']]['admin_name']; } else { $items[$value['id']]['lock_reason'] = ''; $items[$value['id']]['lock_type'] = ''; $items[$value['id']]['time_lock'] = ''; $items[$value['id']]['create_time_lock'] = 0; $items[$value['id']]['admin_name'] = ''; } } //end lay ly do khoa nick if ($od_dir == 'ASC') { $od_dir = 'DESC'; } else { $od_dir = 'ASC'; } $href_id = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'order_by=id&order_dir=' . $od_dir); $href_name = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'order_by=name&order_dir=' . $od_dir); $href_up = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'order_by=up&order_dir=' . $od_dir); $href_time = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'order_by=time&order_dir=' . $od_dir); $img_id = '<img src="style/images/admin/downarrow.png" alt="">'; //default $img_name = ''; $img_up = ''; $img_time = ''; if ($od_by == 'id') { $img_id = '<img src="style/images/admin/' . ($od_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } if ($od_by == 'name') { $img_name = '<img src="style/images/admin/' . ($od_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; $img_id = ''; } if ($od_by == 'up') { $img_up = '<img src="style/images/admin/' . ($od_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; $img_id = ''; } if ($od_by == 'time') { $img_time = '<img src="style/images/admin/' . ($od_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; $img_id = ''; } // neu show cac thanh vien bi khoa, se sap xep theo thoi diem khoa hien tai giam dan if (Url::get('block') == 1) { usort($items, array("ListUserAdminForm", "cmp")); } $display->add('img_id', $img_id); $display->add('img_name', $img_name); $display->add('img_up', $img_up); $display->add('img_time', $img_time); $display->add('href_id', $href_id); $display->add('href_name', $href_name); $display->add('href_up', $href_up); $display->add('href_time', $href_time); $display->add('total_account', $total); $display->add('limit_date', BAN_NICK_DATE); $display->add('items', $items); $display->add('cid', $cid); //System::debug($items); $display->add('paging', $paging); $display->add('is_root', User::is_root()); $display->output('list'); $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 getNoteItem() { if (!User::is_login()) { $json['msg'] = 'no_login'; die(json_encode($json)); } $userId = User::id(); $select = 'SELECT id,img_id,item_name,img_server,item_url,img_url,user_id,item_price FROM img_save'; $where = ' WHERE user_id = ' . $userId; $order_by = ' ORDER BY id DESC'; $limit = ' LIMIT 6 '; $sql = $select . $where . $order_by . $limit; $items = array(); $re = DB::query($sql); if ($re) { $noteItem = array(); while ($item = mysql_fetch_assoc($re)) { $item['price'] = $item['item_price']; $item['title'] = EClassApi::subString(EClassApi::filter_title($item['item_name']), 0, 40, true); $item['des'] = EClassApi::subString(EClassApi::filter_title($item['item_name']), 0, 42, true); /*$item['name'] = EClassApi::word_limit($item['name'],12,'');*/ $item['img56'] = $item['img_url'] ? EClassApi::getImageThumb($item['img_url'], 56, 56, 0, $item['img_server']) : 'style/images/no-images-69x53.jpg'; $item['href'] = $item['item_url']; $noteItem[] = $item; } $json['msg'] = 'success'; $json['data'] = $noteItem; die(json_encode($json)); } }