public function synchronize_patients()
{
$data['regimens'] = Regimen::getAll();
$data['supporters'] = Supporter::getAll();
$data['service_types'] = Regimen_Service_Type::getAll();
$data['sources'] = Patient_Source::getAll();
$data['drugs'] = Drugcode::getAll();
$data['regimen_change_purpose'] = Regimen_Change_Purpose::getAll();
$data['visit_purpose'] = Visit_Purpose::getAll();
$data['opportunistic_infections'] = Opportunistic_Infection::getAll();
$data['regimen_drugs'] = Regimen_Drug::getAll();
}
public function listing()
{
$access_level = $this->session->userdata('user_indicator');
$source = 0;
if ($access_level == "pharmacist") {
$source = $this->session->userdata('facility');
}
$data = array();
$data['styles'] = array("jquery-ui.css");
$data['scripts'] = array("jquery-ui.js");
$data['regimens'] = Regimen::getAll($source);
$data['regimens_enabled'] = Regimen::getAllEnabled($source);
$data['regimen_categories'] = Regimen_Category::getAll();
$data['regimen_service_types'] = Regimen_Service_Type::getAll();
$data['drug_codes'] = Drugcode::getAll($source);
$data['drug_codes_enabled'] = Drugcode::getAllEnabled($source);
$this->base_params($data);
}
public function listing()
{
$access_level = $this->session->userdata('user_indicator');
$source = 0;
if ($access_level == "pharmacist") {
$source = $this->session->userdata('facility');
}
$data = array();
$data['content_view'] = "regimen_listing_v";
$data['styles'] = array("jquery-ui.css");
$data['scripts'] = array("jquery-ui.js");
$regimens = Regimen::getAllHydrated($source, $access_level);
$tmpl = array('table_open' => '<table id="regimen_setting" class="table table-bordered table-hover table-striped setting_table">');
$this->table->set_template($tmpl);
$this->table->set_heading('id', 'Regimen', 'Line', 'Regimen Category', 'Type Of Service', 'Options');
foreach ($regimens as $regimen) {
$links = "";
$drug = $regimen['id'];
$type_of_service = $regimen['Regimen_Service_Type'];
//if($type_of_service!="ART" && $access_level!="system_administrator"){
if ($access_level != "facility_administrator") {
$array_param = array('id' => $regimen['id'], 'role' => 'button', 'class' => 'edit_user', 'data-toggle' => 'modal');
if ($regimen['Enabled'] == 1) {
//$links .= anchor('' . $regimen['id'], 'Edit', array('class' => 'edit_user','id'=>$regimen['id']));
$links .= anchor('#edit_form', 'Edit', $array_param);
}
} elseif ($access_level == "facility_administrator") {
//href="#entry_form" role="button" id="new_regimen" class="btn" data-toggle="modal"
$array_param = array('id' => $regimen['id'], 'role' => 'button', 'class' => 'edit_user', 'data-toggle' => 'modal');
if ($regimen['Enabled'] == 1) {
$links .= anchor('#edit_form', 'Edit', $array_param);
}
}
if ($regimen['Enabled'] == 1 && @$regimen['Merged_To']) {
$links .= " | ";
$links .= anchor('regimen_management/disable/' . $regimen['id'], 'Disable', array('class' => 'disable_user actual'));
}
if ($regimen['Enabled'] == 1 && @$regimen['Merged_To'] == "" && $access_level == "facility_administrator") {
$links .= " | ";
$links .= anchor('regimen_management/disable/' . $regimen['id'], 'Disable', array('class' => 'disable_user actual'));
$links .= " | ";
$links .= "<a href='#' class='merge_drug' id='{$drug}'>Merge</a>";
}
if ($regimen['Enabled'] == 0 && $access_level == "facility_administrator") {
$links .= anchor('regimen_management/enable/' . $regimen['id'], 'Enable', array('class' => 'enable_user actual'));
}
if ($regimen['Merged_To'] != '') {
if ($access_level == "facility_administrator") {
$links .= " | ";
$links .= anchor('regimen_management/unmerge/' . $regimen['id'], 'Unmerge', array('class' => 'unmerge_drug'));
}
$checkbox = "<input type='checkbox' name='drugcodes' id='drugcodes' class='drugcodes' value='{$drug}' disabled/>";
} else {
$checkbox = "<input type='checkbox' name='drugcodes' id='drugcodes' class='drugcodes' value='{$drug}'/>";
}
$mapped = "";
if ($regimen['map'] != 0) {
$mapped = "<b>(mapped)</b>";
}
if ($regimen['Regimen_Code']) {
$regimen_code = $regimen['Regimen_Code'] . " | " . $regimen['Regimen_Desc'];
} else {
$regimen_code = $regimen['Regimen_Desc'];
}
$this->table->add_row($regimen['id'], $checkbox . "" . $regimen_code . " " . $mapped, $regimen['Line'], $regimen['Regimen_Category'], $regimen['Regimen_Service_Type'], $links);
}
$data['access_level'] = $access_level;
$data['regimens'] = $this->table->generate();
$data['regimen_categories'] = Regimen_Category::getAll();
$data['regimen_service_types'] = Regimen_Service_Type::getAll();
$sql = "SELECT s.id,s.code,s.name,sr.Name as category_name,s.category_id\n FROM sync_regimen s \n LEFT JOIN sync_regimen_category sr ON sr.id = s.category_id\n WHERE s.id NOT IN(SELECT r.map\n FROM regimen r\n WHERE r.map !='0')\n OR s.name LIKE '%other%'\n OR s.code LIKE '%x%'\n ORDER BY s.category_id,s.code asc";
$query = $this->db->query($sql);
$unmapped_regimens = $query->result_array();
$sync_regimens = Sync_Regimen::getActive();
$data['edit_mappings'] = $unmapped_regimens;
$data['mappings'] = $sync_regimens;
$this->base_params($data);
}
public function load_form($form_id = NULL)
{
if ($form_id == "patient_details") {
$data['pob'] = District::getItems();
$data['gender'] = Gender::getItems();
$data['current_status'] = Patient_Status::getItems();
$data['source'] = Patient_Source::getItems();
$data['drug_prophylaxis'] = Drug_Prophylaxis::getItems();
$data['service'] = Regimen_Service_Type::getItems();
$data['fplan'] = Family_Planning::getItems();
$data['other_illnesses'] = Other_Illnesses::getItems();
$data['pep_reason'] = Pep_Reason::getItems();
$data['drug_allergies'] = Drugcode::getItems();
$regimens = Regimen::getItems();
$data['start_regimen'] = $regimens;
$data['current_regimen'] = $regimens;
$data['who_stage'] = Who_Stage::getItems();
//Get facilities beacuse of UTF-8 encoding
$this->db->select('facilitycode AS id, name AS Name');
$query = $this->db->get('facilities');
$facilities = $query->result_array();
foreach ($facilities as $facility) {
$facility_list[] = array('id' => $facility['id'], 'Name' => utf8_encode($facility['Name']));
}
$data['transfer_from'] = $facility_list;
}
echo json_encode($data);
}
public function graph_patients_enrolled_in_year($year = "")
{
$main_array = array();
$facility_code = $this->session->userdata('facility');
$months = array('1' => 'Jan', '2' => 'Feb', '3' => 'Mar', '4' => 'Apr', '5' => 'May', '6' => 'Jun', '7' => 'Jul', '8' => 'Aug', '9' => 'Sep', '10' => 'Oct', '11' => 'Nov', '12' => 'Dec');
$services_data = Regimen_Service_Type::getHydratedAll();
foreach ($services_data as $service) {
$services[] = $service['Name'];
}
//Loop through all services
foreach ($services as $service) {
$service_array = array();
$month_data = array();
$service_array['name'] = $service;
//Loop through all months
foreach ($months as $month => $month_name) {
$sql = "SELECT COUNT(*) AS total\n\t\t\t\t\t FROM patient p \n\t\t\t\t\t LEFT JOIN regimen_service_type rst ON p.service=rst.id\n\t\t\t\t\t WHERE YEAR(p.date_enrolled)='{$year}' \n\t\t\t\t\t AND MONTH(p.date_enrolled)='{$month}'\n\t\t\t\t\t AND rst.name LIKE '%{$service}%'\n\t\t\t\t\t AND p.facility_code='{$facility_code}'";
$query = $this->db->query($sql);
$results = $query->result_array();
if ($results) {
$month_data[] = @(int) $results[0]['total'];
} else {
$month_data[] = 0;
}
}
$service_array['data'] = $month_data;
//append service data to main array
$main_array[] = $service_array;
}
//chart data
$resultArray = json_encode($main_array);
$categories = json_encode(array_values($months));
//chart settings
$data['resultArraySize'] = 7;
$data['container'] = 'chart_sales';
$data['chartType'] = 'line';
$data['title'] = 'Chart';
$data['chartTitle'] = 'Listing of Patients Enrolled for the Year: ' . $year;
$data['categories'] = $categories;
$data['xAxix'] = 'Months of the Year';
$data['suffix'] = '';
$data['yAxix'] = 'Totals';
$data['resultArray'] = $resultArray;
$data['graphs'] = $this->load->view('graph_v', $data, TRUE);
$data['title'] = "webADT | Reports";
$data['hide_side_menu'] = 1;
$data['banner_text'] = "Facility Reports";
$data['selected_report_type_link'] = "standard_report_row";
$data['selected_report_type'] = "Standard Reports";
$data['report_title'] = "Graph of Number of Patients Enrolled Per Month in a Given Year";
$data['facility_name'] = $this->session->userdata('facility_name');
$data['content_view'] = 'reports/graphs_on_patients_v';
$this->load->view('template', $data);
}
