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-ZEXB-1-T','T0079153','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','406000','2026-05-02','406000','0.350','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:21:03','0.350','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-ZEXB-1-T','T0079153');
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-05-02','D1G-ZEXB-1-T','D1G','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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-ZEXB-2-T','T0079154','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','406000','2026-05-02','406000','0.350','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:21:20','0.350','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-ZEXB-2-T','T0079154');
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-05-02','D1G-ZEXB-2-T','D1G','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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-ZEXB-3-T','T0079155','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','371500','2026-05-02','371500','0.320','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:21:36','0.320','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-ZEXB-3-T','T0079155');
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-05-02','D1G-ZEXB-3-T','D1G','TOKO','01-SEM','100.00','0.320','0.320','1','0.320','0.320','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-ZEXB-4-T','T0079156','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','441000','2026-05-02','441000','0.380','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:21:54','0.380','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-ZEXB-4-T','T0079156');
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-05-02','D1G-ZEXB-4-T','D1G','TOKO','01-SEM','100.00','0.380','0.380','1','0.380','0.380','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-ZEXB-5-T','T0079157','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','406000','2026-05-02','406000','0.350','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:23:03','0.350','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-ZEXB-5-T','T0079157');
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-05-02','D1G-ZEXB-5-T','D1G','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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-ZEXB-6-T','T0079158','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','406000','2026-05-02','406000','0.350','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:23:16','0.350','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-ZEXB-6-T','T0079158');
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-05-02','D1G-ZEXB-6-T','D1G','TOKO','01-SEM','100.00','0.350','0.350','1','0.350','0.350','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-ZEXB-7-T','T0079159','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MG','D1G','TOKO','01-SEM','383000','2026-05-02','383000','0.330','100.00','8','0','1160000.00','1','0.04', 'input','2026-05-02 08:23:23','0.330','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-ZEXB-7-T','T0079159');
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-05-02','D1G-ZEXB-7-T','D1G','TOKO','01-SEM','100.00','0.330','0.330','1','0.330','0.330','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-ZEXB-8-T','T0079160','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','466000','2026-05-02','466000','0.400','100.00','8','0','1165000.00','1','0.04', 'input','2026-05-02 08:23:58','0.400','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-ZEXB-8-T','T0079160');
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-05-02','D1F-ZEXB-8-T','D1F','TOKO','01-SEM','100.00','0.400','0.400','1','0.400','0.400','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-ZEXB-9-T','T0079161','MGD1 5K BG ','LT SLOBOK BOLA KRAWANG VAR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','548000','2026-05-02','548000','0.470','100.00','8','0','1165000.00','1','0.04', 'input','2026-05-02 08:24:14','0.470','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-ZEXB-9-T','T0079161');
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-05-02','D1F-ZEXB-9-T','D1F','TOKO','01-SEM','100.00','0.470','0.470','1','0.470','0.470','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-260502-0001','1','D1F-ZEXB-8-T','1','0.4','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-ZEXB-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1F','D1F-ZEXB-8-T' , '1','0.4','0.4', '1','0.4','0.4','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.4',berat_out_asli=berat_out_asli+'0.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXB-8-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-260502-0001','2','D1F-ZEXB-9-T','1','0.47','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-ZEXB-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1F','D1F-ZEXB-9-T' , '1','0.47','0.47', '1','0.47','0.47','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.47',berat_out_asli=berat_out_asli+'0.47',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZEXB-9-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-260502-0001','3','D1G-ZEXB-1-T','1','0.35','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-ZEXB-1-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-1-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','4','D1G-ZEXB-2-T','1','0.35','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-ZEXB-2-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-2-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','5','D1G-ZEXB-3-T','1','0.32','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-ZEXB-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-3-T' , '1','0.32','0.32', '1','0.32','0.32','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.32',berat_out_asli=berat_out_asli+'0.32',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','6','D1G-ZEXB-4-T','1','0.38','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-ZEXB-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-4-T' , '1','0.38','0.38', '1','0.38','0.38','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.38',berat_out_asli=berat_out_asli+'0.38',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','7','D1G-ZEXB-5-T','1','0.35','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-ZEXB-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-5-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','8','D1G-ZEXB-6-T','1','0.35','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-ZEXB-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-6-T' , '1','0.35','0.35', '1','0.35','0.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.35',berat_out_asli=berat_out_asli+'0.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260502-0001','9','D1G-ZEXB-7-T','1','0.33','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-ZEXB-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2026-05-02','TOKO','SMBK-D','D1G','D1G-ZEXB-7-T' , '1','0.33','0.33', '1','0.33','0.33','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.33',berat_out_asli=berat_out_asli+'0.33',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1G-ZEXB-7-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-260502-0001','2026-05-02','2026-05-02','08:24','3.3','input','2026-05-02 08:24:41');
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 ('F226020937501','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YAAE-63-T','AT MODEL MATA VAR LG 8K ','OL','0.550','1','100.00','616000','0','0','15000','622000','0','5000','0','627000','TIN','T0066037','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YAAE-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='A1E-YAAE-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020937501','2026-05-02','0.550','2026-05-02','09:37:51','PLG0079588','622000','622000','5000','627000','627000','kasir','2026-05-02 09:37:50','F22602093750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020937501','2026-05-02','09:37:51','TIN','627000','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-260502-0002','D','2026-05-02','09:37:51','kasir','PENJUALAN','F226020937501','9109964000','627000','9110591000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='627000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020937501' 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 ('F226020937502','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDBB-57-T','GW TUSUK KUPU PASIR VAR BW 8K ','OL','0.470','1','100.00','526000','0','0','15000','531000','0','5000','0','536000','TIN','T0078847','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBB-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='B1E-ZDBB-57-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 ('F226020937502','2026-05-02','0.470','2026-05-02','09:37:51','PLG0079589','531000','531000','5000','536000','536000','kasir','2026-05-02 09:37:50','F22602093750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020937502','2026-05-02','09:37:51','TIN','536000','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-260502-0003','D','2026-05-02','09:37:51','kasir','PENJUALAN','F226020937502','9110591000','536000','9111127000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='536000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020937502' 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 ('F226020937503','kasir',' 1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDBB-55-T','GW TUSUK KUPU PASIR VAR BW 8K ','OL','0.470','1','100.00','526000','0','0','15000','531000','0','5000','0','536000','TIN','T0078845','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBB-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='B1E-ZDBB-55-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 ('F226020937503','2026-05-02','0.470','2026-05-02','09:37:51','PLG0079590','531000','531000','5000','536000','536000','kasir','2026-05-02 09:37:50','F22602093750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020937503','2026-05-02','09:37:51','TIN','536000','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-260502-0004','D','2026-05-02','09:37:51','kasir','PENJUALAN','F226020937503','9111127000','536000','9111663000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='536000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020937503' 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 ('F226020937504','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXF-15-T','LT MODEL COIN DOLLAR VAR LG 8K ','OL','0.470','1','100.00','526000','0','0','15000','531000','0','5000','0','536000','TIN','T0077837','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='D1E-ZCXF-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020937504','2026-05-02','0.470','2026-05-02','09:37:51','PLG0079591','531000','531000','5000','536000','536000','kasir','2026-05-02 09:37:50','F22602093750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020937504','2026-05-02','09:37:51','TIN','536000','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-260502-0005','D','2026-05-02','09:37:51','kasir','PENJUALAN','F226020937504','9111663000','536000','9112199000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='536000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020937504' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020937501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020937502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937503' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937503' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020937503';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937504' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020937504' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020937504';
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 ('F226020941461','kasir','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-ZCBC-20-T','GL X RANTAI HOLLOW P4 SLEP LT 17K ','OL','3.060','1','100.00','6212000','0','0','15000','6237000','0','21000','0','6258000','TIN','T0078255','F3TE','0','0','-','0','2030000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZCBC-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3TE-ZCBC-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020941461','2026-05-02','3.060','2026-05-02','09:41:47','PLG0079592','6237000','6237000','21000','6258000','6258000','kasir','2026-05-02 09:41:46','F22602094146');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020941461','2026-05-02','09:41:47','TIN','6258000','21000');
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-260502-0006','D','2026-05-02','09:41:47','kasir','PENJUALAN','F226020941461','9112199000','6258000','9118457000');
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 ('F226021014061','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZEXA-26-T','LT SLOBOK KUPU ARESO VAR LG 8K ','OL','0.310','1','100.00','360000','0','0','15000','361000','0','5000','0','366000','TIN','T0079138','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXA-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='D1G-ZEXA-26-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 ('F226021014061','2026-05-02','0.310','2026-05-02','10:14:06','PLG0079593','361000','361000','5000','366000','366000','kasir','2026-05-02 10:14:06','F22602101406');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021014061','2026-05-02','10:14:06','TIN','366000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260502-0007','D','2026-05-02','10:14:06','kasir','PENJUALAN','F226021014061','9118457000','366000','9118823000');
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 ('F226021018351','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-YJCX-15-T','KL GUCCI UB 42CM 8K ','','2.000','1','100.00','2240000','0','0','15000','2230000','0','0','0','2230000','TJ','T0074719','H1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCX-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='H1E-YJCX-15-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 ('F226021018351','2026-05-02','2.000','2026-05-02','10:18:35','PLG0079594','2230000','2230000','0','2230000','2230000','kasir','2026-05-02 10:18:35','F22602101835');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021018351','2026-05-02','10:18:35','TJ','2230000','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-260502-0008','D','2026-05-02','10:18:35','kasir','PENJUALAN','F226021018351','9118823000','2230000','9121053000');
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 ('F226021051371','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZEXA-18-T','AT TINDIK BABY LG 8K ','OL','0.470','1','100.00','526000','0','0','15000','529000','0','5000','0','534000','TIN','T0079130','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='A1E-ZEXA-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021051371','2026-05-02','0.470','2026-05-02','10:51:38','PLG0079595','529000','529000','5000','534000','534000','kasir','2026-05-02 10:51:37','F22602105137');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021051371','2026-05-02','10:51:38','TIN','534000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260502-0009','D','2026-05-02','10:51:38','kasir','PENJUALAN','F226021051371','9121053000','534000','9121587000');
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 ('F226021100211','kasir','1',' MEF3 PM ','TOKO','SMBK-F','F3E-ZDCX-29-T','GL MODEL DAUN SLEP PM 8K ','','3.060','1','100.00','3427000','0','0','15000','3412000','0','0','0','3412000','TJ','T0079098','F3E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZDCX-29-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 ('F226021100211','2026-05-02','3.060','2026-05-02','11:00:22','PLG0079596','3412000','3412000','0','3412000','3412000','kasir','2026-05-02 11:00:21','F22602110021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021100211','2026-05-02','11:00:22','TJ','3412000','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-260502-0010','D','2026-05-02','11:00:22','kasir','PENJUALAN','F226021100211','9121587000','3412000','9124999000');
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 ('F226021136451','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAX-43-T','GL MODEL FANCY VAR HW 8K ','','1.470','1','100.00','1646000','0','0','15000','1640000','0','0','0','1640000','RTA','T0077984','F3E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAX-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZCAX-43-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 ('F226021136451','2026-05-02','1.470','2026-05-02','11:36:46','PLG0079597','1640000','1640000','0','1640000','1640000','kasir','2026-05-02 11:36:45','F22602113645');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021136451','2026-05-02','11:36:46','RTA','1640000','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-260502-0011','D','2026-05-02','11:36:46','kasir','PENJUALAN','F226021136451','9124999000','1640000','9126639000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1640000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021136451' 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 ('F226021136452','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEXA-36-T','GL FLIK BUNGA CLOVER VAR HW 8K ','','2.190','1','100.00','2453000','0','0','15000','2442000','0','0','0','2442000','RTA','T0079148','F3E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZEXA-36-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 ('F226021136452','2026-05-02','2.190','2026-05-02','11:36:46','PLG0079598','2442000','2442000','0','2442000','2442000','kasir','2026-05-02 11:36:45','F22602113645');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021136452','2026-05-02','11:36:46','RTA','2442000','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-260502-0012','D','2026-05-02','11:36:46','kasir','PENJUALAN','F226021136452','9126639000','2442000','9129081000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2442000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021136452' 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 ('F226021136453','kasir',' 1',' MEE2 X HA ','TOKO','SMBK-E','E2E-WCBD-75-0','CC X MODEL HURUF MATA HA 18','','1.310','1','100.00','1467000','0','0','15000','1461000','0','0','0','1461000','RTA','00220518','E2E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-WCBD-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E2E-WCBD-75-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 ('F226021136453','2026-05-02','1.310','2026-05-02','11:36:46','PLG0079599','1461000','1461000','0','1461000','1461000','kasir','2026-05-02 11:36:45','F22602113645');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021136453','2026-05-02','11:36:46','RTA','1461000','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-260502-0013','D','2026-05-02','11:36:46','kasir','PENJUALAN','F226021136453','9129081000','1461000','9130542000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1461000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021136453' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021136452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021136451';
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 ('F226021200061','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZDBB-39-T','GL OVAL MODEL C TD D56 8K ','','3.290','1','100.00','3685000','0','0','15000','3668000','0','0','0','3668000','RTA','T0078829','F1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDBB-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.290',berat_jual_asli=berat_jual_asli+'3.290',stock_jual='1',berat_akhir=berat_akhir-'3.290',berat_akhir_asli=berat_akhir_asli-'3.290',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZDBB-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021200061','2026-05-02','3.290','2026-05-02','12:00:06','PLG0079600','3668000','3668000','0','3668000','3668000','kasir','2026-05-02 12:00:06','F22602120006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021200061','2026-05-02','12:00:06','RTA','3668000','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-260502-0014','D','2026-05-02','12:00:06','kasir','PENJUALAN','F226021200061','9130542000','3668000','9134210000');
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 ('F226021202431','kasir','1',' MDD2D X UB','TOKO','SMBK-D','D2D-ZDBG-60-0','LT X SLOBOK SOLITAIRE MATA UB 8K ','OL','1.020','1','100.00','1122000','0','0','15000','1118000','0','10000','0','1128000','NS','00401303','D2D','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZDBG-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='D2D-ZDBG-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021202431','2026-05-02','1.020','2026-05-02','12:02:43','PLG0079601','1118000','1118000','10000','1128000','1128000','kasir','2026-05-02 12:02:43','F22602120243');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021202431','2026-05-02','12:02:43','NS','1128000','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-260502-0015','D','2026-05-02','12:02:43','kasir','PENJUALAN','F226021202431','9134210000','1128000','9135338000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1128000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021202431' 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 ('F226021202432','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDBC-19-T','KL SANTA KH 42CM 8K ','OL','2.010','1','100.00','2251000','0','0','15000','2251000','0','10000','0','2261000','NS','T0078900','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBC-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='H1E-ZDBC-19-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 ('F226021202432','2026-05-02','2.010','2026-05-02','12:02:43','PLG0079602','2251000','2251000','10000','2261000','2261000','kasir','2026-05-02 12:02:43','F22602120243');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021202432','2026-05-02','12:02:43','NS','2261000','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-260502-0016','D','2026-05-02','12:02:43','kasir','PENJUALAN','F226021202432','9135338000','2261000','9137599000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2261000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021202432' 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 ('F226021212001','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZDBC-53-T','AT JERSY SLEP LG 8K ','OL','0.430','1','100.00','482000','0','0','15000','486000','0','5000','0','491000','RTA','T0078934','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='A1E-ZDBC-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021212001','2026-05-02','0.430','2026-05-02','12:12:01','PLG0079603','486000','486000','5000','491000','491000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212001','2026-05-02','12:12:01','RTA','491000','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-260502-0017','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212001','9137599000','491000','9138090000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='491000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212001' 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 ('F226021212002','kasir',' 1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDBC-10-T','AT JERSY POLOS CM 8K ','OL','0.550','1','100.00','616000','0','0','15000','622000','0','5000','0','627000','RTA','T0078891','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='A1E-ZDBC-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021212002','2026-05-02','0.550','2026-05-02','12:12:01','PLG0079604','622000','622000','5000','627000','627000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212002','2026-05-02','12:12:01','RTA','627000','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-260502-0018','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212002','9138090000','627000','9138717000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='627000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212002' 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 ('F226021212003','kasir',' 1',' MEE1 5K HW','TOKO','SMBK-E','E1E-ZDBX-19-T','CC MODEL SLEP VAR HW 15 8K ','OL','0.710','1','100.00','795000','0','0','15000','802000','0','5000','0','807000','RTA','T0078754','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBX-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBX-19-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 ('F226021212003','2026-05-02','0.710','2026-05-02','12:12:01','PLG0079605','802000','802000','5000','807000','807000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212003','2026-05-02','12:12:01','RTA','807000','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-260502-0019','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212003','9138717000','807000','9139524000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='807000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212003' 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 ('F226021212004','kasir',' 1',' MDE1 PM 10','TOKO','SMBK-E','E1D-ZDAC-24-T','CC MODEL DAUN VAR PM 10 8K ','OL','1.030','1','100.00','1133000','0','0','15000','1138000','0','5000','0','1143000','RTA','T0078643','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAC-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1D-ZDAC-24-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 ('F226021212004','2026-05-02','1.030','2026-05-02','12:12:01','PLG0079606','1138000','1138000','5000','1143000','1143000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212004','2026-05-02','12:12:01','RTA','1143000','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-260502-0020','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212004','9139524000','1143000','9140667000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1143000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212004' 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 ('F226021212005','kasir',' 1',' MDE1 PM 16','TOKO','SMBK-E','E1D-ZDAC-23-T','CC MODEL DAUN VAR PM 16 8K ','OL','1.030','1','100.00','1133000','0','0','15000','1138000','0','5000','0','1143000','RTA','T0078642','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1D-ZDAC-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 ('F226021212005','2026-05-02','1.030','2026-05-02','12:12:01','PLG0079607','1138000','1138000','5000','1143000','1143000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212005','2026-05-02','12:12:01','RTA','1143000','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-260502-0021','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212005','9140667000','1143000','9141810000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1143000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212005' 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 ('F226021212006','kasir',' 1',' MDE1 5K LG','TOKO','SMBK-E','E1D-YKAG-56-T','CC MODEL MEDAN PASIR LG 16 8K ','OL','1.170','1','100.00','1287000','0','0','15000','1294000','0','6000','0','1300000','RTA','T0075059','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAG-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-05-02' AND kode_barang='E1D-YKAG-56-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 ('F226021212006','2026-05-02','1.170','2026-05-02','12:12:01','PLG0079608','1294000','1294000','6000','1300000','1300000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212006','2026-05-02','12:12:01','RTA','1300000','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-260502-0022','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212006','9141810000','1300000','9143110000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212006' 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 ('F226021212007','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZDBX-335-0','CC X SOLITAIRE MATA CM 20 8K ','OL','1.150','1','100.00','1265000','0','0','15000','1265000','0','12000','0','1277000','RTA','00400272','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBX-335-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E2D-ZDBX-335-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 ('F226021212007','2026-05-02','1.150','2026-05-02','12:12:01','PLG0079609','1265000','1265000','12000','1277000','1277000','kasir','2026-05-02 12:12:00','F22602121200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021212007','2026-05-02','12:12:01','RTA','1277000','12000');
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-260502-0023','D','2026-05-02','12:12:01','kasir','PENJUALAN','F226021212007','9143110000','1277000','9144387000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1277000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021212007' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260502-0001','1','F1E-ZAAI-235-0','1','9.910','9.910','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZAAI-235-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZAAI-235-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-02 12:21:16' WHERE kode_barang='F1E-ZAAI-235-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZAAI-235-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-02 12:21:16','TOKO','SMBK-F','F1E','F1E-ZAAI-235-0','1','9.910','9.910','1','9.910','9.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZAAI-235-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZAAI-235-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-20260502-0001','1','F1E-ZABC-89-0','1','9.820','9.820','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZABC-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZABC-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-02 12:21:16' WHERE kode_barang='F1E-ZABC-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZABC-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-02 12:21:16','TOKO','SMBK-F','F1E','F1E-ZABC-89-0','1','9.820','9.820','1','9.820','9.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZABC-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZABC-89-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-20260502-0001','1','F1E-ZDBX-346-0','1','2.840','2.840','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZDBX-346-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZDBX-346-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-02 12:21:16' WHERE kode_barang='F1E-ZDBX-346-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZDBX-346-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-02 12:21:16','TOKO','SMBK-F','F1E','F1E-ZDBX-346-0','1','2.840','2.840','1','2.840','2.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZDBX-346-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZDBX-346-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260502-0001','2026-05-02','12:20','22.570','input','2026-05-02 12:21:16');
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 ('F226021224411','kasir','1',' MEF3E TD 5','TOKO','SMBK-F','F1E-ZDBX-346-0','GL OVAL C GELOMBANG TD 54 8K ','OL','2.840','1','100.00','3167000','0','0','15000','3181000','0','14000','0','3195000','TIN','00400283','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDBX-346-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZDBX-346-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 ('F226021224411','2026-05-02','2.840','2026-05-02','12:24:42','PLG0079610','3181000','3181000','14000','3195000','3195000','kasir','2026-05-02 12:24:41','F22602122441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021224411','2026-05-02','12:24:42','TIN','3195000','14000');
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-260502-0024','D','2026-05-02','12:24:42','kasir','PENJUALAN','F226021224411','9144387000','3195000','9147582000');
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 ('F226021231251','kasir','1',' MEF1 X UB ','TOKO','SMBK-F','F1E-ZABC-89-0','GL X SHOGUN SLEP UB 58 8K ','','9.820','1','100.00','10949000','0','0','15000','10950000','0','20000','0','10970000','TJ','00386719','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZABC-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.820',berat_jual_asli=berat_jual_asli+'9.820',stock_jual='1',berat_akhir=berat_akhir-'9.820',berat_akhir_asli=berat_akhir_asli-'9.820',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZABC-89-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 ('F226021231251','2026-05-02','9.820','2026-05-02','12:31:25','PLG0079611','10950000','10950000','20000','10970000','0','kasir','2026-05-02 12:31:25','F22602123125');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021231251','2026-05-02','12:31:25','TJ','10970000','20000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260502-0001','2026-05-02','2026-05-02 12:31:25','PENJUALAN : F226021231251','7962398474289','BCA','10970000','10970000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260502-0002','D','2026-05-02','12:31:25','BCA','PENJUALAN','F226021231251','4377785888','10970000','4388755888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7962398474289','SRI WAHYUNI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10970000' WHERE no_faktur_jual='F226021231251' 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 ('F226021232111','kasir','1',' MEF1 20K U','TOKO','SMBK-F','F1E-ZAAI-235-0','GL SHOGUN SLEP UB 58 8K ','','9.910','1','100.00','11050000','0','0','15000','11050000','0','20000','0','11070000','TJ','00386176','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAI-235-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.910',berat_jual_asli=berat_jual_asli+'9.910',stock_jual='1',berat_akhir=berat_akhir-'9.910',berat_akhir_asli=berat_akhir_asli-'9.910',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZAAI-235-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 ('F226021232111','2026-05-02','9.910','2026-05-02','12:32:11','PLG0079612','11050000','11050000','20000','11070000','0','kasir','2026-05-02 12:32:11','F22602123211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021232111','2026-05-02','12:32:11','TJ','11070000','20000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260502-0002','2026-05-02','2026-05-02 12:32:11','PENJUALAN : F226021232111','872408947094','BCA','11070000','11070000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260502-0003','D','2026-05-02','12:32:11','BCA','PENJUALAN','F226021232111','4388755888','11070000','4399825888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('872408947094','SRI WAHYUNI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='11070000' WHERE no_faktur_jual='F226021232111' 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 ('F226021244391','kasir','1',' MEF3 10K U','TOKO','SMBK-F','F3E-ZEXA-39-T','GL SANTA SERUT BUNGA PASIR 3C VAR UB 8K ','OL','1.530','1','100.00','1714000','0','0','15000','1711000','0','10000','0','1721000','TIN','T0079151','F3E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZEXA-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021244391','2026-05-02','1.530','2026-05-02','12:44:39','PLG0079613','1711000','1711000','10000','1721000','1721000','kasir','2026-05-02 12:44:39','F22602124439');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021244391','2026-05-02','12:44:39','TIN','1721000','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-260502-0025','D','2026-05-02','12:44:39','kasir','PENJUALAN','F226021244391','9147582000','1721000','9149303000');
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 ('F226021251181','kasir','1',' MEF3 10K U','TOKO','SMBK-F','F3E-ZEXA-40-T','GL SANTA SERUT BUNGA PASIR 3C VAR UB 8K ','OL','1.530','1','100.00','1714000','0','0','15000','1719000','0','10000','0','1729000','RTA','T0079152','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZEXA-40-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 ('F226021251181','2026-05-02','1.530','2026-05-02','12:51:19','PLG0079614','1719000','1719000','10000','1729000','1729000','kasir','2026-05-02 12:51:18','F22602125118');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226021251181','2026-05-02','12:51:19','RTA','1729000','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-260502-0026','D','2026-05-02','12:51:19','kasir','PENJUALAN','F226021251181','9149303000','1729000','9151032000');
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 ('F226020240171','kasir','1',' MEE2 X PM ','TOKO','SMBK-E','E2E-ZDBG-303-0','CC X MODEL MATA PM 10 8K ','OL H','0.530','1','100.00','594000','0','0','15000','594000','0','10000','0','604000','NS','00401546','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBG-303-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E2E-ZDBG-303-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 ('F226020240171','2026-05-02','0.530','2026-05-02','14:40:18','PLG0079615','594000','594000','10000','604000','604000','kasir','2026-05-02 14:40:17','F22602024017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020240171','2026-05-02','14:40:18','NS','604000','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-260502-0027','D','2026-05-02','14:40:18','kasir','PENJUALAN','F226020240171','9151032000','604000','9151636000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='604000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020240171' 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 ('F226020240172','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZDBB-79-T','CC MODEL KUPU MATA VAR CM 14 8K ','OL H','0.750','1','100.00','840000','0','0','15000','843000','0','10000','0','853000','NS','T0078869','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBB-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E2E-ZDBB-79-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 ('F226020240172','2026-05-02','0.750','2026-05-02','14:40:18','PLG0079616','843000','843000','10000','853000','853000','kasir','2026-05-02 14:40:17','F22602024017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020240172','2026-05-02','14:40:18','NS','853000','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-260502-0028','D','2026-05-02','14:40:18','kasir','PENJUALAN','F226020240172','9151636000','853000','9152489000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020240172' 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 ('F226020240173','kasir',' 1',' MEE2 CM 12','TOKO','SMBK-E','E2E-ZDBB-81-T','CC MODEL KUPU MATA VAR CM 12 8K ','OL H','0.760','1','100.00','851000','0','0','15000','854000','0','10000','0','864000','NS','T0078871','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBB-81-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-05-02' AND kode_barang='E2E-ZDBB-81-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 ('F226020240173','2026-05-02','0.760','2026-05-02','14:40:18','PLG0079617','854000','854000','10000','864000','864000','kasir','2026-05-02 14:40:17','F22602024017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020240173','2026-05-02','14:40:18','NS','864000','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-260502-0029','D','2026-05-02','14:40:18','kasir','PENJUALAN','F226020240173','9152489000','864000','9153353000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='864000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020240173' 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 ('F226020240174','kasir',' 1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZAAE-2-T','KL MILANO UB 40CM 8K ','OL H','3.050','1','100.00','3416000','0','0','15000','3416000','0','31000','0','3447000','NS','T0076564','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAE-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='H1E-ZAAE-2-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 ('F226020240174','2026-05-02','3.050','2026-05-02','14:40:18','PLG0079618','3416000','3416000','31000','3447000','3447000','kasir','2026-05-02 14:40:17','F22602024017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020240174','2026-05-02','14:40:18','NS','3447000','31000');
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-260502-0030','D','2026-05-02','14:40:18','kasir','PENJUALAN','F226020240174','9153353000','3447000','9156800000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3447000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020240174' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020240171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020240172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240173' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240173' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020240173';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240174' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020240174' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020240174';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020941461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020941461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020941461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021014061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021014061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021014061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021018351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021018351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021018351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021051371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021051371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021051371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021100211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021100211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021100211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021136453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021136453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021200061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021200061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021200061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021202431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021202432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021212007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021212007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021224411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021224411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021224411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021231251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021231251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021231251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021232111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021232111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021232111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021244391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021244391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021244391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021251181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021251181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021251181';
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 ('F226020251521','kasir','1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZDBC-50-T','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','OL H','0.530','1','100.00','594000','0','0','15000','594000','0','10000','0','604000','NS','T0078931','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='B1E-ZDBC-50-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 ('F226020251521','2026-05-02','0.530','2026-05-02','14:51:52','PLG0079619','594000','594000','10000','604000','604000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251521','2026-05-02','14:51:52','NS','604000','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-260502-0031','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251521','9156800000','604000','9157404000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='604000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251521' 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 ('F226020251522','kasir',' 1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZDBE-52-T','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','OL H','0.530','1','100.00','594000','0','0','15000','594000','0','10000','0','604000','NS','T0079021','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBE-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='B1E-ZDBE-52-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 ('F226020251522','2026-05-02','0.530','2026-05-02','14:51:52','PLG0079620','594000','594000','10000','604000','604000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251522','2026-05-02','14:51:52','NS','604000','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-260502-0032','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251522','9157404000','604000','9158008000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='604000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251522' 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 ('F226020251523','kasir',' 1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDBB-48-T','AT MODEL TETES ARESO CM 8K ','OL H','0.510','1','100.00','571000','0','0','15000','571000','0','10000','0','581000','NS','T0078838','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBB-48-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-05-02' AND kode_barang='A1E-ZDBB-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020251523','2026-05-02','0.510','2026-05-02','14:51:52','PLG0079621','571000','571000','10000','581000','581000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251523','2026-05-02','14:51:52','NS','581000','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-260502-0033','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251523','9158008000','581000','9158589000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251523' 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 ('F226020251524','kasir',' 1',' MEF1 X UB ','TOKO','SMBK-F','F1E-ZDAH-78-0','GL X OVAL C SLEP UB 54 8K ','OL H','2.140','1','100.00','2397000','0','0','15000','2397000','0','21000','0','2418000','NS','00399779','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAH-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZDAH-78-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 ('F226020251524','2026-05-02','2.140','2026-05-02','14:51:52','PLG0079622','2397000','2397000','21000','2418000','2418000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251524','2026-05-02','14:51:52','NS','2418000','21000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260502-0034','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251524','9158589000','2418000','9161007000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2418000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251524' 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 ('F226020251525','kasir',' 1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZAAG-37-T','GL BANGKOK MODEL C TD D56 8K ','OL H','3.950','1','100.00','4424000','0','0','15000','4424000','0','40000','0','4464000','NS','T0076631','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAG-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.950',berat_jual_asli=berat_jual_asli+'3.950',stock_jual='1',berat_akhir=berat_akhir-'3.950',berat_akhir_asli=berat_akhir_asli-'3.950',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZAAG-37-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 ('F226020251525','2026-05-02','3.950','2026-05-02','14:51:52','PLG0079623','4424000','4424000','40000','4464000','4464000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251525','2026-05-02','14:51:52','NS','4464000','40000');
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-260502-0035','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251525','9161007000','4464000','9165471000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4464000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251525' 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 ('F226020251526','kasir',' 1',' MFD1 8K BG','TOKO','SMBK-D','D1F-ZDAF-25-T','LT MODEL BUNGA PASIR VAR BG 8K ','OL H','1.020','1','100.00','1163000','0','0','15000','1163000','0','10000','0','1173000','NS','T0078691','D1F','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAF-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='D1F-ZDAF-25-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 ('F226020251526','2026-05-02','1.020','2026-05-02','14:51:52','PLG0079624','1163000','1163000','10000','1173000','1173000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251526','2026-05-02','14:51:52','NS','1173000','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-260502-0036','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251526','9165471000','1173000','9166644000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1173000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251526' 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 ('F226020251527','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZDBC-36-T','CC MODEL C CM 16 8K ','OL H','0.870','1','100.00','957000','0','0','15000','961000','0','10000','0','971000','NS','T0078917','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1D-ZDBC-36-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 ('F226020251527','2026-05-02','0.870','2026-05-02','14:51:52','PLG0079625','961000','961000','10000','971000','971000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251527','2026-05-02','14:51:52','NS','971000','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-260502-0037','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251527','9166644000','971000','9167615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='971000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251527' 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 ('F226020251528','kasir',' 1',' MEE2 X BM ','TOKO','SMBK-E','E2E-YLCX-127-0','CC X MODEL MATA CAT BM 12 8K ','OL H','0.760','1','100.00','851000','0','0','15000','854000','0','10000','0','864000','NS','00383532','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLCX-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E2E-YLCX-127-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 ('F226020251528','2026-05-02','0.760','2026-05-02','14:51:52','PLG0079626','854000','854000','10000','864000','864000','kasir','2026-05-02 14:51:52','F22602025152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020251528','2026-05-02','14:51:52','NS','864000','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-260502-0038','D','2026-05-02','14:51:52','kasir','PENJUALAN','F226020251528','9167615000','864000','9168479000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='864000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020251528' 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 ('F226020258101','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZDBI-165-0','GL X TIFF SLEP VAR HW 8K ','OL H','1.650','1','100.00','1848000','0','0','15000','1848000','0','17000','0','1865000','NS','00401811','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBI-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZDBI-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 ('F226020258101','2026-05-02','1.650','2026-05-02','14:58:10','PLG0079627','1848000','1848000','17000','1865000','1865000','kasir','2026-05-02 14:58:10','F22602025810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020258101','2026-05-02','14:58:10','NS','1865000','17000');
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-260502-0039','D','2026-05-02','14:58:10','kasir','PENJUALAN','F226020258101','9168479000','1865000','9170344000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020258101' 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 ('F226020258102','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZBAC-18-T','GL FANCY MODEL VAR HW 8K ','OL H','1.650','1','100.00','1848000','0','0','15000','1848000','0','17000','0','1865000','NS','T0077227','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAC-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZBAC-18-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 ('F226020258102','2026-05-02','1.650','2026-05-02','14:58:10','PLG0079628','1848000','1848000','17000','1865000','1865000','kasir','2026-05-02 14:58:10','F22602025810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020258102','2026-05-02','14:58:10','NS','1865000','17000');
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-260502-0040','D','2026-05-02','14:58:10','kasir','PENJUALAN','F226020258102','9170344000','1865000','9172209000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020258102' 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 ('F226020258103','kasir',' 1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZDAH-153-0','KL X SANTA ARESO VAR HW 42 8K ','OL H','1.930','1','100.00','2162000','0','0','15000','2162000','0','19000','0','2181000','NS','00399854','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAH-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='H1E-ZDAH-153-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 ('F226020258103','2026-05-02','1.930','2026-05-02','14:58:10','PLG0079629','2162000','2162000','19000','2181000','2181000','kasir','2026-05-02 14:58:10','F22602025810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020258103','2026-05-02','14:58:10','NS','2181000','19000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260502-0041','D','2026-05-02','14:58:10','kasir','PENJUALAN','F226020258103','9172209000','2181000','9174390000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2181000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020258103' 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 ('F226020258104','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDAF-19-T','GL RANTAI HOLLOW PLAT UB 8K ','OL H','1.030','1','100.00','1154000','0','0','15000','1154000','0','10000','0','1164000','NS','T0078685','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAF-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZDAF-19-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 ('F226020258104','2026-05-02','1.030','2026-05-02','14:58:10','PLG0079630','1154000','1154000','10000','1164000','1164000','kasir','2026-05-02 14:58:10','F22602025810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020258104','2026-05-02','14:58:10','NS','1164000','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-260502-0042','D','2026-05-02','14:58:10','kasir','PENJUALAN','F226020258104','9174390000','1164000','9175554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1164000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020258104' 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 ('F226020258105','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDAF-20-T','GL RANTAI HOLLOW PLAT UB 8K ','OL H','1.040','1','100.00','1165000','0','0','15000','1165000','0','10000','0','1175000','NS','T0078686','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAF-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F3E-ZDAF-20-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 ('F226020258105','2026-05-02','1.040','2026-05-02','14:58:10','PLG0079631','1165000','1165000','10000','1175000','1175000','kasir','2026-05-02 14:58:10','F22602025810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020258105','2026-05-02','14:58:10','NS','1175000','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-260502-0043','D','2026-05-02','14:58:10','kasir','PENJUALAN','F226020258105','9175554000','1175000','9176729000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1175000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020258105' 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 ('F226020259451','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-35-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.760','1','100.00','851000','0','0','15000','854000','0','10000','0','864000','NS','T0079056','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-35-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-05-02' AND kode_barang='E1E-ZDBH-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 ('F226020259451','2026-05-02','0.760','2026-05-02','14:59:45','PLG0079632','854000','854000','10000','864000','864000','kasir','2026-05-02 14:59:45','F22602025945');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020259451','2026-05-02','14:59:45','NS','864000','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-260502-0044','D','2026-05-02','14:59:45','kasir','PENJUALAN','F226020259451','9176729000','864000','9177593000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='864000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020259451' 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 ('F226020259452','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZDBB-86-T','CC MODEL HATI SLEP VAR CM 16 8K ','OL H','1.260','1','100.00','1386000','0','0','15000','1387000','0','13000','0','1400000','NS','T0078876','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBB-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1D-ZDBB-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020259452','2026-05-02','1.260','2026-05-02','14:59:45','PLG0079633','1387000','1387000','13000','1400000','1400000','kasir','2026-05-02 14:59:45','F22602025945');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020259452','2026-05-02','14:59:45','NS','1400000','13000');
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-260502-0045','D','2026-05-02','14:59:45','kasir','PENJUALAN','F226020259452','9177593000','1400000','9178993000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020259452' 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 ('F226020259453','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-17-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.670','1','100.00','750000','0','0','15000','752000','0','10000','0','762000','NS','T0079038','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-17-T' 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-05-02' AND kode_barang='E1E-ZDBH-17-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 ('F226020259453','2026-05-02','0.670','2026-05-02','14:59:45','PLG0079634','752000','752000','10000','762000','762000','kasir','2026-05-02 14:59:45','F22602025945');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020259453','2026-05-02','14:59:45','NS','762000','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-260502-0046','D','2026-05-02','14:59:45','kasir','PENJUALAN','F226020259453','9178993000','762000','9179755000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='762000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020259453' 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 ('F226020259454','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-27-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.660','1','100.00','739000','0','0','15000','741000','0','10000','0','751000','NS','T0079048','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-27-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 ('F226020259454','2026-05-02','0.660','2026-05-02','14:59:45','PLG0079635','741000','741000','10000','751000','751000','kasir','2026-05-02 14:59:45','F22602025945');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020259454','2026-05-02','14:59:45','NS','751000','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-260502-0047','D','2026-05-02','14:59:45','kasir','PENJUALAN','F226020259454','9179755000','751000','9180506000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='751000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020259454' 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 ('F226020259455','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-23-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.720','1','100.00','806000','0','0','15000','809000','0','10000','0','819000','NS','T0079044','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-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 ('F226020259455','2026-05-02','0.720','2026-05-02','14:59:45','PLG0079636','809000','809000','10000','819000','819000','kasir','2026-05-02 14:59:45','F22602025945');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020259455','2026-05-02','14:59:45','NS','819000','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-260502-0048','D','2026-05-02','14:59:45','kasir','PENJUALAN','F226020259455','9180506000','819000','9181325000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='819000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020259455' 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 ('F226020301591','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-32-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.750','1','100.00','840000','0','0','15000','843000','0','10000','0','853000','NS','T0079053','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020301591','2026-05-02','0.750','2026-05-02','15:01:59','PLG0079637','843000','843000','10000','853000','853000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301591','2026-05-02','15:01:59','NS','853000','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-260502-0049','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301591','9181325000','853000','9182178000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301591' 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 ('F226020301592','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-22-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.710','1','100.00','795000','0','0','15000','797000','0','10000','0','807000','NS','T0079043','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-22-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 ('F226020301592','2026-05-02','0.710','2026-05-02','15:01:59','PLG0079638','797000','797000','10000','807000','807000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301592','2026-05-02','15:01:59','NS','807000','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-260502-0050','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301592','9182178000','807000','9182985000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='807000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301592' 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 ('F226020301593','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-25-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.730','1','100.00','818000','0','0','15000','820000','0','10000','0','830000','NS','T0079046','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-25-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 ('F226020301593','2026-05-02','0.730','2026-05-02','15:01:59','PLG0079639','820000','820000','10000','830000','830000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301593','2026-05-02','15:01:59','NS','830000','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-260502-0051','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301593','9182985000','830000','9183815000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='830000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301593' 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 ('F226020301594','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-36-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.700','1','100.00','784000','0','0','15000','786000','0','10000','0','796000','NS','T0079057','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-36-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 ('F226020301594','2026-05-02','0.700','2026-05-02','15:01:59','PLG0079640','786000','786000','10000','796000','796000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301594','2026-05-02','15:01:59','NS','796000','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-260502-0052','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301594','9183815000','796000','9184611000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='796000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301594' 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 ('F226020301595','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-33-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.700','1','100.00','784000','0','0','15000','786000','0','10000','0','796000','NS','T0079054','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZDBH-33-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 ('F226020301595','2026-05-02','0.700','2026-05-02','15:01:59','PLG0079641','786000','786000','10000','796000','796000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301595','2026-05-02','15:01:59','NS','796000','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-260502-0053','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301595','9184611000','796000','9185407000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='796000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301595' 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 ('F226020301596','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-19-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL H','0.680','1','100.00','762000','0','0','15000','763000','0','10000','0','773000','NS','T0079040','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-19-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-05-02' AND kode_barang='E1E-ZDBH-19-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 ('F226020301596','2026-05-02','0.680','2026-05-02','15:01:59','PLG0079642','763000','763000','10000','773000','773000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301596','2026-05-02','15:01:59','NS','773000','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-260502-0054','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301596','9185407000','773000','9186180000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='773000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301596' 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 ('F226020301597','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-40-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.680','1','100.00','762000','0','0','15000','763000','0','10000','0','773000','NS','T0079061','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-40-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-05-02' AND kode_barang='E1E-ZDBH-40-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 ('F226020301597','2026-05-02','0.680','2026-05-02','15:01:59','PLG0079643','763000','763000','10000','773000','773000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301597','2026-05-02','15:01:59','NS','773000','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-260502-0055','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301597','9186180000','773000','9186953000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='773000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301597' 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 ('F226020301598','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-31-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL H','0.680','1','100.00','762000','0','0','15000','763000','0','10000','0','773000','NS','T0079052','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-31-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-05-02' AND kode_barang='E1E-ZDBH-31-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 ('F226020301598','2026-05-02','0.680','2026-05-02','15:01:59','PLG0079644','763000','763000','10000','773000','773000','kasir','2026-05-02 15:01:59','F22602030159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020301598','2026-05-02','15:01:59','NS','773000','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-260502-0056','D','2026-05-02','15:01:59','kasir','PENJUALAN','F226020301598','9186953000','773000','9187726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='773000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020301598' 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 ('F226020307571','kasir','1',' MDE1 X PM ','TOKO','SMBK-E','E1D-ZDBG-312-0','CC X MODEL DAUN SLEP PM 16 8K ','OL','0.980','1','100.00','1078000','0','0','15000','1083000','0','5000','0','1088000','TIN','00401555','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBG-312-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1D-ZDBG-312-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 ('F226020307571','2026-05-02','0.980','2026-05-02','15:07:58','PLG0079645','1083000','1083000','5000','1088000','1088000','kasir','2026-05-02 15:07:57','F22602030757');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020307571','2026-05-02','15:07:58','TIN','1088000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260502-0057','D','2026-05-02','15:07:58','kasir','PENJUALAN','F226020307571','9187726000','1088000','9188814000');
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 ('F226020313121','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZDBH-45-T','GL OVAL MODEL C TD D52 8K ','','3.030','1','100.00','3394000','0','0','15000','3378000','0','0','0','3378000','RTA','T0079066','F1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDBH-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='F1E-ZDBH-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020313121','2026-05-02','3.030','2026-05-02','15:13:13','PLG0079646','3378000','3378000','0','3378000','3378000','kasir','2026-05-02 15:13:12','F22602031312');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020313121','2026-05-02','15:13:13','RTA','3378000','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-260502-0058','D','2026-05-02','15:13:13','kasir','PENJUALAN','F226020313121','9188814000','3378000','9192192000');
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-00005315','X-00005315','KL SANTA KH 42CM 8K','GR','---','H1E','BELI','BELI001','1180000','2026-05-02','1.530','1','kasir','2026-05-02 15:34:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005315','X-00005315');
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-260502-0001','F225121151251','RTA','1','BELI','BELI001','H1E', 'X-00005315', 'KL SANTA KH 42CM 8K','1.530','1.530','100.00','1280000','1180000','771242','1115000','1','1180000','1180000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260502-0001','2026-05-02','2026-05-02','15:34:11','RTA','---','1.530','1180000','1180000','1180000','1180000','1180000','kasir','2026-05-02 15:34:11','FB-260502-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260502-0001','HERU W','PO','','','','kasir','2026-05-02 15:34:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-02' 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-260502-0059','K','2026-05-02','15:34:11','kasir','PEMBELIAN UMUM','FB-260502-0001','9192192000','1180000','9191012000');
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-00005316','X-00005316','CC BANGKOK SLEP LG 15 8K','GR','---','E1E','BELI','BELI001','390000','2026-05-02','0.480','1','kasir','2026-05-02 15:34:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005316','X-00005316');
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-260502-0002','F225241112191','TJ','1','BELI','BELI001','E1E', 'X-00005316', 'CC BANGKOK SLEP LG 15 8K','0.480','0.480','100.00','488000','390000','812500','1115000','1','390000','390000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260502-0002','2026-05-02','2026-05-02','15:34:54','TJ','---','0.480','390000','390000','390000','390000','390000','kasir','2026-05-02 15:34:54','FB-260502-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260502-0002','TATA','BEDI WETAN 02/02','','','081249664545','kasir','2026-05-02 15:34:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-02' 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-260502-0060','K','2026-05-02','15:34:54','kasir','PEMBELIAN UMUM','FB-260502-0002','9191012000','390000','9190622000');
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-00005317','X-00005317','GL FANCY MODEL HATI MATA VAR HW 8K','GR','---','F3E','BELI','BELI001','1694000','2026-05-02','1.900','1','kasir','2026-05-02 15:35:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005317','X-00005317');
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-260502-0003','F226291116231','RTA','1','BELI','BELI001','F3E', 'X-00005317', 'GL FANCY MODEL HATI MATA VAR HW 8K','2.100','1.900','100.00','2888000','1694000','891579','1115000','1','1694000','1694000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-260502-0003','2026-05-02','2026-05-02','15:35:22','RTA','---','1.900','1694000','1694000','1694000','1694000','1694000','kasir','2026-05-02 15:35:23','FB-260502-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260502-0003','DINA','WAGIRLOR NGEBEL','','','081217016619','kasir','2026-05-02 15:35:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-02' 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-260502-0061','K','2026-05-02','15:35:22','kasir','PEMBELIAN UMUM','FB-260502-0003','9190622000','1694000','9188928000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251523' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251523';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251524' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251524' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251524';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251525' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251525' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251525';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251526' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251526' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251526';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251527' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251527' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251527';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251528' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251528' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251528';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020258101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020258102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258103' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258103' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020258103';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258104' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258104' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020258104';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258105' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020258105' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020258105';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020259451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020259452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020259453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259454' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259454' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020259454';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259455' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020259455' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020259455';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301595' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301595' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301595';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301596' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301596' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301596';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301597' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301597' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301597';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301598' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020301598' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020301598';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020307571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020307571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020307571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020313121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020313121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020313121';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260502-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260502-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260502-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260502-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260502-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260502-0003';
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 ('F226020337491','admin','1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-ZEXA-5-T','CC PIPA MODEL DAUN VAR HTM 18 8K ','','0.450','1','100.00','504000','0','0','15000','502000','0','0','0','502000','NS','T0079117','E1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='E1E-ZEXA-5-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 ('F226020337491','2026-05-02','0.450','2026-05-02','15:37:49','PLG0079647','502000','502000','0','502000','502000','admin','2026-05-02 15:37:49','F22602033749');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020337491','2026-05-02','15:37:49','NS','502000','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-260502-0062','D','2026-05-02','15:37:49','admin','PENJUALAN','F226020337491','9188928000','502000','9189430000');
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 ('F226020343311','admin','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZEXA-23-T','LT SLOBOK PITA ARESO VAR LG 8K ','','0.270','1','100.00','313000','0','0','15000','312000','0','0','0','312000','NS','T0079135','D1G','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXA-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-05-02' AND kode_barang='D1G-ZEXA-23-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 ('F226020343311','2026-05-02','0.270','2026-05-02','15:43:31','PLG0079648','312000','312000','0','312000','312000','admin','2026-05-02 15:43:31','F22602034331');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-02','F226020343311','2026-05-02','15:43:31','NS','312000','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-260502-0063','D','2026-05-02','15:43:31','admin','PENJUALAN','F226020343311','9189430000','312000','9189742000');
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-00005318','X-00005318','LT SLOBOK BOLA KRAWANG VAR BG 8K','GR','---','D1H','BELI','BELI001','184000','2026-05-02','0.230','1','admin','2026-05-02 15:50:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1H','X-00005318','X-00005318');
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-260502-0004','F225181034401','RTA','1','BELI','BELI001','D1H', 'X-00005318', 'LT SLOBOK BOLA KRAWANG VAR BG 8K','0.230','0.230','100.00','205000','184000','800000','1180000','1','184000','184000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.230',berat_beli_asli=berat_beli_asli+'0.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.230',berat_akhir_asli=berat_akhir_asli+'0.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1H' 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-260502-0004','2026-05-02','2026-05-02','15:50:16','RTA','---','0.230','184000','184000','184000','184000','184000','admin','2026-05-02 15:50:17','FB-260502-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260502-0004','YUYUN','KUNTI SAMPUNG','','','','admin','2026-05-02 15:50:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-02' 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-260502-0064','K','2026-05-02','15:50:16','admin','PEMBELIAN UMUM','FB-260502-0004','9189742000','184000','9189558000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020337491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020337491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020337491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020343311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020343311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020343311';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260502-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260502-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-02';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-02' 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-260503-0001','D','2026-05-03','16:29:20','SYSTEM','SALDO AWAL','SALDO AWAL','0','9189558000','9189558000');
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-260503-0001','D','2026-05-03','16:29:20','BCA','SALDO AWAL','SALDO AWAL','0','4399825888','4399825888');
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-260503-0001','D','2026-05-03','16:29:20','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-260503-0001','D','2026-05-03','16:29:20','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-260503-0001','D','2026-05-03','16:29:20','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-260503-0001','D','2026-05-03','16:29:20','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-05-03';
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-20260503-0001','1','D1F-ZEXB-48-0','1','0.400','0.400','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZEXB-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZEXB-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-05-03 17:19:50' WHERE kode_barang='D1F-ZEXB-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZEXB-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:19:50','TOKO','SMBK-D','D1F','D1F-ZEXB-48-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZEXB-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZEXB-48-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-20260503-0001','1','D1D-ZEXB-49-0','1','0.870','0.870','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1D-ZEXB-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1D-ZEXB-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-05-03 17:19:50' WHERE kode_barang='D1D-ZEXB-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1D-ZEXB-49-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:19:50','TOKO','SMBK-D','D1D','D1D-ZEXB-49-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1D' 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='D1D-ZEXB-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1D-ZEXB-49-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260503-0001','2026-05-03','17:19','1.270','input','2026-05-02 17:19:50');
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-20260503-0001','1','F1E-ZDBH-29-0','1','2.720','2.720','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZDBH-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZDBH-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-03 17:20:05' WHERE kode_barang='F1E-ZDBH-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZDBH-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:20:05','TOKO','SMBK-F','F1E','F1E-ZDBH-29-0','1','2.720','2.720','1','2.720','2.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZDBH-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZDBH-29-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-20260503-0001','1','F3E-ZEXB-71-0','1','3.050','3.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXB-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-03 17:20:05' WHERE kode_barang='F3E-ZEXB-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXB-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:20:05','TOKO','SMBK-F','F3E','F3E-ZEXB-71-0','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZEXB-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-71-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-20260503-0001','1','F3E-ZEXB-72-0','1','2.980','2.980','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-03 17:20:05' WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:20:05','TOKO','SMBK-F','F3E','F3E-ZEXB-72-0','1','2.980','2.980','1','2.980','2.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZEXB-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-72-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-20260503-0001','1','F3E-ZEXB-73-0','1','1.230','1.230','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXB-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-03 17:20:05' WHERE kode_barang='F3E-ZEXB-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXB-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:20:05','TOKO','SMBK-F','F3E','F3E-ZEXB-73-0','1','1.230','1.230','1','1.230','1.230','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-ZEXB-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260503-0001','1','F3E-ZEXB-74-0','1','1.800','1.800','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXB-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-05-03 17:20:05' WHERE kode_barang='F3E-ZEXB-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXB-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-03 17:20:05','TOKO','SMBK-F','F3E','F3E-ZEXB-74-0','1','1.800','1.800','1','1.800','1.800','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-ZEXB-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXB-74-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260503-0001','2026-05-03','17:19','11.780','input','2026-05-02 17:20:04');