<?php
/*
 * Created on 27 ธ.ค. 2549
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $obj=new data('pmt_case_cate');
 $method=new method();
 if($_POST){
 	if($_REQUEST['btnSave']){
		if(empty($_REQUEST[no_edit_flag]))
			$_REQUEST[no_edit_flag]='';
 		if(empty($_REQUEST['action'])){
			$cmd="SELECT * FROM pmt_case_cate WHERE 1 AND ( case_cate_name='".$_REQUEST[case_cate_name]."' OR case_cate_id='".$_REQUEST[case_cate_id]."')";
			//echo $cmd; exit;
			$tmp=$obj->getCmdData($cmd);
			if(empty($tmp[case_cate_id])){
				$obj->addField($_REQUEST);
				$obj->insertData();
			}else{
				$method->alert('พบข้อมูลชื่อประเภทคดีแล้ว');
				$method->go('fct0202.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
			}
 		}else if($_REQUEST['action']=='edit'){
			$obj->addField($_REQUEST);
 			$req['case_cate_id']=$_REQUEST['edit_no'];
 			$obj->setCondition($req);
 			$obj->updateData();
 		}
 		$method->alert('บันทึกข้อมูลแล้ว');
 		$method->go('fct0202.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 	}

 }
 /*
 if($_REQUEST['action']=='del'){
 	$con['case_cate_id']=$_REQUEST['edit_no'];
 	$obj->setCondition($con);
 	$obj->deleteData();
 	$method->alert('ลบข้อมูลแล้ว');
 	$method->go('fct0202.php');
 }*/

 if($_REQUEST['action']=='del'){
	for($i=0;$i<sizeof($_REQUEST['hid_id']);$i++){
		if($_REQUEST['sel'][$i]){
			$con['case_cate_id']=$_REQUEST['hid_id'][$i];
			$obj->setCondition($con);
			//$obj->echoDelete();
			$obj->deleteData();
		}
	}
	//$method->alert('ลบข้อมูลแล้ว');
	//$method->go('fct0202.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 }


 if($_REQUEST['action']=='edit'){
	$cmd="Select pc.*
		FROM pmt_case_cate pc
		WHERE pc.case_cate_id='".$_REQUEST['edit_no']."'";
 	$edit=$obj->getCmdData($cmd);
 }

 if(($_REQUEST['Search'])||($_REQUEST['sPage'])){
 	if(!empty($_REQUEST['case_cate_id']))
 		$con1.=" AND pc.case_cate_id='".$_REQUEST[case_cate_id]."'";
 	if(!empty($_REQUEST['case_cate_name']))
 		$con1.=" AND pc.case_cate_name LIKE '%".$_REQUEST[case_cate_name]."%'";
 	$obj->setCondition($con);
 	$_REQUEST['sPage']=1;
 }

 $cmd="Select pc.*,
		pd1.dep_name AS create_dep_name, pd2.dep_name AS update_dep_name 
		FROM pmt_case_cate 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 case_cate_id ASC";

 if(empty($_REQUEST['page']))
 	$_REQUEST['page']=1;
 if(empty($_REQUEST['limit']))
 	$_REQUEST['limit']=50;
 $data=$obj->getAllCmdData($cmd, $_REQUEST['page'],$_REQUEST['limit']);

 $cfg[pros_accu][1]='โจทก์';
 $cfg[pros_accu][2]='จำเลย';
?>