Esempio n. 1
0
 private function cek_position_competency($position_id, $competency_def_id)
 {
     $f_ = array('competency_def_id' => 'where/' . $competency_def_id, 'position_id' => 'where/' . $position_id, 'is_deleted' => 'where/0');
     $q_ = GetAll_('position_competency', $f_);
     if ($q_->num_rows() > 0) {
         return TRUE;
     } else {
         return FALSE;
     }
 }
Esempio n. 2
0
</label>
                                </div>
                                <div class="col-md-8">
                                    <select name="competency_def<?php 
        echo $row['id'];
        ?>
[]" class="select2" id="competency<?php 
        echo $row['id'];
        ?>
_def<?php 
        echo $user->id;
        ?>
" style="width:100%" placeholder="Competency" multiple>
                                    <?php 
        $f_competency_def = array('is_deleted' => "where/0", 'comp_group_id' => "where/" . $row['id'], 'title' => "order/asc");
        $q_competency_def = GetAll_('competency_def', $f_competency_def);
        $competency_def = $q_competency_def->num_rows() > 0 ? $q_competency_def : array();
        foreach ($competency_def->result_array() as $value) {
            echo '<option value="' . $value['id'] . '" >' . $value['title'] . '</option>';
        }
        ?>
                                    </select>
                                </div>
                            </div>

                            <div id="position_conpetency_div">
                            <?php 
        $f_position_competency = array('position_competency.is_deleted' => "where/0", 'position_competency.position_id' => "where/" . $user->id, 'competency_def.comp_group_id' => "where/" . $row['id']);
        $q_competency_def = GetJoin('position_competency', 'competency_def', 'position_competency.competency_def_id = competency_def.id', 'left', 'position_competency.id as id,position_competency.position_id as position_id,position_competency.itj as itj,competency_def.title as competency_title', $f_position_competency);
        if ($q_competency_def->num_rows() > 0) {
            ?>