Ejemplo n.º 1
0
 function index($year = '2009')
 {
     $data['page_name'] = '<b>Plantilla of Personnel</b>';
     $data['msg'] = '';
     $data['error_msg'] = '';
     // Use for office listbox
     $data['options'] = $this->options->office_options();
     $data['selected'] = Input::get('office_id') ? Input::get('office_id') : Session::get('office_id');
     $data['year_options'] = $this->options->year_options(date('Y') - 5, date('Y') + 3);
     //2010 - 2020
     $data['year_selected'] = Input::get('year') ? Input::get('year') : date('Y');
     $office_id = $data['selected'];
     $this->Employee->fields = array('id', 'employee_id', 'office_id', 'lname', 'fname', 'mname');
     if ($office_id != '') {
         $p = new Plantilla_item();
         $data['rows'] = $p->get_by_office_id($office_id);
     }
     //
     $data['year'] = $year;
     foreach ($data['rows'] as $row) {
         $c = new Plantilla_m();
         $c->where('employee_id', $row->id);
         $c->where('year', $year);
         $c->get();
         if ($c->exists()) {
             //echo 'cool';
         } else {
             $c->employee_id = $row->id;
             $c->year = $year;
             //$c->type 			= 'balance';
             //$c->save();
             //echo 'not cool';
         }
     }
     if (Input::get('op')) {
     }
     $data['main_content'] = 'plantilla/index';
     return View::make('includes/template', $data);
 }
Ejemplo n.º 2
0
	  <th width="35%" bgcolor="#D6D6D6"><strong>Name of Incumbent</strong></th>
	  <th width="12%" bgcolor="#D6D6D6">Year</th>
	  <th width="7%" bgcolor="#D6D6D6">SG</th>
	  <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