public function unmerge($drugcode)
{
$this->load->database();
//First Query that umerges the regimen
$the_query = "UPDATE regimen SET merged_to='' WHERE id='{$drugcode}';";
$this->db->query($the_query);
//Second Query that updates patient table start_regimen
$the_query = "UPDATE patient SET start_regimen='{$drugcode}',start_regimen_merged_from='' WHERE start_regimen_merged_from='{$drugcode}';";
$this->db->query($the_query);
//Third Query that updates patient table current_regimen
$the_query = "UPDATE patient SET current_regimen='{$drugcode}',current_regimen_merged_from='' WHERE current_regimen_merged_from='{$drugcode}';";
$this->db->query($the_query);
//Fourth Query that updates patient_visit table
$the_query = "UPDATE patient_visit SET regimen='{$drugcode}',regimen_merged_from='' WHERE regimen_merged_from='{$drugcode}';";
$this->db->query($the_query);
//Fifth Query that updates patient_visit table last regimen
$the_query = "UPDATE patient_visit SET last_regimen='{$drugcode}',last_regimen_merged_from='' WHERE last_regimen_merged_from='{$drugcode}';";
$this->db->query($the_query);
//Final Query that updates regimen_drug table
$the_query = "UPDATE regimen_drug SET regimen='{$drugcode}',regimen_merged_from='' WHERE regimen_merged_from='{$drugcode}';";
$this->db->query($the_query);
$results = Regimen::getRegimen($drugcode);
$this->session->set_userdata('message_counter', '1');
$this->session->set_userdata('msg_error', $results->Regimen_Code . ' was Unmerged');
redirect('settings_management');
}
