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 ('F326040859081','input','1',' MDE1 X UB ','TOKO','PM-E','E1D-YIBD-413-0','CC X VELG C SLEP UB 16 8K ','','2.050','1','100.00','2132000','0','0','15000','2132000','0','0','0','2132000','AAT','00370834','E1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBD-413-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E1D-YIBD-413-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326040859081','2026-07-04','2.050','2026-07-04','08:59:08','PLG0030123','2132000','2132000','0','2132000','2132000','input','2026-07-04 08:59:08','F32604085908');
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-07-04','F326040859081','2026-07-04','08:59:08','AAT','2132000','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-260704-0002','D','2026-07-04','08:59:08','input','PENJUALAN','F326040859081','6131557000','2132000','6133689000');
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 ('F326041005001','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-ZDBX-109-0','GL X GHENIA LT 8K ','','1.010','1','100.00','1071000','0','0','15000','1070000','0','0','0','1070000','LIS','00400045','F3E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3E-ZDBX-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041005001','2026-07-04','1.010','2026-07-04','10:05:01','PLG0030124','1070000','1070000','0','1070000','1070000','kasir','2026-07-04 10:05:00','F32604100500');
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-07-04','F326041005001','2026-07-04','10:05:01','LIS','1070000','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-260704-0003','D','2026-07-04','10:05:01','kasir','PENJUALAN','F326041005001','6133689000','1070000','6134759000');
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 ('F326041008381','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZEBE-202-0','KL X MILANO UB 44 9K ','','4.100','1','100.00','4756000','0','0','15000','4756000','0','0','0','4756000','SIN','00404901','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZEBE-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.100',berat_jual_asli=berat_jual_asli+'4.100',stock_jual='1',berat_akhir=berat_akhir-'4.100',berat_akhir_asli=berat_akhir_asli-'4.100',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='H2J-ZEBE-202-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041008381','2026-07-04','4.100','2026-07-04','10:08:38','PLG0030125','4756000','4756000','0','4756000','4756000','kasir','2026-07-04 10:08:38','F32604100838');
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-07-04','F326041008381','2026-07-04','10:08:38','SIN','4756000','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-260704-0004','D','2026-07-04','10:08:38','kasir','PENJUALAN','F326041008381','6134759000','4756000','6139515000');
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 ('F326041022201','kasir','1',' MEE2 X AY ','TOKO','PM-E','E2E-ZCCX-555-0','CC X SOLITAIRE MATA AY 10 8K ','','0.750','1','100.00','795000','0','0','15000','795000','0','5000','0','800000','LIS','00397209','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCCX-555-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E2E-ZCCX-555-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041022201','2026-07-04','0.750','2026-07-04','10:22:20','PLG0030126','795000','795000','5000','800000','800000','kasir','2026-07-04 10:22:20','F32604102220');
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-07-04','F326041022201','2026-07-04','10:22:20','LIS','800000','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-260704-0005','D','2026-07-04','10:22:20','kasir','PENJUALAN','F326041022201','6139515000','800000','6140315000');
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 ('F326041047101','kasir','1',' MED1E HW ','TOKO','PM-D','D1E-ZDAE-171-0','LT MODEL DAUN SLEP HW 8K ','','0.520','1','100.00','551000','0','0','15000','550000','0','0','0','550000','LIS','00399457','D1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDAE-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='D1E-ZDAE-171-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041047101','2026-07-04','0.520','2026-07-04','10:47:10','PLG0030127','550000','550000','0','550000','550000','kasir','2026-07-04 10:47:10','F32604104710');
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-07-04','F326041047101','2026-07-04','10:47:10','LIS','550000','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-260704-0006','D','2026-07-04','10:47:10','kasir','PENJUALAN','F326041047101','6140315000','550000','6140865000');
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 ('F326041223511','kasir','1',' MEF1 X YT5','TOKO','PM-F','F1E-ZEBG-94-0','GL X OVAL C SLEP YT 58 8K ','','2.550','1','100.00','2703000','0','0','15000','2703000','0','0','0','2703000','FIT','00405092','F1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBG-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F1E-ZEBG-94-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041223511','2026-07-04','2.550','2026-07-04','12:23:52','PLG0030128','2703000','2703000','0','2703000','2703000','kasir','2026-07-04 12:23:51','F32604122351');
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-07-04','F326041223511','2026-07-04','12:23:52','FIT','2703000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260704-0007','D','2026-07-04','12:23:52','kasir','PENJUALAN','F326041223511','6140865000','2703000','6143568000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2703000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041223511' 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 ('F326041223512','kasir',' 1',' MEF1 X YT ','TOKO','PM-F','F1E-ZFXC-151-0','GL X OVAL C SLEP YT 58 8K ','','2.500','1','100.00','2650000','0','0','15000','2650000','0','0','0','2650000','FIT','00406694','F1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXC-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F1E-ZFXC-151-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041223512','2026-07-04','2.500','2026-07-04','12:23:52','PLG0030129','2650000','2650000','0','2650000','2650000','kasir','2026-07-04 12:23:51','F32604122351');
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-07-04','F326041223512','2026-07-04','12:23:52','FIT','2650000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260704-0008','D','2026-07-04','12:23:52','kasir','PENJUALAN','F326041223512','6143568000','2650000','6146218000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326041223512' 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 ('F326041240541','kasir','1',' MDE2 CM 12','TOKO','PM-E','E2D-ZFAF-6-0','CC WEDDING MATA CM 12 8K ','','1.030','1','100.00','1071000','0','0','15000','1071000','0','0','0','1071000','SIN','00408755','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAF-6-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-07-04' AND kode_barang='E2D-ZFAF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326041240541','2026-07-04','1.030','2026-07-04','12:40:54','PLG0030130','1071000','1071000','0','1071000','1071000','kasir','2026-07-04 12:40:54','F32604124054');
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-07-04','F326041240541','2026-07-04','12:40:54','SIN','1071000','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-260704-0009','D','2026-07-04','12:40:54','kasir','PENJUALAN','F326041240541','6146218000','1071000','6147289000');
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-00019546','X-00019546','GL PIPA MODEL MATA VAR KH D56 17K','GR','---','F2TE','BELI','BELI001','8555000','2026-07-04','4.870','1','kasir','2026-07-04 12:46:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2TE','X-00019546','X-00019546');
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-260704-0001','F325131004351','FIT','1','BELI','BELI001','F2TE', 'X-00019546', 'GL PIPA MODEL MATA VAR KH D56 17K','4.870','4.870','100.00','9300000','8555000','1756674','1950000','1','8555000','8555000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.870',berat_beli_asli=berat_beli_asli+'4.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.870',berat_akhir_asli=berat_akhir_asli+'4.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2TE' 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-260704-0001','2026-07-04','2026-07-04','12:46:35','FIT','---','4.870','8555000','8555000','8555000','8555000','8555000','kasir','2026-07-04 12:46:36','FB-260704-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0001','ADITYA KUSUMAWATI','KLAMPISAN KISMANTORO','','','','kasir','2026-07-04 12:46:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0010','K','2026-07-04','12:46:35','kasir','PEMBELIAN UMUM','FB-260704-0001','6147289000','8555000','6138734000');
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-00019547','X-00019547','LT COR T 8K','GR','---','D1E','BELI','BELI001','395000','2026-07-04','0.410','1','kasir','2026-07-04 12:51:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00019547','X-00019547');
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-260704-0002','t0078702','SIN','1','BELI','BELI001','D1E', 'X-00019547', 'LT COR T 8K','0.410','0.410','100.00','465000','395000','963415','1070000','1','395000','395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.410',berat_beli_asli=berat_beli_asli+'0.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.410',berat_akhir_asli=berat_akhir_asli+'0.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-260704-0002','2026-07-04','2026-07-04','12:51:26','SIN','---','0.410','395000','395000','395000','395000','395000','kasir','2026-07-04 12:51:26','FB-260704-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0002','NUROSTALIA','PARANG','','','','kasir','2026-07-04 12:51:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0011','K','2026-07-04','12:51:26','kasir','PEMBELIAN UMUM','FB-260704-0002','6138734000','395000','6138339000');
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-00019548','X-00019548','CC X VELG SLEP CM 18 8K','GR','---','E1D','BELI','BELI001','1870000','2026-07-04','2.030','1','kasir','2026-07-04 12:52:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019548','X-00019548');
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-260704-0003','F325100955481','AAT','1','BELI','BELI001','E1D', 'X-00019548', 'CC X VELG SLEP CM 18 8K','2.030','2.030','100.00','1970000','1870000','921182','1050000','1','1870000','1870000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0003','2026-07-04','2026-07-04','12:52:41','AAT','---','2.030','1870000','1870000','1870000','1870000','1870000','kasir','2026-07-04 12:52:42','FB-260704-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0003','PASIAH','BITING PURWANTORO','','','082133931705','kasir','2026-07-04 12:52:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0012','K','2026-07-04','12:52:41','kasir','PEMBELIAN UMUM','FB-260704-0003','6138339000','1870000','6136469000');
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-00019549','X-00019549','CC WEDDING MATA CM 14 8K','GR','---','E2D','BELI','BELI001','870000','2026-07-04','0.900','1','kasir','2026-07-04 12:53:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019549','X-00019549');
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-260704-0004','F326160253231','FIT','1','BELI','BELI001','E2D', 'X-00019549', 'CC WEDDING MATA CM 14 8K','0.900','0.900','100.00','963000','870000','966667','1050000','1','870000','870000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' 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-260704-0004','2026-07-04','2026-07-04','12:53:24','FIT','---','0.900','870000','870000','870000','870000','870000','kasir','2026-07-04 12:53:24','FB-260704-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0004','RISMA','BITING PURWANTORO','','','','kasir','2026-07-04 12:53:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0013','K','2026-07-04','12:53:24','kasir','PEMBELIAN UMUM','FB-260704-0004','6136469000','870000','6135599000');
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 ('F326040100091','kasir','1',' MDA1D X CM','TOKO','PM-A','A1D-YLAE-34-0','AT X HUGGIES KLIP VAR CM 8K ','','1.250','1','100.00','1300000','0','0','15000','1300000','0','0','0','1300000','LIS','00381012','A1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAE-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1D-YLAE-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326040100091','2026-07-04','1.250','2026-07-04','13:00:09','PLG0030131','1300000','1300000','0','1300000','1300000','kasir','2026-07-04 13:00:09','F32604010009');
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-07-04','F326040100091','2026-07-04','13:00:09','LIS','1300000','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-260704-0014','D','2026-07-04','13:00:09','kasir','PENJUALAN','F326040100091','6135599000','1300000','6136899000');
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-00019550','X-00019550','LT SLOBOK BUNGA ARESO LG 8K','GR','---','D1E','BELI','BELI001','412000','2026-07-04','0.420','1','kasir','2026-07-04 13:28:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00019550','X-00019550');
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-260704-0005','F326100207041','AAT','1','BELI','BELI001','D1E', 'X-00019550', 'LT SLOBOK BUNGA ARESO LG 8K','0.420','0.420','100.00','470000','412000','980952','1070000','1','412000','412000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-260704-0005','2026-07-04','2026-07-04','13:28:33','AAT','---','0.420','412000','412000','412000','412000','412000','kasir','2026-07-04 13:28:34','FB-260704-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0005','MELIANA','GEDAWUNG KISMANTORO','','','','kasir','2026-07-04 13:28:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0015','K','2026-07-04','13:28:33','kasir','PEMBELIAN UMUM','FB-260704-0005','6136899000','412000','6136487000');
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 ('F326040159091','kasir','1',' TEF3 X UB ','TOKO','PT-F','F3TE-XDBG-79-T','GL X SIEM MODEL HATI MATA VAR UB 17K ','','1.830','1','100.00','3568000','0','0','15000','3568000','0','0','0','3568000','SIN','T0056729','F3TE','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-XDBG-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3TE-XDBG-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326040159091','2026-07-04','1.830','2026-07-04','13:59:10','PLG0030132','3568000','3568000','0','3568000','3568000','kasir','2026-07-04 13:59:09','F32604015909');
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-07-04','F326040159091','2026-07-04','13:59:10','SIN','3568000','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-260704-0016','D','2026-07-04','13:59:10','kasir','PENJUALAN','F326040159091','6136487000','3568000','6140055000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040159091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040159091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040159091';
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 ('F326040204361','kasir','1',' TEF3 X UB ','TOKO','PT-F','F3TE-XDBG-79-T','GL X SIEM MODEL HATI MATA VAR UB 17K ','','1.830','1','100.00','3568000','0','0','15000','3568000','0','0','0','3568000','SIN','T0056729','F3TE','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-XDBG-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3TE-XDBG-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326040204361','2026-07-04','1.830','2026-07-04','14:04:36','PLG0030133','3568000','3568000','0','3568000','3568000','kasir','2026-07-04 14:04:36','F32604020436');
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-07-04','F326040204361','2026-07-04','14:04:36','SIN','3568000','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-260704-0018','D','2026-07-04','14:04:36','kasir','PENJUALAN','F326040204361','6136487000','3568000','6140055000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040204361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040204361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040204361';
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 ('F326040219081','kasir','1',' TEF3 X UB ','TOKO','PT-F','F3TE-XDBG-79-T','GL X SIEM MODEL HATI MATA VAR UB 17K ','','1.830','1','100.00','3568000','0','0','15000','3568000','0','0','0','3568000','SIN','T0056729','F3TE','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-XDBG-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3TE-XDBG-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326040219081','2026-07-04','1.830','2026-07-04','14:19:08','PLG0030134','3568000','3568000','0','3568000','3568000','kasir','2026-07-04 14:19:08','F32604021908');
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-07-04','F326040219081','2026-07-04','14:19:08','SIN','3568000','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-260704-0020','D','2026-07-04','14:19:08','kasir','PENJUALAN','F326040219081','6136487000','3568000','6140055000');
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-00019551','X-00019551','CC MODEL ISYANA SLEP LG 16 8K','GR','---','E1E','BELI','BELI001','502000','2026-07-04','0.510','1','kasir','2026-07-04 14:22:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019551','X-00019551');
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-260704-0006','F326120222191','AAT','1','BELI','BELI001','E1E', 'X-00019551', 'CC MODEL ISYANA SLEP LG 16 8K','0.510','0.510','100.00','565000','502000','984314','1070000','1','502000','502000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0006','2026-07-04','2026-07-04','14:22:02','AAT','---','0.510','502000','502000','502000','502000','502000','kasir','2026-07-04 14:22:02','FB-260704-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0006','ANA','SENDANG PURWANTORO','','','081564762329','kasir','2026-07-04 14:22:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0021','K','2026-07-04','14:22:02','kasir','PEMBELIAN UMUM','FB-260704-0006','6140055000','502000','6139553000');
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-00019552','X-00019552','LT X SLOBOK BALOK HURUF BG S 8K','GR','---','D1F','BELI','BELI001','527000','2026-07-04','0.520','1','kasir','2026-07-04 14:23:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00019552','X-00019552');
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-260704-0007','F326120222195','AAT','1','BELI','BELI001','D1F', 'X-00019552', 'LT X SLOBOK BALOK HURUF BG S 8K','0.520','0.520','100.00','585000','527000','1013462','1080000','1','527000','527000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260704-0007','2026-07-04','2026-07-04','14:23:14','AAT','---','0.520','527000','527000','527000','527000','527000','kasir','2026-07-04 14:23:15','FB-260704-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0007','ANA','SENDANG PURWANTORO','','','081564762329','kasir','2026-07-04 14:23:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0022','K','2026-07-04','14:23:14','kasir','PEMBELIAN UMUM','FB-260704-0007','6139553000','527000','6139026000');
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-00019553','X-00019553','GL OVAL C SLEP UB 56 8K','GR','---','F1E','BELI','BELI001','2065000','2026-07-04','2.270','1','kasir','2026-07-04 14:24:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019553','X-00019553');
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-260704-0008','F326120222192','AAT','1','BELI','BELI001','F1E', 'X-00019553', 'GL OVAL C SLEP UB 56 8K','2.270','2.270','100.00','2508000','2065000','909692','1070000','1','2065000','2065000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.270',berat_beli_asli=berat_beli_asli+'2.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.270',berat_akhir_asli=berat_akhir_asli+'2.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0008','2026-07-04','2026-07-04','14:24:06','AAT','---','2.270','2065000','2065000','2065000','2065000','2065000','kasir','2026-07-04 14:24:06','FB-260704-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0008','ANA','SENDANG PURWANTORO','','','081564762329','kasir','2026-07-04 14:24:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0023','K','2026-07-04','14:24:06','kasir','PEMBELIAN UMUM','FB-260704-0008','6139026000','2065000','6136961000');
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-00019554','X-00019554','KL SANTA KH 42 8K','GR','---','H1E','BELI','BELI001','1486000','2026-07-04','1.510','1','kasir','2026-07-04 14:24:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019554','X-00019554');
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-260704-0009','F326120222194','AAT','1','BELI','BELI001','H1E', 'X-00019554', 'KL SANTA KH 42 8K','1.510','1.510','100.00','1670000','1486000','984106','1070000','1','1486000','1486000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.510',berat_beli_asli=berat_beli_asli+'1.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.510',berat_akhir_asli=berat_akhir_asli+'1.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' 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-260704-0009','2026-07-04','2026-07-04','14:24:25','AAT','---','1.510','1486000','1486000','1486000','1486000','1486000','kasir','2026-07-04 14:24:26','FB-260704-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0009','ANA','SENDANG PURWANTORO','','','081564762329','kasir','2026-07-04 14:24:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0024','K','2026-07-04','14:24:25','kasir','PEMBELIAN UMUM','FB-260704-0009','6136961000','1486000','6135475000');
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 ('F326040257191','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-YIBD-288-0','CC X MODEL MATA LG 13 8K ','','0.830','1','100.00','863000','0','0','15000','865000','0','0','0','865000','AAT','00370709','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBD-288-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E2D-YIBD-288-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326040257191','2026-07-04','0.830','2026-07-04','14:57:19','PLG0030135','865000','865000','0','865000','865000','kasir','2026-07-04 14:57:19','F32604025719');
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-07-04','F326040257191','2026-07-04','14:57:19','AAT','865000','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-260704-0025','D','2026-07-04','14:57:19','kasir','PENJUALAN','F326040257191','6135475000','865000','6136340000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040100091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040100091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040100091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040219081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040219081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040219081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040257191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040257191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040257191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326040859081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326040859081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326040859081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041005001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041005001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041005001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041008381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041008381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041008381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041022201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041022201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041022201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041047101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041047101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041047101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041223511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041223511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041223511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041223512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041223512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041223512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326041240541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326041240541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326041240541';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-04';
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-07-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-04' 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-260705-0001','D','2026-07-05','15:16:40','SYSTEM','SALDO AWAL','SALDO AWAL','0','6136340000','6136340000');
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-260705-0001','D','2026-07-05','15:16:40','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
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-260705-0001','D','2026-07-05','15:16:40','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-260705-0001','D','2026-07-05','15:16:40','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-05';
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-20260705-0001','1','D1E-ZFXC-86-0','1','0.500','0.500','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZFXC-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZFXC-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-07-05 17:09:20' WHERE kode_barang='D1E-ZFXC-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZFXC-86-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-07-05 17:09:20','TOKO','PM-D','D1E','D1E-ZFXC-86-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZFXC-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZFXC-86-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260705-0001','2026-07-05','17:09','0.500','admpindah','2026-07-04 17:09:19');
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-20260705-0001','1','E1D-ZFXC-104-0','1','1.060','1.060','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFXC-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFXC-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:35' WHERE kode_barang='E1D-ZFXC-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFXC-104-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-07-05 17:09:35','TOKO','PM-E','E1D','E1D-ZFXC-104-0','1','1.060','1.060','1','1.060','1.060','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-ZFXC-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFXC-104-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-20260705-0001','1','E1D-ZFBI-88-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFBI-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFBI-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:35' WHERE kode_barang='E1D-ZFBI-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFBI-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-05 17:09:35','TOKO','PM-E','E1D','E1D-ZFBI-88-0','1','1.020','1.020','1','1.020','1.020','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-ZFBI-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFBI-88-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260705-0001','1','E1E-ZGXD-1-0','1','0.750','0.750','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGXD-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGXD-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E1E-ZGXD-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGXD-1-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-07-05 17:09:36','TOKO','PM-E','E1E','E1E-ZGXD-1-0','1','0.750','0.750','1','0.750','0.750','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-ZGXD-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGXD-1-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-20260705-0001','1','E1E-ZGXD-2-0','1','0.750','0.750','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGXD-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGXD-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E1E-ZGXD-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGXD-2-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-07-05 17:09:36','TOKO','PM-E','E1E','E1E-ZGXD-2-0','1','0.750','0.750','1','0.750','0.750','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-ZGXD-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGXD-2-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-20260705-0001','1','E2D-ZGXD-16-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-16-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-16-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-16-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-20260705-0001','1','E2D-ZGXD-17-0','1','1.520','1.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-17-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-17-0','1','1.520','1.520','1','1.520','1.520','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-ZGXD-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-17-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-20260705-0001','1','E2D-ZGXD-18-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-18-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-18-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260705-0001','1','E2D-ZGXD-19-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-19-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-19-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-19-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-20260705-0001','1','E2D-ZGXD-20-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-20-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-20-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-20-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-20260705-0001','1','E2D-ZGXD-21-0','1','1.520','1.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-21-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-21-0','1','1.520','1.520','1','1.520','1.520','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-ZGXD-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-21-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-20260705-0001','1','E2D-ZGXD-22-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-22-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-22-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-22-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-20260705-0001','1','E2D-ZGXD-23-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-23-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-23-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-23-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-20260705-0001','1','E2D-ZGXD-24-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-24-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-24-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-24-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-20260705-0001','1','E2D-ZGXD-25-0','1','1.520','1.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-25-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-25-0','1','1.520','1.520','1','1.520','1.520','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-ZGXD-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-25-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-20260705-0001','1','E2D-ZGXD-26-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-26-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-26-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-26-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-20260705-0001','1','E2D-ZGXD-27-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-27-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-27-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-27-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-20260705-0001','1','E2D-ZGXD-28-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-28-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-28-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-28-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-20260705-0001','1','E2D-ZGXD-29-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-29-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-29-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-29-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-20260705-0001','1','E2D-ZGXD-30-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-30-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-30-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260705-0001','1','E2D-ZGXD-31-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-31-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-31-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-31-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-20260705-0001','1','E2D-ZGXD-32-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-32-0','1','1.530','1.530','1','1.530','1.530','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-ZGXD-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-32-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-20260705-0001','1','E2D-ZGXD-33-0','1','1.550','1.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGXD-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-05 17:09:36' WHERE kode_barang='E2D-ZGXD-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGXD-33-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-07-05 17:09:36','TOKO','PM-E','E2D','E2D-ZGXD-33-0','1','1.550','1.550','1','1.550','1.550','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-ZGXD-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGXD-33-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260705-0001','2026-07-05','17:09','31.210','admpindah','2026-07-04 17:09: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-20260705-0001','1','F2E-ZFXE-231-0','1','2.800','2.800','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZFXE-231-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZFXE-231-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-05 17:09:57' WHERE kode_barang='F2E-ZFXE-231-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZFXE-231-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-07-05 17:09:57','TOKO','PM-F','F2E','F2E-ZFXE-231-0','1','2.800','2.800','1','2.800','2.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZFXE-231-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZFXE-231-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260705-0001','2026-07-05','17:09','2.800','admpindah','2026-07-04 17:09:56');
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-20260705-0001','1','H1E-ZFBI-182-0','1','1.020','1.020','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFBI-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFBI-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-05 17:10:13' WHERE kode_barang='H1E-ZFBI-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFBI-182-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-07-05 17:10:13','TOKO','PM-H','H1E','H1E-ZFBI-182-0','1','1.020','1.020','1','1.020','1.020','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-ZFBI-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFBI-182-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260705-0001','2026-07-05','17:10','1.020','admpindah','2026-07-04 17:10:12');