function editAction() { parent::editAction(); $cdforward = array(); $values = $this->_form->getValues(); $cdforward = $values['cdforward']; $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $this->_model->update($array, 'cdforward = ' . $cdforward); $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage("Erro na inserção dos dados."); $this->addMessage($e->getMessage()); $url = '/message/error'; $this->_redirect($url); } $this->addMessage("Alteração realizada com sucesso."); $this->_redirect("/message/success/cadastre/param_controller/forward/param_action/index"); }
public function saveAction() { parent::saveAction(); $measurementunitModel = new MeasurementunitModel(); $array = array(); $message = ''; $measurementunitModel->getAdapter()->beginTransaction(); try { $array = array('idnotation' => $this->_request->getParam('idnotation'), 'nmmeasurementunit' => $this->_request->getParam('nmmeasurementunit')); if ($this->_request->getParam('cdmeasurementunit') == '') { $measurementunitModel->insert($array); $message = "Cadastro efetuado com sucesso."; } else { $message = ''; $message = "Registro alterado com sucesso."; $measurementunitModel->update($array, 'cdmeasurementunit=' . $this->_request->getParam('cdmeasurementunit')); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = ''; $message = "Erro na operação."; $message = $e->getMessage(); } $this->view->message = $message; }
public function saveAction() { $accountentryModel = new AccountentryModel(); parent::saveAction(); $this->_model->getAdapter()->beginTransaction(); $message = ''; try { $userSession = Zend_Session::namespaceGet('Gslab_Session'); $cdusergslab = $userSession['user']->cdusergslab; $nrbatch = $this->_request->getParam('nrbatch'); $nrinvoice = $this->_request->getParam('nrinvoice'); $dtduedate = $this->_request->getParam('dtduedate'); $vlinvoice = $this->_request->getParam('vlinvoice'); $cdcovenant = $this->_request->getParam('cdcovenant'); $dtduedate = new Zend_Date($dtduedate, 'YYYY-MM-dd HH:mm:ss'); $dtduedate = $dtduedate->toString('YYYY-MM-dd HH:mm:ss'); $array = array('nrbatch' => $nrbatch, 'dtduedate' => $dtduedate); $arrayAE = array('cdclient' => $cdcovenant, 'fgclienttype' => 'b', 'cdusergslab' => $cdusergslab, 'fgaccountentrytype' => 2, 'vlinvoicevalue' => $vlinvoice, 'nraccountentry' => $nrbatch, 'idinvoiceref' => $nrinvoice, 'dtdeadline' => $dtduedate, 'fgaccountcheck' => 0, 'dttransactiondate' => date("Y-m-d H:i:s"), 'dtentrydate' => date("Y-m-d H:i:s")); $this->_model->insert($array); $cdbilling = $this->_model->getAdapter()->lastInsertId($this->_controller); $accountentryModel->insert($arrayAE); $this->_model->getAdapter()->commit(); echo $cdbilling; } catch (Exception $e) { $message = ''; $this->_model->getAdapter()->rollBack(); $message = 'Ocorreu um erro interno, portanto seus dados ainda não foram salvos na nossa base de dados, verifique os campos obrigatórios e tente novamente!'; } }
public function saveAction() { parent::saveAction(); $cdmaterial = $this->_request->getParam("cdmaterial"); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $message = ''; $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } if ($cdmaterial == '') { $this->_model->insert($array); $message = "Cadastro efetuado com sucesso."; } else { $message = ''; $message = "Registro alterado com sucesso."; $this->_model->update($array, 'cdmaterial=' . $cdmaterial); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = ''; $message = "Erro na operação."; $message = $e->getMessage(); } $this->view->message = $message; }
public function saveAction() { parent::saveAction(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); $userInfo = $this->getSessionData("user", "cdcompany"); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { if ($id == "dtpurchase") { $value = new Zend_Date($value, 'dd-MM-YYYY'); $value = $value->toString('YYYY-MM-dd'); } $array[$id] = addslashes($value); } } $array['cdcompany'] = $userInfo['cdcompany']; $parameters = json_decode($_GET['parameters'], true); $this->_model->insert($array); $cdequipment = $this->_model->getAdapter()->lastInsertId(); if (!empty($_GET['parameters'])) { $this->saveParametersAction($cdequipment, $parameters, false); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage("Erro na inserção dos dados!" . $e->getMessage()); $this->_redirect($this->redirectLink('error')); } $this->addMessage("Cadastro realizado com sucesso."); $this->_redirect($this->redirectLink("success", "cadastre", "equipment") . "/param/"); }
public function saveAction() { $cdsupplycentre = $this->_request->getParam('cdsupplycentre'); parent::saveAction(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } if ($cdsupplycentre != '') { $message = "Registro alterado com sucesso!"; $this->_model->update($array, 'cdsupplycentre=' . $cdsupplycentre); } else { $message = "Cadastro realizado com sucesso!"; $this->_model->insert($array); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $message = ''; $this->_model->getAdapter()->rollBack(); $message = 'Ocorreu um erro interno, por tanto seus dados ainda não foram salvos na nossa base de dados, verifique os campos obrigatório e tente novamente!'; //$message=$e->getMessage(); } $this->view->message = $message; // $this->_redirect($this->redirectLink("success", "stock", "center", "index") . "/"); }
public function saveAction() { $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); $message = ''; // Declaração dos Render() do Zend para a Validação do Formulário $formRenders = array($this->_form->addElementsForm(), $this->_form->addElementsExistantStock(), $this->_form->addElementsStockControl()); // Função que valida os Campos do Formulario com multiplos Render() parent::validateMultipleForm($formRenders); // <----- try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } if ($this->_values['cdsupply'] != null) { $array['fgsupplycontrol'] = 1; if ($this->_values['cdsupplycentre'] != null && $this->_values['cdsupplier'] != null) { date_default_timezone_set('UTC'); $supplystockModel = new SupplystockModel(); $arraySupplyStock = array(); $arraySupplyStock['cdsupply'] = $this->_values['cdsupply']; $arraySupplyStock['cdsupplycentre'] = $this->_values['cdsupplycentre']; $arraySupplyStock['cdsupplier'] = $this->_values['cdsupplier']; $dtcheckin = date("Y-m-d") . " " . date("H:i"); $arraySupplyStock['dtcheckin'] = $dtcheckin; if ($this->_values['vlsupplyunit'] != null) { $vlunitprice = $this->_values['vlsupplyunit']; $vlsupplytoDB = str_replace(" ", "", $vlunitprice); $vlsupplytoDB = str_replace(",", ".", $vlsupplytoDB); $vlsupplytoDB = str_replace("R\$", "", $vlsupplytoDB); $arraySupplyStock['vlunitprice'] = $vlsupplytoDB; } if ($this->_values['nrsupplyquantity'] != null) { $supplyModel = new SupplyModel(); $arraySupplyStock['qtquantity'] = $this->_values['nrsupplyquantity']; $arraySupplyStock['qtsupplybalance'] = $this->_values['nrsupplyquantity']; $qtdebalance = $supplyModel->fetchRow("cdsupply = " . $this->_values['cdsupply']); $supplyModel->update(array("qtbalance" => $qtdebalance['qtbalance'] + $arraySupplyStock['qtsupplybalance']), "cdsupply = " . $this->_values['cdsupply']); } $supplystockModel->insert($arraySupplyStock); } } else { $array['fgsupplycontrol'] = 2; } $this->_model->insert($array); $message = "Cadastro realizado com sucesso."; $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = ''; $message = "Erro na operação."; $message = $e->getMessage(); } $this->view->message = $message; }
public function saveAction() { parent::saveAction(); $values = $this->_form->getValues(); //print_r($values); $values['vlchvalue'] = str_replace(".", "", $values['vlchvalue']); $values['vlchvalue'] = str_replace(",", ".", $values['vlchvalue']); if ($values['dtcovenant'] != null) { $valuesDt = explode("-", $values['dtcovenant']); $values['dtcovenant'] = $valuesDt['2'] . "-" . $valuesDt['1'] . "-" . $valuesDt['0']; } $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } else { if ($id == 'idcnpj' && $value == '') { $array[$id] = addslashes($value); } } } $acao = $_POST['acao']; $cdcovenant = $_POST['cdcovenant']; if ($cdcovenant != '') { if ($acao == 'delete') { $where = $this->_model->getAdapter()->quoteInto('cdcovenant = ' . $cdcovenant); $this->_model->delete($where); $message = "Convênio deletado com sucesso."; } else { $this->_model->update($array, 'cdcovenant = ' . $cdcovenant); $message = "Convênio Atualizado."; } } else { if ($acao != 'delete') { $this->_model->insert($array); $message = "Cadastro efetuado com sucesso."; } else { if ($acao == 'delete' && $cdcovenant == '') { $message = "Nenhum cadastro foi selecionado."; } } } $this->_model->getAdapter()->commit(); $this->addMessage($message); $url = $this->redirectLink("success", "cadastre", "covenant"); $this->_redirect($url); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = "Erro na inserção dos dados." + $e->getMessage(); } //$this->view->message = $message; }
public function saveAction() { parent::saveAction(); $message = ''; $methodsupply = $this->_request->getParam("methodsupply"); $methodsupply = json_decode($methodsupply, true); $methodsupplyModel = new MethodsupplyModel(); $columnsMethod = $this->_model->info(Zend_Db_Table_Abstract::COLS); $columnsMethodSupply = $methodsupplyModel->info(Zend_Db_Table_Abstract::COLS); $array = array(); $methodsupplyArr = array(); $cdmethod = $this->_values['cdmethod']; $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { // echo $id.' <--> '; if (isset($value) && $value != '' && in_array($id, $columnsMethod)) { $array[$id] = addslashes($value); } } if ($cdmethod == null) { $this->_model->insert($array); $lastCDmethod = $this->_model->getAdapter()->lastInsertId(); foreach ($methodsupply as $methodsupplyArr) { foreach ($methodsupplyArr as $cols => $colsvalue) { //Última PK da Tabela de Métodos $insertmethodsupply['cdmethod'] = $lastCDmethod; //Validação se existe na Tabela if (isset($colsvalue) && $colsvalue != '' && in_array($cols, $columnsMethodSupply)) { $insertmethodsupply[$cols] = addslashes($colsvalue); } } $methodsupplyModel->insert($insertmethodsupply); } $message = "Código: {$lastCDmethod} - Cadastro efetuado com sucesso."; } else { $this->_model->update($array, "cdmethod = {$cdmethod}"); $message = "Código: {$cdmethod} - Atualização efetuada com sucesso."; } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = ''; $message = "Erro na operação."; $message = $e->getMessage(); } $this->view->message = $message; }
public function saveAction() { parent::saveAction(); $values = $this->_form->getValues(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $this->_model->insert($array); $cdclient = $this->_model->getAdapter()->lastInsertId($this->_controller); $clientphonunber = new ClientphonenumberModel(); $columnsClientPhonunber = $clientphonunber->info(Zend_Db_Table_Abstract::COLS); $arrayClientPhonunber = array(); foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columnsClientPhonunber)) { $arrayClientPhonunber[$id] = addslashes($value); } } $arrayClientPhonunber["cdclient"] = addslashes($cdclient); $clientphonunber->insert($arrayClientPhonunber); $clientAddress = new ClientaddressModel(); $columnsClientAddress = $clientAddress->info(Zend_Db_Table_Abstract::COLS); $arrayClientAddress = array(); foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columnsClientAddress)) { $arrayClientAddress[$id] = addslashes($value); } } $arrayClientAddress["cdclient"] = addslashes($cdclient); $clientAddress->insert($arrayClientAddress); $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage($e->getMessage()); $this->addMessage("Erro na inserção dos dados."); $url = '/cadastre/message/index'; $this->_redirect($url); } $this->addMessage("Cadastro efetuado com sucesso."); $url = '/cadastre/message/index'; $this->_redirect($url); }
public function saveAction() { $update = false; $nmcolor = $this->_request->getParam("nmcolor"); $cdphysicallocation = $this->_request->getParam("cdphysicallocation"); $nmcolorparent = $this->_request->getParam("nmcolorparent"); //die($nmcolor.$nmcolorparent); if ($nmcolorparent != '' && $nmcolor == '') { $nmcolor = $nmcolorparent; } parent::saveAction(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $array['nmcolor'] = $nmcolor; if ($cdphysicallocation != '') { $update = true; $this->_model->update($array, "cdphysicallocation=" . $cdphysicallocation); } else { $this->_model->insert($array); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $erro = true . $this->_model->getAdapter()->rollBack(); $this->addMessage($e->getMessage()); } if ($erro == true) { $this->_redirect($this->redirectLink("error", "cadastre", "department", "index")); } if ($update == true) { $this->addMessage("Registro alterado com sucesso."); } else { $this->addMessage("Registro incluido com sucesso."); } if ($erro == true) { $this->_redirect($this->redirectLink("error", "cadastre", "department", "index")); } $this->_redirect($this->redirectLink("success", "cadastre", "physicallocation", "index")); }
public function saveAction() { parent::saveAction(); /* Instancia classe SupplyStock */ $supplystockModel = new SupplystockModel(); /* Instancia classe Supply */ $supplyModel = new SupplyModel(); /* Instancia classe SupplyFlow */ $supplyflowModel = new SupplyflowModel(); $supplies = json_decode($_GET['supply'], true); $i = 0; $supply = array(); $supplystockModel->getAdapter()->beginTransaction(); try { foreach ($supplies as $row) { $data = explode("-", $_POST['dtcheckout']); if ($row['dtexpires'] != "Indeterminado") { $expire = explode("-", $row['dtexpires']); } $valor = substr($row['vlunitprice'], 2); /* Adiciona lista de Itens na SupplyStock */ $supply[$i] = array('cdsupply' => $row['cdsupply'], 'qtquantity' => $row['qtquantity'], 'qtsupplybalance' => $row['qtquantity'], 'cdsupplycentre' => $_POST['cdsupplycentrefrom'], 'dtexpire' => $expire[2] . "-" . $expire[1] . "-" . $expire[0] . " 00:00:00", 'dtcheckin' => $data[2] . "-" . $data[1] . "-" . $data[0] . " " . $_POST['hrcheckin'] . ":00", 'cdsupplier' => $_POST['cdsupplyentrysupplier'], 'idinvoice' => $_POST['cdsupplyinvoice'], 'idbatch' => $_POST['cdsupplylot'], 'vlunitprice' => $valor); /* Insere registros na StockFlow */ $supplyflow[$i] = array('cdsupply' => $row['cdsupply'], 'qtquantity' => $row['qtquantity'], 'cdsupplycentreto' => $_POST['cdsupplycentrefrom'], 'fgsupplyioreason' => '4', 'dtcheckin' => date("Y-m-d H:i:s"), 'dtcheckout' => date("Y-m-d H:i:s"), 'cdsupplycentrefrom' => null); /* Atualiza quantidade de itens na Supply */ $dataSupplier = $supplyModel->fetchRow($supplyModel->getSupplyByCdSupply($row['cdsupply'])); $dataSupplier['qtbalance'] = $dataSupplier['qtbalance'] + $row['qtquantity']; $array['qtbalance'] = $dataSupplier['qtbalance']; $supplyModel->update($array, 'cdsupply = ' . $row['cdsupply']); $supplystockModel->insert($supply[$i]); $supplyflowModel->insert($supplyflow[$i]); $i++; } $lastId = $supplystockModel->getAdapter()->lastInsertId(); $message = "Cadastro efetuado com sucesso.<br>Número no Protocolo gerado: " . $lastId; $supplystockModel->getAdapter()->commit(); } catch (Exception $e) { $supplystockModel->getAdapter()->rollBack(); $message = "Erro na inserção dos dados."; } $this->view->message = $message; }
public function saveAction() { parent::saveAction(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); $message = ''; foreach ($_POST as $Ncampo => $valor) { $valueopt = $_POST['value']; } try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { if ($this->_values['fgdatatype'] == 4) { if (isset($this->_values["dtminvalue"]) && $this->_values["dtminvalue"] != '') { $dtminvalue = GslabUtils::dateToDatabaseFormat($this->_values["dtminvalue"]); } if (isset($this->_values["dtmaxvalue"]) && $this->_values["dtmaxvalue"] != '') { $dtmaxvalue = GslabUtils::dateToDatabaseFormat($this->_values["dtmaxvalue"]); } $array = array('idattribute' => $_POST['idattribute'], 'nmattribute' => $_POST['nmattribute'], 'fgdatatype' => $_POST['fgdatatype'], 'dtminvalue' => $dtminvalue, 'dtmaxvalue' => $dtmaxvalue); } else { $array[$id] = addslashes($value); } } } $this->_model->insert($array); if ($this->_values['fgdatatype'] == '5') { $cdattribute = $this->_model->getAdapter()->lastInsertId(); $this->saveOptionsAction($valueopt, $cdattribute); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $message = "Erro na inserção dos dados!" . $e->getMessage(); } $message = "Cadastro realizado com sucesso."; $this->view->message = $message; }
public function saveAction() { parent::saveAction(); // print_r($_POST);die; $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $this->_model->insert($array); $this->_model->getAdapter()->commit(); $this->addMessage("Cadastro efetuado com sucesso."); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage("Erro na alteração dos dados."); $this->addMessage($e->getMessage()); $this->_redirect($this->redirectLink("error", "cadastre", "role", "index") . "/"); } $this->_redirect($this->redirectLink("success", "cadastre", "role", "index") . "/"); }
public function saveAction() { parent::saveAction(); }
public function saveAction() { parent::saveAction(); $supplysupplyflowtypeModel = new SupplysupplyflowtypeModel(); $supplyModel = new SupplyModel(); $supplyModel->getAdapter()->beginTransaction(); $paramSupplyArray = array(); $paramSupplyflowtype = array(); $message = ''; $paramSupplyArray = array('idsupply' => $_POST['idsupply'], 'nmsupply' => $_POST['nmsupply'], 'cdsupplytype' => $_POST['cdsupplytype'], 'cdmeasurementunit' => $_POST['cdmeasurementunit'], 'dspreparation' => $_POST['dspreparation'], 'fgtype' => $this->_request->getParam('fgtype')); if ($this->_request->getParam('cdsupply') != '') { $supplyModel->update($paramSupplyArray, "cdsupply = " . $this->_request->getParam('cdsupply')); $paramSupplyflowtype = array('cdsupply' => $this->_request->getParam('cdsupply'), 'cdsupplyflowtype' => $this->_request->getParam('cdsupplyflowtype')); $supplysupplyflowtypeModel->update($paramSupplyflowtype, "cdsupply = " . $this->_request->getParam('cdsupply')); $message = "Alteração realizada com sucesso!"; $supplyModel->getAdapter()->commit(); } else { $cdsupply = $supplyModel->insert($paramSupplyArray); $paramSupplyflowtype = array('cdsupply' => $cdsupply, 'cdsupplyflowtype' => $this->_request->getParam('cdsupplyflowtype')); $supplysupplyflowtypeModel->insert($paramSupplyflowtype); $message = "Cadastro efetuado com sucesso!"; $supplyModel->getAdapter()->commit(); } $this->view->message = $message; }
public function saveAction() { $url = ''; parent::saveAction(); $cdcompany = $this->_request->getParam("cdcompany"); $update = ''; $_UP['type'] = array("jpg", "gif", "png"); /* Uploading Document File on Server */ $upload = new Zend_File_Transfer_Adapter_Http(); if ($_FILES['nmcompanylogo']['name'] != '') { $typeFile = strtolower(end(explode('.', $_FILES['nmcompanylogo']['name']))); if (array_search($typeFile, $_UP['type']) === false) { $this->addMessage("O arquivo deve ter uma extensão válida tipo jpg, png ou gif."); $this->_redirect($this->redirectLink('error')); } } $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); $this->file_new_name_body = $_POST['nmcompany']; try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $cdcompany = $array["cdcompany"]; if ($cdcompany != '0') { $update = "1"; $this->_model->update($array, 'cdcompany = ' . $cdcompany); $companylogo = array("nmcompanylogo" => $cdcompany . '.' . $typeFile); $this->_model->update($companylogo, 'cdcompany = ' . $cdcompany); $this->addMessage("Alterado com sucesso."); } else { $this->_model->insert($array); $cdcompany = $this->_model->getAdapter()->lastInsertId($this->_controller); $companylogo = array("nmcompanylogo" => $cdcompany . '.' . $typeFile); $this->_model->update($companylogo, 'cdcompany = ' . $cdcompany); $this->addMessage("Cadastro efetuado com sucesso."); } $upload->setDestination('companyimages/'); if ($_FILES['nmcompanylogo']['name'] != '') { $validate = false; if ($update == "1") { $filepath = 'companyimages/' . $cdcompany . '.' . $typeFile; unlink($filepath); } try { $upload->addFilter('Rename', array('target' => 'companyimages/' . $cdcompany . '.' . $typeFile)); $upload->receive(); $imagem = 'companyimages/' . $cdcompany . '.' . $typeFile; list($width, $height) = getimagesize($imagem); if ($width <= 105 && $height <= 70) { $validate = true; } else { $validate = false; $ratio = $width / $height; } if ($ratio < 2 && $validate == false) { $new_height = 70; $new_width = 105; $new_image = $cdcompany . '.' . $typeFile; $image_temp = imagecreatetruecolor($new_width, $new_height); $original = imagecreatefromjpeg($imagem); imagecopyresampled($image_temp, $original, 0, 0, 0, 0, $new_width, $new_height, $width, $height); imagejpeg($image_temp, 'companyimages/' . $new_image, 80); } else { $this->addMessage("Esta imagem é incompatível, pois possui uma proporção que pode prejudicar a visualização em relatórios. Por favor, selecione outra imagem ou entre em contato com o suporte técnico."); $this->_redirect($this->redirectLink('error')); } } catch (Zend_File_Transfer_Exception $e) { $e->getMessage(); } $info = $upload->getFileInfo(); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage($e->getMessage()); $this->addMessage("Erro na inserção dos dados."); $this->_redirect("/message/error/param_module/cadastre/param_controller/laboratory/param_action/index"); } if ($update == '1') { $this->_redirect($this->redirectLink("success", "cadastre", "laboratory", "edit") . "/param/" . $cdcompany); } else { $this->_redirect("/message/success/param_module/cadastre/param_controller/laboratory/param_action/include"); } }
public function saveActionRename() { parent::saveAction(); $values = $this->_form->getValues(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $cdusergslab = $values['cdusergslab']; $nmpassword = $values['nmpassword']; $values['nmpassword'] = md5($nmpassword); $this->_model->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } $values = $this->_request->getParams(); if (isset($cdusergslab)) { $userData = $this->_model->fetchall($this->_model->getUserByCd($cdusergslab)); $userExist = count($userData); } if ($userExist == 0) { $this->_model->insert($array); } else { $this->_model->update($array, 'cdusergslab = ' . $cdusergslab); } $cdusergslab = $this->_model->getAdapter()->lastInsertId($this->_controller); $userAddress = new UseraddressModel(); $columnsUserAddress = $userAddress->info(Zend_Db_Table_Abstract::COLS); $arrayUserAddress = array(); foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columnsUserAddress)) { $arrayUserAddress[$id] = addslashes($value); } } $arrayUserAddress["cdusergslab"] = addslashes($cdusergslab); if ($userExist == 0) { $userAddress->insert($arrayUserAddress); } else { $userAddress->update($arrayUserAddress, 'cdusergslab = ' . $cdusergslab); } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); } }
public function saveAction() { parent::saveAction(); // Pega parâmetros passados por intermédio do request $array = array(); $values = $this->_request->getParams(); $cdexamination = $this->_request->getParam('cdexamination'); $idexamination = $this->_request->getParam('idexamination'); $nmexamination = $this->_request->getParam('nmexamination'); $nrminage = $this->_request->getParam('nrminage'); $fgtypeagemin = $this->_request->getParam('fgtypeagemin'); $nrmaxage = $this->_request->getParam('nrmaxage'); $cddepartment = $this->_request->getParam('cddepartment'); $fgtypeagemax = $this->_request->getParam('fgtypeagemax'); $qtdsamples = $this->_request->getParam('qtdsamples'); $fgsex = $this->_request->getParam('fgsex'); $allowpartialsave = $this->_request->getParam('allowpartialsave'); $dsdiagnosis = $this->_request->getParam('dsdiagnosis'); $dsinterference = $this->_request->getParam('dsinterference'); $departments = $this->_request->getParam('departments'); $mapattrib = $this->_request->getParam('fgmapattrib'); $departments = json_decode($departments); $synonyms = $this->_request->getParam('synonyms'); $synonyms = json_decode($synonyms); $materials = $this->_request->getParam('materials'); $materials = json_decode($materials); $examinationModel = new ExaminationModel(); $examinationModel->getAdapter()->beginTransaction(); /* var_dump($values); var_dump($this->view->controller); var_dump($this->view->action); die(); */ try { /* Salva dados na tabela 'examination' */ $examination = array(); $examination['idexamination'] = $idexamination; $examination['nmexamination'] = $nmexamination; $examination['fgsex'] = $fgsex; $examination['nrsamplelimit'] = $qtdsamples; $examination['fgparcialsave'] = $allowpartialsave; $examination['dsdiagnosis'] = $dsdiagnosis; $examination['dsinterference'] = $dsinterference; $examination['nrminage'] = $nrminage; $examination['nrmaxage'] = $nrmaxage; $examination['cdtimeframeminage'] = $fgtypeagemin; $examination['cdtimeframemaxage'] = $fgtypeagemax; // Passar para ExaminationMaterial //$examination['cddepartment'] = $cddepartment; // Mostragem dos atributos no mapa if (isset($mapattrib)) { if ($mapattrib) { $examination['fgmapattrib'] = 1; } else { $examination['fgmapattrib'] = 2; } } $previousAction = GslabUtils::getPreviousAction($this->view); if (strcmp($previousAction, "edit") == 0) { $examinationModel->update($examination, 'examination.cdexamination = ' . $cdexamination); } else { $examinationModel->insert($examination); $cdexamination = $examinationModel->getAdapter()->lastInsertId(); } /* Salva dados na tabela 'examinationdepartment' */ $examinationPermissionModel = new ExaminationpermissionModel(); foreach ($departments as $singleDepartment) { // Salva dados na tabela 'examinationpermission' $departmentPrintPermission = array('cddepartment' => $singleDepartment->cddepartment, 'cdexamination' => $cdexamination, 'fgprintmap' => $singleDepartment->map, 'fgprintsampleprotocol' => $singleDepartment->protocol, 'fgprintappraisal' => $singleDepartment->appraisal); $examinationPermissionModel->insert($departmentPrintPermission); } /* Salva dados na tabela 'examinationmaterial' */ $examinationMaterialModel = new ExaminationmaterialModel(); foreach ($materials as $singleMaterial) { $examinationMaterial = array('cdexamination' => $cdexamination, 'cdmaterial' => $singleMaterial->cdmaterial, 'fgdefault' => $singleMaterial->select); $examinationMaterialModel->insert($examinationMaterial); } /* Salva dados na tabela 'synonym' - Criando os registros */ $synonymModel = new SynonymModel(); $examinationSynonymModel = new ExaminationsynonymModel(); foreach ($synonyms as $singleSynonym) { $synonym = array('nmsynonym' => $singleSynonym->nmsynonym, 'fgdefault' => $singleSynonym->select); $synonymModel->insert($synonym); $cdsynonym = $synonymModel->getAdapter()->lastInsertId(); // Salva dados na tabela 'examinationsynonym' - ligando os sinonimias ao exame $examinationSynonym = array('cdexamination' => $cdexamination, 'cdsynonym' => $cdsynonym); $examinationSynonymModel->insert($examinationSynonym); } $examinationrevisionModel = new ExaminationrevisionModel(); $columns = $examinationrevisionModel->info(Zend_Db_Table_Abstract::COLS); foreach ($values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } //var_dump($values); //die(); $examinationrevisionModel->insert($array); //$this->_model->getAdapter()->commit(); // Avisa que o cadastro foi bem sucedido e retorna para o modo de inclusão de exames para um novo cadastro. $message = "Cadastro efetuado com sucesso."; } catch (Exception $e) { $message = "Erro na inserção dos dados. <br> Por favor, entre em contato e informe a mensagem a seguir: </br>"; $this->_model->getAdapter()->rollBack(); } $this->view->message = $message; }
public function saveAction() { parent::saveAction(); $this->_model->getAdapter()->beginTransaction(); $paramSystemSettingsArray = array(); try { if ($_POST['fgencryptpwd'] == 'true') { $fgencryptpwd = '1'; } else { $fgencryptpwd = '2'; } if ($_POST['fgloginblock'] == 'true') { $fgloginblock = '1'; } else { $fgloginblock = '2'; } if ($_POST['fgloginblockadminalert'] == 'true') { $fgloginblockadminalert = '1'; } else { $fgloginblockadminalert = '2'; } if ($_POST['fgunknownloginalert'] == 'true') { $fgunknownloginalert = '1'; } else { $fgunknownloginalert = '2'; } if ($_POST['fgchangepwdtimeframe'] == 'true') { $fgchangepwdtimeframe = '1'; } else { $fgchangepwdtimeframe = '2'; } if ($_POST['fgemailnotification'] == 'true') { $fgemailnotification = '1'; } else { $fgemailnotification = '2'; } if ($_POST['fgemailautentication'] == 'true') { $fgemailautentication = '1'; } else { $fgemailautentication = '2'; } if ($_POST['fgnotificationhistory'] == 'true') { $fgnotificationhistory = '1'; } else { $fgnotificationhistory = '2'; } if ($_POST['fgoptdocmgmt'] == 'true') { $fgoptdocmgmt = '1'; } else { $fgoptdocmgmt = '2'; } if ($_POST['fgoptlayoutengine'] == 'true') { $fgoptlayoutengine = '1'; } else { $fgoptlayoutengine = '2'; } if ($_POST['fgoptstepcontrol'] == 'true') { $fgoptstepcontrol = '1'; } else { $fgoptstepcontrol = '2'; } if ($_POST['fgoptworkflowenabled'] == 'true') { $fgoptworkflowenabled = '1'; } else { $fgoptworkflowenabled = '2'; } if ($_POST['fgoptreqexamsequencegen'] == 'true') { $fgoptreqexamsequencegen = '1'; } else { $fgoptreqexamsequencegen = '2'; } if ($_POST['fgoptsamplewarning'] == 'true') { $fgoptsamplewarning = '1'; } else { $fgoptsamplewarning = '2'; } if ($_POST['fgoptsampleuniquenumber'] == 'true') { $fgoptsampleuniquenumber = '1'; } else { $fgoptsampleuniquenumber = '2'; } if ($_POST['fgoptstdbarcodeprefix'] == 'true') { $fgoptstdbarcodeprefix = '1'; } else { $fgoptstdbarcodeprefix = '2'; } if (isset($_POST['cdsystemconfiguration']) && $_POST['cdsystemconfiguration'] != '') { $paramSystemSettingsArray = array('cdsystemconfiguration' => $_POST['cdsystemconfiguration'], 'idlicensecompany' => $_POST['idlicensecompany'], 'idlicensekey' => $_POST['idlicensekey'], 'nmlicensecompanyname' => $_POST['nmlicensecompanyname'], 'idcurrency' => $_POST['idcurrency'], 'nrinacttime' => $_POST['nrinacttime'], 'cdtimeframeinact' => $_POST['cdtimeframeinact'], 'nmurlsystem' => $_POST['nmurlsystem'], 'idadminpassword' => $_POST['idadminpassword'], 'fgencryptpwd' => $fgencryptpwd, 'fgloginblock' => $fgloginblock, 'nrloginblockattempts' => $_POST['nrloginblockattempts'], 'fgloginblockadminalert' => $fgloginblockadminalert, 'fgunknownloginalert' => $fgunknownloginalert, 'fgchangepwdtimeframe' => $fgchangepwdtimeframe, 'cdtimeframechangepwd' => $_POST['cdtimeframechangepwd'], 'nrchangepwdtimeframe' => $_POST['nrchangepwdtimeframe'], 'fgemailnotification' => $fgemailnotification, 'nmdefaultemail' => $_POST['nmdefaultemail'], 'idmailserver' => $_POST['idmailserver'], 'nrmailserverport' => $_POST['nrmailserverport'], 'fgmailserverprotocol' => $_POST['fgmailserverprotocol'], 'fgemailautentication' => $fgemailautentication, 'nmemailuser' => $_POST['nmemailuser'], 'idemailpassword' => $_POST['idemailpassword'], 'fgnotificationhistory' => $fgnotificationhistory, 'notificationhtmltemplate' => addslashes($_POST['notificationhtmltemplate']), 'fgoptdocmgmt' => $fgoptdocmgmt, 'fgoptlayoutengine' => $fgoptlayoutengine, 'fgoptstepcontrol' => $fgoptstepcontrol, 'fgoptworkflowenabled' => $fgoptworkflowenabled, 'fgoptreqexamsequencegen' => $fgoptreqexamsequencegen, 'fgoptsamplewarning' => $fgoptsamplewarning, 'fgoptsampleuniquenumber' => $fgoptsampleuniquenumber, 'fgoptstdbarcodeprefix' => $fgoptstdbarcodeprefix, 'nroptstdbarcodeprefix' => $_POST['nroptstdbarcodeprefix']); $this->_model->update($paramSystemSettingsArray, 'cdsystemconfiguration = ' . $_POST['cdsystemconfiguration']); $message = "Alteração realizada com sucesso"; $this->_model->getAdapter()->commit(); } else { $paramSystemSettingsArray = array('idlicensecompany' => $_POST['idlicensecompany'], 'idlicensekey' => $_POST['idlicensekey'], 'nmlicensecompanyname' => $_POST['nmlicensecompanyname'], 'idcurrency' => $_POST['idcurrency'], 'nrinacttime' => $_POST['nrinacttime'], 'cdtimeframeinact' => $_POST['cdtimeframeinact'], 'nmurlsystem' => $_POST['nmurlsystem'], 'idadminpassword' => $_POST['idadminpassword'], 'fgencryptpwd' => $fgencryptpwd, 'fgloginblock' => $fgloginblock, 'nrloginblockattempts' => $_POST['nrloginblockattempts'], 'fgloginblockadminalert' => $fgloginblockadminalert, 'fgunknownloginalert' => $fgunknownloginalert, 'fgchangepwdtimeframe' => $fgchangepwdtimeframe, 'cdtimeframechangepwd' => $_POST['cdtimeframechangepwd'], 'nrchangepwdtimeframe' => $_POST['nrchangepwdtimeframe'], 'fgemailnotification' => $fgemailnotification, 'nmdefaultemail' => $_POST['nmdefaultemail'], 'idmailserver' => $_POST['idmailserver'], 'nrmailserverport' => $_POST['nrmailserverport'], 'fgmailserverprotocol' => $_POST['fgmailserverprotocol'], 'fgemailautentication' => $fgemailautentication, 'nmemailuser' => $_POST['nmemailuser'], 'idemailpassword' => $_POST['idemailpassword'], 'fgnotificationhistory' => $fgnotificationhistory, 'notificationhtmltemplate' => addslashes($_POST['notificationhtmltemplate']), 'fgoptdocmgmt' => $fgoptdocmgmt, 'fgoptlayoutengine' => $fgoptlayoutengine, 'fgoptstepcontrol' => $fgoptstepcontrol, 'fgoptworkflowenabled' => $fgoptworkflowenabled, 'fgoptreqexamsequencegen' => $fgoptreqexamsequencegen, 'fgoptsamplewarning' => $fgoptsamplewarning, 'fgoptsampleuniquenumber' => $fgoptsampleuniquenumber, 'fgoptstdbarcodeprefix' => $fgoptstdbarcodeprefix, 'nroptstdbarcodeprefix' => $_POST['nroptstdbarcodeprefix']); $this->_model->insert($paramSystemSettingsArray); $message = "Cadastro efetuado com sucesso"; $this->_model->getAdapter()->commit(); } } catch (Exception $e) { $message = "Cadastro efetuado com sucesso"; $this->_model->getAdapter()->commit(); $message = "Erro na inserção dos dados." + $e->getMessage(); $this->_model->getAdapter()->rollBack(); } $this->view->message = $message; }
public function saveAction() { $update = false; $erro = false; $cddepartmentparent = $this->_request->getParam("cddepartmentparent"); $cddepartment = $this->_request->getParam("cddepartment"); $cddcompany = $this->_request->getParam("cdcompany"); // var_dump($this->_request->getParams()); // die(); if ($cddcompany == '' && $cddepartmentparent == '' && $cddepartment == '') { $this->addMessage("Selecione uma pasta na arvore de setores."); $this->_redirect("/message/error/param_module/cadastre/param_controller/department/param_action/index"); } else { parent::saveAction(); $columns = $this->_model->info(Zend_Db_Table_Abstract::COLS); $array = array(); $this->_model->getAdapter()->beginTransaction(); try { foreach ($this->_values as $id => $value) { if (isset($value) && $value != '' && in_array($id, $columns)) { $array[$id] = addslashes($value); } } if ($cddepartment != '') { $departmentModel = new DepartmentModel(); if (isset($array['cddepartmentparent'])) { $validate = $departmentModel->validateUpdateDepartment($array['cddepartmentparent'], $cddepartment); if ($validate->nmdepartment == null || $validate->nmdepartment == '') { $this->_model->update($array, 'cddepartment=' . $cddepartment); $update = true; } else { $this->addMessage("Não pode ser alterado."); $erro = true; } } else { $array['cddepartmentparent'] = null; $this->_model->update($array, 'cddepartment=' . $cddepartment); $update = true; } } else { $this->_model->insert($array); $insertdep_cddepartment = $this->_model->getAdapter()->lastInsertId($this->_controller); } $departmentCompanyModel = new CompanydepartmentModel(); $columnsDepatmentCompany = $departmentCompanyModel->info(Zend_Db_Table_Abstract::COLS); $arrayDepartementCompany = array(); foreach ($this->_values as $id => $value) { if (isset($this->_values) && $value != '' && in_array($id, $columnsDepatmentCompany)) { $arrayDepartementCompany[$id] = addslashes($value); } } if ($cddcompany != '0' && $cddepartment != '') { //die($cddcompany); $array = array('cdcompany' => $arrayDepartementCompany, 'cddepartment' => $cddepartment); $arrayDepartementCompany["cdcompany"] = $cddcompany; $departmentCompanyModel->update($arrayDepartementCompany, 'cddepartment=' . $cddepartment); $update = true; } else { //die($cddcompany); if ($cddepartment == '' && $cddcompany != '0') { $arrayDepartementCompany["cdcompany"] = $cddcompany; $arrayDepartementCompany["cddepartment"] = addslashes($insertdep_cddepartment); $departmentCompanyModel->insert($arrayDepartementCompany); } } $this->_model->getAdapter()->commit(); } catch (Exception $e) { $this->_model->getAdapter()->rollBack(); $this->addMessage($e->getMessage()); $this->addMessage("Erro na inserção dos dados."); $erro = true; } if ($erro == true) { $this->_redirect($this->redirectLink("error", "cadastre", "department", "index")); } if ($update == true) { $this->addMessage("Registro alterado com sucesso."); } else { $this->addMessage("Registro Incluido com sucesso."); } $this->_redirect($this->redirectLink("success", "cadastre", "department", "index")); } }