public function facilities() { $facilities = LiveData::select('*')->from('vl_facilities'); if (!empty(\Auth::user()->hub_id)) { $facilities = $facilities->where('hubID', \Auth::user()->hub_id)->get(); } elseif (!empty(\Auth::user()->facility_id)) { $facilities = $facilities->where('id', \Auth::user()->facility_id); } return view('results.facilities', compact('facilities')); }
public function edit_user($id) { $user = User::findOrFail($id); if (\Request::has('edit')) { $data = \Request::all(); $user->update($data); return redirect('admin/list_users')->with('msge', "saving successful"); } else { $hubs = LiveData::getHubs(); $facilities = LiveData::getFacilities(); $hubs = \MyHTML::get_arr_pair($hubs, 'hub'); $facilities = \MyHTML::get_arr_pair($facilities, 'facility'); return view('auth.edit_user', compact('hubs', 'facilities', 'user', 'id')); } }
public function qc($id) { $now = date("Y-m-d H:i:s"); $qc_by = \Auth::user()->email; if (\Request::has('samples')) { $samples = \Request::get('samples'); $sql = "INSERT INTO vl_facility_printing (sample_id, qc_at, qc_by) VALUES "; foreach ($samples as $sample_id) { $sql .= "({$sample_id}, '{$now}', '{$qc_by}'),"; } $sql = trim($sql, ","); \DB::connection('live_db')->unprepared($sql); redirect("/qc/{$id}/"); } $samples = LiveData::worksheetSamples($id); $wk = LiveData::select("*")->from("vl_samples_worksheetcredentials")->where('id', '=', $id)->limit(1)->get(); $wk = $wk[0]; return view('qc.qc', compact('samples', 'id', 'wk')); }
public static function getIPs() { return LiveData::select('id', 'ip')->from('vl_ips')->get(); }
private function _loadRegimens() { $this->mongo->regimens->drop(); $res = LiveData::getRegimens(); foreach ($res as $row) { $data = ['id' => $row->id, 'name' => $row->appendix]; $this->mongo->regimens->insert($data); } }
public function getData() { $results = LiveData::leftjoin('vl_samples AS s', 's.id', '=', 'p.sample_id')->leftjoin('vl_facilities AS f', 'f.id', '=', 's.facilityID')->leftjoin('vl_hubs AS h', 'h.id', '=', 'f.hubID')->select('printed_by', 'printed_at', 'formNumber', 'facility', 'hub')->from('vl_facility_printing AS p')->where('printed', 'YES')->orderby('printed_at', 'DESC'); return \Datatables::of($results)->make(true); }