INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-28';
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-06-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-28' 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-260629-0001','D','2026-06-29','08:45:59','SYSTEM','SALDO AWAL','SALDO AWAL','0','11415086000','11415086000');
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-260629-0001','D','2026-06-29','08:45:59','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-260629-0001','D','2026-06-29','08:45:59','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-260629-0001','D','2026-06-29','08:45:59','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-260629-0001','D','2026-06-29','08:45:59','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260629-0001','D','2026-06-29','08:45:59','BCA','SALDO AWAL','SALDO AWAL','0','4592341888','4592341888');
UPDATE tp_system SET tgl_system='2026-06-29';
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 ('F226290850221','kasir','1',' MEA1E LG ','TOKO','SMBK-A','A1E-ZFBC-5-T','AT DAISY MATA SLEP LG 8K ','OL','0.500','1','100.00','532000','0','0','15000','543000','0','5000','0','548000','TIN','T0080614','A1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBC-5-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-06-29' AND kode_barang='A1E-ZFBC-5-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 ('F226290850221','2026-06-29','0.500','2026-06-29','08:50:23','PLG0081623','543000','543000','5000','548000','548000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850221','2026-06-29','08:50:23','TIN','548000','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-260629-0002','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850221','11415086000','548000','11415634000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850221' 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 ('F226290850222','kasir',' 1',' MEA1E LG ','TOKO','SMBK-A','A1E-ZFBC-6-T','AT DAISY MATA SLEP LG 8K ','OL','0.500','1','100.00','532000','0','0','15000','543000','0','5000','0','548000','TIN','T0080615','A1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBC-6-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-06-29' AND kode_barang='A1E-ZFBC-6-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 ('F226290850222','2026-06-29','0.500','2026-06-29','08:50:23','PLG0081624','543000','543000','5000','548000','548000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850222','2026-06-29','08:50:23','TIN','548000','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-260629-0003','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850222','11415634000','548000','11416182000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850222' 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 ('F226290850223','kasir',' 1',' MFB1 X BW ','TOKO','SMBK-B','B0C-ZFBB-272-0','GW X MRICAN DG 8K ','OL','0.510','1','100.00','533000','0','0','15000','564000','0','5000','0','569000','TIN','00409851','B0C','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-ZFBB-272-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='B0C-ZFBB-272-0' 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 ('F226290850223','2026-06-29','0.510','2026-06-29','08:50:23','PLG0081625','564000','564000','5000','569000','569000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850223','2026-06-29','08:50:23','TIN','569000','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-260629-0004','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850223','11416182000','569000','11416751000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='569000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850223' 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 ('F226290850224','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-3-T','CC MODEL SPECTRA KH 14 8K ','OL','0.370','1','100.00','401000','0','0','15000','409000','0','5000','0','414000','TIN','T0080745','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-3-T' 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-06-29' AND kode_barang='E1F-ZFBE-3-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 ('F226290850224','2026-06-29','0.370','2026-06-29','08:50:23','PLG0081626','409000','409000','5000','414000','414000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850224','2026-06-29','08:50:23','TIN','414000','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-260629-0005','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850224','11416751000','414000','11417165000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='414000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850224' 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 ('F226290850225','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-46-T','CC MODEL SLEP CM 14 8K ','OL','0.480','1','100.00','511000','0','0','15000','521000','0','5000','0','526000','TIN','T0080788','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFBE-46-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 ('F226290850225','2026-06-29','0.480','2026-06-29','08:50:23','PLG0081627','521000','521000','5000','526000','526000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850225','2026-06-29','08:50:23','TIN','526000','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-260629-0006','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850225','11417165000','526000','11417691000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850225' 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 ('F226290850226','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-48-T','CC MODEL SLEP CM 16 8K ','OL','0.550','1','100.00','586000','0','0','15000','597000','0','5000','0','602000','TIN','T0080790','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFBE-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226290850226','2026-06-29','0.550','2026-06-29','08:50:23','PLG0081628','597000','597000','5000','602000','602000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850226','2026-06-29','08:50:23','TIN','602000','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-260629-0007','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850226','11417691000','602000','11418293000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850226' 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 ('F226290850227','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-45-T','CC MODEL SLEP CM 14 8K ','OL','0.560','1','100.00','596000','0','0','15000','608000','0','5000','0','613000','TIN','T0080787','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFBE-45-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 ('F226290850227','2026-06-29','0.560','2026-06-29','08:50:23','PLG0081629','608000','608000','5000','613000','613000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850227','2026-06-29','08:50:23','TIN','613000','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-260629-0008','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850227','11418293000','613000','11418906000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850227' 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 ('F226290850228','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-47-T','CC MODEL SLEP CM 16 8K ','OL','0.660','1','100.00','703000','0','0','15000','716000','0','5000','0','721000','TIN','T0080789','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFBE-47-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 ('F226290850228','2026-06-29','0.660','2026-06-29','08:50:23','PLG0081630','716000','716000','5000','721000','721000','kasir','2026-06-29 08:50:22','F22629085022');
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-06-29','F226290850228','2026-06-29','08:50:23','TIN','721000','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-260629-0009','D','2026-06-29','08:50:23','kasir','PENJUALAN','F226290850228','11418906000','721000','11419627000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='721000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290850228' 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 ('F226290851141','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZFBB-134-0','CC X MODEL SLEP CM 20 8K ','OL','1.150','1','100.00','1202000','0','0','15000','1219000','0','6000','0','1225000','TIN','00409713','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBB-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZFBB-134-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 ('F226290851141','2026-06-29','1.150','2026-06-29','08:51:15','PLG0081631','1219000','1219000','6000','1225000','1225000','kasir','2026-06-29 08:51:14','F22629085114');
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-06-29','F226290851141','2026-06-29','08:51:15','TIN','1225000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260629-0010','D','2026-06-29','08:51:15','kasir','PENJUALAN','F226290851141','11419627000','1225000','11420852000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1225000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290851141' 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 ('F226290851142','kasir',' 1',' MEF2 HW 55','TOKO','SMBK-F','F2E-ZFBC-33-T','GL OVAL MODEL PAKU MATA SLEP HW 55 8K ','OL','2.080','1','100.00','2215000','0','0','15000','2247000','0','10000','0','2257000','TIN','T0080642','F2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFBC-33-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-06-29' AND kode_barang='F2E-ZFBC-33-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 ('F226290851142','2026-06-29','2.080','2026-06-29','08:51:15','PLG0081632','2247000','2247000','10000','2257000','2257000','kasir','2026-06-29 08:51:14','F22629085114');
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-06-29','F226290851142','2026-06-29','08:51:15','TIN','2257000','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-260629-0011','D','2026-06-29','08:51:15','kasir','PENJUALAN','F226290851142','11420852000','2257000','11423109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2257000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290851142' 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 ('F226290851551','kasir','1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZFBC-48-T','CC MODEL ISYANA SLEP LG 18 8K ','OL','1.120','1','100.00','1170000','0','0','15000','1187000','0','6000','0','1193000','TIN','T0080657','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBC-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZFBC-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226290851551','2026-06-29','1.120','2026-06-29','08:51:56','PLG0081633','1187000','1187000','6000','1193000','0','kasir','2026-06-29 08:51:55','F22629085155');
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-06-29','F226290851551','2026-06-29','08:51:56','TIN','1193000','6000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260629-0001','2026-06-29','2026-06-29 08:51:55','PENJUALAN : F226290851551','476574657677','BCA','1193000','1193000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0002','D','2026-06-29','08:51:56','BCA','PENJUALAN','F226290851551','4592341888','1193000','4593534888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('476574657677','EVITASARI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1193000' WHERE no_faktur_jual='F226290851551' 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 ('F226290933001','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-49-T','GL KOREA SLEP UB 8K ','OL','0.570','1','100.00','607000','0','0','15000','618000','0','5000','0','623000','TIN','T0080484','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-49-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-06-29' AND kode_barang='F3E-ZFAF-49-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 ('F226290933001','2026-06-29','0.570','2026-06-29','09:33:01','PLG0081634','618000','618000','5000','623000','623000','kasir','2026-06-29 09:33:00','F22629093300');
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-06-29','F226290933001','2026-06-29','09:33:01','TIN','623000','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-260629-0012','D','2026-06-29','09:33:01','kasir','PENJUALAN','F226290933001','11423109000','623000','11423732000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='623000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290933001' 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 ('F226290933002','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-50-T','GL KOREA SLEP UB 8K ','OL','0.580','1','100.00','618000','0','0','15000','629000','0','5000','0','634000','TIN','T0080485','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F3E-ZFAF-50-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 ('F226290933002','2026-06-29','0.580','2026-06-29','09:33:01','PLG0081635','629000','629000','5000','634000','634000','kasir','2026-06-29 09:33:00','F22629093300');
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-06-29','F226290933002','2026-06-29','09:33:01','TIN','634000','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-260629-0013','D','2026-06-29','09:33:01','kasir','PENJUALAN','F226290933002','11423732000','634000','11424366000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='634000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290933002' 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 ('F226290933003','kasir',' 1',' MEF3 6K UB','TOKO','SMBK-F','F3E-ZFXD-33-T','GL RANTAI P3 SLEP UB 8K ','OL','1.020','1','100.00','1086000','0','0','15000','1101000','0','6000','0','1107000','TIN','T0080198','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F3E-ZFXD-33-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 ('F226290933003','2026-06-29','1.020','2026-06-29','09:33:01','PLG0081636','1101000','1101000','6000','1107000','1107000','kasir','2026-06-29 09:33:00','F22629093300');
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-06-29','F226290933003','2026-06-29','09:33:01','TIN','1107000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260629-0014','D','2026-06-29','09:33:01','kasir','PENJUALAN','F226290933003','11424366000','1107000','11425473000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290933003' 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 ('F226290933004','kasir',' 1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZEAE-96-T','KL KOREA UB 44CM 8K ','OL','1.450','1','100.00','1544000','0','0','15000','1566000','0','7000','0','1573000','TIN','T0079522','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEAE-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1E-ZEAE-96-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 ('F226290933004','2026-06-29','1.450','2026-06-29','09:33:01','PLG0081637','1566000','1566000','7000','1573000','1573000','kasir','2026-06-29 09:33:00','F22629093300');
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-06-29','F226290933004','2026-06-29','09:33:01','TIN','1573000','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-260629-0015','D','2026-06-29','09:33:01','kasir','PENJUALAN','F226290933004','11425473000','1573000','11427046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290933004' 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 ('F226290933005','kasir',' 1',' MEH1E HW 4','TOKO','SMBK-H','H1E-ZFBC-79-T','KL RANTAI CD VAR SLEP HW 42 8K ','OL','2.000','1','100.00','2130000','0','0','15000','2160000','0','10000','0','2170000','TIN','T0080688','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBC-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1E-ZFBC-79-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 ('F226290933005','2026-06-29','2.000','2026-06-29','09:33:01','PLG0081638','2160000','2160000','10000','2170000','2170000','kasir','2026-06-29 09:33:00','F22629093300');
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-06-29','F226290933005','2026-06-29','09:33:01','TIN','2170000','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-260629-0016','D','2026-06-29','09:33:01','kasir','PENJUALAN','F226290933005','11427046000','2170000','11429216000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2170000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290933005' 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 ('F226290958121','kasir','1',' MFD1 10K B','TOKO','SMBK-D','D1F-ZFBD-49-T','LT MODEL FISH SLEP BG 8K ','OL','1.960','1','100.00','2127000','0','0','15000','2156000','0','10000','0','2166000','TIN','T0080737','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBD-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='D1F-ZFBD-49-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 ('F226290958121','2026-06-29','1.960','2026-06-29','09:58:12','PLG0081639','2156000','2156000','10000','2166000','2166000','kasir','2026-06-29 09:58:12','F22629095812');
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-06-29','F226290958121','2026-06-29','09:58:12','TIN','2166000','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-260629-0017','D','2026-06-29','09:58:12','kasir','PENJUALAN','F226290958121','11429216000','2166000','11431382000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2166000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290958121' 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 ('F226290958122','kasir',' 1',' MFD1 12K B','TOKO','SMBK-D','D1F-ZFBD-51-T','LT MODEL FISH SLEP BG 8K ','OL','2.330','1','100.00','2528000','0','0','15000','2563000','0','12000','0','2575000','TIN','T0080739','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBD-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='D1F-ZFBD-51-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 ('F226290958122','2026-06-29','2.330','2026-06-29','09:58:12','PLG0081640','2563000','2563000','12000','2575000','2575000','kasir','2026-06-29 09:58:12','F22629095812');
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-06-29','F226290958122','2026-06-29','09:58:12','TIN','2575000','12000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260629-0018','D','2026-06-29','09:58:12','kasir','PENJUALAN','F226290958122','11431382000','2575000','11433957000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290958122' 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 ('F226291025561','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDCX-13-T','GL GENIA UB 8K ','','0.540','1','100.00','575000','0','0','15000','580000','0','0','0','580000','TIN','T0079082','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F3E-ZDCX-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226291025561','2026-06-29','0.540','2026-06-29','10:25:57','PLG0081641','580000','580000','0','580000','580000','kasir','2026-06-29 10:25:56','F22629102556');
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-06-29','F226291025561','2026-06-29','10:25:57','TIN','580000','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-260629-0019','D','2026-06-29','10:25:57','kasir','PENJUALAN','F226291025561','11433957000','580000','11434537000');
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 ('F226291054081','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-41-T','CC WEDDING MATA SLEP CM 8 8K ','','1.600','1','100.00','1672000','0','0','15000','1688000','0','10000','0','1698000','TIN','T0079924','E2D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-ZEBF-41-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 ('F226291054081','2026-06-29','1.600','2026-06-29','10:54:09','PLG0081642','1688000','1688000','10000','1698000','1698000','kasir','2026-06-29 10:54:08','F22629105408');
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-06-29','F226291054081','2026-06-29','10:54:09','TIN','1698000','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-260629-0020','D','2026-06-29','10:54:09','kasir','PENJUALAN','F226291054081','11434537000','1698000','11436235000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1698000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291054081' 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 ('F226291054082','kasir',' 1',' MEE1E HT 1','TOKO','SMBK-E','E1E-ZFAI-16-T','CC MODEL BANGKOK SLEP HT 10 8K ','','0.550','1','100.00','586000','0','0','15000','591000','0','0','0','591000','TIN','T0080516','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFAI-16-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 ('F226291054082','2026-06-29','0.550','2026-06-29','10:54:09','PLG0081643','591000','591000','0','591000','591000','kasir','2026-06-29 10:54:08','F22629105408');
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-06-29','F226291054082','2026-06-29','10:54:09','TIN','591000','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-260629-0021','D','2026-06-29','10:54:09','kasir','PENJUALAN','F226291054082','11436235000','591000','11436826000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='591000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291054082' 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 ('F226291056201','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-8-T','CC MODEL DAUN SLEP LG 12 8K ','','0.440','1','100.00','469000','0','0','15000','473000','0','0','0','473000','TIN','T0079949','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZEBH-8-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 ('F226291056201','2026-06-29','0.440','2026-06-29','10:56:21','PLG0081644','473000','473000','0','473000','473000','kasir','2026-06-29 10:56:20','F22629105620');
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-06-29','F226291056201','2026-06-29','10:56:21','TIN','473000','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-260629-0022','D','2026-06-29','10:56:21','kasir','PENJUALAN','F226291056201','11436826000','473000','11437299000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291056201' 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 ('F226291056202','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-36-T','CC MODEL DAUN SLEP LG 16 8K ','','0.480','1','100.00','511000','0','0','15000','516000','0','0','0','516000','TIN','T0080536','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFAI-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226291056202','2026-06-29','0.480','2026-06-29','10:56:21','PLG0081645','516000','516000','0','516000','516000','kasir','2026-06-29 10:56:20','F22629105620');
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-06-29','F226291056202','2026-06-29','10:56:21','TIN','516000','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-260629-0023','D','2026-06-29','10:56:21','kasir','PENJUALAN','F226291056202','11437299000','516000','11437815000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='516000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291056202' 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 ('F226291136021','kasir','1',' TEH1 X HW4','TOKO','TBK-H','H1TE-ZEBB-78-T','KL X RANTAI HOLLOW SLEP HW 46 17K ','','2.970','1','100.00','5910000','0','0','15000','5821000','0','0','0','5821000','TIN','T0079841','H1TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZEBB-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1TE-ZEBB-78-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 ('F226291136021','2026-06-29','2.970','2026-06-29','11:36:02','PLG0081646','5821000','5821000','0','5821000','5821000','kasir','2026-06-29 11:36:02','F22629113602');
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-06-29','F226291136021','2026-06-29','11:36:02','TIN','5821000','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-260629-0024','D','2026-06-29','11:36:02','kasir','PENJUALAN','F226291136021','11437815000','5821000','11443636000');
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 ('F226291140471','kasir','1',' MEF3E X PM','TOKO','SMBK-F','F3E-ZEXE-114-0','GL X KREPYAK DAUN SLEP PM 8K ','','3.880','1','100.00','4132000','0','0','15000','4171000','0','0','0','4171000','TIN','00402287','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXE-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='F3E-ZEXE-114-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 ('F226291140471','2026-06-29','3.880','2026-06-29','11:40:48','PLG0081647','4171000','4171000','0','4171000','4171000','kasir','2026-06-29 11:40:47','F22629114047');
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-06-29','F226291140471','2026-06-29','11:40:48','TIN','4171000','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-260629-0025','D','2026-06-29','11:40:48','kasir','PENJUALAN','F226291140471','11443636000','4171000','11447807000');
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 ('F226291142401','kasir','1',' MDA1 UB ','TOKO','SMBK-A','A1D-ZBAF-39-T','AT HUGGIES KLIP BOLA ARESO UB 8K ','OL','1.070','1','100.00','1118000','0','0','15000','1135000','0','5000','0','1140000','TIN','T0077418','A1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAF-39-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-06-29' AND kode_barang='A1D-ZBAF-39-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 ('F226291142401','2026-06-29','1.070','2026-06-29','11:42:40','PLG0081648','1135000','1135000','5000','1140000','1140000','kasir','2026-06-29 11:42:40','F22629114240');
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-06-29','F226291142401','2026-06-29','11:42:40','TIN','1140000','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-260629-0026','D','2026-06-29','11:42:40','kasir','PENJUALAN','F226291142401','11447807000','1140000','11448947000');
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 ('F226291154441','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXD-65-T','CC MODEL ISYANA SLEP LG 16 8K ','OL','0.600','1','100.00','639000','0','0','15000','651000','0','5000','0','656000','TIN','T0080230','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFXD-65-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 ('F226291154441','2026-06-29','0.600','2026-06-29','11:54:45','PLG0081649','651000','651000','5000','656000','0','kasir','2026-06-29 11:54:44','F22629115444');
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-06-29','F226291154441','2026-06-29','11:54:45','TIN','656000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260629-0002','2026-06-29','2026-06-29 11:54:44','PENJUALAN : F226291154441','097867655342321','BCA','656000','656000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0003','D','2026-06-29','11:54:45','BCA','PENJUALAN','F226291154441','4593534888','656000','4594190888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('097867655342321','HEPY');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='656000' WHERE no_faktur_jual='F226291154441' 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 ('F226291238161','kasir','1',' MEE1E LG 2','TOKO','SMBK-E','E1E-ZFAI-41-T','CC MODEL BANGKOK SLEP LG 20 8K ','OL','0.550','1','100.00','586000','0','0','15000','597000','0','5000','0','602000','TIN','T0080541','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZFAI-41-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 ('F226291238161','2026-06-29','0.550','2026-06-29','12:38:16','PLG0081650','597000','597000','5000','602000','602000','kasir','2026-06-29 12:38:16','F22629123816');
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-06-29','F226291238161','2026-06-29','12:38:16','TIN','602000','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-260629-0027','D','2026-06-29','12:38:16','kasir','PENJUALAN','F226291238161','11448947000','602000','11449549000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291238161' 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 ('F226291238162','kasir',' 1',' MEE1 LG 19','TOKO','SMBK-E','E1E-ZEXH-43-T','CC BANGKOK SLEP LG 19 8K ','OL','0.560','1','100.00','596000','0','0','15000','608000','0','5000','0','613000','TIN','T0079342','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1E-ZEXH-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226291238162','2026-06-29','0.560','2026-06-29','12:38:16','PLG0081651','608000','608000','5000','613000','613000','kasir','2026-06-29 12:38:16','F22629123816');
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-06-29','F226291238162','2026-06-29','12:38:16','TIN','613000','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-260629-0028','D','2026-06-29','12:38:16','kasir','PENJUALAN','F226291238162','11449549000','613000','11450162000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291238162' 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 ('F226291246301','kasir','1',' MGB1G LG ','TOKO','SMBK-B','B1G-ZFBD-19-T','GW MRICAN POLOS SLEP LG 8K ','OL','0.260','1','100.00','287000','0','0','15000','294000','0','5000','0','299000','LUS','T0080707','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='B1G-ZFBD-19-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 ('F226291246301','2026-06-29','0.260','2026-06-29','12:46:31','PLG0081652','294000','294000','5000','299000','299000','kasir','2026-06-29 12:46:30','F22629124630');
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-06-29','F226291246301','2026-06-29','12:46:31','LUS','299000','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-260629-0029','D','2026-06-29','12:46:31','kasir','PENJUALAN','F226291246301','11450162000','299000','11450461000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='299000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291246301' 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 ('F226291246302','kasir',' 1',' MGB1G LG ','TOKO','SMBK-B','B1G-ZFBD-21-T','GW MRICAN POLOS SLEP LG 8K ','OL','0.260','1','100.00','287000','0','0','15000','294000','0','5000','0','299000','LUS','T0080709','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='B1G-ZFBD-21-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 ('F226291246302','2026-06-29','0.260','2026-06-29','12:46:31','PLG0081653','294000','294000','5000','299000','299000','kasir','2026-06-29 12:46:30','F22629124630');
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-06-29','F226291246302','2026-06-29','12:46:31','LUS','299000','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-260629-0030','D','2026-06-29','12:46:31','kasir','PENJUALAN','F226291246302','11450461000','299000','11450760000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='299000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291246302' 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 ('F226291246303','kasir',' 1',' MGB1G LG ','TOKO','SMBK-B','B1G-ZFBD-20-T','GW MRICAN POLOS SLEP LG 8K ','OL','0.260','1','100.00','287000','0','0','15000','294000','0','5000','0','299000','LUS','T0080708','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='B1G-ZFBD-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226291246303','2026-06-29','0.260','2026-06-29','12:46:31','PLG0081654','294000','294000','5000','299000','299000','kasir','2026-06-29 12:46:30','F22629124630');
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-06-29','F226291246303','2026-06-29','12:46:31','LUS','299000','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-260629-0031','D','2026-06-29','12:46:31','kasir','PENJUALAN','F226291246303','11450760000','299000','11451059000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='299000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291246303' 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 ('F226291246304','kasir',' 1',' MDE1D BM 1','TOKO','SMBK-E','E1D-ZFBD-30-T','CC VELG C SLEP BM 12 8K ','OL','1.010','1','100.00','1055000','0','0','15000','1081000','0','5000','0','1086000','LUS','T0080718','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBD-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZFBD-30-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 ('F226291246304','2026-06-29','1.010','2026-06-29','12:46:31','PLG0081655','1081000','1081000','5000','1086000','1086000','kasir','2026-06-29 12:46:30','F22629124630');
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-06-29','F226291246304','2026-06-29','12:46:31','LUS','1086000','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-260629-0032','D','2026-06-29','12:46:31','kasir','PENJUALAN','F226291246304','11451059000','1086000','11452145000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1086000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291246304' 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 ('F226291246305','kasir',' 1',' MDE1D BM 1','TOKO','SMBK-E','E1D-ZFBD-29-T','CC VELG C SLEP BM 16 8K ','OL','1.050','1','100.00','1097000','0','0','15000','1124000','0','5000','0','1129000','LUS','T0080717','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBD-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZFBD-29-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 ('F226291246305','2026-06-29','1.050','2026-06-29','12:46:31','PLG0081656','1124000','1124000','5000','1129000','1129000','kasir','2026-06-29 12:46:30','F22629124630');
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-06-29','F226291246305','2026-06-29','12:46:31','LUS','1129000','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-260629-0033','D','2026-06-29','12:46:31','kasir','PENJUALAN','F226291246305','11452145000','1129000','11453274000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1129000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291246305' 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 ('F226290113421','kasir','1',' MEH1 15K U','TOKO','SMBK-H','H1E-YLCA-5-T','KL SANTA ANAK MODEL CAT 35 UB 8K ','OLS 3HAT2','2.550','1','100.00','2716000','0','0','15000','2767000','0','189000','0','2956000','TIN','T0076287','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLCA-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1E-YLCA-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226290113421','2026-06-29','2.550','2026-06-29','13:13:44','PLG0081657','2767000','2767000','189000','2956000','2956000','kasir','2026-06-29 13:13:42','F22629011342');
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-06-29','F226290113421','2026-06-29','13:13:44','TIN','2956000','189000');
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-260629-0034','D','2026-06-29','13:13:44','kasir','PENJUALAN','F226290113421','11453274000','2956000','11456230000');
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 ('F226290145441','kasir','1',' MED2D CM 1','TOKO','SMBK-E','E2D-ZFAI-46-T','CC MODEL WEDDING MATA SLEP CM 12 8K ','','0.920','1','100.00','961000','0','0','15000','989000','0','0','0','989000','TIN','T0080546','E2D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAI-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-ZFAI-46-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 ('F226290145441','2026-06-29','0.920','2026-06-29','13:45:45','PLG0081658','989000','989000','0','989000','0','kasir','2026-06-29 13:45:44','F22629014544');
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-06-29','F226290145441','2026-06-29','13:45:45','TIN','989000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260629-0003','2026-06-29','2026-06-29 13:45:44','PENJUALAN : F226290145441','256587998','BCA','989000','989000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260629-0004','D','2026-06-29','13:45:45','BCA','PENJUALAN','F226290145441','4594190888','989000','4595179888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('256587998','WAKHID');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='989000' WHERE no_faktur_jual='F226290145441' 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 ('F226290219481','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YBXA-95-T','GW TUSUK MODEL HATI MATA VAR LG PE 8K ','OL','0.610','1','100.00','650000','0','0','15000','662000','0','5000','0','667000','TIN','T0066482','B1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YBXA-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='B1E-YBXA-95-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 ('F226290219481','2026-06-29','0.610','2026-06-29','14:19:48','PLG0081659','662000','662000','5000','667000','667000','kasir','2026-06-29 14:19:48','F22629021948');
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-06-29','F226290219481','2026-06-29','14:19:48','TIN','667000','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-260629-0035','D','2026-06-29','14:19:48','kasir','PENJUALAN','F226290219481','11456230000','667000','11456897000');
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 ('F226290221091','kasir','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-ZCBC-35-T','KL X CASANO HW 42CM 17K ','OL','1.430','1','100.00','2846000','0','0','15000','2780000','0','10000','0','2790000','TIN','T0078270','H1TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='H1TE-ZCBC-35-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 ('F226290221091','2026-06-29','1.430','2026-06-29','14:21:09','PLG0081660','2780000','2780000','10000','2790000','2790000','kasir','2026-06-29 14:21:09','F22629022109');
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-06-29','F226290221091','2026-06-29','14:21:09','TIN','2790000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0036','D','2026-06-29','14:21:09','kasir','PENJUALAN','F226290221091','11456897000','2790000','11459687000');
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 ('F226290252241','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZEAF-32-T','CC MODEL C CM 18 8K ','OL','1.050','1','100.00','1097000','0','0','15000','1113000','0','5000','0','1118000','TIN','T0079554','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAF-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E1D-ZEAF-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226290252241','2026-06-29','1.050','2026-06-29','14:52:24','PLG0081661','1113000','1113000','5000','1118000','1118000','kasir','2026-06-29 14:52:24','F22629025224');
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-06-29','F226290252241','2026-06-29','14:52:24','TIN','1118000','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-260629-0037','D','2026-06-29','14:52:24','kasir','PENJUALAN','F226290252241','11459687000','1118000','11460805000');
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 ('F226290303461','kasir','1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZECX-24-T','CC MODEL SLEP HW 17 8K ','','0.750','1','100.00','799000','0','0','15000','806000','0','0','0','806000','TIN','T0080090','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-24-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-06-29' AND kode_barang='E1E-ZECX-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226290303461','2026-06-29','0.750','2026-06-29','15:03:47','PLG0081662','806000','806000','0','806000','806000','kasir','2026-06-29 15:03:46','F22629030346');
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-06-29','F226290303461','2026-06-29','15:03:47','TIN','806000','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-260629-0038','D','2026-06-29','15:03:47','kasir','PENJUALAN','F226290303461','11460805000','806000','11461611000');
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-00005485','X-00005485','GL OVAL MODEL C TD D60 8K','GR','---','F1E','BELI','BELI001','2930000','2026-06-29','3.370','1','admin','2026-06-29 15:10:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005485','X-00005485');
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-260629-0001','F225141205581','RHM','1','BELI','BELI001','F1E', 'X-00005485', 'GL OVAL MODEL C TD D60 8K','3.430','3.370','100.00','3602000','2930000','869436','1065000','1','2930000','2930000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.370',berat_beli_asli=berat_beli_asli+'3.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.370',berat_akhir_asli=berat_akhir_asli+'3.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260629-0001','2026-06-29','2026-06-29','15:10:43','RHM','---','3.370','2930000','2930000','2930000','2930000','2930000','admin','2026-06-29 15:10:43','FB-260629-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0001','NUR AINI RAHAYU','JL SUDONOKIRJO M 40','','','082257000759','admin','2026-06-29 15:10:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0039','K','2026-06-29','15:10:43','admin','PEMBELIAN UMUM','FB-260629-0001','11461611000','2930000','11458681000');
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-00005486','X-00005486','CC X WEDDING MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1895000','2026-06-29','2.000','1','admin','2026-06-29 15:11:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005486','X-00005486');
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-260629-0002','F225141043151','TIN','1','BELI','BELI001','E2D', 'X-00005486', 'CC X WEDDING MATA CM 14 8K','2.000','2.000','100.00','2060000','1895000','947500','1055000','1','1895000','1895000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260629-0002','2026-06-29','2026-06-29','15:11:02','TIN','---','2.000','1895000','1895000','1895000','1895000','1895000','admin','2026-06-29 15:11:03','FB-260629-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0002','ELA','NDINOK NGEBEL','','','082337863941','admin','2026-06-29 15:11:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0040','K','2026-06-29','15:11:02','admin','PEMBELIAN UMUM','FB-260629-0002','11458681000','1895000','11456786000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290113421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290113421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290113421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290145441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290145441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290145441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290219481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290219481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290219481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290221091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290221091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290221091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290252241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290252241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290252241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290303461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290303461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290303461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850224' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850224' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850224';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850225' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850225' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850225';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850226' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850226' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850226';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850227' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850227' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850227';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850228' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290850228' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290850228';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290851141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290851142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290851551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290851551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290933001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290933002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290933003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290933004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290933005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290933005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290958121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290958121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290958121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290958122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290958122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290958122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291025561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291025561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291025561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291054081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291054081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291054081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291054082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291054082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291054082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291056201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291056201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291056201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291056202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291056202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291056202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291136021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291136021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291136021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291140471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291140471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291140471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291142401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291142401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291142401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291154441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291154441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291154441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291238161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291238161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291238161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291238162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291238162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291238162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291246301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291246302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246303' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246303' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291246303';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246304' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246304' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291246304';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246305' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291246305' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291246305';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0002';
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 ('F226290333151','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFAH-183-0','CC X MODEL MATA CM 16 8K ','OL','0.910','1','100.00','951000','0','0','15000','969000','0','5000','0','974000','TIN','00409190','E2D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-06-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAH-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-06-29' AND kode_barang='E2D-ZFAH-183-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 ('F226290333151','2026-06-29','0.910','2026-06-29','15:33:16','PLG0081663','969000','969000','5000','974000','974000','kasir','2026-06-29 15:33:15','F22629033315');
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-06-29','F226290333151','2026-06-29','15:33:16','TIN','974000','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-260629-0041','D','2026-06-29','15:33:16','kasir','PENJUALAN','F226290333151','11456786000','974000','11457760000');
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-00005487','X-00005487','CC X MODEL SLEP CM 16 8K','GR','---','E1D','BELI','BELI001','743000','2026-06-29','1.000','1','admin','2026-06-29 16:04:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005487','X-00005487');
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-260629-0003','F225160351141','TIN','1','BELI','BELI001','E1D', 'X-00005487', 'CC X MODEL SLEP CM 16 8K','1.000','1.000','100.00','808000','743000','743000','1055000','1','743000','743000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260629-0003','2026-06-29','2026-06-29','16:04:09','TIN','---','1.000','743000','743000','743000','743000','743000','admin','2026-06-29 16:04:10','FB-260629-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260629-0003','AMANDA','SAWOO','','','085736402966','admin','2026-06-29 16:04:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-29' 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-260629-0042','K','2026-06-29','16:04:09','admin','PEMBELIAN UMUM','FB-260629-0003','11457760000','743000','11457017000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290333151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290333151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290333151';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260629-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260629-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-29';
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-06-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-29' 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-260630-0001','D','2026-06-30','16:17:19','SYSTEM','SALDO AWAL','SALDO AWAL','0','11457017000','11457017000');
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-260630-0001','D','2026-06-30','16:17:19','BCA','SALDO AWAL','SALDO AWAL','0','4595179888','4595179888');
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-260630-0001','D','2026-06-30','16:17:19','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260630-0001','D','2026-06-30','16:17:19','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-260630-0001','D','2026-06-30','16:17:19','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-260630-0001','D','2026-06-30','16:17:19','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-30';