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