protected function modify(AnnouncementPro $announcementPro)
{
$q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET TITLE = :title, DESCRIPTION = :description, PRICE_PUBLIC = :pricePublic, PHOTO_MAIN = :photoMain, PHOTO_OPTION_1 = :photoOption1, PHOTO_OPTION_2 = :photoOption2, TIPS = :tips, RAW_MATERIAL = :rawMaterial, ADDRESS_1 = :address1, ADDRESS_2 = :address2, ZIP_CODE = :zipCode, CITY = :city, COUNTRY = :country, REGION_ID =:regionId, DEPARTMENT_ID =:departmentId, IS_PUBLISHED = :isPublished, PUBLICATION_DATE = :publicationDate, CATEGORY_ID = :categoryId, SUB_CATEGORY_ID = :subCategoryId, USER_ID = :userId, STATE_ID = :stateId, ADMIN_COMMENT = :adminComment WHERE ID = :id');
$q->bindValue(':title', $announcementPro->getTitle());
$q->bindValue(':description', $announcementPro->getDescription());
$q->bindValue(':pricePublic', $announcementPro->getPricePublic());
$q->bindValue(':photoMain', $announcementPro->getPhotoMain());
$q->bindValue(':photoOption1', $announcementPro->getPhotoOption1());
$q->bindValue(':photoOption2', $announcementPro->getPhotoOption2());
$q->bindValue(':tips', $announcementPro->getTips());
$q->bindValue(':rawMaterial', $announcementPro->getRawMaterial());
$q->bindValue(':address1', $announcementPro->getAddress1());
$q->bindValue(':address2', $announcementPro->getAddress2());
$q->bindValue(':zipCode', $announcementPro->getZipCode());
$q->bindValue(':city', $announcementPro->getCity());
$q->bindValue(':country', $announcementPro->getCountry());
$q->bindValue(':regionId', $announcementPro->getRegionId());
$q->bindValue(':departmentId', $announcementPro->getDepartmentId());
$q->bindValue(':isPublished', $announcementPro->getIsPublished());
$q->bindValue(':publicationDate', $announcementPro->getPublicationDate());
$q->bindValue(':categoryId', $announcementPro->getCategoryId(), PDO::PARAM_INT);
$q->bindValue(':subCategoryId', $announcementPro->getSubCategoryId(), PDO::PARAM_INT);
$q->bindValue(':userId', $announcementPro->getUserId(), PDO::PARAM_INT);
$q->bindValue(':stateId', $announcementPro->getStateId(), PDO::PARAM_INT);
$q->bindValue(':adminComment', $announcementPro->getAdminComment());
$q->bindValue(':id', $announcementPro->id());
$q->execute();
}
private function parseForm(HTTPRequest $request, AnnouncementPro $announce)
{
$title = htmlspecialchars($request->postData('title'));
$isPublished = $request->postExists('is-published');
$description = htmlspecialchars($request->postData('description'));
$pricePublic = htmlspecialchars($request->postData('price-public'));
if ($request->postExists('has-tips')) {
$tips = htmlspecialchars($request->postData('tips'));
} else {
$tips = '';
}
$rawMaterial = htmlspecialchars($request->postData('raw-material'));
$address1 = htmlspecialchars($request->postData('address1'));
$address2 = htmlspecialchars($request->postData('address2'));
$zipCode = htmlspecialchars($request->postData('zip-code'));
$city = htmlspecialchars($request->postData('city'));
$country = 'FRANCE';
$departmentId = htmlspecialchars($request->postData('department'));
$regionId = $this->_departmentsManager->get($departmentId)->getRegionId();
$categoryId = htmlspecialchars($request->postData('category'));
$subCategoryId = htmlspecialchars($request->postData('sub-category'));
$userId = $this->_user->id();
//Parsing
$announce->setTitle($title);
$announce->setIsPublished($isPublished);
$announce->setDescription($description);
$announce->setPricePublic($this->str2num($pricePublic));
$announce->setTips($tips);
$announce->setRawMaterial($rawMaterial);
$announce->setAddress1($address1);
$announce->setAddress2($address2);
$announce->setZipCode($zipCode);
$announce->setCity($city);
$announce->setCountry($country);
$announce->setDepartmentId($departmentId);
$announce->setRegionId($regionId);
$announce->setCategoryId($categoryId);
$announce->setSubCategoryId($subCategoryId);
$announce->setUserId($userId);
$announce->setAdminComment('');
// Demande de suppression de photo
if ($request->postExists('delete-photo-main')) {
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . $announce->getPhotoMain());
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . AnnouncementPro::THUMBNAILS_PREFIX . $announce->getPhotoMain());
$announce->setPhotoMain('');
}
if ($request->postExists('delete-photo-option-1')) {
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . $announce->getPhotoOption1());
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . AnnouncementPro::THUMBNAILS_PREFIX . $announce->getPhotoOption1());
$announce->setPhotoOption1('');
}
if ($request->postExists('delete-photo-option-2')) {
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . $announce->getPhotoOption2());
unlink($_SERVER['DOCUMENT_ROOT'] . AnnouncementPro::ANNOUNCEMENT_PRO_DIRECTORY . $announce->id() . '/' . AnnouncementPro::THUMBNAILS_PREFIX . $announce->getPhotoOption2());
$announce->setPhotoOption2('');
}
}