|
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/ |
Upload File : |
<?
session_start();
include_once("../../config/config_epm.inc.php");
include_once("function/function.inc.php");
if($_POST['Submit']){
//$letter_date = Save_date($_POST['letter_date']);
$strSQL_2 = "SELECT
Count(runno) AS chkCount
FROM labor_personal_training
WHERE id_card='".$_GET['id_card']."' AND runno='".$_POST['runno']."'
";
$rsConn_2 = mysql_db_query($dbname,$strSQL_2);
$Result_2 = mysql_fetch_assoc($rsConn_2);
$checkRepeat=0;
if($_GET['edit']==''){
if($Result_2['chkCount'] < 1){
$sql2="
INSERT INTO `labor_personal_training` SET
`id_card`='".$_GET['id_card']."',
`training_location`='".$_POST['training_location']."',
`training_name`='".$_POST['training_name']."',
`training_endtime`='".dateFormat($_POST['training_endtime'],'thaieng_slash')."',
`number_time`='".$_POST['number_time']."',
`unit_id`='".$_POST['unit_id']."'
";
//echo $sql2;
mysql_query($sql2);
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
exit();
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_base_unit\">\n";
exit();*/
}
else{
$checkRepeat = 1;
}
}
else{
//echo $Result_2['type_id'];
if($Result_2['chkCount'] < 1 || $_GET['id_card']==$Result_2['id_card']){
mysql_query("
UPDATE `labor_personal_training` SET
`id_card`='".$_GET['id_card']."',
`training_location`='".$_POST['training_location']."',
`training_name`='".$_POST['training_name']."',
`training_endtime`='".dateFormat($_POST['training_endtime'],'thaieng_slash')."',
`number_time`='".$_POST['number_time']."',
`unit_id`='".$_POST['unit_id']."'
WHERE id_card='".$_GET['id_card']."' AND runno='".$_GET['runno']."'
");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
exit();
/*print"<script language='JavaScript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว') </script> ";
print"<meta http-equiv=\"refresh\" content=\"0;URL=?p=labor_base_unit\">\n";
exit();*/
}
else{
$checkRepeat = 1;
}
}
}
if($_GET['runid_del']){
mysql_query("DELETE FROM pathumthani_integration.labor_personal_training WHERE runno='".$_GET['runid_del']."' ");
print"<meta http-equiv=\"refresh\" content=\"0;URL=?id_card=".$_GET['id_card']."\">\n";
}
?>
<link href="common/style.css" rel=stylesheet>
<script language='javascript' src='js/function.js'></script>
<script language="javascript" src="js/daily_popcalendar.js"></script>
<link rel="stylesheet" type="text/css" href="js/style_tootip_isnumber.css" />
<script type="text/javascript" language="javascript" src="js/tootip_isnumber.js"></script>
<script type="text/javascript" src="js/jquery-1.3.2.js"></script>
<style type="text/css">
<!--
.style2 {color: #FF0000}
.style1 {color: #FF0000}
body{background-color:E1F0FF}
-->
</style>
<form id="formp2" name="formp2" method="POST" action="" onsubmit="return CheckForm_1(this)">
<?
if($_GET['edit']!=''){
$strSQL_3 = "SELECT * FROM labor_personal_training ";
if($_GET['runno']){
$strSQL_3 .= " WHERE runno= '".$_GET['runno']."' ";
}
$rsConn_3 = mysql_db_query($dbname,$strSQL_3);
$Result_3 = mysql_fetch_assoc($rsConn_3);
}
?>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="234" height="24" align="left" valign="top"><strong>ประเภทอาชีพ / สาขาที่ฝึก / หลักสูตร</strong><span class="style1">*</span></td>
<td width="751" align="left"><input name="training_name" type="text" id="training_name" size="58" value="<?=($_POST['training_name']=='')?$Result_3['training_name']:$_POST['training_name']?>" /></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>สถาบัน / หน่วยงาน / สถานที่ฝึก</strong></td>
<td align="left"><input name="training_location" type="text" id="training_location" size="58" value="<?=($_POST['training_location']=='')?$Result_3['training_location']:$_POST['training_location']?>" /></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>ระยะเวลาที่ฝึก</strong></td>
<td align="left"><input name="number_time" type="text" id="number_time" size="20" value="<?=($_POST['number_time']=='')?$Result_3['number_time']:$_POST['number_time']?>" onKeyPress="return isNumber(event,this.id);" />
<select name="unit_id" id="unit_id" style="width:100px">
<option value="0">เลือกหน่วยเวลา</option>
<?
$sqlunit_id= mysql_query("SELECT
labor_master_unit.unit_id,
labor_master_unit.detail
FROM labor_master_unit
");
while( $resunit_id= mysql_fetch_array($sqlunit_id) ) {
?>
<option value="<?=$resunit_id['unit_id']?>" <? if($Result_3['unit_id']==$resunit_id['unit_id']){ echo "selected"; } ?>>
<?=$resunit_id['detail']?>
<?
}
?>
</option>
</select></td>
</tr>
<tr>
<td height="24" align="left" valign="top"><strong>วันจบฝึกอบรม</strong></td>
<td align="left">
<input name="training_endtime" type="text" id="training_endtime" maxlength="10" size="15" value="<?=($_POST['training_endtime']=='')?dateFormat($Result_3['training_endtime'],'engthai_slash'):$_POST['training_endtime']?>" onblur=" checkThaiDate(this,document.getElementById('div_txt_training_endtime')); " onkeypress="chkDateFormat(this,event)" /><img src="js/calendar/calendar2.gif" align="top" border="0" onClick="popUpCalendar(this, document.getElementById('training_endtime'), 'dd/mm/yyyy')" title="วัน เดือน ปี" style="cursor:pointer;" /><span id='div_txt_training_endtime'></span>
</td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"></td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"><input type="submit" name="Submit" value="บันทึก" />
<input type="button" name="Submit2" value="ยกเลิก" onclick="window.location='?id_card=<?=$_GET['id_card']?>'" /></td>
</tr>
<tr>
<td height="24" align="left"> </td>
<td align="left"></td>
</tr>
<tr>
<td height="24" colspan="2" align="left">
<table id="table_person" width="99%" align="center" border="0" cellspacing="1" cellpadding="3" bgcolor="#999999">
<tr bgcolor="#CCCCCC">
<td width="5%" align="center">ลำดับที่</td>
<td width="25%" align="center">ประเภทอาชีพ / สาขาที่ฝึก / หลักสูตร</td>
<td width="25%" align="center">สถาบัน / หน่วยงาน / สถานที่ฝึก</td>
<td width="11%" align="center">ระยะเวลาที่ฝึก</td>
<td width="11%" align="center">หน่วยเวลา</td>
<td width="11%" align="center">วันจบฝึกอบรม</td>
<td width="10%" align="center">การจัดการ</td>
</tr>
<?
$sql_vacancy_2=" SELECT
labor_personal_training.id_card,
labor_personal_training.runno,
labor_personal_training.training_location,
labor_personal_training.training_name,
labor_personal_training.training_endtime,
labor_personal_training.number_time,
labor_personal_training.unit_id
FROM labor_personal_training
WHERE labor_personal_training.id_card='".$_GET['id_card']."'
ORDER BY labor_personal_training.training_endtime DESC
";
$rs_vacancy_2=mysql_db_query($dbname,$sql_vacancy_2);
$i=0;
while($res_vacancy_2=mysql_fetch_assoc($rs_vacancy_2)){
$i++;
$sql_unit_id=" SELECT
labor_master_unit.unit_id,
labor_master_unit.detail
FROM labor_master_unit
WHERE labor_master_unit.unit_id = '".$res_vacancy_2['unit_id']."'
";
$rs_unit_id=mysql_db_query($dbname,$sql_unit_id);
$res_unit_id=mysql_fetch_assoc($rs_unit_id);
?>
<tr bgcolor="#FFFFFF">
<td align="center"><?=$i?></td>
<td align="left"><?=$res_vacancy_2['training_name']?></td>
<td align="left"><?=$res_vacancy_2['training_location']?></td>
<td align="right"><?=$res_vacancy_2['number_time']?></td>
<td align="center"><?=$res_unit_id['detail']?></td>
<td align="center"><?=dateFormat($res_vacancy_2['training_endtime'],'thaidot')?></td>
<td align="center">
<a href="?id_card=<?=$_GET['id_card']?>&runno=<?=$res_vacancy_2['runno']?>&edit=1"><img src="../../images/dash_icon/ico_edit.png" alt="แก้ไขข้อมูล" title="แก้ไขข้อมูล" width="16" height="16" border="0" align="middle" /></a>
<a href="?id_card=<?=$_GET['id_card']?>&runid_del=<?=$res_vacancy_2['runno']?>" onClick="return Conf(this)"><img src="../../images/dash_icon/ico_del.png" alt="ลบข้อมูล" title="ลบข้อมูล" width="16" height="16" border="0" align="middle" onmouseover="this.style.cursor='hand';"/></a>
</td>
</tr>
<? }?>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</form>
<script>
function CheckForm_1(e){
if ( e.training_name.value == "" ) {
alert("กรุณาป้อน ประเภทอาชีพ / สาขาที่ฝึก / หลักสูตร");
e.training_name.focus();
return false;
}else if(document.getElementById('div_txt_training_endtime').innerHTML != ""){
alert(" ! กรุณาระบุ วันจบฝึกอบรม ให้ถูกต้อง");
document.getElementById('div_txt_training_endtime').focus();
return false;
}
return true;
}
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}
</script>