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-20260522-0001','1','A1D-ZCAI-127-0','1','1.520','1.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZCAI-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZCAI-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-22 07:44:52' WHERE kode_barang='A1D-ZCAI-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZCAI-127-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-05-22 07:44:52','TOKO','PM-A','A1D','A1D-ZCAI-127-0','1','1.520','1.520','1','1.520','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZCAI-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZCAI-127-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260522-0001','1','A1E-ZCCX-439-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZCCX-439-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZCCX-439-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-22 07:44:52' WHERE kode_barang='A1E-ZCCX-439-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZCCX-439-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-05-22 07:44:52','TOKO','PM-A','A1E','A1E-ZCCX-439-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZCCX-439-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZCCX-439-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:44','2.020','admpindah','2026-05-22 07:44:52');
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-20260522-0001','1','D2E-ZEXI-55-0','1','0.550','0.550','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZEXI-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZEXI-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-05-22 07:45:09' WHERE kode_barang='D2E-ZEXI-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZEXI-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-22 07:45:09','TOKO','PM-D','D2E','D2E-ZEXI-55-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZEXI-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZEXI-55-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:45','0.550','admpindah','2026-05-22 07:45:09');
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-20260522-0001','1','E1E-ZCCA-126-0','1','0.680','0.680','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCCA-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCCA-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-22 07:45:24' WHERE kode_barang='E1E-ZCCA-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCCA-126-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-05-22 07:45:24','TOKO','PM-E','E1E','E1E-ZCCA-126-0','1','0.680','0.680','1','0.680','0.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCCA-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCCA-126-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260522-0001','1','E2E-ZEAA-103-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZEAA-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZEAA-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-22 07:45:24' WHERE kode_barang='E2E-ZEAA-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZEAA-103-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-05-22 07:45:24','TOKO','PM-E','E2E','E2E-ZEAA-103-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZEAA-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZEAA-103-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:45','1.180','admpindah','2026-05-22 07:45:24');
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-20260522-0001','1','H1E-ZEXI-179-0','1','1.830','1.830','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEXI-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEXI-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-22 07:45:45' WHERE kode_barang='H1E-ZEXI-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEXI-179-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-05-22 07:45:45','TOKO','PM-H','H1E','H1E-ZEXI-179-0','1','1.830','1.830','1','1.830','1.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZEXI-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEXI-179-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:45','1.830','admpindah','2026-05-22 07:45:45');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260522-0001','1','A1TD-ZEBA-6-T','1','0.910','0.910','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZEBA-6-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZEBA-6-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-05-22 07:46:32' WHERE kode_barang='A1TD-ZEBA-6-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZEBA-6-T' 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-05-22 07:46:32','TOKO','PT-A','A1TD','A1TD-ZEBA-6-T','1','0.910','0.910','1','0.910','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZEBA-6-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZEBA-6-T';
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-20260522-0001','1','A1TE-ZEBA-7-T','1','0.520','0.520','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZEBA-7-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-7-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-05-22 07:46:32' WHERE kode_barang='A1TE-ZEBA-7-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZEBA-7-T' 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-05-22 07:46:32','TOKO','PT-A','A1TE','A1TE-ZEBA-7-T','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZEBA-7-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-7-T';
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-20260522-0001','1','A1TE-ZEBA-8-T','1','0.460','0.460','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZEBA-8-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-8-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-05-22 07:46:32' WHERE kode_barang='A1TE-ZEBA-8-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZEBA-8-T' 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-05-22 07:46:32','TOKO','PT-A','A1TE','A1TE-ZEBA-8-T','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZEBA-8-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-8-T';
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-20260522-0001','1','A1TE-ZEBA-9-T','1','0.510','0.510','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZEBA-9-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-9-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-05-22 07:46:32' WHERE kode_barang='A1TE-ZEBA-9-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZEBA-9-T' 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-05-22 07:46:32','TOKO','PT-A','A1TE','A1TE-ZEBA-9-T','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZEBA-9-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-9-T';
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-20260522-0001','1','A1TE-ZEBA-10-T','1','0.570','0.570','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZEBA-10-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-10-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-05-22 07:46:32' WHERE kode_barang='A1TE-ZEBA-10-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZEBA-10-T' 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-05-22 07:46:32','TOKO','PT-A','A1TE','A1TE-ZEBA-10-T','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZEBA-10-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZEBA-10-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:46','2.970','admpindah','2026-05-22 07:46: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-20260522-0001','1','E2TD-ZEBA-11-T','1','1.110','1.110','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-ZEBA-11-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-ZEBA-11-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E2TD-ZEBA-11-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-ZEBA-11-T' 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-05-22 07:46:50','TOKO','PT-E','E2TD','E2TD-ZEBA-11-T','1','1.110','1.110','1','1.110','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-ZEBA-11-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-ZEBA-11-T';
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-20260522-0001','1','E1TD-ZEBA-12-T','1','1.150','1.150','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZEBA-12-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-12-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E1TD-ZEBA-12-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZEBA-12-T' 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-05-22 07:46:50','TOKO','PT-E','E1TD','E1TD-ZEBA-12-T','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZEBA-12-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-12-T';
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-20260522-0001','1','E1TD-ZEBA-13-T','1','1.000','1.000','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZEBA-13-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-13-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E1TD-ZEBA-13-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZEBA-13-T' 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-05-22 07:46:50','TOKO','PT-E','E1TD','E1TD-ZEBA-13-T','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZEBA-13-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-13-T';
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-20260522-0001','1','E1TD-ZEBA-14-T','1','1.541','1.541','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZEBA-14-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-14-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E1TD-ZEBA-14-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZEBA-14-T' 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-05-22 07:46:50','TOKO','PT-E','E1TD','E1TD-ZEBA-14-T','1','1.541','1.541','1','1.541','1.541','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZEBA-14-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-14-T';
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-20260522-0001','1','E2TD-ZEBA-15-T','1','1.260','1.260','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-ZEBA-15-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-ZEBA-15-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E2TD-ZEBA-15-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-ZEBA-15-T' 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-05-22 07:46:50','TOKO','PT-E','E2TD','E2TD-ZEBA-15-T','1','1.260','1.260','1','1.260','1.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-ZEBA-15-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-ZEBA-15-T';
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-20260522-0001','1','E1TD-ZEBA-16-T','1','1.540','1.540','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZEBA-16-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-16-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-05-22 07:46:50' WHERE kode_barang='E1TD-ZEBA-16-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZEBA-16-T' 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-05-22 07:46:50','TOKO','PT-E','E1TD','E1TD-ZEBA-16-T','1','1.540','1.540','1','1.540','1.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZEBA-16-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZEBA-16-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:46','7.601','admpindah','2026-05-22 07:46:49');
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-20260522-0001','1','H1TE-ZEBA-17-T','1','3.900','3.900','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZEBA-17-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-17-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-05-22 07:47:08' WHERE kode_barang='H1TE-ZEBA-17-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZEBA-17-T' 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-05-22 07:47:08','TOKO','PT-H','H1TE','H1TE-ZEBA-17-T','1','3.900','3.900','1','3.900','3.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZEBA-17-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-17-T';
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-20260522-0001','1','H1TE-ZEBA-18-T','1','2.920','2.920','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZEBA-18-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-18-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-05-22 07:47:08' WHERE kode_barang='H1TE-ZEBA-18-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZEBA-18-T' 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-05-22 07:47:08','TOKO','PT-H','H1TE','H1TE-ZEBA-18-T','1','2.920','2.920','1','2.920','2.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZEBA-18-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-18-T';
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-20260522-0001','1','H1TE-ZEBA-19-T','1','2.900','2.900','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZEBA-19-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-19-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-05-22 07:47:08' WHERE kode_barang='H1TE-ZEBA-19-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZEBA-19-T' 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-05-22 07:47:08','TOKO','PT-H','H1TE','H1TE-ZEBA-19-T','1','2.900','2.900','1','2.900','2.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZEBA-19-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-19-T';
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-20260522-0001','1','H1TE-ZEBA-20-T','1','3.520','3.520','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZEBA-20-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-20-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-05-22 07:47:08' WHERE kode_barang='H1TE-ZEBA-20-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZEBA-20-T' 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-05-22 07:47:08','TOKO','PT-H','H1TE','H1TE-ZEBA-20-T','1','3.520','3.520','1','3.520','3.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZEBA-20-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZEBA-20-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260522-0001','2026-05-22','07:46','13.240','admpindah','2026-05-22 07:47:07');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220815481','input','1',' TEF3 UB ','TOKO','PT-F','F3TE-YLAC-43-T','GL RANTAI S SLEP UB 17K ','','1.510','1','100.00','3050000','0','0','15000','3050000','0','0','0','3050000','FIT','T0075778','F3TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAC-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='F3TE-YLAC-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220815481','2026-05-22','1.510','2026-05-22','08:15:49','PLG0029306','3050000','3050000','0','3050000','3050000','input','2026-05-22 08:15:48','F32622081548');
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-05-22','F326220815481','2026-05-22','08:15:49','FIT','3050000','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-260522-0002','D','2026-05-22','08:15:49','input','PENJUALAN','F326220815481','5082730000','3050000','5085780000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220900461','input','1',' MEB1 5K HW','TOKO','PM-B','B1E-ZEAH-108-0','GW TIFF CLOVER CAT HITAM HW 8K ','','0.510','1','100.00','564000','0','0','15000','565000','0','5000','0','570000','SIN','00404014','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAH-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='B1E-ZEAH-108-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220900461','2026-05-22','0.510','2026-05-22','09:00:46','PLG0029307','565000','565000','5000','570000','570000','input','2026-05-22 09:00:46','F32622090046');
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-05-22','F326220900461','2026-05-22','09:00:46','SIN','570000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260522-0003','D','2026-05-22','09:00:46','input','PENJUALAN','F326220900461','5085780000','570000','5086350000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221040151','input','1',' MDE1 CM 10','TOKO','PM-E','E1D-ZCAX-521-0','CC MODEL DUAN SLEP CM 10 8K ','','0.860','1','100.00','933000','0','0','15000','933000','0','0','0','933000','FIT','00393498','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAX-521-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E1D-ZCAX-521-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221040151','2026-05-22','0.860','2026-05-22','10:40:16','PLG0029308','933000','933000','0','933000','933000','input','2026-05-22 10:40:15','F32622104015');
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-05-22','F326221040151','2026-05-22','10:40:16','FIT','933000','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-260522-0004','D','2026-05-22','10:40:16','input','PENJUALAN','F326221040151','5086350000','933000','5087283000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221056351','input','1',' TEE1 XX HK','TOKO','PT-E','E1TE-WJAG-98-T','CC XX VELG KACA HK 10 ','','0.950','1','100.00','1919000','0','0','15000','1890000','0','0','0','1890000','SIN','T0049682','E1TE','0','0','-','1','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-WJAG-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E1TE-WJAG-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221056351','2026-05-22','0.950','2026-05-22','10:56:36','PLG0029309','1890000','1890000','0','1890000','1890000','input','2026-05-22 10:56:35','F32622105635');
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-05-22','F326221056351','2026-05-22','10:56:36','SIN','1890000','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-260522-0005','D','2026-05-22','10:56:36','input','PENJUALAN','F326221056351','5087283000','1890000','5089173000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221141111','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-YKXC-583-0','CC X BANGKOK SLEP CM 10 8K ','','1.000','1','100.00','1085000','0','0','15000','1085000','0','0','0','1085000','AAT','00376514','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKXC-583-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E1D-YKXC-583-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221141111','2026-05-22','1.000','2026-05-22','11:41:12','PLG0029310','1085000','1085000','0','1085000','1085000','input','2026-05-22 11:41:11','F32622114111');
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-05-22','F326221141111','2026-05-22','11:41:12','AAT','1085000','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-260522-0006','D','2026-05-22','11:41:12','input','PENJUALAN','F326221141111','5089173000','1085000','5090258000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221156021','input','1',' MEF1 X CM ','TOKO','PM-F','F1E-ZDAH-75-0','GL X OVAL DAUN SLEP CM 54 8K','','3.460','1','100.00','3823000','0','0','15000','3823000','0','0','0','3823000','SIN','00399776','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAH-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='F1E-ZDAH-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221156021','2026-05-22','3.460','2026-05-22','11:56:02','PLG0029311','3823000','3823000','0','3823000','3823000','input','2026-05-22 11:56:02','F32622115602');
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-05-22','F326221156021','2026-05-22','11:56:02','SIN','3823000','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-260522-0007','D','2026-05-22','11:56:02','input','PENJUALAN','F326221156021','5090258000','3823000','5094081000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221210331','input','1',' MEE1 LG 21','TOKO','PM-E','E1E-ZEAE-238-0','CC MODEL DAUN VAR LG 21 8K ','','0.600','1','100.00','663000','0','0','15000','663000','0','0','0','663000','LIS','00403716','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E1E-ZEAE-238-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221210331','2026-05-22','0.600','2026-05-22','12:10:34','PLG0029312','663000','663000','0','663000','663000','input','2026-05-22 12:10:33','F32622121033');
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-05-22','F326221210331','2026-05-22','12:10:34','LIS','663000','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-260522-0008','D','2026-05-22','12:10:34','input','PENJUALAN','F326221210331','5094081000','663000','5094744000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326221222081','input','1',' MDE2 X MJ ','TOKO','PM-E','E2D-ZEXI-244-0','CC X MODEL MATA MJ 18 8K ','','1.380','1','100.00','1497000','0','0','15000','1497000','0','0','0','1497000','FIT','00403065','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXI-244-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E2D-ZEXI-244-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326221222081','2026-05-22','1.380','2026-05-22','12:22:09','PLG0029313','1497000','1497000','0','1497000','1497000','input','2026-05-22 12:22:08','F32622122208');
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-05-22','F326221222081','2026-05-22','12:22:09','FIT','1497000','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-260522-0009','D','2026-05-22','12:22:09','input','PENJUALAN','F326221222081','5094744000','1497000','5096241000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019193','X-00019193','GL ANAK MODEL TRIXIE VAR LT 8K','GR','---','F3E','BELI','BELI001','965000','2026-05-22','1.020','1','kasir','2026-05-22 13:23:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019193','X-00019193');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260522-0001','F326281014001','FIT','1','BELI','BELI001','F3E', 'X-00019193', 'GL ANAK MODEL TRIXIE VAR LT 8K','1.020','1.020','100.00','1143000','965000','946078','1115000','1','965000','965000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260522-0001','2026-05-22','2026-05-22','13:23:31','FIT','---','1.020','965000','965000','965000','965000','965000','kasir','2026-05-22 13:23:32','FB-260522-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0001','BIANCA','SENDANG PWO','','','','kasir','2026-05-22 13:23:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0010','K','2026-05-22','13:23:31','kasir','PEMBELIAN UMUM','FB-260522-0001','5096241000','965000','5095276000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019194','X-00019194','CC X POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','970000','2026-05-22','0.960','1','kasir','2026-05-22 13:23:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019194','X-00019194');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260522-0002','F326270127211','LIS','1','BELI','BELI001','E1D', 'X-00019194', 'CC X POLOS CM 22 8K','0.960','0.960','100.00','1045000','970000','1010417','1095000','1','970000','970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260522-0002','2026-05-22','2026-05-22','13:23:53','LIS','---','0.960','970000','970000','970000','970000','970000','kasir','2026-05-22 13:23:53','FB-260522-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0002','ENI','NAWANGAN PACITAN','','','','kasir','2026-05-22 13:23:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0011','K','2026-05-22','13:23:53','kasir','PEMBELIAN UMUM','FB-260522-0002','5095276000','970000','5094306000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019195','X-00019195','KL X NORY UB 44 8K','GR','---','H1E','BELI','BELI001','1900000','2026-05-22','2.020','1','kasir','2026-05-22 13:51:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019195','X-00019195');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260522-0003','F325061045211','AAT','1','BELI','BELI001','H1E', 'X-00019195', 'KL X NORY UB 44 8K','2.020','2.020','100.00','2000000','1900000','940594','1115000','1','1900000','1900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260522-0003','2026-05-22','2026-05-22','13:51:53','AAT','---','2.020','1900000','1900000','1900000','1900000','1900000','kasir','2026-05-22 13:51:53','FB-260522-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0003','NADIFAH','BADEGAN','','','','kasir','2026-05-22 13:51:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0012','K','2026-05-22','13:51:53','kasir','PEMBELIAN UMUM','FB-260522-0003','5094306000','1900000','5092406000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220236441','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-ZCCX-536-0','CC X MODEL HURUF MATA PM 18 N 8K ','','1.220','1','100.00','1324000','0','0','15000','1325000','0','0','0','1325000','LIS','00397190','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-536-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='E2D-ZCCX-536-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220236441','2026-05-22','1.220','2026-05-22','14:36:44','PLG0029314','1325000','1325000','0','1325000','1325000','kasir','2026-05-22 14:36:44','F32622023644');
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-05-22','F326220236441','2026-05-22','14:36:44','LIS','1325000','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-260522-0013','D','2026-05-22','14:36:44','kasir','PENJUALAN','F326220236441','5092406000','1325000','5093731000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220239041','kasir','1',' MEH1 XX HW','TOKO','PM-H','H1E-YLAA-54-0','KL XX SANTA SPECTA HITAM VAR HW 42 8K ','','2.270','1','100.00','2508000','0','0','15000','2440000','0','0','0','2440000','FIT','00380636','H1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAA-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='H1E-YLAA-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220239041','2026-05-22','2.270','2026-05-22','14:39:05','PLG0029315','2440000','2440000','0','2440000','2440000','kasir','2026-05-22 14:39:04','F32622023904');
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-05-22','F326220239041','2026-05-22','14:39:05','FIT','2440000','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-260522-0014','D','2026-05-22','14:39:05','kasir','PENJUALAN','F326220239041','5093731000','2440000','5096171000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019196','X-00019196','KL RG CASANO HATI KECIL HW','GR','---','H2TF','BELI','BELI001','4155000','2026-05-22','2.680','1','kasir','2026-05-22 14:41:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2TF','X-00019196','X-00019196');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260522-0004','F322081108181','FIT','1','BELI','BELI001','H2TF', 'X-00019196', 'KL RG CASANO HATI KECIL HW','2.680','2.680','100.00','2040000','4155000','1550373','2040000','1','4155000','4155000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.680',berat_beli_asli=berat_beli_asli+'2.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.680',berat_akhir_asli=berat_akhir_asli+'2.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2TF' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260522-0004','2026-05-22','2026-05-22','14:41:32','FIT','---','2.680','4155000','4155000','4155000','4155000','4155000','kasir','2026-05-22 14:41:32','FB-260522-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0004','AYU','DANGKRANG PWO','','','','kasir','2026-05-22 14:41:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0015','K','2026-05-22','14:41:32','kasir','PEMBELIAN UMUM','FB-260522-0004','5096171000','4155000','5092016000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220253451','input','1',' MEA1E HW ','TOKO','PM-A','A1E-ZEAH-100-0','AT ITALY SLEP VAR HW 8K ','','0.630','1','100.00','696000','0','0','15000','695000','0','0','0','695000','AAT','00404006','A1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEAH-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='A1E-ZEAH-100-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220253451','2026-05-22','0.630','2026-05-22','14:53:46','PLG0029316','695000','695000','0','695000','695000','input','2026-05-22 14:53:45','F32622025345');
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-05-22','F326220253451','2026-05-22','14:53:46','AAT','695000','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-260522-0016','D','2026-05-22','14:53:46','input','PENJUALAN','F326220253451','5092016000','695000','5092711000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220257191','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-ZDXH-117-0','KL GUCI ANAK 34 CM UB 8K ','','2.000','1','100.00','2210000','0','0','15000','2210000','0','0','0','2210000','SIN','00398569','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXH-117-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-05-22' AND kode_barang='H1E-ZDXH-117-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220257191','2026-05-22','2.000','2026-05-22','14:57:20','PLG0029317','2210000','2210000','0','2210000','2210000','input','2026-05-22 14:57:19','F32622025719');
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-05-22','F326220257191','2026-05-22','14:57:20','SIN','2210000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260522-0017','D','2026-05-22','14:57:20','input','PENJUALAN','F326220257191','5092711000','2210000','5094921000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2210000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220257191' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326220257192','input',' 1',' MFD2F X LG','TOKO','PM-D','D2F-YHAI-162-0','LT X MODEL HURUF MATA LG F 8K ','','0.450','1','100.00','506000','0','0','15000','505000','0','0','0','505000','SIN','00366193','D2F','0','0','-','1','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YHAI-162-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='D2F-YHAI-162-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220257192','2026-05-22','0.450','2026-05-22','14:57:20','PLG0029318','505000','505000','0','505000','505000','input','2026-05-22 14:57:19','F32622025719');
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-05-22','F326220257192','2026-05-22','14:57:20','SIN','505000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260522-0018','D','2026-05-22','14:57:20','input','PENJUALAN','F326220257192','5094921000','505000','5095426000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='505000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326220257192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3763000',harga_beli ='3763000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11460000',harga_beli ='11460000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11384000',harga_beli ='11384000' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9512000',harga_beli ='9512000' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='19100000',harga_beli ='19100000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='898000',harga_beli ='898000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11460000',harga_beli ='11460000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11460000',harga_beli ='11460000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11460000',harga_beli ='11460000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='15280000',harga_beli ='15280000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='19100000',harga_beli ='19100000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='13370000',harga_beli ='13370000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='13370000',harga_beli ='13370000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='13370000',harga_beli ='13370000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2005500',harga_beli ='2005500' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='11498500',harga_beli ='11498500' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7583000',harga_beli ='7583000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1929500',harga_beli ='1929500' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1012500',harga_beli ='1012500' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7583000',harga_beli ='7583000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5692000',harga_beli ='5692000' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='15280000',harga_beli ='15280000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7640000',harga_beli ='7640000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='10696000',harga_beli ='10696000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5768500',harga_beli ='5768500' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5768500',harga_beli ='5768500' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3858500',harga_beli ='3858500' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='993500',harga_beli ='993500' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3724500',harga_beli ='3724500' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5654000',harga_beli ='5654000' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2960500',harga_beli ='2960500' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1853000',harga_beli ='1853000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2884500',harga_beli ='2884500' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5634500',harga_beli ='5634500' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1929500',harga_beli ='1929500' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3858500',harga_beli ='3858500' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9397500',harga_beli ='9397500' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3533500',harga_beli ='3533500' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7544500',harga_beli ='7544500' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5654000',harga_beli ='5654000' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='19119500',harga_beli ='19119500' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='19119500',harga_beli ='19119500' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='955000',harga_beli ='955000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='917000',harga_beli ='917000' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3839500',harga_beli ='3839500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9550000',harga_beli ='9550000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9588500',harga_beli ='9588500' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7602000',harga_beli ='7602000' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='7602000',harga_beli ='7602000' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3839500',harga_beli ='3839500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2769500',harga_beli ='2769500' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='2865000',harga_beli ='2865000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='9588500',harga_beli ='9588500' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5730000',harga_beli ='5730000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5768500',harga_beli ='5768500' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='879000',harga_beli ='879000' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3094500',harga_beli ='3094500' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='6036000',harga_beli ='6036000' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='T0076226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1948500',harga_beli ='1948500' WHERE kode_barcode='T0076227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='T0076230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='3896500',harga_beli ='3896500' WHERE kode_barcode='T0076231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1910000',harga_jual='5634500',harga_beli ='5634500' WHERE kode_barcode='T0038726' LIMIT 1;
UPDATE tm_group SET harga='1910000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1910000','input','2026-05-22 15:11:20');
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3802500',harga_beli ='3802500' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11580000',harga_beli ='11580000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11503000',harga_beli ='11503000' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9611500',harga_beli ='9611500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19300000',harga_beli ='19300000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='907500',harga_beli ='907500' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11580000',harga_beli ='11580000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11580000',harga_beli ='11580000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11580000',harga_beli ='11580000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='15440000',harga_beli ='15440000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19300000',harga_beli ='19300000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13510000',harga_beli ='13510000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13510000',harga_beli ='13510000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='13510000',harga_beli ='13510000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2026500',harga_beli ='2026500' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='11619000',harga_beli ='11619000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7662500',harga_beli ='7662500' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1949500',harga_beli ='1949500' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1023000',harga_beli ='1023000' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7662500',harga_beli ='7662500' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5751500',harga_beli ='5751500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='15440000',harga_beli ='15440000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7720000',harga_beli ='7720000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='10808000',harga_beli ='10808000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2798500',harga_beli ='2798500' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5829000',harga_beli ='5829000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5829000',harga_beli ='5829000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1004000',harga_beli ='1004000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3763500',harga_beli ='3763500' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5713000',harga_beli ='5713000' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2991500',harga_beli ='2991500' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1872500',harga_beli ='1872500' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5693500',harga_beli ='5693500' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1949500',harga_beli ='1949500' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3899000',harga_beli ='3899000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9496000',harga_beli ='9496000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3570500',harga_beli ='3570500' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7623500',harga_beli ='7623500' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5713000',harga_beli ='5713000' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19319500',harga_beli ='19319500' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='19319500',harga_beli ='19319500' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='965000',harga_beli ='965000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='926500',harga_beli ='926500' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3879500',harga_beli ='3879500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9650000',harga_beli ='9650000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9689000',harga_beli ='9689000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7681500',harga_beli ='7681500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='7681500',harga_beli ='7681500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3879500',harga_beli ='3879500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2798500',harga_beli ='2798500' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3860000',harga_beli ='3860000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='2895000',harga_beli ='2895000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='9689000',harga_beli ='9689000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5790000',harga_beli ='5790000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5829000',harga_beli ='5829000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='888000',harga_beli ='888000' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3127000',harga_beli ='3127000' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='6099000',harga_beli ='6099000' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1930000',harga_beli ='1930000' WHERE kode_barcode='T0076226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1969000',harga_beli ='1969000' WHERE kode_barcode='T0076227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='1891500',harga_beli ='1891500' WHERE kode_barcode='T0076230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='3937500',harga_beli ='3937500' WHERE kode_barcode='T0076231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1930000',harga_jual='5693500',harga_beli ='5693500' WHERE kode_barcode='T0038726' LIMIT 1;
UPDATE tm_group SET harga='1930000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1930000','input','2026-05-22 15:12: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,status_otorisasi,harga_skrg) VALUES ('F326220312371','input','1',' TAA0 X DW ','TOKO','PT-A','A0TA-YLBF-56-T','AT X JERSY MRICAN DW 17K ','','1.000','1','100.00','1930000','0','0','15000','1930000','0','0','0','1930000','SIN','T0076226','A0TA','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-05-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-22' AND kode_barang='A0TA-YLBF-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326220312371','2026-05-22','1.000','2026-05-22','15:12:37','PLG0029319','1930000','1930000','0','1930000','1930000','input','2026-05-22 15:12:37','F32622031237');
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-05-22','F326220312371','2026-05-22','15:12:37','SIN','1930000','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-260522-0019','D','2026-05-22','15:12:37','input','PENJUALAN','F326220312371','5095426000','1930000','5097356000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019197','X-00019197','GL MODEL FANCY VAR HW 8K','GR','---','F3E','BELI','BELI001','2325000','2026-05-22','2.620','1','kasir','2026-05-22 15:22:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019197','X-00019197');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260522-0005','F325261108431','AAT','1','BELI','BELI001','F3E', 'X-00019197', 'GL MODEL FANCY VAR HW 8K','2.620','2.620','100.00','2475000','2325000','887405','1115000','1','2325000','2325000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.620',berat_beli_asli=berat_beli_asli+'2.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.620',berat_akhir_asli=berat_akhir_asli+'2.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260522-0005','2026-05-22','2026-05-22','15:22:09','AAT','---','2.620','2325000','2325000','2325000','2325000','2325000','kasir','2026-05-22 15:22:10','FB-260522-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260522-0005','PUTRI','GESING KISMANTORO','','','','kasir','2026-05-22 15:22:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260522-0020','K','2026-05-22','15:22:09','kasir','PEMBELIAN UMUM','FB-260522-0005','5097356000','2325000','5095031000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260522-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260522-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220236441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220236441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220236441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220239041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220239041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220239041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220253451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220253451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220253451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220257191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220257191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220257191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220257192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220257192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220257192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220312371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220312371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220312371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220815481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220815481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220815481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326220900461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326220900461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326220900461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221040151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221040151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221040151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221056351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221056351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221056351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221141111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221141111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221141111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221156021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221156021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221156021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221210331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221210331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221210331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326221222081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326221222081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326221222081';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-22';
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-05-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260523-0001','D','2026-05-23','15:34:49','SYSTEM','SALDO AWAL','SALDO AWAL','0','5095031000','5095031000');
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-260523-0001','D','2026-05-23','15:34:49','BCA','SALDO AWAL','SALDO AWAL','0','712562000','712562000');
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-260523-0001','D','2026-05-23','15:34:49','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260523-0001','D','2026-05-23','15:34:49','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-23';