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