public function update(array $data, $id) { $model_company = new Company_Model_Company(); if ($model_company->existSupplierCompany($data["fiscal_name"], $id)) { //TODO ENVIAR UN MENSAJE die("supplier existe"); } //add types of activity for the supplier $db = Zend_Registry::get('db'); $db->delete("suppliers_has_activity_types", "suppliers_id=" . $id); $data_activity_type["suppliers_id"] = $data["id"]; foreach ($data["activity_types_id"] as $value) { $data_activity_type["activity_types_id"] = $value; $db->insert("suppliers_has_activity_types", $data_activity_type); // Zend_Debug::dump($data_activity_type); } // die(); $model_company = new Company_Model_Company(); $data_company = $data; $data_company["id"] = $data_company["companies_id"]; $model_company->update($data_company, 'id = ' . (int) $data["companies_id"]); $table = $this->getTable(); $fields = $table->info(Zend_Db_Table_Abstract::COLS); foreach ($data as $field => $value) { if (!in_array($field, $fields)) { unset($data[$field]); } } return $table->update($data, 'id = ' . (int) $id); }
/** * EditAction for Companys * * @return void */ public function editAction() { $this->gpms = new Zend_Session_Namespace('gpms'); if ($this->gpms->storage->out_production == 0) { return $this->_helper->_redirector->gotoSimple('index', 'company', 'company'); } $this->view->title = "Edit Company"; $form = new Company_Form_Company(); //get the dates for the table $model = new Company_Model_Company(); $select_company = $model->fetchEntry($_SESSION["company"]["id"]); $this->view->select_company = $select_company; if ($this->getRequest()->isPost()) { if ($form->isValid($this->getRequest()->getPost())) { $model = new Company_Model_Company(); $id = $this->getRequest()->getPost('id'); $model->update($form->getValues(), 'id = ' . (int) $id); return $this->_helper->redirector('index'); } else { $form->populate($this->getRequest()->getPost()); } } else { $id = $_SESSION["company"]["id"]; if ($id > 0) { $model = new Company_Model_Company(); $form->populate($model->fetchEntry($id)); } } $this->view->form = $form; }