public function resumenPersona($cidpers, $crazsoc)
{
$parameters[] = $cidpers;
$dataAdapter = new Model_DataAdapter();
$rows = $dataAdapter->executeAssocQuery("pl_function.panel_persona", $parameters);
if ($rows != null) {
$mperson = $rows[0];
} else {
$mperson = array('cidpers' => $cidpers, 'crazsoc' => $crazsoc, 'vnrodoc' => 'No existe información', 'dfecdoc' => '', 'vmotivo' => '', 'ntotpre' => '0', 'ntotcom' => '0', 'nbaseim' => '0.00', 'nimpanu' => '0.00', 'vprofis' => 'No', 'vprotra' => 'No', 'dfecpag' => '');
}
$rows = $dataAdapter->executeAssocQuery("pl_function.resumen_saldo_personal", $parameters);
if ($rows != null) {
$msaldos = $rows[0];
} else {
$msaldos = array('cidpers' => '', 'ntotals' => '', 'npendie' => '', 'ncancel' => '', 'nporcen' => '', 'vindica' => 'ff0000.png');
}
return array("mperson" => $mperson, "msaldos" => $msaldos);
}
public function registrarAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->getHelper('ajaxContext')->initContext();
if ($this->getRequest()->isXmlHttpRequest()) {
$name = $this->_request->getParam('name');
$procedure = $this->_request->getParam('procedure');
$print = $this->_request->getParam('print');
$parameters = json_decode($this->_request->getParam('parameters'), true);
$dataAdapter = new Model_DataAdapter();
if ($print == 'true') {
$rows = $dataAdapter->executeAssocQuery($procedure, $parameters);
$this->_helper->viewRenderer->setNoRender();
echo $this->_helper->json($rows);
} else {
$records = $dataAdapter->saveQuery($name, $procedure, $parameters);
$this->view->name = $name;
$this->view->records = $records;
}
}
}
public function listarpredioAction()
{
$this->_helper->getHelper('ajaxContext')->initContext();
if ($this->getRequest()->isXmlHttpRequest()) {
$this->_helper->layout->disableLayout();
$name = $this->_request->getParam('name');
if (isset($name)) {
$dataSet = new Zend_Session_Namespace($name);
$rows = $dataSet->data;
$this->view->cidpers = $rows[0][0];
$this->view->vnombre = $rows[0][1];
$this->view->vdirecc = $rows[0][2];
$this->_request->setParam('cidpers', $rows[0][0]);
} else {
$this->view->cidpers = $this->_request->getParam('cidpers');
$this->view->vnombre = $this->_request->getParam('crazsoc');
$this->view->vdirecc = $this->_request->getParam('direccf');
$mhresum = $this->_request->getParam('mhresum');
if (isset($mhresum)) {
$this->view->mhresum = $this->_request->getParam('mhresum');
$this->view->vnrodoc = $this->_request->getParam('vnrodoc');
} else {
$parameters[] = $this->view->cidpers;
$dataAdapter = new Model_DataAdapter();
$rows = $dataAdapter->executeAssocQuery("pl_function.panel_persona", $parameters);
if (count($rows) == 1) {
$this->view->mhresum = $rows[0]['mhresum'];
$this->view->vnrodoc = $rows[0]['vnrodoc'];
}
}
}
//$this->view->cidpers;
//'%','0','2013-03-08','0','0','%'
$parameters[] = $this->view->cidpers;
$parameters[] = '%';
$parameters[] = '0';
$parameters[] = date("y-m-d");
$parameters[] = '0';
$parameters[] = '0';
$parameters[] = '%';
$dataAdapter = new Model_DataAdapter();
$rows = $dataAdapter->executeAssocQuery("tesoreria.fx_Estadocuenta", $parameters);
// echo count($rows );
// print_r($rows);
$pintar = new Libreria_Pintar();
if (count($rows) > 0) {
$deudas = '<table width="500" >';
// $deudas.='<tr>';
// $deudas.='<td>Tributo</td>';
// $deudas.='<td>Cod.Predio</td>';
// $deudas.='<td>Año</td>';
// $deudas.='<td>Periodo</td>';
// $deudas.='<td>Insoluto</td>';
// $deudas.='<td>Mora</td>';
// $deudas.='<td>Total</td>';
// $deudas.='<td>Estado</td>';
// $deudas.='<td><input type="checkbox" id="checkfracctodos" onClick="checktodosfracci();" /></td>';
// $deudas.='</tr>';
$montototal = 0;
for ($i = 0; $i < count($rows); ++$i) {
$montototal += $rows[$i]['ntotals'];
$deudas .= '<tr>';
$deudas .= '<td>' . (string) $rows[$i]['ctiprc0'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['ccodpre'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['cejerci'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['cperiod'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['nimpins'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['nimpmor'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['ntotals'] . '</td>';
$deudas .= '<td>' . (string) $rows[$i]['vestad2'] . '</td>';
$deudas .= '<td><input id="' . $rows[$i]['idsigma'] . '" type="checkbox" class="checkfracc" value="' . $rows[$i]['ntotals'] . '" onclick="calculamontofracc(this.id);" /> </td>';
$deudas .= '</tr>';
}
$deudas .= '</table>';
$val[] = array('tabladeudas', $deudas, 'html');
$val[] = array('txtdeudatotal', $montototal, 'val');
//$js[]=array('$("#txtnrocuotas").spinner();');
$js[] = array('themeTextBox(); themeComboBox();');
$pintar->PintarValor($val);
$pintar->EjecutarFuncion($js);
}
}
}
public function guardarrusticoAction()
{
$this->_helper->getHelper('ajaxContext')->initContext();
if ($this->getRequest()->isXmlHttpRequest()) {
$this->_helper->layout->disableLayout();
$ddatosuserlog = new Zend_Session_Namespace('datosuserlog');
$coduser = $ddatosuserlog->cidpers;
$vhostnm = $ddatosuserlog->vhostnm;
/* cubinor
cubisur
cubiest
cubioes
cpronor
cprosur
cproest
cprooes
cpculti
canagua
nestado
*/
$row = $_POST['idsigma'] . ',' . $_POST['dpredio'] . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . '' . ',' . $_POST['nestado'] . ',' . $vhostnm . ',' . $coduser . ',' . date("y-m-d");
$parameters[] = $row;
$dataAdapter = new Model_DataAdapter();
$rows = $dataAdapter->executeSelect("pl_function.guardar_mrustic", $parameters);
$row2 = $_POST['idsigma'] . ',' . $rows[0][0] . ',' . $_POST['cclasif'] . ',' . $_POST['ccatego'] . ',' . $_POST['narance'] . ',' . $_POST['nhectar'] . ',' . $_POST['nvalrus'] . ',' . $_POST['nestado'] . ',' . $vhostnm . ',' . $coduser . ',' . date("y-m-d") . ',' . $_POST['cperiod'];
$parameters2[] = $row2;
$dataAdapter2 = new Model_DataAdapter();
$rows2 = $dataAdapter->executeSelect("pl_function.guardar_drustic", $parameters2);
if ($rows > 0) {
$parameters3 = array($_POST['dpredio'], $_POST["cperiod"]);
$data['error'] = "";
$data['data'] = $dataAdapter->executeAssocQuery("pl_function.listar_caracteristica_rustico", $parameters3);
} else {
$data['error'] = "Error al actualizar";
$data['data'] = "";
}
$this->_helper->json($data);
}
}
