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 ('F225120809431','kasir','1',' TIA1 X HK ','TOKO','TBK-A','A1TI-YDAH-10-T','AT X TINDIK BABY HK 17K ','OL','0.260','1','100.00','432000','0','0','15000','439000','0','7000','0','446000','RTA','T0068696','A1TI','0','0','-','0','1663000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TI-YDAH-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='A1TI-YDAH-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225120809431','2025-09-12','0.260','2025-09-12','08:09:44','PLG0072556','439000','439000','7000','446000','446000','kasir','2025-09-12 08:09:43','F22512080943');
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-12','F225120809431','2025-09-12','08:09:44','RTA','446000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250912-0002','D','2025-09-12','08:09:44','kasir','PENJUALAN','F225120809431','224886000','446000','225332000');
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 ('F225120834041','kasir','1',' MFA1 UB ','TOKO','SMBK-A','A1F-YHXE-19-T','AT HUGGIES KLIP BOLA ARESO UB 8K ','','1.380','1','100.00','1265000','0','0','15000','1265000','0','0','0','1265000','NS','T0071808','A1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHXE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='A1F-YHXE-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225120834041','2025-09-12','1.380','2025-09-12','08:34:04','PLG0072557','1265000','1265000','0','1265000','1265000','kasir','2025-09-12 08:34:04','F22512083404');
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-12','F225120834041','2025-09-12','08:34:04','NS','1265000','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-250912-0003','D','2025-09-12','08:34:04','kasir','PENJUALAN','F225120834041','225332000','1265000','226597000');
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 ('F225121008511','kasir','1',' MDE1 X AY ','TOKO','SMBK-E','E1D-YFAD-92-0','CC X MODEL SLEP AY 12 8K ','','0.810','1','100.00','715000','0','0','15000','715000','0','0','0','715000','RHM','00357372','E1D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YFAD-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='E1D-YFAD-92-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 ('F225121008511','2025-09-12','0.810','2025-09-12','10:08:52','PLG0072558','715000','715000','0','715000','715000','kasir','2025-09-12 10:08:51','F22512100851');
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-12','F225121008511','2025-09-12','10:08:52','RHM','715000','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-250912-0004','D','2025-09-12','10:08:52','kasir','PENJUALAN','F225121008511','226597000','715000','227312000');
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 ('F225121010311','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIXB-11-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.460','1','100.00','430000','0','0','15000','435000','0','5000','0','440000','NS','T0072755','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXB-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='D1G-YIXB-11-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 ('F225121010311','2025-09-12','0.460','2025-09-12','10:10:32','PLG0072559','435000','435000','5000','440000','440000','kasir','2025-09-12 10:10:31','F22512101031');
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-12','F225121010311','2025-09-12','10:10:32','NS','440000','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-250912-0005','D','2025-09-12','10:10:32','kasir','PENJUALAN','F225121010311','227312000','440000','227752000');
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 ('F225121038161','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YIXH-84-T','GW TUSUK MODEL PITA VAR LG PE 8K ','OL','0.500','1','100.00','450000','0','0','15000','458000','0','5000','0','463000','NS','T0073093','B1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='B1E-YIXH-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225121038161','2025-09-12','0.500','2025-09-12','10:38:16','PLG0072560','458000','458000','5000','463000','463000','kasir','2025-09-12 10:38:16','F22512103816');
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-12','F225121038161','2025-09-12','10:38:16','NS','463000','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-250912-0006','D','2025-09-12','10:38:16','kasir','PENJUALAN','F225121038161','227752000','463000','228215000');
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 ('F225121043061','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-YHBI-206-0','AT X MODEL MATA CAT HITAM LG 8K ','OL','0.520','1','100.00','468000','0','0','15000','473000','0','5000','0','478000','RTA','00367447','A1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YHBI-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='A1E-YHBI-206-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225121043061','2025-09-12','0.520','2025-09-12','10:43:07','PLG0072561','473000','473000','5000','478000','0','kasir','2025-09-12 10:43:06','F22512104306');
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-12','F225121043061','2025-09-12','10:43:07','RTA','478000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250912-0001','2025-09-12','2025-09-12 10:43:06','PENJUALAN : F225121043061','899787870000','BCA','478000','478000','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-250912-0002','D','2025-09-12','10:43:07','BCA','PENJUALAN','F225121043061','3979254888','478000','3979732888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('899787870000','NURUL');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='478000' WHERE no_faktur_jual='F225121043061' 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 ('F225121053131','kasir','1',' MDE2 CM 16','TOKO','SMBK-E','E2D-YIXH-43-T','CC WEDDING MATA CM 16 8K ','','1.080','1','100.00','954000','0','0','15000','954000','0','0','0','954000','TIN','T0073052','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='E2D-YIXH-43-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 ('F225121053131','2025-09-12','1.080','2025-09-12','10:53:14','PLG0072562','954000','954000','0','954000','954000','kasir','2025-09-12 10:53:13','F22512105313');
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-12','F225121053131','2025-09-12','10:53:14','TIN','954000','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-250912-0007','D','2025-09-12','10:53:14','kasir','PENJUALAN','F225121053131','228215000','954000','229169000');
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-P' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:21:54',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='PHG-XJBC-225-0' AND kode_barcode='00323324';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHG-XJBC-225-0','00323324','2025-09-12',' 12:22:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PHG-YCBH-18-T' AND kode_barcode='T0068364';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHG-YCBH-18-T','T0068364','2025-09-12',' 12:22:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PHK-YHXH-139-0' AND kode_barcode='00364667';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHK-YHXH-139-0','00364667','2025-09-12',' 12:22:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PHG-YGCA-8-T' AND kode_barcode='T0071742';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHG-YGCA-8-T','T0071742','2025-09-12',' 12:22:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PHG-YIXD-11-T' AND kode_barcode='T0072863';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHG-YIXD-11-T','T0072863','2025-09-12',' 12:22:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PHG-VCAH-284-0' AND kode_barcode='00152769';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PHG-VCAH-284-0','00152769','2025-09-12',' 12:22:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PFG-YIXB-7-T' AND kode_barcode='T0072751';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PFG-YIXB-7-T','T0072751','2025-09-12',' 12:22:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-38-T' AND kode_barcode='T0048292';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-38-T','T0048292','2025-09-12',' 12:22:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-XIXC-67-T' AND kode_barcode='T0061335';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-XIXC-67-T','T0061335','2025-09-12',' 12:22:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-XDBB-157-0' AND kode_barcode='00294205';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-XDBB-157-0','00294205','2025-09-12',' 12:22:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WFAF-39-T' AND kode_barcode='T0045242';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WFAF-39-T','T0045242','2025-09-12',' 12:22:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WFAF-38-T' AND kode_barcode='T0045241';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WFAF-38-T','T0045241','2025-09-12',' 12:22:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WFAF-42-T' AND kode_barcode='T0045245';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WFAF-42-T','T0045245','2025-09-12',' 12:22:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WFAF-40-T' AND kode_barcode='T0045243';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WFAF-40-T','T0045243','2025-09-12',' 12:22:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-41-T' AND kode_barcode='T0048295';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-41-T','T0048295','2025-09-12',' 12:22:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-42-T' AND kode_barcode='T0048296';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-42-T','T0048296','2025-09-12',' 12:22:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-46-T' AND kode_barcode='T0048300';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-46-T','T0048300','2025-09-12',' 12:22:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-47-T' AND kode_barcode='T0048301';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-47-T','T0048301','2025-09-12',' 12:22:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-39-T' AND kode_barcode='T0048293';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-39-T','T0048293','2025-09-12',' 12:23:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-WHCA-40-T' AND kode_barcode='T0048294';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-WHCA-40-T','T0048294','2025-09-12',' 12:23:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-XHBX-21-T' AND kode_barcode='T0060770';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-XHBX-21-T','T0060770','2025-09-12',' 12:23:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PBG-YGBF-100-0' AND kode_barcode='00362756';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PBG-YGBF-100-0','00362756','2025-09-12',' 12:23:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-YEXC-245-0' AND kode_barcode='00352556';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-YEXC-245-0','00352556','2025-09-12',' 12:23:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PAG-XIXD-39-T' AND kode_barcode='T0061394';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PAG-XIXD-39-T','T0061394','2025-09-12',' 12:23:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-WHAF-19-T' AND kode_barcode='T0047666';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-WHAF-19-T','T0047666','2025-09-12',' 12:23:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-WHXI-32-T' AND kode_barcode='T0047229';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-WHXI-32-T','T0047229','2025-09-12',' 12:23:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-WECA-10-T' AND kode_barcode='T0044677';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-WECA-10-T','T0044677','2025-09-12',' 12:23:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PSG-YGXE-34-T' AND kode_barcode='T0070814';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PSG-YGXE-34-T','T0070814','2025-09-12',' 12:23:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-WHAX-10-0' AND kode_barcode='00247865';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-WHAX-10-0','00247865','2025-09-12',' 12:23:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-XBBI-55-T' AND kode_barcode='T0054701';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-XBBI-55-T','T0054701','2025-09-12',' 12:23:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-XFAD-35-T' AND kode_barcode='T0058213';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-XFAD-35-T','T0058213','2025-09-12',' 12:23:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-VJXA-9-T' AND kode_barcode='T0038579';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-VJXA-9-T','T0038579','2025-09-12',' 12:23:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PEG-WJBF-23-T' AND kode_barcode='T0050123';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PEG-WJBF-23-T','T0050123','2025-09-12',' 12:23:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YHBG-58-T' AND kode_barcode='T0072650';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YHBG-58-T','T0072650','2025-09-12',' 12:23:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YHBG-59-T' AND kode_barcode='T0072651';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YHBG-59-T','T0072651','2025-09-12',' 12:23:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-VIAI-80-0' AND kode_barcode='00188859';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-VIAI-80-0','00188859','2025-09-12',' 12:24:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-WFAB-246-0' AND kode_barcode='00237858';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-WFAB-246-0','00237858','2025-09-12',' 12:24:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PFG-YDAB-21-0' AND kode_barcode='00349169';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PFG-YDAB-21-0','00349169','2025-09-12',' 12:24:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PFG-XEXH-1-0' AND kode_barcode='00297170';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PFG-XEXH-1-0','00297170','2025-09-12',' 12:24:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YBXE-50-T' AND kode_barcode='T0066631';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YBXE-50-T','T0066631','2025-09-12',' 12:24:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YAXG-87-T' AND kode_barcode='T0065675';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YAXG-87-T','T0065675','2025-09-12',' 12:24:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YBXE-48-T' AND kode_barcode='T0066629';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YBXE-48-T','T0066629','2025-09-12',' 12:24:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YEXC-248-0' AND kode_barcode='00352559';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YEXC-248-0','00352559','2025-09-12',' 12:24:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-WAXI-1-T' AND kode_barcode='T0041219';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-WAXI-1-T','T0041219','2025-09-12',' 12:24:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YBXE-52-T' AND kode_barcode='T0066633';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YBXE-52-T','T0066633','2025-09-12',' 12:24:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YBXE-47-T' AND kode_barcode='T0066628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YBXE-47-T','T0066628','2025-09-12',' 12:24:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-VDCX-217-0' AND kode_barcode='00162425';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-VDCX-217-0','00162425','2025-09-12',' 12:24:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-XJAH-54-T' AND kode_barcode='T0063238';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-XJAH-54-T','T0063238','2025-09-12',' 12:24:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YBAD-125-0' AND kode_barcode='00339018';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YBAD-125-0','00339018','2025-09-12',' 12:24:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='PDG-YFBF-153-T' AND kode_barcode='T0070520';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('PDG-YFBF-153-T','T0070520','2025-09-12',' 12:24:46','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:25:51');
CREATE TABLE th_20250912_122551 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122551_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-12 12:25:55');
CREATE TABLE th_20250912_122555 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122555_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-S' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:26:03',input_by='kasir';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:26:16');
CREATE TABLE th_20250912_122616 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122616_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-S' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:26:26',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='S2F-XHXE-67-T' AND kode_barcode='T0060082';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S2F-XHXE-67-T','T0060082','2025-09-12',' 12:26:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S1G-YGXE-176-0' AND kode_barcode='00359815';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S1G-YGXE-176-0','00359815','2025-09-12',' 12:26:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S2F-XHBD-191-0' AND kode_barcode='00313562';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S2F-XHBD-191-0','00313562','2025-09-12',' 12:26:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S2F-XJAB-60-0' AND kode_barcode='00320947';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S2F-XJAB-60-0','00320947','2025-09-12',' 12:26:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3G-WIBE-9-T' AND kode_barcode='T0048929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3G-WIBE-9-T','T0048929','2025-09-12',' 12:26:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3F-VKBF-21-0' AND kode_barcode='00200842';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3F-VKBF-21-0','00200842','2025-09-12',' 12:26:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3G-WABE-9-T' AND kode_barcode='T0041723';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3G-WABE-9-T','T0041723','2025-09-12',' 12:27:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3F-VKBF-20-0' AND kode_barcode='00200841';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3F-VKBF-20-0','00200841','2025-09-12',' 12:27:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3G-WABE-8-T' AND kode_barcode='T0041722';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3G-WABE-8-T','T0041722','2025-09-12',' 12:27:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='S3G-XFAX-54-T' AND kode_barcode='T0057897';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('S3G-XFAX-54-T','T0057897','2025-09-12',' 12:27:11','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:27:55');
CREATE TABLE th_20250912_122755 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122755_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-12 12:28:03');
CREATE TABLE th_20250912_122803 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122803_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 ='TBK-A' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:28:15',input_by='kasir';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:28:43');
CREATE TABLE th_20250912_122843 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_122843_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 ='TBK-A' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:28:53',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XGAI-9-T' AND kode_barcode='T0059389';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XGAI-9-T','T0059389','2025-09-12',' 12:28:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XFBH-73-T' AND kode_barcode='T0058703';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XFBH-73-T','T0058703','2025-09-12',' 12:29:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-49-T' AND kode_barcode='T0072901';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-49-T','T0072901','2025-09-12',' 12:29:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-50-T' AND kode_barcode='T0072902';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-50-T','T0072902','2025-09-12',' 12:29:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YIXD-43-T' AND kode_barcode='T0072895';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YIXD-43-T','T0072895','2025-09-12',' 12:29:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFBF-46-T' AND kode_barcode='T0070413';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFBF-46-T','T0070413','2025-09-12',' 12:29:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-XIBG-13-T' AND kode_barcode='T0062338';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-XIBG-13-T','T0062338','2025-09-12',' 12:29:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YDBC-41-T' AND kode_barcode='T0068855';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YDBC-41-T','T0068855','2025-09-12',' 12:29:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YGAH-196-T' AND kode_barcode='T0071227';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YGAH-196-T','T0071227','2025-09-12',' 12:29:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-VABE-200-T' AND kode_barcode='T0027957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-VABE-200-T','T0027957','2025-09-12',' 12:29:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFAA-70-T' AND kode_barcode='T0069921';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFAA-70-T','T0069921','2025-09-12',' 12:29:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFAA-44-T' AND kode_barcode='T0069895';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFAA-44-T','T0069895','2025-09-12',' 12:29:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFBF-48-T' AND kode_barcode='T0070415';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFBF-48-T','T0070415','2025-09-12',' 12:29:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YBBA-2-T' AND kode_barcode='T0067225';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YBBA-2-T','T0067225','2025-09-12',' 12:29:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XFBI-65-T' AND kode_barcode='T0058776';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XFBI-65-T','T0058776','2025-09-12',' 12:29:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-51-T' AND kode_barcode='T0072903';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-51-T','T0072903','2025-09-12',' 12:29:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XAAA-18-T' AND kode_barcode='T0053132';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XAAA-18-T','T0053132','2025-09-12',' 12:29:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFBF-43-T' AND kode_barcode='T0070410';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFBF-43-T','T0070410','2025-09-12',' 12:30:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFBF-44-T' AND kode_barcode='T0070411';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFBF-44-T','T0070411','2025-09-12',' 12:30:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YHAC-169-T' AND kode_barcode='T0072309';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YHAC-169-T','T0072309','2025-09-12',' 12:30:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-YEBD-67-T' AND kode_barcode='T0069570';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-YEBD-67-T','T0069570','2025-09-12',' 12:30:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TI-YGBI-111-T' AND kode_barcode='T0071644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TI-YGBI-111-T','T0071644','2025-09-12',' 12:30:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TI-YGBI-112-T' AND kode_barcode='T0071645';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TI-YGBI-112-T','T0071645','2025-09-12',' 12:30:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TI-YGAI-1-T' AND kode_barcode='T0071238';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TI-YGAI-1-T','T0071238','2025-09-12',' 12:30:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-YGAI-13-T' AND kode_barcode='T0071250';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-YGAI-13-T','T0071250','2025-09-12',' 12:30:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDAX-9-T' AND kode_barcode='T0003644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDAX-9-T','T0003644','2025-09-12',' 12:30:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDAX-7-T' AND kode_barcode='T0003642';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDAX-7-T','T0003642','2025-09-12',' 12:30:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDXI-119-T' AND kode_barcode='T0003614';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDXI-119-T','T0003614','2025-09-12',' 12:30:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDXI-121-T' AND kode_barcode='T0003616';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDXI-121-T','T0003616','2025-09-12',' 12:30:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDXI-133-T' AND kode_barcode='T0003628';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDXI-133-T','T0003628','2025-09-12',' 12:30:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDAX-44-T' AND kode_barcode='T0003679';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDAX-44-T','T0003679','2025-09-12',' 12:30:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UDAX-36-T' AND kode_barcode='T0003671';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UDAX-36-T','T0003671','2025-09-12',' 12:30:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UCAI-12-T' AND kode_barcode='T0001785';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UCAI-12-T','T0001785','2025-09-12',' 12:30:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A0TA-UEXI-59-T' AND kode_barcode='T0005008';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A0TA-UEXI-59-T','T0005008','2025-09-12',' 12:30:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XBAG-45-T' AND kode_barcode='T0054076';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XBAG-45-T','T0054076','2025-09-12',' 12:30:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-UCAX-20-T' AND kode_barcode='T0001186';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-UCAX-20-T','T0001186','2025-09-12',' 12:30:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YBBA-3-T' AND kode_barcode='T0067226';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YBBA-3-T','T0067226','2025-09-12',' 12:30:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-VGXB-16-T' AND kode_barcode='T0035652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-VGXB-16-T','T0035652','2025-09-12',' 12:31:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-VGXB-15-T' AND kode_barcode='T0035651';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-VGXB-15-T','T0035651','2025-09-12',' 12:31:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-48-T' AND kode_barcode='T0072900';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-48-T','T0072900','2025-09-12',' 12:31:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YGAH-195-T' AND kode_barcode='T0071226';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YGAH-195-T','T0071226','2025-09-12',' 12:31:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YGAH-194-T' AND kode_barcode='T0071225';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YGAH-194-T','T0071225','2025-09-12',' 12:31:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YFBF-42-T' AND kode_barcode='T0070409';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YFBF-42-T','T0070409','2025-09-12',' 12:31:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YBBA-5-T' AND kode_barcode='T0067228';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YBBA-5-T','T0067228','2025-09-12',' 12:31:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-UDBI-15-T' AND kode_barcode='T0004664';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-UDBI-15-T','T0004664','2025-09-12',' 12:31:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YIXD-41-T' AND kode_barcode='T0072893';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YIXD-41-T','T0072893','2025-09-12',' 12:31:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YIXD-40-T' AND kode_barcode='T0072892';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YIXD-40-T','T0072892','2025-09-12',' 12:31:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-XDBI-3-T' AND kode_barcode='T0056740';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-XDBI-3-T','T0056740','2025-09-12',' 12:31:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XAXC-6-T' AND kode_barcode='T0052851';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XAXC-6-T','T0052851','2025-09-12',' 12:31:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YDAH-3-T' AND kode_barcode='T0068689';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YDAH-3-T','T0068689','2025-09-12',' 12:31:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YDAH-2-T' AND kode_barcode='T0068688';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YDAH-2-T','T0068688','2025-09-12',' 12:31:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-XDCX-10-T' AND kode_barcode='T0056798';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-XDCX-10-T','T0056798','2025-09-12',' 12:31:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XBBF-1-T' AND kode_barcode='T0054300';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XBBF-1-T','T0054300','2025-09-12',' 12:31:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YHXG-107-T' AND kode_barcode='T0072094';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YHXG-107-T','T0072094','2025-09-12',' 12:31:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-WJAG-4-T' AND kode_barcode='T0049588';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-WJAG-4-T','T0049588','2025-09-12',' 12:31:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YGAH-198-T' AND kode_barcode='T0071229';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YGAH-198-T','T0071229','2025-09-12',' 12:31:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YFBF-45-T' AND kode_barcode='T0070412';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YFBF-45-T','T0070412','2025-09-12',' 12:31:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-WEBB-26-T' AND kode_barcode='T0044320';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-WEBB-26-T','T0044320','2025-09-12',' 12:31:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-WHBI-61-T' AND kode_barcode='T0048156';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-WHBI-61-T','T0048156','2025-09-12',' 12:32:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XBBI-99-T' AND kode_barcode='T0054745';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XBBI-99-T','T0054745','2025-09-12',' 12:32:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XFBI-61-T' AND kode_barcode='T0058772';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XFBI-61-T','T0058772','2025-09-12',' 12:32:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YBBA-6-T' AND kode_barcode='T0067229';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YBBA-6-T','T0067229','2025-09-12',' 12:32:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-WHXD-50-T' AND kode_barcode='T0047029';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-WHXD-50-T','T0047029','2025-09-12',' 12:32:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-XGAE-4-T' AND kode_barcode='T0059284';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-XGAE-4-T','T0059284','2025-09-12',' 12:32:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-XDAB-5-T' AND kode_barcode='T0056275';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-XDAB-5-T','T0056275','2025-09-12',' 12:32:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YBAA-86-T' AND kode_barcode='T0066742';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YBAA-86-T','T0066742','2025-09-12',' 12:32:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-XLBG-19-T' AND kode_barcode='T0065371';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-XLBG-19-T','T0065371','2025-09-12',' 12:32:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-XDAB-4-T' AND kode_barcode='T0056274';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-XDAB-4-T','T0056274','2025-09-12',' 12:32:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YBAA-87-T' AND kode_barcode='T0066743';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YBAA-87-T','T0066743','2025-09-12',' 12:32:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YBAA-91-T' AND kode_barcode='T0066747';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YBAA-91-T','T0066747','2025-09-12',' 12:32:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YBAA-90-T' AND kode_barcode='T0066746';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YBAA-90-T','T0066746','2025-09-12',' 12:32:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-WKXI-44-T' AND kode_barcode='T0050452';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-WKXI-44-T','T0050452','2025-09-12',' 12:32:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-WFBX-11-T' AND kode_barcode='T0045357';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-WFBX-11-T','T0045357','2025-09-12',' 12:32:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YIXD-42-T' AND kode_barcode='T0072894';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YIXD-42-T','T0072894','2025-09-12',' 12:32:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-UCBF-36-T' AND kode_barcode='T0002161';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-UCBF-36-T','T0002161','2025-09-12',' 12:32:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-WBAG-18-T' AND kode_barcode='T0042246';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-WBAG-18-T','T0042246','2025-09-12',' 12:32:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-WDXA-3-T' AND kode_barcode='T0043170';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-WDXA-3-T','T0043170','2025-09-12',' 12:32:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YGAH-191-T' AND kode_barcode='T0071222';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YGAH-191-T','T0071222','2025-09-12',' 12:32:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TF-YGAH-193-T' AND kode_barcode='T0071224';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TF-YGAH-193-T','T0071224','2025-09-12',' 12:32:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-47-T' AND kode_barcode='T0072899';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-47-T','T0072899','2025-09-12',' 12:33:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TD-YIXD-46-T' AND kode_barcode='T0072898';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TD-YIXD-46-T','T0072898','2025-09-12',' 12:33:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YIXD-44-T' AND kode_barcode='T0072896';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YIXD-44-T','T0072896','2025-09-12',' 12:33:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-YHBG-3-T' AND kode_barcode='T0072595';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-YHBG-3-T','T0072595','2025-09-12',' 12:33:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='A1TE-VIAI-97-T' AND kode_barcode='T0038099';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('A1TE-VIAI-97-T','T0038099','2025-09-12',' 12:33:15','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:34:30');
CREATE TABLE th_20250912_123430 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_123430_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-12 12:34:32');
CREATE TABLE th_20250912_123432 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_123432_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-12 12:34:36');
CREATE TABLE th_20250912_123436 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_123436_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 ='TBK-B' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:34:47',input_by='kasir';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:35:04');
CREATE TABLE th_20250912_123504 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_123504_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 ='TBK-B' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:35:14',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDBG-21-T' AND kode_barcode='T0056671';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDBG-21-T','T0056671','2025-09-12',' 12:35:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDBG-20-T' AND kode_barcode='T0056670';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDBG-20-T','T0056670','2025-09-12',' 12:35:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-UGBX-21-T' AND kode_barcode='T0012592';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-UGBX-21-T','T0012592','2025-09-12',' 12:35:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDAC-17-T' AND kode_barcode='T0056328';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDAC-17-T','T0056328','2025-09-12',' 12:35:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-UEAH-286-T' AND kode_barcode='T0005809';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-UEAH-286-T','T0005809','2025-09-12',' 12:35:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-WLBF-65-T' AND kode_barcode='T0052726';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-WLBF-65-T','T0052726','2025-09-12',' 12:35:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-YDAH-18-T' AND kode_barcode='T0068704';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-YDAH-18-T','T0068704','2025-09-12',' 12:35:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDAC-15-T' AND kode_barcode='T0056326';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDAC-15-T','T0056326','2025-09-12',' 12:35:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDBG-17-T' AND kode_barcode='T0056667';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDBG-17-T','T0056667','2025-09-12',' 12:35:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XGAF-13-T' AND kode_barcode='T0059353';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XGAF-13-T','T0059353','2025-09-12',' 12:35:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-WKBA-5-T' AND kode_barcode='T0050781';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-WKBA-5-T','T0050781','2025-09-12',' 12:35:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDBG-18-T' AND kode_barcode='T0056668';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDBG-18-T','T0056668','2025-09-12',' 12:35:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-WABX-62-T' AND kode_barcode='T0041548';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-WABX-62-T','T0041548','2025-09-12',' 12:36:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-YDAH-22-T' AND kode_barcode='T0068708';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-YDAH-22-T','T0068708','2025-09-12',' 12:36:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDAC-18-T' AND kode_barcode='T0056329';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDAC-18-T','T0056329','2025-09-12',' 12:36:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDAC-20-T' AND kode_barcode='T0056331';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDAC-20-T','T0056331','2025-09-12',' 12:36:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-WABX-59-T' AND kode_barcode='T0041545';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-WABX-59-T','T0041545','2025-09-12',' 12:36:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-XDBG-13-T' AND kode_barcode='T0056663';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-XDBG-13-T','T0056663','2025-09-12',' 12:36:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B0TA-YDAH-20-T' AND kode_barcode='T0068706';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B0TA-YDAH-20-T','T0068706','2025-09-12',' 12:36:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WEBB-33-T' AND kode_barcode='T0044327';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WEBB-33-T','T0044327','2025-09-12',' 12:36:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WBXH-59-T' AND kode_barcode='T0042134';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WBXH-59-T','T0042134','2025-09-12',' 12:36:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WJAG-7-T' AND kode_barcode='T0049591';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WJAG-7-T','T0049591','2025-09-12',' 12:36:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WGAI-11-T' AND kode_barcode='T0046333';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WGAI-11-T','T0046333','2025-09-12',' 12:36:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XJXB-32-T' AND kode_barcode='T0062573';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XJXB-32-T','T0062573','2025-09-12',' 12:36:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XIBG-22-T' AND kode_barcode='T0062347';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XIBG-22-T','T0062347','2025-09-12',' 12:36:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WBAG-17-T' AND kode_barcode='T0042245';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WBAG-17-T','T0042245','2025-09-12',' 12:36:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XJXB-33-T' AND kode_barcode='T0062574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XJXB-33-T','T0062574','2025-09-12',' 12:36:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WACA-20-T' AND kode_barcode='T0041884';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WACA-20-T','T0041884','2025-09-12',' 12:36:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XJXB-31-T' AND kode_barcode='T0062572';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XJXB-31-T','T0062572','2025-09-12',' 12:36:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-WABF-55-T' AND kode_barcode='T0041808';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-WABF-55-T','T0041808','2025-09-12',' 12:36:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TD-YIXD-103-T' AND kode_barcode='T0072955';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TD-YIXD-103-T','T0072955','2025-09-12',' 12:37:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-YAAD-22-T' AND kode_barcode='T0065958';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-YAAD-22-T','T0065958','2025-09-12',' 12:37:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-YIXE-23-T' AND kode_barcode='T0072993';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-YIXE-23-T','T0072993','2025-09-12',' 12:37:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TJ-YFBF-55-T' AND kode_barcode='T0070422';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TJ-YFBF-55-T','T0070422','2025-09-12',' 12:37:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-VHBE-73-T' AND kode_barcode='T0037257';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-VHBE-73-T','T0037257','2025-09-12',' 12:37:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TD-YFBF-58-T' AND kode_barcode='T0070425';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TD-YFBF-58-T','T0070425','2025-09-12',' 12:37:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YIXD-52-T' AND kode_barcode='T0072904';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YIXD-52-T','T0072904','2025-09-12',' 12:37:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TD-YIXD-102-T' AND kode_barcode='T0072954';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TD-YIXD-102-T','T0072954','2025-09-12',' 12:37:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TG-YIXD-101-T' AND kode_barcode='T0072953';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TG-YIXD-101-T','T0072953','2025-09-12',' 12:37:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XFBI-81-T' AND kode_barcode='T0058792';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XFBI-81-T','T0058792','2025-09-12',' 12:37:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TD-XJAB-26-T' AND kode_barcode='T0062887';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TD-XJAB-26-T','T0062887','2025-09-12',' 12:37:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TE-XLBG-26-T' AND kode_barcode='T0065378';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TE-XLBG-26-T','T0065378','2025-09-12',' 12:37:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XGAI-13-T' AND kode_barcode='T0059393';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XGAI-13-T','T0059393','2025-09-12',' 12:37:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YAAD-11-T' AND kode_barcode='T0065947';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YAAD-11-T','T0065947','2025-09-12',' 12:37:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YGXA-2-T' AND kode_barcode='T0070522';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YGXA-2-T','T0070522','2025-09-12',' 12:37:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YGXA-1-T' AND kode_barcode='T0070521';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YGXA-1-T','T0070521','2025-09-12',' 12:37:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YFBF-52-T' AND kode_barcode='T0070419';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YFBF-52-T','T0070419','2025-09-12',' 12:37:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XHBX-84-T' AND kode_barcode='T0060833';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XHBX-84-T','T0060833','2025-09-12',' 12:37:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XLBG-23-T' AND kode_barcode='T0065375';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XLBG-23-T','T0065375','2025-09-12',' 12:37:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XEAG-5-T' AND kode_barcode='T0057170';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XEAG-5-T','T0057170','2025-09-12',' 12:37:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YFBF-50-T' AND kode_barcode='T0070417';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YFBF-50-T','T0070417','2025-09-12',' 12:37:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XHBX-82-T' AND kode_barcode='T0060831';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XHBX-82-T','T0060831','2025-09-12',' 12:38:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XHBX-80-T' AND kode_barcode='T0060829';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XHBX-80-T','T0060829','2025-09-12',' 12:38:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-XBBI-139-T' AND kode_barcode='T0054785';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-XBBI-139-T','T0054785','2025-09-12',' 12:38:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='B1TF-YDBC-49-T' AND kode_barcode='T0068863';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('B1TF-YDBC-49-T','T0068863','2025-09-12',' 12:38:09','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:40:06');
CREATE TABLE th_20250912_124006 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_124006_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-12 12:40:10');
CREATE TABLE th_20250912_124010 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_124010_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-12 12:40:15');
CREATE TABLE th_20250912_124015 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_124015_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-12 12:40:19');
CREATE TABLE th_20250912_124019 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_124019_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 ='TBK-D' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:40:31',input_by='kasir';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:40:43');
CREATE TABLE th_20250912_124043 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_124043_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 ='TBK-D' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:40:52',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='D1TD-YFBF-60-T' AND kode_barcode='T0070427';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TD-YFBF-60-T','T0070427','2025-09-12',' 12:41:01','1','kasir');
INSERT INTO tt_barang_stock_lebih(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('','','2025-09-12',' 12:41:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='' AND kode_barcode='';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('','','2025-09-12',' 12:41:50','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 ='TBK-D' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-12',jam_taking= '12:42:21',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YFBF-61-T' AND kode_barcode='T0070428';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YFBF-61-T','T0070428','2025-09-12',' 12:42:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-XGAI-27-T' AND kode_barcode='T0059407';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-XGAI-27-T','T0059407','2025-09-12',' 12:42:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-XJAB-35-T' AND kode_barcode='T0062896';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-XJAB-35-T','T0062896','2025-09-12',' 12:42:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YDBC-55-T' AND kode_barcode='T0068869';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YDBC-55-T','T0068869','2025-09-12',' 12:42:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TD-YGBD-83-T' AND kode_barcode='T0071511';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TD-YGBD-83-T','T0071511','2025-09-12',' 12:42:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TD-YGBI-120-T' AND kode_barcode='T0071653';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TD-YGBI-120-T','T0071653','2025-09-12',' 12:42:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-XLBG-39-T' AND kode_barcode='T0065391';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-XLBG-39-T','T0065391','2025-09-12',' 12:42:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WLAB-19-T' AND kode_barcode='T0051706';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WLAB-19-T','T0051706','2025-09-12',' 12:43:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YDBC-54-T' AND kode_barcode='T0068868';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YDBC-54-T','T0068868','2025-09-12',' 12:43:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WFBX-15-T' AND kode_barcode='T0045361';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WFBX-15-T','T0045361','2025-09-12',' 12:43:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIXI-116-T' AND kode_barcode='T0037708';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIXI-116-T','T0037708','2025-09-12',' 12:43:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TD-YGBI-119-T' AND kode_barcode='T0071652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TD-YGBI-119-T','T0071652','2025-09-12',' 12:43:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YIXD-105-T' AND kode_barcode='T0072957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YIXD-105-T','T0072957','2025-09-12',' 12:43:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YIXD-58-T' AND kode_barcode='T0072910';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YIXD-58-T','T0072910','2025-09-12',' 12:43:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WDAG-11-T' AND kode_barcode='T0043536';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WDAG-11-T','T0043536','2025-09-12',' 12:43:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIAC-77-T' AND kode_barcode='T0037830';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIAC-77-T','T0037830','2025-09-12',' 12:43:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UKAC-61-T' AND kode_barcode='T0022513';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UKAC-61-T','T0022513','2025-09-12',' 12:43:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WEXD-36-T' AND kode_barcode='T0044008';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WEXD-36-T','T0044008','2025-09-12',' 12:43:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TE-YIXD-20-T' AND kode_barcode='T0072872';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TE-YIXD-20-T','T0072872','2025-09-12',' 12:44:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TE-WGXF-72-T' AND kode_barcode='T0046035';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TE-WGXF-72-T','T0046035','2025-09-12',' 12:44:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WABX-71-T' AND kode_barcode='T0041557';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WABX-71-T','T0041557','2025-09-12',' 12:44:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YIXD-57-T' AND kode_barcode='T0072909';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YIXD-57-T','T0072909','2025-09-12',' 12:44:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YIXD-104-T' AND kode_barcode='T0072956';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YIXD-104-T','T0072956','2025-09-12',' 12:44:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WJAX-12-T' AND kode_barcode='T0049432';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WJAX-12-T','T0049432','2025-09-12',' 12:44:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIAC-76-T' AND kode_barcode='T0037829';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIAC-76-T','T0037829','2025-09-12',' 12:44:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WFXI-62-T' AND kode_barcode='T0045047';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WFXI-62-T','T0045047','2025-09-12',' 12:44:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WDAG-4-T' AND kode_barcode='T0043529';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WDAG-4-T','T0043529','2025-09-12',' 12:44:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TE-WGXF-71-T' AND kode_barcode='T0046034';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TE-WGXF-71-T','T0046034','2025-09-12',' 12:44:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TE-WDAG-14-T' AND kode_barcode='T0043539';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TE-WDAG-14-T','T0043539','2025-09-12',' 12:44:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YDAH-25-T' AND kode_barcode='T0068711';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YDAH-25-T','T0068711','2025-09-12',' 12:44:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YIXD-56-T' AND kode_barcode='T0072908';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YIXD-56-T','T0072908','2025-09-12',' 12:44:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YGXA-6-T' AND kode_barcode='T0070526';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YGXA-6-T','T0070526','2025-09-12',' 12:45:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-XLBG-37-T' AND kode_barcode='T0065389';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-XLBG-37-T','T0065389','2025-09-12',' 12:45:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WFXI-76-T' AND kode_barcode='T0045061';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WFXI-76-T','T0045061','2025-09-12',' 12:45:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YGBD-79-T' AND kode_barcode='T0071507';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YGBD-79-T','T0071507','2025-09-12',' 12:45:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UGAC-71-T' AND kode_barcode='T0012058';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UGAC-71-T','T0012058','2025-09-12',' 12:45:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIAG-31-T' AND kode_barcode='T0037957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIAG-31-T','T0037957','2025-09-12',' 12:45:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WABX-2-T' AND kode_barcode='T0041488';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WABX-2-T','T0041488','2025-09-12',' 12:45:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UCBG-53-T' AND kode_barcode='T0002316';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UCBG-53-T','T0002316','2025-09-12',' 12:45:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YHBG-5-T' AND kode_barcode='T0072597';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YHBG-5-T','T0072597','2025-09-12',' 12:45:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIAG-32-T' AND kode_barcode='T0037958';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIAG-32-T','T0037958','2025-09-12',' 12:45:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UDXE-52-T' AND kode_barcode='T0003166';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UDXE-52-T','T0003166','2025-09-12',' 12:45:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-XHXH-17-T' AND kode_barcode='T0060254';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-XHXH-17-T','T0060254','2025-09-12',' 12:45:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WHAI-7-T' AND kode_barcode='T0047737';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WHAI-7-T','T0047737','2025-09-12',' 12:45:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WEXD-32-T' AND kode_barcode='T0044004';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WEXD-32-T','T0044004','2025-09-12',' 12:45:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YGBD-80-T' AND kode_barcode='T0071508';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YGBD-80-T','T0071508','2025-09-12',' 12:46:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VIAG-30-T' AND kode_barcode='T0037956';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VIAG-30-T','T0037956','2025-09-12',' 12:46:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VEBF-66-T' AND kode_barcode='T0034478';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VEBF-66-T','T0034478','2025-09-12',' 12:46:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VKBB-72-T' AND kode_barcode='T0040036';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VKBB-72-T','T0040036','2025-09-12',' 12:46:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VEBF-67-T' AND kode_barcode='T0034479';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VEBF-67-T','T0034479','2025-09-12',' 12:46:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YHBG-4-T' AND kode_barcode='T0072596';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YHBG-4-T','T0072596','2025-09-12',' 12:46:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TD-YFBF-67-T' AND kode_barcode='T0070434';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TD-YFBF-67-T','T0070434','2025-09-12',' 12:46:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UCBG-43-T' AND kode_barcode='T0002306';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UCBG-43-T','T0002306','2025-09-12',' 12:46:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WHAB-11-T' AND kode_barcode='T0047312';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WHAB-11-T','T0047312','2025-09-12',' 12:47:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-XIBF-26-T' AND kode_barcode='T0062309';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-XIBF-26-T','T0062309','2025-09-12',' 12:47:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-XAXC-19-T' AND kode_barcode='T0052864';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-XAXC-19-T','T0052864','2025-09-12',' 12:47:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VEBF-77-T' AND kode_barcode='T0034489';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VEBF-77-T','T0034489','2025-09-12',' 12:47:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-YGBD-76-T' AND kode_barcode='T0071504';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-YGBD-76-T','T0071504','2025-09-12',' 12:47:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UEBH-35-T' AND kode_barcode='T0007063';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UEBH-35-T','T0007063','2025-09-12',' 12:47:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YBBA-10-T' AND kode_barcode='T0067233';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YBBA-10-T','T0067233','2025-09-12',' 12:47:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-XGAE-6-T' AND kode_barcode='T0059286';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-XGAE-6-T','T0059286','2025-09-12',' 12:47:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D0TA-WLBF-80-T' AND kode_barcode='T0052741';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D0TA-WLBF-80-T','T0052741','2025-09-12',' 12:47:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WHAI-11-T' AND kode_barcode='T0047741';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WHAI-11-T','T0047741','2025-09-12',' 12:47:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-XIBF-27-T' AND kode_barcode='T0062310';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-XIBF-27-T','T0062310','2025-09-12',' 12:47:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VEBF-80-T' AND kode_barcode='T0034492';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VEBF-80-T','T0034492','2025-09-12',' 12:47:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-VEBF-78-T' AND kode_barcode='T0034490';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-VEBF-78-T','T0034490','2025-09-12',' 12:47:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-UCBG-94-T' AND kode_barcode='T0002357';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-UCBG-94-T','T0002357','2025-09-12',' 12:48:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-YGBD-78-T' AND kode_barcode='T0071506';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-YGBD-78-T','T0071506','2025-09-12',' 12:48:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UEBH-33-T' AND kode_barcode='T0007061';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UEBH-33-T','T0007061','2025-09-12',' 12:48:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UCXI-69-T' AND kode_barcode='T0001094';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UCXI-69-T','T0001094','2025-09-12',' 12:48:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-XLBG-32-T' AND kode_barcode='T0065384';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-XLBG-32-T','T0065384','2025-09-12',' 12:48:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D0TA-YDAH-23-T' AND kode_barcode='T0068709';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D0TA-YDAH-23-T','T0068709','2025-09-12',' 12:48:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-YIXD-54-T' AND kode_barcode='T0072906';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-YIXD-54-T','T0072906','2025-09-12',' 12:48:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YDAH-31-T' AND kode_barcode='T0068717';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YDAH-31-T','T0068717','2025-09-12',' 12:48:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WJXG-55-T' AND kode_barcode='T0049385';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WJXG-55-T','T0049385','2025-09-12',' 12:48:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-XDBI-8-T' AND kode_barcode='T0056745';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-XDBI-8-T','T0056745','2025-09-12',' 12:48:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WABG-6-T' AND kode_barcode='T0041814';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WABG-6-T','T0041814','2025-09-12',' 12:48:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WABG-2-T' AND kode_barcode='T0041810';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WABG-2-T','T0041810','2025-09-12',' 12:48:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UCBI-36-T' AND kode_barcode='T0002494';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UCBI-36-T','T0002494','2025-09-12',' 12:48:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-VDAI-164-T' AND kode_barcode='T0032934';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-VDAI-164-T','T0032934','2025-09-12',' 12:48:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YGCX-5-T' AND kode_barcode='T0071670';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YGCX-5-T','T0071670','2025-09-12',' 12:48:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-VFXB-9-T' AND kode_barcode='T0034698';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-VFXB-9-T','T0034698','2025-09-12',' 12:49:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YDAH-32-T' AND kode_barcode='T0068718';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YDAH-32-T','T0068718','2025-09-12',' 12:49:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TG-XBXG-42-T' AND kode_barcode='T0053864';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TG-XBXG-42-T','T0053864','2025-09-12',' 12:49:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YDAH-34-T' AND kode_barcode='T0068720';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YDAH-34-T','T0068720','2025-09-12',' 12:49:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UCBI-11-T' AND kode_barcode='T0002469';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UCBI-11-T','T0002469','2025-09-12',' 12:49:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-VDAI-167-T' AND kode_barcode='T0032937';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-VDAI-167-T','T0032937','2025-09-12',' 12:49:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-VLXH-148-T' AND kode_barcode='T0040678';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-VLXH-148-T','T0040678','2025-09-12',' 12:49:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YGCX-8-T' AND kode_barcode='T0071673';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YGCX-8-T','T0071673','2025-09-12',' 12:49:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YGCX-6-T' AND kode_barcode='T0071671';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YGCX-6-T','T0071671','2025-09-12',' 12:49:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UBAI-44-T' AND kode_barcode='T0000044';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UBAI-44-T','T0000044','2025-09-12',' 12:49:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WEXI-26-T' AND kode_barcode='T0044127';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WEXI-26-T','T0044127','2025-09-12',' 12:49:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-XGAF-17-T' AND kode_barcode='T0059357';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-XGAF-17-T','T0059357','2025-09-12',' 12:49:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-XGAF-18-T' AND kode_barcode='T0059358';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-XGAF-18-T','T0059358','2025-09-12',' 12:49:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WJXG-56-T' AND kode_barcode='T0049386';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WJXG-56-T','T0049386','2025-09-12',' 12:49:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WJBE-4-T' AND kode_barcode='T0049970';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WJBE-4-T','T0049970','2025-09-12',' 12:49:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WABX-6-T' AND kode_barcode='T0041492';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WABX-6-T','T0041492','2025-09-12',' 12:49:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YGCX-4-T' AND kode_barcode='T0071669';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YGCX-4-T','T0071669','2025-09-12',' 12:49:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YDAH-36-T' AND kode_barcode='T0068722';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YDAH-36-T','T0068722','2025-09-12',' 12:50:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UCBI-10-T' AND kode_barcode='T0002468';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UCBI-10-T','T0002468','2025-09-12',' 12:50:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WGXA-3-T' AND kode_barcode='T0045758';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WGXA-3-T','T0045758','2025-09-12',' 12:50:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WBXD-20-T' AND kode_barcode='T0042026';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WBXD-20-T','T0042026','2025-09-12',' 12:50:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-WABG-11-T' AND kode_barcode='T0041819';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-WABG-11-T','T0041819','2025-09-12',' 12:50:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YGCX-7-T' AND kode_barcode='T0071672';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YGCX-7-T','T0071672','2025-09-12',' 12:50:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TG-YBXD-38-T' AND kode_barcode='T0066540';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TG-YBXD-38-T','T0066540','2025-09-12',' 12:50:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-YFAA-68-T' AND kode_barcode='T0069919';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-YFAA-68-T','T0069919','2025-09-12',' 12:50:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-YFAA-69-T' AND kode_barcode='T0069920';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-YFAA-69-T','T0069920','2025-09-12',' 12:50:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-UGAI-113-T' AND kode_barcode='T0012570';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-UGAI-113-T','T0012570','2025-09-12',' 12:51:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D2TE-WBXH-7-T' AND kode_barcode='T0042082';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D2TE-WBXH-7-T','T0042082','2025-09-12',' 12:51:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-VKAA-20-T' AND kode_barcode='T0039590';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-VKAA-20-T','T0039590','2025-09-12',' 12:51:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='D1TF-YIXD-53-T' AND kode_barcode='T0072905';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('D1TF-YIXD-53-T','T0072905','2025-09-12',' 12:51:41','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-12 12:52:48');
CREATE TABLE th_20250912_125248 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_125248_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-12 12:52:51');
CREATE TABLE th_20250912_125251 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250912_125251_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 ('F225121258181','kasir','1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YGAG-229-0','CC X MODEL MATA BM 12 8K ','OL','1.020','1','100.00','901000','0','0','15000','923000','0','5000','0','928000','TJ','00361314','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGAG-229-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-09-12' AND kode_barang='E2D-YGAG-229-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 ('F225121258181','2025-09-12','1.020','2025-09-12','12:58:19','PLG0072563','923000','923000','5000','928000','0','kasir','2025-09-12 12:58:18','F22512125818');
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-12','F225121258181','2025-09-12','12:58:19','TJ','928000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250912-0002','2025-09-12','2025-09-12 12:58:18','PENJUALAN : F225121258181','78429842049','BCA','928000','928000','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-250912-0003','D','2025-09-12','12:58:19','BCA','PENJUALAN','F225121258181','3979732888','928000','3980660888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('78429842049','ENDANG');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='928000' WHERE no_faktur_jual='F225121258181' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121258181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121258181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121258181';
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-00004613','X-00004613','GL PIPA MODEL MATA SLEP VAR PM D56 8K','GR','---','F2E','BELI','BELI001','3773000','2025-09-12','5.020','1','kasir','2025-09-12 14:39:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00004613','X-00004613');
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-250912-0001','F225040219512','RHM','1','BELI','BELI001','F2E', 'X-00004613', 'GL PIPA MODEL MATA SLEP VAR PM D56 8K','5.020','5.020','100.00','4192000','3773000','751594','900000','1','3773000','3773000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.020',berat_beli_asli=berat_beli_asli+'5.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.020',berat_akhir_asli=berat_akhir_asli+'5.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-250912-0001','2025-09-12','2025-09-12','14:39:25','RHM','---','5.020','3773000','3773000','3773000','3773000','3773000','kasir','2025-09-12 14:39:25','FB-250912-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250912-0001','BU SUWINI','PUPUS. NGEBEL','','','085879150608','kasir','2025-09-12 14:39:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-12' 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-250912-0008','K','2025-09-12','14:39:25','kasir','PEMBELIAN UMUM','FB-250912-0001','229169000','3773000','225396000');
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-00004614','X-00004614','AT ANAK MODEL BONEKA CAT VAR LG 17K','GR','---','A1TE','BELI','BELI001','267000','2025-09-12','0.230','1','kasir','2025-09-12 14:39:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00004614','X-00004614');
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-250912-0002','F225161028321','NS','1','BELI','BELI001','A1TE', 'X-00004614', 'AT ANAK MODEL BONEKA CAT VAR LG 17K','0.550','0.230','100.00','801000','267000','1160870','1595000','1','267000','267000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.230',berat_beli_asli=berat_beli_asli+'0.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.230',berat_akhir_asli=berat_akhir_asli+'0.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-250912-0002','2025-09-12','2025-09-12','14:39:45','NS','---','0.230','267000','267000','267000','267000','267000','kasir','2025-09-12 14:39:46','FB-250912-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250912-0002','SUNDARI','NGASINAN JETIS 1/1','','','08973459684','kasir','2025-09-12 14:39:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-12' 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-250912-0009','K','2025-09-12','14:39:45','kasir','PEMBELIAN UMUM','FB-250912-0002','225396000','267000','225129000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120809431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120809431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120809431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120834041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120834041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120834041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121008511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121008511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121008511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121010311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121010311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121010311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121038161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121038161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121038161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121043061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121043061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121043061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121053131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121053131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121053131';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250912-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250912-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250912-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250912-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-12';
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-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-12';
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-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-12' 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-250913-0001','D','2025-09-13','16:02:57','SYSTEM','SALDO AWAL','SALDO AWAL','0','225129000','225129000');
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-250913-0001','D','2025-09-13','16:02:57','BCA','SALDO AWAL','SALDO AWAL','0','3980660888','3980660888');
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-250913-0001','D','2025-09-13','16:02:57','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250913-0001','D','2025-09-13','16:02:57','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-250913-0001','D','2025-09-13','16:02:57','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-250913-0001','D','2025-09-13','16:02:57','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-09-13';
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-20250913-0001','1','A1D-YIAB-12-0','1','1.040','1.040','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YIAB-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YIAB-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-09-13 16:53:08' WHERE kode_barang='A1D-YIAB-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YIAB-12-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-13 16:53:08','TOKO','SMBK-A','A1D','A1D-YIAB-12-0','1','1.040','1.040','1','1.040','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YIAB-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YIAB-12-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:52','1.040','input','2025-09-12 16:53:07');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250913-0001','1','B1D-YIAB-39-0','1','1.110','1.110','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-YIAB-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-YIAB-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-13 16:53:26' WHERE kode_barang='B1D-YIAB-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-YIAB-39-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-13 16:53:26','TOKO','SMBK-B','B1D','B1D-YIAB-39-0','1','1.110','1.110','1','1.110','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' 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='B1D-YIAB-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-YIAB-39-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-20250913-0001','1','B1G-YIAB-47-0','1','0.380','0.380','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-YIAB-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-YIAB-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-13 16:53:26' WHERE kode_barang='B1G-YIAB-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-YIAB-47-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-13 16:53:26','TOKO','SMBK-B','B1G','B1G-YIAB-47-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-YIAB-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-YIAB-47-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-20250913-0001','1','B1E-YIAB-54-0','1','0.690','0.690','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YIAB-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YIAB-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-13 16:53:26' WHERE kode_barang='B1E-YIAB-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YIAB-54-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-13 16:53:26','TOKO','SMBK-B','B1E','B1E-YIAB-54-0','1','0.690','0.690','1','0.690','0.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YIAB-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YIAB-54-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-20250913-0001','1','B1E-YIAB-55-0','1','0.860','0.860','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YIAB-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YIAB-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-13 16:53:26' WHERE kode_barang='B1E-YIAB-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YIAB-55-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-13 16:53:26','TOKO','SMBK-B','B1E','B1E-YIAB-55-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YIAB-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YIAB-55-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:53','3.040','input','2025-09-12 16:53:26');
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-20250913-0001','1','D1F-YHAD-212-0','1','0.570','0.570','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YHAD-212-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YHAD-212-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1F-YHAD-212-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YHAD-212-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-13 16:53:44','TOKO','SMBK-D','D1F','D1F-YHAD-212-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YHAD-212-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YHAD-212-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-20250913-0001','1','D1D-YIAB-59-0','1','1.940','1.940','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1D-YIAB-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1D-YIAB-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1D-YIAB-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1D-YIAB-59-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-13 16:53:44','TOKO','SMBK-D','D1D','D1D-YIAB-59-0','1','1.940','1.940','1','1.940','1.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1D' 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='D1D-YIAB-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1D-YIAB-59-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-20250913-0001','1','D1D-YIAB-60-0','1','1.180','1.180','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1D-YIAB-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1D-YIAB-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1D-YIAB-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1D-YIAB-60-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-13 16:53:44','TOKO','SMBK-D','D1D','D1D-YIAB-60-0','1','1.180','1.180','1','1.180','1.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1D' 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='D1D-YIAB-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1D-YIAB-60-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-20250913-0001','1','D2E-YIAB-65-0','1','0.430','0.430','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YIAB-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YIAB-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D2E-YIAB-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YIAB-65-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-13 16:53:44','TOKO','SMBK-D','D2E','D2E-YIAB-65-0','1','0.430','0.430','1','0.430','0.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YIAB-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YIAB-65-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-20250913-0001','1','D1G-YIAB-70-0','1','0.380','0.380','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-YIAB-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-YIAB-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1G-YIAB-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-YIAB-70-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-13 16:53:44','TOKO','SMBK-D','D1G','D1G-YIAB-70-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-YIAB-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-YIAB-70-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-20250913-0001','1','D1G-YIAB-71-0','1','0.350','0.350','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-YIAB-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-YIAB-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1G-YIAB-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-YIAB-71-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-13 16:53:44','TOKO','SMBK-D','D1G','D1G-YIAB-71-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-YIAB-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-YIAB-71-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-20250913-0001','1','D1F-YIAB-78-0','1','0.890','0.890','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YIAB-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YIAB-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-09-13 16:53:44' WHERE kode_barang='D1F-YIAB-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YIAB-78-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-13 16:53:44','TOKO','SMBK-D','D1F','D1F-YIAB-78-0','1','0.890','0.890','1','0.890','0.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YIAB-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YIAB-78-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:53','5.740','input','2025-09-12 16:53:44');
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-20250913-0001','1','E2D-YIAB-266-0','1','1.160','1.160','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-266-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-266-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-266-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-266-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-266-0','1','1.160','1.160','1','1.160','1.160','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-YIAB-266-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-266-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-20250913-0001','1','E2D-YIAB-267-0','1','0.870','0.870','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-267-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-267-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-267-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-267-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-267-0','1','0.870','0.870','1','0.870','0.870','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-YIAB-267-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-267-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-20250913-0001','1','E2D-YIAB-268-0','1','0.960','0.960','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-268-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-268-0','1','0.960','0.960','1','0.960','0.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YIAB-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-268-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-20250913-0001','1','E2D-YIAB-269-0','1','0.920','0.920','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-269-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-269-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-269-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-269-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-269-0','1','0.920','0.920','1','0.920','0.920','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-YIAB-269-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-269-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-20250913-0001','1','E2D-YIAB-270-0','1','0.800','0.800','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-270-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-270-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-270-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-270-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-270-0','1','0.800','0.800','1','0.800','0.800','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-YIAB-270-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-270-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-20250913-0001','1','E2D-YIAB-271-0','1','0.800','0.800','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-271-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-271-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-271-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-271-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-271-0','1','0.800','0.800','1','0.800','0.800','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-YIAB-271-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-271-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-20250913-0001','1','E2D-YIAB-272-0','1','0.820','0.820','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YIAB-272-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YIAB-272-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2D-YIAB-272-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YIAB-272-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-13 16:54:05','TOKO','SMBK-E','E2D','E2D-YIAB-272-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-YIAB-272-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YIAB-272-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-20250913-0001','1','E1D-YIAB-273-0','1','1.380','1.380','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YIAB-273-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YIAB-273-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E1D-YIAB-273-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YIAB-273-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-13 16:54:05','TOKO','SMBK-E','E1D','E1D-YIAB-273-0','1','1.380','1.380','1','1.380','1.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YIAB-273-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YIAB-273-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-20250913-0001','1','E1D-YIAB-274-0','1','1.420','1.420','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YIAB-274-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YIAB-274-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E1D-YIAB-274-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YIAB-274-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-13 16:54:05','TOKO','SMBK-E','E1D','E1D-YIAB-274-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YIAB-274-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YIAB-274-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-20250913-0001','1','E2E-YIAB-275-0','1','0.660','0.660','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIAB-275-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIAB-275-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2E-YIAB-275-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIAB-275-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-13 16:54:05','TOKO','SMBK-E','E2E','E2E-YIAB-275-0','1','0.660','0.660','1','0.660','0.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIAB-275-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIAB-275-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-20250913-0001','1','E2E-YIAB-276-0','1','0.530','0.530','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIAB-276-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIAB-276-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2E-YIAB-276-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIAB-276-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-13 16:54:05','TOKO','SMBK-E','E2E','E2E-YIAB-276-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIAB-276-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIAB-276-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-20250913-0001','1','E2E-YIAB-277-0','1','0.530','0.530','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIAB-277-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIAB-277-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-13 16:54:05' WHERE kode_barang='E2E-YIAB-277-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIAB-277-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-13 16:54:05','TOKO','SMBK-E','E2E','E2E-YIAB-277-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIAB-277-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIAB-277-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:53','10.850','input','2025-09-12 16:54:05');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250913-0001','1','F1E-YIAB-124-0','1','3.960','3.960','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YIAB-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YIAB-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-09-13 16:54:27' WHERE kode_barang='F1E-YIAB-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YIAB-124-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-13 16:54:27','TOKO','SMBK-F','F1E','F1E-YIAB-124-0','1','3.960','3.960','1','3.960','3.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YIAB-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YIAB-124-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-20250913-0001','1','F3E-YIAB-176-0','1','1.570','1.570','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIAB-176-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIAB-176-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-09-13 16:54:27' WHERE kode_barang='F3E-YIAB-176-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIAB-176-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-13 16:54:27','TOKO','SMBK-F','F3E','F3E-YIAB-176-0','1','1.570','1.570','1','1.570','1.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YIAB-176-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIAB-176-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-20250913-0001','1','F3E-YIAB-177-0','1','1.960','1.960','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIAB-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIAB-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-09-13 16:54:27' WHERE kode_barang='F3E-YIAB-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIAB-177-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-13 16:54:27','TOKO','SMBK-F','F3E','F3E-YIAB-177-0','1','1.960','1.960','1','1.960','1.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YIAB-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIAB-177-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-20250913-0001','1','F4J-YIAB-178-0','1','0.950','0.950','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F4J-YIAB-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4J-YIAB-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-09-13 16:54:27' WHERE kode_barang='F4J-YIAB-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4J-YIAB-178-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-13 16:54:27','TOKO','SMBK-F','F4J','F4J-YIAB-178-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4J-YIAB-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4J-YIAB-178-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:54','8.440','input','2025-09-12 16:54:26');
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-20250913-0001','1','H2J-YIAB-202-0','1','5.010','5.010','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YIAB-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YIAB-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H2J-YIAB-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YIAB-202-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-13 16:54:46','TOKO','SMBK-H','H2J','H2J-YIAB-202-0','1','5.010','5.010','1','5.010','5.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YIAB-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YIAB-202-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-20250913-0001','1','H2I-YIAB-203-0','1','1.270','1.270','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YIAB-203-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YIAB-203-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H2I-YIAB-203-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YIAB-203-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-13 16:54:46','TOKO','SMBK-H','H2I','H2I-YIAB-203-0','1','1.270','1.270','1','1.270','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YIAB-203-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YIAB-203-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-20250913-0001','1','H2I-YIAB-204-0','1','3.030','3.030','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-YIAB-204-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-YIAB-204-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H2I-YIAB-204-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-YIAB-204-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-13 16:54:46','TOKO','SMBK-H','H2I','H2I-YIAB-204-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-YIAB-204-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-YIAB-204-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-20250913-0001','1','H1F-YIAB-205-0','1','5.050','5.050','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YIAB-205-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YIAB-205-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1F-YIAB-205-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YIAB-205-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-13 16:54:46','TOKO','SMBK-H','H1F','H1F-YIAB-205-0','1','5.050','5.050','1','5.050','5.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YIAB-205-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YIAB-205-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-20250913-0001','1','H1F-YIAB-206-0','1','3.080','3.080','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YIAB-206-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YIAB-206-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1F-YIAB-206-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YIAB-206-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-13 16:54:46','TOKO','SMBK-H','H1F','H1F-YIAB-206-0','1','3.080','3.080','1','3.080','3.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YIAB-206-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YIAB-206-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-20250913-0001','1','H1F-YIAB-207-0','1','1.010','1.010','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YIAB-207-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YIAB-207-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1F-YIAB-207-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YIAB-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-13 16:54:46','TOKO','SMBK-H','H1F','H1F-YIAB-207-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YIAB-207-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YIAB-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-20250913-0001','1','H1E-YIAB-208-0','1','2.060','2.060','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YIAB-208-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YIAB-208-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1E-YIAB-208-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YIAB-208-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-13 16:54:46','TOKO','SMBK-H','H1E','H1E-YIAB-208-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YIAB-208-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YIAB-208-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-20250913-0001','1','H1E-YIAB-209-0','1','2.070','2.070','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YIAB-209-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YIAB-209-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1E-YIAB-209-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YIAB-209-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-13 16:54:46','TOKO','SMBK-H','H1E','H1E-YIAB-209-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YIAB-209-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YIAB-209-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-20250913-0001','1','H1E-YIAB-210-0','1','0.980','0.980','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YIAB-210-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YIAB-210-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1E-YIAB-210-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YIAB-210-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-13 16:54:46','TOKO','SMBK-H','H1E','H1E-YIAB-210-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YIAB-210-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YIAB-210-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-20250913-0001','1','H1E-YIAB-211-0','1','1.100','1.100','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YIAB-211-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YIAB-211-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-13 16:54:46' WHERE kode_barang='H1E-YIAB-211-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YIAB-211-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-13 16:54:46','TOKO','SMBK-H','H1E','H1E-YIAB-211-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YIAB-211-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YIAB-211-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:54','24.660','input','2025-09-12 16:54:45');
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-20250913-0001','1','PFG-YIAB-81-0','1','2.210','2.210','TOKO','SSBK-P','TOKO','SMBK-P');
DELETE FROM tm_barang WHERE kode_barang='PFG-YIAB-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PFG-YIAB-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-P',tgl_last_beli='2025-09-13 16:55:09' WHERE kode_barang='PFG-YIAB-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PFG-YIAB-81-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-13 16:55:09','TOKO','SMBK-P','PFG','PFG-YIAB-81-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PFG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PFG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PFG-YIAB-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='PFG-YIAB-81-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250913-0001','2025-09-13','16:54','2.210','input','2025-09-12 16:55:09');