예제 #1
0
    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%">&nbsp;</td>
    <td width="29%">&nbsp;</td>
    <td width="10%">&nbsp;</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>&nbsp;</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>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5" align="left" style="font-size:11px"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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">&nbsp;</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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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%">&nbsp;</td>
    <td width="42%">&nbsp;</td>
    <td width="39%">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</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">&nbsp;</td>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center">Date</td>
    <td align="center">&nbsp;</td>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center">&nbsp;</td>
    <td align="center">' . $sr_prepared . '</td>
    <td align="center">' . $sr_certified . '</td>
  </tr>
  <tr>
    <td>&nbsp;</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>&nbsp;</td>
    <td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $a . '</em></b></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $b . '</em></b></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $c . '</em></b></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="center" style="font-family:\'Times New Roman\', Times, serif"><b><em>' . $d . '</em></b></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</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();
    }
예제 #2
0
 function page1($employee_id)
 {
     $this->load->helper('settings');
     $this->load->library('fpdf');
     //define('FPDF_FONTPATH',$this->config->item('fonts_path'));
     $this->load->library('fpdi');
     //$this->load->model('Personal_Info');
     //Get personal info
     //$pi = $this->Personal_Info->get_personal_info($employee_id);
     $pi = new Personal();
     $pi->get_by_employee_id($employee_id);
     //print_r($personal_info);
     // initiate FPDI
     $pdf = new FPDI('P', 'mm', 'Legal');
     // add a page
     $pdf->AddPage();
     // set the sourcefile
     $pdf->setSourceFile('dtr/template/pds/page1.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);
     /*******************************
      *START PERSONAL INFORMATION ==
      ******************************/
     $split[0] = '';
     $split[1] = '';
     $split[2] = '';
     $split[3] = '';
     $split[4] = '';
     $split[5] = '';
     $split[6] = '';
     $split[7] = '';
     $split[8] = '';
     $split[9] = '';
     $split[10] = '';
     $split[11] = '';
     $split[12] = '';
     $split[13] = '';
     $split[14] = '';
     $split[15] = '';
     $split[16] = '';
     $split[17] = '';
     $split[18] = '';
     $split[19] = '';
     $split[20] = '';
     $split[21] = '';
     $split[22] = '';
     $split[23] = '';
     $split[24] = '';
     $split[25] = '';
     $split[26] = '';
     $split[27] = '';
     $split[28] = '';
     $split[29] = '';
     //$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
     //$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
     //$pdf->MultiCell(0,3,"hello this is a sample \nlong text with line break" ,'',1,'L',false);
     $this->load->helper('text');
     //$pdf->MultiCell(0,3,word_wrap("hello this is a sample nlong text with line break", 15) ,'',1,'L',false);
     $split = str_split($pi->lname);
     // Write something ==LAST NAME =========
     $pdf->SetXY(39, 53);
     $pdf->Write(0, $split[0]);
     $pdf->SetX(44);
     $pdf->Write(0, $split[1]);
     $pdf->SetX(49);
     $pdf->Write(0, $split[2]);
     $pdf->SetX(54);
     $pdf->Write(0, $split[3]);
     $pdf->SetX(60);
     $pdf->Write(0, $split[4]);
     $pdf->SetX(65);
     $pdf->Write(0, $split[5]);
     $pdf->SetX(70);
     $pdf->Write(0, $split[6]);
     $pdf->SetX(75);
     $pdf->Write(0, $split[7]);
     $pdf->SetX(81);
     $pdf->Write(0, $split[8]);
     $pdf->SetX(86);
     $pdf->Write(0, $split[9]);
     $pdf->SetX(91);
     $pdf->Write(0, $split[10]);
     $pdf->SetX(96);
     $pdf->Write(0, $split[11]);
     $pdf->SetX(101);
     $pdf->Write(0, $split[12]);
     $pdf->SetX(106);
     $pdf->Write(0, $split[13]);
     $pdf->SetX(111);
     $pdf->Write(0, $split[14]);
     $pdf->SetX(116);
     $pdf->Write(0, $split[15]);
     $pdf->SetX(121);
     $pdf->Write(0, $split[16]);
     $pdf->SetX(126);
     $pdf->Write(0, $split[17]);
     $pdf->SetX(131);
     $pdf->Write(0, $split[18]);
     $pdf->SetX(137);
     $pdf->Write(0, $split[19]);
     $pdf->SetX(142);
     $pdf->Write(0, $split[20]);
     $pdf->SetX(147);
     $pdf->Write(0, $split[21]);
     $pdf->SetX(152);
     $pdf->Write(0, $split[22]);
     $pdf->SetX(157);
     $pdf->Write(0, $split[23]);
     $pdf->SetX(163);
     $pdf->Write(0, $split[24]);
     $pdf->SetX(168);
     $pdf->Write(0, $split[25]);
     $pdf->SetX(173);
     $pdf->Write(0, $split[26]);
     $pdf->SetX(178);
     $pdf->Write(0, $split[27]);
     $pdf->SetX(183);
     $pdf->Write(0, $split[28]);
     $pdf->SetX(188);
     $pdf->Write(0, $split[29]);
     // line break
     //=========FIRST NAME====
     $split = str_split($pi->fname);
     $pdf->Ln(6);
     $pdf->SetX(39);
     $pdf->Write(0, $split[0]);
     $pdf->SetX(44);
     $pdf->Write(0, $split[1]);
     $pdf->SetX(49);
     $pdf->Write(0, $split[2]);
     $pdf->SetX(54);
     $pdf->Write(0, $split[3]);
     $pdf->SetX(60);
     $pdf->Write(0, $split[4]);
     $pdf->SetX(65);
     $pdf->Write(0, $split[5]);
     $pdf->SetX(70);
     $pdf->Write(0, $split[6]);
     $pdf->SetX(75);
     $pdf->Write(0, $split[7]);
     $pdf->SetX(81);
     $pdf->Write(0, $split[8]);
     $pdf->SetX(86);
     $pdf->Write(0, $split[9]);
     $pdf->SetX(91);
     $pdf->Write(0, $split[10]);
     $pdf->SetX(96);
     $pdf->Write(0, $split[11]);
     $pdf->SetX(101);
     $pdf->Write(0, $split[12]);
     $pdf->SetX(106);
     $pdf->Write(0, $split[13]);
     $pdf->SetX(111);
     $pdf->Write(0, $split[14]);
     $pdf->SetX(116);
     $pdf->Write(0, $split[15]);
     $pdf->SetX(121);
     $pdf->Write(0, $split[16]);
     $pdf->SetX(126);
     $pdf->Write(0, $split[17]);
     $pdf->SetX(131);
     $pdf->Write(0, $split[18]);
     $pdf->SetX(137);
     $pdf->Write(0, $split[19]);
     $pdf->SetX(142);
     $pdf->Write(0, $split[20]);
     $pdf->SetX(147);
     $pdf->Write(0, $split[21]);
     $pdf->SetX(152);
     $pdf->Write(0, $split[22]);
     $pdf->SetX(157);
     $pdf->Write(0, $split[23]);
     $pdf->SetX(163);
     $pdf->Write(0, $split[24]);
     $pdf->SetX(168);
     $pdf->Write(0, $split[25]);
     $pdf->SetX(173);
     $pdf->Write(0, $split[26]);
     $pdf->SetX(178);
     $pdf->Write(0, $split[27]);
     $pdf->SetX(183);
     $pdf->Write(0, $split[28]);
     $pdf->SetX(188);
     $pdf->Write(0, $split[29]);
     //======== MNAME
     $split = str_split($pi->mname);
     // line break
     $pdf->Ln(6);
     $pdf->SetX(39);
     $pdf->Write(0, $split[0]);
     $pdf->SetX(44);
     $pdf->Write(0, $split[1]);
     $pdf->SetX(49);
     $pdf->Write(0, $split[2]);
     $pdf->SetX(54);
     $pdf->Write(0, $split[3]);
     $pdf->SetX(60);
     $pdf->Write(0, $split[4]);
     $pdf->SetX(65);
     $pdf->Write(0, $split[5]);
     $pdf->SetX(70);
     $pdf->Write(0, $split[6]);
     $pdf->SetX(75);
     $pdf->Write(0, $split[7]);
     $pdf->SetX(81);
     $pdf->Write(0, $split[8]);
     $pdf->SetX(86);
     $pdf->Write(0, $split[9]);
     $pdf->SetX(91);
     $pdf->Write(0, $split[10]);
     $pdf->SetX(96);
     $pdf->Write(0, $split[11]);
     $pdf->SetX(101);
     $pdf->Write(0, $split[12]);
     $pdf->SetX(106);
     $pdf->Write(0, $split[13]);
     $pdf->SetX(111);
     $pdf->Write(0, $split[14]);
     $pdf->SetX(116);
     $pdf->Write(0, $split[15]);
     $pdf->SetX(121);
     $pdf->Write(0, $split[16]);
     $pdf->SetX(126);
     $pdf->Write(0, $split[17]);
     $pdf->SetX(131);
     $pdf->Write(0, $split[18]);
     $pdf->SetX(137);
     $pdf->Write(0, $split[19]);
     $pdf->SetX(142);
     $pdf->Write(0, $split[20]);
     $pdf->SetX(147);
     $pdf->Write(0, $split[21]);
     $pdf->SetX(152);
     $pdf->Write(0, $split[22]);
     $pdf->SetX(157);
     $pdf->Write(0, $split[23]);
     $pdf->SetX(163);
     $pdf->Write(0, $split[24]);
     $pdf->SetX(168);
     $pdf->Write(0, $split[25]);
     $pdf->SetX(173);
     $pdf->Write(0, $split[26]);
     $pdf->SetX(178);
     $pdf->Write(0, $split[27]);
     $pdf->SetX(183);
     $pdf->Write(0, $split[28]);
     $pdf->SetX(188);
     $pdf->Write(0, $split[29]);
     $pdf->SetX(189);
     $pdf->Write(0, $pi->extension);
     $date = $pi->birth_date;
     list($year, $month, $day) = explode('-', $date);
     $pdf->Ln(6);
     $pdf->SetX(67);
     $pdf->Write(0, $month . '-' . $day . '-' . $year);
     $res_address = splitstroverflow($pi->res_address, 30);
     $pdf->SetX(126);
     $pdf->Write(0, $res_address[0]);
     $pdf->Ln(4);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->birth_place);
     $pdf->SetX(126);
     $pdf->Write(0, $res_address[1]);
     $pdf->Ln(5);
     if ($pi->sex == 'M') {
         $setx = 41.5;
     }
     if ($pi->sex == 'F') {
         $setx = 58;
     }
     $pdf->SetX($setx);
     $pdf->Write(0, 'X');
     if ($pi->civil_status == 1) {
         $pdf->SetXY(41.5, 85);
         $pdf->Write(0, 'X');
     }
     if ($pi->civil_status == 2) {
         $pdf->SetXY(41.5, 89);
         $pdf->Write(0, 'X');
     }
     if ($pi->civil_status == 3) {
         $pdf->SetXY(41.5, 94.5);
         $pdf->Write(0, 'X');
     }
     if ($pi->civil_status == 4) {
         $pdf->SetXY(64, 85);
         $pdf->Write(0, 'X');
     }
     if ($pi->civil_status == 5) {
         $pdf->SetXY(64, 89);
         $pdf->Write(0, 'X');
     }
     if ($pi->civil_status == 6) {
         $pdf->SetXY(64, 94.5);
         $pdf->Write(0, 'X');
     }
     //citizeship
     $pdf->SetXY(39, 103);
     $pdf->Write(0, $pi->citizenship);
     $pdf->Ln(5.2);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->height);
     $pdf->Ln(5.2);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->weight);
     $pdf->Ln(5.2);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->blood_type);
     $pdf->Ln(4);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->gsis);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->pagibig);
     $pdf->Ln(4);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->philhealth);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $pi->sss);
     $pdf->SetXY(126, 85);
     $pdf->Write(0, $pi->res_zip);
     $pdf->Ln(5);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->res_tel);
     $pdf->Ln(5);
     $pdf->SetX(126);
     $permanent_address = splitstroverflow($pi->permanent_address, 30);
     $pdf->Write(0, $permanent_address[0]);
     $pdf->Ln(4);
     $pdf->SetX(126);
     $pdf->Write(0, $permanent_address[1]);
     $pdf->Ln(15);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->permanent_zip);
     $pdf->Ln(4);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->permanent_tel);
     $pdf->Ln(4.3);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->email);
     $pdf->Ln(4.9);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->cp);
     $pdf->Ln(4.3);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->agency_employee_no);
     $pdf->Ln(4.3);
     $pdf->SetX(126);
     $pdf->Write(0, $pi->tin);
     /*******************************
      *END PERSONAL INFORMATION =====
      ******************************/
     //======================================================================
     /*******************************
      *START FAMILY BACK GROUND=======
      ******************************/
     //Get family background
     //$fb = $this->Family_Background->get_family_background($employee_id);
     $fb = new Family();
     $fb->get_by_employee_id($employee_id);
     $pdf->SetXY(39, 146);
     $pdf->Write(0, $fb->spouse_lname);
     $pdf->Ln(4.3);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_fname);
     $pdf->Ln(4.3);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_mname);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_occupation);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_employer);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_biz_ad);
     $pdf->Ln(5);
     $pdf->SetX(39);
     $pdf->Write(0, $fb->spouse_tel);
     $pdf->Ln(9);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->father_lname);
     $pdf->Ln(4.5);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->father_fname);
     $pdf->Ln(4.5);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->father_mname);
     $pdf->Ln(4.5);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->mother_lname);
     $pdf->Ln(4.5);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->mother_fname);
     $pdf->Ln(4.5);
     $pdf->SetX(57);
     $pdf->Write(0, $fb->mother_mname);
     /*******************************
      *END FAMILY BACK GROUND=======
      ******************************/
     //=============================================================================
     /*******************************
      *START CHILDREN================
      ******************************/
     //$children = $this->Children->get_child($employee_id);
     $children = new Children();
     $children->order_by('birth_date');
     $children->get_by_employee_id($employee_id);
     $pdf->SetXY(110, 145);
     $i = 1;
     $pdf->SetFont('Arial', '', 10);
     foreach ($children as $child) {
         if ($i == 7 || $i == 9 || $i == 11) {
             $pdf->Ln(4.5);
         } else {
             $pdf->Ln(5);
         }
         $pdf->SetX(110);
         $pdf->Write(0, $child->children);
         $date = $child->birth_date;
         list($year, $month, $day) = explode('-', $date);
         $pdf->SetX(170);
         $pdf->Write(0, $month . '/' . $day . '/' . $year);
         $i++;
     }
     /*******************************
      *END CHILDREN==================
      ******************************/
     //=====================================================================
     /*******************************
      *START EDUC==================
      ******************************/
     $e = new Education();
     //$educs = $this->Educational_Background->get_educ($employee_id, $level = 1);
     $educs = $e->get_single_educ($employee_id, $level = 1);
     $pdf->SetFont('Arial', '', 10);
     $pdf->SetXY(39, 233);
     //
     /*******************************
      *END EDUC==================
      ******************************/
     foreach ($educs as $educ) {
         $sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
         $sch = explode("|", $sch);
         //$degree = wordwrap($educ->degree_course, 15, "|");
         $degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
         $degree = explode("|", $degree);
         $pdf->Write(0, $sch[0]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[0]);
         $pdf->SetX(107);
         $pdf->Write(0, $educ->year_graduated);
         $pdf->SetX(130);
         $pdf->Write(0, $educ->highest_grade);
         $pdf->SetX(150);
         $pdf->Write(0, $educ->attend_from);
         $pdf->SetX(163);
         $pdf->Write(0, $educ->attend_to);
         $pdf->SetX(177);
         $pdf->Write(0, $educ->scholarship);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[1]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[1]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[2]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[2]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[3]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[3]);
     }
     //secondary
     // $educs = $this->Educational_Background->get_educ($employee_id, $level = 2);
     $educs = $e->get_single_educ($employee_id, $level = 2);
     $pdf->SetXY(39, 246);
     foreach ($educs as $educ) {
         //$sch = wordwrap($educ->school_name, 23, "|");
         $sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
         $sch = explode("|", $sch);
         //$degree = wordwrap($educ->degree_course, 15, "|");
         $degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
         $degree = explode("|", $degree);
         $pdf->Write(0, $sch[0]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[0]);
         $pdf->SetX(107);
         $pdf->Write(0, $educ->year_graduated);
         $pdf->SetX(130);
         $pdf->Write(0, $educ->highest_grade);
         $pdf->SetX(150);
         $pdf->Write(0, $educ->attend_from);
         $pdf->SetX(163);
         $pdf->Write(0, $educ->attend_to);
         $pdf->SetX(177);
         $pdf->Write(0, $educ->scholarship);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[1]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[1]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[2]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[2]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[3]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[3]);
     }
     //vocational
     // $educs = $this->Educational_Background->get_educ($employee_id, $level = 3);
     $educs = $e->get_single_educ($employee_id, $level = 3);
     $pdf->SetXY(39, 259);
     foreach ($educs as $educ) {
         //$sch = wordwrap($educ->school_name, 23, "|");
         $sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
         $sch = explode("|", $sch);
         //$degree = wordwrap($educ->degree_course, 15, "|");
         $degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
         $degree = explode("|", $degree);
         $pdf->Write(0, $sch[0]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[0]);
         $pdf->SetX(107);
         $pdf->Write(0, $educ->year_graduated);
         $pdf->SetX(130);
         $pdf->Write(0, $educ->highest_grade);
         $pdf->SetX(150);
         $pdf->Write(0, $educ->attend_from);
         $pdf->SetX(163);
         $pdf->Write(0, $educ->attend_to);
         $pdf->SetX(177);
         $pdf->Write(0, $educ->scholarship);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[1]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[1]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[2]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[2]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[3]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[3]);
     }
     //college
     // $educs = $this->Educational_Background->get_educ($employee_id, $level = 4);
     $educs = $e->get_single_educ($employee_id, $level = 4);
     $pdf->SetXY(39, 274);
     foreach ($educs as $educ) {
         //$sch = wordwrap($educ->school_name, 23, "|");
         $sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
         $sch = explode("|", $sch);
         //$degree = wordwrap($educ->degree_course, 15, "|");
         $degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
         $degree = explode("|", $degree);
         $pdf->Write(0, $sch[0]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[0]);
         $pdf->SetX(107);
         $pdf->Write(0, $educ->year_graduated);
         $pdf->SetX(130);
         $pdf->Write(0, $educ->highest_grade);
         $pdf->SetX(150);
         $pdf->Write(0, $educ->attend_from);
         $pdf->SetX(163);
         $pdf->Write(0, $educ->attend_to);
         $pdf->SetX(177);
         $pdf->Write(0, $educ->scholarship);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[1]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[1]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[2]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[2]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[3]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[3]);
     }
     //graduate studies
     //$educs = $this->Educational_Background->get_educ($employee_id, $level = 5);
     $educs = $e->get_single_educ($employee_id, $level = 5);
     $pdf->SetXY(39, 290);
     foreach ($educs as $educ) {
         //$sch = wordwrap($educ->school_name, 23, "|");
         $sch = wordwrap(ucwords(strtolower($educ->school_name)), 23, "|");
         $sch = explode("|", $sch);
         //$degree = wordwrap($educ->degree_course, 15, "|");
         $degree = wordwrap(ucwords(strtolower($educ->degree_course)), 15, "|");
         $degree = explode("|", $degree);
         $pdf->Write(0, $sch[0]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[0]);
         $pdf->SetX(107);
         $pdf->Write(0, $educ->year_graduated);
         $pdf->SetX(130);
         $pdf->Write(0, $educ->highest_grade);
         $pdf->SetX(150);
         $pdf->Write(0, $educ->attend_from);
         $pdf->SetX(163);
         $pdf->Write(0, $educ->attend_to);
         $pdf->SetX(177);
         $pdf->Write(0, $educ->scholarship);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[1]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[1]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[2]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[2]);
         $pdf->Ln(3);
         $pdf->SetX(39);
         $pdf->Write(0, $sch[3]);
         $pdf->SetX(78);
         $pdf->Write(0, $degree[3]);
     }
     // Output
     //$pdf->Output('resources/pdfs/archives/page1_'.$employee_id.'.pdf', 'F');
     $pdf->Output('dtr/template/pds/page1_' . $employee_id . '.pdf', 'F');
     $this->pds[] = 'dtr/template/pds/page1_' . $employee_id . '.pdf';
     //$this->pds[] = 'resources/pdfs/archives/page1_'.$employee_id.'.pdf';
     //header("location:".base_url()."resources/pdfs/archives/page1_".$employee_id.'.pdf');
 }