|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /home/pathumthani_integration/integration/application/labor/js/ |
Upload File : |
<?
session_start();
include("../../config/config_durable_articles.inc.php");
//$sql_select='';
//echo $_POST[heditcontract];
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
//echo $_POST['hAction'];
if($_POST['hAction']=='SAVEDATA')
{
#prepare where cond
$arr_list = $_SESSION['DA_LIST'];
$where_cond = " AND list_id IN(";
$where_delete="";
foreach($arr_list as $key => $value)
{
if($value[3] == 'd')
{
$where_delete .= $value[0].",";
}
else
{
$where_cond.= $value[0].",";
}
}
$where_cond = substr($where_cond,0,strlen($where_cond)-1);
$where_delete = substr($where_delete,0,strlen($where_delete)-1);
$where_cond .= ")";
# end prepare where cond
# delete for flag='d'
$sql_del = "DELETE FROM da_rotation WHERE da_list_runid in($where_delete) AND status in('b','o')";
//echo $sql_del;
//exit();
mysql_db_query($dbname,$sql_del);
# update rotation_status to '' or null
mysql_db_query($dbname,"UPDATE da_list SET rotation_status=null WHERE list_id in($where_delete)");
$sql_select = " SELECT dl.*,dt.type_name";
$sql_select .= " FROM da_list dl";
$sql_select .= " LEFT JOIN da_type dt ON dl.da_name=dt.type_id";
$sql_select .= " WHERE 1=1 ";
$sql_select .= $where_cond;
//echo $sql_select;
//exit();
$res_sql_select = mysql_db_query($dbname,$sql_select);
while($rs_sql_select = mysql_fetch_assoc($res_sql_select))
{
//$runid = "";
$da_list_runid = $rs_sql_select['list_id'];
$doc_no = $_POST['txt_doc_no'];
$doc_date = dateKeyToMysqlDate($_POST['txt_docdate']);
$list_name = $rs_sql_select['type_name'];
$da_id = $rs_sql_select['da_id'];
$borrow_user = $_POST['sel_borrow_user'];
//echo $borrow_user;
//exit();
$borrow_pos = $_POST['txt_borrow_pos'];
$borrow_date = dateKeyToMysqlDate($_POST['txt_borrow_date']);
$lend_user = $_POST['sel_lend_user'];
$lend_pos = $_POST['txt_lend_pos'];
$lend_date = dateKeyToMysqlDate($_POST['txt_lend_date']);
$order_user = $_POST['txt_order_user'];
$order_pos = $_POST['txt_order_pos'];
$order_date = dateKeyToMysqlDate($_POST['txt_order_date']);
$division = $_POST['sel_department'];
$status = $_POST['rad_rotation_'.$rs_sql_select['list_id']];
$remark = $_POST['txt_remark_'.$rs_sql_select['list_id']];
$create_user = $_SESSION['session_username'];
$list_id = $rs_sql_select['list_id'];
//$create_datetime = "";
//checkdup
$sql_dup = "select * from da_rotation dr where dr.da_list_runid = '$list_id' AND dr.doc_no='$doc_no' AND dr.status in('b','o') order by create_datetime";
//echo $sql_dup;
//exit();
$res_dup = mysql_db_query($dbname,$sql_dup);
$rs_dup = mysql_fetch_assoc($res_dup);
$runid = $rs_dup['runid'];
if($rs_dup['runid'])
{
$sql_update = " UPDATE da_rotation SET";
//$sql_update .= "da_list_runid,";
$sql_update .= " doc_no='$doc_no',";
$sql_update .= " doc_date='$doc_date',";
$sql_update .= " list_name='$list_name',";
$sql_update .= " da_id='$da_id',";
$sql_update .= " borrow_user='$borrow_user',";
$sql_update .= " borrow_pos='$borrow_pos',";
$sql_update .= " borrow_date='$borrow_date',";
$sql_update .= " lend_user='$lend_user',";
$sql_update .= " lend_pos='$lend_pos',";
$sql_update .= " lend_date='$lend_date',";
$sql_update .= " order_user='$order_user',";
$sql_update .= " order_pos='$order_pos',";
$sql_update .= " order_date='$order_date',";
$sql_update .= " division='$division',";
$sql_update .= " status='$status',";
$sql_update .= " remark='$remark'";
$sql_update .= " WHERE ";
$sql_update .= " runid='$runid'";
//$sql_update .= "create_user='$doc_date',";
//$sql_update .= "create_datetime='$doc_date'";
//echo $sql_update;
//exit();
mysql_db_query($dbname,$sql_update);
}
else
{
$sql_insert = "INSERT INTO da_rotation(";
//$sql_insert .= "runid,";
$sql_insert .= "da_list_runid,";
$sql_insert .= "doc_no,";
$sql_insert .= "doc_date,";
$sql_insert .= "list_name,";
$sql_insert .= "da_id,";
$sql_insert .= "borrow_user,";
$sql_insert .= "borrow_pos,";
$sql_insert .= "borrow_date,";
$sql_insert .= "lend_user,";
$sql_insert .= "lend_pos,";
$sql_insert .= "lend_date,";
$sql_insert .= "order_user,";
$sql_insert .= "order_pos,";
$sql_insert .= "order_date,";
$sql_insert .= "division,";
$sql_insert .= "status,";
$sql_insert .= "remark,";
$sql_insert .= "create_user,";
$sql_insert .= "create_datetime";
$sql_insert .= ") VALUES (";
//$sql_insert .=" '$runid',";
$sql_insert .=" '$da_list_runid',";
$sql_insert .=" '$doc_no',";
$sql_insert .=" '$doc_date',";
$sql_insert .=" '$list_name',";
$sql_insert .=" '$da_id',";
$sql_insert .=" '$borrow_user',";
$sql_insert .=" '$borrow_pos',";
$sql_insert .=" '$borrow_date',";
$sql_insert .=" '$lend_user',";
$sql_insert .=" '$lend_pos',";
$sql_insert .=" '$lend_date',";
$sql_insert .=" '$order_user',";
$sql_insert .=" '$order_pos',";
$sql_insert .=" '$order_date',";
$sql_insert .=" '$division',";
$sql_insert .=" '$status',";
$sql_insert .=" '$remark',";
$sql_insert .=" '$create_user',";
$sql_insert .=" now()";
$sql_insert .= ")";
mysql_db_query($dbname,$sql_insert);
}
$sql_da_list_update = " UPDATE da_list";
$sql_da_list_update .= " SET";
$sql_da_list_update .= " rotation_status='$status'";
$sql_da_list_update .= " WHERE ";
$sql_da_list_update .= " list_id='$list_id'";
mysql_db_query($dbname,$sql_da_list_update);
unset($_SESSION['DA_LIST']);
unset($_SESSION["DA_CONTRACT"]);
}
print"<meta http-equiv=\"refresh\" content=\"0;URL=durable_articles_borrow.php?action=\">\n";
exit();
}
}
function dateKeyToMysqlDate($d)
{
$d2 = explode("/",$d);
if(count($d2) < 3)
{
return '';
}
$d3[0] = $d2[2]-543;
$d3[1] = $d2[1];
$d3[2] = $d2[0];
return implode("-",$d3);
}
function mysqlDateToDateKey($d)
{
$d2 = explode("-",$d);
if(count($d2) < 3 || $d=='0000-00-00')
{
return '';
}
$d3[1] = $d2[2];
$d3[2] = $d2[1];
$d3[3] = $d2[0]+543;
return implode("/",$d3);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<TITLE> ระบบสนับสนุนการจัดการครุภัณฑ์</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<style>
.bg_th{
background-image:url(images/horiz-bg.png);
background-repeat:repeat-x;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
.style1 {color: #FF0000}
.style2 {color: #EEEEEE}
</style>
<script language="javascript" src="js/function.js"></script>
<script language="javascript" src="js/daily_popcalendar.js"></script>
<script type="text/javascript">
function Inint_AJAX() {
try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE
try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE
try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript
alert("XMLHttpRequest not supported");
return null;
}
function checkDocNoDupAjax(src,doc_no,doc_no_ori) {
if(doc_no_ori != doc_no || trim(doc_no_ori) == '')
{
var req = Inint_AJAX();
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
document.getElementById(src).innerHTML = req.responseText;
}
}
};
req.open("GET", "ajax.rotation.php?action=checkdup&doc_no="+doc_no); //สร้าง connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
req.send(null); //ส่งค่า
}
}
function createListUserAjax(src,staffgroup_id) {
var req = Inint_AJAX();
req.onreadystatechange = function () {
if (req.readyState==4) {
if (req.status==200) {
document.getElementById(src).innerHTML = req.responseText;
}
}
};
req.open("GET", "ajax.rotation.php?action=getlistuser&staffgroup_id="+staffgroup_id); //สร้าง connection
req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header
req.send(null); //ส่งค่า
}
function deleteList(id,da_id)
{
if(confirm('ยืนยันลบ ครุภัณฑ์หมายเลข '+da_id+' '))
{
//window.location.href="?action=delete&id="+id;
//form1.submit();
var h = document.getElementById('hdel');
h.value = "yes";
document.form1.action = "?action=add&id="+id;
document.form1.submit();
}
}
function deleteDoc(contract_no)
{
if(confirm('ยืนยันลบ '+contract_no+' '))
{
//window.location.href="?action=delete&id="+id;
//form1.submit();
var h = document.getElementById('hdelcontract');
h.value = "yes";
document.form1.action = "?action=&id="+contract_no;
document.form1.submit();
}
}
function editDoc(contract_no)
{
var h = document.getElementById('heditcontract');
h.value = "yes";
document.form1.action = "?action=add&id="+contract_no;
document.form1.submit();
}
function checkForm(num)
{
var t = document.getElementById('table1');
//var num = t.rows.length;
//alert('num : '+num);
if(num<1)
{
alert('! กรุณาเลือกครุภัณฑ์');
//form1.txt_doc_no.focus();
return false;
}
for(i=1;i<=num;i++)
{
var rd1 = document.getElementById('rad_rotation1_'+i);
var rd2 = document.getElementById('rad_rotation2_'+i);
//var div1 = document.getElementById('spanAlert'+i);
//var div2 = document.getElementById('spanAlert2'+i);
//alert(rd1);
//alert(rd2);
//div1.innerHTML = "";
//div2.innerHTML = "";
if(!rd1.checked && !rd2.checked)
{
alert('! กรุณาระบุ ยืม หรือ โอน ');
//div1.innerHTML = "*";
//div2.innerHTML = "*";
//rd1.focus();
return false;
}
//alert('xx2');
}
if(trim(document.form1.txt_doc_no.value)=='')
{
alert('! กรุณาระบุเลขที่เอกสาร');
document.form1.txt_doc_no.focus();
return false;
}
if(trim(document.form1.txt_docdate.value)=='')
{
alert('! กรุณาระบุวันที่เอกสาร');
document.form1.txt_docdate.focus();
return false;
}
if(!checkThaiDate(document.form1.txt_docdate.value))
{
alert('! กรุณาระบุวันที่เอกสาร ให้ถูกต้อง');
document.form1.txt_docdate.focus();
return false;
}
if(document.form1.txt_borrow_date.value != '')
{
if(!checkThaiDate(document.form1.txt_borrow_date.value))
{
alert('! กรุณาระบุวันที่ ให้ถูกต้อง');
document.form1.txt_borrow_date.focus();
return false;
}
}
if(document.form1.txt_lend_date.value != '')
{
if(!checkThaiDate(document.form1.txt_lend_date.value))
{
alert('! กรุณาระบุวันที่ ให้ถูกต้อง');
document.form1.txt_lend_date.focus();
return false;
}
}
if(document.form1.txt_order_date.value != '')
{
if(!checkThaiDate(document.form1.txt_order_date.value))
{
alert('! กรุณาระบุวันที่ ให้ถูกต้อง');
document.form1.txt_order_date.focus();
return false;
}
}
//var d = explode("/",form1.txt_docdate.value);
// if(trim(form1.txt_borrow_user.value)=='')
// {
// alert('! กรุณาระบุชื่อผู้เบิก');
// form1.txt_borrow_user.focus();
// return false;
// }
//alert('xxx');
// if(trim(form1.txt_lend_user.value)=='')
// {
// alert('! กรุณาระบุชื่อผู้จ่าย');
// form1.txt_lend_user.focus();
// return false;
// }
if(trim(document.form1.txt_order_user.value)=='')
{
alert('! กรุณาระบุชื่อผู้สั่งจ่าย');
document.form1.txt_order_user.focus();
return false;
}
var di = document.getElementById('divDocNoAlert');
if(trim(di.innerHTML) != '')
{
alert('! เลขที่เอกสารซ้ำ');
document.form1.txt_doc_no.focus();
return false;
}
document.form1.hAction.value = 'SAVEDATA'; // for save
document.form1.action = "?action=add";
document.form1.submit();
return true;
}
function trim(text)
{
return text.replace( /^\s+|\s+$/g, "" );
}
function checkThaiDate(DDMMBBBB)
{
// regular expression to match required date format
re = /^(\d{1,2})\/(\d{1,2})\/(\d{4})$/;
var DDMMBBBB = trim(DDMMBBBB);
if(DDMMBBBB != '') {
if(regs = DDMMBBBB.match(re)) {
var yyyy=parseInt(regs[3]);
var mm=parseInt(regs[2]);
var dd=parseInt(regs[1]);
//return false;
//alert(dd);
if(dd < 1 || dd > 31) {
//alert(dd);
return false;
}
if(mm < 1 || mm > 12) {
//alert(mm);
return false;
}
var BBBB = yyyy - 543;
if(BBBB < 1902 ) {
//alert(BBBB);
return false;
}
if(mm == 2){
if( (BBBB % 4 == 0) || (BBBB % 100 == 0) )
{
if(dd > 29)
{
return false;
}
}
else
{
if(dd > 28)
{
return false;
}
}
}
return true;
} else {
return false;
}
}
}
</script>
</HEAD>
<BODY>
<?php include("header.php"); ?>
<?php include("../../common/common.inc.php") ?> <strong style="color:#000033; font-size:18px;"><img src="images/unpublish_f2.png" align="absmiddle" border="0"/>ข้อมูลการยืม/โอนครุภัณฑ์</strong>
<form id="form1" name="form1" method="post" action="">
<?
$rowid=0;
if($_GET['action'] != 'add' && $_GET['action'] != 'detail' && $_GET['action'] != 'edit')
{
if($_POST['hdelcontract'] == 'yes')
{
$sql_update_list = "UPDATE da_list
SET
rotation_status=null
WHERE
list_id in
(
select da_list_runid from da_rotation
)
";
mysql_db_query($dbname,$sql_update_list);
$sql_delete_contract = "DELETE
FROM da_rotation
WHERE
doc_no='".$_GET[id]."'
AND status in('b','o')
";
mysql_db_query($dbname,$sql_delete_contract);
}
?>
<table align="center" width="99%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td>
<?php
# query for dash board
$strSQL="";
$cond='';
if($_GET[runid] != '')
{
$cond = ' AND dc.runid='.$_GET[runid];
}
$strSQL = " SELECT *,
es.groupname,
pgl.project_group_name
FROM da_contract dc
LEFT JOIN epm_staffgroup es ON es.gid=dc.division
LEFT JOIN project_group_lbl pgl ON pgl.pgid=dc.project
WHERE 1=1 "
.$cond."
ORDER BY contract_date";
$res = mysql_db_query($dbname,$strSQL);
if(isset($cols))
{
//$strSQL .= " ORDER BY ".$cols." ".$sort;
}
//echo "<br>".$strSQL;
$rsConn = mysql_db_query($dbname,$strSQL);
$all_row = mysql_num_rows($rsConn);
$board_row_per_page = 10;
$total_page = ceil($all_row/$board_row_per_page);
$page = ($_GET['page'])?$_GET['page']:1;
$page = ($page > $total_page)?$total_page:$page;
$page = ($page <= 0)?1:$page;
$limit_start = ($page==1)?0:(($page*$board_row_per_page)-$board_row_per_page);
$limit_end = $board_row_per_page;
if($View==''){
$strSQL .= " LIMIT ".$limit_start.", ".$limit_end;
$num = $limit_start ;
}
if(isset($cols)&&isset($sort)){
$solink="&cols=$cols&sort=$sort";
}
//$text_search = ($_GET['b_search'])?"b_search=ค้นหา&letter_code_search=".$_GET['letter_code_search']."&letter_code2_search=".$_GET['letter_code2_search']."&letter_name_search=".$_GET['letter_name_search']."&letter_secname_search=".$_GET['letter_secname_search']."&LetterType_search=".$_GET['LetterType_search']."&name_search=".$_GET['name_search']."&letter_surname_search=".$_GET['letter_surname_search']."&date_order=".$_GET['date_order']."&date_order2=".$_GET['date_order2']:"";
//$text_search = "&sel_aumpur=".$_GET['sel_aumpur']."&sel_year=".$_GET['sel_year']."&sel_district=".$_GET['sel_district'];
$prev_page = $page - 1; $prev_page = ($prev_page <= 1)?1:$prev_page;
$prev = "self.location='".$PHP_SELF."?p=durable_articles_borrow.php".$text_search."&action=&search=$search&page=$prev_page$link$solink'";
$next_page = $page + 1; $next_page = ($next_page >= $total_page)?$total_page:$next_page;
$next = "self.location='".$PHP_SELF."?p=durable_articles_borrow.php".$text_search."&action=&search=$search&page=$next_page$link$solink'";
$prev_Tenpage=$page-$board_row_per_page;$prev_Tenpage=($prev_Tenpage<= 1)?1:$prev_Tenpage;
$prevTen = "self.location='".$PHP_SELF."?p=durable_articles_borrow.php".$text_search."&action=&search=$search&page=$prev_Tenpage$link$solink'";
$nextTenPage=$page+$board_row_per_page;$next_TenPage=($next_TenPage >= $total_page)?$total_page:$next_TenPage;
$nextTen = "self.location='".$PHP_SELF."?p=durable_articles_borrow.php".$text_search."&action=&search=$search&page=$nextTenPage$link$solink'";
?>
<? if($View==""){$Klink="?p=durable_articles_borrow.php".$text_search."&action&View=All"; $CSh="ข้อมูลทั้งหมด"; $Klink2="?".$text_search."&View=";}else{$Klink="?p=durable_articles_borrow.php".$text_search."&action=&View=";$CSh="ข้อมูล ".$board_row_per_page." รายการล่าสุด";$Klink2="?p=complain_detail.php".$text_search."&View=All";}?>
ทั้งหมด <b> <font color="#CC0000">
<?=number_format($all_row);?>
</font> </b> รายการ
<? if($View==""){?>
แบ่งเป็น <b><font color="#0033CC">
<?=number_format($total_page);?>
</font></b> หน้า
<? }?>
<a href="<?=$Klink?>"><img src="img/Search-Add.gif" alt="<?=$CSh?>" width="16" height="16" border="0" /></a>
<? if($View==''){?>
<? if($page==1){?>
<img src="img/page_div_icon/xFirst.gif" />
<? }else{?>
<img src="img/page_div_icon/First.gif" align="absmiddle" border="0" width="10" height="12" onClick="<?=$prevTen;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<? if($page==1){?>
<img src="img/page_div_icon/xPrevious.gif" />
<? }else{?>
<img src="img/page_div_icon/Previous.gif" align="absmiddle" border="0" width="7" height="12" onClick="<?=$prev;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<?php
$board_link_num = $board_row_per_page;
$ii = 1;
if ( $board_link_num > $total_page ){
$loop_page = $total_page;
} else {
$bx = ceil($board_link_num / 2);
$pp = $page - $bx;
$pn = $page + $bx;
$loop_page = $pn;
$ii = $pp;
if ( $total_page <= $loop_page ) {
$loop_page = $total_page;
$ii = $loop_page - ($board_link_num -1);
}
if ( $ii < 1 ) {
$ii = 1;
$loop_page = $ii + ($board_link_num -1);
}
}
for($i=$ii;$i<=$loop_page;$i++){
if ( $i==$page || !$page ) {
$txt = "<b>$i</b>";
} else {
$txt = $i;
}
?>
<a href="<?=$PHP_SELF;?>?p=durable_articles_borrow.php&sort=<?=$sort;?>&action=&search=<?=$search?><?=$text_search?>&page=<?=$i;?>">
<?=$txt;?>
</a>
<?
} # for
?>
<? if($page==$loop_page){?>
<img src="img/page_div_icon/xNext.gif" />
<? }else{?>
<img src="img/page_div_icon/Next.gif" align="absmiddle" border="0" width="7" height="12" onClick="<?=$next;?>" onMouseOver="style.cursor='hand';"/>
<? }?>
<? if($page==$loop_page){?>
<img src="img/page_div_icon/xLast.gif" />
<? }else{?>
<img src="img/page_div_icon/Last.gif" align="absmiddle" border="0" width="10" height="12" onClick="<?=$nextTen;?>" onMouseOver="style.cursor='hand';"/>
<?
}
}#End View=
$sort=$_GET['sort']=='ASC' ? 'DESC' : 'ASC';
?>
</td>
<td align="right"><strong style="color:#000033;"><img src="images/add.png" align="absmiddle" border="0"/><strong style="color:#000033;"><a href="durable_articles_borrow.php?action=add&clear=ok">เพิ่มรายการ</a></strong></td>
</tr>
</table>
<table width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr >
<td class="bg_th" width="20">ลำดับ</td>
<td class="bg_th" >ใบเบิกเลขที่</td>
<td class="bg_th">วันที่ยื่นเอกสาร</td>
<td class="bg_th">ผู้ยื่นเอกสาร</td>
<td class="bg_th">หน่วยงานที่ยื่น</td>
<td class="bg_th" width="96">จำนวนรายการ</td>
<td class="bg_th" width="76" align="center">การจัดการ</td>
</tr>
<?
//echo "action : ".$_GET['action'];
$sql_docno = "select count(doc_no) 'cnt_doc',doc_date,doc_no,borrow_date,borrow_user,groupname,staffname,staffsurname from da_rotation dr left join epm_staffgroup esg on esg.gid=dr.division left join epm_staff es ON dr.borrow_user=es.staffid WHERE dr.status in('b','o') group by doc_no,doc_date,borrow_date,borrow_user,groupname,staffname,staffsurname ";
//echo $sql_docno;
$res_doc = mysql_db_query($dbname,$sql_docno);
while($rs_doc = mysql_fetch_assoc($res_doc))
{
$rowid++;
?>
<tr bgcolor="#FFFFFF">
<td width="20"><?=$rowid?></td>
<td align="center"><a href="?action=detail&id=<?=$rs_doc['doc_no']?>"><?=$rs_doc['doc_no']?></a></td>
<td align="center"><?=dateFormat($rs_doc['doc_date'],'thaidot')?></td>
<td ><?=$rs_doc['staffname'].' '.$rs_doc['staffsurname']?></td>
<td ><?=$rs_doc['groupname']?></td>
<td align="center"><?=$rs_doc['cnt_doc']?></td>
<td align="center"><a href="javascript:editDoc('<?=$rs_doc[doc_no]?>')"><img src="img/icon-write.png" border="0" /></a> <a href="javascript:deleteDoc('<?=$rs_doc[doc_no]?>')"><img src="img/icon-delete.png" border="0" /></a></td>
</tr>
<?
}
?>
</table>
<?
}
else if($_GET['action'] == 'detail')
{
?>
<table align="center" width="99%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td> </td>
<td align="right"><strong style="color:#000033;"><a href="durable_articles_borrow.php?action=">ใบเบิกเลขที่ <?=$_GET[id]?></a></strong></td>
</tr>
</table>
<table width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr >
<td class="bg_th" width="20">ลำดับ</td>
<td class="bg_th" width="160" >หมายเลขประจำครุภัณฑ์</td>
<td class="bg_th">ชื่อครุภัณฑ์</td>
<td class="bg_th" width="100">ยี่ห้อ</td>
<td class="bg_th" width="160">หมายเลขประจำเครื่อง</td>
<td class="bg_th" width="150"> หน่วยงาน</td>
<td class="bg_th" width="76" align="center">สถานะ</td>
</tr>
<?
//echo "action : ".$_GET['action'];
$sql_list = "select dl.da_id,type_name,brand,serial,status,groupname from da_rotation dr left join epm_staffgroup es on es.gid=dr.division inner join da_list dl on dl.list_id = dr.da_list_runid left join da_type dt on dt.type_id = dl.da_name WHERE 1=1 and dr.status in('b','o')";
$sql_list_cond = " AND doc_no='".$_GET[id]."' ORDER BY dr.create_datetime DESC";
$sql_list .= $sql_list_cond;
//echo $sql_list;
//exit();
$res_list = mysql_db_query($dbname,$sql_list);
while($rs_list = mysql_fetch_assoc($res_list))
{
$rowid++;
?>
<tr bgcolor="#FFFFFF">
<td width="20"><?=$rowid?></td>
<td align="center"><?=$rs_list['da_id']?></td>
<td ><?=$rs_list['type_name']?></td>
<td ><?=$rs_list['brand']?></td>
<td align="center"><?=$rs_list['serial']?></td>
<td ><?=$rs_list['groupname']?></td>
<td align="center"><?
if($rs_list['status']=='b')
{
echo 'ยืม';
}
elseif($rs_list['status']=='o')
{
echo 'โอน';
}
elseif($rs_list['status']=='r')
{
echo 'คืน';
}
?></td>
</tr>
<?
}
?>
</table>
<?
}
else if($_GET['action'] == 'add')
{
if($_GET['clear']=='ok')
{
unset($_SESSION['DA_LIST']);
unset($_SESSION["DA_CONTRACT"]);
}
?>
<table align="center" width="99%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td> </td>
<td align="right"><strong style="color:#000033;"><img src="images/add.png" align="absmiddle" border="0"/><strong style="color:#000033;"><a href="javascript:addDurableArticles();">เลือกครุภัณฑ์</a></strong></td>
</tr>
</table>
<table id="table1" width="99%" border="0" align="center" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr >
<td class="bg_th" width="50">ลำดับ</td>
<td class="bg_th" width="30">ยืม</td>
<td class="bg_th" width="30">โอน</td>
<td class="bg_th" width="160">หมายเลขประจำครุภัณฑ์</td>
<td class="bg_th" >รายการ</td>
<td class="bg_th" >ยี่ห้อ</td>
<td class="bg_th" width="237" align="center">หมายเหตุ</td>
<td class="bg_th" width="76" align="center">การจัดการ</td>
</tr>
<?
//echo "<pre>";
//print_r($_SESSION["DA_LIST"]);
//echo "</pre>";
if($_POST['hdel'] == 'yes')
{
$list_id = $_GET['id'];
$arr_list = $_SESSION["DA_LIST"];
//unset($arr_list[$list_id]);
$arr_list[$list_id][3] = 'd';
$_SESSION["DA_LIST"] = $arr_list;
// echo "<pre>";
// print_r($arr_list);
// echo "</pre>";
// exit();
}
if($_POST[heditcontract]=='yes')
{
$contract_no = $_GET[id];
$sql_select_contract = "select * from da_rotation where doc_no ='$contract_no' ";
//echo $sql_select_contract;
//exit();
$res_select_contract = mysql_db_query($dbname,$sql_select_contract);
//$rs_select_contract = mysql_fetch_assoc($res_select_contract);
$arr_list = array();
while($rs_select_contract= mysql_fetch_assoc($res_select_contract))
{
$arr_list[$rs_select_contract['da_list_runid']][0]=$rs_select_contract['da_list_runid'];
$arr_list[$rs_select_contract['da_list_runid']][1]=$rs_select_contract['status']; //status
$arr_list[$rs_select_contract['da_list_runid']][2]=$rs_select_contract['remark']; //remark
}
unset($_SESSION["DA_LIST"]);
$_SESSION["DA_LIST"] = $arr_list;
}
$arr_list = $_SESSION["DA_LIST"];
//print_r($arr_list);
//exit();
$rowid=0;
$table1_row=0;
foreach($arr_list as $key=>$value)
{
$list_id = $value[0];
if($value[3] <> 'd')
{
$sql_select_item = " SELECT distinct dl.*,du.*,dt.type_name ";
$sql_select_item .= " FROM da_list dl ";
$sql_select_item .= " LEFT JOIN da_unit du ON dl.unit_id = du.unit_id ";
$sql_select_item .= " LEFT JOIN da_type dt ON dl.da_name = dt.type_id ";
$sql_select_item .= " WHERE list_id=$list_id";
//echo $sql_select_item;
$res_item = mysql_db_query($dbname,$sql_select_item);
while($rs_item = mysql_fetch_assoc($res_item))
{
$rowid +=1;
$table1_row+=1;
?>
<tr bgcolor="#FFFFFF">
<td width="50"><?=$rowid?></td>
<td align="center"><input type="radio" value="b" <?=$value[1]=='b'? 'checked' : ''?> name="rad_rotation_<?=$rs_item['list_id']?>" id="rad_rotation1_<?=$rowid?>" /></td>
<td align="center"><input type="radio" value="o" <?=$value[1]=='o'? 'checked' : ''?> name="rad_rotation_<?=$rs_item['list_id']?>" id="rad_rotation2_<?=$rowid?>" /></td>
<td align="center"><?=$rs_item['da_id']?></td>
<td align="center" ><?=$rs_item['type_name']?></td>
<td align="center" ><?=$rs_item['brand']?></td>
<td align="center" width="237"><label>
<input type="text" name="txt_remark_<?=$rs_item['list_id']?>" size="30" value="<?=$value[2]?>"/>
</label></td>
<td align="center" width="76"><a href="javascript:deleteList('<?=$rs_item[list_id]?>','<?=$rs_item[da_id]?>')"><img src="img/icon-delete.png" border="0" /></a></td>
</tr>
<?
}
}
}
?>
</table>
<br />
<?
//echo $_POST[heditcontract];
$rs_select_contract;
if($_POST[heditcontract]=='yes')
{
$contract_no = $_GET[id];
$sql_select_contract = "select * from da_rotation where doc_no ='$contract_no' limit 1";
//echo $sql_select_contract;
//exit();
$res_select_contract = mysql_db_query($dbname,$sql_select_contract);
$rs_select_contract = mysql_fetch_assoc($res_select_contract);
$_SESSION["DA_CONTRACT"] = $rs_select_contract;
}
else
{
$rs_select_contract = $_SESSION["DA_CONTRACT"];
}
?>
<table width="99%" align="center" border="0" bgcolor="#CCCCCC" cellpadding="3" cellspacing="1">
<tr bgcolor="#FFFFFF" ><td bgcolor="#EEEEEE"><br />
<table width="85%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#EEEEEE" id="table1">
<tr >
<td width="95" >เลขที่เอกสาร:<span class="style1">* </span></td>
<input type="hidden" name="hdocnoold" id="hdocnoold" value="<?=$rs_select_contract['doc_no']?>"/>
<td width="230"><input type="text" name="txt_doc_no" id="txt_doc_no" value="<?=$rs_select_contract['doc_no']?>" size="15" maxlength="20" onblur="checkDocNoDupAjax('divDocNoAlert',this.value,form1.hdocnoold.value)"/> <span id="divDocNoAlert"></span></td>
<td> </td>
<td > </td>
<td width="66">หน่วยงาน:<span class="style1">*</span> </td>
<td ><?php
$sql_department = "SELECT * FROM epm_staffgroup WHERE groupname not like('G%') and groupname not like('A%') ORDER BY groupname";
$res_department = mysql_db_query($dbname,$sql_department);
$rowid = 0;
$selected_staffgroupd_id;
echo "<select name='sel_department' id='sel_department' onchange='createListUserAjax(\"divBorrowUser\",this.options[this.options.selectedIndex].value)'>";
$rs_department = mysql_fetch_assoc($res_department);
if($rs_select_contract['division'] == $rs_department['gid'])
{
echo '<option value="'.$rs_department['gid'].'" selected>'.$rs_department['groupname'].'</option>';
$selected_staffgroupd_id = $rs_department['gid'];
}else
{
echo '<option value="'.$rs_department['gid'].'">'.$rs_department['groupname'].'</option>';
}
while($rs_department = mysql_fetch_assoc($res_department))
{
$rowid++;
if($rs_select_contract['division'] == $rs_department['gid'])
{
echo '<option value="'.$rs_department['gid'].'" selected>'.$rs_department['groupname'].'</option>';
$selected_staffgroupd_id = $rs_department['gid'];
}
else
{
echo '<option value="'.$rs_department['gid'].'">'.$rs_department['groupname'].'</option>';
}
}
echo "</select>";
?></td>
<td width="95"> </td>
</tr>
<tr >
<td >วันที่เอกสาร:<span class="style1">*</span></td>
<td colspan="6"><input type="text" name="txt_docdate" id="txt_docdate" value="<?=mysqlDateToDateKey($rs_select_contract['doc_date'])?>" onblur="checkDate('txt_docdate');" onkeypress="chkDateFormat('txt_docdate',event)" onKeyUp="return isNumberKey('txt_docdate',event);" size="15" maxlength="10"/>
<img src="js/calendar/calendar2.gif" style="cursor:hand" title="วันเดือนปี" onclick="popUpCalendar(this, document.form1.txt_docdate, 'dd/mm/yyyy');" /></td>
</tr>
<tr >
<td > </td>
<td > </td>
<td> </td>
<td > </td>
<td > </td>
<td > </td>
<td > </td>
</tr>
<tr >
<td >ลงชื่อ:<span class="style1">*</span> </td>
<td ><div id='divBorrowUser'></div></td>
<td width="50">ผู้เบิก</td>
<td > </td>
<td >ลงชื่อ:<span class="style1">*</span> </td>
<td width="180" >
<select name="sel_lend_user" id="sel_lend_user">
<?
$sql_lend_user = "SELECT staffname,staffsurname,staffid FROM epm_staff WHERE staffname like '%พัสดุ%' ";
$res_lend_user = mysql_db_query($dbname,$sql_lend_user);
$rs_lend_user=mysql_fetch_assoc($res_lend_user);
if(isset($rs_lend_user[staffid]))
{
echo "<option selected value='".$rs_lend_user['staffid']."'>".$rs_lend_user['staffname']." ".$rs_lend_user['staffsurname']."</option>";
}
while($rs_lend_user=mysql_fetch_assoc($res_lend_user))
{
if($rs_select_contract['lend_user']==$rs_lend_user['staffid'])
{
echo "<option selected value='".$rs_lend_user['staffid']."'>".$rs_lend_user['staffname']." ".$rs_lend_user['staffsurname']."</option>";
}
else
{
echo "<option value='".$rs_lend_user['staffid']."'>".$rs_lend_user['staffname']." ".$rs_lend_user['staffsurname']."</option>";
}
}
?>
</select> </td>
<td >ผู้จ่ายครุภัณฑ์</td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span >ตำแหน่ง:</span></td>
<td bgcolor="#EEEEEE"><input name="txt_borrow_pos" type="text" id="txt_borrow_pos" value="<?=$rs_select_contract['borrow_pos']?>" size="30" /></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span >ตำแหน่ง:</span></td>
<td bgcolor="#EEEEEE" ><input name="txt_lend_pos" type="text" id="txt_lend_pos" value="<?=$rs_select_contract['lend_pos']?>" size="30"/></td>
<td align="right" bgcolor="#EEEEEE"><span class="style2"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span >วันที่:</span></td>
<td bgcolor="#EEEEEE"><span class="style2">
<input type="text" name="txt_borrow_date" id="txt_borrow_date" size="15" maxlength="10" value="<?=mysqlDateToDateKey($rs_select_contract['borrow_date'])?>"/>
<img src="js/calendar/calendar2.gif" title="วันเดือนปี" onclick="popUpCalendar(this, document.form1.txt_borrow_date, 'dd/mm/yyyy');" /></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span>วันที่:</span></td>
<td bgcolor="#EEEEEE" ><span class="style2">
<input type="text" name="txt_lend_date" id="txt_lend_date" size="15" maxlength="10" value="<?=mysqlDateToDateKey($rs_select_contract['lend_date'])?>"/>
<img src="js/calendar/calendar2.gif" title="วันเดือนปี" onclick="popUpCalendar(this, document.form1.txt_lend_date, 'dd/mm/yyyy');" /></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE">ลงชื่อ<span class="style1">*</span></td>
<td bgcolor="#EEEEEE" ><input name="txt_order_user" type="text" id="txt_order_user" value="<?=$rs_select_contract['order_user']?>" size="30"/></td>
<td bgcolor="#EEEEEE" ><span >ผู้สั่งจ่าย</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span >ตำแหน่ง</span></td>
<td bgcolor="#EEEEEE" ><input name="txt_order_pos" type="text" id="txt_order_pos" value="<?=$rs_select_contract['order_pos']?>" size="30"/></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span >วันที่</span></td>
<td bgcolor="#EEEEEE" ><span class="style2">
<input type="text" name="txt_order_date" id="txt_order_date" size="15" maxlength="10" value="<?=mysqlDateToDateKey($rs_select_contract['order_date'])?>"/>
<img src="js/calendar/calendar2.gif" title="วันเดือนปี" onclick="popUpCalendar(this, document.form1.txt_order_date, 'dd/mm/yyyy');" /></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE"><span class="style2"></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
<td bgcolor="#EEEEEE" ><span class="style2"></span></td>
</tr>
</table></td></tr>
</table>
<br />
<div align="center">
<input type="button" name="btn_save" value="บันทึก" onclick="return checkForm(<?=$table1_row?>);" />
<input type="button" name="btn_cancel" value="ยกเลิก" onclick="window.location.href='durable_articles_borrow.php?action='" />
</div>
<?
}
?>
<input type="hidden" name="hdel" id="hdel" value=""/>
<input type="hidden" name="hdelcontract" id="hdelcontract" value=""/>
<input type="hidden" name="heditcontract" id="heditcontract" value=""/>
<input type="hidden" name="hAction" id="hAction" value=""/>
</form>
</BODY>
<script type="text/javascript">
function addDurableArticles()
{
window.open("durable_articles_browse.php?tablerow=<?=$table1_row?>");
}
window.onload = function()
{
var o_sel = document.getElementById('sel_department');
var staffgroup_id;
if(o_sel)
{
staffgroup_id = o_sel.options[o_sel.options.selectedIndex].value;
}
createListUserAjax("divBorrowUser",staffgroup_id);
init();
}
</script>
</HTML>