
<?php



    session_start();

    

    /**  Define Validate Access  */

    define( '_VALID_ACCESS', 1 );



    /**  Check Session User Login  */

    if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {

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

        echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";

        echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";

        exit();

    } 

    else {

        /**  Configuration  */

        require_once( "../configuration.php" );

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

        require_once( "../include/Function.php" );

    

        /**  Create Database Object  */

        $dbObj = new DBConn;



        //=== SESSION

        $Username = $valid_user; 

        

        

        /**  Config Table for This Page  */

        $myTable1 = "personal_tb";

        

        /**  Table  -->  personal_tb  */

        $query = "SELECT *  FROM personal_tb 

                    LEFT JOIN district ON personal_tb.districtId = district.districtId 

                    LEFT JOIN amphur ON personal_tb.amphurId = amphur.amphurId 

                    LEFT JOIN province ON personal_tb.provinceId = province.provinceId

                    WHERE Username='$Username' ";

        $result = $dbObj->execQuery($query);

        $rs = $dbObj->fetchArray($result);

        $Teacher_code = $rs['Teacher_code'];



        $query2 = " SELECT * FROM prefix";

        $result2 = $dbObj->execQuery($query2);



        $doc_path = $_Config_live_site."/personal_pic";

    } # else

 ?>

<!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" />

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

<script language="javascript" src="../js/utilities.js"></script>

<script language="javascript" src="../js/calendarDateInput2.js"></script>

<script language="javascript" src="../js/ajaxScript.js"></script>

<title>ข้อมูลประวัติส่วนตัว - แก้ไขข้อมูลประวัติส่วนตัว</title>

</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="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>

    <td width="800" height="440" align="left" valign="top" style="padding:10px 0px 5px 10px"><fieldset>

    <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php">หน้าหลัก</a></font><img src="../picture/ico3.gif" width="10" height="10" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Menu_History.php?Teacher_code=<?=$Teacher_code;?>">ข้อมูลประวัติส่วนตัว</a></font></font><img src="../picture/ico3.gif" width="10" height="10" align="absmiddle" border="0" /></font><span class="NOTE"><strong>แก้ไขข้อมูลประวัติส่วนตัว</strong></a></font></span></legend>

    <form id="pc" name="pc" method="post" action="Edit_Fam_His.php" enctype="multipart/form-data">

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

      <tr>

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

      </tr>

      

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td height="150" align="center">

            <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">

              <tr>

                <td width="76%">

                    <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#E4E4E4">

                        <tr bordercolor="#E7FAFE">

                            <td width="20%" height="20" align="right" nowrap bordercolor="#FFFFFF" bgcolor="#FFFFFF">ชื่อ-นามสกุล</td>

                            <td width="0%" nowrap bgcolor="#FFFFFF">&nbsp;</td>

                            <td width="80%" nowrap bgcolor="#FFFFFF">

                                <SELECT NAME="First_name" style="text-align:center">

                                    <OPTION VALUE="">---------- เลือก ----------</OPTION>

                                    <?php 

                                        while($rs2 = mysql_fetch_object($result2)){

                                    ?>                                                

                                            <OPTION style="text-align:left" VALUE="<?=$rs2->prefixId;?>" <?=($rs2->prefixId==$rs["First_name"])?"SELECTED":"";?>><?=$rs2->prefixName;?></OPTION>

                                    <?

                                        }

                                    ?>

                                </SELECT>&nbsp;

                                <input name="Teacher_name" type="text" size="18" id="Teacher_name" value="<? echo $rs['Teacher_name']; ?>" /> - 

                                <input name="Teacher_lastname" type="text" size="18" id="Teacher_lastname" value="<? echo $rs['Teacher_lastname']; ?>" />                            </td>

                        </tr>

                        <tr bordercolor="#E7FAFE">

                            <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">เลขที่บัตรประชาชน</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF"><input name="Citizen_id" type="text" id="Citizen_id" value="<?=citizenID_format($rs['Citizen_id']);?>" size="15" maxlength="17" onkeypress="return (NumOnly(event) && changeFormatPin(this,event));"/></td>

                        </tr>

                        <tr bordercolor="#FFFFFF">

                            <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">วัน/เดือน/ปี เกิด</td>

                            <td width="10" nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">

                                <script>DateInput('mDate', true, 'DD/MM/YYYY','<?=(isset($rs["DateBirth"]))?ymdT2dmyE($rs["DateBirth"]):date("d/m/Y");?>');</script>                            </td>

                        </tr>

                        <tr bordercolor="#E7FAFE">

                            <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">เพศ</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">

                                <input type="radio" name="Sex" id="Sex" <?php if ( !strcmp("$rs[Sex]","ชาย") ) { echo "checked"; } ?> value="ชาย" />

                                ชาย

                                <input type="radio" name="Sex" id="Sex" <?php if ( !strcmp("$rs[Sex]","หญิง") ) { echo "checked"; } ?> value="หญิง" />

                                หญิง                            </td>

                        </tr>

                        <tr bordercolor="#E7FAFE">

                            <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">เชื้อชาติ</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">

                                <input name="Nationality" id="Nationality" type="text" value="<? echo $rs['Nationality']; ?>" size="7" /> &nbsp; สัญชาติ 

                                <input name="Nation" id="Nation" type="text" value="<? echo $rs['Nation']; ?>" size="7" />                            </td>

                        </tr>

                        <tr bordercolor="#E7FAFE">

                            <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ศาสนา</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                            <td nowrap="nowrap" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                        <tr>

                            <td colspan="3">

                                <input type="radio" name="Religion" id="Religion" value="พุทธ" <?php if (!strcmp("$rs[Religion]","พุทธ") ) { echo "checked"; } ?> onclick="document.getElementById('ReligionOther').style.display='none'"/>

                                พุทธ

                                <input type="radio" name="Religion" id="Religion" value="คริสต์" <?php if (!strcmp("$rs[Religion]","คริสต์") ) { echo "checked"; } ?> onclick="document.getElementById('ReligionOther').style.display='none'"/>

                                คริสต์

                                <input type="radio" name="Religion" id="Religion" value="อิสลาม" <?php if ( !strcmp("$rs[Religion]","อิสลาม") ) { echo "checked"; } ?> onclick="document.getElementById('ReligionOther').style.display='none'"/>

                                อิสลาม

                                <input type="radio" name="Religion" id="Religion" value="อื่นๆ" <?php if ( !strpos($rs["Religion"],"@")===false ) { echo "checked"; } ?> onclick="document.getElementById('ReligionOther').style.display=''"/>

                                อื่นๆ

                                <input type="text" name="ReligionOther" id="ReligionOther" size="7" style="display:<?=(!stripos($rs["Religion"],'@')===false)?"":"none";?>" value="<?php if(!stripos($rs["Religion"],'@')===false){list($relType,$relName)=split('@',$rs["Religion"]); echo $relName;}?>">                            </td>

                        </tr>

                    </table>                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td align="right" valign="top" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ที่อยู่ตาม ภูมิลำเนา</td>

                <td width="10" nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input type="text" name="Address" id="Address" value="<?=htmlspecialchars_decode($rs['Address']);?>" size="15">                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ตำบล/แขวง</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input name="districtName" type="text" class="input1" id="districtName" value="<?=$rs["districtName"];?>" size="15" maxlength="100" readonly="readonly" />

                      <img src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id="IMG3" style="CURSOR: hand" onclick='MM_openBrWindow(&quot;homeDistrictTable.php&quot;,&quot;test&quot;,&quot;width = 550, height=350,scrollbars=yes&quot;)' />

                      <input name="districtId" type="hidden" value="<? echo $rs['districtId']?>" />                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">อำเภอ/เขต</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input name="amphurName" type="text" class="input1" id="amphurName" value="<?=$rs["amphurName"];?>"  size="15" maxlength="100" readonly="readonly" />

                    <input name="amphurId" type="hidden" value="<? echo $rs['amphurId']?>" />                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">จังหวัด</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input name="provinceName" type="text" class="input1" value="<?=$rs["provinceName"];?>"  size="15" maxlength="100" readonly="readonly" />                    

                    <input name="provinceId" type="hidden" id="provinceId" value="<? echo $rs['provinceId']?>" />                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">สถานภาพ บิดา</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input type="radio" name="Status2" id="Status2" value="มีชีวิตอยู่" <?php if ( !strcmp("$rs[Status2]","มีชีวิตอยู่") ) { echo "checked"; } ?> />

                    มีชีวิตอยู่

                    <input type="radio" name="Status2" id="Status2" value="ถึงแก่กรรม" <?php if ( !strcmp("$rs[Status2]","ถึงแก่กรรม") ) { echo "checked"; } ?> />

                    ถึงแก่กรรม                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">สถานภาพ มารดา</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input type="radio" name="Status3" id="Status3" value="มีชีวิตอยู่" <?php if ( !strcmp("$rs[Status3]","มีชีวิตอยู่") ) { echo "checked"; } ?> />

                    มีชีวิตอยู่

                    <input type="radio" name="Status3" id="Status3" value="ถึงแก่กรรม" <?php if ( !strcmp("$rs[Status3]","ถึงแก่กรรม") ) { echo "checked"; } ?> />

                    ถึงแก่กรรม                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ชื่อ-นามสกุล บิดา</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input name="Father_name" id="Father_name" type="text" value="<? echo $rs['Father_name']; ?>" size="30" />                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ชื่อ-นามสกุล มารดา</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF"><input name="Mother_name" id="Mother_name" type="text" value="<? echo $rs['Mother_name']; ?>" size="30" /></td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">สถานภาพการสมรส</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <table width="100%" border="0" cellspacing="0" cellpadding="0">

                        <tr>

                            <td>

                                <input type="radio" name="Status" id="Status" <?php if ( !strcmp("$rs[Status]","โสด") ) { echo "checked"; } ?> value="โสด" onclick="document.getElementById('SoulmateRows').style.display='none'; document.getElementById('Total_childRows').style.display='none';" checked/>

                                โสด

                                <input type="radio" name="Status" id="Status" <?php if ( !strcmp("$rs[Status]","สมรส") ) { echo "checked"; } ?> value="สมรส" onclick="document.getElementById('SoulmateRows').style.display=''; document.getElementById('Total_childRows').style.display='';"/>

                                สมรส

                                <input type="radio" name="Status" id="Status" <?php if ( !strcmp("$rs[Status]","หย่าร้าง") ) { echo "checked"; } ?> value="หย่าร้าง" onclick="document.getElementById('SoulmateRows').style.display=''; document.getElementById('Total_childRows').style.display='';"/>

                                หย่าร้าง

                                <!--<input type="radio" name="Status" id="Status" <?php if ( !strcmp("$rs[Status]","ถึงแก่กรรม") ) { echo "checked"; } ?> value="ถึงแก่กรรม" />

                                ถึงแก่กรรม-->                            </td>

                        </tr>

                    </table>                </td>

            </tr>

            <tr bordercolor="#E7FAFE" id="SoulmateRows" style="display:<?=(!strcmp("$rs[Status]","โสด"))?"none":"";?>">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">ชื่อ-นามสกุล คู่สมรส</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF"><input name="Soulmate" type="text" id="Soulmate" value="<? echo $rs['Soulmate']; ?>" size="30" /></td>

            </tr>

            <tr bordercolor="#E7FAFE" id="Total_childRows" style="display:<?=(!strcmp("$rs[Status]","โสด"))?"none":"";?>">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">จำนวนบุตร</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">

                    <input name="Total_child" type="text" id="Total_child" style="text-align:center" value="<? echo $rs['Total_child']; ?>" size="5" maxlength="3" />

                    คน                </td>

            </tr>

            <tr bordercolor="#E7FAFE">

                <td height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">รูปภาพประจำตัว</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>

                <td nowrap="nowrap" bgcolor="#FFFFFF"><input name="Img1" type="file" id="Img1" size="30" />&nbsp;&nbsp;<I>ไฟล์ jpg เท่านั้น</I></td>

            </tr>

            <tr bgcolor="#CEE6FF">

                <td colspan="3" bgcolor="#FFFFFF">&nbsp;</td>

            </tr>

            <tr bgcolor="#CEE6FF">

                <td height="20" bgcolor="#FFFFFF" align="center">&nbsp;</td>

                <td height="20" bgcolor="#FFFFFF" align="center">&nbsp;</td>

                <td height="20" bgcolor="#FFFFFF" align="left">

                    <input type="hidden" name="Teacher_code" value="<? echo $rs['Teacher_code']; ?>" />

                    <input name="btnSubmit" type="submit" id="btnSubmit" class="WIDTH60 CURSOR-HAND" value="บันทึก" title="คลิ๊กที่นี่เพื่อบันทึกข้อมูลที่แก้ไข"/>

                      &nbsp;

                    <input name="btnBack" type="button" id="btnBack" onclick="location.href='Show_Fam_History.php'" value="ยกเลิก" class="WIDTH60 CURSOR-HAND" />                </td>

            </tr>

        </table>    </td>

    <td width="24%" valign="top" align="center">

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

            <tr>

                <td><img src="<?=$personalPicPath.$rs['Img1'];?>" width="150" height="170" /></td>

            </tr>

        </table>    </td>

   </tr>

 </table></td>

</tr>

<tr>

 <td>&nbsp;</td>

      </tr>

    </table>

    </form>

</fieldset></td>

</tr>

</table>

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

</body>

</html>

<?php

    /**  Free Resource */

    $dbObj->freeresult($result1);

    

    /**  Close the Database  */

    $dbObj->disconn();

    

    /**  Unset Class  */

    unset($dbObj);

?>