| เลือกปีงบประมาณ
|
| |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
| รายการ |
จำนวนเงินที่ขออนุมัติ |
จำนวนเงินที่ ขอใช้ |
คงเหลือเงินตามแผน |
ร้อยละ |
จำนวนเงินที่ ใช้จริง |
จำนวนเงินค้างเบิก |
ร้อยละ |
 ไตรมาส 1 |
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC6'],2,'.',',');
?>
|
='$startDate1' and pt.Date<= '$endDate1' ";
$result3 = $dbObj->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.ProjectId=ptt.ProjectId and pt.Date >='$startDate1' and pt.Date<= '$endDate1' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
execQuery($sql);
$rs13 = $dbObj->fetchArray($result13);
$sql = " 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 >='$startDate1' and pt.Date<= '$endDate1' ";
$result14 = $dbObj->execQuery($sql);
$rs14 = $dbObj->fetchArray($result14);
$Sum = $rs13[SumC6] - $rs14[SumB2] ;
$per4 = ($rs14[SumB2] * 100 ) / $rs13[SumC6];
echo number_format($per4,2,'.','.');
?> |
='$startDate1' and pt.Date<= '$endDate1' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?>
|
='$startDate1' and pt.Date<= '$endDate1' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate1' and pt.Date<= '$endDate1' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
='$startDate1' and pt.Date<= '$endDate1' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql = " SELECT SUM(Budget_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 >='$startDate1' and pt.Date<= '$endDate1' ";
$result14 = $dbObj->execQuery($sql);
$rs14 = $dbObj->fetchArray($result14);
$Sum = $rss3[SumC6] - $rs14[SumB2] ;
$per4 = ($rs14[SumB2] * 100 ) / $rss3[SumC6];
echo number_format($per4,2,'.','.');
?> |
| ไตรมาส 2 |
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC6'],2,'.',',');
?>
|
='$startDate2' and pt.Date<= '$endDate2' ";
$result3 = $dbObj->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.ProjectId=ptt.ProjectId and pt.Date >='$startDate2' and pt.Date<= '$endDate2' ";
$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 >='$startDate2' and pt.Date<= '$endDate2' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC1];
echo number_format($per4,2,'.','.');
?> |
='$startDate2' and pt.Date<= '$endDate2' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?>
|
='$startDate2' and pt.Date<= '$endDate2' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate2' and pt.Date<= '$endDate2' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
='$startDate2' and pt.Date<= '$endDate2' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate2' and pt.Date<= '$endDate2' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC6] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC6];
echo number_format($per4,2,'.','.');
?>
|
| ไตรมาส 3 |
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC6'],2,'.',',');
?> |
='$startDate3' and pt.Date<= '$endDate3' ";
$result3 = $dbObj->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.ProjectId=ptt.ProjectId and pt.Date >='$startDate3' and pt.Date<= '$endDate3' ";
$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 >='$startDate3' and pt.Date<= '$endDate3' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC1];
echo number_format($per4,2,'.','.');
?> |
='$startDate3' and pt.Date<= '$endDate3' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?>
|
='$startDate3' and pt.Date<= '$endDate3' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate3' and pt.Date<= '$endDate3' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
='$startDate3' and pt.Date<= '$endDate3' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate3' and pt.Date<= '$endDate3' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC6] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC6];
echo number_format($per4,2,'.','.');
?>
|
| ไตรมาส 4 |
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC6'],2,'.',',');
?> |
='$startDate4' and pt.Date<= '$endDate4' ";
$result3 = $dbObj->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.ProjectId=ptt.ProjectId and pt.Date >='$startDate4' and pt.Date<= '$endDate4' ";
$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 >='$startDate4' and pt.Date<= '$endDate4' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC1];
echo number_format($per4,2,'.','.');
?> |
='$startDate4' and pt.Date<= '$endDate4' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
echo number_format($rss3['SumB2'],2,'.',',');
?>
|
='$startDate4' and pt.Date<= '$endDate4' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate4' and pt.Date<= '$endDate4' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC1] - $rss10[SumB2] ;
echo number_format($Sum4,2,'.',',');
?> |
='$startDate4' and pt.Date<= '$endDate4' ";
$result3 = $dbObj->execQuery($sql3);
$rss3 = $dbObj->fetchArray($result3);
$sql10 = " SELECT SUM(Budget_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 >='$startDate4' and pt.Date<= '$endDate4' ";
$result10 = $dbObj->execQuery($sql10);
$rss10 = $dbObj->fetchArray($result10);
$Sum4 = $rss3[SumC6] - $rss10[SumB2] ;
$per4 = ($rss10[SumB2] * 100 ) / $rss3[SumC6];
echo number_format($per4,2,'.','.');
?>
|
| สรุปการใช้เงิน |
execQuery($sql4);
$rss4 = $dbObj->fetchArray($result4);
echo number_format($rss4['SumC8'],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,'.','.');
?> |
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,'.','.');
?>
|
|