public static function save_facility_evaluation($data_array)
{
$facility_code = $data_array['facility_code'];
$user_id = $data_array['assessor'];
$query = Doctrine_Query::create()->select("*")->from("facility_evaluation")->where("facility_code={$facility_code} and assessor={$user_id}");
$level = $query->execute();
if (count($level) == 0) {
$o = new Facility_Evaluation();
$o->fromArray($data_array);
$o->save();
return "saved ";
} else {
$query = "update facility_evaluation set";
foreach ($data_array as $key => $value) {
$query .= "`{$key}`='{$value}',";
}
$query = substr($query, 0, -1);
$query .= "where facility_code={$facility_code} and assessor={$user_id}";
$inserttransaction1 = Doctrine_Manager::getInstance()->getCurrentConnection()->execute("{$query}");
return "updated";
}
}
public function save_facility_evaluation()
{
$facility_code = $this->session->userdata('facility_id');
$current_user = $this->session->userdata('user_id');
$date = date('y-m-d');
$data_array = $_POST['data_array'];
$dataarray = explode("|", $data_array);
$f_headno = $dataarray[0];
$f_depheadno = $dataarray[1];
$nurse_no = $dataarray[2];
$store_mgrno = $dataarray[3];
$p_techno = $dataarray[4];
$trainer = $dataarray[5];
$comp_avail = $dataarray[6];
$modem_avail = $dataarray[7];
$bundles_avail = $dataarray[8];
$manuals_avail = $dataarray[9];
$satisfaction_lvl = $dataarray[10];
$agreed_time = $dataarray[11];
$feedback = $dataarray[12];
$pharm_supervision = $dataarray[13];
$coord_supervision = $dataarray[14];
$req_id = $dataarray[15];
$req_spec = $dataarray[16];
$req_addr = $dataarray[17];
$train_remarks = $dataarray[18];
$train_recommend = $dataarray[19];
$train_useful = $dataarray[20];
$comf_issue = $dataarray[21];
$comf_order = $dataarray[22];
$comf_update = $dataarray[23];
$comf_gen = $dataarray[24];
$use_freq = $dataarray[25];
$freq_spec = $dataarray[26];
$improvement = $dataarray[27];
$ease_of_use = $dataarray[28];
$meet_expect = $dataarray[29];
$expect_suggest = $dataarray[30];
$retrain = $dataarray[31];
$mydata = array('facility_code' => $facility_code, 'assessor' => $current_user, 'date' => $date, 'fhead_no' => $f_headno, 'fdep_no' => $f_depheadno, 'nurse_no' => $nurse_no, 'sman_no' => $store_mgrno, 'ptech_no' => $p_techno, 'trainer' => $trainer, 'comp_avail' => $comp_avail, 'modem_avail' => $modem_avail, 'bundles_avail' => $bundles_avail, 'manuals_avail' => $manuals_avail, 'satisfaction_lvl' => $satisfaction_lvl, 'agreed_time' => $agreed_time, 'feedback' => $feedback, 'pharm_supervision' => $pharm_supervision, 'coord_supervision' => $coord_supervision, 'req_id' => $req_id, 'req_spec' => $req_spec, 'req_addr' => $req_addr, 'train_remarks' => $train_remarks, 'train_recommend' => $train_recommend, 'train_useful' => $train_useful, 'comf_issue' => $comf_issue, 'comf_order' => $comf_order, 'comf_update' => $comf_update, 'comf_gen' => $comf_gen, 'use_freq' => $use_freq, 'freq_spec' => $freq_spec, 'improvement' => $improvement, 'ease_of_use' => $ease_of_use, 'meet_expect' => $meet_expect, 'expect_suggest' => $expect_suggest, 'retrain' => $retrain);
echo Facility_Evaluation::save_facility_evaluation($mydata);
$facility_code = $this->session->userdata('facility_id');
$data['content_view'] = "facility/facility_reports/reports_v";
$data['report_view'] = "facility/facility_reports/potential_expiries_v";
$data['report_data'] = Facility_stocks::potential_expiries($facility_code);
$data['active_panel'] = 'expiries';
$view = 'shared_files/template/template';
}
public function get_facility_evaluation_data($facility_code)
{
$data = Facility_Evaluation::get_people_who_have_responded($facility_code);
$table_data = '<table cellspacing="0" border="0" width="100%"><tr><th>Responednt</th><th>Trainer</th><th>Date</th><th>view</th></tr>';
foreach ($data as $key => $facility_data) {
$date = date('d M Y', strtotime($facility_data['date_created']));
$table_data .= "<tr><td>{$facility_data['fname']} {$facility_data['lname']} </td><td>{$facility_data['trainer']} </td><td>{$date}</td>\n\t<td><a href='" . base_url() . "report_management/facility_evaluation/{$facility_data['facility_code']}/{$facility_data['assessor']}' class='link'>view response</a></td></tr>";
}
echo $table_data . "</table>";
}
