function load_fee_form()
{
access_control($this);
# Get the passed details into the url data array if any
$urldata = $this->uri->uri_to_assoc(3, array('m', 'i', 'a'));
# Pick all assigned data
$data = assign_to_data($urldata);
$data['classes'] = $this->classobj->get_classes();
$data['terms'] = $this->terms->get_terms();
#user is editing
if (!empty($data['i'])) {
$classid = decryptValue($data['i']);
$data['feedetails'] = $this->Query_reader->get_row_as_array('search_fees_structure', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $classid));
$data['feedetails']['classes'] = remove_empty_indices(explode('|', $data['feedetails']['classes']));
#Check if the term belongs to the current user's school
if ($data['feedetails']['school'] != $this->myschool['id']) {
$data['feedetails'] = array();
}
#Check if the user is simply viewing
if (!empty($data['a']) && decryptValue($data['a']) == 'view') {
$data['isview'] = "Y";
}
}
$this->load->view('finances/fee_form_view', $data);
}
function get_student_academics($student = 0, $term_id = 0, $year_id = 0)
{
access_control($this);
# $this -> write_xml();
#exit();
# Get the passed details into the url data array if any
$urldata = $this->uri->uri_to_assoc(3, array('m', 'i', 'term'));
# Pick all assigned data
$data = assign_to_data($urldata);
#Get the student's details
$studentid = $student > 0 ? $student : decryptValue($data['i']);
if ($term_id > 0) {
$data['term'] = encryptValue($term_id);
}
$data['studentdetails'] = $this->Query_reader->get_row_as_array('get_students_list', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $studentid));
#Get terms for which the student has been registered
$data['academic_periods'] = $this->db->query("SELECT * FROM terms WHERE id IN (SELECT term FROM register WHERE student=" . $studentid . ") AND isactive='Y' ORDER BY year DESC")->result_array();
$view_to_load = 'students/student_academics_view';
if (!empty($data['term'])) {
$view_to_load = 'students/term_academic_info';
#Get the term details
$termid = decryptValue($data['term']);
$data['termdetails'] = $this->Query_reader->get_row_as_array('search_terms_list', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $termid));
#Check if the student belongs to the current user's school
if ($data['studentdetails']['school'] != $this->schoolinfo['id']) {
$data['studentdetails'] = array();
$studentid = '';
$data['msg'] = 'ERROR: The student data could not be found.';
} else {
#Get subjects the student has registered for in the selected term
$data['registration_data'] = $registration_data = $this->Query_reader->get_row_as_array('search_register', array('limittext' => '', 'searchstring' => 'student=' . $studentid . ' AND term ="' . $termid . '"'));
//Get the applicable exams for selected term
if (!empty($registration_data)) {
$data['exams'] = $this->db->query($this->Query_reader->get_query_by_code('search_exams', array('limittext' => '', 'searchstring' => ' AND classes like "%' . $registration_data['class'] . '%" AND term ="' . $termid . '" AND isactive="Y"')))->result_array();
//get the subject details
$subject_arr = remove_empty_indices(explode('|', $registration_data['subjects']));
#print_r($registration_data);
#exit();
if (!empty($subject_arr)) {
$data['subjects'] = $this->db->query($this->Query_reader->get_query_by_code('search_subjects', array('limittext' => '', 'searchstring' => ' AND id IN (' . implode(',', $subject_arr) . ')', 'isactive' => 'Y')))->result_array();
}
//Get class of registration details
$data['classdetails'] = get_db_object_details($this, 'classes', $registration_data['class']);
}
}
}
# Fetching Calendar Years::
#Get the student's details
$std = decryptValue($data['i']);
$data['std'] = $std;
$this->load->model('calendar_year');
$school_id = $this->schoolinfo['id'];
$year_array = $this->calendar_year->fetch_calendar_year($school_id);
$data['schoolid'] = $this->session->userdata('schoolinfo');
$data['year_calendar'] = $year_array;
$data = add_msg_if_any($this, $data);
// print_r($view_to_load); exit();
# print_r($view_to_load);
$this->load->view($view_to_load, $data);
}
<?php
#$page_list = array();
if (!empty($page_list)) {
echo "<table width='100%' border='0' cellspacing='0' cellpadding='5'>\r\r\n \t<tr>\r\r\n\t\t\t<td class='listheader' width='1%'> </td>\r\r\n \t<td class='listheader' nowrap>Scale <a class='fancybox fancybox.ajax' href='" . base_url() . "grading/load_grading_form')' title='Click to add a grading scale'><img src='" . base_url() . "images/add_item.png' border='0'/></a></td>\r\r\n\t\t\t<td class='listheader' nowrap='nowrap'>Description</td>\r\r\n\t\t\t<td class='listheader' nowrap>Classes</td>\r\r\n\t\t\t<td class='listheader' nowrap>Date Added</td>\r\r\n\t\t\t</tr>";
$counter = 0;
foreach ($page_list as $row) {
#Get applicable classes
$class_str = '';
$classids = explode('|', $row['classes']);
$classids = remove_empty_indices($classids);
#Show in drop down if more than 1 class
if (is_array($classids)) {
if (count($classids) > 1) {
foreach ($classids as $key => $classid) {
$class_str .= '<option>' . get_class_title($this, $classid) . '</option>';
}
$class_str = '<select class="selectfield">' . $class_str . '</select>';
} elseif (count($classids) > 0) {
$class_str = get_class_title($this, end($classids));
}
} else {
$class_str = "N/A";
}
#Show one row at a time
echo "<tr id='tr_" . $row['id'] . "' class='listrow' style='" . get_row_color($counter, 2) . "'>\r\r\n\t\t<td class='leftListCell rightListCell' valign='middle' nowrap>";
#if(check_user_access($this,'delete_deal')){
echo "<a href='javascript:void(0)' onclick=\"asynchDelete('" . base_url() . "grading/delete_grading_scheme/i/" . encryptValue($row['id']) . "', 'Are you sure you want to remove this grading scale? \\nThis operation can not be undone. \\nClick OK to confirm, \\nCancel to cancel this operation and stay on this page.', 'tr_" . $row['id'] . "');\" title=\"Click to remove " . $row['gradingname'] . " from the school exam schedule.\"><img src='" . base_url() . "images/delete.png' border='0'/></a>";
#}
#if(check_user_access($this,'update_deals')){
echo " <a class='fancybox fancybox.ajax' href='" . base_url() . "grading/load_grading_form/i/" . encryptValue($row['id']) . "' title=\"Click to edit " . $row['gradingname'] . " details.\"><img src='" . base_url() . "images/edit.png' border='0'/></a>";
</td>
</tr>
<tr>
<td valign="top" nowrap="nowrap" class="label" style="padding-top:13px">Classes:</td>
<td nowrap class="field">
<?php
if (!empty($isview)) {
echo "<span class='viewtext'>" . $classes . "</span>";
} else {
echo get_required_field_wrap($requiredfields, 'classes');
echo '<table cellpadding="5"><tr>';
$class_ctr = 0;
$selected_classes = array();
if (!empty($formdata['classes'])) {
$selected_classes = remove_empty_indices(explode('|', $formdata['classes']));
}
foreach ($classes as $class) {
$class_ctr++;
echo '<td style="padding-left:0" valign="middle"><input ' . (in_array($class['id'], $selected_classes) ? 'checked="checked"' : '') . ' onchange="update_classes(' . count($classes) . ', \'classes\')" id="class' . $class_ctr . '" type="checkbox" value="' . $class['id'] . '" name="classes[]" /></td><td style="padding-left:0">' . $class['class'] . '</td>';
if ($class_ctr % 3 == 0) {
echo '</tr></tr>';
}
}
if ($class_ctr % 3 > 0) {
echo '<td colspan="' . $class_ctr % 3 . '"> </td>';
}
echo '</tr></table>';
echo get_required_field_wrap($requiredfields, 'classes', 'end');
}
?>
function remove_empty_indices($array_obj)
{
if (is_array($array_obj)) {
foreach ($array_obj as $key => $value) {
if (is_array($value)) {
$array_obj[$key] = remove_empty_indices($value);
} else {
if ($value == '') {
unset($array_obj[$key]);
}
}
}
}
return $array_obj;
}
$term = $terms['term'];
# hear is where every thing happens right 0n ##
# creat report
$report = $xml->createElement("report");
$root->appendChild($report);
# retport id
$reportid = $xml->createElement("reportid");
$report->appendChild($reportid);
$data['registration_data'] = $registration_data = $this->Query_reader->get_row_as_array('search_register', array('limittext' => '', 'searchstring' => 'student=' . $studentid . ' AND term ="' . $termid . '"'));
$termdetails = $this->Query_reader->get_row_as_array('search_terms_list', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $termid));
// Registration
$registration_data = $registration_data = $this->Query_reader->get_row_as_array('search_register', array('limittext' => '', 'searchstring' => 'student=' . $studentid . ' AND term ="' . $termid . '"'));
if (!empty($registration_data)) {
$exams = $this->db->query($this->Query_reader->get_query_by_code('search_exams', array('limittext' => '', 'searchstring' => ' AND classes like "%' . $registration_data['class'] . '%" AND term ="' . $termid . '" AND isactive="Y"')))->result_array();
//get the subject details
$subject_arr = remove_empty_indices(explode('|', $registration_data['subjects']));
#print_r($registration_data);
#exit();
if (!empty($subject_arr)) {
$subjects = $this->db->query($this->Query_reader->get_query_by_code('search_subjects', array('limittext' => '', 'searchstring' => ' AND id IN (' . implode(',', $subject_arr) . ')', 'isactive' => 'Y')))->result_array();
// Class Details
$classdetails = get_db_object_details($this, 'classes', $registration_data['class']);
}
}
#head information ::
#create head element
$head = $xml->createElement("head");
$report->appendChild($head);
# head element children::
$logo1 = $xml->createElement("logo1");
//logourl
function assign_teacher()
{
access_control($this);
# Get the passed details into the url data array if any
$urldata = $this->uri->uri_to_assoc(3, array('m', 'i', 'a', 't'));
# Pick all assigned data
$data = assign_to_data($urldata);
if ($data['save']) {
$data['formdata'] = $data;
$required_fields = array('subject', 'class', 'teacher');
foreach ($data as $key => $data_value) {
$data[$key] = restore_bad_chars($data_value);
}
$_POST = clean_form_data($data);
$validation_results = validate_form('', $_POST, $required_fields);
$feename_error = '';
#Only proceed if the validation for required fields passes
if ($validation_results['bool']) {
if (!empty($data['editid'])) {
// print_r('Entered'); exit();
$result = $this->db->query($this->Query_reader->get_query_by_code('update_subject_teacher', array_merge($_POST, array('id' => $data['editid']))));
} else {
$result = $this->db->query($this->Query_reader->get_query_by_code('assign_subject_teacher', $_POST));
if ($result) {
#Delete previous assignments
# $this->db->delete('subjectteacherassignments', 'class ='.$data['class'].' AND subject='.$data['subject'].' AND teacher !='.$data['teacher'].((!empty($data['paper']))? ' AND paper='.$data['paper'] : ''));
}
}
#Format and send the errors
if (!empty($result) && $result) {
$user_details = get_db_object_details($this, 'schoolusers', $data['teacher']);
$subject_details = get_db_object_details($this, 'subjects', $data['subject']);
$data['msg'] = $user_details['firstname'] . ' ' . $user_details['lastname'] . ' has been successfully assigned as <br />the ' . $subject_details['subject'] . ' teacher for ' . get_class_title($this, $data['class']);
$data['formdata'] = array();
} else {
if (empty($data['msg'])) {
$data['msg'] = "ERROR: The subject-teacher assignment could not be saved or was not saved correctly.";
}
}
}
$data['requiredfields'] = $validation_results['requiredfields'];
}
$subjectid = $data['subject'];
$data['formdata'] = $this->Query_reader->get_row_as_array('search_subjects', array('isactive' => 'Y', 'limittext' => '', 'searchstring' => ' AND id = ' . $subjectid));
$classes_array = explode('|', $data['formdata']['classes']);
$classes_array = remove_empty_indices($classes_array);
$classes_str = implode(',', $classes_array);
$data['classes'] = $this->classobj->get_classes('', ' AND id IN (' . $classes_str . ')');
$data['papers'] = $this->db->query($this->Query_reader->get_query_by_code('search_papers', array('isactive' => 'Y', 'searchstring' => ' AND subject = ' . $subjectid, 'limittext' => '')))->result_array();
$data['staff'] = $this->db->query($this->Query_reader->get_query_by_code('search_school_users', array('limittext' => '', 'searchstring' => ' AND school =' . $this->myschool['id'])))->result_array();
$this->load->view('incl/subject_teacher_form', $data);
}
