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