| Server IP : 74.208.127.88 / Your IP : 216.73.216.182 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 : /proc/self/root/proc/thread-self/root/var/www/html/muebles/application/master/ |
Upload File : |
<?php
$titlepage="Mercancia";
$idsmenu=4;
include "../../library/config.php";
require_once("../model/dbconn.php");
require_once("../model/pos.php");
require_once("../model/sql.php");
include "../layout/top-header.php";
include "../../library/check_login.php";
include "../../library/check_access.php";
?>
<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">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Mercancia
<small>visita <a href="http://yusasoft.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><a href="#" id="btn-add"><i class="fa fa-barcode"> Alta Mercancia</i></a></li>
<li style="Background-color:white"><a href="../master/purchase2.php" ><i class="fa fa-truck"> Salida de mercancia a Venta</i></a></li>
<li><a href="../sales3/return.php"><i class="fa fa-share"> Entrada de mercancia a almacen</i></a></li>
<li><a href="purchase.php" ><i class="fa fa-reply"> Actualizar Inventario</i></a></li>
<li><a href="v_item0.php"><i class="fa fa-cloud-download"> Reporte Inventario </i></a></li>
<li>
<a href="<?php echo $sitename.'application/customer/menu.php'; ?>" title="salir inventarios" >Regresar</i></a>
</li>
</ul>
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</section>
<!-- /.content -->
<!-- Modal -->
<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">Nueva Mercancia</h4>
</div>
<div class="modal-body">
<div class="box-body">
<div class="form-horizontal">
<div class="form-group">
<label class="col-sm-2 control-label">Nombre: </label>
<input type="hidden" class="form-control " id="txtiditem" name="txtiditem" value="*New" placeholder="" disabled="">
<input type="hidden" id="crud" name="crud" class="" value="N">
<div class="col-sm-12"><input type="text" class="form-control " id="txtname" name="txtname" value="" autocomplete="off" placeholder="agregar nombre del producto"> </div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Departamento:</label>
<div class="col-sm-12">
<span class="hidden" id="id_category">Categoria</span>
<select name="category_id" id="category_id" class="form-control">
<option value="0">-- NINGUNA --</option>
<option value=""></option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-1 control-label">Codigo:</label>
<div class="col-sm-11"><input type="text" class="form-control " id="txtcodebar" name="txtcodebar" autocomplete="off" value="" placeholder="Agregar codigo de barras" > </div>
</div>
<div class="form-group"> <label class="col-sm-1 control-label">Stock: </label>
<div class="col-sm-11"><input type="text" class="form-control decimal" id="txtstock" name="" value="" placeholder="Existencia o stock" > </div>
</div>
<div class="form-group"> <label class="col-sm-1 control-label">Unidad: </label>
<div class="col-sm-11"><input type="text" class="form-control " id="txtunit" name="" value="" placeholder="ingrese tipo de unidad de producto ejemp. pz"> </div>
</div>
<div class="form-group">
<label class="col-sm-1 control-label">Precio De Credito:</label>
<div class="col-sm-11">
<div class="input-group">
<span class="input-group-addon">$.</span>
<input type="text" class="form-control money" id="txtprice" name="" value="" placeholder=""></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-1 control-label">Precio Contado:</label>
<div class="col-sm-11">
<div class="input-group">
<span class="input-group-addon">$.</span>
<input type="text" class="form-control money" id="txtnote" name="" value="" placeholder="">
</div>
</div>
</div>
<div class="form-group" id='txtmensajeBaja' >
<div class="row">
<div class="col-md-6">
<label for="Motivo Baja">Motivo Baja:</label>
<input type="text" name="txtreason" id="txtreason" class="form-control" placeholder="Motivo Baja" tabindex="4">
</div>
<div class="col-md-6">
<label for="fecha">Fecha:</label>
<input type="date" name="txtdateBaja" id="txtdateBaja" class="form-control" placeholder="fecha" tabindex="4">
</div>
</div>
</div>
</div>
<div style="margin-top:2px;">
<button type="submit" title="Guardar producto" class="btn btn-primary " id="btn-save" name=""><i class="fa fa-save"></i> Guardar</button>
<button type="button" class="btn btn-warning" title="editar " id="btnedit"> <i class="fa fa-pencil"></i> Editar</button>
<button type="button" class="btn btn-danger" title="baja " id="btnBaja"> <i class="fa fa-home"></i> Baja</button>
<button type="button" class="btn btn-info pull-right" title="Confirmar " id="btnConfirmar"> <i class="fa fa-home"></i> Confirmar</button>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-right" data-dismiss="modal">Cerrar</button>
<span id="infoproses"></span>
</div>
</div>
</div>
</div>
<style>
ul.ui-autocomplete {
z-index: 1100;
}
</style>
<div id="passwordmodal" class="modal fade ">
<div class="modal-dialog modal-md">
<div class="modal-content">
<div class="modal-header" style="Background-color:red">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Dar de Baja Empleado </h4>
</div>
<!--modal header-->
<div class="modal-body">
<div class="form-horizontal">
<div class="box-body">
<div class="form-group">
<label class="col-sm-3 control-label">Nombre de Empleado </label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtnameB" placeholder="Empleado a dar de Baja" >
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Fecha de Baja </label>
<div class="col-sm-9">
<input type="date" class="form-control" id="txtdateBaja" >
</div>
</div>
<input type="hidden" id="txthidetrxidB" >
<div class="form-group">
<label class="col-sm-3 control-label">Motivo de Baja </label>
<div class="col-sm-9">
<input type="text" class="form-control" id="txtreason" placeholder="Motivo de Baja" autocomplete="off">
</div>
</div>
<input type="hidden" class="form-control" id="txtpass" value="123" placeholder="Contraseña" >
<div class="form-group">
<label class="col-sm-2 control-label">
<button type="submit" class="btn btn-info " id="btncheckpass" name="btncheckpass"><i class="fa fa-home"></i> Confirmar</button> <span id="infopassword"></span>
</label>
</div>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" id="closeModalEntrada" data-dismiss="modal">Cerrar</button>
</div>
<!--modal footer-->
</div>
<!--modal-content-->
</div>
<!--modal-dialog modal-lg-->
</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 type="text/javascript">
//sacamos el precio de contado con el 40% menos del credito
document.getElementById("txtprice").onblur=message;
function message() {
var credito = document.getElementById("txtprice").value;
var contado = document.getElementById("txtprice").value;
//porcentaje de contado a descontar
var descuento = parseInt(credito)*0.35;
console.log("Datos descontados del credito:");
console.log(descuento.toFixed(2));
contado = credito-descuento;
document.getElementById("txtnote").value = contado.toFixed(2);
}
$(document).ready(function(){
$(document).ready(function(){
$("#category_id").load('../model/select_category.php');
});
$("#txtname").keydown(function(e) {
if(e.which == 13) {
set_focus("#category_id");
}
});
$("#category_id").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtcodebar");
}
});
$("#txtcodebar").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtstock");
}
});
$("#txtstock").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtunit");
}
});
$("#txtunit").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtprice");
}
});
$("#txtprice").keydown(function(e) {
if(e.which == 13) {
//alert("Precio de contado: " + discrp);
set_focus("#txtnote");
}
});
$("#txtnote").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtreason");
}
});
$("#txtreason").keydown(function(e) {
if(e.which == 13) {
set_focus("#txtdateBaja");
}
});
// function to repair keyboard tab in modal dialog adminlte
(function (){
var close = window.swal.close;
var previousWindowKeyDown = window.onkeydown;
window.swal.close = function() {
close();
window.onkeydown = previousWindowKeyDown;
};
})();
$('#table-customer').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_customer"
},
error: function (request, textStatus, errorThrown) {
swal(request.responseJSON.message);
}
},
columns: [
{ "data": null,render : function ( data, type, full, meta ) {
return meta.row + 1;
}},
{ "data": "name" },
{ "data": "gender" },
{ "data": "country" },
{ "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='Eliminar' class='btn btn-hapus btn-danger btn-xs'><i class='fa fa-remove'></i> Eliminar</button> ";
} },
]
});
});
$("#btn-save").click(function(){
if($("#txtname").val() == ''){
swal("Ingrese nombre");
return;
}
if($("#txtprice").val() == ''){
swal("Ingrese precio");
return;
}
if($("#txtstock").val() == ''){
swal("ingrese numero de exitencias");
return;
}
if($("#crud").val() == 'N'){
swal({
title: "Nuevo",
text: "Crear Nueva Mercancia ?",
type: "warning",
showCancelButton: true,
confirmButtonClass: "btn-primary",
confirmButtonText: "Guardar",
closeOnConfirm: false,
showLoaderOnConfirm: true
},
function(){
add_customer($("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(),$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val());
});
}
if($("#crud").val() == 'E')
{
swal({
title: "Editar",
text: " Editar Mercancia ?",
type: "warning",
showCancelButton: true,
confirmButtonClass: "btn-primary",
confirmButtonText: "Actualizar",
closeOnConfirm: false,
showLoaderOnConfirm: true
},
function(){
edit_customer($("#txtiditem").val(),$("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(),$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val());
});
}
if($("#crud").val() == 'B')
{
swal({
title: "Baja",
text: " Dar de Baja Mercancia ?",
type: "warning",
showCancelButton: true,
confirmButtonClass: "btn-primary",
confirmButtonText: "Actualizar",
closeOnConfirm: false,
showLoaderOnConfirm: true
},
function(){
edit_customer2($("#txtiditem").val(),$("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(),$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val(),$("#txtreason").val(),$("#txtdateBaja").val());
});
}
});
//guardar add_customer($("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(), ,$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val());
function add_customer(nm,cat,code,stk,uni,pri,not){
let ajax = {
method: "new_item",
name : nm,
category_id:cat,
codebar:code,
stock:stk,
unit:uni,
price:pri,
price_cont:not
}
$.ajax({
url: "c_item.php",
type: "POST",
data: ajax,
success: function(data, textStatus, jqXHR)
{
$resp = JSON.parse(data);
if($resp['status'] == true){
$("#txtname").val("");
$("#txtcodebar").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#txtunit").val("");
$("#txtnote").val("");
set_focus("#txtname");
document.getElementById("txtname").focus();
swal("Registro Exitoso!");
}else{
swal("Error al guardar mercancia : "+$resp['message'])
}
},
error: function (request, textStatus, errorThrown) {
swal("Error ", request.responseJSON.message, "error");
}
});
}
//($("#txtcode").val(),$("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(),$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val());
function edit_customer(id,nm,cat,code,stk,uni,pri,not){
let ajax = {
method: "edit_item",
id_cust : id,
name : nm,
category_id:cat,
codebar:code,
stock:stk,
unit:uni,
price:pri,
price_cont:not
}
$.ajax({
url: "c_item.php",
type: "POST",
data: ajax,
success: function(data, textStatus, jqXHR)
{
$resp = JSON.parse(data);
if($resp['status'] == true){
$("#txtname").val("");
$("#txtcodebar").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#txtunit").val("");
$("#txtnote").val("");
$("#category_id").html("");
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#modal-customer").modal("hide");
swal("Se Actualizo Registro! ");
}else{
$("#txtname").val("");
$("#txtcodebar").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#txtunit").val("");
$("#txtnote").val("");
$("#category_id").html("");
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#modal-customer").modal("hide");
swal($resp['message']);
}
},
error: function (request, textStatus, errorThrown) {
swal("Error ", request.responseJSON.message, "error");
}
});
}
// BAJA ($("#txtcode").val(),$("#txtname").val(),$("#category_id").val(),$("#txtcodebar").val(),$("#txtstock").val(),$("#txtunit").val(),$("#txtprice").val(),$("#txtnote").val());
function edit_customer2(id,nm,cat,code,stk,uni,pri,not,rea,dateB){
let ajax = {
method: "edit_itemB",
id_cust : id,
name : nm,
category_id:cat,
codebar:code,
stock:stk,
unit:uni,
price:pri,
price_cont:not,
reason: rea,
dateB:dateB
}
$.ajax({
url: "c_item.php",
type: "POST",
data: ajax,
success: function(data, textStatus, jqXHR)
{
$resp = JSON.parse(data);
if($resp['status'] == true){
$("#txtname").val("");
$("#txtcodebar").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#txtunit").val("");
$("#txtnote").val("");
$("#category_id").html("");
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#modal-customer").modal("hide");
swal("Se Actualizo Registro Baja! ");
}else{
$("#txtname").val("");
$("#txtcodebar").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#txtunit").val("");
$("#txtnote").val("");
$("#category_id").html("");
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#modal-customer").modal("hide");
swal($resp['message']);
}
},
error: function (request, textStatus, errorThrown) {
swal("Error ", request.responseJSON.message, "error");
}
});
}
$("#btn-add").click(function(){
$("#category_id").load('../model/select_category.php');
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#modal-customer").modal("show");
$("#txtname").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#crud").val("N");
$("#myModalLabel").html("Nueva Mercancia");
document.getElementById('btn-save').style.visibility = "visible"; // show
document.getElementById('btnBaja').style.visibility = "visible"; // show
document.getElementById('btnedit').style.visibility = "visible"; // show
document.getElementById('btnConfirmar').style.visibility = "hidden"; // show
document.getElementById('txtmensajeBaja').style.visibility = "hidden"; // show
document.getElementById('btnBaja2').style.visibility = "hidden"; // show
});
$("#btnedit").click(function(){
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#txtname").val("");
$("#txtprice").val("");
$("#txtstock").val("");
$("#crud").val("E");
$("#myModalLabel").html("Editar Mercancia");
document.getElementById('btnBaja').style.visibility = "hidden"; // show
document.getElementById('btn-save').style.visibility = "hidden"; // show
document.getElementById('btnedit').style.visibility = "hidden"; // show
document.getElementById('btnConfirmar').style.visibility = "visible"; // show
});
$("#btnBaja").click(function(){
set_focus("#txtname");
document.getElementById("txtname").focus();
$("#txtname").val("");
$("#txtcountry").val("");
$("#txtphone").val("");
$("#crud").val("B");
$("#myModalLabel").html("Baja Mercancia");
document.getElementById('btn-save').style.visibility = "hidden"; // show
document.getElementById('btnBaja').style.visibility = "hidden"; // show
document.getElementById('btnedit').style.visibility = "hidden"; // show
document.getElementById('btnConfirmar').style.visibility = "visible"; // show
document.getElementById('txtmensajeBaja').style.visibility = "visible"; // show
//$("#modal-customer").modal("hide");
});
//CONFIRMAR crud
$("#btnConfirmar").click(function(){
$("#btn-save").click();
});
$( "#txtname" ).autocomplete({
search : function(){$(this).addClass('working');},
open : function(){$(this).removeClass('working');},
source: function(request, response) {
$.getJSON("autocomplete_item.php", { term: $('#txtname').val() },
response); },
minLength:1,
select:function(event, ui){
$("#txtname").val(ui.item.nombre);
$("#txtiditem").val(ui.item.id_item);
$("#txtprice").val(ui.item.credito);
$("#txtnote").val(ui.item.contado);
$("#txtcodebar").val(ui.item.barcode);
$("#txtstock").val(ui.item.stock);
$("#txtunit").val(ui.item.unit);
$("#id_category").html(ui.item.category_id);
$("#actual_category").html(ui.item.actual_category);
$("#category_id").val(ui.item.category_id);
}
}).autocomplete( "instance" )._renderItem = function( ul, item ) {
return $( "<li>" )
.append( "<dl><dt>"+item.label + "</dt>"+item.price+item.note+ "</dl>" )
.appendTo( ul );
};
$(document).on("click",".btn-hapus",function(){
let current_row = $(this).parents('tr');
if (current_row.hasClass('child')) {
current_row = current_row.prev();
}
let table = $('#table-customer').DataTable();
let data = table.row( current_row).data();
let idcust = data.id_cust;
swal({
title: "Borrar",
text: "Eliminar permanentemente, esta seguro ?",
type: "warning",
showCancelButton: true,
confirmButtonClass: "btn-danger",
confirmButtonText: "Borrar",
closeOnConfirm: false,
showLoaderOnConfirm: true
},
function(){
let ajax = {
method : "delete_customer",
id_cust : idcust,
}
$.ajax({
url:"customer.php",
type: "POST",
data: ajax,
success: function(data, textStatus, jqXHR)
{
$resp = JSON.parse(data);
if($resp['status'] == true){
swal("Correctamento eliminado");
let xtable = $('#table-customer').DataTable();
xtable.ajax.reload( null, false );
}else{
swal("Error delete customer : "+$resp['message'])
}
},
error: function (request, textStatus, errorThrown) {
swal("Error ", request.responseJSON.message, "error");
}
});
});
});
</script>
</body>
</html>