public function showImageAction() { $commentMapper = new CommentMapper(); $imageMapper = new ImageMapper(); $galleryMapper = new GalleryMapper(); $id = $this->getRequest()->getParam('id'); $galleryId = $this->getRequest()->getParam('gallery'); if ($this->getRequest()->getPost('saveComment')) { $date = new \Ilch\Date(); $commentModel = new CommentModel(); if ($this->getRequest()->getPost('fkId')) { $commentModel->setKey('gallery/index/showimage/gallery/' . $galleryId . '/id/' . $id . '/id_c/' . $this->getRequest()->getPost('fkId')); $commentModel->setFKId($this->getRequest()->getPost('fkId')); } else { $commentModel->setKey('gallery/index/showimage/gallery/' . $galleryId . '/id/' . $id); } $commentModel->setText($this->getRequest()->getPost('gallery_comment_text')); $commentModel->setDateCreated($date); $commentModel->setUserId($this->getUser()->getId()); $commentMapper->save($commentModel); } $gallery = $galleryMapper->getGalleryById($galleryId); $comments = $commentMapper->getCommentsByKey('gallery/index/showimage/gallery/' . $galleryId . '/id/' . $id); $image = $imageMapper->getImageById($id); $model = new ImageModel(); $model->setImageId($image->getImageId()); $model->setVisits($image->getVisits() + 1); $imageMapper->saveVisits($model); $this->getLayout()->set('metaTitle', $this->getTranslator()->trans('gallery') . ' - ' . $this->getTranslator()->trans('image') . ' - ' . $image->getImageTitle()); $this->getLayout()->set('metaDescription', $this->getTranslator()->trans('gallery') . ' - ' . $image->getImageDesc()); $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('menuGalleryOverview'), array('action' => 'index'))->add($gallery->getTitle(), array('action' => 'show', 'id' => $galleryId))->add($image->getImageTitle(), array('action' => 'showimage', 'gallery' => $galleryId, 'id' => $id)); $this->getView()->set('image', $imageMapper->getImageById($id)); $this->getView()->set('comments', $comments); }
/** * Updates image meta. * * @param ImageModel $model */ public function saveImageTreat(ImageModel $model) { $this->db()->update('gallery_imgs')->values(array('image_title' => $model->getImageTitle(), 'image_description' => $model->getImageDesc()))->where(array('id' => $model->getId()))->execute(); }