<?php
/*
 * Created on 27 ธ.ค. 2549
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
 $obj=new data('puser');
 $method=new method();
 if($_POST){
 	if($_REQUEST['Save']){
		if(!empty($_REQUEST[password])){
			$_REQUEST[password]=md5($_REQUEST[password]);
		}
		if(!empty($_REQUEST[court_id])){
			$cmd="SELECT court_running FROM pcourt WHERE court_id='".$_REQUEST[court_id]."'";
			$tmp=$obj->getCmdData($cmd);
			$_REQUEST[court_running]=$tmp[court_running];
		}
 		if(empty($_REQUEST['action'])){
			$_REQUEST[create_dep_code]=$_SESSION[sesDepCode];
			$_REQUEST[create_user_id]=$_SESSION[userCode];
			$_REQUEST[create_user]=$_SESSION[sesUserName];
			$_REQUEST[create_date]=date("d/m/").(date("Y")+543);;
			$_REQUEST[create_time]=date("H:i:s");
 			$obj->addField($_REQUEST);
 			$obj->insertData();
 		}else if($_REQUEST['action']=='edit'){
 			$_REQUEST[update_user_id]=$_SESSION[userCode];
			$_REQUEST[update_user]=$_SESSION[sesUserName];
			$_REQUEST[last_update_date]=date("d/m/").(date("Y")+543);;
			$_REQUEST[last_update_time]=date("H:i:s");
			$obj->addField($_REQUEST);
 			$req['user_id']=$_REQUEST['user_id'];
 			$obj->setCondition($req);
 			$obj->updateData();
 		}
 		$method->alert('บันทึกข้อมูลแล้ว');
 		$method->go('user_data.php');
 	}
 }
 if($_REQUEST['action']=='del'){
	 if(!empty($_REQUEST['edit_no'])){
		$req['user_id']=$_REQUEST['edit_no'];
		$obj->setCondition($con);
		$obj->deleteData();
		$method->alert('ลบข้อมูลแล้ว');
		$method->go('user_data.php');
	 }else{
		$method->alert('ไม่สามารถลบข้อมูลได้');
		$method->go('user_data.php');
	 }
 }
 if($_REQUEST['btnDel']){
	for($i=0;$i<sizeof($_REQUEST['edit_no']);$i++){
		if($_REQUEST['del'][$i]){
			$con['user_id']=$_REQUEST['edit_no'][$i];
			$obj->setCondition($con);
			$obj->deleteData();
		}
	}
	$method->alert('ลบข้อมูลแล้ว');
	$method->go('user_data.php?limit='.$_REQUEST['limit'].'&page='.$_REQUEST['page']);
 }


 if($_REQUEST['action']=='edit'){
	 $cmd="SELECT u.*, c.court_id, c.court_name
					FROM puser u
					LEFT JOIN pcourt c ON u.court_running=c.court_running
					WHERE u.user_id='".$_REQUEST[edit_no]."'";
 	//$con['user_id']=$_REQUEST['edit_no'];
 	//$obj->setCondition($con);
 	$edit=$obj->getCmdData($cmd);
 }
 if(($_REQUEST['Search'])||($_REQUEST['sPage'])){
 	if(!empty($_REQUEST['user_name']))
 		$con1.=" AND u.user_name='".$_REQUEST[user_name]."'";
 	if(!empty($_REQUEST['email']))
 		$con1.=" AND u.email='".$_REQUEST[email]."'";
 	if(!empty($_REQUEST['user_full_name']))
 		$con1.=" AND u.user_full_name LIKE '%".$_REQUEST[user_full_name]."%'";
 	if(!empty($_REQUEST['court_id']))
 		$con1.=" AND c.court_id='".$_REQUEST[court_id]."'";
 	if(!empty($_REQUEST['court_name']))
 		$con1.=" AND c.court_name LIKE '%".$_REQUEST[court_name]."%'";
 	$obj->setCondition($con);
 	$_REQUEST['sPage']=1;
 } 

 $cmd="SELECT * FROM puser u
				LEFT JOIN pcourt c ON u.court_running=c.court_running
				WHERE 1 ".$con1." ORDER BY u.user_id ASC";

 //echo $cmd; exit;
 if(empty($_REQUEST['page']))
 	$_REQUEST['page']=1;
 if(empty($_REQUEST['limit']))
 	$_REQUEST['limit']=20;
 $data=$obj->getAllCmdData($cmd, $_REQUEST['page'],$_REQUEST['limit']);
 /*
SELECT court_name, court_id AS user_name, concat( cast( substring( court_id, 1, 3 ) AS unsigned ) , cast( substring( court_id, 5, 3 ) AS unsigned ) , court_running ) AS
PASSWORD FROM pcourt

UPDATE `pcourt` SET `password`=MD5(concat( cast( substring( court_id, 1, 3 ) AS unsigned ) , cast( substring( court_id, 5, 3 ) AS unsigned ) , court_running )) WHERE 1
 */

?>