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");
}
