|
|
|
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],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.MoneyS_C='$rss[MoneyS_C]' and pt.ProjectId=ptt.ProjectId ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC1];
echo number_format($per4,2,'.','.');
?> |
|
สรุปการใช้เงิน |
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumC5'],2,'.',',');
?> |
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?> |
execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Spending_use) AS SumB2 FROM project_tb WHERE Budget_Year='$Budget_Year' ";
$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 WHERE Budget_Year='$Budget_Year' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC1];
echo number_format($per4,2,'.','.');
?> |