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