Ingresos y Egresos
| ";
}
elseif ($guardar=="true")
{
if ($action == "ingreso")
{
$Monto = $_POST['montoIngreso'];
$Motivo = $_POST['razonIngreso'];
variacionDeCaja($Motivo, $Monto, $ActiveUser, $Local, "Ingreso a Caja");
echo'';
echo '';
}
/*if ($action == "creditos")
{
$Monto = $_POST['montoCred'];
variacionDeCaja("Ventas con Tarjeta", $Monto, $ActiveUser, $Local, "Ventas con Tarjeta");
echo'';
echo '';
}*/
elseif ($action == "egreso")
{
$Monto = $_POST['montoEgreso'];
$Motivo = $_POST['razonEgreso'];
$MontoReg = $Monto * -1;
variacionDeCaja($Motivo, $MontoReg, $ActiveUser, $Local, "Egreso de Caja");
echo'';
echo '';
}
elseif ($action == "fueradecaja")
{
$Monto = $_POST['montoEgreso'];
$Motivo = $_POST['razonEgreso'];
$MontoReg = $Monto * -1;
variacionDeCaja($Motivo, $MontoReg, $ActiveUser, $Local, "Registro de Gasto");
echo'';
echo '';
}
elseif ($action == "financiera")
{
$Monto = $_POST['montoPago'];
$Motivo = "PAGO DE FINANCIERA ".$_POST['Financiera'];
variacionDeCaja($Motivo, $Monto, $ActiveUser, $Local, "Pago de Financiera");
echo'';
echo '';
}
elseif ($action == "inicial")
{
$Monto = $_POST['cInicial'];
definirCaja($Monto, "Caja Inicial", $Local, $ActiveUser, "Caja Inicial");
echo'';
echo '';
}
elseif ($action == "final")
{
$DosMil = (double)$_POST['2000'];
$Mil = (double)$_POST['1000'];
$Quinientos = (double)$_POST['500'];
$Doscientos = (double)$_POST['200'];
$Cien = (double)$_POST['100'];
$Cincuenta = (double)$_POST['50'];
$Veinte = (double)$_POST['20'];
$CincuentaM = (double)$_POST['50M'];
$Diez = (double)$_POST['10'];
$Cinco = (double)$_POST['5'];
$Dos = (double)$_POST['2'];
$Uno = (double)$_POST['1'];
$DosMil = $DosMil * 2000;
$Mil = $Mil * 1000;
$Quinientos = $Quinientos * 500;
$Doscientos = $Doscientos * 200;
$Cien = $Cien * 100;
$Cincuenta = $Cincuenta * 50;
$Veinte = $Veinte * 20;
$CincuentaM = $CincuentaM * 50;
$Diez = $Diez * 10;
$Cinco = $Cinco * 5;
$Dos = $Dos * 2;
$Uno = $Uno * 1;
definirCaja($DosMil, "Caja Final $2000", $Local, $ActiveUser, "Caja Final $2000");
definirCaja($Mil, "Caja Final $1000", $Local, $ActiveUser, "Caja Final $1000");
definirCaja($Quinientos, "Caja Final $500", $Local, $ActiveUser, "Caja Final $500");
definirCaja($Doscientos, "Caja Final $200", $Local, $ActiveUser, "Caja Final $200");
definirCaja($Cien, "Caja Final $100", $Local, $ActiveUser, "Caja Final $100");
definirCaja($Cincuenta, "Caja Final $50", $Local, $ActiveUser, "Caja Final $50");
definirCaja($CincuentaM, "Caja Final $50M", $Local, $ActiveUser, "Caja Final $50M");
definirCaja($Veinte, "Caja Final $20", $Local, $ActiveUser, "Caja Final $20");
definirCaja($Diez, "Caja Final $10", $Local, $ActiveUser, "Caja Final $10");
definirCaja($Cinco, "Caja Final $5", $Local, $ActiveUser, "Caja Final $5");
definirCaja($Dos, "Caja Final $2", $Local, $ActiveUser, "Caja Final $2");
definirCaja($Uno, "Caja Final $1", $Local, $ActiveUser, "Caja Final $1");
echo'';
echo '';
}
elseif ($action == "arqueo")
{
$today = date("Y-m-d");
$today2 = date("d-m-Y");
$busquedaInicial = mysqli_query($conexion, "SELECT * FROM caja WHERE Local LIKE '%$Local%' AND Tipo LIKE '%Inicial%' AND Fecha LIKE '%$today%'");
while ($rowInicial=mysqli_fetch_row($busquedaInicial))
{
$CajaInicial = $rowInicial[5];
}
$busquedaFinal = mysqli_query($conexion, "SELECT * FROM caja WHERE Local LIKE '%$Local%' AND Tipo LIKE '%$%' AND Fecha LIKE '%$today%'");
while ($rowFinal=mysqli_fetch_row($busquedaFinal))
{
if ($rowFinal[8] == "Caja Final $2000")
{
$DosMil = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $1000")
{
$Mil = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $500")
{
$Quinientos = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $200")
{
$Doscientos = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $100")
{
$Cien = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $50")
{
$Cincuenta = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $20")
{
$Veinte = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $50M")
{
$CincuentaM = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $10")
{
$Diez = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $5")
{
$Cinco = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $2")
{
$Dos = $rowFinal[5];
}
if ($rowFinal[8] == "Caja Final $1")
{
$Uno = $rowFinal[5];
}
$CajaFinal = $DosMil + $Mil + $Quinientos + $Doscientos + $Cien + $Cincuenta + $Veinte + $CincuentaM + $Diez + $Cinco + $Dos + $Uno;
}
if ($CajaInicial > 0 && $CajaFinal > 0)
{
$busquedaArqueo = mysqli_query($conexion, "SELECT * FROM caja WHERE Local LIKE '%$Local%' AND Fecha LIKE '%$today%'");
$CajaFinalArqueo = $CajaInicial;
$TotalVentas = 0;
$Egresos = 0;
$Ingresos = 0;
echo "
Ingresos y Egresos
|
Calculos de Caja
Un Arqueo correcto deberia ser igual a la Caja Final Declarada. |
|
|