Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/thietkewebvumi.com/admin_new/mod/ |
<?php
class district{
function district (){
global $CORE, $TBS;
$TBS->LoadTemplate(ADMIN_PATH."skin/district.html");
switch($CORE->input['code']){
default : case 'list' : $this->goList(); break;
case 'post': $this->goPost(); break;
case 'del': $this->goDel(); break;
}
}
function goList(){
global $CORE, $DB, $func, $TBS, $print , $clev;
$TBS->MergeField('section','list');
if($CORE->input['task']=='reorder'){ // Do reorder ----------------
$input_arr = $CORE->input;
$query = $DB->query("SELECT ID_district,pos FROM district ORDER BY district_name");
while($row = $DB->fetch_row($query))
{
foreach($input_arr as $k => $v){
$k = intval ($k);
$v = intval ($v);
if($k==$row['ID_district']) $DB->query("UPDATE district SET `pos`='$v' WHERE `ID_district`='$k'");
}
}
return $print->redirect ('Đã lưu thứ tự',$CORE->admin_url.'&act=district');
}
if($CORE->input['task']=='activate'){ // Do activate ----------------
$selected = explode("|",$CORE->input['sids']);
foreach ($selected as $v) $DB->query("UPDATE district SET `status`='1' WHERE `ID_district`='$v'");
return $print->redirect ('Đã kích hoạt',$CORE->admin_url.'&act=district');
}
if($CORE->input['task']=='deactivate'){ // Do activate ----------------
$selected = explode("|",$CORE->input['sids']);
foreach ($selected as $v) $DB->query("UPDATE district SET `status`='0' WHERE `ID_district`='$v'");
return $print->redirect ('Đã bỏ kích hoạt',$CORE->admin_url.'&act=district');
}
if($CORE->input['task']=='massdel'){ // Do activate ----------------
$selected = explode("|",$CORE->input['sids']);
foreach ($selected as $v)
{
if($v>0 || $v!='')
{
$DB->query("DELETE FROM district WHERE `ID_district`='$v'");
}
}
//return $print->redirect ('Đã xóa',$CORE->admin_url.'&act=district');
}
$fcat = $func->drop_down_menu('fcat',$CORE->input['fcat'],'city','ID_city','city_name','ORDER BY city_name','Chọn thành phố');
$TBS->Mergefield('fcat',$fcat);
// Filtering Begin --------------------------------------------------------
$where = "WHERE a.district_name<>''";
if($CORE->input['fcat'])
{
$where .= " AND a.ID_city=".$CORE->input['fcat'];
}
if($CORE->input['fstatus'] && $CORE->input['fstatus']<2)
{
$where .= " AND a.status=".$CORE->input['fstatus'];
}
if($CORE->input['fkeyword'])
{
$where .= " AND a.district_name LIKE '%".$CORE->input['fkeyword']."%'";
}
// Filtering End --------------------------------------------------------
// Sorting Begin -----------------------------------------------------
if($CORE->input['sortby']) $_SESSION['prodcat_dirby'] = ($_SESSION['prodcat_dirby']==1) ? 0 : 1;
$dbsort = ($CORE->input['sortby']) ? $CORE->input['sortby'] : $_SESSION['prodcat_sortby'];
switch ($dbsort){
default : $sortby = 'ORDER BY a.pos DESC'; break;
case 'name' : $sortby = ($_SESSION['prodcat_dirby']==1) ? 'ORDER BY a.district_name DESC' : 'ORDER BY a.district_name'; break;
case 'cat' : $sortby = ($_SESSION['prod_dirby']==1) ? 'ORDER BY a.ID_city DESC' : 'ORDER BY a.ID_city'; break;
//case 'category' : $sortby = ($_SESSION['dirby']==1) ? 'ORDER BY n.cat DESC' : 'ORDER BY n.cat'; break;
//case 'time' : $sortby = ($_SESSION['dirby']==1) ? 'ORDER BY n.time DESC' : 'ORDER BY n.time'; break;
case 'pos' : $sortby = ($_SESSION['prodcat_dirby']==1) ? 'ORDER BY a.pos DESC' : 'ORDER BY a.pos'; break;
case 'status' : $sortby = ($_SESSION['prodcat_dirby']==1) ? 'ORDER BY a.status DESC' : 'ORDER BY a.status'; break;
}
$_SESSION['prodcat_sortby'] = $dbsort;
// Sorting End --------------------------------------------------------
// Filtering Begin --------------------------------------------------------
//$cat = ($_GET['category']) ? " AND n.cid='".$_GET['category']."'" : "";
//$keyword = ($_GET['keyword']!='') ? " AND n.title LIKE '%".$_GET['keyword']."%'" : "";
// Filtering End --------------------------------------------------------
/*
$query = $DB->query("SELECT * FROM NNCCMS_district $sortby");
$c = 0;
while($row = $DB->fetch_row($query))
{
$c++;
$row['no'] = $c;
$arr[] = $row;
}
*/
$pageNum = ($_GET['pageNum']>0) ? intval($_GET['pageNum']) : 1;
$pageSize = 30;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->query("SELECT * FROM district a ".$where);
$total = mysql_num_rows($t);
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM district a LEFT JOIN city b ON a.ID_city = b.ID_city ".$where." ".$sortby." LIMIT $from, $pageSize");
$c = 0;
while ($row = $DB->fetch_row($query)){
$c++;
$row['no'] = $c;
$clev[] = $row;
}
if(is_null($clev)) $clev[] = array();
//$lev1R = $TBS->MergeBlock('lev1','array','menu');
//if ($lev1R>0) $lev2R = $TBS->MergeBlock('lev2','array','menu[%p1%][sub]');
//if ($lev2R>0) $TBS->MergeBlock('lev3','array','menu[%p1%][sub][%p2%][sub]');
$TBS->MergeBlock('lev1',$clev);
$nav = $print->Pagination($totalPage,$pageNum,$CORE->admin_url.'&act=district');
$TBS->MergeField('nav',$nav);
//$scat = $func->drop_down_menu('post_scat','','NNCCMS_district','cid','cname','WHERE scat=0','Không chọn...');
//$TBS->MergeField('scat',$scat);
//if(is_null($arr)) $arr[] = array();
//$TBS->MergeBlock('list',$arr);
$TBS->Show(TBS_OUTPUT+TBS_NOTHING);
}
function goPost(){
global $CORE, $DB, $func, $TBS, $print;
$TBS->MergeField('section','post');
if($_SESSION['error']) unset($CORE->input['bsubmit']);
// Show post -----------------------------------------------------------------------
if(!$CORE->input['bsubmit']){
$id = intval($CORE->input['id']);
if ($_SESSION['error']) $prevError = $_SESSION['error']; unset($_SESSION['error']);
if ($_SESSION['state']) $prevState = $_SESSION['state']; unset($_SESSION['state']);
if($prevState!=NULL){
$data = $prevState;
}else{
if($id==0){
$data['status'] = 1;
}else{
$query = $DB->query("SELECT * FROM district WHERE ID_district='".$id."'");
$data = $DB->fetch_row($query);
}
}
$data['ID_city'] = $func->drop_down_menu('ID_city',$data['ID_city'],'city','ID_city','city_name','','');
$data['status'] = $func->yes_no($data['status'],'status');
$error[] = $prevError;
$post[] = $data;
$TBS->MergeBlock('error',$error);
$TBS->MergeBlock('post',$post);
// Show page --------------
$TBS->Show(TBS_OUTPUT+TBS_NOTHING);
// Do post -------------------------------------------
}else{
$ID_district = $state['ID_district'] = intval($CORE->input['id']);
$ID_city = $state['ID_city'] = intval($CORE->input['ID_city']);
$district_name = $state['cname'] = $CORE->input['cname'];
$pos = $state['pos'] = intval($CORE->input['pos']);
$status = $state['status'] = intval($CORE->input['status']);
//$time = time();
// -------------- check -------------------------
if($district_name=='') $error['district_name'] = 1;
// If detects any errors then return to the postform with errors
if($error!=''){
$_SESSION['error'] = $error;
$_SESSION['state'] = $state;
return $this->goPost();
}
// Do Add ------------------
if($ID_district==0){
$DB->query("INSERT INTO district(`ID_district`,`district_name`,ID_city,`pos`,`status`)
VALUES(
'','".$district_name."','".$ID_city."','".$pos."','".$status."');");
// Do Edit -----------------
}else{
$DB->query("UPDATE `district` SET `ID_city` = '$ID_city',`district_name` = '$district_name',`pos` = '$pos',`status` = '$status' WHERE `ID_district`='$ID_district'");
}
return $print->redirect("Đã cập nhật","index.php?act=district");
}
}
function goDel(){
global $CORE, $DB, $print;
$id = intval($CORE->input['id']);
$query = $DB->query("SELECT * FROM district WHERE `ID_district`='$id' LIMIT 1");
if ($DB->get_num_rows($query)>0) $DB->query("DELETE FROM district WHERE `ID_district`='$id'");
// $DB->query("DELETE FROM city WHERE `ID_city`='$id'");
$url = $CORE->admin_url."&act=district";
$text = "Đã xóa...";
$print->redirect ($text,$url);
}
}
$run = new district();
?>