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