$conn = new conexion();
include "../funciones/fechas.php";
$codfactura = $_GET["codfactura"];
$sel_alb = "SELECT * FROM facturas WHERE codfactura='{$codfactura}'";
$rs_alb = $conn->consulta($sel_alb);
$nombreCliente = mysql_result($rs_alb, 0, "nombreCliente");
$iva = mysql_result($rs_alb, 0, "iva");
$fecha = mysql_result($rs_alb, 0, "fecha");
$remito = mysql_result($rs_alb, 0, "remito");
$numfactura = mysql_result($rs_alb, 0, "numfactura");
$sel_lineas = "SELECT * FROM factulinea WHERE codfactura='{$codfactura}' ORDER BY numlinea ASC";
$rs_lineas = $conn->consulta($sel_lineas);
$fechahoy = date("Y-m-d");
$sel_albaran = "call pConsulta_codFactura()";
$rs_albaran = $conn->consulta($sel_albaran);
$resultadoFact = $conn->fetch_array($rs_albaran);
$codfacturatmp = $resultadoFact['codfactura'];
$contador = 0;
$baseimponible = 0;
while ($contador < mysql_num_rows($rs_lineas)) {
$codfamilia = mysql_result($rs_lineas, $contador, "codfamilia");
$codigo = mysql_result($rs_lineas, $contador, "codigo");
$cantidad = mysql_result($rs_lineas, $contador, "cantidad");
$precio = mysql_result($rs_lineas, $contador, "precio");
$importe = mysql_result($rs_lineas, $contador, "importe");
$baseimponible = $baseimponible + $importe;
$dcto = mysql_result($rs_lineas, $contador, "dcto");
$sel_tmp = "INSERT INTO factulineatmp (codfactura,numlinea,codfamilia,codigo,cantidad,precio,importe,dcto) VALUES ('{$codfacturatmp}','','{$codfamilia}','{$codigo}','{$cantidad}','{$precio}','{$importe}','{$dcto}')";
$rs_tmp = $conn->consulta($sel_tmp);
$contador++;
}
if (isset($_POST['id']) || isset($_GET['id'])) {
if (isset($_POST['id'])) {
$id = $_POST['id'];
$full_name = $_POST['full_name'];
$user_name = $_POST['user_name'];
$user_email = $_POST['user_email'];
$joined = $_POST['joined'];
$rol = $_POST['rol'];
$contadorVeces = $_POST['contadorVeces'];
$user_activated = $_POST['user_activated'];
$consulta = "update users set id='" . $id . "',full_name='" . $full_name . "',user_name='" . $user_name . "',user_email='" . $user_email . "',joined='" . $joined . "',rol='" . $rol . "',user_activated='" . $user_activated . "' where id = '" . $id . "'";
$resultado = $conn->consulta($consulta);
if ($resultado != null) {
$consultaSession = "select rol from users where user_name = '" . $_SESSION['user'] . "'";
$resultadoSession = $conn->consulta($consultaSession);
$row = $conn->fetch_array($resultadoSession);
$_SESSION['rol'] = $row['rol'];
$valor = "actualizar";
} else {
$valor = "actualizar_error";
}
$query = "Select * from users order by id asc";
$seleccion = $conn->consulta($query);
}
if (isset($_GET['id'])) {
$id = $_GET['id'];
$user_name = $_GET['user_name'];
$contadorVeces = $_GET['contadorVeces'];
$consulta = "delete from users where id = '" . $id . "' and user_name = '" . $user_name . "'";
$resultado = $conn->consulta($consulta);
if ($resultado != null) {
<?php
session_start();
if (!isset($_SESSION['idSession'])) {
header("Location:index.php");
} else {
require "includes/sys/conexion.php";
$conn = new conexion();
$consulta = "select rol from users where user_name = '" . $_SESSION['user'] . "'";
$resultado = $conn->consulta($consulta);
$row = $conn->fetch_array($resultado);
$_SESSION['rol'] = $row['rol'];
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Menu Principal</title>
<script type="text/javascript" src="js/alertify.min.js"></script>
<script type="text/javascript" src="js/jquery-1.10.2.js"></script>
<script type="text/javascript" src="js/jquery-ui.js"></script>
<script type="text/javascript" src="js/operaciones.js"></script>
<script type="text/javascript" src="js/stickUp.min.js"></script>
<link rel="shortcut icon" type="image/png" href="css/puntoVentasImg/icon.png" />
<!-- CSS -->
<link rel="stylesheet" href="css/alertify.min.css"/>
<link rel="stylesheet" href="css/jquery-ui.css"/>
</div>
<table class="fuente8" style="width: 55%; margin-top: 5%; margin-left: 5%;">
<tr class="cabeceraTabla">
<th>ID</th>
<th>Nombre Completo</th>
<th>Nombre Usuario</th>
<th>Contraseña</th>
<th>Correo Electronico</th>
<th>Código de Activación</th>
<th>Agregado</th>
<th>Rol</th>
<th>Estado</th>
</tr>
<?php
while ($row = @$conn->fetch_array($resultado)) {
echo '<form action="usuarios.php" id="formularioUsers" method="post">';
echo '<tr class="itemImparTabla"><td class="aCentro"><input style="width:26px;" readonly="yes" title="No se puede editar" type="text" maxlength="20" name = "id" value = "' . $row['id'] . '"/></td>
<td><input type="text" maxlength="200" name = "full_name" value = "' . $row['full_name'] . '"/></td>
<td><input style="width:100px;" type="text" maxlength="25" name = "user_name" value = "' . $row['user_name'] . '"/></td>
<td><input style="width:250px;" readonly="yes" title="No se puede editar" type="text" maxlength="50" name = "user_pwd" value = "' . $row['user_pwd'] . '"/></td>
<td><input type="text" maxlength="200" name = "user_email" value = "' . $row['user_email'] . '"/></td>
<td><input style="width:80px;" type="text" maxlength="10" readonly="yes" title="No se puede editar" name = "activation_code" value = "' . $row['activation_code'] . '"/></td>
<td><input style="width:80px;" type="text" maxlength="20" readonly="yes" title="No se puede editar" name = "joined" value = "' . $row['joined'] . '"/></td>
<td><input style="width:26px;" type="text" maxlength="2" name = "rol" value = "' . $row['rol'] . '"/></td>
<td><input style="width:26px;" type="text" maxlength="2" name = "user_activated" value = "' . $row['user_activated'] . '"/></td>
<td><input type="submit" id="bActualizarUser" value="" title="Actualizar Usuario"></td>';
echo "</form>";
echo '<td><a href="usuarios.php?id=' . $row['id'] . '&user_name=' . $row['user_name'] . '"><button id="bEliminarUser" title="Eliminar Usuario"></button></a></td></tr>';
}
include "comunesfactura.php";
require "../sys/conexion.php";
$conn = new conexion();
include "../funciones/fechas.php";
include "Numbers/Words.php";
$pdf = new PDF();
$pdf->Open();
$pdf->AddPage();
// Cabecera
if (@$GLOBALS['fondofac'] == "SI") {
$pdf->Header('./logo/$GLOBALS["imagenfac"]', 0, 0, 205, 295);
}
$codfactura = @$_GET["codfactura"];
$consulta = "Select * from facturas,clientes where facturas.codfactura='{$codfactura}' and clientes.codcliente=clientes.codcliente";
$resultado = $conn->consulta($consulta);
$lafila = @$conn->fetch_array($resultado);
$fecha = implota($lafila["fecha"]);
$dia1 = substr($fecha, 0, 2);
// El mes sale como numero
$mes1 = substr($fecha, 3, 2);
// si se activa este comando el mes sale con letras
//$mes1=mes($mes1);
$ano1 = substr($fecha, 6, 4);
$pdf->SetFillColor(255, 255, 255);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetDrawColor(0, 0, 0);
$pdf->SetLineWidth(0.2);
$pdf->SetFont('courier', 'B', 10);
$pdf->Ln(15);
//el primer bloque empieza en la linea 18
$pdf->Cell(20);
if ($fechainicio != "") {
$where .= " and fecha>='" . $fechainicio . "'";
} else {
if ($fechafin != "") {
$where .= " and fecha<='" . $fechafin . "'";
}
}
}
$where .= " ORDER BY codfactura DESC";
$query_busqueda = "SELECT count(*) as filas FROM facturas WHERE borrado=0 AND " . $where;
$rs_busqueda = @$conn->consulta($query_busqueda);
$filas = @mysql_result($rs_busqueda, 0, "filas");
$query_busqueda = "SELECT * FROM facturas WHERE borrado=0 AND estado=1 AND " . $where;
$rs_busqueda = @$conn->consulta($query_busqueda);
$totalfacturas = 0;
while ($row = @$conn->fetch_array($rs_busqueda, MYSQL_ASSOC)) {
$totalfacturas += $row["totalfactura"];
}
?>
<html>
<head>
<meta charset="UTF-8">
<title>Facturas Clientes</title>
<link href="../estilos/estilos.css" type="text/css" rel="stylesheet">
<script language="javascript">
function ver_factura(codfactura) {
miPopup = window.open("ver_factura.php?codfactura=" + codfactura + "&cadena_busqueda=<?php
echo $cadena_busqueda;
?>
", "miwin", "width=1200,height=650,scrollbars=yes");
<?php
session_start();
if (!isset($_SESSION['idSession'])) {
header("Location:../../index.php");
} else {
require "../sys/conexion.php";
$conn = new conexion();
$base = @$_GET["baseimponible"];
$fechahoy = date("Y-m-d");
$sel_fact = "call pConsulta_codFactura()";
$rs_fact = $conn->consulta($sel_fact);
$resultadoFact = @$conn->fetch_array($rs_fact);
$codfacturatmp = $resultadoFact['codfactura'];
// Se actualiza a la nueva numeracion de factura
if ($GLOBALS['setnumfac'] == 1) {
$sel_articulos = "UPDATE facturastmp SET codfactura='" . $GLOBALS['numeracionfactura'] . "' WHERE codfactura='" . $codfacturatmp . "'";
$rs_articulos = $conn->consulta($sel_articulos);
$codfacturatmp = $GLOBALS['numeracionfactura'];
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Ventas</title>
<script type="text/javascript" src="../../js/alertify.min.js"></script>
<script type="text/javascript" src="../../js/jquery-1.10.2.js"></script>
