<?php
	define('thisscript','pageslist');

	require_once 'globalad.php';
	require_once '../class/Page.php';
	require_once '../class/PageCategory.php';
	$newpage = new Page();
	$ctg = new PageCategory();

	if (empty($userid)){
		redirecting("index.php");
	}
	
	if (empty($useraccess['manage_page'])){
		redirecting('index.php');
	}

	if (empty($general['showperpageadmin'])){
		$general['showperpageadmin'] = 20;
	}
	
	/* sanitize post, get, request */
	$_POST['replayedit'] = ((empty($_POST['replayedit']))?"":$_POST['replayedit']);
	$_GET['getlist'] = ((empty($_GET['getlist']))?"":$_GET['getlist']);
	$_GET['keyword'] = ((empty($_GET['keyword']))?array():$_GET['keyword']);
	$_GET['field'] = ((empty($_GET['field']))?array():$_GET['field']);
	/* end sanitize */
	
	$listr = '';
	$pagelink = '';
	$listaction = '';
	
	if ($_GET['getlist'] == 'pagenav'){
		$keywords = $_GET['keyword'];
		$fields = $_GET['field'];
		$alls = $newpage->searchPage($keywords,$fields,'','','pagenav',$_GET['p']);
		echo $alls;
		exit;

	}
	else if ($_GET['getlist'] == 'ajax'){
		$allctg = $ctg->getPageCategoryList();
		$pctg = array();
		if (sizeof($allctg) > 0){
			foreach ($allctg as $data){
				$pctg[$data['categoryid']] = $data['categoryname_1'];
			}
		}
	
		$keywords = $_GET['keyword'];
		$fields = $_GET['field'];
		$alls = $newpage->searchPage($keywords,$fields,'','','data');
		$totalrows = sizeof($alls);
		$totalpgs = ceil($totalrows / $general['showperpageadmin']);
		$pgs = handlepage($_GET['p'],$totalpgs);
		$dblast = $newpage->searchPage($keywords,$fields,$_GET['sortf'],$_GET['sortd'],'data',$pgs);
		$listtr = '';
		if (sizeof($dblast) > 0){
			foreach ($dblast as $result){
				$cstatus = '';
				switch ($result['status']){
					case '1' : $cstatus = 'Active'; break;
					case '2' : $cstatus = 'Inactive'; break;		
				}
				$listr .= '
				<!--<div class="hovertr" ondblclick="window.open(\'pagedetail.php?id='.$result['pageid'].'\',\'_self\')">
					<div align="center">
						<table border="0" width="100%" cellspacing="3" cellpadding="0">-->
							<tr ondblclick="window.open(\'pagedetail.php?id='.$result['pageid'].'\',\'_self\')">
								<td width="5%" height="25" align="center"><input type="checkbox" name="cek[]" value="'.$result['pageid'].'"></td>
								<td width="50%" height="25" align="left"><a href="pagedetail.php?id='.$result['pageid'].'">'.$result['title_1'].'</a></td>
								<td width="20%" height="25" align="left">
								'.(empty($pctg[$result['categoryid']])?'-':$pctg[$result['categoryid']]).'</td>
								<td width="10%" height="25" align="center">
								<input type="hidden" name="sortsid[]" value="'.$result['pageid'].'">
								<input name="sorts[]" type="text" style="text-align: right" value="'.$result['sort'].'" size="3"></td>	
								<td width="15%" height="25" align="center">
								'.$cstatus.'</td>						
							</tr>
							<!--</tr>
						</table>
					</div>
				</div>
			<div style="width: 100%; height: 3px" class="line_h"></div>-->
			';
			}
			/* $listr .= '<div align="right">
						With selected : 
						<select name="replayedit" style="text-align: right">
						<option value="1" selected>Urutkan (Sort)</option>
						<option value="2">Aktif di Website</option>
						<option value="3">Tidak Aktif di Website</option>
						<option value="4">Hapus Halaman Terseleksi</option>		
						</select>&nbsp;&nbsp;<input type="submit" value="Go" class="button"></div><br>
					  '; */
		}
		else{
			$listr = 'NO DATA';
		}
			
		echo $listr;
		exit;
	}
	
	$listaction .= '<div align="right">
						With selected : 
						<select name="replayedit" style="text-align: right">
						<option value="1" selected>Urutkan (Sort)</option>
						<option value="2">Aktif di Website</option>
						<option value="3">Tidak Aktif di Website</option>
						<option value="4">Hapus Halaman Terseleksi</option>		
						</select>&nbsp;&nbsp;<input type="submit" value="Go" class="btn btn-success btn-sm"></div><br>
					  ';
	
	$menu = $_POST['replayedit'];
	if ($menu == 1){
		$alldep = $_POST['sorts'];
		$alldepid = $_POST['sortsid'];
		$sizealldep = sizeof($alldepid);
		if ($sizealldep > 0){
			for ($ax = 0; $ax < $sizealldep; $ax++){
				$newpage->setId($alldepid[$ax]);
				if (ctype_digit($alldep[$ax])){
					$newpage->updateSort($alldep[$ax]);
				}
			}
		}
	}
	else if ($menu == 2){
		$alldep = $_POST['cek'];
		$sizealldep = sizeof($alldep);
		if ($sizealldep > 0){
			for ($ax = 0; $ax < $sizealldep; $ax++){
				 $db->query("UPDATE page SET status=1 WHERE pageid ='".$db->clean($alldep[$ax])."'");
			}
		}
	}
	else if ($menu == 3){
		$alldep = $_POST['cek'];
		$sizealldep = sizeof($alldep);
		if ($sizealldep > 0){
			for ($ax = 0; $ax < $sizealldep; $ax++){
				 $db->query("UPDATE page SET status=2 WHERE pageid='".$db->clean($alldep[$ax])."'");
			}
		}
	}
	else if ($menu ==4){
		$alldep = $_POST['cek'];
		$sizealldep = sizeof($alldep);
		if ($sizealldep > 0){
			for ($ax = 0; $ax < $sizealldep; $ax++){
				$newpage->setId($alldep[$ax]);
				$newpage->deletePage();
			}
		}
	}
	
	/* build category list */
	$nav_query = $db->fetch_all("SELECT * FROM category_page WHERE parentid = -1 ORDER BY sort");
	$depth = 1;
	$exclude = array();
	array_push($exclude, 0);
	
	$pagectgoption = '';
	if (sizeof($nav_query) > 0){
		foreach ($nav_query as $nav_row){
			$goOn = 1;
			for ($x = 0; $x < count($exclude); $x++){
				if ($exclude[$x] == $nav_row['categoryid']){
					$goOn = 0;
					break;
				}
			}
			if ($goOn == 1){
				$pagectgoption .= "<option value=\"".$nav_row['categoryid']."\">".$nav_row['categoryname_'.$langid]."</option>";
				array_push($exclude, $nav_row['categoryid']);
				$pagectgoption .= $ctg->buildChildAdmin($nav_row['categoryid'],-1);
			}
		}
	}
	
	require_once 'incl/global_template.php';
	
	$theme = gettemplate('pageslist');
	eval("\$theme = \"$theme\";");
	echo $theme;
?>