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(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 = '';
$paging = AZPagging::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', AZLib::mouse_hover('#E2F1DF', true));
$display->output('list');
$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 = '';
$paging = AZPagging::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', AZLib::mouse_hover('#E2F1DF', true));
$display->output('list');
$this->endForm();
}
function draw_list($region, $modules)
{
$i = 0;
$last = false;
if ($modules) {
foreach ($modules as $key => $item) {
if ($i) {
if ($i > 1) {
$last['move_up'] = '<a href="' . Url::build_current(array('cmd' => 'move', 'id' => $this->page['id'], 'block_id' => $last['id'], 'move' => 'up')) . '"><img src="style/images/admin/up_arrow_.gif" alt="Move up"></a>';
$last['move_top'] = '<a href="' . Url::build('edit_page', array('id' => $this->page['id'], 'block_id' => $last['id'], 'cmd' => 'move_top')) . '">MoveTop</a>';
}
$last['move_down'] = '<a href="' . Url::build('edit_page', array('cmd' => 'move', 'id' => $this->page['id'], 'block_id' => $last['id'], 'move' => 'down')) . '"><img src="style/images/admin/down_arrow_.gif" alt="Move down"></a>';
$last['move_bottom'] = '<a href="' . Url::build('edit_page', array('id' => $this->page['id'], 'block_id' => $last['id'], 'cmd' => 'move_bottom')) . '">MoveBottom</a>';
}
$i++;
$last =& $modules[$key];
$last['move_up'] = '';
$last['move_down'] = '';
}
if ($i > 1) {
$modules[$key]['move_up'] = '<a href="' . Url::build('edit_page', array('cmd' => 'move', 'id' => $this->page['id'], 'block_id' => $item['id'], 'move' => 'up')) . '"><img src="style/images/admin/up_arrow_.gif" alt="Move up"></a>';
$modules[$key]['move_top'] = '<a href="' . Url::build('edit_page', array('id' => $this->page['id'], 'block_id' => $item['id'], 'cmd' => 'move_top')) . '">MoveTop</a>';
}
}
global $display;
$display->add('hover', AZLib::mouse_hover('#CCCCCC', true));
$display->add('id', $this->page['id']);
$display->add('name', $region);
$display->add('items', $modules);
return $display->output('list_block', true);
}
