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-20260326-0001','1','E2D-ZCBE-243-0','1','1.070','1.070','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCBE-243-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCBE-243-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-26 08:01:53' WHERE kode_barang='E2D-ZCBE-243-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCBE-243-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:01:53','TOKO','SMBK-E','E2D','E2D-ZCBE-243-0','1','1.070','1.070','1','1.070','1.070','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-ZCBE-243-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCBE-243-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-20260326-0001','1','E1D-ZCBE-244-0','1','0.900','0.900','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCBE-244-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCBE-244-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-26 08:01:53' WHERE kode_barang='E1D-ZCBE-244-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCBE-244-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:01:53','TOKO','SMBK-E','E1D','E1D-ZCBE-244-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZCBE-244-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCBE-244-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-20260326-0001','1','E1D-ZCBE-245-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCBE-245-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCBE-245-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-26 08:01:53' WHERE kode_barang='E1D-ZCBE-245-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCBE-245-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:01:53','TOKO','SMBK-E','E1D','E1D-ZCBE-245-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZCBE-245-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCBE-245-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260326-0001','2026-03-26','08:01','3.020','input','2026-03-26 08:01:53');
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-20260326-0001','1','F3E-ZCBE-246-0','1','1.320','1.320','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCBE-246-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-246-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-26 08:02:28' WHERE kode_barang='F3E-ZCBE-246-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCBE-246-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:02:28','TOKO','SMBK-F','F3E','F3E-ZCBE-246-0','1','1.320','1.320','1','1.320','1.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCBE-246-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-246-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-20260326-0001','1','F3E-ZCBE-247-0','1','1.520','1.520','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCBE-247-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-247-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-26 08:02:28' WHERE kode_barang='F3E-ZCBE-247-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCBE-247-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:02:28','TOKO','SMBK-F','F3E','F3E-ZCBE-247-0','1','1.520','1.520','1','1.520','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCBE-247-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-247-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-20260326-0001','1','F3E-ZCBE-248-0','1','1.880','1.880','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCBE-248-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-248-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-26 08:02:28' WHERE kode_barang='F3E-ZCBE-248-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCBE-248-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:02:28','TOKO','SMBK-F','F3E','F3E-ZCBE-248-0','1','1.880','1.880','1','1.880','1.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCBE-248-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-248-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-20260326-0001','1','F3E-ZCBE-249-0','1','2.500','2.500','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCBE-249-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-249-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-26 08:02:28' WHERE kode_barang='F3E-ZCBE-249-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCBE-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-03-26 08:02:28','TOKO','SMBK-F','F3E','F3E-ZCBE-249-0','1','2.500','2.500','1','2.500','2.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCBE-249-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-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-20260326-0001','1','F3E-ZCBE-250-0','1','2.630','2.630','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCBE-250-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-250-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-26 08:02:28' WHERE kode_barang='F3E-ZCBE-250-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCBE-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-03-26 08:02:28','TOKO','SMBK-F','F3E','F3E-ZCBE-250-0','1','2.630','2.630','1','2.630','2.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCBE-250-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCBE-250-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260326-0001','2026-03-26','08:02','9.850','input','2026-03-26 08:02:27');
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-20260326-0001','1','H1E-ZCBE-289-0','1','1.770','1.770','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCBE-289-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCBE-289-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-03-26 08:02:46' WHERE kode_barang='H1E-ZCBE-289-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCBE-289-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:02:46','TOKO','SMBK-H','H1E','H1E-ZCBE-289-0','1','1.770','1.770','1','1.770','1.770','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-ZCBE-289-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCBE-289-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-20260326-0001','1','H1E-ZCBE-290-0','1','2.150','2.150','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCBE-290-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCBE-290-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-03-26 08:02:46' WHERE kode_barang='H1E-ZCBE-290-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCBE-290-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-26 08:02:46','TOKO','SMBK-H','H1E','H1E-ZCBE-290-0','1','2.150','2.150','1','2.150','2.150','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-ZCBE-290-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCBE-290-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260326-0001','2026-03-26','08:02','3.920','input','2026-03-26 08:02:46');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZCBF-1-T','T0078286','MEF1 TD D56 ','GL OVAL MODEL C TD D56 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3625500','2026-03-26','3625500','3.180','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:24:31','3.180','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZCBF-1-T','T0078286');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F1E-ZCBF-1-T','F1E','TOKO','01-SEM','100.00','3.180','3.180','1','3.180','3.180','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-ZCBF-2-T','T0078287','MEF1 TD D56 ','GL OVAL MODEL C TD D56 8K ','','GR','---','ME','F1E','TOKO','01-SEM','3808000','2026-03-26','3808000','3.340','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:24:38','3.340','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-ZCBF-2-T','T0078287');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F1E-ZCBF-2-T','F1E','TOKO','01-SEM','100.00','3.340','3.340','1','3.340','3.340','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZCBF-3-T','T0078288','MEB1 A CM ','GW ITALY PANJANG ALPHABET A CM 8K ','','GR','---','ME','B1E','TOKO','01-SEM','707000','2026-03-26','707000','0.620','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:26:12','0.620','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZCBF-3-T','T0078288');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','B1E-ZCBF-3-T','B1E','TOKO','01-SEM','100.00','0.620','0.620','1','0.620','0.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZCBF-4-T','T0078289','MEB1 A CM ','GW ITALY PANJANG ALPHABET A CM 8K ','','GR','---','ME','B1E','TOKO','01-SEM','707000','2026-03-26','707000','0.620','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:26:18','0.620','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZCBF-4-T','T0078289');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','B1E-ZCBF-4-T','B1E','TOKO','01-SEM','100.00','0.620','0.620','1','0.620','0.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-5-T','T0078290','MEF3 X 20K HW ','GL X CHARM MODEL VAR HW 8K ','GL TALI MERAH','GR','---','ME','F3E','TOKO','01-SEM','798000','2026-03-26','798000','0.700','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:28:09','0.700','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-5-T','T0078290');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-5-T','F3E','TOKO','01-SEM','100.00','0.700','0.700','1','0.700','0.700','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-6-T','T0078291','MEF3 UB ','GL MODEL GENIA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','547500','2026-03-26','547500','0.480','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:28:45','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-6-T','T0078291');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-6-T','F3E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-7-T','T0078292','MEF3 UB ','GL MODEL GENIA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','547500','2026-03-26','547500','0.480','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:28:54','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-7-T','T0078292');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-7-T','F3E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-8-T','T0078293','MEF3 UB ','GL MODEL GENIA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','536000','2026-03-26','536000','0.470','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:29:08','0.470','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-8-T','T0078293');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-8-T','F3E','TOKO','01-SEM','100.00','0.470','0.470','1','0.470','0.470','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-9-T','T0078294','MEF3 UB ','GL MODEL GENIA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','547500','2026-03-26','547500','0.480','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:29:16','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-9-T','T0078294');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-9-T','F3E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-ZCBF-10-T','T0078295','MEF3 UB ','GL MODEL GENIA UB 8K ','','GR','---','ME','F3E','TOKO','01-SEM','547500','2026-03-26','547500','0.480','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:29:24','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-ZCBF-10-T','T0078295');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','F3E-ZCBF-10-T','F3E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZCBF-11-T','T0078296','MDE2 10K CM 20 ','CC WEDDING MATA CM 20 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1691500','2026-03-26','1691500','1.510','100.00','8','0','1120000.00','1','0.04', 'input','2026-03-26 08:32:16','1.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZCBF-11-T','T0078296');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','E2D-ZCBF-11-T','E2D','TOKO','01-SEM','100.00','1.510','1.510','1','1.510','1.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZCBF-12-T','T0078297','MDE2 10K CM 24 ','CC WEDDING MATA CM 24 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1702500','2026-03-26','1702500','1.520','100.00','8','0','1120000.00','1','0.04', 'input','2026-03-26 08:32:28','1.520','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZCBF-12-T','T0078297');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','E2D-ZCBF-12-T','E2D','TOKO','01-SEM','100.00','1.520','1.520','1','1.520','1.520','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0001','1','F3E-ZCBF-6-T','1','0.480','0.480','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-6-T','100.00','1','0.480','0.480','1','0.480','0.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0001','2','F3E-ZCBF-7-T','1','0.480','0.480','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-7-T','100.00','1','0.480','0.480','1','0.480','0.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0001','3','F3E-ZCBF-8-T','1','0.470','0.470','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-8-T','100.00','1','0.470','0.470','1','0.470','0.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.470',berat_out_asli=berat_out_asli+'0.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0001','4','F3E-ZCBF-9-T','1','0.480','0.480','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-9-T','100.00','1','0.480','0.480','1','0.480','0.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0001','5','F3E-ZCBF-10-T','1','0.480','0.480','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-10-T','100.00','1','0.480','0.480','1','0.480','0.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260326-0001','2026-03-26','2026-03-26','08:34','2.39','input','2026-03-26 08:34:28');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0002','1','F1E-ZCBF-1-T','1','3.180','3.180','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F1E-ZCBF-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F1E','F1E-ZCBF-1-T','100.00','1','3.180','3.180','1','3.180','3.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.180',berat_out_asli=berat_out_asli+'3.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F1E-ZCBF-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0002','2','F1E-ZCBF-2-T','1','3.340','3.340','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F1E-ZCBF-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F1E','F1E-ZCBF-2-T','100.00','1','3.340','3.340','1','3.340','3.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.340',berat_out_asli=berat_out_asli+'3.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F1E-ZCBF-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260326-0002','2026-03-26','2026-03-26','08:42','6.52','input','2026-03-26 08:42:48');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0003','1','B1E-ZCBF-3-T','1','0.620','0.620','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-B' WHERE kode_barang='B1E-ZCBF-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-B','B1E','B1E-ZCBF-3-T','100.00','1','0.620','0.620','1','0.620','0.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.620',berat_out_asli=berat_out_asli+'0.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='B1E-ZCBF-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0003','2','B1E-ZCBF-4-T','1','0.620','0.620','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-B' WHERE kode_barang='B1E-ZCBF-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-B','B1E','B1E-ZCBF-4-T','100.00','1','0.620','0.620','1','0.620','0.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.620',berat_out_asli=berat_out_asli+'0.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='B1E-ZCBF-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260326-0003','2026-03-26','2026-03-26','08:42','1.24','input','2026-03-26 08:43:16');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0004','1','F3E-ZCBF-5-T','1','0.700','0.700','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F3E-ZCBF-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-F','F3E','F3E-ZCBF-5-T','100.00','1','0.700','0.700','1','0.700','0.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.700',berat_out_asli=berat_out_asli+'0.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCBF-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260326-0004','2026-03-26','2026-03-26','08:43','0.7','input','2026-03-26 08:43:34');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0005','1','E2D-ZCBF-11-T','1','1.510','1.510','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZCBF-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-E','E2D','E2D-ZCBF-11-T','100.00','1','1.510','1.510','1','1.510','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCBF-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0005','2','E2D-ZCBF-12-T','1','1.520','1.520','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZCBF-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-03-26','TOKO','SMBK-E','E2D','E2D-ZCBF-12-T','100.00','1','1.520','1.520','1','1.520','1.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCBF-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260326-0005','2026-03-26','2026-03-26','08:43','3.03','input','2026-03-26 08:44:02');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBF-13-T','T0078298','MED1 5K LG ','LT MODEL FINE GOLD VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','593000','2026-03-26','593000','0.520','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:45:30','0.520','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBF-13-T','T0078298');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1E-ZCBF-13-T','D1E','TOKO','01-SEM','100.00','0.520','0.520','1','0.520','0.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBF-14-T','T0078299','MED1 5K LG ','LT MODEL FINE GOLD VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','593000','2026-03-26','593000','0.520','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:45:49','0.520','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBF-14-T','T0078299');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1E-ZCBF-14-T','D1E','TOKO','01-SEM','100.00','0.520','0.520','1','0.520','0.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1E-ZCBF-15-T','T0078300','MED1 5K LG ','LT MODEL FINE GOLD VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','593000','2026-03-26','593000','0.520','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:45:59','0.520','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCBF-15-T','T0078300');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1E-ZCBF-15-T','D1E','TOKO','01-SEM','100.00','0.520','0.520','1','0.520','0.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-16-T','T0078301','MFD1 5K BG I ','LT SLOBOK BULAT HURUF BG I 8K ','','GR','---','MF','D1F','TOKO','01-SEM','705000','2026-03-26','705000','0.580','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:46:33','0.580','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-16-T','T0078301');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-16-T','D1F','TOKO','01-SEM','100.00','0.580','0.580','1','0.580','0.580','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-17-T','T0078302','MFD1 5K BG R ','LT SLOBOK BULAT HURUF BG R 8K ','','GR','---','MF','D1F','TOKO','01-SEM','620000','2026-03-26','620000','0.510','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:46:52','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-17-T','T0078302');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-17-T','D1F','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-18-T','T0078303','MFD1 5K BG R ','LT SLOBOK BULAT HURUF BG R 8K ','','GR','---','MF','D1F','TOKO','01-SEM','814500','2026-03-26','814500','0.670','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:46:58','0.670','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-18-T','T0078303');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-18-T','D1F','TOKO','01-SEM','100.00','0.670','0.670','1','0.670','0.670','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-19-T','T0078304','MFD1 5K BG L ','LT SLOBOK BALOK HURUF BG L 8K ','','GR','---','MF','D1F','TOKO','01-SEM','559000','2026-03-26','559000','0.460','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:47:46','0.460','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-19-T','T0078304');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-19-T','D1F','TOKO','01-SEM','100.00','0.460','0.460','1','0.460','0.460','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-20-T','T0078305','MFD1 5K BG N ','LT SLOBOK BALOK HURUF BG N 8K ','','GR','---','MF','D1F','TOKO','01-SEM','790000','2026-03-26','790000','0.650','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:48:19','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-20-T','T0078305');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-20-T','D1F','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-21-T','T0078306','MFD1 5K BG N ','LT SLOBOK BALOK HURUF BG N 8K ','','GR','---','MF','D1F','TOKO','01-SEM','790000','2026-03-26','790000','0.650','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:48:24','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-21-T','T0078306');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-21-T','D1F','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1F-ZCBF-22-T','T0078307','MFD1 5K BG K ','LT SLOBOK BALOK HURUF BG K 8K ','','GR','---','MF','D1F','TOKO','01-SEM','790000','2026-03-26','790000','0.650','100.00','8','0','1215000.00','1','0.04', 'input','2026-03-26 08:48:39','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCBF-22-T','T0078307');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1F-ZCBF-22-T','D1F','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1G-ZCBF-23-T','T0078308','MGD1 5K BG O ','LT SLOBOK BALOK HURUF BG O 8K ','','GR','---','MG','D1G','TOKO','01-SEM','444000','2026-03-26','444000','0.370','100.00','8','0','1200000.00','1','0.04', 'input','2026-03-26 08:49:01','0.370','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1G','D1G-ZCBF-23-T','T0078308');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1G-ZCBF-23-T','D1G','TOKO','01-SEM','100.00','0.370','0.370','1','0.370','0.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1G-ZCBF-24-T','T0078309','MGD1 5K BG C ','LT SLOBOK BALOK HURUF BG C 8K ','','GR','---','MG','D1G','TOKO','01-SEM','444000','2026-03-26','444000','0.370','100.00','8','0','1200000.00','1','0.04', 'input','2026-03-26 08:49:16','0.370','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1G','D1G-ZCBF-24-T','T0078309');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1G-ZCBF-24-T','D1G','TOKO','01-SEM','100.00','0.370','0.370','1','0.370','0.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1G-ZCBF-25-T','T0078310','MGD1 5K BG J ','LT SLOBOK BALOK HURUF BG J 8K ','','GR','---','MG','D1G','TOKO','01-SEM','432000','2026-03-26','432000','0.360','100.00','8','0','1200000.00','1','0.04', 'input','2026-03-26 08:49:28','0.360','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1G','D1G-ZCBF-25-T','T0078310');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1G-ZCBF-25-T','D1G','TOKO','01-SEM','100.00','0.360','0.360','1','0.360','0.360','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1H-ZCBF-26-T','T0078311','MHD1 5K BG I ','LT SLOBOK BALOK HURUF BG I 8K ','','GR','---','MH','D1H','TOKO','01-SEM','281000','2026-03-26','281000','0.230','100.00','8','','1220000.00','1','0.04', 'input','2026-03-26 08:50:11','0.230','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1H','D1H-ZCBF-26-T','T0078311');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','D1H-ZCBF-26-T','D1H','TOKO','01-SEM','100.00','0.230','0.230','1','0.230','0.230','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','1','D1E-ZCBF-13-T','1','0.52','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCBF-13-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1E','D1E-ZCBF-13-T' , '1','0.52','0.52', '1','0.52','0.52','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.52',berat_out_asli=berat_out_asli+'0.52',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCBF-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','2','D1E-ZCBF-14-T','1','0.52','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCBF-14-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1E','D1E-ZCBF-14-T' , '1','0.52','0.52', '1','0.52','0.52','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.52',berat_out_asli=berat_out_asli+'0.52',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCBF-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','3','D1E-ZCBF-15-T','1','0.52','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCBF-15-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1E','D1E-ZCBF-15-T' , '1','0.52','0.52', '1','0.52','0.52','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.52',berat_out_asli=berat_out_asli+'0.52',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCBF-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','4','D1F-ZCBF-16-T','1','0.58','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-16-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-16-T' , '1','0.58','0.58', '1','0.58','0.58','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.58',berat_out_asli=berat_out_asli+'0.58',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','5','D1F-ZCBF-17-T','1','0.51','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-17-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-17-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','6','D1F-ZCBF-18-T','1','0.67','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-18-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-18-T' , '1','0.67','0.67', '1','0.67','0.67','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.67',berat_out_asli=berat_out_asli+'0.67',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','7','D1F-ZCBF-19-T','1','0.46','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-19-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-19-T' , '1','0.46','0.46', '1','0.46','0.46','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.46',berat_out_asli=berat_out_asli+'0.46',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','8','D1F-ZCBF-20-T','1','0.65','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-20-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-20-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','9','D1F-ZCBF-21-T','1','0.65','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-21-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-21-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','10','D1F-ZCBF-22-T','1','0.65','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCBF-22-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1F','D1F-ZCBF-22-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCBF-22-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','11','D1G-ZCBF-23-T','1','0.37','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1G-ZCBF-23-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1G','D1G-ZCBF-23-T' , '1','0.37','0.37', '1','0.37','0.37','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.37',berat_out_asli=berat_out_asli+'0.37',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZCBF-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','12','D1G-ZCBF-24-T','1','0.37','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1G-ZCBF-24-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1G','D1G-ZCBF-24-T' , '1','0.37','0.37', '1','0.37','0.37','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.37',berat_out_asli=berat_out_asli+'0.37',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZCBF-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','13','D1G-ZCBF-25-T','1','0.36','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1G-ZCBF-25-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1G','D1G-ZCBF-25-T' , '1','0.36','0.36', '1','0.36','0.36','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.36',berat_out_asli=berat_out_asli+'0.36',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZCBF-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0006','14','D1H-ZCBF-26-T','1','0.23','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1H-ZCBF-26-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-D','D1H','D1H-ZCBF-26-T' , '1','0.23','0.23', '1','0.23','0.23','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.23',berat_out_asli=berat_out_asli+'0.23',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1H-ZCBF-26-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260326-0006','2026-03-26','2026-03-26','08:50','7.06','input','2026-03-26 08:50:43');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBF-27-T','T0078312','MEH1 UB 34 ','KL ANAK GUCCI UB 34CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1208500','2026-03-26','1208500','1.060','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:51:52','1.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBF-27-T','T0078312');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','H1E-ZCBF-27-T','H1E','TOKO','01-SEM','100.00','1.060','1.060','1','1.060','1.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBF-28-T','T0078313','MEH1 UB 42 ','KL RANTAI HOLLOW DOUBLE UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3443000','2026-03-26','3443000','3.020','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:52:26','3.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBF-28-T','T0078313');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','H1E-ZCBF-28-T','H1E','TOKO','01-SEM','100.00','3.020','3.020','1','3.020','3.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBF-29-T','T0078314','MEH1 UB 42 ','KL RANTAI HOLLOW DOUBLE UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','889500','2026-03-26','889500','0.780','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:52:58','0.780','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBF-29-T','T0078314');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','H1E-ZCBF-29-T','H1E','TOKO','01-SEM','100.00','0.780','0.780','1','0.780','0.780','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBF-30-T','T0078315','MEH1 UB 42 ','KL RANTAI HOLLOW DOUBLE UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','912000','2026-03-26','912000','0.800','100.00','8','0','1140000.00','1','0.04', 'input','2026-03-26 08:53:11','0.800','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBF-30-T','T0078315');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','H1E-ZCBF-30-T','H1E','TOKO','01-SEM','100.00','0.800','0.800','1','0.800','0.800','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZCBF-31-T','T0078316','MEH1 UB 42 ','KL RANTAI HOLLOW DOUBLE UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','912000','2026-03-26','912000','0.800','100.00','8','','1140000.00','1','0.04', 'input','2026-03-26 08:53:20','0.800','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZCBF-31-T','T0078316');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-03-26','H1E-ZCBF-31-T','H1E','TOKO','01-SEM','100.00','0.800','0.800','1','0.800','0.800','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0007','1','H1E-ZCBF-27-T','1','1.06','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBF-27-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-H','H1E','H1E-ZCBF-27-T' , '1','1.06','1.06', '1','1.06','1.06','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.06',berat_out_asli=berat_out_asli+'1.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBF-27-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0007','2','H1E-ZCBF-28-T','1','3.02','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBF-28-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-H','H1E','H1E-ZCBF-28-T' , '1','3.02','3.02', '1','3.02','3.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.02',berat_out_asli=berat_out_asli+'3.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBF-28-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0007','3','H1E-ZCBF-29-T','1','0.78','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBF-29-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-H','H1E','H1E-ZCBF-29-T' , '1','0.78','0.78', '1','0.78','0.78','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.78',berat_out_asli=berat_out_asli+'0.78',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBF-29-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0007','4','H1E-ZCBF-30-T','1','0.8','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBF-30-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-H','H1E','H1E-ZCBF-30-T' , '1','0.8','0.8', '1','0.8','0.8','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.8',berat_out_asli=berat_out_asli+'0.8',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBF-30-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260326-0007','5','H1E-ZCBF-31-T','1','0.8','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZCBF-31-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-03-26','TOKO','SMBK-H','H1E','H1E-ZCBF-31-T' , '1','0.8','0.8', '1','0.8','0.8','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.8',berat_out_asli=berat_out_asli+'0.8',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZCBF-31-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260326-0007','2026-03-26','2026-03-26','08:53','6.46','input','2026-03-26 08:53:40');
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 ('F226260923171','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZCAX-29-T','GW TUSUK DEASY MATA LG 8K ','','0.300','1','100.00','360000','0','0','15000','354000','0','0','0','354000','RTA','T0077970','B1G','0','0','-','1','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZCAX-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='B1G-ZCAX-29-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 ('F226260923171','2026-03-26','0.300','2026-03-26','09:23:18','PLG0078447','354000','354000','0','354000','354000','kasir','2026-03-26 09:23:17','F22626092317');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260923171','2026-03-26','09:23:18','RTA','354000','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-260326-0002','D','2026-03-26','09:23:18','kasir','PENJUALAN','F226260923171','7553933000','354000','7554287000');
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 ('F226260924411','kasir','1',' MED1 HW ','TOKO','SMBK-D','D1E-ZBAH-37-T','LT MODEL COIN DOLLAR HW 8K ','OLS XRMTU','0.510','1','100.00','592000','0','0','15000','600000','0','97000','0','697000','RHM','T0077482','D1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAH-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='D1E-ZBAH-37-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 ('F226260924411','2026-03-26','0.510','2026-03-26','09:24:42','PLG0078448','600000','600000','97000','697000','697000','kasir','2026-03-26 09:24:41','F22626092441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260924411','2026-03-26','09:24:42','RHM','697000','97000');
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-260326-0003','D','2026-03-26','09:24:42','kasir','PENJUALAN','F226260924411','7554287000','697000','7554984000');
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 ('F226260927441','kasir','1',' MEE1 HW 15','TOKO','SMBK-E','E1E-ZABA-95-T','CC MODEL BUNGA ARESO HW 15 8K ','','0.560','1','100.00','650000','0','0','15000','638000','0','0','0','638000','RTA','T0076868','E1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABA-95-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-03-26' AND kode_barang='E1E-ZABA-95-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 ('F226260927441','2026-03-26','0.560','2026-03-26','09:27:44','PLG0078449','638000','638000','0','638000','638000','kasir','2026-03-26 09:27:44','F22626092744');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260927441','2026-03-26','09:27:44','RTA','638000','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-260326-0004','D','2026-03-26','09:27:44','kasir','PENJUALAN','F226260927441','7554984000','638000','7555622000');
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 ('F226261011371','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-35-T','CC MODEL SOLITAIRE MATA VAR CM 16 8K ','','1.380','1','100.00','1573000','0','0','15000','1546000','0','10000','0','1556000','TIN','T0077711','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCXE-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261011371','2026-03-26','1.380','2026-03-26','10:11:38','PLG0078450','1546000','1546000','10000','1556000','1556000','kasir','2026-03-26 10:11:37','F22626101137');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261011371','2026-03-26','10:11:38','TIN','1556000','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-260326-0005','D','2026-03-26','10:11:38','kasir','PENJUALAN','F226261011371','7555622000','1556000','7557178000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1556000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261011371' 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 ('F226261011372','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZBAX-9-T','GL RANTAI HOLLOW PLAT C SLEP HW 8K ','','1.890','1','100.00','2192000','0','0','15000','2155000','0','0','0','2155000','TIN','T0077124','F3E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZBAX-9-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 ('F226261011372','2026-03-26','1.890','2026-03-26','10:11:38','PLG0078451','2155000','2155000','0','2155000','2155000','kasir','2026-03-26 10:11:37','F22626101137');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261011372','2026-03-26','10:11:38','TIN','2155000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260326-0006','D','2026-03-26','10:11:38','kasir','PENJUALAN','F226261011372','7557178000','2155000','7559333000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2155000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261011372' 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 ('F226261011373','kasir',' 1',' MEA1E LG ','TOKO','SMBK-A','A1E-ZACX-144-0','AT BANGKOK KLIP SLEP LG 8K ','','0.600','1','100.00','696000','0','0','15000','684000','0','0','0','684000','TIN','00387445','A1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZACX-144-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='A1E-ZACX-144-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 ('F226261011373','2026-03-26','0.600','2026-03-26','10:11:38','PLG0078452','684000','684000','0','684000','684000','kasir','2026-03-26 10:11:37','F22626101137');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261011373','2026-03-26','10:11:38','TIN','684000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260326-0007','D','2026-03-26','10:11:38','kasir','PENJUALAN','F226261011373','7559333000','684000','7560017000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='684000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261011373' 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 ('F226261047371','kasir','1',' TFD1 X BG ','TOKO','TBK-D','D1TF-YLBF-27-T','LT X SLOBOK BULAT HURUF BG H 17K ','','0.800','1','100.00','1696000','0','0','15000','1665000','0','7000','0','1672000','NS','T0076197','D1TF','0','0','-','1','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-YLBF-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='D1TF-YLBF-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226261047371','2026-03-26','0.800','2026-03-26','10:47:37','PLG0078453','1665000','1665000','7000','1672000','1672000','kasir','2026-03-26 10:47:37','F22626104737');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261047371','2026-03-26','10:47:37','NS','1672000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260326-0008','D','2026-03-26','10:47:37','kasir','PENJUALAN','F226261047371','7560017000','1672000','7561689000');
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 ('F226261058311','kasir','1',' TEA1 LG ','TOKO','TBK-A','A1TE-WHXD-50-T','AT MODEL MATA LG ','','0.680','1','100.00','1428000','0','0','15000','1401000','0','0','0','1401000','RTA','T0047029','A1TE','0','0','-','1','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-WHXD-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='A1TE-WHXD-50-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 ('F226261058311','2026-03-26','0.680','2026-03-26','10:58:32','PLG0078454','1401000','1401000','0','1401000','1401000','kasir','2026-03-26 10:58:31','F22626105831');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261058311','2026-03-26','10:58:32','RTA','1401000','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-260326-0009','D','2026-03-26','10:58:32','kasir','PENJUALAN','F226261058311','7561689000','1401000','7563090000');
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 ('F226261126591','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAH-165-0','GL FLIK MODEL DAUN VAR HW 8K ','','1.850','1','100.00','2146000','0','0','15000','2110000','0','0','0','2110000','RTA','00395120','F3E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAH-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='F3E-ZCAH-165-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 ('F226261126591','2026-03-26','1.850','2026-03-26','11:26:59','PLG0078455','2110000','2110000','0','2110000','2110000','kasir','2026-03-26 11:26:59','F22626112659');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261126591','2026-03-26','11:26:59','RTA','2110000','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-260326-0010','D','2026-03-26','11:26:59','kasir','PENJUALAN','F226261126591','7563090000','2110000','7565200000');
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 ('F226261140161','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZCXG-28-T','GW TRIXIE PANJANG HATI MATA LG 8K ','OL','0.560','1','100.00','650000','0','0','15000','658000','0','5000','0','663000','RTA','T0077899','B1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCXG-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='B1E-ZCXG-28-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 ('F226261140161','2026-03-26','0.560','2026-03-26','11:40:17','PLG0078456','658000','658000','5000','663000','663000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140161','2026-03-26','11:40:17','RTA','663000','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-260326-0011','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140161','7565200000','663000','7565863000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140161' 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 ('F226261140162','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXE-130-T','LT MODEL PITA VAR LG 8K ','OL','0.500','1','100.00','580000','0','0','15000','588000','0','5000','0','593000','RTA','T0077806','D1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXE-130-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='D1E-ZCXE-130-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 ('F226261140162','2026-03-26','0.500','2026-03-26','11:40:17','PLG0078457','588000','588000','5000','593000','593000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140162','2026-03-26','11:40:17','RTA','593000','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-260326-0012','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140162','7565863000','593000','7566456000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140162' 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 ('F226261140163','kasir',' 1',' MEE2 X UB ','TOKO','SMBK-E','E2E-ZCAD-231-0','CC X MODEL MATA UB 14 8K ','OL','0.670','1','100.00','777000','0','0','15000','787000','0','5000','0','792000','RTA','00394364','E2E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAD-231-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2E-ZCAD-231-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 ('F226261140163','2026-03-26','0.670','2026-03-26','11:40:17','PLG0078458','787000','787000','5000','792000','792000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140163','2026-03-26','11:40:17','RTA','792000','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-260326-0013','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140163','7566456000','792000','7567248000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='792000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140163' 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 ('F226261140164','kasir',' 1',' MDE2 X PM ','TOKO','SMBK-E','E2D-ZCXI-121-0','CC X MODEL MATA PM 14 8K ','OL','0.950','1','100.00','1083000','0','0','15000','1097000','0','5000','0','1102000','RTA','00392936','E2D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXI-121-0' 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-03-26' AND kode_barang='E2D-ZCXI-121-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 ('F226261140164','2026-03-26','0.950','2026-03-26','11:40:17','PLG0078459','1097000','1097000','5000','1102000','1102000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140164','2026-03-26','11:40:17','RTA','1102000','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-260326-0014','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140164','7567248000','1102000','7568350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1102000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140164' 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 ('F226261140165','kasir',' 1',' MDE1 HW 13','TOKO','SMBK-E','E1D-ZCAA-21-T','CC MODEL SLEP VAR HW 13 8K ','OL','1.270','1','100.00','1448000','0','0','15000','1461000','0','6000','0','1467000','RTA','T0078020','E1D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAA-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E1D-ZCAA-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261140165','2026-03-26','1.270','2026-03-26','11:40:17','PLG0078460','1461000','1461000','6000','1467000','1467000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140165','2026-03-26','11:40:17','RTA','1467000','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-260326-0015','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140165','7568350000','1467000','7569817000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1467000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140165' 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 ('F226261140166','kasir',' 1',' MDE2 X NJ ','TOKO','SMBK-E','E2D-ZCXB-15-0','CC X MODEL MATA NJ 14 8K ','OL','1.380','1','100.00','1573000','0','0','15000','1587000','0','7000','0','1594000','RTA','00391438','E2D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCXB-15-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 ('F226261140166','2026-03-26','1.380','2026-03-26','11:40:17','PLG0078461','1587000','1587000','7000','1594000','1594000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140166','2026-03-26','11:40:17','RTA','1594000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260326-0016','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140166','7569817000','1594000','7571411000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1594000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140166' 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 ('F226261140167','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-YHAB-38-T','GL RANTAI HOLLOW UB 8K ','OL','2.080','1','100.00','2413000','0','0','15000','2434000','0','10000','0','2444000','RTA','T0072245','F3E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAB-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='F3E-YHAB-38-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 ('F226261140167','2026-03-26','2.080','2026-03-26','11:40:17','PLG0078462','2434000','2434000','10000','2444000','2444000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140167','2026-03-26','11:40:17','RTA','2444000','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-260326-0017','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140167','7571411000','2444000','7573855000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2444000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140167' 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 ('F226261140168','kasir',' 1',' MEF2 UB D5','TOKO','SMBK-F','F2E-ZCXE-76-T','GL OVAL MODEL PAKU MATA UB D56 8K ','OL','2.260','1','100.00','2622000','0','0','15000','2645000','0','11000','0','2656000','RTA','T0077752','F2E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCXE-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='F2E-ZCXE-76-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 ('F226261140168','2026-03-26','2.260','2026-03-26','11:40:17','PLG0078463','2645000','2645000','11000','2656000','2656000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140168','2026-03-26','11:40:17','RTA','2656000','11000');
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-260326-0018','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140168','7573855000','2656000','7576511000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140168' 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 ('F226261140169','kasir',' 1',' MEH1 15K U','TOKO','SMBK-H','H1E-YLCA-8-T','KL TIFF ANAK MODEL CAT 35 UB 8K ','OL','2.080','1','100.00','2413000','0','0','15000','2429000','0','15000','0','2444000','RTA','T0076290','H1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLCA-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='H1E-YLCA-8-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 ('F226261140169','2026-03-26','2.080','2026-03-26','11:40:17','PLG0078464','2429000','2429000','15000','2444000','2444000','kasir','2026-03-26 11:40:16','F22626114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261140169','2026-03-26','11:40:17','RTA','2444000','15000');
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-260326-0019','D','2026-03-26','11:40:17','kasir','PENJUALAN','F226261140169','7576511000','2444000','7578955000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2444000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261140169' 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 ('F226261142231','kasir','1',' MDD1 LG ','TOKO','SMBK-D','D1D-ZCAA-62-T','LT MODEL GOLD BAR LG 8K ','OL','0.970','1','100.00','1106000','0','0','15000','1120000','0','5000','0','1125000','NS','T0078061','D1D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZCAA-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='D1D-ZCAA-62-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 ('F226261142231','2026-03-26','0.970','2026-03-26','11:42:24','PLG0078465','1120000','1120000','5000','1125000','1125000','kasir','2026-03-26 11:42:23','F22626114223');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261142231','2026-03-26','11:42:24','NS','1125000','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-260326-0020','D','2026-03-26','11:42:24','kasir','PENJUALAN','F226261142231','7578955000','1125000','7580080000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1125000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261142231' 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 ('F226261142232','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZBBA-6-0','KL MILANO UB 42 8K ','OL','2.050','1','100.00','2378000','0','0','15000','2400000','0','10000','0','2410000','NS','00391119','H1E','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBBA-6-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-03-26' AND kode_barang='H1E-ZBBA-6-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 ('F226261142232','2026-03-26','2.050','2026-03-26','11:42:24','PLG0078466','2400000','2400000','10000','2410000','2410000','kasir','2026-03-26 11:42:23','F22626114223');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261142232','2026-03-26','11:42:24','NS','2410000','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-260326-0021','D','2026-03-26','11:42:24','kasir','PENJUALAN','F226261142232','7580080000','2410000','7582490000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2410000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261142232' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261142232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261142232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261142232';
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 ('F226261206491','kasir','1',' MEH1 KH ','TOKO','SMBK-H','H1E-ZCAB-1-T','KL SIEM COBRA MODEL MATA VAR KH 8K ','','1.870','1','100.00','2169000','0','0','15000','2132000','0','0','0','2132000','TJ','T0078072','H1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAB-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='H1E-ZCAB-1-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 ('F226261206491','2026-03-26','1.870','2026-03-26','12:06:50','PLG0078467','2132000','2132000','0','2132000','2132000','kasir','2026-03-26 12:06:49','F22626120649');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261206491','2026-03-26','12:06:50','TJ','2132000','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-260326-0022','D','2026-03-26','12:06:50','kasir','PENJUALAN','F226261206491','7582490000','2132000','7584622000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261206491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261206491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261206491';
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 ('F226261223121','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAX-56-T','GL MODEL CAPELA VAR HW 8K ','','1.170','1','100.00','1357000','0','0','15000','1335000','0','0','0','1335000','NS','T0077997','F3E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAX-56-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-03-26' AND kode_barang='F3E-ZCAX-56-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 ('F226261223121','2026-03-26','1.170','2026-03-26','12:23:13','PLG0078468','1335000','1335000','0','1335000','1335000','kasir','2026-03-26 12:23:12','F22626122312');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261223121','2026-03-26','12:23:13','NS','1335000','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-260326-0023','D','2026-03-26','12:23:13','kasir','PENJUALAN','F226261223121','7584622000','1335000','7585957000');
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 ('F226261253011','kasir','1',' MEE2E CM 2','TOKO','SMBK-E','E2E-ZBAC-34-T','CC WEDDING MATA CM 20 8K ','','1.050','1','100.00','1218000','0','0','15000','1197000','0','0','0','1197000','RTA','T0077243','E2E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2E-ZBAC-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 ('F226261253011','2026-03-26','1.050','2026-03-26','12:53:02','PLG0078469','1197000','1197000','0','1197000','1197000','kasir','2026-03-26 12:53:01','F22626125301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226261253011','2026-03-26','12:53:02','RTA','1197000','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-260326-0024','D','2026-03-26','12:53:02','kasir','PENJUALAN','F226261253011','7585957000','1197000','7587154000');
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 ('F226260127301','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-44-T','CC WEDDING MATA CM 14 8K ','','1.550','1','100.00','1767000','0','0','15000','1736000','0','10000','0','1746000','RTA','T0077720','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCXE-44-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 ('F226260127301','2026-03-26','1.550','2026-03-26','13:27:31','PLG0078470','1736000','1736000','10000','1746000','1746000','kasir','2026-03-26 13:27:30','F22626012730');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260127301','2026-03-26','13:27:31','RTA','1746000','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-260326-0025','D','2026-03-26','13:27:31','kasir','PENJUALAN','F226260127301','7587154000','1746000','7588900000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1746000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260127301' 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 ('F226260127302','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCBF-11-T','CC WEDDING MATA CM 20 8K ','','1.510','1','100.00','1691000','0','0','15000','1691000','0','10000','0','1701000','RTA','T0078296','E2D','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCBF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCBF-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260127302','2026-03-26','1.510','2026-03-26','13:27:31','PLG0078471','1691000','1691000','10000','1701000','1701000','kasir','2026-03-26 13:27:30','F22626012730');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260127302','2026-03-26','13:27:31','RTA','1701000','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-260326-0026','D','2026-03-26','13:27:31','kasir','PENJUALAN','F226260127302','7588900000','1701000','7590601000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1701000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260127302' 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 ('F226260207021','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLXD-58-T','LT SLOBOK BALOK HURUF R BG 8K ','OLS DDWUQ','0.600','1','100.00','708000','0','0','15000','717000','0','117000','0','834000','RHM','T0075526','D1F','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLXD-58-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-03-26' AND kode_barang='D1F-YLXD-58-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 ('F226260207021','2026-03-26','0.600','2026-03-26','14:07:02','PLG0078472','717000','717000','117000','834000','834000','kasir','2026-03-26 14:07:02','F22626020702');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260207021','2026-03-26','14:07:02','RHM','834000','117000');
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-260326-0027','D','2026-03-26','14:07:02','kasir','PENJUALAN','F226260207021','7590601000','834000','7591435000');
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 ('F226260258091','kasir','1',' MDE1 HW 15','TOKO','SMBK-E','E1E-ZCAA-23-T','CC MODEL SLEP VAR HW 15 8K ','','0.760','1','100.00','882000','0','0','15000','851000','0','0','0','851000','RHM','T0078022','E1E','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E1E-ZCAA-23-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 ('F226260258091','2026-03-26','0.760','2026-03-26','14:58:10','PLG0078473','851000','851000','0','851000','851000','kasir','2026-03-26 14:58:09','F22626025809');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260258091','2026-03-26','14:58:10','RHM','851000','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-260326-0028','D','2026-03-26','14:58:10','kasir','PENJUALAN','F226260258091','7591435000','851000','7592286000');
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-00005224','X-00005224','KL GUCCI UB 42CM 8K','GR','---','H1F','BELI','BELI001','1442000','2026-03-26','2.000','1','kasir','2026-03-26 15:07:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00005224','X-00005224');
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-260326-0001','F225180125391','NS','1','BELI','BELI001','H1F', 'X-00005224', 'KL GUCCI UB 42CM 8K','2.000','2.000','100.00','1650000','1442000','721000','1215000','1','1442000','1442000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-260326-0001','2026-03-26','2026-03-26','15:07:03','NS','---','2.000','1442000','1442000','1442000','1442000','1442000','kasir','2026-03-26 15:07:03','FB-260326-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260326-0001','AIDA','NGEPOS MLILIR 2/1','','','089696610910','kasir','2026-03-26 15:07:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260326-0029','K','2026-03-26','15:07:03','kasir','PEMBELIAN UMUM','FB-260326-0001','7592286000','1442000','7590844000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260127301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260127301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260127301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260127302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260127302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260127302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260207021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260207021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260207021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260258091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260258091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260258091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260923171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260923171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260923171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260924411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260924411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260924411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260927441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260927441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260927441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261011371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261011372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011373' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261011373' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261011373';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261047371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261047371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261047371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261058311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261058311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261058311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261126591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261126591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261126591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140163' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140163' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140163';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140164' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140164' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140164';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140165' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140165' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140165';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140166' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140166' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140166';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140167' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140167' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140167';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140168' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140168' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140168';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140169' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261140169' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261140169';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261142231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261142231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261142231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261223121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261223121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261223121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261253011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261253011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261253011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260326-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260326-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 ('F226260354021','kasir','1',' TDE2 15K C','TOKO','TBK-E','E2TD-ZAAI-106-T','CC WEDDING MATA CM 10 17K ','','2.030','1','100.00','4222000','0','0','15000','4141000','0','15000','0','4156000','RTA','T0076771','E2TD','0','0','-','1','2080000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZAAI-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2TD-ZAAI-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260354021','2026-03-26','2.030','2026-03-26','15:54:03','PLG0078474','4141000','4141000','15000','4156000','4156000','kasir','2026-03-26 15:54:02','F22626035402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260354021','2026-03-26','15:54:03','RTA','4156000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260326-0030','D','2026-03-26','15:54:03','kasir','PENJUALAN','F226260354021','7590844000','4156000','7595000000');
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 ('F226260355011','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCXE-48-T','CC WEDDING MATA CM 16 8K ','','1.520','1','100.00','1733000','0','0','15000','1702000','0','10000','0','1712000','RTA','T0077724','E2D','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-03-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXE-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-03-26' AND kode_barang='E2D-ZCXE-48-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 ('F226260355011','2026-03-26','1.520','2026-03-26','15:55:02','PLG0078475','1702000','1702000','10000','1712000','1712000','kasir','2026-03-26 15:55:01','F22626035501');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-26','F226260355011','2026-03-26','15:55:02','RTA','1712000','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-260326-0031','D','2026-03-26','15:55:02','kasir','PENJUALAN','F226260355011','7595000000','1712000','7596712000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260354021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260354021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260354021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260355011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260355011';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-26';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260327-0001','D','2026-03-27','16:05:40','SYSTEM','SALDO AWAL','SALDO AWAL','0','7596712000','7596712000');
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-260327-0001','D','2026-03-27','16:05:40','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260327-0001','D','2026-03-27','16:05:40','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260327-0001','D','2026-03-27','16:05:40','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-260327-0001','D','2026-03-27','16:05:40','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-260327-0001','D','2026-03-27','16:05:40','BCA','SALDO AWAL','SALDO AWAL','0','4317221888','4317221888');
UPDATE tp_system SET tgl_system='2026-03-27';