<?php
/*
 * Created on 29 มี.ค. 2549
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $obj=new data('ppers_type');
 $method=new method();
 if($_POST){

	 if($_REQUEST['btnDel']){
		for($i=0;$i<sizeof($_REQUEST['hid_id']);$i++){
			if($_REQUEST['del'][$i]){
				$cond['pers_type']=$_REQUEST['hid_id'][$i];
				$obj->setCondition($cond);
				$obj->deleteData();
			}
		}
		$method->alert('ลบข้อมูลแล้ว');
 		$method->go('fct0108.php');
	}
 	if(($_REQUEST['Search'])||($_REQUEST['sPage'])){
 		if(!empty($_REQUEST['pers_type']))
 			$con['pers_type']=$_REQUEST['pers_type'];
 		if(!empty($_REQUEST['pers_type_desc']))
 			$con['pers_type_desc']=$_REQUEST['pers_type_desc'];
 		$obj->setCondition($con);
 		$_REQUEST['sPage']=1;
 	}
 	if($_REQUEST['Save']&&(!empty($_REQUEST['pers_type']))){
 		if(empty($_REQUEST['action'])){
			$cmd="SELECT * FROM ppers_type WHERE pers_type = '".$_REQUEST[pers_type]."' ";
			//echo $cmd; exit;
			$tmp=$obj->getCmdData($cmd);
			if(empty($tmp[pers_type])){
				$obj->addField($_REQUEST);
				$obj->insertData();
			}else{
				$method->alert('พบรหัส '.$_REQUEST[pers_type].' นี้แล้ว');
				$method->go('fct0108.php');
			}
 		}else if($_REQUEST['action']=='edit'){
 			$obj->addField($_REQUEST);
 			$req['court_running']=$obj->getCourt();
 			$req['pers_type']=$_REQUEST['edit_no'];
 			$obj->setCondition($req);
 			$obj->updateData();
 		}
 		$method->alert('บันทึกข้อมูลแล้ว');
 		$method->go('fct0108.php');
 	}
 }
 if($_REQUEST['action']=='del'){
 	$con['pers_type']=$_REQUEST['title_no'];
 	$obj->setCondition($con);
 	$obj->deleteData();
 	$method->alert('ลบข้อมูลแล้ว');
 	$method->go('fct0108.php');
 }
 if($_REQUEST['action']=='edit'){
 	$con['pers_type']=$_REQUEST['edit_no'];
 	$obj->setCondition($con);
 	$edit=$obj->getData();
 }
 if(empty($_REQUEST['page']))
 	$_REQUEST['page']=1;
 if(empty($_REQUEST['limit']))
 	$_REQUEST['limit']=50;

 $cmd=    "SELECT pc.*, pd1.dep_name AS create_dep_name, pd2.dep_name AS update_dep_name 
				FROM ppers_type pc
				LEFT JOIN pmt_department pd1 ON pc.create_dep_code=pd1.dep_code
				LEFT JOIN pmt_department pd2 ON pc.update_dep_code=pd2.dep_code
				WHERE 1 ".$con1." ORDER BY pers_type ASC";
 /*$data=$obj->pageData($_REQUEST['page'],$_REQUEST['limit'], 'ORDER BY pers_type ASC');*/
 $data=$obj->getAllCmdData($cmd);
?>