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 editAction()
{
$cdclient = $this->_request->getParam("cdclient");
$addressTypeModel = new AddresstypeModel();
$this->view->addressTypeData = $addressTypeModel->getAllAddressType();
$clientModel = new ClientModel();
$clientadressModel = new ClientaddressModel();
$clientphoneModel = new ClientphonenumberModel();
$clientaddressData = $clientadressModel->fetchRow();
$client = $clientModel->fetchRow('cdclient = ' . $cdclient);
$this->view->client = $client;
$age = $this->view->client->dtbirth;
$data = new Zend_Date($this->view->client->dtbirth, "YYYY-MM-dd HH:mm:ss");
$this->view->client->dtbirth = $data->toString('dd-MM-YYYY');
$this->view->nrage = GslabUtils::calcAgeDifferenceShort($age);
$this->view->address = $clientadressModel->fetchRow($clientadressModel->getStateById($clientaddressData['idstate'], $cdclient));
$clientphoneData = $clientphoneModel->fetchRow('cdclient = ' . $cdclient);
$this->view->phone = $clientphoneData;
if ($client['dtdum'] != '') {
$client['dtdum'] = new Zend_Date($this->view->client->dtdum, "YYYY-MM-dd HH:mm:ss");
$this->view->dtdum = $client['dtdum']->toString('dd-MM-YYYY');
} else {
$this->view->dtdum = '';
}
if ($clientphoneData['cdclientphonenumber'] != '') {
$cdclientphonenumber = $clientphoneData['cdclientphonenumber'];
if ($clientphoneData['nrphonenumber'] != '') {
$phonenumber = $clientphoneData['nrphonenumber'];
$dddphonenumber = $clientphoneData['nrdddphone'];
} else {
$phonenumber = '';
$dddphonenumber = '';
}
if ($clientphoneData['nrcellphonenumber'] != '') {
$cellphonenumber = $clientphoneData['nrcellphonenumber'];
$dddcellphonenumber = $clientphoneData['nrdddcellphone'];
} else {
$cellphonenumber = '';
$dddcellphonenumber = '';
}
} else {
$phonenumber = '';
$dddphonenumber = '';
$cdclientphonenumber = '';
$cellphonenumber = '';
$dddcellphonenumber = '';
}
$this->view->nrphonenumber = $phonenumber;
$this->view->nrcellphonenumber = $cellphonenumber;
$this->view->nrdddphone = $dddphonenumber;
$this->view->nrdddcellphone = $dddcellphonenumber;
$this->view->cdclientphonenumber = $cdclientphonenumber;
}