INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260620-0001','1','E1D-ZEBX-38-T','1','1.450','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZEBX-38-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-ZEBX-38-T' 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='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1D-ZEBX-38-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.450',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.450',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='E1D-ZEBX-38-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260620-0001','2','E2D-ZEBF-42-T','1','1.570','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZEBF-42-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-ZEBF-42-T' 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='E2D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E2D-ZEBF-42-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='E2D-ZEBF-42-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260620-0001','3','E1E-ZEBH-413-0','1','0.740','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZEBH-413-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1E-ZEBH-413-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1E-ZEBH-413-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.740',berat_out_asli='0.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.740',berat_akhir_asli =berat_akhir_asli-'0.740' WHERE kode_barang='E1E-ZEBH-413-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-260620-0001','2026-06-20','2026-06-20','07:54','0.740','input','260620');
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 ('F226200833401','kasir','1',' MEE1 X CM ','TOKO','SMBK-E','E1E-ZFAH-210-0','CC X MODEL SLEP CM 12 8K ','OL','0.760','1','100.00','832000','0','0','15000','840000','0','5000','0','845000','TIN','00409217','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAH-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1E-ZFAH-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200833401','2026-06-20','0.760','2026-06-20','08:33:41','PLG0081244','840000','840000','5000','845000','845000','kasir','2026-06-20 08:33:40','F22620083340');
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-06-20','F226200833401','2026-06-20','08:33:41','TIN','845000','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-260620-0002','D','2026-06-20','08:33:41','kasir','PENJUALAN','F226200833401','11027769000','845000','11028614000');
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 ('F226200834071','kasir','1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZFAF-58-T','GW TUSUK MATA LG 8K ','OL','0.310','1','100.00','346000','0','0','15000','349000','0','5000','0','354000','TIN','T0080493','B1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFAF-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='B1F-ZFAF-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200834071','2026-06-20','0.310','2026-06-20','08:34:07','PLG0081245','349000','349000','5000','354000','354000','kasir','2026-06-20 08:34:07','F22620083407');
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-06-20','F226200834071','2026-06-20','08:34:07','TIN','354000','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-260620-0003','D','2026-06-20','08:34:07','kasir','PENJUALAN','F226200834071','11028614000','354000','11028968000');
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 ('F226201014481','kasir','1',' MDE2 5K CM','TOKO','SMBK-E','E2D-ZDXG-23-T','CC MODEL BUNGA MATA VAR CM 12 8K ','','1.070','1','100.00','1150000','0','0','15000','1150000','0','5000','0','1155000','TIN','T0078563','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDXG-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZDXG-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201014481','2026-06-20','1.070','2026-06-20','10:14:48','PLG0081246','1150000','1150000','5000','1155000','0','kasir','2026-06-20 10:14:48','F22620101448');
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-06-20','F226201014481','2026-06-20','10:14:48','TIN','1155000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0001','2026-06-20','2026-06-20 10:14:48','PENJUALAN : F226201014481','0987654321','BCA','1155000','1155000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0002','D','2026-06-20','10:14:48','BCA','PENJUALAN','F226201014481','4532521888','1155000','4533676888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','PRAYITNO');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201014481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201014481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201014481';
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 ('F226201016171','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZEXE-138-0','KL X SANTA MATA VAR HW 42 8K ','','2.400','1','100.00','2628000','0','0','15000','2628000','0','0','0','2628000','TIN','00402311','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXE-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1E-ZEXE-138-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201016171','2026-06-20','2.400','2026-06-20','10:16:18','PLG0081247','2628000','2628000','0','2628000','0','kasir','2026-06-20 10:16:17','F22620101617');
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-06-20','F226201016171','2026-06-20','10:16:18','TIN','2628000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0002','2026-06-20','2026-06-20 10:16:17','PENJUALAN : F226201016171','0987654321','BCA','2628000','2628000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0003','D','2026-06-20','10:16:18','BCA','PENJUALAN','F226201016171','4533676888','2628000','4536304888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','PRAYITNO');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201016171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201016171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201016171';
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 ('F226201058061','kasir','1',' TDE1 CM 20','TOKO','TBK-E','E1TD-YIXE-33-T','CC MODEL SLEP VAR CM 20 17K ','','1.500','1','100.00','2970000','0','0','15000','3065000','0','0','0','3065000','RHM','T0073003','E1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YIXE-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1TD-YIXE-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226201058061','2026-06-20','1.500','2026-06-20','10:58:06','PLG0081248','3065000','3065000','0','3065000','3065000','kasir','2026-06-20 10:58:06','F22620105806');
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-06-20','F226201058061','2026-06-20','10:58:06','RHM','3065000','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-260620-0004','D','2026-06-20','10:58:06','kasir','PENJUALAN','F226201058061','11028968000','3065000','11032033000');
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 ('F226201104391','kasir','1',' MED1E 5K L','TOKO','SMBK-D','D1E-YJAH-108-T','LT MODEL SLEP LG 8K ','OL','0.520','1','100.00','569000','0','0','15000','575000','0','5000','0','580000','TIN','T0074321','D1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAH-108-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='D1E-YJAH-108-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201104391','2026-06-20','0.520','2026-06-20','11:04:40','PLG0081249','575000','575000','5000','580000','0','kasir','2026-06-20 11:04:39','F22620110439');
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-06-20','F226201104391','2026-06-20','11:04:40','TIN','580000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0003','2026-06-20','2026-06-20 11:04:39','PENJUALAN : F226201104391','74657467','BCA','580000','580000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0004','D','2026-06-20','11:04:40','BCA','PENJUALAN','F226201104391','4536304888','580000','4536884888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('74657467','RICE');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='580000' WHERE no_faktur_jual='F226201104391' 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 ('F226201129581','kasir','1',' TEH1 X UB ','TOKO','TBK-H','H1TE-ZCBC-31-T','KL X SANTA MODEL BOLA ARESO VAR UB 17K ','','3.300','1','100.00','6600000','0','0','15000','6600000','0','0','0','6600000','LUS','T0078266','H1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1TE-ZCBC-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226201129581','2026-06-20','3.300','2026-06-20','11:29:58','PLG0081250','6600000','6600000','0','6600000','6600000','kasir','2026-06-20 11:29:58','F22620112958');
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-06-20','F226201129581','2026-06-20','11:29:58','LUS','6600000','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-260620-0005','D','2026-06-20','11:29:58','kasir','PENJUALAN','F226201129581','11032033000','6600000','11038633000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201129581' 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 ('F226201129582','kasir',' 1',' TDE1 X BM ','TOKO','TBK-E','E1TD-YJBH-45-T','CC X MODEL SLEP BM 22 17K ','','3.970','1','100.00','7861000','0','0','15000','7861000','0','0','0','7861000','LUS','T0074527','E1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YJBH-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.970',berat_jual_asli=berat_jual_asli+'3.970',stock_jual='1',berat_akhir=berat_akhir-'3.970',berat_akhir_asli=berat_akhir_asli-'3.970',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1TD-YJBH-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226201129582','2026-06-20','3.970','2026-06-20','11:29:58','PLG0081251','7861000','7861000','0','7861000','7861000','kasir','2026-06-20 11:29:58','F22620112958');
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-06-20','F226201129582','2026-06-20','11:29:58','LUS','7861000','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-260620-0006','D','2026-06-20','11:29:58','kasir','PENJUALAN','F226201129582','11038633000','7861000','11046494000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7861000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201129582' 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 ('F226201130331','kasir','1',' MDE2 X LG ','TOKO','SMBK-E','E2D-ZBXF-202-0','CC X MODEL MATA LG 12 8K ','OL','1.000','1','100.00','1075000','0','0','15000','1080000','0','5000','0','1085000','TIN','00388784','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-202-0' 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='2026-06-20' AND kode_barang='E2D-ZBXF-202-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201130331','2026-06-20','1.000','2026-06-20','11:30:33','PLG0081252','1080000','1080000','5000','1085000','0','kasir','2026-06-20 11:30:33','F22620113033');
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-06-20','F226201130331','2026-06-20','11:30:33','TIN','1085000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0004','2026-06-20','2026-06-20 11:30:33','PENJUALAN : F226201130331','5453234576','BCA','1085000','1085000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0005','D','2026-06-20','11:30:33','BCA','PENJUALAN','F226201130331','4536884888','1085000','4537969888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('5453234576','MOH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1085000' WHERE no_faktur_jual='F226201130331' 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 ('F226201140461','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEXI-266-0','CC X MODEL MATA CM 12 8K ','','1.010','1','100.00','1086000','0','0','15000','1086000','0','0','0','1086000','RHM','00403087','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXI-266-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZEXI-266-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201140461','2026-06-20','1.010','2026-06-20','11:40:47','PLG0081253','1086000','1086000','0','1086000','1086000','kasir','2026-06-20 11:40:46','F22620114046');
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-06-20','F226201140461','2026-06-20','11:40:47','RHM','1086000','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-260620-0007','D','2026-06-20','11:40:47','kasir','PENJUALAN','F226201140461','11046494000','1086000','11047580000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1086000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201140461' 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 ('F226201140462','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YEAE-272-0','CC X MODEL MATA CM 12 8K ','','1.010','1','100.00','1086000','0','0','15000','1086000','0','0','0','1086000','RHM','00354044','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEAE-272-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-YEAE-272-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201140462','2026-06-20','1.010','2026-06-20','11:40:47','PLG0081254','1086000','1086000','0','1086000','1086000','kasir','2026-06-20 11:40:46','F22620114046');
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-06-20','F226201140462','2026-06-20','11:40:47','RHM','1086000','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-260620-0008','D','2026-06-20','11:40:47','kasir','PENJUALAN','F226201140462','11047580000','1086000','11048666000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1086000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201140462' 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 ('F226201214491','kasir','1',' TED1 UB ','TOKO','TBK-D','D1TE-ZFXE-119-T','LT MODEL HATI SLEP UB 17K ','OL','0.550','1','100.00','1100000','0','0','15000','1106000','0','7000','0','1113000','TIN','T0080421','D1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-ZFXE-119-T' 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-06-20' AND kode_barang='D1TE-ZFXE-119-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226201214491','2026-06-20','0.550','2026-06-20','12:14:49','PLG0081255','1106000','1106000','7000','1113000','1113000','kasir','2026-06-20 12:14:49','F22620121449');
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-06-20','F226201214491','2026-06-20','12:14:49','TIN','1113000','7000');
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-260620-0009','D','2026-06-20','12:14:49','kasir','PENJUALAN','F226201214491','11048666000','1113000','11049779000');
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 ('F226201236301','kasir','1',' MEF2 PM 56','TOKO','SMBK-F','F2E-YLAH-8-T','GL PIPA MATA 56 PM 8K ','','2.910','1','100.00','3186000','0','0','15000','3186000','0','0','0','3186000','LUS','T0075937','F2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAH-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F2E-YLAH-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201236301','2026-06-20','2.910','2026-06-20','12:36:30','PLG0081256','3186000','3186000','0','3186000','0','kasir','2026-06-20 12:36:30','F22620123630');
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-06-20','F226201236301','2026-06-20','12:36:30','LUS','3186000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0005','2026-06-20','2026-06-20 12:36:30','PENJUALAN : F226201236301','76532356787544','BCA','3186000','3186000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0006','D','2026-06-20','12:36:30','BCA','PENJUALAN','F226201236301','4537969888','3186000','4541155888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('76532356787544','BAYU');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3186000' WHERE no_faktur_jual='F226201236301' 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 ('F226201236302','kasir',' 1',' MEF3 11K K','TOKO','SMBK-F','F3E-ZFXD-31-T','GL RANTAI P3 SLEP KH 8K ','','2.130','1','100.00','2332000','0','0','15000','2332000','0','11000','0','2343000','LUS','T0080196','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZFXD-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201236302','2026-06-20','2.130','2026-06-20','12:36:30','PLG0081257','2332000','2332000','11000','2343000','0','kasir','2026-06-20 12:36:30','F22620123630');
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-06-20','F226201236302','2026-06-20','12:36:30','LUS','2343000','11000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0006','2026-06-20','2026-06-20 12:36:30','PENJUALAN : F226201236302','76532356787544','BCA','2343000','2343000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0007','D','2026-06-20','12:36:30','BCA','PENJUALAN','F226201236302','4541155888','2343000','4543498888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('76532356787544','BAYU');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201236301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201236301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201236301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201236302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201236302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201236302';
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 ('F226201245181','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFAI-31-T','CC VELG SLEP CM 12 8K ','OL','1.050','1','100.00','1129000','0','0','15000','1135000','0','5000','0','1140000','LUS','T0080531','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1D-ZFAI-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201245181','2026-06-20','1.050','2026-06-20','12:45:18','PLG0081258','1135000','1135000','5000','1140000','1140000','kasir','2026-06-20 12:45:18','F22620124518');
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-06-20','F226201245181','2026-06-20','12:45:18','LUS','1140000','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-260620-0010','D','2026-06-20','12:45:18','kasir','PENJUALAN','F226201245181','11049779000','1140000','11050919000');
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 ('F226201257491','kasir','1',' MDB1 LG ','TOKO','SMBK-B','B1D-YJXD-84-T','GW SUPING MODEL BOTEGA VAR LG 8K ','OLS HNY78','1.010','1','100.00','1086000','0','0','15000','1116000','0','107000','0','1223000','TIN','T0073898','B1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YJXD-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='B1D-YJXD-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226201257491','2026-06-20','1.010','2026-06-20','12:57:50','PLG0081259','1116000','1116000','107000','1223000','1223000','kasir','2026-06-20 12:57:49','F22620125749');
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-06-20','F226201257491','2026-06-20','12:57:50','TIN','1223000','107000');
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-260620-0011','D','2026-06-20','12:57:50','kasir','PENJUALAN','F226201257491','11050919000','1223000','11052142000');
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 ('F226200121051','kasir','1',' TEH1 X UB ','TOKO','TBK-H','H1TE-ZDXD-170-T','KL X MILANO UB 42CM 17K ','OL','4.070','1','100.00','8140000','0','0','15000','8153000','0','28000','0','8181000','LUS','T0078457','H1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZDXD-170-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.070',berat_jual_asli=berat_jual_asli+'4.070',stock_jual='1',berat_akhir=berat_akhir-'4.070',berat_akhir_asli=berat_akhir_asli-'4.070',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1TE-ZDXD-170-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226200121051','2026-06-20','4.070','2026-06-20','13:21:05','PLG0081260','8153000','8153000','28000','8181000','8181000','kasir','2026-06-20 13:21:05','F22620012105');
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-06-20','F226200121051','2026-06-20','13:21:05','LUS','8181000','28000');
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-260620-0012','D','2026-06-20','13:21:05','kasir','PENJUALAN','F226200121051','11052142000','8181000','11060323000');
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 ('F226200125371','kasir','1',' MEE1 AY 16','TOKO','SMBK-E','E1E-ZBAD-11-T','CC AUREL MODEL UNTIR AY 16 8K ','OL','0.550','1','100.00','602000','0','0','15000','608000','0','5000','0','613000','TIN','T0077300','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAD-11-T' 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-06-20' AND kode_barang='E1E-ZBAD-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200125371','2026-06-20','0.550','2026-06-20','13:25:38','PLG0081261','608000','608000','5000','613000','613000','kasir','2026-06-20 13:25:37','F22620012537');
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-06-20','F226200125371','2026-06-20','13:25:38','TIN','613000','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-260620-0013','D','2026-06-20','13:25:38','kasir','PENJUALAN','F226200125371','11060323000','613000','11060936000');
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 ('F226200208271','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZDBC-22-T','KL SANTA MODEL 3C SLEP VAR HW 8K ','OL','2.220','1','100.00','2431000','0','0','15000','2442000','0','11000','0','2453000','TIN','T0078903','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBC-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1E-ZDBC-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200208271','2026-06-20','2.220','2026-06-20','14:08:27','PLG0081262','2442000','2442000','11000','2453000','0','kasir','2026-06-20 14:08:27','F22620020827');
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-06-20','F226200208271','2026-06-20','14:08:27','TIN','2453000','11000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260620-0007','2026-06-20','2026-06-20 14:08:27','PENJUALAN : F226200208271','09987654321','BCA','2453000','2453000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260620-0008','D','2026-06-20','14:08:27','BCA','PENJUALAN','F226200208271','4543498888','2453000','4545951888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('09987654321','DWI SETYORINI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2453000' WHERE no_faktur_jual='F226200208271' 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 ('F226200239581','kasir','1',' MDD2D X BM','TOKO','SMBK-D','D2D-ZFXH-112-0','LT X MODEL MATA BM 8K ','','0.890','1','100.00','957000','0','0','15000','957000','0','0','0','957000','LUS','00407973','D2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZFXH-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.890',berat_jual_asli=berat_jual_asli+'0.890',stock_jual='1',berat_akhir=berat_akhir-'0.890',berat_akhir_asli=berat_akhir_asli-'0.890',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='D2D-ZFXH-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200239581','2026-06-20','0.890','2026-06-20','14:39:58','PLG0081263','957000','957000','0','957000','957000','kasir','2026-06-20 14:39:58','F22620023958');
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-06-20','F226200239581','2026-06-20','14:39:58','LUS','957000','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-260620-0014','D','2026-06-20','14:39:58','kasir','PENJUALAN','F226200239581','11060936000','957000','11061893000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='957000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200239581' 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 ('F226200239582','kasir',' 1',' MEH1 KH 44','TOKO','SMBK-H','H1E-ZBAX-78-T','KL SANTA KH 44CM 8K ','','5.030','1','100.00','5508000','0','0','15000','5508000','0','0','0','5508000','LUS','T0077193','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.030',berat_jual_asli=berat_jual_asli+'5.030',stock_jual='1',berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1E-ZBAX-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200239582','2026-06-20','5.030','2026-06-20','14:39:58','PLG0081264','5508000','5508000','0','5508000','5508000','kasir','2026-06-20 14:39:58','F22620023958');
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-06-20','F226200239582','2026-06-20','14:39:58','LUS','5508000','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-260620-0015','D','2026-06-20','14:39:58','kasir','PENJUALAN','F226200239582','11061893000','5508000','11067401000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200239582' LIMIT 1;
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-00005464','X-00005464','CC X MODEL SLEP CM 15 17K','GR','---','E1TD','BELI','BELI001','3050000','2026-06-20','1.530','1','admin','2026-06-20 14:56:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TD','X-00005464','X-00005464');
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-260620-0001','F226160832571','RHM','1','BELI','BELI001','E1TD', 'X-00005464', 'CC X MODEL SLEP CM 15 17K','1.530','1.530','100.00','3126000','3050000','1993464','1980000','1','3050000','3050000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TD' 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-260620-0001','2026-06-20','2026-06-20','14:56:49','RHM','---','1.530','3050000','3050000','3050000','3050000','3050000','admin','2026-06-20 14:56:50','FB-260620-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0001','TRI ASTUTI','','','','','admin','2026-06-20 14:56:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0016','K','2026-06-20','14:56:49','admin','PEMBELIAN UMUM','FB-260620-0001','11067401000','3050000','11064351000');
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-00005465','X-00005465','CC X MODEL MATA YT 16 8K','GR','---','E2D','BELI','BELI001','1044000','2026-06-20','1.080','1','admin','2026-06-20 14:56:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005465','X-00005465');
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-260620-0002','F226300817571','RHM','2','BELI','BELI001','E2D', 'X-00005465', 'CC X MODEL MATA YT 16 8K','1.080','1.080','100.00','1188000','1044000','966667','1075000','1','1044000','1044000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0002','2026-06-20','2026-06-20','14:56:49','RHM','---','1.080','1044000','1044000','1044000','1044000','1044000','admin','2026-06-20 14:56:50','FB-260620-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0002','AYUS','MAJAYAN MADIUN','','','085807449537','admin','2026-06-20 14:56:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0017','K','2026-06-20','14:56:49','admin','PEMBELIAN UMUM','FB-260620-0002','11064351000','1044000','11063307000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200121051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200121051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200121051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200125371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200125371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200125371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200208271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200208271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200208271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200239581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200239581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200239581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200239582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200239582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200239582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200833401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200833401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200833401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200834071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200834071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200834071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201058061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201058061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201104391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201104391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201104391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201129581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201129581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201129581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201129582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201129582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201129582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201130331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201130331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201130331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201140461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201140462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201214491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201214491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201214491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201245181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201245181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201245181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201257491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201257491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201257491';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0002';
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 ('F226200301131','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZFXD-106-T','GL OVAL C SLEP TD 56 8K ','OL','4.850','1','100.00','5311000','0','0','15000','5336000','0','24000','0','5360000','LUS','T0080271','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.850',berat_jual_asli=berat_jual_asli+'4.850',stock_jual='1',berat_akhir=berat_akhir-'4.850',berat_akhir_asli=berat_akhir_asli-'4.850',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F1E-ZFXD-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200301131','2026-06-20','4.850','2026-06-20','15:01:14','PLG0081265','5336000','5336000','24000','5360000','5360000','kasir','2026-06-20 15:01:13','F22620030113');
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-06-20','F226200301131','2026-06-20','15:01:14','LUS','5360000','24000');
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-260620-0018','D','2026-06-20','15:01:14','kasir','PENJUALAN','F226200301131','11063307000','5360000','11068667000');
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 ('F226200323091','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEAE-1-T','GL OVAL MODEL C TD D56 8K ','','3.220','1','100.00','3526000','0','0','15000','3526000','0','0','0','3526000','TIN','T0079427','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAE-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F1E-ZEAE-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226200323091','2026-06-20','3.220','2026-06-20','15:23:09','PLG0081266','3526000','3526000','0','3526000','3526000','kasir','2026-06-20 15:23:09','F22620032309');
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-06-20','F226200323091','2026-06-20','15:23:09','TIN','3526000','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-260620-0019','D','2026-06-20','15:23:09','kasir','PENJUALAN','F226200323091','11068667000','3526000','11072193000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200301131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200301131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200301131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200323091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200323091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200323091';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-20';
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-06-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-20' 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-260621-0001','D','2026-06-21','16:04:32','SYSTEM','SALDO AWAL','SALDO AWAL','0','11072193000','11072193000');
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-260621-0001','D','2026-06-21','16:04:32','BCA','SALDO AWAL','SALDO AWAL','0','4545951888','4545951888');
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-260621-0001','D','2026-06-21','16:04:32','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260621-0001','D','2026-06-21','16:04:32','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-260621-0001','D','2026-06-21','16:04:32','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-260621-0001','D','2026-06-21','16:04:32','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-21';