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'));
 }
Exemple #4
0
 public static function getIPs()
 {
     return LiveData::select('id', 'ip')->from('vl_ips')->get();
 }
Exemple #5
0
 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);
 }