public function newMultiUnit($updatesA, $unit, $database)
 {
     $echo = "Entering newMultiUnit ........................................ ";
     File::append($this->logfilename, $echo . "\r\n");
     //dd($updatesA, $unit);
     // check if multiple units
     // get sqM for specific unit
     $a = explode(" & ", $updatesA['strComplexNo']);
     $sqM = explode(" & ", $updatesA['strSqMeters']);
     $found = in_array($unit, $a);
     if ($found) {
         $place = array_search($unit, $a);
         $updatesA['strSqMeters'] = $sqM[$place];
     }
     $now = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString();
     $updatesA['id'] = null;
     $updatesA['strKey'] = $updatesA['strKey'];
     $updatesA['numStreetNo'] = $updatesA['strStreetNo'];
     $updatesA['numComplexNo'] = $updatesA['strComplexNo'];
     $updatesA['created_at'] = $now;
     // dd($updatesA, $a, $found, $place, $a[$place], $sqM[$place]);
     // delete older ones
     $delOld = Property::on($database)->where('strKey', $updatesA['strKey'])->where(DB::raw("STR_TO_DATE(dtmRegDate, '%Y-%m-%d')"), '<', Date($updatesA['dtmRegDate']))->delete();
     $echo = "..DELETE OLD ............    " . $updatesA['strKey'] . "   -   " . $delOld;
     File::append($this->logfilename, $echo . "\r\n");
     // insert new property record
     Property::on($database)->insert($updatesA);
     // add owner record if not existing
     //
     $hascontact = Owner::on($database)->select('id')->where('strIDNumber', '=', $updatesA['strIdentity']);
     if ($hascontact->count() == 0) {
         // update details from admin contacts
         $admin_contacts = "farmbook_admin";
         $otf = new \App\Database\OTF(['database' => $admin_contacts]);
         $db = DB::connection($admin_contacts);
         $owner_details = Contact::on($admin_contacts)->select('*')->where('strIDNumber', $updatesA['strIdentity'])->first();
         // contact details found in admin contacts
         if (sizeof($owner_details) == 1) {
             $uid = $owner_details->strIDNumber;
             // set database back
             $dbname = $database;
             $otf = new \App\Database\OTF(['database' => $dbname]);
             $db = DB::connection($dbname);
             // update contact details
             $owner = Owner::on($database)->insert(array('strIDNumber' => $owner_details->strIDNumber, 'NAME' => $owner_details->NAME, 'TITLE' => $owner_details->TITLE, 'INITIALS' => $owner_details->INITIALS, 'strSurname' => $owner_details->strSurname, 'strFirstName' => $owner_details->strFirstName, 'strHomePhoneNo' => $owner_details->strHomePhoneNo, 'strWorkPhoneNo' => $owner_details->strWorkPhoneNo, 'strCellPhoneNo' => $owner_details->strCellPhoneNo, 'EMAIL' => $owner_details->EMAIL, 'created_at' => $now, 'updated_at' => $now));
             // update from prop rec
         } else {
             $dbname = $database;
             $otf = new \App\Database\OTF(['database' => $dbname]);
             $db = DB::connection($dbname);
             $owner = Owner::on($database)->insert(array('strIDNumber' => $updatesA['strIdentity'], 'NAME' => $updatesA['strOwners'], 'created_at' => $now));
         }
     } else {
         // dont wipe old details
     }
     // add note
     //
     $hasnote = Note::on($database)->select('id')->where('strKey', '=', $updatesA['strKey'])->get();
     if ($hasnote->count() == 0) {
         //$note       = Note::on($database)->insert(array('strKey' => $updatesA[$x]['strKey'], 'numErf' => $updatesA[$x]['numErf'], 'memNotes' => "\n" . $now . '  ' . $updatesA[$x]['strOwners'] . '  - New Owner.', 'created_at' => $now));
         $note = Note::on($database)->insert(array('strKey' => $updatesA['strKey'], 'numErf' => $updatesA['numErf'], 'created_at' => $now));
     } else {
         $note = Note::on($database)->where('strKey', '=', $updatesA['strKey'])->update(array('memNotes' => DB::raw('concat(memNotes, " \\n' . $now . '  ' . $updatesA['strOwners'] . ' -  New Owner.")'), 'updated_at' => $now));
     }
     $echo = "Finishing newMultiUnit ........................................  ";
     File::append($this->logfilename, $echo . "\r\n");
 }