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 ('F225060901151','kasir','1',' MDB1 CM PE','TOKO','SMBK-B','B1D-YJXF-11-T','GW TUSUK MODEL HATI POLOS CM PE 8K ','OL','0.950','1','100.00','931000','0','0','15000','960000','0','5000','0','965000','NS','T0073909','B1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YJXF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='B1D-YJXF-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225060901151','2025-11-06','0.950','2025-11-06','09:01:16','PLG0074480','960000','960000','5000','965000','965000','kasir','2025-11-06 09:01:15','F22506090115');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060901151','2025-11-06','09:01:16','NS','965000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0002','D','2025-11-06','09:01:16','kasir','PENJUALAN','F225060901151','2402241000','965000','2403206000');
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 ('F225060901391','kasir','1',' MED1 CM ','TOKO','SMBK-D','D1E-YKXA-51-T','LT MODEL LETTERA PLAT CM 8K ','OL','0.530','1','100.00','530000','0','0','15000','535000','0','5000','0','540000','NS','T0074846','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKXA-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='D1E-YKXA-51-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 ('F225060901391','2025-11-06','0.530','2025-11-06','09:01:40','PLG0074481','535000','535000','5000','540000','540000','kasir','2025-11-06 09:01:39','F22506090139');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060901391','2025-11-06','09:01:40','NS','540000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0003','D','2025-11-06','09:01:40','kasir','PENJUALAN','F225060901391','2403206000','540000','2403746000');
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 ('F225060903001','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YKXC-5-T','GL MODEL GENIA UB 8K ','OL','0.510','1','100.00','510000','0','0','15000','515000','0','5000','0','520000','NS','T0074918','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXC-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F3E-YKXC-5-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 ('F225060903001','2025-11-06','0.510','2025-11-06','09:03:00','PLG0074482','515000','515000','5000','520000','520000','kasir','2025-11-06 09:03:00','F22506090300');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060903001','2025-11-06','09:03:00','NS','520000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0004','D','2025-11-06','09:03:00','kasir','PENJUALAN','F225060903001','2403746000','520000','2404266000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060903001' 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 ('F225060903002','kasir',' 1',' MFH1 UB ','TOKO','SMBK-H','H1F-YJXF-178-0','KL SIEM COBRA BOLA ARESO VAR UB 8K ','OL','1.340','1','100.00','1367000','0','0','15000','1373000','0','7000','0','1380000','NS','00372475','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXF-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='H1F-YJXF-178-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225060903002','2025-11-06','1.340','2025-11-06','09:03:00','PLG0074483','1373000','1373000','7000','1380000','1380000','kasir','2025-11-06 09:03:00','F22506090300');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060903002','2025-11-06','09:03:00','NS','1380000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0005','D','2025-11-06','09:03:00','kasir','PENJUALAN','F225060903002','2404266000','1380000','2405646000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060903002' 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 ('F225060903281','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YKXA-61-T','GL OVAL MODEL C TD D52 8K ','OL','2.990','1','100.00','2990000','0','0','15000','3005000','0','15000','0','3020000','NS','T0074856','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXA-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F1E-YKXA-61-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 ('F225060903281','2025-11-06','2.990','2025-11-06','09:03:28','PLG0074484','3005000','3005000','15000','3020000','3020000','kasir','2025-11-06 09:03:28','F22506090328');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060903281','2025-11-06','09:03:28','NS','3020000','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-251106-0006','D','2025-11-06','09:03:28','kasir','PENJUALAN','F225060903281','2405646000','3020000','2408666000');
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 ('F225060904301','kasir','1',' MFH1F UB 4','TOKO','SMBK-H','H1F-YJBD-119-T','KL KOREA UB 46CM 8K ','OL','1.000','1','100.00','1020000','0','0','15000','1025000','0','5000','0','1030000','TJ','T0074469','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-119-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='H1F-YJBD-119-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 ('F225060904301','2025-11-06','1.000','2025-11-06','09:04:30','PLG0074485','1025000','1025000','5000','1030000','1030000','kasir','2025-11-06 09:04:30','F22506090430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060904301','2025-11-06','09:04:30','TJ','1030000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0007','D','2025-11-06','09:04:30','kasir','PENJUALAN','F225060904301','2408666000','1030000','2409696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1030000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060904301' 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 ('F225060904302','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YJXF-96-0','LT SLOBOK BOLA SLEP BG 8K ','OL','0.270','1','100.00','286000','0','0','15000','289000','0','5000','0','294000','TJ','00372393','D1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YJXF-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='D1H-YJXF-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225060904302','2025-11-06','0.270','2025-11-06','09:04:30','PLG0074486','289000','289000','5000','294000','294000','kasir','2025-11-06 09:04:30','F22506090430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060904302','2025-11-06','09:04:30','TJ','294000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0008','D','2025-11-06','09:04:30','kasir','PENJUALAN','F225060904302','2409696000','294000','2409990000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='294000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060904302' 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 ('F225061119511','kasir','1',' TEA1 X LG ','TOKO','TBK-A','A1TE-YIXD-43-T','AT X JERSY SLEP LG 17K ','','0.530','1','100.00','949000','0','0','15000','955000','0','0','0','955000','TJ','T0072895','A1TE','0','0','-','0','1790000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YIXD-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='A1TE-YIXD-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225061119511','2025-11-06','0.530','2025-11-06','11:19:52','PLG0074487','955000','955000','0','955000','955000','kasir','2025-11-06 11:19:51','F22506111951');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061119511','2025-11-06','11:19:52','TJ','955000','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-251106-0009','D','2025-11-06','11:19:52','kasir','PENJUALAN','F225061119511','2409990000','955000','2410945000');
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 ('F225061132381','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YKXA-64-T','GL OVAL MODEL C TD D56 8K ','OL','3.310','1','100.00','3310000','0','0','15000','3326000','0','17000','0','3343000','TJ','T0074859','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXA-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F1E-YKXA-64-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 ('F225061132381','2025-11-06','3.310','2025-11-06','11:32:39','PLG0074488','3326000','3326000','17000','3343000','3343000','kasir','2025-11-06 11:32:38','F22506113238');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061132381','2025-11-06','11:32:39','TJ','3343000','17000');
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-251106-0010','D','2025-11-06','11:32:39','kasir','PENJUALAN','F225061132381','2410945000','3343000','2414288000');
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 ('F225061154591','kasir','1',' MGB1 BW ','TOKO','SMBK-B','B1G-YKXA-103-T','GW TUSUK BUNGA PASIR 2C BW 8K ','OL','0.450','1','100.00','468000','0','0','15000','475000','0','5000','0','480000','RTA','T0074898','B1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YKXA-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='B1G-YKXA-103-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225061154591','2025-11-06','0.450','2025-11-06','11:54:59','PLG0074489','475000','475000','5000','480000','480000','kasir','2025-11-06 11:54:59','F22506115459');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061154591','2025-11-06','11:54:59','RTA','480000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0011','D','2025-11-06','11:54:59','kasir','PENJUALAN','F225061154591','2414288000','480000','2414768000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061154591' 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 ('F225061154592','kasir',' 1',' MCB0 DG ','TOKO','SMBK-B','B0C-YKXC-25-T','GW TUSUK MRICAN POLOS DG 8K ','OL','0.500','1','100.00','480000','0','0','15000','488000','0','5000','0','493000','RTA','T0074938','B0C','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YKXC-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='B0C-YKXC-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225061154592','2025-11-06','0.500','2025-11-06','11:54:59','PLG0074490','488000','488000','5000','493000','493000','kasir','2025-11-06 11:54:59','F22506115459');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061154592','2025-11-06','11:54:59','RTA','493000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0012','D','2025-11-06','11:54:59','kasir','PENJUALAN','F225061154592','2414768000','493000','2415261000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='493000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061154592' 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 ('F225061216311','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YJAF-39-T','KL JEDAR UB 42 8K ','OL','0.980','1','100.00','980000','0','0','15000','990000','0','5000','0','995000','TJ','T0074165','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAF-39-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='2025-11-06' AND kode_barang='H1E-YJAF-39-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 ('F225061216311','2025-11-06','0.980','2025-11-06','12:16:32','PLG0074491','990000','990000','5000','995000','995000','kasir','2025-11-06 12:16:31','F22506121631');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061216311','2025-11-06','12:16:32','TJ','995000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0013','D','2025-11-06','12:16:32','kasir','PENJUALAN','F225061216311','2415261000','995000','2416256000');
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 ('F225061227311','kasir','1',' MDE2 X PM ','TOKO','SMBK-E','E2D-YIAC-343-0','CC X MODEL MATA PM 10 8K ','','1.050','1','100.00','1029000','0','0','15000','1029000','0','0','0','1029000','RTA','00369427','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-343-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YIAC-343-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 ('F225061227311','2025-11-06','1.050','2025-11-06','12:27:32','PLG0074492','1029000','1029000','0','1029000','1029000','kasir','2025-11-06 12:27:31','F22506122731');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061227311','2025-11-06','12:27:32','RTA','1029000','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-251106-0014','D','2025-11-06','12:27:32','kasir','PENJUALAN','F225061227311','2416256000','1029000','2417285000');
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 ('F225061241411','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-YJBI-91-T','CC MODEL MATA VAR LG 12 8K ','OL','0.470','1','100.00','470000','0','0','15000','475000','0','5000','0','480000','NS','T0074651','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBI-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2E-YJBI-91-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 ('F225061241411','2025-11-06','0.470','2025-11-06','12:41:42','PLG0074493','475000','475000','5000','480000','480000','kasir','2025-11-06 12:41:41','F22506124141');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225061241411','2025-11-06','12:41:42','NS','480000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0015','D','2025-11-06','12:41:42','kasir','PENJUALAN','F225061241411','2417285000','480000','2417765000');
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 ('F225060120501','kasir','1',' MEE1 HW 15','TOKO','SMBK-E','E1E-YKXA-93-T','CC MODEL SLEP VAR HW 15 8K ','OL','0.600','1','100.00','600000','0','0','15000','610000','0','5000','0','615000','NS','T0074888','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXA-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E1E-YKXA-93-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 ('F225060120501','2025-11-06','0.600','2025-11-06','13:20:50','PLG0074494','610000','610000','5000','615000','615000','kasir','2025-11-06 13:20:50','F22506012050');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060120501','2025-11-06','13:20:50','NS','615000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0016','D','2025-11-06','13:20:50','kasir','PENJUALAN','F225060120501','2417765000','615000','2418380000');
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 ('F225060136381','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YJXF-115-T','CC WEDDING MATA CM 10 8K ','','2.030','1','100.00','1989000','0','0','15000','1990000','0','10000','0','2000000','NS','T0074013','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXF-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YJXF-115-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 ('F225060136381','2025-11-06','2.030','2025-11-06','13:36:38','PLG0074495','1990000','1990000','10000','2000000','2000000','kasir','2025-11-06 13:36:38','F22506013638');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060136381','2025-11-06','13:36:38','NS','2000000','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-251106-0017','D','2025-11-06','13:36:38','kasir','PENJUALAN','F225060136381','2418380000','2000000','2420380000');
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 ('F225060152121','kasir','1',' TDE1 CM 12','TOKO','TBK-E','E1TD-YJXC-3-T','CC MODEL SLEP CM 12 17K ','OL','1.500','1','100.00','2655000','0','0','15000','2704000','0','11000','0','2715000','NS','T0073724','E1TD','0','0','-','0','1770000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YJXC-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E1TD-YJXC-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225060152121','2025-11-06','1.500','2025-11-06','13:52:12','PLG0074496','2704000','2704000','11000','2715000','2715000','kasir','2025-11-06 13:52:12','F22506015212');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060152121','2025-11-06','13:52:12','NS','2715000','11000');
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-251106-0018','D','2025-11-06','13:52:12','kasir','PENJUALAN','F225060152121','2420380000','2715000','2423095000');
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 ('F225060246031','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YKXA-62-T','GL OVAL MODEL C TD D52 8K ','OL','3.000','1','100.00','3000000','0','0','15000','3015000','0','15000','0','3030000','RTA','T0074857','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXA-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F1E-YKXA-62-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 ('F225060246031','2025-11-06','3.000','2025-11-06','14:46:03','PLG0074497','3015000','3015000','15000','3030000','0','kasir','2025-11-06 14:46:03','F22506024603');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F225060246031','2025-11-06','14:46:03','RTA','3030000','15000');
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-251106-0001','2025-11-06','2025-11-06 14:46:03','PENJUALAN : F225060246031','89089878767657','BCA','3030000','3030000','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-251106-0002','D','2025-11-06','14:46:03','BCA','PENJUALAN','F225060246031','4115435888','3030000','4118465888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89089878767657','LUKI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3030000' WHERE no_faktur_jual='F225060246031' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060120501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060120501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060120501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060136381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060136381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060136381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060152121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060152121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060152121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060246031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060246031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060246031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060901151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060901151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060901151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060901391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060901391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060901391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060903001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060903002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060903281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060903281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060904301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060904301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060904301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060904302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060904302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060904302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061119511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061119511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061119511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061132381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061132381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061132381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061154591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061154591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061154591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061154592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061154592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061154592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061216311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061216311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061216311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061227311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061227311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061227311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061241411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061241411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061241411';
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-00004800','X-00004800','AT X HUGGIES CD VAR YT','GR','---','A1E','BELI','BELI001','1260000','2025-11-06','1.370','1','kasir','2025-11-06 15:18:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004800','X-00004800');
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-251106-0001','F225040242191','RTA','1','BELI','BELI001','A1E', 'X-00004800', 'AT X HUGGIES CD VAR YT','1.370','1.370','100.00','1370000','1260000','919708','1000000','1','1260000','1260000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.370',berat_beli_asli=berat_beli_asli+'1.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.370',berat_akhir_asli=berat_akhir_asli+'1.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-251106-0001','2025-11-06','2025-11-06','15:18:50','RTA','---','1.370','1260000','1260000','1260000','1260000','1260000','kasir','2025-11-06 15:18:50','FB-251106-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0001','GALUH','JL. JAYAKATWANG SINDURO','','','083808295898','kasir','2025-11-06 15:18:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' 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-251106-0019','K','2025-11-06','15:18:50','kasir','PEMBELIAN UMUM','FB-251106-0001','2423095000','1260000','2421835000');
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-00004801','X-00004801','CC MODEL MATA VAR CM 10 8K','GR','---','E2D','BELI','BELI001','882000','2025-11-06','0.910','1','kasir','2025-11-06 15:19:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004801','X-00004801');
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-251106-0002','F225050320541','RTA','1','BELI','BELI001','E2D', 'X-00004801', 'CC MODEL MATA VAR CM 10 8K','0.910','0.910','100.00','892000','882000','969231','980000','1','882000','882000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0002','2025-11-06','2025-11-06','15:19:04','RTA','---','0.910','882000','882000','882000','882000','882000','kasir','2025-11-06 15:19:04','FB-251106-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0002','EKO','GEMAHARJO PACITAN','','','085648619396','kasir','2025-11-06 15:19:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' 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-251106-0020','K','2025-11-06','15:19:04','kasir','PEMBELIAN UMUM','FB-251106-0002','2421835000','882000','2420953000');
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-00004802','X-00004802','GL MODEL FLIK PITA VAR HW 8K','GR','---','F3E','BELI','BELI001','1748000','2025-11-06','1.900','1','kasir','2025-11-06 15:20:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004802','X-00004802');
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-251106-0003','F225230932431','TJ','1','BELI','BELI001','F3E', 'X-00004802', 'GL MODEL FLIK PITA VAR HW 8K','1.900','1.900','100.00','2014000','1748000','920000','1000000','1','1748000','1748000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-251106-0003','2025-11-06','2025-11-06','15:20:13','TJ','---','1.900','1748000','1748000','1748000','1748000','1748000','kasir','2025-11-06 15:20:13','FB-251106-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0003','VIONA','PENGKOL TENGAH 1/2','','','','kasir','2025-11-06 15:20:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' 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-251106-0021','K','2025-11-06','15:20:13','kasir','PEMBELIAN UMUM','FB-251106-0003','2420953000','1748000','2419205000');
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-00004803','X-00004803','GL ANAK MODEL FLIK VAR LT 8K','GR','---','F3E','BELI','BELI001','1560000','2025-11-06','1.950','1','kasir','2025-11-06 15:20:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004803','X-00004803');
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-251106-0004','F225230932432','TJ','2','BELI','BELI001','F3E', 'X-00004803', 'GL ANAK MODEL FLIK VAR LT 8K','1.970','1.950','100.00','2088000','1560000','800000','1000000','1','1560000','1560000','RUSAK');
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 ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-251106-0004','2025-11-06','2025-11-06','15:20:13','TJ','---','1.950','1560000','1560000','1560000','1560000','1560000','kasir','2025-11-06 15:20:13','FB-251106-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0004','VIONA','PENGKOL TENGAH 1/2','','','','kasir','2025-11-06 15:20:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' 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-251106-0022','K','2025-11-06','15:20:13','kasir','PEMBELIAN UMUM','FB-251106-0004','2419205000','1560000','2417645000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-06' 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-251107-0001','D','2025-11-07','16:03:04','SYSTEM','SALDO AWAL','SALDO AWAL','0','2417645000','2417645000');
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-251107-0001','D','2025-11-07','16:03:04','BCA','SALDO AWAL','SALDO AWAL','0','4118465888','4118465888');
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-251107-0001','D','2025-11-07','16:03:04','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','16:03:04','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-251107-0001','D','2025-11-07','16:03:04','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-251107-0001','D','2025-11-07','16:03:04','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-11-07';
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-20251107-0001','1','B1F-YIBB-125-0','1','0.400','0.400','TOKO','SBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-07 16:19:53' WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-07 16:19:53','TOKO','SMBK-B','B1F','B1F-YIBB-125-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1F-YIBB-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-YIBB-125-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251107-0001','2025-11-07','16:19','0.400','input','2025-11-06 16:19:53');
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-20251107-0001','1','B1E-YJBC-242-0','1','0.450','0.450','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJBC-242-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJBC-242-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-07 16:50:13' WHERE kode_barang='B1E-YJBC-242-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJBC-242-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-07 16:50:13','TOKO','SMBK-B','B1E','B1E-YJBC-242-0','1','0.450','0.450','1','0.450','0.450','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-YJBC-242-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJBC-242-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251107-0001','2025-11-07','16:50','0.450','input','2025-11-06 16:50: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-20251107-0001','1','E1E-YJBI-167-0','1','0.450','0.450','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBI-167-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBI-167-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-07 16:50:28' WHERE kode_barang='E1E-YJBI-167-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBI-167-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-07 16:50:28','TOKO','SMBK-E','E1E','E1E-YJBI-167-0','1','0.450','0.450','1','0.450','0.450','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-YJBI-167-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBI-167-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251107-0001','2025-11-07','16:50','0.450','input','2025-11-06 16:50:28');
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-20251107-0001','1','F3E-YKXC-171-0','1','0.510','0.510','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXC-171-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXC-171-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-11-07 16:50:42' WHERE kode_barang='F3E-YKXC-171-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXC-171-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-07 16:50:42','TOKO','SMBK-F','F3E','F3E-YKXC-171-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKXC-171-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXC-171-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251107-0001','2025-11-07','16:50','0.510','input','2025-11-06 16:50:42');