หน่วยงาน |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
|
จำนวนเงิน |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
|
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
|
execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['SumB1'],2,'.',',');
?> |
จำนวนเงินที่ใช้ |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
='$startDate' and pt.Date <='$endDate' ";
$result10 = mysql_query($sql10);
$rss10 = mysql_fetch_array($result10);
echo number_format($rss10['SumB2'],2,'.',',');
?>
|
='$startDate' and pt.Date<= '$endDate' ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['SumB1'],2,'.',',');
?> |
จำนวนเงินคงเหลือ |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
='$startDate' and pt.Date<= '$endDate' ";
$result10 = mysql_query($sql10);
$rss10 = mysql_fetch_array($result10);
$Sum4 = $rss1[SumB1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
='$startDate' and pt.Date<= '$endDate' ";
$result10 = mysql_query($sql10);
$rss10 = mysql_fetch_array($result10);
$Sum4 = $rss1[SumB1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
จำนวนเงินรวม |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumC5'],2,'.',',');
?> |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC6'],2,'.',',');
?> |
จำนวนเงินที่ใช้ |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
='$startDate' and pt.Date<= '$endDate' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?> |
='$startDate' and pt.Date<= '$endDate' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?> |
จำนวนเงินคงเหลือ |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result6) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Spending_use) AS SumB2 FROM project_tb pt, project_type_tb ptt WHERE pt.MoneyS_C='$rss[MoneyS_C]' and pt.Budget_Year='$Budget_Year' and pt.ProjectId=ptt.ProjectId and pt.Date >='$startDate' and pt.Date <= '$endDate' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Spending_use) AS SumB2 FROM project_tb pt, project_type_tb ptt WHERE pt.Budget_Year='$Budget_Year' and pt.ProjectId=ptt.ProjectId and pt.Date >='$startDate' and pt.Date<= '$endDate' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
|