public function editProductsAction() { $productsString = $this->getRequest()->getParam('products'); $idGroup = $this->getRequest()->getParam('id'); $products = explode(',', $productsString); foreach ($products as $key => $idProductGroups) { //all products that need to be in the table $modelGroup = new Default_Model_ProductGroups(); $modelGroup->setIdProduct($idProductGroups); $modelGroup->setIdGroup($idGroup); $modelGroupFind = new Default_Model_ProductGroups(); $selectFind = $modelGroupFind->getMapper()->getDbTable()->select()->where('idProduct = ?', $idProductGroups)->where('idGroup = ?', $idGroup); $modelGroupFind->fetchRow($selectFind); if ($modelGroupFind->getId() == NULL) { //existing product added in the database $modelGroup->setOrder($key); $modelGroup->save(); } } }
function edit(Default_Model_RecurrentExpenses $model) { $expenseId = new Zend_Form_Element_Hidden('expenseId'); $expenseId->setValue($model->getId()); $this->addElement($expenseId); $this->name->setValue($model->getName()); $this->name->setLabel(Zend_Registry::get('translate')->_('admin_name')); $this->price->setValue($model->getPrice()); $this->price->setLabel(Zend_Registry::get('translate')->_('admin_price')); $this->date->setValue(date('m/d/Y', strtotime($model->getDate()))); $this->date->setLabel('Date'); $productGroups = new Default_Model_ProductGroups(); $select = $productGroups->getMapper()->getDbTable()->select()->where('idProduct=?', $model->getId())->where('repeated=?', 1); $result = $productGroups->fetchAll($select); if (NULL != $result) { foreach ($result as $value) { $options[$value->getId()] = $value->getIdGroup(); } } $this->idGroup->setValue($options); $this->idGroup->setLabel(Zend_Registry::get('translate')->_('category')); $this->submit->setValue(Zend_Registry::get('translate')->_('admin_edit_recurrent_expense')); }
public function delete(Default_Model_ProductGroups $value) { $id = $value->getId(); $data = array('deleted' => '1'); $this->getDbTable()->update($data, array('id = ?' => $id)); //logs action done //$user_name = $value->getUserName()->getName().' '.$value->getUserName()->getSurname(); $product_name = $value->getName(); $action_done = 'User deleted the group ' . $product_name . ' '; Needs_Logs::DbLogTracking(0, $id, 'expenses', 'stergere', $action_done); //end logs action done return $id; }
public function editAction() { $auth = Zend_Auth::getInstance(); $authAccount = $auth->getStorage()->read(); if (null != $authAccount) { if (null != $authAccount->getId()) { $user = new Default_Model_Users(); $user->find($authAccount->getId()); } } $id = $this->getRequest()->getParam('id'); /*$hasAccess = Needs_Roles::hasAccess(Zend_Registry::get('user')->getIdRole(),'adaugare_proiect'); if(!$hasAccess) { $this->_redirect(WEBROOT.'products'); }*/ $model = new Default_Model_RecurrentExpenses(); if ($model->find($id)) { $form = new Default_Form_RecurrentExpenses(); $form->edit($model); $form->setDecorators(array('ViewScript', array('ViewScript', array('viewScript' => 'forms/recurrent-expenses/edit-expense.phtml')))); $this->view->form = $form; if ($this->getRequest()->isPost()) { if ($this->getRequest()->getPost('submit')) { if ($form->isValid($this->getRequest()->getPost())) { $oldDate = $model->getDate(); $post = $this->getRequest()->getPost(); $model->setOptions($form->getValues()); $model->setDate(date("Y-m-d", strtotime($post["date"]))); if ($oldDate != date("Y-m-d", strtotime($post["date"]))) { $model->setDatePaid(); } $model->setType('0'); if ($expenseId = $model->save()) { if (!empty($post['galleryFiles']) && is_array($post['galleryFiles'])) { foreach ($post['galleryFiles'] as $valuesGallery) { $tmpFiles = new Default_Model_TempFiles(); if ($tmpFiles->find($valuesGallery)) { $post = $this->getRequest()->getPost(); $gallery = new Default_Model_FileManager(); $gallery->setOptions($form->getValues()); $gallery->setType($tmpFiles->getFileType()); $gallery->setSize($tmpFiles->getFileSize()); $gallery->setModule('sharedfiles'); $gallery->setIdMessage($expenseId); $gallery->setIdUser(1); $gallery->setName($tmpFiles->getFileName()); $savedId = $gallery->save(); if ($savedId) { $shared = new Default_Model_SharedList(); $shared->setIdUser(Zend_Registry::get('user')->getId()); $shared->setIdFile($savedId); $shared->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 } Needs_Tools::DeleteLegaturi($expenseId, '1'); $idGroup = $this->getRequest()->getParam('idGroup'); $modelGroup = new Default_Model_ProductGroups(); $modelGroup->setIdProduct($expenseId); $modelGroup->setIdGroup($idGroup); $modelGroup->setRepeated(1); $modelGroup->save(); $post = $this->getRequest()->getPost(); //mesaj de succes $this->_flashMessenger->addMessage("<div class='success canhide'><p>Recurrent expense was modified successfully<a href='javascript:;'></a></p></div>"); } else { $this->_flashMessenger->addMessage("<div class='failure canhide'><p>Recurrent expense was not modified<a href='javascript:;'></a></p></div>"); } $this->_redirect(WEBROOT . 'recurrent-expenses'); } } } } }
public static function DeleteLegaturibyGroup($groupId) { $productGroups = new Default_Model_ProductGroups(); $where = $productGroups->getMapper()->getDbTable()->getAdapter()->quoteInto('idGroup = ?', $groupId); return $productGroups->getMapper()->getDbTable()->delete($where); }