|
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");
include_once("../../inc/function.php");
//exit;
### REQUEST_METHOD = "POST"
$cur_date = date("Y-m-d");
$cur_year = date("Y");
$cur_year_thai = $cur_year+543;
$cur_month = date("m");
$cur_day = date("d");
if($_SERVER['REQUEST_METHOD'] == 'POST') # กดปุ่ม บันทึก(SAVE)
{
if($_POST['submit'] = "บันทึกข้อมูล")
{
$sqlcmd = "";
foreach($_POST as $key => $val)
{
if($key != "submit" && trim($val) != "" && trim($key) != "runid")
{
$sqlcmd .= ",$key = '".$val."'";
}
}
$sqlcmd = substr($sqlcmd,1);
if($_GET['action'] = "edit")
{
if($_GET['course_training_id'] != "")
{
$sqlcmd = "UPDATE labor_course_training SET ".$sqlcmd;
$sqlcmd .= " WHERE course_training_id=".$_POST["runid"];
}
else
{
$sqlcmd = "INSERT INTO labor_course_training SET ".$sqlcmd;
}
}
if($sqlcmd != "")
{
// echo "<pre>";
// echo $sqlcmd;
// exit;
mysql_query($sqlcmd) or die('can not query');
print"<script language='javascript'> alert('บันทึกข้อมูลเรียบร้อยแล้ว'); </script>";
print"<meta http-equiv=\"refresh\" content=\"0;URL=index.php?p=labor_course\">\n";
exit();
}
}
}
$row;
$course_training_id = $_GET['course_training_id'];
### mode delete ###
if($_GET['action'] == 'delete')
{
if(trim(course_training_id) != "")
{
$sqlcmd = "DELETE FROM labor_course_training WHERE course_training_id=".intval($course_training_id);
mysql_query($sqlcmd) or die('can not query');
print"<script language='javascript'> alert('ลบข้อมูลเรียบร้อยแล้ว'); </script>";
print"<meta http-equiv=\"refresh\" content=\"0;URL=index.php?p=labor_course\">\n";
exit();
}
}
### mode edit ###
if($_GET['action'] == 'edit')
{
if(trim($course_training_id) != "")
{
$sqlsel = " SELECT
labor_master_course_branch.branch_name,
labor_master_course_branch.branch_id,
labor_course_training.course_training_id,
labor_course_training.course_year,
labor_course_training.course_name,
labor_course_training.course_name_en,
labor_course_training.project,
labor_course_training.training_place,
labor_course_training.course_activity_id,
labor_course_training.course_sub_activity_id,
labor_course_training.course_group_id,
labor_course_training.course_branch_id,
labor_course_training.course_work_id,
labor_course_training.course_period,
labor_course_training.company_period
FROM
labor_course_training
Inner Join labor_master_course_activity ON labor_master_course_activity.course_activity_id = labor_course_training.course_activity_id
Inner Join labor_master_course_branch ON labor_course_training.course_branch_id = labor_master_course_branch.branch_id
WHERE labor_course_training.course_training_id="
.intval($course_training_id).
"
";
if($_GET['debug'] == "on")
{
echo "<pre>";
echo $sqlsel;
}
$res = mysql_query($sqlsel);
$row = mysql_fetch_assoc($res);
}
else
exit;
}
### END POST ###
?>
<style type="text/css">
.redstar{
color:#FF0000;
font-size:10px;
font-weight:500;
}
.container .pusher{
cursor:pointer;
padding:3px 10px 3px 7px;
font-weight:900;
font-size:12px;
margin:0;
background:url(img/bgheader-2.PNG);
color:#FFFFFF;
}
.container .mover{
border:1px solid #3399CC;
padding:3px 10px 3px 7px;
margin: 0;
background-color:#E1F0FF;
}
.container {
padding:6px;
margin-top:5px;
width: auto;
font-size:11px;
}
.list1{
width:170px
}
</style>
<script type="text/javascript" charset="utf-8" src="js/jquery-1.2.3.pack.js"></script>
<script type="text/javascript" src="js/daily_popcalendar.js"></script>
<script type="text/javascript" src="js/function.js"></script>
<script type="text/javascript">
function checkForm()
{
var o = document.getElementById("course_activity_id");
var sel = o.options[o.options.selectedIndex];
if(trim(sel.value) == "")
{
alert("! กรุณาระบุกิจกรรมหลัก");
o.focus();
return false;
}
var o = document.getElementById("course_group_id");
var sel = o.options[o.options.selectedIndex];
if(trim(sel.value) == "")
{
alert("! กรุณาระบุกลุ่มอาชีพ");
o.focus();
return false;
}
var o = document.getElementById("course_name");
if(trim(o.value) == "")
{
alert("! กรุณาระบุชื่อหลักสูตร");
o.focus();
o.select();
return false;
}
var o = document.getElementById('msg_course_period');
if(trim(o.innerHTML) != "")
{
alert("! กรุณาระบุระยะเวลาฝึกในสพร./ศพจ. ให้ถูกต้อง");
return false;
}
var o = document.getElementById('msg_company_period');
if(trim(o.innerHTML) != "")
{
alert("! กรุณาระบุระยะเวลาฝึกในสถานประกอบกิจการ ให้ถูกต้อง");
return false;
}
return true;
}
</script>
<!--ajax-->
<script language="javascript1.2">
function CreateXmlHttp(){
//Creating object of XMLHTTP in IE
try {
XmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e){
try{
XmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
catch(oc) {
XmlHttp = null;
}
}
//Creating object of XMLHTTP in Mozilla and Safari
if(!XmlHttp && typeof XMLHttpRequest != "undefined") {
XmlHttp = new XMLHttpRequest();
}
} // end function CreateXmlHttp
function chgPinDup(e, defa_v) {
if ( e ) {
//var id_card = mergePIN(document.form1.id_card);
id_card = new String(e);
CreateXmlHttp();
XmlHttp.open("get", "ajax.chkpindup.php?PvID="+id_card, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200) {
var res = XmlHttp.responseText;
document.getElementById('pcr').innerHTML = "";
if(res == "1")
{
document.getElementById('pcr').innerHTML = "<font color=\"#CC0000\">! พบเลขบัตรประชาชนดังกล่าว ในระบบแล้ว</font>"
}
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
}
<!--function คำนวณอายุ โดยการ input วันเกิดเข้าไป-->
function education_id_onchange(e)
{
var v = e.value;
if ( e ) {
CreateXmlHttp();
XmlHttp.open("get", "ajax.chgschool.php?education_id="+v, true);
XmlHttp.onreadystatechange=function() {
if (XmlHttp.readyState==4) {
if (XmlHttp.status==200){
var res = XmlHttp.responseText; //alert(res);
document.getElementById("lblSchool").innerHTML= res;
} else if (XmlHttp.status==404) {
alert("ไม่สามารถทำการดึงข้อมูลได้");
} else {
alert("Error : "+XmlHttp.status);
}
}
};
XmlHttp.send(null);
}
}
</script>
<table width="65%" border="0" align="center" cellspacing="0" cellpadding="3" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center">
<b style="font-size:16px">หลักสูตรการฝึกอบรมฝีมือแรงงาน</b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
</table>
<form action="" method="post" name="form1" id="form1" enctype="multipart/form-data">
<table width="65%" border="1" align="center" cellspacing="0" cellpadding="3" bordercolor="#CCCCCC" style="border-collapse:collapse;">
<tr>
<td>
<div class="container">
<table width="100%" cellspacing="0" cellpadding="0"><tr><td><div class="pusher" id="slideToggle" style="font-size:12px">ข้อมูลหลักสูตร <img src="img/page_div_icon/Next.gif" align="absmiddle" /></div></td><td align="right"><div class="pusher" id="slideToggle"><b style="font-size:12px">ปีงบประมาณ
<?
if($_GET['course_training_id'] == "")
{
echo $cur_year_thai ;
}
else
{
echo $row['course_year'];
}
?>
<input type="hidden" id="course_year" name="course_year" value="<?=$cur_year_thai?>" />
</b></div></td></tr></table>
<div class="mover">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td width="213"><div align="left">
<label class="redstar">*</label>
กิจกรรมหลัก</div></td>
<td><select name="course_activity_id" id="course_activity_id" style="width:300px">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT * FROM labor_master_course_activity WHERE parent_id=0";
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($rsConn) ) {
$slted = "";
if($row['course_activity_id'] == $Result->course_activity_id)
{
$slted = "selected";
}
echo "<option value=\"".$Result->course_activity_id."\" ".$slted.">".$Result->activity."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
กลุ่มอาชีพ</div></td>
<td><select name="course_group_id" id="course_group_id" style="width:300px">
<option value="">เลือก</option>
<?php
$strSQL = "SELECT * FROM labor_master_course_branch WHERE parent_id=0";
$rsConn = mysql_query($strSQL);
while ( $Result = mysql_fetch_object($rsConn) ) {
$slted = "";
if($row['branch_id'] == $Result->branch_id)
{
$slted = "selected";
}
echo "<option value=\"".$Result->branch_id."\" ".$slted.">".$Result->branch_name."</option>\n";
}
?>
</select></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar">*</label>
ชื่อหลักสูตร
</div></td>
<td><input name="course_name" id="course_name" type="text" style="width:300px" value="<?=$row['course_name']?>"
/><span id="msg_idcard" class="redstar"></span></td>
</tr>
<tr>
<td><div align="left"><label class="redstar"></label>
<label class="redstar"></label>
ชื่อหลักสูตร ภาษาอังกฤษ </div></td>
<td><input name="course_name_en" id="course_name_en" type="text" style="width:300px" value="<?=$row['course_name_en']?>"></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar"></label>
ระยะเวลาฝึกในสพร./ศพจ. </div></td>
<td><input name="course_period" id="course_period" type="text" maxlength="11" size="10" value="<?=$row['course_period']?>" onkeyup="checkNumber(this,document.getElementById('msg_course_period'))" onblur="return IsDigit(this.value,true,document.getElementById('msg_course_period'))" />
ชั่วโมง<span id="msg_course_period" class="redstar"></span></td>
</tr>
<tr>
<td><div align="left">
<label class="redstar"></label>
ระยะเวลาฝึกในสถานประกอบกิจการ</div></td>
<td><input name="company_period" id="company_period" type="text" size="10" value="<?=$row['company_period']?>" onkeyup="checkNumber(this,document.getElementById('msg_company_period'))" onblur="return IsDigit(this.value,true,document.getElementById('msg_company_period'))" maxlength="11"/>
ชั่วโมง<span id="msg_company_period" class="redstar"></span></td>
</tr>
</table>
</div>
</div>
<div id="save_data" align="center">
<input type="hidden" name="runid" id="runid" value=<?=$_GET['course_training_id']?> />
<input type="submit" name="submit" value="บันทึกข้อมูล" onclick="return checkForm();"/>
<input type="reset" name="cancel" value="ยกเลิก" />
<input type="button" name="back" value="ย้อนกลับ" onclick="javascript:window.location.href='index.php?p=labor_course'" />
</div> </td>
</tr>
</table>
</form>