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