=$no;?> |
=$rs['First_name'];?>
=$rs['Teacher_name'];?>
=$rs['Teacher_lastname'];?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Content ='วิชาการ' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='บริหาร' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='วิชาชีพเฉพาะ' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='ทัศนคติ' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='การเรียนการสอน' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='คุณธรรมจริยธรรม' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and Content ='อื่นๆ' and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?>
|
= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' and Teacher_code='$rs[Teacher_code]' and ( Content ='วิชาการ' Or Content ='บริหาร' Or Content ='วิชาชีพเฉพาะ' Or Content ='ทัศนคติ' Or Content ='การเรียนการสอน' Or Content ='คุณธรรมจริยธรรม' Or Content ='อื่นๆ') and (Training_std ='N' Or Training_std ='Y' ) ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo number_format($rs2['Sum'],2,'.',',');
?> |