INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260110-0001','1','E1D-ZAXH-70-T','1','1.010','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXH-70-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-ZAXH-70-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1D-ZAXH-70-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.010',berat_out_asli='1.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.010',berat_akhir_asli =berat_akhir_asli-'1.010' WHERE kode_barang='E1D-ZAXH-70-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260110-0001','2','E1D-ZAXH-71-T','1','1.030','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXH-71-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-ZAXH-71-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1D-ZAXH-71-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.030',berat_out_asli='1.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.030',berat_akhir_asli =berat_akhir_asli-'1.030' WHERE kode_barang='E1D-ZAXH-71-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260110-0001','3','E1D-ZAXH-72-T','1','1.030','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXH-72-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-ZAXH-72-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1D-ZAXH-72-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.030',berat_out_asli='1.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.030',berat_akhir_asli =berat_akhir_asli-'1.030' WHERE kode_barang='E1D-ZAXH-72-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260110-0001','4','E1D-ZAXH-73-T','1','0.980','TOKO','BK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXH-73-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E1D-ZAXH-73-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-E';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E1D-ZAXH-73-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.980',berat_out_asli='0.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.980',berat_akhir_asli =berat_akhir_asli-'0.980' WHERE kode_barang='E1D-ZAXH-73-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260110-0001','2026-01-10','2026-01-10','07:34','0.980','input','260110');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260110-0002','1','D2TE-YGBD-76-T','1','0.700','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2TE-YGBD-76-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2TE-YGBD-76-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='D2TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-D';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D2TE-YGBD-76-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.700',berat_out_asli='0.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.700',berat_akhir_asli =berat_akhir_asli-'0.700' WHERE kode_barang='D2TE-YGBD-76-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260110-0002','2026-01-10','2026-01-10','07:34','0.700','input','260110');
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-20260110-0001','1','H1E-YJCA-73-0','1','1.020','1.020','TOKO','SBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YJCA-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YJCA-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-01-10 07:37:26' WHERE kode_barang='H1E-YJCA-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YJCA-73-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-01-10 07:37:26','TOKO','SMBK-H','H1E','H1E-YJCA-73-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YJCA-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YJCA-73-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-20260110-0001','1','H1F-YKBB-60-0','1','1.020','1.020','TOKO','SBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-01-10 07:37:26' WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YKBB-60-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-01-10 07:37:26','TOKO','SMBK-H','H1F','H1F-YKBB-60-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YKBB-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YKBB-60-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','07:37','2.040','input','2026-01-10 07:37:25');
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-20260110-0001','1','A1D-ZAXI-249-0','1','0.800','0.800','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZAXI-249-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZAXI-249-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-01-10 07:39:27' WHERE kode_barang='A1D-ZAXI-249-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZAXI-249-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-01-10 07:39:27','TOKO','SMBK-A','A1D','A1D-ZAXI-249-0','1','0.800','0.800','1','0.800','0.800','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-ZAXI-249-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZAXI-249-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-20260110-0001','1','A1D-ZAXI-250-0','1','0.970','0.970','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZAXI-250-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZAXI-250-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-01-10 07:39:27' WHERE kode_barang='A1D-ZAXI-250-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZAXI-250-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-01-10 07:39:27','TOKO','SMBK-A','A1D','A1D-ZAXI-250-0','1','0.970','0.970','1','0.970','0.970','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-ZAXI-250-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZAXI-250-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','07:39','1.770','input','2026-01-10 07:39:26');
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-20260110-0001','1','D1E-ZAXI-267-0','1','0.430','0.430','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZAXI-267-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZAXI-267-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-01-10 07:39:41' WHERE kode_barang='D1E-ZAXI-267-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZAXI-267-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-01-10 07:39:41','TOKO','SMBK-D','D1E','D1E-ZAXI-267-0','1','0.430','0.430','1','0.430','0.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZAXI-267-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZAXI-267-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-20260110-0001','1','D1E-ZAXI-268-0','1','0.620','0.620','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZAXI-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZAXI-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-01-10 07:39:41' WHERE kode_barang='D1E-ZAXI-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZAXI-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-01-10 07:39:41','TOKO','SMBK-D','D1E','D1E-ZAXI-268-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZAXI-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZAXI-268-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','07:39','1.050','input','2026-01-10 07:39:40');
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-20260110-0001','1','E2D-ZAXI-393-0','1','1.520','1.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-393-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-393-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-393-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-393-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-393-0','1','1.520','1.520','1','1.520','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-393-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-393-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-20260110-0001','1','E2D-ZAXI-394-0','1','1.220','1.220','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-394-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-394-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-394-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-394-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-394-0','1','1.220','1.220','1','1.220','1.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-394-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-394-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-20260110-0001','1','E2D-ZAXI-395-0','1','0.960','0.960','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-395-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-395-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-395-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-395-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-395-0','1','0.960','0.960','1','0.960','0.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-395-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-395-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-20260110-0001','1','E2D-ZAXI-396-0','1','1.000','1.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-396-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-396-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-396-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-396-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-396-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-396-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-396-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-20260110-0001','1','E2E-ZAXI-397-0','1','0.750','0.750','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZAXI-397-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZAXI-397-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2E-ZAXI-397-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZAXI-397-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-01-10 07:39:56','TOKO','SMBK-E','E2E','E2E-ZAXI-397-0','1','0.750','0.750','1','0.750','0.750','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-ZAXI-397-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZAXI-397-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-20260110-0001','1','E2E-ZAXI-398-0','1','1.010','1.010','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZAXI-398-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZAXI-398-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2E-ZAXI-398-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZAXI-398-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-01-10 07:39:56','TOKO','SMBK-E','E2E','E2E-ZAXI-398-0','1','1.010','1.010','1','1.010','1.010','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-ZAXI-398-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZAXI-398-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-20260110-0001','1','E2D-ZAXI-399-0','1','0.800','0.800','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-399-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-399-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-399-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-399-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-399-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-399-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-399-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-20260110-0001','1','E2D-ZAXI-400-0','1','1.020','1.020','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-400-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-400-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-400-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-400-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-400-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-400-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-400-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-20260110-0001','1','E2D-ZAXI-401-0','1','0.770','0.770','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-401-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-401-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-401-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-401-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-401-0','1','0.770','0.770','1','0.770','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-401-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-401-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-20260110-0001','1','E2D-ZAXI-402-0','1','0.570','0.570','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZAXI-402-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-402-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E2D-ZAXI-402-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZAXI-402-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-01-10 07:39:56','TOKO','SMBK-E','E2D','E2D-ZAXI-402-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZAXI-402-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZAXI-402-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-20260110-0001','1','E1E-ZAXI-403-0','1','0.600','0.600','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZAXI-403-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZAXI-403-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-10 07:39:56' WHERE kode_barang='E1E-ZAXI-403-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZAXI-403-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-01-10 07:39:56','TOKO','SMBK-E','E1E','E1E-ZAXI-403-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZAXI-403-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZAXI-403-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','07:39','10.220','input','2026-01-10 07:39:55');
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 ('F226100847531','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YLBX-5-T','KL SIEM COBRA MATA VAR KH 42 8K ','OL','1.970','1','100.00','2157000','0','0','15000','2216000','0','10000','0','2226000','TIN','T0075990','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-YLBX-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100847531','2026-01-10','1.970','2026-01-10','08:47:54','PLG0076301','2216000','2216000','10000','2226000','2226000','kasir','2026-01-10 08:47:53','F22610084753');
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-01-10','F226100847531','2026-01-10','08:47:54','TIN','2226000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0002','D','2026-01-10','08:47:54','kasir','PENJUALAN','F226100847531','4681198000','2226000','4683424000');
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 ('F226100936111','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YCBA-20-T','GW TUSUK MODEL HATI VAR CM PE 8K ','','0.600','1','100.00','657000','0','0','15000','672000','0','0','0','672000','NS','T0068062','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YCBA-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='B1E-YCBA-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100936111','2026-01-10','0.600','2026-01-10','09:36:12','PLG0076302','672000','672000','0','672000','672000','kasir','2026-01-10 09:36:11','F22610093611');
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-01-10','F226100936111','2026-01-10','09:36:12','NS','672000','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-260110-0003','D','2026-01-10','09:36:12','kasir','PENJUALAN','F226100936111','4683424000','672000','4684096000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100936111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100936111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100936111';
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 ('F226101001001','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YLAF-105-0','AT X BANGKOK KLIP SLEP LG 8K ','','1.020','1','100.00','1096000','0','0','15000','1106000','0','0','0','1106000','NS','00381289','A1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAF-105-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-01-10' AND kode_barang='A1D-YLAF-105-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101001001','2026-01-10','1.020','2026-01-10','10:01:00','PLG0076303','1106000','1106000','0','1106000','1106000','kasir','2026-01-10 10:01:00','F22610100100');
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-01-10','F226101001001','2026-01-10','10:01:00','NS','1106000','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-260110-0004','D','2026-01-10','10:01:00','kasir','PENJUALAN','F226101001001','4684096000','1106000','4685202000');
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 ('F226101054251','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-15-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076338','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101054251','2026-01-10','0.200','2026-01-10','10:54:26','PLG0076304','236000','236000','5000','241000','241000','kasir','2026-01-10 10:54:25','F22610105425');
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-01-10','F226101054251','2026-01-10','10:54:26','NS','241000','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-260110-0005','D','2026-01-10','10:54:26','kasir','PENJUALAN','F226101054251','4685202000','241000','4685443000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101054251' 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 ('F226101054252','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-20-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076343','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101054252','2026-01-10','0.200','2026-01-10','10:54:26','PLG0076305','236000','236000','5000','241000','241000','kasir','2026-01-10 10:54:25','F22610105425');
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-01-10','F226101054252','2026-01-10','10:54:26','NS','241000','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-260110-0006','D','2026-01-10','10:54:26','kasir','PENJUALAN','F226101054252','4685443000','241000','4685684000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101054252' 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 ('F226101054253','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-25-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076348','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101054253','2026-01-10','0.200','2026-01-10','10:54:26','PLG0076306','236000','236000','5000','241000','241000','kasir','2026-01-10 10:54:25','F22610105425');
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-01-10','F226101054253','2026-01-10','10:54:26','NS','241000','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-260110-0007','D','2026-01-10','10:54:26','kasir','PENJUALAN','F226101054253','4685684000','241000','4685925000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101054253' 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 ('F226101054254','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-14-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076337','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101054254','2026-01-10','0.200','2026-01-10','10:54:26','PLG0076307','236000','236000','5000','241000','241000','kasir','2026-01-10 10:54:25','F22610105425');
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-01-10','F226101054254','2026-01-10','10:54:26','NS','241000','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-260110-0008','D','2026-01-10','10:54:26','kasir','PENJUALAN','F226101054254','4685925000','241000','4686166000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101054254' 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 ('F226101054255','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-12-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076335','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101054255','2026-01-10','0.200','2026-01-10','10:54:26','PLG0076308','236000','236000','5000','241000','241000','kasir','2026-01-10 10:54:25','F22610105425');
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-01-10','F226101054255','2026-01-10','10:54:26','NS','241000','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-260110-0009','D','2026-01-10','10:54:26','kasir','PENJUALAN','F226101054255','4686166000','241000','4686407000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101054255' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054255' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054255' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101054255';
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 ('F226101058301','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-26-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076349','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101058301','2026-01-10','0.200','2026-01-10','10:58:31','PLG0076309','236000','236000','5000','241000','241000','kasir','2026-01-10 10:58:30','F22610105830');
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-01-10','F226101058301','2026-01-10','10:58:31','NS','241000','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-260110-0010','D','2026-01-10','10:58:31','kasir','PENJUALAN','F226101058301','4686407000','241000','4686648000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101058301' 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 ('F226101058302','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-27-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076350','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101058302','2026-01-10','0.200','2026-01-10','10:58:31','PLG0076310','236000','236000','5000','241000','241000','kasir','2026-01-10 10:58:30','F22610105830');
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-01-10','F226101058302','2026-01-10','10:58:31','NS','241000','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-260110-0011','D','2026-01-10','10:58:31','kasir','PENJUALAN','F226101058302','4686648000','241000','4686889000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101058302' 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 ('F226101058303','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-18-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076341','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101058303','2026-01-10','0.200','2026-01-10','10:58:31','PLG0076311','236000','236000','5000','241000','241000','kasir','2026-01-10 10:58:30','F22610105830');
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-01-10','F226101058303','2026-01-10','10:58:31','NS','241000','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-260110-0012','D','2026-01-10','10:58:31','kasir','PENJUALAN','F226101058303','4686889000','241000','4687130000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101058303' 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 ('F226101058304','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-23-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076346','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101058304','2026-01-10','0.200','2026-01-10','10:58:31','PLG0076312','236000','236000','5000','241000','241000','kasir','2026-01-10 10:58:30','F22610105830');
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-01-10','F226101058304','2026-01-10','10:58:31','NS','241000','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-260110-0013','D','2026-01-10','10:58:31','kasir','PENJUALAN','F226101058304','4687130000','241000','4687371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101058304' 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 ('F226101058305','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-17-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076340','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101058305','2026-01-10','0.200','2026-01-10','10:58:31','PLG0076313','236000','236000','5000','241000','241000','kasir','2026-01-10 10:58:30','F22610105830');
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-01-10','F226101058305','2026-01-10','10:58:31','NS','241000','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-260110-0014','D','2026-01-10','10:58:31','kasir','PENJUALAN','F226101058305','4687371000','241000','4687612000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101058305' 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 ('F226101101361','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-19-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076342','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101101361','2026-01-10','0.200','2026-01-10','11:01:37','PLG0076314','236000','236000','5000','241000','241000','kasir','2026-01-10 11:01:36','F22610110136');
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-01-10','F226101101361','2026-01-10','11:01:37','NS','241000','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-260110-0015','D','2026-01-10','11:01:37','kasir','PENJUALAN','F226101101361','4687612000','241000','4687853000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101101361' 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 ('F226101101362','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-21-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076344','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101101362','2026-01-10','0.200','2026-01-10','11:01:37','PLG0076315','236000','236000','5000','241000','241000','kasir','2026-01-10 11:01:36','F22610110136');
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-01-10','F226101101362','2026-01-10','11:01:37','NS','241000','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-260110-0016','D','2026-01-10','11:01:37','kasir','PENJUALAN','F226101101362','4687853000','241000','4688094000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101101362' 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 ('F226101101363','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-16-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076339','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101101363','2026-01-10','0.200','2026-01-10','11:01:37','PLG0076316','236000','236000','5000','241000','241000','kasir','2026-01-10 11:01:36','F22610110136');
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-01-10','F226101101363','2026-01-10','11:01:37','NS','241000','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-260110-0017','D','2026-01-10','11:01:37','kasir','PENJUALAN','F226101101363','4688094000','241000','4688335000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101101363' 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 ('F226101101364','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-13-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076336','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101101364','2026-01-10','0.200','2026-01-10','11:01:37','PLG0076317','236000','236000','5000','241000','241000','kasir','2026-01-10 11:01:36','F22610110136');
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-01-10','F226101101364','2026-01-10','11:01:37','NS','241000','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-260110-0018','D','2026-01-10','11:01:37','kasir','PENJUALAN','F226101101364','4688335000','241000','4688576000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101101364' 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 ('F226101101365','kasir',' 1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZAXH-22-T','AS EXTENSION LG 8K ','OL','0.200','1','100.00','227000','0','0','15000','236000','0','5000','0','241000','NS','T0076345','S1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAXH-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='S1G-ZAXH-22-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101101365','2026-01-10','0.200','2026-01-10','11:01:37','PLG0076318','236000','236000','5000','241000','241000','kasir','2026-01-10 11:01:36','F22610110136');
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-01-10','F226101101365','2026-01-10','11:01:37','NS','241000','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-260110-0019','D','2026-01-10','11:01:37','kasir','PENJUALAN','F226101101365','4688576000','241000','4688817000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='241000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101101365' 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 ('F226101105281','kasir','1',' MFH1 UB 44','TOKO','SMBK-H','H1F-YKBB-60-0','KL KOREA SLEP UB 44 8K ','OL','1.020','1','100.00','1137000','0','0','15000','1158000','0','5000','0','1163000','NS','00378209','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YKBB-60-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-01-10' AND kode_barang='H1F-YKBB-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105281','2026-01-10','1.020','2026-01-10','11:05:29','PLG0076319','1158000','1158000','5000','1163000','1163000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105281','2026-01-10','11:05:29','NS','1163000','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-260110-0020','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105281','4688817000','1163000','4689980000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1163000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105281' 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 ('F226101105282','kasir',' 1',' MEH1 LT 40','TOKO','SMBK-H','H1E-YJCA-73-0','KL NORY LT 40 8K ','OL','1.020','1','100.00','1117000','0','0','15000','1137000','0','5000','0','1142000','NS','00375460','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCA-73-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-01-10' AND kode_barang='H1E-YJCA-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105282','2026-01-10','1.020','2026-01-10','11:05:29','PLG0076320','1137000','1137000','5000','1142000','1142000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105282','2026-01-10','11:05:29','NS','1142000','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-260110-0021','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105282','4689980000','1142000','4691122000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1142000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105282' 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 ('F226101105283','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YGXB-80-T','GL FANY POLOS HW 8K ','OL','1.150','1','100.00','1259000','0','0','15000','1282000','0','6000','0','1288000','NS','T0070660','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGXB-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-YGXB-80-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105283','2026-01-10','1.150','2026-01-10','11:05:29','PLG0076321','1282000','1282000','6000','1288000','1288000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105283','2026-01-10','11:05:29','NS','1288000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260110-0022','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105283','4691122000','1288000','4692410000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1288000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105283' 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 ('F226101105284','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YGXB-81-T','GL FANY POLOS HW 8K ','OL','1.130','1','100.00','1237000','0','0','15000','1260000','0','6000','0','1266000','NS','T0070661','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGXB-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-YGXB-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105284','2026-01-10','1.130','2026-01-10','11:05:29','PLG0076322','1260000','1260000','6000','1266000','1266000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105284','2026-01-10','11:05:29','NS','1266000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260110-0023','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105284','4692410000','1266000','4693676000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1266000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105284' 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 ('F226101105285','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YGXB-82-T','GL FANY POLOS HW 8K ','OL','1.170','1','100.00','1281000','0','0','15000','1304000','0','6000','0','1310000','NS','T0070662','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGXB-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-YGXB-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105285','2026-01-10','1.170','2026-01-10','11:05:29','PLG0076323','1304000','1304000','6000','1310000','1310000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105285','2026-01-10','11:05:29','NS','1310000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260110-0024','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105285','4693676000','1310000','4694986000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1310000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105285' 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 ('F226101105286','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F3E-YJXA-82-T','GL MODEL FANCY VAR KH 8K ','OL','1.600','1','100.00','1752000','0','0','15000','1785000','0','8000','0','1793000','NS','T0073574','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-YJXA-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105286','2026-01-10','1.600','2026-01-10','11:05:29','PLG0076324','1785000','1785000','8000','1793000','1793000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105286','2026-01-10','11:05:29','NS','1793000','8000');
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-260110-0025','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105286','4694986000','1793000','4696779000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1793000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105286' 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 ('F226101105287','kasir',' 1',' MEF3E X KH','TOKO','SMBK-F','F3E-YFAD-296-0','GL X CAPELLA SLEP KH 8K ','OL','2.070','1','100.00','2267000','0','0','15000','2308000','0','10000','0','2318000','NS','00357576','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFAD-296-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-YFAD-296-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105287','2026-01-10','2.070','2026-01-10','11:05:29','PLG0076325','2308000','2308000','10000','2318000','2318000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105287','2026-01-10','11:05:29','NS','2318000','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-260110-0026','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105287','4696779000','2318000','4699097000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2318000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105287' 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 ('F226101105288','kasir',' 1',' MFF3F X UB','TOKO','SMBK-F','F3F-XFAI-102-0','GL X FILLIGRE SLEP UB 8K ','OL','1.030','1','100.00','1148000','0','0','15000','1149000','0','5000','0','1154000','NS','00303196','F3F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-XFAI-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3F-XFAI-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101105288','2026-01-10','1.030','2026-01-10','11:05:29','PLG0076326','1149000','1149000','5000','1154000','1154000','kasir','2026-01-10 11:05:28','F22610110528');
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-01-10','F226101105288','2026-01-10','11:05:29','NS','1154000','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-260110-0027','D','2026-01-10','11:05:29','kasir','PENJUALAN','F226101105288','4699097000','1154000','4700251000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1154000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101105288' 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 ('F226101117121','kasir','1',' TDA1 X CM ','TOKO','TBK-A','A1TD-YIXD-47-T','AT X MODEL DAISY MATA CM 17K ','OL','1.000','1','100.00','1970000','0','0','15000','2005000','0','10000','0','2015000','RTA','T0072899','A1TD','0','0','-','0','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YIXD-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='A1TD-YIXD-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101117121','2026-01-10','1.000','2026-01-10','11:17:13','PLG0076327','2005000','2005000','10000','2015000','2015000','kasir','2026-01-10 11:17:12','F22610111712');
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-01-10','F226101117121','2026-01-10','11:17:13','RTA','2015000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0028','D','2026-01-10','11:17:13','kasir','PENJUALAN','F226101117121','4700251000','2015000','4702266000');
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 ('F226101121041','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZAXH-152-T','KL TRIXIE BUNGA CLOVER SLEP HW 8K ','OL','2.090','1','100.00','2289000','0','0','15000','2362000','0','10000','0','2372000','RTA','T0076475','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXH-152-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-ZAXH-152-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121041','2026-01-10','2.090','2026-01-10','11:21:05','PLG0076328','2362000','2362000','10000','2372000','2372000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121041','2026-01-10','11:21:05','RTA','2372000','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-260110-0029','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121041','4702266000','2372000','4704638000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2372000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121041' 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 ('F226101121042','kasir',' 1',' MEH1 UB 34','TOKO','SMBK-H','H1E-YKBH-74-T','KL ANAK GUCCI UB 34CM 8K','OL','1.070','1','100.00','1172000','0','0','15000','1209000','0','5000','0','1214000','RTA','T0075306','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBH-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-YKBH-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121042','2026-01-10','1.070','2026-01-10','11:21:05','PLG0076329','1209000','1209000','5000','1214000','1214000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121042','2026-01-10','11:21:05','RTA','1214000','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-260110-0030','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121042','4704638000','1214000','4705852000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1214000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121042' 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 ('F226101121043','kasir',' 1',' MEF3 20K H','TOKO','SMBK-F','F3E-ZAXI-39-T','GL BAMBU MRICAN ARESO VAR HW 8K ','OL','0.790','1','100.00','869000','0','0','15000','897000','0','25000','0','922000','RTA','T0076514','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXI-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.790',berat_jual_asli=berat_jual_asli+'0.790',stock_jual='1',berat_akhir=berat_akhir-'0.790',berat_akhir_asli=berat_akhir_asli-'0.790',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-ZAXI-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121043','2026-01-10','0.790','2026-01-10','11:21:05','PLG0076330','897000','897000','25000','922000','922000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121043','2026-01-10','11:21:05','RTA','922000','25000');
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-260110-0031','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121043','4705852000','922000','4706774000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='922000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121043' 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 ('F226101121044','kasir',' 1',' MEF3 YT ','TOKO','SMBK-F','F3E-ZAXG-13-T','GL MODEL PAPERLINA YT 8K ','OL','1.280','1','100.00','1402000','0','0','15000','1447000','0','6000','0','1453000','RTA','T0076304','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='F3E-ZAXG-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121044','2026-01-10','1.280','2026-01-10','11:21:05','PLG0076331','1447000','1447000','6000','1453000','1453000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121044','2026-01-10','11:21:05','RTA','1453000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260110-0032','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121044','4706774000','1453000','4708227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1453000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121044' 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 ('F226101121045','kasir',' 1',' MEE2 X YT ','TOKO','SMBK-E','E2E-YLCX-123-0','CC X MODEL MATA YT 14 8K ','OL','0.610','1','100.00','668000','0','0','15000','692000','0','5000','0','697000','RTA','00383528','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLCX-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E2E-YLCX-123-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121045','2026-01-10','0.610','2026-01-10','11:21:05','PLG0076332','692000','692000','5000','697000','697000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121045','2026-01-10','11:21:05','RTA','697000','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-260110-0033','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121045','4708227000','697000','4708924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='697000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121045' 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 ('F226101121046','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZAXH-37-T','CC MODEL MATA VAR CM 14 8K ','OL','0.610','1','100.00','668000','0','0','15000','692000','0','5000','0','697000','RTA','T0076360','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZAXH-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E2E-ZAXH-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121046','2026-01-10','0.610','2026-01-10','11:21:05','PLG0076333','692000','692000','5000','697000','697000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121046','2026-01-10','11:21:05','RTA','697000','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-260110-0034','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121046','4708924000','697000','4709621000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='697000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121046' 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 ('F226101121047','kasir',' 1',' MEE2E HT 1','TOKO','SMBK-E','E2E-YLBX-34-T','CC BANGKOK MATA SLEP HT 14 8K ','OL','0.520','1','100.00','569000','0','0','15000','590000','0','5000','0','595000','RTA','T0076019','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLBX-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E2E-YLBX-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121047','2026-01-10','0.520','2026-01-10','11:21:05','PLG0076334','590000','590000','5000','595000','595000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121047','2026-01-10','11:21:05','RTA','595000','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-260110-0035','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121047','4709621000','595000','4710216000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121047' 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 ('F226101121048','kasir',' 1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZAXH-60-T','CC MODEL DAUN CM 14 8K ','OL','0.970','1','100.00','1043000','0','0','15000','1082000','0','5000','0','1087000','RTA','T0076383','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-60-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-01-10' AND kode_barang='E1D-ZAXH-60-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101121048','2026-01-10','0.970','2026-01-10','11:21:05','PLG0076335','1082000','1082000','5000','1087000','1087000','kasir','2026-01-10 11:21:04','F22610112104');
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-01-10','F226101121048','2026-01-10','11:21:05','RTA','1087000','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-260110-0036','D','2026-01-10','11:21:05','kasir','PENJUALAN','F226101121048','4710216000','1087000','4711303000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1087000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101121048' 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 ('F226101123031','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZAXH-59-T','CC MODEL DAUN CM 16 8K ','OL','1.010','1','100.00','1086000','0','0','15000','1121000','0','5000','0','1126000','RTA','T0076382','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101123031','2026-01-10','1.010','2026-01-10','11:23:04','PLG0076336','1121000','1121000','5000','1126000','1126000','kasir','2026-01-10 11:23:03','F22610112303');
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-01-10','F226101123031','2026-01-10','11:23:04','RTA','1126000','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-260110-0037','D','2026-01-10','11:23:04','kasir','PENJUALAN','F226101123031','4711303000','1126000','4712429000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1126000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101123031' 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 ('F226101123032','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-YFAF-48-T','LT MODEL PITA CAT VAR LG 8K ','OL','0.560','1','100.00','613000','0','0','15000','636000','0','5000','0','641000','RTA','T0070184','D1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YFAF-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1E-YFAF-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101123032','2026-01-10','0.560','2026-01-10','11:23:04','PLG0076337','636000','636000','5000','641000','641000','kasir','2026-01-10 11:23:03','F22610112303');
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-01-10','F226101123032','2026-01-10','11:23:04','RTA','641000','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-260110-0038','D','2026-01-10','11:23:04','kasir','PENJUALAN','F226101123032','4712429000','641000','4713070000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='641000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101123032' 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 ('F226101123033','kasir',' 1',' MDD1 CM ','TOKO','SMBK-D','D1D-ZAXH-149-T','LT MODEL DAUN VAR CM 8K ','OL','1.130','1','100.00','1215000','0','0','15000','1254000','0','6000','0','1260000','RTA','T0076472','D1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZAXH-149-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1D-ZAXH-149-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101123033','2026-01-10','1.130','2026-01-10','11:23:04','PLG0076338','1254000','1254000','6000','1260000','1260000','kasir','2026-01-10 11:23:03','F22610112303');
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-01-10','F226101123033','2026-01-10','11:23:04','RTA','1260000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260110-0039','D','2026-01-10','11:23:04','kasir','PENJUALAN','F226101123033','4713070000','1260000','4714330000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101123033' 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 ('F226101125221','kasir','1',' MDD2 X CM ','TOKO','SMBK-D','D2D-YHAI-164-0','LT X MODEL MATA CM 8K ','','0.920','1','100.00','989000','0','0','15000','1012000','0','0','0','1012000','RHM','00366195','D2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YHAI-164-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D2D-YHAI-164-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101125221','2026-01-10','0.920','2026-01-10','11:25:22','PLG0076339','1012000','1012000','0','1012000','1012000','kasir','2026-01-10 11:25:22','F22610112522');
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-01-10','F226101125221','2026-01-10','11:25:22','RHM','1012000','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-260110-0040','D','2026-01-10','11:25:22','kasir','PENJUALAN','F226101125221','4714330000','1012000','4715342000');
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 ('F226101128231','kasir','1',' MDE1 CM 15','TOKO','SMBK-E','E1D-ZAXH-100-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL','0.780','1','100.00','838000','0','0','15000','866000','0','5000','0','871000','TIN','T0076423','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-100-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-100-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101128231','2026-01-10','0.780','2026-01-10','11:28:24','PLG0076340','866000','866000','5000','871000','871000','kasir','2026-01-10 11:28:23','F22610112823');
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-01-10','F226101128231','2026-01-10','11:28:24','TIN','871000','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-260110-0041','D','2026-01-10','11:28:24','kasir','PENJUALAN','F226101128231','4715342000','871000','4716213000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='871000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101128231' 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 ('F226101128232','kasir',' 1',' MDE1 CM 13','TOKO','SMBK-E','E1D-ZAXH-94-T','CC MODEL PITA PASIR VAR CM 13 8K ','OL','0.870','1','100.00','935000','0','0','15000','966000','0','5000','0','971000','TIN','T0076417','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101128232','2026-01-10','0.870','2026-01-10','11:28:24','PLG0076341','966000','966000','5000','971000','971000','kasir','2026-01-10 11:28:23','F22610112823');
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-01-10','F226101128232','2026-01-10','11:28:24','TIN','971000','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-260110-0042','D','2026-01-10','11:28:24','kasir','PENJUALAN','F226101128232','4716213000','971000','4717184000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='971000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101128232' 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 ('F226101128233','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZAXI-20-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL','0.850','1','100.00','918000','0','0','15000','944000','0','5000','0','949000','TIN','T0076495','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXI-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXI-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101128233','2026-01-10','0.850','2026-01-10','11:28:24','PLG0076342','944000','944000','5000','949000','949000','kasir','2026-01-10 11:28:23','F22610112823');
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-01-10','F226101128233','2026-01-10','11:28:24','TIN','949000','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-260110-0043','D','2026-01-10','11:28:24','kasir','PENJUALAN','F226101128233','4717184000','949000','4718133000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='949000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101128233' 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 ('F226101148011','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZAXI-7-T','CC MODEL PITA PASIR VAR CM 11 8K ','','0.870','1','100.00','957000','0','0','15000','974000','0','5000','0','979000','RHM','T0076482','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZAXI-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1E-ZAXI-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101148011','2026-01-10','0.870','2026-01-10','11:48:02','PLG0076343','974000','974000','5000','979000','979000','kasir','2026-01-10 11:48:01','F22610114801');
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-01-10','F226101148011','2026-01-10','11:48:02','RHM','979000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0044','D','2026-01-10','11:48:02','kasir','PENJUALAN','F226101148011','4718133000','979000','4719112000');
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 ('F226101152221','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-YLAX-71-T','KL GUCI 40CM UB 8K ','','1.130','1','100.00','1237000','0','0','15000','1266000','0','0','0','1266000','TIN','T0075655','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAX-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-YLAX-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101152221','2026-01-10','1.130','2026-01-10','11:52:23','PLG0076344','1266000','1266000','0','1266000','1266000','kasir','2026-01-10 11:52:22','F22610115222');
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-01-10','F226101152221','2026-01-10','11:52:23','TIN','1266000','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-260110-0045','D','2026-01-10','11:52:23','kasir','PENJUALAN','F226101152221','4719112000','1266000','4720378000');
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 ('F226101209451','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLXD-55-T','LT SLOBOK BALOK HURUF D BG 8K ','OL','0.550','1','100.00','613000','0','0','15000','635000','0','5000','0','640000','TIN','T0075523','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXD-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1F-YLXD-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209451','2026-01-10','0.550','2026-01-10','12:09:45','PLG0076345','635000','635000','5000','640000','640000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209451','2026-01-10','12:09:45','TIN','640000','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-260110-0046','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209451','4720378000','640000','4721018000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='640000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209451' 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 ('F226101209452','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLAX-15-T','LT SLOBOK BALOK HURUF H BG 8K ','OL','0.640','1','100.00','714000','0','0','15000','739000','0','5000','0','744000','TIN','T0075599','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAX-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1F-YLAX-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209452','2026-01-10','0.640','2026-01-10','12:09:45','PLG0076346','739000','739000','5000','744000','744000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209452','2026-01-10','12:09:45','TIN','744000','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-260110-0047','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209452','4721018000','744000','4721762000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='744000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209452' 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 ('F226101209453','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLAX-14-T','LT SLOBOK BALOK HURUF H BG 8K ','OL','0.660','1','100.00','736000','0','0','15000','762000','0','5000','0','767000','TIN','T0075598','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAX-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1F-YLAX-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209453','2026-01-10','0.660','2026-01-10','12:09:45','PLG0076347','762000','762000','5000','767000','767000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209453','2026-01-10','12:09:45','TIN','767000','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-260110-0048','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209453','4721762000','767000','4722529000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='767000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209453' 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 ('F226101209454','kasir',' 1',' MDE1 CM 11','TOKO','SMBK-E','E1D-ZAXH-83-T','CC MODEL PITA PASIR VAR CM 11 8K ','OL','0.780','1','100.00','838000','0','0','15000','870000','0','5000','0','875000','TIN','T0076406','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-83-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209454','2026-01-10','0.780','2026-01-10','12:09:45','PLG0076348','870000','870000','5000','875000','875000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209454','2026-01-10','12:09:45','TIN','875000','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-260110-0049','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209454','4722529000','875000','4723404000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209454' 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 ('F226101209455','kasir',' 1',' MDE1 CM 13','TOKO','SMBK-E','E1D-ZAXH-98-T','CC MODEL PITA PASIR VAR CM 13 8K ','OL','0.960','1','100.00','1032000','0','0','15000','1070000','0','5000','0','1075000','TIN','T0076421','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209455','2026-01-10','0.960','2026-01-10','12:09:45','PLG0076349','1070000','1070000','5000','1075000','1075000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209455','2026-01-10','12:09:45','TIN','1075000','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-260110-0050','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209455','4723404000','1075000','4724479000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1075000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209455' 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 ('F226101209456','kasir',' 1',' MDE1 CM 15','TOKO','SMBK-E','E1D-ZAXH-105-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL','1.000','1','100.00','1075000','0','0','15000','1110000','0','5000','0','1115000','TIN','T0076428','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-105-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209456','2026-01-10','1.000','2026-01-10','12:09:45','PLG0076350','1110000','1110000','5000','1115000','1115000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209456','2026-01-10','12:09:45','TIN','1115000','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-260110-0051','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209456','4724479000','1115000','4725594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1115000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209456' 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 ('F226101209457','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-YLCA-266-0','CC WEDDING MATA CM 16 8K ','OL','2.050','1','100.00','2204000','0','0','15000','2276000','0','10000','0','2286000','TIN','00383897','E2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLCA-266-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E2D-YLCA-266-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101209457','2026-01-10','2.050','2026-01-10','12:09:45','PLG0076351','2276000','2276000','10000','2286000','2286000','kasir','2026-01-10 12:09:45','F22610120945');
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-01-10','F226101209457','2026-01-10','12:09:45','TIN','2286000','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-260110-0052','D','2026-01-10','12:09:45','kasir','PENJUALAN','F226101209457','4725594000','2286000','4727880000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2286000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226101209457' 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 ('F226101211161','kasir','1',' MFH1 X AY ','TOKO','SMBK-H','H1F-ZAXH-286-0','KL X TRIXIE NAGITA HURUF AY S 8K ','OL','2.240','1','100.00','2509000','0','0','15000','2556000','0','20000','0','2576000','NS','00384372','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-ZAXH-286-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1F-ZAXH-286-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101211161','2026-01-10','2.240','2026-01-10','12:11:17','PLG0076352','2556000','2556000','20000','2576000','2576000','kasir','2026-01-10 12:11:16','F22610121116');
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-01-10','F226101211161','2026-01-10','12:11:17','NS','2576000','20000');
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-260110-0053','D','2026-01-10','12:11:17','kasir','PENJUALAN','F226101211161','4727880000','2576000','4730456000');
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 ('F226101211441','kasir','1',' MEE1 LG 9 ','TOKO','SMBK-E','E1E-ZAXH-43-T','CC MODEL DAUN LG 9 8K ','OL','0.430','1','100.00','471000','0','0','15000','480000','0','5000','0','485000','NS','T0076366','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZAXH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1E-ZAXH-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226101211441','2026-01-10','0.430','2026-01-10','12:11:45','PLG0076353','480000','480000','5000','485000','485000','kasir','2026-01-10 12:11:44','F22610121144');
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-01-10','F226101211441','2026-01-10','12:11:45','NS','485000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0054','D','2026-01-10','12:11:45','kasir','PENJUALAN','F226101211441','4730456000','485000','4730941000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100847531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100847531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100847531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101001001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101001001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101001001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101054251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101054252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054253' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054253' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101054253';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054254' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101054254' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101054254';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101058301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101058302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058303' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058303' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101058303';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058304' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058304' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101058304';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058305' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101058305' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101058305';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101101361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101101362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101101363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101101364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101365' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101101365' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101101365';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105284' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105284' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105284';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105285' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105285' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105285';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105286' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105286' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105286';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105287' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105287' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105287';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105288' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101105288' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101105288';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101117121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101117121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101117121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121044' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121044' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121044';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121045' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121045' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121045';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121046' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121046' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121046';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121047' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121047' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121047';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121048' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101121048' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101121048';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101123031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101123032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101123033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101123033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101125221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101125221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101125221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101128231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101128232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128233' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101128233' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101128233';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101148011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101148011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101148011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101152221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101152221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101152221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209454' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209454' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209454';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209455' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209455' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209455';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209456' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209456' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209456';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209457' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101209457' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101209457';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101211161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101211161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101211161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226101211441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226101211441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226101211441';
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 ('F226100102301','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZAXI-395-0','CC X MODEL MATA CM 12 8K ','OL','0.960','1','100.00','1042000','0','0','15000','1066000','0','5000','0','1071000','NS','00384772','E2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAXI-395-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E2D-ZAXI-395-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100102301','2026-01-10','0.960','2026-01-10','13:02:30','PLG0076354','1066000','1066000','5000','1071000','1071000','kasir','2026-01-10 13:02:30','F22610010230');
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-01-10','F226100102301','2026-01-10','13:02:30','NS','1071000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0055','D','2026-01-10','13:02:30','kasir','PENJUALAN','F226100102301','4730941000','1071000','4732012000');
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 ('F226100104551','kasir','1',' MEA1E CM ','TOKO','SMBK-A','A1E-YLBX-54-T','AT MODEL ARESO VAR CM 8K ','','0.650','1','100.00','712000','0','0','15000','728000','0','0','0','728000','RHM','T0076039','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBX-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='A1E-YLBX-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100104551','2026-01-10','0.650','2026-01-10','13:04:56','PLG0076355','728000','728000','0','728000','728000','kasir','2026-01-10 13:04:55','F22610010455');
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-01-10','F226100104551','2026-01-10','13:04:56','RHM','728000','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-260110-0056','D','2026-01-10','13:04:56','kasir','PENJUALAN','F226100104551','4732012000','728000','4732740000');
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 ('F226100110461','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-YLAX-7-T','LT SLOBOK LOVE LG 8K','','0.260','1','100.00','295000','0','0','15000','302000','0','0','0','302000','TIN','T0075591','D1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YLAX-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='D1G-YLAX-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100110461','2026-01-10','0.260','2026-01-10','13:10:46','PLG0076356','302000','302000','0','302000','302000','kasir','2026-01-10 13:10:46','F22610011046');
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-01-10','F226100110461','2026-01-10','13:10:46','TIN','302000','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-260110-0057','D','2026-01-10','13:10:46','kasir','PENJUALAN','F226100110461','4732740000','302000','4733042000');
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 ('F226100114421','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZAXI-45-T','KL KOREA UB 42CM 8K ','OL','0.970','1','100.00','1067000','0','0','15000','1102000','0','5000','0','1107000','NS','T0076520','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXI-45-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-01-10' AND kode_barang='H1E-ZAXI-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100114421','2026-01-10','0.970','2026-01-10','13:14:42','PLG0076357','1102000','1102000','5000','1107000','1107000','kasir','2026-01-10 13:14:42','F22610011442');
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-01-10','F226100114421','2026-01-10','13:14:42','NS','1107000','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-260110-0058','D','2026-01-10','13:14:42','kasir','PENJUALAN','F226100114421','4733042000','1107000','4734149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100114421' 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 ('F226100114422','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZAXI-44-T','KL KOREA UB 42CM 8K ','OL','0.950','1','100.00','1045000','0','0','15000','1078000','0','5000','0','1083000','NS','T0076519','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXI-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-ZAXI-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100114422','2026-01-10','0.950','2026-01-10','13:14:42','PLG0076358','1078000','1078000','5000','1083000','1083000','kasir','2026-01-10 13:14:42','F22610011442');
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-01-10','F226100114422','2026-01-10','13:14:42','NS','1083000','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-260110-0059','D','2026-01-10','13:14:42','kasir','PENJUALAN','F226100114422','4734149000','1083000','4735232000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1083000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100114422' 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 ('F226100114423','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZAXI-42-T','KL KOREA UB 45CM 8K ','OL','1.010','1','100.00','1111000','0','0','15000','1141000','0','5000','0','1146000','NS','T0076517','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXI-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-ZAXI-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100114423','2026-01-10','1.010','2026-01-10','13:14:42','PLG0076359','1141000','1141000','5000','1146000','1146000','kasir','2026-01-10 13:14:42','F22610011442');
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-01-10','F226100114423','2026-01-10','13:14:42','NS','1146000','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-260110-0060','D','2026-01-10','13:14:42','kasir','PENJUALAN','F226100114423','4735232000','1146000','4736378000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1146000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100114423' 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 ('F226100114424','kasir',' 1',' MFH1 KH 44','TOKO','SMBK-H','H1F-YIBI-99-T','KL KOREA KH 44CM 8K ','OL','2.060','1','100.00','2297000','0','0','15000','2370000','0','10000','0','2380000','NS','T0073412','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIBI-99-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1F-YIBI-99-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100114424','2026-01-10','2.060','2026-01-10','13:14:42','PLG0076360','2370000','2370000','10000','2380000','2380000','kasir','2026-01-10 13:14:42','F22610011442');
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-01-10','F226100114424','2026-01-10','13:14:42','NS','2380000','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-260110-0061','D','2026-01-10','13:14:42','kasir','PENJUALAN','F226100114424','4736378000','2380000','4738758000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100114424' 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 ('F226100114425','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZAXI-43-T','KL KOREA UB 42CM 8K ','OL','1.000','1','100.00','1100000','0','0','15000','1130000','0','5000','0','1135000','NS','T0076518','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXI-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1E-ZAXI-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100114425','2026-01-10','1.000','2026-01-10','13:14:42','PLG0076361','1130000','1130000','5000','1135000','1135000','kasir','2026-01-10 13:14:42','F22610011442');
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-01-10','F226100114425','2026-01-10','13:14:42','NS','1135000','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-260110-0062','D','2026-01-10','13:14:42','kasir','PENJUALAN','F226100114425','4738758000','1135000','4739893000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1135000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226100114425' 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 ('F226100159151','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZAXH-52-T','CC MODEL DAUN CM 16 8K ','','0.920','1','100.00','989000','0','0','15000','1012000','0','0','0','1012000','RTA','T0076375','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='E1D-ZAXH-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100159151','2026-01-10','0.920','2026-01-10','13:59:16','PLG0076362','1012000','1012000','0','1012000','1012000','kasir','2026-01-10 13:59:15','F22610015915');
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-01-10','F226100159151','2026-01-10','13:59:16','RTA','1012000','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-260110-0063','D','2026-01-10','13:59:16','kasir','PENJUALAN','F226100159151','4739893000','1012000','4740905000');
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-00005003','X-00005003','AT X KLIP BANGKOK SLEP LG 17K','GR','---','A1TD','BELI','BELI001','1700000','2026-01-10','1.050','1','kasir','2026-01-10 14:28:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TD';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TD','X-00005003','X-00005003');
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-260110-0001','F225100927281','TIN','1','BELI','BELI001','A1TD', 'X-00005003', 'AT X KLIP BANGKOK SLEP LG 17K','1.050','1.050','100.00','1890000','1700000','1619048','1970000','1','1700000','1700000','CUCI');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-10','BELI','BELI001','A1TD','X-00005003','100.00','1.050','1.050','1','1.050','1.050','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-260110-0001','2026-01-10','2026-01-10','14:28:43','TIN','---','1.050','1700000','1700000','1700000','1700000','1700000','kasir','2026-01-10 14:28:44','FB-260110-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0001','BU ANIS','DSN. KANTAN II BABADAN','','','','kasir','2026-01-10 14:28:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260110-0064','K','2026-01-10','14:28:43','kasir','PEMBELIAN UMUM','FB-260110-0001','4740905000','1700000','4739205000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100102301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100102301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100102301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100104551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100104551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100104551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100110461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100110461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100110461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100114421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100114422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100114423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114424' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114424' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100114424';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114425' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100114425' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100114425';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100159151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100159151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100159151';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0001';
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 ('F226100301381','kasir','1',' MFH1 UB 32','TOKO','SMBK-H','H1F-YKBH-78-T','KL ANAK MILANO UB 32CM 8K ','','2.040','1','100.00','2275000','0','0','15000','2326000','0','0','0','2326000','RTA','T0075310','H1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YKBH-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='H1F-YKBH-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226100301381','2026-01-10','2.040','2026-01-10','15:01:39','PLG0076363','2326000','2326000','0','2326000','2326000','kasir','2026-01-10 15:01:38','F22610030138');
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-01-10','F226100301381','2026-01-10','15:01:39','RTA','2326000','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-260110-0065','D','2026-01-10','15:01:39','kasir','PENJUALAN','F226100301381','4739205000','2326000','4741531000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
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-00005004','X-00005004','GL RG ELZETRA UB','GR','---','F3TG','BELI','BELI001','4257000','2026-01-10','2.580','1','kasir','2026-01-10 15:15:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TG','X-00005004','X-00005004');
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-260110-0002','F223131056431','NS','1','BELI','BELI001','F3TG', 'X-00005004', 'GL RG ELZETRA UB','2.690','2.580','100.00','2139000','4257000','1650000','2030000','1','4257000','4257000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.580',berat_beli_asli=berat_beli_asli+'2.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.580',berat_akhir_asli=berat_akhir_asli+'2.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TG' 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-260110-0002','2026-01-10','2026-01-10','15:15:53','NS','---','2.580','4257000','4257000','4257000','4257000','4257000','kasir','2026-01-10 15:15:54','FB-260110-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0002','PUTRA KEMBAR','JINGGLONG','','','','kasir','2026-01-10 15:15:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260110-0066','K','2026-01-10','15:15:53','kasir','PEMBELIAN UMUM','FB-260110-0002','4741531000','4257000','4737274000');
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-00005005','X-00005005','GL X BLACKGOLD ELZETRA UB 17K','GR','---','F1TG','BELI','BELI001','4224000','2026-01-10','2.560','1','kasir','2026-01-10 15:15:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TG','X-00005005','X-00005005');
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-260110-0003','F224201031451','NS','2','BELI','BELI001','F1TG', 'X-00005005', 'GL X BLACKGOLD ELZETRA UB 17K','2.670','2.560','100.00','2897000','4224000','1650000','2030000','1','4224000','4224000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.560',berat_beli_asli=berat_beli_asli+'2.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.560',berat_akhir_asli=berat_akhir_asli+'2.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TG' 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-260110-0003','2026-01-10','2026-01-10','15:15:53','NS','---','2.560','4224000','4224000','4224000','4224000','4224000','kasir','2026-01-10 15:15:54','FB-260110-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0003','PUTRA KEMBAR','JL TELUTUR NO 36','','','','kasir','2026-01-10 15:15:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260110-0067','K','2026-01-10','15:15:53','kasir','PEMBELIAN UMUM','FB-260110-0003','4737274000','4224000','4733050000');
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-00005006','X-00005006','CC X MODEL SOLITAIRE MATA VAR UB 14','GR','---','E2TE','BELI','BELI001','3828000','2026-01-10','2.320','1','kasir','2026-01-10 15:15:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00005006','X-00005006');
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-260110-0004','F224131009441','NS','3','BELI','BELI001','E2TE', 'X-00005006', 'CC X MODEL SOLITAIRE MATA VAR UB 14','3.710','2.320','100.00','3791000','3828000','1650000','1990000','1','3828000','3828000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.320',berat_beli_asli=berat_beli_asli+'2.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.320',berat_akhir_asli=berat_akhir_asli+'2.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260110-0004','2026-01-10','2026-01-10','15:15:53','NS','---','2.320','3828000','3828000','3828000','3828000','3828000','kasir','2026-01-10 15:15:54','FB-260110-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0004','PUTRA KEMBAR','JINGGLONG','','','','kasir','2026-01-10 15:15:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260110-0068','K','2026-01-10','15:15:53','kasir','PEMBELIAN UMUM','FB-260110-0004','4733050000','3828000','4729222000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226100301381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226100301381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226100301381';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-10';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-10' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260111-0001','D','2026-01-11','16:04:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','4729222000','4729222000');
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-260111-0001','D','2026-01-11','16:04:14','BCA','SALDO AWAL','SALDO AWAL','0','4231741888','4231741888');
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-260111-0001','D','2026-01-11','16:04:14','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260111-0001','D','2026-01-11','16:04:14','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260111-0001','D','2026-01-11','16:04:14','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-260111-0001','D','2026-01-11','16:04:14','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-01-11';