public function indexAction()
{
$config = array();
$this->assets->addCss('/media/plugins/org/css/primitives.latest.css');
$this->assets->addJs('/js/highcharts/js/highcharts.js')->addJs('/js/highcharts/js/modules/data.js')->addJs('/js/highcharts/js/modules/exporting.js')->addJs('/js/highcharts/js/modules/drilldown.js')->addJs('/scripts/dashboard.js');
$this->view->setVar('usuario', $this->_user);
$clientes = consultas::clientesContrato()->count();
$productossinalquilar = Productos::sum(array("baja_logica=1 and cantidad>0", 'column' => 'cantidad'));
$productosalquilados = Contratosproductos::sum(array("baja_logica=1 and cantidad>0", 'column' => 'cantidad'));
$contratosActivos = Contratos::count(array("baja_logica=1"));
$this->view->setVar('clientes', $clientes);
$this->view->setVar('productossinalquilar', $productossinalquilar);
$this->view->setVar('productosalquilados', $productosalquilados);
$this->view->setVar('contratosActivos', $contratosActivos);
/*Datos para el grafico*/
$fechaActual = date('Y-m');
$nuevafecha = strtotime('-11 month', strtotime($fechaActual));
$nuevafecha = date('Y-m', $nuevafecha);
$usuariocomercial = Usuarios::find(array('habilitado = 1 and nivel in (2,3)', "order" => "id ASC"));
$html_tabla = '<tr><th></th>';
$array_usuario_id = array();
foreach ($usuariocomercial as $v) {
$html_tabla .= '<th>' . $v->nombre . ' ' . $v->paterno . '</th>';
$array_usuario_id[] = $v->id;
}
$html_tabla .= '</tr>';
while ($nuevafecha <= $fechaActual) {
$html_tabla .= '<tr><th>' . date("M", strtotime($nuevafecha)) . '</th>';
for ($i = 0; $i < count($array_usuario_id); $i++) {
$model = new Consultas();
$cantidadcontratos = $model->contratosComerciales($nuevafecha, $array_usuario_id[$i]);
$html_tabla .= '<td>' . $cantidadcontratos[0]->cant . '</td>';
}
$html_tabla .= '</tr>';
$nuevafecha = strtotime('1 month', strtotime($nuevafecha));
$nuevafecha = date('Y-m', $nuevafecha);
}
$this->view->setVar('html_tabla', $html_tabla);
}
include_once 'classes/paginacao.php';
?>
<table border="1px">
<tr>
<th>#</th>
<th>Nome Completo</th>
<th>E-mail</th>
<th>UF</th>
<th>Status</th>
<th>Tipo</th>
<th>Sexo</th>
<th colspan="2">Ações</th>
</tr>
<?php
$conexao = new Consultas();
$conexao->conecta();
$txt = "";
$q = $conexao->query("SELECT * FROM usuario ORDER BY COD_USUARIO DESC");
$conexao->exibeRegistros();
$pg = $conexao->setPage(5, "index.php?link=5", "/cat/teste");
$i = 0;
while ($rs = $conexao->resultados("<center><br><br><br><br>Não existem registros nesta consulta<br><br><br><br></center>", 1)) {
?>
<tr>
<td><?php
echo $rs['COD_USUARIO'];
?>
</td>
<td><?php
echo $rs['NOME_USUARIO'] . $rs['SOBRENOME_USUARIO'];
<?php
session_start();
if (!isset($_SESSION['User'])) {
header("Location:../index.html");
}
require '../Conexion/Consultas.php';
$con = new Consultas();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<!-- Always force latest IE rendering engine (even in intranet) & Chrome Frame Remove this if you use the .htaccess -->
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>form</title>
<meta name="description" content="">
<meta name="author" content="Karloz">
<!--Funciones-->
<script type="text/javascript" src="../js/Funciones.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<div id="botones" class="text-right animated shake">
<button type="button" class="btn btn-default" onclick="javascript: window.print()"><span style="color: blue;" class="glyphicon glyphicon-print"></span> Imprimir</button>
</div>
</form>
<div class="col-md-6">
</div>
<div class="col-md-12">
<br>
<br>
<br>
<br>
<?php
include './controlador/Cconsultas.php';
$objeto = new Consultas();
if (isset($_POST['barea'])) {
echo "<center><h4>Resultado de la Busqueda ' " . $objeto->mostrarArea($_POST['area']) . "'</h4></center> ";
$sql = mysql_query("SELECT * FROM plandeclase WHERE idarea = '{$_POST['area']}'");
while ($res = mysql_fetch_object($sql)) {
echo "<div class='col-md-4'>\n <div class='thumbnail'>\n <img alt='Bootstrap Thumbnail First' width='40%' src='./img/pdf-icon1.png' />\n <div class='caption'>\n <h3>\n Autor: <h5>" . $objeto->convertirUsuario($res->idusuario) . " " . $objeto->convertir($res->idusuario) . "</h5>\n </h3>\n <p>\n <b>Grado:</b> " . $res->grado . "\n </p>\n <p>\n <a class='btn btn-success' href='planes/" . $res->url . "'>Descargar</a>\n </p>\n </div>\n </div>\n </div>";
}
}
?>
</div>
</fieldset>
</div>
<?php
require_once 'model/Consultas.php';
require_once 'core/Conection.php';
$conection = new Conection();
$conn = $conection->Conectarse();
$consultas = new Consultas();
$nombre = $_REQUEST['nombre'];
$paterno = $_REQUEST['paterno'];
$materno = $_REQUEST['materno'];
//Insertar datos en la tabla
$sql = $consultas->Buscar($nombre, $paterno, $materno);
$result = pg_query($conn, $sql);
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<title>Listado Imagenes</title>
</head>
<body>
<div id="header">
<h1>Listado</h1>
<a href="index.php">Regresar</a>
</div>
<div id="cuerpo">
<form action="">
<input type="text" name="nombre" />
<input type="text" name="paterno" />
<input type="text" name="materno" />
public function contratosClientes($responsable_id)
{
$sql = "SELECT cl.id,cl.razon_social,COALESCE(SUM(cp.total),0) as monto\r\n FROM \r\n contratos c \r\n INNER JOIN clientes cl ON c.cliente_id = cl.id\r\n LEFT JOIN contratosproductos cp ON c.id = cp.contrato_id AND cp.baja_logica = 1\r\n WHERE c.responsable_id ='{$responsable_id}'\r\n GROUP BY c.cliente_id";
$db = new Consultas();
return new Resultset(null, $db, $db->getReadConnection()->query($sql));
}
</div>
</div>
<div class="col-md-4">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 class="panel-title">Mis Planes de Clases</h3>
</div>
<div class="panel-body">
<table class="table table-striped table-hover ">
<thead>
<tr style="font-size:12px;">
<th>#</th>
<th>Área</th>
<th>Grado</th>
<th>Opciones</th>
</tr>
</thead>
<tbody>
<?php
include './controlador/Cconsultas.php';
$obj = new Consultas();
$obj->listarmisPlanes($row['id']);
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<?php
} else {
?>
<table border="1px">
<tr>
<th>Nome da categoria</th>
<th>Cor da categoria</th>
<th>Status da categoria</th>
<th colspan="2">Ações</th>
</tr>
<?php
$conexao = new Consultas();
$conexao->conecta();
$txt = "";
$q = $conexao->query("SELECT * FROM categoria ORDER BY COD_CATEGORIA DESC");
$conexao->exibeRegistros();
$pg = $conexao->setPage(5, "index.php?link=1&l", "");
$i = 0;
while ($res = $conexao->resultados("<center><br><br><br><br>Não existem registros nesta consulta<br><br><br><br></center>", 1)) {
if ($res['STATUS_CATEGORIA'] == 1) {
$txtStatus = "Ativa";
} else {
$txtStatus = "Inativa";
}
?>
<tr style="background-color: <?php
echo $res['COR_CATEGORIA'];
