function basicTable2($header, $rut, $orden)
{
include_once '../conexion.php';
$this->SetFont('Arial', 'B', 15);
//SQL
$conexion = new conexion();
$conn = $conexion->conn();
$sql = "SELECT p.UrlFoto, p.nombreProducto, v.subTotal, v.iva, v.total " . "FROM venta_producto vp INNER JOIN productos p " . "ON vp.idProducto = p.idProducto INNER JOIN venta v " . "ON vp.idVenta = v.idVenta INNER JOIN carrito c " . "ON v.idCarrito = c.idCarrito INNER JOIN clientes cli " . "ON cli.rut = v.rut " . "WHERE cli.rut = " . $rut . " AND c.orden = '" . $orden . "';";
$rows = $conn->query($sql)->fetchAll();
//FIN SQL
$this->Cell(0, 10, utf8_decode('Total Pagado'), 0, 0, 'C');
$this->Ln(10);
$this->SetFont('Arial', 'B', 10);
foreach ($header as $col) {
$this->Cell(37.5, 7, $col, 1, 0, 'C');
}
$this->Ln();
//datos
foreach ($rows as $row) {
$urlFoto = $row['UrlFoto'];
$nombreProducto = $row['nombreProducto'];
$subTotal = $row['subTotal'];
$iva = $row['iva'];
$total = $row['total'];
}
$this->Cell(37.5, 6, utf8_decode(number_format($subTotal)), 1, 0, 'C');
$this->Cell(37.5, 6, utf8_decode(number_format($iva)), 1, 0, 'C');
$this->Cell(37.5, 6, utf8_decode(number_format($total)), 1, 0, 'C');
}
function basicTable($header)
{
include_once '../conexion.php';
$this->SetFont('Arial', 'B', 10);
$conexion = new conexion();
$conn = $conexion->conn();
$sql = "SELECT * FROM clientes ORDER BY 1;";
$rows = $conn->query($sql)->fetchAll();
foreach ($header as $col) {
$this->Cell(39, 7, $col, 1, 0, 'C');
}
$this->Ln();
//datos
foreach ($rows as $row) {
$rut = $row['rut'];
$nombre = $row['nombre'] . ' ' . $row['apellido'];
$telefono = $row['telefono'];
$email = $row['email'];
$this->Cell(39, 7, utf8_decode($rut), 1, 0, 'R');
$this->Cell(39, 7, utf8_decode($nombre), 1, 0, 'R');
$this->Cell(39, 7, utf8_encode($telefono), 1, 0, 'R');
$this->Cell(39, 7, utf8_decode($email), 1, 0, 'R');
$this->Ln();
}
$this->Ln(5);
}
function countDespacho()
{
include_once '../conexion.php';
try {
$c = new conexion();
$conn = $c->conn();
$sql = "SELECT count(idDespacho)+1 AS 'count' FROM despacho;";
$rows = $conn->query($sql)->fetchAll();
foreach ($rows as $row) {
return $row['count'];
}
} catch (Exception $exc) {
echo $exc->getTraceAsString();
}
}
function nombreComunas($idComuna)
{
include_once '../conexion.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$sql = "SELECT nombreComuna FROM comunas WHERE idComuna = " . $idComuna . ";";
$rows = $conn->query($sql)->fetchAll();
foreach ($rows as $row) {
return $nombreComuna = $row['nombreComuna'];
}
} catch (Exception $ex) {
die;
} finally {
}
}
function listadoTipoProductos()
{
include_once '../conexion.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$sql = "SELECT * FROM tipoproductos";
$rows = $conn->query($sql)->fetchAll();
foreach ($rows as $row) {
$idTipoProducto = $row['idTipoProducto'];
$descripcion = $row['descripcion'];
echo '<option value = "' . $idTipoProducto . '">' . $descripcion . '</option>';
}
} catch (Exception $ex) {
die;
} finally {
}
}
function insertMetodoDePagos(MetodoDePagos $mp)
{
require_once '../conexion.php';
require_once '../model.business/MetodoDePagos.php';
try {
$idMetodoDePagos = $mp->getIdMetodosDePago();
$descripcion = $mp->getDescripcion();
$conexion = new conexion();
$conn = $conexion->conn();
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = $conn->prepare("INSERT INTO metodosDePago VALUES(:idMetodoDePagos,:descripcion);");
$sql->bindParam(':idMetodoDePagos', $idMetodoDePagos);
$sql->bindParam(':descripcion', $descripcion);
return $sql->execute();
} catch (PDOException $exc) {
return $exc->getMessage();
} finally {
}
}
function passwordGerente($username)
{
require_once '../conexion.php';
require_once '../model.business/Cliente.php';
require_once '../model.business/Persona.php';
try {
$conexion = new conexion();
$cliente = new Cliente();
$sql = "SELECT contraseña FROM login WHERE username = "******";";
$conn = $conexion->conn();
$query = $conn->query($sql);
$rows = $query->fetchAll();
foreach ($rows as $row) {
return $contraseña = $row["contraseña"];
}
} catch (Exception $ex) {
$ex->getTraceAsString();
}
}
function countCarrito()
{
include_once '../conexion.php';
include_once '../model.business/Carro.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$query = $conn->prepare("SELECT count(idCarrito)+1 as 'count' FROM carrito;");
$query->execute();
$rows = $query->fetchAll();
foreach ($rows as $row) {
return $row['count'];
}
return null;
} catch (PDOException $exc) {
die;
} finally {
}
}
function maxMarcas()
{
include_once '../conexion.php';
include_once '../model.business/Carro.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$query = $conn->prepare("SELECT MAX(idMarca)+1 as 'max' FROM marcas;");
$query->execute();
$rows = $query->fetchAll();
foreach ($rows as $row) {
return $row['max'];
}
return null;
} catch (PDOException $exc) {
die;
} finally {
}
}
function insertLoginAdmin(Administrador $a)
{
require_once '../conexion.php';
require_once '../model.business/Cliente.php';
try {
$username = $a->getUsername();
$password = $a->getPassword();
$conexion = new conexion();
$conn = $conexion->conn();
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = $conn->prepare("INSERT INTO login VALUES(:username,:password, 1);");
$sql->bindParam(':username', $username);
$sql->bindParam(':password', $password);
return $sql->execute();
} catch (PDOException $exc) {
return $exc->getCode();
} finally {
}
}
function searchAdmin(Administrador $a)
{
require_once '../conexion.php';
require_once '../model.business/Administrador.php';
require_once '../model.business/Persona.php';
try {
$conexion = new conexion();
$administrador = new Administrador();
$sql = "SELECT a.nombre, a.apellido FROM administrador a " . "INNER JOIN login l ON a.username = l.username " . "WHERE l.username = '******' AND l.contraseña = '" . $a->getPassword() . "';";
$conn = $conexion->conn();
$query = $conn->query($sql);
$rows = $query->fetchAll();
foreach ($rows as $row) {
$administrador->setUsername($a->getUsername());
$administrador->setPassword($a->getPassword());
$administrador->setRol(0);
$administrador->setNombre($row["nombre"]);
$administrador->setApellido($row["apellido"]);
}
return $administrador;
} catch (Exception $ex) {
$ex->getTraceAsString();
}
}
format: '<b>{point.name}</b>: {point.percentage:.1f} %',
style: {
color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
}
}
}
},
series: [{
type: 'pie',
name: 'Preferencia',
data: [
<?php
$c = new conexion();
$sql = "SELECT count(v.idProducto) 'cantidad',p.nombreProducto from venta_producto v INNER JOIN productos p ON p.idProducto = v.idProducto " . " GROUP BY 2;";
//se conecta a la BD
$conn = $c->conn();
//Crea la consulta
$query = $conn->query($sql);
//Toma los valores de la consulta;
$rows = $query->fetchAll();
foreach ($rows as $row) {
?>
['<?php
echo $row['nombreProducto'];
?>
', <?php
echo $row['cantidad'];
?>
],
<?php
}
function listaProductosXOrdenesSegundaParte($rut, $orden)
{
include_once '../conexion.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$sql = "SELECT p.UrlFoto, p.nombreProducto, v.subTotal, v.iva, v.total " . "FROM venta_producto vp INNER JOIN productos p " . "ON vp.idProducto = p.idProducto INNER JOIN venta v " . "ON vp.idVenta = v.idVenta INNER JOIN carrito c " . "ON v.idCarrito = c.idCarrito INNER JOIN clientes cli " . "ON cli.rut = v.rut " . "WHERE cli.rut = " . $rut . " AND c.orden = '" . $orden . "';";
$rows = $conn->query($sql)->fetchAll();
foreach ($rows as $row) {
$urlFoto = $row['UrlFoto'];
$nombreProducto = $row['nombreProducto'];
$subTotal = $row['subTotal'];
$iva = $row['iva'];
$total = $row['total'];
}
echo "<div class='w3-row-padding'>";
echo "<div class='w3-col m2'>";
echo number_format($subTotal);
echo "</div>";
echo "<div class='w3-col m2'>";
echo number_format($iva);
echo "</div>";
echo "<div class='w3-col m2'>";
echo number_format($total);
echo "</div>";
echo "<div class='w3-col m1'> </div>";
echo "</div>";
} catch (Exception $exc) {
}
}
function deleteProducto($idProducto)
{
require_once '../conexion.php';
require_once '../model.business/Producto.php';
try {
$conexion = new conexion();
$conn = $conexion->conn();
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = $conn->prepare("DELETE FROM productos WHERE idProducto = :idProducto ;");
$sql->bindParam(':idProducto', $idProducto);
return $sql->execute();
} catch (PDOException $exc) {
echo $exc->getMessage();
}
}
function buscarClienteXRut($rut)
{
require_once '../conexion.php';
require_once '../model.business/Cliente.php';
require_once '../model.business/Persona.php';
try {
$conexion = new conexion();
$cliente = new Cliente();
$sql = "SELECT c.nombre, c.apellido,c.rut,c.telefono, c.email FROM clientes c " . "INNER JOIN login l ON c.username = l.username " . "WHERE c.rut = " . $rut . ";";
$conn = $conexion->conn();
$query = $conn->query($sql);
$rows = $query->fetchAll();
foreach ($rows as $row) {
$cliente->setNombre($row["nombre"]);
$cliente->setApellido($row["apellido"]);
$cliente->setRut($row["rut"]);
$cliente->setTelefono($row["telefono"]);
$cliente->setEmail($row["email"]);
return $cliente;
}
return null;
} catch (Exception $ex) {
$ex->getTraceAsString();
}
}
