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 ('F225110916071','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YIXB-15-T','GL MODEL FLIK CAPELA VAR HW 8K ','ol','1.700','1','100.00','1530000','0','0','15000','1547000','0','9000','0','1556000','NS','T0072759','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXB-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='F3E-YIXB-15-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 ('F225110916071','2025-09-11','1.700','2025-09-11','09:16:08','PLG0072536','1547000','1547000','9000','1556000','1556000','kasir','2025-09-11 09:16:07','F22511091607');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110916071','2025-09-11','09:16:08','NS','1556000','9000');
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-250911-0002','D','2025-09-11','09:16:08','kasir','PENJUALAN','F225110916071','185305000','1556000','186861000');
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 ('F225110925291','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YDBC-57-T','CC X MODEL SOLITAIRE MATA VAR CM 18 17K ','ol','2.510','1','100.00','3961000','0','0','15000','4048000','0','18000','0','4066000','RTA','T0068871','E2TD','0','0','-','0','1578000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YDBC-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E2TD-YDBC-57-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 ('F225110925291','2025-09-11','2.510','2025-09-11','09:25:30','PLG0072537','4048000','4048000','18000','4066000','4066000','kasir','2025-09-11 09:25:29','F22511092529');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110925291','2025-09-11','09:25:30','RTA','4066000','18000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0003','D','2025-09-11','09:25:30','kasir','PENJUALAN','F225110925291','186861000','4066000','190927000');
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 ('F225110927341','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YHAC-54-0','GL X RANTAI HOLLOW CD SLEP HW 8K ','ol','2.310','1','100.00','2079000','0','0','15000','2103000','0','12000','0','2115000','RTA','00365424','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAC-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='F3E-YHAC-54-0' 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 ('F225110927341','2025-09-11','2.310','2025-09-11','09:27:35','PLG0072538','2103000','2103000','12000','2115000','2115000','kasir','2025-09-11 09:27:34','F22511092734');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110927341','2025-09-11','09:27:35','RTA','2115000','12000');
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-250911-0004','D','2025-09-11','09:27:35','kasir','PENJUALAN','F225110927341','190927000','2115000','193042000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2115000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110927341' 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 ('F225110927342','kasir',' 1',' MED1 X BG ','TOKO','SMBK-D','D1E-YHBH-39-0','LT X MODEL SLEP BG 8K ','ol','0.680','1','100.00','612000','0','0','15000','622000','0','5000','0','627000','RTA','00367025','D1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YHBH-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='D1E-YHBH-39-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 ('F225110927342','2025-09-11','0.680','2025-09-11','09:27:35','PLG0072539','622000','622000','5000','627000','627000','kasir','2025-09-11 09:27:34','F22511092734');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110927342','2025-09-11','09:27:35','RTA','627000','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-250911-0005','D','2025-09-11','09:27:35','kasir','PENJUALAN','F225110927342','193042000','627000','193669000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='627000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110927342' 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 ('F225110928261','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIXB-32-T','CC WEDDING MATA CM 16 8K ','ol','2.020','1','100.00','1784000','0','0','15000','1828000','0','10000','0','1838000','RTA','T0072776','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E2D-YIXB-32-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 ('F225110928261','2025-09-11','2.020','2025-09-11','09:28:27','PLG0072540','1828000','1828000','10000','1838000','1838000','kasir','2025-09-11 09:28:26','F22511092826');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110928261','2025-09-11','09:28:27','RTA','1838000','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-250911-0006','D','2025-09-11','09:28:27','kasir','PENJUALAN','F225110928261','193669000','1838000','195507000');
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 ('F225110930501','kasir','1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YHBE-48-T','CC WEDDING MATA CM 12 8K ','ol','2.130','1','100.00','1881000','0','0','15000','1927000','0','11000','0','1938000','TIN','T0072533','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBE-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E2D-YHBE-48-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 ('F225110930501','2025-09-11','2.130','2025-09-11','09:30:50','PLG0072541','1927000','1927000','11000','1938000','1938000','kasir','2025-09-11 09:30:50','F22511093050');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110930501','2025-09-11','09:30:50','TIN','1938000','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-250911-0007','D','2025-09-11','09:30:50','kasir','PENJUALAN','F225110930501','195507000','1938000','197445000');
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 ('F225110934211','kasir','1',' MDE1 CM 20','TOKO','SMBK-E','E1D-YIXH-40-T','CC POLOS CM 20 8K ','ol','1.520','1','100.00','1342000','0','0','15000','1383000','0','8000','0','1391000','NS','T0073049','E1D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIXH-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E1D-YIXH-40-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 ('F225110934211','2025-09-11','1.520','2025-09-11','09:34:22','PLG0072542','1383000','1383000','8000','1391000','1391000','kasir','2025-09-11 09:34:21','F22511093421');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110934211','2025-09-11','09:34:22','NS','1391000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0008','D','2025-09-11','09:34:22','kasir','PENJUALAN','F225110934211','197445000','1391000','198836000');
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 ('F225111005451','kasir','1',' MFE1 UB 20','TOKO','SMBK-E','E1F-YHXH-62-T','CC MODEL BOTEGA VAR UB 20 8K ','','1.250','1','100.00','1146000','0','0','15000','1146000','0','0','0','1146000','NS','T0072162','E1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YHXH-62-T' 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='2025-09-11' AND kode_barang='E1F-YHXH-62-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 ('F225111005451','2025-09-11','1.250','2025-09-11','10:05:45','PLG0072543','1146000','1146000','0','1146000','1146000','kasir','2025-09-11 10:05:45','F22511100545');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111005451','2025-09-11','10:05:45','NS','1146000','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-250911-0009','D','2025-09-11','10:05:45','kasir','PENJUALAN','F225111005451','198836000','1146000','199982000');
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 ('F225111053081','kasir','1',' MFD1 CM ','TOKO','SMBK-D','D1F-YHXH-16-T','LT LETTERA PLAT CM 8K ','ol','0.530','1','100.00','486000','0','0','15000','495000','0','5000','0','500000','TIN','T0072116','D1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHXH-16-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-09-11' AND kode_barang='D1F-YHXH-16-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 ('F225111053081','2025-09-11','0.530','2025-09-11','10:53:09','PLG0072544','495000','495000','5000','500000','500000','kasir','2025-09-11 10:53:08','F22511105308');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111053081','2025-09-11','10:53:09','TIN','500000','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-250911-0010','D','2025-09-11','10:53:09','kasir','PENJUALAN','F225111053081','199982000','500000','200482000');
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 ('F225111058341','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YIXH-75-T','GW TUSUK MODEL MATA VAR LG PE 8K ','ol','0.600','1','100.00','540000','0','0','15000','550000','0','5000','0','555000','NS','T0073084','B1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-75-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-09-11' AND kode_barang='B1E-YIXH-75-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 ('F225111058341','2025-09-11','0.600','2025-09-11','10:58:34','PLG0072545','550000','550000','5000','555000','555000','kasir','2025-09-11 10:58:34','F22511105834');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111058341','2025-09-11','10:58:34','NS','555000','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-250911-0011','D','2025-09-11','10:58:34','kasir','PENJUALAN','F225111058341','200482000','555000','201037000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111058341' 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 ('F225111058342','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YIXH-78-T','GW TUSUK MODEL MATA VAR LG PE 8K ','ol','0.600','1','100.00','540000','0','0','15000','550000','0','5000','0','555000','NS','T0073087','B1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-78-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-09-11' AND kode_barang='B1E-YIXH-78-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 ('F225111058342','2025-09-11','0.600','2025-09-11','10:58:34','PLG0072546','550000','550000','5000','555000','555000','kasir','2025-09-11 10:58:34','F22511105834');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111058342','2025-09-11','10:58:34','NS','555000','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-250911-0012','D','2025-09-11','10:58:34','kasir','PENJUALAN','F225111058342','201037000','555000','201592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111058342' LIMIT 1;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-11 11:00:21');
CREATE TABLE th_20250911_110021 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250911_110021_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-11 11:00:25');
CREATE TABLE th_20250911_110025 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250911_110025_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-F' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '11:00:35',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-WIXF-293-0' AND kode_barcode='00252786';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-WIXF-293-0','00252786','2025-09-11',' 11:01:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-XEXC-147-0' AND kode_barcode='00296126';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-XEXC-147-0','00296126','2025-09-11',' 11:01:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-WHXA-229-0' AND kode_barcode='00246279';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-WHXA-229-0','00246279','2025-09-11',' 11:01:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YCBX-36-T' AND kode_barcode='T0068001';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YCBX-36-T','T0068001','2025-09-11',' 11:02:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YBAE-268-0' AND kode_barcode='00339328';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YBAE-268-0','00339328','2025-09-11',' 11:02:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YDBD-76-0' AND kode_barcode='00350702';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YDBD-76-0','00350702','2025-09-11',' 11:02:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YGAE-8-T' AND kode_barcode='T0070932';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YGAE-8-T','T0070932','2025-09-11',' 11:02:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDBD-49-0' AND kode_barcode='00350675';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDBD-49-0','00350675','2025-09-11',' 11:03:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XCXH-142-T' AND kode_barcode='T0055154';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XCXH-142-T','T0055154','2025-09-11',' 11:03:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXE-46-T' AND kode_barcode='T0071835';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXE-46-T','T0071835','2025-09-11',' 11:03:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1F-YEXA-55-T' AND kode_barcode='T0069108';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1F-YEXA-55-T','T0069108','2025-09-11',' 11:03:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XHBB-117-0' AND kode_barcode='00313268';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XHBB-117-0','00313268','2025-09-11',' 11:04:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XLAX-49-0' AND kode_barcode='00329449';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XLAX-49-0','00329449','2025-09-11',' 11:04:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFAH-15-T' AND kode_barcode='T0070203';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFAH-15-T','T0070203','2025-09-11',' 11:04:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCBI-45-0' AND kode_barcode='00346985';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCBI-45-0','00346985','2025-09-11',' 11:04:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGAE-10-T' AND kode_barcode='T0070934';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGAE-10-T','T0070934','2025-09-11',' 11:04:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGXB-71-T' AND kode_barcode='T0070651';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGXB-71-T','T0070651','2025-09-11',' 11:04:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXH-60-T' AND kode_barcode='T0073069';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXH-60-T','T0073069','2025-09-11',' 11:05:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXH-59-T' AND kode_barcode='T0073068';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXH-59-T','T0073068','2025-09-11',' 11:05:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXH-4-T' AND kode_barcode='T0072104';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXH-4-T','T0072104','2025-09-11',' 11:05:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXH-6-T' AND kode_barcode='T0072106';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXH-6-T','T0072106','2025-09-11',' 11:05:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXH-7-T' AND kode_barcode='T0072107';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXH-7-T','T0072107','2025-09-11',' 11:05:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-XFXF-144-0' AND kode_barcode='00301280';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-XFXF-144-0','00301280','2025-09-11',' 11:05:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YGXD-12-0' AND kode_barcode='00359328';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YGXD-12-0','00359328','2025-09-11',' 11:05:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFBX-124-0' AND kode_barcode='00358209';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFBX-124-0','00358209','2025-09-11',' 11:05:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YGXD-13-0' AND kode_barcode='00359329';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YGXD-13-0','00359329','2025-09-11',' 11:06:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1F-YFAC-21-0' AND kode_barcode='00357136';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1F-YFAC-21-0','00357136','2025-09-11',' 11:06:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YHBI-249-0' AND kode_barcode='00367490';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YHBI-249-0','00367490','2025-09-11',' 11:06:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XLAH-202-0' AND kode_barcode='00330652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XLAH-202-0','00330652','2025-09-11',' 11:06:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YEAD-277-0' AND kode_barcode='00353476';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YEAD-277-0','00353476','2025-09-11',' 11:06:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEBD-8-0' AND kode_barcode='00355094';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEBD-8-0','00355094','2025-09-11',' 11:06:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBH-9-0' AND kode_barcode='00366995';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBH-9-0','00366995','2025-09-11',' 11:06:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFXI-12-0' AND kode_barcode='00356757';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFXI-12-0','00356757','2025-09-11',' 11:06:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XHBD-83-0' AND kode_barcode='00313454';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XHBD-83-0','00313454','2025-09-11',' 11:06:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YECA-3-0' AND kode_barcode='00355863';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YECA-3-0','00355863','2025-09-11',' 11:06:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='00F1E-YFAC-11-0' AND kode_barcode='00357126';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('00F1E-YFAC-11-0','00357126','2025-09-11',' 11:06:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFAC-11-0' AND kode_barcode='00357126';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFAC-11-0','00357126','2025-09-11',' 11:07:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHAC-35-0' AND kode_barcode='00365405';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHAC-35-0','00365405','2025-09-11',' 11:07:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGAX-33-0' AND kode_barcode='00360427';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGAX-33-0','00360427','2025-09-11',' 11:07:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGAF-30-T' AND kode_barcode='T0070973';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGAF-30-T','T0070973','2025-09-11',' 11:09:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXE-8-T' AND kode_barcode='T0071797';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXE-8-T','T0071797','2025-09-11',' 11:09:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXH-21-T' AND kode_barcode='T0072121';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXH-21-T','T0072121','2025-09-11',' 11:10:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YFBD-63-T' AND kode_barcode='T0070283';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YFBD-63-T','T0070283','2025-09-11',' 11:11:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGAH-54-T' AND kode_barcode='T0071085';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGAH-54-T','T0071085','2025-09-11',' 11:11:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YHXD-14-T' AND kode_barcode='T0071774';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YHXD-14-T','T0071774','2025-09-11',' 11:11:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1F-YCCX-9-T' AND kode_barcode='T0068410';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1F-YCCX-9-T','T0068410','2025-09-11',' 11:11:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBE-23-T' AND kode_barcode='T0072508';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBE-23-T','T0072508','2025-09-11',' 11:12:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBE-20-T' AND kode_barcode='T0072505';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBE-20-T','T0072505','2025-09-11',' 11:12:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXB-25-T' AND kode_barcode='T0072769';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXB-25-T','T0072769','2025-09-11',' 11:12:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBE-22-T' AND kode_barcode='T0072507';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBE-22-T','T0072507','2025-09-11',' 11:12:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXB-26-T' AND kode_barcode='T0072770';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXB-26-T','T0072770','2025-09-11',' 11:12:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXD-8-T' AND kode_barcode='T0072860';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXD-8-T','T0072860','2025-09-11',' 11:12:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBE-19-T' AND kode_barcode='T0072504';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBE-19-T','T0072504','2025-09-11',' 11:13:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBE-21-T' AND kode_barcode='T0072506';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBE-21-T','T0072506','2025-09-11',' 11:13:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YGAH-53-T' AND kode_barcode='T0071084';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YGAH-53-T','T0071084','2025-09-11',' 11:13:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHBH-194-T' AND kode_barcode='T0072690';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHBH-194-T','T0072690','2025-09-11',' 11:13:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXF-13-T' AND kode_barcode='T0071905';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXF-13-T','T0071905','2025-09-11',' 11:13:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXF-14-T' AND kode_barcode='T0071906';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXF-14-T','T0071906','2025-09-11',' 11:13:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YIXD-7-T' AND kode_barcode='T0072859';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YIXD-7-T','T0072859','2025-09-11',' 11:14:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCAE-82-T' AND kode_barcode='T0067825';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCAE-82-T','T0067825','2025-09-11',' 11:14:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEAG-14-T' AND kode_barcode='T0069333';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEAG-14-T','T0069333','2025-09-11',' 11:14:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGCX-13-T' AND kode_barcode='T0071678';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGCX-13-T','T0071678','2025-09-11',' 11:14:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAF-25-T' AND kode_barcode='T0070968';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAF-25-T','T0070968','2025-09-11',' 11:15:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBI-63-T' AND kode_barcode='T0071596';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBI-63-T','T0071596','2025-09-11',' 11:16:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHAE-70-T' AND kode_barcode='T0072370';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHAE-70-T','T0072370','2025-09-11',' 11:16:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHAI-45-T' AND kode_barcode='T0072385';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHAI-45-T','T0072385','2025-09-11',' 11:16:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHAE-69-T' AND kode_barcode='T0072369';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHAE-69-T','T0072369','2025-09-11',' 11:16:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-85-T' AND kode_barcode='T0072072';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-85-T','T0072072','2025-09-11',' 11:17:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-84-T' AND kode_barcode='T0072071';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-84-T','T0072071','2025-09-11',' 11:18:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-83-T' AND kode_barcode='T0072070';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-83-T','T0072070','2025-09-11',' 11:18:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-25-T' AND kode_barcode='T0072125';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-25-T','T0072125','2025-09-11',' 11:18:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFXD-12-T' AND kode_barcode='T0069756';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFXD-12-T','T0069756','2025-09-11',' 11:20:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-26-T' AND kode_barcode='T0072126';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-26-T','T0072126','2025-09-11',' 11:20:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YGAB-10-T' AND kode_barcode='T0070893';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YGAB-10-T','T0070893','2025-09-11',' 11:21:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-14-T' AND kode_barcode='T0072499';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-14-T','T0072499','2025-09-11',' 11:21:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-13-T' AND kode_barcode='T0072498';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-13-T','T0072498','2025-09-11',' 11:22:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-22-T' AND kode_barcode='T0072122';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-22-T','T0072122','2025-09-11',' 11:22:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXD-6-T' AND kode_barcode='T0072858';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXD-6-T','T0072858','2025-09-11',' 11:23:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXF-7-T' AND kode_barcode='T0071899';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXF-7-T','T0071899','2025-09-11',' 11:23:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXF-8-T' AND kode_barcode='T0071900';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXF-8-T','T0071900','2025-09-11',' 11:23:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHXF-57-T' AND kode_barcode='T0071949';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHXF-57-T','T0071949','2025-09-11',' 11:24:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-9-T' AND kode_barcode='T0073018';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-9-T','T0073018','2025-09-11',' 11:24:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-7-T' AND kode_barcode='T0073016';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-7-T','T0073016','2025-09-11',' 11:24:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YIXH-3-T' AND kode_barcode='T0073012';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YIXH-3-T','T0073012','2025-09-11',' 11:24:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YIXH-1-T' AND kode_barcode='T0073010';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YIXH-1-T','T0073010','2025-09-11',' 11:25:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YIXH-2-T' AND kode_barcode='T0073011';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YIXH-2-T','T0073011','2025-09-11',' 11:25:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-5-T' AND kode_barcode='T0073014';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-5-T','T0073014','2025-09-11',' 11:26:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-4-T' AND kode_barcode='T0073013';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-4-T','T0073013','2025-09-11',' 11:26:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-80-T' AND kode_barcode='T0072067';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-80-T','T0072067','2025-09-11',' 11:27:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-81-T' AND kode_barcode='T0072068';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-81-T','T0072068','2025-09-11',' 11:27:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YGBB-72-T' AND kode_barcode='T0071344';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YGBB-72-T','T0071344','2025-09-11',' 11:28:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFXD-13-T' AND kode_barcode='T0069757';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFXD-13-T','T0069757','2025-09-11',' 11:30:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-24-T' AND kode_barcode='T0072509';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-24-T','T0072509','2025-09-11',' 11:31:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-WFBI-10-T' AND kode_barcode='T0045687';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-WFBI-10-T','T0045687','2025-09-11',' 11:33:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-36-T' AND kode_barcode='T0072136';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-36-T','T0072136','2025-09-11',' 11:33:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEXE-286-0' AND kode_barcode='00353169';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEXE-286-0','00353169','2025-09-11',' 11:34:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHXE-43-T' AND kode_barcode='T0071832';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHXE-43-T','T0071832','2025-09-11',' 11:34:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFXD-40-T' AND kode_barcode='T0069784';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFXD-40-T','T0069784','2025-09-11',' 11:34:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAG-119-0' AND kode_barcode='00361204';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAG-119-0','00361204','2025-09-11',' 11:34:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBB-84-0' AND kode_barcode='00366697';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBB-84-0','00366697','2025-09-11',' 11:34:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-21-T' AND kode_barcode='T0070904';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-21-T','T0070904','2025-09-11',' 11:34:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-26-T' AND kode_barcode='T0070909';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-26-T','T0070909','2025-09-11',' 11:34:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-24-T' AND kode_barcode='T0070907';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-24-T','T0070907','2025-09-11',' 11:35:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-22-T' AND kode_barcode='T0070905';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-22-T','T0070905','2025-09-11',' 11:35:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-20-T' AND kode_barcode='T0070903';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-20-T','T0070903','2025-09-11',' 11:35:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXB-82-T' AND kode_barcode='T0070662';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXB-82-T','T0070662','2025-09-11',' 11:35:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXB-92-T' AND kode_barcode='T0070672';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXB-92-T','T0070672','2025-09-11',' 11:35:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXB-17-T' AND kode_barcode='T0072761';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXB-17-T','T0072761','2025-09-11',' 11:35:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YECA-32-T' AND kode_barcode='T0069743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YECA-32-T','T0069743','2025-09-11',' 11:35:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEBD-15-T' AND kode_barcode='T0069518';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEBD-15-T','T0069518','2025-09-11',' 11:36:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBB-105-T' AND kode_barcode='T0071377';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBB-105-T','T0071377','2025-09-11',' 11:36:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YECA-72-0' AND kode_barcode='00355932';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YECA-72-0','00355932','2025-09-11',' 11:36:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBB-104-T' AND kode_barcode='T0071376';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBB-104-T','T0071376','2025-09-11',' 11:36:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEAE-114-0' AND kode_barcode='00353886';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEAE-114-0','00353886','2025-09-11',' 11:36:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDBC-17-T' AND kode_barcode='T0068831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDBC-17-T','T0068831','2025-09-11',' 11:36:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCBF-95-T' AND kode_barcode='T0068270';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCBF-95-T','T0068270','2025-09-11',' 11:36:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDAB-15-T' AND kode_barcode='T0068644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDAB-15-T','T0068644','2025-09-11',' 11:36:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDAB-14-T' AND kode_barcode='T0068643';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDAB-14-T','T0068643','2025-09-11',' 11:36:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-55-T' AND kode_barcode='T0072262';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-55-T','T0072262','2025-09-11',' 11:36:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCAG-207-0' AND kode_barcode='00343442';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCAG-207-0','00343442','2025-09-11',' 11:36:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-52-T' AND kode_barcode='T0072259';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-52-T','T0072259','2025-09-11',' 11:36:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-58-T' AND kode_barcode='T0072265';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-58-T','T0072265','2025-09-11',' 11:36:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAE-75-T' AND kode_barcode='T0072375';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAE-75-T','T0072375','2025-09-11',' 11:36:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-51-T' AND kode_barcode='T0072258';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-51-T','T0072258','2025-09-11',' 11:36:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='T0F3E-YHAB-54-T' AND kode_barcode='T0072261';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('T0F3E-YHAB-54-T','T0072261','2025-09-11',' 11:37:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-54-T' AND kode_barcode='T0072261';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-54-T','T0072261','2025-09-11',' 11:37:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAC-58-0' AND kode_barcode='00365428';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAC-58-0','00365428','2025-09-11',' 11:37:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDAB-13-T' AND kode_barcode='T0068642';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDAB-13-T','T0068642','2025-09-11',' 11:37:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBB-102-T' AND kode_barcode='T0071374';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBB-102-T','T0071374','2025-09-11',' 11:37:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEAI-106-0' AND kode_barcode='00354590';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEAI-106-0','00354590','2025-09-11',' 11:37:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBH-145-0' AND kode_barcode='00367131';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBH-145-0','00367131','2025-09-11',' 11:37:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXB-91-T' AND kode_barcode='T0070671';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXB-91-T','T0070671','2025-09-11',' 11:37:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCBF-99-T' AND kode_barcode='T0068274';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCBF-99-T','T0068274','2025-09-11',' 11:37:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHCX-32-T' AND kode_barcode='T0072743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHCX-32-T','T0072743','2025-09-11',' 11:37:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXB-81-T' AND kode_barcode='T0070661';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXB-81-T','T0070661','2025-09-11',' 11:37:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXE-42-T' AND kode_barcode='T0071831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXE-42-T','T0071831','2025-09-11',' 11:37:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAC-47-0' AND kode_barcode='00365417';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAC-47-0','00365417','2025-09-11',' 11:37:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBH-147-0' AND kode_barcode='00367133';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBH-147-0','00367133','2025-09-11',' 11:37:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAC-49-0' AND kode_barcode='00365419';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAC-49-0','00365419','2025-09-11',' 11:37:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YEXB-20-T' AND kode_barcode='T0069137';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YEXB-20-T','T0069137','2025-09-11',' 11:37:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YBXA-70-T' AND kode_barcode='T0066457';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YBXA-70-T','T0066457','2025-09-11',' 11:37:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YECA-116-0' AND kode_barcode='00355976';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YECA-116-0','00355976','2025-09-11',' 11:37:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEAI-89-0' AND kode_barcode='00354573';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEAI-89-0','00354573','2025-09-11',' 11:38:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-XIAG-221-0' AND kode_barcode='00317931';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-XIAG-221-0','00317931','2025-09-11',' 11:38:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXI-101-0' AND kode_barcode='00364965';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXI-101-0','00364965','2025-09-11',' 11:38:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBH-146-0' AND kode_barcode='00367132';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBH-146-0','00367132','2025-09-11',' 11:38:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAH-161-T' AND kode_barcode='T0071192';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAH-161-T','T0071192','2025-09-11',' 11:38:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAH-163-T' AND kode_barcode='T0071194';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAH-163-T','T0071194','2025-09-11',' 11:38:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFXD-42-T' AND kode_barcode='T0069786';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFXD-42-T','T0069786','2025-09-11',' 11:38:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFAB-28-T' AND kode_barcode='T0069967';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFAB-28-T','T0069967','2025-09-11',' 11:38:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFXD-41-T' AND kode_barcode='T0069785';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFXD-41-T','T0069785','2025-09-11',' 11:38:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-XKXB-243-0' AND kode_barcode='00324839';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-XKXB-243-0','00324839','2025-09-11',' 11:38:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-XHBD-148-0' AND kode_barcode='00313519';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-XHBD-148-0','00313519','2025-09-11',' 11:38:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAF-46-T' AND kode_barcode='T0070989';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAF-46-T','T0070989','2025-09-11',' 11:38:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFAD-296-0' AND kode_barcode='00357576';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFAD-296-0','00357576','2025-09-11',' 11:38:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAF-47-T' AND kode_barcode='T0070990';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAF-47-T','T0070990','2025-09-11',' 11:38:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEAE-101-0' AND kode_barcode='00353873';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEAE-101-0','00353873','2025-09-11',' 11:38:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHAE-47-0' AND kode_barcode='00365954';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHAE-47-0','00365954','2025-09-11',' 11:38:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YCAG-201-0' AND kode_barcode='00343436';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YCAG-201-0','00343436','2025-09-11',' 11:38:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHBE-31-T' AND kode_barcode='T0072516';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHBE-31-T','T0072516','2025-09-11',' 11:39:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHBE-29-T' AND kode_barcode='T0072514';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHBE-29-T','T0072514','2025-09-11',' 11:39:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHBE-28-T' AND kode_barcode='T0072513';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHBE-28-T','T0072513','2025-09-11',' 11:39:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHBE-30-T' AND kode_barcode='T0072515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHBE-30-T','T0072515','2025-09-11',' 11:39:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-XFAI-102-0' AND kode_barcode='00303196';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-XFAI-102-0','00303196','2025-09-11',' 11:39:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAH-162-T' AND kode_barcode='T0071193';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAH-162-T','T0071193','2025-09-11',' 11:39:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXB-80-T' AND kode_barcode='T0070660';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXB-80-T','T0070660','2025-09-11',' 11:39:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDXI-120-0' AND kode_barcode='00348376';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDXI-120-0','00348376','2025-09-11',' 11:39:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-50-T' AND kode_barcode='T0072037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-50-T','T0072037','2025-09-11',' 11:39:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBI-69-T' AND kode_barcode='T0071602';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBI-69-T','T0071602','2025-09-11',' 11:39:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAE-79-T' AND kode_barcode='T0072379';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAE-79-T','T0072379','2025-09-11',' 11:39:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXE-47-T' AND kode_barcode='T0071836';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXE-47-T','T0071836','2025-09-11',' 11:39:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGXI-43-T' AND kode_barcode='T0070857';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGXI-43-T','T0070857','2025-09-11',' 11:39:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAE-80-T' AND kode_barcode='T0072380';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAE-80-T','T0072380','2025-09-11',' 11:39:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBI-18-T' AND kode_barcode='T0071551';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBI-18-T','T0071551','2025-09-11',' 11:39:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEXC-45-T' AND kode_barcode='T0069235';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEXC-45-T','T0069235','2025-09-11',' 11:39:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXE-39-T' AND kode_barcode='T0071828';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXE-39-T','T0071828','2025-09-11',' 11:39:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEXA-18-T' AND kode_barcode='T0069071';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEXA-18-T','T0069071','2025-09-11',' 11:39:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEBD-253-0' AND kode_barcode='00355340';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEBD-253-0','00355340','2025-09-11',' 11:40:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDBC-16-T' AND kode_barcode='T0068830';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDBC-16-T','T0068830','2025-09-11',' 11:40:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCXG-35-0' AND kode_barcode='00342232';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCXG-35-0','00342232','2025-09-11',' 11:40:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAF-45-T' AND kode_barcode='T0070988';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAF-45-T','T0070988','2025-09-11',' 11:40:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-57-T' AND kode_barcode='T0072264';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-57-T','T0072264','2025-09-11',' 11:40:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBF-11-T' AND kode_barcode='T0072574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBF-11-T','T0072574','2025-09-11',' 11:40:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-61-T' AND kode_barcode='T0072268';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-61-T','T0072268','2025-09-11',' 11:40:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAC-52-0' AND kode_barcode='00365422';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAC-52-0','00365422','2025-09-11',' 11:40:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEXA-60-T' AND kode_barcode='T0069113';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEXA-60-T','T0069113','2025-09-11',' 11:40:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-59-T' AND kode_barcode='T0072266';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-59-T','T0072266','2025-09-11',' 11:40:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFBX-173-0' AND kode_barcode='00358258';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFBX-173-0','00358258','2025-09-11',' 11:40:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-35-T' AND kode_barcode='T0072135';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-35-T','T0072135','2025-09-11',' 11:40:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXH-34-T' AND kode_barcode='T0072134';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXH-34-T','T0072134','2025-09-11',' 11:40:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFAI-14-T' AND kode_barcode='T0070217';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFAI-14-T','T0070217','2025-09-11',' 11:43:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YFAI-15-T' AND kode_barcode='T0070218';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YFAI-15-T','T0070218','2025-09-11',' 11:43:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YGBA-87-0' AND kode_barcode='00361968';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YGBA-87-0','00361968','2025-09-11',' 11:43:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YCAI-170-0' AND kode_barcode='00344061';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YCAI-170-0','00344061','2025-09-11',' 11:43:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDAH-83-T' AND kode_barcode='T0068769';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDAH-83-T','T0068769','2025-09-11',' 11:43:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBA-82-0' AND kode_barcode='00361963';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBA-82-0','00361963','2025-09-11',' 11:43:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBA-85-0' AND kode_barcode='00361966';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBA-85-0','00361966','2025-09-11',' 11:43:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-40-T' AND kode_barcode='T0072247';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-40-T','T0072247','2025-09-11',' 11:43:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-38-T' AND kode_barcode='T0072245';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-38-T','T0072245','2025-09-11',' 11:43:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAH-158-T' AND kode_barcode='T0071189';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAH-158-T','T0071189','2025-09-11',' 11:43:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-34-T' AND kode_barcode='T0072519';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-34-T','T0072519','2025-09-11',' 11:43:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBA-81-0' AND kode_barcode='00361962';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBA-81-0','00361962','2025-09-11',' 11:43:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-XEAE-33-0' AND kode_barcode='00298187';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-XEAE-33-0','00298187','2025-09-11',' 11:43:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBF-15-T' AND kode_barcode='T0072578';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBF-15-T','T0072578','2025-09-11',' 11:44:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBF-13-T' AND kode_barcode='T0072576';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBF-13-T','T0072576','2025-09-11',' 11:44:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-65-T' AND kode_barcode='T0073074';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-65-T','T0073074','2025-09-11',' 11:44:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-66-T' AND kode_barcode='T0073075';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-66-T','T0073075','2025-09-11',' 11:44:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBB-109-T' AND kode_barcode='T0071381';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBB-109-T','T0071381','2025-09-11',' 11:44:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGBB-106-T' AND kode_barcode='T0071378';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGBB-106-T','T0071378','2025-09-11',' 11:44:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-36-T' AND kode_barcode='T0072521';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-36-T','T0072521','2025-09-11',' 11:44:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-WIBX-166-0' AND kode_barcode='00254937';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-WIBX-166-0','00254937','2025-09-11',' 11:44:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3G-YHAB-50-T' AND kode_barcode='T0072257';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3G-YHAB-50-T','T0072257','2025-09-11',' 11:44:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3G-YHAB-44-T' AND kode_barcode='T0072251';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3G-YHAB-44-T','T0072251','2025-09-11',' 11:44:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='T0F3G-YHAB-42-T' AND kode_barcode='T0072249';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('T0F3G-YHAB-42-T','T0072249','2025-09-11',' 11:44:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3G-YHAB-42-T' AND kode_barcode='T0072249';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3G-YHAB-42-T','T0072249','2025-09-11',' 11:44:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3G-YHAB-41-T' AND kode_barcode='T0072248';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3G-YHAB-41-T','T0072248','2025-09-11',' 11:44:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHXH-69-T' AND kode_barcode='T0072169';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHXH-69-T','T0072169','2025-09-11',' 11:45:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YGAF-77-0' AND kode_barcode='00360901';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YGAF-77-0','00360901','2025-09-11',' 11:45:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YGAF-78-0' AND kode_barcode='00360902';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YGAF-78-0','00360902','2025-09-11',' 11:45:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YIXC-10-T' AND kode_barcode='T0072825';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YIXC-10-T','T0072825','2025-09-11',' 11:45:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3H-YHXH-32-T' AND kode_barcode='T0072132';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3H-YHXH-32-T','T0072132','2025-09-11',' 11:45:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YFBD-68-T' AND kode_barcode='T0070288';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YFBD-68-T','T0070288','2025-09-11',' 11:45:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YGAB-19-T' AND kode_barcode='T0070902';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YGAB-19-T','T0070902','2025-09-11',' 11:45:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YGAB-18-T' AND kode_barcode='T0070901';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YGAB-18-T','T0070901','2025-09-11',' 11:45:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YGBD-101-0' AND kode_barcode='00362339';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YGBD-101-0','00362339','2025-09-11',' 11:45:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4J-YHBE-32-T' AND kode_barcode='T0072517';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4J-YHBE-32-T','T0072517','2025-09-11',' 11:45:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YGBI-67-T' AND kode_barcode='T0071600';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YGBI-67-T','T0071600','2025-09-11',' 11:45:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YCBD-68-0' AND kode_barcode='00344861';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YCBD-68-0','00344861','2025-09-11',' 11:45:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F4I-YCAH-51-T' AND kode_barcode='T0067895';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F4I-YCAH-51-T','T0067895','2025-09-11',' 11:45:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEBA-5-T' AND kode_barcode='T0069426';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEBA-5-T','T0069426','2025-09-11',' 11:46:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YEBA-3-T' AND kode_barcode='T0069424';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YEBA-3-T','T0069424','2025-09-11',' 11:46:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCBX-50-T' AND kode_barcode='T0068015';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCBX-50-T','T0068015','2025-09-11',' 11:46:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCBF-94-T' AND kode_barcode='T0068269';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCBF-94-T','T0068269','2025-09-11',' 11:46:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YCBX-55-T' AND kode_barcode='T0068020';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YCBX-55-T','T0068020','2025-09-11',' 11:46:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXD-13-T' AND kode_barcode='T0071773';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXD-13-T','T0071773','2025-09-11',' 11:46:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFBD-58-T' AND kode_barcode='T0070278';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFBD-58-T','T0070278','2025-09-11',' 11:46:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDAH-77-T' AND kode_barcode='T0068763';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDAH-77-T','T0068763','2025-09-11',' 11:46:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YECA-1-T' AND kode_barcode='T0069712';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YECA-1-T','T0069712','2025-09-11',' 11:47:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGBD-24-T' AND kode_barcode='T0071452';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGBD-24-T','T0071452','2025-09-11',' 11:47:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGBD-23-T' AND kode_barcode='T0071451';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGBD-23-T','T0071451','2025-09-11',' 11:47:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGBD-26-T' AND kode_barcode='T0071454';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGBD-26-T','T0071454','2025-09-11',' 11:47:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGBD-25-T' AND kode_barcode='T0071453';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGBD-25-T','T0071453','2025-09-11',' 11:47:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCBE-132-0' AND kode_barcode='00345294';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCBE-132-0','00345294','2025-09-11',' 11:47:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEXE-15-0' AND kode_barcode='00352898';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEXE-15-0','00352898','2025-09-11',' 11:47:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEXE-14-0' AND kode_barcode='00352897';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEXE-14-0','00352897','2025-09-11',' 11:47:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XJBH-71-0' AND kode_barcode='00324352';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XJBH-71-0','00324352','2025-09-11',' 11:47:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XIBG-72-0' AND kode_barcode='00319331';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XIBG-72-0','00319331','2025-09-11',' 11:47:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XKAC-131-0' AND kode_barcode='00326018';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XKAC-131-0','00326018','2025-09-11',' 11:47:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDAE-9-T' AND kode_barcode='T0068669';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDAE-9-T','T0068669','2025-09-11',' 11:48:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCXC-271-0' AND kode_barcode='00341310';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCXC-271-0','00341310','2025-09-11',' 11:48:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEXG-40-0' AND kode_barcode='00353394';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEXG-40-0','00353394','2025-09-11',' 11:48:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XLAX-67-0' AND kode_barcode='00329467';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XLAX-67-0','00329467','2025-09-11',' 11:48:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCBX-32-T' AND kode_barcode='T0067997';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCBX-32-T','T0067997','2025-09-11',' 11:48:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXF-33-T' AND kode_barcode='T0071925';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXF-33-T','T0071925','2025-09-11',' 11:48:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXF-32-T' AND kode_barcode='T0071924';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXF-32-T','T0071924','2025-09-11',' 11:48:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDAE-8-T' AND kode_barcode='T0068668';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDAE-8-T','T0068668','2025-09-11',' 11:48:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFXC-275-0' AND kode_barcode='00356293';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFXC-275-0','00356293','2025-09-11',' 11:48:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCBX-29-T' AND kode_barcode='T0067994';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCBX-29-T','T0067994','2025-09-11',' 11:48:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDCX-186-0' AND kode_barcode='00351438';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDCX-186-0','00351438','2025-09-11',' 11:48:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YDAE-12-T' AND kode_barcode='T0068672';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YDAE-12-T','T0068672','2025-09-11',' 11:48:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YEBH-24-T' AND kode_barcode='T0069628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YEBH-24-T','T0069628','2025-09-11',' 11:48:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGXE-20-T' AND kode_barcode='T0070800';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGXE-20-T','T0070800','2025-09-11',' 11:48:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XDXD-51-T' AND kode_barcode='T0056006';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XDXD-51-T','T0056006','2025-09-11',' 11:49:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YGXE-19-T' AND kode_barcode='T0070799';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YGXE-19-T','T0070799','2025-09-11',' 11:49:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XLXC-175-T' AND kode_barcode='T0064568';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XLXC-175-T','T0064568','2025-09-11',' 11:49:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-XLXC-176-T' AND kode_barcode='T0064569';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-XLXC-176-T','T0064569','2025-09-11',' 11:49:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1F-YHAD-293-0' AND kode_barcode='00365907';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1F-YHAD-293-0','00365907','2025-09-11',' 11:49:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YFBX-127-0' AND kode_barcode='00358212';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YFBX-127-0','00358212','2025-09-11',' 11:49:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YEAI-69-0' AND kode_barcode='00354553';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YEAI-69-0','00354553','2025-09-11',' 11:49:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-YDXI-24-T' AND kode_barcode='T0068547';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-YDXI-24-T','T0068547','2025-09-11',' 11:49:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F2E-WEXB-21-T' AND kode_barcode='T0043832';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F2E-WEXB-21-T','T0043832','2025-09-11',' 11:49:41','1','kasir');
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 ('F225111150211','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-YHXH-19-T','GL OVAL MODEL C UB D54 8K','ol ','2.270','1','100.00','2043000','0','0','15000','2066000','0','11000','0','2077000','RHM','T0072119','F1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHXH-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='F1E-YHXH-19-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 ('F225111150211','2025-09-11','2.270','2025-09-11','11:50:22','PLG0072547','2066000','2066000','11000','2077000','2077000','kasir','2025-09-11 11:50:21','F22511115021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111150211','2025-09-11','11:50:22','RHM','2077000','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-250911-0013','D','2025-09-11','11:50:22','kasir','PENJUALAN','F225111150211','201592000','2077000','203669000');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-F' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '11:50:46',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YCBH-27-T' AND kode_barcode='T0068373';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YCBH-27-T','T0068373','2025-09-11',' 11:51:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXA-44-0' AND kode_barcode='00367622';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXA-44-0','00367622','2025-09-11',' 11:51:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXH-62-T' AND kode_barcode='T0073071';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXH-62-T','T0073071','2025-09-11',' 11:51:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F1E-YHXF-12-T' AND kode_barcode='T0071904';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F1E-YHXF-12-T','T0071904','2025-09-11',' 11:51:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXD-2-T' AND kode_barcode='T0072854';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXD-2-T','T0072854','2025-09-11',' 11:51:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXG-345-0' AND kode_barcode='00364394';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXG-345-0','00364394','2025-09-11',' 11:52:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHBE-15-T' AND kode_barcode='T0072500';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHBE-15-T','T0072500','2025-09-11',' 11:52:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-XIBE-280-0' AND kode_barcode='00318970';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-XIBE-280-0','00318970','2025-09-11',' 11:52:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YBBF-102-0' AND kode_barcode='00340494';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YBBF-102-0','00340494','2025-09-11',' 11:52:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFBX-174-0' AND kode_barcode='00358259';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFBX-174-0','00358259','2025-09-11',' 11:52:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-XAAC-218-0' AND kode_barcode='00274797';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-XAAC-218-0','00274797','2025-09-11',' 11:52:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAX-61-0' AND kode_barcode='00360455';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAX-61-0','00360455','2025-09-11',' 11:52:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-XABF-118-0' AND kode_barcode='00277194';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-XABF-118-0','00277194','2025-09-11',' 11:52:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YDAI-40-0' AND kode_barcode='00349950';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YDAI-40-0','00349950','2025-09-11',' 11:52:46','1','kasir');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-F' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '11:53:47',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHAB-45-T' AND kode_barcode='T0072252';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHAB-45-T','T0072252','2025-09-11',' 11:53:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHAB-49-T' AND kode_barcode='T0072256';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHAB-49-T','T0072256','2025-09-11',' 11:53:54','1','kasir');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-F' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '11:55:16',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAB-23-T' AND kode_barcode='T0070906';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAB-23-T','T0070906','2025-09-11',' 11:55:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAB-56-T' AND kode_barcode='T0072263';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAB-56-T','T0072263','2025-09-11',' 11:55:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHXE-37-T' AND kode_barcode='T0071826';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHXE-37-T','T0071826','2025-09-11',' 11:56:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YIXB-16-T' AND kode_barcode='T0072760';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YIXB-16-T','T0072760','2025-09-11',' 11:56:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YHBB-83-0' AND kode_barcode='00366696';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YHBB-83-0','00366696','2025-09-11',' 11:56:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3F-YEAI-107-0' AND kode_barcode='00354591';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3F-YEAI-107-0','00354591','2025-09-11',' 11:56:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YHAC-69-0' AND kode_barcode='00365439';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YHAC-69-0','00365439','2025-09-11',' 11:56:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFAD-298-0' AND kode_barcode='00357578';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFAD-298-0','00357578','2025-09-11',' 11:56:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YGAG-140-0' AND kode_barcode='00361225';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YGAG-140-0','00361225','2025-09-11',' 11:57:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='F3E-YFBX-172-0' AND kode_barcode='00358257';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('F3E-YFBX-172-0','00358257','2025-09-11',' 11:57:25','1','kasir');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110916071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110916071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110916071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110925291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110925291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110925291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110927341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110927341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110927341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110927342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110927342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110927342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110928261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110928261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110928261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110930501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110930501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110930501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110934211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111005451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111005451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111005451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111053081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111053081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111053081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111058341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111058341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111058341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111058342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111058342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111058342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111150211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111150211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111150211';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-11 12:02:43');
CREATE TABLE th_20250911_120243 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250911_120243_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-11 12:02:48');
CREATE TABLE th_20250911_120248 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250911_120248_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-H' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '12:03:00',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XDAB-85-0' AND kode_barcode='00292516';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XDAB-85-0','00292516','2025-09-11',' 12:03:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XCAI-176-0' AND kode_barcode='00286761';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XCAI-176-0','00286761','2025-09-11',' 12:03:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YGCA-15-T' AND kode_barcode='T0071749';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YGCA-15-T','T0071749','2025-09-11',' 12:03:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YHBE-78-T' AND kode_barcode='T0072563';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YHBE-78-T','T0072563','2025-09-11',' 12:03:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YHBE-77-T' AND kode_barcode='T0072562';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YHBE-77-T','T0072562','2025-09-11',' 12:03:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXE-60-T' AND kode_barcode='T0071849';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXE-60-T','T0071849','2025-09-11',' 12:04:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YEBD-178-0' AND kode_barcode='00355265';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YEBD-178-0','00355265','2025-09-11',' 12:04:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YIXB-14-T' AND kode_barcode='T0072758';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YIXB-14-T','T0072758','2025-09-11',' 12:04:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGAF-56-T' AND kode_barcode='T0070999';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGAF-56-T','T0070999','2025-09-11',' 12:04:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YIXB-13-T' AND kode_barcode='T0072757';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YIXB-13-T','T0072757','2025-09-11',' 12:04:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YBAC-50-0' AND kode_barcode='00338880';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YBAC-50-0','00338880','2025-09-11',' 12:04:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XCBG-37-T' AND kode_barcode='T0055783';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XCBG-37-T','T0055783','2025-09-11',' 12:04:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XCBH-89-0' AND kode_barcode='00288302';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XCBH-89-0','00288302','2025-09-11',' 12:04:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XLBA-17-T' AND kode_barcode='T0065250';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XLBA-17-T','T0065250','2025-09-11',' 12:04:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YEXC-204-0' AND kode_barcode='00352515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YEXC-204-0','00352515','2025-09-11',' 12:04:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGXD-87-0' AND kode_barcode='00359403';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGXD-87-0','00359403','2025-09-11',' 12:04:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YEAI-153-0' AND kode_barcode='00354637';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YEAI-153-0','00354637','2025-09-11',' 12:05:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBE-65-T' AND kode_barcode='T0072550';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBE-65-T','T0072550','2025-09-11',' 12:05:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-XEAG-78-T' AND kode_barcode='T0057243';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-XEAG-78-T','T0057243','2025-09-11',' 12:05:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-XHBD-27-0' AND kode_barcode='00313398';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-XHBD-27-0','00313398','2025-09-11',' 12:05:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEAD-477-0' AND kode_barcode='00353676';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEAD-477-0','00353676','2025-09-11',' 12:05:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-XGAI-55-0' AND kode_barcode='00308205';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-XGAI-55-0','00308205','2025-09-11',' 12:05:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEAD-509-0' AND kode_barcode='00353708';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEAD-509-0','00353708','2025-09-11',' 12:05:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBX-196-0' AND kode_barcode='00366474';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBX-196-0','00366474','2025-09-11',' 12:05:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEBD-164-0' AND kode_barcode='00355251';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEBD-164-0','00355251','2025-09-11',' 12:05:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YDXI-217-0' AND kode_barcode='00348473';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YDXI-217-0','00348473','2025-09-11',' 12:05:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEAD-511-0' AND kode_barcode='00353710';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEAD-511-0','00353710','2025-09-11',' 12:05:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YDBI-153-0' AND kode_barcode='00351250';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YDBI-153-0','00351250','2025-09-11',' 12:05:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEXC-190-0' AND kode_barcode='00352501';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEXC-190-0','00352501','2025-09-11',' 12:05:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YDXC-179-0' AND kode_barcode='00347886';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YDXC-179-0','00347886','2025-09-11',' 12:06:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YDCX-56-0' AND kode_barcode='00351308';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YDCX-56-0','00351308','2025-09-11',' 12:06:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-XDAH-16-T' AND kode_barcode='T0056449';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-XDAH-16-T','T0056449','2025-09-11',' 12:06:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAI-84-T' AND kode_barcode='T0072424';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAI-84-T','T0072424','2025-09-11',' 12:06:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YBAB-54-T' AND kode_barcode='T0066835';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YBAB-54-T','T0066835','2025-09-11',' 12:06:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAB-37-T' AND kode_barcode='T0072244';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAB-37-T','T0072244','2025-09-11',' 12:06:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YBAB-4-0' AND kode_barcode='00338557';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YBAB-4-0','00338557','2025-09-11',' 12:06:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBC-39-0' AND kode_barcode='00366743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBC-39-0','00366743','2025-09-11',' 12:06:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBE-60-T' AND kode_barcode='T0072545';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBE-60-T','T0072545','2025-09-11',' 12:06:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-47-T' AND kode_barcode='T0071939';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-47-T','T0071939','2025-09-11',' 12:06:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-49-T' AND kode_barcode='T0071941';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-49-T','T0071941','2025-09-11',' 12:06:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-55-T' AND kode_barcode='T0071947';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-55-T','T0071947','2025-09-11',' 12:06:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-46-T' AND kode_barcode='T0071938';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-46-T','T0071938','2025-09-11',' 12:06:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-52-T' AND kode_barcode='T0071944';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-52-T','T0071944','2025-09-11',' 12:06:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-54-T' AND kode_barcode='T0071946';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-54-T','T0071946','2025-09-11',' 12:06:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WJXI-231-0' AND kode_barcode='00258439';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WJXI-231-0','00258439','2025-09-11',' 12:07:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YEXC-193-0' AND kode_barcode='00352504';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YEXC-193-0','00352504','2025-09-11',' 12:07:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBE-74-T' AND kode_barcode='T0072559';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBE-74-T','T0072559','2025-09-11',' 12:07:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-XDXF-54-T' AND kode_barcode='T0056082';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-XDXF-54-T','T0056082','2025-09-11',' 12:07:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YEXC-535-0' AND kode_barcode='00352846';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YEXC-535-0','00352846','2025-09-11',' 12:07:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WIXD-74-0' AND kode_barcode='00252093';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WIXD-74-0','00252093','2025-09-11',' 12:08:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-XJBH-274-0' AND kode_barcode='00324555';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-XJBH-274-0','00324555','2025-09-11',' 12:08:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBA-21-T' AND kode_barcode='T0072451';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBA-21-T','T0072451','2025-09-11',' 12:08:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHAE-23-0' AND kode_barcode='00365930';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHAE-23-0','00365930','2025-09-11',' 12:08:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YCBD-91-0' AND kode_barcode='00344884';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YCBD-91-0','00344884','2025-09-11',' 12:08:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBE-76-T' AND kode_barcode='T0072561';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBE-76-T','T0072561','2025-09-11',' 12:08:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBE-67-T' AND kode_barcode='T0072552';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBE-67-T','T0072552','2025-09-11',' 12:08:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXG-41-T' AND kode_barcode='T0072028';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXG-41-T','T0072028','2025-09-11',' 12:08:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YHBX-17-0' AND kode_barcode='00366295';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YHBX-17-0','00366295','2025-09-11',' 12:08:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YFXI-130-0' AND kode_barcode='00356875';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YFXI-130-0','00356875','2025-09-11',' 12:09:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBE-68-T' AND kode_barcode='T0072553';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBE-68-T','T0072553','2025-09-11',' 12:09:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YGBD-121-0' AND kode_barcode='00362359';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YGBD-121-0','00362359','2025-09-11',' 12:09:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YEBH-25-T' AND kode_barcode='T0069629';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YEBH-25-T','T0069629','2025-09-11',' 12:09:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YECA-45-0' AND kode_barcode='00355905';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YECA-45-0','00355905','2025-09-11',' 12:09:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YFAC-43-0' AND kode_barcode='00357158';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YFAC-43-0','00357158','2025-09-11',' 12:10:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YGBD-115-0' AND kode_barcode='00362353';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YGBD-115-0','00362353','2025-09-11',' 12:10:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YIXH-69-T' AND kode_barcode='T0073078';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YIXH-69-T','T0073078','2025-09-11',' 12:10:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YIXH-68-T' AND kode_barcode='T0073077';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YIXH-68-T','T0073077','2025-09-11',' 12:10:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YIXH-67-T' AND kode_barcode='T0073076';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YIXH-67-T','T0073076','2025-09-11',' 12:10:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-WJAC-80-0' AND kode_barcode='00258948';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-WJAC-80-0','00258948','2025-09-11',' 12:10:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBE-62-T' AND kode_barcode='T0072547';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBE-62-T','T0072547','2025-09-11',' 12:10:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGXA-87-T' AND kode_barcode='T0070607';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGXA-87-T','T0070607','2025-09-11',' 12:11:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBE-63-T' AND kode_barcode='T0072548';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBE-63-T','T0072548','2025-09-11',' 12:11:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YEBB-60-0' AND kode_barcode='00354951';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YEBB-60-0','00354951','2025-09-11',' 12:11:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WAAF-234-0' AND kode_barcode='00208509';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WAAF-234-0','00208509','2025-09-11',' 12:11:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YHAC-102-0' AND kode_barcode='00365472';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YHAC-102-0','00365472','2025-09-11',' 12:11:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAI-80-T' AND kode_barcode='T0072420';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAI-80-T','T0072420','2025-09-11',' 12:11:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WCAX-191-0' AND kode_barcode='00217935';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WCAX-191-0','00217935','2025-09-11',' 12:11:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YHAC-126-0' AND kode_barcode='00365497';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YHAC-126-0','00365497','2025-09-11',' 12:11:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YHBI-303-0' AND kode_barcode='00367544';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YHBI-303-0','00367544','2025-09-11',' 12:11:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAE-22-0' AND kode_barcode='00365929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAE-22-0','00365929','2025-09-11',' 12:11:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YHXG-451-0' AND kode_barcode='00364501';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YHXG-451-0','00364501','2025-09-11',' 12:11:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-YCAG-90-0' AND kode_barcode='00343325';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-YCAG-90-0','00343325','2025-09-11',' 12:12:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YBXE-7-0' AND kode_barcode='00337649';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YBXE-7-0','00337649','2025-09-11',' 12:12:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAI-79-T' AND kode_barcode='T0072419';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAI-79-T','T0072419','2025-09-11',' 12:12:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YAAG-196-0' AND kode_barcode='00334763';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YAAG-196-0','00334763','2025-09-11',' 12:12:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WFBD-72-0' AND kode_barcode='00239820';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WFBD-72-0','00239820','2025-09-11',' 12:12:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WLXA-195-0' AND kode_barcode='00267004';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WLXA-195-0','00267004','2025-09-11',' 12:12:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YGAE-17-T' AND kode_barcode='T0070941';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YGAE-17-T','T0070941','2025-09-11',' 12:12:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YFXI-129-0' AND kode_barcode='00356874';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YFXI-129-0','00356874','2025-09-11',' 12:12:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBH-100-0' AND kode_barcode='00367086';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBH-100-0','00367086','2025-09-11',' 12:12:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YBXG-41-0' AND kode_barcode='00337961';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YBXG-41-0','00337961','2025-09-11',' 12:12:48','1','kasir');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-H' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '12:14:50',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-XHXI-99-T' AND kode_barcode='T0060374';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-XHXI-99-T','T0060374','2025-09-11',' 12:15:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-WHAG-389-0' AND kode_barcode='00249417';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-WHAG-389-0','00249417','2025-09-11',' 12:15:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-WHXB-34-T' AND kode_barcode='T0046912';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-WHXB-34-T','T0046912','2025-09-11',' 12:15:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBE-64-T' AND kode_barcode='T0072549';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBE-64-T','T0072549','2025-09-11',' 12:16:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGAF-22-T' AND kode_barcode='T0070965';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGAF-22-T','T0070965','2025-09-11',' 12:16:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XGXI-248-0' AND kode_barcode='00306862';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XGXI-248-0','00306862','2025-09-11',' 12:16:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YDAE-12-0' AND kode_barcode='00349481';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YDAE-12-0','00349481','2025-09-11',' 12:17:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YFXD-14-T' AND kode_barcode='T0069758';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YFXD-14-T','T0069758','2025-09-11',' 12:17:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-23-T' AND kode_barcode='T0071915';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-23-T','T0071915','2025-09-11',' 12:17:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHBE-26-T' AND kode_barcode='T0072511';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHBE-26-T','T0072511','2025-09-11',' 12:17:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHXF-26-T' AND kode_barcode='T0071918';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHXF-26-T','T0071918','2025-09-11',' 12:17:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXH-17-T' AND kode_barcode='T0072117';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXH-17-T','T0072117','2025-09-11',' 12:18:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-YHXF-28-T' AND kode_barcode='T0071920';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-YHXF-28-T','T0071920','2025-09-11',' 12:18:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-XLAD-3-0' AND kode_barcode='00329820';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-XLAD-3-0','00329820','2025-09-11',' 12:18:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YABB-425-0' AND kode_barcode='00335800';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YABB-425-0','00335800','2025-09-11',' 12:18:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXG-468-0' AND kode_barcode='00364518';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXG-468-0','00364518','2025-09-11',' 12:18:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YFXI-121-0' AND kode_barcode='00356866';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YFXI-121-0','00356866','2025-09-11',' 12:19:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAI-118-0' AND kode_barcode='00366149';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAI-118-0','00366149','2025-09-11',' 12:19:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YEAI-132-0' AND kode_barcode='00354616';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YEAI-132-0','00354616','2025-09-11',' 12:19:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXG-469-0' AND kode_barcode='00364519';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXG-469-0','00364519','2025-09-11',' 12:19:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-WAAF-44-0' AND kode_barcode='00208319';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-WAAF-44-0','00208319','2025-09-11',' 12:19:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YGXD-50-0' AND kode_barcode='00359366';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YGXD-50-0','00359366','2025-09-11',' 12:19:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YBXG-37-0' AND kode_barcode='00337957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YBXG-37-0','00337957','2025-09-11',' 12:19:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XEXH-144-0' AND kode_barcode='00297313';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XEXH-144-0','00297313','2025-09-11',' 12:19:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YGBD-109-0' AND kode_barcode='00362347';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YGBD-109-0','00362347','2025-09-11',' 12:19:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-VKBA-34-0' AND kode_barcode='00200044';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-VKBA-34-0','00200044','2025-09-11',' 12:20:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-VCBH-146-0' AND kode_barcode='00153946';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-VCBH-146-0','00153946','2025-09-11',' 12:20:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1H-UCAB-285-0' AND kode_barcode='00087904';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1H-UCAB-285-0','00087904','2025-09-11',' 12:20:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1H-XBBD-21-0' AND kode_barcode='00281740';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1H-XBBD-21-0','00281740','2025-09-11',' 12:20:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1H-ULXB-203-0' AND kode_barcode='00134560';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1H-ULXB-203-0','00134560','2025-09-11',' 12:20:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-UKAA-55-T' AND kode_barcode='T0022342';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-UKAA-55-T','T0022342','2025-09-11',' 12:20:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1H-WCAA-99-0' AND kode_barcode='00218246';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1H-WCAA-99-0','00218246','2025-09-11',' 12:20:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1H-WGBH-130-0' AND kode_barcode='00245684';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1H-WGBH-130-0','00245684','2025-09-11',' 12:21:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YHAC-118-0' AND kode_barcode='00365488';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YHAC-118-0','00365488','2025-09-11',' 12:21:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGAG-149-0' AND kode_barcode='00361234';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGAG-149-0','00361234','2025-09-11',' 12:21:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-YEXA-62-T' AND kode_barcode='T0069115';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-YEXA-62-T','T0069115','2025-09-11',' 12:21:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-YHBX-35-0' AND kode_barcode='00366313';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-YHBX-35-0','00366313','2025-09-11',' 12:21:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-YGAG-147-0' AND kode_barcode='00361232';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-YGAG-147-0','00361232','2025-09-11',' 12:21:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H3J-YCXG-109-0' AND kode_barcode='00342306';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H3J-YCXG-109-0','00342306','2025-09-11',' 12:21:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YFBX-107-0' AND kode_barcode='00358192';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YFBX-107-0','00358192','2025-09-11',' 12:21:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YAAC-214-0' AND kode_barcode='00333874';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YAAC-214-0','00333874','2025-09-11',' 12:21:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YFAC-31-0' AND kode_barcode='00357146';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YFAC-31-0','00357146','2025-09-11',' 12:21:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-WJAX-100-T' AND kode_barcode='T0049520';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-WJAX-100-T','T0049520','2025-09-11',' 12:21:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHAI-120-0' AND kode_barcode='00366151';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHAI-120-0','00366151','2025-09-11',' 12:21:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YEXF-39-0' AND kode_barcode='00353267';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YEXF-39-0','00353267','2025-09-11',' 12:21:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-XLBG-113-0' AND kode_barcode='00331637';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-XLBG-113-0','00331637','2025-09-11',' 12:21:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-XLBG-112-0' AND kode_barcode='00331636';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-XLBG-112-0','00331636','2025-09-11',' 12:21:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YIXD-1-T' AND kode_barcode='T0072853';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YIXD-1-T','T0072853','2025-09-11',' 12:22:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XJBA-97-T' AND kode_barcode='T0063384';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XJBA-97-T','T0063384','2025-09-11',' 12:23:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XGXD-25-T' AND kode_barcode='T0058910';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XGXD-25-T','T0058910','2025-09-11',' 12:23:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XFBH-12-T' AND kode_barcode='T0058642';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XFBH-12-T','T0058642','2025-09-11',' 12:23:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XDBC-28-T' AND kode_barcode='T0056597';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XDBC-28-T','T0056597','2025-09-11',' 12:23:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XLAG-31-T' AND kode_barcode='T0065083';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XLAG-31-T','T0065083','2025-09-11',' 12:24:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XGXD-24-T' AND kode_barcode='T0058909';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XGXD-24-T','T0058909','2025-09-11',' 12:24:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-VFBC-26-T' AND kode_barcode='T0035290';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-VFBC-26-T','T0035290','2025-09-11',' 12:24:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XEBI-46-T' AND kode_barcode='T0057456';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XEBI-46-T','T0057456','2025-09-11',' 12:24:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2J-YGCA-16-T' AND kode_barcode='T0071750';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2J-YGCA-16-T','T0071750','2025-09-11',' 12:24:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-VACA-47-T' AND kode_barcode='T0028349';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-VACA-47-T','T0028349','2025-09-11',' 12:24:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XJBF-151-0' AND kode_barcode='00324060';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XJBF-151-0','00324060','2025-09-11',' 12:25:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-UGBB-9-0' AND kode_barcode='00111181';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-UGBB-9-0','00111181','2025-09-11',' 12:26:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-WLAI-41-0' AND kode_barcode='00269844';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-WLAI-41-0','00269844','2025-09-11',' 12:26:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YBBF-49-0' AND kode_barcode='00340441';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YBBF-49-0','00340441','2025-09-11',' 12:26:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-VEXG-91-0' AND kode_barcode='00163383';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-VEXG-91-0','00163383','2025-09-11',' 12:26:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-VEXG-60-0' AND kode_barcode='00163352';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-VEXG-60-0','00163352','2025-09-11',' 12:27:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XIBG-106-0' AND kode_barcode='00319365';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XIBG-106-0','00319365','2025-09-11',' 12:27:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-XABF-59-0' AND kode_barcode='00277135';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-XABF-59-0','00277135','2025-09-11',' 12:27:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XKAC-171-0' AND kode_barcode='00326058';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XKAC-171-0','00326058','2025-09-11',' 12:27:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-VHAF-30-0' AND kode_barcode='00182416';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-VHAF-30-0','00182416','2025-09-11',' 12:28:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XLAF-248-0' AND kode_barcode='00330165';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XLAF-248-0','00330165','2025-09-11',' 12:28:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-WKAC-160-0' AND kode_barcode='00263733';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-WKAC-160-0','00263733','2025-09-11',' 12:28:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-WEXB-287-0' AND kode_barcode='00230037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-WEXB-287-0','00230037','2025-09-11',' 12:28:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-XGBB-173-0' AND kode_barcode='00308689';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-XGBB-173-0','00308689','2025-09-11',' 12:29:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1G-VGBC-609-0' AND kode_barcode='00178515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1G-VGBC-609-0','00178515','2025-09-11',' 12:29:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-XJAB-352-0' AND kode_barcode='00321239';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-XJAB-352-0','00321239','2025-09-11',' 12:29:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YABB-423-0' AND kode_barcode='00335798';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YABB-423-0','00335798','2025-09-11',' 12:31:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1E-YGBD-3-T' AND kode_barcode='T0071431';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1E-YGBD-3-T','T0071431','2025-09-11',' 12:33:29','1','kasir');
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 ('F225111234581','kasir','1',' MDE1 X HW ','TOKO','SMBK-E','E1D-YFBA-129-0','CC X MODEL SLEP HW 14 8K ','','1.640','1','100.00','1448000','0','0','15000','1448000','0','0','0','1448000','TIN','00358403','E1D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YFBA-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E1D-YFBA-129-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 ('F225111234581','2025-09-11','1.640','2025-09-11','12:34:58','PLG0072548','1448000','1448000','0','1448000','1448000','kasir','2025-09-11 12:34:58','F22511123458');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111234581','2025-09-11','12:34:58','TIN','1448000','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-250911-0014','D','2025-09-11','12:34:58','kasir','PENJUALAN','F225111234581','203669000','1448000','205117000');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='SMBK-H' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-11',jam_taking= '12:36:02',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YIXD-17-T' AND kode_barcode='T0072869';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YIXD-17-T','T0072869','2025-09-11',' 12:36:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXE-51-T' AND kode_barcode='T0071840';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXE-51-T','T0071840','2025-09-11',' 12:36:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHXE-52-T' AND kode_barcode='T0071841';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHXE-52-T','T0071841','2025-09-11',' 12:36:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H1F-YHBA-20-T' AND kode_barcode='T0072450';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H1F-YHBA-20-T','T0072450','2025-09-11',' 12:36:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='H2I-XIAH-55-0' AND kode_barcode='00318021';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('H2I-XIAH-55-0','00318021','2025-09-11',' 12:36:26','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-11 12:39:29');
CREATE TABLE th_20250911_123929 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250911_123929_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
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 ('F225111247571','kasir','1',' TGH1 X UB ','TOKO','TBK-H','H1TG-YIXD-94-T','KL X MILANO UB 42CM 17K','OL','4.030','1','100.00','6565000','0','0','15000','6639000','0','28000','0','6667000','NS','T0072946','H1TG','0','0','-','0','1629000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TG-YIXD-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='H1TG-YIXD-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111247571','2025-09-11','4.030','2025-09-11','12:47:57','PLG0072549','6639000','6639000','28000','6667000','6667000','kasir','2025-09-11 12:47:57','F22511124757');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225111247571','2025-09-11','12:47:57','NS','6667000','28000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0015','D','2025-09-11','12:47:57','kasir','PENJUALAN','F225111247571','205117000','6667000','211784000');
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 ('F225110120081','kasir','1',' TFF3 UB ','TOKO','TBK-F','F3TF-YIXE-34-T','GL KOREA UB 17K ','','0.430','1','100.00','693000','0','0','15000','697000','0','0','0','697000','TIN','T0073004','F3TF','0','0','-','0','1612000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TF-YIXE-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='F3TF-YIXE-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110120081','2025-09-11','0.430','2025-09-11','13:20:08','PLG0072550','697000','697000','0','697000','0','kasir','2025-09-11 13:20:08','F22511012008');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110120081','2025-09-11','13:20:08','TIN','697000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250911-0001','2025-09-11','2025-09-11 13:20:08','PENJUALAN : F225110120081','234567','BCA','697000','697000','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-250911-0002','D','2025-09-11','13:20:08','BCA','PENJUALAN','F225110120081','3977562888','697000','3978259888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('234567','RETNA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110120081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110120081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110120081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111234581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111234581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111234581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111247571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111247571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111247571';
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-00004611','X-00004611','CC MODEL DAUN MATA NJ 17','GR','---','E2E','BELI','BELI001','320000','2025-09-11','0.580','1','kasir','2025-09-11 14:24:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004611','X-00004611');
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-250911-0001','F223051125191','NS','1','BELI','BELI001','E2E', 'X-00004611', 'CC MODEL DAUN MATA NJ 17','0.660','0.580','100.00','298000','320000','551724','900000','1','320000','320000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250911-0001','2025-09-11','2025-09-11','14:24:59','NS','---','0.580','320000','320000','320000','320000','320000','kasir','2025-09-11 14:24:59','FB-250911-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250911-0001','RIKA','CARANGREJO SAMPUNG','','','089536005936','kasir','2025-09-11 14:24:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250911-0016','K','2025-09-11','14:24:59','kasir','PEMBELIAN UMUM','FB-250911-0001','211784000','320000','211464000');
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 ('F225110229461','kasir','1',' MEE2 LG 8 ','TOKO','SMBK-E','E2E-YHXG-21-T','CC MODEL MATA VAR LG 8 8K ','OL','0.520','1','100.00','468000','0','0','15000','476000','0','5000','0','481000','RTA','T0072008','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXG-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E2E-YHXG-21-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 ('F225110229461','2025-09-11','0.520','2025-09-11','14:29:47','PLG0072551','476000','476000','5000','481000','481000','kasir','2025-09-11 14:29:46','F22511022946');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110229461','2025-09-11','14:29:47','RTA','481000','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-250911-0017','D','2025-09-11','14:29:47','kasir','PENJUALAN','F225110229461','211464000','481000','211945000');
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 ('F225110230381','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YIXB-25-T','GL OVAL MODEL C TD D58 8K ','OL','3.230','1','100.00','2907000','0','0','15000','2939000','0','16000','0','2955000','RTA','T0072769','F1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIXB-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='F1E-YIXB-25-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 ('F225110230381','2025-09-11','3.230','2025-09-11','14:30:38','PLG0072552','2939000','2939000','16000','2955000','2955000','kasir','2025-09-11 14:30:38','F22511023038');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110230381','2025-09-11','14:30:38','RTA','2955000','16000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0018','D','2025-09-11','14:30:38','kasir','PENJUALAN','F225110230381','211945000','2955000','214900000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110229461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110229461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110229461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110230381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110230381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110230381';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250911-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250911-0001';
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-00004612','X-00004612','CC MODEL MATA VAR MJ 17 8K','GR','---','E2E','BELI','BELI001','535000','2025-09-11','0.660','1','kasir','2025-09-11 15:38:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004612','X-00004612');
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-250911-0002','F225090321321','RHM','1','BELI','BELI001','E2E', 'X-00004612', 'CC MODEL MATA VAR MJ 17 8K','0.660','0.660','100.00','594000','535000','810606','900000','1','535000','535000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.660',berat_beli_asli=berat_beli_asli+'0.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.660',berat_akhir_asli=berat_akhir_asli+'0.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250911-0002','2025-09-11','2025-09-11','15:38:52','RHM','---','0.660','535000','535000','535000','535000','535000','kasir','2025-09-11 15:38:52','FB-250911-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250911-0002','BU ARUM','TUMPUK. JENANGAN','','','082257653692','kasir','2025-09-11 15:38:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250911-0019','K','2025-09-11','15:38:52','kasir','PEMBELIAN UMUM','FB-250911-0002','214900000','535000','214365000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250911-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250911-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225110352031','kasir','1',' TGB1 Q121 ','TOKO','TBK-B','B1TG-YIXE-22-T','GW Q121 PANJANG CUSTOM VIELOVE AY 17K ','','3.030','1','100.00','4936000','0','0','15000','4966000','0','721000','0','5687000','RTA','T0072992','B1TG','0','0','-','0','1629000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TG-YIXE-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='B1TG-YIXE-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110352031','2025-09-11','3.030','2025-09-11','15:52:04','PLG0072553','4966000','4966000','721000','5687000','5687000','kasir','2025-09-11 15:52:03','F22511035203');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110352031','2025-09-11','15:52:04','RTA','5687000','721000');
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-250911-0020','D','2025-09-11','15:52:04','kasir','PENJUALAN','F225110352031','214365000','5687000','220052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5687000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110352031' 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 ('F225110352032','kasir',' 1',' TFB1 X UB ','TOKO','TBK-B','B1TF-YFBF-54-T','GW X TUSUK ITALY PANJANG ARESO VAR UB 17K ','','2.980','1','100.00','4804000','0','0','15000','4834000','0','0','0','4834000','RTA','T0070421','B1TF','0','0','-','0','1612000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YFBF-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='B1TF-YFBF-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110352032','2025-09-11','2.980','2025-09-11','15:52:04','PLG0072554','4834000','4834000','0','4834000','4834000','kasir','2025-09-11 15:52:03','F22511035203');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110352032','2025-09-11','15:52:04','RTA','4834000','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-250911-0021','D','2025-09-11','15:52:04','kasir','PENJUALAN','F225110352032','220052000','4834000','224886000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4834000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110352032' 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 ('F225110400141','kasir','1',' TEE1 LG 14','TOKO','TBK-E','E1TE-YHAC-174-T','CC MODEL DAUN VAR LG 14 17K ','','0.620','1','100.00','989000','0','0','15000','995000','0','0','0','995000','RTA','T0072314','E1TE','0','0','-','0','1595000');
UPDATE tm_barang SET tgl_last_jual='2025-09-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-YHAC-174-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2025-09-11' AND kode_barang='E1TE-YHAC-174-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 ('F225110400141','2025-09-11','0.620','2025-09-11','16:00:14','PLG0072555','995000','995000','0','995000','0','kasir','2025-09-11 16:00:14','F22511040014');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-11','F225110400141','2025-09-11','16:00:14','RTA','995000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250911-0002','2025-09-11','2025-09-11 16:00:14','PENJUALAN : F225110400141','98898989887','BCA','995000','995000','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-250911-0003','D','2025-09-11','16:00:14','BCA','PENJUALAN','F225110400141','3978259888','995000','3979254888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('98898989887','NITA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='995000' WHERE no_faktur_jual='F225110400141' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110352031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110352031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110352031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110352032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110352032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110352032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110400141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110400141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110400141';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-11';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250912-0001','D','2025-09-12','16:10:44','SYSTEM','SALDO AWAL','SALDO AWAL','0','224886000','224886000');
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-250912-0001','D','2025-09-12','16:10:44','BCA','SALDO AWAL','SALDO AWAL','0','3979254888','3979254888');
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-250912-0001','D','2025-09-12','16:10:44','','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-250912-0001','D','2025-09-12','16:10:44','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-250912-0001','D','2025-09-12','16:10:44','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-250912-0001','D','2025-09-12','16:10:44','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-09-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-20250912-0001','1','E2D-YHAC-207-0','1','0.820','0.820','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YHAC-207-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YHAC-207-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-12 16:43:39' WHERE kode_barang='E2D-YHAC-207-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YHAC-207-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-12 16:43:39','TOKO','SMBK-E','E2D','E2D-YHAC-207-0','1','0.820','0.820','1','0.820','0.820','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-YHAC-207-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YHAC-207-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-20250912-0001','1','E2D-YIXH-122-0','1','1.080','1.080','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIXH-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIXH-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-12 16:43:39' WHERE kode_barang='E2D-YIXH-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIXH-122-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-12 16:43:39','TOKO','SMBK-E','E2D','E2D-YIXH-122-0','1','1.080','1.080','1','1.080','1.080','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-YIXH-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIXH-122-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250912-0001','2025-09-12','16:43','1.900','input','2025-09-11 16:43:38');