require("header.php");?> |
require("left.php");?> |
เงินรายได้ :
$SelType="select * from fnpayout_tprocedure2 where FNPTProc2_ID='1' ";
$dbType=mysql_db_query($dbname, $SelType);
$rsType=mysql_fetch_array($dbType);
$FNPTProc2_Name=$rsType['FNPTProc2_Name'];
echo $FNPTProc2_Name;
?> |
|
ลำดับ |
ประเภท |
แหล่งเงิน |
อว |
วันที่ |
เรื่อง |
โดย |
if($FAcc_Access=="FNP1" ){ ?>
ปรับปรุง |
สถานะ |
}?>
if($FAcc_Access=="FNP1"){
$SelFNP2="select * from fnpayout where FNP_Procedure='1' and FNP_Budget='$BG' order by FNP_ID desc limit $Gopage,$Pagesize";
}elseif($FAcc_Access=="FNP2"){
$SelFNP2="select * from fnpayout where FNP_Procedure='1' 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'];
$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' order by FNPChReq_ID desc";
$dbChereq=mysql_db_query($dbname, $SelChereq);
$rsChereq=mysql_fetch_array($dbChereq);
$FNPChReq_ID=$rsrsChereq['FNPChReq_ID'];
$FNPChReq_Status=$rsrsChereq['FNPChReq_Status'];
list($Bdate,$Btime)=split(' ',$FNP_BookDate);
list($byear,$bmonth,$bday)=split('-',$Bdate);
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 $ProcBudget_Name;?> |
echo $FNP_BookNo;?> |
echo $BookDate;?> |
echo $FNP_Subject;?> |
echo $FNP_Author;?> |
if($FAcc_Access=="FNP1" ){
echo "
| ";
if($FNPChReq_ID==""){
echo "
| ";
}else{
if($FNPChReq_Status==0){
echo "
| ";
}elseif($FNPChReq_Status==1){
echo "
| ";
}
}
}
?>
}?>
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");?> |
|