require("header.php");?> |
require("left.php");?> |
เงินงบประมาณ :
$SelType="select * from fnpayout_tprocedure1 where FNPTProc1_ID='5' ";
$dbType=mysql_db_query($dbname, $SelType);
$rsType=mysql_fetch_array($dbType);
$FNPTProc1_Name=$rsType['FNPTProc1_Name'];
echo $FNPTProc1_Name;
?>
|
|
ลำดับ |
ประเภท |
อว |
วันที่ |
เรื่อง |
โดย |
ส่งคืน |
if($FAcc_Access=="FNP1"){
$SelFNP2="select * from fnpayout where FNP_Procedure='5' and FNP_Budget='$BG' order by FNP_ID desc limit $Gopage,$Pagesize";
}elseif($FAcc_Access=="FNP2"){
$SelFNP2="select * from fnpayout where FNP_Procedure='5' and FNP_Depart='$FAcc_Depart' and FNP_Budget='$BG' order by FNP_ID desc limit $Gopage,$Pagesize";
}
$dbFNP2=mysql_db_query($dbname,$SelFNP2) or die ('cannot connect P2');
$numFNP2=mysql_num_rows($dbFNP2);
if($numFNP2==0){
echo " - - NONE - - | ";
}else{
for($Recs=1;$Recs <= $Pagesize;$Recs++){
$rsFNP2=mysql_fetch_array($dbFNP2);
$Number = $Gopage+$Recs;
$FNP_ID=$rsFNP2['FNP_ID'];
$FNP_BookNo=$rsFNP2['FNP_BookNo'];
$FNP_BookDate=$rsFNP2['FNP_BookDate'];
$FNP_Subject=$rsFNP2['FNP_Subject'];
$FNP_Author=$rsFNP2['FNP_Author'];
$FNP_Type=$rsFNP2['FNP_Type'];
$FNP_Budget=$rsFNP2['FNP_Budget'];
$Book_ID=$rsFNP2['Book_ID'];
list($byear,$bmonth,$bday)=split('-',$FNP_BookDate);
if($bday<10){ $bday=substr($bday,1,1); }else{ $bday=$bday; }
$Byear=$byear+543;
$BookDate=$bday." ".getMonthName($bmonth)." ".$Byear;
If ($bg=="#FDF3EE"){
$bg="#F9F9F9";
}Else{
$bg="#FDF3EE";
}
?>
echo $Number;?> |
echo $FNP_Type;?> |
echo $FNP_BookNo;?> |
echo $BookDate;?> |
echo $FNP_Subject;?> |
echo $FNP_Author;?> |
include ('../../logbook/condb.php');
$SelProc="select * from tprocess where Book_ID='$Book_ID' and Proc_Status='2' order by Proc_ID asc";
$dbProc=mysql_db_query($dbname, $SelProc);
$numProc=mysql_num_rows($dbProc);
for($pro=1;$pro<=$numProc;$pro++){
$rsProc=mysql_fetch_array($dbProc);
$Proc_ID=$rsProc['Proc_ID'];
$Proc_Date=$rsProc['Proc_Date'];
$Proc_Status=$rsProc['Proc_Status'];
$Proc_User=$rsProc['Proc_User'];
if($Proc_Date=="0000-00-00" || $Proc_Date==""){
$Proc_Date="-";
}else{
$p_year=substr($Proc_Date,0,4)+543;
$Proc_Date=substr($Proc_Date,8,2)."-".substr($Proc_Date,5,2)."-".$p_year;
}
$Sel_Proc_Exp="select * from tprocess_export where Proc_ID='$Proc_ID' ";
$db_Proc_Exp=mysql_db_query($dbname, $Sel_Proc_Exp);
$rs_Proc_Exp=mysql_fetch_array($db_Proc_Exp);
$Proc_Exp_ID=$rs_Proc_Exp['Proc_Exp_ID'];
$Proc_Exp_Date=$rs_Proc_Exp['Proc_Exp_Date'];
$Proc_Exp_Round=$rs_Proc_Exp['Proc_Exp_Round'];
$Proc_Exp_FStatus=$rs_Proc_Exp['Proc_Exp_FStatus'];
$Proc_Exp_FDetail=$rs_Proc_Exp['Proc_Exp_FDetail'];
$Proc_Exp_FDate=$rs_Proc_Exp['Proc_Exp_FDate'];
$Proc_Exp_Type=$rs_Proc_Exp['Proc_Exp_Type'];
$Proc_Exp_User=$rs_Proc_Exp['Proc_Exp_User'];
//...วันที่ส่งออก
if($Proc_Exp_Date=="0000-00-00" || $Proc_Exp_Date==""){
$Proc_Exp_Date="-";
}else{
$exp_year=substr($Proc_Exp_Date,0,4)+543;
//$Proc_Exp_Date=substr($Proc_Exp_Date,8,2)."-".substr($Proc_Exp_Date,5,2)."-".substr($Proc_Exp_Date,0,4);
$Proc_Exp_Date=substr($Proc_Exp_Date,8,2)."-".substr($Proc_Exp_Date,5,2)."-".$exp_year;
}
//...วันที่ติดตาม
if($Proc_Exp_FDate=="0000-00-00" || $Proc_Exp_FDate==""){
$Proc_Exp_FDate="-";
}else{
$f_year=substr($Proc_Exp_FDate,0,4)+543;
//$Proc_Exp_FDate=substr($Proc_Exp_FDate,8,2)."-".substr($Proc_Exp_FDate,5,2)."-".substr($Proc_Exp_FDate,0,4);
$Proc_Exp_FDate=substr($Proc_Exp_FDate,8,2)."-".substr($Proc_Exp_FDate,5,2)."-".$f_year;
}
echo $Proc_Exp_Date." ";
}
?> |
}?>
include("condb.php");
if($numFNP != 0){
echo " Page ".$Checkpage." / " .$Maxcount ."";
//echo " ";
If ($Checkpage>1){
echo "[ Previous ] ";
}
If ($Checkpage<$Maxcount) {
echo " [ Next ] ";
}
echo " [ ";
$Pad="";
$Scriptname=${"Script_Name"};
for ($N=1; $N<=$Maxcount; $N=$N+1){
if ($N>=10){
$Pad="";
}
$Ref="".$Pad.$N."";
echo " ".$Ref." ";
}
echo " ] ";
}}// num_row == 0
//mysql_close($conn);
?>
|
|
|
|
|
require("footer.php");?> |
|