<h3 class="box-title">Job Titles</h3>
<div class="box-tools pull-right">
<button class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-plus"></i></button>
<button class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
</div><!-- /.box-tools -->
</div><!-- /.box-header -->
<div class="box-body">
<div class="table-responsive">
<table class="table table-hovered table-striped table-bordered">
<thead>
<th class="text-center">ID </th>
<th class="text-center">Name </th>
<th class="text-center">Status </th>
</thead>
<?php
$emp = View_employees_list::find($id);
foreach ($emp as $row) {
?>
<tr>
<th class="text-center"><?php
echo $row->emp_id;
?>
</th>
<td class="text-center"><?php
echo "{$row->first_name} {$row->middle_name} {$row->last_name}";
?>
</td>
<th class="text-center"><?php
echo $row->status;
?>
</th>
public function getPayslipDetails($payslip_id)
{
$query = "SELECT *, DATE_FORMAT(payslip_date, '%b %d, %Y') as payslip_date_format, " . "DATE_FORMAT(start_date, '%b %d, %Y') as start_date_format, DATE_FORMAT(end_date, '%b %d, %Y') as end_date_format " . "FROM tbl_payslip " . "WHERE payslip_id = " . $payslip_id;
$payslip_details = $this->db->query($query);
//$payslip_details = $this->db->get_where('tbl_payslip', array('payslip_id' => $payslip_id));
//$employee = $this->retrieveEmployeeInfo($payslip_details->row('emp_id'));
$employee = View_employees_list::find($payslip_details->row('emp_id'));
$payslip_allowances = $this->db->get_where('view_payslip_allowances', array('payslip_id' => $payslip_id));
$payslip_taxes = $this->db->get_where('view_payslip_taxes', array('payslip_id' => $payslip_id));
$payslip = array('employee' => $employee, 'payslip' => $payslip_details->row(), 'payslip_allowances' => $payslip_allowances->result(), 'payslip_taxes' => $payslip_taxes->result());
return $payslip;
}
public function getEmpInfo()
{
$user = View_users_model::find_by_username($this->input->post('txtUsername'));
return View_employees_list::find($user->employee_id);
}
public function leaves_table()
{
if ($this->input->get('leave_status')) {
Leave_request_model::update_leave();
}
$data['emp'] = View_employees_list::all();
$data['record'] = View_leaves_request::all();
$data['pageTitle'] = 'Leaves - MSInc.';
$data['content'] = 'employee/leaves_table';
$this->load->view($this->master_layout, $data);
$this->display_notif();
}
public function attendance_employee()
{
if ($this->input->post('btnFilter')) {
$post = $this->input->post();
$data['attendance'] = attendance_model::generateAttendanceEmployee($post['cboEmployee'], $post['cboMonth'], $post['cboYear']);
}
if ($this->input->post('btnPrint')) {
$post = $this->input->post();
$attendance = attendance_model::generateAttendanceEmployee($post['cboEmployee'], $post['cboMonth'], $post['cboYear']);
$this->print_attendance_employee($attendance);
}
$data['employees'] = View_employees_list::all();
$data['months'] = $this->generateMonths();
$data['years'] = $this->generateYears();
$data['pageTitle'] = 'Employee Attendance Report - MSInc.';
$data['content'] = 'reports/attendance_employee';
$this->load->view($this->master_layout, $data);
}