?>
"/>
<?php
echo $stu->stu_matric_no;
?>
</td>
<td width="100" align="center">
<?php
echo $stu->stu_current_sem;
?>
</td>
<td>
<?php
echo strcap($stu->cou_name);
?>
</td>
<td align="center" width="200" class="class_name">
<?php
echo $stu->class_name;
?>
</td>
<td align="right">
<select width="150" id="group" name="group[]" class="group">
<option value="-1">--Sila Pilih--</option>
<?php
foreach ($max as $row) {
?>
<tr>
<td height="35"><div align="right">Kursus</div></td>
<td height="35"><div align="center">:</div></td>
<td width="52%" height="35">
<div align="left" id="divKursus">
<select id="slct_kursus" name="slct_kursus" style="width:270px;" class="validate[required]" disabled="true">
<option value="">-- Sila Pilih --</option>
<!-- <?php
foreach ($courses as $row) {
?>
<option value="<?php
echo $row->cou_id;
?>
">
<?php
echo ucwords($row->cou_course_code) . ' - ' . strcap($row->cou_name);
?>
</option>
<?php
}
?>
-->
</select>
</div>
</td>
</tr>
<tr>
<td width="45%" height="35"><div align="right">Semester</div></td>
<td width="3%" height="35"><div align="center">:</div></td>
<td width="52%" height="35"><div align="left"><select width="50%" style="width:270px;" name="semester" id="semester" class="validate[required]" >
<option value="">-- Sila Pilih --</option>
function ajax_student_pindah_response()
{
$user_login = $this->ion_auth->user()->row();
$colid = $user_login->col_id;
$sSearch['sNama'] = $this->input->post('nama');
$sSearch['sAngkaGiliran'] = $this->input->post('angka_giliran');
$sSearch['sMykad'] = $this->input->post('mykad');
$sSearch['sSem'] = $this->input->post('sem');
$aoData['iDisplayStart'] = $this->input->post('iDisplayStart');
$aoData['iDisplayLength'] = $this->input->post('iDisplayLength');
$aoData['iSortCol_0'] = $this->input->post('iSortCol_0');
$aoData['iSortingCols'] = $this->input->post('iSortingCols');
$aoData['sSearch'] = $this->input->post('sSearch');
$aoData['sEcho'] = $this->input->post('sEcho');
$result1 = $this->m_student_management->transfer_list($colid, $aoData, $sSearch);
$iTotal = $result1['query']->num_rows();
$arr = array('sEcho' => $aoData['sEcho'], 'iTotalRecords' => $iTotal, 'iTotalDisplayRecords' => $result1['iFilteredTotal']);
if ($iTotal > 0) {
foreach ($result1['query']->result() as $key) {
$arr['aaData'][] = array(strcap($key->stu_name), $key->stu_mykad, $key->stu_matric_no, "<center>" . $key->stu_current_sem . "</center>", "<center><a class='btn btn-info btn-small' href='" . site_url('student/student_management/display_pindah/' . $key->stu_id) . "'>Pindah</a></center>");
}
} else {
$arr['aaData'] = array();
}
echo json_encode($arr);
}
foreach ($kv_list as $row) {
$option[$row->col_id] = $row->col_name;
$i++;
}
for ($i = 1; $i <= 10; $i++) {
$semester[$i] = $i;
}
$status[0] = "Berhenti";
$status[1] = "Aktif";
$tmpl = array('table_open' => '
<table id="table_id" class="display">
');
$this->table->set_template($tmpl);
$this->table->set_heading('Bil', 'Nama Murid', 'No MyKad', 'Angka Giliran', 'Kursus', 'Jantina', 'Bangsa', 'Agama', 'Tindakan');
foreach ($query as $item) {
$this->table->add_row('', strcap($item['stu_name']), $item['stu_mykad'], strtoupper($item['stu_matric_no']), strcap($item['cou_name']), strcap($item['stu_gender']), strcap($item['stu_race']), strcap($item['stu_religion']), '<a href="' . site_url() . '/student/student_management/display_update_student/' . $item['stu_id'] . '"><i class="icon-edit"></i></a>');
}
echo $table = $this->table->generate();
?>
<!--END Generate Datatable-->
<!-- Modal -->
<?php
$att = 'required="true"';
$att_ajax = 'required="true" id="kv"';
?>
<div id="myModalAddStudent" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">
x
</button>
if ($modul->schedule_time_end < 1900) {
echo " petang";
} else {
echo " malam";
}
}
}
}
?>
</td>
<td style="border-left: none;border-top: none;font-size:8pt;padding-left:2pt;">
<?php
echo $modul->mod_paper;
?>
- <?php
echo strcap($modul->mod_name);
?>
</td>
</tr>
<?php
}
} else {
?>
<tr>
<td colspan="3" style="border-top: none;font-size:8pt;" align="center">Tiada Jadual</td>
</tr>
<?php
}
?>
<!--<tr rowspan="2">
?>
<tr>
<td width="10" align="center">
<?php
echo $i;
?>
</td>
<td width="300">
<input type="hidden" name="exam_id[]" id="exam_id" value="<?php
echo $det->exam_id;
?>
"/>
<?php
echo strcap($det->user_name);
?>
</td>
<td width="100">
<input type="hidden" name="exam_id[]" id="exam_id" value="<?php
echo $det->exam_id;
?>
"/>
<?php
echo $det->col_name;
?>
</td>
</tr>
function get_subject_lecturer_by_paging($col_id = "")
{
$arr_d = array();
$sOrder = "";
$ar_search['c.cou_id'] = $_POST['course'];
$ar_search['m.mod_id'] = $_POST['subject'];
$ar_search['u.user_name'] = $_POST['lecturer'];
$ar_search['la.la_current_semester'] = $_POST['semester'];
$ar_search['la.la_status'] = $_POST['status'];
$ar_search['la.la_current_year'] = $this->session->userdata('tahun');
$ar_search['la.la_current_session'] = $this->session->userdata('sesi');
//$ar_search['la.la_group'] =$_POST['group'];
/* Ordering */
if (isset($_POST['iSortCol_0'])) {
$sOrsder = "ORDER BY ";
for ($i = 0; $i < $_POST['iSortingCols']; $i++) {
$this->db->order_by($this->fnColumnToField($_POST['iSortCol_' . $i]), $_POST['sSortDir_' . $i]);
}
}
$sWhere = "";
if (isset($_POST['sSearch']) && $_POST['sSearch'] != "") {
$this->db->where("(u.user_name LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%'\n OR m.mod_name LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%'\n OR la.la_current_year LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%'\n OR cm.cm_semester LIKE '%" . mysql_real_escape_string($_POST['sSearch']) . "%' )");
}
$this->db->select('*');
$this->db->from('lecturer_assign la');
$this->db->join('user u', 'la.user_id = u.user_id', 'left');
$this->db->join('course_module cm', 'cm.cm_id = la.cm_id', 'left');
$this->db->join('course c', 'cm.cou_id = c.cou_id', 'left');
$this->db->join('module m', 'cm.mod_id = m.mod_id', 'left');
$this->db->join('class cl', 'la.la_group = cl.class_id', 'left');
// $this->db->where('cl.class_status', 1);
$this->db->where('u.col_id', $col_id);
if (sizeof($ar_search) > 0) {
foreach ($ar_search as $p_name => $p_value) {
if ($p_name == "u.user_name") {
$this->db->like($p_name, $p_value, 'both');
} else {
if ($p_value != '') {
$this->db->where($p_name, $p_value);
}
}
}
}
$this->db->order_by("cm.cm_id", "DESC");
$this->db->group_by("la.la_id");
$rResult1 = $this->db->get();
$iFilteredTotal = $rResult1->num_rows();
$db_query = $this->db->last_query();
/* Paging */
$sLimit = "";
if (isset($_POST['iDisplayStart']) && $_POST['iDisplayLength'] != '-1') {
$db_query .= " LIMIT " . mysql_real_escape_string($_POST['iDisplayStart']) . ', ' . mysql_real_escape_string($_POST['iDisplayLength']);
$bil = $_POST['iDisplayStart'];
} else {
$bil = 0;
}
$rResult = $this->db->query($db_query);
$aResultTotal = $rResult->num_rows();
$iTotal = $rResult->num_rows();
$num = 0;
if (isset($_POST['sEcho'])) {
$arr_d['sEcho'] = intval($_POST['sEcho']);
}
$arr_d['iTotalRecords'] = $iTotal;
$arr_d['iTotalDisplayRecords'] = $iFilteredTotal;
if (!empty($iTotal)) {
foreach ($rResult->result() as $st) {
//$nama = $st->first_name. " " .$st->last_name;
$bil++;
$arr_d["aaData"][] = array("<span>" . strcap($st->user_name) . "</span>", "<span>" . strcap($st->mod_name) . "</span>", "<span>" . strcap($st->cou_name) . "</span>", "<center><span>" . $st->la_current_year . "</span></center>", "<center><span>" . $st->cm_semester . "</span></center>", "<span>" . strtoupper($st->class_name) . "</span>", $st->la_status == 1 ? "<span>Biasa</span>" : "<span>Mengulang</span>");
}
} else {
$arr_d["aaData"] = array();
}
return $arr_d;
}
echo $i;
?>
</td>
<td width="400">
<?php
echo $rows->cou_course_code;
?>
- <?php
echo strcap($rows->cou_name);
?>
</td>
<td width="400">
<?php
echo strcap($rows->cou_cluster);
?>
</td>
<td width="100" align="center">
<center>
<button name="btn_padam" id="btn_padam" class="btn btn_padam" type="button" value="<?php
echo $rows->cc_id;
?>
"><i class="icon-trash"></i> Padam</button>
</center>
</td>
</tr>
<?php
function ajax_student_autosuggest($colid = null)
{
$term = $this->input->get('term');
// $colid=$this->input->get('colid');
$this->db->select('*');
$this->db->from('student');
$this->db->like('stu_name', $term);
$this->db->join('college_course', 'college_course.cc_id=student.cc_id');
if ($colid != null) {
$this->db->where('college_course.col_id', $colid);
}
$this->db->limit(10);
$result = $this->db->get()->result();
$respond = array();
foreach ($result as $key) {
$respond[] = strcap($key->stu_name);
}
echo json_encode($respond);
}
"/>
<?php
//count module_course
$count = 0;
foreach ($course_module as $mod) {
if (!in_array($mod->mod_id, $arr_mod)) {
$count++;
}
}
foreach ($course_module as $mod) {
if (!in_array($mod->mod_id, $arr_mod)) {
$m_data = 1;
echo "<tr>";
echo "<td><center>{$mod->mod_paper}</center></td>";
echo "<td>" . strcap($mod->mod_name) . "</td>";
echo "<td><center>{$mod->mod_credit_hour}</center></td>";
echo "<td><center>{$mod->mod_sem}</center></td>";
echo "<td><center><input class='validate[minCheckbox[{$count}]] checkbox' id='module' type='checkbox' name='module[]' value='{$mod->mod_id}'></center></td>";
echo "</tr>";
}
}
if (!isset($m_data)) {
echo "<tr>";
echo "<td colspan='5'>";
echo "<i><span style='color:red'/>Tiada Maklumat</span></i>";
echo "</td></tr>";
}
echo "</table>";
if (isset($m_data)) {
echo "<input class='btn btn-info' type='button' id='btn_reg_module' name='btn_reg_module' style='width:10%' value='Daftar'>";
$tr = '';
}
$mod_ids = explode(',', $row->mod_ids);
?>
<tr <?php
echo $tr;
?>
height="26px" class="tables">
<td class="dep" align="center" style="border-right:none;border-top:none;"><?php
echo $bil;
?>
</td>
<td class="dep" style="border-top:none;">
<?php
echo strcap($row->stu_name);
?>
</td>
<td class="dep" align="center" style="border-top:none;border-left:none">
<?php
echo $row->stu_matric_no;
?>
</td>
<!--<td class="dep" style="border-top:none;">-->
<!--<table width="100%" height="30px" cellpadding=0 cellspacing=0 class="tables2">
<tr rowspan="3">
<?php
$co = 0;
foreach ($kod_subjek as $key => $rows) {
$avData = array();
if ($type[$key] == "AK") {
">
</td>
<td width="300">
<input type="hidden" name="cou_id_<?php
echo $cls->class_id;
?>
" id="cou_id_<?php
echo $cls->class_id;
?>
" value="<?php
echo $cls->cou_id;
?>
"/>
<?php
echo strcap($cls->cou_name);
?>
</td>
<td width="300" align="center">
<span id="sem_<?php
echo $cls->class_id;
?>
"><?php
echo $cls->class_sem;
?>
</span>
</td>
<td width="300" align="center">
<center>
<select id="sub3" name='add_subject[]' class="validate[required] input-xxlarge" style="margin-bottom: 0px;" >
<?php
if (!empty($canrepeat)) {
?>
<option value =''>-- Sila Pilih --</option>
<?php
} else {
?>
<option value =''>Tiada Modul Di tawarkan</option>
<?php
}
?>
<?php
foreach ($canrepeat as $row) {
echo "<option value='" . $row->mod_id . "|" . $row->md_id . "'>" . $row->mod_paper . " - " . strcap($row->mod_name) . "</option>";
}
?>
</select></td>
<td style="vertical-align: middle; text-align: center;">
<?php
echo strtoupper($student[0]->stu_current_sem);
?>
<input type="hidden" name='add_semester[]' id='semester' value="<?php
echo $student[0]->stu_current_sem;
?>
">
</td>
<td style="vertical-align: middle; text-align: center;">
<?php
echo strtoupper($student[0]->stu_current_year);
