function up()
{
// Do only if Province of Laguna
$lgu_code = Setting::getField('lgu_code');
if ($lgu_code == 'laguna_province') {
$o = new Office_m();
$offices = $o->get();
foreach ($offices as $office) {
// Select all employees by office
$e = new Employee_m();
$employees = $e->get_by_office_id($office->office_id);
$office_id = sprintf("%03d", $office->office_id);
// Add leading zeros
$i = 1;
foreach ($employees as $employee) {
// Lets update the employee id
$employee_id = sprintf("%03d", $i);
// Add leading zeros
$update_employee = new Employee_m();
$update_employee->get_by_id($employee->id);
$update_employee->employee_id = $office_id . $employee_id;
$update_employee->save();
$i++;
}
}
}
}
function up()
{
$lgu_code = Setting::getField('lgu_code');
if ($lgu_code == '') {
if ($this->db->table_exists('pds_profile')) {
$this->db->order_by('id');
$q = $this->db->get('pds_profile');
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $row) {
$p = new Employee_m();
$p->get_by_id($row['employee_id']);
$p->item_number = $row['item_number'];
$p->last_promotion = $row['last_promotion'];
$p->level = $row['level'];
$p->eligibility = $row['eligibility'];
$p->graduated = $row['graduated'];
$p->course = $row['course'];
$p->units = $row['units'];
$p->post_grad = $row['post_grad'];
$p->save();
}
}
}
}
}
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 up()
{
if ($this->db->table_exists('pds_personal_info')) {
$q = $this->db->get('pds_personal_info');
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $row) {
$e = new Employee_m();
$e->get_by_id($row['employee_id']);
$e->birth_date = $row['birth_date'];
$e->sex = $row['sex'];
$e->save();
}
}
}
}
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 employees($office_id = '', $employee_id = '')
{
$e = new Employee_m();
$e->order_by('lname');
$employees = $e->get_by_office_id($office_id);
$json = array();
foreach ($employees as $employee) {
// If employee is not blank we will
// going to use the 'employee_id' field as index
// not the 'id' field
if ($employee_id != '') {
$json[$employee->employee_id] = $employee->lname . ', ' . $employee->fname;
} else {
$json[$employee->id] = $employee->lname . ', ' . $employee->fname;
}
}
echo json_encode($json);
}
function up()
{
if ($this->db->table_exists('training_attendees')) {
$q = $this->db->get('training_attendees');
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $row) {
$e = new Employee_m();
$e->get_by_id($row['employee_id']);
if (!$e->exists()) {
$this->db->where('id', $row['id']);
$this->db->delete('training_attendees');
//echo $this->db->last_query().'<br>';
}
}
}
$this->db->where('event_id', 0);
$this->db->delete('training_attendees');
}
}
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 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 front_id($results)
{
$this->load->helper('settings');
//print preview of MR
$this->load->library('fpdf');
$this->load->library('fpdi');
// initiate FPDI
$pdf = new FPDI('L');
// add a page
$pdf->AddPage();
// set the sourcefile
$pagecount = $pdf->setSourceFile('pdf-report/id/front-id.pdf');
// import page 1
$tplIdx = $pdf->importPage(1);
// use the imported page and place it at point 10,10 with a width of 100 mm
$pdf->useTemplate($tplIdx);
//367
// now write some text above the imported page
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', '', 9);
$n = 1;
foreach ($results as $result) {
$s = new Employee_m();
$row = $s->get_by_id($result->employee_id);
if ($n == 11) {
//add new page
$pdf->addPage();
for ($n = 1; $n <= 1; $n++) {
$tplidx = $pdf->ImportPage(1);
$pdf->useTemplate($tplIdx);
//, 1, 1, 210
}
$n = $n - 1;
}
//======================== START Column 1 ==============================
$pic = 'pics/not_available.png';
$photo = 'pics/' . $row->employee_id . '.png';
if (file_exists($photo)) {
$pic = 'pics/' . $row->employee_id . '.png';
}
//signature
$sign = 'pics/signatures/' . $row->employee_id . '.png';
$employee_id = $row->employee_id;
$name = utf8_decode($row->fname . ' ' . $row->lname);
$lblname = 'NAME';
$office = 'LAGUNA UNIVERSITY';
$position = $row->position;
$fs = '11.5';
if (strlen($name) >= 22) {
$fs = '9';
}
//----------------------------- Row 1 ----------------------------------
if ($n == 1) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(18.5, 29);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 17.5, 31, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(18.5, 71);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(18.5, 74);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 20, 75, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(18.5, 83);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(18.5, 88);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(18.5, 94);
$pdf->Cell(30, 0, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 2 ----------------------------------
if ($n == 2) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(76.5, 29);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 75.5, 31, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(76.5, 71);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(76.5, 74);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 78, 75, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(76.5, 83);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(76.5, 88);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(76.5, 94);
$pdf->Cell(30, 0, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 3 ----------------------------------
if ($n == 3) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(134.5, 29);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 133.5, 31, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(134.5, 71);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(134.5, 74);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 136, 75, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(134.5, 83);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(134.5, 88);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(134.5, 94);
$pdf->Cell(30, 0, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 4 ----------------------------------
if ($n == 4) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(192.5, 29);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 191.5, 31, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(192.5, 71);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(192.5, 74);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 194, 75, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(192.5, 83);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(192.5, 88);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(192.5, 94);
$pdf->Cell(30, 0, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 5 ----------------------------------
if ($n == 5) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(250.5, 29);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 249.5, 31, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(250.5, 71);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(250.5, 74);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 252, 75, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(250.5, 83);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(250.5, 88);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(250.5, 94);
$pdf->Cell(30, 0, strtoupper($position), '0', 0, 'C', false);
}
//======================== END Column 1 ==============================
//======================== START Column 1 ==============================
//----------------------------- Row 2 ----------------------------------
if ($n == 6) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(18.5, 129);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 17.5, 132, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(18.5, 172);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(18.5, 175);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 20, 176, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(18.5, 184);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(18.5, 188.5);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(18.5, 200);
$pdf->Cell(30, -11, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 2 ----------------------------------
if ($n == 7) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(76.5, 129);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 75.5, 132, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(76.5, 172);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(76.5, 175);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 78, 176, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(76.5, 184);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(76.5, 188.5);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(76.5, 200);
$pdf->Cell(30, -11, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 3 ----------------------------------
if ($n == 8) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(134.5, 129);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 133.5, 132, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(134.5, 172);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(134.5, 175);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 136, 176, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(134.5, 184);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(134.5, 188.5);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(134.5, 200);
$pdf->Cell(30, -11, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 4 ----------------------------------
if ($n == 9) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(192.5, 129);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 191.5, 132, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(192.5, 172);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(192.5, 175);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 194, 176, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(192.5, 184);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(192.5, 188.5);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(192.5, 200);
$pdf->Cell(30, -11, strtoupper($position), '0', 0, 'C', false);
}
//----------------------------- Row 5 ----------------------------------
if ($n == 10) {
//Employee number
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetXY(250.5, 129);
$pdf->Cell(30, 0, 'EMP No. ' . $employee_id, '0', 0, 'C', false);
//Employee Photo 2x3
$pdf->image($pic, 249.5, 132, 32, 37);
//x, y, w, h
//Employee name
$pdf->SetFont('Arial', 'B', $fs);
$pdf->SetXY(250.5, 172);
$pdf->Cell(30, 0, strtoupper($name), '0', 0, 'C', false);
//label name
$pdf->SetFont('Arial', '', 5);
$pdf->SetXY(250.5, 175);
$pdf->Cell(30, 0, $lblname, '0', 0, 'C', false);
//Signature
if (file_exists($sign)) {
$pdf->image($sign, 252, 176, 25, 10);
//x, y, w, h
}
//label signature
$pdf->SetXY(250.5, 184);
$pdf->Cell(30, 0, 'SIGNATURE', '0', 0, 'C', false);
//Office
$pdf->SetTextColor(255, 255, 255);
//r, g ,b
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetXY(250.5, 188.5);
$pdf->Cell(30, 0, $office, '0', 0, 'C', false);
//Position
$pdf->SetTextColor(255, 255, 0);
$pdf->SetFont('Arial', '', 10);
$pdf->SetXY(250.5, 200);
$pdf->Cell(30, -11, strtoupper($position), '0', 0, 'C', false);
}
$n++;
//======================== END Column 2 ==============================
}
// Output
$pdf->Output('pdf-report/front-id.pdf', 'F');
return 'pdf-report/front-id.pdf';
}
function employees($employee_id = '')
{
$data['page_name'] = '<b>Employee\'s Training Record</b>';
$data['focus_field'] = 'tra_name';
$data['msg'] = '';
$employee_id = Input::get('employee_id');
$e = new Employee_m();
$data['employee'] = $e->get_by_id(Input::get('employee_id'));
$data['pics'] = file_exists('pics/' . $e->pics) ? $e->pics : 'not_available.jpg';
$image_properties = array('src' => base_url() . 'pics/' . $data['pics'], 'width' => '140', 'height' => '140');
$data['pics'] = $image_properties;
$em = new Employee_movement_m();
$em->get_by_id($e->employee_movement_id);
$data['employment_movement'] = $em->employee_movement;
if (Input::get('op')) {
// TRAINING PROGRAMS=========================
$tra_name = Input::get('tra_name');
$tra_date_from = Input::get('tra_date_from');
$tra_date_to = Input::get('tra_date_to');
$tra_hours = Input::get('tra_hours');
$tra_conduct = Input::get('tra_conduct');
$tra_location = Input::get('tra_location');
$t = new Training();
$t->get_by_employee_id($employee_id);
$t->delete_all();
$i = 0;
foreach ($tra_name as $tra) {
if ($tra != "") {
$t = new Training();
$t->employee_id = $employee_id;
$t->name = $tra_name[$i];
$t->date_from = $tra_date_from[$i];
$t->date_to = $tra_date_to[$i];
$t->number_hours = $tra_hours[$i];
$t->conducted_by = $tra_conduct[$i];
$t->location = $tra_location[$i];
$t->save();
}
$i++;
}
$data['msg'] = 'Trainings has been saved!';
}
// Recommended trainings
if (Input::get('op2')) {
$recommends = Input::get('recommend_id');
$reco_year = Input::get('reco_year');
$course_id = Input::get('course_id');
$relevant = Input::get('relevant');
$reco_remarks = Input::get('reco_remarks');
$i = 0;
foreach ($recommends as $r_id) {
if ($reco_year[$i] != '') {
$t = new Training_recomended_m();
$t->where('course_id', $course_id[$i]);
$t->where('reco_year', $reco_year[$i]);
$t->where('employee_id', $employee_id);
$t->get();
$t->employee_id = $employee_id;
$t->reco_year = $reco_year[$i];
$t->course_id = $course_id[$i];
$t->relevant = $relevant[$i];
$t->reco_remarks = $reco_remarks[$i];
$t->save();
}
$i++;
}
// Remove checked
if (Input::get('remove')) {
foreach (Input::get('remove') as $recommended_id) {
$t = new Training_recomended_m();
$t->get_by_id($recommended_id);
$t->delete();
}
}
}
// Actual duties
if (Input::get('op3')) {
$duties_ids = Input::get('duties_id');
$duty_from = Input::get('duty_from');
$duty_to = Input::get('duty_to');
$duty_desc = Input::get('duty_desc');
$i = 0;
foreach ($duties_ids as $r_id) {
if ($duty_from[$i] != '') {
$ed = new Employee_duty_m();
$ed->get_by_id($r_id);
$ed->employee_id = $employee_id;
$ed->duty_from = $duty_from[$i];
$ed->duty_to = $duty_to[$i];
$ed->duty_desc = $duty_desc[$i];
$ed->save();
}
$i++;
}
}
// Training===========================================================
$t = new Training();
$t->order_by('date_from', 'DESC');
$data['trains'] = $t->get_by_employee_id($employee_id);
$data['tra_location_options'] = array('local' => 'Local', 'regional' => 'Regional', 'national' => 'National', 'international' => 'International');
if ($employee_id == '') {
$data['trains'] = array();
}
// Recommended Trainings
$t = new Training_recomended_m();
$t->order_by('reco_year');
$data['recommends'] = $t->get_by_employee_id($employee_id);
// Actual Duties
$ed = new Employee_duty_m();
$ed->order_by('duty_from');
$data['duties'] = $ed->get_by_employee_id($employee_id);
$data['selected'] = $e->office_id;
//Use for office listbox
$data['options'] = $this->options->office_options();
// Courses
$t = new Training_course();
$data['courses'] = $t->courses();
$data['employee_id'] = $employee_id;
$data['main_content'] = 'employees';
return View::make('includes/template', $data);
}
/**
* Enter description here...
*
* @param unknown_type $employee_id
* @param unknown_type $office_id
* @param unknown_type $page
*/
function edit_employee($employee_id = '', $office_id = '', $page = '')
{
$data['page_name'] = '<b>Edit Employee</b>';
$data['msg'] = '';
$this->Employee->fields = array('shift_id', 'friday_exempted', 'office_id', 'detailed_office_id', 'permanent', 'first_day_of_service', 'position', 'assistant_dept_head', 'employee_id', 'division_id', 'salary_grade', 'step', 'pics', 'id', 'salut', 'lname', 'fname', 'mname', 'extension', 'orig_id', 'emergency_contact', 'emergency_contact_no');
$employee_info = $this->Employee->get_employee_info($employee_id);
if ($employee_id == '') {
$employee_info = $this->Employee->get_employee_info(Input::get('orig_id'));
}
$shift_id_from_select = $employee_info['shift_id'];
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['selected'] = $employee_info['office_id'];
$data['division_id'] = $employee_info['division_id'];
//for detailed office
$data['detailed_options'] = $this->options->office_options($add_select = TRUE);
$data['detailed_selected'] = $employee_info['detailed_office_id'];
//dropdown for type of employment
$data['permanent_options'] = $this->options->type_employment();
$data['permanent_options_selected'] = $employee_info['permanent'];
$data['first_day_of_service'] = $employee_info['first_day_of_service'];
$data['position'] = $employee_info['position'];
$data['assistant_dept_head'] = $employee_info['assistant_dept_head'];
$data['employee_id'] = $employee_info['employee_id'];
$data['friday_exempted'] = $employee_info['friday_exempted'];
//Salary grade options
$data['sg_options'] = $this->options->salary_grade();
//step increment
$data['step_options'] = $this->options->step();
$data['sg_selected'] = $employee_info['salary_grade'];
$data['step_selected'] = $employee_info['step'];
$data['page'] = $this->uri->segment(5);
$data['office_return'] = $this->uri->segment(4);
$data['image_file_name'] = $employee_info['pics'];
//Shift List
$data['shifts_options'] = $this->options->shift();
$data['shift2'] = $employee_info['shift_id'];
if ($employee_info['pics'] == '' || !file_exists('pics/' . $employee_info['pics'])) {
$data['image_file_name'] = 'not_available.jpg';
}
$data['id'] = $employee_info['id'];
$data['salutation'] = $employee_info['salut'];
$data['lname'] = $employee_info['lname'];
$data['fname'] = $employee_info['fname'];
$data['mname'] = $employee_info['mname'];
$data['extension'] = $employee_info['extension'];
//The original employee id
$data['orig_id'] = $employee_info['id'];
$data['emergency_contact'] = $employee_info['emergency_contact'];
$data['emergency_contact_no'] = $employee_info['emergency_contact_no'];
if (Input::get('op')) {
$orig_id = Input::get('orig_id');
$id = Input::get('id');
if ($employee_id != Input::get('employee_id')) {
$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('position', 'Position', 'required');
$this->form_validation->set_rules('extension', 'First Name', '');
$this->form_validation->set_rules('permanent', 'Type of employment', 'required');
if ($this->form_validation->run($this) == FALSE) {
$data['selected'] = Input::get('office_id');
$data['detailed_selected'] = Input::get('detailed_office_id');
$data['employee_id'] = Input::get('employee_id');
$data['page'] = Input::get('page');
$data['office_return'] = Input::get('office_return');
} else {
if (Input::get('employee_id') != $employee_info['employee_id']) {
$em = new Employee_m();
$em->get_by_id($orig_id);
$em->orig_id = $employee_info['employee_id'];
$em->save();
# code...
}
//echo $orig_id;
//echo Input::get('employee_id');
//var_dump($employee_info['employee_id']);
//var_dump($employee_info['orig_id']);
//exit;
$info = array('employee_id' => Input::get('employee_id'), 'lname' => Input::get('lname'), 'fname' => Input::get('fname'), 'mname' => Input::get('mname'), 'extension' => Input::get('extension'), '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'), 'permanent' => Input::get('permanent'), 'first_day_of_service' => Input::get('first_day_of_service'), 'salary_grade' => Input::get('sg'), 'step' => Input::get('step'), 'position' => Input::get('position'), 'assistant_dept_head' => Input::get('assistant_dept_head'), 'shift_id' => Input::get('shift2'), 'shift_type' => Input::get('shift2'), 'friday_exempted' => Input::get('friday_exempted'), 'updated' => 1, 'emergency_contact' => Input::get('emergency_contact'), 'emergency_contact_no' => Input::get('emergency_contact_no'));
//$data['emergency_contact'] = $employee_info['emergency_contact'];
//File name of the photo
$file_register = Session::get('file_register');
if ($file_register) {
$info['pics'] = $file_register;
$info['finger_pics'] = '/../' . current_work_dir() . '/pics/' . Session::get('file_register');
}
$this->Employee->update_employee($info, $id);
$this->Logs->insert_logs('employees', 'EDIT EMPLOYEE', 'Edit employee (' . $id . ')', $id);
$page = Input::get('page');
$office_return = Input::get('office_return');
// Use for messaging
Session::flash('msg', 'Employee updated!');
return Redirect::to('employees/index/' . $page . '/' . $office_return, 'refresh');
}
}
$data['main_content'] = 'edit_employee';
return View::make('includes/template', $data);
}
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);
}
function schedule_retirement_pay($date_retired = '', $employee_id = '1')
{
$data = array();
$data['msg'] = '';
$this->load->library('fpdf');
if (!defined('FPDF_FONTPATH')) {
define('FPDF_FONTPATH', $this->config->item('fonts_path'));
}
$this->load->library('fpdi');
// initiate FPDI
$pdf = new FPDI('L', 'mm', 'Legal');
$pdf->SetAutoPageBreak(FALSE);
// add a page
$pdf->AddPage();
// set the sourcefile
$pdf->setSourceFile('dtr/template/leave/schedule_retirement_pay.pdf');
// select the first page
$tplIdx = $pdf->importPage(1);
// use the page we imported
$pdf->useTemplate($tplIdx);
$e = new Employee_m();
$e->get_by_employee_id($employee_id);
// set font, font style, font size.
$pdf->SetFont('Times', '', 10);
$pdf->SetTextColor(89, 89, 89);
// set initial placement
$pdf->SetXY(142, 20.5);
$personal = new Personal_m();
$personal->where('employee_id', $e->id);
$personal->get(1);
$this->load->helper('date');
$o = new Office_m();
$o->get_by_office_id($e->office_id);
$period = 'January 1, 2012 May 10, 2012';
$office_name = $o->office_name;
$lgu_name = Setting::getField('lgu_name');
//var_dump($date_retired);
$date_retired_diff = $date_retired;
$date_birth = convert_long_date($personal->birth_date, TRUE);
$first_day_of_service = convert_long_date($e->first_day_of_service);
$date_retired = convert_long_date($date_retired, TRUE);
$salary = $this->Salary_grade->get_monthly_salary($e->salary_grade, $e->step);
//$pdf->SetX(114);
$pdf->Write(0, $period);
$pdf->Ln(10);
$pdf->SetX(63);
$pdf->Write(0, $office_name);
$pdf->Ln(5);
$pdf->SetX(63);
$pdf->Write(0, $lgu_name);
$pdf->SetFont('Times', 'B', 10);
$pdf->Ln(21.5);
$pdf->SetX(14);
$pdf->Write(0, $e->fname . ' ' . substr($e->mname, 0, 1) . '. ' . $e->lname);
$pdf->SetFont('Times', '', 10);
$pdf->SetX(65);
$pdf->Write(0, $date_birth);
$pdf->SetX(88);
$pdf->Write(0, $date_retired);
$date1 = new DateTime("1970-7-01");
$date2 = new DateTime("2011-11-16");
$date1 = new DateTime($e->first_day_of_service);
$date2 = new DateTime($date_retired_diff);
$interval = $date1->diff($date2);
//echo "difference " . $interval->y . " years, " . $interval->m." months, ".$interval->d." days ";
if ($interval->y != 0) {
$pdf->SetX(114);
$pdf->Write(0, $interval->y . " years");
}
if ($interval->m != 0) {
$pdf->Ln(5);
$pdf->SetX(114);
$pdf->Write(0, $interval->m . " months");
}
if ($interval->d != 0) {
$pdf->Ln(5);
$pdf->SetX(114);
$pdf->Write(0, $interval->d . " days");
}
// Salary
$pdf->SetXY(145, 53);
$pdf->Cell(20, 8, number_format($salary, 2), '', 0, 'C', FALSE);
$total_leave = $this->Leave_card->get_total_leave_credits($employee_id);
$vacation_leave = $total_leave['vacation'];
$sick_leave = $total_leave['sick'];
$total = $vacation_leave + $sick_leave;
$terminal_leave = $salary * $total * 0.0478087;
// vacation leave
$pdf->SetXY(203, 58);
$pdf->Cell(20, 8, number_format($vacation_leave, 3), '', 0, 'R', FALSE);
// sick leave
$pdf->SetXY(203, 63);
$pdf->Cell(20, 8, number_format($sick_leave, 3), '', 0, 'R', FALSE);
// total
$pdf->SetXY(203, 68);
$pdf->Cell(20, 8, number_format($total, 3), '', 0, 'R', FALSE);
// terminal leave
$pdf->SetX(274);
$pdf->Cell(20, 8, number_format($terminal_leave, 2), '', 0, 'R', FALSE);
$pdf->SetFont('Times', 'B', 10);
// grand total leave
$pdf->SetXY(203, 119);
$pdf->Cell(20, 8, number_format($total, 3), '', 0, 'R', FALSE);
// total terminal amount
$pdf->SetX(274);
$pdf->Cell(20, 8, number_format($terminal_leave, 2), '', 0, 'R', FALSE);
// Signatories
$pdf->Ln(35);
$pdf->SetX(13);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_prepared'), '', 0, 'C', FALSE);
// date
$pdf->SetFont('Times', '', 10);
$pdf->SetX(76);
$pdf->Cell(50, 8, date('F d, Y'), '', 0, 'C', FALSE);
$pdf->SetFont('Times', 'B', 10);
$pdf->SetX(147);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_approved'), '', 0, 'C', FALSE);
$pdf->SetFont('Times', '', 10);
$pdf->Ln(5);
$pdf->SetX(13);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_prepared_position'), '', 0, 'C', FALSE);
$pdf->SetX(146);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_approved_position'), '', 0, 'C', FALSE);
$pdf->SetFont('Times', 'B', 10);
$pdf->Ln(25);
$pdf->SetX(13);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_certified'), '', 0, 'C', FALSE);
$pdf->SetX(88);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_attested'), '', 0, 'C', FALSE);
$pdf->SetX(147);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_availability'), '', 0, 'C', FALSE);
$pdf->SetX(223);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_noted'), '', 0, 'C', FALSE);
$pdf->SetFont('Times', '', 10);
$pdf->Ln(5);
$pdf->SetX(13);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_certified_position'), '', 0, 'C', FALSE);
$pdf->SetX(88);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_attested_position'), '', 0, 'C', FALSE);
$pdf->SetX(147);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_availability_position'), '', 0, 'C', FALSE);
$pdf->SetX(223);
$pdf->Cell(50, 8, Setting::getField('retirement_signatory_noted_position'), '', 0, 'C', FALSE);
header('Cache-Control: maxage=3600');
//Adjust maxage appropriately
header('Pragma: public');
$pdf->Output('dtr/reports/schedule_retirement_pay' . $employee_id . '.pdf', 'F');
// index 'L' for landscape
$this->pages['L'] = 'dtr/reports/schedule_retirement_pay' . $employee_id . '.pdf';
}
function employee_schedule_save($id = '', $page = '')
{
$data['page_name'] = '<b>Save Employee Schedule</b>';
$data['msg'] = '';
$data['selected'] = Session::get('office_id');
if ($id != '') {
$sd = new Schedule_detail();
$sd->get_by_id($id);
$data['selected'] = $sd->office_id;
}
// Use for office listbox
$data['options'] = $this->options->office_options(TRUE);
$this->load->helper('options');
$sd = new Schedule_detail();
$data['sched'] = $sd->get_by_id($id);
$dates = unserialize($sd->dates);
if ($dates == '') {
$dates = array('year' => date('Y'), 'period_from' => 1, 'period_to' => date('d'), 'month' => date('m'));
}
$db_employees = unserialize($sd->employees);
if (!Input::get('op')) {
// if the database has value on it add the value from database to session
if (is_array($db_employees)) {
if (!is_array(Session::get('employees'))) {
Session::put('employees', array());
}
$employees = array_merge(Session::get('employees'), $db_employees);
Session::put('employees', $employees);
}
}
if (Input::get('op')) {
$employees = Session::get('employees');
$month_year = Input::get('year') . '-' . Input::get('month');
$between_from = $month_year . '-' . Input::get('period_from');
$between_to = $month_year . '-' . Input::get('period_to');
$dates = array('year' => Input::get('year'), 'period_from' => Input::get('period_from'), 'period_to' => Input::get('period_to'), 'month' => Input::get('month'));
$days = $this->Helps->get_days_in_between($between_from, $between_to);
if (!Input::get('op')) {
if (is_array($db_employees)) {
$employees = array_merge($employees, $db_employees);
}
}
$employees = array_unique($employees);
$sd->name = Input::get('name');
$sd->employees = serialize($employees);
$sd->dates = serialize($dates);
$sd->schedule_id = Input::get('schedule_id');
$sd->office_id = Input::get('office_id');
$sd->save();
Session::flash('msg', 'Schedule saved!');
// Get the schedule
$s = new Schedule();
$s->get_by_id(Input::get('schedule_id'));
$times = unserialize($s->times);
// Check if 2 logs or 4 logs
if ($times['am_in_hour'] != '' && $times['am_out_hour'] != '' && $times['pm_in_hour'] != '' && $times['pm_out_hour'] != '') {
$sched_data['hour_from'] = '';
$sched_data['hour_to'] = '';
$sched_data['am_in'] = $times['am_in_hour'] . ':' . $times['am_in_min'];
$sched_data['am_out'] = $times['am_out_hour'] . ':' . $times['am_out_min'];
$sched_data['pm_in'] = $times['pm_in_hour'] . ':' . $times['pm_in_min'];
$sched_data['pm_out'] = $times['pm_out_hour'] . ':' . $times['pm_out_min'];
$shift_id = 3;
$shift_type = 3;
} else {
//echo '2 times';
// IN
if ($times['am_in_hour'] != '') {
$sched_data['hour_from'] = $times['am_in_hour'] . ':' . $times['am_in_min'];
} else {
if ($times['pm_in_hour'] != '') {
$sched_data['hour_from'] = $times['pm_in_hour'] . ':' . $times['pm_in_min'];
}
}
// OUT
if ($times['am_out_hour'] != '') {
$sched_data['hour_to'] = $times['am_out_hour'] . ':' . $times['am_out_min'];
} else {
if ($times['pm_out_hour'] != '') {
$sched_data['hour_to'] = $times['pm_out_hour'] . ':' . $times['pm_out_min'];
}
}
$sched_data['am_in'] = '';
$sched_data['am_out'] = '';
$sched_data['pm_in'] = '';
$sched_data['pm_out'] = '';
$shift_id = 2;
$shift_type = 2;
// Check if 24 hrs
if ($sched_data['hour_from'] == $sched_data['hour_to']) {
$shift_id = 4;
$shift_type = 4;
}
}
foreach ($days as $day) {
//echo $day."<br>";
$sched_data['date'] = $day;
$oe = new Employee_m();
foreach ($employees as $employee) {
// Change the shift ID
$oe->get_by_employee_id($employee);
$oe->shift_id = $shift_id;
$oe->shift_type = $shift_type;
$oe->save();
// Check if there is schedule for this date
$sched_data['employee_id'] = $employee;
$is_schedule_exists = $this->Schedule_employees->is_schedule_exists($employee, $day);
// Update
if ($is_schedule_exists == TRUE) {
$this->Schedule_employees->update($sched_data, $day, $employee);
} else {
$this->Schedule_employees->insert($sched_data);
}
}
}
//Unset the session
//$employees = array();
//Session::put($employees);
Session::forget('employees');
//return Redirect::to('settings_manage/schedules/'.$page, 'refresh');
Session::flash('msg', 'Schedule saved!');
$data['msg'] = 'Employee Schedule has been saved!';
}
// Months
$data['month_options'] = $this->options->month_options();
$data['month_selected'] = $dates['month'];
//print_r($dates);
// Period from
$data['days_options'] = $this->options->days_options();
$data['period_from_selected'] = $dates['period_from'];
// Period to
$data['days_options'] = $this->options->days_options();
$data['period_to_selected'] = $dates['period_to'];
$data['year_options'] = $this->options->year_options(2009, 2020);
//2010 - 2020
$data['year_selected'] = $dates['year'];
$data['main_content'] = 'employee_schedule_save';
return View::make('includes/template', $data);
}
<th width="11%" bgcolor="#D6D6D6">Amount</th>
</tr>
<?php
$i = 0;
?>
<?php
$p = new Plantilla_m();
?>
<?php
foreach ($rows as $row) {
?>
<?php
$p->where('year', $year);
$p->where('plantilla_item_id', $row->id);
$p->get();
$e = new Employee_m();
$e->get_by_id($p->employee_id);
// last param of dg_editCell is the size of the textbox
$onclick0 = "onClick=\"dg_editCell(offices,'" . $p->id . "','item_no','offices.0.{$i}', 'plantilla')\"";
$onclick1 = "onClick=\"dg_editCell(offices,'" . $p->id . "','position','offices.1.{$i}', 'plantilla', '40')\"";
$onclick2 = "onClick=\"dg_editCell(offices,'" . $p->id . "','year','offices.2.{$i}', 'plantilla', '8')\"";
$onclick3 = "onClick=\"dg_editCell(offices,'" . $p->id . "','sg','offices.3.{$i}', 'plantilla', '5')\"";
$onclick4 = "onClick=\"dg_editCell(offices,'" . $p->id . "','amount','offices.4.{$i}', 'plantilla', '10')\"";
?>
<?php
$bg = $this->Helps->set_line_colors();
?>
<tr bgcolor="<?php
echo $bg;
?>
" onmouseover="this.bgColor = '<?php
function preview($employee_id)
{
$this->load->helper('settings');
$this->load->library('fpdf');
//define('FPDF_FONTPATH',$this->config->item('fonts_path'));
$this->load->library('fpdi');
//$pi = new Personal();
//$pi->get_by_employee_id( $employee_id );
//print_r($personal_info);
// initiate FPDI
$pdf = new FPDI('P', 'mm', 'Letter');
// add a page
$pdf->AddPage();
// set the sourcefile
//$pdf->setSourceFile('dtr/template/service_record/service_record.pdf');
// import page 1
//$tplIdx = $pdf->importPage(1);
// use the imported page and place it at point 10,10 with a width of 100 mm
//$pdf->useTemplate($tplIdx, 1, 1, 210);
// now write some text above the imported page
$pdf->SetFont('Arial');
$pdf->SetTextColor(0, 0, 0);
$pdf->SetXY(15, 60);
$pdf->SetFont('Arial', '', 16);
$pdf->Cell(0, 3, "Employee's Service Record", '', 1, 'C', false);
$pdf->Ln(4);
$e = new Employee_m();
$e->get_by_id($employee_id);
$pdf->SetFont('Arial', '', 12);
$pdf->Cell(0, 8, "Employee No.:" . $e->employee_id, '', 1, 'L', false);
$pdf->Ln(2);
$pdf->SetFont('Arial', '', 12);
$pdf->Cell(0, 8, "Employee Name:" . $e->lname . ', ' . $e->fname . ' ' . $e->mname, '', 1, 'L', false);
$pdf->Ln(4);
$pdf->Cell(0, 8, "Date From Date To Position Department Movement Status Status", '1', 1, 'L', false);
$pdf->Ln(4);
$work = new Work();
$work->where('govt_service', '1');
$work->order_by('inclusive_date_from', 'DESC');
$works = $work->get_by_employee_id($employee_id);
$i = 1;
$this->load->helper('text');
foreach ($works as $work) {
$pdf->SetFont('Arial', '', 8);
$pdf->SetX(10);
list($year, $month, $day) = explode('-', $work->inclusive_date_from);
$inclusive_date_from = $month . '/' . $day . '/' . $year;
$pdf->Write(0, $inclusive_date_from);
list($year, $month, $day) = explode('-', $work->inclusive_date_to);
$inclusive_date_to = $month . '/' . $day . '/' . $year;
if ($work->inclusive_date_to == 'Present') {
$inclusive_date_to = 'Present';
}
$pdf->SetX(29);
$pdf->Write(0, $inclusive_date_to);
$pdf->SetFont('Arial', '', 8);
$pdf->SetX(50);
$pdf->Write(0, str_replace('…', '..', character_limiter($work->position, 35)));
$pdf->SetX(100);
//$pdf->Write(0, $work->company);
$pdf->Write(0, str_replace('…', '..', character_limiter($work->company, 35)));
//$pdf->SetFont('Arial', '', 12);
$pdf->SetX(160);
$pdf->Write(0, $work->movement);
//$pdf->SetX(150);
//$pdf->Write(0, $work->salary_grade);
$pdf->SetFont('Arial', '', 8);
$pdf->SetX(185);
$pdf->Write(0, $work->status);
$work->govt_service = $work->govt_service == 1 ? 'Yes' : 'No';
$pdf->SetX(190);
//$pdf->Write(0, $work->govt_service);
$pdf->SetFont('Arial', '', 12);
if ($i == 6 || $i == 10 || $i == 13 || $i == 16 || $i == 19 || $i == 22) {
$pdf->Ln(8);
} else {
$pdf->Ln(7);
}
$i++;
}
$pdf->Cell(0, 8, "--------------------------------------------------------- Nothing Follows ---------------------------------------------------------", '', 1, 'C', false);
// Signatories
$pdf->Ln(15);
$pdf->SetX(20);
$pdf->Cell(90, 5, "PREPARED BY:", '0', 0, 'C', false);
$pdf->Cell(90, 5, "CERTIFIED CORRECT:", '0', 1, 'C', false);
$pdf->Ln(10);
$sr_prepared = Setting::getField('sr_prepared');
$sr_prepared_position = Setting::getField('sr_prepared_position');
$sr_certified = Setting::getField('sr_certified');
$sr_certified_position = Setting::getField('sr_certified_position');
$pdf->SetX(20);
$pdf->Cell(90, 5, $sr_prepared, '0', 0, 'C', false);
//4th param border
$pdf->Cell(90, 5, $sr_certified, '0', 1, 'C', false);
$pdf->SetX(20);
$pdf->Cell(90, 5, $sr_prepared_position, '0', 0, 'C', false);
$pdf->Cell(90, 5, $sr_certified_position, '0', 1, 'C', false);
// Output
$pdf->Output('dtr/template/service_record/archives/service_record_' . $employee_id . '.pdf', 'I');
}
function aso()
{
$e = new Employee_m();
$e->where('id', '25')->get();
echo 'aso';
}
function show_image_url($employee_id = '')
{
//echo '3';
//exit;
$e = new Employee_m();
$e->get_by_employee_id($employee_id);
//echo $this->db->last_query();
echo '<img src="' . base_url() . 'pics/' . $e->pics . '">';
}
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);
}
</table>
<table width="100%" border="0" class="type-one">
<tr class="type-one-header">
<th width="8%" bgcolor="#D6D6D6"><strong>Employee No.</strong></th>
<th width="25%" bgcolor="#D6D6D6"><strong>Employee Name</strong></th>
<th width="30%" bgcolor="#D6D6D6"><strong>Department / Office</strong></th>
<th width="8%" bgcolor="#D6D6D6"><strong>Status</strong></th>
<th width="10%" bgcolor="#D6D6D6"><strong>Date Requested</strong></th>
<th width="30%" bgcolor="#D6D6D6"><strong>Action</strong></th>
</tr>
<?php
$add_to_cart = '';
foreach ($results as $result) {
//get by employee ID
$e = new Employee_m();
$rows = $e->get_by_id($result->employee_id);
if ($e->count() >= '1') {
foreach ($rows as $row) {
if ($row->id == $result->employee_id) {
$add_to_cart = "<a href='" . base_url() . "employees/remove_cart/" . $page . "/" . $row->id . "/1'>Remove to Request<a>";
}
}
}
$office_name = $this->Office->get_office_name($row->office_id);
$pics = $row->pics;
if ($pics == "" || !file_exists("pics/{$pics}")) {
$pics = 'not_available.jpg';
}
$bg = $this->Helps->set_line_colors();
?>
function back_id($results)
{
$params = array('mode' => '', 'format' => 'Legal', 'default_font_size' => 0, 'default_font' => '', 'mgl' => '0', 'mgr' => '0', 'mgt' => '0', 'mgb' => '0', 'mgh' => '0', 'mgf' => '0', 'orientation' => 'P');
$this->load->library('mpdf', $params);
// LOAD a stylesheet
//$this->mpdf->SetHTMLHeader('<div align="center" style="font-size:15">LAGUNA UNIVERSITY PROPERTY INVENTORY SYSTEM<div>');
$stylesheet = file_get_contents(base_url() . 'css/mpdf/mpdfstyletables.css');
$this->mpdf->WriteHTML($stylesheet, 1);
// The parameter 1 tells that this is css/style only and no body/html/text
//$today = date("F, l, d, Y - H:i:s a");
//$this->mpdf->SetFooter($today.'||{PAGENO} of {nbpg}');
$tbl_start_b = '<table border="0"><tr>';
$this->mpdf->WriteHTML($tbl_start_b);
$x = '4';
//4 start counting
$y = '0';
foreach ($results as $result) {
//get info from PDS table
$p = new Pds_personal_info_m();
$row = $p->get_by_employee_id($result->employee_id);
//get info from Employee table
$e = new Employee_m();
$e_row = $e->get_by_id($val);
$blood_type = '';
if (strlen($row->blood_type) >= 1) {
$blood_type = """ . $row->blood_type . """;
}
$y++;
$o = new Office_m();
$office = $o->get_by_office_id($e_row->office_id);
$html_f = '<td align="center">
<table border="0" width="205" height="320" style="background-image: url(images/id/id-back.png) no-repeat; font-size:9px; font-family:Arial" >
<tr><td height="12" colspan="2"></td></tr>
<tr>
<td width="20%" height="37" align="left">ADDRESS:</td>
<td align="center">' . ucwords(strtolower($row->permanent_address)) . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">BIRTHDAY:</td>
<td align="center" valign="bottom">' . $row->birth_date . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">BLOOD TYPE:</td>
<td align="center" valign="bottom">' . $blood_type . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">GSIS:</td>
<td align="center" valign="bottom">' . $row->gsis . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">PAG-IBIG:</td>
<td align="center" valign="bottom">' . $row->pagibig . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">PHILHEALTH:</td>
<td align="center" valign="bottom">' . $row->philhealth . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">TIN:</td>
<td align="center" valign="bottom">' . $row->tin . '</td>
</tr>
<tr>
<td height="10" colspan="2" align="center">
This card must be surrendered immediately upon termination or separation from service. if found. please send or mail to</td>
</tr>
<tr>
<td align="center" colspan="2">
<b>Provincial Government of Laguna<br>' . $office->office_name . '</b>
<br>' . $office->office_address . '
</td>
</tr>
<tr>
<td align="center" colspan="2" height="20" valign="bottom"><b>IN CASE OF EMERGENCY, PLEASE NOTIFY:</b></td>
</tr>
<tr>
<td align="center" colspan="2"><b> <br /> </b></td>
</tr>
<tr>
<td align="center" height="61" colspan="2" style="background-image: url(images/id/gov.signiture.png) no-repeat;"> </td>
</tr>
</table></td>';
if ($y == $x) {
$html_f = '
<tr><td align="center">
<table border="0" width="205" height="320" style="background-image: url(images/id/id-back.png) no-repeat; font-size:9px; font-family:Arial" >
<tr><td height="12" colspan="2"></td></tr>
<tr>
<td width="20%" height="37" align="left">ADDRESS:</td>
<td align="center">' . ucwords(strtolower($row->permanent_address)) . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">BIRTHDAY:</td>
<td align="center" valign="bottom">' . $row->birth_date . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">BLOOD TYPE:</td>
<td align="center" valign="bottom">' . $blood_type . '</td>
</tr>
<tr>
<td height="18" align="left" valign="bottom">GSIS:</td>
<td align="center" valign="bottom">' . $row->gsis . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">PAG-IBIG:</td>
<td align="center" valign="bottom">' . $row->pagibig . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">PHILHEALTH:</td>
<td align="center" valign="bottom">' . $row->philhealth . '</td>
</tr>
<tr>
<td height="20" align="left" valign="bottom">TIN:</td>
<td align="center" valign="bottom">' . $row->tin . '</td>
</tr>
<tr>
<td height="10" colspan="2" align="center">
This card must be surrendered immediately upon termination or separation from service. if found. please send or mail to</td>
</tr>
<tr>
<td align="center" colspan="2">
<b>Provincial Government of Laguna<br>' . $office->office_name . '</b>
<br>' . $office->office_address . '
</td>
</tr>
<tr>
<td align="center" colspan="2" height="20" valign="bottom"><b>IN CASE OF EMERGENCY, PLEASE NOTIFY:</b></td>
</tr>
<tr>
<td align="center" colspan="2"><b> <br /> </b></td>
</tr>
<tr>
<td align="center" height="61" colspan="2" style="background-image: url(images/id/gov.signiture.png) no-repeat;"> </td>
</tr>
</table></td></tr>';
$x = $x + 3;
//3 count of generated id per column
}
$this->mpdf->WriteHTML($html_f);
}
$tbl_end_b = '</tr></table>';
$this->mpdf->WriteHTML($tbl_end_b);
header('Cache-Control: maxage=3600');
//Adjust maxage appropriately
header('Pragma: public');
$this->mpdf->Output('dtr/template/id_generated/back_id.pdf', 'F');
return TRUE;
}
function sr_print_preview($employee_id = '', $report_name = '')
{
$a = Setting::getField('republic');
$b = Setting::getField('lgu_name');
$c = Setting::getField('lgu_office');
$d = Setting::getField('lgu_address');
// this is for heading republic
$lgu_code = Setting::getField('lgu_code');
$logo = 'dtr/template/logo/logo.jpg';
// Laguna Province
if ($lgu_code == 'laguna_province') {
$logo = 'dtr/template/laguna_province/logo.jpg';
}
$employee = new Employee_m();
$employee->get_by_id($employee_id);
$personal = new Personal();
$personal->get_by_employee_id($employee_id);
// Signatories
$sr_prepared = Setting::getField('sr_prepared');
$sr_prepared_position = Setting::getField('sr_prepared_position');
$sr_certified = Setting::getField('sr_certified');
$sr_certified_position = Setting::getField('sr_certified_position');
$service = '<table width="100%" border="0" cellpadding="5" cellspacing="5">
<tr>
<td colspan="5" align="center" style="font-size:25px"><strong>SERVICE RECORD</strong></td>
</tr>
<tr>
<td width="24%" align="left"><strong>Employee Number :</strong></td>
<td width="22%"><b>' . $employee->employee_id . '</b></td>
<td width="15%"> </td>
<td width="29%"> </td>
<td width="10%"> </td>
</tr>
<tr>
<td align="left"><strong>Name :</strong></td>
<td colspan="3" style="font-family:\'Times New Roman\', Times, serif"><em><b>' . $employee->lname . ', ' . $employee->fname . ' ' . $employee->mname . '</b></em></td>
<td> </td>
</tr>
<tr>
<td align="left"><strong>Birthday :</strong></td>
<td><em><b>' . $employee->birth_date . '</b></em></td>
<td align="right"><strong>Birthplace :</strong></td>
<td><em><b>' . $personal->birth_place . '</b></em></td>
<td> </td>
</tr>
<tr>
<td colspan="5" align="left" style="font-size:11px"> <em>This is to certify that the employee named herein above actually rendered services in this Office as shown by the service record below, each line of which is supported by appointment and other papers actually issued by this Office and approved by the authorities concerned.</em></td>
</tr>
</table>
<table width="100%" border="1">
<tr>
<td colspan="2" align="center" valign="middle">SERVICE<br />
(Inclusive Date)</td>
<td colspan="3" align="center" valign="middle">RECORDS OF APPOINTMENT</td>
<td align="center" valign="middle">OFFICE ENTITY / DIVISION</td>
<td align="center" valign="middle">L/V ABS<br />
W/O PAY</td>
<td colspan="2" align="center" valign="middle">SEPARATION</td>
</tr>
<tr>
<td align="center">From</td>
<td align="center">To</td>
<td align="center">Designation</td>
<td align="center">Status</td>
<td align="center">Salary</td>
<td align="center">Station/Place of Assignment/Branch</td>
<td align="center"> </td>
<td align="center">Date</td>
<td align="center">Cause</td>
</tr>
';
$html = '
<!-- defines the headers/footers - this must occur before the headers/footers are set -->
<!--mpdf
<htmlpagefooter name="myfooter">
<table width="100%">
<tr>
<td colspan="3" align="center">-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- </td>
</tr>
<tr>
<td colspan="3"> Issued in compliance with Executive Order No. 54 Dated August 10, 1954, and in accordance with Circular No. 58, dated August 10, 1954, of the System.</td>
</tr>
<tr>
<td width="19%"> </td>
<td width="42%"> </td>
<td width="39%"> </td>
</tr>
<tr>
<td> </td>
<td align="center">PREPARED BY</td>
<td align="center">CERTIFIED CORRECT</td>
</tr>
<tr>
<td align="center">' . date('F d, Y') . '</td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center">Date</td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center">' . $sr_prepared . '</td>
<td align="center">' . $sr_certified . '</td>
</tr>
<tr>
<td> </td>
<td align="center">' . $sr_prepared_position . '</td>
<td align="center">' . $sr_certified_position . '</td>
</tr>
</table></htmlpagefooter>
mpdf-->
<!-- set the headers/footers - they will occur from here on in the document -->
<!--mpdf
<sethtmlpagefooter name="myfooter" page="all" value="1"/>
mpdf-->
<table width="100%" border="0">
<tr>
<td> </td>
<td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $a . '</em></b></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $b . '</em></b></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $c . '</em></b></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $d . '</em></b></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<style type="text/css">
#apDiv1 {
position:absolute;
width:104px;
height:106px;
z-index:1;
left: 100px;
top: 55px;
}
</style>
<div id="apDiv1"><img src="' . base_url() . $logo . '" alt="" name="logo" width="110" height="110"/></div>
' . $service;
$s = new Service_record();
//$s->order_by('date_from');
$s->select('id, employee_id, date_from, date_to, designation, status, salary, office_entity, branch, remarks, lwop, separation_date, separation_cause, STR_TO_DATE(date_from,"%m/%d/%Y") as nice_date', false);
$s->order_by("nice_date");
$rows = $s->get_by_employee_id($employee_id);
$i = 1;
// Number of entries to display per page
$first_page = Setting::getField('service_record_entries_first_page');
$second_page = Setting::getField('service_record_entries_second_page');
$third_page = Setting::getField('service_record_entries_3rd_page');
$fourth_page = Setting::getField('service_record_entries_4th_page');
//for ($i ==0; $i != 70; $i ++)
foreach ($rows as $row) {
$number_character = strlen($row->designation . $row->salary . $row->salary . $row->office_entity . $row->lwop . $row->separation_date . $row->separation_cause);
$html .= '<tr>
<td align="center">' . $row->date_from . '</td>
<td align="center">' . $row->date_to . '</td>
<td align="center">' . $row->designation . '</td>
<td align="center">' . $row->status . '</td>
<td align="right">' . $row->salary . '</td>
<td align="center">' . $row->office_entity . '</td>
<td align="left">' . $row->lwop . '</td>
<td align="left">' . $row->separation_date . '</td>
<td align="left" style="font-size:7">' . $row->separation_cause . '</td>
</tr>';
// Second page
if ($i == $first_page) {
$html .= '</table>';
// close the table
$html .= '<pagebreak />' . $service;
}
// If there is third page
if ($i == $first_page + $second_page) {
$html .= '</table>';
// close the table
$html .= '<pagebreak />' . $service;
}
// If there is 4th page
if ($i == $first_page + $second_page + $third_page) {
$html .= '</table>';
// close the table
$html .= '<pagebreak />' . $service;
}
// If there is 5th page
if ($i == $first_page + $second_page + $third_page + $fourth_page) {
$html .= '</table>';
// close the table
$html .= '<pagebreak />' . $service;
}
$i++;
}
$html .= '</table>';
//$html.='
//<pagebreak />
//'.$service.'</table>
//<pagebreak />
//';
$params = array('format' => 'Letter');
$params = array('format' => 'Legal');
$params = array('format' => Setting::getField('service_record_paper_size'));
$this->load->library('mpdf', $params);
//$mpdf=new mPDF('c','Letter');
//$this->mpdf->mirrorMargins = 1; // Use different Odd/Even headers and footers and mirror margins
$stylesheet = file_get_contents(base_url() . 'css/mpdf/mpdfstyletables.css');
$this->mpdf->WriteHTML($stylesheet, 1);
// The parameter 1 tells that this is css/style only and no
$this->mpdf->SetHTMLHeader('Page {PAGENO} of {nb}', '', false);
//$this->mpdf->SetHTMLFooter('{PAGENO}');
$this->mpdf->WriteHTML($html);
$this->mpdf->Output();
}
function assets_other_info($employee_id = '')
{
$data['page_name'] = '<b>Assets and Liabilities</b>';
$data['section_name'] = '<b>Other Info</b>';
$data['msg'] = '';
$e = new Employee_m();
$data['employee'] = $e->get_by_id($employee_id);
if (Input::get('op')) {
$a = new Asset_info();
$a->where('employee_id', $employee_id)->get();
$a->employee_id = $employee_id;
$a->s_tin = Input::get('s_tin');
$a->s_cc_no = Input::get('s_cc_no');
$a->s_issue_at = Input::get('s_issue_at');
$a->s_issue_date = Input::get('s_issue_date');
$a->tin = Input::get('tin');
$a->cc_no = Input::get('cc_no');
$a->issue_at = Input::get('issue_at');
$a->issue_date = Input::get('issue_date');
$a->save();
$data['msg'] = $data['section_name'] . ' has been saved!';
}
$a = new Asset_info();
$data['info'] = $a->get_by_employee_id($employee_id);
$data['selected'] = $e->office_id;
//Use for office listbox
$data['options'] = $this->options->office_options();
$data['employee_id'] = $employee_id;
$data['main_content'] = 'assets_other_info';
return View::make('includes/template', $data);
}
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<form method="post" action="" enctype="multipart/form-data">
<table id="dtr.table" width="100%" border="0" class="type-one">
<tr class="type-one-header">
<th width="56%" bgcolor="#D6D6D6">Name</th>
<th width="44%" bgcolor="#D6D6D6"> </th>
</tr>
<?php
$oe = new Employee_m();
?>
<?php
foreach ($employees as $employee) {
?>
<?php
$oe->get_by_employee_id($employee);
?>
<?php
$bg = $this->Helps->set_line_colors();
?>
<tr bgcolor="<?php
echo $bg;
?>
" onmouseover="this.bgColor = '<?php
<th width="17%" bgcolor="#D6D6D6">Acted Upon</th>
<th width="17%" bgcolor="#D6D6D6">KSS Form</th>
<th width="17%" bgcolor="#D6D6D6">PDF</th>
<th width="17%" bgcolor="#D6D6D6">PDS</th>
<th width="17%" bgcolor="#D6D6D6">Education</th>
<th width="17%" bgcolor="#D6D6D6">Eligibility</th>
<th width="17%" bgcolor="#D6D6D6">NBI Clearance</th>
<th width="17%" bgcolor="#D6D6D6">Oath of Office</th>
<th width="17%" bgcolor="#D6D6D6">Med. Cert.</th>
<th width="17%" bgcolor="#D6D6D6">SALN</th>
<th width="17%" bgcolor="#D6D6D6">PES</th>
<th width="17%" bgcolor="#D6D6D6">Remarks</th>
<th width="14%" bgcolor="#D6D6D6"><strong>Action</strong></th>
</tr>
<?php
$e = new Employee_m();
?>
<?php
foreach ($rows as $row) {
?>
<?php
$e->get_by_id($row->employee_id);
?>
<?php
$bg = $this->Helps->set_line_colors();
?>
<tr bgcolor="<?php
echo $bg;
?>
" onmouseover="this.bgColor = '<?php
echo $this->config->item('mouseover_linecolor');
