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-20260314-0001','1','A1D-YKBB-131-0','1','1.530','1.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKBB-131-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKBB-131-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-03-14 07:49:21' WHERE kode_barang='A1D-YKBB-131-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKBB-131-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-03-14 07:49:21','TOKO','PM-A','A1D','A1D-YKBB-131-0','1','1.530','1.530','1','1.530','1.530','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-YKBB-131-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKBB-131-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:49','1.530','admpindah','2026-03-14 07:49:20');
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-20260314-0001','1','B1E-YJAC-35-0','1','0.550','0.550','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJAC-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJAC-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-03-14 07:49:58' WHERE kode_barang='B1E-YJAC-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJAC-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:49:58','TOKO','PM-B','B1E','B1E-YJAC-35-0','1','0.550','0.550','1','0.550','0.550','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-YJAC-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJAC-35-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-20260314-0001','1','B1D-ZBBE-119-0','1','1.070','1.070','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZBBE-119-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZBBE-119-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-03-14 07:49:58' WHERE kode_barang='B1D-ZBBE-119-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZBBE-119-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-03-14 07:49:58','TOKO','PM-B','B1D','B1D-ZBBE-119-0','1','1.070','1.070','1','1.070','1.070','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-ZBBE-119-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZBBE-119-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-20260314-0001','1','B1E-ZCAC-185-0','1','0.650','0.650','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZCAC-185-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-185-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-03-14 07:49:58' WHERE kode_barang='B1E-ZCAC-185-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZCAC-185-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-03-14 07:49:58','TOKO','PM-B','B1E','B1E-ZCAC-185-0','1','0.650','0.650','1','0.650','0.650','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-ZCAC-185-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-185-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-20260314-0001','1','B1E-ZCAC-186-0','1','0.800','0.800','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZCAC-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-03-14 07:49:58' WHERE kode_barang='B1E-ZCAC-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZCAC-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-03-14 07:49:58','TOKO','PM-B','B1E','B1E-ZCAC-186-0','1','0.800','0.800','1','0.800','0.800','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-ZCAC-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-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-20260314-0001','1','B1E-ZCAC-187-0','1','0.590','0.590','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZCAC-187-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-187-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-03-14 07:49:58' WHERE kode_barang='B1E-ZCAC-187-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZCAC-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-03-14 07:49:58','TOKO','PM-B','B1E','B1E-ZCAC-187-0','1','0.590','0.590','1','0.590','0.590','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-ZCAC-187-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZCAC-187-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:49','3.660','admpindah','2026-03-14 07:49:58');
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-20260314-0001','1','D2E-ZCAC-180-0','1','0.600','0.600','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZCAC-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZCAC-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-03-14 07:50:22' WHERE kode_barang='D2E-ZCAC-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZCAC-180-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-03-14 07:50:22','TOKO','PM-D','D2E','D2E-ZCAC-180-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZCAC-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZCAC-180-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-20260314-0001','1','D2E-ZCAC-181-0','1','0.800','0.800','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZCAC-181-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZCAC-181-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-03-14 07:50:22' WHERE kode_barang='D2E-ZCAC-181-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZCAC-181-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-03-14 07:50:22','TOKO','PM-D','D2E','D2E-ZCAC-181-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZCAC-181-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZCAC-181-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:50','1.400','admpindah','2026-03-14 07:50:22');
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-20260314-0001','1','E1D-ZBXD-254-0','1','1.500','1.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBXD-254-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBXD-254-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1D-ZBXD-254-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBXD-254-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-03-14 07:50:40','TOKO','PM-E','E1D','E1D-ZBXD-254-0','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZBXD-254-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBXD-254-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-20260314-0001','1','E2E-ZCAC-214-0','1','0.570','0.570','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZCAC-214-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZCAC-214-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E2E-ZCAC-214-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZCAC-214-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E2E','E2E-ZCAC-214-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZCAC-214-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZCAC-214-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','E1D-ZCAC-215-0','1','0.950','0.950','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCAC-215-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCAC-215-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1D-ZCAC-215-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCAC-215-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E1D','E1D-ZCAC-215-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZCAC-215-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCAC-215-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','E1D-ZCAC-216-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCAC-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCAC-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1D-ZCAC-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCAC-216-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E1D','E1D-ZCAC-216-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZCAC-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCAC-216-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','E1E-ZCAC-217-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCAC-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1E-ZCAC-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCAC-217-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E1E','E1E-ZCAC-217-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCAC-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-217-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-20260314-0001','1','E1E-ZCAC-218-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCAC-218-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-218-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1E-ZCAC-218-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCAC-218-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E1E','E1E-ZCAC-218-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCAC-218-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-218-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','E1E-ZCAC-219-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCAC-219-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-219-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1E-ZCAC-219-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCAC-219-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:50:40','TOKO','PM-E','E1E','E1E-ZCAC-219-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCAC-219-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-219-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-20260314-0001','1','E1E-ZCAC-220-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCAC-220-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-220-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1E-ZCAC-220-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCAC-220-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-03-14 07:50:40','TOKO','PM-E','E1E','E1E-ZCAC-220-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCAC-220-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-220-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-20260314-0001','1','E1E-ZCAC-221-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCAC-221-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-221-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-14 07:50:40' WHERE kode_barang='E1E-ZCAC-221-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCAC-221-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-03-14 07:50:40','TOKO','PM-E','E1E','E1E-ZCAC-221-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZCAC-221-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCAC-221-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:50','6.460','admpindah','2026-03-14 07:50:39');
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-20260314-0001','1','F3G-XJAB-268-0','1','2.080','2.080','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3G-XJAB-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3G-XJAB-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3G-XJAB-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3G-XJAB-268-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:51:06','TOKO','PM-F','F3G','F3G-XJAB-268-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3G' 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='F3G-XJAB-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3G-XJAB-268-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','F3F-YKXA-269-0','1','0.580','0.580','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3F-YKXA-269-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3F-YKXA-269-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3F-YKXA-269-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3F-YKXA-269-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-14 07:51:06','TOKO','PM-F','F3F','F3F-YKXA-269-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3F' 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='F3F-YKXA-269-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YKXA-269-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','F3E-ZCXB-282-0','1','1.660','1.660','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXB-282-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXB-282-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCXB-282-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXB-282-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCXB-282-0','1','1.660','1.660','1','1.660','1.660','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-ZCXB-282-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXB-282-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-20260314-0001','1','F1E-ZCAC-190-0','1','2.420','2.420','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZCAC-190-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZCAC-190-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F1E-ZCAC-190-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZCAC-190-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-03-14 07:51:06','TOKO','PM-F','F1E','F1E-ZCAC-190-0','1','2.420','2.420','1','2.420','2.420','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-ZCAC-190-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZCAC-190-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-20260314-0001','1','F1E-ZCAC-191-0','1','2.390','2.390','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZCAC-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZCAC-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F1E-ZCAC-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZCAC-191-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-03-14 07:51:06','TOKO','PM-F','F1E','F1E-ZCAC-191-0','1','2.390','2.390','1','2.390','2.390','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-ZCAC-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZCAC-191-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-20260314-0001','1','F3E-ZCAC-222-0','1','0.480','0.480','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-222-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-222-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-222-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-222-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-222-0','1','0.480','0.480','1','0.480','0.480','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-ZCAC-222-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-222-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-20260314-0001','1','F3E-ZCAC-223-0','1','1.520','1.520','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-223-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-223-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-223-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-223-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-223-0','1','1.520','1.520','1','1.520','1.520','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-ZCAC-223-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-223-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-20260314-0001','1','F3E-ZCAC-224-0','1','2.500','2.500','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-224-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-224-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-224-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-224-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-224-0','1','2.500','2.500','1','2.500','2.500','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-ZCAC-224-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-224-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-20260314-0001','1','F3E-ZCAC-225-0','1','2.050','2.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-225-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-225-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-225-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-225-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-225-0','1','2.050','2.050','1','2.050','2.050','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-ZCAC-225-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-225-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-20260314-0001','1','F3E-ZCAC-226-0','1','1.500','1.500','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-226-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-226-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-226-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-226-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-226-0','1','1.500','1.500','1','1.500','1.500','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-ZCAC-226-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-226-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-20260314-0001','1','F3E-ZCAC-227-0','1','1.520','1.520','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAC-227-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-227-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-14 07:51:06' WHERE kode_barang='F3E-ZCAC-227-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAC-227-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-03-14 07:51:06','TOKO','PM-F','F3E','F3E-ZCAC-227-0','1','1.520','1.520','1','1.520','1.520','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-ZCAC-227-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAC-227-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:50','18.700','admpindah','2026-03-14 07:51:05');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260314-0001','1','H1E-ZCAC-213-0','1','2.200','2.200','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCAC-213-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCAC-213-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-03-14 07:51:36' WHERE kode_barang='H1E-ZCAC-213-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCAC-213-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-03-14 07:51:36','TOKO','PM-H','H1E','H1E-ZCAC-213-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-ZCAC-213-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCAC-213-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:51','2.200','admpindah','2026-03-14 07:51: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-20260314-0001','1','S1G-ZCXG-295-0','1','0.310','0.310','TOKO','PMBK-S','TOKO','PM-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZCXG-295-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZCXG-295-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-S',tgl_last_beli='2026-03-14 07:51:57' WHERE kode_barang='S1G-ZCXG-295-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZCXG-295-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-03-14 07:51:57','TOKO','PM-S','S1G','S1G-ZCXG-295-0','1','0.310','0.310','1','0.310','0.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' 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='S1G-ZCXG-295-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZCXG-295-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260314-0001','2026-03-14','07:51','0.310','admpindah','2026-03-14 07:51:56');
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 ('F326140902051','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-YLXF-224-0','GL X OVAL C UB 54 8K ','','4.390','1','100.00','5202000','0','0','15000','5203000','0','0','0','5203000','SIN','00380040','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLXF-224-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.390',berat_jual_asli=berat_jual_asli+'4.390',stock_jual='1',berat_akhir=berat_akhir-'4.390',berat_akhir_asli=berat_akhir_asli-'4.390',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F1E-YLXF-224-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140902051','2026-03-14','4.390','2026-03-14','09:02:05','PLG0027636','5203000','5203000','0','5203000','5203000','input','2026-03-14 09:02:05','F32614090205');
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-03-14','F326140902051','2026-03-14','09:02:05','SIN','5203000','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-260314-0002','D','2026-03-14','09:02:05','input','PENJUALAN','F326140902051','2977323000','5203000','2982526000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5203000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140902051' 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 ('F326140902052','input',' 1',' MEF1 X UB ','TOKO','PM-F','F1E-YKXC-599-0','GL X OVAL C SLEP UB 52 8K ','','4.730','1','100.00','5605000','0','0','15000','5605000','0','0','0','5605000','SIN','00376530','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXC-599-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.730',berat_jual_asli=berat_jual_asli+'4.730',stock_jual='1',berat_akhir=berat_akhir-'4.730',berat_akhir_asli=berat_akhir_asli-'4.730',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F1E-YKXC-599-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140902052','2026-03-14','4.730','2026-03-14','09:02:05','PLG0027637','5605000','5605000','0','5605000','5605000','input','2026-03-14 09:02:05','F32614090205');
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-03-14','F326140902052','2026-03-14','09:02:05','SIN','5605000','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-260314-0003','D','2026-03-14','09:02:05','input','PENJUALAN','F326140902052','2982526000','5605000','2988131000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140902052' 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 ('F326140905241','input','1',' MEF3 XX HW','TOKO','PM-F','F3E-ZCXG-269-0','GL XX TIFF SPECTRA VAR HW 8K ','','1.770','1','100.00','2097000','0','0','15000','2045000','0','0','0','2045000','LIS','00392705','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-269-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F3E-ZCXG-269-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140905241','2026-03-14','1.770','2026-03-14','09:05:24','PLG0027638','2045000','2045000','0','2045000','2045000','input','2026-03-14 09:05:24','F32614090524');
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-03-14','F326140905241','2026-03-14','09:05:24','LIS','2045000','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-260314-0004','D','2026-03-14','09:05:24','input','PENJUALAN','F326140905241','2988131000','2045000','2990176000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140905241' 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 ('F326140905242','input',' 1',' MEE2 X PM ','TOKO','PM-E','E2E-ZBXF-141-0','CC X MODEL MATA PM 12 8K ','','0.500','1','100.00','592000','0','0','15000','593000','0','0','0','593000','LIS','00388723','E2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBXF-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2E-ZBXF-141-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140905242','2026-03-14','0.500','2026-03-14','09:05:24','PLG0027639','593000','593000','0','593000','593000','input','2026-03-14 09:05:24','F32614090524');
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-03-14','F326140905242','2026-03-14','09:05:24','LIS','593000','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-260314-0005','D','2026-03-14','09:05:24','input','PENJUALAN','F326140905242','2990176000','593000','2990769000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140905242' 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 ('F326140949061','input','1',' MEE2 CM 10','TOKO','PM-E','E2E-ZCAX-182-0','CC MODEL MATA VAR CM 10 8K ','','0.450','1','100.00','533000','0','0','15000','535000','0','0','0','535000','AAT','00393154','E2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2E-ZCAX-182-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140949061','2026-03-14','0.450','2026-03-14','09:49:07','PLG0027640','535000','535000','0','535000','535000','input','2026-03-14 09:49:06','F32614094906');
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-03-14','F326140949061','2026-03-14','09:49:07','AAT','535000','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-260314-0006','D','2026-03-14','09:49:07','input','PENJUALAN','F326140949061','2990769000','535000','2991304000');
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 ('F326140950051','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZBXC-239-0','GL X OVAL C SLEP YT 52 8K ','','2.800','1','100.00','3318000','0','0','15000','3318000','0','0','0','3318000','AAT','00387918','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBXC-239-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F1E-ZBXC-239-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140950051','2026-03-14','2.800','2026-03-14','09:50:06','PLG0027641','3318000','3318000','0','3318000','3318000','input','2026-03-14 09:50:05','F32614095005');
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-03-14','F326140950051','2026-03-14','09:50:06','AAT','3318000','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-260314-0007','D','2026-03-14','09:50:06','input','PENJUALAN','F326140950051','2991304000','3318000','2994622000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3318000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140950051' 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 ('F326140950052','input',' 1',' MDE2 CM 10','TOKO','PM-E','E2D-ZCXE-127-0','CC MODEL KUPU MATA VAR CM 10 8K ','','0.830','1','100.00','967000','0','0','15000','967000','0','0','0','967000','AAT','00392228','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2D-ZCXE-127-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140950052','2026-03-14','0.830','2026-03-14','09:50:06','PLG0027642','967000','967000','0','967000','967000','input','2026-03-14 09:50:05','F32614095005');
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-03-14','F326140950052','2026-03-14','09:50:06','AAT','967000','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-260314-0008','D','2026-03-14','09:50:06','input','PENJUALAN','F326140950052','2994622000','967000','2995589000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='967000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140950052' 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 ('F326141053431','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-ZAXH-111-T','CC MODEL DAUN VAR CM 14 8K ','','0.970','1','100.00','1130000','0','0','15000','1130000','0','0','0','1130000','AAT','T0076434','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-111-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E1D-ZAXH-111-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141053431','2026-03-14','0.970','2026-03-14','10:53:43','PLG0027643','1130000','1130000','0','1130000','1130000','input','2026-03-14 10:53:43','F32614105343');
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-03-14','F326141053431','2026-03-14','10:53:43','AAT','1130000','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-260314-0009','D','2026-03-14','10:53:43','input','PENJUALAN','F326141053431','2995589000','1130000','2996719000');
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 ('F326141118081','input','1',' TEF1 X DW ','TOKO','PT-F','F1TE-XJAB-168-T','GL X ANAK SHOGUN SLEP DW D38 17K ','','2.980','1','100.00','6407000','0','0','15000','6408000','0','0','0','6408000','SIN','T0063029','F1TE','0','0','-','0','2150000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-XJAB-168-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F1TE-XJAB-168-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141118081','2026-03-14','2.980','2026-03-14','11:18:08','PLG0027644','6408000','6408000','0','6408000','6408000','input','2026-03-14 11:18:08','F32614111808');
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-03-14','F326141118081','2026-03-14','11:18:08','SIN','6408000','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-260314-0010','D','2026-03-14','11:18:08','input','PENJUALAN','F326141118081','2996719000','6408000','3003127000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6408000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141118081' 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 ('F326141118082','input',' 1',' TEF2 X LG ','TOKO','PT-F','F2TE-YFBF-148-T','GL X PIPA ANAK BONEKA CAT MATA LG D36 17K ','','2.600','1','100.00','5590000','0','0','15000','5590000','0','0','0','5590000','SIN','T0070515','F2TE','0','0','-','0','2150000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2TE-YFBF-148-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F2TE-YFBF-148-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141118082','2026-03-14','2.600','2026-03-14','11:18:08','PLG0027645','5590000','5590000','0','5590000','5590000','input','2026-03-14 11:18:08','F32614111808');
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-03-14','F326141118082','2026-03-14','11:18:08','SIN','5590000','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-260314-0011','D','2026-03-14','11:18:08','input','PENJUALAN','F326141118082','3003127000','5590000','3008717000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141118082' 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 ('F326141125401','input','1',' MEF1 YT 56','TOKO','PM-F','F1E-YLXI-5-T','GL OVAL MODEL C 56 YT 8K','','4.450','1','100.00','5273000','0','0','15000','5273000','0','0','0','5273000','LIS','T0075576','F1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLXI-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.450',berat_jual_asli=berat_jual_asli+'4.450',stock_jual='1',berat_akhir=berat_akhir-'4.450',berat_akhir_asli=berat_akhir_asli-'4.450',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='F1E-YLXI-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141125401','2026-03-14','4.450','2026-03-14','11:25:40','PLG0027646','5273000','5273000','0','5273000','5273000','input','2026-03-14 11:25:40','F32614112540');
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-03-14','F326141125401','2026-03-14','11:25:40','LIS','5273000','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-260314-0012','D','2026-03-14','11:25:40','input','PENJUALAN','F326141125401','3008717000','5273000','3013990000');
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 ('F326141207361','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCXB-340-0','KL X GUCCI UB 44 9K ','','2.920','1','100.00','3752000','0','0','15000','3752000','0','0','0','3752000','LIS','00391763','H2J','0','0','-','0','1285000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCXB-340-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='H2J-ZCXB-340-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141207361','2026-03-14','2.920','2026-03-14','12:07:36','PLG0027647','3752000','3752000','0','3752000','3752000','input','2026-03-14 12:07:36','F32614120736');
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-03-14','F326141207361','2026-03-14','12:07:36','LIS','3752000','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-260314-0013','D','2026-03-14','12:07:36','input','PENJUALAN','F326141207361','3013990000','3752000','3017742000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3752000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141207361' 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 ('F326141207362','input',' 1',' MDD2 UB ','TOKO','PM-D','D2D-YKAG-80-T','LT MODEL MATA VAR UB 8K ','','1.160','1','100.00','1351000','0','0','15000','1351000','0','0','0','1351000','LIS','T0075083','D2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YKAG-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='D2D-YKAG-80-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141207362','2026-03-14','1.160','2026-03-14','12:07:36','PLG0027648','1351000','1351000','0','1351000','1351000','input','2026-03-14 12:07:36','F32614120736');
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-03-14','F326141207362','2026-03-14','12:07:36','LIS','1351000','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-260314-0014','D','2026-03-14','12:07:36','input','PENJUALAN','F326141207362','3017742000','1351000','3019093000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141207362' 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 ('F326141218531','input','1',' MEH1 X HW ','TOKO','PM-H','H1E-ZCXG-212-0','KL X SANTA HW 42 8K ','','2.950','1','100.00','3496000','0','0','15000','3496000','0','0','0','3496000','AAT','00392648','H1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXG-212-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='H1E-ZCXG-212-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141218531','2026-03-14','2.950','2026-03-14','12:18:53','PLG0027649','3496000','3496000','0','3496000','3496000','input','2026-03-14 12:18:53','F32614121853');
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-03-14','F326141218531','2026-03-14','12:18:53','AAT','3496000','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-260314-0015','D','2026-03-14','12:18:53','input','PENJUALAN','F326141218531','3019093000','3496000','3022589000');
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 ('F326141219551','input','1',' MEE2 CM 12','TOKO','PM-E','E2E-ZAAC-270-0','CC MODEL HATI MATA CM 12 8K ','','0.700','1','100.00','829000','0','0','15000','830000','0','0','0','830000','SIN','00385177','E2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZAAC-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2E-ZAAC-270-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141219551','2026-03-14','0.700','2026-03-14','12:19:55','PLG0027650','830000','830000','0','830000','830000','input','2026-03-14 12:19:55','F32614121955');
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-03-14','F326141219551','2026-03-14','12:19:55','SIN','830000','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-260314-0016','D','2026-03-14','12:19:55','input','PENJUALAN','F326141219551','3022589000','830000','3023419000');
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 ('F326141224311','input','1',' MFA1 HW ','TOKO','PM-A','A1F-YKAE-150-0','AT MODEL HATI ARESO HW 8K ','','0.680','1','100.00','819000','0','0','15000','820000','0','0','0','820000','SIN','00377558','A1F','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YKAE-150-0' 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-03-14' AND kode_barang='A1F-YKAE-150-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141224311','2026-03-14','0.680','2026-03-14','12:24:31','PLG0027651','820000','820000','0','820000','820000','input','2026-03-14 12:24:31','F32614122431');
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-03-14','F326141224311','2026-03-14','12:24:31','SIN','820000','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-260314-0017','D','2026-03-14','12:24:31','input','PENJUALAN','F326141224311','3023419000','820000','3024239000');
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 ('F326141235451','input','1',' MGA1 LG ','TOKO','PM-A','A1G-ZCXG-322-0','AT TINDIK BABY MRICAN POLOS LG 8K ','','0.300','1','100.00','367000','0','0','15000','368000','0','0','0','368000','AAT','00392758','A1G','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZCXG-322-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-03-14' AND kode_barang='A1G-ZCXG-322-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141235451','2026-03-14','0.300','2026-03-14','12:35:45','PLG0027652','368000','368000','0','368000','368000','input','2026-03-14 12:35:45','F32614123545');
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-03-14','F326141235451','2026-03-14','12:35:45','AAT','368000','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-260314-0018','D','2026-03-14','12:35:45','input','PENJUALAN','F326141235451','3024239000','368000','3024607000');
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-00018458','X-00018458','CC COR M 8K','GR','---','E2E','BELI','BELI001','1727000','2026-03-14','2.430','1','kasir','2026-03-14 12:45:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018458','X-00018458');
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-260314-0001','F323010115561','SIN','1','BELI','BELI001','E2E', 'X-00018458', 'CC COR M 8K','2.430','2.430','100.00','1095000','1727000','710700','1195000','1','1727000','1727000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.430',berat_beli_asli=berat_beli_asli+'2.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.430',berat_akhir_asli=berat_akhir_asli+'2.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' 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-260314-0001','2026-03-14','2026-03-14','12:45:49','SIN','---','2.430','1727000','1727000','1727000','1727000','1727000','kasir','2026-03-14 12:45:50','FB-260314-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0001','FRENDY','MLARAK','','','','kasir','2026-03-14 12:45:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0019','K','2026-03-14','12:45:49','kasir','PEMBELIAN UMUM','FB-260314-0001','3024607000','1727000','3022880000');
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-00018459','X-00018459','CC COR M 8K','GR','---','E2E','BELI','BELI001','1520000','2026-03-14','2.160','1','kasir','2026-03-14 12:45:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018459','X-00018459');
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-260314-0002','F323010115562','SIN','2','BELI','BELI001','E2E', 'X-00018459', 'CC COR M 8K','2.160','2.160','100.00','975000','1520000','703704','1195000','1','1520000','1520000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.160',berat_beli_asli=berat_beli_asli+'2.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.160',berat_akhir_asli=berat_akhir_asli+'2.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' 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-260314-0002','2026-03-14','2026-03-14','12:45:49','SIN','---','2.160','1520000','1520000','1520000','1520000','1520000','kasir','2026-03-14 12:45:50','FB-260314-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0002','FRENDY','MLARAK','','','','kasir','2026-03-14 12:45:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0020','K','2026-03-14','12:45:49','kasir','PEMBELIAN UMUM','FB-260314-0002','3022880000','1520000','3021360000');
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 ('F326141248051','kasir','1',' MDE2 CM 18','TOKO','PM-E','E2D-ZCAX-523-0','CC WEDDING MATA CM 18 8K ','','1.080','1','100.00','1258000','0','0','15000','1258000','0','0','0','1258000','SIN','00393500','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-523-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2D-ZCAX-523-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141248051','2026-03-14','1.080','2026-03-14','12:48:06','PLG0027653','1258000','1258000','0','1258000','1258000','kasir','2026-03-14 12:48:05','F32614124805');
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-03-14','F326141248051','2026-03-14','12:48:06','SIN','1258000','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-260314-0021','D','2026-03-14','12:48:06','kasir','PENJUALAN','F326141248051','3021360000','1258000','3022618000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1258000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141248051' 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 ('F326141248052','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZCAA-158-0','CC WEDDING MATA CM 18 8K ','','1.080','1','100.00','1258000','0','0','15000','1258000','0','10000','0','1268000','SIN','00393660','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAA-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2D-ZCAA-158-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141248052','2026-03-14','1.080','2026-03-14','12:48:06','PLG0027654','1258000','1258000','10000','1268000','1268000','kasir','2026-03-14 12:48:05','F32614124805');
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-03-14','F326141248052','2026-03-14','12:48:06','SIN','1268000','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-260314-0022','D','2026-03-14','12:48:06','kasir','PENJUALAN','F326141248052','3022618000','1268000','3023886000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1268000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141248052' 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 ('F326141248053','kasir',' 1',' MDE1 CM 10','TOKO','PM-E','E1D-YIBI-155-0','CC MODEL DAUN VAR CM 10 8K ','','1.020','1','100.00','1188000','0','0','15000','1188000','0','0','0','1188000','SIN','00371026','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBI-155-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-03-14' AND kode_barang='E1D-YIBI-155-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141248053','2026-03-14','1.020','2026-03-14','12:48:06','PLG0027655','1188000','1188000','0','1188000','1188000','kasir','2026-03-14 12:48:05','F32614124805');
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-03-14','F326141248053','2026-03-14','12:48:06','SIN','1188000','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-260314-0023','D','2026-03-14','12:48:06','kasir','PENJUALAN','F326141248053','3023886000','1188000','3025074000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1188000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141248053' 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-00018460','X-00018460','AT MODEL MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','425000','2026-03-14','0.550','1','kasir','2026-03-14 12:49:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00018460','X-00018460');
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-260314-0003','F325211118091','FIT','1','BELI','BELI001','A1E', 'X-00018460', 'AT MODEL MATA VAR LG 8K','0.550','0.550','100.00','457000','425000','772727','1195000','1','425000','425000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260314-0003','2026-03-14','2026-03-14','12:49:30','FIT','---','0.550','425000','425000','425000','425000','425000','kasir','2026-03-14 12:49:30','FB-260314-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0003','ADARA','TALESAN PWO','','','','kasir','2026-03-14 12:49:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0024','K','2026-03-14','12:49:30','kasir','PEMBELIAN UMUM','FB-260314-0003','3025074000','425000','3024649000');
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-00018461','X-00018461','GW X TIFF MATA VAR LG 8K','GR','---','B1E','BELI','BELI001','700000','2026-03-14','0.630','1','kasir','2026-03-14 12:51:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00018461','X-00018461');
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-260314-0004','F326191140442','FIT','1','BELI','BELI001','B1E', 'X-00018461', 'GW X TIFF MATA VAR LG 8K','0.630','0.630','100.00','781000','700000','1111111','1195000','1','700000','700000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260314-0004','2026-03-14','2026-03-14','12:51:10','FIT','---','0.630','700000','700000','700000','700000','700000','kasir','2026-03-14 12:51:10','FB-260314-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0004','AJIS','SALAM BANDAR','','','082232171356','kasir','2026-03-14 12:51:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0025','K','2026-03-14','12:51:10','kasir','PEMBELIAN UMUM','FB-260314-0004','3024649000','700000','3023949000');
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 ('F326141252551','kasir','1',' MEE1 5K CM','TOKO','PM-E','E1E-ZCAB-186-0','CC PIPA KUKU MACAN SLEP CM 12 8K ','','0.560','1','100.00','664000','0','0','15000','665000','0','5000','0','670000','LIS','00393887','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAB-186-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-03-14' AND kode_barang='E1E-ZCAB-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141252551','2026-03-14','0.560','2026-03-14','12:52:55','PLG0027656','665000','665000','5000','670000','670000','kasir','2026-03-14 12:52:55','F32614125255');
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-03-14','F326141252551','2026-03-14','12:52:55','LIS','670000','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-260314-0026','D','2026-03-14','12:52:55','kasir','PENJUALAN','F326141252551','3023949000','670000','3024619000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='670000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141252551' 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 ('F326141252552','kasir',' 1',' MEA1E X LG','TOKO','PM-A','A1E-ZBAD-96-0','AT X BANGKOK KLIP SLEP LG 8K ','','0.550','1','100.00','652000','0','0','15000','653000','0','0','0','653000','LIS','00389702','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAD-96-0' 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-03-14' AND kode_barang='A1E-ZBAD-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326141252552','2026-03-14','0.550','2026-03-14','12:52:55','PLG0027657','653000','653000','0','653000','653000','kasir','2026-03-14 12:52:55','F32614125255');
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-03-14','F326141252552','2026-03-14','12:52:55','LIS','653000','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-260314-0027','D','2026-03-14','12:52:55','kasir','PENJUALAN','F326141252552','3024619000','653000','3025272000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='653000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141252552' 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-00018462','X-00018462','LT X SLOBOK HURUF BALOK BG N 8K','GR','---','D1F','BELI','BELI001','530000','2026-03-14','0.660','1','kasir','2026-03-14 12:53:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00018462','X-00018462');
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-260314-0005','F325121136351','FIT','1','BELI','BELI001','D1F', 'X-00018462', 'LT X SLOBOK HURUF BALOK BG N 8K','0.660','0.660','100.00','560000','530000','803030','1215000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.660',berat_beli_asli=berat_beli_asli+'0.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.660',berat_akhir_asli=berat_akhir_asli+'0.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260314-0005','2026-03-14','2026-03-14','12:53:33','FIT','---','0.660','530000','530000','530000','530000','530000','kasir','2026-03-14 12:53:34','FB-260314-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0005','LINA','BADEGAN','','','','kasir','2026-03-14 12:53:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0028','K','2026-03-14','12:53:33','kasir','PEMBELIAN UMUM','FB-260314-0005','3025272000','530000','3024742000');
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 ('F326140155101','kasir','1',' MEH1 HW 42','TOKO','PM-H','H1E-ZBAH-290-0','KL SANTA HATI VAR HW 42 8K ','','1.950','1','100.00','2311000','0','0','15000','2310000','0','0','0','2310000','AAT','00390667','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAH-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='H1E-ZBAH-290-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140155101','2026-03-14','1.950','2026-03-14','13:55:10','PLG0027658','2310000','2310000','0','2310000','2310000','kasir','2026-03-14 13:55:10','F32614015510');
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-03-14','F326140155101','2026-03-14','13:55:10','AAT','2310000','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-260314-0029','D','2026-03-14','13:55:10','kasir','PENJUALAN','F326140155101','3024742000','2310000','3027052000');
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 ('F326140224591','input','1',' MEE2 CM 12','TOKO','PM-E','E2E-YDXD-12-0','CC MODEL MATA CM 12 8K ','','0.710','1','100.00','841000','0','0','15000','840000','0','0','0','840000','FIT','00347905','E2E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YDXD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2E-YDXD-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140224591','2026-03-14','0.710','2026-03-14','14:24:59','PLG0027659','840000','840000','0','840000','840000','input','2026-03-14 14:24:59','F32614022459');
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-03-14','F326140224591','2026-03-14','14:24:59','FIT','840000','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-260314-0030','D','2026-03-14','14:24:59','input','PENJUALAN','F326140224591','3027052000','840000','3027892000');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260314-0001','1','E2D-ZAAI-3-0','TOKO','PM-E','CC MODEL MATA CM 18 8K ','1','2.320','PS MANUAL');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2026-03-14 14:30:03',status_delete='2.320' WHERE kode_barang='E2D-ZAAI-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-ZAAI-3-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAAI-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.320,berat_hancur_asli=berat_hancur_asli+2.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2D-ZAAI-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260314-0001','2','F3E-ZAAB-63-0','TOKO','PM-F','GL KREPYAK MODEL DAUN HW 8K ','1','3.120','RETUR');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2026-03-14 14:30:03',status_delete='3.120' WHERE kode_barang='F3E-ZAAB-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3E-ZAAB-63-0';
DELETE FROM tm_barang WHERE kode_barang='F3E-ZAAB-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.120,berat_hancur_asli=berat_hancur_asli+3.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F3E-ZAAB-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260314-0001','2026-03-14','irgosa','2026-03-14','14:30:03','irgosa','2026-03-14 14:30:03');
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-00018463','X-00018463','AT X MODEL MATA LG 8K','GR','---','A1E','BELI','BELI001','470000','2026-03-14','0.500','1','kasir','2026-03-14 14:37:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00018463','X-00018463');
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-260314-0006','F325090214351','FIT','1','BELI','BELI001','A1E', 'X-00018463', 'AT X MODEL MATA LG 8K','0.500','0.500','100.00','510000','470000','940000','1195000','1','470000','470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260314-0006','2026-03-14','2026-03-14','14:37:38','FIT','---','0.500','470000','470000','470000','470000','470000','kasir','2026-03-14 14:37:39','FB-260314-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260314-0006','EKA YULIA','SAMBITILENG PWO','','','0881010700629','kasir','2026-03-14 14:37:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-14' 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-260314-0031','K','2026-03-14','14:37:38','kasir','PEMBELIAN UMUM','FB-260314-0006','3027892000','470000','3027422000');
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 ('F326140242261','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCXB-72-0','CC X MODEL MATA CM 12 8K ','','0.810','1','100.00','944000','0','0','15000','945000','0','0','0','945000','FIT','00391495','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-03-14' AND kode_barang='E2D-ZCXB-72-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140242261','2026-03-14','0.810','2026-03-14','14:42:27','PLG0027660','945000','945000','0','945000','945000','kasir','2026-03-14 14:42:26','F32614024226');
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-03-14','F326140242261','2026-03-14','14:42:27','FIT','945000','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-260314-0032','D','2026-03-14','14:42:27','kasir','PENJUALAN','F326140242261','3027422000','945000','3028367000');
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 ('F326140249501','kasir','1',' MDA1D X LG','TOKO','PM-A','A1D-YJBB-230-0','AT X GYPSY SLEP LG 8K ','','1.000','1','100.00','1165000','0','0','15000','1165000','0','0','0','1165000','LIS','00374293','A1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJBB-230-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-03-14' AND kode_barang='A1D-YJBB-230-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326140249501','2026-03-14','1.000','2026-03-14','14:49:50','PLG0027661','1165000','1165000','0','1165000','1165000','kasir','2026-03-14 14:49:50','F32614024950');
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-03-14','F326140249501','2026-03-14','14:49:50','LIS','1165000','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-260314-0033','D','2026-03-14','14:49:50','kasir','PENJUALAN','F326140249501','3028367000','1165000','3029532000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260314-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260314-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140155101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140155101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140155101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140224591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140224591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140224591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140242261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140242261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140242261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140249501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140249501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140249501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140902051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140902052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140902052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140905241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140905241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140905241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140905242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140905242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140905242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140949061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140949061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140949061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140950051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140950051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140950051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140950052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140950052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140950052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141053431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141053431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141053431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141118081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141118081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141118081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141118082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141118082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141118082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141125401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141125401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141125401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141207361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141207361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141207361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141207362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141207362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141207362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141218531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141218531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141218531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141219551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141219551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141219551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141224311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141224311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141224311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141235451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141235451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141235451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141248051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141248052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248053' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141248053' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141248053';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141252551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141252551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141252551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141252552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141252552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141252552';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-14';
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-03-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-14' 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-260315-0001','D','2026-03-15','15:21:40','SYSTEM','SALDO AWAL','SALDO AWAL','0','3029532000','3029532000');
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-260315-0001','D','2026-03-15','15:21:40','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260315-0001','D','2026-03-15','15:21:40','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-260315-0001','D','2026-03-15','15:21:40','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-03-15';