public function deleteAlbumAction()
{
$this->_helper->layout()->disableLayout();
$albumId = $this->_getParam('id');
$objModelAlbum = new Album_Model_Album();
$objModelAlbumPhoto = new Album_Model_AlbumPhoto();
$objModelAlbumTag = new Album_Model_AlbumTag();
$objModelAlbumPhotoTag = new Album_Model_AlbumPhotoTag();
$objModelPhotoTag = new Album_Model_PhotoTag();
$objModelComment = new Application_Model_Comment();
// Remove all comment for album
$whereAlbumComment = "item_type='album_comment' AND item_id='{$albumId}'";
$objModelComment->delete($whereAlbumComment);
// Remove all album tag
$whereAlbumTag = "album_id='{$albumId}'";
$objModelAlbumTag->delete($whereAlbumTag);
// Fetch all photo of album
$whereAlbumPhoto = "album_id='{$albumId}'";
$arrPhoto = $objModelAlbumPhoto->fetchAll($whereAlbumPhoto);
if (count($arrPhoto) > 0) {
foreach ($arrPhoto as $photo) {
$photoId = $photo->id;
$photoName = $photo->image;
$imagePathT = PUBLIC_PATH . "/media/album/thumb/" . $photoName;
$imagePathC = PUBLIC_PATH . "/media/album/custom/" . $photoName;
$imagePathD = PUBLIC_PATH . "/media/album/default/" . $photoName;
unlink($imagePathT);
// Remove image from thumb folder
unlink($imagePathC);
// Remove image from custom folder
unlink($imagePathD);
// Remove image from default folder
// Remove photo comment
$wherePhotoComment = "item_type='photo_comment' AND item_id='{$photoId}'";
$objModelComment->delete($wherePhotoComment);
// Remove tagged photo
$whereTaggedPhoto = "photo_id='{$photoId}'";
$objModelPhotoTag->delete($whereTaggedPhoto);
// Remove photo tag
$whereAlbumPhotoTag = "photo_id='{$photoId}'";
$objModelAlbumPhotoTag->delete($whereAlbumPhotoTag);
}
}
// Remove all photo
$whereAlbumPhoto = "album_id='{$albumId}'";
$objModelAlbumPhoto->delete($whereAlbumPhoto);
// Remove Album
$whereAlbum = "id='{$albumId}'";
$objModelAlbum->delete($whereAlbum);
$this->_redirect('/album/my-photos');
$this->_helper->viewRenderer->setNoRender(true);
}
public function albumSubmitAction()
{
$this->_helper->layout()->disableLayout();
$params = $this->getRequest()->getParams();
$userNs = new Zend_Session_Namespace('members');
$option['userId'] = $userNs->userId;
// LoggedIn UserId
$arrLatLang = explode(",", $params['latlang']);
$latitude = substr($arrLatLang[0], 1, strlen($arrLatLang[0]));
// Longitude of location
$longitude = substr($arrLatLang[1], 0, -1);
// Latitude of location
$option['name'] = $params['name'];
$option['description'] = addslashes(strip_tags($params['description']));
$option['location'] = $params['address'];
$option['permission'] = $params['permissions'];
$option['longitude'] = $longitude;
$option['latitude'] = $latitude;
$option['status'] = 1;
$albumM = new Album_Model_Album($option);
$album_id = $albumM->save();
/*----- start tags--------*/
if ($params['album_tags'] != "" && $params['album_tags'] != "Separate Tags by a comma. For example: ' Holiday, London, Travel'") {
$arrTags = explode(",", $params['album_tags']);
foreach ($arrTags as $_tag) {
$_tag = trim($_tag);
$tagsM = new Application_Model_Tags();
$tag = $tagsM->fetchRow("tag='{$_tag}'");
if (false === $tag) {
$tagsM->setTag($_tag);
$tag_id = $tagsM->save();
} else {
$tag_id = $tag->getId();
}
$albumTagM = new Album_Model_AlbumTag();
$albumTagM->setAlbumId($album_id);
$albumTagM->setTagId($tag_id);
$albumTagM->save();
}
}
echo $album_id;
exit;
}
public function getAlbumTags($albumId)
{
$objModelAlbumTag = new Album_Model_AlbumTag();
$objModelTag = new Application_Model_Tags();
$whereAlbumTag = "album_id='{$albumId}'";
$arrTagId = $objModelAlbumTag->fetchAll($whereAlbumTag);
$strTag = "";
if (!empty($arrTagId)) {
foreach ($arrTagId as $tagId) {
$tId = $tagId->tagId;
$valTag = $objModelTag->find($tId);
$strTag = $strTag . ',' . $valTag->getTag();
}
$strTag = substr($strTag, 1, strlen($strTag));
}
return $strTag;
}
private function setModel($row)
{
$model = new Album_Model_AlbumTag();
$model->setId($row->id)->setAlbumId($row->album_id)->setTagId($row->tag_id);
return $model;
}
public function albumEditSubmitAction()
{
$this->_helper->layout()->disableLayout();
$arrPostVal = $this->getRequest()->getParams();
$objModelAlbum = new Album_Model_Album();
$objModelTags = new Application_Model_Tags();
$objModelAlbumTag = new Album_Model_AlbumTag();
$name = addslashes(strip_tags($arrPostVal['name']));
$description = addslashes(strip_tags($arrPostVal['description']));
$location = $arrPostVal['location'];
$permission = $arrPostVal['permissions'];
$tags = $arrPostVal['tags'];
$albumId = $arrPostVal['albumId'];
$latlang = $arrPostVal['latlang'];
$arrLatLang = explode(",", $latlang);
$latitude = substr($arrLatLang[0], 1, strlen($arrLatLang[0]));
// Longitude of location
$longitude = substr($arrLatLang[1], 0, -1);
$valAlbum = $objModelAlbum->find($albumId);
$valAlbum->setName($name);
$valAlbum->setDescription($description);
$valAlbum->setLocation($location);
$valAlbum->setPermission($permission);
$valAlbum->setLatitude($latitude);
$valAlbum->setLongitude($longitude);
$valAlbum->save();
/*--------------------- ALBUM TAG ---------------------*/
$arrTag = explode(",", $tags);
$objModelAlbumTag->delete("album_id='{$albumId}'");
foreach ($arrTag as $tag) {
$newTag = trim($tag);
$whereTag = "";
$whereTag = "tag='{$newTag}'";
$arrTags = $objModelTags->fetchAll($whereTag);
if (count($arrTags) > 0) {
$optionAlbumTag['albumId'] = $albumId;
$optionAlbumTag['tagId'] = $arrTags[0]->id;
$objModelAlbumTag->setOptions($optionAlbumTag);
$objModelAlbumTag->save();
} else {
$optionTag['tag'] = $newTag;
$objModelTags->setOptions($optionTag);
$id = $objModelTags->save();
/*-----------------------------------*/
$optionAlbumTag['albumId'] = $albumId;
$optionAlbumTag['tagId'] = $id;
$objModelAlbumTag->setOptions($optionAlbumTag);
$objModelAlbumTag->save();
}
}
exit;
}
