public function downloadAction()
{
$id = $this->getRequest()->getParam('id');
//$loggedInUserId = Zend_Registry::get('user')->getId();
$model = new Default_Model_UploadedFiles();
if ($model->find($id)) {
$name = $model->getName();
$this->view->result = $name;
}
}
public function indexAction()
{
// BEGIN:FILTERS
$filters = array();
//array with variables to send to pagination (filters)
$type = $this->getRequest()->getParam('type');
//can be 'sent','trash' or empty (inbox)
$this->view->type = $type;
if (!empty($type)) {
$filters['type'] = $type;
}
$searchTxt = $this->getRequest()->getParam('searchTxt');
if (!empty($searchTxt)) {
$filters['searchTxt'] = $searchTxt;
}
$this->view->search = $filters;
// END:FILTERS
//BEGIN:SEARCH FORM
$formSearch = new Default_Form_MessagesSearch();
$formSearch->setDecorators(array('ViewScript', array('ViewScript', array('viewScript' => 'forms/messages-search.phtml'))));
$this->view->formSearch = $formSearch;
//END:SEARCH FORM
//BEGIN:FORM ADD
$replyId = $this->getRequest()->getParam('replyId');
$form = new Default_Form_Messages();
$form->setDecorators(array('ViewScript', array('ViewScript', array('viewScript' => 'forms/messages.phtml'))));
if (!empty($replyId)) {
$model = new Default_Model_Messages();
$model->find($replyId);
if ($model->getIdUserTo() == Zend_Registry::get('user')->getId()) {
$form->reply($model);
}
}
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if (!empty($post['action']) && $post['action'] == 'add') {
//if is valid save message
if ($form->isValid($this->getRequest()->getPost())) {
//save message
$model = new Default_Model_Messages();
$model->setOptions($form->getValues());
$model->setIdUserFrom(Zend_Registry::get('user')->getId());
$savedId = $model->save();
if ($savedId) {
//BEGIN:SAVE ATTACHMENTS
if (!empty($post['galleryFiles']) && is_array($post['galleryFiles'])) {
foreach ($post['galleryFiles'] as $valuesGallery) {
$tmpFiles = new Default_Model_TempFiles();
if ($tmpFiles->find($valuesGallery)) {
$gallery = new Default_Model_UploadedFiles();
$gallery->setIdMessage($savedId);
$gallery->setType($tmpFiles->getFileType());
$gallery->setIdUser(Zend_Registry::get('user')->getId());
$gallery->setModule('messages');
$gallery->setName($tmpFiles->getFileName());
$gallery->save();
//copy picture and crop
$tempFile = APPLICATION_PUBLIC_PATH . '/media/temps/' . $tmpFiles->getFileName();
$targetFile = APPLICATION_PUBLIC_PATH . '/media/files/' . $tmpFiles->getFileName();
@copy($tempFile, $targetFile);
@unlink($tempFile);
$tmpFiles->delete();
}
}
}
//END:SAVE ATTACHMENTS
$this->_flashMessenger->addMessage("<div class='success canhide'><p>Your message was succesfully sent.</p><a href='javascript:;'></a></div>");
} else {
$this->_flashMessenger->addMessage("<div class='failure canhide'><p>Error sending message!</p><a href='javascript:;'></a></div>");
}
$this->_redirect(WEBROOT . 'messages');
}
}
}
//END:FORM ADD
//BEGIN:LISTING
$model = new Default_Model_Messages();
$select = $model->getMapper()->getDbTable()->select();
if (!empty($type) && $type == 'sent') {
//sent
$select->from(array('u' => 'messages'), array('u.id', 'idUserFrom' => 'u.idUserTo', 'u.subject', 'u.created'))->where('u.idUserFrom = ?', Zend_Registry::get('user')->getId())->where('NOT u.deletedFrom')->where('NOT u.trashedFrom');
} elseif (!empty($type) && $type == 'trash') {
//trash
$select->from(array('u' => 'messages'), array('u.id', 'u.idUserFrom', 'u.idUserTo', 'u.subject', 'u.created'))->where("" . "(u.idUserTo = '" . Zend_Registry::get('user')->getId() . "' AND u.trashedTo = 1 AND NOT u.deletedTo) " . "OR " . "(u.idUserFrom = '" . Zend_Registry::get('user')->getId() . "' AND u.trashedFrom = 1 AND NOT u.deletedFrom)");
} else {
//inbox
$select->from(array('u' => 'messages'), array('u.id', 'u.idUserFrom', 'u.idUserTo', 'u.subject', 'u.created'))->where('u.idUserTo = ?', Zend_Registry::get('user')->getId())->where('NOT u.deletedTo')->where('NOT u.trashedTo');
}
if (!empty($searchTxt)) {
$select->where("u.subject LIKE ('%" . $searchTxt . "%') OR u.message LIKE ('%" . $searchTxt . "%')");
}
$select->order('u.created DESC')->setIntegrityCheck(false);
// pagination
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($select));
$paginator->setItemCountPerPage(10);
$paginator->setCurrentPageNumber($this->_getParam('page'));
$paginator->setPageRange(5);
Zend_Paginator::setDefaultScrollingStyle('Sliding');
Zend_View_Helper_PaginationControl::setDefaultViewPartial(array('_pagination.phtml', $filters));
$this->view->inboxNr = Needs_Messages::getInboxMessagesNumber();
$this->view->sentNr = Needs_Messages::getSentMessagesNumber();
$this->view->trashNr = Needs_Messages::getTrashMessagesNumber();
$this->view->result = $paginator;
$this->view->itemCountPerPage = $paginator->getItemCountPerPage();
$this->view->totalItemCount = $paginator->getTotalItemCount();
//END:LISTING
}
public function save(Default_Model_UploadedFiles $value)
{
$data = array('idMessage' => $value->getIdMessage(), 'idUser' => $value->getIdUser(), 'name' => $value->getName(), 'type' => $value->getType(), 'module' => $value->getModule());
if (null === ($id = $value->getId())) {
$data['created'] = new Zend_Db_Expr('NOW()');
$id = $this->getDbTable()->insert($data);
} else {
$this->getDbTable()->update($data, array('id = ?' => $id));
}
return $id;
}
public static function checkDuplicatedFileName($filename, $ext, $oldId = Null)
{
$i = 2;
$duplicatedFileName = true;
$finalFileName = $filename;
while ($duplicatedFileName) {
$modelNew = new Default_Model_UploadedFiles();
$modelNew->getModelbyName($finalFileName . "." . $ext);
if (!empty($oldId)) {
if ($modelNew->getId() && $modelNew->getId() != $oldId) {
$finalFileName = $filename . '-' . $i;
} else {
$duplicatedFileName = false;
}
} else {
if ($modelNew->getId()) {
$finalFileName = $filename . '-' . $i;
} else {
$duplicatedFileName = false;
}
}
$i++;
}
return $finalFileName;
}
public function deleteExpenseSavedUploadsAction()
{
$return = 0;
$fileId = $this->getRequest()->getParam('fileId');
$picModel = new Default_Model_UploadedFiles();
if ($picModel->find($fileId)) {
@unlink(APPLICATION_PUBLIC_PATH . '/media/files/' . $picModel->getName());
if ($picModel->delete()) {
$return = 1;
}
}
echo Zend_Json_Encoder::encode($return);
}
