/** * Delete entries * * @param array|string $where SQL WHERE clause(s) * @return int|string */ public function delete($id) { $model_activities = new Production_Model_Activity(); if ($model_activities->fetchHaveActivities($id)) { die("esta compañia tiene actividades relacionanadas"); } $model_permission_production = new Production_Model_Permissionproduction(); $model_permission_production->delete_production($id); //delete resource $table = $this->getTable(); $table->delete('id = ' . (int) $id); }
public function _selectOptions_Users() { $sql = "SELECT acl_users.id,acl_users.name\n FROM acl_users,acl_users_has_companies \n WHERE acl_users_has_companies.acl_users_id=acl_users.id \n AND (acl_users_has_companies.companies_id=" . $_SESSION['company']['id'] . " OR acl_users_has_companies.companies_id=" . $_SESSION['production']['client_company'] . ")"; $db = Zend_Registry::get('db'); $result = $db->fetchPairs($sql); $model = new Production_Model_Permissionproduction(); foreach ($result as $key => $value) { if ($model->fetchisEntry($key, $_SESSION['production']['id'])) { unset($result[$key]); } } if ($result == null) { echo "no quedan usuarios para añadir"; //$this->url(array('controller' => 'permissionproduction', 'action' => 'index' )); } return $result; }
/** * deleteAction for Productions * * @return void */ public function selectAction() { $id = $this->_getParam('id', 0); // //se comprueba que el usuario tiene permiso para esa produccion //se comprueba que el usuario tiene permiso para esa accion hecho $model_permission_production = new Production_Model_Permissionproduction(); if (!$model_permission_production->isUserAllowedProduccition($id)) { echo "no tiene acceso a la produccion " . $production["name"]; return $this->_helper->_redirector->gotoSimple('index', 'production', 'production'); } $model = new Production_Model_Production(); $production = $model->fetchEntry($id); $this->production = new Zend_Session_Namespace('production'); $this->production->id = $id; $this->production->name = $production["name"]; $this->production->activity_users = null; $this->production->activity = null; return $this->_helper->_redirector->gotoSimple('consult', 'finances', 'finances'); }
function consultAction() { //get the page of the table $this->production = new Zend_Session_Namespace('production'); if ($this->production->id == null) { return $this->_helper->_redirector->gotoSimple('index', 'production', 'production'); } $page = $this->_getParam('page', 1); //get the dates for the table $model = new Production_Model_Production(); $data = $model->fetchEntryProduction(); $this->production->client_company = $data["client_companies_id"]; $this->production->own_company = $data["companies_id"]; $this->production->own_company_name = $data["own_company_name"]; $this->production->client_company_name = $data["client_company_name"]; $this->view->production = $data; //send information to the view $this->view->title = "Production Consult"; //get the dates for the table Activity $model = new Production_Model_Activity(); // Zend_Debug::dump($_SESSION); // die(); //TODO cambiar hardcode por roles que pueden verse if ($_SESSION['gpms']['role'] == "Encargado Actividad" or $_SESSION['gpms']['role'] == "public") { $data_activities = $model->fetchOwnActivities(); } else { $data_activities = $model->fetchActivities(); } if ($data_activities) { $paginator = Zend_Paginator::factory($data_activities); $production = Zend_Registry::get('production'); $paginator->setItemCountPerPage($production->paginator); $paginator->setCurrentPageNumber($page); $paginator->setPageRange($production->paginator); $this->view->paginator = $paginator; } else { $this->view->paginator = null; } //get the dates for permission $page = $this->_getParam('page', 1); //get the dates for the table $model_permission = new Production_Model_Permissionproduction(); $data_permission = $model_permission->fetchUserPermissionproductions(); //paginator if ($data) { $paginator2 = Zend_Paginator::factory($data_permission); $production = Zend_Registry::get('production'); $paginator2->setItemCountPerPage($production->paginator); $paginator2->setCurrentPageNumber($page); $paginator2->setPageRange($production->paginator); $this->view->paginator2 = $paginator2; } else { $this->view->paginator = null; } //send information to the view }
/** * inlitterAction for Permissionproductions * * @return void */ public function inlitterAction() { //check if the user select a production $this->production = new Zend_Session_Namespace('production'); if ($this->production->id == null) { return $this->_helper->_redirector->gotoSimple('index', 'production', 'production'); } if ($this->getRequest()->isPost()) { $del = $this->getRequest()->getPost('del'); if ($del == 'Yes') { $id = $this->getRequest()->getPost('id'); $model = new Production_Model_Permissionproduction(); $model->inLitter('id = ' . (int) $id); } return $this->_helper->redirector('index'); } else { $id = $this->_getParam('id', 0); if ($id > 0) { $model = new Production_Model_Permissionproduction(); $this->view->permissionproduction = $model->fetchEntry($id); } } }