<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Managedepartment extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->model('Common_Model');
if(! $this->session->userdata('elib_adminloggedin')) {
redirect('admin');
}
}
/*
* Function : index
* Desc : listing all records
*/
public function index()
{
$data = array();
$header = array();
$data['schoolArray'] = $this->Common_Model->SqlgetCommonIdArray('su_schools');
$data['recordsArray'] = $recordsArray = $this->Common_Model->SqlgetCommonQuery('su_departments');
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/managedepartment/index',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to manage department module');
}
/*
* Function : adddepartment
* Desc : For particular Record
*/
public function adddepartment($id='')
{
// School Array
$data = array();
$schoolArray = $this->Common_Model->getAllRecords('tbl_schools','id, school_name, school_code');
if($_POST){
$this->form_validation->set_rules('school_id','School Name','required');
$this->form_validation->set_rules('name','Department Name','required');
$this->form_validation->set_rules('status','Status','required');
if($this->form_validation->run())
{
$school_id = $this->input->post('school_id');
$name = $this->input->post('name');
$status = $this->input->post('status');
$data=array(
'school_id'=>$school_id,
'name'=>$name,
'status'=>$status,
'is_deleted'=>'0',
);
if($this->input->post('id')){
$data['modifiedon'] = date('Y-m-d H:i:s');
$id = $this->input->post('id');
$this->Common_Model->updateinfo($tbl_name='tbl_departments',$data,'id',$id);
setHistory('Department Info Updated successfully');
} else {
$data['createdon'] = date('Y-m-d H:i:s');
$this->Common_Model->saveinfo($tbl_name='tbl_departments',$data);
setHistory('Department Info Added successfully');
}
redirect('admin/managedepartment');
} else {
$this->load->view('admin/managedepartment/addrecord');
setHistory('Error! Add/Edit Department');
}
} else {
$sdetail=$this->Common_Model->getSingleRecord('tbl_departments',' * ', array('id'=>$id));
$data['sd'] =$sdetail;
$data['schoolArray'] = $schoolArray;
$this->load->view('admin/_parts/header',$data);
$this->load->view('admin/managedepartment/addrecord',$data);
$this->load->view('admin/_parts/footer');
setHistory('Go to Add/Edit Department module');
}
}
/*
* Function : deletedepartment
* Desc : For records deletion
*/
public function deletedepartment($uid)
{
$this->Common_Model->deleterecords('tbl_departments',$uid);
$this->session->set_flashdata('success', 'Data deleted');
setHistory('Department record deleted successfully');
redirect('admin/managedepartment');
}
}