INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','1','E2D-YIXB-34-T','1','2.050','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIXB-34-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YIXB-34-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-YIXB-34-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='E2D-YIXB-34-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','2','E2D-YIBI-73-T','1','1.570','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIBI-73-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YIBI-73-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-YIBI-73-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-YIBI-73-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','3','E2D-YJAA-53-0','1','2.020','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJAA-53-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YJAA-53-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='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-YJAA-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='E2D-YJAA-53-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','4','E2D-YLAE-150-0','1','1.560','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLAE-150-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YLAE-150-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='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-YLAE-150-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.560',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.560',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='E2D-YLAE-150-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','5','E2D-YKAG-39-T','1','1.710','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKAG-39-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YKAG-39-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-YKAG-39-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.710',berat_out_asli='1.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.710',berat_akhir_asli =berat_akhir_asli-'1.710' WHERE kode_barang='E2D-YKAG-39-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','6','E2D-YLXC-2-T','1','1.850','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXC-2-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YLXC-2-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-YLXC-2-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='E2D-YLXC-2-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','7','E2D-YLXC-3-T','1','1.640','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXC-3-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YLXC-3-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-YLXC-3-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.640',berat_out_asli='1.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.640',berat_akhir_asli =berat_akhir_asli-'1.640' WHERE kode_barang='E2D-YLXC-3-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','8','E2D-YLXC-4-T','1','1.860','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YLXC-4-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-YLXC-4-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-YLXC-4-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='E2D-YLXC-4-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260211-0001','9','E2D-ZAXE-70-0','1','1.560','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXE-70-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2D-ZAXE-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='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-ZAXE-70-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.560',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.560',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='E2D-ZAXE-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-260211-0001','2026-02-11','2026-02-11','07:55','1.560','input','260211');
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 ('F226110814331','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZBAX-30-T','KL SANTA MODEL PITA VAR HW 8K ','OL','2.310','1','100.00','2945000','0','0','15000','2956000','0','12000','0','2968000','RTA','T0077145','H1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='H1E-ZBAX-30-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 ('F226110814331','2026-02-11','2.310','2026-02-11','08:14:34','PLG0077218','2956000','2956000','12000','2968000','2968000','kasir','2026-02-11 08:14:33','F22611081433');
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-02-11','F226110814331','2026-02-11','08:14:34','RTA','2968000','12000');
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-260211-0002','D','2026-02-11','08:14:34','kasir','PENJUALAN','F226110814331','5868220000','2968000','5871188000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1D-ZBAA-1-T','T0077200','MDD1 LG 8K ','LT COR MODEL SLEP LG 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1042000','2026-02-11','1042000','0.830','100.00','8','0','1255000.00','1','0.04', 'input','2026-02-11 08:35:39','0.830','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-ZBAA-1-T','T0077200');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','D1D-ZBAA-1-T','D1D','TOKO','01-SEM','100.00','0.830','0.830','1','0.830','0.830','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0001','1','D1D-ZBAA-1-T','1','0.83','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-ZBAA-1-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-D','D1D','D1D-ZBAA-1-T' , '1','0.83','0.83', '1','0.83','0.83','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.83',berat_out_asli=berat_out_asli+'0.83',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-ZBAA-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260211-0001','2026-02-11','2026-02-11','08:36','0.83','input','2026-02-11 08:36:18');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZBAA-2-T','T0077201','MEF1 YT ','GL MODEL DAUN SLEP YT 8K ','','GR','---','ME','F1E','TOKO','01-SEM','4322500','2026-02-11','4322500','3.390','100.00','8','0','1275000.00','1','0.04', 'input','2026-02-11 08:45:21','3.390','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZBAA-2-T','T0077201');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F1E-ZBAA-2-T','F1E','TOKO','01-SEM','100.00','3.390','3.390','1','3.390','3.390','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1D-ZBAA-1-T','T0077200','T0077200','LT COR MODEL SLEP LG 8K ','LT COR MODEL SLEP LG 8K','','','1042000','1042000',' 0','0','input','2026-02-11 08:46:14');
UPDATE tm_barang SET nama_barang='LT COR MODEL SLEP LG 8K' ,nama_atribut='' ,kode_intern='MDD1 LG', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1D-ZBAA-1-T' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZBAA-3-T','T0077202','MEF1 YT ','GL MODEL SANTA SERUT DAUN VAR YT 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2486500','2026-02-11','2486500','1.950','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 08:48:54','1.950','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZBAA-3-T','T0077202');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F1E-ZBAA-3-T','F1E','TOKO','01-SEM','100.00','1.950','1.950','1','1.950','1.950','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZBAA-4-T','T0077203','MEF1 LT ','GL MODEL DAUN SLEP LT 8K ','','GR','---','ME','F1E','TOKO','01-SEM','4513500','2026-02-11','4513500','3.540','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 08:51:27','3.540','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZBAA-4-T','T0077203');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F1E-ZBAA-4-T','F1E','TOKO','01-SEM','100.00','3.540','3.540','1','3.540','3.540','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-5-T','T0077204','MEF3 YT ','GL MODEL DAUN SLEP YT 8K ','','GR','---','ME','F3E','TOKO','01-SEM','5406000','2026-02-11','5406000','4.240','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 08:58:49','4.240','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-5-T','T0077204');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-5-T','F3E','TOKO','01-SEM','100.00','4.240','4.240','1','4.240','4.240','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-6-T','T0077205','MEF3 HW ','GL MODEL RANTE PLAT SLEP HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3965500','2026-02-11','3965500','3.110','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 09:00:24','3.110','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-6-T','T0077205');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-6-T','F3E','TOKO','01-SEM','100.00','3.110','3.110','1','3.110','3.110','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 ('F226110901061','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZABA-26-T','AS EXTENSION LG 8K ','OLS 6MS28','0.200','1','100.00','263000','0','0','15000','270000','0','37000','0','307000','RHM','T0076799','S1G','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZABA-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='S1G-ZABA-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226110901061','2026-02-11','0.200','2026-02-11','09:01:07','PLG0077219','270000','270000','37000','307000','307000','kasir','2026-02-11 09:01:06','F22611090106');
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-02-11','F226110901061','2026-02-11','09:01:07','RHM','307000','37000');
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-260211-0003','D','2026-02-11','09:01:07','kasir','PENJUALAN','F226110901061','5871188000','307000','5871495000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-7-T','T0077206','MEF3 UB 15K ','GL MEDAN SLEP PASIR UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3060000','2026-02-11','3060000','2.400','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 09:04:45','2.400','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-7-T','T0077206');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-7-T','F3E','TOKO','01-SEM','100.00','2.400','2.400','1','2.400','2.400','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','1','F1E-ZBAA-2-T','1','3.39','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZBAA-2-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F1E','F1E-ZBAA-2-T' , '1','3.39','3.39', '1','3.39','3.39','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.39',berat_out_asli=berat_out_asli+'3.39',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZBAA-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','2','F1E-ZBAA-3-T','1','1.95','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZBAA-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F1E','F1E-ZBAA-3-T' , '1','1.95','1.95', '1','1.95','1.95','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.95',berat_out_asli=berat_out_asli+'1.95',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZBAA-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','3','F1E-ZBAA-4-T','1','3.54','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZBAA-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F1E','F1E-ZBAA-4-T' , '1','3.54','3.54', '1','3.54','3.54','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.54',berat_out_asli=berat_out_asli+'3.54',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZBAA-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','4','F3E-ZBAA-5-T','1','4.24','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-5-T' , '1','4.24','4.24', '1','4.24','4.24','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.24',berat_out_asli=berat_out_asli+'4.24',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','5','F3E-ZBAA-6-T','1','3.11','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-6-T' , '1','3.11','3.11', '1','3.11','3.11','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.11',berat_out_asli=berat_out_asli+'3.11',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0002','6','F3E-ZBAA-7-T','1','2.4','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-7-T' , '1','2.4','2.4', '1','2.4','2.4','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.4',berat_out_asli=berat_out_asli+'2.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260211-0002','2026-02-11','2026-02-11','09:05','18.63','input','2026-02-11 09:05:38');
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 ('F226110925461','kasir','1',' MEE1 UB 15','TOKO','SMBK-E','E1E-ZABA-102-T','CC MODEL RING VAR UB 15 8K ','','0.570','1','100.00','727000','0','0','15000','724000','0','0','0','724000','TJ','T0076875','E1E','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABA-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='E1E-ZABA-102-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 ('F226110925461','2026-02-11','0.570','2026-02-11','09:25:46','PLG0077220','724000','724000','0','724000','724000','kasir','2026-02-11 09:25:46','F22611092546');
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-02-11','F226110925461','2026-02-11','09:25:46','TJ','724000','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-260211-0004','D','2026-02-11','09:25:46','kasir','PENJUALAN','F226110925461','5871495000','724000','5872219000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-8-T','T0077207','MEF3 HW 20K ','GL CASTELA SLEP VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','4411500','2026-02-11','4411500','3.460','100.00','8','0','1275000.00','1','0.04', 'input','2026-02-11 09:30:10','3.460','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-8-T','T0077207');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-8-T','F3E','TOKO','01-SEM','100.00','3.460','3.460','1','3.460','3.460','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-9-T','T0077208','MEF3 UB 15K ','GL MEDAN SLEP PASIR UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3111000','2026-02-11','3111000','2.440','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 09:31:44','2.440','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-9-T','T0077208');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-9-T','F3E','TOKO','01-SEM','100.00','2.440','2.440','1','2.440','2.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZBAA-10-T','T0077209','MEF3 UB 15K ','GL MEDAN SLEP PASIR UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','2920000','2026-02-11','2920000','2.290','100.00','8','','1275000.00','1','0.04', 'input','2026-02-11 09:31:54','2.290','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZBAA-10-T','T0077209');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-11','F3E-ZBAA-10-T','F3E','TOKO','01-SEM','100.00','2.290','2.290','1','2.290','2.290','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0003','1','F3E-ZBAA-10-T','1','2.29','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-10-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-10-T' , '1','2.29','2.29', '1','2.29','2.29','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.29',berat_out_asli=berat_out_asli+'2.29',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0003','2','F3E-ZBAA-8-T','1','3.46','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-8-T' , '1','3.46','3.46', '1','3.46','3.46','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.46',berat_out_asli=berat_out_asli+'3.46',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260211-0003','3','F3E-ZBAA-9-T','1','2.44','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZBAA-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-02-11','TOKO','SMBK-F','F3E','F3E-ZBAA-9-T' , '1','2.44','2.44', '1','2.44','2.44','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.44',berat_out_asli=berat_out_asli+'2.44',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZBAA-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260211-0003','2026-02-11','2026-02-11','09:32','8.19','input','2026-02-11 09:34:10');
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 ('F226111006261','kasir','1',' MEA1 HW ','TOKO','SMBK-A','A1E-YKBH-98-T','AT MODEL ARESO VAR HW 8K ','','0.970','1','100.00','1237000','0','0','15000','1232000','0','0','0','1232000','TJ','T0075330','A1E','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKBH-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='A1E-YKBH-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226111006261','2026-02-11','0.970','2026-02-11','10:06:27','PLG0077221','1232000','1232000','0','1232000','1232000','kasir','2026-02-11 10:06:26','F22611100626');
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-02-11','F226111006261','2026-02-11','10:06:27','TJ','1232000','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-260211-0005','D','2026-02-11','10:06:27','kasir','PENJUALAN','F226111006261','5872219000','1232000','5873451000');
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 ('F226111049011','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZAXH-80-T','CC MODEL PITA VAR CM 16 8K ','OL','1.470','1','100.00','1845000','0','0','15000','1845000','0','7000','0','1852000','TIN','T0076403','E1D','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='E1D-ZAXH-80-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 ('F226111049011','2026-02-11','1.470','2026-02-11','10:49:02','PLG0077222','1845000','1845000','7000','1852000','1852000','kasir','2026-02-11 10:49:01','F22611104901');
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-02-11','F226111049011','2026-02-11','10:49:02','TIN','1852000','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-260211-0006','D','2026-02-11','10:49:02','kasir','PENJUALAN','F226111049011','5873451000','1852000','5875303000');
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 ('F226111052441','kasir','1',' MDE2 X PM ','TOKO','SMBK-E','E2D-YLAG-212-0','CC X MODEL MATA PM 16 8K ','','1.000','1','100.00','1255000','0','0','15000','1250000','0','0','0','1250000','RHM','00381566','E2D','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAG-212-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-02-11' AND kode_barang='E2D-YLAG-212-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 ('F226111052441','2026-02-11','1.000','2026-02-11','10:52:45','PLG0077223','1250000','1250000','0','1250000','1250000','kasir','2026-02-11 10:52:44','F22611105244');
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-02-11','F226111052441','2026-02-11','10:52:45','RHM','1250000','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-260211-0007','D','2026-02-11','10:52:45','kasir','PENJUALAN','F226111052441','5875303000','1250000','5876553000');
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 ('F226111107161','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAX-13-T','GL SANTA MODEL PITA MATA VAR HW 8K ','OL ','1.410','1','100.00','1798000','0','0','15000','1805000','0','7000','0','1812000','RHM','T0077128','F3E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='F3E-ZBAX-13-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 ('F226111107161','2026-02-11','1.410','2026-02-11','11:07:17','PLG0077224','1805000','1805000','7000','1812000','1812000','kasir','2026-02-11 11:07:16','F22611110716');
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-02-11','F226111107161','2026-02-11','11:07:17','RHM','1812000','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-260211-0008','D','2026-02-11','11:07:17','kasir','PENJUALAN','F226111107161','5876553000','1812000','5878365000');
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 ('F226111107471','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZBAX-28-T','KL CASANO SIEM HATI VAR HW 8K ','OL ','1.640','1','100.00','2091000','0','0','15000','2099000','0','8000','0','2107000','RHM','T0077143','H1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='H1E-ZBAX-28-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 ('F226111107471','2026-02-11','1.640','2026-02-11','11:07:48','PLG0077225','2099000','2099000','8000','2107000','2107000','kasir','2026-02-11 11:07:47','F22611110747');
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-02-11','F226111107471','2026-02-11','11:07:48','RHM','2107000','8000');
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-260211-0009','D','2026-02-11','11:07:48','kasir','PENJUALAN','F226111107471','5878365000','2107000','5880472000');
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 ('F226111114161','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZBAX-77-T','KL MILANO UB 40CM 8K ','OL','2.080','1','100.00','2652000','0','0','15000','2652000','0','10000','0','2662000','TIN','T0077192','H1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='H1E-ZBAX-77-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 ('F226111114161','2026-02-11','2.080','2026-02-11','11:14:16','PLG0077226','2652000','2652000','10000','2662000','2662000','kasir','2026-02-11 11:14:16','F22611111416');
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-02-11','F226111114161','2026-02-11','11:14:16','TIN','2662000','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-260211-0010','D','2026-02-11','11:14:16','kasir','PENJUALAN','F226111114161','5880472000','2662000','5883134000');
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 ('F226111125081','kasir','1',' MEF3 10K U','TOKO','SMBK-F','F3E-ZBAX-6-T','GL MEDAN BOLA PASIR VAR UB 8K ','OL','2.330','1','100.00','2971000','0','0','15000','2972000','0','23000','0','2995000','RTA','T0077121','F3E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='F3E-ZBAX-6-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 ('F226111125081','2026-02-11','2.330','2026-02-11','11:25:08','PLG0077227','2972000','2972000','23000','2995000','2995000','kasir','2026-02-11 11:25:08','F22611112508');
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-02-11','F226111125081','2026-02-11','11:25:08','RTA','2995000','23000');
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-260211-0011','D','2026-02-11','11:25:08','kasir','PENJUALAN','F226111125081','5883134000','2995000','5886129000');
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 ('F226111158331','kasir','1',' MEF1 TD D6','TOKO','SMBK-F','F1E-ZAAE-24-T','GL OVAL MODEL C TD D60 8K ','OL','5.470','1','100.00','6974000','0','0','15000','6990000','0','40000','0','7030000','RTA','T0076586','F1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAE-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.470',berat_jual_asli=berat_jual_asli+'5.470',stock_jual='1',berat_akhir=berat_akhir-'5.470',berat_akhir_asli=berat_akhir_asli-'5.470',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='F1E-ZAAE-24-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 ('F226111158331','2026-02-11','5.470','2026-02-11','11:58:33','PLG0077228','6990000','6990000','40000','7030000','7030000','kasir','2026-02-11 11:58:33','F22611115833');
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-02-11','F226111158331','2026-02-11','11:58:33','RTA','7030000','40000');
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-260211-0012','D','2026-02-11','11:58:33','kasir','PENJUALAN','F226111158331','5886129000','7030000','5893159000');
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 ('F226111229231','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZBAX-26-T','KL SANTA MODEL HATI POLOS HW 8K ','OL','2.000','1','100.00','2550000','0','0','15000','2550000','0','10000','0','2560000','RTA','T0077141','H1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='H1E-ZBAX-26-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 ('F226111229231','2026-02-11','2.000','2026-02-11','12:29:24','PLG0077229','2550000','2550000','10000','2560000','2560000','kasir','2026-02-11 12:29:23','F22611122923');
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-02-11','F226111229231','2026-02-11','12:29:24','RTA','2560000','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-260211-0013','D','2026-02-11','12:29:24','kasir','PENJUALAN','F226111229231','5893159000','2560000','5895719000');
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 ('F226111231211','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAA-6-T','GL MODEL RANTE PLAT SLEP HW 8K ','OL','3.110','1','100.00','3965000','0','0','15000','3980000','0','16000','0','3996000','RTA','T0077205','F3E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAA-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='F3E-ZBAA-6-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 ('F226111231211','2026-02-11','3.110','2026-02-11','12:31:21','PLG0077230','3980000','3980000','16000','3996000','3996000','kasir','2026-02-11 12:31:21','F22611123121');
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-02-11','F226111231211','2026-02-11','12:31:21','RTA','3996000','16000');
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-260211-0014','D','2026-02-11','12:31:21','kasir','PENJUALAN','F226111231211','5895719000','3996000','5899715000');
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 ('F226111231561','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZBAX-25-T','KL SANTA MODEL HATI POLOS HW 8K ','OL','2.000','1','100.00','2550000','0','0','15000','2560000','0','10000','0','2570000','RTA','T0077140','H1E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAX-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='H1E-ZBAX-25-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 ('F226111231561','2026-02-11','2.000','2026-02-11','12:31:56','PLG0077231','2560000','2560000','10000','2570000','2570000','kasir','2026-02-11 12:31:56','F22611123156');
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-02-11','F226111231561','2026-02-11','12:31:56','RTA','2570000','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-260211-0015','D','2026-02-11','12:31:56','kasir','PENJUALAN','F226111231561','5899715000','2570000','5902285000');
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 ('F226110101271','kasir','1',' MGPF KH ','TOKO','SMBK-P','PFG-YIXB-7-T','GL WG RANTAI HOLLOW DOUBLE VAR KH 8K ','OL','2.000','1','100.00','2630000','0','0','15000','2630000','0','10000','0','2640000','RTA','T0072751','PFG','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFG-YIXB-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='PFG-YIXB-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F226110101271','2026-02-11','2.000','2026-02-11','13:01:28','PLG0077232','2630000','2630000','10000','2640000','2640000','kasir','2026-02-11 13:01:27','F22611010127');
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-02-11','F226110101271','2026-02-11','13:01:28','RTA','2640000','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-260211-0016','D','2026-02-11','13:01:28','kasir','PENJUALAN','F226110101271','5902285000','2640000','5904925000');
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 ('F226110115301','kasir','1',' MDD1 5K LG','TOKO','SMBK-D','D1D-YIBB-89-T','LT MODEL FINE GOLD LG 8K ','','0.980','1','100.00','1230000','0','0','15000','1210000','0','5000','0','1215000','RTA','T0073225','D1D','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YIBB-89-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='D1D-YIBB-89-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 ('F226110115301','2026-02-11','0.980','2026-02-11','13:15:30','PLG0077233','1210000','1210000','5000','1215000','0','kasir','2026-02-11 13:15:30','F22611011530');
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-02-11','F226110115301','2026-02-11','13:15:30','RTA','1215000','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-260211-0001','2026-02-11','2026-02-11 13:15:30','PENJUALAN : F226110115301','90988877665','BCA','1215000','1215000','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-260211-0002','D','2026-02-11','13:15:30','BCA','PENJUALAN','F226110115301','4270217888','1215000','4271432888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('90988877665','SRI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1215000' WHERE no_faktur_jual='F226110115301' 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 ('F226110157541','kasir','1',' MEF3 10K H','TOKO','SMBK-F','F3E-ZBAX-4-T','GL MODEL FLIK CLOVER PASIR VAR HW 8K ','OL','3.510','1','100.00','4475000','0','0','15000','4492000','0','18000','0','4510000','RTA','T0077119','F3E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='F3E-ZBAX-4-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 ('F226110157541','2026-02-11','3.510','2026-02-11','13:57:55','PLG0077234','4492000','4492000','18000','4510000','4510000','kasir','2026-02-11 13:57:54','F22611015754');
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-02-11','F226110157541','2026-02-11','13:57:55','RTA','4510000','18000');
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-260211-0017','D','2026-02-11','13:57:55','kasir','PENJUALAN','F226110157541','5904925000','4510000','5909435000');
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 ('F226110158481','kasir','1',' MEF3 UB 15','TOKO','SMBK-F','F3E-ZBAA-7-T','GL MEDAN SLEP PASIR UB 8K ','OL','2.400','1','100.00','3060000','0','0','15000','3060000','0','12000','0','3072000','RTA','T0077206','F3E','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAA-7-T' 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-02-11' AND kode_barang='F3E-ZBAA-7-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 ('F226110158481','2026-02-11','2.400','2026-02-11','13:58:49','PLG0077235','3060000','3060000','12000','3072000','3072000','kasir','2026-02-11 13:58:48','F22611015848');
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-02-11','F226110158481','2026-02-11','13:58:49','RTA','3072000','12000');
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-260211-0018','D','2026-02-11','13:58:49','kasir','PENJUALAN','F226110158481','5909435000','3072000','5912507000');
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 ('F226110211191','kasir','1',' MEF3 UB 15','TOKO','SMBK-F','F3E-ZBAA-7-T','GL MEDAN SLEP PASIR UB 8K ','OL','2.400','1','100.00','3060000','0','0','15000','3057000','0','15000','0','3072000','RTA','T0077206','F3E','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAA-7-T' 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-02-11' AND kode_barang='F3E-ZBAA-7-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 ('F226110211191','2026-02-11','2.400','2026-02-11','14:11:19','PLG0077236','3057000','3057000','15000','3072000','3072000','kasir','2026-02-11 14:11:19','F22611021119');
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-02-11','F226110211191','2026-02-11','14:11:19','RTA','3072000','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-260211-0020','D','2026-02-11','14:11:19','kasir','PENJUALAN','F226110211191','5909435000','3072000','5912507000');
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 ('F226110213351','kasir','1',' MDE2 X LG ','TOKO','SMBK-E','E2D-YLCX-136-0','CC X SOLITAIRE MATA LG 10 8K ','','1.030','1','100.00','1293000','0','0','15000','1272000','0','10000','0','1282000','TJ','00383541','E2D','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-02-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLCX-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-02-11' AND kode_barang='E2D-YLCX-136-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 ('F226110213351','2026-02-11','1.030','2026-02-11','14:13:35','PLG0077237','1272000','1272000','10000','1282000','0','kasir','2026-02-11 14:13:35','F22611021335');
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-02-11','F226110213351','2026-02-11','14:13:35','TJ','1282000','10000');
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-260211-0002','2026-02-11','2026-02-11 14:13:35','PENJUALAN : F226110213351','974398347940934','BCA','1282000','1282000','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-260211-0003','D','2026-02-11','14:13:35','BCA','PENJUALAN','F226110213351','4271432888','1282000','4272714888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('974398347940934','ARYAKEMUNING');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1282000' WHERE no_faktur_jual='F226110213351' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110101271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110101271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110101271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110115301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110115301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110115301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110157541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110157541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110157541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110211191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110211191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110211191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110213351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110213351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110213351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110814331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110814331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110814331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110901061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110901061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110901061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110925461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110925461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110925461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111006261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111049011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111049011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111049011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111052441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111052441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111052441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111107161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111107161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111107161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111107471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111107471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111107471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111114161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111114161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111114161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111125081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111125081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111125081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111158331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111158331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111158331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111229231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111229231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111229231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111231211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111231211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111231211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111231561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111231561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111231561';
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-00005085','X-00005085','CC MODEL MATA PM 14','GR','---','E2E','BELI','BELI001','715000','2026-02-11','0.820','1','kasir','2026-02-11 15:19:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005085','X-00005085');
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-260211-0001','F223141108541','TIN','1','BELI','BELI001','E2E', 'X-00005085', 'CC MODEL MATA PM 14','0.970','0.820','100.00','455000','715000','871951','1275000','1','715000','715000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260211-0001','2026-02-11','2026-02-11','15:19:01','TIN','---','0.820','715000','715000','715000','715000','715000','kasir','2026-02-11 15:19:02','FB-260211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260211-0001','DIAH','SOOKO','','','085230210834','kasir','2026-02-11 15:19:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-11' 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-260211-0021','K','2026-02-11','15:19:01','kasir','PEMBELIAN UMUM','FB-260211-0001','5912507000','715000','5911792000');
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-00005086','X-00005086','AT HUGGIES BOLA ARESSO VAR HW','GR','---','A1TF','BELI','BELI001','3605000','2026-02-11','1.950','1','kasir','2026-02-11 15:24:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TF','X-00005086','X-00005086');
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-260211-0002','F223271116251','RTA','1','BELI','BELI001','A1TF', 'X-00005086', 'AT HUGGIES BOLA ARESSO VAR HW','2.080','1.950','100.00','1737000','3605000','1848718','2320000','1','3605000','3605000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TF' 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-260211-0002','2026-02-11','2026-02-11','15:24:02','RTA','---','1.950','3605000','3605000','3605000','3605000','3605000','kasir','2026-02-11 15:24:02','FB-260211-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260211-0002','PAPIK','TAMBAK MAS MADIUN','','','081237596814','kasir','2026-02-11 15:24:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-11' 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-260211-0022','K','2026-02-11','15:24:02','kasir','PEMBELIAN UMUM','FB-260211-0002','5911792000','3605000','5908187000');
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-00005087','X-00005087','GL X RANTAI HOLLOW P4 SLEP LT','GR','---','F3TE','BELI','BELI001','5455000','2026-02-11','2.950','1','kasir','2026-02-11 15:25:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00005087','X-00005087');
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-260211-0003','F224171007541','RTA','1','BELI','BELI001','F3TE', 'X-00005087', 'GL X RANTAI HOLLOW P4 SLEP LT','3.070','2.950','100.00','2640000','5455000','1849153','2300000','1','5455000','5455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-260211-0003','2026-02-11','2026-02-11','15:25:29','RTA','---','2.950','5455000','5455000','5455000','5455000','5455000','kasir','2026-02-11 15:25:30','FB-260211-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260211-0003','PAPIK','TAMBAKMAS MADIUN','','','081359418958','kasir','2026-02-11 15:25:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-11' 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-260211-0023','K','2026-02-11','15:25:29','kasir','PEMBELIAN UMUM','FB-260211-0003','5908187000','5455000','5902732000');
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-00005088','X-00005088','GL RANTAI HOLLOW P4 SLEP VAR LT 17K','GR','---','F3TE','BELI','BELI001','5550000','2026-02-11','3.000','1','kasir','2026-02-11 15:25:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00005088','X-00005088');
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-260211-0004','F225110141131','RTA','2','BELI','BELI001','F3TE', 'X-00005088', 'GL RANTAI HOLLOW P4 SLEP VAR LT 17K','3.080','3.000','100.00','4497000','5550000','1850000','2300000','1','5550000','5550000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-260211-0004','2026-02-11','2026-02-11','15:25:29','RTA','---','3.000','5550000','5550000','5550000','5550000','5550000','kasir','2026-02-11 15:25:30','FB-260211-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260211-0004','RUDI','TAMBAKMAS MADIUN','','','081359418958','kasir','2026-02-11 15:25:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-11' 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-260211-0024','K','2026-02-11','15:25:29','kasir','PEMBELIAN UMUM','FB-260211-0004','5902732000','5550000','5897182000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260211-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260211-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260211-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260211-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260211-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260211-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260211-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260211-0004';
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-00005089','X-00005089','KL GUCCI UB 42CM 8K','GR','---','H1E','BELI','BELI001','2714000','2026-02-11','3.020','1','kasir','2026-02-11 15:27:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005089','X-00005089');
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-260211-0005','F225010141361','TIN','1','BELI','BELI001','H1E', 'X-00005089', 'KL GUCCI UB 42CM 8K','3.020','3.020','100.00','2951000','2714000','898675','1275000','1','2714000','2714000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.020',berat_beli_asli=berat_beli_asli+'3.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.020',berat_akhir_asli=berat_akhir_asli+'3.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-11' 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-260211-0005','2026-02-11','2026-02-11','15:27:58','TIN','---','3.020','2714000','2714000','2714000','2714000','2714000','kasir','2026-02-11 15:27:59','FB-260211-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260211-0005','HUSNA','MAGETAN','','','085136778220','kasir','2026-02-11 15:27:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-11' 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-260211-0025','K','2026-02-11','15:27:58','kasir','PEMBELIAN UMUM','FB-260211-0005','5897182000','2714000','5894468000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260211-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260211-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-11';
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-02-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-11' 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-260212-0001','D','2026-02-12','16:54:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','5894468000','5894468000');
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-260212-0001','D','2026-02-12','16:54:07','BCA','SALDO AWAL','SALDO AWAL','0','4272714888','4272714888');
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-260212-0001','D','2026-02-12','16:54:07','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260212-0001','D','2026-02-12','16:54:07','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-260212-0001','D','2026-02-12','16:54:07','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-260212-0001','D','2026-02-12','16:54:07','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-02-12';
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-20260212-0001','1','A1D-ZBAA-74-0','1','1.030','1.030','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZBAA-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZBAA-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-02-12 17:07:09' WHERE kode_barang='A1D-ZBAA-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZBAA-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 ('2026-02-12 17:07:09','TOKO','SMBK-A','A1D','A1D-ZBAA-74-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-ZBAA-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZBAA-74-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260212-0001','2026-02-12','17:07','1.030','input','2026-02-11 17:07:09');
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-20260212-0001','1','B1H-ZBAA-96-0','1','0.270','0.270','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-ZBAA-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-ZBAA-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-12 17:07:22' WHERE kode_barang='B1H-ZBAA-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-ZBAA-96-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:22','TOKO','SMBK-B','B1H','B1H-ZBAA-96-0','1','0.270','0.270','1','0.270','0.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-ZBAA-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-ZBAA-96-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-20260212-0001','1','B1E-ZBAA-97-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBAA-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-12 17:07:22' WHERE kode_barang='B1E-ZBAA-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBAA-97-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:22','TOKO','SMBK-B','B1E','B1E-ZBAA-97-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZBAA-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-97-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-20260212-0001','1','B1E-ZBAA-98-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZBAA-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-02-12 17:07:22' WHERE kode_barang='B1E-ZBAA-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZBAA-98-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:22','TOKO','SMBK-B','B1E','B1E-ZBAA-98-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZBAA-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZBAA-98-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260212-0001','2026-02-12','17:07','1.370','input','2026-02-11 17:07: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-20260212-0001','1','D2E-ZBAA-112-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZBAA-112-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZBAA-112-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-02-12 17:07:36' WHERE kode_barang='D2E-ZBAA-112-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZBAA-112-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:36','TOKO','SMBK-D','D2E','D2E-ZBAA-112-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-ZBAA-112-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZBAA-112-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260212-0001','2026-02-12','17:07','0.480','input','2026-02-11 17:07:35');
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-20260212-0001','1','E1E-ZBAA-136-0','1','0.740','0.740','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZBAA-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZBAA-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E1E-ZBAA-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZBAA-136-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E1E','E1E-ZBAA-136-0','1','0.740','0.740','1','0.740','0.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZBAA-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZBAA-136-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-20260212-0001','1','E2D-ZBAA-137-0','1','1.100','1.100','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAA-137-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-137-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E2D-ZBAA-137-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAA-137-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E2D','E2D-ZBAA-137-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-ZBAA-137-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-137-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-20260212-0001','1','E2D-ZBAA-138-0','1','0.860','0.860','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAA-138-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-138-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E2D-ZBAA-138-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAA-138-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E2D','E2D-ZBAA-138-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-ZBAA-138-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-138-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-20260212-0001','1','E2D-ZBAA-139-0','1','0.960','0.960','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAA-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-139-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E2D-ZBAA-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAA-139-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E2D','E2D-ZBAA-139-0','1','0.960','0.960','1','0.960','0.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-ZBAA-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-139-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-20260212-0001','1','E2D-ZBAA-140-0','1','1.000','1.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAA-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-140-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E2D-ZBAA-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAA-140-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E2D','E2D-ZBAA-140-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-ZBAA-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-140-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-20260212-0001','1','E2D-ZBAA-141-0','1','0.830','0.830','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAA-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E2D-ZBAA-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAA-141-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E2D','E2D-ZBAA-141-0','1','0.830','0.830','1','0.830','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' 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='E2D-ZBAA-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAA-141-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-20260212-0001','1','E1D-ZBAA-142-0','1','0.910','0.910','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBAA-142-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBAA-142-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-02-12 17:07:49' WHERE kode_barang='E1D-ZBAA-142-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBAA-142-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:07:49','TOKO','SMBK-E','E1D','E1D-ZBAA-142-0','1','0.910','0.910','1','0.910','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZBAA-142-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBAA-142-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260212-0001','2026-02-12','17:07','6.400','input','2026-02-11 17:07:49');
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-20260212-0001','1','H1E-ZBAA-196-0','1','1.030','1.030','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBAA-196-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-196-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-12 17:08:06' WHERE kode_barang='H1E-ZBAA-196-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBAA-196-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:08:06','TOKO','SMBK-H','H1E','H1E-ZBAA-196-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBAA-196-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-196-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-20260212-0001','1','H1E-ZBAA-197-0','1','2.670','2.670','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBAA-197-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-197-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-12 17:08:06' WHERE kode_barang='H1E-ZBAA-197-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBAA-197-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-12 17:08:06','TOKO','SMBK-H','H1E','H1E-ZBAA-197-0','1','2.670','2.670','1','2.670','2.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBAA-197-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-197-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-20260212-0001','1','H1E-ZBAA-198-0','1','2.200','2.200','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZBAA-198-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-198-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-02-12 17:08:06' WHERE kode_barang='H1E-ZBAA-198-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZBAA-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 ('2026-02-12 17:08:06','TOKO','SMBK-H','H1E','H1E-ZBAA-198-0','1','2.200','2.200','1','2.200','2.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZBAA-198-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZBAA-198-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260212-0001','2026-02-12','17:07','5.900','input','2026-02-11 17:08:05');