function draw() { global $display; $this->beginForm(); $display->add('url_admin', Url::build_current()); $display->add('msg', $this->showFormErrorMessages(1)); if ($this->contact['name']) { $email = stripslashes($this->contact['name']) . " "; } if ($this->contact['address']) { $email .= "( " . stripslashes($this->contact['address']) . ") "; } $email .= '<a href="mailto:' . $this->contact['email'] . '"><font color=blue>' . $this->contact['email'] . "</font></a>"; $display->add('email', $email); $display->add('date', date('H:i:s d/m/Y', $this->contact['time'])); $display->add('date2', AZLib::duration_time($this->contact['time'])); $display->add('content', stripslashes($this->contact['content'])); $display->add('reply_content', stripslashes(Url::get('reply_content'))); $display->add('subject', stripslashes(Url::get('subject'))); if ($this->contact['reply_content']) { $display->add('replied_content', stripslashes($this->contact['reply_content'])); } else { $display->add('replied_content', "Chưa có"); } $display->output('FeedbackReply'); $this->endForm(); }
function draw() { global $display; $cmd = Url::get('cmd'); $display->add('id_survey', $this->public_survey['id']); $display->add('title', stripslashes($this->public_survey['title'])); $display->add('question', stripslashes($this->public_survey['question'])); $display->add('url_edit', Url::build('admin_survey', array('cmd' => 'edit', 'id_survey' => $this->public_survey['id']))); $opts = DB::fetch_all('SELECT * FROM `public_survey_opinion` WHERE `id_survey`=' . $this->public_survey['id']); $i = 0; foreach ($opts as &$opt) { $i++; $opt['num'] = $i; $opt['edit'] = Url::build_current(array('id_survey' => Url::get('id_survey', 'int', 0), 'cmd' => 'edit', 'id' => $opt['id'])); $opt['del'] = Url::build_current(array('id_survey' => Url::get('id_survey', 'int', 0), 'cmd' => 'delete', 'id' => $opt['id'])); } $display->add('opts', $opts); if ($cmd == 'edit') { $public_survey_opinion = DB::select('public_survey_opinion', 'id=' . Url::get('id', 0)); if ($public_survey_opinion) { $display->add('value', $public_survey_opinion['option']); $display->add('option_id', $public_survey_opinion['id']); } } $this->beginForm(); $display->output('PublicSurveyOption'); $this->endForm(); }
function draw() { if (!User::is_admin()) { return; } $this->beginForm(false, 'get', false, Url::build_current()); global $display; $name = trim(Url::get('user_name')); $request_gid = trim(Url::get('gids')); $cond = ''; if ($name != '') { $cond .= ' AND user_name LIKE "%' . $name . '%"'; } if ($request_gid != '') { $cond .= " AND ((gids LIKE '%|" . $request_gid . "|%') OR (gids LIKE '" . $request_gid . "|%') OR (gids LIKE '%|" . $request_gid . "') OR (gids = '" . $request_gid . "')) "; } $acc_groups = CGlobal::$group; //$user_permits=array(); $all_users = array(); //$allist_users=array(); self::getContent($acc_groups, $all_users, $cond); $display->add('all_groups', json_encode($acc_groups)); $display->add('acc_groups', $acc_groups); $display->add('all_users', $all_users); $display->add('all_users_json', json_encode($all_users)); $display->add('name', $name); $display->add('request_gid', $request_gid); $display->output('AdminUser'); $this->endForm(); }
function draw() { global $display; $cats = array(); $display->add('url_add', Url::build_current(array('cmd' => 'add'))); /* $display->add('url_edit',Url::build_current(array('cmd'=>'edit','id'=>$category['id']))); $display->add('url_del',Url::build_current(array('cmd'=>'delete','id'=>$category['id']))); $display->add('url_sort_up',Url::build_current(array('cmd'=>'move_home','dir'=>'move_home','id'=>$category['id']))); $display->add('url_sort_low',Url::build_current(array('cmd'=>'move_home','dir'=>'move_end','id'=>$category['id']))); */ $posMin = 1; $posMax = DB::count("news_categories"); $re = DB::query('SELECT * FROM news_categories ORDER BY position, id'); if ($re) { $index = 0; $column = 1; while ($row = mysql_fetch_assoc($re)) { $row['url'] = URL::build('news_list', array('news_catid' => $row['id'], 'azname' => AZLib::safe_title($row['name']))); $row['edit'] = Url::build_current(array('cmd' => 'edit', 'id' => $row['id'])); $row['delete'] = Url::build_current(array('cmd' => 'delete', 'id' => $row['id'])); $row['move_home'] = '<a title="Chuyển lên trên cùng" href="' . Url::build_current(array('cmd' => 'move_home', 'id' => $row['id'])) . '">Move HOME</a>'; $row['move_end'] = '<a title="Chuyển xuống dưới cùng" href="' . Url::build_current(array('cmd' => 'move_end', 'id' => $row['id'])) . '">Move END</a>'; if ($row['position'] > $posMin) { $row['move_up'] = '<a title="Chuyển lên" href="' . Url::build_current(array('cmd' => 'move_up', 'id' => $row['id'])) . '"><img src="style/img/admin/move_up.gif"></a>'; } if ($row['position'] < $posMax) { $row['move_down'] = '<a title="Chuyển xuống" href="' . Url::build_current(array('cmd' => 'move_down', 'id' => $row['id'])) . '"><img src="style/img/admin/move_down.gif"></a>'; } $cats[$row['id']] = $row; } } $display->add('cats', $cats); $display->output("NewsAdminCats"); }
function draw() { global $display; $this->beginForm(false, "post", false, Url::build_current()); $item_per_page = 30; $total_row = DB::fetch('SELECT count(*) AS total_row FROM `province` limit 0,1', 'total_row', 0); $paging = ''; $items = array(); if ($total_row) { $limit = ''; $paging = AZPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $sql = "SELECT * FROM province ORDER BY id " . $limit; $re = DB::query($sql); if ($re) { while ($row = mysql_fetch_assoc($re)) { $area = array(1 => 'Bắc', 2 => 'Trung', 3 => 'Nam'); $status = array('SHOW' => 'Hiện', 'HIDE' => '<font color=red>Ẩn</font>', 'HOME' => 'HOME'); $row['area'] = $area[$row['area']]; $row['status'] = $status[$row['status']]; $items[$row['id']] = $row; $items[$row['id']] = $row; } } } $display->add('hover', AZLib::mouse_hover('#F7F7F7', true)); $display->add('items', $items); $display->add('paging', $paging); $display->add('total_row', $total_row); $display->output('list'); $this->endForm(); }
function draw() { global $display; $this->beginForm(); $all_zone_cats = array(); $re = DB::query("SELECT c.id, z.zoneid, c.name , c.status FROM (SELECT zoneid, catid FROM category_zone_cat) AS z LEFT JOIN category AS c ON c.id=z.catid ORDER BY position"); if ($re) { while ($cat = mysql_fetch_assoc($re)) { if ($cat['status'] == 'HOME') { $cat['name'] .= ' (HOME)'; } elseif ($cat['status'] == 'HIDE') { $cat['name'] .= ' (HIDE)'; } $cat['link'] = Url::build_current(array('cmd' => 'edit', 'id' => $cat['id'])); $all_zone_cats[$cat['zoneid']][$cat['id']] = $cat; } } $sql = "SELECT * FROM category_zone ORDER BY position"; $re = DB::query($sql); $items = array(); $sub_items = array(); if ($re) { $last_id = 0; while ($row = mysql_fetch_assoc($re)) { if (isset($all_zone_cats[$row['id']])) { $row['cats_total'] = count($all_zone_cats[$row['id']]); $row['cats'] = $all_zone_cats[$row['id']]; } else { $row['cats_total'] = 0; $row['cats'] = array(); } $row['edit_link'] = Url::build_current(array('mod', 'cmd' => 'edit', 'id' => $row['id'])); if ($row['status'] == 1) { $row['status'] = '<b>Hiện</b> [ <a href="' . Url::build_current(array('mod', 'cmd' => 'hide', 'id' => $row['id'])) . '">Ẩn</a> ]'; } elseif ($row['status'] == 0) { $row['status'] = '<b>Ẩn</b> [ <a href="' . Url::build_current(array('mod', 'cmd' => 'show', 'id' => $row['id'])) . '">Hiện</a> ]'; } //Top cat if (!isset($sub_items[$row['id']])) { $sub_items[$row['id']] = array(); } if ($last_id) { $items[$last_id]['down'] = '<a href="' . Url::build_current(array('mod', 'cmd' => 'move_down', 'id' => $last_id)) . '"><img src="style/images/admin/down_arrow_.gif" /></a>'; $row['up'] = '<a href="' . Url::build_current(array('mod', 'cmd' => 'move_up', 'id' => $row['id'])) . '"><img src="style/images/admin/up_arrow_.gif" /></a>'; } else { $row['up'] = ''; } $row['down'] = ''; $items[$row['id']] = $row; $last_id = $row['id']; } if ($last_id && $items[$last_id]['position'] > 1) { $items[$last_id]['up'] = '<a href="' . Url::build_current(array('mod', 'cmd' => 'move_up', 'id' => $last_id)) . '"><img src="style/images/admin/up_arrow_.gif" /></a>'; } } $display->add('items', $items); $display->add('hover', ''); $display->output('zone_list'); $this->endForm(); }
function draw() { global $display; $display->add('msg', $this->showFormErrorMessages(1)); $display->add("url_admin", Url::build_current()); $status_select = Url::get('status_select', 6); //1:Chưa cập nhật; 2: Đã gửi đơn hàng ; 3: Đã TT; 4: Hủy đơn hàng; 5: Đã duyệt $status_arr = array(6 => "--Tất cả--", 2 => "Đã gửi đơn hàng", 1 => "Chưa cập nhật", 3 => "Đã Thanh toán", 5 => "Đã duyệt", 4 => "Đã hủy"); $display->add("status_option", AZLib::getOption($status_arr, $status_select)); $date_begin = Url::get('date_begin'); $date_end = Url::get('date_end'); $display->add("date_begin", $date_begin); $display->add("date_end", $date_end); $created_time_from = 0; $created_time_to = 0; if ($date_begin) { $date_arr = explode("-", $date_begin); 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 ($date_end) { $date_arr = explode("-", $date_end); 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]); } } $condition = ""; if ($status_select != 6) { $condition .= "status=" . $status_select; } if ($created_time_from) { $condition .= ($condition != '' ? ' AND ' : '') . ' time_create >=' . $created_time_from; } if ($date_end) { $condition .= ($condition != '' ? ' AND ' : '') . " time_create <={$created_time_to}"; } $total = DB::count("cart", $condition); $limit = ''; $display->add('paging', AZPagging::paging_list($limit, $total, 40, 10, 'page_no', '', true, 'Đơn hàng')); $all_carts = array(); $re = DB::query("SELECT * FROM cart " . ($condition != '' ? 'WHERE ' : '') . $condition . " ORDER BY id DESC {$limit}"); if ($re) { while ($Cart = mysql_fetch_assoc($re)) { $Cart["time_create"] = date('d/m/Y H:i:s', $Cart['time_create']); $Cart["time_change"] = date('d/m/Y H:i:s', $Cart['time_change']); $Cart["url"] = Url::build_current(array('cmd' => 'edit', 'id' => $Cart['id'])); $Cart["status"] = $status_arr[$Cart['status']]; $Cart["delete"] = Url::build_current(array('cmd' => 'delete', 'id' => $Cart['id'])); $Cart["price"] = number_format($Cart['price'], null, null, '.'); $all_carts[$Cart['id']] = $Cart; } } $display->add('all_carts', $all_carts); $display->add('is_admin', User::is_admin()); $this->beginForm(); $display->output('CartAdmin'); $this->endForm(); }
function on_submit() { $all_modules = array(); $re = DB::query('SELECT id, name FROM module ORDER BY name'); if ($re) { while ($module = mysql_fetch_assoc($re)) { $all_modules[strtolower($module['name'])] = $module; } } $module_dirs = scandir(DIR_MODULE); unset($module_dirs[0]); unset($module_dirs[1]); if ($module_dirs) { $i = 1; foreach ($module_dirs as $module_dir) { if (is_dir(DIR_MODULE . $module_dir) && !isset($all_modules[strtolower($module_dir)])) { $arr = array('name' => $module_dir); if ($this->update) { $id = DB::insert('module', $arr); if ($id) { $this->list_scan .= '<br />' . $i++ . ') <font color="blue">Đã thêm module: ' . $module_dir . '</font>'; $all_modules[strtolower($module_dir)] = array('id' => $id, 'name' => $module_dir); } } else { $this->list_scan .= '<br />' . $i++ . ')<font color="blue">Thêm module: ' . $module_dir . '</font>'; } } } } if ($all_modules) { $this->list_scan .= $this->list_scan ? '<br />' : ''; $i = 1; foreach ($all_modules as $module) { if (!is_dir(DIR_MODULE . $module['name'])) { if ($this->update) { DB::delete('block', 'module_id=' . $module['id']); DB::delete('module', 'id=' . $module['id']); $this->list_scan .= '<br />' . $i++ . ')<font color="red">Đã xoá module: ' . $module['name'] . '</font>'; } else { $this->list_scan .= '<br />' . $i++ . ')<font color="red">Xoá module: ' . $module['name'] . '</font>'; } } } } $this->list_scan = $this->list_scan ? '<center><b>CÁC MODULES THAY ĐỔI</b></center>' . $this->list_scan . '<br />' : ''; if ($this->update) { $this->list_scan .= '<br /><center><font color="green"><b>ĐÃ CẬP NHẬT XONG</b> <br /><br /><a href="' . Url::build_current(array('cmd' => 'scan')) . '"><b>Scan tiếp</b></a></font></center><br />'; } else { if ($this->list_scan) { $this->list_scan .= '<br /><br /><center><input type="submit" value="Cập nhật"></center>'; } else { $this->list_scan .= '<center><b>KHÔNG CÓ THÔNG TIN THAY ĐỔI NÀO</b></center>'; } } }
function draw() { global $display; $this->beginForm(); $sql = "SELECT COUNT(*) AS total_row FROM spam_mail"; $total = DB::fetch($sql, 'total_row', 0); $spam_content = DB::select('spam_content', 'status=1'); $pagging = ''; $spam_emails = array(); if ($total) { $limit = ''; $pagging = AZPagging::pagingSE($limit, $total, 50, 10, 'page_no', true); $sql = "SELECT id, email_list, time, time_modify, spam_id, status FROM spam_mail ORDER BY id DESC {$limit}"; $re = DB::query($sql); if ($re) { while ($email = mysql_fetch_assoc($re)) { if ($email['time'] != $email['time_modify']) { $email['time'] = "<b>Tạo:</b> " . date('H\\hi d.m.Y', $email['time']); $email['time'] .= "<br /><b>Sửa:</b> " . date('H\\hi d.m.Y', $email['time_modify']); } else { $email['time'] = "<b>Tạo:</b> " . date('H\\hi d.m.Y', $email['time']); } if ($spam_content && $spam_content['id'] == $email['spam_id']) { $email['spam_id'] = '<font color="green">Đã spam</font>'; $email['reset'] = AZLib::button(Url::build_current(array('cmd' => 'reset_email', 'id' => $email['id'])), 'icon-reload.gif', 'Spam lại'); } else { $email['spam_id'] = '<font color="orange">Chưa được Spam</font>'; $email['reset'] = ''; } if ($email['status']) { $email['status'] = '<font color="green">Có</font>'; $email['check'] = AZLib::button(Url::build_current(array('cmd' => 'deactive_email', 'id' => $email['id'])), 'admin/delete_button_dis.gif', 'Không cho phép spam'); } else { $email['status'] = '<font color="orange">Không</font>'; $email['check'] = AZLib::button(Url::build_current(array('cmd' => 'active_email', 'id' => $email['id'])), 'admin/check.gif', 'Cho phép spam'); } if ($email['email_list']) { $email['email_list'] = count(explode("\n", $email['email_list'])); } else { $email['email_list'] = 0; } $email['edit_link'] = Url::build_current(array('cmd' => 'edit_email', 'id' => $email['id'])); $email['del_link'] = Url::build_current(array('cmd' => 'delete_email', 'id' => $email['id'])); $spam_emails[$email['id']] = $email; } } } $display->add('check_all', AZLib::button(Url::build_current(array('cmd' => 'active_all_email')), 'admin/check.gif', 'Cho phép spam tất cả các mail')); $display->add('check_none', AZLib::button(Url::build_current(array('cmd' => 'deactive_all_email')), 'admin/delete_button_dis.gif', 'Không phép spam tất cả các mail')); $display->add('items', $spam_emails); $display->add('pagging', $pagging); $display->output('ManageEmail'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'active'))); $display->add('msg', $this->showFormErrorMessages(1)); $display->add('smsg', $this->showFormSuccesMessages(1)); $display->add('show_active', $this->show_active); $display->add('user_name', Url::get('user_name', $this->user['user_name'])); $display->output('active'); $this->endForm(); }
function draw() { global $display; $InfoContent = stripslashes(@CGlobal::$configs['Info_' . AZNet::$page['name']]['conf_val']); $display->add("url_home", WEB_DIR); $display->add("title", AZNet::$page['title']); $display->add("url", Url::build_current()); if (User::is_admin()) { $display->add("edit", Url::build_current(array('cmd' => 'update_' . AZNet::$page['name']))); } $display->add("text", html_entity_decode($InfoContent, ENT_QUOTES, "UTF-8")); $this->beginForm(); $display->output("InfoView"); $this->endForm(); }
function draw() { global $display; $display->add("url_home", WEB_DIR); $display->add("title", AZNet::$page['title']); $display->add("url", Url::build_current()); $content = stripslashes(Url::get('content')); if (!$content) { $content = stripslashes(@CGlobal::$configs["Info_" . AZNet::$page['name']]['conf_val']); } $display->add("msg", $this->showFormErrorMessages(1)); $display->add("content", $content); $this->beginForm(); $display->output("InfoEdit"); $this->endForm(); }
function draw() { global $display; $this->beginForm(); $display->add('url_add', Url::build_current(array('cmd' => 'add'))); $current_path = "<a href='" . URL::build('news_list', array('news_catid' => $this->row['id'], 'azname' => AZLib::safe_title($this->row['name']))) . "'>" . $this->row['name'] . "</a>"; $display->add('current_cat', $current_path); $display->add('name', Url::get('name', $this->row['name'])); $display->add('position_option', AZLib::getOptionNum(1, DB::count("news_categories"), Url::get('position', $this->row['position']))); $display->add('public', Url::get('public', $this->row['public'] ? 1 : 2)); $display->add('keywords', Url::get('keywords', $this->row['keywords'])); $display->add('description', Url::get('description', $this->row['description'])); $display->add('msg', $this->showFormErrorMessages(1)); $display->output("NewsAdminCatsEdit"); $this->endForm(); }
function draw() { global $display; $item_id = intval(Url::get('id', 0)); $this->beginForm(true, 'post', false, Url::build_current(array("cmd" => "edit", "id" => $item_id))); $item = array(); // Get Data if ($item_id) { $item = News::get_item($item_id); } $display->add('item', $item); $display->add('error_message', $this->getErrorMessage('news/item/error')); $display->add('success_message', $this->getSuccessMessage('news/item/success')); $display->output('Edit'); $this->endForm(); }
function draw() { $this->beginForm(false, 'post', false, Url::build_current()); $category_id = intval(Url::get('id', 0)); $category = array(); // Get Data if (!empty($category_id)) { $category = NewsCategory::get_category($category_id, true); } global $display; $display->add('category', $category); $display->add('error_message', $this->getErrorMessage('news/category/error')); $display->add('success_message', $this->getSuccessMessage('news/category/success')); $display->output('Edit'); $this->endForm(); }
function __construct($row) { Module::Module($row); if (User::is_admin()) { switch (Url::get('cmd')) { case 'delete': $id = (int) Url::get('id', 0); if ($id) { DB::delete('news_letter_email', "id={$id}"); Url::redirect_current(); } break; case 'export': DB::query('SELECT email FROM news_letter_email ORDER BY email ASC'); $emails = DB::fetch_all(); if ($emails) { $txt = ''; foreach ($emails as $email) { if ($txt != '') { $txt .= "\n" . $email['email']; } else { $txt = $email['email']; } } if ($txt != '') { header('Content-type: application/txt'); header('Content-Disposition: attachment; filename="newsletter_email.txt"'); echo $txt; exit; } } echo '<script> alert("Không có Email nào!"); window.location="' . Url::build_current() . '"; </script>'; break; default: require_once 'forms/NewsLetterAdmin.php'; $this->add_form(new NewsLetterAdminForm()); break; } } else { Url::access_denied(); } }
function draw() { global $display; $display->add('msg', $this->showFormErrorMessages(1)); $display->add("customer_name", stripslashes(URL::get('customer_name', Cart::$cart['customer_name']))); $display->add("customer_email", stripslashes(URL::get('customer_email', Cart::$cart['customer_email']))); $display->add("customer_phone", stripslashes(URL::get('customer_phone', Cart::$cart['customer_phone']))); $display->add("customer_address", stripslashes(URL::get('customer_address', Cart::$cart['customer_address']))); $display->add("customer_note", stripslashes(URL::get('customer_note', Cart::$cart['customer_note']))); //$quantity_total =0; $price_total = 0; $cart_items = array(); if (Cart::$cart_items) { foreach (Cart::$cart_items as $cart_item_id => $cart_item) { $item = Cart::$items[$cart_item['item_id']]; if (isset(CGlobal::$allCategories[$item['category_id']])) { $cart_item['url'] = WEB_DIR . CGlobal::$allCategories[$item['category_id']]['nice_name'] . "/p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } else { $cart_item['url'] = WEB_DIR . "p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } $cart_item['name'] = $item['name']; $cart_item['price_num'] = $item['price']; $cart_item['price'] = number_format($item['price'], 0, ',', '.'); if ($item['img_url']) { $cart_item['img_url'] = AZLib::getImageThumb($item['img_url'], 120, 120, 0, $item['img_server']); } else { $item['img_url'] = ''; } $cart_item['row_total'] = $cart_item['checked'] ? number_format($item['price'] * $cart_item['quantity'], null, null, '.') . ' VNĐ' : ''; $price_total += $cart_item['checked'] ? $item['price'] * $cart_item['quantity'] : 0; //$quantity_total += $cart_item['checked'] ? $cart_item['quantity'] : 0; $cart_items[$cart_item['id']] = $cart_item; } } //$display->add('quantity_total',number_format($quantity_total,null,null,'.')); $display->add('price_total', number_format($price_total, null, null, '.')); $display->add('url_finish', Url::build_current(array('cmd' => 'finish'))); $display->add('cart_items', $cart_items); $display->add('cart_id', "Cart_" . Cart::$cart['id']); $this->beginForm(); $display->output('CartFinish'); $this->endForm(); }
function draw() { global $display; $this->beginForm(true, 'post', false, Url::build_current()); $item_id = intval(Url::get('id', 0)); $cid = intval(Url::get('cid', 0)); if (!empty($cid)) { $display->add('cid', $cid); } $item = array(); // Get Data if ($item_id) { $item = News::get_item($item_id); } $display->add('item', $item); $display->add('categories', NewsCategory::get_categories()); $display->add('error_message', $this->getErrorMessage('news/item/error')); $display->add('success_message', $this->getSuccessMessage('news/item/success')); $display->output('Detail'); $this->endForm(); }
function draw() { global $display; $this->beginForm(); $sql = "SELECT COUNT(*) AS total_row FROM spam_content"; $total = DB::fetch($sql, 'total_row', 0); $pagging = ''; $spam_contents = array(); if ($total) { $limit = ''; $pagging = AZPagging::pagingSE($limit, $total, 50, 10, 'page_no', true); $sql = "SELECT id, des, subject, content, time, time_modify, status FROM spam_content ORDER BY id DESC {$limit}"; $re = DB::query($sql); if ($re) { while ($spam = mysql_fetch_assoc($re)) { if ($spam['time'] != $spam['time_modify']) { $spam['time'] = "<b>Tạo:</b> " . date('H\\hi d.m.Y', $spam['time']); $spam['time'] .= "<br /><b>Sửa:</b> " . date('H\\hi d.m.Y', $spam['time_modify']); } else { $spam['time'] = "<b>Tạo:</b> " . date('H\\hi d.m.Y', $spam['time']); } if ($spam['status'] == 0) { $spam['status'] = '<font color="orange">Chưa kích hoạt</font>'; $spam['check'] = AZLib::button(Url::build_current(array('cmd' => 'active_content', 'id' => $spam['id'])), 'admin/check.gif', 'Kích hoạt'); } elseif ($spam['status'] == 1) { $spam['status'] = '<font color="red"><b>Kích hoạt</b></font>'; $spam['check'] = AZLib::button(Url::build_current(array('cmd' => 'deactive_content', 'id' => $spam['id'])), 'admin/delete_button_dis.gif', 'Bỏ kích hoạt'); } $spam['edit_link'] = Url::build_current(array('cmd' => 'edit_content', 'id' => $spam['id'])); $spam['del_link'] = Url::build_current(array('cmd' => 'delete_content', 'id' => $spam['id'])); $spam['onclick'] = Url::open_popup('spam_preview.php?spam_id=' . $spam['id'], '600', 400, false, false, false, true, false, false, true); $spam_contents[] = $spam; } } } $display->add('items', $spam_contents); $display->add('pagging', $pagging); $display->output('ManageSpam'); $this->endForm(); }
function draw() { global $display; $display->add('msg', $this->showFormErrorMessages(1)); $quantity_total = 0; $price_total = 0; $cart_items = array(); if (Cart::$cart_items) { foreach (Cart::$cart_items as $cart_item_id => $cart_item) { $item = Cart::$items[$cart_item['item_id']]; if (isset(CGlobal::$allCategories[$item['category_id']])) { $cart_item['url'] = WEB_DIR . CGlobal::$allCategories[$item['category_id']]['nice_name'] . "/p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } else { $cart_item['url'] = WEB_DIR . "p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } $cart_item['name'] = $item['name']; $cart_item['price_num'] = $item['price']; $cart_item['price'] = number_format($item['price'], 0, ',', '.'); if ($item['img_url']) { $cart_item['img_url'] = AZLib::getImageThumb($item['img_url'], 120, 120, 0, $item['img_server']); } else { $item['img_url'] = ''; } $cart_item['row_total'] = $cart_item['checked'] ? number_format($item['price'] * $cart_item['quantity'], null, null, '.') . ' VNĐ' : ''; $cart_item['delete'] = Url::build_current(array('cmd' => 'delete', 'id' => $cart_item['id'])); $price_total += $cart_item['checked'] ? $item['price'] * $cart_item['quantity'] : 0; $quantity_total += $cart_item['checked'] ? $cart_item['quantity'] : 0; $cart_items[$cart_item['id']] = $cart_item; } } $display->add('quantity_total', number_format($quantity_total, null, null, '.')); $display->add('price_total', number_format($price_total, null, null, '.')); $display->add('url_finish', Url::build_current(array('cmd' => 'finish'))); $display->add('cart_items', $cart_items); $display->add("print_link", Url::open_popup(Url::build('cart_print', array('id' => Cart::$cart['id'])), 1000, 800, false, false, false, false, false, 1, 1)); $this->beginForm(); $display->output('Cart'); $this->endForm(); }
function draw() { global $display; $keyword = Url::get('keyword'); $display->add('keyword', $keyword); $display->add('export_link', Url::build_current(array('cmd' => 'export'))); $where = '1'; if ($keyword != '') { $where .= ' AND email LIKE "%' . $keyword . '%"'; } $total_item = DB::count('news_letter_email', $where); $limit = ''; $item_per_page = 40; $page_no = (int) Url::get('page_no'); $pagging = AZPagging::paging_list($limit, $total_item, $item_per_page, 10); $re = DB::query('SELECT * FROM news_letter_email WHERE ' . $where . ' ORDER BY id ' . $limit); $news_letter_emails = array(); $i = 0; if ($page_no <= 0) { $page_no = 1; } if ($re) { while ($item = mysql_fetch_assoc($re)) { $item['time_add'] = date('H:i', $item['time_add']) . ' ngày ' . date('d/m/Y', $item['time_add']) . '<br />Cách đây ' . AZLib::duration_time($item['time_add']); $item['delete'] = AZLib::buttonDel(Url::build_current(array('cmd' => 'delete', 'id' => $item['id'])), 'style/images/admin/delete.gif', 'Loại bỏ Email này khỏi danh sách!'); $i++; $item['i'] = $i + ($page_no - 1) * $item_per_page; $news_letter_emails[$item['id']] = $item; } } $display->add('pagging', $pagging); $display->add('news_letter_emails', $news_letter_emails); $display->add('count', $total_item); $this->beginForm(); $display->output("NewsLetterAdmin"); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, 'post', false, Url::build_current()); $name = trim(Url::get('name')); $order_by = Url::get('order_by', 'id'); $order_dir = Url::get('order_dir', 'DESC'); $cond = ' 1 '; if ($name != '') { $cond .= ' AND name LIKE "%' . $name . '%"'; } $item_per_page = 50; $total_row = DB::fetch('SELECT count(*) AS total_row FROM `page` WHERE ' . $cond . ' LIMIT 0,1', 'total_row', 0); $items = array(); $paging = ''; if ($total_row) { $limit = ''; require_once ROOT_PATH . 'core/ECPagging.php'; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $sql = 'SELECT id ,name,title, description FROM `page` WHERE ' . $cond . ' ORDER BY ' . $order_by . ' ' . $order_dir . ' ' . $limit; $re = DB::query($sql); if ($re) { while ($row = mysql_fetch_assoc($re)) { $row['href'] = Url::build('edit_page', array('id' => $row['id'])); $items[$row['id']] = $row; } } } if ($order_dir == 'ASC') { $order_dir = 'DESC'; } else { $order_dir = 'ASC'; } $href_id = Url::build_current(array('order_by' => 'id', 'order_dir' => $order_dir)); $href_name = Url::build_current(array('order_by' => 'name', 'order_dir' => $order_dir)); $href_des = Url::build_current(array('order_by' => 'description', 'order_dir' => $order_dir)); $href_title = Url::build_current(array('order_by' => 'title', 'order_dir' => $order_dir)); $img_id = ''; $img_name = ''; $img_title = ''; $img_des = ''; if ($order_by == 'id') { $img_id = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } if ($order_by == 'name') { $img_name = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } if ($order_by == 'description') { $img_des = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } if ($order_by == 'title') { $img_title = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } $display->add('img_id', $img_id); $display->add('img_name', $img_name); $display->add('img_title', $img_title); $display->add('img_des', $img_des); $display->add('href_id', $href_id); $display->add('href_title', $href_title); $display->add('href_name', $href_name); $display->add('href_des', $href_des); $display->add('name', $name); $display->add('paging', $paging); $display->add('items', $items); $display->add('hover', EClassApi::mouse_hover('#E2F1DF', true)); $display->output('list'); $this->endForm(); }
function draw() { global $display; $display->add('msg', $this->showFormErrorMessages(1)); if ($this->cart['user_id']) { $display->add("user_name", $this->cart['user_name']); } $display->add("user_id", $this->cart['user_id']); $display->add("customer_name", stripslashes(URL::get('customer_name', $this->cart['customer_name']))); $display->add("customer_email", stripslashes(URL::get('customer_email', $this->cart['customer_email']))); $display->add("customer_phone", stripslashes(URL::get('customer_phone', $this->cart['customer_phone']))); $display->add("customer_address", stripslashes(URL::get('customer_address', $this->cart['customer_address']))); $display->add("customer_note", stripslashes(URL::get('customer_note', $this->cart['customer_note']))); $display->add("note", stripslashes(URL::get('note', $this->cart['note']))); //$quantity_total =0; $price_total = 0; $cart_items = array(); if ($this->cart_items) { foreach ($this->cart_items as $cart_item_id => $cart_item) { $item = $this->items[$cart_item['item_id']]; if (isset(CGlobal::$allCategories[$item['category_id']])) { $cart_item['url'] = WEB_DIR . CGlobal::$allCategories[$item['category_id']]['nice_name'] . "/p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } else { $cart_item['url'] = WEB_DIR . "p{$item['id']}/" . AZLib::safe_title($item['name']) . ".html"; } $cart_item['name'] = $item['name']; $cart_item['price_num'] = $item['price']; $cart_item['price'] = number_format($item['price'], 0, ',', '.'); if ($item['img_url']) { $cart_item['img_url'] = AZLib::getImageThumb($item['img_url'], 120, 120, 0, $item['img_server']); } else { $item['img_url'] = ''; } $cart_item["delete"] = Url::build_current(array('cmd', 'id', 'act' => 'del_item', 'ci_id' => $cart_item['id'])); $cart_item['row_total'] = $cart_item['checked'] ? number_format($item['price'] * $cart_item['quantity'], null, null, '.') . ' VNĐ' : ''; $price_total += $cart_item['checked'] ? $item['price'] * $cart_item['quantity'] : 0; //$quantity_total += $cart_item['checked'] ? $cart_item['quantity'] : 0; $cart_items[$cart_item['id']] = $cart_item; } } $display->add('price_total', number_format($price_total, null, null, '.')); $display->add('url_finish', Url::build_current(array('cmd' => 'finish'))); $display->add('cart_items', $cart_items); //1:Chưa cập nhật; 2: Đã gửi đơn hàng ; 3: Đã TT; 4: Hủy đơn hàng; 5: Đã duyệt $status_arr = array(6 => "--Tất cả--", 2 => "Đã gửi đơn hàng", 1 => "Chưa cập nhật", 3 => "Đã Thanh toán", 5 => "Đã duyệt", 4 => "Đã hủy"); $display->add("status_option", AZLib::getOption($status_arr, $this->cart['status'])); $display->add('cart_id', "Cart_" . $this->cart['id']); $display->add("time_create", date('d/m/Y H:i:s', $this->cart['time_create'])); $display->add("time_change", date('d/m/Y H:i:s', $this->cart['time_change'])); if ($this->cart['time_finish']) { $display->add("time_finish", date('d/m/Y H:i:s', $this->cart['time_finish'])); } else { $display->add("time_finish", "Chưa hoàn thành!"); } $this->beginForm(); $display->output('CartEdit'); $this->endForm(); }
function draw() { global $display; $this->beginForm(); $filter_groups = array(); $max_pos_gfilter = 1; if (CGlobal::$all_gfilters) { foreach (CGlobal::$all_gfilters as $filter_group) { if ($max_pos_gfilter <= $filter_group['pos']) { $max_pos_gfilter = $filter_group['pos'] + 1; } $filter_group['link'] = Url::build_current(array('cmd' => 'filter', 'fgroup_id' => $filter_group['id'])); $filter_group['del'] = Url::build_current(array('cmd', 'fgroup_del' => $filter_group['id'])); $filter_groups[$filter_group['id']] = $filter_group; } } $display->add('filter_groups', $filter_groups); $display->add('option_gfilter_pos', AZLib::getOptionNum(1, $max_pos_gfilter, $max_pos_gfilter)); $display->output('FilterList'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, 'get', false, Url::build_current()); $item_per_page = 15; $sql_count = 'SELECT count(*) AS total_row FROM news_category'; $list_categories = array(); $paging = ''; // Get Filter Parameters $name = Url::get('name'); $is_active = Url::get('is_active', 0); $conditions = ''; $id = intval(Url::get('id', 0)); if (!empty($id)) { if (strstr($conditions, 'WHERE')) { $conditions .= " AND id = " . $id; } else { $conditions .= " WHERE id = " . $id; } $display->add('id', $id); } if (!empty($name)) { if (strstr($conditions, 'WHERE')) { $conditions .= " AND name LIKE '%" . $name . "%'"; } else { $conditions .= " WHERE name LIKE '%" . $name . "%'"; } $display->add('name', $name); } if ($is_active > 0) { if ($is_active == 2) { $is_active = 0; $display->add('name', 2); } else { $display->add('name', $is_active); } if (strstr($conditions, 'WHERE')) { $conditions .= " AND is_active = " . $is_active; } else { $conditions .= " WHERE is_active = " . $is_active; } } $total_row = DB::fetch($sql_count, 'total_row', 0); if ($total_row) { $limit = ''; require_once ROOT_PATH . 'core/ECPagging.php'; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $sql = 'SELECT * FROM news_category ' . $conditions . ' ORDER BY id DESC ' . $limit; $res = DB::query($sql); if ($res) { while ($row = mysql_fetch_assoc($res)) { if (empty($row['post_day'])) { $row['post_day'] = time(); } $row['post_day_formatted'] = date('d/m/Y', $row['post_day']); $list_categories[] = $row; } } mysql_free_result($res); } $display->add('error_message', $this->getErrorMessage('news/category/error')); $display->add('success_message', $this->getSuccessMessage('news/category/success')); $display->add('list_categories', $list_categories); $display->add('total_row', $total_row); $display->add('paging', $paging); $display->output('List'); $this->endForm(); }
function draw() { global $display; $this->beginForm(true); $filters = array(); $max_pos_filter = 1; $max_pos_filter = 1 + DB::fetch("SELECT MAX(pos) AS max_pos FROM filter WHERE fgid=" . $this->filter_group['id'], "max_pos", 0); $re = DB::query("SELECT * FROM filter WHERE fgid=" . $this->filter_group['id'] . " ORDER BY pos"); if ($re) { while ($filter = mysql_fetch_assoc($re)) { $filter['del'] = Url::build_current(array('cmd', 'fgroup_id', 'f_del' => $filter['id'])); $filters[$filter['id']] = $filter; } } $display->add('filters', $filters); $display->add('group_filter_id', $this->filter_group['id']); $display->add('group_filter_name', $this->filter_group['name']); $cat_arr = array(); if ($this->filter_group['catids']) { $catid_arr = explode(',', $this->filter_group['catids']); foreach ($catid_arr as $catid) { $cat = array('id' => $catid, 'name' => CGlobal::$allCategories[$catid]['name']); if (isset(CGlobal::$allCategories[$catid])) { $cat['name'] = CGlobal::$allCategories[$catid]['name']; } else { $cat['name'] = "<font color=red>(Đã xóa)</font>"; } $cat_arr[$catid] = $cat; } } //$display->add('group_catids', $this->filter_group['catids']); $display->add('cat_arr', $cat_arr); $display->add('group_pos', $this->filter_group['pos']); $display->add('option_filter_pos', AZLib::getOptionNum(1, $max_pos_filter, $max_pos_filter)); $display->output('Filter'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'list_faq'))); $filter_name = trim(Url::get('filter_name')); $filter_id = intval(trim(Url::get('filter_id'))); $filter_active = intval(trim(Url::get('filter_active'))); $faq_ids = Url::get('banner_ids'); if (!empty($faq_ids) && !empty($bulk_action)) { $faq_ids = implode(',', $faq_ids); switch ($bulk_action) { case '1': $query = 'UPDATE faq SET is_active = 1 WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; case '2': $query = 'UPDATE faq SET is_active = 0 WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; case '3': $query = 'DELETE FROM faq WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; } if (isset($query)) { DB::query($query); } } $cond = array(); if (!empty($filter_id)) { $cond[] = 'id LIKE "%' . $filter_id . '%"'; $display->add('filter_id', $filter_id); } if (!empty($filter_name)) { $cond[] = 'name LIKE "%' . $filter_name . '%" '; $display->add('filter_name', $filter_name); } if (!empty($_POST)) { switch ($filter_active) { case 0: $cond[] = ' is_active = ' . $filter_active; break; case 1: $cond[] = ' is_active = ' . $filter_active; break; default: break; } $display->add('filter_active', $filter_active); } else { $display->add('filter_active', 2); } $item_per_page = 50; $cond = EClassApi::analyze_conditions($cond); $list_faq = array(); $paging = ''; $total_row = Faq::count_all($cond); if ($total_row) { require_once ROOT_PATH . 'core/ECPagging.php'; $limit = ''; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $list_faq = Faq::get_collection($limit, $cond, ' ORDER BY question ASC'); } $error_message = $this->getErrorMessage('admin/faq/error'); $display->add('error_message', $error_message); $display->add('paging', $paging); $display->add('list_faq', $list_faq); $display->output('List'); $this->endForm(); }
function draw() { global $display; $display->add('skin_path', IMAGE_PATH); $txt = ''; $option1 = ''; $sql = "SELECT * FROM `public_survey` WHERE "; $search = Url::get('search'); if ($search != '') { $condition = "title LIKE '%{$search}%' OR question LIKE '%{$search}%'"; } else { $condition = " 1"; } $totalRows = DB::count("public_survey", $condition); $limit = ''; $display->add('pagging', AZPagging::paging_list($limit, $totalRows, 40)); $sql .= $condition . $limit; $block_id = (int) Url::get('block_id', 0); $href = str_replace(WEB_DIR, '', urldecode(Url::get('href'))); $surveys = DB::fetch_all($sql); if ($surveys) { foreach ($surveys as &$survey) { if ($block_id) { $survey["add_to_block"] = $href . ($href != '' ? '&' : '?') . "cmd=add_poll_to_block&poll_id={$survey['id']}&block_id={$block_id}"; } if ($survey['view'] == 1) { $survey["url_view"] = Url::build_current(array("cmd" => "unpublish", "id" => $survey['id'])); $survey["view"] = '<img src="style/images/unexam.gif" title="Ẩn"/>'; $survey["view_str"] = "Hiển thị"; } else { $survey["url_view"] = Url::build_current(array("cmd" => "publish", "id" => $survey['id'])); $survey["view_str"] = "Đang ẩn"; $survey["view"] = '<img src="style/images/exam.gif" title="Cho hiển thị"/>'; } $survey["url_view_survey"] = Url::build('view_survey', array('id' => $survey['id'])); $survey["url_option"] = Url::build('admin_option', array('id_survey' => $survey['id'])); $question = $survey['question'] . '<br><br>'; $total_cout = DB::fetch('SELECT SUM(`count`) AS total_cout FROM `public_survey_opinion` WHERE id_survey=' . $survey['id'], 'total_cout', 0); $options = DB::fetch_all('SELECT * FROM `public_survey_opinion` WHERE id_survey=' . $survey['id']); foreach ($options as $option) { $question .= "+ [ID:{$option['id']}] <b>{$option['option']}</b> <font color=red>({$option['count']}/{$total_cout} lượt chọn)</font><br>"; } $survey["question"] = $question; if ($survey['type'] == 0) { $type_send = "Nhiều lựa chọn"; } else { $type_send = "Một lựa chọn"; } $survey["type_send"] = $type_send; $survey["time"] = date("d/m/Y H:i", $survey["time"]); $survey["time_m"] = date("d/m/Y H:i", $survey["time_m"]); $survey["edit"] = Url::build_current(array('id_survey' => $survey['id'], 'cmd' => 'edit')); $survey["delete"] = Url::build_current(array('id_survey' => $survey['id'], 'cmd' => 'delete')); } } $display->add('surveys', $surveys); $display->add('url_addnew', Url::build('admin_survey', array('cmd' => 'add'))); $display->output('ListSurvey'); }
function draw() { global $display; //$this->beginForm(false,'post',false,Url::build_current()); $this->beginForm(); $name = trim(Url::get('name')); $order_by = Url::get('order_by', 'id'); $order_dir = Url::get('order_dir', 'DESC'); $cond = ' 1 '; if ($name != '') { $cond .= ' AND name LIKE "%' . $name . '%"'; } $item_per_page = 50; $total_row = DB::fetch('SELECT count(*) AS total_row FROM `module` WHERE ' . $cond . ' LIMIT 0,1', 'total_row', 0); $items = array(); $paging = ''; if ($total_row) { $limit = ''; require_once ROOT_PATH . 'core/ECPagging.php'; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $sql = 'SELECT id ,name FROM `module` WHERE ' . $cond . ' ORDER BY ' . $order_by . ' ' . $order_dir . ' ' . $limit; $re = DB::query($sql); if ($re) { while ($row = mysql_fetch_assoc($re)) { if (Url::check('page_id')) { $row['onclick'] = ' onclick="location=\'' . Url::build('edit_page', array('module_id' => $row['id'], 'id' => (int) Url::get('page_id', 0), 'region', 'after', 'replace', 'href')) . '\';" style="cursor:pointer;" title="Click vào đây để cắm Module vào Page"'; } else { $row['onclick'] = ''; } $re2 = DB::query('SELECT page.id,page.name FROM block INNER JOIN page ON page.id=block.page_id WHERE module_id="' . $row['id'] . '"'); if ($re2) { while ($page = mysql_fetch_assoc($re2)) { $row['pages'][$page['id']] = $page; } } else { $row['pages'] = array(); } $items[$row['id']] = $row; } } } if ($order_dir == 'ASC') { $order_dir = 'DESC'; } else { $order_dir = 'ASC'; } $href_id = Url::build_current(array('order_by' => 'id', 'order_dir' => $order_dir)); $href_name = Url::build_current(array('order_by' => 'name', 'order_dir' => $order_dir)); $img_id = ''; $img_name = ''; if ($order_by == 'id') { $img_id = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } if ($order_by == 'name') { $img_name = '<img src="style/images/admin/' . ($order_dir != 'DESC' ? 'down' : 'up') . 'arrow.png" alt="">'; } $display->add('img_id', $img_id); $display->add('img_name', $img_name); $display->add('href_id', $href_id); $display->add('href_name', $href_name); $display->add('name', $name); $display->add('paging', $paging); $display->add('items', $items); $display->add('hover', EClassApi::mouse_hover('#E2F1DF', true)); $display->output('list'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, "POST", false, Url::build_current()); $search_value = " 1 "; $type_check = Url::get('type_check', 1); $display->add('type_check', $type_check); if ($type_check == 2) { $search_value = ' type=2'; } else { $search_value = ' type>=0'; } $order_by = " ORDER BY time DESC"; //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 = 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]); } } if ($created_time_from) { $search_value .= ' AND time >= ' . $created_time_from; } if ($created_time_to) { $search_value .= ' AND time <= ' . $created_time_to; } ///// Tim ADMIN if (Url::get('admin_text_value') != '') { $admin_text_value = Url::get('admin_text_value'); $display->add('admin_text_value', $admin_text_value); $str_search = str_replace("'", '"', $admin_text_value); $str_search = str_replace("'", '"', $str_search); $str_search = str_replace(""", '"', $str_search); $search_value .= " AND admin_name LIKE '%" . $str_search . "%'"; } if (Url::get('admin_text_value_open') != '') { $admin_text_value_open = Url::get('admin_text_value_open'); $display->add('admin_text_value_open', $admin_text_value_open); $str_search = str_replace("'", '"', $admin_text_value_open); $str_search = str_replace("'", '"', $str_search); $str_search = str_replace(""", '"', $str_search); $search_value .= " AND unlock_user LIKE '%" . $str_search . "%'"; } $admin_id_search = (int) Url::get('admin_id_search', 0); if ($admin_id_search) { $search_value .= ' AND admin_id=' . $admin_id_search; } if ($admin_id_search == 0) { $admin_id_search = ''; } $display->add('admin_id_search', $admin_id_search); ///// Tim User // search ô textbox tài khoản if (Url::get('text_value') != '') { $text_value = 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); $search_value .= " AND user_lock.user_name LIKE '%" . $str_search . "%'"; } // search ô textbox ID $id_search = (int) Url::get('id_search', 0); if ($id_search) { $search_value .= ' AND user_lock.user_id=' . $id_search; } if ($id_search == 0) { $id_search = ''; } $display->add('id_search', $id_search); $paging = ''; $item_per_page = Url::get('item_per_page', 50); $sql_count = 'SELECT COUNT(id) AS total_item FROM user_lock WHERE ' . $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, 'Thành viên', 'Trang'); $sql = 'SELECT user_lock.*, user.block_time, user.invalid_time FROM user_lock INNER JOIN user ON user.id=user_lock.user_id WHERE ' . $search_value . $order_by . $limit; $result = DB::query($sql); if ($result) { while ($row = mysql_fetch_assoc($result)) { $row['time'] = date('H:i d/m/y', $row['time']); $row['is_block'] = false; if ($row['unlock_time'] > 0) { $row['unlock_time'] = date('H:i d/m/y', $row['unlock_time']); } else { $row['unlock_time'] = ""; } $row['unban_nick'] = Url::build_all(array('chk_id', 'del_all', 'cmd', 'id', 'lock_die_all', 'hd_ac'), 'cmd=unban_nick&id=' . $row['id'] . '&user_id=' . $row['user_id']); if ($row['block_time'] > TIME_NOW) { $row['is_block'] = "khóa theo ngày"; } elseif ($row['block_time'] == -1) { $row['is_block'] = "khóa vĩnh viễn"; } //$row['is_block'] .= $row['is_block']!=""?" & ":""; if ($row['invalid_time'] > TIME_NOW) { $row['is_block'] = "KD theo ngày"; } elseif ($row['invalid_time'] == -1) { $row['is_block'] = "KD vĩnh viễn"; } $items[$row['id']] = $row; } } } $display->add('total_user', $total); $display->add('items', $items); $display->add('paging', $paging); $display->output('ManageUserLock'); $this->endForm(); }