INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','11:06:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-28 ','11:09:13');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0001','kasirbip','1',' DP-01760BI','TOKO','BIPPSN','PSPLT-ZCXC-40-0','CINCIN PALADIUM ','','3.630','1','17.00','816000','0','0','17000','1789000','0','0','0','1789000','SULIS','00042183','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.630',berat_jual_asli=berat_jual_asli+'3.630',stock_jual='1',berat_akhir=berat_akhir-'3.630',berat_akhir_asli=berat_akhir_asli-'3.630',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PSPLT-ZCXC-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0001','2026-03-28','3.630','2026-03-28','11:13:46','PLG0010161','1789000','1789000','0','1789000','0','kasirbip','2026-03-28 11:13:46','FJ-260328-0001','DP-01760','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0001','2026-03-28','11:13:46','SULIS','1789000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0001','2026-03-28','2026-03-28 11:13:46','PENJUALAN : FJ-260328-0001','.','TBC','839000','839000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0002','D','2026-03-28','11:13:46','TBC','PENJUALAN','FJ-260328-0001','21184423514','839000','21185262514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='839000' WHERE no_faktur_jual='FJ-260328-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0002','kasirbip',' 1',' DP-01759BI','TOKO','BIPPSN','PSPLT-ZCAX-6-0','CINCIN PALADIUM ','','1.720','1','17.00','387000','0','0','17000','1476000','0','0','0','1476000','SULIS','00042230','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PSPLT-ZCAX-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0002','2026-03-28','1.720','2026-03-28','11:13:46','PLG0010162','1476000','1476000','0','1476000','0','kasirbip','2026-03-28 11:13:46','FJ-260328-0001','DP-01759','780000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0002','2026-03-28','11:13:46','SULIS','1476000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0002','2026-03-28','2026-03-28 11:13:46','PENJUALAN : FJ-260328-0002','.','TBC','696000','696000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0003','D','2026-03-28','11:13:46','TBC','PENJUALAN','FJ-260328-0002','21185262514','696000','21185958514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1535000' WHERE no_faktur_jual='FJ-260328-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01906','GIN','1','CC','NAMBAH SZ MENJADI 16 DAN CROM ULANG SEPERTI ASAL PUTIH GLOSSY COMB DOFF SEMPROT','2.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0003','2026-03-28','2026-03-28 11:59:49','SERVICE : SV-01906','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0004','D','2026-03-28','11:59:49','TBC','SERVICE','SV-01906','21185958514','50000','21186008514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01906','2026-03-28','2026-03-28','11:59:49','PLG0010163','kasirbip','2026-04-20','kasirbip','2026-03-28 11:59:49','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01907','SULIS','1','CC PLD','PUTIH GLOSY PASANG PERMATA GRF JANGAN HILANG SZ 9 5','2.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0004','2026-03-28','2026-03-28 14:03:03','SERVICE : SV-01907','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0005','D','2026-03-28','14:03:03','TBC','SERVICE','SV-01907','21186008514','50000','21186058514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01907','2026-03-28','2026-03-28','14:03:03','PLG0010164','kasirbip','2026-03-24','kasirbip','2026-03-28 14:03:03','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01863','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','300000','0','700000','1300000','sz 9.5 model tanpa mata','putih glosy','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0005','2026-03-28','2026-03-28 15:30:27','PESANAN : DP-01863','.','TBC','1040000','1040000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0006','D','2026-03-28','15:30:27','TBC','PESANAN','DP-01863','21186058514','1040000','21187098514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01863','2026-03-28','2026-03-28','15:30:27','PLG0010165','SULIS','2026-05-05','kasirbip','2026-03-28 15:30:27','2.000','0','0','0','1040000','0','700000','1300000','1300000','260000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01864','SULIS','1','PLD','WED RING','','','3.500','','10.00','1','1200000','300000','0','700000','1750000','sz 17 putih glosy','model tanpa mata','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0006','2026-03-28','2026-03-28 15:31:30','PESANAN : DP-01864','.','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0007','D','2026-03-28','15:31:30','TBC','PESANAN','DP-01864','21187098514','1400000','21188498514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01864','2026-03-28','2026-03-28','15:31:30','PLG0010166','SULIS','2026-05-05','kasirbip','2026-03-28 15:31:30','3.500','0','0','0','1400000','0','700000','1750000','1750000','350000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','16:55:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-03-28 ','17:09:58');
DELETE FROM tm_berlian WHERE kode_barang='PMM-YGXH-12-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-YGXH-12-0','00037041','00037041','CINCIN SILVER 925 ','CINCIN SILVER 925','','','41500','41500',' 150000','150000','Nagatech','2026-03-28 17:12:44');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-15-00290 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YGXH-12-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0003','Nagatech','1',' 700K-15-00','TOKO','MMPER','PMM-YGXH-12-0','CINCIN SILVER 925','','2.070','1','100.00','48000','0','0','17000','850000','0','0','0','850000','ASRI','00037041','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXH-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PMM-YGXH-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0003','2026-03-28','2.070','2026-03-28','17:14:09','PLG0010167','850000','850000','0','850000','0','Nagatech','2026-03-28 17:14:09','FJ-260328-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0003','2026-03-28','17:14:09','ASRI','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0007','2026-03-28','2026-03-28 17:14:09','PENJUALAN : FJ-260328-0003','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0008','D','2026-03-28','17:14:09','TBC','PENJUALAN','FJ-260328-0003','21188498514','850000','21189348514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260328-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0004','Nagatech',' 1',' 700K-11-80','TOKO','MMPER','PMM-ZBAX-40-0','CINCIN SILVER 925 ','','2.690','1','100.00','275000','0','0','17000','850000','0','0','0','850000','ASRI','00041476','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBAX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PMM-ZBAX-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0004','2026-03-28','2.690','2026-03-28','17:14:09','PLG0010168','850000','850000','0','850000','0','Nagatech','2026-03-28 17:14:09','FJ-260328-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0004','2026-03-28','17:14:09','ASRI','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0008','2026-03-28','2026-03-28 17:14:09','PENJUALAN : FJ-260328-0004','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0009','D','2026-03-28','17:14:09','TBC','PENJUALAN','FJ-260328-0004','21189348514','850000','21190198514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260328-0004' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01908','MIA','1','SEPASANG SILVER','CWO SZ 19 PUTIH DOFF AMPLASS CWE PUTIH GLOSY FONT BRUSH SCRIPT','6.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01908','2026-03-28','2026-03-28','17:24:24','PLG0010169','kasirbip','2026-03-22','kasirbip','2026-03-28 17:24:24','6.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-28 ','17:24:56');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0005','kasirbip','1',' 800K-14-22','TOKO','BIPPER','PBDG-ZBBG-8-0','CINCIN SILVER 925 ','','2.630','1','100.00','269000','0','0','17000','950000','0','0','0','950000','MIA','00042010','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PBDG-ZBBG-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0005','2026-03-28','2.630','2026-03-28','17:26:45','PLG0010170','950000','950000','0','950000','0','kasirbip','2026-03-28 17:26:44','FJ-260328-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0005','2026-03-28','17:26:45','MIA','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0009','2026-03-28','2026-03-28 17:26:44','PENJUALAN : FJ-260328-0005','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0010','D','2026-03-28','17:26:45','TBC','PENJUALAN','FJ-260328-0005','21190198514','950000','21191148514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260328-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0006','kasirbip',' 1',' 700K-25-00','TOKO','BIPPER','LXPER-ZBAH-26-0','CINCIN SILVER 925 ','','4.810','1','100.00','492000','0','0','17000','900000','0','0','0','900000','MIA','00041644','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.810',berat_jual_asli=berat_jual_asli+'4.810',stock_jual='1',berat_akhir=berat_akhir-'4.810',berat_akhir_asli=berat_akhir_asli-'4.810',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='LXPER-ZBAH-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0006','2026-03-28','4.810','2026-03-28','17:26:45','PLG0010171','900000','900000','0','900000','0','kasirbip','2026-03-28 17:26:44','FJ-260328-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0006','2026-03-28','17:26:45','MIA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0010','2026-03-28','2026-03-28 17:26:44','PENJUALAN : FJ-260328-0006','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0011','D','2026-03-28','17:26:45','TBC','PENJUALAN','FJ-260328-0006','21191148514','900000','21192048514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-260328-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0007','Nagatech','1',' PLDMM-0001','TOKO','MMPLD','PLDMM-ZAAE-37-0','CINCIN PALADIUM PLDMM-00017 ','','1.970','1','5.00','269000','0','0','17000','1641000','0','0','0','1641000','ASRI','00040922','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZAAE-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PLDMM-ZAAE-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0007','2026-03-28','1.970','2026-03-28','19:25:34','PLG0010172','1641000','1641000','0','1641000','0','Nagatech','2026-03-28 19:25:33','FJ-260328-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0007','2026-03-28','19:25:34','ASRI','1641000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0011','2026-03-28','2026-03-28 19:25:33','PENJUALAN : FJ-260328-0007','.','TBC','1641000','1641000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0012','D','2026-03-28','19:25:34','TBC','PENJUALAN','FJ-260328-0007','21192048514','1641000','21193689514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1641000' WHERE no_faktur_jual='FJ-260328-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0008','Nagatech',' 1',' PLDMM-0002','TOKO','MMPLD','PLDMM-ZACX-11-0','CINCIN PALADIUM PLDMM-00025 ','','3.990','1','17.00','896000','0','0','17000','1997000','0','0','0','1997000','ASRI','00041225','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZACX-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.990',berat_jual_asli=berat_jual_asli+'3.990',stock_jual='1',berat_akhir=berat_akhir-'3.990',berat_akhir_asli=berat_akhir_asli-'3.990',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PLDMM-ZACX-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0008','2026-03-28','3.990','2026-03-28','19:25:34','PLG0010173','1997000','1997000','0','1997000','0','Nagatech','2026-03-28 19:25:33','FJ-260328-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0008','2026-03-28','19:25:34','ASRI','1997000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0012','2026-03-28','2026-03-28 19:25:33','PENJUALAN : FJ-260328-0008','.','TBC','1997000','1997000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0013','D','2026-03-28','19:25:34','TBC','PENJUALAN','FJ-260328-0008','21193689514','1997000','21195686514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3638000' WHERE no_faktur_jual='FJ-260328-0008' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01909','ASRI','1','PLD 10','COWOK RESIZE KE SIZE 20 GRF EVA ABI CROM PUIH DOFF SEMPROT SETENGAH CEWEK GRF ABI EVA CROM PUTIH FONT MONOTYPE CORSIVA','5.960','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01909','2026-03-28','2026-03-28','19:34:49','PLG0010174','Nagatech','2026-03-15','Nagatech','2026-03-28 19:34:49','5.960','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0009','kasirbip','1',' 850K-20-23','TOKO','BIPPER','PBDG-ZCAA-40-0','CINCIN SILVER 925 ','','4.130','1','100.00','422000','0','0','17000','1050000','0','0','0','1050000','MIA','00042276','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.130',berat_jual_asli=berat_jual_asli+'4.130',stock_jual='1',berat_akhir=berat_akhir-'4.130',berat_akhir_asli=berat_akhir_asli-'4.130',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PBDG-ZCAA-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0009','2026-03-28','4.130','2026-03-28','19:36:13','PLG0010175','1050000','1050000','0','1050000','0','kasirbip','2026-03-28 19:36:12','FJ-260328-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0009','2026-03-28','19:36:13','MIA','1050000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0013','2026-03-28','2026-03-28 19:36:12','PENJUALAN : FJ-260328-0009','.','TBC','1050000','1050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0014','D','2026-03-28','19:36:13','TBC','PENJUALAN','FJ-260328-0009','21195686514','1050000','21196736514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-260328-0009' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01910','MIA','1','CC SILVER','PUTIH GLOSY COMBO DOFT SEMPROT RESIZE SZ 19 FONT BERKSHINE SWASH GRF','4.130','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01910','2026-03-28','2026-03-28','19:39:00','PLG0010176','kasirbip','2026-04-23','kasirbip','2026-03-28 19:39:00','4.130','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0009';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0010','kasirbip','1',' 850K-18-23','TOKO','BIPPER','PBDG-ZCAA-42-0','CINCIN SILVER 925 ','','4.060','1','100.00','415000','0','0','17000','1050000','0','0','0','1050000','GIN','00042278','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PBDG-ZCAA-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0010','2026-03-28','4.060','2026-03-28','20:05:55','PLG0010177','1050000','1050000','0','1050000','0','kasirbip','2026-03-28 20:05:54','FJ-260328-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0010','2026-03-28','20:05:55','GIN','1050000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0014','2026-03-28','2026-03-28 20:05:54','PENJUALAN : FJ-260328-0010','.','TBC','1050000','1050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0015','D','2026-03-28','20:05:55','TBC','PENJUALAN','FJ-260328-0010','21196736514','1050000','21197786514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-260328-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260328-0011','kasirbip',' 1',' 800K-13-20','TOKO','BIPPER','PBDG-YLAX-70-0','CINCIN SILVER 925 ','','2.330','1','100.00','143000','0','0','17000','900000','0','0','0','900000','GIN','00040472','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLAX-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='PBDG-YLAX-70-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260328-0011','2026-03-28','2.330','2026-03-28','20:05:55','PLG0010178','900000','900000','0','900000','0','kasirbip','2026-03-28 20:05:54','FJ-260328-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FJ-260328-0011','2026-03-28','20:05:55','GIN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0015','2026-03-28','2026-03-28 20:05:54','PENJUALAN : FJ-260328-0011','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0016','D','2026-03-28','20:05:55','TBC','PENJUALAN','FJ-260328-0011','21197786514','900000','21198686514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1950000' WHERE no_faktur_jual='FJ-260328-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260328-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260328-0011';
UPDATE tt_service_head SET tgl_selesai='2026-03-28',  status ='DONE' WHERE no_service='SV-01874';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01874';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-03-28',  status ='CLOS' WHERE no_service='SV-01874';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01874';
UPDATE tt_service_head SET tgl_selesai='2026-03-28',  status ='DONE' WHERE no_service='SV-01892';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01892';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01911','ASRI','1','SLV','NAIK 2 NOMER DAN CROM ULANG PUTIH GRF JANGAN HILANG','2.610','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01911','2026-03-28','2026-03-28','20:28:25','PLG0010179','Nagatech','2026-03-10','Nagatech','2026-03-28 20:28:25','2.610','0','0','0','0','0','0','0','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01865','SULIS','1','GOLD','WED RING','','','2.000','','50.00','1','2550000','2100000','0','750000','4950000','28 zircon putih glosy','sz 9.5 grf Mr. Ravenzka','berat jgn lebih dari 2gr','280000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0016','2026-03-28','2026-03-28 21:06:42','PESANAN : DP-01865','.','TBC','4184000','4184000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0017','D','2026-03-28','21:06:42','TBC','PESANAN','DP-01865','21198686514','4184000','21202870514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01865','2026-03-28','2026-03-28','21:06:42','PLG0010180','SULIS','2026-05-05','kasirbip','2026-03-28 21:06:42','2.000','0','0','0','4184000','0','750000','5230000','5230000','1046000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01866','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','300000','0','750000','1650000','sz 13 putih glosy 10 zircon','model spt contoh','grf Mrs. Naila','100000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0017','2026-03-28','2026-03-28 21:08:56','PESANAN : DP-01866','.','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0018','D','2026-03-28','21:08:56','TBC','PESANAN','DP-01866','21202870514','1400000','21204270514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01866','2026-03-28','2026-03-28','21:08:56','PLG0010181','SULIS','2026-05-05','kasirbip','2026-03-28 21:08:56','3.000','0','0','0','1400000','0','750000','1750000','1750000','350000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-28 ','21:38:08');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-28';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','TBC','SALDO AWAL','SALDO AWAL','0','21204270514','21204270514');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','BCD','SALDO AWAL','SALDO AWAL','0','1356733500','1356733500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260329-0001','D','2026-03-29','21:38:17','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000');
UPDATE tp_system SET tgl_system='2026-03-29';