INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','08:55:32'); 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-20261028-0001','1','PSPLT-ZJBG-25-0','1','4.980','4.980','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPLT-ZJBG-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-25-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPLT','PSPLT-ZJBG-25-0','1','4.980','4.980','1','4.980','4.980','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBG-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPLT-ZJBG-26-0','1','3.630','3.630','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPLT-ZJBG-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-26-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPLT','PSPLT-ZJBG-26-0','1','3.630','3.630','1','3.630','3.630','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBG-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPRT-ZJBG-27-0','1','3.510','3.510','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPRT-ZJBG-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPRT','PSPRT-ZJBG-27-0','1','3.510','3.510','1','3.510','3.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPRT-ZJBG-28-0','1','4.200','4.200','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPRT-ZJBG-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPRT','PSPRT-ZJBG-28-0','1','4.200','4.200','1','4.200','4.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPRT-ZJBG-32-0','1','2.950','2.950','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPRT-ZJBG-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPRT','PSPRT-ZJBG-32-0','1','2.950','2.950','1','2.950','2.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPLT-ZJBH-4-0','1','3.880','3.880','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBH-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBH-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBH-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPLT-ZJBH-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBH-4-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPLT','PSPLT-ZJBH-4-0','1','3.880','3.880','1','3.880','3.880','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBH-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBH-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0001','1','PSPRT-ZJBH-5-0','1','2.000','2.000','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBH-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBH-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBH-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-28 08:56:00' WHERE kode_barang='PSPRT-ZJBH-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBH-5-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 08:56:00','TOKO','MMPSN','PSPRT','PSPRT-ZJBH-5-0','1','2.000','2.000','1','2.000','2.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBH-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBH-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261028-0001','2026-10-28','08:55','25.150','kasir','2026-10-28 08:56:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','09:04:35'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-28 ','09:53:08'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-28 ','10:54:01'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0001','kasirbip','1',' DP-04453DU','TOKO','DUPSN','PSPLT-ZJBF-19-0','CINCIN PALADIUM ','','3.320','1','17.00','746000','0','0','17800','1912000','0','0','0','1912000','PUT','00048629','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPLT-ZJBF-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0001','2026-10-28','3.320','2026-10-28','10:57:18','PLG0018049','1912000','1912000','0','1912000','0','kasirbip','2026-10-28 10:57:17','FJ-261028-0001','DP-04453','1580000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0001','2026-10-28','10:57:18','PUT','1912000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0001','2026-10-28','2026-10-28 10:57:17','PENJUALAN : FJ-261028-0001','.','TBC','332000','332000','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-261028-0002','D','2026-10-28','10:57:18','TBC','PENJUALAN','FJ-261028-0001','30066480464','332000','30066812464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='332000' WHERE no_faktur_jual='FJ-261028-0001' 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,potong_rp,keterangan) VALUES ('FJ-261028-0002','kasirbip',' 1',' DP-04452DU','TOKO','DUPSN','PSGT-ZJBF-33-0','CINCIN EMAS ','','2.000','1','45.00','2112000','0','0','17800','3550000','0','0','0','3550000','PUT','00048643','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBF-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSGT-ZJBF-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0002','2026-10-28','2.000','2026-10-28','10:57:18','PLG0018050','3550000','3550000','0','3550000','0','kasirbip','2026-10-28 10:57:17','FJ-261028-0001','DP-04452','2840000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0002','2026-10-28','10:57:18','PUT','3550000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0002','2026-10-28','2026-10-28 10:57:17','PENJUALAN : FJ-261028-0002','.','TBC','710000','710000','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-261028-0003','D','2026-10-28','10:57:18','TBC','PENJUALAN','FJ-261028-0002','30066812464','710000','30067522464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1042000' WHERE no_faktur_jual='FJ-261028-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','11:03:48'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-28 ','12:00:42'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-28 ','12:09:14'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04849','ADL','1','PLD','WEDDING RING','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','sz cwe 17 5','gf Vintage : Aliffatah...Pusma','Warna mix gold dan white','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0003','2026-10-28','2026-10-28 12:16:26','PESANAN : DP-04849','-','TBC','1500000','1500000'); 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-261028-0004','D','2026-10-28','12:16:26','TBC','PESANAN','DP-04849','30067522464','1500000','30069022464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04849','2026-10-28','2026-10-28','12:16:26','PLG0018051','ADL','2026-11-22','jogja','2026-10-28 12:16:26','4.000','0','0','0','1500000','0','800000','3000000','3000000','1500000'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0003','kasirbip','1',' DP-04450BI','TOKO','BIPPSN','PSPRT-ZJBF-30-0','CINCIN PERAK SR03 YL01 ','','3.210','1','100.00','328000','0','0','17800','950000','0','0','0','950000','KUR','00048640','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.210',berat_jual_asli=berat_jual_asli+'3.210',stock_jual='1',berat_akhir=berat_akhir-'3.210',berat_akhir_asli=berat_akhir_asli-'3.210',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBF-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0003','2026-10-28','3.210','2026-10-28','12:33:18','PLG0018052','950000','950000','0','950000','0','kasirbip','2026-10-28 12:33:18','FJ-261028-0003','DP-04450','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0003','2026-10-28','12:33:18','KUR','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0003' 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,potong_rp,keterangan) VALUES ('FJ-261028-0004','kasirbip','1',' DP-04302BI','TOKO','BIPPSN','PSGT-ZJBA-32-0','CINCIN EMAS ','','2.350','1','57.00','3143000','0','0','17800','5030000','0','0','0','5030000','SULIS','00048462','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBA-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSGT-ZJBA-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0004','2026-10-28','2.350','2026-10-28','12:49:11','PLG0018053','5030000','5030000','0','5030000','0','kasirbip','2026-10-28 12:49:11','FJ-261028-0004','DP-04302','4240000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0004','2026-10-28','12:49:11','SULIS','5030000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0004','2026-10-28','2026-10-28 12:49:11','PENJUALAN : FJ-261028-0004','.','TBC','790000','790000','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-261028-0005','D','2026-10-28','12:49:11','TBC','PENJUALAN','FJ-261028-0004','30069022464','790000','30069812464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='790000' WHERE no_faktur_jual='FJ-261028-0004' 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,potong_rp,keterangan) VALUES ('FJ-261028-0005','kasirbip',' 1',' DP-04303BI','TOKO','BIPPSN','PSPLT-ZJBF-27-0','CINCIN PALADIUM ','','3.190','1','32.00','1348000','0','0','17800','2504500','0','0','0','2504500','SULIS','00048637','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPLT-ZJBF-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0005','2026-10-28','3.190','2026-10-28','12:49:11','PLG0018054','2504500','2504500','0','2504500','0','kasirbip','2026-10-28 12:49:11','FJ-261028-0004','DP-04303','2140000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0005','2026-10-28','12:49:11','SULIS','2504500','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0005','2026-10-28','2026-10-28 12:49:11','PENJUALAN : FJ-261028-0005','.','TBC','364500','364500','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-261028-0006','D','2026-10-28','12:49:11','TBC','PENJUALAN','FJ-261028-0005','30069812464','364500','30070176964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1154500' WHERE no_faktur_jual='FJ-261028-0005' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04850','MIL','1','PLD','WEDRING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','sz cwo 23 crom putih glosy doff semprot','grf Hilma-17.12.2026 font yeseva','EXSPRESS 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0006','2026-10-28','2026-10-28 12:51:38','PESANAN : DP-04850','.','TBC','2040000','2040000'); 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-261028-0007','D','2026-10-28','12:51:38','TBC','PESANAN','DP-04850','30070176964','2040000','30072216964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04850','2026-10-28','2026-10-28','12:51:38','PLG0018055','MIL','2026-11-12','kasirbip','2026-10-28 12:51:38','5.000','0','0','0','2040000','0','800000','2550000','2550000','510000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04851','MIL','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','800000','1675000','sz cwe 14 crom putih glosy doff semprot','grf Fajar-07.12.2026 fony yeseva','EXSPRESS 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0007','2026-10-28','2026-10-28 12:54:34','PESANAN : DP-04851','.','TBC','1340000','1340000'); 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-261028-0008','D','2026-10-28','12:54:34','TBC','PESANAN','DP-04851','30072216964','1340000','30073556964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04851','2026-10-28','2026-10-28','12:54:34','PLG0018056','MIL','2026-11-12','kasirbip','2026-10-28 12:54:34','2.500','0','0','0','1340000','0','800000','1675000','1675000','335000'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0006','kasirbip','1',' 500K-175-0','TOKO','DUPERBDG','LXPER-ZEBB-7-0','CINCIN SILVER 925 YL-01 ','','2.190','1','100.00','224000','0','0','17800','600000','0','0','0','600000','PUT','00043719','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBB-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='LXPER-ZEBB-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0006','2026-10-28','2.190','2026-10-28','14:07:09','PLG0018057','600000','600000','0','600000','0','kasirbip','2026-10-28 14:07:08','FJ-261028-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0006','2026-10-28','14:07:09','PUT','600000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0008','2026-10-28','2026-10-28 14:07:08','PENJUALAN : FJ-261028-0006','.','TBC','600000','600000','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-261028-0009','D','2026-10-28','14:07:09','TBC','PENJUALAN','FJ-261028-0006','30073556964','600000','30074156964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='600000' WHERE no_faktur_jual='FJ-261028-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0006'; 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,potong_rp,keterangan) VALUES ('FJ-261028-0007','kasirbip','1',' DP-04305DU','TOKO','DUPSN','PSPRT-ZJBC-32-0','CINCIN PERAK ','','2.440','1','100.00','249000','0','0','17800','1000000','0','0','0','1000000','PUT','00048552','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBC-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0007','2026-10-28','2.440','2026-10-28','14:29:00','PLG0018058','1000000','1000000','0','1000000','0','kasirbip','2026-10-28 14:28:59','FJ-261028-0007','DP-04305','1000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0007','2026-10-28','14:29:00','PUT','1000000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0007' 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,potong_rp,keterangan) VALUES ('FJ-261028-0008','kasirbip',' 1',' DP-04306DU','TOKO','DUPSN','PSPRT-ZJBC-49-0','CINCIN PERAK ','','2.900','1','100.00','296000','0','0','17800','850000','0','0','0','850000','PUT','00048569','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBC-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0008','2026-10-28','2.900','2026-10-28','14:29:00','PLG0018059','850000','850000','0','850000','0','kasirbip','2026-10-28 14:28:59','FJ-261028-0007','DP-04306','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0008','2026-10-28','14:29:00','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0008'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02302','SULIS','1','CC SILVER','CEOM KUNING GLOSY DAN DOFF KOMB PUTIH DOFF AMPLASS','3.000','1','50000','50000'); 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-261028-0009','2026-10-28','2026-10-28 14:57:28','SERVICE : SV-02302','.','TBC','50000','50000','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-261028-0010','D','2026-10-28','14:57:28','TBC','SERVICE','SV-02302','30074156964','50000','30074206964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02302','2026-10-28','2026-10-28','14:57:28','PLG0018060','kasirbip','2026-11-12','kasirbip','2026-10-28 14:57:28','3.000','0','0','0','50000','0','50000','50000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','15:02:06'); 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-20261028-0002','1','PSPRT-ZJBG-41-0','1','3.280','3.280','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-28 16:26:08' WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 16:26:08','TOKO','SBYPSN','PSPRT','PSPRT-ZJBG-41-0','1','3.280','3.280','1','3.280','3.280','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0002','1','PSPLT-ZJBG-42-0','1','3.410','3.410','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-42-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-42-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-28 16:26:08' WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 16:26:08','TOKO','SBYPSN','PSPLT','PSPLT-ZJBG-42-0','1','3.410','3.410','1','3.410','3.410','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBG-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-42-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0002','1','PSPRT-ZJBG-47-0','1','2.950','2.950','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-47-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-47-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-47-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-28 16:26:08' WHERE kode_barang='PSPRT-ZJBG-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-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 ('2026-10-28 16:26:08','TOKO','SBYPSN','PSPRT','PSPRT-ZJBG-47-0','1','2.950','2.950','1','2.950','2.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-47-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261028-0002','2026-10-28','16:25','9.640','sby','2026-10-28 16:26:08'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0009','sby','1',' 800K-155-0','TOKO','SBYPER','PSBY-ZJXE-13-0','CINCIN SILVER 925 ','','2.760','1','100.00','282000','0','0','17800','900000','0','0','0','900000','ARA','00047898','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJXE-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSBY-ZJXE-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0009','2026-10-28','2.760','2026-10-28','16:30:17','PLG0018061','900000','900000','0','900000','0','sby','2026-10-28 16:30:17','FJ-261028-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0009','2026-10-28','16:30:17','ARA','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0010','2026-10-28','2026-10-28 16:30:17','PENJUALAN : FJ-261028-0009','','TBC','900000','900000','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-261028-0011','D','2026-10-28','16:30:17','TBC','PENJUALAN','FJ-261028-0009','30074206964','900000','30075106964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261028-0009' 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,potong_rp,keterangan) VALUES ('FJ-261028-0010','sby',' 1',' 750K-13-00','TOKO','SBYPER','PSBY-ZEXA-52-0','CINCIN SILVER 925 ','','2.240','1','100.00','229000','0','0','17800','850000','0','0','0','850000','ARA','00043074','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-52-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSBY-ZEXA-52-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0010','2026-10-28','2.240','2026-10-28','16:30:17','PLG0018062','850000','850000','0','850000','0','sby','2026-10-28 16:30:17','FJ-261028-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0010','2026-10-28','16:30:17','ARA','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0011','2026-10-28','2026-10-28 16:30:17','PENJUALAN : FJ-261028-0010','','TBC','850000','850000','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-261028-0012','D','2026-10-28','16:30:17','TBC','PENJUALAN','FJ-261028-0010','30075106964','850000','30075956964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-261028-0010' 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,potong_rp,keterangan) VALUES ('FJ-261028-0011','sby','1',' DP-04195SB','TOKO','SBYPSN','PSGT-ZJAF-7-0','CINCIN EMAS ','','4.500','1','45.00','4751000','0','0','17800','7060000','0','0','0','7060000','DIL','00048204','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.500',berat_jual_asli=berat_jual_asli+'4.500',stock_jual='1',berat_akhir=berat_akhir-'4.500',berat_akhir_asli=berat_akhir_asli-'4.500',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSGT-ZJAF-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0011','2026-10-28','4.500','2026-10-28','16:34:27','PLG0018063','7060000','7060000','0','7060000','0','sby','2026-10-28 16:34:27','FJ-261028-0011','DP-04195','4900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0011','2026-10-28','16:34:27','DIL','7060000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0012','2026-10-28','2026-10-28 16:34:27','PENJUALAN : FJ-261028-0011','','TBC','2160000','2160000','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-261028-0013','D','2026-10-28','16:34:27','TBC','PENJUALAN','FJ-261028-0011','30075956964','2160000','30078116964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2160000' WHERE no_faktur_jual='FJ-261028-0011' 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,potong_rp,keterangan) VALUES ('FJ-261028-0012','sby',' 1',' DP-04196SB','TOKO','SBYPSN','PSGT-ZJAF-6-0','CINCIN EMAS ','','3.500','1','45.00','3695000','0','0','17800','5660000','0','0','0','5660000','DIL','00048203','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSGT-ZJAF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0012','2026-10-28','3.500','2026-10-28','16:34:27','PLG0018064','5660000','5660000','0','5660000','0','sby','2026-10-28 16:34:27','FJ-261028-0011','DP-04196','3900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0012','2026-10-28','16:34:27','DIL','5660000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0013','2026-10-28','2026-10-28 16:34:27','PENJUALAN : FJ-261028-0012','','TBC','1760000','1760000','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-261028-0014','D','2026-10-28','16:34:27','TBC','PENJUALAN','FJ-261028-0012','30078116964','1760000','30079876964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3920000' WHERE no_faktur_jual='FJ-261028-0012' 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,potong_rp,keterangan) VALUES ('FJ-261028-0013','jogja','1',' DP-04319JO','TOKO','JOGPSN','PSPRT-ZJBF-23-0','CINCIN PERAK ','','2.180','1','100.00','223000','0','0','17800','850000','0','0','0','850000','ADL','00048633','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBF-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0013','2026-10-28','2.180','2026-10-28','16:46:32','PLG0018065','850000','850000','0','850000','0','jogja','2026-10-28 16:46:31','FJ-261028-0013','DP-04319','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0013','2026-10-28','16:46:32','ADL','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0014','2026-10-28','2026-10-28 16:46:31','PENJUALAN : FJ-261028-0013','','TBC','850000','850000','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-261028-0015','D','2026-10-28','16:46:32','TBC','PENJUALAN','FJ-261028-0013','30079876964','850000','30080726964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261028-0013' 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,potong_rp,keterangan) VALUES ('FJ-261028-0014','jogja',' 1',' DP-04318JO','TOKO','JOGPSN','PSGT-ZJBF-40-0','CINCIN EMAS ','','2.060','1','45.00','2176000','0','0','17800','2884000','0','750000','0','3634000','ADL','00048650','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBF-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSGT-ZJBF-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0014','2026-10-28','2.060','2026-10-28','16:46:32','PLG0018066','2884000','2884000','750000','3634000','0','jogja','2026-10-28 16:46:31','FJ-261028-0013','DP-04318','1775000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0014','2026-10-28','16:46:32','ADL','3634000','750000'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261028-0014' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','17:05:51'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','17:06:17'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0015','kasir','1',' DP-04393MM','TOKO','MMPSN','PSPRT-ZJBG-27-0','CINCIN PERAK SR03 YL01 ','','3.510','1','100.00','359000','0','0','17800','950000','0','0','0','950000','ELLA','00048681','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBG-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0015','2026-10-28','3.510','2026-10-28','17:07:10','PLG0018067','950000','950000','0','950000','0','kasir','2026-10-28 17:07:10','FJ-261028-0015','DP-04393','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0015','2026-10-28','17:07:10','ELLA','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0015' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04852','KUR','1','GOLD','WED RING','','','2.500','','37.50','1','2300000','1400000','0','900000','4400000','22 rircon putih glosy sz 13','font yeseva one grf Agil','','220000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0015','2026-10-28','2026-10-28 17:27:10','PESANAN : DP-04852','.','TBC','3690000','3690000'); 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-261028-0016','D','2026-10-28','17:27:10','TBC','PESANAN','DP-04852','30080726964','3690000','30084416964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04852','2026-10-28','2026-10-28','17:27:10','PLG0018068','KUR','2026-11-22','kasirbip','2026-10-28 17:27:10','2.500','0','0','0','3690000','0','900000','4620000','4620000','930000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','17:27:35'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04853','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 15 putih doff semprot','font yeseva one grf Yulan','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0016','2026-10-28','2026-10-28 17:28:52','PESANAN : DP-04853','.','TBC','900000','900000'); 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-261028-0017','D','2026-10-28','17:28:52','TBC','PESANAN','DP-04853','30084416964','900000','30085316964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04853','2026-10-28','2026-10-28','17:28:52','PLG0018069','KUR','2026-11-22','kasirbip','2026-10-28 17:28:52','2.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04854','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','950000','0','950000','sz cwe 14.5 SR.04 grf 16.01.2027','sz cwo 18.5 YL.01 grf 16.01.2027','font Comic sans','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0017','2026-10-28','2026-10-28 17:37:04','PESANAN : DP-04854','.','TBC','1050000','1050000'); 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-261028-0018','D','2026-10-28','17:37:04','TBC','PESANAN','DP-04854','30085316964','1050000','30086366964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04854','2026-10-28','2026-10-28','17:37:04','PLG0018070','PUT','2026-11-30','kasirbip','2026-10-28 17:37:04','4.000','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04855','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','PERMATA 1 BUTIR (REQ LEBAR 4MM / DILEBARKAN DIKIT)','SIZE 18 GRF: Sanya ?? Efendi (BERKSHIRE)','CROM KUNING GLOSSY MIX PUTIH DOFF','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0018','2026-10-28','2026-10-28 17:50:50','PESANAN : DP-04855','-','TBC','2000000','2000000'); 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-261028-0019','D','2026-10-28','17:50:50','TBC','PESANAN','DP-04855','30086366964','2000000','30088366964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04855','2026-10-28','2026-10-28','17:50:50','PLG0018071','DIL','2026-11-22','sby','2026-10-28 17:50:50','4.000','0','0','0','2000000','0','750000','2960000','2960000','960000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','17:56:16'); UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2200000',harga_beli ='2200000' WHERE kode_barcode='00019926' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2315500',harga_beli ='2315500' WHERE kode_barcode='00019929' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2315500',harga_beli ='2315500' WHERE kode_barcode='00019933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7081500',harga_beli ='7081500' WHERE kode_barcode='00024887' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7255000',harga_beli ='7255000' WHERE kode_barcode='00024889' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5885500',harga_beli ='5885500' WHERE kode_barcode='00024890' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00024891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00024892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='00024893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='00024895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5866000',harga_beli ='5866000' WHERE kode_barcode='00024896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00024897' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5769500',harga_beli ='5769500' WHERE kode_barcode='00024898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5788500',harga_beli ='5788500' WHERE kode_barcode='00024899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5866000',harga_beli ='5866000' WHERE kode_barcode='00024900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00024901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00024902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00024903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='00024904' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='00024905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4129500',harga_beli ='4129500' WHERE kode_barcode='00024909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4245000',harga_beli ='4245000' WHERE kode_barcode='00024912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4148500',harga_beli ='4148500' WHERE kode_barcode='00024919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4206500',harga_beli ='4206500' WHERE kode_barcode='00024922' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4129500',harga_beli ='4129500' WHERE kode_barcode='00024923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16834500',harga_beli ='16834500' WHERE kode_barcode='00025675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17579500',harga_beli ='17579500' WHERE kode_barcode='00025676' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='18102000',harga_beli ='18102000' WHERE kode_barcode='00025677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15728000',harga_beli ='15728000' WHERE kode_barcode='00025679' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='27019500',harga_beli ='27019500' WHERE kode_barcode='00025682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16732500',harga_beli ='16732500' WHERE kode_barcode='00025683' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='19739000',harga_beli ='19739000' WHERE kode_barcode='00025684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8697000',harga_beli ='8697000' WHERE kode_barcode='00025687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16497000',harga_beli ='16497000' WHERE kode_barcode='00025697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10845000',harga_beli ='10845000' WHERE kode_barcode='00025702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4007500',harga_beli ='4007500' WHERE kode_barcode='00025711' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4276500',harga_beli ='4276500' WHERE kode_barcode='00025714' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12725000',harga_beli ='12725000' WHERE kode_barcode='00025716' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6404000',harga_beli ='6404000' WHERE kode_barcode='00025717' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4627500',harga_beli ='4627500' WHERE kode_barcode='00025718' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3801000',harga_beli ='3801000' WHERE kode_barcode='00025724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1529000',harga_beli ='1529000' WHERE kode_barcode='00025726' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1508000',harga_beli ='1508000' WHERE kode_barcode='00025727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='00025730' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9922500',harga_beli ='9922500' WHERE kode_barcode='00025740' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4957500',harga_beli ='4957500' WHERE kode_barcode='00025742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6004000',harga_beli ='6004000' WHERE kode_barcode='00025743' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='18872000',harga_beli ='18872000' WHERE kode_barcode='00025747' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='47595000',harga_beli ='47595000' WHERE kode_barcode='00025795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21104500',harga_beli ='21104500' WHERE kode_barcode='00025796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='44003000',harga_beli ='44003000' WHERE kode_barcode='00025797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15758500',harga_beli ='15758500' WHERE kode_barcode='00025798' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='19274500',harga_beli ='19274500' WHERE kode_barcode='00025799' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15354500',harga_beli ='15354500' WHERE kode_barcode='00025800' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5731000',harga_beli ='5731000' WHERE kode_barcode='00025877' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5576500',harga_beli ='5576500' WHERE kode_barcode='00025880' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4129500',harga_beli ='4129500' WHERE kode_barcode='00025882' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4843500',harga_beli ='4843500' WHERE kode_barcode='00025883' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00025888' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='27115500',harga_beli ='27115500' WHERE kode_barcode='00025892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12214000',harga_beli ='12214000' WHERE kode_barcode='00025893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9802000',harga_beli ='9802000' WHERE kode_barcode='00025894' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12445500',harga_beli ='12445500' WHERE kode_barcode='00025896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00026055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4333500',harga_beli ='4333500' WHERE kode_barcode='00026056' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3241000',harga_beli ='3241000' WHERE kode_barcode='00026058' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5480000',harga_beli ='5480000' WHERE kode_barcode='00026061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3820500',harga_beli ='3820500' WHERE kode_barcode='00026062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3666500',harga_beli ='3666500' WHERE kode_barcode='00026064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3627500',harga_beli ='3627500' WHERE kode_barcode='00026065' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2875000',harga_beli ='2875000' WHERE kode_barcode='00026070' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2856000',harga_beli ='2856000' WHERE kode_barcode='00026071' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4978500',harga_beli ='4978500' WHERE kode_barcode='00026072' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7544500',harga_beli ='7544500' WHERE kode_barcode='00026078' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11519500',harga_beli ='11519500' WHERE kode_barcode='00026079' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2238500',harga_beli ='2238500' WHERE kode_barcode='00026081' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4843500',harga_beli ='4843500' WHERE kode_barcode='00026082' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3673500',harga_beli ='3673500' WHERE kode_barcode='00026085' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15147000',harga_beli ='15147000' WHERE kode_barcode='00026086' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13661000',harga_beli ='13661000' WHERE kode_barcode='00026087' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='54971500',harga_beli ='54971500' WHERE kode_barcode='00026090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='57615000',harga_beli ='57615000' WHERE kode_barcode='00026091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10998500',harga_beli ='10998500' WHERE kode_barcode='00026093' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21147500',harga_beli ='21147500' WHERE kode_barcode='00026095' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17269500',harga_beli ='17269500' WHERE kode_barcode='00026096' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4824000',harga_beli ='4824000' WHERE kode_barcode='00026099' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3605000',harga_beli ='3605000' WHERE kode_barcode='00026104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5398000',harga_beli ='5398000' WHERE kode_barcode='00026105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3605000',harga_beli ='3605000' WHERE kode_barcode='00026106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3712500',harga_beli ='3712500' WHERE kode_barcode='00026107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4835500',harga_beli ='4835500' WHERE kode_barcode='00026108' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3569000',harga_beli ='3569000' WHERE kode_barcode='00026109' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3320500',harga_beli ='3320500' WHERE kode_barcode='00026110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3622500',harga_beli ='3622500' WHERE kode_barcode='00026111' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4755000',harga_beli ='4755000' WHERE kode_barcode='00026112' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5452000',harga_beli ='5452000' WHERE kode_barcode='00026113' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00026115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3948500',harga_beli ='3948500' WHERE kode_barcode='00026117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4002000',harga_beli ='4002000' WHERE kode_barcode='00026118' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3152000',harga_beli ='3152000' WHERE kode_barcode='00026119' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2691500',harga_beli ='2691500' WHERE kode_barcode='00026120' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2709500',harga_beli ='2709500' WHERE kode_barcode='00026121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='49309000',harga_beli ='49309000' WHERE kode_barcode='00026125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7711500',harga_beli ='7711500' WHERE kode_barcode='00026126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7206500',harga_beli ='7206500' WHERE kode_barcode='00026132' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9383000',harga_beli ='9383000' WHERE kode_barcode='00026140' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5115500',harga_beli ='5115500' WHERE kode_barcode='00026141' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00026142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3975000',harga_beli ='3975000' WHERE kode_barcode='00026145' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5135000',harga_beli ='5135000' WHERE kode_barcode='00026147' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9534000',harga_beli ='9534000' WHERE kode_barcode='00026152' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12896500',harga_beli ='12896500' WHERE kode_barcode='00026469' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7031000',harga_beli ='7031000' WHERE kode_barcode='00026471' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3417000',harga_beli ='3417000' WHERE kode_barcode='00026472' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3733000',harga_beli ='3733000' WHERE kode_barcode='00026475' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='25022500',harga_beli ='25022500' WHERE kode_barcode='00026480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='26404500',harga_beli ='26404500' WHERE kode_barcode='00026481' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9164000',harga_beli ='9164000' WHERE kode_barcode='00026484' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4108000',harga_beli ='4108000' WHERE kode_barcode='00026486' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4068500',harga_beli ='4068500' WHERE kode_barcode='00026487' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6023500',harga_beli ='6023500' WHERE kode_barcode='00026525' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3417000',harga_beli ='3417000' WHERE kode_barcode='00026527' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3989500',harga_beli ='3989500' WHERE kode_barcode='00026529' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='00026534' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13133500',harga_beli ='13133500' WHERE kode_barcode='00026537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8848000',harga_beli ='8848000' WHERE kode_barcode='00026538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14930500',harga_beli ='14930500' WHERE kode_barcode='00026553' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9243000',harga_beli ='9243000' WHERE kode_barcode='00026557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14298500',harga_beli ='14298500' WHERE kode_barcode='00026560' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3989500',harga_beli ='3989500' WHERE kode_barcode='00026561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4029000',harga_beli ='4029000' WHERE kode_barcode='00026563' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7872500',harga_beli ='7872500' WHERE kode_barcode='00026653' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2161500',harga_beli ='2161500' WHERE kode_barcode='00026654' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3222500',harga_beli ='3222500' WHERE kode_barcode='00026655' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3319000',harga_beli ='3319000' WHERE kode_barcode='00026656' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3820500',harga_beli ='3820500' WHERE kode_barcode='00026658' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2200000',harga_beli ='2200000' WHERE kode_barcode='00026659' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4496000',harga_beli ='4496000' WHERE kode_barcode='00026660' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4168000',harga_beli ='4168000' WHERE kode_barcode='00026665' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4940000',harga_beli ='4940000' WHERE kode_barcode='00026666' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3994500',harga_beli ='3994500' WHERE kode_barcode='00026668' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4390000',harga_beli ='4390000' WHERE kode_barcode='00026669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9119500',harga_beli ='9119500' WHERE kode_barcode='00026671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3486000',harga_beli ='3486000' WHERE kode_barcode='00026677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5483000',harga_beli ='5483000' WHERE kode_barcode='00026678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2663000',harga_beli ='2663000' WHERE kode_barcode='00026680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4573000',harga_beli ='4573000' WHERE kode_barcode='00026681' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2836500',harga_beli ='2836500' WHERE kode_barcode='00026684' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3087500',harga_beli ='3087500' WHERE kode_barcode='00026686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4554000',harga_beli ='4554000' WHERE kode_barcode='00026691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9416000',harga_beli ='9416000' WHERE kode_barcode='00026693' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5403000',harga_beli ='5403000' WHERE kode_barcode='00026697' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4245000',harga_beli ='4245000' WHERE kode_barcode='00026699' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00026702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5094000',harga_beli ='5094000' WHERE kode_barcode='00026708' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4573000',harga_beli ='4573000' WHERE kode_barcode='00026710' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2701500',harga_beli ='2701500' WHERE kode_barcode='00026711' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4147500',harga_beli ='4147500' WHERE kode_barcode='00027627' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12067000',harga_beli ='12067000' WHERE kode_barcode='00027630' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14911000',harga_beli ='14911000' WHERE kode_barcode='00027632' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='22277000',harga_beli ='22277000' WHERE kode_barcode='00027635' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='24074500',harga_beli ='24074500' WHERE kode_barcode='00027636' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14516000',harga_beli ='14516000' WHERE kode_barcode='00027638' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9124500',harga_beli ='9124500' WHERE kode_barcode='00027643' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10408000',harga_beli ='10408000' WHERE kode_barcode='00027645' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13824500',harga_beli ='13824500' WHERE kode_barcode='00027646' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10862000',harga_beli ='10862000' WHERE kode_barcode='00027647' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7505000',harga_beli ='7505000' WHERE kode_barcode='00027649' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6122500',harga_beli ='6122500' WHERE kode_barcode='00027650' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17379500',harga_beli ='17379500' WHERE kode_barcode='00027652' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21230500',harga_beli ='21230500' WHERE kode_barcode='00027654' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7299000',harga_beli ='7299000' WHERE kode_barcode='00027657' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3296500',harga_beli ='3296500' WHERE kode_barcode='00027659' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5274000',harga_beli ='5274000' WHERE kode_barcode='00027663' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5374000',harga_beli ='5374000' WHERE kode_barcode='00027664' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3787500',harga_beli ='3787500' WHERE kode_barcode='00027667' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11264500',harga_beli ='11264500' WHERE kode_barcode='00027668' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5544500',harga_beli ='5544500' WHERE kode_barcode='00027669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15344500',harga_beli ='15344500' WHERE kode_barcode='00027671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16028000',harga_beli ='16028000' WHERE kode_barcode='00027672' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8788500',harga_beli ='8788500' WHERE kode_barcode='00027678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5036500',harga_beli ='5036500' WHERE kode_barcode='00027680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12526000',harga_beli ='12526000' WHERE kode_barcode='00027681' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5152000',harga_beli ='5152000' WHERE kode_barcode='00027682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2971500',harga_beli ='2971500' WHERE kode_barcode='00027687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3859000',harga_beli ='3859000' WHERE kode_barcode='00027688' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13475500',harga_beli ='13475500' WHERE kode_barcode='00027691' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17859500',harga_beli ='17859500' WHERE kode_barcode='00027694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3555000',harga_beli ='3555000' WHERE kode_barcode='00029700' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7371500',harga_beli ='7371500' WHERE kode_barcode='00029701' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5813500',harga_beli ='5813500' WHERE kode_barcode='00029702' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12805000',harga_beli ='12805000' WHERE kode_barcode='00029703' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14842500',harga_beli ='14842500' WHERE kode_barcode='00029705' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8909500',harga_beli ='8909500' WHERE kode_barcode='00029706' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9735000',harga_beli ='9735000' WHERE kode_barcode='00030416' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='37838000',harga_beli ='37838000' WHERE kode_barcode='00030724' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00030727' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='25871500',harga_beli ='25871500' WHERE kode_barcode='00030732' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12896500',harga_beli ='12896500' WHERE kode_barcode='00030733' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9591500',harga_beli ='9591500' WHERE kode_barcode='00030735' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21921500',harga_beli ='21921500' WHERE kode_barcode='00030741' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11099000',harga_beli ='11099000' WHERE kode_barcode='00030742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2991000',harga_beli ='2991000' WHERE kode_barcode='00030753' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3550500',harga_beli ='3550500' WHERE kode_barcode='00030754' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9394500',harga_beli ='9394500' WHERE kode_barcode='00030755' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3081000',harga_beli ='3081000' WHERE kode_barcode='00030761' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3160000',harga_beli ='3160000' WHERE kode_barcode='00030763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5451000',harga_beli ='5451000' WHERE kode_barcode='00030766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5174500',harga_beli ='5174500' WHERE kode_barcode='00030767' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5530000',harga_beli ='5530000' WHERE kode_barcode='00030768' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5451000',harga_beli ='5451000' WHERE kode_barcode='00030769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21526500',harga_beli ='21526500' WHERE kode_barcode='00030773' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='50380000',harga_beli ='50380000' WHERE kode_barcode='00030774' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4341500',harga_beli ='4341500' WHERE kode_barcode='00030786' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3647000',harga_beli ='3647000' WHERE kode_barcode='00030787' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8374500',harga_beli ='8374500' WHERE kode_barcode='00031682' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1640500',harga_beli ='1640500' WHERE kode_barcode='00031686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00031687' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7834000',harga_beli ='7834000' WHERE kode_barcode='00031690' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3347000',harga_beli ='3347000' WHERE kode_barcode='00032055' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00033504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2242500',harga_beli ='2242500' WHERE kode_barcode='00033509' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2204500',harga_beli ='2204500' WHERE kode_barcode='00033510' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13333000',harga_beli ='13333000' WHERE kode_barcode='00033511' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13642000',harga_beli ='13642000' WHERE kode_barcode='00033512' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='20260000',harga_beli ='20260000' WHERE kode_barcode='00033513' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15803000',harga_beli ='15803000' WHERE kode_barcode='00033516' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11307000',harga_beli ='11307000' WHERE kode_barcode='00033517' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5132500',harga_beli ='5132500' WHERE kode_barcode='00033518' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2243000',harga_beli ='2243000' WHERE kode_barcode='00033881' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4597500',harga_beli ='4597500' WHERE kode_barcode='00034763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2826500',harga_beli ='2826500' WHERE kode_barcode='00034769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4823500',harga_beli ='4823500' WHERE kode_barcode='00034776' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2894500',harga_beli ='2894500' WHERE kode_barcode='00035831' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4842500',harga_beli ='4842500' WHERE kode_barcode='00036412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4183000',harga_beli ='4183000' WHERE kode_barcode='00036626' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5087500',harga_beli ='5087500' WHERE kode_barcode='00036627' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4503500',harga_beli ='4503500' WHERE kode_barcode='00036628' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6001000',harga_beli ='6001000' WHERE kode_barcode='00036763' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5924000',harga_beli ='5924000' WHERE kode_barcode='00036764' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5885500',harga_beli ='5885500' WHERE kode_barcode='00036765' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5866000',harga_beli ='5866000' WHERE kode_barcode='00036766' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3146500',harga_beli ='3146500' WHERE kode_barcode='00036806' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3693000',harga_beli ='3693000' WHERE kode_barcode='00036852' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4164000',harga_beli ='4164000' WHERE kode_barcode='00036853' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13564500',harga_beli ='13564500' WHERE kode_barcode='00036906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16767500',harga_beli ='16767500' WHERE kode_barcode='00036907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9879500',harga_beli ='9879500' WHERE kode_barcode='00036908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00036909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10265000',harga_beli ='10265000' WHERE kode_barcode='00036912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17327000',harga_beli ='17327000' WHERE kode_barcode='00036914' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11384500',harga_beli ='11384500' WHERE kode_barcode='00036916' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='19353000',harga_beli ='19353000' WHERE kode_barcode='00036918' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4164000',harga_beli ='4164000' WHERE kode_barcode='00037019' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5596000',harga_beli ='5596000' WHERE kode_barcode='00037246' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4484500',harga_beli ='4484500' WHERE kode_barcode='00037250' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5144000',harga_beli ='5144000' WHERE kode_barcode='00037273' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3523500',harga_beli ='3523500' WHERE kode_barcode='00037278' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2902000',harga_beli ='2902000' WHERE kode_barcode='00037280' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3617500',harga_beli ='3617500' WHERE kode_barcode='00037284' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6764000',harga_beli ='6764000' WHERE kode_barcode='00037288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4049000',harga_beli ='4049000' WHERE kode_barcode='00038371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4029000',harga_beli ='4029000' WHERE kode_barcode='00038373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4068500',harga_beli ='4068500' WHERE kode_barcode='00038375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3436500',harga_beli ='3436500' WHERE kode_barcode='00038376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7070500',harga_beli ='7070500' WHERE kode_barcode='00038378' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12481500',harga_beli ='12481500' WHERE kode_barcode='00038381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3298500',harga_beli ='3298500' WHERE kode_barcode='00038383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8492500',harga_beli ='8492500' WHERE kode_barcode='00038385' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8709500',harga_beli ='8709500' WHERE kode_barcode='00038386' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8749000',harga_beli ='8749000' WHERE kode_barcode='00038387' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2860500',harga_beli ='2860500' WHERE kode_barcode='00038388' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2898500',harga_beli ='2898500' WHERE kode_barcode='00038389' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3203500',harga_beli ='3203500' WHERE kode_barcode='00038391' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3108500',harga_beli ='3108500' WHERE kode_barcode='00038393' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3165500',harga_beli ='3165500' WHERE kode_barcode='00038394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1697500',harga_beli ='1697500' WHERE kode_barcode='00038396' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1659000',harga_beli ='1659000' WHERE kode_barcode='00038397' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2136000',harga_beli ='2136000' WHERE kode_barcode='00038399' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00038400' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2002500',harga_beli ='2002500' WHERE kode_barcode='00038402' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2574500',harga_beli ='2574500' WHERE kode_barcode='00038404' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2345500',harga_beli ='2345500' WHERE kode_barcode='00038408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4424000',harga_beli ='4424000' WHERE kode_barcode='00038419' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4424000',harga_beli ='4424000' WHERE kode_barcode='00038420' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4519500',harga_beli ='4519500' WHERE kode_barcode='00038421' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4424000',harga_beli ='4424000' WHERE kode_barcode='00038422' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5511000',harga_beli ='5511000' WHERE kode_barcode='00038424' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5854000',harga_beli ='5854000' WHERE kode_barcode='00038425' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4634000',harga_beli ='4634000' WHERE kode_barcode='00038427' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4138000',harga_beli ='4138000' WHERE kode_barcode='00038429' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4634000',harga_beli ='4634000' WHERE kode_barcode='00038430' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4138000',harga_beli ='4138000' WHERE kode_barcode='00038431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11422000',harga_beli ='11422000' WHERE kode_barcode='00038433' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11479000',harga_beli ='11479000' WHERE kode_barcode='00038434' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9628500',harga_beli ='9628500' WHERE kode_barcode='00038435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9860000',harga_beli ='9860000' WHERE kode_barcode='00038436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2315500',harga_beli ='2315500' WHERE kode_barcode='00038437' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2354500',harga_beli ='2354500' WHERE kode_barcode='00038438' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6599000',harga_beli ='6599000' WHERE kode_barcode='00038441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7564000',harga_beli ='7564000' WHERE kode_barcode='00038446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12870000',harga_beli ='12870000' WHERE kode_barcode='00038452' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15880000',harga_beli ='15880000' WHERE kode_barcode='00038454' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4367000',harga_beli ='4367000' WHERE kode_barcode='00038534' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3966500',harga_beli ='3966500' WHERE kode_barcode='00038535' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1811500',harga_beli ='1811500' WHERE kode_barcode='00038536' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2307500',harga_beli ='2307500' WHERE kode_barcode='00038537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2441000',harga_beli ='2441000' WHERE kode_barcode='00038538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3680500',harga_beli ='3680500' WHERE kode_barcode='00038551' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4138000',harga_beli ='4138000' WHERE kode_barcode='00038552' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5538000',harga_beli ='5538000' WHERE kode_barcode='00038553' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5287000',harga_beli ='5287000' WHERE kode_barcode='00038554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21649500',harga_beli ='21649500' WHERE kode_barcode='00038556' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3891000',harga_beli ='3891000' WHERE kode_barcode='00038557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9164000',harga_beli ='9164000' WHERE kode_barcode='00038559' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1165500',harga_beli ='1165500' WHERE kode_barcode='00038564' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1165500',harga_beli ='1165500' WHERE kode_barcode='00038565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6043500',harga_beli ='6043500' WHERE kode_barcode='00038567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4068500',harga_beli ='4068500' WHERE kode_barcode='00038568' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5905000',harga_beli ='5905000' WHERE kode_barcode='00038569' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4088500',harga_beli ='4088500' WHERE kode_barcode='00038570' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4049000',harga_beli ='4049000' WHERE kode_barcode='00038571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10112000',harga_beli ='10112000' WHERE kode_barcode='00038575' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='116905000',harga_beli ='116905000' WHERE kode_barcode='00038877' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='45166000',harga_beli ='45166000' WHERE kode_barcode='00038891' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='42078000',harga_beli ='42078000' WHERE kode_barcode='00038892' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='36698500',harga_beli ='36698500' WHERE kode_barcode='00038893' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4434000',harga_beli ='4434000' WHERE kode_barcode='00038894' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5555500',harga_beli ='5555500' WHERE kode_barcode='00038895' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10869000',harga_beli ='10869000' WHERE kode_barcode='00038896' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7446500',harga_beli ='7446500' WHERE kode_barcode='00038897' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3352500',harga_beli ='3352500' WHERE kode_barcode='00038898' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9765000',harga_beli ='9765000' WHERE kode_barcode='00038899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7608500',harga_beli ='7608500' WHERE kode_barcode='00038900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5227500',harga_beli ='5227500' WHERE kode_barcode='00038901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3347000',harga_beli ='3347000' WHERE kode_barcode='00038902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8523000',harga_beli ='8523000' WHERE kode_barcode='00038903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4882500',harga_beli ='4882500' WHERE kode_barcode='00038904' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11697000',harga_beli ='11697000' WHERE kode_barcode='00038905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13474000',harga_beli ='13474000' WHERE kode_barcode='00038906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7487500',harga_beli ='7487500' WHERE kode_barcode='00038907' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10110000',harga_beli ='10110000' WHERE kode_barcode='00038908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00038923' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='26396000',harga_beli ='26396000' WHERE kode_barcode='00038924' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='20978500',harga_beli ='20978500' WHERE kode_barcode='00038925' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2238500',harga_beli ='2238500' WHERE kode_barcode='00038950' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5524500',harga_beli ='5524500' WHERE kode_barcode='00038951' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14696500',harga_beli ='14696500' WHERE kode_barcode='00039103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3666500',harga_beli ='3666500' WHERE kode_barcode='00039104' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4878500',harga_beli ='4878500' WHERE kode_barcode='00039105' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17103000',harga_beli ='17103000' WHERE kode_barcode='00039107' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3634000',harga_beli ='3634000' WHERE kode_barcode='00039109' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='00039110' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4128000',harga_beli ='4128000' WHERE kode_barcode='00039111' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3749500',harga_beli ='3749500' WHERE kode_barcode='00039164' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2902000',harga_beli ='2902000' WHERE kode_barcode='00039165' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3881500',harga_beli ='3881500' WHERE kode_barcode='00039166' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3165500',harga_beli ='3165500' WHERE kode_barcode='00039169' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2864000',harga_beli ='2864000' WHERE kode_barcode='00039171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='23998000',harga_beli ='23998000' WHERE kode_barcode='00039222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12247000',harga_beli ='12247000' WHERE kode_barcode='00039223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4796500',harga_beli ='4796500' WHERE kode_barcode='00039224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7285000',harga_beli ='7285000' WHERE kode_barcode='00039227' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10403000',harga_beli ='10403000' WHERE kode_barcode='00039228' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6987500',harga_beli ='6987500' WHERE kode_barcode='00039229' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6866500',harga_beli ='6866500' WHERE kode_barcode='00039230' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6280000',harga_beli ='6280000' WHERE kode_barcode='00039231' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4831000',harga_beli ='4831000' WHERE kode_barcode='00039233' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3054000',harga_beli ='3054000' WHERE kode_barcode='00039235' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3933000',harga_beli ='3933000' WHERE kode_barcode='00039236' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2273000',harga_beli ='2273000' WHERE kode_barcode='00039237' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2240500',harga_beli ='2240500' WHERE kode_barcode='00039238' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00039444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3916500',harga_beli ='3916500' WHERE kode_barcode='00040124' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1214000',harga_beli ='1214000' WHERE kode_barcode='00040125' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1214000',harga_beli ='1214000' WHERE kode_barcode='00040127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2059500',harga_beli ='2059500' WHERE kode_barcode='00040134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2445500',harga_beli ='2445500' WHERE kode_barcode='00040142' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2390500',harga_beli ='2390500' WHERE kode_barcode='00040143' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2758500',harga_beli ='2758500' WHERE kode_barcode='00040148' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2372000',harga_beli ='2372000' WHERE kode_barcode='00040149' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2354000',harga_beli ='2354000' WHERE kode_barcode='00040150' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1177000',harga_beli ='1177000' WHERE kode_barcode='00040157' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1581500',harga_beli ='1581500' WHERE kode_barcode='00040161' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1655000',harga_beli ='1655000' WHERE kode_barcode='00040162' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1342500',harga_beli ='1342500' WHERE kode_barcode='00040163' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8954500',harga_beli ='8954500' WHERE kode_barcode='00040165' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5663500',harga_beli ='5663500' WHERE kode_barcode='00040169' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8072000',harga_beli ='8072000' WHERE kode_barcode='00040171' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5718500',harga_beli ='5718500' WHERE kode_barcode='00040176' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6050000',harga_beli ='6050000' WHERE kode_barcode='00040181' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10740500',harga_beli ='10740500' WHERE kode_barcode='00040182' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6664000',harga_beli ='6664000' WHERE kode_barcode='00040183' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7799500',harga_beli ='7799500' WHERE kode_barcode='00040186' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7837000',harga_beli ='7837000' WHERE kode_barcode='00040189' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='21481000',harga_beli ='21481000' WHERE kode_barcode='00040190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10442500',harga_beli ='10442500' WHERE kode_barcode='00040194' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7501500',harga_beli ='7501500' WHERE kode_barcode='00040198' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='00040202' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3779000',harga_beli ='3779000' WHERE kode_barcode='00040204' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00040205' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00040206' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3890500',harga_beli ='3890500' WHERE kode_barcode='00040207' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00040208' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3946500',harga_beli ='3946500' WHERE kode_barcode='00040209' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1093000',harga_beli ='1093000' WHERE kode_barcode='00040213' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2449500',harga_beli ='2449500' WHERE kode_barcode='00040215' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10570000',harga_beli ='10570000' WHERE kode_barcode='00040217' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2593500',harga_beli ='2593500' WHERE kode_barcode='00040222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2670000',harga_beli ='2670000' WHERE kode_barcode='00040223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7246000',harga_beli ='7246000' WHERE kode_barcode='00040225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4958000',harga_beli ='4958000' WHERE kode_barcode='00040231' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5377500',harga_beli ='5377500' WHERE kode_barcode='00040238' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5625500',harga_beli ='5625500' WHERE kode_barcode='00040239' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3756500',harga_beli ='3756500' WHERE kode_barcode='00040241' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5587000',harga_beli ='5587000' WHERE kode_barcode='00040242' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4519500',harga_beli ='4519500' WHERE kode_barcode='00040243' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5682500',harga_beli ='5682500' WHERE kode_barcode='00040245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9839500',harga_beli ='9839500' WHERE kode_barcode='00040246' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5701500',harga_beli ='5701500' WHERE kode_barcode='00040247' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4100000',harga_beli ='4100000' WHERE kode_barcode='00040249' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7322500',harga_beli ='7322500' WHERE kode_barcode='00040252' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4138000',harga_beli ='4138000' WHERE kode_barcode='00040253' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12184500',harga_beli ='12184500' WHERE kode_barcode='00040254' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12013000',harga_beli ='12013000' WHERE kode_barcode='00040255' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4004500',harga_beli ='4004500' WHERE kode_barcode='00040256' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3756500',harga_beli ='3756500' WHERE kode_barcode='00040261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3756500',harga_beli ='3756500' WHERE kode_barcode='00040263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5739500',harga_beli ='5739500' WHERE kode_barcode='00040264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4176000',harga_beli ='4176000' WHERE kode_barcode='00040266' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4214500',harga_beli ='4214500' WHERE kode_barcode='00040267' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='00040270' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='24422500',harga_beli ='24422500' WHERE kode_barcode='00040273' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4959000',harga_beli ='4959000' WHERE kode_barcode='00040274' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4767000',harga_beli ='4767000' WHERE kode_barcode='00040370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3712000',harga_beli ='3712000' WHERE kode_barcode='00040372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3429500',harga_beli ='3429500' WHERE kode_barcode='00040373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9023000',harga_beli ='9023000' WHERE kode_barcode='00040608' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3919000',harga_beli ='3919000' WHERE kode_barcode='00041059' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4710500',harga_beli ='4710500' WHERE kode_barcode='00041062' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='24970000',harga_beli ='24970000' WHERE kode_barcode='00041134' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11017500',harga_beli ='11017500' WHERE kode_barcode='00041207' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5502000',harga_beli ='5502000' WHERE kode_barcode='00041208' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16530000',harga_beli ='16530000' WHERE kode_barcode='00041211' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7437000',harga_beli ='7437000' WHERE kode_barcode='00041214' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041363' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041367' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041368' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00041372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2724000',harga_beli ='2724000' WHERE kode_barcode='00041408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4823500',harga_beli ='4823500' WHERE kode_barcode='00041574' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5483000',harga_beli ='5483000' WHERE kode_barcode='00041575' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5822000',harga_beli ='5822000' WHERE kode_barcode='00041576' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2517500',harga_beli ='2517500' WHERE kode_barcode='00041870' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2059500',harga_beli ='2059500' WHERE kode_barcode='00041871' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1602000',harga_beli ='1602000' WHERE kode_barcode='00041902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8220000',harga_beli ='8220000' WHERE kode_barcode='00041905' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='20202000',harga_beli ='20202000' WHERE kode_barcode='00041906' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='28441000',harga_beli ='28441000' WHERE kode_barcode='00041908' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10863500',harga_beli ='10863500' WHERE kode_barcode='00041909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8335500',harga_beli ='8335500' WHERE kode_barcode='00041910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5268000',harga_beli ='5268000' WHERE kode_barcode='00041911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8818000',harga_beli ='8818000' WHERE kode_barcode='00041912' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4303000',harga_beli ='4303000' WHERE kode_barcode='00041916' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2007000',harga_beli ='2007000' WHERE kode_barcode='00041917' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4245000',harga_beli ='4245000' WHERE kode_barcode='00041918' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3673500',harga_beli ='3673500' WHERE kode_barcode='00041919' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3634000',harga_beli ='3634000' WHERE kode_barcode='00041920' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3180000',harga_beli ='3180000' WHERE kode_barcode='00041924' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3180000',harga_beli ='3180000' WHERE kode_barcode='00041925' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00041929' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2860500',harga_beli ='2860500' WHERE kode_barcode='00041931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2689000',harga_beli ='2689000' WHERE kode_barcode='00041934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2860500',harga_beli ='2860500' WHERE kode_barcode='00041935' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3413500',harga_beli ='3413500' WHERE kode_barcode='00041939' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3203500',harga_beli ='3203500' WHERE kode_barcode='00041943' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7532000',harga_beli ='7532000' WHERE kode_barcode='00041944' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9076500',harga_beli ='9076500' WHERE kode_barcode='00041945' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3280500',harga_beli ='3280500' WHERE kode_barcode='00041949' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7371000',harga_beli ='7371000' WHERE kode_barcode='00041950' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6059000',harga_beli ='6059000' WHERE kode_barcode='00041953' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5962500',harga_beli ='5962500' WHERE kode_barcode='00041954' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2161500',harga_beli ='2161500' WHERE kode_barcode='00041955' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='00041956' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00041957' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00041959' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00041960' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5827500',harga_beli ='5827500' WHERE kode_barcode='00041961' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00041962' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2856000',harga_beli ='2856000' WHERE kode_barcode='00041963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3145500',harga_beli ='3145500' WHERE kode_barcode='00041964' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2412000',harga_beli ='2412000' WHERE kode_barcode='00041965' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2933000',harga_beli ='2933000' WHERE kode_barcode='00041967' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2971500',harga_beli ='2971500' WHERE kode_barcode='00041968' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5113500',harga_beli ='5113500' WHERE kode_barcode='00041969' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2393000',harga_beli ='2393000' WHERE kode_barcode='00041971' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2373500',harga_beli ='2373500' WHERE kode_barcode='00041973' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2817500',harga_beli ='2817500' WHERE kode_barcode='00041976' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6830500',harga_beli ='6830500' WHERE kode_barcode='00041977' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2933000',harga_beli ='2933000' WHERE kode_barcode='00041978' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6483500',harga_beli ='6483500' WHERE kode_barcode='00041980' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11075500',harga_beli ='11075500' WHERE kode_barcode='00041982' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='19179500',harga_beli ='19179500' WHERE kode_barcode='00041983' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6715000',harga_beli ='6715000' WHERE kode_barcode='00041985' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5094000',harga_beli ='5094000' WHERE kode_barcode='00041986' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15436000',harga_beli ='15436000' WHERE kode_barcode='00041988' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12445500',harga_beli ='12445500' WHERE kode_barcode='00041990' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='16517000',harga_beli ='16517000' WHERE kode_barcode='00041991' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1833500',harga_beli ='1833500' WHERE kode_barcode='00041992' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12712500',harga_beli ='12712500' WHERE kode_barcode='00042536' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12712500',harga_beli ='12712500' WHERE kode_barcode='00042537' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12712500',harga_beli ='12712500' WHERE kode_barcode='00042538' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12712500',harga_beli ='12712500' WHERE kode_barcode='00042539' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2441000',harga_beli ='2441000' WHERE kode_barcode='00042780' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2847000',harga_beli ='2847000' WHERE kode_barcode='00042781' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5089500',harga_beli ='5089500' WHERE kode_barcode='00042782' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1328000',harga_beli ='1328000' WHERE kode_barcode='00042931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1348500',harga_beli ='1348500' WHERE kode_barcode='00042932' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1154500',harga_beli ='1154500' WHERE kode_barcode='00042933' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1594000',harga_beli ='1594000' WHERE kode_barcode='00042934' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1328000',harga_beli ='1328000' WHERE kode_barcode='00042955' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='00042999' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='00043000' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='00043001' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='00043007' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='00043008' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='00043009' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='00043010' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8172000',harga_beli ='8172000' WHERE kode_barcode='00043011' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1226000',harga_beli ='1226000' WHERE kode_barcode='00043114' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1767500',harga_beli ='1767500' WHERE kode_barcode='00043115' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1522500',harga_beli ='1522500' WHERE kode_barcode='00043116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1389500',harga_beli ='1389500' WHERE kode_barcode='00043117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1379500',harga_beli ='1379500' WHERE kode_barcode='00043118' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1839000',harga_beli ='1839000' WHERE kode_barcode='00043121' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='00043122' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1410000',harga_beli ='1410000' WHERE kode_barcode='00043123' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1379500',harga_beli ='1379500' WHERE kode_barcode='00043124' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00043126' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1532500',harga_beli ='1532500' WHERE kode_barcode='00043127' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1512000',harga_beli ='1512000' WHERE kode_barcode='00043128' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1430500',harga_beli ='1430500' WHERE kode_barcode='00043129' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1420000',harga_beli ='1420000' WHERE kode_barcode='00043130' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12485000',harga_beli ='12485000' WHERE kode_barcode='00043600' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5094000',harga_beli ='5094000' WHERE kode_barcode='00043628' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1195500',harga_beli ='1195500' WHERE kode_barcode='00044415' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1195500',harga_beli ='1195500' WHERE kode_barcode='00044418' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6189000',harga_beli ='6189000' WHERE kode_barcode='00044438' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4785500',harga_beli ='4785500' WHERE kode_barcode='00044615' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2070500',harga_beli ='2070500' WHERE kode_barcode='00044742' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4061000',harga_beli ='4061000' WHERE kode_barcode='00044792' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3904500',harga_beli ='3904500' WHERE kode_barcode='00044793' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4080500',harga_beli ='4080500' WHERE kode_barcode='00044794' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2596500',harga_beli ='2596500' WHERE kode_barcode='00044795' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3592500',harga_beli ='3592500' WHERE kode_barcode='00044796' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3592500',harga_beli ='3592500' WHERE kode_barcode='00044797' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3358000',harga_beli ='3358000' WHERE kode_barcode='00044798' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4588000',harga_beli ='4588000' WHERE kode_barcode='00044800' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2335000',harga_beli ='2335000' WHERE kode_barcode='00044801' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2265000',harga_beli ='2265000' WHERE kode_barcode='00044802' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3656000',harga_beli ='3656000' WHERE kode_barcode='00044804' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3015000',harga_beli ='3015000' WHERE kode_barcode='00044805' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5257000',harga_beli ='5257000' WHERE kode_barcode='00044806' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3203000',harga_beli ='3203000' WHERE kode_barcode='00044807' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1526500',harga_beli ='1526500' WHERE kode_barcode='00044808' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9668000',harga_beli ='9668000' WHERE kode_barcode='00044809' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9420000',harga_beli ='9420000' WHERE kode_barcode='00044810' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15012000',harga_beli ='15012000' WHERE kode_barcode='00044811' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14896000',harga_beli ='14896000' WHERE kode_barcode='00044812' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14124000',harga_beli ='14124000' WHERE kode_barcode='00044813' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13912000',harga_beli ='13912000' WHERE kode_barcode='00044814' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3143500',harga_beli ='3143500' WHERE kode_barcode='00044815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12279500',harga_beli ='12279500' WHERE kode_barcode='00044816' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9286500',harga_beli ='9286500' WHERE kode_barcode='00044817' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9668000',harga_beli ='9668000' WHERE kode_barcode='00044818' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2733500',harga_beli ='2733500' WHERE kode_barcode='00044819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='12559500',harga_beli ='12559500' WHERE kode_barcode='00044901' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1294000',harga_beli ='1294000' WHERE kode_barcode='00045054' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11307000',harga_beli ='11307000' WHERE kode_barcode='00045358' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1030000',harga_beli ='1030000' WHERE kode_barcode='00045369' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1677000',harga_beli ='1677000' WHERE kode_barcode='00045408' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5841000',harga_beli ='5841000' WHERE kode_barcode='00045409' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00045410' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2148000',harga_beli ='2148000' WHERE kode_barcode='00045411' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4993000',harga_beli ='4993000' WHERE kode_barcode='00045412' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6293000',harga_beli ='6293000' WHERE kode_barcode='00045413' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6048000',harga_beli ='6048000' WHERE kode_barcode='00045414' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1775500',harga_beli ='1775500' WHERE kode_barcode='00045433' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1563000',harga_beli ='1563000' WHERE kode_barcode='00045434' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1814000',harga_beli ='1814000' WHERE kode_barcode='00045435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00045436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3415500',harga_beli ='3415500' WHERE kode_barcode='00045438' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2354500',harga_beli ='2354500' WHERE kode_barcode='00045439' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14047000',harga_beli ='14047000' WHERE kode_barcode='00045441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11172000',harga_beli ='11172000' WHERE kode_barcode='00045442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3299500',harga_beli ='3299500' WHERE kode_barcode='00045443' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5171500',harga_beli ='5171500' WHERE kode_barcode='00045444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2610500',harga_beli ='2610500' WHERE kode_barcode='00045515' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2610500',harga_beli ='2610500' WHERE kode_barcode='00045516' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3537000',harga_beli ='3537000' WHERE kode_barcode='00045710' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6625000',harga_beli ='6625000' WHERE kode_barcode='00045713' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1267000',harga_beli ='1267000' WHERE kode_barcode='00045769' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1185000',harga_beli ='1185000' WHERE kode_barcode='00045770' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1491500',harga_beli ='1491500' WHERE kode_barcode='00045777' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9299000',harga_beli ='9299000' WHERE kode_barcode='00045836' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1522500',harga_beli ='1522500' WHERE kode_barcode='00045931' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1535500',harga_beli ='1535500' WHERE kode_barcode='00045969' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1553000',harga_beli ='1553000' WHERE kode_barcode='00046083' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1829000',harga_beli ='1829000' WHERE kode_barcode='00046260' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2191500',harga_beli ='2191500' WHERE kode_barcode='00046261' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1587500',harga_beli ='1587500' WHERE kode_barcode='00046262' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='932000',harga_beli ='932000' WHERE kode_barcode='00046263' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1824500',harga_beli ='1824500' WHERE kode_barcode='00046426' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1149500',harga_beli ='1149500' WHERE kode_barcode='00046427' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1093000',harga_beli ='1093000' WHERE kode_barcode='00046428' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1375500',harga_beli ='1375500' WHERE kode_barcode='00046429' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1017500',harga_beli ='1017500' WHERE kode_barcode='00046430' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2299000',harga_beli ='2299000' WHERE kode_barcode='00046431' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1884500',harga_beli ='1884500' WHERE kode_barcode='00046432' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2600500',harga_beli ='2600500' WHERE kode_barcode='00046433' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1865500',harga_beli ='1865500' WHERE kode_barcode='00046434' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2054000',harga_beli ='2054000' WHERE kode_barcode='00046435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1582500',harga_beli ='1582500' WHERE kode_barcode='00046436' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1794500',harga_beli ='1794500' WHERE kode_barcode='00046437' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2528000',harga_beli ='2528000' WHERE kode_barcode='00046438' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2759500',harga_beli ='2759500' WHERE kode_barcode='00046439' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1698000',harga_beli ='1698000' WHERE kode_barcode='00046440' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1852500',harga_beli ='1852500' WHERE kode_barcode='00046441' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4206500',harga_beli ='4206500' WHERE kode_barcode='00046442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4129500',harga_beli ='4129500' WHERE kode_barcode='00046443' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2933000',harga_beli ='2933000' WHERE kode_barcode='00046444' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4438000',harga_beli ='4438000' WHERE kode_barcode='00046445' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3261000',harga_beli ='3261000' WHERE kode_barcode='00046446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2798000',harga_beli ='2798000' WHERE kode_barcode='00046447' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3898000',harga_beli ='3898000' WHERE kode_barcode='00046448' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3126000',harga_beli ='3126000' WHERE kode_barcode='00046449' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3994500',harga_beli ='3994500' WHERE kode_barcode='00046450' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4168000',harga_beli ='4168000' WHERE kode_barcode='00046451' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3184000',harga_beli ='3184000' WHERE kode_barcode='00046452' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3975000',harga_beli ='3975000' WHERE kode_barcode='00046453' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3299500',harga_beli ='3299500' WHERE kode_barcode='00046454' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3029500',harga_beli ='3029500' WHERE kode_barcode='00046455' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4689000',harga_beli ='4689000' WHERE kode_barcode='00046456' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5171500',harga_beli ='5171500' WHERE kode_barcode='00046457' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='00046458' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1737000',harga_beli ='1737000' WHERE kode_barcode='00046459' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1756000',harga_beli ='1756000' WHERE kode_barcode='00046460' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6329000',harga_beli ='6329000' WHERE kode_barcode='00046461' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1794500',harga_beli ='1794500' WHERE kode_barcode='00046462' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1737000',harga_beli ='1737000' WHERE kode_barcode='00046463' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5981500',harga_beli ='5981500' WHERE kode_barcode='00046464' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6174500',harga_beli ='6174500' WHERE kode_barcode='00046465' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6445000',harga_beli ='6445000' WHERE kode_barcode='00046466' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5750000',harga_beli ='5750000' WHERE kode_barcode='00046467' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00046468' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6850000',harga_beli ='6850000' WHERE kode_barcode='00046469' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5499500',harga_beli ='5499500' WHERE kode_barcode='00046470' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4959000',harga_beli ='4959000' WHERE kode_barcode='00046471' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5943000',harga_beli ='5943000' WHERE kode_barcode='00046472' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2449500',harga_beli ='2449500' WHERE kode_barcode='00046473' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5294500',harga_beli ='5294500' WHERE kode_barcode='00046474' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8516500',harga_beli ='8516500' WHERE kode_barcode='00046475' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3071500',harga_beli ='3071500' WHERE kode_barcode='00046476' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3109000',harga_beli ='3109000' WHERE kode_barcode='00046477' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3523500',harga_beli ='3523500' WHERE kode_barcode='00046478' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5238000',harga_beli ='5238000' WHERE kode_barcode='00046480' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2826500',harga_beli ='2826500' WHERE kode_barcode='00046481' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4409000',harga_beli ='4409000' WHERE kode_barcode='00046482' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6199000',harga_beli ='6199000' WHERE kode_barcode='00046483' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7036500',harga_beli ='7036500' WHERE kode_barcode='00046484' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3165500',harga_beli ='3165500' WHERE kode_barcode='00046485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4271500',harga_beli ='4271500' WHERE kode_barcode='00046486' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4443000',harga_beli ='4443000' WHERE kode_barcode='00046488' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2587500',harga_beli ='2587500' WHERE kode_barcode='00046489' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4049000',harga_beli ='4049000' WHERE kode_barcode='00046490' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2785000',harga_beli ='2785000' WHERE kode_barcode='00046491' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4720500',harga_beli ='4720500' WHERE kode_barcode='00046492' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4384500',harga_beli ='4384500' WHERE kode_barcode='00046493' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3594500',harga_beli ='3594500' WHERE kode_barcode='00046494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2390000',harga_beli ='2390000' WHERE kode_barcode='00046496' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2982500',harga_beli ='2982500' WHERE kode_barcode='00046497' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3160000',harga_beli ='3160000' WHERE kode_barcode='00046498' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3140500',harga_beli ='3140500' WHERE kode_barcode='00046499' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3535500',harga_beli ='3535500' WHERE kode_barcode='00046500' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8038000',harga_beli ='8038000' WHERE kode_barcode='00046501' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7781500',harga_beli ='7781500' WHERE kode_barcode='00046502' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2844000',harga_beli ='2844000' WHERE kode_barcode='00046503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1126000',harga_beli ='1126000' WHERE kode_barcode='00046504' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1126000',harga_beli ='1126000' WHERE kode_barcode='00046505' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2824500',harga_beli ='2824500' WHERE kode_barcode='00046506' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00047010' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1205500',harga_beli ='1205500' WHERE kode_barcode='00047011' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1195500',harga_beli ='1195500' WHERE kode_barcode='00047014' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1420000',harga_beli ='1420000' WHERE kode_barcode='00047015' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00047038' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1869500',harga_beli ='1869500' WHERE kode_barcode='00047039' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1829000',harga_beli ='1829000' WHERE kode_barcode='00047042' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00047074' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2760500',harga_beli ='2760500' WHERE kode_barcode='00047076' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1192000',harga_beli ='1192000' WHERE kode_barcode='00047360' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10075500',harga_beli ='10075500' WHERE kode_barcode='00047549' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3820500',harga_beli ='3820500' WHERE kode_barcode='00047810' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3820500',harga_beli ='3820500' WHERE kode_barcode='00047811' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3917000',harga_beli ='3917000' WHERE kode_barcode='00047812' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00047813' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3975000',harga_beli ='3975000' WHERE kode_barcode='00047814' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00047815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3917000',harga_beli ='3917000' WHERE kode_barcode='00047816' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00047817' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5692500',harga_beli ='5692500' WHERE kode_barcode='00047818' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5518500',harga_beli ='5518500' WHERE kode_barcode='00047819' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2502000',harga_beli ='2502000' WHERE kode_barcode='00048061' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1725500',harga_beli ='1725500' WHERE kode_barcode='00048064' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4882000',harga_beli ='4882000' WHERE kode_barcode='00048334' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5962500',harga_beli ='5962500' WHERE kode_barcode='00048335' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3589000',harga_beli ='3589000' WHERE kode_barcode='00048336' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='14954000',harga_beli ='14954000' WHERE kode_barcode='00048337' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6020500',harga_beli ='6020500' WHERE kode_barcode='00048338' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8007500',harga_beli ='8007500' WHERE kode_barcode='00048339' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6213500',harga_beli ='6213500' WHERE kode_barcode='00048340' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4110000',harga_beli ='4110000' WHERE kode_barcode='00048341' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4148500',harga_beli ='4148500' WHERE kode_barcode='00048342' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00048343' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6618500',harga_beli ='6618500' WHERE kode_barcode='00048344' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6078000',harga_beli ='6078000' WHERE kode_barcode='00048345' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3261000',harga_beli ='3261000' WHERE kode_barcode='00048346' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5711500',harga_beli ='5711500' WHERE kode_barcode='00048347' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4071500',harga_beli ='4071500' WHERE kode_barcode='00048348' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4091000',harga_beli ='4091000' WHERE kode_barcode='00048349' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3473500',harga_beli ='3473500' WHERE kode_barcode='00048350' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4052000',harga_beli ='4052000' WHERE kode_barcode='00048351' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4399500',harga_beli ='4399500' WHERE kode_barcode='00048352' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5248500',harga_beli ='5248500' WHERE kode_barcode='00048353' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1278000',harga_beli ='1278000' WHERE kode_barcode='00048354' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1316000',harga_beli ='1316000' WHERE kode_barcode='00048355' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1259000',harga_beli ='1259000' WHERE kode_barcode='00048356' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1182500',harga_beli ='1182500' WHERE kode_barcode='00048357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1182500',harga_beli ='1182500' WHERE kode_barcode='00048358' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1239500',harga_beli ='1239500' WHERE kode_barcode='00048359' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2078500',harga_beli ='2078500' WHERE kode_barcode='00048360' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3356000',harga_beli ='3356000' WHERE kode_barcode='00048361' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='839500',harga_beli ='839500' WHERE kode_barcode='00048362' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2612500',harga_beli ='2612500' WHERE kode_barcode='00048363' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2860500',harga_beli ='2860500' WHERE kode_barcode='00048364' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1945000',harga_beli ='1945000' WHERE kode_barcode='00048365' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1394500',harga_beli ='1394500' WHERE kode_barcode='00048366' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2902000',harga_beli ='2902000' WHERE kode_barcode='00048367' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2066500',harga_beli ='2066500' WHERE kode_barcode='00048368' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1471000',harga_beli ='1471000' WHERE kode_barcode='00048369' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='00048370' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2048000',harga_beli ='2048000' WHERE kode_barcode='00048371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3872000',harga_beli ='3872000' WHERE kode_barcode='00048372' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1526500',harga_beli ='1526500' WHERE kode_barcode='00048373' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3436500',harga_beli ='3436500' WHERE kode_barcode='00048374' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1047000',harga_beli ='1047000' WHERE kode_barcode='00048375' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1027000',harga_beli ='1027000' WHERE kode_barcode='00048376' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1106000',harga_beli ='1106000' WHERE kode_barcode='00048377' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1066500',harga_beli ='1066500' WHERE kode_barcode='00048378' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1066500',harga_beli ='1066500' WHERE kode_barcode='00048379' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='987500',harga_beli ='987500' WHERE kode_barcode='00048380' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00048381' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1639500',harga_beli ='1639500' WHERE kode_barcode='00048382' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2271500',harga_beli ='2271500' WHERE kode_barcode='00048383' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2220000',harga_beli ='2220000' WHERE kode_barcode='00048384' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2989000',harga_beli ='2989000' WHERE kode_barcode='00048385' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2611000',harga_beli ='2611000' WHERE kode_barcode='00048386' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1328500',harga_beli ='1328500' WHERE kode_barcode='00048387' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1381000',harga_beli ='1381000' WHERE kode_barcode='00048388' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='00048389' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1958000',harga_beli ='1958000' WHERE kode_barcode='00048390' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3347000',harga_beli ='3347000' WHERE kode_barcode='00048494' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1277000',harga_beli ='1277000' WHERE kode_barcode='00048580' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1359000',harga_beli ='1359000' WHERE kode_barcode='00048581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1134000',harga_beli ='1134000' WHERE kode_barcode='00048582' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1297500',harga_beli ='1297500' WHERE kode_barcode='00048583' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1481500',harga_beli ='1481500' WHERE kode_barcode='00048584' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1226000',harga_beli ='1226000' WHERE kode_barcode='00048585' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1246500',harga_beli ='1246500' WHERE kode_barcode='00048586' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1461000',harga_beli ='1461000' WHERE kode_barcode='00048587' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1696000',harga_beli ='1696000' WHERE kode_barcode='00048588' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00048589' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1205500',harga_beli ='1205500' WHERE kode_barcode='00048590' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1604000',harga_beli ='1604000' WHERE kode_barcode='00048591' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1308000',harga_beli ='1308000' WHERE kode_barcode='00048592' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1195500',harga_beli ='1195500' WHERE kode_barcode='00048593' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2867000',harga_beli ='2867000' WHERE kode_barcode='00048599' LIMIT 1; UPDATE tm_group SET harga='2270000' WHERE kode_group = 'GOLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2270000','kasir','2026-10-28 17:57:38'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261028-0016','jogja','1',' DP-04644JO','TOKO','JOGPSN','PSPRT-ZJBF-44-0','CINCIN PERAK YL01 ','','3.010','1','100.00','308000','0','0','17800','850000','0','0','0','850000','DEW','00048654','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBF-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0016','2026-10-28','3.010','2026-10-28','17:57:45','PLG0018072','850000','850000','0','850000','0','jogja','2026-10-28 17:57:44','FJ-261028-0016','DP-04644','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0016','2026-10-28','17:57:45','DEW','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0016' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04856','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE: 15.5','GRF: E??H FONT: BRUSH SCRIPT','FINISHING: PUTIH DOFF MIX GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0019','2026-10-28','2026-10-28 18:13:14','PESANAN : DP-04856','-','TBC','900000','900000'); 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-261028-0020','D','2026-10-28','18:13:14','TBC','PESANAN','DP-04856','30088366964','900000','30089266964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04856','2026-10-28','2026-10-28','18:13:14','PLG0018073','VAN','2026-11-20','sby','2026-10-28 18:13:14','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-28 ','18:21:30'); DELETE FROM tm_berlian WHERE kode_barang='TFCMR-ZJBX-49-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFCMR-ZJBX-49-0','00048382','00048382','THIFA CINCIN MAS RG ','THIFA CINCIN MAS RG','','','1639500','1639500',' 0','0','kasir','2026-10-28 18:22:22'); UPDATE tm_barang SET nama_barang='THIFA CINCIN MAS RG' ,nama_atribut='' ,kode_intern='TFCMR75-87% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFCMR-ZJBX-49-0' 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,potong_rp,keterangan) VALUES ('FJ-261028-0017','kasir','1',' TFCMR75-87','TOKO','TFCINMAS','TFCMR-ZJBX-49-0','THIFA CINCIN MAS RG','','0.830','1','87.00','1673000','0','0','17800','1700000','0','0','0','1700000','RISIANA','00048382','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZJBX-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='TFCMR-ZJBX-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0017','2026-10-28','0.830','2026-10-28','18:23:02','PLG0018074','1700000','1700000','0','1700000','1700000','kasir','2026-10-28 18:23:01','FJ-261028-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0017','2026-10-28','18:23:02','RISIANA','1700000','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-261028-0002','D','2026-10-28','18:23:02','kasir','PENJUALAN','FJ-261028-0017','294600','1700000','1994600'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0017'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04857','PUT','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz cwe 14 crom putih glosy','grf Jae font Yeseva','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0020','2026-10-28','2026-10-28 18:30:43','PESANAN : DP-04857','.','TBC','1000000','1000000'); 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-261028-0021','D','2026-10-28','18:30:43','TBC','PESANAN','DP-04857','30089266964','1000000','30090266964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04857','2026-10-28','2026-10-28','18:30:43','PLG0018075','PUT','2026-11-30','kasirbip','2026-10-28 18:30:43','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04858','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','800000','0','800000','sz cwo 15.5 crom putih glosy','grf Tiwi font Yeseva','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0021','2026-10-28','2026-10-28 18:32:31','PESANAN : DP-04858','.','TBC','800000','800000'); 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-261028-0022','D','2026-10-28','18:32:31','TBC','PESANAN','DP-04858','30090266964','800000','30091066964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04858','2026-10-28','2026-10-28','18:32:31','PLG0018076','MIL','2026-11-30','kasirbip','2026-10-28 18:32:31','3.000','0','0','0','800000','0','0','800000','800000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04859','SULIS','1','GOLD','WED RING','','','2.000','','37.50','1','2270000','1400000','0','750000','3550000','sz 14 putih doff semprot 1 zircon','font yeseva one grf Z .... C','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0022','2026-10-28','2026-10-28 18:38:51','PESANAN : DP-04859','.','TBC','2800000','2800000'); 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-261028-0023','D','2026-10-28','18:38:51','TBC','PESANAN','DP-04859','30091066964','2800000','30093866964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04859','2026-10-28','2026-10-28','18:38:51','PLG0018077','SULIS','2026-11-28','kasirbip','2026-10-28 18:38:51','2.000','0','0','0','2800000','0','750000','3550000','3550000','750000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04860','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','500000','1200000','sz 14 putih doff amplass','font yeseva one grf Z .... C','YL-01','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261028-0023','2026-10-28','2026-10-28 18:40:12','PESANAN : DP-04860','.','TBC','1000000','1000000'); 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-261028-0024','D','2026-10-28','18:40:12','TBC','PESANAN','DP-04860','30093866964','1000000','30094866964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04860','2026-10-28','2026-10-28','18:40:12','PLG0018078','SULIS','2026-11-28','kasirbip','2026-10-28 18:40:12','2.000','0','0','0','1000000','0','500000','1200000','1200000','200000'); 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,potong_rp,keterangan) VALUES ('FJ-261028-0018','sby','1',' DP-04467SB','TOKO','SBYPSN','PSPLT-ZJBD-34-0','CINCIN PALADIUM ','','3.090','1','17.00','694000','0','0','17800','1832000','0','0','0','1832000','DIL','00048609','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBD-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPLT-ZJBD-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0018','2026-10-28','3.090','2026-10-28','19:10:53','PLG0018079','1832000','1832000','0','1832000','0','sby','2026-10-28 19:10:52','FJ-261028-0018','DP-04467','1500000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0018','2026-10-28','19:10:53','DIL','1832000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0024','2026-10-28','2026-10-28 19:10:52','PENJUALAN : FJ-261028-0018','','TBC','332000','332000','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-261028-0025','D','2026-10-28','19:10:53','TBC','PENJUALAN','FJ-261028-0018','30094866964','332000','30095198964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='332000' WHERE no_faktur_jual='FJ-261028-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0018'; 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-20261028-0003','1','PSPRT-ZJBG-33-0','1','3.440','3.440','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-28 19:17:45' WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 19:17:45','TOKO','BIPPSN','PSPRT','PSPRT-ZJBG-33-0','1','3.440','3.440','1','3.440','3.440','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0003','1','PSPRT-ZJBG-34-0','1','2.210','2.210','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-28 19:17:45' WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 19:17:45','TOKO','BIPPSN','PSPRT','PSPRT-ZJBG-34-0','1','2.210','2.210','1','2.210','2.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0003','1','PSPRT-ZJBG-35-0','1','4.030','4.030','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-28 19:17:45' WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 19:17:45','TOKO','BIPPSN','PSPRT','PSPRT-ZJBG-35-0','1','4.030','4.030','1','4.030','4.030','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; 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-20261028-0003','1','PSPRT-ZJBG-46-0','1','2.990','2.990','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-28 19:17:45' WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-28 19:17:45','TOKO','BIPPSN','PSPRT','PSPRT-ZJBG-46-0','1','2.990','2.990','1','2.990','2.990','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBG-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-28' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261028-0003','2026-10-28','19:17','12.670','kasirbip','2026-10-28 19:17:44'); UPDATE tt_service_head SET tgl_selesai='2026-10-28', status ='DONE' WHERE no_service='SV-02287'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02287'; 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,potong_rp,keterangan) VALUES ('FJ-261028-0019','jogja','1',' DP-04345JO','TOKO','JOGPSN','PSPRT-ZJBF-25-0','CINCIN PERAK ','','1.440','1','100.00','147000','0','0','17800','950000','0','0','0','950000','ADL','00048635','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBF-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0019','2026-10-28','1.440','2026-10-28','19:22:50','PLG0018080','950000','950000','0','950000','0','jogja','2026-10-28 19:22:50','FJ-261028-0019','DP-04345','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0019','2026-10-28','19:22:50','ADL','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0019' 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,potong_rp,keterangan) VALUES ('FJ-261028-0020','jogja',' 1',' DP-04344JO','TOKO','JOGPSN','PSPRT-ZJBF-24-0','CINCIN PERAK YL10 ','','4.480','1','100.00','458000','0','0','17800','900000','0','0','0','900000','ADL','00048634','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.480',berat_jual_asli=berat_jual_asli+'4.480',stock_jual='1',berat_akhir=berat_akhir-'4.480',berat_akhir_asli=berat_akhir_asli-'4.480',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSPRT-ZJBF-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0020','2026-10-28','4.480','2026-10-28','19:22:50','PLG0018081','900000','900000','0','900000','0','jogja','2026-10-28 19:22:50','FJ-261028-0019','DP-04344','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0020','2026-10-28','19:22:50','ADL','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261028-0020' 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,potong_rp,keterangan) VALUES ('FJ-261028-0021','kasirbip','1',' 800K-255-0','TOKO','DUPERBDG','LXPER-ZJBA-16-0','CINCIN SILVER 925 ','','3.870','1','100.00','395000','0','0','17800','950000','0','0','0','950000','PUT','00048446','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJBA-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.870',berat_jual_asli=berat_jual_asli+'3.870',stock_jual='1',berat_akhir=berat_akhir-'3.870',berat_akhir_asli=berat_akhir_asli-'3.870',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='LXPER-ZJBA-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0021','2026-10-28','3.870','2026-10-28','19:27:26','PLG0018082','950000','950000','0','950000','0','kasirbip','2026-10-28 19:27:26','FJ-261028-0021','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0021','2026-10-28','19:27:26','PUT','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0025','2026-10-28','2026-10-28 19:27:26','PENJUALAN : FJ-261028-0021','.','TBC','950000','950000','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-261028-0026','D','2026-10-28','19:27:26','TBC','PENJUALAN','FJ-261028-0021','30095198964','950000','30096148964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-261028-0021' 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,potong_rp,keterangan) VALUES ('FJ-261028-0022','kasirbip','1',' 800K-16-00','TOKO','DUPERBDG','LXPER-ZHAX-8-0','CINCIN SILVER 925 ','','2.960','1','100.00','302000','0','0','17800','900000','0','0','0','900000','MIL','00046011','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAX-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='LXPER-ZHAX-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0022','2026-10-28','2.960','2026-10-28','19:28:00','PLG0018083','900000','900000','0','900000','0','kasirbip','2026-10-28 19:27:59','FJ-261028-0022','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0022','2026-10-28','19:28:00','MIL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0026','2026-10-28','2026-10-28 19:27:59','PENJUALAN : FJ-261028-0022','.','TBC','900000','900000','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-261028-0027','D','2026-10-28','19:28:00','TBC','PENJUALAN','FJ-261028-0022','30096148964','900000','30097048964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261028-0022' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0022'; 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,potong_rp,keterangan) VALUES ('FJ-261028-0023','sby','1',' 800K-21-00','TOKO','SBYPER','PSBY-ZJAI-74-0','CINCIN SILVER 925 ','','2.760','1','100.00','282000','0','0','17800','900000','0','0','0','900000','DIL','00048318','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-74-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='PSBY-ZJAI-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0023','2026-10-28','2.760','2026-10-28','19:32:02','PLG0018084','900000','900000','0','900000','0','sby','2026-10-28 19:32:01','FJ-261028-0023','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0023','2026-10-28','19:32:02','DIL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0027','2026-10-28','2026-10-28 19:32:01','PENJUALAN : FJ-261028-0023','','TBC','900000','900000','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-261028-0028','D','2026-10-28','19:32:02','TBC','PENJUALAN','FJ-261028-0023','30097048964','900000','30097948964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261028-0023' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0023'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-28', status ='CLOS' WHERE no_service='SV-02287'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02287'; 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,potong_rp,keterangan) VALUES ('FJ-261028-0024','kasirbip','1',' 850K-18-00','TOKO','DUPERBDG','LXPER-ZFAH-33-0','CINCIN SILVER 925 ','','2.990','1','100.00','305000','0','0','17800','950000','0','0','0','950000','PUT','00044546','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='LXPER-ZFAH-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0024','2026-10-28','2.990','2026-10-28','19:50:14','PLG0018085','950000','950000','0','950000','0','kasirbip','2026-10-28 19:50:13','FJ-261028-0024','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0024','2026-10-28','19:50:14','PUT','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0028','2026-10-28','2026-10-28 19:50:13','PENJUALAN : FJ-261028-0024','.','TBC','950000','950000','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-261028-0029','D','2026-10-28','19:50:14','TBC','PENJUALAN','FJ-261028-0024','30097948964','950000','30098898964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-261028-0024' 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,potong_rp,keterangan) VALUES ('FJ-261028-0025','kasirbip',' 1',' 800K-18-00','TOKO','DUPERBDG','LXPER-ZHBH-32-0','CINCIN SILVER 925 ','','2.840','1','100.00','290000','0','0','17800','900000','0','0','0','900000','PUT','00046622','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHBH-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2026-10-28' AND kode_barang='LXPER-ZHBH-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261028-0025','2026-10-28','2.840','2026-10-28','19:50:14','PLG0018086','900000','900000','0','900000','0','kasirbip','2026-10-28 19:50:13','FJ-261028-0024','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-28','FJ-261028-0025','2026-10-28','19:50:14','PUT','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261028-0029','2026-10-28','2026-10-28 19:50:13','PENJUALAN : FJ-261028-0025','.','TBC','900000','900000','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-261028-0030','D','2026-10-28','19:50:14','TBC','PENJUALAN','FJ-261028-0025','30098898964','900000','30099798964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-261028-0025' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261028-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261028-0025'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-28 ','21:07:01'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-29','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-28'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-28'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-28'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-28' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-28'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-28'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-28'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-28'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-29' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-28' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; 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-261029-0001','D','2026-10-29','21:27:21','TBC','SALDO AWAL','SALDO AWAL','0','30099798964','30099798964'); 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-261029-0001','D','2026-10-29','21:27:21','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); 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-261029-0001','D','2026-10-29','21:27:21','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); 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-261029-0001','D','2026-10-29','21:27:21','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261029-0001','D','2026-10-29','21:27:21','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261029-0001','D','2026-10-29','21:27:21','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-261029-0001','D','2026-10-29','21:27:21','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-261029-0001','D','2026-10-29','21:27:21','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-261029-0001','D','2026-10-29','21:27:21','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-261029-0001','D','2026-10-29','21:27:21','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-261029-0001','D','2026-10-29','21:27:21','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-261029-0001','D','2026-10-29','21:27:21','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-10-29';