INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','A1E-ZGBX-210-0','1','0.550','0.550','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZGBX-210-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZGBX-210-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-18 08:01:52' WHERE kode_barang='A1E-ZGBX-210-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZGBX-210-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:01:52','TOKO','PM-A','A1E','A1E-ZGBX-210-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZGBX-210-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZGBX-210-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','A1D-ZHXA-5-0','1','1.050','1.050','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHXA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHXA-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-18 08:01:52' WHERE kode_barang='A1D-ZHXA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHXA-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:01:52','TOKO','PM-A','A1D','A1D-ZHXA-5-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZHXA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHXA-5-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','A1E-ZHXA-30-0','1','0.580','0.580','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHXA-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHXA-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-18 08:01:52' WHERE kode_barang='A1E-ZHXA-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHXA-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:01:52','TOKO','PM-A','A1E','A1E-ZHXA-30-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHXA-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHXA-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','A1D-ZHXH-396-0','1','1.150','1.150','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHXH-396-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHXH-396-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-18 08:01:52' WHERE kode_barang='A1D-ZHXH-396-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHXH-396-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:01:52','TOKO','PM-A','A1D','A1D-ZHXH-396-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZHXH-396-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHXH-396-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','A1E-ZHAD-135-0','1','0.440','0.440','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHAD-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHAD-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-18 08:01:52' WHERE kode_barang='A1E-ZHAD-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHAD-135-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:01:52','TOKO','PM-A','A1E','A1E-ZHAD-135-0','1','0.440','0.440','1','0.440','0.440','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHAD-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHAD-135-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260818-0001','2026-08-18','08:01','3.770','admpindah','2026-08-18 08:01:52');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','B1E-ZHAE-39-0','1','0.570','0.570','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHAE-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHAE-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-08-18 08:02:50' WHERE kode_barang='B1E-ZHAE-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHAE-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:02:50','TOKO','PM-B','B1E','B1E-ZHAE-39-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZHAE-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHAE-39-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260818-0001','2026-08-18','08:02','0.570','admpindah','2026-08-18 08:02:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','E1D-ZHXC-59-0','1','0.980','0.980','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZHXC-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZHXC-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-08-18 08:03:33' WHERE kode_barang='E1D-ZHXC-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZHXC-59-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:03:33','TOKO','PM-E','E1D','E1D-ZHXC-59-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZHXC-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZHXC-59-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260818-0001','2026-08-18','08:03','0.980','admpindah','2026-08-18 08:03:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','F1E-ZGBI-70-0','1','2.140','2.140','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZGBI-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZGBI-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-08-18 08:03:55' WHERE kode_barang='F1E-ZGBI-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZGBI-70-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:03:55','TOKO','PM-F','F1E','F1E-ZGBI-70-0','1','2.140','2.140','1','2.140','2.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZGBI-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZGBI-70-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','F1E-ZHAX-312-0','1','1.300','1.300','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZHAX-312-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZHAX-312-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-08-18 08:03:55' WHERE kode_barang='F1E-ZHAX-312-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZHAX-312-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:03:55','TOKO','PM-F','F1E','F1E-ZHAX-312-0','1','1.300','1.300','1','1.300','1.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZHAX-312-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZHAX-312-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260818-0001','2026-08-18','08:03','3.440','admpindah','2026-08-18 08:03:54');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','H1E-ZGCA-78-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCA-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCA-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-08-18 08:04:14' WHERE kode_barang='H1E-ZGCA-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCA-78-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:04:14','TOKO','PM-H','H1E','H1E-ZGCA-78-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCA-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCA-78-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260818-0001','1','H2J-ZHXH-141-0','1','4.030','4.030','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-08-18 08:04:14' WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-18 08:04:14','TOKO','PM-H','H2J','H2J-ZHXH-141-0','1','4.030','4.030','1','4.030','4.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZHXH-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZHXH-141-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260818-0001','2026-08-18','08:04','6.080','admpindah','2026-08-18 08:04:14');
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,status_otorisasi,harga_skrg) VALUES ('F326180837441','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZGCX-56-0','KL X NORI ANAK UB 34 8K ','','1.020','1','100.00','1104000','0','0','15000','1105000','0','0','0','1105000','SIN','00415955','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGCX-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='H1E-ZGCX-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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) VALUES ('F326180837441','2026-08-18','1.020','2026-08-18','08:37:44','PLG0030856','1105000','1105000','0','1105000','1105000','input','2026-08-18 08:37:44','F32618083744');
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-08-18','F326180837441','2026-08-18','08:37:44','SIN','1105000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0002','D','2026-08-18','08:37:44','input','PENJUALAN','F326180837441','6901913000','1105000','6903018000');
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,status_otorisasi,harga_skrg) VALUES ('F326180921511','input','1',' MDB1 X SB ','TOKO','PM-B','B1D-ZDBG-175-0','GW X MODEL MATA SB PE 8K ','','1.060','1','100.00','1126000','0','0','15000','1125000','0','5000','0','1130000','LIS','00401418','B1D','0','0','-','1','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZDBG-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='B1D-ZDBG-175-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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) VALUES ('F326180921511','2026-08-18','1.060','2026-08-18','09:21:51','PLG0030857','1125000','1125000','5000','1130000','1130000','input','2026-08-18 09:21:51','F32618092151');
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-08-18','F326180921511','2026-08-18','09:21:51','LIS','1130000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0003','D','2026-08-18','09:21:51','input','PENJUALAN','F326180921511','6903018000','1130000','6904148000');
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,status_otorisasi,harga_skrg) VALUES ('F326180924401','input','1',' MEA1E X LG','TOKO','PM-A','A1E-ZGAG-16-0','AT X DAISY MATA LG 8K ','','0.550','1','100.00','595000','0','0','15000','595000','0','0','0','595000','FIT','00413852','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGAG-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='A1E-ZGAG-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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) VALUES ('F326180924401','2026-08-18','0.550','2026-08-18','09:24:40','PLG0030858','595000','595000','0','595000','595000','input','2026-08-18 09:24:40','F32618092440');
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-08-18','F326180924401','2026-08-18','09:24:40','FIT','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0004','D','2026-08-18','09:24:40','input','PENJUALAN','F326180924401','6904148000','595000','6904743000');
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,status_otorisasi,harga_skrg) VALUES ('F326181015311','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZGXA-30-0','CC X METRO MATA LG 22 8K ','','1.170','1','100.00','1243000','0','0','15000','1243000','0','0','0','1243000','FIT','00411554','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXA-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E2D-ZGXA-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326181015311','2026-08-18','1.170','2026-08-18','10:15:32','PLG0030859','1243000','1243000','0','1243000','1243000','input','2026-08-18 10:15:31','F32618101531');
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-08-18','F326181015311','2026-08-18','10:15:32','FIT','1243000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0005','D','2026-08-18','10:15:32','input','PENJUALAN','F326181015311','6904743000','1243000','6905986000');
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,status_otorisasi,harga_skrg) VALUES ('F326181140161','input','1',' MDE2 X UB ','TOKO','PM-E','E2D-YFBA-116-0','CC X MODEL MATA UB 12 8K ','','0.810','1','100.00','860000','0','0','15000','860000','0','0','0','860000','FIT','00358390','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFBA-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E2D-YFBA-116-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326181140161','2026-08-18','0.810','2026-08-18','11:40:17','PLG0030860','860000','860000','0','860000','860000','input','2026-08-18 11:40:16','F32618114016');
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-08-18','F326181140161','2026-08-18','11:40:17','FIT','860000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0006','D','2026-08-18','11:40:17','input','PENJUALAN','F326181140161','6905986000','860000','6906846000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019949','X-00019949','GL X PIPA MATA PM 50 8K','GR','---','F2E','BELI','BELI001','2292000','2026-08-18','2.970','1','kasir','2026-08-18 11:52:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00019949','X-00019949');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260818-0001','F325141119421','AAT','1','BELI','BELI001','F2E', 'X-00019949', 'GL X PIPA MATA PM 50 8K','2.970','2.970','100.00','2465000','2292000','771717','1092000','1','2292000','2292000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.970',berat_beli_asli=berat_beli_asli+'2.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.970',berat_akhir_asli=berat_akhir_asli+'2.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0001','2026-08-18','2026-08-18','11:52:51','AAT','---','2.970','2292000','2292000','2292000','2292000','2292000','kasir','2026-08-18 11:52:51','FB-260818-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0001','BAGAS','GESING PLOSO','','','','kasir','2026-08-18 11:52:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260818-0007','K','2026-08-18','11:52:51','kasir','PEMBELIAN UMUM','FB-260818-0001','6906846000','2292000','6904554000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019950','X-00019950','CC X WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1965000','2026-08-18','1.970','1','kasir','2026-08-18 11:53:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019950','X-00019950');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260818-0002','F326291210571','SIN','1','BELI','BELI001','E2D', 'X-00019950', 'CC X WEDDING MATA CM 16 8K','1.970','1.970','100.00','2148000','1965000','997462','1072000','1','1965000','1965000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0002','2026-08-18','2026-08-18','11:53:20','SIN','---','1.970','1965000','1965000','1965000','1965000','1965000','kasir','2026-08-18 11:53:21','FB-260818-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0002','SUSANTI','GELANG KULON','','','','kasir','2026-08-18 11:53:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260818-0008','K','2026-08-18','11:53:20','kasir','PEMBELIAN UMUM','FB-260818-0002','6904554000','1965000','6902589000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019951','X-00019951','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1035000','2026-08-18','1.050','1','kasir','2026-08-18 11:53:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019951','X-00019951');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260818-0003','F326200329381','FIT','1','BELI','BELI001','E2D', 'X-00019951', 'CC WEDDING MATA CM 20 8K','1.050','1.050','100.00','1218000','1035000','985714','1072000','1','1035000','1035000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0003','2026-08-18','2026-08-18','11:53:39','FIT','---','1.050','1035000','1035000','1035000','1035000','1035000','kasir','2026-08-18 11:53:40','FB-260818-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0003','SITI AMINAH','MIRI KISMANTORO','','','082114309613','kasir','2026-08-18 11:53:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260818-0009','K','2026-08-18','11:53:39','kasir','PEMBELIAN UMUM','FB-260818-0003','6902589000','1035000','6901554000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019952','X-00019952','CC COR POLOS 13 HW 8K','GR','---','E1D','BELI','BELI001','775000','2026-08-18','0.850','1','kasir','2026-08-18 11:54:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019952','X-00019952');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260818-0004','F326091004401','SIN','1','BELI','BELI001','E1D', 'X-00019952', 'CC COR POLOS 13 HW 8K','0.850','0.850','100.00','933000','775000','911765','1072000','1','775000','775000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0004','2026-08-18','2026-08-18','11:54:25','SIN','---','0.850','775000','775000','775000','775000','775000','kasir','2026-08-18 11:54:25','FB-260818-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0004','BU MESINAH','GAMBIRANOM','','','','kasir','2026-08-18 11:54:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260818-0010','K','2026-08-18','11:54:25','kasir','PEMBELIAN UMUM','FB-260818-0004','6901554000','775000','6900779000');
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,status_otorisasi,harga_skrg) VALUES ('F326181220281','kasir','1',' MEA1E PM ','TOKO','PM-A','A1E-ZFXE-164-0','AT ITALY VAR SLEP PM 8K ','','0.550','1','100.00','595000','0','0','15000','595000','0','0','0','595000','AAT','00407416','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXE-164-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='A1E-ZFXE-164-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' 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) VALUES ('F326181220281','2026-08-18','0.550','2026-08-18','12:20:29','PLG0030861','595000','595000','0','595000','595000','kasir','2026-08-18 12:20:28','F32618122028');
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-08-18','F326181220281','2026-08-18','12:20:29','AAT','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0011','D','2026-08-18','12:20:29','kasir','PENJUALAN','F326181220281','6900779000','595000','6901374000');
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,status_otorisasi,harga_skrg) VALUES ('F326180111331','kasir','1',' MEF1 LG 52','TOKO','PM-F','F1E-ZGBC-277-0','GL OVAL TINJU ARESO LG 52 8K ','','1.900','1','100.00','2056000','0','0','15000','2056000','0','0','0','2056000','SIN','00415350','F1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBC-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='F1E-ZGBC-277-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326180111331','2026-08-18','1.900','2026-08-18','13:11:34','PLG0030862','2056000','2056000','0','2056000','2056000','kasir','2026-08-18 13:11:33','F32618011133');
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-08-18','F326180111331','2026-08-18','13:11:34','SIN','2056000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0012','D','2026-08-18','13:11:34','kasir','PENJUALAN','F326180111331','6901374000','2056000','6903430000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019953','X-00019953','CC X MODEL BONEKA ANAK CAT MATA LG 8K','GR','---','E2F','BELI','BELI001','460000','2026-08-18','0.450','1','kasir','2026-08-18 13:31:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00019953','X-00019953');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260818-0005','F326130105371','FIT','1','BELI','BELI001','E2F', 'X-00019953', 'CC X MODEL BONEKA ANAK CAT MATA LG 8K','0.450','0.450','100.00','520000','460000','1022222','1102000','1','460000','460000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0005','2026-08-18','2026-08-18','13:31:25','FIT','---','0.450','460000','460000','460000','460000','460000','kasir','2026-08-18 13:31:25','FB-260818-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0005','ZAHRA','MANGGIS SUKOREJO','','','082324024399','kasir','2026-08-18 13:31:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260818-0013','K','2026-08-18','13:31:25','kasir','PEMBELIAN UMUM','FB-260818-0005','6903430000','460000','6902970000');
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,status_otorisasi,harga_skrg) VALUES ('F326180133001','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZHAX-349-0','GL CAPELLA SLEP HW 8K ','','2.170','1','100.00','2348000','0','0','15000','2348000','0','0','0','2348000','LIS','00418494','F3E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAX-349-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='F3E-ZHAX-349-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326180133001','2026-08-18','2.170','2026-08-18','13:33:01','PLG0030863','2348000','2348000','0','2348000','2348000','kasir','2026-08-18 13:33:00','F32618013300');
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-08-18','F326180133001','2026-08-18','13:33:01','LIS','2348000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0014','D','2026-08-18','13:33:01','kasir','PENJUALAN','F326180133001','6902970000','2348000','6905318000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260818-0001','1','F3E-ZBBE-39-0','1','1.170','1.170','TOKO','PM-F','TOKO','MBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MBK-F' WHERE kode_barang='F3E-ZBBE-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-08-18','TOKO','MBK-F','F3E','F3E-ZBBE-39-0','100.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-18' AND kode_barang='F3E-ZBBE-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260818-0001','2026-08-18','2026-08-18','14:52','1.17','input','2026-08-18 14:52:45');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180111331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180111331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180111331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180133001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180133001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180133001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180837441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180837441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180837441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180921511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180921511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180921511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180924401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180924401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180924401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181015311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181015311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181015311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181140161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181140161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181140161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181220281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181220281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181220281';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-18';
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-08-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260819-0001','D','2026-08-19','15:00:54','SYSTEM','SALDO AWAL','SALDO AWAL','0','6905318000','6905318000');
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-260819-0001','D','2026-08-19','15:00:54','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
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-260819-0001','D','2026-08-19','15:00:54','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
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-260819-0001','D','2026-08-19','15:00:54','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
UPDATE tp_system SET tgl_system='2026-08-19';