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-20260526-0001','1','A1D-ZEBE-28-0','1','0.870','0.870','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZEBE-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZEBE-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1D-ZEBE-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZEBE-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:43:48','TOKO','PM-A','A1D','A1D-ZEBE-28-0','1','0.870','0.870','1','0.870','0.870','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-ZEBE-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZEBE-28-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','A1E-ZEBE-37-0','1','0.450','0.450','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZEBE-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1E-ZEBE-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZEBE-37-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-26 07:43:48','TOKO','PM-A','A1E','A1E-ZEBE-37-0','1','0.450','0.450','1','0.450','0.450','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-ZEBE-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-37-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-20260526-0001','1','A1E-ZEBE-214-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZEBE-214-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-214-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1E-ZEBE-214-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZEBE-214-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-26 07:43:48','TOKO','PM-A','A1E','A1E-ZEBE-214-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-ZEBE-214-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-214-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-20260526-0001','1','A1E-ZEBE-215-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZEBE-215-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-215-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1E-ZEBE-215-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZEBE-215-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-26 07:43:48','TOKO','PM-A','A1E','A1E-ZEBE-215-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-ZEBE-215-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-215-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-20260526-0001','1','A1E-ZEBE-216-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZEBE-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1E-ZEBE-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZEBE-216-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-26 07:43:48','TOKO','PM-A','A1E','A1E-ZEBE-216-0','1','0.530','0.530','1','0.530','0.530','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-ZEBE-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-216-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-20260526-0001','1','A1E-ZEBE-217-0','1','0.500','0.500','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZEBE-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-05-26 07:43:48' WHERE kode_barang='A1E-ZEBE-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZEBE-217-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-26 07:43:48','TOKO','PM-A','A1E','A1E-ZEBE-217-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-ZEBE-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZEBE-217-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:43','3.350','admpindah','2026-05-26 07:43:48');
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-20260526-0001','1','B1F-ZEBE-17-0','1','0.320','0.320','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-ZEBE-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-ZEBE-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-05-26 07:44:08' WHERE kode_barang='B1F-ZEBE-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-ZEBE-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:44:08','TOKO','PM-B','B1F','B1F-ZEBE-17-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1F-ZEBE-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-ZEBE-17-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:44','0.320','admpindah','2026-05-26 07:44:07');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','D1F-ZEBE-126-0','1','0.330','0.330','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZEBE-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZEBE-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-05-26 07:44:28' WHERE kode_barang='D1F-ZEBE-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZEBE-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-26 07:44:28','TOKO','PM-D','D1F','D1F-ZEBE-126-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZEBE-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZEBE-126-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:44','0.330','admpindah','2026-05-26 07:44:28');
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-20260526-0001','1','E1D-ZCCA-138-0','1','0.980','0.980','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCCA-138-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCCA-138-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1D-ZCCA-138-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCCA-138-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-26 07:44:44','TOKO','PM-E','E1D','E1D-ZCCA-138-0','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZCCA-138-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCCA-138-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-20260526-0001','1','E1D-ZDBA-188-0','1','0.870','0.870','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZDBA-188-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZDBA-188-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1D-ZDBA-188-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZDBA-188-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-26 07:44:44','TOKO','PM-E','E1D','E1D-ZDBA-188-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZDBA-188-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZDBA-188-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-20260526-0001','1','E2D-ZEBE-67-0','1','0.830','0.830','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZEBE-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZEBE-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E2D-ZEBE-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZEBE-67-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-26 07:44:44','TOKO','PM-E','E2D','E2D-ZEBE-67-0','1','0.830','0.830','1','0.830','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZEBE-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZEBE-67-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-20260526-0001','1','E1D-ZEBE-81-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZEBE-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZEBE-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1D-ZEBE-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZEBE-81-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:44:44','TOKO','PM-E','E1D','E1D-ZEBE-81-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZEBE-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZEBE-81-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-20260526-0001','1','E1D-ZEBE-86-0','1','1.530','1.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZEBE-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZEBE-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1D-ZEBE-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZEBE-86-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:44:44','TOKO','PM-E','E1D','E1D-ZEBE-86-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZEBE-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZEBE-86-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-20260526-0001','1','E2E-ZEBE-94-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZEBE-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZEBE-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E2E-ZEBE-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZEBE-94-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-26 07:44:44','TOKO','PM-E','E2E','E2E-ZEBE-94-0','1','0.470','0.470','1','0.470','0.470','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-ZEBE-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZEBE-94-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-20260526-0001','1','E1E-ZEBE-100-0','1','0.600','0.600','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZEBE-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZEBE-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1E-ZEBE-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZEBE-100-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-26 07:44:44','TOKO','PM-E','E1E','E1E-ZEBE-100-0','1','0.600','0.600','1','0.600','0.600','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-ZEBE-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZEBE-100-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-20260526-0001','1','E1E-ZEBE-103-0','1','0.550','0.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZEBE-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZEBE-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-05-26 07:44:44' WHERE kode_barang='E1E-ZEBE-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZEBE-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-26 07:44:44','TOKO','PM-E','E1E','E1E-ZEBE-103-0','1','0.550','0.550','1','0.550','0.550','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-ZEBE-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZEBE-103-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:44','6.830','admpindah','2026-05-26 07:44:44');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','F1E-YGAI-101-0','1','10.080','10.080','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YGAI-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YGAI-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-05-26 07:45:08' WHERE kode_barang='F1E-YGAI-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YGAI-101-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-26 07:45:08','TOKO','PM-F','F1E','F1E-YGAI-101-0','1','10.080','10.080','1','10.080','10.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YGAI-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YGAI-101-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-20260526-0001','1','F3E-ZDAH-95-0','1','4.420','4.420','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZDAH-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZDAH-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-05-26 07:45:08' WHERE kode_barang='F3E-ZDAH-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZDAH-95-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-26 07:45:08','TOKO','PM-F','F3E','F3E-ZDAH-95-0','1','4.420','4.420','1','4.420','4.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZDAH-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZDAH-95-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-20260526-0001','1','F3E-ZEXI-134-0','1','4.970','4.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXI-134-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXI-134-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-05-26 07:45:08' WHERE kode_barang='F3E-ZEXI-134-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXI-134-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-26 07:45:08','TOKO','PM-F','F3E','F3E-ZEXI-134-0','1','4.970','4.970','1','4.970','4.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZEXI-134-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXI-134-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-20260526-0001','1','F3E-ZEBE-153-0','1','3.070','3.070','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEBE-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEBE-153-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-05-26 07:45:08' WHERE kode_barang='F3E-ZEBE-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEBE-153-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-26 07:45:08','TOKO','PM-F','F3E','F3E-ZEBE-153-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZEBE-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEBE-153-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:44','22.540','admpindah','2026-05-26 07:45:07');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','H1E-ZEBE-182-0','1','2.120','2.120','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBE-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H1E-ZEBE-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBE-182-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:45:39','TOKO','PM-H','H1E','H1E-ZEBE-182-0','1','2.120','2.120','1','2.120','2.120','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-ZEBE-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-182-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-20260526-0001','1','H1E-ZEBE-193-0','1','3.050','3.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBE-193-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-193-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H1E-ZEBE-193-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBE-193-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-26 07:45:39','TOKO','PM-H','H1E','H1E-ZEBE-193-0','1','3.050','3.050','1','3.050','3.050','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-ZEBE-193-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-193-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-20260526-0001','1','H1E-ZEBE-195-0','1','4.020','4.020','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBE-195-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-195-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H1E-ZEBE-195-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBE-195-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-26 07:45:39','TOKO','PM-H','H1E','H1E-ZEBE-195-0','1','4.020','4.020','1','4.020','4.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZEBE-195-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-195-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-20260526-0001','1','H2J-ZEBE-202-0','1','4.100','4.100','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZEBE-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZEBE-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H2J-ZEBE-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZEBE-202-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:45:39','TOKO','PM-H','H2J','H2J-ZEBE-202-0','1','4.100','4.100','1','4.100','4.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZEBE-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZEBE-202-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','H2J-ZEBE-206-0','1','1.270','1.270','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZEBE-206-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZEBE-206-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H2J-ZEBE-206-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZEBE-206-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-26 07:45:39','TOKO','PM-H','H2J','H2J-ZEBE-206-0','1','1.270','1.270','1','1.270','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZEBE-206-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZEBE-206-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260526-0001','1','H1E-ZEBE-218-0','1','3.030','3.030','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBE-218-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-218-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H1E-ZEBE-218-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBE-218-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-26 07:45:39','TOKO','PM-H','H1E','H1E-ZEBE-218-0','1','3.030','3.030','1','3.030','3.030','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-ZEBE-218-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-218-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-20260526-0001','1','H1E-ZEBE-219-0','1','4.060','4.060','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBE-219-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-219-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-05-26 07:45:39' WHERE kode_barang='H1E-ZEBE-219-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBE-219-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-26 07:45:39','TOKO','PM-H','H1E','H1E-ZEBE-219-0','1','4.060','4.060','1','4.060','4.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZEBE-219-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBE-219-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260526-0001','2026-05-26','07:45','21.650','admpindah','2026-05-26 07:45:38');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326260837531','input','1',' MEE1 LG 14','TOKO','PM-E','E1E-ZEAE-235-0','CC MODEL DAUN VAR LG 14 8K ','','0.530','1','100.00','588000','0','0','15000','588000','0','0','0','588000','AAT','00403713','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-235-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E1E-ZEAE-235-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 ('F326260837531','2026-05-26','0.530','2026-05-26','08:37:54','PLG0029391','588000','588000','0','588000','588000','input','2026-05-26 08:37:53','F32626083753');
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-26','F326260837531','2026-05-26','08:37:54','AAT','588000','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-260526-0002','D','2026-05-26','08:37:54','input','PENJUALAN','F326260837531','5215457000','588000','5216045000');
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 ('F326260838281','input','1',' MEE1 5K UB','TOKO','PM-E','E1E-ZBAG-81-0','CC OSROT BONEKA CAT VAR UB 8K ','','0.700','1','100.00','777000','0','0','15000','777000','0','5000','0','782000','AAT','00390373','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAG-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E1E-ZBAG-81-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 ('F326260838281','2026-05-26','0.700','2026-05-26','08:38:29','PLG0029392','777000','777000','5000','782000','782000','input','2026-05-26 08:38:28','F32626083828');
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-26','F326260838281','2026-05-26','08:38:29','AAT','782000','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-260526-0003','D','2026-05-26','08:38:29','input','PENJUALAN','F326260838281','5216045000','782000','5216827000');
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 ('F326260858551','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZDBG-325-0','CC X SOLITAIRE MATA CM 12 8K ','','1.300','1','100.00','1417000','0','0','15000','1417000','0','10000','0','1427000','LIS','00401568','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBG-325-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E2D-ZDBG-325-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 ('F326260858551','2026-05-26','1.300','2026-05-26','08:58:56','PLG0029393','1417000','1417000','10000','1427000','1427000','input','2026-05-26 08:58:55','F32626085855');
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-26','F326260858551','2026-05-26','08:58:56','LIS','1427000','10000');
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-260526-0004','D','2026-05-26','08:58:56','input','PENJUALAN','F326260858551','5216827000','1427000','5218254000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1427000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260858551' 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 ('F326260858552','input',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-ZDBG-192-0','CC X SOLITAIRE MATA CM 10 8K ','','0.800','1','100.00','888000','0','0','15000','888000','0','10000','0','898000','LIS','00401435','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBG-192-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E2E-ZDBG-192-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 ('F326260858552','2026-05-26','0.800','2026-05-26','08:58:56','PLG0029394','888000','888000','10000','898000','898000','input','2026-05-26 08:58:55','F32626085855');
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-26','F326260858552','2026-05-26','08:58:56','LIS','898000','10000');
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-260526-0005','D','2026-05-26','08:58:56','input','PENJUALAN','F326260858552','5218254000','898000','5219152000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='898000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260858552' LIMIT 1;
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-00019223','X-00019223','CC X MODEL MATA UB 12','GR','---','E2E','BELI','BELI001','830000','2026-05-26','1.180','1','kasir','2026-05-26 09:16:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019223','X-00019223');
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-260526-0001','F325020211471','LIS','1','BELI','BELI001','E2E', 'X-00019223', 'CC X MODEL MATA UB 12','1.180','1.180','100.00','785000','830000','703390','1120000','1','830000','830000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.180',berat_beli_asli=berat_beli_asli+'1.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.180',berat_akhir_asli=berat_akhir_asli+'1.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260526-0001','2026-05-26','2026-05-26','09:16:49','LIS','---','1.180','830000','830000','830000','830000','830000','kasir','2026-05-26 09:16:49','FB-260526-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0001','TENDY','NAWANGAN','','','','kasir','2026-05-26 09:16:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0006','K','2026-05-26','09:16:49','kasir','PEMBELIAN UMUM','FB-260526-0001','5219152000','830000','5218322000');
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 ('F326260935191','kasir','1',' MEF1 YT 65','TOKO','PM-F','F1E-YLXI-4-T','GL OVAL MODEL C 65 YT 8K','','3.740','1','100.00','4151000','0','0','15000','4152000','0','0','0','4152000','FIT','T0075575','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLXI-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.740',berat_jual_asli=berat_jual_asli+'3.740',stock_jual='1',berat_akhir=berat_akhir-'3.740',berat_akhir_asli=berat_akhir_asli-'3.740',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='F1E-YLXI-4-T' 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 ('F326260935191','2026-05-26','3.740','2026-05-26','09:35:20','PLG0029395','4152000','4152000','0','4152000','4152000','kasir','2026-05-26 09:35:19','F32626093519');
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-26','F326260935191','2026-05-26','09:35:20','FIT','4152000','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-260526-0007','D','2026-05-26','09:35:20','kasir','PENJUALAN','F326260935191','5218322000','4152000','5222474000');
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 ('F326260959291','kasir','1',' MEB1 CM PE','TOKO','PM-B','B1E-ZCAH-388-0','GW TUSUK HATI MATA CM PE 8K ','','0.720','1','100.00','799000','0','0','15000','800000','0','0','0','800000','AAT','00395343','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCAH-388-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='B1E-ZCAH-388-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 ('F326260959291','2026-05-26','0.720','2026-05-26','09:59:30','PLG0029396','800000','800000','0','800000','800000','kasir','2026-05-26 09:59:29','F32626095929');
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-26','F326260959291','2026-05-26','09:59:30','AAT','800000','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-260526-0008','D','2026-05-26','09:59:30','kasir','PENJUALAN','F326260959291','5222474000','800000','5223274000');
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 ('F326261009081','kasir','1',' TEE2 X KH ','TOKO','PT-E','E2TE-VEBC-88-T','CC X MODEL MATA KH 15 ','','1.850','1','100.00','3737000','0','0','15000','3737000','0','0','0','3737000','FIT','T0034362','E2TE','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-VEBC-88-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E2TE-VEBC-88-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 ('F326261009081','2026-05-26','1.850','2026-05-26','10:09:08','PLG0029397','3737000','3737000','0','3737000','3737000','kasir','2026-05-26 10:09:08','F32626100908');
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-26','F326261009081','2026-05-26','10:09:08','FIT','3737000','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-260526-0009','D','2026-05-26','10:09:08','kasir','PENJUALAN','F326261009081','5223274000','3737000','5227011000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3737000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261009081' 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 ('F326261009082','kasir',' 1',' TEF3 X UB ','TOKO','PT-F','F3TE-YIXE-17-T','GL X FANCY BOLA MATA VAR UB 17K ','','4.930','1','100.00','9959000','0','0','15000','9960000','0','0','0','9960000','FIT','T0072987','F3TE','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YIXE-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.930',berat_jual_asli=berat_jual_asli+'4.930',stock_jual='1',berat_akhir=berat_akhir-'4.930',berat_akhir_asli=berat_akhir_asli-'4.930',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='F3TE-YIXE-17-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 ('F326261009082','2026-05-26','4.930','2026-05-26','10:09:08','PLG0029398','9960000','9960000','0','9960000','9960000','kasir','2026-05-26 10:09:08','F32626100908');
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-26','F326261009082','2026-05-26','10:09:08','FIT','9960000','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-260526-0010','D','2026-05-26','10:09:08','kasir','PENJUALAN','F326261009082','5227011000','9960000','5236971000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='9960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261009082' 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 ('F326261009083','kasir',' 1',' TEA1 X HT ','TOKO','PT-A','A1TE-WFBX-2-T','AT X HUGGIES MODEL MATA HT ','','1.760','1','100.00','3555000','0','0','15000','3555000','0','0','0','3555000','FIT','T0045348','A1TE','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-WFBX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='A1TE-WFBX-2-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 ('F326261009083','2026-05-26','1.760','2026-05-26','10:09:08','PLG0029399','3555000','3555000','0','3555000','3555000','kasir','2026-05-26 10:09:08','F32626100908');
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-26','F326261009083','2026-05-26','10:09:08','FIT','3555000','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-260526-0011','D','2026-05-26','10:09:08','kasir','PENJUALAN','F326261009083','5236971000','3555000','5240526000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261009083' 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 ('F326261009084','kasir',' 1',' MEF3E X HW','TOKO','PM-F','F3E-YLAG-58-0','GL X CASTELI ARESO VAR HW 8K ','','1.850','1','100.00','2053000','0','0','15000','2053000','0','0','0','2053000','FIT','00381412','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='F3E-YLAG-58-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 ('F326261009084','2026-05-26','1.850','2026-05-26','10:09:08','PLG0029400','2053000','2053000','0','2053000','2053000','kasir','2026-05-26 10:09:08','F32626100908');
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-26','F326261009084','2026-05-26','10:09:08','FIT','2053000','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-260526-0012','D','2026-05-26','10:09:08','kasir','PENJUALAN','F326261009084','5240526000','2053000','5242579000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2053000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261009084' 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 ('F326261018091','kasir','1',' MED1 HW ','TOKO','PM-D','D1E-ZDXD-266-0','LT COR MODEL SLEP HW 8K ','','0.500','1','100.00','555000','0','0','15000','555000','0','0','0','555000','LIS','00397966','D1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDXD-266-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='D1E-ZDXD-266-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 ('F326261018091','2026-05-26','0.500','2026-05-26','10:18:10','PLG0029401','555000','555000','0','555000','555000','kasir','2026-05-26 10:18:09','F32626101809');
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-26','F326261018091','2026-05-26','10:18:10','LIS','555000','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-260526-0013','D','2026-05-26','10:18:10','kasir','PENJUALAN','F326261018091','5242579000','555000','5243134000');
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 ('F326261035131','kasir','1',' MEH1 UB 34','TOKO','PM-H','H1E-ZDXH-116-0','KL GUCI ANAK 34 CM UB 8K ','','1.060','1','100.00','1177000','0','0','15000','1177000','0','0','0','1177000','SIN','00398568','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXH-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='H1E-ZDXH-116-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 ('F326261035131','2026-05-26','1.060','2026-05-26','10:35:14','PLG0029402','1177000','1177000','0','1177000','1177000','kasir','2026-05-26 10:35:13','F32626103513');
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-26','F326261035131','2026-05-26','10:35:14','SIN','1177000','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-260526-0014','D','2026-05-26','10:35:14','kasir','PENJUALAN','F326261035131','5243134000','1177000','5244311000');
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 ('F326261039151','kasir','1',' MEE1 LG 12','TOKO','PM-E','E1E-ZEAE-234-0','CC MODEL DAUN VAR LG 12 8K ','','0.430','1','100.00','477000','0','0','15000','478000','0','0','0','478000','LIS','00403712','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-234-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E1E-ZEAE-234-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 ('F326261039151','2026-05-26','0.430','2026-05-26','10:39:16','PLG0029403','478000','478000','0','478000','478000','kasir','2026-05-26 10:39:15','F32626103915');
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-26','F326261039151','2026-05-26','10:39:16','LIS','478000','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-260526-0015','D','2026-05-26','10:39:16','kasir','PENJUALAN','F326261039151','5244311000','478000','5244789000');
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 ('F326261054061','kasir','1',' MEA1 LG ','TOKO','PM-A','A1E-ZEBE-214-0','AT COR MODEL MATA DAISY LG 8K ','','0.500','1','100.00','560000','0','0','15000','550000','0','0','0','550000','SIN','00404913','A1E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEBE-214-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='A1E-ZEBE-214-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 ('F326261054061','2026-05-26','0.500','2026-05-26','10:54:07','PLG0029404','550000','550000','0','550000','550000','kasir','2026-05-26 10:54:06','F32626105406');
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-26','F326261054061','2026-05-26','10:54:07','SIN','550000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260526-0016','D','2026-05-26','10:54:07','kasir','PENJUALAN','F326261054061','5244789000','550000','5245339000');
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 ('F326261057161','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZEBE-193-0','KL X GUCCI UB 42 8K ','','3.050','1','100.00','3416000','0','0','15000','3385000','0','0','0','3385000','LIS','00404892','H1E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='H1E-ZEBE-193-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 ('F326261057161','2026-05-26','3.050','2026-05-26','10:57:17','PLG0029405','3385000','3385000','0','3385000','3385000','kasir','2026-05-26 10:57:16','F32626105716');
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-26','F326261057161','2026-05-26','10:57:17','LIS','3385000','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-260526-0017','D','2026-05-26','10:57:17','kasir','PENJUALAN','F326261057161','5245339000','3385000','5248724000');
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 ('F326261103161','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDBG-257-0','CC X MODEL SLEP CM 18 8K ','','1.450','1','100.00','1580000','0','0','15000','1580000','0','0','0','1580000','SIN','00401500','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBG-257-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E1D-ZDBG-257-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 ('F326261103161','2026-05-26','1.450','2026-05-26','11:03:16','PLG0029406','1580000','1580000','0','1580000','1580000','kasir','2026-05-26 11:03:16','F32626110316');
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-26','F326261103161','2026-05-26','11:03:16','SIN','1580000','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-260526-0018','D','2026-05-26','11:03:16','kasir','PENJUALAN','F326261103161','5248724000','1580000','5250304000');
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-00019224','X-00019224','CC X WEDDING POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','1052000','2026-05-26','1.030','1','kasir','2026-05-26 11:13:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019224','X-00019224');
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-260526-0002','F326240929352','AAT','1','BELI','BELI001','E1D', 'X-00019224', 'CC X WEDDING POLOS CM 14 8K','1.030','1.030','100.00','1165000','1052000','1021359','1100000','1','1052000','1052000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' 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-260526-0002','2026-05-26','2026-05-26','11:13:17','AAT','---','1.030','1052000','1052000','1052000','1052000','1052000','kasir','2026-05-26 11:13:17','FB-260526-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0002','SANDI','PUGELAN CANGKUL','','','085217242324','kasir','2026-05-26 11:13:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0019','K','2026-05-26','11:13:17','kasir','PEMBELIAN UMUM','FB-260526-0002','5250304000','1052000','5249252000');
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-00019225','X-00019225','CC X MODEL LISTRING GELOMBANG MT HW 13 8K','GR','---','E2E','BELI','BELI001','675000','2026-05-26','0.710','1','kasir','2026-05-26 11:15:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019225','X-00019225');
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-260526-0003','F325281012471','LIS','1','BELI','BELI001','E2E', 'X-00019225', 'CC X MODEL LISTRING GELOMBANG MT HW 13 8K','0.710','0.710','100.00','725000','675000','950704','1120000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.710',berat_beli_asli=berat_beli_asli+'0.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.710',berat_akhir_asli=berat_akhir_asli+'0.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260526-0003','2026-05-26','2026-05-26','11:15:22','LIS','---','0.710','675000','675000','675000','675000','675000','kasir','2026-05-26 11:15:23','FB-260526-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0003','KINAN','TENGGAR','','','082237990389','kasir','2026-05-26 11:15:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0020','K','2026-05-26','11:15:22','kasir','PEMBELIAN UMUM','FB-260526-0003','5249252000','675000','5248577000');
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-00019226','X-00019226','GW TIXIE PANJANG MATA VAR LG 8K','GR','---','B1E','BELI','BELI001','522000','2026-05-26','0.560','1','kasir','2026-05-26 11:15:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019226','X-00019226');
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-260526-0004','F325281001171','LIS','1','BELI','BELI001','B1E', 'X-00019226', 'GW TIXIE PANJANG MATA VAR LG 8K','0.560','0.560','100.00','568000','522000','932143','1120000','1','522000','522000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260526-0004','2026-05-26','2026-05-26','11:15:53','LIS','---','0.560','522000','522000','522000','522000','522000','kasir','2026-05-26 11:15:53','FB-260526-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0004','RISKA','TENGGAR','','','082237990389','kasir','2026-05-26 11:15:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0021','K','2026-05-26','11:15:53','kasir','PEMBELIAN UMUM','FB-260526-0004','5248577000','522000','5248055000');
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-00019227','X-00019227','GL OVAL MODEL C UB D56 17K','GR','---','F1TE','BELI','BELI001','3097000','2026-05-26','1.970','1','kasir','2026-05-26 11:17:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00019227','X-00019227');
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-260526-0005','F325240834231','SIN','1','BELI','BELI001','F1TE', 'X-00019227', 'GL OVAL MODEL C UB D56 17K','1.970','1.970','100.00','2660000','3097000','1572081','2020000','1','3097000','3097000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' 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-260526-0005','2026-05-26','2026-05-26','11:17:32','SIN','---','1.970','3097000','3097000','3097000','3097000','3097000','kasir','2026-05-26 11:17:33','FB-260526-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0005','NURMA','BITING PURWANTORO','','','','kasir','2026-05-26 11:17:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0022','K','2026-05-26','11:17:32','kasir','PEMBELIAN UMUM','FB-260526-0005','5248055000','3097000','5244958000');
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-00019228','X-00019228','CC X MODEL MATA CM 10 8K','GR','---','E2E','BELI','BELI001','560000','2026-05-26','0.600','1','kasir','2026-05-26 11:18:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019228','X-00019228');
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-260526-0006','F325041032192','SIN','1','BELI','BELI001','E2E', 'X-00019228', 'CC X MODEL MATA CM 10 8K','0.600','0.600','100.00','595000','560000','933333','1120000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260526-0006','2026-05-26','2026-05-26','11:18:13','SIN','---','0.600','560000','560000','560000','560000','560000','kasir','2026-05-26 11:18:13','FB-260526-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0006','CICI','BITING BADEGAN','','','','kasir','2026-05-26 11:18:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0023','K','2026-05-26','11:18:13','kasir','PEMBELIAN UMUM','FB-260526-0006','5244958000','560000','5244398000');
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-00019229','X-00019229','CC MODEL DAUN VAR LG 9 8K','GR','---','E1E','BELI','BELI001','390000','2026-05-26','0.420','1','kasir','2026-05-26 11:18:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019229','X-00019229');
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-260526-0007','F325200249321','SIN','1','BELI','BELI001','E1E', 'X-00019229', 'CC MODEL DAUN VAR LG 9 8K','0.420','0.420','100.00','425000','390000','928571','1120000','1','390000','390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260526-0007','2026-05-26','2026-05-26','11:18:39','SIN','---','0.420','390000','390000','390000','390000','390000','kasir','2026-05-26 11:18:39','FB-260526-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0007','CICI','BITING','','','089676968062','kasir','2026-05-26 11:18:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0024','K','2026-05-26','11:18:39','kasir','PEMBELIAN UMUM','FB-260526-0007','5244398000','390000','5244008000');
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-00019230','X-00019230','CC MODEL DAUN LG 16 8K','GR','---','E1E','BELI','BELI001','485000','2026-05-26','0.470','1','kasir','2026-05-26 11:18:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019230','X-00019230');
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-260526-0008','F326250146081','AAT','1','BELI','BELI001','E1E', 'X-00019230', 'CC MODEL DAUN LG 16 8K','0.470','0.470','100.00','578000','485000','1031915','1120000','1','485000','485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260526-0008','2026-05-26','2026-05-26','11:18:57','AAT','---','0.470','485000','485000','485000','485000','485000','kasir','2026-05-26 11:18:58','FB-260526-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0008','JARSEH','GELURAN SUKOMANGU','','','082135942303','kasir','2026-05-26 11:18:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0025','K','2026-05-26','11:18:57','kasir','PEMBELIAN UMUM','FB-260526-0008','5244008000','485000','5243523000');
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-00019231','X-00019231','GW DAISY MATA LG PE','GR','---','B1F','BELI','BELI001','285000','2026-05-26','0.520','1','kasir','2026-05-26 11:19:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00019231','X-00019231');
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-260526-0009','F322150952593','SIN','1','BELI','BELI001','B1F', 'X-00019231', 'GW DAISY MATA LG PE','0.520','0.520','100.00','235000','285000','548077','1140000','1','285000','285000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-260526-0009','2026-05-26','2026-05-26','11:19:41','SIN','---','0.520','285000','285000','285000','285000','285000','kasir','2026-05-26 11:19:41','FB-260526-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0009','ENIS','BITING','','','','kasir','2026-05-26 11:19:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0026','K','2026-05-26','11:19:41','kasir','PEMBELIAN UMUM','FB-260526-0009','5243523000','285000','5243238000');
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 ('F326261132351','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-ZCAI-766-0','GL LONG LING UB 8K ','','0.970','1','100.00','1077000','0','0','15000','1077000','0','0','0','1077000','SIN','00396168','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-766-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='F3E-ZCAI-766-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 ('F326261132351','2026-05-26','0.970','2026-05-26','11:32:35','PLG0029407','1077000','1077000','0','1077000','1077000','kasir','2026-05-26 11:32:35','F32626113235');
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-26','F326261132351','2026-05-26','11:32:35','SIN','1077000','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-260526-0027','D','2026-05-26','11:32:35','kasir','PENJUALAN','F326261132351','5243238000','1077000','5244315000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1077000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261132351' 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 ('F326261132352','kasir',' 1',' MEF3E UB ','TOKO','PM-F','F3E-ZDAE-221-0','GL GUCCI UB 8K ','','0.580','1','100.00','644000','0','0','15000','644000','0','0','0','644000','SIN','00399507','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAE-221-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='F3E-ZDAE-221-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 ('F326261132352','2026-05-26','0.580','2026-05-26','11:32:35','PLG0029408','644000','644000','0','644000','644000','kasir','2026-05-26 11:32:35','F32626113235');
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-26','F326261132352','2026-05-26','11:32:35','SIN','644000','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-260526-0028','D','2026-05-26','11:32:35','kasir','PENJUALAN','F326261132352','5244315000','644000','5244959000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='644000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261132352' 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 ('F326260100151','kasir','1',' MGE1 X AY ','TOKO','PM-E','E1G-ZCCX-564-0','CC X MODEL MATA AY 12 8K ','','0.330','1','100.00','379000','0','0','15000','380000','0','0','0','380000','AAT','00397218','E1G','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCCX-564-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E1G-ZCCX-564-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 ('F326260100151','2026-05-26','0.330','2026-05-26','13:00:16','PLG0029409','380000','380000','0','380000','380000','kasir','2026-05-26 13:00:15','F32626010015');
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-26','F326260100151','2026-05-26','13:00:16','AAT','380000','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-260526-0029','D','2026-05-26','13:00:16','kasir','PENJUALAN','F326260100151','5244959000','380000','5245339000');
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-00019232','X-00019232','KL X NORI ANAK KH 34 8K','GR','---','H1E','BELI','BELI001','2070000','2026-05-26','2.100','1','kasir','2026-05-26 13:25:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019232','X-00019232');
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-260526-0010','F326121229592','SIN','1','BELI','BELI001','H1E', 'X-00019232', 'KL X NORI ANAK KH 34 8K','2.100','2.100','100.00','2500000','2070000','985714','1120000','1','2070000','2070000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' 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-260526-0010','2026-05-26','2026-05-26','13:25:04','SIN','---','2.100','2070000','2070000','2070000','2070000','2070000','kasir','2026-05-26 13:25:04','FB-260526-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0010','NADIN','WATUSONO SLOGOHIMO','','','082133506496','kasir','2026-05-26 13:25:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0030','K','2026-05-26','13:25:04','kasir','PEMBELIAN UMUM','FB-260526-0010','5245339000','2070000','5243269000');
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-00019233','X-00019233','AT COR MODEL ITALY HW 8K','GR','---','A1E','BELI','BELI001','617000','2026-05-26','0.600','1','kasir','2026-05-26 13:52:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019233','X-00019233');
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-260526-0011','F326310251251','LIS','1','BELI','BELI001','A1E', 'X-00019233', 'AT COR MODEL ITALY HW 8K','0.600','0.600','100.00','685000','617000','1028333','1120000','1','617000','617000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260526-0011','2026-05-26','2026-05-26','13:52:03','LIS','---','0.600','617000','617000','617000','617000','617000','kasir','2026-05-26 13:52:03','FB-260526-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0011','RIKA','GAMBIRANOM KISMANTORO','','','','kasir','2026-05-26 13:52:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0031','K','2026-05-26','13:52:03','kasir','PEMBELIAN UMUM','FB-260526-0011','5243269000','617000','5242652000');
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 ('F326260216361','kasir','1',' TEE2 X MJ ','TOKO','PT-E','E2TE-VJAX-71-T','CC X MODEL MATA MJ 14 ','','1.750','1','100.00','3535000','0','0','15000','3535000','0','0','0','3535000','AAT','T0038788','E2TE','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-VJAX-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E2TE-VJAX-71-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 ('F326260216361','2026-05-26','1.750','2026-05-26','14:16:36','PLG0029410','3535000','3535000','0','3535000','3535000','kasir','2026-05-26 14:16:36','F32626021636');
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-26','F326260216361','2026-05-26','14:16:36','AAT','3535000','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-260526-0032','D','2026-05-26','14:16:36','kasir','PENJUALAN','F326260216361','5242652000','3535000','5246187000');
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 ('F326260237131','kasir','1',' MEE2 X HT ','TOKO','PM-E','E2E-ZCAD-151-0','CC X PIPA MATA HT 14 8K ','','0.530','1','100.00','588000','0','0','15000','588000','0','0','0','588000','FIT','00394279','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAD-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-26' AND kode_barang='E2E-ZCAD-151-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 ('F326260237131','2026-05-26','0.530','2026-05-26','14:37:14','PLG0029411','588000','588000','0','588000','588000','kasir','2026-05-26 14:37:13','F32626023713');
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-26','F326260237131','2026-05-26','14:37:14','FIT','588000','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-260526-0033','D','2026-05-26','14:37:14','kasir','PENJUALAN','F326260237131','5246187000','588000','5246775000');
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-00019234','X-00019234','CC VELG POLOS OR 18 17K','GR','---','E1TE','BELI','BELI001','1595000','2026-05-26','1.000','1','kasir','2026-05-26 14:57:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00019234','X-00019234');
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-260526-0012','F325031037011','FIT','1','BELI','BELI001','E1TE', 'X-00019234', 'CC VELG POLOS OR 18 17K','1.020','1.000','100.00','1445000','1595000','1595000','2020000','1','1595000','1595000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-260526-0012','2026-05-26','2026-05-26','14:57:38','FIT','---','1.000','1595000','1595000','1595000','1595000','1595000','kasir','2026-05-26 14:57:38','FB-260526-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260526-0012','BU KATNI','GELANG','','','','kasir','2026-05-26 14:57:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-26' 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-260526-0034','K','2026-05-26','14:57:38','kasir','PEMBELIAN UMUM','FB-260526-0012','5246775000','1595000','5245180000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260526-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260526-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260100151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260100151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260100151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260216361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260216361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260216361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260237131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260237131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260237131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260837531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260837531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260837531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260838281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260838281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260838281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260858551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260858552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260935191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260935191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260935191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260959291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260959291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260959291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261009081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261009082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009083' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009083' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261009083';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009084' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261009084' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261009084';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261018091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261018091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261018091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261035131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261035131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261035131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261039151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261054061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261054061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261054061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261057161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261057161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261057161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261103161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261103161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261103161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261132351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261132352';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-26';
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-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-26';
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-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-26' 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-260527-0001','D','2026-05-27','15:13:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','5245180000','5245180000');
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-260527-0001','D','2026-05-27','15:13:56','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-260527-0001','D','2026-05-27','15:13:56','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-260527-0001','D','2026-05-27','15:13:56','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-05-27';