1.
function save_book_information()
{
var is_valid=$('#form_book_info').valid();
if(is_valid==true)
{
var filename = "/book_information/save_book_information";
var request = $.ajax({
url : filename,
type : "POST",
data : {
//bookid : $.trim($("#book_id").val()),
isbn : $.trim($("#isbn_num").val()),
category : $.trim($("#book_cat").val()),
booklang : $.trim($("#book_lang").val()),
auth_name : $.trim($("#auther_name").val()),
publisher : $.trim($("#publisher").val()),
published_year : $.trim($("#published_year").val()),
booktitle : $.trim($("#book_title").val()),
rack : $.trim($("#rack_num").val()),
desc : $.trim($("#book_desc").val()),
},
dataType : "html"
});
request.done(function(result){
var output = jQuery.parseJSON(result);
alert(output.msg);
if(output.flag==1)
{
location.reload(true);
}
});
request.fail(function(jqXHR,textStatus){
alert(textStatus);
});
}
}
2.
public function listings($offset=0,$searchexist="0",$userdata=""){
$this->load->library('pagination');
$config['base_url'] = SERVER_URL.'/student_list/listing';
$config['per_page'] = 5;
$config['num_links'] = 2;
$config['full_tag_open'] = '
';
$config['total_rows'] = $this->db->get_where('dkb_students', array('is_active' => 1, 'status' => 1, 'payment_status' => 1, 'academic_year' => $this->loggedyear))->num_rows();
$this->pagination->initialize($config);
$query='SELECT a.class_name, b.section_name, c.* FROM dkb_class a, dkb_section b, dkb_students c WHERE a.id=c.class_id AND b.id=c.section_id AND c.is_active=1 AND c.status=1 AND c.academic_year='.$this->loggedyear.'';
if($searchexist<>"0"){
if(trim($userdata['stud_class'])!="" && trim($userdata['stud_sec'])!="" && trim($userdata['stud_name'])==""){
$query.=' AND c.class_id ="'.$userdata['stud_class'].'" AND c.section_id ="'.$userdata['stud_sec'].'"';
}else if(trim($userdata['stud_class'])!="" && trim($userdata['stud_sec'])!="" && trim($userdata['stud_name'])!=""){
$query.=' AND c.class_id ="'.$userdata['stud_class'].'" AND c.section_id ="'.$userdata['stud_sec'].'" AND c.admission_number ="'.$userdata['stud_name'].'"';
}else if(trim($userdata['stud_class'])=="" && trim($userdata['stud_sec'])=="" && trim($userdata['stud_name'])=="" && $userdata['admn_num']!=""){
$query.=' AND c.admission_number ="'.$userdata['admn_num'].'"';
}else if(trim($userdata['stud_class'])=="" && trim($userdata['stud_sec'])=="" && trim($userdata['stud_name'])=="" && $userdata['fromdate']!="" && $userdata['todate']!=""){
$query.=' AND c.form_fillup_date BETWEEN "'.change_dateformat($userdata['fromdate']).'" AND "'.change_dateformat($userdata['todate']).'"';
}
}
if($this->uri->segment(3) !=''){
$page = ', '.$this->uri->segment(3);
}else{
$page = '';
}
$main_query = $query.=' ORDER BY c.id LIMIT '.$config['per_page'].$page;
$modeldata['listing_data'] = $this->db->query($main_query)->result_array();
return $modeldata;
}
3.
# |
Admission No. |
Student Name |
Class / Section |
Mother Name |
Father Name |
DOB |
Contact |
Sex |
Action |