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 ('F226270821391','kasir','1',' MEE1 X UB ','TOKO','SMBK-E','E1E-ZFAH-228-0','CC X SPIRAL SLEP UB 14 8K ','OL','0.740','1','100.00','788000','0','0','15000','799000','0','5000','0','804000','TIN','00409235','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAH-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFAH-228-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 ('F226270821391','2026-06-27','0.740','2026-06-27','08:21:39','PLG0081570','799000','799000','5000','804000','804000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821391','2026-06-27','08:21:39','TIN','804000','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-260627-0002','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821391','11374852000','804000','11375656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='804000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821391' 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 ('F226270821392','kasir',' 1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZFAI-74-T','AT KLIP DAUN SLEP CM 8K ','OL','0.960','1','100.00','1003000','0','0','15000','1018000','0','5000','0','1023000','TIN','T0080574','A1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAI-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='A1D-ZFAI-74-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 ('F226270821392','2026-06-27','0.960','2026-06-27','08:21:39','PLG0081571','1018000','1018000','5000','1023000','1023000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821392','2026-06-27','08:21:39','TIN','1023000','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-260627-0003','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821392','11375656000','1023000','11376679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1023000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821392' 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 ('F226270821393','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-101-T','GW TUSUK HATI SLEP CM 8K ','OL','0.220','1','100.00','243000','0','0','15000','246000','0','5000','0','251000','TIN','T0080601','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='B1G-ZFAI-101-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 ('F226270821393','2026-06-27','0.220','2026-06-27','08:21:39','PLG0081572','246000','246000','5000','251000','251000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821393','2026-06-27','08:21:39','TIN','251000','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-260627-0004','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821393','11376679000','251000','11376930000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='251000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821393' 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 ('F226270821394','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-103-T','GW TUSUK HATI SLEP CM 8K ','OL','0.220','1','100.00','243000','0','0','15000','246000','0','5000','0','251000','TIN','T0080603','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='B1G-ZFAI-103-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 ('F226270821394','2026-06-27','0.220','2026-06-27','08:21:39','PLG0081573','246000','246000','5000','251000','251000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821394','2026-06-27','08:21:39','TIN','251000','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-260627-0005','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821394','11376930000','251000','11377181000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='251000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821394' 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 ('F226270821395','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-100-T','GW TUSUK HATI SLEP CM 8K ','OL','0.220','1','100.00','243000','0','0','15000','246000','0','5000','0','251000','TIN','T0080600','B1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-100-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='B1G-ZFAI-100-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 ('F226270821395','2026-06-27','0.220','2026-06-27','08:21:39','PLG0081574','246000','246000','5000','251000','251000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821395','2026-06-27','08:21:39','TIN','251000','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-260627-0006','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821395','11377181000','251000','11377432000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='251000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821395' 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 ('F226270821396','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFBC-50-T','CC MODEL ISYANA SLEP LG 14 8K ','OL','0.460','1','100.00','490000','0','0','15000','497000','0','5000','0','502000','TIN','T0080659','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBC-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFBC-50-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 ('F226270821396','2026-06-27','0.460','2026-06-27','08:21:39','PLG0081575','497000','497000','5000','502000','502000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821396','2026-06-27','08:21:39','TIN','502000','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-260627-0007','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821396','11377432000','502000','11377934000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='502000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821396' 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 ('F226270821397','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-38-T','CC MODEL ISYANA SLEP LG 10 8K ','OL','0.500','1','100.00','532000','0','0','15000','540000','0','5000','0','545000','TIN','T0080538','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-38-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-27' AND kode_barang='E1E-ZFAI-38-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 ('F226270821397','2026-06-27','0.500','2026-06-27','08:21:39','PLG0081576','540000','540000','5000','545000','545000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821397','2026-06-27','08:21:39','TIN','545000','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-260627-0008','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821397','11377934000','545000','11378479000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821397' 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 ('F226270821398','kasir',' 1',' MEE1 LG 22','TOKO','SMBK-E','E1E-ZFAF-29-T','CC MODEL DAUN SLEP 22 LG 8K','OL','0.550','1','100.00','586000','0','0','15000','594000','0','5000','0','599000','TIN','T0080464','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-29-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-27' AND kode_barang='E1E-ZFAF-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 ('F226270821398','2026-06-27','0.550','2026-06-27','08:21:39','PLG0081577','594000','594000','5000','599000','599000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821398','2026-06-27','08:21:39','TIN','599000','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-260627-0009','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821398','11378479000','599000','11379078000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='599000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821398' 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 ('F226270821399','kasir',' 1',' MDA1D X CM','TOKO','SMBK-A','A1D-ZEXI-119-0','AT X MODEL KLIP DAUN MATA CM 8K ','OL','1.150','1','100.00','1202000','0','0','15000','1213000','0','6000','0','1219000','TIN','00402940','A1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXI-119-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-27' AND kode_barang='A1D-ZEXI-119-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270821399','2026-06-27','1.150','2026-06-27','08:21:39','PLG0081578','1213000','1213000','6000','1219000','1219000','kasir','2026-06-27 08:21:39','F22627082139');
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-27','F226270821399','2026-06-27','08:21:39','TIN','1219000','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-260627-0010','D','2026-06-27','08:21:39','kasir','PENJUALAN','F226270821399','11379078000','1219000','11380297000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1219000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270821399' 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 ('F226270905481','kasir','1',' MKPHK X KH','TOKO','SMBK-P','PHK-YHXH-139-0','KL X WG SANTA KH 42 9K ','OLS PTUD3','2.070','1','100.00','2494000','0','0','15000','2494000','0','238000','0','2732000','TIN','00364667','PHK','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHK-YHXH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='PHK-YHXH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F226270905481','2026-06-27','2.070','2026-06-27','09:05:48','PLG0081579','2494000','2494000','238000','2732000','2732000','kasir','2026-06-27 09:05:48','F22627090548');
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-27','F226270905481','2026-06-27','09:05:48','TIN','2732000','238000');
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-260627-0011','D','2026-06-27','09:05:48','kasir','PENJUALAN','F226270905481','11380297000','2732000','11383029000');
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 ('F226270921371','kasir','1',' MKPHK X KH','TOKO','SMBK-P','PHK-YHXH-139-0','KL X WG SANTA KH 42 9K ','OLS PTUD3','2.070','1','100.00','2494000','0','0','15000','2494000','0','258000','0','2752000','TIN','00364667','PHK','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHK-YHXH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='PHK-YHXH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F226270921371','2026-06-27','2.070','2026-06-27','09:21:38','PLG0081580','2494000','2494000','258000','2752000','2752000','kasir','2026-06-27 09:21:37','F22627092137');
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-27','F226270921371','2026-06-27','09:21:38','TIN','2752000','258000');
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-260627-0013','D','2026-06-27','09:21:38','kasir','PENJUALAN','F226270921371','11380297000','2752000','11383049000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260627-0001','1','H1E-ZECX-8-T','1','1.710','1.710','TOKO','SMBK-H','TOKO','BK-H');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-H' WHERE kode_barang='H1E-ZECX-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-H';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-27','TOKO','BK-H','H1E','H1E-ZECX-8-T','100.00','1','1.710','1.710','1','1.710','1.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.710',berat_out_asli=berat_out_asli+'1.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-27' AND kode_barang='H1E-ZECX-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260627-0001','2026-06-27','2026-06-27','09:25','1.71','admin','2026-06-27 09:25:18');
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 ('F226270948241','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-8-T','CC MODEL SPECTRA KH 14 8K ','OL','0.370','1','100.00','401000','0','0','15000','409000','0','5000','0','414000','TIN','T0080750','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-8-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-27' AND kode_barang='E1F-ZFBE-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 ('F226270948241','2026-06-27','0.370','2026-06-27','09:48:24','PLG0081581','409000','409000','5000','414000','0','kasir','2026-06-27 09:48:24','F22627094824');
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-27','F226270948241','2026-06-27','09:48:24','TIN','414000','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-260627-0001','2026-06-27','2026-06-27 09:48:24','PENJUALAN : F226270948241','5767665654','BCA','414000','414000','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-260627-0002','D','2026-06-27','09:48:24','BCA','PENJUALAN','F226270948241','4589625888','414000','4590039888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('5767665654','ROZAQ');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='414000' WHERE no_faktur_jual='F226270948241' 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 ('F226270949441','kasir','1',' MEB1E BM ','TOKO','SMBK-B','B1E-ZFBE-67-T','GW TUSUK PANJANG VAR SLEP BM 8K ','OL','0.590','1','100.00','628000','0','0','15000','640000','0','5000','0','645000','TIN','T0080809','B1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFBE-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='B1E-ZFBE-67-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 ('F226270949441','2026-06-27','0.590','2026-06-27','09:49:45','PLG0081582','640000','640000','5000','645000','645000','kasir','2026-06-27 09:49:44','F22627094944');
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-27','F226270949441','2026-06-27','09:49:45','TIN','645000','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-260627-0014','D','2026-06-27','09:49:45','kasir','PENJUALAN','F226270949441','11383049000','645000','11383694000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='645000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270949441' 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 ('F226270949442','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-16-T','CC MODEL ARESO SLEP KH 15 8K ','OL','0.340','1','100.00','369000','0','0','15000','376000','0','5000','0','381000','TIN','T0080758','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-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 ('F226270949442','2026-06-27','0.340','2026-06-27','09:49:45','PLG0081583','376000','376000','5000','381000','381000','kasir','2026-06-27 09:49:44','F22627094944');
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-27','F226270949442','2026-06-27','09:49:45','TIN','381000','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-260627-0015','D','2026-06-27','09:49:45','kasir','PENJUALAN','F226270949442','11383694000','381000','11384075000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='381000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270949442' 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 ('F226270949443','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-17-T','CC MODEL ARESO SLEP KH 15 8K ','OL','0.370','1','100.00','401000','0','0','15000','409000','0','5000','0','414000','TIN','T0080759','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-17-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-27' AND kode_barang='E1F-ZFBE-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270949443','2026-06-27','0.370','2026-06-27','09:49:45','PLG0081584','409000','409000','5000','414000','414000','kasir','2026-06-27 09:49:44','F22627094944');
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-27','F226270949443','2026-06-27','09:49:45','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-260627-0016','D','2026-06-27','09:49:45','kasir','PENJUALAN','F226270949443','11384075000','414000','11384489000','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='F226270949443' 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 ('F226270949444','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1F-ZFBE-28-T','CC MODEL SLEP HW 15 8K ','OL','0.380','1','100.00','412000','0','0','15000','420000','0','5000','0','425000','TIN','T0080770','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-28-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 ('F226270949444','2026-06-27','0.380','2026-06-27','09:49:45','PLG0081585','420000','420000','5000','425000','425000','kasir','2026-06-27 09:49:44','F22627094944');
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-27','F226270949444','2026-06-27','09:49:45','TIN','425000','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-260627-0017','D','2026-06-27','09:49:45','kasir','PENJUALAN','F226270949444','11384489000','425000','11384914000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270949444' 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 ('F226270949445','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFBE-70-T','GL KAKI SIEM COBRA SLEP UB 8K ','OL','0.580','1','100.00','618000','0','0','15000','630000','0','5000','0','635000','TIN','T0080812','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBE-70-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-27' AND kode_barang='F3E-ZFBE-70-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 ('F226270949445','2026-06-27','0.580','2026-06-27','09:49:45','PLG0081586','630000','630000','5000','635000','635000','kasir','2026-06-27 09:49:44','F22627094944');
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-27','F226270949445','2026-06-27','09:49:45','TIN','635000','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-260627-0018','D','2026-06-27','09:49:45','kasir','PENJUALAN','F226270949445','11384914000','635000','11385549000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270949445' 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 ('F226271008111','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZEAE-281-0','KL KOREA UB 44CM 8K ','OL','1.520','1','100.00','1619000','0','0','15000','1642000','0','8000','0','1650000','TIN','00403760','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEAE-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='H1E-ZEAE-281-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271008111','2026-06-27','1.520','2026-06-27','10:08:11','PLG0081587','1642000','1642000','8000','1650000','1650000','kasir','2026-06-27 10:08:11','F22627100811');
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-27','F226271008111','2026-06-27','10:08:11','TIN','1650000','8000');
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-260627-0019','D','2026-06-27','10:08:11','kasir','PENJUALAN','F226271008111','11385549000','1650000','11387199000');
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 ('F226271035271','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YKBH-30-T','GW TUSUK BUNGA MATA VAR LG PE 8K ','OL','0.610','1','100.00','650000','0','0','15000','662000','0','5000','0','667000','TIN','T0075262','B1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKBH-30-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-27' AND kode_barang='B1E-YKBH-30-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 ('F226271035271','2026-06-27','0.610','2026-06-27','10:35:27','PLG0081588','662000','662000','5000','667000','667000','kasir','2026-06-27 10:35:27','F22627103527');
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-27','F226271035271','2026-06-27','10:35:27','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,status_valid) VALUES ('KM-260627-0020','D','2026-06-27','10:35:27','kasir','PENJUALAN','F226271035271','11387199000','667000','11387866000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='667000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271035271' 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 ('F226271035272','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZFAG-177-0','GL X TIFF BONEKA ANAK CAT VAR YT 8K ','OL','1.770','1','100.00','1885000','0','0','15000','1911000','0','9000','0','1920000','TIN','00409000','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAG-177-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='F3E-ZFAG-177-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 ('F226271035272','2026-06-27','1.770','2026-06-27','10:35:27','PLG0081589','1911000','1911000','9000','1920000','1920000','kasir','2026-06-27 10:35:27','F22627103527');
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-27','F226271035272','2026-06-27','10:35:27','TIN','1920000','9000');
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-260627-0021','D','2026-06-27','10:35:27','kasir','PENJUALAN','F226271035272','11387866000','1920000','11389786000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1920000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271035272' 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 ('F226271122231','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZFAF-5-T','GL OVAL C SLEP UB 54 8K ','OL','2.270','1','100.00','2418000','0','0','15000','2452000','0','11000','0','2463000','TIN','T0080440','F1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFAF-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='F1E-ZFAF-5-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 ('F226271122231','2026-06-27','2.270','2026-06-27','11:22:24','PLG0081590','2452000','2452000','11000','2463000','2463000','kasir','2026-06-27 11:22:23','F22627112223');
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-27','F226271122231','2026-06-27','11:22:24','TIN','2463000','11000');
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-260627-0022','D','2026-06-27','11:22:24','kasir','PENJUALAN','F226271122231','11389786000','2463000','11392249000');
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 ('F226271123481','kasir','1',' MGA1 X DG ','TOKO','SMBK-A','A1G-ZFBB-268-0','AT X TINDIK BABY DG 8K ','OL','0.250','1','100.00','276000','0','0','15000','281000','0','5000','0','286000','TIN','00409847','A1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZFBB-268-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='A1G-ZFBB-268-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271123481','2026-06-27','0.250','2026-06-27','11:23:48','PLG0081591','281000','281000','5000','286000','286000','kasir','2026-06-27 11:23:48','F22627112348');
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-27','F226271123481','2026-06-27','11:23:48','TIN','286000','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-260627-0023','D','2026-06-27','11:23:48','kasir','PENJUALAN','F226271123481','11392249000','286000','11392535000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='286000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271123481' 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 ('F226271123482','kasir',' 1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZFAI-67-T','LT MODEL DAUN CHARM SLEP LG 8K ','OL','0.380','1','100.00','412000','0','0','15000','420000','0','5000','0','425000','TIN','T0080567','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFAI-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='D1F-ZFAI-67-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 ('F226271123482','2026-06-27','0.380','2026-06-27','11:23:48','PLG0081592','420000','420000','5000','425000','425000','kasir','2026-06-27 11:23:48','F22627112348');
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-27','F226271123482','2026-06-27','11:23:48','TIN','425000','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-260627-0024','D','2026-06-27','11:23:48','kasir','PENJUALAN','F226271123482','11392535000','425000','11392960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271123482' 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 ('F226271123483','kasir',' 1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFXE-29-T','CC MODEL SLEP CM 18 8K ','OL','0.950','1','100.00','993000','0','0','15000','1012000','0','5000','0','1017000','TIN','T0080331','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1D-ZFXE-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 ('F226271123483','2026-06-27','0.950','2026-06-27','11:23:48','PLG0081593','1012000','1012000','5000','1017000','1017000','kasir','2026-06-27 11:23:48','F22627112348');
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-27','F226271123483','2026-06-27','11:23:48','TIN','1017000','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-260627-0025','D','2026-06-27','11:23:48','kasir','PENJUALAN','F226271123483','11392960000','1017000','11393977000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1017000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271123483' 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 ('F226271144201','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-5-T','CC MODEL SPECTRA KH 12 8K ','OL','0.350','1','100.00','380000','0','0','15000','386000','0','8000','0','394000','TIN','T0080747','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271144201','2026-06-27','0.350','2026-06-27','11:44:20','PLG0081594','386000','386000','8000','394000','394000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144201','2026-06-27','11:44:20','TIN','394000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0026','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144201','11393977000','394000','11394371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144201' 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 ('F226271144202','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-4-T','CC MODEL SPECTRA KH 14 8K ','OL','0.350','1','100.00','380000','0','0','15000','386000','0','8000','0','394000','TIN','T0080746','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-4-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 ('F226271144202','2026-06-27','0.350','2026-06-27','11:44:20','PLG0081595','386000','386000','8000','394000','394000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144202','2026-06-27','11:44:20','TIN','394000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0027','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144202','11394371000','394000','11394765000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144202' 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 ('F226271144203','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-1-T','CC MODEL SPECTRA KH 14 8K ','OL','0.370','1','100.00','401000','0','0','15000','408000','0','8000','0','416000','TIN','T0080743','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-1-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-27' AND kode_barang='E1F-ZFBE-1-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 ('F226271144203','2026-06-27','0.370','2026-06-27','11:44:20','PLG0081596','408000','408000','8000','416000','416000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144203','2026-06-27','11:44:20','TIN','416000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0028','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144203','11394765000','416000','11395181000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='416000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144203' 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 ('F226271144204','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1F-ZFBE-26-T','CC MODEL SLEP HW 15 8K ','OL','0.400','1','100.00','434000','0','0','15000','441000','0','8000','0','449000','TIN','T0080768','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-26-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 ('F226271144204','2026-06-27','0.400','2026-06-27','11:44:20','PLG0081597','441000','441000','8000','449000','449000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144204','2026-06-27','11:44:20','TIN','449000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0029','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144204','11395181000','449000','11395630000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='449000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144204' 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 ('F226271144205','kasir',' 1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZFBE-25-T','CC MODEL SLEP HW 13 8K ','OL','0.410','1','100.00','437000','0','0','15000','444000','0','8000','0','452000','TIN','T0080767','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFBE-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271144205','2026-06-27','0.410','2026-06-27','11:44:20','PLG0081598','444000','444000','8000','452000','452000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144205','2026-06-27','11:44:20','TIN','452000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0030','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144205','11395630000','452000','11396082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='452000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144205' 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 ('F226271144206','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-43-T','CC MODEL SLEP CM 12 8K ','OL','0.470','1','100.00','501000','0','0','15000','509000','0','8000','0','517000','TIN','T0080785','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFBE-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 ('F226271144206','2026-06-27','0.470','2026-06-27','11:44:20','PLG0081599','509000','509000','8000','517000','517000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144206','2026-06-27','11:44:20','TIN','517000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0031','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144206','11396082000','517000','11396599000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='517000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144206' 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 ('F226271144207','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-40-T','CC MODEL SLEP CM 16 8K ','OL','0.500','1','100.00','532000','0','0','15000','540000','0','10000','0','550000','TIN','T0080782','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-40-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-27' AND kode_barang='E1E-ZFBE-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271144207','2026-06-27','0.500','2026-06-27','11:44:20','PLG0081600','540000','540000','10000','550000','550000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144207','2026-06-27','11:44:20','TIN','550000','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-260627-0032','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144207','11396599000','550000','11397149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144207' 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 ('F226271144208','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-50-T','CC MODEL SLEP CM 14 8K ','OL','0.500','1','100.00','532000','0','0','15000','540000','0','10000','0','550000','TIN','T0080792','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-50-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-27' AND kode_barang='E1E-ZFBE-50-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 ('F226271144208','2026-06-27','0.500','2026-06-27','11:44:20','PLG0081601','540000','540000','10000','550000','550000','kasir','2026-06-27 11:44:20','F22627114420');
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-27','F226271144208','2026-06-27','11:44:20','TIN','550000','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-260627-0033','D','2026-06-27','11:44:20','kasir','PENJUALAN','F226271144208','11397149000','550000','11397699000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271144208' 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 ('F226271145101','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-37-T','CC MODEL SLEP CM 14 8K ','OL','0.550','1','100.00','586000','0','0','15000','595000','0','10000','0','605000','TIN','T0080779','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-37-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-27' AND kode_barang='E1E-ZFBE-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271145101','2026-06-27','0.550','2026-06-27','11:45:10','PLG0081602','595000','595000','10000','605000','605000','kasir','2026-06-27 11:45:10','F22627114510');
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-27','F226271145101','2026-06-27','11:45:10','TIN','605000','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-260627-0034','D','2026-06-27','11:45:10','kasir','PENJUALAN','F226271145101','11397699000','605000','11398304000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271145101' 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 ('F226271145102','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-52-T','CC MODEL SLEP CM 16 8K ','OL','0.670','1','100.00','714000','0','0','15000','725000','0','10000','0','735000','TIN','T0080794','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFBE-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226271145102','2026-06-27','0.670','2026-06-27','11:45:10','PLG0081603','725000','725000','10000','735000','735000','kasir','2026-06-27 11:45:10','F22627114510');
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-27','F226271145102','2026-06-27','11:45:10','TIN','735000','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-260627-0035','D','2026-06-27','11:45:10','kasir','PENJUALAN','F226271145102','11398304000','735000','11399039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='735000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226271145102' 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 ('F226271145411','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFAI-83-T','KL KOREA SLEP KH 44 8K ','OL','4.050','1','100.00','4313000','0','0','15000','4374000','0','20000','0','4394000','TIN','T0080583','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAI-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.050',berat_jual_asli=berat_jual_asli+'4.050',stock_jual='1',berat_akhir=berat_akhir-'4.050',berat_akhir_asli=berat_akhir_asli-'4.050',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='H1E-ZFAI-83-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 ('F226271145411','2026-06-27','4.050','2026-06-27','11:45:42','PLG0081604','4374000','4374000','20000','4394000','4394000','kasir','2026-06-27 11:45:41','F22627114541');
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-27','F226271145411','2026-06-27','11:45:42','TIN','4394000','20000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260627-0036','D','2026-06-27','11:45:42','kasir','PENJUALAN','F226271145411','11399039000','4394000','11403433000');
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 ('F226271206071','kasir','1',' MDE1 5K LG','TOKO','SMBK-E','E1D-ZDAF-10-T','CC MODEL SLEP VAR LG 16 8K ','','0.930','1','100.00','972000','0','0','15000','981000','0','5000','0','986000','LUS','T0078676','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAF-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1D-ZDAF-10-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 ('F226271206071','2026-06-27','0.930','2026-06-27','12:06:07','PLG0081605','981000','981000','5000','986000','986000','kasir','2026-06-27 12:06:07','F22627120607');
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-27','F226271206071','2026-06-27','12:06:07','LUS','986000','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-260627-0037','D','2026-06-27','12:06:07','kasir','PENJUALAN','F226271206071','11403433000','986000','11404419000');
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 ('F226271225421','kasir','1',' MEF3 25K H','TOKO','SMBK-F','F3E-ZFBE-73-T','GL RLINK HATI VAR HW 8K ','OL','0.540','1','100.00','575000','0','0','15000','586000','0','30000','0','616000','TIN','T0080815','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBE-73-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-27' AND kode_barang='F3E-ZFBE-73-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 ('F226271225421','2026-06-27','0.540','2026-06-27','12:25:43','PLG0081606','586000','586000','30000','616000','0','kasir','2026-06-27 12:25:42','F22627122542');
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-27','F226271225421','2026-06-27','12:25:43','TIN','616000','30000');
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-260627-0002','2026-06-27','2026-06-27 12:25:42','PENJUALAN : F226271225421','7465657676','BCA','616000','616000','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-260627-0003','D','2026-06-27','12:25:43','BCA','PENJUALAN','F226271225421','4590039888','616000','4590655888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7465657676','WINTARI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='616000' WHERE no_faktur_jual='F226271225421' 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 ('F226271226211','kasir','1',' MEF2E BM 5','TOKO','SMBK-F','F2E-ZFBE-78-T','GL OVAL MATA VAR SLEP BM 55 8K ','OL','1.190','1','100.00','1267000','0','0','15000','1285000','0','6000','0','1291000','TIN','T0080820','F2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFBE-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.190',berat_jual_asli=berat_jual_asli+'1.190',stock_jual='1',berat_akhir=berat_akhir-'1.190',berat_akhir_asli=berat_akhir_asli-'1.190',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='F2E-ZFBE-78-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 ('F226271226211','2026-06-27','1.190','2026-06-27','12:26:21','PLG0081607','1285000','1285000','6000','1291000','0','kasir','2026-06-27 12:26:21','F22627122621');
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-27','F226271226211','2026-06-27','12:26:21','TIN','1291000','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-260627-0003','2026-06-27','2026-06-27 12:26:21','PENJUALAN : F226271226211','86789576876','BCA','1291000','1291000','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-260627-0004','D','2026-06-27','12:26:21','BCA','PENJUALAN','F226271226211','4590655888','1291000','4591946888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('86789576876','WINTARI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1291000' WHERE no_faktur_jual='F226271226211' 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 ('F226270119041','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-51-T','CC MODEL SLEP CM 16 8K ','OL','0.570','1','100.00','607000','0','0','15000','618000','0','5000','0','623000','TIN','T0080793','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-51-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-27' AND kode_barang='E1E-ZFBE-51-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 ('F226270119041','2026-06-27','0.570','2026-06-27','13:19:05','PLG0081608','618000','618000','5000','623000','623000','kasir','2026-06-27 13:19:04','F22627011904');
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-27','F226270119041','2026-06-27','13:19:05','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-260627-0038','D','2026-06-27','13:19:05','kasir','PENJUALAN','F226270119041','11404419000','623000','11405042000','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='F226270119041' 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 ('F226270119042','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-14-T','CC MODEL ARESO SLEP KH 13 8K ','OL','0.360','1','100.00','391000','0','0','15000','398000','0','5000','0','403000','TIN','T0080756','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-14-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 ('F226270119042','2026-06-27','0.360','2026-06-27','13:19:05','PLG0081609','398000','398000','5000','403000','403000','kasir','2026-06-27 13:19:04','F22627011904');
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-27','F226270119042','2026-06-27','13:19:05','TIN','403000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260627-0039','D','2026-06-27','13:19:05','kasir','PENJUALAN','F226270119042','11405042000','403000','11405445000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='403000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270119042' 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 ('F226270119043','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-6-T','CC MODEL SPECTRA KH 14 8K ','OL','0.370','1','100.00','401000','0','0','15000','409000','0','5000','0','414000','TIN','T0080748','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-6-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-27' AND kode_barang='E1F-ZFBE-6-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 ('F226270119043','2026-06-27','0.370','2026-06-27','13:19:05','PLG0081610','409000','409000','5000','414000','414000','kasir','2026-06-27 13:19:04','F22627011904');
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-27','F226270119043','2026-06-27','13:19:05','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-260627-0040','D','2026-06-27','13:19:05','kasir','PENJUALAN','F226270119043','11405445000','414000','11405859000','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='F226270119043' 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 ('F226270119044','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-19-T','CC MODEL HATI SLEP KH 15 8K ','OL','0.380','1','100.00','412000','0','0','15000','420000','0','5000','0','425000','TIN','T0080761','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270119044','2026-06-27','0.380','2026-06-27','13:19:05','PLG0081611','420000','420000','5000','425000','425000','kasir','2026-06-27 13:19:04','F22627011904');
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-27','F226270119044','2026-06-27','13:19:05','TIN','425000','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-260627-0041','D','2026-06-27','13:19:05','kasir','PENJUALAN','F226270119044','11405859000','425000','11406284000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270119044' 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 ('F226270119561','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-53-T','GL RANTAI HOLLOW SLEP UB 8K ','OL','0.610','1','100.00','650000','0','0','15000','662000','0','5000','0','667000','TIN','T0080488','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-53-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-27' AND kode_barang='F3E-ZFAF-53-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 ('F226270119561','2026-06-27','0.610','2026-06-27','13:19:56','PLG0081612','662000','662000','5000','667000','667000','kasir','2026-06-27 13:19:56','F22627011956');
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-27','F226270119561','2026-06-27','13:19:56','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,status_valid) VALUES ('KM-260627-0042','D','2026-06-27','13:19:56','kasir','PENJUALAN','F226270119561','11406284000','667000','11406951000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='667000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270119561' 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 ('F226270119562','kasir',' 1',' MEF3E KH ','TOKO','SMBK-F','F3E-ZEBX-81-T','GL RANTAI HOLLOW KH 8K ','OL','2.030','1','100.00','2162000','0','0','15000','2193000','0','10000','0','2203000','TIN','T0079672','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBX-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='F3E-ZEBX-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270119562','2026-06-27','2.030','2026-06-27','13:19:56','PLG0081613','2193000','2193000','10000','2203000','2203000','kasir','2026-06-27 13:19:56','F22627011956');
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-27','F226270119562','2026-06-27','13:19:56','TIN','2203000','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-260627-0043','D','2026-06-27','13:19:56','kasir','PENJUALAN','F226270119562','11406951000','2203000','11409154000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2203000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270119562' 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 ('F226270154001','kasir','1',' TEA1 CM ','TOKO','TBK-A','A1TE-YJXC-13-T','AT DAKOCAN MATA VAR CM 17K ','','0.680','1','100.00','1353000','0','0','15000','1333000','0','0','0','1333000','TIN','T0073734','A1TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YJXC-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='A1TE-YJXC-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270154001','2026-06-27','0.680','2026-06-27','13:54:01','PLG0081614','1333000','1333000','0','1333000','1333000','kasir','2026-06-27 13:54:00','F22627015400');
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-27','F226270154001','2026-06-27','13:54:01','TIN','1333000','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-260627-0044','D','2026-06-27','13:54:01','kasir','PENJUALAN','F226270154001','11409154000','1333000','11410487000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1333000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270154001' 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 ('F226270154002','kasir',' 1',' TFH1 HW 44','TOKO','TBK-H','H1TF-VDCX-22-T','KL TOSCANO HW 44CM ','','5.050','1','100.00','10150000','0','0','15000','9999000','0','0','0','9999000','TIN','T0033573','H1TF','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-VDCX-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='H1TF-VDCX-22-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 ('F226270154002','2026-06-27','5.050','2026-06-27','13:54:01','PLG0081615','9999000','9999000','0','9999000','9999000','kasir','2026-06-27 13:54:00','F22627015400');
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-27','F226270154002','2026-06-27','13:54:01','TIN','9999000','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-260627-0045','D','2026-06-27','13:54:01','kasir','PENJUALAN','F226270154002','11410487000','9999000','11420486000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='9999000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270154002' 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 ('F226270156041','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFAI-24-T','CC MODEL SLEP CM 15 8K ','','0.760','1','100.00','809000','0','0','15000','817000','0','0','0','817000','TIN','T0080524','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1E-ZFAI-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 ('F226270156041','2026-06-27','0.760','2026-06-27','13:56:05','PLG0081616','817000','817000','0','817000','817000','kasir','2026-06-27 13:56:04','F22627015604');
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-27','F226270156041','2026-06-27','13:56:05','TIN','817000','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-260627-0046','D','2026-06-27','13:56:05','kasir','PENJUALAN','F226270156041','11420486000','817000','11421303000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='817000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270156041' 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 ('F226270156042','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-69-T','CC MODEL PITA PASIR VAR CM 14 8K ','','0.750','1','100.00','799000','0','0','15000','806000','0','5000','0','811000','TIN','T0079230','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-69-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-27' AND kode_barang='E1E-ZEXF-69-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 ('F226270156042','2026-06-27','0.750','2026-06-27','13:56:05','PLG0081617','806000','806000','5000','811000','811000','kasir','2026-06-27 13:56:04','F22627015604');
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-27','F226270156042','2026-06-27','13:56:05','TIN','811000','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-260627-0047','D','2026-06-27','13:56:05','kasir','PENJUALAN','F226270156042','11421303000','811000','11422114000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='811000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270156042' 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 ('F226270156043','kasir',' 1',' MDE1D HW 1','TOKO','SMBK-E','E1D-ZFAI-5-T','CC MODEL SLEP HW 15 8K ','','1.030','1','100.00','1076000','0','0','15000','1087000','0','0','0','1087000','TIN','T0080505','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1D-ZFAI-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270156043','2026-06-27','1.030','2026-06-27','13:56:05','PLG0081618','1087000','1087000','0','1087000','1087000','kasir','2026-06-27 13:56:04','F22627015604');
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-27','F226270156043','2026-06-27','13:56:05','TIN','1087000','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-260627-0048','D','2026-06-27','13:56:05','kasir','PENJUALAN','F226270156043','11422114000','1087000','11423201000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1087000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270156043' 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 ('F226270215081','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-13-T','CC MODEL ARESO SLEP KH 14 8K ','OL','0.360','1','100.00','391000','0','0','15000','398000','0','5000','0','403000','TIN','T0080755','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-13-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 ('F226270215081','2026-06-27','0.360','2026-06-27','14:15:08','PLG0081619','398000','398000','5000','403000','403000','kasir','2026-06-27 14:15:08','F22627021508');
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-27','F226270215081','2026-06-27','14:15:08','TIN','403000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260627-0049','D','2026-06-27','14:15:08','kasir','PENJUALAN','F226270215081','11423201000','403000','11423604000');
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 ('F226270254131','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZFBE-2-T','CC MODEL SPECTRA KH 16 8K ','','0.360','1','100.00','391000','0','0','15000','395000','0','0','0','395000','LUS','T0080744','E1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBE-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='E1F-ZFBE-2-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 ('F226270254131','2026-06-27','0.360','2026-06-27','14:54:14','PLG0081620','395000','395000','0','395000','0','kasir','2026-06-27 14:54:13','F22627025413');
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-27','F226270254131','2026-06-27','14:54:14','LUS','395000','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-260627-0004','2026-06-27','2026-06-27 14:54:13','PENJUALAN : F226270254131','988776654534231','BCA','395000','395000','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-260627-0005','D','2026-06-27','14:54:14','BCA','PENJUALAN','F226270254131','4591946888','395000','4592341888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('988776654534231','ARFIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='395000' WHERE no_faktur_jual='F226270254131' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119044' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119044' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119044';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270119562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270119562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270154001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270154001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270154001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270154002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270154002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270154002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270156041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270156042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270156043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270156043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270215081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270215081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270215081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270254131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270254131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270254131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821394' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821394' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821394';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821395' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821395' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821395';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821396' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821396' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821396';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821397' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821397' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821397';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821398' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821398' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821398';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821399' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270821399' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270821399';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270921371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270921371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270921371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270948241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270948241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270948241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270949441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270949442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270949443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949444' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949444' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270949444';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949445' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270949445' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270949445';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271008111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271008111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271008111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271035271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271035271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271035271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271035272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271035272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271035272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271122231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271122231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271122231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271123481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271123482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271123483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271123483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144204' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144204' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144204';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144205' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144205' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144205';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144206' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144206' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144206';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144207' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144207' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144207';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144208' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271144208' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271144208';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271145101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271145102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271145411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271145411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271206071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271206071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271206071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271225421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271225421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271225421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271226211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271226211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271226211';
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-00005479','X-00005479','KL SIEM COBRA KH 42CM 8K','GR','---','H1E','BELI','BELI001','1200000','2026-06-27','1.250','1','admin','2026-06-27 15:10:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005479','X-00005479');
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-260627-0001','F226181117131','TIN','1','BELI','BELI001','H1E', 'X-00005479', 'KL SIEM COBRA KH 42CM 8K','1.250','1.250','100.00','1494000','1200000','960000','1065000','1','1200000','1200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260627-0001','2026-06-27','2026-06-27','15:10:25','TIN','---','1.250','1200000','1200000','1200000','1200000','1200000','admin','2026-06-27 15:10:25','FB-260627-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0001','NETA','WAGIRLOR NGEBEL','','','081546282037','admin','2026-06-27 15:10:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0050','K','2026-06-27','15:10:25','admin','PEMBELIAN UMUM','FB-260627-0001','11423604000','1200000','11422404000');
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-00005480','X-00005480','AT X ITALY SLEP VAR UB 8K','GR','---','A1F','BELI','BELI001','1009000','2026-06-27','1.290','1','admin','2026-06-27 15:10:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00005480','X-00005480');
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-260627-0002','F225121218191','TIN','2','BELI','BELI001','A1F', 'X-00005480', 'AT X ITALY SLEP VAR UB 8K','1.290','1.290','100.00','1097000','1009000','782171','1085000','1','1009000','1009000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.290',berat_beli_asli=berat_beli_asli+'1.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.290',berat_akhir_asli=berat_akhir_asli+'1.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260627-0002','2026-06-27','2026-06-27','15:10:25','TIN','---','1.290','1009000','1009000','1009000','1009000','1009000','admin','2026-06-27 15:10:25','FB-260627-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0002','VALEN','JABUNG MLARAK','','','085147442600','admin','2026-06-27 15:10:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0051','K','2026-06-27','15:10:25','admin','PEMBELIAN UMUM','FB-260627-0002','11422404000','1009000','11421395000');
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-00005481','X-00005481','AT TINDIK BABY LG 8K','GR','---','A1E','BELI','BELI001','454000','2026-06-27','0.470','1','admin','2026-06-27 15:10:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005481','X-00005481');
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-260627-0003','F226110143001','TIN','3','BELI','BELI001','A1E', 'X-00005481', 'AT TINDIK BABY LG 8K','0.470','0.470','100.00','572000','454000','965957','1065000','1','454000','454000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260627-0003','2026-06-27','2026-06-27','15:10:25','TIN','---','0.470','454000','454000','454000','454000','454000','admin','2026-06-27 15:10:25','FB-260627-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0003','ADE NOVIYANTI','BALONG','','','','admin','2026-06-27 15:10:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0052','K','2026-06-27','15:10:25','admin','PEMBELIAN UMUM','FB-260627-0003','11421395000','454000','11420941000');
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-00005482','X-00005482','GL MODEL FLIK VAR LT 8K','GR','---','F3E','BELI','BELI001','1025000','2026-06-27','1.060','1','admin','2026-06-27 15:10:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005482','X-00005482');
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-260627-0004','F226030945491','TIN','4','BELI','BELI001','F3E', 'X-00005482', 'GL MODEL FLIK VAR LT 8K','1.060','1.060','100.00','1240000','1025000','966981','1065000','1','1025000','1025000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260627-0004','2026-06-27','2026-06-27','15:10:25','TIN','---','1.060','1025000','1025000','1025000','1025000','1025000','admin','2026-06-27 15:10:25','FB-260627-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0004','LUTFI TRIANANDA','JL PESANTREN 32 MENANG JAMBON','','','089661137600','admin','2026-06-27 15:10:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0053','K','2026-06-27','15:10:25','admin','PEMBELIAN UMUM','FB-260627-0004','11420941000','1025000','11419916000');
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-00005483','X-00005483','CC MODEL HATI RANTAI SLEP CM 14','GR','---','E1TE','BELI','BELI001','1130000','2026-06-27','0.750','1','admin','2026-06-27 15:12:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00005483','X-00005483');
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-260627-0005','F223250904081','LUS','1','BELI','BELI001','E1TE', 'X-00005483', 'CC MODEL HATI RANTAI SLEP CM 14','0.830','0.750','100.00','635000','1130000','1506667','1990000','1','1130000','1130000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-260627-0005','2026-06-27','2026-06-27','15:12:50','LUS','---','0.750','1130000','1130000','1130000','1130000','1130000','admin','2026-06-27 15:12:51','FB-260627-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0005','RISKA','SOKO TUBAN','','','085753879001','admin','2026-06-27 15:12:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0054','K','2026-06-27','15:12:50','admin','PEMBELIAN UMUM','FB-260627-0005','11419916000','1130000','11418786000');
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-00005484','X-00005484','KL SANTA AUREL MODEL MATA UB','GR','---','H2TG','BELI','BELI001','4424000','2026-06-27','2.800','1','admin','2026-06-27 15:14:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2TG','X-00005484','X-00005484');
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-260627-0006','F223131024452','TIN','1','BELI','BELI001','H2TG', 'X-00005484', 'KL SANTA AUREL MODEL MATA UB','3.170','2.800','100.00','2552000','4424000','1580000','2030000','1','4424000','4424000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.800',berat_beli_asli=berat_beli_asli+'2.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.800',berat_akhir_asli=berat_akhir_asli+'2.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2TG' 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-260627-0006','2026-06-27','2026-06-27','15:14:48','TIN','---','2.800','4424000','4424000','4424000','4424000','4424000','admin','2026-06-27 15:14:49','FB-260627-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260627-0006','IKO','VILA BUMI BATARA 30 SETONO','','','082229555827','admin','2026-06-27 15:14:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-27' 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-260627-0055','K','2026-06-27','15:14:48','admin','PEMBELIAN UMUM','FB-260627-0006','11418786000','4424000','11414362000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260627-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260627-0006';
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 ('F226270317361','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZFXA-66-0','LT X SLOBOK BOLA SLEP BG 8K ','OL','0.310','1','100.00','336000','0','0','15000','343000','0','5000','0','348000','LUS','00406234','D1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFXA-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='D1F-ZFXA-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270317361','2026-06-27','0.310','2026-06-27','15:17:36','PLG0081621','343000','343000','5000','348000','348000','kasir','2026-06-27 15:17:36','F22627031736');
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-27','F226270317361','2026-06-27','15:17:36','LUS','348000','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-260627-0056','D','2026-06-27','15:17:36','kasir','PENJUALAN','F226270317361','11414362000','348000','11414710000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='348000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270317361' 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 ('F226270317362','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-7-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL','0.330','1','100.00','365000','0','0','15000','371000','0','5000','0','376000','LUS','T0079159','D1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-06-27' AND kode_barang='D1G-ZEXB-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270317362','2026-06-27','0.330','2026-06-27','15:17:36','PLG0081622','371000','371000','5000','376000','376000','kasir','2026-06-27 15:17:36','F22627031736');
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-27','F226270317362','2026-06-27','15:17:36','LUS','376000','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-260627-0057','D','2026-06-27','15:17:36','kasir','PENJUALAN','F226270317362','11414710000','376000','11415086000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='376000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270317362' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270317361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270317361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270317361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270317362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270317362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270317362';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-27';
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-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-27';
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-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-27' 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-260628-0001','D','2026-06-28','16:37:51','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-260628-0001','D','2026-06-28','16:37:51','BCA','SALDO AWAL','SALDO AWAL','0','4592341888','4592341888');
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-260628-0001','D','2026-06-28','16:37:51','','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-260628-0001','D','2026-06-28','16:37:51','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-260628-0001','D','2026-06-28','16:37:51','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-260628-0001','D','2026-06-28','16:37:51','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-28';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260628-0001','1','H1E-ZECX-8-T','1','1.710','TOKO','BK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZECX-8-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1E-ZECX-8-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-H';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1E-ZECX-8-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.710',berat_out_asli='1.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.710',berat_akhir_asli =berat_akhir_asli-'1.710' WHERE kode_barang='H1E-ZECX-8-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260628-0001','2026-06-28','2026-06-28','17:05','1.710','input','260628');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260628-0001','1','E1D-ZFBG-65-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFBG-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFBG-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-28 17:06:15' WHERE kode_barang='E1D-ZFBG-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFBG-65-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-28 17:06:15','TOKO','SMBK-E','E1D','E1D-ZFBG-65-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZFBG-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFBG-65-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260628-0001','2026-06-28','17:06','1.050','input','2026-06-27 17:06:14');