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 ('F325210820381','input','1',' MHA1H DG ','TOKO','PM-A','A1H-YIAB-278-0','AT BABY TINDIK SLEP DG 8K ','','0.270','1','100.00','263000','0','0','15000','263000','0','0','0','263000','AAT','00369055','A1H','0','0','-','0','973000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YIAB-278-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='A1H-YIAB-278-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 ('F325210820381','2025-09-21','0.270','2025-09-21','08:20:39','PLG0024946','263000','263000','0','263000','263000','input','2025-09-21 08:20:38','F32521082038');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210820381','2025-09-21','08:20:39','AAT','263000','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-250921-0002','D','2025-09-21','08:20:39','input','PENJUALAN','F325210820381','50373000','263000','50636000');
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 ('F325210904301','input','1',' MEF1 X 15K','TOKO','PM-F','F1E-YGBF-146-0','GL X BANGKOK HOLLOW LASER ANAK KH 50 8K ','','3.130','1','100.00','2886000','0','0','15000','2885000','0','15000','0','2900000','FIT','00362802','F1E','0','0','-','1','922000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YGBF-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='F1E-YGBF-146-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 ('F325210904301','2025-09-21','3.130','2025-09-21','09:04:30','PLG0024947','2885000','2885000','15000','2900000','2900000','input','2025-09-21 09:04:30','F32521090430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210904301','2025-09-21','09:04:30','FIT','2900000','15000');
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-250921-0003','D','2025-09-21','09:04:30','input','PENJUALAN','F325210904301','50636000','2900000','53536000');
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 ('F325210905091','input','1',' MEF3E X PM','TOKO','PM-F','F3E-YIAE-195-0','GL X KREPYAK SLEP PM 8K ','','3.080','1','100.00','2840000','0','0','15000','2840000','0','0','0','2840000','FIT','00369646','F3E','0','0','-','0','922000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-195-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='F3E-YIAE-195-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 ('F325210905091','2025-09-21','3.080','2025-09-21','09:05:09','PLG0024948','2840000','2840000','0','2840000','2840000','input','2025-09-21 09:05:09','F32521090509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210905091','2025-09-21','09:05:09','FIT','2840000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250921-0004','D','2025-09-21','09:05:09','input','PENJUALAN','F325210905091','53536000','2840000','56376000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2840000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325210905091' 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,status_otorisasi,harga_skrg) VALUES ('F325210905092','input',' 1',' TDE1 LG 18','TOKO','PT-E','E1TD-YGBD-105-T','CC MODEL DAUN SLEP LG 18 17K ','','1.000','1','100.00','1613000','0','0','15000','1613000','0','0','0','1613000','FIT','T0071533','E1TD','0','0','-','0','1613000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YGBD-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='E1TD-YGBD-105-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325210905092','2025-09-21','1.000','2025-09-21','09:05:09','PLG0024949','1613000','1613000','0','1613000','1613000','input','2025-09-21 09:05:09','F32521090509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210905092','2025-09-21','09:05:09','FIT','1613000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250921-0005','D','2025-09-21','09:05:09','input','PENJUALAN','F325210905092','56376000','1613000','57989000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325210905092' LIMIT 1;
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-20250921-0001','1','A1E-YFXF-61-0','1','0.550','0.550','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YFXF-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YFXF-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-09-21 09:40:22' WHERE kode_barang='A1E-YFXF-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YFXF-61-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 ('2025-09-21 09:40:22','TOKO','PM-A','A1E','A1E-YFXF-61-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-YFXF-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YFXF-61-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-20250921-0001','1','A1D-YGXE-329-0','1','1.030','1.030','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YGXE-329-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YGXE-329-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-09-21 09:40:22' WHERE kode_barang='A1D-YGXE-329-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YGXE-329-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 ('2025-09-21 09:40:22','TOKO','PM-A','A1D','A1D-YGXE-329-0','1','1.030','1.030','1','1.030','1.030','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-YGXE-329-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YGXE-329-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-20250921-0001','1','A1E-YGAH-18-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YGAH-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YGAH-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-09-21 09:40:22' WHERE kode_barang='A1E-YGAH-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YGAH-18-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 ('2025-09-21 09:40:22','TOKO','PM-A','A1E','A1E-YGAH-18-0','1','0.530','0.530','1','0.530','0.530','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-YGAH-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YGAH-18-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-20250921-0001','1','A1D-YGBF-5-0','1','1.080','1.080','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YGBF-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YGBF-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-09-21 09:40:22' WHERE kode_barang='A1D-YGBF-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YGBF-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 ('2025-09-21 09:40:22','TOKO','PM-A','A1D','A1D-YGBF-5-0','1','1.080','1.080','1','1.080','1.080','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-YGBF-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YGBF-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-20250921-0001','1','A1E-YIAB-32-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YIAB-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YIAB-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-09-21 09:40:22' WHERE kode_barang='A1E-YIAB-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YIAB-32-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 ('2025-09-21 09:40:22','TOKO','PM-A','A1E','A1E-YIAB-32-0','1','0.530','0.530','1','0.530','0.530','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-YIAB-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YIAB-32-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250921-0001','2025-09-21','09:40','3.720','irgosa','2025-09-21 09:40:21');
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-20250921-0001','1','B1F-YIAE-135-0','1','0.450','0.450','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-YIAE-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-YIAE-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2025-09-21 09:40:38' WHERE kode_barang='B1F-YIAE-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-YIAE-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 ('2025-09-21 09:40:38','TOKO','PM-B','B1F','B1F-YIAE-135-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1F-YIAE-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-YIAE-135-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250921-0001','2025-09-21','09:40','0.450','irgosa','2025-09-21 09:40:37');
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-20250921-0001','1','D1E-XLXE-5-T','1','0.530','0.530','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-XLXE-5-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-XLXE-5-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-09-21 09:40:49' WHERE kode_barang='D1E-XLXE-5-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-XLXE-5-T' 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 ('2025-09-21 09:40:49','TOKO','PM-D','D1E','D1E-XLXE-5-T','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-XLXE-5-T';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-XLXE-5-T';
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-20250921-0001','1','D2F-YCAH-419-0','1','0.470','0.470','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2F-YCAH-419-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2F-YCAH-419-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-09-21 09:40:49' WHERE kode_barang='D2F-YCAH-419-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2F-YCAH-419-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 ('2025-09-21 09:40:49','TOKO','PM-D','D2F','D2F-YCAH-419-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2F-YCAH-419-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2F-YCAH-419-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-20250921-0001','1','D2E-YDCX-316-0','1','0.480','0.480','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YDCX-316-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YDCX-316-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-09-21 09:40:49' WHERE kode_barang='D2E-YDCX-316-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YDCX-316-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 ('2025-09-21 09:40:49','TOKO','PM-D','D2E','D2E-YDCX-316-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' 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='D2E-YDCX-316-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YDCX-316-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-20250921-0001','1','D2D-YHAI-165-0','1','0.620','0.620','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-09-21 09:40:49' WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-YHAI-165-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 ('2025-09-21 09:40:49','TOKO','PM-D','D2D','D2D-YHAI-165-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-YHAI-165-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YHAI-165-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250921-0001','2025-09-21','09:40','2.100','irgosa','2025-09-21 09:40:48');
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-20250921-0001','1','F3E-YFAD-321-0','1','2.900','2.900','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YFAD-321-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YFAD-321-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YFAD-321-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YFAD-321-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YFAD-321-0','1','2.900','2.900','1','2.900','2.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YFAD-321-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YFAD-321-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-20250921-0001','1','F3E-YHAC-122-0','1','2.060','2.060','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YHAC-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YHAC-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YHAC-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YHAC-122-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YHAC-122-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YHAC-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHAC-122-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-20250921-0001','1','F1E-YHAI-69-0','1','3.030','3.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YHAI-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YHAI-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F1E-YHAI-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YHAI-69-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 ('2025-09-21 09:41:03','TOKO','PM-F','F1E','F1E-YHAI-69-0','1','3.030','3.030','1','3.030','3.030','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-YHAI-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YHAI-69-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-20250921-0001','1','F3E-YHAI-198-0','1','2.050','2.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YHAI-198-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YHAI-198-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YHAI-198-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YHAI-198-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YHAI-198-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YHAI-198-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHAI-198-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-20250921-0001','1','F3E-YHBB-73-0','1','1.060','1.060','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YHBB-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YHBB-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YHBB-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YHBB-73-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YHBB-73-0','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YHBB-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YHBB-73-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-20250921-0001','1','F3E-YIAB-145-0','1','1.870','1.870','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIAB-145-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIAB-145-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YIAB-145-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIAB-145-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YIAB-145-0','1','1.870','1.870','1','1.870','1.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YIAB-145-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIAB-145-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-20250921-0001','1','F3E-YIAE-217-0','1','1.350','1.350','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIAE-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIAE-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-09-21 09:41:03' WHERE kode_barang='F3E-YIAE-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIAE-217-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 ('2025-09-21 09:41:03','TOKO','PM-F','F3E','F3E-YIAE-217-0','1','1.350','1.350','1','1.350','1.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-YIAE-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIAE-217-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250921-0001','2025-09-21','09:40','14.320','irgosa','2025-09-21 09:41:03');
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-20250921-0001','1','H2I-YHBB-88-0','1','9.880','9.880','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YHBB-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YHBB-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-09-21 09:41:17' WHERE kode_barang='H2I-YHBB-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YHBB-88-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 ('2025-09-21 09:41:17','TOKO','PM-H','H2I','H2I-YHBB-88-0','1','9.880','9.880','1','9.880','9.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YHBB-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YHBB-88-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-20250921-0001','1','H1F-YIXI-74-0','1','4.070','4.070','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YIXI-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YIXI-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-09-21 09:41:17' WHERE kode_barang='H1F-YIXI-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YIXI-74-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 ('2025-09-21 09:41:17','TOKO','PM-H','H1F','H1F-YIXI-74-0','1','4.070','4.070','1','4.070','4.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YIXI-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YIXI-74-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-20250921-0001','1','H1F-YIXI-79-0','1','3.070','3.070','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YIXI-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YIXI-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-09-21 09:41:17' WHERE kode_barang='H1F-YIXI-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YIXI-79-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 ('2025-09-21 09:41:17','TOKO','PM-H','H1F','H1F-YIXI-79-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YIXI-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YIXI-79-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-20250921-0001','1','H2I-YIAB-193-0','1','1.500','1.500','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YIAB-193-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YIAB-193-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-09-21 09:41:17' WHERE kode_barang='H2I-YIAB-193-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YIAB-193-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 ('2025-09-21 09:41:17','TOKO','PM-H','H2I','H2I-YIAB-193-0','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YIAB-193-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YIAB-193-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-20250921-0001','1','H2I-YIAB-194-0','1','1.500','1.500','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YIAB-194-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YIAB-194-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-09-21 09:41:17' WHERE kode_barang='H2I-YIAB-194-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YIAB-194-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 ('2025-09-21 09:41:17','TOKO','PM-H','H2I','H2I-YIAB-194-0','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YIAB-194-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YIAB-194-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250921-0001','2025-09-21','09:41','20.020','irgosa','2025-09-21 09:41:17');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250921-0001','1','D1D-YCXE-70-0','1','0.860','TOKO','MBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1D-YCXE-70-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1D-YCXE-70-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='MBK-D';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1D-YCXE-70-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.860' WHERE kode_barang='D1D-YCXE-70-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-250921-0001','2025-09-21','2025-09-21','09:46','0.860','irgosa','250921');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250921-0002','1','D1D-XJBD-338-0','1','1.020','TOKO','SBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1D-XJBD-338-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1D-XJBD-338-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-D';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1D-XJBD-338-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.020' WHERE kode_barang='D1D-XJBD-338-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250921-0002','2','D2D-YGXE-213-0','1','0.870','TOKO','SBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YGXE-213-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2D-YGXE-213-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-D';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D2D-YGXE-213-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.870',berat_out_asli='0.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.870',berat_akhir_asli =berat_akhir_asli-'0.870' WHERE kode_barang='D2D-YGXE-213-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-250921-0002','2025-09-21','2025-09-21','09:46','0.870','irgosa','250921');
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 ('F325210953091','input','1',' MDD2 X YT ','TOKO','PM-D','D2D-YHAI-165-0','LT X MODEL MATA YT 8K ','','0.620','1','100.00','564000','0','0','15000','563000','0','0','0','563000','AAT','00366196','D2D','0','0','-','1','910000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YHAI-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='D2D-YHAI-165-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F325210953091','2025-09-21','0.620','2025-09-21','09:53:09','PLG0024950','563000','563000','0','563000','563000','input','2025-09-21 09:53:09','F32521095309');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210953091','2025-09-21','09:53:09','AAT','563000','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-250921-0006','D','2025-09-21','09:53:09','input','PENJUALAN','F325210953091','57989000','563000','58552000');
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 ('F325211011181','input','1',' TDE2 10K C','TOKO','PT-E','E2TD-YGXD-17-T','CC WEDDING MATA CM 20 17K ','','2.230','1','100.00','3597000','0','0','15000','3598000','0','10000','0','3608000','SIN','T0070767','E2TD','0','0','-','0','1613000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YGXD-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='E2TD-YGXD-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325211011181','2025-09-21','2.230','2025-09-21','10:11:19','PLG0024951','3598000','3598000','10000','3608000','3608000','input','2025-09-21 10:11:18','F32521101118');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325211011181','2025-09-21','10:11:19','SIN','3608000','10000');
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-250921-0007','D','2025-09-21','10:11:19','input','PENJUALAN','F325211011181','58552000','3608000','62160000');
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 ('F325211100401','input','1',' MCE0 X NW ','TOKO','PM-E','E0C-YFAF-46-0','CC X SETENGAH RANTAI NW 13 8K ','','2.920','1','100.00','2593000','0','0','15000','2565000','0','0','0','2565000','SIN','00357688','E0C','0','0','-','1','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0C-YFAF-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='E0C-YFAF-46-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 ('F325211100401','2025-09-21','2.920','2025-09-21','11:00:41','PLG0024952','2565000','2565000','0','2565000','2565000','input','2025-09-21 11:00:40','F32521110040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325211100401','2025-09-21','11:00:41','SIN','2565000','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-250921-0008','D','2025-09-21','11:00:41','input','PENJUALAN','F325211100401','62160000','2565000','64725000');
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-00017031','X-00017031','CC COR T 8K','GR','---','E1E','BELI','BELI001','1375000','2025-09-21','2.100','1','kasir','2025-09-21 11:52:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017031','X-00017031');
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-250921-0001','F323110141301','SIN','1','BELI','BELI001','E1E', 'X-00017031', 'CC COR T 8K','2.100','2.100','100.00','948000','1375000','654762','927000','1','1375000','1375000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-250921-0001','2025-09-21','2025-09-21','11:52:57','SIN','---','2.100','1375000','1375000','1375000','1375000','1375000','kasir','2025-09-21 11:52:58','FB-250921-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0001','TIAS','BLIMBING','','','','kasir','2025-09-21 11:52:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0009','K','2025-09-21','11:52:57','kasir','PEMBELIAN UMUM','FB-250921-0001','64725000','1375000','63350000');
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-00017032','X-00017032','LT X MODEL HURUF MATA LG A 8K','GR','---','D2F','BELI','BELI001','458000','2025-09-21','0.560','1','kasir','2025-09-21 11:53:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00017032','X-00017032');
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-250921-0002','F325300224231','AAT','1','BELI','BELI001','D2F', 'X-00017032', 'LT X MODEL HURUF MATA LG A 8K','0.560','0.560','100.00','493000','458000','817857','944000','1','458000','458000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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-250921-0002','2025-09-21','2025-09-21','11:53:32','AAT','---','0.560','458000','458000','458000','458000','458000','kasir','2025-09-21 11:53:33','FB-250921-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0002','AYUK','GEDAWUNG KISMANTORO','','','','kasir','2025-09-21 11:53:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0010','K','2025-09-21','11:53:32','kasir','PEMBELIAN UMUM','FB-250921-0002','63350000','458000','62892000');
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-00017033','X-00017033','GW X MRICAN POLOS DG 8K','GR','---','B0C','BELI','BELI001','402000','2025-09-21','0.530','1','kasir','2025-09-21 11:54:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-B0C';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B0C','X-00017033','X-00017033');
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-250921-0003','F325070955271','FIT','1','BELI','BELI001','B0C', 'X-00017033', 'GW X MRICAN POLOS DG 8K','0.530','0.530','100.00','433000','402000','758491','888000','1','402000','402000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B0C' 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-250921-0003','2025-09-21','2025-09-21','11:54:46','FIT','---','0.530','402000','402000','402000','402000','402000','kasir','2025-09-21 11:54:47','FB-250921-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0003','SISRI','BITING BADEGAN','','','','kasir','2025-09-21 11:54:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0011','K','2025-09-21','11:54:46','kasir','PEMBELIAN UMUM','FB-250921-0003','62892000','402000','62490000');
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-00017034','X-00017034','GL X OVAL MATA LT 56 8K','GR','---','F2E','BELI','BELI001','1260000','2025-09-21','2.000','1','kasir','2025-09-21 11:55:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017034','X-00017034');
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-250921-0004','F324101039381','FIT','1','BELI','BELI001','F2E', 'X-00017034', 'GL X OVAL MATA LT 56 8K','2.000','2.000','100.00','1340000','1260000','630000','927000','1','1260000','1260000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' 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-250921-0004','2025-09-21','2025-09-21','11:55:20','FIT','---','2.000','1260000','1260000','1260000','1260000','1260000','kasir','2025-09-21 11:55:21','FB-250921-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0004','YUNIAR','BRANGKAL BITING','','','','kasir','2025-09-21 11:55:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0012','K','2025-09-21','11:55:20','kasir','PEMBELIAN UMUM','FB-250921-0004','62490000','1260000','61230000');
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 ('F325211208281','kasir','1',' TDE1 UB 16','TOKO','PT-E','E1TD-YHBG-16-T','CC MODEL DAUN SLEP UB 16 17K ','','0.900','1','100.00','1452000','0','0','15000','1452000','0','0','0','1452000','AAT','T0072608','E1TD','0','0','-','0','1613000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBG-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='E1TD-YHBG-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F325211208281','2025-09-21','0.900','2025-09-21','12:08:28','PLG0024953','1452000','1452000','0','1452000','1452000','kasir','2025-09-21 12:08:28','F32521120828');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325211208281','2025-09-21','12:08:28','AAT','1452000','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-250921-0013','D','2025-09-21','12:08:28','kasir','PENJUALAN','F325211208281','61230000','1452000','62682000');
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-00017035','X-00017035','AS EXTENSION UB 8K','GR','---','S1G','BELI','BELI001','230000','2025-09-21','0.370','1','kasir','2025-09-21 13:38:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-S1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-S1G','X-00017035','X-00017035');
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-250921-0005','F324130216242','FIT','1','BELI','BELI001','S1G', 'X-00017035', 'AS EXTENSION UB 8K','0.370','0.370','100.00','246000','230000','621622','956000','1','230000','230000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.370',berat_beli_asli=berat_beli_asli+'0.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.370',berat_akhir_asli=berat_akhir_asli+'0.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='S1G' 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-250921-0005','2025-09-21','2025-09-21','13:38:33','FIT','---','0.370','230000','230000','230000','230000','230000','kasir','2025-09-21 13:38:33','FB-250921-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0005','BANGUN','POJOK GONDANG','','','','kasir','2025-09-21 13:38:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0014','K','2025-09-21','13:38:33','kasir','PEMBELIAN UMUM','FB-250921-0005','62682000','230000','62452000');
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-00017036','X-00017036','GL OVAL MODEL C YT D60 8K','GR','---','F1E','BELI','BELI001','2040000','2025-09-21','3.570','1','kasir','2025-09-21 13:38:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017036','X-00017036');
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-250921-0006','F324040153081','FIT','2','BELI','BELI001','F1E', 'X-00017036', 'GL OVAL MODEL C YT D60 8K','3.570','3.570','100.00','1783000','2040000','571429','927000','1','2040000','2040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.570',berat_beli_asli=berat_beli_asli+'3.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.570',berat_akhir_asli=berat_akhir_asli+'3.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-250921-0006','2025-09-21','2025-09-21','13:38:33','FIT','---','3.570','2040000','2040000','2040000','2040000','2040000','kasir','2025-09-21 13:38:33','FB-250921-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0006','BANGUN','POJOK GONDANG','','','','kasir','2025-09-21 13:38:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0015','K','2025-09-21','13:38:33','kasir','PEMBELIAN UMUM','FB-250921-0006','62452000','2040000','60412000');
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-00017037','X-00017037','GL X ANAK PIPA MODEL MATA LG D38','GR','---','F2E','BELI','BELI001','1150000','2025-09-21','2.070','1','kasir','2025-09-21 13:40:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017037','X-00017037');
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-250921-0007','F322200954151','FIT','1','BELI','BELI001','F2E', 'X-00017037', 'GL X ANAK PIPA MODEL MATA LG D38','2.070','2.070','100.00','882000','1150000','555556','927000','1','1150000','1150000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' 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-250921-0007','2025-09-21','2025-09-21','13:40:39','FIT','---','2.070','1150000','1150000','1150000','1150000','1150000','kasir','2025-09-21 13:40:39','FB-250921-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0007','FATIMAH','BLIMBING','','','','kasir','2025-09-21 13:40:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0016','K','2025-09-21','13:40:39','kasir','PEMBELIAN UMUM','FB-250921-0007','60412000','1150000','59262000');
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-00017038','X-00017038','KL X SANTA KH 44CM','GR','---','H2I','BELI','BELI001','1165000','2025-09-21','1.980','1','kasir','2025-09-21 13:40:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017038','X-00017038');
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-250921-0008','F322080240591','FIT','2','BELI','BELI001','H2I', 'X-00017038', 'KL X SANTA KH 44CM','2.000','1.980','100.00','918000','1165000','588384','995000','1','1165000','1165000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-250921-0008','2025-09-21','2025-09-21','13:40:39','FIT','---','1.980','1165000','1165000','1165000','1165000','1165000','kasir','2025-09-21 13:40:39','FB-250921-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0008','LIA','BLIMBING','','','','kasir','2025-09-21 13:40:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0017','K','2025-09-21','13:40:39','kasir','PEMBELIAN UMUM','FB-250921-0008','59262000','1165000','58097000');
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-00017039','X-00017039','CC COR T 8K','GR','---','E1F','BELI','BELI001','570000','2025-09-21','1.000','1','kasir','2025-09-21 13:42:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00017039','X-00017039');
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-250921-0009','F323070109061','FIT','1','BELI','BELI001','E1F', 'X-00017039', 'CC COR T 8K','1.000','1.000','100.00','455000','570000','570000','944000','1','570000','570000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-250921-0009','2025-09-21','2025-09-21','13:42:06','FIT','---','1.000','570000','570000','570000','570000','570000','kasir','2025-09-21 13:42:06','FB-250921-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0009','LIA','BLIMBING PURWANTORO','','','','kasir','2025-09-21 13:42:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0018','K','2025-09-21','13:42:06','kasir','PEMBELIAN UMUM','FB-250921-0009','58097000','570000','57527000');
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 ('F325210225321','input','1',' MEF2 XX UB','TOKO','PM-F','F2E-WJXG-203-0','GL X PIPA MATA UB 58 ','','7.950','1','100.00','7330000','0','0','15000','7092000','0','0','0','7092000','FIT','00258107','F2E','0','0','-','1','927000');
UPDATE tm_barang SET tgl_last_jual='2025-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-WJXG-203-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.950',berat_jual_asli=berat_jual_asli+'7.950',stock_jual='1',berat_akhir=berat_akhir-'7.950',berat_akhir_asli=berat_akhir_asli-'7.950',stock_akhir='0' WHERE tanggal='2025-09-21' AND kode_barang='F2E-WJXG-203-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 ('F325210225321','2025-09-21','7.950','2025-09-21','14:25:33','PLG0024954','7092000','7092000','0','7092000','7092000','input','2025-09-21 14:25:32','F32521022532');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-21','F325210225321','2025-09-21','14:25:33','FIT','7092000','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-250921-0019','D','2025-09-21','14:25:33','input','PENJUALAN','F325210225321','57527000','7092000','64619000');
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-00017040','X-00017040','AT COR 8K','GR','---','A1F','BELI','BELI001','840000','2025-09-21','1.020','1','kasir','2025-09-21 14:45:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017040','X-00017040');
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-250921-0010','00366173','AAT','1','BELI','BELI001','A1F', 'X-00017040', 'AT COR 8K','1.020','1.020','100.00','917000','840000','823529','944000','1','840000','840000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-250921-0010','2025-09-21','2025-09-21','14:45:45','AAT','---','1.020','840000','840000','840000','840000','840000','kasir','2025-09-21 14:45:46','FB-250921-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0010','MARLINA','DS TEMON SAMPUNG','','','','kasir','2025-09-21 14:45:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0020','K','2025-09-21','14:45:45','kasir','PEMBELIAN UMUM','FB-250921-0010','64619000','840000','63779000');
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-00017041','X-00017041','KL KADAR 8K','GR','---','H1E','BELI','BELI001','2100000','2025-09-21','2.590','1','kasir','2025-09-21 14:45:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017041','X-00017041');
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-250921-0011','t0072712','AAT','2','BELI','BELI001','H1E', 'X-00017041', 'KL KADAR 8K','2.590','2.590','100.00','2285000','2100000','810811','927000','1','2100000','2100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.590',berat_beli_asli=berat_beli_asli+'2.590',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.590',berat_akhir_asli=berat_akhir_asli+'2.590',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-250921-0011','2025-09-21','2025-09-21','14:45:45','AAT','---','2.590','2100000','2100000','2100000','2100000','2100000','kasir','2025-09-21 14:45:46','FB-250921-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0011','','','','','','kasir','2025-09-21 14:45:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0021','K','2025-09-21','14:45:45','kasir','PEMBELIAN UMUM','FB-250921-0011','63779000','2100000','61679000');
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-00017042','X-00017042','GL COR M 8K','GR','---','F2E','BELI','BELI001','4522000','2025-09-21','6.980','1','kasir','2025-09-21 14:47:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017042','X-00017042');
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-250921-0012','F323151243361','FIT','1','BELI','BELI001','F2E', 'X-00017042', 'GL COR M 8K','6.980','6.980','100.00','3165000','4522000','647851','927000','1','4522000','4522000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.980',berat_beli_asli=berat_beli_asli+'6.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.980',berat_akhir_asli=berat_akhir_asli+'6.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' 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-250921-0012','2025-09-21','2025-09-21','14:47:54','FIT','---','6.980','4522000','4522000','4522000','4522000','4522000','kasir','2025-09-21 14:47:54','FB-250921-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0012','SARMIATI','NGUNENG','','','','kasir','2025-09-21 14:47:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0022','K','2025-09-21','14:47:54','kasir','PEMBELIAN UMUM','FB-250921-0012','61679000','4522000','57157000');
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-00017043','X-00017043','GL PIPA MODEL MATA VAR PM D56 8K','GR','---','F2E','BELI','BELI001','2263000','2025-09-21','2.980','1','kasir','2025-09-21 14:47:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017043','X-00017043');
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-250921-0013','F325130101171','FIT','2','BELI','BELI001','F2E', 'X-00017043', 'GL PIPA MODEL MATA VAR PM D56 8K','2.980','2.980','100.00','2460000','2263000','759396','927000','1','2263000','2263000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.980',berat_beli_asli=berat_beli_asli+'2.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.980',berat_akhir_asli=berat_akhir_asli+'2.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-21' 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-250921-0013','2025-09-21','2025-09-21','14:47:54','FIT','---','2.980','2263000','2263000','2263000','2263000','2263000','kasir','2025-09-21 14:47:54','FB-250921-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0013','SAMIATI','NGUNENG PUHPELEM','','','','kasir','2025-09-21 14:47:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0023','K','2025-09-21','14:47:54','kasir','PEMBELIAN UMUM','FB-250921-0013','57157000','2263000','54894000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210225321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210225321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210225321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210820381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210820381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210820381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210904301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210904301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210904301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210905091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210905091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210905091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210905092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210905092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210905092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325210953091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325210953091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325210953091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325211011181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325211011181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325211011181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325211100401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325211100401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325211100401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325211208281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325211208281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325211208281';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0013';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-21';
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='2025-09-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-21' 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-250922-0001','D','2025-09-22','15:13:47','SYSTEM','SALDO AWAL','SALDO AWAL','0','54894000','54894000');
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-250922-0001','D','2025-09-22','15:13:47','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-250922-0001','D','2025-09-22','15:13:47','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-250922-0001','D','2025-09-22','15:13:47','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-09-22';