getData($query1); $query2 = "SELECT * FROM persontb WHERE personCode=$id "; $result2 = $crud->getData($query2); foreach($result2 as $key => $res2){$name=$res2['name']." ".$res2['surName'];} $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id "; $result3 = $crud->getData($query3); foreach($result3 as $key => $res3){$sumAll=($res3['to1']+$res3['to2']+$res3['to3']+$res3['to4']+$res3['to5']+$res3['to6']+$res3['to7']+$res3['to8']+$res3['to9']);} ?>
ของ =$name?> |
||||||||||
---|---|---|---|---|---|---|---|---|---|---|
ครั้งที่ | ชื่อโครงการที่เข้าร่วม | เริ่มต้น | สิ้นสุด | ชม.วก. | ชม.วช. | เงิน วก. | เงิน วช. | รวมเงิน | รวมชั่วโมง | % รายโครงการ |
=$no?> | =$res1['projectName']?> | =DateThai($res1['start'])?> | =DateThai($res1['end'])?> | =number_format($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out'])?> | =number_format($res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out'])?> | =number_format($res1['ac_money'])?> | =number_format($res1['pr_money'])?> | =number_format(($res1['ac_money']+$res1['pr_money']+$res1['moral_money']),2)?> | =number_format(($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']),2)?> | =number_format((($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'])/$sumAll)*100,2)?>% |
รวมทั้งหมด | =number_format($sumary1,2)?> | =number_format($sumary2,2)?> | =number_format($sumary4,2)?> | =number_format($sumary5,2)?> | =number_format($sumary7,2)?> | =number_format($sumary8,2)?> |