<?php include "../seguridad.php"; require_once '../Connections/cn.php'; include "../clases/datos.php"; $objDatos = new datos(); $rsTreeview = $objDatos->ObtenerMenuAdministrativoSelAll($_SESSION['MM_Username']); $row_rsTreeview = $objDatos->PoblarMenuAdministrativoSelAll($rsTreeview); $totalRows_rsTreeview = mysql_num_rows($rsTreeview); $rsComprobante = $objDatos->ObtenerComprobanteOperacionSelAll($_GET['xyz']); $row_Comprobante = $objDatos->PoblarComprobanteOperacionSelAll($rsComprobante); $totalRows_rsComprobante = mysql_num_rows($rsComprobante); mysql_select_db($database_cn, $cn); $query_rsCab = "Select CodCliente, Nombres, Direccion, Telefono from cliente where CodCliente=" . $_GET['pqr'] . " "; $rsCab = mysql_query($query_rsCab, $cn) or die(mysql_error()); $row_rsCab = mysql_fetch_assoc($rsCab); $totalRows_rsCab = mysql_num_rows($rsCab); /*mysql_select_db($database_cn, $cn); $query_rsDetalle = "SELECT CASE b.Tipo WHEN 'Pension' THEN (SELECT concat('Pension - ',x.NroPension) FROM programacionalumno x WHERE x.CodProgramacionAlumno=b.Codigo) WHEN 'concepto' THEN (SELECT y.NombreProducto FROM productos y WHERE y.CodProducto=b.Codigo) END AS Concepto, b.Cantidad, b.PrecioUnit, b.Cantidad*b.PrecioUnit AS Monto, b.Dscto, b.Mora, b.SubTotal FROM comprobante a INNER JOIN detallecomprobante b ON b.CodComprobante=a.CodComprobante WHERE a.CodAlumno='".$_SESSION['CajaCodAlumno']."' AND a.CodComprobante='".$_SESSION['CajaCodComprobante']."' "; $rsDetalle = mysql_query($query_rsDetalle, $cn) or die(mysql_error()); $row_rsDetalle = mysql_fetch_assoc($rsDetalle); $totalRows_rsDetalle = mysql_num_rows($rsDetalle);*/ mysql_select_db($database_cn, $cn); $query_rsTotal = "SELECT SUM(b.SubTotal) as Total FROM comprobante a INNER JOIN detallecomprobante b ON b.CodComprobante=a.CodComprobante WHERE a.CodAlumno=" . $_GET['pqr'] . " AND a.CodComprobante='" . $_SESSION['CajaCodComprobante'] . "' "; $rsTotal = mysql_query($query_rsTotal, $cn) or die(mysql_error()); $row_rsTotal = mysql_fetch_assoc($rsTotal); $totalRows_rsTotal = mysql_num_rows($rsTotal); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/templateadm.dwt.php" codeOutsideHTMLIsLocked="false" --> <head>