public function index(Request $request) { // set database $database = Auth::user()->getDatabase(); //change database for notes $owner = new Owner(); $owner->changeConnection($database); //change database for Street $property = new Property(); $property->changeConnection($database); // get inputs $Input = $request->input('input'); $Select = $request->input('selected'); //dd( $streetInput,$streetSelect); // check if input or select // if input ignore select if (strlen($Input) > 0) { // search $search = $Input; $properties = Property::on($database)->where('strOwners', 'LIKE', "%{$search}%")->orderby('strOwners', 'ASC')->get(); } else { $owner = Property::on($database)->where('id', $Select)->first(); $search = $owner->strOwners; $properties = Property::on($database)->where('strOwners', $search)->orderby('strOwners', 'ASC')->get(); } Session::put('search', $Input); Session::put('controllerroute', '/owners'); // view properties // return with error if no result if ($properties->count()) { return view('owners', compact('properties', 'search')); } else { Session::flash('flash_message', '' . "No properties matching search criteria."); Session::flash('flash_type', 'alert-danger'); return Redirect::back(); } }
public function update(Request $request) { // set database $database = Auth::user()->getDatabase(); //change database $owner = new Owner(); $owner->changeConnection($database); //change database $note = new Note(); $note->changeConnection($database); // get logged in user $user = Auth::user()->name; $now = Carbon\Carbon::now('Africa/Cairo')->toDateTimeString(); // get inputs $strKey = $request->input('strKey'); $strIdentity = $request->input('strIdentity'); $strOwners = $request->input('strOwners'); $homePhone = $request->input('strHomePhoneNo'); $workPhone = $request->input('strWorkPhoneNo'); $cellPhone = $request->input('strCellPhoneNo'); $email = $request->input('EMAIL'); $note = $request->input('note'); $newnote = $request->input('newnote'); $strStreetNo = $request->input('strStreetNo'); $strStreetName = $request->input('strStreetName'); $followup = $request->input('followup'); $date = ""; if (strLen($followup) > 0) { $date = Carbon\Carbon::createFromFormat('Y-m-d', $followup); } try { // update personal details // $owner = Owner::on( $database )->where('strIDNumber', $strIdentity)->update(array('strCellPhoneNo' => $cellPhone, // 'strHomePhoneNo' => $homePhone, // 'strWorkPhoneNo' => $workPhone, // 'EMAIL' => $email, // 'updated_at'=> $now // )); $properties = Property::on($database)->where('strKey', $strKey)->update(array('strStreetNo' => $strStreetNo, 'numStreetNo' => $strStreetNo, 'strStreetName' => $strStreetName)); //dd($properties); //update owner details $owner = Owner::on($database)->where('strIDNumber', $strIdentity)->first(); $owner->strHomePhoneNo = $homePhone; $owner->strCellPhoneNo = $cellPhone; $owner->strWorkPhoneNo = $workPhone; $owner->EMAIL = $email; $owner->save(); // check if there is a new note if (strlen($newnote) > 0) { // if a previous note exists add a carrige return and new note if (strlen($note) > 0) { $updatednote = ltrim(rtrim($note)) . "\n" . $now . " " . $user . " wrote: " . "\n" . $newnote; } else { // add just the new note $updatednote = $now . " " . $user . " wrote: " . "\n" . $newnote; } // update the note $affected = Note::on($database)->where('strKey', $strKey)->update(array('memNotes' => $updatednote, 'followup' => $date, 'updated_at' => $now)); } Note::on($database)->where('strKey', $strKey)->update(array('followup' => $date, 'updated_at' => $now)); } catch (exception $e) { Session::flash('flash_message', 'Error ' . $e->getMessage()); Session::flash('flash_type', 'alert-danger'); return Redirect::back(); } Session::flash('flash_message', 'Updated ' . $strOwners . ' at ' . $now); Session::flash('flash_type', 'alert-success'); return Redirect::back(); }
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"); }