public function detalleproveedorAction() { //Conectamos con BBDD $sid = new Container('base'); $db_name = $sid->offsetGet('dbNombre'); $this->dbAdapter = $this->getServiceLocator()->get($db_name); //Instancias $prv = new ProveedorTable($this->dbAdapter); $tps = new TipoServicioTable($this->dbAdapter); $vpr = new VProveedorTable($this->dbAdapter); //Obtenemos id de Proveedor $data = $this->getRequest()->getPost(); //Consultamos Proveedor y sus servicios en BBDD $prov = $prv->getProveedoresId($data['id']); $serv = $tps->getServicioId($prov[0]['id_servicio']); $vpro = $vpr->getProveedoresId($prov[0]['id']); $prov[0]['servicio'] = $serv[0]['nombre']; $prov[0]['categoria'] = $serv[0]['categoria']; $prov['0']['rut'] = number_format($prov['0']['rut'], -3, "", ".") . "-" . ucfirst($prov['0']['dv']); $prov['0']['monto'] = $vpro[0]['monto']; $prov['0']['fecha'] = date("d-m-Y", strtotime($vpro[0]['ultimopago'])); $result = new JsonModel($prov); return $result; }
public function nuevoaseguradorAction() { //Conectamos con BBDD $sid = new Container('base'); $db_name = $sid->offsetGet('dbNombre'); $this->dbAdapter = $this->getServiceLocator()->get($db_name); //Instancias $form = new ProveedorForm("form"); $ban = new ListaBancoTable($this->dbAdapter); $srv = new TipoServicioTable($this->dbAdapter); //Obtenemos Datos y cargamos Formulario $tipos = $srv->getComboAseguradora($this->dbAdapter); $servi = $srv->getComboServAseguradora($this->dbAdapter); $bancos = $ban->getDatos(); //Cargamos combos $form->get('categoria')->setAttribute('options', $tipos); $form->get('categoria')->setAttribute('disabled', 'disabled'); $form->get('servicio')->setAttribute('options', $servi); $form->get('servicio')->setAttribute('disabled', 'disabled'); $form->get('id_banco')->setAttribute('options', $bancos); //Retornamos a la vista $result = new ViewModel(array('form' => $form)); $result->setTerminal(true); return $result; }