public function disable($regimen_drug_id)
{
$this->load->database();
$query = $this->db->query("UPDATE regimen_drug SET active='0'WHERE drugcode='{$regimen_drug_id}'");
$results = Drugcode::getDrugCode($regimen_drug_id);
//$this -> session -> set_userdata('message_counter', '2');
$this->session->set_userdata('msg_error', $results->Drug . ' was disabled!');
redirect('settings_management');
}
public function unmerge($drugcode)
{
$this->load->database();
//First Query that umerges the drug_code
$the_query = "UPDATE drugcode SET merged_to='' WHERE id='{$drugcode}';";
$this->db->query($the_query);
//Second Query that updates drug_stock_movement table to unmerge all drug id's that match the merged_from column
$the_query = "UPDATE drug_stock_movement SET drug='{$drugcode}',merged_from='' WHERE merged_from='{$drugcode}';";
$this->db->query($the_query);
//Third Query that updates patient_visit table to unmerge all drug id's that match the merged_from column
$the_query = "UPDATE patient_visit SET drug_id='{$drugcode}',merged_from='' WHERE merged_from='{$drugcode}';";
$this->db->query($the_query);
//Final Query that updates regimen_drug table to unmerge all drug id's that match the merged_from column
$the_query = "UPDATE regimen_drug SET drugcode='{$drugcode}',merged_from='' WHERE merged_from='{$drugcode}';";
$this->db->query($the_query);
$results = Drugcode::getDrugCode($drugcode);
$this->session->set_userdata('message_counter', '1');
$this->session->set_userdata('msg_error', $results->Drug . ' was unmerged!');
redirect('settings_management');
}
