public function listing() { $access_level = $this->session->userdata('user_indicator'); $source = 0; if ($access_level == "pharmacist") { $source = $this->session->userdata('facility'); } $data = array(); $drugcodes = Drugcode::getAll($source, $access_level); $tmpl = array('table_open' => '<table id="drugcode_setting" class="setting_table table table-bordered table-striped">'); $this->table->set_template($tmpl); $this->table->set_heading('id', 'Drug', 'Unit', 'Dose', 'Supplier', 'Options'); foreach ($drugcodes as $drugcode) { $array_param = array('id' => $drugcode['id'], 'role' => 'button', 'class' => 'edit_user', 'data-toggle' => 'modal'); $links = ""; if ($drugcode['Enabled'] == 1) { $links .= anchor('#edit_drugcode', 'Edit', $array_param); } $drug = $drugcode['id']; if ($drugcode['Enabled'] == 1 && $access_level == "facility_administrator") { $links .= " | "; $links .= anchor('drugcode_management/disable/' . $drugcode['id'], 'Disable', array('class' => 'disable_user')); $links .= " | "; $links .= "<a href='#' class='merge_drug' id='{$drug}'>Merge</a>"; } elseif ($access_level == "facility_administrator") { $links .= anchor('drugcode_management/enable/' . $drugcode['id'], 'Enable', array('class' => 'enable_user')); } if ($drugcode['Merged_To'] != '') { if ($access_level == "facility_administrator") { $links .= " | "; $links .= anchor('drugcode_management/unmerge/' . $drugcode['id'], 'Unmerge', array('class' => 'unmerge_drug')); } $checkbox = "<input type='checkbox' name='drugcodes' id='drugcodes' class='drugcodes' value='{$drug}' disabled/>"; } else { $checkbox = "<input type='checkbox' name='drugcodes' id='drugcodes' class='drugcodes' value='{$drug}'/>"; } $mapped = ""; if ($drugcode['map'] != 0) { $mapped = "<b>(mapped)</b>"; } $this->table->add_row($drugcode['id'], $checkbox . " " . strtoupper($drugcode['Drug']) . " " . $mapped, "<b>" . $drugcode['drug_unit'] . "</b>", "<b>" . $drugcode['Dose'] . "</b>", "<b>" . $drugcode['supplier'] . "</b>", $links); } $data['drugcodes'] = $this->table->generate(); $data['suppliers'] = Drug_Source::getAllHydrated(); $data['classifications'] = Drug_Classification::getAllHydrated($access_level, "0"); $query = $this->db->query("SELECT s.id,CONCAT_WS('] ',CONCAT_WS(' [',s.name,s.abbreviation),CONCAT_WS(' | ',s.strength,s.formulation)) as name,s.packsize\n FROM sync_drug s \n WHERE s.id NOT IN(SELECT dc.map\n FROM drugcode dc\n WHERE dc.map !='0')\n AND (s.category_id='1' or s.category_id='2' or s.category_id='3')\n ORDER BY name asc"); $data['edit_mappings'] = $query->result_array(); $data['mappings'] = Sync_Drug::getActive(); $data['instructions'] = Drug_instructions::getAllInstructions(); $this->base_params($data); }
public function disable($classification_id) { $query = $this->db->query("UPDATE drug_classification SET Active='0'WHERE id='{$classification_id}'"); $results = Drug_Classification::getClassification($classification_id); $this->session->set_userdata('msg_error', $results->Name . ' was disabled'); $this->session->set_flashdata('filter_datatable', $results->Name); //Filter datatable redirect("settings_management"); }