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']);}
?>