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();
}
