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-20260910-0001','1','A1D-ZIXI-124-0','1','1.010','1.010','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXI-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:12' WHERE kode_barang='A1D-ZIXI-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXI-124-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-10 07:56:12','TOKO','SMBK-A','A1D','A1D-ZIXI-124-0','1','1.010','1.010','1','1.010','1.010','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-ZIXI-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-124-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260910-0001','1','A1D-ZIXI-127-0','1','1.080','1.080','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXI-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:13' WHERE kode_barang='A1D-ZIXI-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXI-127-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-10 07:56:13','TOKO','SMBK-A','A1D','A1D-ZIXI-127-0','1','1.080','1.080','1','1.080','1.080','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-ZIXI-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-127-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260910-0001','1','A1D-ZIXI-138-0','1','0.890','0.890','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXI-138-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-138-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:13' WHERE kode_barang='A1D-ZIXI-138-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXI-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-09-10 07:56:13','TOKO','SMBK-A','A1D','A1D-ZIXI-138-0','1','0.890','0.890','1','0.890','0.890','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-ZIXI-138-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXI-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-20260910-0001','1','A1E-ZIXI-140-0','1','0.740','0.740','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXI-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-140-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:13' WHERE kode_barang='A1E-ZIXI-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXI-140-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-09-10 07:56:13','TOKO','SMBK-A','A1E','A1E-ZIXI-140-0','1','0.740','0.740','1','0.740','0.740','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-ZIXI-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-140-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-20260910-0001','1','A1E-ZIXI-141-0','1','0.760','0.760','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXI-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:13' WHERE kode_barang='A1E-ZIXI-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXI-141-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-09-10 07:56:13','TOKO','SMBK-A','A1E','A1E-ZIXI-141-0','1','0.760','0.760','1','0.760','0.760','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-ZIXI-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-141-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-20260910-0001','1','A1E-ZIXI-142-0','1','0.500','0.500','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXI-142-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-142-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 07:56:13' WHERE kode_barang='A1E-ZIXI-142-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXI-142-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-09-10 07:56:13','TOKO','SMBK-A','A1E','A1E-ZIXI-142-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-ZIXI-142-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXI-142-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','07:56','4.980','input','2026-09-10 07:56:12');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260910-0001','1','B1D-ZIXI-146-0','1','0.860','0.860','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZIXI-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZIXI-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-10 07:56:36' WHERE kode_barang='B1D-ZIXI-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZIXI-146-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-09-10 07:56:36','TOKO','SMBK-B','B1D','B1D-ZIXI-146-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-ZIXI-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZIXI-146-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-20260910-0001','1','B1E-ZIXI-147-0','1','0.600','0.600','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIXI-147-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIXI-147-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-10 07:56:36' WHERE kode_barang='B1E-ZIXI-147-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIXI-147-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-09-10 07:56:36','TOKO','SMBK-B','B1E','B1E-ZIXI-147-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZIXI-147-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIXI-147-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-20260910-0001','1','B1G-ZIXI-154-0','1','0.300','0.300','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZIXI-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZIXI-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-10 07:56:36' WHERE kode_barang='B1G-ZIXI-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZIXI-154-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-09-10 07:56:36','TOKO','SMBK-B','B1G','B1G-ZIXI-154-0','1','0.300','0.300','1','0.300','0.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZIXI-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZIXI-154-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-20260910-0001','1','B1G-ZIXI-155-0','1','0.300','0.300','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZIXI-155-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZIXI-155-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-10 07:56:36' WHERE kode_barang='B1G-ZIXI-155-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZIXI-155-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-09-10 07:56:36','TOKO','SMBK-B','B1G','B1G-ZIXI-155-0','1','0.300','0.300','1','0.300','0.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZIXI-155-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZIXI-155-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','07:56','2.060','input','2026-09-10 07:56:36');
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-20260910-0001','1','D2D-ZIXI-160-0','1','1.060','1.060','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-ZIXI-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-ZIXI-160-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-10 07:56:54' WHERE kode_barang='D2D-ZIXI-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-ZIXI-160-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-09-10 07:56:54','TOKO','SMBK-D','D2D','D2D-ZIXI-160-0','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-ZIXI-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-ZIXI-160-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-20260910-0001','1','D1F-ZIXI-174-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZIXI-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZIXI-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-10 07:56:54' WHERE kode_barang='D1F-ZIXI-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZIXI-174-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-09-10 07:56:54','TOKO','SMBK-D','D1F','D1F-ZIXI-174-0','1','0.320','0.320','1','0.320','0.320','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-ZIXI-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZIXI-174-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','07:56','1.380','input','2026-09-10 07:56:54');
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-20260910-0001','1','F2E-ZIXI-186-0','1','3.100','3.100','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZIXI-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZIXI-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-10 07:57:17' WHERE kode_barang='F2E-ZIXI-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZIXI-186-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-09-10 07:57:17','TOKO','SMBK-F','F2E','F2E-ZIXI-186-0','1','3.100','3.100','1','3.100','3.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZIXI-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZIXI-186-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-20260910-0001','1','F1E-ZIXI-187-0','1','3.970','3.970','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZIXI-187-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIXI-187-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-10 07:57:17' WHERE kode_barang='F1E-ZIXI-187-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIXI-187-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-09-10 07:57:17','TOKO','SMBK-F','F1E','F1E-ZIXI-187-0','1','3.970','3.970','1','3.970','3.970','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-ZIXI-187-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIXI-187-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-20260910-0001','1','F3E-ZIXI-259-0','1','3.610','3.610','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXI-259-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXI-259-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-10 07:57:17' WHERE kode_barang='F3E-ZIXI-259-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXI-259-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-09-10 07:57:17','TOKO','SMBK-F','F3E','F3E-ZIXI-259-0','1','3.610','3.610','1','3.610','3.610','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-ZIXI-259-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXI-259-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-20260910-0001','1','F3E-ZIXI-260-0','1','0.980','0.980','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXI-260-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXI-260-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-10 07:57:17' WHERE kode_barang='F3E-ZIXI-260-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXI-260-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-09-10 07:57:17','TOKO','SMBK-F','F3E','F3E-ZIXI-260-0','1','0.980','0.980','1','0.980','0.980','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-ZIXI-260-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXI-260-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','07:57','11.660','input','2026-09-10 07:57:17');
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-20260910-0001','1','H1E-ZIXI-207-0','1','2.250','2.250','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZIXI-207-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZIXI-207-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-09-10 07:57:39' WHERE kode_barang='H1E-ZIXI-207-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZIXI-207-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-10 07:57:39','TOKO','SMBK-H','H1E','H1E-ZIXI-207-0','1','2.250','2.250','1','2.250','2.250','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-ZIXI-207-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZIXI-207-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260910-0001','1','H1E-ZIXI-208-0','1','2.200','2.200','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZIXI-208-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZIXI-208-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-09-10 07:57:39' WHERE kode_barang='H1E-ZIXI-208-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZIXI-208-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-10 07:57:39','TOKO','SMBK-H','H1E','H1E-ZIXI-208-0','1','2.200','2.200','1','2.200','2.200','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-ZIXI-208-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZIXI-208-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','07:57','4.450','input','2026-09-10 07:57:38');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226100828171','kasir','1',' MEE2 KH 19','TOKO','SMBK-E','E2E-ZIXC-53-T','CC MODEL MATA VAR KH 19 8K ','OL','0.520','1','100.00','549000','0','0','15000','554000','0','5000','0','559000','TIN','T0082900','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIXC-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2E-ZIXC-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100828171','2026-09-10','0.520','2026-09-10','08:28:18','PLG0084738','554000','554000','5000','559000','559000','kasir','2026-09-10 08:28:17','F22610082817');
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-09-10','F226100828171','2026-09-10','08:28:18','TIN','559000','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-260910-0002','D','2026-09-10','08:28:18','kasir','PENJUALAN','F226100828171','14848952000','559000','14849511000');
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 ('F226100842201','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZGAA-28-T','CC MODEL SLEP CM 10 8K ','OL','0.560','1','100.00','591000','0','0','15000','596000','0','5000','0','601000','LUS','T0081039','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAA-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1E-ZGAA-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100842201','2026-09-10','0.560','2026-09-10','08:42:20','PLG0084739','596000','596000','5000','601000','601000','kasir','2026-09-10 08:42:20','F22610084220');
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-09-10','F226100842201','2026-09-10','08:42:20','LUS','601000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0003','D','2026-09-10','08:42:20','kasir','PENJUALAN','F226100842201','14849511000','601000','14850112000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='601000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100842201' 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 ('F226100842202','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZIXH-87-T','GL TRIXIE SERUT PENITI MATA VAR UB 8K ','OL','1.370','1','100.00','1445000','0','0','15000','1453000','0','7000','0','1460000','LUS','T0083234','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXH-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZIXH-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100842202','2026-09-10','1.370','2026-09-10','08:42:20','PLG0084740','1453000','1453000','7000','1460000','1460000','kasir','2026-09-10 08:42:20','F22610084220');
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-09-10','F226100842202','2026-09-10','08:42:20','LUS','1460000','7000');
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-260910-0004','D','2026-09-10','08:42:20','kasir','PENJUALAN','F226100842202','14850112000','1460000','14851572000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1460000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100842202' 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 ('F226100906351','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZIXI-32-T','GW TRIXIE PANJANG RABBIT MATA LG 8K ','OL','0.550','1','100.00','580000','0','0','15000','586000','0','5000','0','591000','TJ','T0083287','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIXI-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='B1E-ZIXI-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100906351','2026-09-10','0.550','2026-09-10','09:06:36','PLG0084741','586000','586000','5000','591000','591000','kasir','2026-09-10 09:06:35','F22610090635');
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-09-10','F226100906351','2026-09-10','09:06:36','TJ','591000','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-260910-0005','D','2026-09-10','09:06:36','kasir','PENJUALAN','F226100906351','14851572000','591000','14852163000');
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 ('F226100907101','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZIXH-74-T','LT MODEL DAUN VAR LG 8K ','OL','0.200','1','100.00','219000','0','0','15000','221000','0','5000','0','226000','TJ','T0083221','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZIXH-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D1G-ZIXH-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100907101','2026-09-10','0.200','2026-09-10','09:07:10','PLG0084742','221000','221000','5000','226000','226000','kasir','2026-09-10 09:07:10','F22610090710');
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-09-10','F226100907101','2026-09-10','09:07:10','TJ','226000','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-260910-0006','D','2026-09-10','09:07:10','kasir','PENJUALAN','F226100907101','14852163000','226000','14852389000');
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 ('F226100907511','kasir','1',' MFE2 KH 14','TOKO','SMBK-E','E2F-ZIXH-41-T','CC MODEL PAKU MATA VAR KH 14 8K ','OL','0.380','1','100.00','408000','0','0','15000','412000','0','5000','0','417000','TJ','T0083188','E2F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIXH-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2F-ZIXH-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100907511','2026-09-10','0.380','2026-09-10','09:07:52','PLG0084743','412000','412000','5000','417000','417000','kasir','2026-09-10 09:07:51','F22610090751');
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-09-10','F226100907511','2026-09-10','09:07:52','TJ','417000','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-260910-0007','D','2026-09-10','09:07:52','kasir','PENJUALAN','F226100907511','14852389000','417000','14852806000');
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 ('F226100941451','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZHBI-96-T','CC WEDDING MATA SLEP CM 16 8K ','OL','1.580','1','100.00','1635000','0','0','15000','1641000','0','10000','0','1651000','TIN','T0082785','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBI-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2D-ZHBI-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100941451','2026-09-10','1.580','2026-09-10','09:41:45','PLG0084744','1641000','1641000','10000','1651000','1651000','kasir','2026-09-10 09:41:45','F22610094145');
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-09-10','F226100941451','2026-09-10','09:41:45','TIN','1651000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260910-0008','D','2026-09-10','09:41:45','kasir','PENJUALAN','F226100941451','14852806000','1651000','14854457000');
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 ('F226100943001','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZEBG-200-0','AT X DAISY MATA LG 8K ','','1.000','1','100.00','1035000','0','0','15000','1035000','0','0','0','1035000','NOV','00405199','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-200-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1D-ZEBG-200-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100943001','2026-09-10','1.000','2026-09-10','09:43:00','PLG0084745','1035000','1035000','0','1035000','1035000','kasir','2026-09-10 09:43:00','F22610094300');
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-09-10','F226100943001','2026-09-10','09:43:00','NOV','1035000','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-260910-0009','D','2026-09-10','09:43:00','kasir','PENJUALAN','F226100943001','14854457000','1035000','14855492000');
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 ('F226100955171','kasir','1',' MEE1 5K LG','TOKO','SMBK-E','E1E-ZIXI-46-T','CC MODEL ANGGUR PASIR VAR LG 14 8K ','OL','0.680','1','100.00','717000','0','0','15000','724000','0','5000','0','729000','TIN','T0083301','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXI-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1E-ZIXI-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100955171','2026-09-10','0.680','2026-09-10','09:55:17','PLG0084746','724000','724000','5000','729000','729000','kasir','2026-09-10 09:55:17','F22610095517');
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-09-10','F226100955171','2026-09-10','09:55:17','TIN','729000','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-260910-0010','D','2026-09-10','09:55:17','kasir','PENJUALAN','F226100955171','14855492000','729000','14856221000');
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 ('F226101040141','kasir','1',' MDE2 CM 10','TOKO','SMBK-E','E2D-ZIXH-1-T','CC MODEL MATA VAR CM 10 8K ','','1.010','1','100.00','1045000','0','0','15000','1045000','0','0','0','1045000','NOV','T0083148','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXH-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2D-ZIXH-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101040141','2026-09-10','1.010','2026-09-10','10:40:14','PLG0084747','1045000','1045000','0','1045000','1045000','kasir','2026-09-10 10:40:14','F22610104014');
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-09-10','F226101040141','2026-09-10','10:40:14','NOV','1045000','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-260910-0011','D','2026-09-10','10:40:14','kasir','PENJUALAN','F226101040141','14856221000','1045000','14857266000');
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 ('F226101041491','kasir','1',' TEF3 X UB ','TOKO','TBK-F','F3TE-ZIXE-27-T','GL X SANTA SERUT MODEL INFINITY UB 17K ','OL','2.080','1','100.00','4077000','0','0','15000','4020000','0','15000','0','4035000','TIN','T0083045','F3TE','0','0','-','1','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZIXE-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3TE-ZIXE-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101041491','2026-09-10','2.080','2026-09-10','10:41:50','PLG0084748','4020000','4020000','15000','4035000','4035000','kasir','2026-09-10 10:41:49','F22610104149');
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-09-10','F226101041491','2026-09-10','10:41:50','TIN','4035000','15000');
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-260910-0012','D','2026-09-10','10:41:50','kasir','PENJUALAN','F226101041491','14857266000','4035000','14861301000');
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 ('F226101045191','kasir','1',' MEF3 MT ','TOKO','SMBK-F','F3E-ZIXG-45-T','GL KREPYAK SISIK NAGA VAR MT 8K ','','4.160','1','100.00','4389000','0','0','15000','4390000','0','0','0','4390000','TJ','T0083104','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXG-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZIXG-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101045191','2026-09-10','4.160','2026-09-10','10:45:19','PLG0084749','4390000','4390000','0','4390000','4390000','kasir','2026-09-10 10:45:19','F22610104519');
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-09-10','F226101045191','2026-09-10','10:45:19','TJ','4390000','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-260910-0013','D','2026-09-10','10:45:19','kasir','PENJUALAN','F226101045191','14861301000','4390000','14865691000');
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 ('F226101056421','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZIXH-11-T','CC WEDDING MATA CM 16 8K ','','1.520','1','100.00','1573000','0','0','15000','1573000','0','10000','0','1583000','LUS','T0083158','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXH-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2D-ZIXH-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101056421','2026-09-10','1.520','2026-09-10','10:56:42','PLG0084750','1573000','1573000','10000','1583000','1583000','kasir','2026-09-10 10:56:42','F22610105642');
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-09-10','F226101056421','2026-09-10','10:56:42','LUS','1583000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260910-0014','D','2026-09-10','10:56:42','kasir','PENJUALAN','F226101056421','14865691000','1583000','14867274000');
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 ('F226101109381','kasir','1',' MED1 HTM ','TOKO','SMBK-D','D1E-ZEAB-32-T','LT MODEL SLEP VAR HTM 8K ','','0.700','1','100.00','738000','0','0','15000','739000','0','0','0','739000','TIN','T0079390','D1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEAB-32-T' 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-09-10' AND kode_barang='D1E-ZEAB-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101109381','2026-09-10','0.700','2026-09-10','11:09:39','PLG0084751','739000','739000','0','739000','0','kasir','2026-09-10 11:09:38','F22610110938');
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-09-10','F226101109381','2026-09-10','11:09:39','TIN','739000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0001','2026-09-10','2026-09-10 11:09:38','PENJUALAN : F226101109381','6582467893769','BCA','739000','739000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0002','D','2026-09-10','11:09:39','BCA','PENJUALAN','F226101109381','4793896888','739000','4794635888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('6582467893769','LEON');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='739000' WHERE no_faktur_jual='F226101109381' 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 ('F226101110201','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZHXH-14-T','KL RANTAI HOLLOW UB 46 8K ','','1.020','1','100.00','1076000','0','0','15000','1076000','0','0','0','1076000','TIN','T0082133','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='H1E-ZHXH-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226101110201','2026-09-10','1.020','2026-09-10','11:10:21','PLG0084752','1076000','1076000','0','1076000','0','kasir','2026-09-10 11:10:20','F22610111020');
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-09-10','F226101110201','2026-09-10','11:10:21','TIN','1076000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0002','2026-09-10','2026-09-10 11:10:20','PENJUALAN : F226101110201','89639873983','BCA','1076000','1076000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0003','D','2026-09-10','11:10:21','BCA','PENJUALAN','F226101110201','4794635888','1076000','4795711888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89639873983','LEON');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1076000' WHERE no_faktur_jual='F226101110201' 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 ('F226101111191','kasir','1',' MEB1E CM ','TOKO','SMBK-B','B1E-ZFAI-106-T','GW TUSUK VAR SLEP CM 8K','','0.530','1','100.00','559000','0','0','15000','559000','0','0','0','559000','TIN','T0080606','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAI-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='B1E-ZFAI-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101111191','2026-09-10','0.530','2026-09-10','11:11:20','PLG0084753','559000','559000','0','559000','0','kasir','2026-09-10 11:11:19','F22610111119');
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-09-10','F226101111191','2026-09-10','11:11:20','TIN','559000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0003','2026-09-10','2026-09-10 11:11:19','PENJUALAN : F226101111191','344567288973','BCA','559000','559000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0004','D','2026-09-10','11:11:20','BCA','PENJUALAN','F226101111191','4795711888','559000','4796270888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('344567288973','LEONA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='559000' WHERE no_faktur_jual='F226101111191' 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 ('F226101112091','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZHBI-37-T','GW MODEL SLEP CM PE 8K ','','0.570','1','100.00','601000','0','0','15000','601000','0','0','0','601000','TIN','T0082726','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHBI-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='B1E-ZHBI-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101112091','2026-09-10','0.570','2026-09-10','11:12:10','PLG0084754','601000','601000','0','601000','0','kasir','2026-09-10 11:12:09','F22610111209');
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-09-10','F226101112091','2026-09-10','11:12:10','TIN','601000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0004','2026-09-10','2026-09-10 11:12:09','PENJUALAN : F226101112091','325362728837','BCA','601000','601000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0005','D','2026-09-10','11:12:10','BCA','PENJUALAN','F226101112091','4796270888','601000','4796871888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('325362728837','LEONA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='601000' WHERE no_faktur_jual='F226101112091' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101112091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101112091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101112091';
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 ('F226101116411','kasir','1',' MEE1 X HT ','TOKO','SMBK-E','E1E-ZHBF-289-0','CC X MODEL SLEP HT 16 8K','','0.560','1','100.00','591000','0','0','15000','591000','0','0','0','591000','TIN','00420661','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBF-289-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1E-ZHBF-289-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101116411','2026-09-10','0.560','2026-09-10','11:16:41','PLG0084755','591000','591000','0','591000','0','kasir','2026-09-10 11:16:41','F22610111641');
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-09-10','F226101116411','2026-09-10','11:16:41','TIN','591000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0005','2026-09-10','2026-09-10 11:16:41','PENJUALAN : F226101116411','42526272727172','BCA','591000','591000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0006','D','2026-09-10','11:16:41','BCA','PENJUALAN','F226101116411','4796871888','591000','4797462888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('42526272727172','LEONA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='591000' WHERE no_faktur_jual='F226101116411' 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 ('F226101122411','kasir','1',' MFE1 KH 16','TOKO','SMBK-E','E1F-ZIXH-32-T','CC MODEL BUNGA CLOVER SLEP KH 16 8K ','','0.350','1','100.00','376000','0','0','15000','376000','0','0','0','376000','DIN','T0083179','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXH-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1F-ZIXH-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101122411','2026-09-10','0.350','2026-09-10','11:22:41','PLG0084756','376000','376000','0','376000','376000','kasir','2026-09-10 11:22:41','F22610112241');
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-09-10','F226101122411','2026-09-10','11:22:41','DIN','376000','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-260910-0015','D','2026-09-10','11:22:41','kasir','PENJUALAN','F226101122411','14867274000','376000','14867650000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='376000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101122411' 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 ('F226101122412','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZHXE-35-T','CC MODEL HATI SLEP LG 16 8K ','','0.500','1','100.00','527000','0','0','15000','528000','0','0','0','528000','DIN','T0081948','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1E-ZHXE-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101122412','2026-09-10','0.500','2026-09-10','11:22:41','PLG0084757','528000','528000','0','528000','528000','kasir','2026-09-10 11:22:41','F22610112241');
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-09-10','F226101122412','2026-09-10','11:22:41','DIN','528000','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-260910-0016','D','2026-09-10','11:22:41','kasir','PENJUALAN','F226101122412','14867650000','528000','14868178000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='528000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101122412' 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 ('F226101151181','kasir','1',' TEE1 LG 16','TOKO','TBK-E','E1TE-ZIXC-114-T','CC MODEL LINEA VAR LG 16 17K ','OL','0.750','1','100.00','1470000','0','0','15000','1455000','0','7000','0','1462000','LUS','T0082961','E1TE','0','0','-','1','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZIXC-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1TE-ZIXC-114-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101151181','2026-09-10','0.750','2026-09-10','11:51:18','PLG0084758','1455000','1455000','7000','1462000','1462000','kasir','2026-09-10 11:51:18','F22610115118');
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-09-10','F226101151181','2026-09-10','11:51:18','LUS','1462000','7000');
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-260910-0017','D','2026-09-10','11:51:18','kasir','PENJUALAN','F226101151181','14868178000','1462000','14869640000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101151181' 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 ('F226101151182','kasir',' 1',' TEE1 LG 16','TOKO','TBK-E','E1TE-ZIXC-115-T','CC MODEL LINEA VAR LG 16 17K ','OL','0.780','1','100.00','1529000','0','0','15000','1513000','0','7000','0','1520000','LUS','T0082962','E1TE','0','0','-','1','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZIXC-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1TE-ZIXC-115-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101151182','2026-09-10','0.780','2026-09-10','11:51:18','PLG0084759','1513000','1513000','7000','1520000','1520000','kasir','2026-09-10 11:51:18','F22610115118');
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-09-10','F226101151182','2026-09-10','11:51:18','LUS','1520000','7000');
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-260910-0018','D','2026-09-10','11:51:18','kasir','PENJUALAN','F226101151182','14869640000','1520000','14871160000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101151182' 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 ('F226101151183','kasir',' 1',' TEF1 UB D5','TOKO','TBK-F','F1TE-ZIXC-106-T','GL OVAL MODEL C UB D52 17K ','OL','2.700','1','100.00','5292000','0','0','15000','5219000','0','19000','0','5238000','LUS','T0082953','F1TE','0','0','-','1','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZIXC-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F1TE-ZIXC-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101151183','2026-09-10','2.700','2026-09-10','11:51:18','PLG0084760','5219000','5219000','19000','5238000','5238000','kasir','2026-09-10 11:51:18','F22610115118');
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-09-10','F226101151183','2026-09-10','11:51:18','LUS','5238000','19000');
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-260910-0019','D','2026-09-10','11:51:18','kasir','PENJUALAN','F226101151183','14871160000','5238000','14876398000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5238000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101151183' 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 ('F226101153131','kasir','1',' MED2 LG S ','TOKO','SMBK-D','D2E-ZIXH-80-T','LT MODEL HURUF MATA LG S 8K ','OL','0.530','1','100.00','559000','0','0','15000','565000','0','5000','0','570000','LUS','T0083227','D2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZIXH-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D2E-ZIXH-80-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101153131','2026-09-10','0.530','2026-09-10','11:53:14','PLG0084761','565000','565000','5000','570000','570000','kasir','2026-09-10 11:53:13','F22610115313');
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-09-10','F226101153131','2026-09-10','11:53:14','LUS','570000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0020','D','2026-09-10','11:53:14','kasir','PENJUALAN','F226101153131','14876398000','570000','14876968000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101153131' 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 ('F226101153132','kasir',' 1',' MED2 LG S ','TOKO','SMBK-D','D2E-ZIXH-81-T','LT MODEL HURUF MATA LG S 8K ','OL','0.530','1','100.00','559000','0','0','15000','565000','0','5000','0','570000','LUS','T0083228','D2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZIXH-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D2E-ZIXH-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101153132','2026-09-10','0.530','2026-09-10','11:53:14','PLG0084762','565000','565000','5000','570000','570000','kasir','2026-09-10 11:53:13','F22610115313');
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-09-10','F226101153132','2026-09-10','11:53:14','LUS','570000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0021','D','2026-09-10','11:53:14','kasir','PENJUALAN','F226101153132','14876968000','570000','14877538000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101153132' 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 ('F226101153133','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZIXG-32-T','GL RANTAI HOLLOW DOUBLE UB 8K ','OL','1.970','1','100.00','2078000','0','0','15000','2088000','0','10000','0','2098000','LUS','T0083091','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXG-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZIXG-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101153133','2026-09-10','1.970','2026-09-10','11:53:14','PLG0084763','2088000','2088000','10000','2098000','2098000','kasir','2026-09-10 11:53:13','F22610115313');
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-09-10','F226101153133','2026-09-10','11:53:14','LUS','2098000','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-260910-0022','D','2026-09-10','11:53:14','kasir','PENJUALAN','F226101153133','14877538000','2098000','14879636000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2098000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101153133' 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 ('F226101153134','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZIXC-92-T','GL RANTAI HOLLOW DOUBLE KH 8K ','OL','4.130','1','100.00','4357000','0','0','15000','4377000','0','21000','0','4398000','LUS','T0082939','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXC-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.130',berat_jual_asli=berat_jual_asli+'4.130',stock_jual='1',berat_akhir=berat_akhir-'4.130',berat_akhir_asli=berat_akhir_asli-'4.130',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZIXC-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101153134','2026-09-10','4.130','2026-09-10','11:53:14','PLG0084764','4377000','4377000','21000','4398000','4398000','kasir','2026-09-10 11:53:13','F22610115313');
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-09-10','F226101153134','2026-09-10','11:53:14','LUS','4398000','21000');
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-260910-0023','D','2026-09-10','11:53:14','kasir','PENJUALAN','F226101153134','14879636000','4398000','14884034000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4398000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101153134' 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 ('F226101153135','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZHBH-51-T','KL SANTA KH 42 8K ','OL','2.020','1','100.00','2131000','0','0','15000','2141000','0','10000','0','2151000','LUS','T0082648','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBH-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='H1E-ZHBH-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226101153135','2026-09-10','2.020','2026-09-10','11:53:14','PLG0084765','2141000','2141000','10000','2151000','2151000','kasir','2026-09-10 11:53:13','F22610115313');
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-09-10','F226101153135','2026-09-10','11:53:14','LUS','2151000','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-260910-0024','D','2026-09-10','11:53:14','kasir','PENJUALAN','F226101153135','14884034000','2151000','14886185000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2151000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101153135' 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 ('F226101207101','kasir','1',' MFS1F X DG','TOKO','SMBK-S','S1F-ZHBF-136-0','AS X EXTENTION DG 8K ','OL','0.310','1','100.00','333000','0','0','15000','336000','0','5000','0','341000','LUS','00420508','S1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1F-ZHBF-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='S1F-ZHBF-136-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226101207101','2026-09-10','0.310','2026-09-10','12:07:10','PLG0084766','336000','336000','5000','341000','341000','kasir','2026-09-10 12:07:10','F22610120710');
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-09-10','F226101207101','2026-09-10','12:07:10','LUS','341000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0025','D','2026-09-10','12:07:10','kasir','PENJUALAN','F226101207101','14886185000','341000','14886526000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='341000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101207101' 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 ('F226101207102','kasir',' 1',' MFS1F X DG','TOKO','SMBK-S','S1F-ZHBF-135-0','AS X EXTENTION DG 8K ','OL','0.320','1','100.00','344000','0','0','15000','347000','0','5000','0','352000','LUS','00420507','S1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1F-ZHBF-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='S1F-ZHBF-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226101207102','2026-09-10','0.320','2026-09-10','12:07:10','PLG0084767','347000','347000','5000','352000','352000','kasir','2026-09-10 12:07:10','F22610120710');
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-09-10','F226101207102','2026-09-10','12:07:10','LUS','352000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0026','D','2026-09-10','12:07:10','kasir','PENJUALAN','F226101207102','14886526000','352000','14886878000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101207102' 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 ('F226101249121','kasir','1',' MEE1 CM 15','TOKO','SMBK-E','E1E-ZIXC-15-T','CC MODEL RANTAI SLEP CM 15 8K ','','0.470','1','100.00','496000','0','0','15000','496000','0','0','0','496000','TJ','T0082862','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXC-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1E-ZIXC-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101249121','2026-09-10','0.470','2026-09-10','12:49:13','PLG0084768','496000','496000','0','496000','496000','kasir','2026-09-10 12:49:12','F22610124912');
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-09-10','F226101249121','2026-09-10','12:49:13','TJ','496000','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-260910-0027','D','2026-09-10','12:49:13','kasir','PENJUALAN','F226101249121','14886878000','496000','14887374000');
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 ('F226101252111','kasir','1',' MFE1 KH 14','TOKO','SMBK-E','E1F-ZIXG-7-T','CC MODEL BUNGA CLOVER SLEP KH 14 8K ','OL','0.370','1','100.00','398000','0','0','15000','401000','0','5000','0','406000','LUS','T0083066','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E1F-ZIXG-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101252111','2026-09-10','0.370','2026-09-10','12:52:12','PLG0084769','401000','401000','5000','406000','406000','kasir','2026-09-10 12:52:11','F22610125211');
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-09-10','F226101252111','2026-09-10','12:52:12','LUS','406000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0028','D','2026-09-10','12:52:12','kasir','PENJUALAN','F226101252111','14887374000','406000','14887780000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101252111' 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 ('F226101252112','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZHAE-181-0','CC X MODEL MATA CM 14 8K ','OL','0.760','1','100.00','802000','0','0','15000','809000','0','5000','0','814000','LUS','00419202','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHAE-181-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2E-ZHAE-181-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101252112','2026-09-10','0.760','2026-09-10','12:52:12','PLG0084770','809000','809000','5000','814000','814000','kasir','2026-09-10 12:52:11','F22610125211');
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-09-10','F226101252112','2026-09-10','12:52:12','LUS','814000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0029','D','2026-09-10','12:52:12','kasir','PENJUALAN','F226101252112','14887780000','814000','14888594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='814000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101252112' 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 ('F226101252591','kasir','1',' TEA1 X LG ','TOKO','TBK-A','A1TE-YBBA-5-T','AT X KLIP BANGKOK SLEP LG 17K ','','0.770','1','100.00','1509000','0','0','15000','1494000','0','7000','0','1501000','LUS','T0067228','A1TE','0','0','-','1','1960000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YBBA-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1TE-YBBA-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101252591','2026-09-10','0.770','2026-09-10','12:53:00','PLG0084771','1494000','1494000','7000','1501000','1501000','kasir','2026-09-10 12:52:59','F22610125259');
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-09-10','F226101252591','2026-09-10','12:53:00','LUS','1501000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260910-0030','D','2026-09-10','12:53:00','kasir','PENJUALAN','F226101252591','14888594000','1501000','14890095000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101252591';
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 ('F226100129301','kasir','1',' MEH1 15K U','TOKO','SMBK-H','H1E-ZIXH-86-T','KL SANTA ANAK BONEKA CAT VAR UB 8K ','OL','2.520','1','100.00','2659000','0','0','15000','2669000','0','15000','0','2684000','TIN','T0083233','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXH-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='H1E-ZIXH-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226100129301','2026-09-10','2.520','2026-09-10','13:29:31','PLG0084772','2669000','2669000','15000','2684000','2684000','kasir','2026-09-10 13:29:30','F22610012930');
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-09-10','F226100129301','2026-09-10','13:29:31','TIN','2684000','15000');
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-260910-0031','D','2026-09-10','13:29:31','kasir','PENJUALAN','F226100129301','14890095000','2684000','14892779000');
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 ('F226100131361','kasir','1',' MEH1 15K U','TOKO','SMBK-H','H1E-ZIXH-86-T','KL SANTA ANAK BONEKA CAT VAR UB 8K ','OL','2.520','1','100.00','2659000','0','0','15000','2669000','0','15000','0','2684000','TIN','T0083233','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXH-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='H1E-ZIXH-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226100131361','2026-09-10','2.520','2026-09-10','13:31:36','PLG0084773','2669000','2669000','15000','2684000','2684000','kasir','2026-09-10 13:31:36','F22610013136');
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-09-10','F226100131361','2026-09-10','13:31:36','TIN','2684000','15000');
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-260910-0033','D','2026-09-10','13:31:36','kasir','PENJUALAN','F226100131361','14890095000','2684000','14892779000');
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 ('F226100133291','kasir','1',' MDA1D HW ','TOKO','SMBK-A','A1D-ZGAD-37-T','AT KLIP C SLEP HW 8K ','OL','1.010','1','100.00','1045000','0','0','15000','1050000','0','5000','0','1055000','TIN','T0081114','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGAD-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1D-ZGAD-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133291','2026-09-10','1.010','2026-09-10','13:33:29','PLG0084774','1050000','1050000','5000','1055000','1055000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133291','2026-09-10','13:33:29','TIN','1055000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0034','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133291','14892779000','1055000','14893834000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1055000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133291' 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 ('F226100133292','kasir',' 1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZHXH-39-0','AT X HUGGIES ARESO SLEP UB 8K ','OL','1.130','1','100.00','1170000','0','0','15000','1175000','0','6000','0','1181000','TIN','00417768','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHXH-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1D-ZHXH-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133292','2026-09-10','1.130','2026-09-10','13:33:29','PLG0084775','1175000','1175000','6000','1181000','1181000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133292','2026-09-10','13:33:29','TIN','1181000','6000');
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-260910-0035','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133292','14893834000','1181000','14895015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1181000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133292' 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 ('F226100133293','kasir',' 1',' MFD1 BG ','TOKO','SMBK-D','D1F-ZIXG-81-T','LT SLOBOK KRAWANG BG 8K ','OL','0.360','1','100.00','387000','0','0','15000','391000','0','5000','0','396000','TIN','T0083140','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIXG-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D1F-ZIXG-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133293','2026-09-10','0.360','2026-09-10','13:33:29','PLG0084776','391000','391000','5000','396000','396000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133293','2026-09-10','13:33:29','TIN','396000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0036','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133293','14895015000','396000','14895411000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='396000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133293' 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 ('F226100133294','kasir',' 1',' MFE2F KH 1','TOKO','SMBK-E','E2F-ZHCA-14-T','CC MODEL PAKU MATA SLEP KH 12 8K ','OL','0.350','1','100.00','376000','0','0','15000','380000','0','5000','0','385000','TIN','T0082803','E2F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHCA-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2F-ZHCA-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133294','2026-09-10','0.350','2026-09-10','13:33:29','PLG0084777','380000','380000','5000','385000','385000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133294','2026-09-10','13:33:29','TIN','385000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0037','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133294','14895411000','385000','14895796000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='385000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133294' 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 ('F226100133295','kasir',' 1',' MFE2F KH 1','TOKO','SMBK-E','E2F-ZHBH-78-T','CC MODEL PAKU MATA SLEP KH 14 8K ','OL','0.400','1','100.00','430000','0','0','15000','434000','0','5000','0','439000','TIN','T0082675','E2F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHBH-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2F-ZHBH-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133295','2026-09-10','0.400','2026-09-10','13:33:29','PLG0084778','434000','434000','5000','439000','439000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133295','2026-09-10','13:33:29','TIN','439000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260910-0038','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133295','14895796000','439000','14896235000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='439000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133295' 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 ('F226100133296','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZIXH-12-T','CC WEDDING MATA CM 18 8K ','OL','1.620','1','100.00','1677000','0','0','15000','1683000','0','10000','0','1693000','TIN','T0083159','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXH-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2D-ZIXH-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100133296','2026-09-10','1.620','2026-09-10','13:33:29','PLG0084779','1683000','1683000','10000','1693000','1693000','kasir','2026-09-10 13:33:29','F22610013329');
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-09-10','F226100133296','2026-09-10','13:33:29','TIN','1693000','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-260910-0039','D','2026-09-10','13:33:29','kasir','PENJUALAN','F226100133296','14896235000','1693000','14897928000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1693000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100133296' 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 ('F226100134501','kasir','1',' MEE2 KH 14','TOKO','SMBK-E','E2E-ZIXI-86-T','CC MODEL SNAKE MATA VAR KH 14 8K ','','0.500','1','100.00','527000','0','0','15000','528000','0','0','0','528000','LUS','T0083341','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIXI-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2E-ZIXI-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100134501','2026-09-10','0.500','2026-09-10','13:34:50','PLG0084780','528000','528000','0','528000','528000','kasir','2026-09-10 13:34:50','F22610013450');
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-09-10','F226100134501','2026-09-10','13:34:50','LUS','528000','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-260910-0040','D','2026-09-10','13:34:50','kasir','PENJUALAN','F226100134501','14897928000','528000','14898456000');
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 ('F226100137571','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZHBF-27-0','AT X GYPSY MRICAN SLEP LG 8K ','OL','1.020','1','100.00','1056000','0','0','15000','1061000','0','5000','0','1066000','DIN','00420399','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHBF-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1D-ZHBF-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100137571','2026-09-10','1.020','2026-09-10','13:37:58','PLG0084781','1061000','1061000','5000','1066000','0','kasir','2026-09-10 13:37:57','F22610013757');
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-09-10','F226100137571','2026-09-10','13:37:58','DIN','1066000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0006','2026-09-10','2026-09-10 13:37:57','PENJUALAN : F226100137571','098765432','BCA','1066000','1066000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0007','D','2026-09-10','13:37:58','BCA','PENJUALAN','F226100137571','4797462888','1066000','4798528888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('098765432','SRI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100137571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100137571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100137571';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-1-T','T0083351','MEF1 UB 58 ','GL OVAL MODAL C 58 UB 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2363500','2026-09-10','2363500','2.240','100.00','8','0','1055000.00','1','0.04', 'input','2026-09-10 13:59:15','2.240','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-1-T','T0083351');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-1-T','F1E','TOKO','01-SEM','100.00','2.240','2.240','1','2.240','2.240','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-2-T','T0083352','MEF1 UB 6 ','GL OVAL MODAL C 6 UB 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3081000','2026-09-10','3081000','2.920','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:01:06','2.920','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-2-T','T0083352');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-2-T','F1E','TOKO','01-SEM','100.00','2.920','2.920','1','2.920','2.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-3-T','T0083353','MEF1 UB 58 ','GL OVAL MODEL C 58 UB 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2332000','2026-09-10','2332000','2.210','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:01:52','2.210','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-3-T','T0083353');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-3-T','F1E','TOKO','01-SEM','100.00','2.210','2.210','1','2.210','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-4-T','T0083354','MEF1 UB 6 ','GL OVAL MODEL C 6 UB 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2564000','2026-09-10','2564000','2.430','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:02:19','2.430','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-4-T','T0083354');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-4-T','F1E','TOKO','01-SEM','100.00','2.430','2.430','1','2.430','2.430','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-5-T','T0083355','MEF1 KH 54 ','GL OVAL MODEL C 54 KH 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3165000','2026-09-10','3165000','3.000','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:03:20','3.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-5-T','T0083355');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-5-T','F1E','TOKO','01-SEM','100.00','3.000','3.000','1','3.000','3.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-6-T','T0083356','MEF1 KH 54 ','GL OVAL MODEL C 54 KH 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3186500','2026-09-10','3186500','3.020','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:03:39','3.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-6-T','T0083356');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-6-T','F1E','TOKO','01-SEM','100.00','3.020','3.020','1','3.020','3.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-7-T','T0083357','MEF1 KH 52 ','GL OVAL MODEL C 52 KH 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3081000','2026-09-10','3081000','2.920','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:04:04','2.920','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-7-T','T0083357');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-7-T','F1E','TOKO','01-SEM','100.00','2.920','2.920','1','2.920','2.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZIAX-8-T','T0083358','MEF3 MT ','GL KREPYAK RANTAI SLEP MT 8K ','','GR','---','ME','F3E','TOKO','01-SEM','4399500','2026-09-10','4399500','4.170','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:05:52','4.170','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZIAX-8-T','T0083358');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F3E-ZIAX-8-T','F3E','TOKO','01-SEM','100.00','4.170','4.170','1','4.170','4.170','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 ('F226100206071','kasir','1',' MEF3E 10K ','TOKO','SMBK-F','F3E-ZHBG-84-T','GL TIFF SPECTRA CAT HITAM SLEP YT 8K ','','1.400','1','100.00','1477000','0','0','15000','1477000','0','10000','0','1487000','NOV','T0082590','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBG-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZHBG-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100206071','2026-09-10','1.400','2026-09-10','14:06:07','PLG0084782','1477000','1477000','10000','1487000','0','kasir','2026-09-10 14:06:07','F22610020607');
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-09-10','F226100206071','2026-09-10','14:06:07','NOV','1487000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0007','2026-09-10','2026-09-10 14:06:07','PENJUALAN : F226100206071','23456789014','BCA','1487000','1487000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0008','D','2026-09-10','14:06:07','BCA','PENJUALAN','F226100206071','4798528888','1487000','4800015888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('23456789014','ENDAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1487000' WHERE no_faktur_jual='F226100206071' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F1E-ZIAX-1-T','T0083351','T0083351','GL OVAL MODAL C 58 UB 8K ','GL OVAL MODEL C 58 UB 8K','','','2363500','2363500',' 0','0','input','2026-09-10 14:06:42');
UPDATE tm_barang SET nama_barang='GL OVAL MODEL C 58 UB 8K' ,nama_atribut='' ,kode_intern='MEF1 UB 58 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F1E-ZIAX-1-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F1E-ZIAX-2-T','T0083352','T0083352','GL OVAL MODAL C 6 UB 8K ','GL OVAL MODEL C 6 UB 8K','','','3081000','3081000',' 0','0','input','2026-09-10 14:06:57');
UPDATE tm_barang SET nama_barang='GL OVAL MODEL C 6 UB 8K' ,nama_atribut='' ,kode_intern='MEF1 UB 6 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F1E-ZIAX-2-T' LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','1','F1E-ZIAX-1-T','1','2.24','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-1-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-1-T' , '1','2.24','2.24', '1','2.24','2.24','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.24',berat_out_asli=berat_out_asli+'2.24',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','2','F1E-ZIAX-2-T','1','2.92','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-2-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-2-T' , '1','2.92','2.92', '1','2.92','2.92','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.92',berat_out_asli=berat_out_asli+'2.92',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','3','F1E-ZIAX-3-T','1','2.21','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-3-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-3-T' , '1','2.21','2.21', '1','2.21','2.21','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.21',berat_out_asli=berat_out_asli+'2.21',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','4','F1E-ZIAX-4-T','1','2.43','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-4-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-4-T' , '1','2.43','2.43', '1','2.43','2.43','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.43',berat_out_asli=berat_out_asli+'2.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','5','F1E-ZIAX-5-T','1','3','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-5-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-5-T' , '1','3','3', '1','3','3','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3',berat_out_asli=berat_out_asli+'3',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','6','F1E-ZIAX-6-T','1','3.02','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-6-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-6-T' , '1','3.02','3.02', '1','3.02','3.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.02',berat_out_asli=berat_out_asli+'3.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','7','F1E-ZIAX-7-T','1','2.92','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-7-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-7-T' , '1','2.92','2.92', '1','2.92','2.92','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.92',berat_out_asli=berat_out_asli+'2.92',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0001','8','F3E-ZIAX-8-T','1','4.17','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-ZIAX-8-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F3E','F3E-ZIAX-8-T' , '1','4.17','4.17', '1','4.17','4.17','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.17',berat_out_asli=berat_out_asli+'4.17',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-ZIAX-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260910-0001','2026-09-10','2026-09-10','14:07','22.91','input','2026-09-10 14:07:48');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZIAX-9-T','T0083359','MEF1 UB 60 ','GL OVAL MODEL C 60 UB 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2405500','2026-09-10','2405500','2.280','100.00','8','','1055000.00','1','0.04', 'input','2026-09-10 14:13:01','2.280','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZIAX-9-T','T0083359');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-10','F1E-ZIAX-9-T','F1E','TOKO','01-SEM','100.00','2.280','2.280','1','2.280','2.280','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260910-0002','1','F1E-ZIAX-9-T','1','2.28','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-ZIAX-9-T' AND kode_lokasi_toko = '01-SEM';
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-09-10','TOKO','SMBK-F','F1E','F1E-ZIAX-9-T' , '1','2.28','2.28', '1','2.28','2.28','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.28',berat_out_asli=berat_out_asli+'2.28',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-ZIAX-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260910-0002','2026-09-10','2026-09-10','14:14','2.28','input','2026-09-10 14:14:46');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F1E-ZIAX-4-T','T0083354','T0083354','GL OVAL MODEL C 6 UB 8K ','GL OVAL MODEL C 60 UB 8K','','','2564000','2564000',' 0','0','input','2026-09-10 14:16:06');
UPDATE tm_barang SET nama_barang='GL OVAL MODEL C 60 UB 8K' ,nama_atribut='' ,kode_intern='MEF1 UB 60 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F1E-ZIAX-4-T' LIMIT 1;
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-20260910-0001','1','A1D-ZIXG-64-0','1','0.850','0.850','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXG-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXG-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-10 14:21:37' WHERE kode_barang='A1D-ZIXG-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXG-64-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-09-10 14:21:37','TOKO','SMBK-A','A1D','A1D-ZIXG-64-0','1','0.850','0.850','1','0.850','0.850','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-ZIXG-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXG-64-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260910-0001','2026-09-10','14:21','0.850','input','2026-09-10 14:21:36');
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 ('F226100225041','kasir','1',' MDA1 10K H','TOKO','SMBK-A','A1D-ZIXG-64-0','AT MODEL BOLA PASIR HW 8K ','OL','0.850','1','100.00','880000','0','0','15000','883000','0','10000','0','893000','TIN','00422242','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIXG-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='A1D-ZIXG-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100225041','2026-09-10','0.850','2026-09-10','14:25:04','PLG0084783','883000','883000','10000','893000','893000','kasir','2026-09-10 14:25:04','F22610022504');
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-09-10','F226100225041','2026-09-10','14:25:04','TIN','893000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260910-0041','D','2026-09-10','14:25:04','kasir','PENJUALAN','F226100225041','14898456000','893000','14899349000');
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 ('F226100225341','kasir','1',' MFD1 LG ','TOKO','SMBK-D','D1F-ZIXG-83-T','LT SLOBOK KUPU SLEP LG 8K ','OL','0.350','1','100.00','376000','0','0','15000','380000','0','5000','0','385000','TIN','T0083142','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIXG-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D1F-ZIXG-83-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100225341','2026-09-10','0.350','2026-09-10','14:25:35','PLG0084784','380000','380000','5000','385000','385000','kasir','2026-09-10 14:25:34','F22610022534');
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-09-10','F226100225341','2026-09-10','14:25:35','TIN','385000','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-260910-0042','D','2026-09-10','14:25:35','kasir','PENJUALAN','F226100225341','14899349000','385000','14899734000');
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 ('F226100225561','kasir','1',' MFE2 KH 12','TOKO','SMBK-E','E2F-ZIXI-92-T','CC MODEL PAKU MATA VAR KH 12 8K ','OL','0.350','1','100.00','376000','0','0','15000','380000','0','5000','0','385000','TIN','T0083347','E2F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIXI-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2F-ZIXI-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100225561','2026-09-10','0.350','2026-09-10','14:25:56','PLG0084785','380000','380000','5000','385000','385000','kasir','2026-09-10 14:25:56','F22610022556');
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-09-10','F226100225561','2026-09-10','14:25:56','TIN','385000','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-260910-0043','D','2026-09-10','14:25:56','kasir','PENJUALAN','F226100225561','14899734000','385000','14900119000');
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 ('F226100230061','kasir','1',' MGD1G X LG','TOKO','SMBK-D','D1G-ZFCX-36-0','LT X SLOBOK BUNGA SLEP LG 8K ','OL','0.300','1','100.00','328000','0','0','15000','332000','0','5000','0','337000','DIN','00411243','D1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZFCX-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D1G-ZFCX-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100230061','2026-09-10','0.300','2026-09-10','14:30:06','PLG0084786','332000','332000','5000','337000','337000','kasir','2026-09-10 14:30:06','F22610023006');
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-09-10','F226100230061','2026-09-10','14:30:06','DIN','337000','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-260910-0044','D','2026-09-10','14:30:06','kasir','PENJUALAN','F226100230061','14900119000','337000','14900456000');
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-00005695','X-00005695','CC ANAK OSROT BONEKA CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','303000','2026-09-10','0.360','1','kasir','2026-09-10 14:49:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005695','X-00005695');
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-260910-0001','F226151110231','LUS','1','BELI','BELI001','E2E', 'X-00005695', 'CC ANAK OSROT BONEKA CAT MATA LG 8K','0.460','0.360','100.00','550000','303000','841667','1055000','1','303000','303000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-10' 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-260910-0001','2026-09-10','2026-09-10','14:49:08','LUS','---','0.360','303000','303000','303000','303000','303000','kasir','2026-09-10 14:49:09','FB-260910-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260910-0001','MIA','MLILIR','','','085894466572','kasir','2026-09-10 14:49:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-10' 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-260910-0045','K','2026-09-10','14:49:08','kasir','PEMBELIAN UMUM','FB-260910-0001','14900456000','303000','14900153000');
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-00005696','X-00005696','CC MODEL MATA VAR CM 12 8K','GR','---','E2E','BELI','BELI001','710000','2026-09-10','0.750','1','kasir','2026-09-10 14:49:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005696','X-00005696');
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-260910-0002','F226051126482','LUS','1','BELI','BELI001','E2E', 'X-00005696', 'CC MODEL MATA VAR CM 12 8K','0.750','0.750','100.00','829000','710000','946667','1055000','1','710000','710000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-10' 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-260910-0002','2026-09-10','2026-09-10','14:49:48','LUS','---','0.750','710000','710000','710000','710000','710000','kasir','2026-09-10 14:49:49','FB-260910-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260910-0002','EKY','TALUN 3/2 NGEBEL','','','085135859179','kasir','2026-09-10 14:49:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-10' 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-260910-0046','K','2026-09-10','14:49:48','kasir','PEMBELIAN UMUM','FB-260910-0002','14900153000','710000','14899443000');
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 ('F226100311201','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-ZDBX-21-T','CC ANAK BONEKA CAT MATA VAR LG 8K ','OL','0.450','1','100.00','475000','0','0','15000','480000','0','5000','0','485000','TIN','T0078756','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='E2E-ZDBX-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100311201','2026-09-10','0.450','2026-09-10','15:11:21','PLG0084787','480000','480000','5000','485000','0','kasir','2026-09-10 15:11:20','F22610031120');
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-09-10','F226100311201','2026-09-10','15:11:21','TIN','485000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0008','2026-09-10','2026-09-10 15:11:20','PENJUALAN : F226100311201','56756758768','BCA','485000','485000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0009','D','2026-09-10','15:11:21','BCA','PENJUALAN','F226100311201','4800015888','485000','4800500888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('56756758768','FITRI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='485000' WHERE no_faktur_jual='F226100311201' 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 ('F226100312001','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZHBG-81-T','GL CASTELI SPECTRA SLEP HW 8K ','OL','1.550','1','100.00','1635000','0','0','15000','1644000','0','8000','0','1652000','TIN','T0082587','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBG-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='F3E-ZHBG-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100312001','2026-09-10','1.550','2026-09-10','15:12:01','PLG0084788','1644000','1644000','8000','1652000','0','kasir','2026-09-10 15:12:00','F22610031200');
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-09-10','F226100312001','2026-09-10','15:12:01','TIN','1652000','8000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260910-0009','2026-09-10','2026-09-10 15:12:00','PENJUALAN : F226100312001','675454545','BCA','1652000','1652000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260910-0010','D','2026-09-10','15:12:01','BCA','PENJUALAN','F226100312001','4800500888','1652000','4802152888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('675454545','FITRI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1652000' WHERE no_faktur_jual='F226100312001' 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-00005697','X-00005697','LT MODEL MERAK 3D SLEP BG 17K','GR','---','D1TF','BELI','BELI001','2291000','2026-09-10','1.250','1','kasir','2026-09-10 15:17:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1TF','X-00005697','X-00005697');
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-260910-0003','F226090232202','TJ','1','BELI','BELI001','D1TF', 'X-00005697', 'LT MODEL MERAK 3D SLEP BG 17K','1.250','1.250','100.00','2438000','2291000','1832800','1980000','1','2291000','2291000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1TF' 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-260910-0003','2026-09-10','2026-09-10','15:17:47','TJ','---','1.250','2291000','2291000','2291000','2291000','2291000','kasir','2026-09-10 15:17:48','FB-260910-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260910-0003','ANA','KARANGLO KIDUL 1/2 JAMBON','','','082141657718','kasir','2026-09-10 15:17:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-10' 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-260910-0047','K','2026-09-10','15:17:47','kasir','PEMBELIAN UMUM','FB-260910-0003','14899443000','2291000','14897152000');
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-00005698','X-00005698','KL X SANTA 46 HW 17K','GR','---','H1TE','BELI','BELI001','18341000','2026-09-10','10.110','1','kasir','2026-09-10 15:17:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TE','X-00005698','X-00005698');
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-260910-0004','F226090400521','TJ','2','BELI','BELI001','H1TE', 'X-00005698', 'KL X SANTA 46 HW 17K','10.110','10.110','100.00','19512000','18341000','1814144','1960000','1','18341000','18341000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.110',berat_beli_asli=berat_beli_asli+'10.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.110',berat_akhir_asli=berat_akhir_asli+'10.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TE' 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-260910-0004','2026-09-10','2026-09-10','15:17:47','TJ','---','10.110','18341000','18341000','18341000','18341000','18341000','kasir','2026-09-10 15:17:48','FB-260910-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260910-0004','ANA','KARANGLO KIDUL 1/2 JAMBON','','','082141657718','kasir','2026-09-10 15:17:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-10' 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-260910-0048','K','2026-09-10','15:17:47','kasir','PEMBELIAN UMUM','FB-260910-0004','14897152000','18341000','14878811000');
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 ('F226100319451','kasir','1',' MED1E 5K Y','TOKO','SMBK-D','D1E-ZHXG-19-T','LT MODEL SPECTRA CAT HITAM SLEP YT 8K ','','0.500','1','100.00','527000','0','0','15000','528000','0','5000','0','533000','NOV','T0082072','D1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHXG-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-09-10' AND kode_barang='D1E-ZHXG-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100319451','2026-09-10','0.500','2026-09-10','15:19:45','PLG0084789','528000','528000','5000','533000','533000','kasir','2026-09-10 15:19:45','F22610031945');
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-09-10','F226100319451','2026-09-10','15:19:45','NOV','533000','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-260910-0049','D','2026-09-10','15:19:45','kasir','PENJUALAN','F226100319451','14878811000','533000','14879344000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100131361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100131361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100131361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100133296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100133296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100134501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100134501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100134501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100206071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100206071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100206071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100225041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100225341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100225561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100225561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100230061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100230061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100230061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100311201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100311201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100311201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100312001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100312001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100312001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100319451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100319451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100319451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100828171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100828171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100828171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100842201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100842201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100842201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100842202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100842202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100842202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100906351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100906351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100906351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100907101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100907101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100907101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100907511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100907511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100907511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100941451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100941451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100941451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100943001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100943001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100943001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100955171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100955171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100955171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101040141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101040141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101040141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101041491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101041491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101041491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101045191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101045191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101045191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101056421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101056421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101056421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101109381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101109381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101109381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101110201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101110201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101110201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101111191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101111191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101111191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101116411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101116411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101116411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101122411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101122411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101122411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101122412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101122412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101122412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101151181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101151182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151183' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101151183' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101151183';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101153131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101153132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153133' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153133' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101153133';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153134' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153134' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101153134';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153135' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101153135' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101153135';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101207101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101207101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101207101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101207102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101207102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101207102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101249121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101249121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101249121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101252111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101252112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101252112';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260910-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260910-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260910-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260910-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260910-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260910-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260910-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260910-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-10';
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-09-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-10' 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-260911-0001','D','2026-09-11','16:40:01','SYSTEM','SALDO AWAL','SALDO AWAL','0','14879344000','14879344000');
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-260911-0001','D','2026-09-11','16:40:01','BCA','SALDO AWAL','SALDO AWAL','0','4802152888','4802152888');
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-260911-0001','D','2026-09-11','16:40:01','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260911-0001','D','2026-09-11','16:40:01','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-260911-0001','D','2026-09-11','16:40:01','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260911-0001','D','2026-09-11','16:40:01','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
UPDATE tp_system SET tgl_system='2026-09-11';