|
|
๑. รายงานเกี่ยวกับโครงการ |
|
๑.๑. |
จำนวนโครงการที่บูรณาการกับการเรียนการสอน |
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum ). " "."โครงการ".""; else echo number_format( $countnum ); ?> [execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M21) AS sum FROM edu_service_tb WHERE M21='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?>] |
|
|
|
=$no;?> |
RegDBConn();
$sql = "Select * From Course Where courseId ='$rs1[courseId]' ";
$result6= mysql_query($sql) or die("Error".mysql_error());
$rs6 = mysql_fetch_array($result6);
echo $rs6['courseCode'] ." ". $rs6['courseName'] ." ". $rs6['courseUnit'] ;
$dbObj->DBConn();
?> |
|
|
|
๑.๒. |
จำนวนโครงการที่บูรณาการการกับงานวิจัย/บทความ |
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> [execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M22) AS sum FROM edu_service_tb WHERE M22='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?>] |
|
|
|
=$no;?> |
|
|
|
|
๑.๓. |
จำนวนโครงการที่บูรณาการทำนุบำรุงศิลปวัฒนธรรม |
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> [execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M23) AS sum FROM edu_service_tb WHERE M23='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?>] |
|
|
|
=$no;?> |
|
|
|
|
๑.๔. |
จำนวนโครงการที่พัฒนาบุคลากรด้านสุขภาพ |
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> [execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M24) AS sum FROM edu_service_tb WHERE M24='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?>] |
|
|
|
=$no;?> |
|
|
|
|
๑.๕. |
โครงการที่แยกตามกลุ่มเป้าหมาย |
|
|
|
|
๑.๕.๑. ประชาชนทั่วไป |
$sql = " SELECT * FROM edu_service_tb WHERE M31='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M31='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?>
|
|
|
๑.๕.๒. นักเรียน/นักศึกษา |
$sql = " SELECT * FROM edu_service_tb WHERE M32='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M32='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๑.๕.๓. พยาบาลวิชาชีพ |
$sql = " SELECT * FROM edu_service_tb WHERE M33='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M33='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๑.๕.๔. อาจารย์พี่เลี้ยง |
$sql = " SELECT * FROM edu_service_tb WHERE M34='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M34='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๑.๕.๕. ศิษย์เก่า |
$sql = " SELECT * FROM edu_service_tb WHERE M36='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M36='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๑.๕.๖. เจ้าหน้าที่สาธารณสุข |
$sql = " SELECT * FROM edu_service_tb WHERE M37='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M37='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๑.๕.๗. อื่นๆ ระบุ |
$sql = " SELECT * FROM edu_service_tb WHERE M35='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M31) AS sum FROM edu_service_tb WHERE M35='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['sum31'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
๑.๖. |
จำนวนตามพันธกิจโครงการแสดงรายปีงบประมาณ |
|
|
|
๑.๗. |
จำนวนตามพันธกิจโครงการแสดงรายปีการศึกษา |
|
|
|
|
|
๒. ผลของโครงการ |
|
๒.๑. |
การบรรลุเป้าหมายครบทุกข้อ |
$sql = " SELECT * FROM edu_service_tb WHERE M101='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> [execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M101) AS sum FROM edu_service_tb WHERE M101='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?>] |
|
|
๒.๒. |
คะแนนเฉลี่ยความพึงพอใจของผู้รับบริการ |
|
|
|
|
๒.๒.๑. มากกว่า 3.51 ขึ้นไป |
$sql = " SELECT * FROM edu_service_tb WHERE M102='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M102) AS sum FROM edu_service_tb WHERE M102='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
๒.๒.๒. เท่ากับ 3.51 |
$sql = " SELECT * FROM edu_service_tb WHERE M102='2' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M102) AS sum FROM edu_service_tb WHERE M102='2' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
๒.๒.๓. น้อยกว่า 3.51 |
$sql = " SELECT * FROM edu_service_tb WHERE M102='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M102) AS sum FROM edu_service_tb WHERE M102='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
|
๒.๓. |
จำนวนผู้ เข้าร่วมโครงการ |
|
|
|
|
- เป็นไปตามเป้าหมาย |
$sql = " SELECT * FROM edu_service_tb WHERE M103='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M103) AS sum FROM edu_service_tb WHERE M103='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
- มากกว่าเป้าหมาย |
$sql = " SELECT * FROM edu_service_tb WHERE M103='2' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M103) AS sum FROM edu_service_tb WHERE M103='2' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
- น้อยกว่าเป้าหมาย |
$sql = " SELECT * FROM edu_service_tb WHERE M103='3' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M103) AS sum FROM edu_service_tb WHERE M103='3' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๒.๔. |
การสร้างรายรับให้กับสถาบัน จำนวนเงิน
|
|
|
|
๒.๕. |
งบประมาณที่ใช้ |
|
|
|
|
-
เป็นไปตามที่กำหนด |
$sql = " SELECT * FROM edu_service_tb WHERE M104='Y' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M104) AS sum FROM edu_service_tb WHERE M104='Y' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
- มากกว่า |
$sql = " SELECT * FROM edu_service_tb WHERE M1041='1' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M1041) AS sum FROM edu_service_tb WHERE M1041='1' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
- น้อยกว่า |
$sql = " SELECT * FROM edu_service_tb WHERE M1041='2' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M104) AS sum FROM edu_service_tb WHERE M1041='2' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
๒.๖. |
การนำไปใช้ประโยชน์ |
$sql = " SELECT * FROM edu_service_tb WHERE M11='Y' and Budget_Year='$Budget_Year' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
".number_format( $countnum )." "."โครงการ".""; else echo number_format( $countnum ); ?> |
execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$sql = "SELECT COUNT(M11) AS sum FROM edu_service_tb WHERE M11='Y' and Budget_Year='$Budget_Year' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs3['num'] ;
echo number_format($per2,'2','.','')." %";
?> |
|
|
|
|
|
|
|
|