public function all_implants() { //implant administration $genModel = model_load_model('generic_model'); $viewData['impAdmin'] = $genModel->get_all_implants(); load_fullview('implant_administration_view', $viewData); }
public function all_wastages() { $target = 'all_wastages'; $viewData['target'] = $target; $genModel = model_load_model('generic_model'); $viewData['wastages'] = $genModel->get_report_all_wastages(); load_fullview('reports/report_template', $viewData); }
public function edit_wastage() { $Id = $this->input->get_post('id'); $where = array('id' => $Id); $basicModel = load_basic_model('wastage'); $viewData['wastageData'] = $basicModel->get($where, 1); load_fullview('edit_wastage_view', $viewData); }
public function edit_batch() { check_session(); $Id = $this->input->get_post('id'); $where = array('drug_batch_id' => $Id); $basicModel = load_basic_model('drug_batch'); $viewData['batchData'] = $basicModel->get($where, 1); // print_array( $viewData['batchData']); load_fullview('edit_batch_view', $viewData); }
public function edit_site_map() { $curUser = currentuser_session(); if ($curUser['user_role'] != 1) { redirect(base_url()); } $Id = $this->input->get_post('id'); $where = array('site_map_id' => $Id); $basicModel = load_basic_model('site_mapping'); $viewData['siteMapData'] = $basicModel->get($where, 1); // print_array( $viewData['batchData']); load_fullview('edit_site_map_view', $viewData); }
public function edit_delivery() { $Id = $this->input->get_post('id'); $where = array('id' => $Id); $basicModel = load_basic_model('deliveries'); $viewData['deliveryData'] = $basicModel->get($where, 1); //get all sites data $sitesModel = load_basic_model('sites'); $viewData['sites'] = $sitesModel->get(); //get all batch data $batchModel = load_basic_model('drug_batch'); $viewData['batches'] = $batchModel->get(); load_fullview('edit_delivery_view', $viewData); }
public function index() { load_fullview('ae_mapping/ae_map_view'); }
public function batch_mapping() { $curUser = currentuser_session(); if ($curUser['user_role'] != 1) { redirect(base_url()); } $batchMapModal = load_basic_model('batch_mapping'); $viewData['batchMapData'] = $batchMapModal->get(); load_fullview('batch_map_view', $viewData); }
public function edit_user() { check_session(); $userId = $this->input->get_post('uid'); $where = array('user_id' => $userId); $basicModel = load_basic_model('users'); $viewData['userData'] = $basicModel->get($where, 1); // get user roles $roleModel = load_basic_model('user_roles'); $viewData['userRoles'] = $roleModel->get(); load_fullview('edit_user_view', $viewData); }
public function search() { $search_text = trim(mysql_real_escape_string($this->input->post('search'))); if (strlen($search_text) == 0) { $this->session->set_flashdata('error', 'Blank string not allowed in search..'); redirect(base_url()); } $result_in_tables = 0; $basicModel = load_basic_model(""); // table count in the database // $sql = 'show tables'; // $tables = $basicModel->explicit($sql); $tables = array('deliveries', 'wastage', 'sites', 'drug_batch'); for ($i = 0; $i < sizeof($tables); $i++) { // @abstract for each table of the db seaching text // $sql = 'select count(*) from ' . $tables[$i]['Tables_in_' . $this->db->database]; $sql = 'select count(*) AS count from ' . $tables[$i]; $numCols = $basicModel->explicit($sql); if ($numCols[0]['count'] > 0) { $sql = 'desc ' . $tables[$i]; $collumns = $basicModel->explicit($sql); $search_sql = 'select * from ' . $tables[$i] . ' WHERE '; $no_varchar_field = 0; for ($j = 0; $j < sizeof($collumns); $j++) { if (preg_match('/(id|date|created|number)/', $collumns[$j]['Field'])) { continue; } if ($no_varchar_field != 0) { $search_sql .= ' or '; } $search_sql .= 'lower(`' . $collumns[$j]['Field'] . '`) like \'%' . $search_text . '%\' '; $no_varchar_field++; } if ($no_varchar_field > 0) { $search_result = $basicModel->explicit($search_sql); if (sizeof($search_result)) { $result_in_tables++; $viewData['search_result'][$tables[$i]] = $search_result; } // else{ // $viewData['search_result'] = array(); // } } } } // print_array($viewData);exit; if (empty($viewData['search_result'])) { $viewData['search_result'] = array(); } $viewData['search_text'] = $search_text; load_fullview('search_view', $viewData); }
public function batch_report() { $basicModal = load_basic_model('clinical_data'); $viewData['clinicalData'] = $basicModal->get(); load_fullview('batch-report-view', $viewData); }