| Server IP : 74.208.127.88 / Your IP : 3.129.250.3 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/mueblesOLDMAYO/applicationOLD/customer2/ |
Upload File : |
<?php
$titlepage="Clientes";
$idsmenu=4;
include "../../library/config.php";
require_once("../model/dbconn.php");
require_once("../model/pos.php");
require_once("../model/sql2.php");
include "../layout/top-header.php";
include "../../library/check_login.php";
include "../../library/check_access.php";
$posR = new pos();
$resultR = array();
$queryR = $posR->getMaxC();
$dataR = $queryR[1];
//aumentamos en 1 para el proximo id
$resultR['Max_id'] = $dataR['id'] + 1;
?>
<link rel="stylesheet" href="../../dist/css/bootstrap-switch.min.css">
<link rel="stylesheet" href="../../plugins/datepicker/datepicker3.css">
<!-- Main content -->
<section class="content">
<!-- Default box -->
<div class="box box-primary">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Clientes
<small>visita <a href="https://yusasoft1.com/">Sistemas Yusa</a> Mas Informacion</small>
</h1>
</section>
<div class="box-body">
<!-- main navigation bar disini -->
<div class="collapse navbar-collapse pull-left" id="navbar-collapse">
<ul class="nav navbar-nav">
<li style="Background-color:orange"><a href="#" id="btn-add"><i class="fa fa-barcode"> Alta Cliente Nuevo</i></a></li>
<li>
<a href="<?php echo $sitename.'application/customer2/menu.php'; ?>" title="salir inventarios" >Regresar</i></a>
</li>
</ul>
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</section>
<!-- /.content -->
<!-- Modal Clientes -->
<div class="modal fade" id="modal-customer" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header" style="Background-color:red">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Nuevo Cliente</h4>
</div>
<div class="modal-body">
<div class="box-body">
<div class="form-horizontal">
<div class="form-group">
<label class="col-sm-3 control-label">Numero Contrato*</label>
<div class="col-sm-9">
<input type="number" class="form-control" id="txtcontract" placeholder="Numero de contrato " required>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">cobrador</label>
<div class="col-sm-9">
<div class="input-group">
<input type="hidden" class="form-control " id="id_seller_ok" value="2" disabled>
<span class="input-group-addon" id="id_seller"></span>
<select name="selector-seller" id="selector-seller" class="form-control" >
<option value="01">-- Seleccionar --</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Nombre Cliente</label>
<div class="col-sm-9">
<input type="hidden" id="crud">
<input type="hidden" id="txtcode">
<input type="text" class="form-control" id="txtnombre" placeholder="Nombre del Cliente " required autocomplete="off">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Nombre del Conyugue</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtconyugue" placeholder="Conyugue " required autocomplete="off">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Direccion</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtdireccion" placeholder="Direccion " required autocomplete="off">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">entre Calles</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtcome_in" placeholder="Datos Adicionales de domicilio " required autocomplete="off">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Telefono</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txttelefono" placeholder="Telefono" required autocomplete="off">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Credito</label>
<div class="col-sm-9">
<select class="form-control" id="cbocredito" >
<option value="SI">SI</option>
<option value="NO">NO</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Poblacion</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtpoblacion" placeholder="Poblacion" required>
</div>
</div>
<span id="infoproses"></span> </div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Limpiar Campos</button>
<button type="button" class="btn btn-info pull-center" id="btnAbrirAdi" >Abrir Datos Adicionales</button>
<button type="button" class="btn btn-primary" title="Guardar Registro Cliente" id="btnsaveitem"> <i class="fa fa-save"></i> Guardar Cliente</button>
</div>
</div>
</div>
</div>
</div>
<!-- Modal Empleo-->
<div class="modal fade" id="modal-customer_job" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header" style="Background-color:red">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Datos Adicionales de Cliente</h4>
</div>
<div class="modal-body">
<div class="box-body">
<div class="form-horizontal">
<div class="modal-header" style="Background-color:red">
<h5 class="modal-title" id="myModalLabel">Datos Empleo</h5>
</div>
<br>
<div class="form-group">
<label class="col-sm-3 control-label">Cliente</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtclientA" value="<?php echo $resultR['Max_id']; ?>" placeholder="Cliente asociado a datos adicionales" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Lugar de Trabajo</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtworkplace" placeholder="Donde trabaja" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Antiguedad</label>
<div class="col-sm-9">
<div class="input-group">
<span class="input-group-addon">$.</span>
<input type="text" class="form-control decimal" id="txtlaborOld" value="0" required>
<span class="input-group-addon "></span>
<select name="txtpayment_period" id="txtlaborOld_periodicity" class="form-control" required>
<option value="0">-- años --</option>
<option value="1">meses</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label"><a href="#" class="btndisc btndiscprc">Sueldo</a></label>
<div class="col-sm-9">
<div class="input-group">
<span class="input-group-addon">$.</span>
<input type="text" class="form-control decimal" id="txtsalary" value="0" required>
<span class="input-group-addon "></span>
<select name="txtpayment_period" id="txtpayment_periodicity" class="form-control" required>
<option value="0">-- semanal --</option>
<option value="1">Semanal</option>
<option value="2">Catorcena</option>
<option value="3">Quincena</option>
<option value="4">Mensual</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label"><a href="#" id="btnaval" class="btndisc btndiscprc">Avales</a></label>
<table id="table-avales" class="table table-bordered">
<thead>
<tr>
<th>Nombre</th>
<th>Direccion</th>
</thead>
<tr>
<td><input type="text"id="textA" /></td>
<td><input type="text"id="textB" /></td>
</tr>
<tr>
<td><input type="text"id="textC" /></td>
<td><input type="text"id="textD" /></td>
</tr>
<button onclick="unirTexto()" id="unir">Agregar</button>
<button onclick="limpiar()" id="limpiar">Limpiar</button>
</table>
<textarea class="form-control " maxlength="250" rows="6" id="txtnote" placeholder="Maximo 4 avales"></textarea>
</div>
<script>
function unirTexto(){
var c1=document.getElementById('textB').value;
var t1=document.getElementById('textA').value;
var clx=document.getElementById('textC').value;
var tly=document.getElementById('textD').value;
var p = t1;
var resultado = document.getElementById('txtnote');
var html = "";
for (var i = 0; i < p.length; i++) {html = "<br>" +' '+ c1 +' '+ t1 + ' '+ clx +' '+ tly +' '+ "<br>"; resultado.innerHTML = html;}
document.getElementById("txtnote").innerHTML = html;
;}
function limpiar() {
document.getElementById('textB').value ="";
document.getElementById('textA').value ="";
document.getElementById('textC').value ="";
document.getElementById('textD').value ="";
resultado.innerHTML = " ";
copia.value= "";}
</script>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Limpiar Campos</button>
<button type="button" class="btn btn-primary" title="Guardar Registro Cliente" id="saveCobranza"> <i class="fa fa-save"></i> Guardar Datos de Empleo</button>
</div>
</div>
<div class="form-horizontal">
<div class="modal-header" style="Background-color:red">
<h5 class="modal-title" id="myModalLabel">Datos de Cobranza</h5>
</div>
<br>
<div class="form-group">
<label class="col-sm-3 control-label"><a href="#" class="btndisc btndiscprc">Pago Minimo</a></label>
<div class="col-sm-9">
<div class="input-group">
<span class="input-group-addon">$.</span>
<input type="text" class="form-control decimal" id="txtmin_pay" value="0" required>
<span class="input-group-addon "></span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Periodicidad del Pago</label>
<div class="col-sm-9">
<div class="input-group">
<span class="input-group-addon" ></span>
<select name="txtpayment_period" id="txtpayment_period" class="form-control" required>
<option value="0">-- Seleccionar --</option>
<option value="1">Semanal</option>
<option value="2">Catorcena</option>
<option value="3">Quincena</option>
<option value="4">Mensual</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Fecha 1er. Pago</label>
<div class="col-sm-9">
<input type="text" class="form-control txtpaydate" id="txtpaydate" value="<?php echo date("Y-m-d hh:mm:ss");?>" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Dia de Cobro</label>
<div class="col-sm-9">
<div class="input-group">
<span class="input-group-addon" ></span>
<select name="txtpayday" id="txtpayday" class="form-control" required>
<option value="0">-- Seleccionar --</option>
<option value="1">Lunes</option>
<option value="2">Martes</option>
<option value="3">Miercoles</option>
<option value="4">Jueves</option>
<option value="5">Viernes</option>
<option value="6">Sabado</option>
<option value="7">Domingo</option>
</select>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Limpiar Campos</button>
<button type="button" class="btn btn-danger pull-center" data-dismiss="modal"> <i class="fa fa-close"></i> Cancelar</button>
<button type="button" class="btn btn-primary" title="Guardar Registro de cobranza 2" id="saveCobranza2"> <i class="fa fa-save"></i> Guardar Datos de Cobranza</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "../layout/footer.php"; //footer template ?>
<?php include "../layout/bottom-footer.php"; //footer template ?>
<script src="../../plugins/datepicker/bootstrap-datepicker.js"></script>
<script src="../../dist/js/redirect.js"></script>
<script src="j_customer.js"></script>
<script src="../../bower_components/bootstrap-sweetalert/dist/sweetalert.min.js"></script>
<script src="../../bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="../../bower_components/datatables.net-bs/js/dataTables.bootstrap.js"></script>
<script type="text/javascript">
$('#table-customer2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"processing": true,
"ordering": false,
"info": false,
"responsive": true,
"autoWidth": false,
"pageLength": 100,
"dom": '<"top"f>rtip',
"fnDrawCallback": function( oSettings ) {
},
"ajax": {
"url": "customer.php",
"type": "POST",
"data" : {
method : "list_customer2"
},
error: function (request, textStatus, errorThrown) {
swal(request.responseJSON.message);
}
},
columns: [
{ "data": null,render : function ( data, type, full, meta ) {
return meta.row + 1;
}},
{ "data": "contract" },
{ "data": "name" },
{ "data": "conyugue" },
{ "data": "direccion" },
{ "data": "come_in" },
{ "data": "credito" },
{ "data": "poblacion" },
{ "data": "phone" },
{ "data": null, render : function(data,type,row){
return "<button title='Editar' class='btn btn-edit btn-warning btn-xs'><i class='fa fa-pencil'></i> Editar</button> <button title='borrar' class='btn btn-hapus btn-danger btn-xs'><i class='fa fa-remove'></i> borrar</button> ";
} },
]
});
$(document).ready(function(){
$("#txtcontract").keydown(function(e) {
if(e.which == 13) {
set_focus("#selector-seller");
}
});
$("#selector-seller").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtnombre");
}
});
$("#txtnombre").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtconyugue");
}
});
$("#txtconyugue").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtdireccion");
}
});
$("#txtdireccion").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtcome_in");
}
});
$("#txtcome_in").keydown(function(e) {
if(e.which == 13) {
set_focus("#txttelefono");
}
});
$("#txttelefono").keydown(function(e) {
if(e.which == 13) {
set_focus("#cbocredito");
}
});
$("#cbocredito").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtpoblacion");
}
});
$("#txtpoblacion").keydown(function(e) {
if(e.which == 13) {
set_focus("#btnsaveitem");
}
});
//salto en ventana de trabajo de cliente txtworkplace
$("#btnsaveitem").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtworkplace");
}
});
$("#txtworkplace").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtlaborOld");
}
});
$("#txtlaborOld").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtsalary");
}
});
$("#txtsalary").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtpayment_periodicity");
}
});
$("#txtpayment_periodicity").keydown(function(e) {
if(e.which == 13) {
set_focus("#textA");
}
});
$("#textA").keydown(function(e) {
if(e.which == 13) {
set_focus("#textB");
}
});
$("#unir").keydown(function(e) {
if(e.which == 13) {
set_focus("#textA");
}
});
//datos de cobranza saveCobranza
$("#saveCobranza").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtmin_pay");
}
});
$("#txtmin_pay").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtpayment_period");
}
});
$("#txtpayment_period").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtpaydate");
}
});
$("#txtpaydate").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtpayday");
}
});
$("#txtpayday").keydown(function(e) {
if(e.which == 13) {
set_focus("#saveCobranza2");
}
});
$( "#txtclient" ).autocomplete({
search : function(){$(this).addClass('working');},
open : function(){$(this).removeClass('working');},
source: function(request, response) {
$.getJSON("autocomplete_client.php", { term: $('#txtclient').val() },
response); },
minLength:1,
select:function(event, ui){
$("#crud").val("E");
$("#txtcode").val(ui.item.id_client);
$("#txtcontract").val(ui.item.contract);
$("#txtnombre").val(ui.item.cliente);
$("#txtconyugue").val(ui.item.conyugue);
$("#txtdireccion").val(ui.item.direccion);
$("#txtcome_in").val(ui.item.come);
$("#txttelefono").val(ui.item.phone1);
$("#txtpoblacion").val(ui.item.id);
$("#cbocredito").val(ui.item.credito);
$("#modal-customer").modal("show");
}
}).autocomplete( "instance" )._renderItem = function( ul, item ) {
return $( "<li>" )
.append( "<dl><dt>"+item.id + "</dt>"+item.name+ "</dl>" )
.appendTo( ul );
};
$(document).on("click",".btn-edit",function(){
var current_row = $(this).parents('tr');
if (current_row.hasClass('child')) {
current_row = current_row.prev();
}
$("#myModalLabel").html("Editar Cliente");
var table = $('#table-customer2').DataTable();
var data = table.row( current_row).data();
$("#txtcontract").val(data.contract);
$("#txtnombre").val(data.name);
$("#txtconyugue").val(data.conyugue);
$("#txtdireccion").val(data.direccion);
$("#txtcode").val(data.id_cust);
$("#txtpoblacion").val(data.poblacion);
$("#cbocredito").val(data.credito)
$("#txttelefono").val(data.phone)
$("#modal-customer").modal("show");
setTimeout(function(){
$("#txtnombre").focus();
}, 1000);
$("#crud").val("E");
});
$(document).on("keyup keydown","#txtclient",function(){
var searchitem = $("#txtclient").val();
value={
term : searchitem,
}
$.ajax(
{
url : "c_search_customer.php",
type: "POST",
data : value,
success: function(data, textStatus, jqXHR)
{
var data = jQuery.parseJSON(data);
$("#table-customer2 tbody").html(data.data)
},
error: function(jqXHR, textStatus, errorThrown)
{
}
});
});
});
</script>
</body>
</html>