function index()
{
$this->data['title'] = 'Manage Staffs Evaluation';
$this->data['content'] = 'staffs/staffevaluation/index';
$this->form_validation->set_rules('sta_name', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_staffevaluation->findAllEvaluations(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'staffs/staffevaluation/index', $this->m_staffevaluation->countAllEvaluations(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* List user group
*/
function index()
{
$this->data['title'] = 'Manage Groups';
$this->data['content'] = 'users/groups/index';
$this->form_validation->set_rules('gro_name', '', 'trim');
$this->form_validation->set_rules('gro_status', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_groups->findAllGroups(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'users/groups/index', $this->m_groups->countAllGroups(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* Retrive job type
*
* @author Man Math <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Rooms Job Type';
$this->data['content'] = 'rooms/roomtypes/index';
$this->form_validation->set_rules('rom_typ_name', '', 'trim');
$this->form_validation->set_rules('rom_typ_status', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_roomtypes->findAllRoomtypes(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'rooms/roomtypes/index', $this->m_roomtypes->countAllRoomtypes(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* List classees
*/
function index()
{
$this->data['title'] = 'Manage Class';
$this->data['content'] = 'classes/index';
$this->form_validation->set_rules('cla_name', '', 'trim');
$this->form_validation->set_rules('cla_status', '', 'trim');
$this->form_validation->set_rules('cla_capacity', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_classes->findAllClass(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'classes/classes/index', $this->m_classes->countAllClass(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* Retrive job type
*
* @author Man Math <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Staffs Job Type';
$this->data['content'] = 'staffs/jobtypes/index';
$this->form_validation->set_rules('sta_job_title', '', 'trim');
$this->form_validation->set_rules('sta_job_title_kh', '', 'trim');
$this->form_validation->set_rules('sta_job_status', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_jobtypes->findAllJobtypes(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'staffs/jobtypes/index', $this->m_jobtypes->countAllJobtypes(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* List classees
*/
function index()
{
$this->data['title'] = 'Teacher Record';
$this->data['content'] = 'teacher/index';
$this->data['staff'] = $this->m_teacher->getStaff();
$this->data['class'] = $this->m_global->getDataArray(TABLE_PREFIX . 'classes', 'cla_id', 'cla_name', 'cla_status');
$this->data['subject'] = $this->m_global->getDataArray(TABLE_PREFIX . 'subject', 'sub_id', 'sub_name', 'sub_status');
$this->data['data'] = $this->m_teacher->findAllTeacher(PAGINGATION_PERPAGE, $this->uri->segment(3));
$num = $this->m_teacher->countAllTeacher();
pagination_config(site_url('teacher/index'), $num, PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* List user account
*/
function index()
{
$this->data['title'] = 'Manage User Account';
$this->data['content'] = 'users/accounts/index';
$this->form_validation->set_rules('use_name', '', 'trim');
$this->form_validation->set_rules('use_status', '', 'trim');
$this->form_validation->set_rules('use_email', '', 'trim|valid_email');
$this->form_validation->run();
$this->data['data'] = $this->m_accounts->findAllAccounts(PAGINGATION_PERPAGE, $this->uri->segment(4));
$this->data['groups'] = $this->m_global->getDataArray(TABLE_PREFIX . 'groups', 'gro_id', 'gro_name', 'gro_status');
pagination_config(base_url() . 'users/accounts/index', $this->m_accounts->countAllAccounts(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* Retrive lecture
*
* @author Man Math <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Lecture Account';
$this->data['content'] = 'staffs/lectures/index';
$this->form_validation->set_rules('sta_card_id', '', 'trim');
$this->form_validation->set_rules('sta_name', '', 'trim');
$this->form_validation->set_rules('sta_name_kh', '', 'trim');
$this->form_validation->set_rules('sta_sex', '', 'trim');
$this->form_validation->set_rules('sta_status', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_lectures->findAllLectures(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'staffs/lectures/index', $this->m_lectures->countAllLectures(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
public function listing()
{
$config['base_url'] = base_url() . 'property/listing';
$config['total_rows'] = select('property_mst', false, array('where' => array('is_delete' => '0')), array('count' => TRUE));
$config['per_page'] = 2;
$config['num_links'] = 3;
$config['page_query_string'] = TRUE;
// Set pagination Query String to TRUE
$offset = $this->input->get('per_page');
$config = array_merge($config, pagination_config());
$this->pagination->initialize($config);
$data['all_property'] = select('property_mst', false, array('where' => array('is_delete' => '0')), array('limit' => $config['per_page'], 'offset' => $offset));
$this->template->load('front', 'front/property/listing', $data);
}
/**
* Retrive room
*
* @author Man Math <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Rooms';
$this->data['content'] = 'rooms/rooms/index';
$this->form_validation->set_rules('rom_name', '', 'trim');
$this->form_validation->set_rules('rom_building', '', 'trim');
$this->form_validation->set_rules('rom_floor', '', 'trim');
$this->form_validation->set_rules('tbl_room_type_rom_typ_id', '', 'trim');
$this->form_validation->set_rules('rom_status', '', 'trim');
$this->form_validation->run();
$this->data['data'] = $this->m_rooms->findAllRooms(PAGINGATION_PERPAGE, $this->uri->segment(4));
$this->data['types'] = $this->m_global->getDataArray(TABLE_PREFIX . 'room_type', 'rom_typ_id', 'rom_typ_name', 'rom_typ_status');
pagination_config(base_url() . 'rooms/rooms/index', $this->m_rooms->countAllRooms(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* Retrive staff
*
* @author Man Math <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Staffs Account';
$this->data['content'] = 'staffs/staffs/index';
$this->form_validation->set_rules('sta_card_id', '', 'trim');
$this->form_validation->set_rules('sta_name', '', 'trim');
$this->form_validation->set_rules('sta_name_kh', '', 'trim');
$this->form_validation->set_rules('sta_job_type', '', 'trim');
$this->form_validation->set_rules('sta_status', '', 'trim');
$this->form_validation->run();
$this->data['jobtypes'] = $this->m_global->getDataArray(TABLE_PREFIX . 'staff_job_type', 'sta_job_id', 'sta_job_title', 'sta_job_status');
$this->data['data'] = $this->m_staffs->findAllStaffs(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'staffs/staffs/index', $this->m_staffs->countAllStaffs(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* Students Payment
* @author Vibol YOEUNG <*****@*****.**>
* @access public
* @return void
*/
function index()
{
$this->data['title'] = 'Manage Students Payment';
$this->data['content'] = 'payments/student_payment/index';
$this->form_validation->set_rules('stu_id', '', 'trim');
$this->form_validation->set_rules('stu_name', '', 'trim');
$this->form_validation->set_rules('stu_kh_name', '', 'trim');
$this->form_validation->set_rules('sp_year', '', 'trim');
$this->form_validation->set_rules('sp_status', '', 'trim');
$this->form_validation->set_rules('tbl_generation_gen_id', '', 'trim');
$this->form_validation->run();
// $this->data['academic'] = $this->m_student_payment->findAllAcademic();
$this->data['academic'] = $this->m_global->getDataArray(TABLE_PREFIX . 'generation', 'gen_id', 'gen_title', 'gen_status');
$this->data['studentPayments'] = $this->m_student_payment->findAllStudentPayments(PAGINGATION_PERPAGE, $this->uri->segment(4));
pagination_config(base_url() . 'payments/student_payment/index', $this->m_student_payment->countAll(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* List user group
*/
function index()
{
$this->data['title'] = 'Student Registration List';
$this->data['content'] = 'students/registrations/index';
$this->form_validation->set_rules('gen_id', '', 'trim');
$this->form_validation->set_rules('fac_id', '', 'trim');
$this->form_validation->set_rules('cla_id', '', 'trim');
$this->form_validation->set_rules('maj_id', '', 'trim');
$this->form_validation->set_rules('stucla_degree', '', 'trim');
$this->form_validation->set_rules('stucla_year_study', '', 'trim');
$this->form_validation->set_rules('stu_en_firstname', '', 'trim');
$this->form_validation->set_rules('stu_en_lastname', '', 'trim');
$this->form_validation->run();
$this->data['generation'] = $this->m_global->getDataArray(TABLE_PREFIX . 'generation', 'gen_id', 'gen_title', 'gen_status');
$this->data['arrayClasses'] = $this->m_global->getDataArray(TABLE_PREFIX . 'classes', 'cla_id', 'cla_name', 'cla_status');
$this->data['arrayMajor'] = $this->m_global->getDataArray(TABLE_PREFIX . 'majors', 'maj_id', 'maj_name', 'maj_status');
$this->data['arrayFaculties'] = $this->m_global->getDataArray(TABLE_PREFIX . 'faculties', 'fac_id', 'fac_name', 'fac_status');
$this->data['data'] = $this->m_registrations->findAllRegistrations(PAGINGATION_PERPAGE, $this->uri->segment(4));
$this->data['lastQuery'] = $this->session->userdata('lastQuery');
pagination_config(base_url() . 'students/registrations/index', $this->m_registrations->countAllRegistrations(), PAGINGATION_PERPAGE);
$this->load->view(LAYOUT, $this->data);
}
/**
* name: index
*
* prepares the table with all entries
*
* @param integer $iCurrentPage current paginated page
*
* @author parobri.ch
* @date 20120710
*/
public function index($iCurrentPage = 0)
{
//--------------------------------------//
// Suchformular
//--------------------------------------//
$searchfields = array('medium');
// Suchbegriffe werden in der "searchValid()"-Methode aus dem $_Post gelesen, validiert
// und als String "$valid_searchstr" aufbereitet
// wenn der "$valid_searchstr" nicht leer ist, wird er in die Session geschrieben
$valid_searchstr = $this->Model->searchValid();
if ($valid_searchstr != '') {
$this->session->set_userdata(array('search_' . $this->sTable => $valid_searchstr));
}
$SessSearch = $this->session->userdata('search_' . $this->sTable);
$this->searchData['search'] = $SessSearch;
$wherearr = $this->Model->whereArr($SessSearch, $searchfields);
//--------------------------------------//
// Order Sql definieren
//--------------------------------------//
$sortbyarr = $this->Model->sortby();
$aData['sort'] = $sortbyarr['sort'];
$order = $sortbyarr['order'];
//--------------------------------------//
// Statusänderung in der Tabelle
//--------------------------------------//
$this->Model->status($this->sTable);
//--------------------------------------//
// Pagination < 1 2 3 >
//--------------------------------------//
// Pagination Class wird geladen
$this->load->library('pagination');
// Pagination Url wird definiert
$sPaginationUrl = base_url() . 'redaktion/' . $this->sControllerName . '/index/';
// Anzahl Einträge insgesamt
$iTotalRows = $this->Model->countEntries($this->sTable, $wherearr);
$iAllRows = $this->Model->countEntries($this->sTable);
// Anzahl Einträge pro Seite
$iPerPage = 15;
// Helper wird geladen und Daten der Funktion "pagination_config" übergeben
$this->load->helper('pagination');
$aConfig = pagination_config($sPaginationUrl, $iTotalRows, $iPerPage);
// $aConfig-Daten werden pagination class übergeben
$this->pagination->initialize($aConfig);
// Links < 1 2 3 > werden definiert
$aData['pagination'] = $this->pagination->create_links();
$aData['gesamt'] = $iAllRows;
$aData['current_page'] = $iCurrentPage;
//--------------------------------------//
// weitere Daten, die übergeben werden
//--------------------------------------//
$aData['uri_edit'] = $this->sUriEdit;
// Tabellen Kopf Zeile (Status und Bearbeitung sind fix in der View)
$aData['tablehead'] = array('Medium');
//--------------------------------------//
// alle Daten aus der Datenbank holen und auslesen
//--------------------------------------//
$aData['result'] = $this->Model->getAll($sTable = $this->sTable, $sSpecialSql = '', $sFields = 'medium_id, medium', $aJoinLeft = '', $aWhere = $wherearr, $sGroupBy = '', $sOrder = $order, $iPerPage, $iCurrentPage);
//--------------------------------------//
// Rendern
//--------------------------------------//
parent::__renderAllwithSearch($this->sControllerName, $aData);
}
function resultByFinal()
{
pagination_config(base_url() . 'studets/scores/index', $this->m_scores->countAllScoresByFinal(), PAGINGATION_PERPAGE);
return $this->m_scores->findAllScoresByFinal(PAGINGATION_PERPAGE, $this->uri->segment(4));
}
