public function save(ContentDto $content, $idUser)
{
if ($content->id > 0) {
$sql[] = "UPDATE content";
} else {
$sql[] = "INSERT INTO content";
}
$sql[] = " SET title = :title,";
$sql[] = " chapo = :chapo,";
$sql[] = " body = :body,";
$sql[] = " home = :home,";
$sql[] = " state = :state,";
$sql[] = " edito = :edito,";
$sql[] = " date_creation = :date_creation,";
$sql[] = " date_modification = :date_modification,";
$sql[] = " date_publication = :date_publication,";
if ($content->id > 0) {
$sql[] = " id_user_modification = :id_user_modification";
$params[':id_user_modification'] = $idUser;
} else {
$sql[] = " id_user_creation = :id_user_creation,";
$sql[] = " id_user_modification = :id_user_modification";
$params[':id_user_creation'] = $idUser;
$params[':id_user_modification'] = $idUser;
}
if ($content->id > 0) {
$sql[] = "WHERE id=:id";
$params[':id'] = $content->id;
}
$params[':title'] = $content->title;
$params[':chapo'] = $content->chapo;
$params[':body'] = $content->body;
$params[':home'] = $content->home ? 1 : 0;
$params[':state'] = $content->state;
$params[':edito'] = $content->edito;
$params[':date_creation'] = strftime("%Y-%m-%d %H:%M:%S", $content->dateCreation);
$params[':date_modification'] = strftime("%Y-%m-%d %H:%M:%S", time());
$params[':date_publication'] = strftime("%Y-%m-%d %H:%M:%S", $content->datePublication);
$result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params);
if ($content->id == 0) {
$content->id = $this->daoTemplate->getLastInsertId();
}
$this->categoryDao->saveIdCategoriesForContent($content->id, $content->listIdCategories);
if ($content->edito == 1) {
$this->updateEdito($content->id);
}
return $result;
}
