
<?php



    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 );

    

    /**  Configuration  */

    include( "configuration.php" );

    require_once( $_Config_absolute_path . "/includes/framework.php" );



    /**  using 'reg' DB  */

    include("./includes/FunctionDB.php");



    /**  Chart  */

    include ("./includes/charts.php");

        

    /**  Create Database Object  */

    //$dbObj = new DBConn;

    ConnectDB();

        

    /**  Config Table for This Page  */

    $myTable = "StudentMaster";

    $myTableFK = "studentId";

    

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />

<title><?=$_Config_sitename;?> - ข้อมูลสารสนเทศนักศึกษา - กราฟแสดงจำนวนนักศึกษา จำแนกตามปีการศึกษา</title>

<script type="text/javascript" src="./js/utilities.js"></script>

<script language="Javascript" src="./charts/charts.js"></script>

<link href="./css/default.css" rel="stylesheet" type="text/css" />

</head>



<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">

<?php

    include( "./templates/incHeader.php" );

?>

<table width="1003" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td width="215" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include( "templates/incMainMenuLeft.php" );?></td>

    <td width="788" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>

     <table width="770" border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td height="5"></td>

      </tr>

      <tr>

        <td height="30" background="images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>&raquo; <a href="Menu_Student.php">ข้อมูลนักศึกษา</a> &raquo; <span class="NOTE">กราฟแสดงจำนวนนักศึกษา จำแนกตามปีการศึกษา</span></strong></td>

        </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td align="center" valign="top"><p><table width="750" border="0" cellspacing="0" cellpadding="0">

            <tr>

              <td align="center"><?php

                    $animateChart = "1";

                

                    //$strXML will be used to store the entire XML document generated

                    //Generate the chart element

                    $strXML = "<chart caption='กราฟแสดงจำนวนนักศึกษา' subCaption='จำแนกตามปีการศึกษา' pieSliceDepth='30' showBorder='0' formatNumberScale='0' numberSuffix=' คน' animation=' " . $animateChart . " '>";

                

                    // Fetch all factory records

                    $strQuery = " SELECT *  FROM $myTable  WHERE studentStatus='1'  GROUP BY admitAcadYear ";    

                    $result1 = mysql_query($strQuery);

                

                    //Iterate through each factory

                    if( $result1 ) {

                        while( $rs1 = mysql_fetch_array($result1) ) {

                            $admitAcadYear = $rs1['admitAcadYear'];

                        

                            $strQuery2 = " SELECT *  FROM  $myTable  WHERE studentStatus='1'  AND  admitAcadYear='$admitAcadYear' AND  studentSex ='M' ";

                            $result2 = mysql_query($strQuery2);

                            $numAmt2 = mysql_num_rows($result2);

                            mysql_free_result($result2);

                            

                            $strQuery3 = " SELECT *  FROM  $myTable  WHERE studentStatus='1'  AND  admitAcadYear='$admitAcadYear' AND  studentSex ='F' ";

                            $result3 = mysql_query($strQuery3);

                            $numAmt3 = mysql_num_rows($result3);

                            mysql_free_result($result3);

                            

                            $strXML .= "<set label='" . $admitAcadYear . " (ช)' value='" . $numAmt2 . "' />";

                            $strXML .= "<set label='" . $admitAcadYear . " (ญ)' value='" . $numAmt3 . "' />";

                        

                        } # while

                    } # if

                    mysql_free_result($result1);

                

                    //Finally, close <chart> element

                    $strXML .= "</chart>";

                

                    //Create the chart - Pie 3D Chart with data from strXML

                    echo renderChart("./charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);

              ?></td>

            </tr>

          </table>

          <br />

          </p></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

    </table>

    </fieldset></td>

  </tr>

</table>

<?php include( "./templates/incFooter.php" ); ?>

</body>

</html>

<?php

    /**  Free Resource */

    //$dbObj->freeresult($result);

    

    /**  Close the Database  */

    //$dbObj->disconn();

    CloseDB();

    

    /**  Unset Class  */

    //unset($dbObj);

?>