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; }