|
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 : /var/www/html/pathumthani_eoffice/application/CA/ |
Upload File : |
<?php
header("Content-Type: text/plain; charset=windows-874");
include "../../config/config.inc.php";
$sql_select="
SELECT
org_staffgroup.gid,
org_staffgroup.groupname,
org_staffgroup.minitry_id,
org_staffgroup.subminitry_id,
org_staffgroup.mobile_phone,
ministry_lbl.name as min_name,
department_lbl.name as sub_name
FROM
org_staffgroup
Inner Join ministry_lbl ON org_staffgroup.minitry_id = ministry_lbl.moc_id
Inner Join department_lbl ON org_staffgroup.subminitry_id = department_lbl.dev_id
WHERE
org_staffgroup.gid = '$org_id'
ORDER BY
org_staffgroup.groupname ASC
LIMIT 1
";
//echo "<pre>".$sql_select;
$result= mysql_db_query($dbname, $sql_select )or die(mysql_error());
$arr_org=mysql_fetch_assoc($result);
$org_info=$arr_org[gid]."::".$arr_org[minitry_id]."::".$arr_org[subminitry_id];
$sql_select= "SELECT * FROM ministry_lbl ORDER BY name ASC";
$result= mysql_db_query($dbname, $sql_select )or die(mysql_error());
$i=0;
while ($result1= mysql_fetch_assoc($result)){
$i++;
if(intval($result1[moc_id])==intval($arr_org[minitry_id])){$min_text=$i;}
}
if($arr_org['minitry_id']!=""&&$arr_org['minitry_id']!="0"){
$i=0;
$ministry_id=$arr_org['minitry_id'];
$sql_select= "SELECT * FROM department_lbl WHERE cast( pv_code AS signed ) = '$ministry_id' ORDER BY name ASC";
$result= mysql_db_query($dbname, $sql_select )or die(mysql_error());
while ($result1= mysql_fetch_assoc($result)){
$i++;
$name = "$result1[name]";
$minitry_text.=$name."::".$result1[dev_id].",";
if($result1[dev_id]==$arr_org[subminitry_id]){$sub_text=$i;}
}//end while // ปิดการเชื่อมต่อ
}
$min_text=($min_text)?$min_text:"0";
$sub_text=($sub_text)?$sub_text:"0";
$minitry_text=($minitry_text)?substr($minitry_text,0,-1):"";
echo $org_info."::".$min_text."::".$sub_text."///".$minitry_text;
mysql_close();
?>