/** * * @param User $user * @return int id of the User inserted in base. False if it didn't work. */ public static function flush($user) { $userId = $user->getId(); $login = $user->getLogin(); $password = $user->getPassword(); $mail = $user->getMail(); $inscriptionDate = $user->getInscriptionDate(); $firstName = $user->getFirstName(); $lastName = $user->getLastName(); $birthDate = $user->getBirthDate(); $address = $user->getAddress(); $phoneNumber = $user->getPhoneNumber(); $avatar = $user->getAvatar(); $role = $user->getRole()->getId(); if ($userId > 0) { $sql = 'UPDATE user u SET ' . 'u.login = ?, ' . 'u.passwd = ?, ' . 'u.mail = ?, ' . 'u.inscription_date = ?, ' . 'u.first_name = ?, ' . 'u.last_name = ?, ' . 'u.birth_date = ?, ' . 'u.address = ?, ' . 'u.phone_number = ?, ' . 'u.avatar = ?, ' . 'u.ROLE_id_role = ? ' . 'WHERE u.id_user = ?'; $params = array('ssssssssssii', &$login, &$password, &$mail, &$inscriptionDate, &$firstName, &$lastName, &$birthDate, &$address, &$phoneNumber, &$avatar, &$role, &$userId); } else { $sql = 'INSERT INTO user ' . '(login, passwd, mail, inscription_date, first_name, ' . 'last_name, birth_date, address, phone_number, avatar, ROLE_id_role) ' . 'VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; $params = array('ssssssssssi', &$login, &$password, &$mail, &$inscriptionDate, &$firstName, &$lastName, &$birthDate, &$address, &$phoneNumber, &$avatar, &$role); } $idInsert = BaseSingleton::insertOrEdit($sql, $params); if ($idInsert !== false && $userId > 0) { $idInsert = $userId; } return $idInsert; }