| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)pathways.org.hk/MIS2/old/student/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<?php require_once '../include/head.php'; ?>
<?php require_once '../include/checkuser.php'; ?>
<?php require_once '../include/Nav_bar.php'; ?>
<?php require_once '../include/DBConnect.php'; ?>
<script type="text/javascript" src="../include/FileUpload/ajaxfileupload.js"></script>
<script>
$(function(){
$('.date-picker').datetimepicker({ pickTime: false,format: 'yyyy-MM-dd' });
});
$(document).ready(function(){
$(document).on('click','#upload',function ajaxFileUpload(){
$.ajaxFileUpload({
url: 'upload_stu_photo.php',
secureuri: false,
fileElementId: 'browse',
dataType: 'json',
data: {name: 'logan', id: 'id'},
success: function(data, status){
if (typeof(data.error) != 'undefined')
{
if (data.error != ''){
alert(data.error);
}
else{
loading.src="student_photo/"+data.msg;
$('#photo').val("student_photo/"+data.msg);
}
}
},
error: function(data, status, e){
alert("error");
alert(e);
}
}
)
return false;
});
$.ajax({
type: "POST",
url: "ajax_edit_stu.php",
data:{
subsidy:$('#subsidy').val(),
linking_id:window.location.toString().split("?")[1].split("=")[1]
},
cache:false,
success:function(html){
$("#subsidy_show").html(html);
}
});
});
$(document).on('change','#subsidy',function(){
$.ajax({
type: "POST",
url: "ajax_edit_stu.php",
data:{
subsidy:$('#subsidy').val(),
linking_id:window.location.toString().split("?")[1].split("=")[1]
},
cache:false,
success:function(html){
$("#subsidy_show").html(html);
}
});
});
$(document).ready(function(){Add_Diagnoses()});
$(document).ready(function(){Add_aspect()});
function delete_row(e){
$(e).parent().parent().remove();
}
function Add_Diagnoses(){
var array = new Array();
var tr="";
for(var i=0;i<(document.getElementsByName("diagnose[]")).length;i++){
if(document.getElementsByName("diagnose[]")[i].checked == true){
array.push((document.getElementsByName("diagnoseval[]")[i].value));
}
}
for(var i=0;i<array.length;i++){
tr+=
"<tr>"+
"<td style=\"border: 1px solid #dddddd;width: 50px;\"><button onclick=\"delete_row(this);\" type='button' class=\"btn\"><i class=\"icon-remove\"></i></button></td>"+
"<td>"+array[i]+"</td>"+
"</tr>";
}
$('#Add_Diagnoses').html(tr);
}
function Add_aspect(){
var array = new Array();
var tr = "";
for(var i=0;i<(document.getElementsByName("add_aspect[]")).length;i++){
if(document.getElementsByName("add_aspect[]")[i].checked == true){
array.push((document.getElementsByName("add_aspectval[]")[i].value));
}
}
for(var i=0;i<array.length;i++){
tr +=
"<tr>"+
"<td style=\"border: 1px solid #dddddd;width: 50px;\"><button onclick=\"delete_row(this);\" type='button' class=\"btn\"><i class=\"icon-remove\"></i></button></td>"+
"<td>"+array[i]+"</td>"+
"</tr>";
}
$('#Add_Aspect').html(tr);
}
</script>
</head>
<body>
<!-- line between nav bar and content -->
<div class="text-right">
<ul class="breadcrumb">
<li><a href="student.php">Student</a></li>
<li><a href="#"></a> <span class="divider">></span></li>
<li class="active">Edit Student</li>
</ul>
</div>
<?php
$linking_id = $_GET['linking_id'];
$query_init = "Select Old_stu_id as o,New_stu_id as n,Sem_yr as s_yr,root_id,
createby, createdate, lastupby, lastupdate, actived, deleted, reg_campus_id,
input_date, application_date, registration_date, is_pathway_student,
is_in_school_student,registration_number, reg_sem_year,last_name, first_name,
ch_name, gender, date_of_birth, home_tel, fax, email, photo, address,
district_id,school_name, father_name, father_occupation, father_mobile, father_off_tel,
mother_name, mother_occupation, mother_mobile, mother_off_tel, guardian_name,
guardian_occupation, guardian_relationship, guardian_mobile, guardian_home_tel,
guardian_off_tel, eme_contact_name, eme_contact_number, eme_contact_relationship,
remarks, ch_assessment_ID, ch_assessment_date,
en_assessment_ID, en_assessment_date, math_assessment_ID, math_assessment_date,
medication from student where linking_id='$linking_id' and deleted='0'";
$query_init1 = "Select grade_id from student_grade where student_grade_id='$linking_id' and deleted='0'";
$query_init2 = "Select diagnose_id,refer_by,other_refer_by from student_diagnose where stu_dia_ID='$linking_id' and deleted='0'";
$query_init3 = "Select aspect_id,assessed_by,other_assessed_by from student_additional_aspect where stu_add_ID='$linking_id' and deleted='0'";
$result = $dbh->query($query_init);
$result->setFetchMode(PDO::FETCH_OBJ);
$row = $result->fetch();
$result1 = $dbh->query($query_init1);
$result1->setFetchMode(PDO::FETCH_OBJ); //grade
$row_init = $result1->fetch();
$result3 = $dbh->query($query_init3);
//$result3->setFetchMode(PDO::FETCH_OBJ);//aspect
//$row_init1=$result3->fetch();
$result2 = $dbh->query($query_init2);
//$result2->setFetchMode(PDO::FETCH_OBJ);//diagnose
//$row_init2=$result2->fetch();
?>
<div class="container-fluid pathways-container">
<form action="student_edit2.php" method="POST">
<table border="0" class="table table-striped table-bordered table-hover table-condensed">
<tr>
<td colspan="4"><h2>Edit Student</h2></td>
</tr>
<tr>
<td>Student No.(Old System)</td>
<td><input type="text" name="old_stu_id" required="true" value="<?= $row->o ?>"></td>
<td>Student No.(New System)</td>
<td><input type="text" name="new_stu_id" required="true" value="<?= $row->n ?>"></td>
</tr>
<tr>
<td>Semester_year</td>
<td colspan="3"><input type="text" name="sem_yr" placeholder="2013-2014" required="true" maxlength="9" minlength="9" value="<?= $row->s_yr; ?>"></td>
</tr>
<tr>
<td>Data Input Date</td>
<td>
<div class="input-append date-picker">
<input type="text" name="input_date" class="dateISO" required="true" value="<?= $row->input_date; ?>">
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
</td>
<td>Input By</td>
<td>
<input type="text" name="input_by" value="Chung Wai ki" readonly="true" required="true" value="<?= $row->createby ?>">
</td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td colspan="4"><b><h4>Student Information</h4></b></td>
</tr>
<tr>
<td>Registration Number</td>
<td colspan="3"><input type="text" name="reg_num" required="true" value="<?= $row->registration_number ?>"></td>
</tr>
<tr>
<td>Status</td>
<td colspan="3">
<select name="is_actived">
<?php
if ($row->actived == 1) {
?>
<option value="1" selected>Active</option>
<option value="0">Disable</option>
<?php
} else {
?>
<option value="1">Active</option>
<option value="0" selected>Disable</option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td>Application Date</td>
<td colspan="3">
<div class="input-append date-picker">
<input type="text" name="app_date" class="dateISO" required="true" value="<?= $row->application_date; ?>">
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
</td>
</tr>
<tr>
<td>Registration Date</td>
<td colspan="3">
<div class="input-append date-picker">
<input type="text" name="reg_date" class="dateISO" required="true" value="<?= $row->registration_date; ?>">
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
</td>
</tr>
<tr>
<td>Type</td>
<td colspan="3">
<?php
if ($row->is_pathway_student == 1) {
?>
<input type="checkbox" name="is_pathway_stu" value="1" checked>Pathway Student
<?php
} else {
?>
<input type="checkbox" name="is_pathway_stu" value="1">Pathway Student
<?php
}
?>
<?php
if ($row->is_in_school_student == 1) {
?>
<input type="checkbox" name="is_in_school" value="1" checked>In-School Student
<?php
} else {
?>
<input type="checkbox" name="is_in_school" value="1">In-School Student
<?php
}
?>
</td>
</tr>
<tr>
<td>Registration Campus</td>
<td colspan="3">
<select name="reg_campus">
<?php
$query = "Select campus_id,campus_name from campus";
$result = $dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while ($row1 = $result->fetch()) {
if ($row->reg_campus_id == $row1->campus_id)
print '<option value=' . $row1->campus_id . ' selected>' . $row1->campus_name . '</option>';
else
print '<option value=' . $row1->campus_id . '>' . $row1->campus_name . '</option>';
}
?>
</select>
</td>
</tr>
<tr>
<td>Registration Semester</td>
<td colspan="3"><input type="text" name="reg_sem_yr" placeholder="2013-2014" required="true" value="<?= $row->reg_sem_year ?>"></td>
</tr>
<tr>
<td colspan="4"><hr></td>
</tr>
<tr>
<td>Last Name</td>
<td><input type="text" name="last_name" required="true" value="<?= $row->last_name; ?>"></td>
<td>First Name</td>
<td><input type="text" name="first_name" required="true" value="<?= $row->first_name; ?>"></td>
</tr>
<tr>
<td>中文姓名</td>
<td><input type="text" name="ch_name" required="true" value="<?= $row->ch_name; ?>"></td>
<td>Gender</td>
<td>
<select name="gender">
<?php
if ($row->gender == 1) {
?>
<option value="1" selected>Male</option>
<option value="0">Female</option>
<?php
} else {
?>
<option value="1">Male</option>
<option value="0" selected>Female</option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td>Date of Birth</td>
<td colspan="3">
<div class="input-append date-picker">
<input type="text" name="date_of_birth" class="dateISO" required="true" value="<?= $row->date_of_birth ?>">
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
</td>
</tr>
<tr>
<td>Tel(Home)</td>
<td><input type="tel" name="home_tel" placeholder="24131323" required="true" value="<?= $row->home_tel ?>"></td>
<td>Fax</td>
<td><input type="tel" name="fax" value="<?= $row->fax ?>"></td>
</tr>
<tr>
<td>E-mail</td>
<td colspan="2"><input type="email" name="email" placeholder="user@example.com" value="<?= $row->email ?>"></td>
<td rowspan="4">
<center>
<?php
if($row->photo!='no photo'){
?>
<img id="loading" src="<?=$row->photo?>">
<input type="hidden" name="photo" id="photo" value="<?=$row->photo?>">
<?php
}
else{
?>
<img id="loading" src="student_photo/personal_photo.gif">
<input type="hidden" name="photo" id="photo" value="no photo">
<?php
}
?>
</center>
</td>
</tr>
<tr>
<td>Address</td>
<td colspan="2"><input type="text" name="address" required="true" value="<?= $row->address ?>"></td>
</tr>
<tr>
<td>District</td>
<td colspan="2">
<select name="district">
<?php
$query1 = "Select district,district_id from district";
$result4 = $dbh->query($query1);
$result4->setFetchMode(PDO::FETCH_OBJ);
while ($row1 = $result4->fetch()) {
if ($row1->district_id == $row->district_id)
print '<option value=' . $row1->district_id . ' selected>' . $row1->district . '</option>';
else
print '<option value=' . $row1->district_id . '>' . $row1->district . '</option>';
}
?>
</select>
</td>
</tr>
<tr>
<td>Name of School Attending</td>
<td colspan="2"><input type="text" name="school_name" required="true" value="<?= $row->school_name ?>"></td>
</tr>
<tr>
<td>Year/Grade</td>
<td colspan="2">
<select name="grade">
<?php
$query2 = "Select grade_id,grade from grade";
$result5 = $dbh->query($query2);
$result5->setFetchMode(PDO::FETCH_OBJ);
while ($row1 = $result5->fetch()) {
if ($row1->grade_id == $row_init->grade_id)//<<$row cant get grade_id
print '<option value=' . $row1->grade_id . '. selected>' . $row1->grade . '</option>';
else
print '<option value=' . $row1->grade_id . '.>' . $row1->grade . '</option>';
}
?>
</select>
</td>
<td>
<center>
<input type="file" name="browse" id="browse" size="45">
<input type="button" id="upload" name="upload" class="btn" value="Upload">
</center>
</td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td colspan="4"><b><h4>Father</h4></b></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="father_name" value='<?= $row->father_name ?>'></td>
<td>Occupation</td>
<td><input type="text" name="father_occ" value='<?= $row->father_occupation ?>'></td>
</tr>
<tr>
<td>Mobile</td>
<td><input type="tel" name="father_mobile" value='<?= $row->father_mobile ?>'></td>
<td>Tel(Office)</td>
<td><input type="tel" name="father_off_tel" value='<?= $row->father_off_tel ?>'></td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td colspan="4"><b><h4>Mother</h4></b></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="mother_name" value='<?= $row->mother_name ?>'></td>
<td>Occupation</td>
<td><input type="text" name="mother_occ" value='<?= $row->father_occupation ?>'></td>
</tr>
<tr>
<td>Mobile</td>
<td><input type="tel" name="mother_mobile" value='<?= $row->mother_mobile ?>'></td>
<td>Tel(Office)</td>
<td><input type="tel" name="mother_off_tel" value='<?= $row->mother_off_tel ?>'></td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td colspan="4"><b><h4>Guardian</h4></b></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="guard_name" value='<?= $row->guardian_name ?>'></td>
<td>Occupation</td>
<td><input type="text" name="guard_occ" value='<?= $row->guardian_occupation ?>'></td>
</tr>
<tr>
<td>Relationship</td>
<td><input type="text" name="guard_relationship" value='<?= $row->guardian_relationship ?>'></td>
<td>Tel(Home)</td>
<td><input type="tel" name="guard_tel_home" value='<?= $row->guardian_home_tel ?>'></td>
</tr>
<tr>
<td>Mobile</td>
<td><input type="tel" name="guard_mobile" value='<?= $row->guardian_mobile ?>'></td>
<td>Tel(Office)</td>
<td><input type="tel" name="guard_off_tel" value='<?= $row->guardian_off_tel ?>'></td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td colspan="4"><b><h4>Emergency Contact Person</h4></b></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="eme_name" value='<?= $row->eme_contact_name ?>'></td>
<td>Contact No.</td>
<td><input type="tel" name="eme_contact_no" value='<?= $row->eme_contact_number ?>'></td>
</tr>
<tr>
<td>Relationship</td>
<td colspan="3"><input type="text" name="eme_relationship" value='<?= $row->eme_contact_relationship ?>'></td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr>
<td><b><h4>Diagnoses</h4></b></td>
<td><button type="button" class="btn" id="diagnoses_btn" data-toggle="modal" data-target="#diagnoses"><i class="icon-plus" ></i> Add</button></td>
<td><b><h4>Additional Aspect</h4></b></td>
<td><button type="button" class="btn" id="add_aspect_btn" data-toggle="modal" data-target="#add_aspect"><i class="icon-plus" ></i> Add</button></td>
</tr>
<tr>
<td colspan="2">
<table id="Add_Diagnoses" style="width: 80%;border: 1px solid #dddddd;margin-left: 40px;margin-bottom: 10px;margin-top: 10px;margin-right: 10px;" >
</table>
</td>
<td colspan="2">
<table id="Add_Aspect" style="width: 80%;border: 1px solid #dddddd;margin-left: 40px;margin-bottom: 10px;margin-top: 10px;margin-right: 10px;" >
</table>
</td>
</tr>
<?php
if ($result2->rowcount() != 0) {
$result2->setFetchMode(PDO::FETCH_OBJ); //diagnose
$row_init2 = $result2->fetch();
?>
<tr>
<td>Refer by</td>
<td><input type="text" name="refer_by" value="<?= $row_init2->refer_by ?>"></td>
<td>Others</td>
<td><input type="text" name="other_refer_by" value="<?= $row_init2->other_refer_by ?>"></td>
</tr>
<?php } else { ?>
<tr>
<td>Refer by</td>
<td><input type="text" name="refer_by"></td>
<td>Others</td>
<td><input type="text" name="other_refer_by"></td>
</tr>
<?php
}
if ($result3->rowcount() != 0) {
$result3->setFetchMode(PDO::FETCH_OBJ); //aspect
$row_init1 = $result3->fetch();
?>
<tr>
<td>Assessed By</td>
<td><input type="text" name="assessed_by" value="<?= $row_init1->assessed_by ?>"></td>
<td>Others</td>
<td><input type="text" name="other_assessed_by" value="<?= $row_init1->other_assessed_by ?>"></td>
</tr>
<?php } else { ?>
<tr>
<td>Assessed By</td>
<td><input type="text" name="assessed_by"></td>
<td>Others</td>
<td><input type="text" name="other_assessed_by"></td>
</tr>
<?php } ?>
<tr>
<td>Remarks</td>
<td colspan="4"><textarea name="remarks"><?= $row->remarks ?></textarea></td>
</tr>
<tr>
<td>Medication</td>
<td colspan="4"><textarea name="medication"><?= $row->medication ?></textarea></td>
</tr>
<tr><td colspan="4"><hr></td></tr>
<tr><td colspan="4"><b><h4>Assessment Result</h4></b></td></tr>
<tr><td colspan="4"><hr></td></tr>
<tr><td colspan="4"><b><h4>Subsidy</h4></b></td></tr>
<tr>
<td>
<?php
$query10 = "Select subsidy_type from subsidy where actived='1' and deleted='0'
and Subsidy_ID IN (Select subsidy_id from student_subsidy where stu_subsidy_id='$linking_id' and actived='1' and deleted='0')";
$result10 = $dbh->query($query10);
if ($result2->rowcount() != 0) {
$result10->setFetchMode(PDO::FETCH_OBJ);
$row10 = $result10->fetch();
if ($row10->subsidy_type == 2) {
?>
<select name="select_subsidy" id="subsidy">
<option value="1">None</option>
<option value="2" selected>Low income family</option>
<option value="3">Family with government subsidy</option>
</select>
<?php
} else {
if ($row10->subsidy_type == 3) {
?>
<select name="select_subsidy" id="subsidy">
<option value="1">None</option>
<option value="2">Low income family</option>
<option value="3" selected>Family with government subsidy</option>
</select>
<?php
}
}
} else {
?>
<select name="select_subsidy" id="subsidy">
<option value="1">None</option>
<option value="2">Low income family</option>
<option value="3">Family with government subsidy</option>
</select>
<?php
}
?>
</td>
<td colspan="3"><input type="text" name="subsidy_pecent" id="subsidy_percent" value="0%" readonly="true"></td>
</tr>
<tr>
<tbody id="subsidy_show"></tbody>
</tr>
</table>
<input type="submit" name="save" class="btn" value="Save">
<div style="display: none;" class="modal fade" id="add_aspect" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4>Addidtional aspects</h4>
</div>
<div class="modal-body">
<table border="0">
<?php
$check = FALSE;
$query3 = "Select aspect_id,aspect_name from additional_aspect";
$result6 = $dbh->query($query3);
$result6->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result6->fetch()) {
$result3 = $dbh->query($query_init3);
$result3->setFetchMode(PDO::FETCH_OBJ); //aspect
print '<tr>';
print '<td>';
while ($row1 = $result3->fetch()) {
if ($row1->aspect_id == $row->aspect_id)
$check = TRUE;
}
if ($check == TRUE) {
print '<input type="checkbox" name="add_aspect[]" value="' . $row->aspect_id . '" checked>' . $row->aspect_name;
print '<input type="hidden" name="add_aspectval[]" value="' . $row->aspect_name . '" >';
} else {
print '<input type="checkbox" name="add_aspect[]" value="' . $row->aspect_id . '">' . $row->aspect_name;
print '<input type="hidden" name="add_aspectval[]" value="' . $row->aspect_name . '" >';
}
print '</td>';
print '</tr>';
$check = FALSE;
}
?>
</table>
</div>
<div class="modal-footer">
<input type="button" name="submit_aspect" class="btn" value="Add" data-dismiss="modal" onclick="Add_aspect();">
</div>
</div>
</div>
</div>
<div style="display: none;" class="modal fade" id="diagnoses" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4>Diagnoses</h4>
</div>
<div class="modal-body">
<table border="0">
<?php
$query3 = "Select diagnose_id,diagnose_name from diagnose";
$result30 = $dbh->query($query3);
$result30->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result30->fetch()) {
$result2 = $dbh->query($query_init2);
$result2->setFetchMode(PDO::FETCH_OBJ); //diagnose
print '<tr>';
print '<td>';
while ($row_init2 = $result2->fetch()) {
if ($row_init2->diagnose_id == $row->diagnose_id) {
$check = TRUE;
}
}
if ($check == TRUE) {
print '<input type="checkbox" name="diagnose[]" value="' . $row->diagnose_id . '" checked>' . $row->diagnose_name;
print '<input type="hidden" name="diagnoseval[]" value="' . $row->diagnose_name . '" >';
} else {
print '<input type="checkbox" name="diagnose[]" value="' . $row->diagnose_id . '">' . $row->diagnose_name;
print '<input type="hidden" name="diagnoseval[]" value="' . $row->diagnose_name . '" >';
}
print '</td>';
print '</tr>';
$check = FALSE;
}
?>
</table>
</div>
<div class="modal-footer">
<input type="button" name="submit_diagnose" class="btn" value="Add" data-dismiss="modal" onclick="Add_Diagnoses();">
</div>
</div>
</div>
</div>
</form>
</div> <!-- /container -->
</body>
</html>