|
$setdata=$_POST[setdata];
$multi=$_POST[multi];
if($multi==TRUE){
if($setdata=="A"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and Year_prop !='0' GROUP BY rt.Year_prop ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.Year_prop ='$rs1[Year_prop]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="B"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and academic_year_finish !='0' GROUP BY rt.academic_year_finish ";
$result2= mysql_query($strQuery);
//Iterate through each factory
if ($result2) {
while( $rs2 = mysql_fetch_array($result2) ) {
$error_id = $rs2['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.academic_year_finish ='$rs2[academic_year_finish]' ";
$result3 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result3);
$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);
?>
}
if($setdata=="C"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish !='0' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="D"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rt.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outreacId ='Y' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rt.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outreacId ='Y' and rt.fiscal_year_finish ='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="E"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rb.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outSouse ='Y' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rb.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outSouse ='Y' and rt.fiscal_year_finish ='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="F"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code Group By rd.academic_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT SUM(Results) AS Sum FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code and rd.academic_year_finish='$rs1[academic_year_finish]' ";
$result2 = mysql_query($strQuery);
$rs2 = $dbObj->fetchArray($result2);
// $Sum = mysql_num_rows($result2);
// echo number_format($rs6['Sum'],2,'.',',');
$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);
?>
}
if($setdata=="G"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt , research_dissemination rd WHERE rt.Research_code = rd.Research_code Group By rd.academic_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code and rd.academic_year_finish='$rs1[academic_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("./charts/Column2D.swf", "", $strXML, "", 750, 375, false, false);
?>
}
}
?> |
|
|