Track issues, Ask questions, Make suggestions,Report a bug
This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.
Hi, Is there any example how to use ACTION BEFORE ADD?
what i want is :
1.- MAke a query to validate if date input EXIST on Database or IS in a RANGE:
$db->rawQuery("UPDATE posts SET view_count=view_count + 1 WHERE id='$rec_id'");
2.- If Exists Cancel ADD and send a message
3.- If NOT Insert
var today = new Date();Note :
var dd = today.getDate();
var mm = today.getMonth()+1; //January is 0!
var yyyy = today.getFullYear();
if(dd<10){dd='0'+dd} if(mm<10){mm='0'+mm} today = yyyy+'-'+mm+'-'+dd;
$(document.body).on('change keyup input', 'input[name="harga_satuan"]', function() {
$('#ctrl-tgl_perubahan').val(today);
});
var varTempo = 0;
$(document.body).on('change',"#ctrl-Customer",function (e) {
var pro = $("#ctrl-Customer option:selected").text();
let arrCust = pro.split(' | ');
var dd = document.getElementById('ctrl-Sales');
for (var i = 0; i < dd.options.length; i++) {
if (dd.options[i].value === arrCust[1]) {
dd.selectedIndex = i;
break;
}
}
//Isi Field Sesuai nilai array
$('input[name="Limit_Kredit"]').val(arrCust[2]);
$('input[name="Total_Piutang"]').val(arrCust[3]);
$('input[name="Tempo_Pembayaran"]').val(arrCust[4]);
$('input[name="Contact_Person"]').val(arrCust[5]);
//Tampilkan Nilai PPN
var nppn = 0;
var hppn = arrCust[6];
hppn = hppn.replace(/^\s+|\s+$/gm,'');
if (hppn === "Y") {
nppn = 10;
} else {
nppn = 0;
}
$('input[name="PPN"]').val(nppn);
//Set Tanggal Tempo Pembayaran
varTempo = arrCust[4]
setTglTempo();
//Hitung Total
nilaiPPN = nppn;
hitungTotal();
});
$(document.body).on('change', 'input[name="Tgl_Rencana_Kirim"]', function() {
//Set Tanggal Tempo Pembayaran
setTglTempo();
});
$(document.body).on('change keyup input', 'input[name="Tempo_Pembayaran"]', function() {
//Set Tanggal Tempo Pembayaran
varTempo = $(this).val();
setTglTempo();
});
function setTglTempo() {
var trk = new Date(document.getElementById('ctrl-Tgl_Rencana_Kirim').value);
trk.setDate(trk.getDate() + parseInt(varTempo));
var ttp = trk.toISOString().slice(0, 10);
$('input[name="Tgl_Tempo_Pembayaran"]').val(ttp);
};
var disRupiah = 0;
var disPersen = 0;
var nilaiPPN =0;
$(document.body).on('change keyup input', 'input[name="Diskon_Persen"]', function() {
//Hitung Total
disPersen = $(this).val();
hitungTotal();
});
$(document.body).on('change keyup input', 'input[name="Diskon_Rupiah"]', function() {
//Hitung Total
disRupiah = $(this).val();
hitungTotal();
});
$(document.body).on('change keyup input', 'input[name="PPN"]', function() {
//Hitung Total
nilaiPPN = $(this).val();
hitungTotal();
});
function hitungTotal() {
var gtADP = 0;
var gtAD = 0;
var gtAP = 0;
gt = document.getElementById('ctrl-Grand_Total').value;
alert(gt);
gtADP = parseInt(gt) * parseInt(disPersen) / 100;
gtAD = parseInt(gt) - gtADP - parseInt(disRupiah);
$('input[name="GT_AD"]').val(gtAD);
gtAP = gtAD + (gtAD * parseInt(nilaiPPN) / 100);
$('input[name="GT_AP"]').val(gtAP);
};
var jml = 0;
var hrg = 0;
var tot = 0;
$(document.body).on('change',"#ctrl-Produk",function (e) {
var pro = $("#ctrl-Produk option:selected").text();
pro = pro.replace(/ /g,'');
let arrpro = pro.split('|');
$('input[name="Satuan"]').val(arrpro[1]);
$('input[name="Harga"]').val(arrpro[2]);
hrg = arrpro[2];
setTotal();
});
$(document.body).on('change keyup input', 'input[name="Jumlah"]', function() {
jml = $(this).val();
setTotal();
});
$(document.body).on('change keyup input', 'input[name="Harga"]', function() {
hrg = $(this).val();
setTotal();
});
function setTotal() {
tot = parseInt(jml, 10) * parseInt(hrg, 10);
$('input[name="Total"]').val(tot);
};
$(function (){
var chartData = {
labels : ["9","10"],
datasets : [
{
label: 'Dataset 1',
backgroundColor:[
'rgba(138,94,38,0.5)','rgba(159,207,225,0.5)', ],
borderWidth:3,
pointStyle:'circle',
pointRadius:5,
lineTension:0.1,
type:'line',
steppedLine:true,
data : ["1","2"],
}
]
}
var ctx = document.getElementById('barchart_salesgraph');
var chart = new Chart(ctx, {
type:'bar',
data: chartData,
options: {
scaleStartValue: 0,
responsive: true,
scales: {
xAxes: [{
ticks:{display: true},
gridLines:{display: true},
categoryPercentage: 1.0,
barPercentage: 0.8,
scaleLabel: {
display: true,
labelString: "Month"
},
}],
yAxes: [{
ticks: {
beginAtZero: true,
display: true
},
scaleLabel: {
display: true,
labelString: "Sales"
}
}]
},
}
,
})});
$('body').on('change keyup input', 'input[name="#ctrl-Jumlah"]', function() {
jml = $(this).val();
$('#ctrl-Total').val(jml * 2);
});
$('body').on('change keyup input', 'input[name="#ctrl-Jumlah"]', function() {
jml = $(this).val();
$('#ctrl-Total').val(jml * 2);
});