/** * This method stores only new employess to DB. * @return null [description] */ public function storeEmployeesAll() { DB::connection()->disableQueryLog(); $all_emp = isset($_POST["emp"]) && !empty($_POST["emp"]) ? $_POST["emp"] : []; if (empty($all_emp)) { return null; } foreach ($all_emp as $emp) { $values = ['pin' => $emp['PIN'], 'name' => array_key_exists("Name", $emp) ? $emp['Name'] : "", 'device_id' => $this->connected_device['device_id'], 'password' => array_key_exists("Password", $emp) ? substr($emp['Password'], 0, 5) : "", 'card' => $emp['Card'], 'group' => $emp['Group'], 'privilege' => $emp['Privilege'], 'pin2' => $emp['PIN2'], 'tz1' => $emp['TZ1'], 'tz2' => $emp['TZ2'], 'tz3' => $emp['TZ3']]; if (Employee::where('pin', $emp['PIN'])->where('device_id', $this->connected_device['device_id'])->first()) { echo "pin:" . $emp['PIN'] . " "; Employee::where('pin', $emp['PIN'])->where('device_id', $this->connected_device['device_id'])->update($values); } else { echo "new pin:" . $emp['PIN'] . " "; Employee::Create($values); } } return "ok"; }