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