Ejemplo n.º 1
0
 function index()
 {
     $sess_now = sessNow() - 1;
     $sess_now = sessNow();
     //TABLE COMPONENT_VALUE;
     $master = getAll('payroll_master', array('session_id' => 'where/' . date('year') - 1));
     foreach ($master->result() as $m) {
         $masterz = array('employee_id' => $m->employee_id, 'session_id' => $m->session_id);
         $m_num_rows = getAll('payroll_master', array('session_id' => 'where/' . $sess_now, 'employee_id' => 'where/' . $m->employee_id))->num_rows();
         if ($m_num_rows > 0) {
             $this->db->where('session_id', $sess_now)->where('employee_id', $m->employee_id)->update('payroll_master', $masterz);
             $m_id = getValue('id', 'payroll_master', array('session_id' => 'where/' . $sess_now, 'employee_id' => 'where/' . $m->employee_id));
         } else {
             $this->db->insert('payroll_master', $masterz);
             $m_id = $this->db->insert_id();
         }
         $m_comp = getAll('payroll_master_component', array('payroll_master_id' => 'where/' . $m->id));
         foreach ($m_comp->result() as $m_c) {
             $m_compz = array('payroll_master_id' => $m_id, 'payroll_component_id' => $m_c->payroll_component_id, 'value' => $m_c->value);
             $m_comp_num_rows = getAll('payroll_master_component', array('payroll_master_id' => 'where/' . $m_id))->num_rows();
             if ($m_comp_num_rows > 0) {
                 $this->db->where('payroll_master_id', $m_id)->update('payroll_master_component', $m_compz);
             } else {
                 $this->db->insert('payroll_master_component', $m_compz);
             }
         }
     }
     echo json_encode(array("result" => TRUE));
 }
Ejemplo n.º 2
0
 public function generate_new_session()
 {
     $sess_now = sessNow();
     $sess_now = 2016;
     //TABLE COMPONENT_VALUE;
     $comp = getAll('payroll_component_value', array('session_id' => 'where/' . date('year') - 1));
     foreach ($comp->result() as $c) {
         $component = array('session_id' => $sess_now, 'payroll_component_id' => $c->payroll_component_id, 'formula' => $c->formula, 'is_condition' => $c->is_condition, 'min' => $c->min, 'max' => $c->max);
         $c_num_rows = getAll('payroll_component_value', array('session_id' => 'where/' . $sess_now, 'payroll_component_id' => 'where/' . $c->payroll_component_id))->num_rows();
         if ($c_num_rows > 0) {
             $this->db->where('session_id', $sess_now)->where('payroll_component_id', $c->payroll_component_id)->update('payroll_component_value', $component);
         } else {
             $this->db->insert('payroll_component_value', $component);
         }
     }
     $master = getAll('payroll_master', array('session_id' => 'where/' . date('year') - 1));
     foreach ($master->result() as $m) {
         $masterz = array('employee_id' => $m->employee_id, 'session_id' => $m->session_id);
         $m_num_rows = getAll('payroll_master', array('session_id' => 'where/' . $sess_now, 'employee_id' => 'where/' . $m->employee_id))->num_rows();
         if ($m_num_rows > 0) {
             $this->db->where('session_id', $sess_now)->where('employee_id', $m->employee_id)->update('payroll_master', $masterz);
             $m_id = getValue('id', 'payroll_master', array('session_id' => 'where/' . $sess_now, 'employee_id' => 'where/' . $m->employee_id));
         } else {
             $this->db->insert('payroll_master', $masterz);
             $m_id = $this->db->insert_id();
         }
         $m_comp = getAll('payroll_master_component', array('payroll_master_id' => 'where/' . $m->id));
         foreach ($m_comp->result() as $m_c) {
             $m_compz = array('payroll_master_id' => $m_id, 'payroll_component_id' => $m_c->payroll_component_id, 'value' => $m_c->value);
             $m_comp_num_rows = getAll('payroll_master_component', array('payroll_master_id' => 'where/' . $m_id))->num_rows();
             if ($m_comp_num_rows > 0) {
                 $this->db->where('payroll_master_id', $m_id)->update('payroll_master_component', $m_compz);
             } else {
                 $this->db->insert('payroll_master_component', $m_compz);
             }
         }
     }
     echo json_encode(array("result" => TRUE));
 }
Ejemplo n.º 3
0
                <!--Tab COLA-->
                <div class="tab-pane fade" id="tab-cola">
                    <div class="container-fluid container-fullw bg-white">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="cola">
                                    <div class="row">
                                        <div class="col-md-2">
                                            <label class="label-form">Select Session</label>
                                        </div>
                                        <div class="col-md-3">
                                            <select class="select2" id="session_select_cola" style="width:100%">
                                                <option>-- Select Session --</option>
                                                <?php 
foreach ($session->result() as $s) {
    $selected = $s->id == sessNow() ? "selected='selected'" : '';
    ?>
                                                    <option value="<?php 
    echo $s->id;
    ?>
" <?php 
    echo $selected;
    ?>
><?php 
    echo $s->description;
    ?>
</option>
                                                <?php 
}
?>
                                            </select>
Ejemplo n.º 4
0
Archivo: add.php Proyecto: pay-test/ci2
}
?>
                                  </select>
                                  <span class="help-block"></span>
                                </div>
                              </div>
                            </div>
                            <div class="col-md-7">
                              <div class="col-md-12">
                                  <label class="control-label col-md-3">Session</label>
                                  <div class="col-md-9">
                                      <select name="session_id" class="form-control">
                                        <?php 
if ($session_id->num_rows() > 0) {
    foreach ($session_id->result() as $sess) {
        $selected = $sess->id == sessNow() ? 'selected="selected"' : '';
        ?>
                                            <option value="<?php 
        echo $sess->id;
        ?>
" <?php 
        echo $selected;
        ?>
><?php 
        echo $sess->id;
        ?>
</option>
                                        <?php 
    }
}
?>