<?php
/*
 * Created on 27 ธ.ค. 2549
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $obj=new data('pallegation');
 $method=new method();

if($_REQUEST[chkMax]){	
	 $cmd="SELECT MAX(CAST(alle_id AS DECIMAL)) AS alle_id FROM pallegation WHERE 1";
	 $max=$obj->getCmdData($cmd);
	 if(!empty($max[alle_id]))
		echo $max[alle_id];
	 else
		 echo '0';
	 exit;
}

 if($_POST){
 	if($_REQUEST['Save']&&(!empty($_REQUEST[alle_id]))){
		if(empty($_REQUEST[user_select]))
			$_REQUEST[user_select]='';
 		if(empty($_REQUEST['action'])){
			$cmd="SELECT * FROM pallegation WHERE alle_id='".$_REQUEST[alle_id]."'";
			//echo $cmd; exit;
			$tmp=$obj->getCmdData($cmd);
			if(empty($tmp[alle_id])){
				$_REQUEST[create_dep_code]=$_SESSION[sesDepCode];
				$_REQUEST[create_user_id]=$_SESSION[userCode];
				$_REQUEST[create_user]=$_SESSION[sesUserName];
				$_REQUEST[create_date]=$method->curDate();
				$_REQUEST[create_time]=$method->curTime();
				$obj->addField($_REQUEST);
				$obj->insertData();
			}else{
				$method->alert('พบข้อมูลรหัส '.$_REQUEST[alle_id].' นี้แล้ว');
				$method->go('fct0212.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
			}
 		}else if($_REQUEST['action']=='edit'){
 			// $req['case_type']=$_REQUEST['case_type'];
 			$req['alle_id']=$_REQUEST['edit_no'];
 			// $req['case_cate_group']=$_REQUEST['edit_case_cate_group'];
			$field=$_REQUEST;
			// unset($field['case_type']);
			unset($field['alle_id']);
			// unset($field['case_cate_group']);
 			$field[update_user_id]=$_SESSION[userCode];
			$field[update_user]=$_SESSION[sesUserName];
			$field[last_update_date]=$method->curDate();
			$field[last_update_time]=$method->curTime();
			$obj->addField($field);
 			$obj->setCondition($req);
 			$obj->updateData();
 		}
 		$method->alert('บันทึกข้อมูลแล้ว');
 		$method->go('fct0212.php?sPage=1&limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 	}

 }
 if($_REQUEST['action']=='del'){
 	// $con['case_type']=$_REQUEST['case_type'];
 	$con['alle_id']=$_REQUEST['edit_no'];
 	$obj->setCondition($con);
 	$obj->deleteData();
 	$method->alert('ลบข้อมูลแล้ว');
 	$method->go('fct0212.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 }
 
 if($_REQUEST['btnDel']){
	for($i=0;$i<sizeof($_REQUEST['hid_id']);$i++){
		if($_REQUEST['sel'][$i]){
			//if(($_REQUEST[hid_sub_group_id][$i]==9)||($_SESSION[userLevel]=='A')){
				$con['alle_running']=$_REQUEST['hid_id'][$i];
				// $con['case_type']=$_REQUEST['case_type'];
				// $con['case_cate_group']=$_REQUEST['hid_case_cate_group'][$i];
				$obj->setCondition($con);
				$obj->deleteData();
			//}
		}
	}
	$method->alert('ลบข้อมูลแล้ว');
	$method->go('fct0212.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 }


 if($_REQUEST['action']=='edit'){
	$cmd="SELECT pa.*, pd1.dep_name AS create_dep_name, pd2.dep_name AS update_dep_name
				FROM pallegation pa				
				LEFT JOIN pmt_department pd1 ON pa.create_dep_code=pd1.dep_code
				LEFT JOIN pmt_department pd2 ON pa.update_dep_code=pd2.dep_code
				WHERE pa.alle_running='".$_REQUEST['edit_no']."'";
 	//echo $cmd; exit;
	$edit=$obj->getCmdData($cmd);
 }

 if(($_REQUEST['Search'])||($_REQUEST['sPage'])){
 	//if(!empty($_REQUEST['case_type']))
 	//	$con1.=" AND pa.case_type='".$_REQUEST[case_type]."'";
 //	if(!empty($_REQUEST['case_cate_group']))
 //		$con1.=" AND pt.case_cate_group='".$_REQUEST[case_cate_group]."'";
 	if(!empty($_REQUEST['alle_id']))
 		$con1.=" AND alle_id='".$_REQUEST[alle_id]."'";
// 	if(!empty($_REQUEST['stat_group']))
//		$con1.=" AND pa.stat_group='".$_REQUEST[stat_group]."'";
// 	if(!empty($_REQUEST['sub_group_id']))
// 		$con1.=" AND pa.sub_group_id='".$_REQUEST[sub_group_id]."'";
 	if(!empty($_REQUEST['alle_name']))
 		$con1.=" AND alle_name LIKE '%".$_REQUEST[alle_name]."%'";
 	$obj->setCondition($con1);
 	$_REQUEST['sPage']=1;
 }

 $cmd="SELECT pa.*,  pd1.dep_name AS create_dep_name, pd2.dep_name AS update_dep_name 
				FROM pallegation pa				
				LEFT JOIN pmt_department pd1 ON pa.create_dep_code=pd1.dep_code
				LEFT JOIN pmt_department pd2 ON pa.update_dep_code=pd2.dep_code
				WHERE 1 ".$con1." ORDER BY alle_id ASC";
 if(empty($_REQUEST['page']))
 	$_REQUEST['page']=1;
 if(empty($_REQUEST['limit']))
 	$_REQUEST['limit']=20;
 //echo $cmd;
 $data=$obj->getAllCmdData($cmd, $_REQUEST['page'],$_REQUEST['limit']);

 //if(empty($edit['stat_group']))
 //	$edit['stat_group']=$_REQUEST['stat_group'];
 //if(empty($edit['sub_group_id']))
 //	$edit['sub_group_id']=$_REQUEST['sub_group_id'];
 //if(empty($edit['case_type']))
 //	$edit['case_type']=$_REQUEST['case_type'];
 //if(empty($edit['case_cate_group']))
 //	$edit['case_cate_group']=$_REQUEST['case_cate_group'];

if(empty($_REQUEST[action]))
	$edit[user_select]=1;

 $cfg[group_desc][1]='คดีมีข้อพิพาทตามประมวลกฎหมายแพ่งและพาณิชย์';
 $cfg[group_desc][2]='คดีไม่มีข้อพิพาทตามประมวลกฎหมายแพ่งและพาณิชย์';
 $cfg[group_desc][3]='คดีมีข้อพิพาทตามกฎหมายอื่น';
 $cfg[group_desc][4]='ข้อหาอื่นในคดี';
 $cfg[group_desc][5]='ข้อหาอื่น ๆ นอกเหนือจากบัญชีคดี';

// $cmd="SELECT case_type, case_cate_group, GROUP_CONCAT(stat_group, '#', group_name) AS name FROM pstat_group_master WHERE 1 GROUP BY case_type, case_cate_group ORDER BY stat_group ASC";
// $statM=$obj->getAllCmdData($cmd);
// $lstM="\t var lstM=new Array();\n";
// for($i=0;$i<$statM[0][rows];$i++){
//	$lstM.="\t lstM['".$statM[$i][case_type]."#".$statM[$i][case_cate_group]."']='".$statM[$i][name]."';\n";
 //}

// $cmd="SELECT CONCAT(case_type, '_', stat_group) AS id, GROUP_CONCAT(sub_group_id, '#', sub_group_name) AS name FROM pstat_group WHERE 1 GROUP BY case_type, stat_group";
// $statS=$obj->getAllCmdData($cmd);
// $lstS="\t var lstS=new Array();\n";
 for($i=0;$i<$statS[0][rows];$i++){
	$lstS.="\t lstS['".$statS[$i][id]."']='".$statS[$i][name]."';\n";
 }

//$cmd="SELECT GROUP_CONCAT( CONCAT( case_cate_group,  '#', case_cate_group_name ) ORDER BY case_cate_group ) AS case_cate_group, case_type
//				FROM pmt_case_cate_group
//				WHERE valid_flag='Y' GROUP BY case_type";
//$tmp=$obj->getAllCmdData($cmd);
//for($i=0;$i<$tmp[0][rows];$i++)
//	$hdData.="\t\t title['";\n";

//if(!$edit[case_type]){
//	$edit[case_type]=$_REQUEST[case_type];
//}
//if(!$edit[case_cate_group]){
///	$edit[case_cate_group]=$_REQUEST[case_cate_group];
//}
if(!$edit[alle_id]){
	$edit[alle_id]=$_REQUEST[alle_id];
}
//if(!$edit[stat_group]){
//	$edit[stat_group]=$_REQUEST[stat_group];
//}
//if(!$edit[sub_group_id]){
//	$edit[sub_group_id]=$_REQUEST[sub_group_id];
//}
if(!$edit[alle_name]){
	$edit[alle_name]=$_REQUEST[alle_name];
}
?>