<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 dept_status() { $dept = $this->input->get('dept'); $data['record'] = View_employees_list::find('all', array('conditions' => "department_name ='{$dept}'")); $data['pageTitle'] = 'Employees - MSInc.'; $data['content'] = 'employee/dept_status'; $this->load->view($this->master_layout, $data); $this->display_notif(); }
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); }