<?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>
