public function saveAction()
{
// parent::saveAction();
$message = '';
$AccountEntryModel = new AccountentryModel();
$AccountEntryModel->getAdapter()->beginTransaction();
$AccountCheckModel = new AccountcheckModel();
$accountentrycheckModel = new AccountcheckaccountentryModel();
$paramAccountentry = array();
$paramAccountcheck = array();
$paramentrycheckArray = array();
$dtentrydate = $this->_request->getParam("dtentrydate");
if ($dtentrydate != '' && isset($dtentrydate)) {
$dtentrydate = new Zend_Date($dtentrydate, 'dd-MM-YYYY');
$dtentrydate = $dtentrydate->toString('YYYY-MM-dd');
}
$dttransactiondate = $this->_request->getParam("dttransactiondate");
if ($dttransactiondate != '' && isset($dttransactiondate)) {
$dttransactiondate = new Zend_Date($dttransactiondate, 'dd-MM-YYYY');
$dttransactiondate = $dttransactiondate->toString('YYYY-MM-dd');
}
$dtinvoicedate = $this->_request->getParam("dtinvoicedate");
if ($dtinvoicedate != '' && isset($dtinvoicedate)) {
$dtinvoicedate = new Zend_Date($dtinvoicedate, 'dd-MM-YYYY');
$dtinvoicedate = $dtinvoicedate->toString('YYYY-MM-dd');
}
$dtdeadline = $this->_request->getParam("dtdeadline");
if ($dtdeadline != '' && isset($dtdeadline)) {
$dtdeadline = new Zend_Date($dtdeadline, 'dd-MM-YYYY');
$dtdeadline = $dtdeadline->toString('YYYY-MM-dd');
}
$dtaccountcheckdate = $this->_request->getParam("dtaccountcheckdate");
if ($dtaccountcheckdate != '' && isset($dtaccountcheckdate)) {
$dtaccountcheckdate = new Zend_Date($dtaccountcheckdate, 'dd-MM-YYYY');
$dtaccountcheckdate = $dtaccountcheckdate->toString('YYYY-MM-dd');
}
$supplierModel = new SupplierModel();
$covenantModel = new CovenantModel();
if ($this->_request->getParam('fgclienttype') == 'a' && $this->_request->getParam('cdclient') != '') {
if ($this->_request->getParam('cdclient') != null && $this->_request->getParam('cdclient') != '') {
$favored = $this->_request->getParam('cdclient');
}
} else {
if ($this->_request->getParam('fgclienttype') == 'b' && $this->_request->getParam('cdclient') != '') {
if ($this->_request->getParam('cdclient') != null && $this->_request->getParam('cdclient') != '') {
$patientData = $covenantModel->fetchRow('cdcovenant = ' . $this->_request->getParam('cdclient'));
$favored = $patientData->cdcovenant;
}
}
}
if ($this->_request->getParam('cdsupplier') != '' && $this->_request->getParam('fgopernature') != '') {
$paramAccountentry = array('cdsupplier' => $this->_request->getParam('cdsupplier'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'cdusergslab' => $this->_request->getParam('cduser'), 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'), 'cdopernature' => $this->_request->getParam('fgopernature'));
} else {
if ($this->_request->getParam('cdsupplier') != '') {
$paramAccountentry = array('cdsupplier' => $this->_request->getParam('cdsupplier'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'cdusergslab' => $this->_request->getParam('cduser'), 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'));
} else {
if ($this->_request->getParam('cdclient') != '' && $this->_request->getParam('fgclienttype') == 'a' && $this->_request->getParam('fgopernature') != '') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'cdclient' => $favored, 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'), 'cdopernature' => $this->_request->getParam('fgopernature'));
} else {
if ($this->_request->getParam('cdclient') != '' && $this->_request->getParam('fgclienttype') == 'a') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'cdclient' => $favored, 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'));
} else {
if ($this->_request->getParam('cdclient') != '' && $this->_request->getParam('fgclienttype') == 'b' && $this->_request->getParam('fgopernature') != '') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'cdclient' => $favored, 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'), 'cdopernature' => $this->_request->getParam('fgopernature'));
} else {
if ($this->_request->getParam('cdclient') != '' && $this->_request->getParam('fgclienttype') == 'b') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'cdclient' => $favored, 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'));
} else {
if ($this->_request->getParam('cdclient') == '' && $this->_request->getParam('cdsupplier') == '' && $this->_request->getParam('fgopernature') != '') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'), 'cdopernature' => $this->_request->getParam('fgopernature'));
} else {
if ($this->_request->getParam('cdclient') == '' && $this->_request->getParam('cdsupplier') == '') {
$paramAccountentry = array('cdusergslab' => $this->_request->getParam('cduser'), 'nraccountentry' => $this->_request->getParam('nraccountentry'), 'fgaccountentrytype' => $this->_request->getParam('fgaccountentrytype'), 'cdsupply' => $this->_request->getParam('cdsupply'), 'fgaccountcheck' => $this->_request->getParam('fgaccountcheck'), 'dtdeadline' => $dtdeadline, 'vlinvoicevalue' => $this->_request->getParam('vlinvoicevalue'), 'idinvoiceref' => $this->_request->getParam('idinvoiceref'), 'dttransactiondate' => $dttransactiondate, 'dtentrydate' => $dtentrydate, 'dtinvoicedate' => $dtinvoicedate, 'dsaccountentrydescription' => $this->_request->getParam('dsaccountentrydescription'), 'fgclienttype' => $this->_request->getParam('fgclienttype'));
}
}
}
}
}
}
}
}
$paramAccountcheck = array('cdusergslab' => $this->_request->getParam('cdusergslab'), 'dtaccountcheckdate' => $dtaccountcheckdate, 'vlaccountcheckvalue' => $this->_request->getParam('vlaccountcheckvalue'), 'vltotaltaxvalue' => $this->_request->getParam('vltotaltaxvalue'), 'vlnetvalue' => $this->_request->getParam('vlnetvalue'));
//update
if ($this->_request->getParam('cdaccountentry') != '' && $this->_request->getParam('fgaccountcheck') == '0') {
$this->_model->update($paramAccountentry, 'cdaccountentry = ' . $this->_request->getParam('cdaccountentry'));
$cdaccountcheck = $AccountCheckModel->insert($paramAccountcheck);
$AccountCheckModel->getAdapter()->commit();
$message = "Baixa realizada com sucesso";
} else {
if ($this->_request->getParam('cdaccountentry') != '' && $this->_request->getParam('fgaccountcheck') == '1') {
$this->_model->update($paramAccountentry, 'cdaccountentry = ' . $this->_request->getParam('cdaccountentry'));
$cdaccountcheck = $AccountCheckModel->insert($paramAccountcheck);
$AccountCheckModel->getAdapter()->commit();
$paramentrycheckArray = array('cdaccountentry' => $this->_request->getParam('cdaccountentry'), 'cdaccountcheck' => $cdaccountcheck);
$accountentrycheckModel->getAdapter()->beginTransaction();
$accountentrycheckModel->insert($paramentrycheckArray);
$accountentrycheckModel->getAdapter()->commit();
$message = "Baixa realizada com sucesso";
} else {
if ($this->_request->getParam('cdaccountentry') == '' && $this->_request->getParam('fgaccountcheck') == '0') {
$AccountEntryModel->insert($paramAccountentry);
$message = "Cadastro efetuado com sucesso";
$AccountEntryModel->getAdapter()->commit();
} else {
if ($this->_request->getParam('cdaccountentry') == '' && $this->_request->getParam('fgaccountcheck') == '1') {
$cdaccountentry = $this->_model->insert($paramAccountentry);
$cdaccountcheck = $AccountCheckModel->insert($paramAccountcheck);
$message = "Cadastro efetuado com sucesso";
$this->_model->getAdapter()->commit();
$AccountCheckModel->getAdapter()->beginTransaction();
$AccountCheckModel->getAdapter()->commit();
$paramentrycheckArray = array('cdaccountentry' => $cdaccountentry, 'cdaccountcheck' => $cdaccountcheck);
$accountentrycheckModel->getAdapter()->beginTransaction();
$accountentrycheckModel->insert($paramentrycheckArray);
$accountentrycheckModel->getAdapter()->commit();
}
}
}
}
$this->view->message = $message;
}
public function searchgridAction()
{
$var = $this->_request->getParams();
$dtbegindate = null;
$dtenddate = null;
// $displaymode = null;
$accountentryModel = new AccountentryModel();
$billingModel = new BillingModel();
$dtbegindate = $this->_request->getParam("dtbegindate");
$dtenddate = $this->_request->getParam("dtenddate");
//$displaymode = $this->_request->getParam("displaymode");
$array = array();
$accountentryModel->getAdapter()->beginTransaction();
try {
$datebegin = new Zend_Date($array['dtbegindate'], 'dd-MM-YYYY');
$datebegin = $datebegin->toString('YYYY-MM-dd HH:mm:ss');
$dateend = new Zend_Date($array['dtenddate'], 'dd-MM-YYYY');
$dateend = $dateend->toString('YYYY-MM-dd HH:mm:ss');
// print_r($dataperiodaccount);
/* Faturamento */
$dataperiodBilling = $billingModel->fetchAll($billingModel->getdataBilling($datebegin, $dateend, $displaymode));
// print_r($dataperiodBilling);
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$count = count($accounts_receivable);
$responce = new stdClass();
/* Manipulação de dados para a grid */
$varsome = 0;
$index = 0;
foreach ($accounts_receivable as $row) {
$responce->cash_entry = $row->vlinvoicevalue;
// $responce->cash_exit = $row->nmcovenant;
// $responce->average_balance_period = $row->nmcovenant;
// $responce->accumulated_balance = $row->nmcovenant;
$index++;
}
$this->view->search = $responce;
// print_r($responce);
} catch (Exception $e) {
$accountentryModel->getAdapter()->rollback();
echo $e->getMessage();
}
}