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 editexaminationdataAction() { $values = $this->_request->getParams(); if (isset($values['dtcollection']) != '') { $values['dtcollection'] = GslabUtils::dateToDatabaseFormat($values['dtcollection']); $values['fgstatus'] = 1; } else { $values['fgstatus'] = 2; } if (isset($values['dtresult']) != '') { $values['dtresult'] = GslabUtils::dateToDatabaseFormat($values['dtresult']); } $array = array(); $requestExaminationModel = new RequestexaminationModel(); $examinationMaterialRequestModel = new ExaminationmaterialrequestModel(); $columns = $requestExaminationModel->info(Zend_Db_Table_Abstract::COLS); $requestExaminationModel->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && $value != '0' && in_array($id, $columns)) { $array[$id] = addslashes($value); } else { if (in_array($id, $columns)) { $array[$id] = null; } } } if (isset($values['fgpriority'])) { if ($values['fgpriority'] == 'Sim') { $array['fgpriority'] = 1; } else { $array['fgpriority'] = 2; } } if (empty($array) && $values['oper'] != 'del') { throw new Exception('Dados Incorretos. Confira seus dados e Tente Novamente.'); } else { if ($values['oper'] != 'del') { $requestExaminationModel->update($array, "cdrequestexamination = " . $values['cdrequestexamination']); } else { // Apenas altera o status da amostra para "Inativo" no lugar de DELETA-LO do banco de dados $requestExaminationModel->update(array("fgstatus" => 0), "cdrequestexamination = " . $values['id']); // $examinationMaterialRequestModel->delete("cdrequestexamination = ".$values['id']); // $requestExaminationModel->delete("cdrequestexamination = ".$values['id']); } } $requestExaminationModel->getAdapter()->commit(); } catch (exception $e) { $requestExaminationModel->getAdapter()->rollback(); $this->addMessage($e->getMessage()); } }
public function saveAction() { $bootstrap = $this->getInvokeArg('bootstrap'); $gslab_db = $bootstrap->getResource('db'); $deliveryModel = new AppraisaldeliveryModel(); $modelRequest = new RequestexaminationModel(); $gslab_db->beginTransaction(); $paramApp = $this->_request->getParam('data'); $request = $this->_request->getParam('request'); $delivery = $this->_request->getParam('delivery'); $date = $this->_request->getParam('date'); $time = $this->_request->getParam('time'); $dtdelivery = GslabUtils::dateToDatabaseFormat($date); $datahora = substr($dtdelivery, 0, -8); try { $paramAppArray = array('cdrequest' => $request, 'nmdeliveryperson' => $delivery, 'dtappraisaldelivery' => $datahora . $time . ":00"); $deliveryModel->insert($paramAppArray); $message = 'Cadastro efetuado com sucesso'; $gslab_db->commit(); } catch (Exception $e) { $message = "Erro na inserção dos dados." + $e->getMessage(); $this->_model->getAdapter()->rollBack(); } $this->view->message = $message; $RequestArray = array('fgstatus' => 6); $modelRequest->update($RequestArray, "cdrequest = " . $request . " AND fgstatus = 5"); }
public function getRequestsData($array, $allowedstatus) { //PESQUISA POR PACIENTE $sector = $array['sector']; if ($sector == '-1') { $sector = null; } $select = $this->select()->from($this->_name)->join("requestexaminationsample", "requestexaminationsample.cdrequest = request.cdrequest")->join("mapsample", "requestexaminationsample.cdrequestexaminationsample = mapsample.cdrequestexaminationsample", array("cdmap", "nrmappage"))->join("map", "mapsample.cdmap = map.cdmap", array("cddepartment", "dtmaprendering"))->join("requestexamination", "requestexaminationsample.cdrequestexamination = requestexamination.cdrequestexamination", array("cdrequestexamination", "fgstatus"))->join("forward", "request.cdforward = forward.cdforward", "forward.nmforward", array())->join("company", "request.cdcompany = company.cdcompany", array())->join("client", "request.cdclient = client.cdclient")->join("covenantpricing", "requestexamination.cdexamination = covenantpricing.cdexamination")->join("covenant", "covenantpricing.cdcovenant = covenant.cdcovenant", array())->join("examinationmaterialrequest", "requestexamination.cdrequestexamination = examinationmaterialrequest.cdrequestexamination")->join("examinationmaterial", "examinationmaterialrequest.cdexaminationmaterial = examinationmaterial.cdexaminationmaterial")->join("material", "examinationmaterial.cdmaterial = material.cdmaterial")->join("examination", "covenantpricing.cdexamination = examination.cdexamination")->join("department", "examinationmaterial.cddepartment = department.cddepartment")->where("request.cdcovenant = covenant.cdcovenant")->where("requestexamination.fgstatus IN (?)", $allowedstatus)->group("mapsample.cdrequestexaminationsample")->setIntegrityCheck(false); if (isset($array['sidx']) && isset($array['sord'])) { $select->order(array($array['sidx'] . " " . $array['sord'], "")); } if (isset($array['page'])) { $select->limit($array['page'], 1); } if (isset($array['page']) && isset($array['rows'])) { $select->limitpage($array['page'], $array['rows']); } if (isset($array['cdpatient']) && $array['cdpatient'] != null) { $select->where("client.cdclient = ?", $array['cdpatient']); if (isset($array['cdrequest']) && $array['cdrequest'] != null) { $select->where("request.cdrequest = ?", $array['cdrequest']); } if (isset($array['nrsample']) && $array['nrsample'] != null) { $select->where("requestexaminationsample.nmbarcodesample LIKE ?", '%' . $array['nrsample'] . '%'); } if (isset($array['sector']) && $array['sector'] != null) { $sector = explode(",", $array['sector']); $select->where("department.cddepartment in (?)", $sector); } if (isset($array['startdate']) && $array['startdate'] != null) { $startDate = GslabUtils::dateToDatabaseFormat($array['startdate']); $select->where("request.dtrequest >= ?", $startDate); } if (isset($array['enddate']) && $array['enddate'] != null) { $enddate = GslabUtils::dateToDatabaseFormat($array['enddate']); $select->where("request.dtrequest <= ?", $enddate); } } $select->where("examinationmaterial.cdexaminationmaterialparent is null"); //PESQUISA POR MAPA if (isset($array['cdmap']) && $array['cdmap'] != null) { $select->where("mapsample.cdmap LIKE ?", "%" . $array['cdmap'] . "%"); if (isset($array['sector2']) && $array['sector2'] != null && $array['sector2'] != "-1") { $select->where("map.cddepartment IN (?)", $array['sector2']); } // if (isset($array['homepage']) && $array['homepage'] != null) { // $select->where("mapsample.nrmappage > ?", $array['homepage']); // } // if (isset($array['lastpage']) && $array['lastpage'] != null) { // $select->where("mapsample.nrmappage < ?", $array['lastpage']); // } if (isset($array['dtfirstmaps']) && $array['dtfirstmaps'] != null) { $startdate = GslabUtils::dateToDatabaseFormat($array['dtfirstmaps']); $select->where("map.dtmaprendering >= ?", $startdate); } if (isset($array['dtendmaps']) && $array['dtendmaps'] != null) { $enddate = GslabUtils::dateToDatabaseFormat($array['dtendmaps']); $select->where("map.dtmaprendering <= ?", $enddate); } } // PESQUISA PELOS ÚLTIMOS RESULTADOS if (!isset($array['cdmap']) && !isset($array['cdpatient']) && (isset($array['startTime']) || isset($array['endTime']))) { if (isset($array['startDate']) && $array['startDate'] != null) { $date = $array['startDate'] . " " . $array['startTime']; $startDate = GslabUtils::dateToDatabaseFormat($date); $select->where("request.dtrequest >= ?", $startDate); } if (isset($array['endDate']) && $array['endDate'] != null) { $date = $array['endDate'] . " " . $array['endTime']; $enddate = GslabUtils::dateToDatabaseFormat($array['endDate'] . " " . $array['endTime']); $select->where("request.dtrequest <= ?", $enddate); } } return $select; }
private function getAppraisalRequestData($cdrequest = null, $cdmap = null, $array = null) { $query = "\r\n SELECT\r\n /* examination */\r\n examination.cdexamination,\r\n examination.nmexamination,\r\n\r\n /* examinationmaterial */\r\n examinationmaterial.cdexaminationmaterial,\r\n examinationmaterial.cdexaminationmaterialparent,\r\n\r\n /* requestexamination */\r\n requestexamination.cdrequestexamination,\r\n\r\n /* request */\r\n request.cdrequest,\r\n\r\n /* requestexaminationsample */\r\n requestexaminationsample.nmbarcodesample,\r\n requestexaminationsample.cdrequestexaminationsample,\r\n \r\n /* mapsample */\r\n mapsample.*, \r\n \r\n /* map */\r\n map.*,\r\n \r\n /* clinet */\r\n client.nmclient,\r\n client.dtbirth,\r\n\r\n /* forward */\r\n forward.nmforward,\r\n\r\n /* material */\r\n material.idmaterial,\r\n material.nmmaterial,\r\n\r\n /* requestexamination */\r\n requestexamination.fgstatus,\r\n requestexamination.dtcollection,\r\n \r\n /* method */\r\n method.nmmethod\r\n\r\n from\r\n request,\r\n examination,\r\n examinationmaterial,\r\n requestexamination,\r\n examinationmaterialrequest,\r\n requestexaminationsample,\r\n mapsample,\r\n map,\r\n client,\r\n forward,\r\n material,\r\n method,\r\n department,\r\n covenant\r\n /*\r\n attribute,\r\n attributeexaminationmaterial,\r\n vlrefattribexammaterial,\r\n factor,\r\n measurementunit\r\n */\r\n \r\n where\r\n requestexamination.cdrequest = request.cdrequest \r\n and examination.cdexamination = examinationmaterial.cdexamination\r\n and examinationmaterialrequest.cdrequestexamination = requestexamination.cdrequestexamination \r\n and examinationmaterialrequest.cdexaminationmaterial = examinationmaterial.cdexaminationmaterial \r\n and requestexaminationsample.cdrequest = request.cdrequest \r\n and requestexaminationsample.cdrequestexamination = requestexamination.cdrequestexamination \r\n and requestexaminationsample.cdrequestexaminationsample = mapsample.cdrequestexaminationsample\r\n and mapsample.cdmap = map.cdmap\r\n and client.cdclient = request.cdclient \r\n and forward.cdforward = request.cdforward \r\n and examinationmaterial.cdmaterial = material.cdmaterial \r\n and method.cdmethod = examinationmaterial.cdmethod\r\n and examinationmaterial.cddepartment = department.cddepartment\r\n and request.cdcovenant = covenant.cdcovenant\r\n and requestexamination.fgstatus IN (1,2,3) \r\n \r\n /* Attribute table keys \r\n and attribute.cdattribute = factor.cdattribute\r\n and attribute.cdattribute = attributeexaminationmaterial.cdattribute\r\n and attribute.cdmeasurementunit = measurementunit.cdmeasurementunit\r\n\r\n and attributeexaminationmaterial.cdattribute = vlrefattribexammaterial.cdattributeexaminationmaterial\r\n and attributeexaminationmaterial.cdattribute = factor.cdattribute\r\n and attributeexaminationmaterial.cdexaminationmaterial = examinationmaterial.cdexaminationmaterial\r\n\r\n and vlrefattribexammaterial.cdfactor = factor.cdfactor\r\n */\r\n "; //Aqui é tratada o tipo de busca, pois em uma busca por mapa não é necessário filtrar a request if ($cdrequest != null && $cdmap == null) { $cdrequest = implode(",", $cdrequest); $query .= " and request.cdrequest in ({$cdrequest})"; if (isset($array['nmsample']) && $array['nmsample'] != null) { $query .= " and requestexaminationsample.nmbarcodesample LIKE '%" . $array['nmsample'] . "%'"; } if (isset($array['startdtrequest']) && $array['startdtrequest'] != null) { $startdtrequest = GslabUtils::dateToDatabaseFormat($array['startdtrequest']); $query .= " and request.dtrequest >= " . $startdtrequest; } if (isset($array['enddtrequest']) && $array['enddtrequest'] != null) { $enddtrequest = GslabUtils::dateToDatabaseFormat($array['enddtrequest']); $query .= " and request.dtrequest <= " . $enddtrequest; } } else { if ($cdmap != null) { $query .= " and mapsample.cdmap = {$cdmap} "; if (isset($array['startpage']) && $array['startpage'] != null) { $query .= " and mapsample.nrmappage >= " . $array['startpage']; } if (isset($array['endpage']) && $array['endpage'] != null) { $query .= " and mapsample.nrmappage <= " . $array['endpage']; } if (isset($array['startdtmaprendering']) && $array['startdtmaprendering'] != null) { $startdtmaprendering = GslabUtils::dateToDatabaseFormat($array['startdtmaprendering']); $query .= " and map.dtmaprendering >= " . $startdtmaprendering; } if (isset($array['enddtmaprendering']) && $array['enddtmaprendering'] != null) { $enddtmaprendering = GslabUtils::dateToDatabaseFormat($array['enddtmaprendering']); $query .= " and map.dtmaprendering <= " . $enddtmaprendering; } } } // Agrupamento pelo código da amostra para evitar duplicidades // por número da página em que a amostra se encontra no mapa $query .= " group by mapsample.cdrequestexaminationsample"; //$query .= " GROUP BY examination.cdexamination"; // echo "query: $query <br />"; // die(); $bootstrap = $this->getInvokeArg('bootstrap'); $gslab_db = $bootstrap->getResource('db'); $query = $gslab_db->query($query); $result = $query->fetchAll(); return $result; }
public function includeAction() { $clientModel = new ClientModel(); $clientModel->getAdapter()->beginTransaction(); $savetype = $this->_request->getParam("type"); $covenantdata = $this->_request->getParam("covenantdata"); $clientPhoneModel = new ClientphonenumberModel(); $clientAdressModel = new ClientaddressModel(); $clientcovenantModel = new ClientcovenantModel(); $paramClientArray = array(); $idcpf = $this->_request->getParam('idcpf'); $idcep = $this->_request->getParam('idcep'); // *** Remove caracteres do CPF e RG *** $idcpf = str_replace(array(".", "-"), "", $idcpf); $idcep = str_replace("-", " ", $idcep); $paramClientArray = array('cdclient' => $this->_request->getParam('cdclient'), 'nmclient' => $this->_request->getParam('nmclient'), 'nmmail' => $this->_request->getParam('nmmail'), 'fgsex' => $this->_request->getParam('fgsex'), 'idrg' => $this->_request->getParam('idrg'), 'idcpf' => $idcpf, 'dtbirth' => $this->_request->getParam('dtbirth'), 'dtdum' => $this->_request->getParam('dtdum'), 'nmprofessional' => $this->_request->getParam('nmprofessional'), 'nrweight' => $this->_request->getParam('nrweight'), 'nrheight' => $this->_request->getParam('nrheight'), 'nmimage' => $this->_request->getParam('nmimage'), 'fgbloodtype' => $this->_request->getParam('fgbloodtype'), 'fgdufactor' => $this->_request->getParam('fgdufactor'), 'fgrhfactor' => $this->_request->getParam('fgrhfactor'), 'fgskincolor' => $this->_request->getParam('fgskincolor'), 'nrsonsnumber' => $this->_request->getParam('nrsonsnumber'), 'nmfather' => $this->_request->getParam('nmfather'), 'nmmother' => $this->_request->getParam('nmmother'), 'dsobservation' => $this->_request->getParam('dsobservation'), 'fgvip' => $this->_request->getParam('fgvip'), 'fgmailmkt' => $this->_request->getParam('fgmailmkt'), 'fgsmoker' => $this->_request->getParam('fgsmoker'), 'fgdiabetes' => $this->_request->getParam('fgdiabetes'), 'fgmaritalstatus' => $this->_request->getParam('fgmaritalstatus'), 'nrcardnumber' => $this->_request->getParam('nrcardnumber')); if (isset($paramClientArray["dtbirth"]) && $paramClientArray["dtbirth"] != '') { $paramClientArray["dtbirth"] = GslabUtils::dateToDatabaseFormat($paramClientArray["dtbirth"]); } if (isset($paramClientArray["dtdum"]) && $paramClientArray["dtdum"] != '') { $paramClientArray["dtdum"] = GslabUtils::dateToDatabaseFormat($paramClientArray["dtdum"]); } if ($savetype == 'edit') { $this->_model->update($paramClientArray, 'cdclient = ' . $this->_request->getParam('cdclient')); $cdclient = $this->_request->getParam('cdclient'); } else { if ($savetype == 'add') { $cdclient = $this->_model->insert($paramClientArray); } } //*** Insere os dados do ClientAddress*** $paramAddressArray = array('cdclient' => $cdclient, 'idcep' => $idcep, 'nmstreet' => $this->_request->getParam('nmstreet'), 'idaddresstype' => $this->_request->getParam('idaddresstype'), 'nmclientaddress' => $this->_request->getParam('nmclientaddress'), 'nrnumber' => $this->_request->getParam('nrnumber'), 'nmneighborhood' => $this->_request->getParam('nmneighborhood'), 'idcity' => $this->_request->getParam('idcity'), 'idstate' => $this->_request->getParam('fgstate'), 'idcomplement' => $this->_request->getParam('idcomplement')); if ($savetype == 'edit') { $clientAdressModel->update($paramAddressArray, 'cdclient = ' . $this->_request->getParam('cdclient')); } else { if ($savetype == 'add') { $clientAdressModel->insert($paramAddressArray); } } //*** Insere os dados do ClientPhoneNumber *** if ($this->_request->getParam('nrphonenumber') != '' || $this->_request->getParam('nrcellphone') != '') { $paramPhoneArray = array('cdclient' => $cdclient, 'nrphonenumber' => $this->_request->getParam('nrphonenumber'), 'nrdddphone' => $this->_request->getParam('nrdddphone'), 'nrdddcellphone' => $this->_request->getParam('nrdddcellphone'), 'nrcellphonenumber' => $this->_request->getParam('nrcellphone')); if ($this->_request->getParam('cdclientphonenumber') != '') { $clientPhoneModel->update($paramPhoneArray, 'cdclientphonenumber = ' . $this->_request->getParam('cdclientphonenumber')); } else { $clientPhoneModel->insert($paramPhoneArray); } } if (!empty($covenantdata)) { $covenantdata = json_decode($covenantdata); $client = $this->_request->getParam("cdclient"); if ($client != '') { $clientcovenantModel->delete('cdclient = ' . $client); } foreach ($covenantdata as $linha) { if ($linha->fgstatus == 0) { $linha->fgstatus = 2; } $arrayCovenant = array('cdclient' => $cdclient, 'cdcovenant' => $linha->cdcovenant, 'idcovenantcard' => $linha->nrregistration, 'nmcardholder' => $linha->nmcardholder, 'dtreference' => date("Y-m-d H:i:s"), 'fgactive' => $linha->fgstatus); try { $clientcovenantModel->insert($arrayCovenant); } catch (Exception $e) { header("HTTP/1.0 406 Não foi possivel salvar os dados do paciente no sistema: Erro Interno -> " . $e->getMessage() . "."); } $arrayCovenant = ''; } } echo 'tudo ok'; $this->_model->getAdapter()->commit(); // $values = $this->_request->getParam("data"); // $values = explode("&", $values); // // /* // * Organiza em um array os dados recebidos // */ // $formData = array(); // foreach($values as $value) // { // $value = explode("=", $value); // $formData[ $value[0] ] = $value[1]; // $formData = str_replace("+", " ", $formData); // } // // $values = $formData; // // // $savetype = $this->_request->getParam("type"); // $covenantdata = $this->_request->getParam("covenantdata"); //// $img = $_GET["img"]; // // $clientPhoneModel = new ClientphonenumberModel(); // $clientAdressModel = new ClientaddressModel(); // $clientcovenantModel = new ClientcovenantModel(); // //// *** Remove caracteres do CPF e RG *** // $values["idcpf"] = str_replace(array(".", "-"), "", $values["idcpf"]); // $values["nrheight"] = str_replace(",", ".", $values["nrheight"]); // // $this->_model->getAdapter()->beginTransaction(); // // $paramClientArray = array(); // // try // { // // $idstate = GslabUtils::getBrazilianStatePrefix($values['idstate']); // $nmclientaddress = GslabUtils::getLogradouroSaveDataBase($values['idaddresstype']); // // // // $paramClientArray = array( // 'cdclient' => $values['cdclient'], // 'nmclient' => $values['nmclient'], // 'nmmail' => $values['nmmail'], // 'fgsex' => $fgsex, // 'idrg' => $values['idrg'], // 'idcpf' => $values['idcpf'], // 'dtbirth' => $values['dtbirth'], // 'nrweight' => $values['nrweight'], // 'nrheight' => $values['nrheight'], //// 'nmimage' => $img, // 'fgbloodtype' => $values['fgbloodtype'], // 'fgdufactor' => $values['fgdufactor'], // 'fgrhfactor' => $values['fgrhfactor'], // 'fgskincolor' => $values['fgskincolor'], // 'nrsonsnumber' => $values['nrsonsnumber'], // 'nmfather' => $values['nmfather'], // 'nmmother' => $values['nmmother'], // 'dsobservation' => $values['dsobservation'], // 'fgvip' => $fgvip, // 'fgmailmkt' => $fgmailmkt, // 'fgsmoker' => $fgsmoker, // 'fgdiabetes' => $fgdiabetes // ); // // if (isset($paramClientArray["dtbirth"]) && $paramClientArray["dtbirth"] != '') // $paramClientArray["dtbirth"] = GslabUtils::dateToDatabaseFormat($paramClientArray["dtbirth"]); // // if ($savetype == 'edit') // $this->_model->update($paramClientArray, 'cdclient = ' . $values['cdclient']); // else if ($savetype == 'add') // $values['cdclient'] = $this->_model->insert($paramClientArray); // // //*** Insere os dados do ClientAddress*** // $paramAddressArray = array( // 'cdclient' => $values['cdclient'], // 'idcep' => $values['idcep'], // 'nmstreet' => $values['nmstreet'], // 'idaddresstype' => $values['idaddresstype'], // 'nmclientaddress' => $nmclientaddress, // 'nrnumber' => $values['nrnumber'], // 'nmneighborhood' => $values['nmneighborhood'], // 'idcity' => $values['idcity'], // 'idstate' => $values['idstate'], // 'idcomplement' => $values['idcomplement'] // ); // // if ($savetype == 'edit') // $clientAdressModel->update($paramAddressArray, 'cdclient = ' . $values['cdclient']); // else if ($savetype == 'add') // $clientAdressModel->insert($paramAddressArray); // // // //*** Insere os dados do ClientPhoneNumber *** // if (isset($values['nrcomercialphone']) && $values['nrcomercialphone'] != '') // { // $dddRes = 47; // $numRes = $values['nrcomercialphone']; // // $paramPhoneArray = array( // 'cdclient' => $values['cdclient'], // 'nrdddphone' => $dddRes, // 'nrphonenumber' => $numRes, // 'fgtypephone' => 1 // ); // // // if (count($clientPhoneModel->fetchAll('cdclient = ' . $values['cdclient'])) > 0) // $clientPhoneModel->update($paramPhoneArray, 'cdclient = ' . $values['cdclient']); // else // $clientPhoneModel->insert($paramPhoneArray); // // } // // if (isset($values['nrphonenumber']) && $values['nrphonenumber'] != '') // { // $numeroCel = explode(" ", $values['nrphonenumber']); // $dddCel = 47; // $numCel = $values['nrphonenumber']; // // $paramCelArray = array( // 'cdclient' => $values['cdclient'], // 'nrdddphone' => $dddCel, // 'nrphonenumber' => $numCel, // 'fgtypephone' => 3 // ); // // if (count($clientPhoneModel->fetchAll('cdclient = ' . $values['cdclient'])) > 0) // $clientPhoneModel->update($paramCelArray, 'cdclient = ' . $values['cdclient']); // else // $clientPhoneModel->insert($paramCelArray); // } // // //$clientcovenantModel->delete('cdclient = ' . $values['cdclient']); // //print_r('cdclient: '. $values['cdclient']); // //die('here'); // // if(!empty($covenantdata)) // { // $covenantdata = json_decode($covenantdata); // foreach ($covenantdata as $linha) // { // if ($linha->fgstatus == 0) // $linha->fgstatus = 2; // // $arrayCovenant = array( // 'cdclient' => $values['cdclient'], // 'cdcovenant' => $linha->cdcovenant, // 'idcovenantcard' => $linha->nrregistration, // 'nmcardholder' => $linha->nmcardholder, // 'dtreference' => date("Y-m-d H:i:s"), // 'fgactive' => $linha->fgstatus // ); // // try // { // $clientcovenantModel->insert($arrayCovenant); // } // catch (Exception $e) // { // header("HTTP/1.0 406 Não foi possivel salvar os dados do paciente no sistema: Erro Interno -> ".$e->getMessage()."."); // } // $arrayCovenant = ''; // } // //print_r('covenantdata1: '. $arrayCovenant); // //die(); // // } // // echo 'tudo ok'; // $this->_model->getAdapter()->commit(); // } // catch (Exception $e) // { // $this->_model->getAdapter()->rollBack(); // header("HTTP/1.0 406 Não foi possivel salvar os dados do paciente no sistema: Erro Interno -> ".$e->getMessage()."."); // } }