Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function rekapProduk(){
- db.transaction(function (tx) {
- var now = new Date();
- var today = now.getFullYear()+''+String('0'+(now.getMonth()+1)).substr(-2,2)+''+String('0'+now.getDate()).substr(-2,2);;
- now.setDate(now.getDate()+30);
- var bln1 = now.getFullYear()+''+String('0'+(now.getMonth()+1)).substr(-2,2)+''+String('0'+now.getDate()).substr(-2,2);
- now.setDate(now.getDate()+30);
- var bln2 = now.getFullYear()+''+String('0'+(now.getMonth()+1)).substr(-2,2)+''+String('0'+now.getDate()).substr(-2,2);
- now.setDate(now.getDate()+30);
- var bln3 = now.getFullYear()+''+String('0'+(now.getMonth()+1)).substr(-2,2)+''+String('0'+now.getDate()).substr(-2,2);
- now.setDate(now.getDate()+30);
- // var bln4 = now.getFullYear()+''+String('0'+(now.getMonth()+1)).substr(-2,2)+''+String('0'+now.getDate()).substr(-2,2);
- var batas = now.getFullYear()+'-'+String('0'+(now.getMonth()+1)).substr(-2,2)+'-'+String('0'+now.getDate()).substr(-2,2);
- tx.executeSql("SELECT kelas,deskripsi,qty,expired from products WHERE expired<='"+batas+"'", [], function(a,res){
- if (res.rows.length) {
- var data = {0:[], 1:[], 2:[], 3:[]/* , 4:[] */};
- var tglData;
- for (var i = 0; i < res.rows.length; i++) {
- tglData = parseInt(res.rows.item(i).expired.replace(/-/g,''));
- if(tglData<=parseInt(today)){
- data[0].push(res.rows.item(i));
- }else if(tglData>parseInt(today) && tglData<=parseInt(bln1)){
- data[1].push(res.rows.item(i));
- }else if(tglData>parseInt(bln1) && tglData<=parseInt(bln2)){
- data[2].push(res.rows.item(i));
- }else if(tglData>parseInt(bln2) && tglData<=parseInt(bln3)){
- data[3].push(res.rows.item(i));
- }
- }
- var table;
- // Expired (WO)
- if(data[0].length){
- table = '<div class="data-table"><table><thead><tr><th class="label">Produk</th><th class="label">Qty</th><th class="label">Expired</th></tr></thead><tbody>';
- $$.each(data[0], function(i, row){
- table += '<tr><td class="label-cell"><strong>'+row.kelas+'</strong><br />'+row.deskripsi+'</td><td class="numeric-cell">'+row.qty+'</td><td class="label-cell">'+tanggal('j-M-Y',row.expired)+'</td></tr>';
- });
- table += '</tbody></table></div>';
- $$('.data-expired-0').html(table);
- }else{
- $$('.data-expired-0').html('<div class="pad">Tidak ada data</div>');
- }
- // Expired 1 bulan
- if(data[1].length){
- table = '<div class="data-table"><table><thead><tr><th class="label">Produk</th><th class="label">Qty</th><th class="label">Expired</th></tr></thead><tbody>';
- $$.each(data[1], function(i, row){
- table += '<tr><td class="label-cell"><strong>'+row.kelas+'</strong><br />'+row.deskripsi+'</td><td class="numeric-cell">'+row.qty+'</td><td class="label-cell">'+tanggal('j-M-Y',row.expired)+'</td></tr>';
- });
- table += '</tbody></table></div>';
- $$('.data-expired-1').html(table);
- }else{
- $$('.data-expired-1').html('<div class="pad">Tidak ada data</div>');
- }
- // Expired 2 bulan
- if(data[2].length){
- table = '<div class="data-table"><table><thead><tr><th class="label">Produk</th><th class="label">Qty</th><th class="label">Expired</th></tr></thead><tbody>';
- $$.each(data[2], function(i, row){
- table += '<tr><td class="label-cell"><strong>'+row.kelas+'</strong><br />'+row.deskripsi+'</td><td class="numeric-cell">'+row.qty+'</td><td class="label-cell">'+tanggal('j-M-Y',row.expired)+'</td></tr>';
- });
- table += '</tbody></table></div>';
- $$('.data-expired-2').html(table);
- }else{
- $$('.data-expired-2').html('<div class="pad">Tidak ada data</div>');
- }
- // Expired 3 bulan
- if(data[3].length){
- table = '<div class="data-table"><table><thead><tr><th class="label">Produk</th><th class="label">Qty</th><th class="label">Expired</th></tr></thead><tbody>';
- $$.each(data[3], function(i, row){
- table += '<tr><td class="label-cell"><strong>'+row.kelas+'</strong><br />'+row.deskripsi+'</td><td class="numeric-cell">'+row.qty+'</td><td class="label-cell">'+tanggal('j-M-Y',row.expired)+'</td></tr>';
- });
- table += '</tbody></table></div>';
- $$('.data-expired-3').html(table);
- }else{
- $$('.data-expired-3').html('<div class="pad">Tidak ada data</div>');
- }
- dataNotifikasi();
- }else{
- $$('.data-expired-1,.data-expired-2,.data-expired-3').html('<div class="pad">Tidak ada data</div>');
- }
- });
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement