<?php
/*
 * Created on 27 ธ.ค. 2549
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $obj=new data('pcase_group_setup');
 $method=new method();
 if($_POST){
 	if($_REQUEST['Save']){
		if(empty($_REQUEST[no_edit_flag]))
			$_REQUEST[no_edit_flag]='';
 		if(empty($_REQUEST['action'])){
			$cmd="SELECT * FROM pcase_group_setup WHERE (REPLACE(group_name, ' ', '')='".str_replace(' ', '', $_REQUEST[group_name])."') 
			            OR group_type_id='".$_REQUEST[group_type_id]."'";
			//echo $cmd; exit;
			$tmp=$obj->getCmdData($cmd);
			if(empty($tmp[group_type_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{
				if($tmp[group_type_id]==$_REQUEST[group_type_id])
					$method->alert('พบข้อมูลรหัสการพ่วงสำนวน '.$_REQUEST[group_type_id].' นี้แล้ว');
				else $method->alert('พบข้อมูลประเภทการพ่วงสำนวน '.$_REQUEST[group_name].' นี้แล้ว');
				$method->go('fct2005.php');
			}
 		}else if($_REQUEST['action']=='edit'){
 			$_REQUEST[update_user_id]=$_SESSION[userCode];
			$_REQUEST[update_user]=$_SESSION[sesUserName];
			$_REQUEST[last_update_date]=$method->curDate();
			$_REQUEST[last_update_time]=$method->curTime();
			$obj->addField($_REQUEST);
 			$req['group_type_id']=$_REQUEST['edit_no'];
 			$obj->setCondition($req);
 			$obj->updateData();
 		}
 		$method->alert('บันทึกข้อมูลแล้ว');
 		$method->go('fct2005.php');
 	}

 }
 if($_REQUEST['action']=='del'){
 	$con['group_type_id']=$_REQUEST['edit_no'];
 	$obj->setCondition($con);
 	$obj->deleteData();
 	$method->alert('ลบข้อมูลแล้ว');
 	$method->go('fct2005.php');
 }
 if($_REQUEST['btnDel']){
	for($i=0;$i<sizeof($_REQUEST['hid_id']);$i++){
		if($_REQUEST['del'][$i]){
			$con['group_type_id']=$_REQUEST['hid_id'][$i];
			$obj->setCondition($con);
			$obj->deleteData();
		}
	}
	$method->alert('ลบข้อมูลแล้ว');
	$method->go('fct2005.php');
 }


 if($_REQUEST['action']=='edit'){
	$con['group_type_id']=$_REQUEST['edit_no'];
 	$obj->setCondition($con);
 	$edit=$obj->getData();
 }

 if(($_REQUEST['Search'])||($_REQUEST['sPage'])){
 	if(!empty($_REQUEST['group_type_id']))
 		$con1.=" AND group_type_id='".$_REQUEST[group_type_id]."'";
 	if(!empty($_REQUEST['group_name']))
 		$con1.=" AND group_name LIKE '%".$_REQUEST[group_name]."%'";
 	$obj->setCondition($con1);
 	$_REQUEST['sPage']=1;
 }

 $cmd="SELECT pc.*, pd1.dep_name AS create_dep_name, pd2.dep_name AS update_dep_name 
				FROM pcase_group_setup 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 group_type_id ASC";
 if(empty($_REQUEST['page']))
 	$_REQUEST['page']=1;
 if(empty($_REQUEST['limit']))
 	$_REQUEST['limit']=20;
 $data=$obj->getAllCmdData($cmd);
?>