function monthly($employee_id = '')
{
$data['page_name'] = '<b>Monthly Payroll</b>';
$data['employee_id'] = $employee_id;
$data['msg'] = '';
if (Input::get('op')) {
}
$e = new Employee_m();
$e->where('office_id', Input::get('office_id') ? Input::get('office_id') : Session::get('office_id'));
$e->where('permanent', 1);
$e->order_by('lname');
$data['employees'] = $e->get();
$data['main_content'] = 'monthly';
return View::make('includes/template', $data);
}
function edit_place($mode = '')
{
if ($mode == 'tax_exempt') {
$e = new Employee_m();
$e->where('id', Input::get('rowid'));
$e->get();
if (Input::get('colid') == 'tax_status') {
$e->tax_status = Input::get('new');
}
if (Input::get('colid') == 'dependents') {
$e->dependents = Input::get('new');
}
$e->save();
exit;
}
}
function reports()
{
$data['page_name'] = '<b>Reports</b>';
$data['pop_up'] = '';
$data['rows'] = array();
$data['records_found'] = '';
if (Input::get('op')) {
$e = new Employee_m();
if (Input::get('lname') != '') {
$e->where('lname', Input::get('lname'));
}
if (Input::get('fname') != '') {
$e->where('fname', Input::get('fname'));
}
if (Input::get('position') != '') {
$e->like('position', Input::get('position'));
}
if (Input::get('permanent') != 'all') {
$e->where('permanent', Input::get('permanent'));
}
if (Input::get('office_id') != '0') {
$e->where('office_id', Input::get('office_id'));
}
if (Input::get('salary_grade') != '') {
list($salary_grade, $step) = explode("-", Input::get('salary_grade'));
$e->where('salary_grade', $salary_grade);
$e->where('step', $step);
}
// =======================================================
if (Input::get('years_service') != '') {
// If blank search for exact year
if (Input::get('years_service_above') == '') {
}
$the_year = date('Y') - Input::get('years_service');
$today = date('Y-m-d');
$e->where('YEAR(first_day_of_service)', $the_year);
$e->where('MONTH(first_day_of_service) >=', date('m'));
}
if (Input::get('eligibility') != '') {
$e->like('eligibility', Input::get('eligibility'), 'both');
}
if (Input::get('course') != '') {
$e->like('course', Input::get('course'), 'both');
}
if (Input::get('sex') != '') {
$e->where('sex', Input::get('sex'));
}
if (Input::get('age') != '') {
$the_year = date('Y') - Input::get('age');
$e->where('YEAR(birth_date)', $the_year);
$e->where('MONTH(birth_date) >=', date('m'));
}
if (Input::get('location') != '') {
$e->like('res_address', Input::get('location'));
}
$e->order_by('lname');
$data['rows'] = $e->get();
$data['records_found'] = $e->result_count();
// if search and print preview
if (Input::get('search_preview')) {
$data['pop_up'] = 1;
$preview = new Search_result_preview();
$data['report_file'] = $preview->preview($data['rows'], Input::get('report_name'));
}
}
$data['options'] = array('position' => 'Position/ Designation', 'department' => 'Office/ Department', 'employment_status' => 'Employment Status');
//Use for office listbox
$data['options'] = $this->options->office_options($add_select = TRUE);
$data['selected'] = Input::get('office_id');
$data['permanent_options'] = $this->options->type_employment($all = TRUE);
$data['permanent_selected'] = Input::get('permanent');
$data['years_service_above_options'] = array('' => '', 'above' => 'above', 'below' => 'below');
$data['years_service_above_selected'] = Input::get('years_service_above');
$data['age_above_options'] = array('' => '', 'above' => 'above', 'below' => 'below');
$data['age_above_selected'] = Input::get('age_above');
$data['main_content'] = 'reports';
return View::make('includes/template', $data);
}
function aso()
{
$e = new Employee_m();
$e->where('id', '25')->get();
echo 'aso';
}
function training_employees()
{
$options = array();
$ci =& get_instance();
$e = new Employee_m();
$e->where('lname !=', '');
$e->where('status', 1);
$e->order_by('lname');
$types = $e->get();
$ci->load->helper('text');
foreach ($types as $type) {
$options[$type->id] = $type->lname . ', ' . $type->fname . ' ' . $type->mname;
}
return $options;
}
function salary_index($employee_id = '')
{
$data['page_name'] = '<b>Employee Salary Index</b>';
$data['employee_id'] = $employee_id;
$data['msg'] = '';
if (Input::get('op')) {
}
$e = new Employee_m();
$e->where('permanent', 1);
$e->where('id', 171);
$e->order_by('lname');
$data['employees'] = $e->get();
$data['main_content'] = 'report/salary_index';
return View::make('includes/template', $data);
}
/**
* Enter description here...
*
*/
function add_employee()
{
$data['page_name'] = '<b>Add employee</b>';
$data['msg'] = '';
//Office
$data['options'] = $this->options->office_options();
$data['selected'] = Session::get('office_id');
// Divisions options
$data['division_options'] = $this->options->division_options(Session::get('office_id'));
//Detailed office
$detailed_options = $this->options->office_options($add_select = TRUE);
$data['detailed_options'] = $detailed_options;
$data['detailed_selected'] = '';
//Type of employment
$data['permanent_options'] = $this->options->type_employment();
$data['permanent_selected'] = '';
//Salary grade options
$data['sg_options'] = $this->options->salary_grade();
$data['sg_selected'] = '';
//Step increment
$data['step_options'] = $this->options->step();
$data['step_selected'] = '';
//Shift List
$data['shifts_options'] = $this->options->shift();
// Lets check if the auto generate employee
// number is enabled
$data['employee_id_readonly'] = '';
$data['auto_generate_employee_id'] = 'no';
$auto_generate_employee_id = Setting::getField('auto_generate_employee_id');
$data['auto_employee_id'] = '';
if ($auto_generate_employee_id == 'yes') {
$data['employee_id_readonly'] = 'readonly';
$data['auto_generate_employee_id'] = 'yes';
// Lets get the maximum employee_id
$e = new Employee_m();
$e->where('office_id', Session::get('office_id'));
$e->select_max('employee_id');
$e->get();
//$data['auto_employee_id'] = $e->employee_id + 1;
//echo $this->db->last_query();
}
//If form submit
if (Input::get('op')) {
$this->form_validation->set_rules('employee_id', 'Employee ID', 'required|callback_employee_id_check');
$this->form_validation->set_rules('salutation', 'Salutation', 'required');
$this->form_validation->set_rules('lname', 'Last Name', 'required');
$this->form_validation->set_rules('fname', 'First Name', 'required');
$this->form_validation->set_rules('extension', 'First Name', '');
$this->form_validation->set_rules('position', 'Position', 'required');
$this->form_validation->set_rules('permanent', 'Type of employment', 'required');
//$this->form_validation->set_rules('password', 'Password', 'required|matches[repassword]');
if ($this->form_validation->run($this) == FALSE) {
$data['selected'] = Input::get('office_id');
$data['detailed_selected'] = Input::get('detailed_office_id');
$data['permanent_selected'] = Input::get('permanent');
$data['sg_selected'] = Input::get('sg');
$data['step_selected'] = Input::get('step');
} else {
$shift_id = Input::get('shift2');
$shift_type = Input::get('shift2');
//File name of the photo
$file_register = Session::get('file_register');
$finger_pics = '/../' . current_work_dir() . '/pics/' . Session::get('file_register');
$info = array('employee_id' => Input::get('employee_id'), 'lname' => Input::get('lname'), 'fname' => Input::get('fname'), 'mname' => Input::get('mname'), 'extension' => Input::get('extension'), 'position' => Input::get('position'), 'assistant_dept_head' => Input::get('assistant_dept_head'), 'office_id' => Input::get('office_id'), 'division_id' => Input::get('division_id'), 'section_id' => Input::get('section_id'), 'detailed_office_id' => Input::get('detailed_office_id'), 'salut' => Input::get('salutation'), 'pics' => $file_register, 'finger_pics' => $finger_pics, 'shift_id' => $shift_id, 'shift_type' => $shift_type, 'status' => 1, 'permanent' => Input::get('permanent'), 'first_day_of_service' => Input::get('first_day_of_service'), 'salary_grade' => Input::get('sg'), 'step' => Input::get('step'), 'newly_added' => 1, 'updated' => 1, 'emergency_contact' => Input::get('emergency_contact'), 'emergency_contact_no' => Input::get('emergency_contact_no'));
$id = $this->Employee->add_employee($info);
$this->Logs->insert_logs('employees', 'ADD EMPLOYEE', 'Add new employee (' . $id . ')', $id);
// Use for messaging
Session::flash('msg', 'New Employee added!');
if ($this->config->item('active_apps') == 'hris') {
// Add to personal info
$p = new Personal_m();
$p->get_by_employee_id($id);
$p->employee_id = $id;
$p->lname = Input::get('lname');
$p->fname = Input::get('fname');
$p->mname = Input::get('mname');
$p->save();
// Redirect to pds page
//return Redirect::to('pds/employee_profile/'.$id, 'refresh');
}
// Redirect to adding new employee form
return Redirect::to('employees/add_employee', 'refresh');
}
}
$data['main_content'] = 'add_employee';
return View::make('includes/template', $data);
}
function delete_office($office_id = '')
{
// Lets check if the office have associated employee
$e = new Employee_m();
$e->where('office_id', $office_id);
$e->get();
// If exists
if ($e->exists()) {
Session::flash('error_msg', 'Unable to delete office.
Please delete all employee associated with the office.');
return Redirect::to('office_manage/view_offices', 'refresh');
}
$this->Office->delete_office($office_id);
// Delete the associated division
$d = new Division();
$d->where('office_id', $office_id)->get();
$d->delete_all();
Session::flash('msg', 'Office deleted!');
return Redirect::to('office_manage/view_offices', 'refresh');
}
function staff_entitlement($employee_id = '')
{
$this->load->helper('payroll_options');
$data['page_name'] = '<b>Staff Entitlement</b>';
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['selected'] = Session::get('office_id');
$data['additional_compensation_id'] = Input::get('additional_compensation_id') ? Input::get('additional_compensation_id') : 1;
$data['msg'] = '';
$office_id = Session::get('office_id');
if (Input::get('op')) {
$data['employee_id'] = Input::get('employee_id');
$data['selected'] = Input::get('office_id');
}
if (Input::get('office_id')) {
$office_id = Input::get('office_id');
}
$e = new Employee_m();
$e->order_by('lname');
$e->where('office_id', $office_id);
$data['rows'] = $e->get();
$data['main_content'] = 'adcom/staff/staff_entitlement';
return View::make('includes/template', $data);
}
