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; } }
</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) { ?>