<?php require_once('../connections/comercial.php'); ?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../logout.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
mysqli_select_db($comercial, $database_comercial);
$query_Recordset1 = "SELECT * FROM cliente WHERE cliente.cli_id='".$_REQUEST['id']."'";
$Recordset1 = mysqli_query($comercial, $query_Recordset1) or die(mysql_error());
$row_Recordset1 = mysqli_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysqli_num_rows($Recordset1);
mysqli_select_db($comercial, $database_comercial);
$query_Recordset2 = "SELECT DISTINCT familia FROM articulos ORDER BY familia";
$Recordset2 = mysqli_query($comercial, $query_Recordset2) or die(mysql_error());
$row_Recordset2 = mysqli_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysqli_num_rows($Recordset2);
mysqli_select_db($comercial, $database_comercial);
$query_Recordset3 = "SELECT * FROM regalospromos ORDER BY descripcion";
$Recordset3 = mysqli_query($comercial, $query_Recordset3) or die(mysql_error());
$row_Recordset3 = mysqli_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysqli_num_rows($Recordset3);
if(($_REQUEST['rep'] != $_SESSION['rep']) || ($_REQUEST['id'] != $_SESSION['cli'])) {
header("Location: ../logout.php");
}
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="utf-8" />
<title>Portal</title>
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet" />
<link href="../bootstrap/css/estilos.css" rel="stylesheet" />
<script src="../bootstrap/js/jquery.js"></script>
<script src="../bootstrap/js/bootstrap.min.js"></script>
<script src="../includes/date.format.js"></script>
<link rel="icon" type="image/x-icon" href="../favicon.ico" />
</head>
<body>
<script type="text/javascript">
var producto = [];
var regalo;
var filaactual;
var familiastexto;
//FUNCIONES
function deshabilitar(num){
//document.getElementById("ref"+num).innerHTML = "";
document.getElementById("pvp"+num).innerHTML = "";
//document.getElementById("emb"+num).innerHTML = "";
//document.getElementById("caj"+num).innerHTML = "";
$( "#cant"+num ).val('');
$("#cant"+num).prop('disabled', true);
$( "#dto"+num ).val('');
$("#dto"+num).prop('disabled', true);
}
function habilitar(num){
$("#cant"+num).prop('disabled', false);
$("#cant"+num).val(producto[num]["caja"]);
$("#cant"+num).change();
$("#dto"+num).prop('disabled', false);
$("#dto"+num).val("0");
$("#dto"+num).change();
}
function habilitarselects(num){
//alert("#fam"+num);
$("#fam"+num).prop('disabled', false);
$("#fam"+num).change();
}
function obtenerfamilias(){
var data = "";
$.ajax({
type: 'GET',
url: 'filtro_promociones.php?o=f5',
data: data,
success: function(data, textStatus, jqXHR)
{
familias = jQuery.parseJSON(data);
familiastexto = "<option value=><b>Familia</b></option>";
for(var i=0; i<familias.length; i++){
familiastexto += "<option value="+familias[i]+">"+familias[i]+"</option>";
}
}});
}
function cambiartotal(num){
var filaactual = num;
var neto = parseFloat(producto[filaactual]["pvp"])*(1-(parseInt($( "#dto"+filaactual ).val())/100));
$("#neto"+filaactual).html(neto.toFixed(2));
var total = parseInt($( "#cant"+filaactual ).val())*neto;
$("#total"+filaactual).html(total.toFixed(2));
cambiarresultado();
}
function cambiarresultado(){
var saltar = true;
var costetotal = 0;
var total = 0;
$("#tablappal tbody tr").each(function() {
if (saltar) saltar = false;
else{
var filanum = $(this).prop("id").replace('fila','');
total += parseFloat($("#total"+filanum).html());
costetotal += parseInt($( "#cant"+filanum ).val())*parseFloat(producto[filanum]["coste"]);
}
});
$("#totaltotal").html("<b>"+total.toFixed(2)+"</b>");
var margenobt = total-costetotal-(parseFloat(regalo["importe"]));
var margendes = total*(regalo["margendes"]/100);
if(margenobt>=margendes){ $("#resultado").html("ACEPTADA"); $("#mailbutton").prop("disabled",false);}
else{ $("#resultado").html("RECHAZADA"); $("#mailbutton").prop("disabled",true);}
}
function crearfila(){
var filaactual = window.filaactual;
var fila = document.getElementById('tablappal').insertRow(-1);
fila.id = "fila"+filaactual;
var t="";
t += "<td bgcolor='#ffffff'><select name=\"fam"+filaactual+"\" id=\"fam"+filaactual+"\" size=\"1\" disabled=\"true\">"+familiastexto+"</select></td>";
t += "<td bgcolor='#ffffff'><select name=\"marca"+filaactual+"\" id=\"marca"+filaactual+"\" size=\"1\"><option value=>Marca</option></select></td>";
t += "<td bgcolor='#ffffff'><select name=\"prod"+filaactual+"\" id=\"prod"+filaactual+"\" size=\"1\"><option value=>Producto</option></select></td>";
//t += "<td bgcolor='#ffffff' id=\"ref"+filaactual+"\"></td>";
//t += "<td bgcolor='#ffffff' id=\"emb"+filaactual+"\"></td>";
t += "<td bgcolor='#ffffff'><input id=\"cant"+filaactual+"\" type=\"number\" name=\"cant"+filaactual+"\" step=\"1\" disabled=\"true\" style=\"text-align: center; width: 50px\"></td>";
//t += "<td bgcolor='#ffffff' id=\"caj"+filaactual+"\"></td>";
t += "<td bgcolor='#ffffff' id=\"pvp"+filaactual+"\"></td>";
t += "<td bgcolor='#ffffff'><input id=\"dto"+filaactual+"\" type=\"number\" name=\"dto"+filaactual+"\" step=\"5\" disabled=\"true\" style=\"text-align: center; width: 50px\">%</td>";
t += "<td bgcolor='#ffffff' id=\"neto"+filaactual+"\"></td>";
t += "<td bgcolor='#ffffff' id=\"total"+filaactual+"\"></td>";
t += "<td><button type=\"button\" id=\"borrar"+filaactual+"\" onclick=\"eliminarfila("+filaactual+");\" style='border:none;background-color: transparent'><img src='../botones/borrar.png' class='img-responsive' alt='Borrar producto' width='24'></button></td>";
fila.innerHTML = t;
document.getElementById('fam'+filaactual).onchange = function(){
deshabilitar(filaactual);
var select = document.getElementById("marca"+filaactual);
var length = select.options.length;
for (i = 0; i < length; i++) select.options[i] = null;
var data = "";
$.ajax({
type: 'GET',
url: 'filtro_promociones.php?o=f1&fam='+$( "#fam"+filaactual ).val(),
data: data,
success: function(data, textStatus, jqXHR)
{
var t = "<option value=>Marca</option>";
var marcas = jQuery.parseJSON("["+data+"]");
for(var i=0; i<marcas[0].length; i++){
t += "<option value="+marcas[0][i]+">"+marcas[0][i]+"</option>";
}
document.getElementById("marca"+filaactual).innerHTML = t;
document.getElementById("prod"+filaactual).innerHTML = "<option value=>Producto</option>";
$("#prod"+filaactual).change();
}});
};
deshabilitar(filaactual);
document.getElementById('marca'+filaactual).onchange = function(){
deshabilitar(filaactual);
var select = document.getElementById("prod"+filaactual);
var length = select.options.length;
for (i = 0; i < length; i++) select.options[i] = null;
var data = "";
$.ajax({
type: 'GET',
url: 'filtro_promociones.php?o=f2&fam='+$( "#fam"+filaactual ).val()+'&marca='+$( "#marca"+filaactual ).val(),
data: data,
success: function(data, textStatus, jqXHR)
{
var t = "<option value=>Producto</option>";
var productos = jQuery.parseJSON("["+data+"]");
for(var i=0; i<productos[0].length; i++){
t += "<option value="+productos[0][i][0]+">"+productos[0][i][1]+"</option>";
}
document.getElementById("prod"+filaactual).innerHTML = t;
$("#prod"+filaactual).change();
}});
};
document.getElementById('prod'+filaactual).onchange = function(){
deshabilitar(filaactual);
var data = "";
$.ajax({
type: 'GET',
url: 'filtro_promociones.php?o=f3&prod='+$( "#prod"+filaactual ).val(),
data: data,
success: function(data, textStatus, jqXHR)
{
producto[filaactual] = jQuery.parseJSON(data);
//document.getElementById("ref"+filaactual).innerHTML = producto[filaactual]["ref"];
document.getElementById("pvp"+filaactual).innerHTML = parseFloat(producto[filaactual]["pvp"]).toFixed(2);
//document.getElementById("emb"+filaactual).innerHTML = producto[filaactual]["caja"];
habilitar(filaactual);
}});
};
document.getElementById('cant'+filaactual).onchange = function(){
if($( "#cant"+filaactual ).val()=="") $( "#cant"+filaactual ).val(producto[filaactual]["caja"]);
//document.getElementById("caj"+filaactual).innerHTML = (parseInt($( "#cant"+filaactual ).val())/parseInt(producto[filaactual]["caja"])).toFixed(2);
cambiartotal(filaactual);
};
document.getElementById('dto'+filaactual).onchange = function(){
$( "#dto"+filaactual ).val(parseInt($( "#dto"+filaactual ).val())+"");
if(parseInt($( "#dto"+filaactual ).val())%5 != 0){ alert("El descuento tiene que ser multiplo de 5."); $( "#dto"+filaactual ).val("0");}
else cambiartotal(filaactual);
};
habilitarselects(filaactual);
window.filaactual++;
}
function eliminarfila(num){
$("#fila"+num).remove();
cambiarresultado();
}
function prueba(){
alert("prueba");
}
function enviarmail(){
var tablatexto = "";
var cliente = "<?php echo $row_Recordset1['cli_id'].' - '.$row_Recordset1['cli_nombre']; ?>";
var saltar = true;
$("#tablappal tbody tr").each(function() {
if (saltar){
tablatexto += "<tr>"+$(this).html()+"</tr>";
saltar = false;
}else{
var filanum = $(this).prop("id").replace('fila','');
tablatexto += "<tr><td style='text-align: center'>"+$("#fam"+filanum).find(":selected").text()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#marca"+filanum).find(":selected").text()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#prod"+filanum).find(":selected").text()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#cant"+filanum).val()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#pvp"+filanum).html()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#dto"+filanum).val()+"%</td>";
tablatexto += "<td style='text-align: center'>"+$("#neto"+filanum).html()+"</td>";
tablatexto += "<td style='text-align: center'>"+$("#total"+filanum).html()+"</td></tr>";
}
});
var total = "<h2 align=\"center\"><b>Total:</b> <span>"+$("#totaltotal").html()+"</span> euros</h2><h2 align=\"center\">"+$("#resultado").html()+"</h2>";
var data="";
$.ajax({
type: "GET",
url: "filtro_promociones.php?o=f6&tabla="+tablatexto+"&cliente="+cliente+"&total="+total+"®alodesc="+regalo["descripcion"],
data: data,
success: function(data, textStatus, jqXHR){
if(data == "error"){
alert("Error enviando el correo.");
}else{
console.log(data);
alert("Correo enviado con \u00e9xito.");
//window.location = $('#volver').attr('href');
}
}
});
}
//FIN FUNCIONES
obtenerfamilias();
filaactual=1;
</script>
<div class="row">
<div class="col-md-2 nopadding">
<div class="sidebar-nav">
<div class="navbar navbar-default" role="navigation">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<img src="../images/xxx.png" class="img-responsive" alt="Logo xxxx ">
<p class="nav navbar-nav">
<a class="navbar-brand izqmargin" href="menucomercial.php"><?php echo $_SESSION['nom']; ?> <?php echo $_SESSION['ape']; ?></a>
</p>
<p class="nav navbar-nav">
<a class="navbar-brand izqmargin" style="color: white;"><?php echo utf8_encode($row_Recordset1['cli_nombre']); ?></a>
</p>
<p class="nav navbar-nav">
<div class="opcionescuenta">
<a href="../logout.php" role="button" class="btn btn-default btn-xs">Cerrar sesión</a>
</div>
</p>
</div>
<div id="navbar" class="navbar-collapse collapse sidebar-navbar-collapse">
<ul class="nav navbar-nav">
<li class="nav-divider"></li>
<li><a href="acciones.php">Acciones</a></li>
<li><a href="clientes.php">Clientes</a></li>
<li><a href="redes.php">Redes</a></li>
<li class="nav-divider"></li>
<li><a href="actividades.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Actividades</a></li>
<li><a href="fichacliente.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Ficha cliente</a></li>
<li><a href="informe.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Informe</a></li>
<li><a href="familias.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Familias</a></li>
<li><a href="ventas.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Ventas</a></li>
<li><a href="comercial.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Visita comercial</a></li>
<li><a href="promociones.php?id=<?php echo $_SESSION['cli']; ?>&rep=<?php echo $_SESSION['rep']; ?>">Promociones</a></li>
<li class="nav-divider"></li>
<li><a href="http:\\www.xxx.com" target="_blank">.com</a></li>
<li><a href="http:\\www.xxx.com" target="_blank">.com</a></li>
<li><a href="https:\\web.whatsapp.com" target="_blank">web.whatsapp.com</a></li>
</ul>
</div>
</div>
</div>
</div>
<div class="col-md-10 nopadding">
<div class="col-md-12 top-buffer">
<div class="jumbotron col-md-11">
<div class="text-center">
<h2><b>Promociones comerciales</b></h2>
<h3><?php echo $_SESSION['cli']; ?> - <?php echo utf8_encode($row_Recordset1['cli_nombre']); ?> <?php if($row_Recordset1['baja']=='B') echo '<font color="#e74c3c"><b>BAJA</b></font>'; ?></h3>
</div>
<br>
<form name="form1" method="post" action="javascript:void(0);">
<div align="center">
<select name="regalo" id="regalo" class="form-control" size="1" autofocus>
<option><b>SELECCIONAR REGALO</b></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset3['id']?>"><?php echo $row_Recordset3['descripcion']?></option>
<?php
} while ($row_Recordset3 = mysqli_fetch_assoc($Recordset3));
$rows = mysqli_num_rows($Recordset3);
if($rows > 0) {
mysqli_data_seek($Recordset3, 0);
$row_Recordset3 = mysqli_fetch_assoc($Recordset3);
}
?>
</select>
<br>
<input class="btn btn-default" type="button" id="anyadir" onclick="crearfila()" value="Añadir producto" disabled>
</p>
<script type="text/javascript">
document.getElementById('regalo').onchange = function(){
var tb = document.getElementById('contabla');
var seleccionado = document.getElementById('regalo');
var pt = document.getElementById('anyadir');
var data = "";
if(seleccionado.selectedIndex == "0") {
$("#anyadir").prop("disabled",true);
pt.disabled = true;
tb.style.display = "none";
}
else {
pt.disabled = false;
tb.style.display = "inline";
}
$.ajax({
type: 'GET',
url: 'filtro_promociones.php?o=f4®alo='+$( "#regalo" ).val(),
data: data,
success: function(data, textStatus, jqXHR)
{
regalo = jQuery.parseJSON(data);
$("#anyadir").prop("disabled",false);
cambiarresultado();
}});
};
</script>
<br>
<div name="contabla" id="contabla" style="display:none">
<table class="table table-bordered" align="center" width="100%" style="text-align: center" id="tablappal" name="tablappal">
<tr style="color:white">
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">FAMILIA</th>
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">MARCA</th>
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="20%">PRODUCTO</th>
<!--<th scope="col">REFERENCIA</th>-->
<!--<th scope="col">EMBALAJE</th>-->
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">CANTIDAD</th>
<!--<th scope="col">CAJAS</th>-->
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">PVP</th>
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">DESCUENTO</th>
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">NETO</th>
<th style="text-align:center; vertical-align:middle" bgcolor="#2c3e50" width="10%">TOTAL NETO</th>
<th style="text-align:center; vertical-align:middle" width="5%"></th>
</tr>
</table>
<h2><b>TOTAL</b> <span id="totaltotal"></span> €</h2>
<h2 id="resultado"></h2>
<input class="btn btn-default" type="button" id="mailbutton" onclick="enviarmail()" value="Recibir correo" disabled>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</body>
</html>
<?php
mysqli_free_result($Recordset1);
mysqli_free_result($Recordset2);
mysqli_free_result($Recordset3);
?>