|
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/industry/ |
Upload File : |
<? session_start() ;
header("Content-Type: text/html; charset=windows-874");
set_time_limit(0) ;
include_once("../../config/config_epm.inc.php");
include_once("manage_user.inc.php");
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620" />
<title><?=$title_name?></title>
<script language="javascript">
function mOvr(src,clrOver){
if (!src.contains(event.fromElement)) src.bgColor = clrOver;
}
function mOut(src,clrIn){
if (!src.contains(event.toElement)) src.bgColor = clrIn;
}
</script>
<style type="text/css">
<!--
A:link {
FONT-SIZE: 12px;color: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif";TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:visited {
FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:active {
FONT-SIZE: 12px; COLOR: #014d5f; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:hover {
FONT-SIZE: 12px; COLOR: #f3960b; FONT-FAMILY: Tahoma, "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
.style1 {color: #FF0000}
.style2 {font-size: 24px}
.h_menu {color:#FF9900}
-->
.bg_th{
background-image:url(images/horiz-bg.png);
background-repeat:repeat-x;
font-weight:bold;
color:#FFFFFF;
text-align:center;
}
</style>
<script language=JavaScript>
function Conf(object) {
if (confirm("ยืนยันการลบข้อมูล")==true) {
return true;
}
return false;
}
function CheckIsIE()
{
if (navigator.appName.toUpperCase() == 'MICROSOFT INTERNET EXPLORER') { return true;}
else { return false; }
}
function PrintThisPage()
{
if (CheckIsIE() == true)
{
parent.iframe1.focus();
parent.iframe1.print();
}
else
{
window.frames['iframe1'].focus();
window.frames['iframe1'].print();
}
}
var updateIframe = function() {
document.getElementById( 'myIframe' ).src = 'book_insert_attach.php';
}
</script>
</head>
<body>
<?
include("header.php");
if($_GET['runid_del']){
$strSQL_P = "SELECT
plant_name
FROM industry_plant
WHERE runid='".$_GET['runid_del']."'
";
$rsConn_P = mysql_db_query($dbname,$strSQL_P);
$Result_P = mysql_fetch_assoc($rsConn_P);
$strSQL_del = "SELECT
Count(code) AS chkCount,code
FROM industry_register
WHERE ind_name='".$Result_P['plant_name']."'
GROUP By code
";
$rsConn_del = mysql_db_query($dbname,$strSQL_del);
$Result_del = mysql_fetch_assoc($rsConn_del);
if($Result_del['chkCount'] < 1){
//echo '1';
mysql_query("DELETE FROM pathumthani_integration.industry_plant WHERE runid='".$_GET['runid_del']."' ");
}else{
//echo '0';
print"<script language='JavaScript'> alert('ข้อมูลนิคม/เขตประกอบการนี้ถูกใช้ในทะเบียนโรงงานอุตสาหกรรม ไม่สามารถลบได้') </script> ";
}
//mysql_query("DELETE FROM pathumthani_integration.industry_plant WHERE runid='".$_GET['runid_del']."' ");
}
?>
<img src="images/unpublish_f2.png" width="30" height="30" border="0" align="absmiddle" /><strong style="color:#000033; font-size:18px;"> ข้อมูลนิคม/เขตประกอบการ </strong><br /><br />
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td></td>
</tr>
<tr>
<td bgcolor="#B4B4B4">
<table width="100%" border="0" cellpadding="5" cellspacing="1">
<tr>
<td bgcolor="#FFFFFF">
<form id="form1" name="form1" method="post" action="" onsubmit="return CheckForm(this)">
<table width="70%" border="0" align="center">
<tr>
<td width="66%" align="left"><strong>เลือกข้อมูลนิคม/เขตประกอบการ : </strong>
<select name="type_id" id="type_id" onChange="window.location='?plant_id='+this.options[this.selectedIndex].value">
<option value="">ข้อมูลนิคม/เขตประกอบการทั้งหมด</option>
<?
$strSQL_22 = "SELECT *
FROM industry_plant
";
$rsConn_22 = mysql_db_query($dbname,$strSQL_22);
while($Result_22 = mysql_fetch_assoc($rsConn_22)){
?>
<option value="<?=$Result_22['plant_id']?>" <? if($_GET['plant_id']==$Result_22['plant_id']){ echo "selected"; } ?>>
<?=$Result_22['plant_name']?>
</option>
<?
}
?>
</select></td>
<td width="34%" align="right"><a href="industry_insert_plant.php?att_type_id=0"><img src="images/add.png" alt="เพิ่มข้อมูลนิคม/เขตประกอบการ" title="เพิ่มข้อมูลนิคม/เขตประกอบการ" border="0" align="absmiddle" /><a href="industry_insert_plant.php?att_type_id=0"> เพิ่มข้อมูลนิคม/เขตประกอบการ</a></td>
</tr>
</table>
<table width="70%" border="0" align="center" bgcolor="#EEEEEE" cellpadding="3" cellspacing="1">
<tr class="bg_th">
<td width="120" align="center">รหัส</td>
<td align="center"><strong>ชื่อนิคม/เขตประกอบการ</strong></td>
<td width="160" align="center">หมายเหตุ</td>
<td width="70" align="center"><strong>การจัดการ</strong></td>
</tr>
<?
$strSQL_1 = "SELECT *
FROM industry_plant
";
if($_GET['plant_id']){
$strSQL_1.=" WHERE plant_id='".$_GET['plant_id']."' ";
}
$strSQL_1.=" ORDER By plant_id ";
$rsConn_1 = mysql_db_query($dbname,$strSQL_1);
$i=0;
while ( $Result_1 = mysql_fetch_assoc($rsConn_1)) {
$i++;
//$color = ( $i % 2 == 0 ) ? "#EFEFEF" : "#FFFFFF" ;
$color = "#FFFFFF" ;
?>
<tr bgcolor="<?=$color?>">
<td align="center"><?=$Result_1['plant_id']?></td>
<td><?=$Result_1['plant_name']?></td>
<td align="center"><?=$Result_1['note']?></td>
<td align="center">
<a href="industry_insert_plant.php?runid=<?=$Result_1['runid']?>&edit=1"><img src="img/icon-write.png" alt="แก้ไข" title="แก้ไข" width="16" height="16" border="0" align="absmiddle" /></a>
<a href="?runid_del=<?=$Result_1['runid']?>" onClick="return Conf(this)"><img src="img/icon-delete.png" alt="ลบ" title="ลบ" width="16" height="16" border="0" align="absmiddle" /></a> </td>
</tr>
<? }?>
</table>
</form>
</td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>