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