public function adduser() { $farmbooks = Farmbook::orderBy('name')->lists('name', 'id'); return view('auth.adduser', compact('farmbooks')); }
/** * Show the application dashboard. * * @return \Illuminate\Http\Response */ public function index() { // dd("user controller"); $farmbooks = Farmbook::orderBy('name')->get(); return view('farmbooks', compact('farmbooks')); }
public function globContacts(Request $request) { $start = \Carbon\Carbon::now('Africa/Johannesburg'); echo 'Start : ' . $start . '<br>'; // get all farmbook databases $farmbooks = Farmbook::orderBy('name')->get(); $email = Auth::user()->email; //log $action = 'GLOBAL UPDATE'; $comment = 'Contacts'; $append = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString() . ', ' . trim($email) . ', ' . $action . ',' . $comment; Storage::append('logfile.txt', $append); // loop through databases for ($x = 0; $x < $farmbooks->count(); $x++) { $error = 0; $database = $farmbooks[$x]->database; try { //change database $own = new Owner(); $own->changeConnection($database); // fetch records with missing info for te numbers and email $owners = Owner::on($database)->select('*')->where('strHomePhoneNo', '')->orWhere('strWorkPhoneNo', '')->orWhere('strCellPhoneNo', '')->orWhere('EMAIL', '')->get(); $noinfoowners = Owner::on($database)->select('*')->where('strHomePhoneNo', '')->Where('strWorkPhoneNo', '')->Where('strCellPhoneNo', '')->Where('EMAIL', '')->get(); $allowners = Owner::on($database)->select('*')->get(); //dd($owners); } catch (Exception $ex) { // echo "<br> ------------------------------------------------------------------" . "<br>"; // echo $x . ". " . $farmbooks[$x]->database . " <br>"; // echo " ** PROBLEM ** " . $ex->getMessage() . "<br>"; // echo " ------------------------------------------------------------------" . "<br>"; $error = 1; //dd(); } //dd($prop); if ($error == 0) { // check it has the farmbook2 ext $found = strpos($database, 'farmbook2'); // echo "<br> ------------------------------------------------------------------" . "<br>"; // if ($found == 0) { // echo "** ALERT ** Database has not got correct naming convention - farmbook2" . " <br>"; // } echo "<br> ------------------------------------------------------------------" . "<br>"; echo $x . ". Farmbook : " . $database . "<br><br>"; echo 'Local Owners : ' . $allowners->count() . "<br>"; echo 'Missing some info : ' . $owners->count() . "<br>"; echo 'Missing all info : ' . $noinfoowners->count() . "<br>"; if ($owners->count() > 0) { // echo " ------------------------------------------------------------------" . "<br>"; // $users = $farmbooks[$x]->users; $new = 0; $canupdate = 0; $can = 0; $canupdateRow = 0; $strHomePhoneNo = 0; $strWorkPhoneNo = 0; $strCellPhoneNo = 0; $EMAIL = 0; foreach ($owners as $owner) { //[0] echo " - " . $owner->NAME . " | " . $owner->strHomePhoneNo . " | " . $owner->strWorkPhoneNo . " | " . $owner->strCellPhoneNo . " | " . $owner->EMAIL . " | " . " <br>"; $found = Contact::select('*')->where('strIDNumber', $owner->strIDNumber)->get(); if ($found->count() > 0) { $new++; $can = 0; if ($owner->strHomePhoneNo == "" && $found[0]->strHomePhoneNo != "") { $canupdate++; $can++; $strHomePhoneNo++; $owner->strHomePhoneNo = $found[0]->strHomePhoneNo; } if ($owner->strWorkPhoneNo == "" && $found[0]->strWorkPhoneNo != "") { $canupdate++; $can++; $strWorkPhoneNo++; $owner->strWorkPhoneNo = $found[0]->strWorkPhoneNo; } if ($owner->strCellPhoneNo == "" && $found[0]->strCellPhoneNo != "") { $canupdate++; $can++; $strCellPhoneNo++; $owner->strCellPhoneNo = $found[0]->strCellPhoneNo; } if ($owner->EMAIL == "" && $found[0]->EMAIL != "") { $canupdate++; $can++; $EMAIL++; $owner->EMAIL = $found[0]->EMAIL; } if ($can > 0) { $canupdateRow++; $owner->update(); } } } echo ' Found in admin contacts : ' . $new . '<br><br>'; echo ' Can update fields : ' . $canupdate . '<br>'; echo ' Can update record : ' . $canupdateRow . '<br><br>'; echo 'strHomePhoneNo updates : ' . $strHomePhoneNo . '<br>'; echo 'strWorkPhoneNo updates : ' . $strWorkPhoneNo . '<br>'; echo 'strCellPhoneNo updates : ' . $strCellPhoneNo . '<br>'; echo 'EMAIL updates : ' . $EMAIL . '<br><br>'; //dd("end of first data"); } } } $end = \Carbon\Carbon::now('Africa/Johannesburg'); echo '<br><br>End : ' . $end . '<br><br>'; echo 'Time : ' . $end->diffForHumans($start); dd("The End"); }