require("header.php");?> |
require("left.php");?> |
เงินงบประมาณ :
$SelType="select * from fnpayout_tprocedure1 where FNPTProc1_ID='4' ";
$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='4' and FNP_Budget='$BG' order by FNP_ID desc limit $Gopage,$Pagesize";
}elseif($FAcc_Access=="FNP2"){
$SelFNP2="select * from fnpayout where FNP_Procedure='4' 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($FNP_Budget<>""){
$SelBG="select * from proc_tbudget where ProcBudget_ID='$FNP_Budget' ";
$dbBG=mysql_db_query($dbname, $SelBG);
$rsBG=mysql_fetch_array($dbBG);
$ProcBudget_Name=$rsBG['ProcBudget_Name'];
}
/*$SelChereq="select * from fnpayout_checkreq where FNP_ID='$FNP_ID' ";
$dbChereq=mysql_db_query($dbname, $SelChereq);
$rsChereq=mysql_fetch_array($dbChereq);
$FNPChReq_ID=$rsChereq['FNPChReq_ID'];
$FNPChReq_Status=$rsChereq['FNPChReq_Status'];*/
If ($bg=="#FDF3EE"){
$bg="#F9F9F9";
}Else{
$bg="#FDF3EE";
}
?>
echo $Number;?> |
echo $FNP_Type;?> |
echo $ProcBudget_Name;?> |
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='1' 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_Proc="select * from tprocess_proc where Proc_ID='$Proc_ID' ";
$db_Proc_Proc=mysql_db_query($dbname, $Sel_Proc_Proc);
$rs_Proc_Proc=mysql_fetch_array($db_Proc_Proc);
$Proc_Proc_ID=$rs_Proc_Proc['Proc_Proc_ID'];
$Proc_Proc_Type=$rs_Proc_Proc['Proc_Proc_Type'];
$Proc_Proc_TypeSend=$rs_Proc_Proc['Proc_Proc_TypeSend'];
$Proc_Proc_Detail=$rs_Proc_Proc['Proc_Proc_Detail'];
$Proc_Proc_User=$rs_Proc_Proc['Proc_Proc_User'];
$SelPType="select * from tprocess_proc_ttype where ProcProc_Type_ID='$Proc_Proc_Type' ";
$dbPType=mysql_db_query($dbname, $SelPType);
$rsPType=mysql_fetch_array($dbPType);
$ProcProc_Type_Name=$rsPType['ProcProc_Type_Name'];
if($Proc_Proc_Type==""){
echo $Proc_Date." ".$Proc_Proc_Detail." ";
}else{
echo $Proc_Date." เสนอ ".$ProcProc_Type_Name." ".$Proc_Proc_TypeSend." ";
}
}
?> |
}?>
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");?> |
|