|
|
|
|
|
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละงบ
| รายการงบ |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
| งบดำเนินงาน | 0.00 | 0.00 | 0.00 | 0.00 | | งบลงทุน | 0.00 | 0.00 | 0.00 | 0.00 | | งบบุคลากร | 0.00 | 0.00 | 0.00 | 0.00 | | งบอุดหนุน | 0.00 | 0.00 | 0.00 | 0.00 | | งบรายจ่ายอื่น ๆ | 0.00 | 0.00 | 0.00 | 0.00 | | งบเบิกแทนกัน | 0.00 | 0.00 | 0.00 | 0.00 | | งบกลาง | 0.00 | 0.00 | 0.00 | 0.00 | | งบเงินนอก | 0.00 | 0.00 | 0.00 | 0.00 | | สำรองนโยบาย | 0.00 | 0.00 | 0.00 | 0.00 |
|
|
'0') {
$thaimonth = array("มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม");
$yn = substr($dtmp, 0, 4) + 543;
$mn = substr($dtmp, 4, 2) - 1;
$dn = substr($dtmp, 6, 2) + 0;
$thaidate = $dn . " เดือน " . $thaimonth[$mn] . " พ.ศ. " . $yn;
} else {
$thaidate = "";
}
return $thaidate;
}
function long_date($dtmp)
{
if (strlen($dtmp) > '0') {
$thaimonth = array("มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม");
$yn = substr($dtmp, 0, 4) + 543;
$mn = substr($dtmp, 5, 2) - 1;
$dn = substr($dtmp, 8, 2) + 0;
$thaidate = $dn . " " . $thaimonth[$mn] . " " . $yn;
} else {
$thaidate = "";
}
return $thaidate;
}
function space($n)
{
$area = " ";
for ($i = 1; $i < $n; $i++) {
$area = $area . " ";
}
return $area;
}
Highcharts Example
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละกลุ่มงาน
| กลุ่มงาน |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
";
echo"".$row['name']." | ";
$sqla="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype in ('2','3') group by d.school_id";
$resulta=mysql_query($sqla);
$rsa = mysql_fetch_array($resulta);
if ($rsa['money']!='') {
$aaa = $rsa['money'];
} else {
$aaa = 0;
}
$sqlb="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype = '4' group by d.school_id";
$resultb=mysql_query($sqlb);
$rsb = mysql_fetch_array($resultb);
if ($rsb['money']!='') {
$bbb = $rsb['money'];
} else {
$bbb = 0;
}
$ccc = $aaa-$bbb;
echo"".n_format($ccc,2)." | ";
$sqlx="select sum(a.money) as sum_a from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where a.paid='3' and c.y_project = '$e_year' and d.school_id ='".$row['id']."' group by d.school_id ";
$resultx=mysql_query($sqlx);
$rsx = mysql_fetch_array($resultx) ;
if ($rsx['sum_a']!='') {
$sum_a = $rsx['sum_a'];
} else {
$sum_a = 0;
}
$ddd = $ccc-$sum_a;
echo"".n_format($sum_a,2)." | ";
echo"".n_format($ddd,2)." | ";
if ($ccc!=0) {
$percen = ($sum_a/ $ccc)*100;
} else {
$percen = 0;
}
echo"".n_format($percen,2)." | ";
echo"";
}
?>
|
|
Highcharts Example
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละโรงเรียน จังหวัดสมุทรสาคร
| โรงเรียน |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
";
echo"".$row['name']." | ";
$sqla="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype in ('2','3') group by d.school_id";
$resulta=mysql_query($sqla);
$rsa = mysql_fetch_array($resulta);
if ($rsa['money']!='') {
$aaa = $rsa['money'];
} else {
$aaa = 0;
}
$sqlb="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype = '4' group by d.school_id";
$resultb=mysql_query($sqlb);
$rsb = mysql_fetch_array($resultb);
if ($rsb['money']!='') {
$bbb = $rsb['money'];
} else {
$bbb = 0;
}
$ccc = $aaa-$bbb;
echo"".n_format($ccc,2)." | ";
$sqlx="select sum(a.money) as sum_a from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where a.paid='3' and c.y_project = '$e_year' and d.school_id ='".$row['id']."' group by d.school_id ";
$resultx=mysql_query($sqlx);
$rsx = mysql_fetch_array($resultx) ;
if ($rsx['sum_a']!='') {
$sum_a = $rsx['sum_a'];
} else {
$sum_a = 0;
}
$ddd = $ccc-$sum_a;
echo"".n_format($sum_a,2)." | ";
echo"".n_format($ddd,2)." | ";
if ($ccc!=0) {
$percen = ($sum_a/ $ccc)*100;
} else {
$percen = 0;
}
echo"".n_format($percen,2)." | ";
echo"";
}
?>
|
|
Highcharts Example
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละโรงเรียน จังหวัดสมุทรสงคราม
| โรงเรียน |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
";
echo"".$row['name']." | ";
$sqla="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype in ('2','3') group by d.school_id";
$resulta=mysql_query($sqla);
$rsa = mysql_fetch_array($resulta);
if ($rsa['money']!='') {
$aaa = $rsa['money'];
} else {
$aaa = 0;
}
$sqlb="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype = '4' group by d.school_id";
$resultb=mysql_query($sqlb);
$rsb = mysql_fetch_array($resultb);
if ($rsb['money']!='') {
$bbb = $rsb['money'];
} else {
$bbb = 0;
}
$ccc = $aaa-$bbb;
echo"".n_format($ccc,2)." | ";
$sqlx="select sum(a.money) as sum_a from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where a.paid='3' and c.y_project = '$e_year' and d.school_id ='".$row['id']."' group by d.school_id ";
$resultx=mysql_query($sqlx);
$rsx = mysql_fetch_array($resultx) ;
if ($rsx['sum_a']!='') {
$sum_a = $rsx['sum_a'];
} else {
$sum_a = 0;
}
$ddd = $ccc-$sum_a;
echo"".n_format($sum_a,2)." | ";
echo"".n_format($ddd,2)." | ";
if ($ccc!=0) {
$percen = ($sum_a/ $ccc)*100;
} else {
$percen = 0;
}
echo"".n_format($percen,2)." | ";
echo"";
}
?>
|
|
Highcharts Example
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละโรงเรียน จังหวัดเพชรบุรี
| โรงเรียน |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
";
echo"".$row['name']." | ";
$sqla="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype in ('2','3') group by d.school_id";
$resulta=mysql_query($sqla);
$rsa = mysql_fetch_array($resulta);
if ($rsa['money']!='') {
$aaa = $rsa['money'];
} else {
$aaa = 0;
}
$sqlb="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype = '4' group by d.school_id";
$resultb=mysql_query($sqlb);
$rsb = mysql_fetch_array($resultb);
if ($rsb['money']!='') {
$bbb = $rsb['money'];
} else {
$bbb = 0;
}
$ccc = $aaa-$bbb;
echo"".n_format($ccc,2)." | ";
$sqlx="select sum(a.money) as sum_a from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where a.paid='3' and c.y_project = '$e_year' and d.school_id ='".$row['id']."' group by d.school_id ";
$resultx=mysql_query($sqlx);
$rsx = mysql_fetch_array($resultx) ;
if ($rsx['sum_a']!='') {
$sum_a = $rsx['sum_a'];
} else {
$sum_a = 0;
}
$ddd = $ccc-$sum_a;
echo"".n_format($sum_a,2)." | ";
echo"".n_format($ddd,2)." | ";
if ($ccc!=0) {
$percen = ($sum_a/ $ccc)*100;
} else {
$percen = 0;
}
echo"".n_format($percen,2)." | ";
echo"";
}
?>
|
|
Highcharts Example
|
Bootstrap 101 Template
ตารางข้อมูลการใช้จ่ายแต่ละโรงเรียน จังหวัดประจวบคีรีขันธ์
| โรงเรียน |
ยอดอนุมัติเงิน |
ค่าใช้จ่าย |
คงเหลือ |
เปอร์เซ็นการใช้จ่าย |
";
echo"".$row['name']." | ";
$sqla="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype in ('2','3') group by d.school_id";
$resulta=mysql_query($sqla);
$rsa = mysql_fetch_array($resulta);
if ($rsa['money']!='') {
$aaa = $rsa['money'];
} else {
$aaa = 0;
}
$sqlb="select sum(a.money) as money from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where d.school_id ='".$row['id']."' and c.y_project = '$e_year' and a.paytype = '4' group by d.school_id";
$resultb=mysql_query($sqlb);
$rsb = mysql_fetch_array($resultb);
if ($rsb['money']!='') {
$bbb = $rsb['money'];
} else {
$bbb = 0;
}
$ccc = $aaa-$bbb;
echo"".n_format($ccc,2)." | ";
$sqlx="select sum(a.money) as sum_a from booklist a inner join project c on a.project_id = c.project_id inner join officer d on c.office_id = d.office_id where a.paid='3' and c.y_project = '$e_year' and d.school_id ='".$row['id']."' group by d.school_id ";
$resultx=mysql_query($sqlx);
$rsx = mysql_fetch_array($resultx) ;
if ($rsx['sum_a']!='') {
$sum_a = $rsx['sum_a'];
} else {
$sum_a = 0;
}
$ddd = $ccc-$sum_a;
echo"".n_format($sum_a,2)." | ";
echo"".n_format($ddd,2)." | ";
if ($ccc!=0) {
$percen = ($sum_a/ $ccc)*100;
} else {
$percen = 0;
}
echo"".n_format($percen,2)." | ";
echo"";
}
?>
|
|
สำนักงานเขตพื้นที่การศึกษามัธยมศึกษา เขต ๑๐
ที่อยู่ 300 ถ.ดำเนินเกษม ต.คลองกระแชง
อ.เมืองเพชรบุรี จ.เพชรบุรี 76000
|
|