| แสดงข้อมูลเงินเดือนบุคคลรายเดือน ปี |
| No |
เดือน |
สรุปยอดเงินรายเดือน |
จำนวนรายการทั้งหมด |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$query2 = " SELECT * FROM month_tb WHERE monthCode='$rs[Start_mont]' ";
$result2 = $dbObj->execQuery($query2);
$rs2 = $dbObj->fetchArray($result2);
$countnum2 = $dbObj->_numrows;
$query3 = " SELECT * FROM salary_repot_tb WHERE Start_mont='$rs[Start_mont]' AND Start_year='$Start_year' ";
$result3 = $dbObj->execQuery($query3);
$rs3 = $dbObj->fetchArray($result3);
$countnum3 = $dbObj->_numrows;
?>
|
|
|
|
| ทั้งหมด เดือน |
| ";
// Fetch all factory records
$strQuery111 = " SELECT * FROM $myTable WHERE Start_year='$Start_year' GROUP BY $myTablePK ORDER BY $myTablePK ASC ";
$result111 = mysql_query($strQuery111);
//Iterate through each factory
if ( $result111 ) {
while( $rs111 = mysql_fetch_array($result111) ) {
$query112 = " SELECT * FROM month_tb WHERE monthCode='$rs111[Start_mont]' ";
$result112 = mysql_query($query112);
$rs112 = mysql_fetch_array($result112);
$strQuery222 = " SELECT * FROM salary_repot_tb WHERE Start_mont='$rs111[Start_mont]' AND Start_year='$Start_year' ";
$result222 = mysql_query($strQuery222);
$numAmt = mysql_num_rows($result222);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|