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(); } }