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-20260402-0001','1','E1TE-WKXI-61-T','1','1.000','1.000','TOKO','TBK-E','TOKO','TBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-WKXI-61-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-WKXI-61-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TBK-E',tgl_last_beli='2026-04-02 08:29:56' WHERE kode_barang='E1TE-WKXI-61-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-WKXI-61-T' 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-04-02 08:29:56','TOKO','TBK-E','E1TE','E1TE-WKXI-61-T','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-WKXI-61-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-WKXI-61-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260402-0001','2026-04-02','08:29','1.000','input','2026-04-02 08:29:55');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226020842531','kasir','1',' TFD1 X BG ','TOKO','TBK-D','D1TF-YJBH-40-T','LT X SLOBOK BULAT HURUF BG F 17K ','OL','0.750','1','100.00','1590000','0','0','15000','1598000','0','7000','0','1605000','TIN','T0074522','D1TF','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-YJBH-40-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-04-02' AND kode_barang='D1TF-YJBH-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020842531','2026-04-02','0.750','2026-04-02','08:42:53','PLG0078712','1598000','1598000','7000','1605000','1605000','kasir','2026-04-02 08:42:53','F22602084253');
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-04-02','F226020842531','2026-04-02','08:42:53','TIN','1605000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260402-0002','D','2026-04-02','08:42:53','kasir','PENJUALAN','F226020842531','7933402000','1605000','7935007000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020842531' 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 ('F226020842532','kasir',' 1',' TEE1 X CM ','TOKO','TBK-E','E1TE-WKXI-61-T','CC X POLOS CM 10 ','OL','1.000','1','100.00','2140000','0','0','15000','2103000','0','7000','0','2110000','TIN','T0050469','E1TE','0','0','-','1','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-WKXI-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='E1TE-WKXI-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020842532','2026-04-02','1.000','2026-04-02','08:42:53','PLG0078713','2103000','2103000','7000','2110000','2110000','kasir','2026-04-02 08:42:53','F22602084253');
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-04-02','F226020842532','2026-04-02','08:42:53','TIN','2110000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260402-0003','D','2026-04-02','08:42:53','kasir','PENJUALAN','F226020842532','7935007000','2110000','7937117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020842532' 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 ('F226020936291','kasir','1',' MGA1 LG ','TOKO','SMBK-A','A1G-ZCXG-2-T','AT TINDIK BABY MRICAN LG 8K ','OL','0.300','1','100.00','361000','0','0','15000','374000','0','5000','0','379000','TIN','T0077873','A1G','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZCXG-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A1G-ZCXG-2-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 ('F226020936291','2026-04-02','0.300','2026-04-02','09:36:30','PLG0078714','374000','374000','5000','379000','379000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936291','2026-04-02','09:36:30','TIN','379000','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-260402-0004','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936291','7937117000','379000','7937496000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='379000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936291' 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 ('F226020936292','kasir',' 1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCAF-15-T','AT TINDIK BABY LG 8K ','OL','0.460','1','100.00','536000','0','0','15000','554000','0','5000','0','559000','TIN','T0078174','A1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A1E-ZCAF-15-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 ('F226020936292','2026-04-02','0.460','2026-04-02','09:36:30','PLG0078715','554000','554000','5000','559000','559000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936292','2026-04-02','09:36:30','TIN','559000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260402-0005','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936292','7937496000','559000','7938055000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='559000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936292' 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 ('F226020936293','kasir',' 1',' MEA1E X BW','TOKO','SMBK-A','A1E-ZCCX-442-0','AT X ITALY SLEP BW 8K ','OL','0.520','1','100.00','606000','0','0','15000','627000','0','5000','0','632000','TIN','00397096','A1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCCX-442-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A1E-ZCCX-442-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020936293','2026-04-02','0.520','2026-04-02','09:36:30','PLG0078716','627000','627000','5000','632000','632000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936293','2026-04-02','09:36:30','TIN','632000','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-260402-0006','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936293','7938055000','632000','7938687000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='632000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936293' 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 ('F226020936294','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZCAC-28-T','GW TRIXIE PANJANG HATI MATA VAR LG 8K ','OL','0.570','1','100.00','664000','0','0','15000','687000','0','5000','0','692000','TIN','T0078141','B1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCAC-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='B1E-ZCAC-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020936294','2026-04-02','0.570','2026-04-02','09:36:30','PLG0078717','687000','687000','5000','692000','692000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936294','2026-04-02','09:36:30','TIN','692000','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-260402-0007','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936294','7938687000','692000','7939379000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='692000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936294' 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 ('F226020936295','kasir',' 1',' MGD1G X UB','TOKO','SMBK-D','D1G-ZCXC-115-0','LT X MODEL SLEP UB 8K ','OL','0.320','1','100.00','386000','0','0','15000','398000','0','5000','0','403000','TIN','00391918','D1G','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXC-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='D1G-ZCXC-115-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 ('F226020936295','2026-04-02','0.320','2026-04-02','09:36:30','PLG0078718','398000','398000','5000','403000','403000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936295','2026-04-02','09:36:30','TIN','403000','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-260402-0008','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936295','7939379000','403000','7939782000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='403000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936295' 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 ('F226020936296','kasir',' 1',' MGD1G X UB','TOKO','SMBK-D','D1G-ZCCX-399-0','LT X MODEL ARESO SLEP UB 8K ','OL','0.370','1','100.00','446000','0','0','15000','461000','0','5000','0','466000','TIN','00397053','D1G','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCCX-399-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='D1G-ZCCX-399-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 ('F226020936296','2026-04-02','0.370','2026-04-02','09:36:30','PLG0078719','461000','461000','5000','466000','466000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936296','2026-04-02','09:36:30','TIN','466000','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-260402-0009','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936296','7939782000','466000','7940248000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='466000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936296' 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 ('F226020936297','kasir',' 1',' MED2E X YT','TOKO','SMBK-D','D2E-ZCCX-401-0','LT X MODEL MATA VAR YT 8K ','OL','0.730','1','100.00','850000','0','0','15000','880000','0','5000','0','885000','TIN','00397055','D2E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCCX-401-0' 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-04-02' AND kode_barang='D2E-ZCCX-401-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 ('F226020936297','2026-04-02','0.730','2026-04-02','09:36:30','PLG0078720','880000','880000','5000','885000','885000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936297','2026-04-02','09:36:30','TIN','885000','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-260402-0010','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936297','7940248000','885000','7941133000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='885000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936297' 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 ('F226020936298','kasir',' 1',' MEE1 X BM ','TOKO','SMBK-E','E1E-ZCCX-497-0','CC X MODEL SPECTRA CAT HITAM BM 12 8K ','OL','0.500','1','100.00','582000','0','0','15000','603000','0','5000','0','608000','TIN','00397151','E1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCCX-497-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='E1E-ZCCX-497-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 ('F226020936298','2026-04-02','0.500','2026-04-02','09:36:30','PLG0078721','603000','603000','5000','608000','608000','kasir','2026-04-02 09:36:29','F22602093629');
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-04-02','F226020936298','2026-04-02','09:36:30','TIN','608000','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-260402-0011','D','2026-04-02','09:36:30','kasir','PENJUALAN','F226020936298','7941133000','608000','7941741000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='608000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020936298' 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 ('F226020938111','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZCCX-491-0','CC X MODEL MATA LG 12 8K ','OL','0.520','1','100.00','606000','0','0','15000','627000','0','5000','0','632000','TIN','00397145','E2E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCCX-491-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='E2E-ZCCX-491-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 ('F226020938111','2026-04-02','0.520','2026-04-02','09:38:11','PLG0078722','627000','627000','5000','632000','632000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938111','2026-04-02','09:38:11','TIN','632000','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-260402-0012','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938111','7941741000','632000','7942373000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='632000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938111' 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 ('F226020938112','kasir',' 1',' MEE1 X UB ','TOKO','SMBK-E','E1E-ZCCX-498-0','CC X MODEL SPECTRA CAT HITAM UB 12 ','OL','0.660','1','100.00','769000','0','0','15000','795000','0','5000','0','800000','TIN','00397152','E1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCCX-498-0' 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-04-02' AND kode_barang='E1E-ZCCX-498-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 ('F226020938112','2026-04-02','0.660','2026-04-02','09:38:11','PLG0078723','795000','795000','5000','800000','800000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938112','2026-04-02','09:38:11','TIN','800000','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-260402-0013','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938112','7942373000','800000','7943173000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938112' 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 ('F226020938113','kasir',' 1',' MEE1 X HW ','TOKO','SMBK-E','E1E-ZCCX-496-0','CC X MODEL GELOMBANG CAT HITAM HW 17 8K ','OL','0.720','1','100.00','839000','0','0','15000','868000','0','5000','0','873000','TIN','00397150','E1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCCX-496-0' 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-04-02' AND kode_barang='E1E-ZCCX-496-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 ('F226020938113','2026-04-02','0.720','2026-04-02','09:38:11','PLG0078724','868000','868000','5000','873000','873000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938113','2026-04-02','09:38:11','TIN','873000','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-260402-0014','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938113','7943173000','873000','7944046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='873000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938113' 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 ('F226020938114','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZCCX-487-0','CC X MODEL MATA CM 10 8K ','OL','0.870','1','100.00','996000','0','0','15000','1031000','0','5000','0','1036000','TIN','00397141','E2D','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-487-0' 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-04-02' AND kode_barang='E2D-ZCCX-487-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 ('F226020938114','2026-04-02','0.870','2026-04-02','09:38:11','PLG0078725','1031000','1031000','5000','1036000','1036000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938114','2026-04-02','09:38:11','TIN','1036000','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-260402-0015','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938114','7944046000','1036000','7945082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1036000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938114' 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 ('F226020938115','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCCA-43-T','GL MODEL FANCY VAR HW 8K ','OL','0.790','1','100.00','920000','0','0','15000','952000','0','5000','0','957000','TIN','T0078339','F3E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCCA-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.790',berat_jual_asli=berat_jual_asli+'0.790',stock_jual='1',berat_akhir=berat_akhir-'0.790',berat_akhir_asli=berat_akhir_asli-'0.790',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='F3E-ZCCA-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 ('F226020938115','2026-04-02','0.790','2026-04-02','09:38:11','PLG0078726','952000','952000','5000','957000','957000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938115','2026-04-02','09:38:11','TIN','957000','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-260402-0016','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938115','7945082000','957000','7946039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='957000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938115' 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 ('F226020938116','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZCBF-29-T','KL RANTAI HOLLOW DOUBLE UB 42CM 8K ','OL','0.780','1','100.00','909000','0','0','15000','940000','0','5000','0','945000','TIN','T0078314','H1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBF-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1E-ZCBF-29-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 ('F226020938116','2026-04-02','0.780','2026-04-02','09:38:11','PLG0078727','940000','940000','5000','945000','945000','kasir','2026-04-02 09:38:11','F22602093811');
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-04-02','F226020938116','2026-04-02','09:38:11','TIN','945000','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-260402-0017','D','2026-04-02','09:38:11','kasir','PENJUALAN','F226020938116','7946039000','945000','7946984000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='945000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020938116' 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 ('F226021004101','kasir','1',' MED2 LG L ','TOKO','SMBK-D','D2E-YJCX-60-0','LT MODEL HURUF MATA LG L 8K ','','0.520','1','100.00','606000','0','0','15000','620000','0','0','0','620000','RTA','00375272','D2E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJCX-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='D2E-YJCX-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 ('F226021004101','2026-04-02','0.520','2026-04-02','10:04:10','PLG0078728','620000','620000','0','620000','620000','kasir','2026-04-02 10:04:10','F22602100410');
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-04-02','F226021004101','2026-04-02','10:04:10','RTA','620000','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-260402-0018','D','2026-04-02','10:04:10','kasir','PENJUALAN','F226021004101','7946984000','620000','7947604000');
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 ('F226021103451','kasir','1',' MHB1 LG ','TOKO','SMBK-B','B1H-ZCXG-69-T','GW TUSUK MRICAN POLOS LG 8K ','','0.250','1','100.00','306000','0','0','15000','313000','0','0','0','313000','RTA','T0077940','B1H','0','0','-','0','1225000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCXG-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='B1H-ZCXG-69-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 ('F226021103451','2026-04-02','0.250','2026-04-02','11:03:45','PLG0078729','313000','313000','0','313000','313000','kasir','2026-04-02 11:03:45','F22602110345');
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-04-02','F226021103451','2026-04-02','11:03:45','RTA','313000','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-260402-0019','D','2026-04-02','11:03:45','kasir','PENJUALAN','F226021103451','7947604000','313000','7947917000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='313000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021103451' 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 ('F226021103452','kasir',' 1',' MEF1 10K L','TOKO','SMBK-F','F1E-ZCXE-82-T','GL ANAK OSROT BONEKA CAT LG 8K ','','0.980','1','100.00','1142000','0','0','15000','1166000','0','10000','0','1176000','RTA','T0077758','F1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCXE-82-T' 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-04-02' AND kode_barang='F1E-ZCXE-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021103452','2026-04-02','0.980','2026-04-02','11:03:45','PLG0078730','1166000','1166000','10000','1176000','1176000','kasir','2026-04-02 11:03:45','F22602110345');
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-04-02','F226021103452','2026-04-02','11:03:45','RTA','1176000','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-260402-0020','D','2026-04-02','11:03:45','kasir','PENJUALAN','F226021103452','7947917000','1176000','7949093000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1176000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021103452' 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 ('F226021113461','kasir','1',' MEF3 X KH ','TOKO','SMBK-F','F3E-ZCXG-270-0','GL X RANTAI HOLLOW P3 SLEP KH 8K ','','2.110','1','100.00','2458000','0','0','15000','2470000','0','0','0','2470000','TJ','00392706','F3E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='F3E-ZCXG-270-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 ('F226021113461','2026-04-02','2.110','2026-04-02','11:13:47','PLG0078731','2470000','2470000','0','2470000','2470000','kasir','2026-04-02 11:13:46','F22602111346');
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-04-02','F226021113461','2026-04-02','11:13:47','TJ','2470000','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-260402-0021','D','2026-04-02','11:13:47','kasir','PENJUALAN','F226021113461','7949093000','2470000','7951563000');
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 ('F226021150581','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZACX-128-T','AT JERSY SLEP LG 8K ','OL','0.950','1','100.00','1088000','0','0','15000','1121000','0','5000','0','1126000','NS','T0077042','A1D','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZACX-128-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A1D-ZACX-128-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 ('F226021150581','2026-04-02','0.950','2026-04-02','11:50:59','PLG0078732','1121000','1121000','5000','1126000','1126000','kasir','2026-04-02 11:50:58','F22602115058');
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-04-02','F226021150581','2026-04-02','11:50:59','NS','1126000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260402-0022','D','2026-04-02','11:50:59','kasir','PENJUALAN','F226021150581','7951563000','1126000','7952689000');
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 ('F226021200411','kasir','1',' TAB0 X DW ','TOKO','TBK-B','B0TA-XGAF-13-T','GW X ANDE ANDE DW 17K ','','1.000','1','100.00','2000000','0','0','15000','2005000','0','0','0','2005000','RTA','T0059353','B0TA','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-XGAF-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='B0TA-XGAF-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226021200411','2026-04-02','1.000','2026-04-02','12:00:41','PLG0078733','2005000','2005000','0','2005000','2005000','kasir','2026-04-02 12:00:41','F22602120041');
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-04-02','F226021200411','2026-04-02','12:00:41','RTA','2005000','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-260402-0023','D','2026-04-02','12:00:41','kasir','PENJUALAN','F226021200411','7952689000','2005000','7954694000');
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 ('F226021202061','kasir','1',' TFH1 HW 42','TOKO','TBK-H','H1TF-XDXG-64-T','KL KOREA HW 42CM 17K ','','5.100','1','100.00','10812000','0','0','15000','10787000','0','0','0','10787000','RTA','T0056148','H1TF','0','0','-','1','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-XDXG-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.100',berat_jual_asli=berat_jual_asli+'5.100',stock_jual='1',berat_akhir=berat_akhir-'5.100',berat_akhir_asli=berat_akhir_asli-'5.100',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1TF-XDXG-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226021202061','2026-04-02','5.100','2026-04-02','12:02:07','PLG0078734','10787000','10787000','0','10787000','10787000','kasir','2026-04-02 12:02:06','F22602120206');
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-04-02','F226021202061','2026-04-02','12:02:07','RTA','10787000','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-260402-0024','D','2026-04-02','12:02:07','kasir','PENJUALAN','F226021202061','7954694000','10787000','7965481000');
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 ('F226021206391','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZCXB-119-0','CC X MODEL MATA CM 14 8K ','OL','0.600','1','100.00','699000','0','0','15000','708000','0','5000','0','713000','NS','00391542','E2E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCXB-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='E2E-ZCXB-119-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 ('F226021206391','2026-04-02','0.600','2026-04-02','12:06:39','PLG0078735','708000','708000','5000','713000','713000','kasir','2026-04-02 12:06:39','F22602120639');
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-04-02','F226021206391','2026-04-02','12:06:39','NS','713000','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-260402-0025','D','2026-04-02','12:06:39','kasir','PENJUALAN','F226021206391','7965481000','713000','7966194000');
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 ('F226021221171','kasir','1',' TEE2 CM 14','TOKO','TBK-E','E2TE-YIXD-23-T','CC SOLITAIRE MATA CM 14 17K ','OL','0.680','1','100.00','1428000','0','0','15000','1469000','0','7000','0','1476000','RTA','T0072875','E2TE','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-YIXD-23-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-04-02' AND kode_barang='E2TE-YIXD-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021221171','2026-04-02','0.680','2026-04-02','12:21:17','PLG0078736','1469000','1469000','7000','1476000','1476000','kasir','2026-04-02 12:21:17','F22602122117');
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-04-02','F226021221171','2026-04-02','12:21:17','RTA','1476000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260402-0026','D','2026-04-02','12:21:17','kasir','PENJUALAN','F226021221171','7966194000','1476000','7967670000');
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 ('F226021228511','kasir','1',' MED2 X LG ','TOKO','SMBK-D','D2E-ZBXE-166-0','LT X MODEL HURUF MATA LG M 8K ','OLS JV6KE','0.550','1','100.00','641000','0','0','15000','663000','0','92000','0','755000','RHM','00388434','D2E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBXE-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='D2E-ZBXE-166-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 ('F226021228511','2026-04-02','0.550','2026-04-02','12:28:51','PLG0078737','663000','663000','92000','755000','755000','kasir','2026-04-02 12:28:51','F22602122851');
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-04-02','F226021228511','2026-04-02','12:28:51','RHM','755000','92000');
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-260402-0027','D','2026-04-02','12:28:51','kasir','PENJUALAN','F226021228511','7967670000','755000','7968425000');
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 ('F226021239301','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZCXE-135-T','LT SLOBOK BOLA ARESO LG 8K ','','0.330','1','100.00','398000','0','0','15000','400000','0','0','0','400000','NS','T0077811','D1G','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXE-135-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='D1G-ZCXE-135-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 ('F226021239301','2026-04-02','0.330','2026-04-02','12:39:31','PLG0078738','400000','400000','0','400000','400000','kasir','2026-04-02 12:39:30','F22602123930');
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-04-02','F226021239301','2026-04-02','12:39:31','NS','400000','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-260402-0028','D','2026-04-02','12:39:31','kasir','PENJUALAN','F226021239301','7968425000','400000','7968825000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021239301' 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 ('F226021239302','kasir',' 1',' MEH1 UB 46','TOKO','SMBK-H','H1E-ZCAB-25-T','KL NORY UB 46CM 8K ','','0.970','1','100.00','1130000','0','0','15000','1135000','0','0','0','1135000','NS','T0078096','H1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAB-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1E-ZCAB-25-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 ('F226021239302','2026-04-02','0.970','2026-04-02','12:39:31','PLG0078739','1135000','1135000','0','1135000','1135000','kasir','2026-04-02 12:39:30','F22602123930');
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-04-02','F226021239302','2026-04-02','12:39:31','NS','1135000','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-260402-0029','D','2026-04-02','12:39:31','kasir','PENJUALAN','F226021239302','7968825000','1135000','7969960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1135000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021239302' 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 ('F226021252221','kasir','1',' TAA0 X DG ','TOKO','TBK-A','A0TA-YLBF-8-T','AT X TINDIK BABY DG 17K','','0.500','1','100.00','1000000','0','0','15000','1015000','0','0','0','1015000','TJ','T0076178','A0TA','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A0TA-YLBF-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226021252221','2026-04-02','0.500','2026-04-02','12:52:22','PLG0078740','1015000','1015000','0','1015000','1015000','kasir','2026-04-02 12:52:22','F22602125222');
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-04-02','F226021252221','2026-04-02','12:52:22','TJ','1015000','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-260402-0030','D','2026-04-02','12:52:22','kasir','PENJUALAN','F226021252221','7969960000','1015000','7970975000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1015000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021252221' 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 ('F226021252222','kasir',' 1',' TEH1 X UB ','TOKO','TBK-H','H1TE-ZCBC-32-T','KL X KOREA UB 42CM 17K ','','4.030','1','100.00','8463000','0','0','15000','8565000','0','0','0','8565000','TJ','T0078267','H1TE','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1TE-ZCBC-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226021252222','2026-04-02','4.030','2026-04-02','12:52:22','PLG0078741','8565000','8565000','0','8565000','8565000','kasir','2026-04-02 12:52:22','F22602125222');
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-04-02','F226021252222','2026-04-02','12:52:22','TJ','8565000','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-260402-0031','D','2026-04-02','12:52:22','kasir','PENJUALAN','F226021252222','7970975000','8565000','7979540000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='8565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021252222' 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 ('F226020204051','kasir','1',' TFH2 X UB ','TOKO','TBK-H','H2TF-XJAB-96-T','KL X CARENDELANO ALPABETH UB F 17K ','','2.650','1','100.00','5618000','0','0','15000','5685000','0','20000','0','5705000','RTA','T0062957','H2TF','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TF-XJAB-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H2TF-XJAB-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226020204051','2026-04-02','2.650','2026-04-02','14:04:05','PLG0078742','5685000','5685000','20000','5705000','5705000','kasir','2026-04-02 14:04:05','F22602020405');
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-04-02','F226020204051','2026-04-02','14:04:05','RTA','5705000','20000');
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-260402-0032','D','2026-04-02','14:04:05','kasir','PENJUALAN','F226020204051','7979540000','5705000','7985245000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5705000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020204051' 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 ('F226020204052','kasir',' 1',' TEH1 X HW ','TOKO','TBK-H','H1TE-ZCBC-29-T','KL X NORY MODEL MATA VAR HW 17K ','','3.080','1','100.00','6468000','0','0','15000','6545000','0','0','0','6545000','RTA','T0078264','H1TE','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1TE-ZCBC-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226020204052','2026-04-02','3.080','2026-04-02','14:04:05','PLG0078743','6545000','6545000','0','6545000','6545000','kasir','2026-04-02 14:04:05','F22602020405');
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-04-02','F226020204052','2026-04-02','14:04:05','RTA','6545000','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-260402-0033','D','2026-04-02','14:04:05','kasir','PENJUALAN','F226020204052','7985245000','6545000','7991790000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020204052' 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 ('F226020241291','kasir','1',' MDE2 5K CM','TOKO','SMBK-E','E2D-YKAG-49-T','CC MODEL AUREL MATA VAR CM 10 8K ','','0.980','1','100.00','1122000','0','0','15000','1127000','0','5000','0','1132000','RTA','T0075052','E2D','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAG-49-T' 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-04-02' AND kode_barang='E2D-YKAG-49-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 ('F226020241291','2026-04-02','0.980','2026-04-02','14:41:30','PLG0078744','1127000','1127000','5000','1132000','1132000','kasir','2026-04-02 14:41:29','F22602024129');
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-04-02','F226020241291','2026-04-02','14:41:30','RTA','1132000','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-260402-0034','D','2026-04-02','14:41:30','kasir','PENJUALAN','F226020241291','7991790000','1132000','7992922000');
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 ('F226020251401','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZABA-4-T','AS EXTENSION LG 8K ','','0.200','1','100.00','241000','0','0','15000','246000','0','0','0','246000','TJ','T0076777','S1G','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZABA-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='S1G-ZABA-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226020251401','2026-04-02','0.200','2026-04-02','14:51:41','PLG0078745','246000','246000','0','246000','246000','kasir','2026-04-02 14:51:40','F22602025140');
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-04-02','F226020251401','2026-04-02','14:51:41','TJ','246000','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-260402-0035','D','2026-04-02','14:51:41','kasir','PENJUALAN','F226020251401','7992922000','246000','7993168000');
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 ('F226020320571','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZCAH-9-T','KL LONG LING UB 40CM 8K ','','1.980','1','100.00','2307000','0','0','15000','2317000','0','0','0','2317000','RTA','T0078197','H1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAH-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1E-ZCAH-9-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 ('F226020320571','2026-04-02','1.980','2026-04-02','15:20:58','PLG0078746','2317000','2317000','0','2317000','2317000','kasir','2026-04-02 15:20:57','F22602032057');
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-04-02','F226020320571','2026-04-02','15:20:58','RTA','2317000','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-260402-0036','D','2026-04-02','15:20:58','kasir','PENJUALAN','F226020320571','7993168000','2317000','7995485000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2317000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020320571' 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 ('F226020320572','kasir',' 1',' MDA1 LG ','TOKO','SMBK-A','A1D-YIXH-23-T','AT JERSY MRICAN VAR LG 8K ','','1.070','1','100.00','1225000','0','0','15000','1231000','0','0','0','1231000','RTA','T0073032','A1D','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIXH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='A1D-YIXH-23-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 ('F226020320572','2026-04-02','1.070','2026-04-02','15:20:58','PLG0078747','1231000','1231000','0','1231000','1231000','kasir','2026-04-02 15:20:57','F22602032057');
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-04-02','F226020320572','2026-04-02','15:20:58','RTA','1231000','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-260402-0037','D','2026-04-02','15:20:58','kasir','PENJUALAN','F226020320572','7995485000','1231000','7996716000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1231000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020320572' 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 ('F226020320573','kasir',' 1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZBAD-71-T','CC MODEL DAUN SLEP VAR CM 14 8K ','','0.900','1','100.00','1030000','0','0','15000','1035000','0','0','0','1035000','RTA','T0077360','E1D','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='E1D-ZBAD-71-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 ('F226020320573','2026-04-02','0.900','2026-04-02','15:20:58','PLG0078748','1035000','1035000','0','1035000','1035000','kasir','2026-04-02 15:20:57','F22602032057');
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-04-02','F226020320573','2026-04-02','15:20:58','RTA','1035000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260402-0038','D','2026-04-02','15:20:58','kasir','PENJUALAN','F226020320573','7996716000','1035000','7997751000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020320573' 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 ('F226020334331','kasir','1',' MFH1 15K B','TOKO','SMBK-H','H1F-ZCAH-7-T','KL TRIXIE MODEL BUNGA PASIR VAR BG 8K ','','2.810','1','100.00','3330000','0','0','15000','3345000','0','15000','0','3360000','RHM','T0078195','H1F','0','0','-','0','1185000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-ZCAH-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1F-ZCAH-7-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 ('F226020334331','2026-04-02','2.810','2026-04-02','15:34:33','PLG0078749','3345000','3345000','15000','3360000','3360000','kasir','2026-04-02 15:34:33','F22602033433');
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-04-02','F226020334331','2026-04-02','15:34:33','RHM','3360000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260402-0039','D','2026-04-02','15:34:33','kasir','PENJUALAN','F226020334331','7997751000','3360000','8001111000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3360000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020334331' 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 ('F226020334332','kasir',' 1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZCAH-2-T','KL LONG LING UB 44CM 8K ','','2.080','1','100.00','2423000','0','0','15000','2435000','0','0','0','2435000','RHM','T0078190','H1E','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-04-02' AND kode_barang='H1E-ZCAH-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 ('F226020334332','2026-04-02','2.080','2026-04-02','15:34:33','PLG0078750','2435000','2435000','0','2435000','2435000','kasir','2026-04-02 15:34:33','F22602033433');
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-04-02','F226020334332','2026-04-02','15:34:33','RHM','2435000','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-260402-0040','D','2026-04-02','15:34:33','kasir','PENJUALAN','F226020334332','8001111000','2435000','8003546000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2435000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020334332' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020204051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020204051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020204051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020204052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020204052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020204052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020241291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020241291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020241291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020251401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020251401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020320571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020320572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320573' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020320573' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020320573';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020334331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020334331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020334331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020334332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020334332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020334332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020842531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020842531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020842531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020842532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020842532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020842532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936297' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936297' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936297';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936298' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020936298' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020936298';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938113' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938113' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938113';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938114' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938114' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938114';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938115' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938115' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938115';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938116' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020938116' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020938116';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021004101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021004101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021004101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021103451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021103451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021103451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021103452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021103452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021103452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021113461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021113461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021113461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021150581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021150581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021150581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021200411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021200411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021200411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021202061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021202061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021206391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021206391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021206391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021221171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021221171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021221171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021228511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021228511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021228511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021239301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021239301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021239301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021239302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021239302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021239302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021252221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021252221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021252221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021252222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021252222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021252222';
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-00005240','X-00005240','GL RANTAI HOLLOW DOUBLE KH 8K','GR','---','F3E','BELI','BELI001','2700000','2026-04-02','2.520','1','kasir','2026-04-02 15:59:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005240','X-00005240');
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-260402-0001','F226200123491','NS','1','BELI','BELI001','F3E', 'X-00005240', 'GL RANTAI HOLLOW DOUBLE KH 8K','2.520','2.520','100.00','3000000','2700000','1071429','1165000','1','2700000','2700000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.520',berat_beli_asli=berat_beli_asli+'2.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.520',berat_akhir_asli=berat_akhir_asli+'2.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-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-260402-0001','2026-04-02','2026-04-02','15:59:14','NS','---','2.520','2700000','2700000','2700000','2700000','2700000','kasir','2026-04-02 15:59:15','FB-260402-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260402-0001','ROFI','JLN KBP DURIAT NO 28B','','','081372984690','kasir','2026-04-02 15:59:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-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-260402-0041','K','2026-04-02','15:59:14','kasir','PEMBELIAN UMUM','FB-260402-0001','8003546000','2700000','8000846000');
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-00005241','X-00005241','AT JERSY MODEL HATI VAR LG 8K','GR','---','A1D','BELI','BELI001','845000','2026-04-02','1.050','1','kasir','2026-04-02 15:59:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005241','X-00005241');
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-260402-0002','F225221144061','RTA','1','BELI','BELI001','A1D', 'X-00005241', 'AT JERSY MODEL HATI VAR LG 8K','1.050','1.050','100.00','785000','845000','804762','1145000','1','845000','845000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260402-0002','2026-04-02','2026-04-02','15:59:47','RTA','---','1.050','845000','845000','845000','845000','845000','kasir','2026-04-02 15:59:47','FB-260402-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260402-0002','AYU','SUKOSARI BABADAN','','','083866446903','kasir','2026-04-02 15:59:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-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-260402-0042','K','2026-04-02','15:59:47','kasir','PEMBELIAN UMUM','FB-260402-0002','8000846000','845000','8000001000');
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-00005242','X-00005242','GW TUSUK MATA LG 8K','GR','---','B1G','BELI','BELI001','348000','2026-04-02','0.320','1','kasir','2026-04-02 16:00:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00005242','X-00005242');
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-260402-0003','F226100137491','NS','1','BELI','BELI001','B1G', 'X-00005242', 'GW TUSUK MATA LG 8K','0.320','0.320','100.00','420000','348000','1087500','1205000','1','348000','348000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1G' 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-260402-0003','2026-04-02','2026-04-02','16:00:27','NS','---','0.320','348000','348000','348000','348000','348000','kasir','2026-04-02 16:00:28','FB-260402-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260402-0003','MEGA','GELANGKULON SAMPUNG','','','085600601680','kasir','2026-04-02 16:00:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-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-260402-0043','K','2026-04-02','16:00:27','kasir','PEMBELIAN UMUM','FB-260402-0003','8000001000','348000','7999653000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260402-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260402-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260402-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260402-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260402-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260402-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-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-04-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-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-260403-0001','D','2026-04-03','16:41:42','SYSTEM','SALDO AWAL','SALDO AWAL','0','7999653000','7999653000');
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-260403-0001','D','2026-04-03','16:41:42','BCA','SALDO AWAL','SALDO AWAL','0','4323967888','4323967888');
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-260403-0001','D','2026-04-03','16:41:42','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-260403-0001','D','2026-04-03','16:41:42','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-260403-0001','D','2026-04-03','16:41:42','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-260403-0001','D','2026-04-03','16:41:42','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-04-03';