public function onLoad($param) { parent::onLoad($param); $nl = new NumALetras(); $this->dbConexion = Conexion::getConexion($this->Application, "db"); Conexion::createConfiguracion(); if (!$this->IsPostBack) { if (isset($this->Request["nota"])) { $importe = Conexion::Retorna_Campo($this->dbConexion, "cobros", "credito", array("id_nota" => $this->Request["nota"])); $pagare = Conexion::Retorna_Registro($this->dbConexion, "pagares", array("id_nota" => $this->Request["nota"])); $this->lblNumero->Text = $pagare[0]["id_pagare"]; $this->lblImporte->Text = number_format($importe, 2); $this->lblLugarFirma->Text = $pagare[0]["lugarfirma"]; $this->lblDia->Text = date("d", strtotime($pagare[0]["fecha"])); $this->lblMes->Text = $this->meses[date("m", strtotime($pagare[0]["fecha"]))]; $this->lblAnio->Text = date("Y", strtotime($pagare[0]["fecha"])); $this->lblCobrador->Text = $pagare[0]["cobrador"]; $this->lblLugarCobro->Text = $pagare[0]["lugarcobro"]; $this->lblCantidad->Text = $nl->ValorEnLetras($importe, " pesos ", " M.N."); $this->lblInteres->Text = $pagare[0]["interes"]; $this->lblDeudor->Text = $pagare[0]["deudor"]; } } }
public function onLoad($param) { parent::onLoad($param); $nal = new NumALetras(); /*$lienzo = imagecreatetruecolor(200, 200); $negro = imagecolorallocate($lienzo, 132, 135, 28); $dibujo = imagerectangle($lienzo, 45, 60, 120, 100, $negro);*/ $id_Contrato = $_REQUEST['id']; $this->dbConexion = Conexion::getConexion($this->Application, "dbpr"); Conexion::createConfiguracion(); $consulta = "SELECT c.id_contrato as contrato ,s.id_solicitud AS solicitud,s.titular AS titularr ,s.antiguedad AS antiguedad,s.creada AS creada,t.numero AS num_tit, t.nombre AS titular, st.cve_sindicato AS tit_cve_sind, st.sindicato AS tit_sind, TIMESTAMPDIFF(YEAR, t.fec_ingre, CURDATE()) AS tit_ant,\n\t\t\ts.aval1, a1.nombre AS aval1_n, sa1.cve_sindicato AS aval1_cve_sind, sa1.sindicato AS aval1_sind, TIMESTAMPDIFF(YEAR, a1.fec_ingre, CURDATE()) AS aval1_ant,\n\t\t\ts.aval2, a2.nombre AS aval2_n, sa2.cve_sindicato AS aval2_cve_sind, sa2.sindicato AS aval2_sind, TIMESTAMPDIFF(YEAR, a2.fec_ingre, CURDATE()) AS aval2_ant,\n\t\t\tDATE_FORMAT(s.firma,'%d/%m/%Y') AS firma, importe, plazo, tasa, saldo_anterior, descuento\n\t\t\t,(SELECT fec_ingre FROM empleados WHERE numero = s.aval1) AS AntiAval1\n\t\t\t,(SELECT fec_ingre FROM empleados WHERE numero = s.aval2) AS AntiAval2\n\t\t\tFROM contrato c\n\t\t\tLEFT JOIN Solicitud s ON s.id_solicitud = c.id_solicitud\n\t\t\tLEFT JOIN sujetos AS t ON t.numero = s.titular\n\t\t\tLEFT JOIN catsindicatos st ON st.cve_sindicato = s.cve_sindicato\n\t\t\tLEFT JOIN sujetos AS a1 ON a1.numero= s.aval1\n\t\t\tLEFT JOIN catsindicatos sa1 ON sa1.cve_sindicato = s.cve_sind_Aval1\n\t\t\tLEFT JOIN sujetos AS a2 ON a2.numero = s.aval2\n\t\t\tLEFT JOIN catsindicatos sa2 ON sa2.cve_sindicato = s.cve_sind_Aval2\n\t\t\tWHERE c.id_contrato = (SELECT MAX(id_contrato) AS contrato FROM contrato WHERE id_solicitud = :id_Contrato )"; $comando = $this->dbConexion->createCommand($consulta); $comando->bindValue(":id_Contrato", $id_Contrato); $result = $comando->query()->readAll(); foreach ($result as $rows) { $VarContrato = $rows['contrato']; $VarTitular = $rows['num_tit']; $VarNombreTitular = $rows['titular']; //$Solicitud=$rows['titular']; $VarAntiguedadTit = $rows['antiguedad']; $SindicatoTit = $rows['tit_sind']; $Importe = $rows['importe']; $Varaval1 = $rows['aval1']; $Varaval2 = $rows['aval2']; $VarnombreAval1 = $rows['aval1_n']; $VarnombreAval2 = $rows['aval2_n']; $AntiAval1 = $rows['AntiAval1']; $AntiAval2 = $rows['AntiAval2']; $VarsindicatoAval1 = $rows['aval1_sind']; $VarsindicatoAval2 = $rows['aval2_sind']; $VarFirmAvales = $rows['firma']; $inter = $rows["importe"] * $rows["plazo"] * $rows["tasa"] / 100; $Varsubtotals = $Importe - $inter; $Varsaldoanterior = 0; $VarImportecheque = 0; $quincena = $rows["plazo"] * 2; $VardescQuincenas = $Importe / $quincena; } $consultaDirec = "SELECT Nombre_completo FROM cat_director WHERE anio = YEAR(NOW())"; $comando = $this->dbConexion->createCommand($consultaDirec); $result = $comando->query()->readAll(); foreach ($result as $rows) { $VarDirector = $rows['Nombre_completo']; } $VarImporte = number_format($Importe, 2); $intereses = number_format($inter, 2); $VardescQuincena = number_format($VardescQuincenas, 2); $Varsubtotal = number_format($Varsubtotals, 2); $this->Titular = $VarTitular . " - " . $VarNombreTitular; $this->Contrato = $VarContrato; $this->importeNeto = $VarImporte; // $this->ImporteLetras = $nal->ValorEnLetras($Importe, "pesos", " M.N."); // $this->Avall1 = $Varaval1 . " - " . $VarnombreAval1; // $this->Avall2 = $Varaval2 . " - " . $VarnombreAval2; // $this->FirmaAvales = $VarFirmAvales; //$this->lienzo = imagecreatetruecolor(200, 200); }