|
|
| เงินรายได้ :
|
| ";
if($FAcc_Access=="FNP1"){
$SelFNP="select * from fnpayout where FNP_Procedure='4' and FNP_Budget='$BG' order by FNP_ID desc";
}elseif($FAcc_Access=="FNP2"){
$SelFNP="select * from fnpayout where FNP_Procedure='4' and FNP_Depart='$FAcc_Depart' and FNP_Budget='$BG' order by FNP_ID desc";
}
$dbFNP=mysql_db_query($dbname, $SelFNP);
$numFNP=mysql_num_rows($dbFNP);
if ($Page >= 1){}
else{ $Page = 1;}
$Gopage=$HTTP_GET_VARS["Page"];
if ($Gopage==""){
$Gopage=1;
}
$Pagesize=$HTTP_GET_VARS["Pagesize"];
if($numFNP=="25"){ $PS="26";}else{$PS="25";}
$Pagesize=$PS;
$Maxcount=ceil($numFNP/$Pagesize);
$Gopage=(($Gopage-1)*$Pagesize)+$Recs;
$Recs=1;
$Checkpage= ($Gopage/$Pagesize)+1;
If ($Checkpage==$Maxcount) {
$Newsize=$numFNP % $Pagesize;
$Pagesize=$Newsize;
}
echo "จำนวน ".$numFNP." รายการ";
?> |
<< ">กลับ |
|
| ลำดับ |
ประเภท |
แหล่งเงิน |
อว |
วันที่ |
เรื่อง |
โดย |
สถานะ |
- - 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'];
/* $SelBG="select * from proc_tbudget where ProcBudget_ID='$FNP_Budget' ";
echo $SelBG;
$dbBG=mysql_db_query($dbname, $SelBG);
$rsBG=mysql_fetch_array($dbBG);
$ProcBudget_Name=$rsBG['ProcBudget_Name'];*/
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;
/*$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";
}
?>
|
|
|
|
|
|
|
'คุณชื่นสุมณ' order by tprocess.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;
}
$Proc_Proc_ID=$rsProc['Proc_Proc_ID'];
$Proc_Proc_Type=$rsProc['Proc_Proc_Type'];
$Proc_Proc_TypeSend=$rsProc['Proc_Proc_TypeSend'];
$Proc_Proc_Detail=$rsProc['Proc_Proc_Detail'];
$Proc_Proc_User=$rsProc['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."
";
}
}
?> |
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);
?>
|
|
| |
|
|
|
|