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 ('F326280946091','input','1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFAI-84-0','CC MODEL BANGKOK SLEP HT 16 8K ','','0.500','1','100.00','532000','0','0','15000','532000','0','0','0','532000','LIS','00409389','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-84-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1E-ZFAI-84-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280946091','2026-06-28','0.500','2026-06-28','09:46:10','PLG0030022','532000','532000','0','532000','532000','input','2026-06-28 09:46:09','F32628094609');
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-28','F326280946091','2026-06-28','09:46:10','LIS','532000','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-260628-0002','D','2026-06-28','09:46:10','input','PENJUALAN','F326280946091','5971550000','532000','5972082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='532000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280946091' 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 ('F326280946092','input',' 1',' MEE2 X HT ','TOKO','PM-E','E2E-ZEAA-103-0','CC X PIPA MATA HT 13 8K ','','0.500','1','100.00','532000','0','0','15000','533000','0','0','0','533000','LIS','00403208','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEAA-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E2E-ZEAA-103-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280946092','2026-06-28','0.500','2026-06-28','09:46:10','PLG0030023','533000','533000','0','533000','533000','input','2026-06-28 09:46:09','F32628094609');
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-28','F326280946092','2026-06-28','09:46:10','LIS','533000','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-260628-0003','D','2026-06-28','09:46:10','input','PENJUALAN','F326280946092','5972082000','533000','5972615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280946092' 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 ('F326280958321','input','1',' TEF1 X AU ','TOKO','PT-F','F1TE-WLBH-49-T','GL X OVAL MODEL C SLEP AU D58 ','','8.200','1','100.00','15990000','0','0','15000','15970000','0','0','0','15970000','SIN','T0052836','F1TE','0','0','-','1','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-WLBH-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.200',berat_jual_asli=berat_jual_asli+'8.200',stock_jual='1',berat_akhir=berat_akhir-'8.200',berat_akhir_asli=berat_akhir_asli-'8.200',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='F1TE-WLBH-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326280958321','2026-06-28','8.200','2026-06-28','09:58:33','PLG0030024','15970000','15970000','0','15970000','15970000','input','2026-06-28 09:58:32','F32628095832');
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-28','F326280958321','2026-06-28','09:58:33','SIN','15970000','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-260628-0004','D','2026-06-28','09:58:33','input','PENJUALAN','F326280958321','5972615000','15970000','5988585000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='15970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280958321' 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 ('F326280958322','input',' 1',' TEF1 X YT ','TOKO','PT-F','F1TE-WAXC-127-T','GL X OVAL MODEL C YT D52 ','','8.130','1','100.00','15854000','0','0','15000','15830000','0','0','0','15830000','SIN','T0041179','F1TE','0','0','-','1','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-WAXC-127-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.130',berat_jual_asli=berat_jual_asli+'8.130',stock_jual='1',berat_akhir=berat_akhir-'8.130',berat_akhir_asli=berat_akhir_asli-'8.130',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='F1TE-WAXC-127-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326280958322','2026-06-28','8.130','2026-06-28','09:58:33','PLG0030025','15830000','15830000','0','15830000','15830000','input','2026-06-28 09:58:32','F32628095832');
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-28','F326280958322','2026-06-28','09:58:33','SIN','15830000','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-260628-0005','D','2026-06-28','09:58:33','input','PENJUALAN','F326280958322','5988585000','15830000','6004415000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='15830000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280958322' LIMIT 1;
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-00019501','X-00019501','GL X TIFF 5M SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1750000','2026-06-28','1.750','1','kasir','2026-06-28 10:16:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019501','X-00019501');
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-260628-0001','F326191106173','FIT','1','BELI','BELI001','F3E', 'X-00019501', 'GL X TIFF 5M SLEP VAR HW 8K','1.750','1.750','100.00','1942000','1750000','1000000','1075000','1','1750000','1750000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-28' 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-260628-0001','2026-06-28','2026-06-28','10:16:27','FIT','---','1.750','1750000','1750000','1750000','1750000','1750000','kasir','2026-06-28 10:16:28','FB-260628-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260628-0001','LAILY','TUMPUK BANDAR PACITAN','','','085707520753','kasir','2026-06-28 10:16:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-28' 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-260628-0006','K','2026-06-28','10:16:27','kasir','PEMBELIAN UMUM','FB-260628-0001','6004415000','1750000','6002665000');
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 ('F326281035011','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZCXB-233-0','GL X OVAL C SLEP UB 58 8K ','','6.960','1','100.00','7412000','0','0','15000','7413000','0','0','0','7413000','FIT','00391656','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCXB-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.960',berat_jual_asli=berat_jual_asli+'6.960',stock_jual='1',berat_akhir=berat_akhir-'6.960',berat_akhir_asli=berat_akhir_asli-'6.960',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='F1E-ZCXB-233-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281035011','2026-06-28','6.960','2026-06-28','10:35:02','PLG0030026','7413000','7413000','0','7413000','7413000','kasir','2026-06-28 10:35:01','F32628103501');
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-28','F326281035011','2026-06-28','10:35:02','FIT','7413000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0007','D','2026-06-28','10:35:02','kasir','PENJUALAN','F326281035011','6002665000','7413000','6010078000');
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 ('F326281054261','kasir','1',' MEE1E LG 2','TOKO','PM-E','E1E-ZFXD-370-0','CC MODEL DAUN SLEP LG 22 8K ','','0.550','1','100.00','586000','0','0','15000','586000','0','0','0','586000','SIN','00407250','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-370-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1E-ZFXD-370-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281054261','2026-06-28','0.550','2026-06-28','10:54:27','PLG0030027','586000','586000','0','586000','586000','kasir','2026-06-28 10:54:26','F32628105426');
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-28','F326281054261','2026-06-28','10:54:27','SIN','586000','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-260628-0008','D','2026-06-28','10:54:27','kasir','PENJUALAN','F326281054261','6010078000','586000','6010664000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281054261' 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 ('F326281054262','kasir',' 1',' MEE1 LG 22','TOKO','PM-E','E1E-ZFAE-9-0','CC MODEL DAUN SLEP LG 22 8K ','','0.520','1','100.00','554000','0','0','15000','554000','0','0','0','554000','SIN','00408717','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1E-ZFAE-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281054262','2026-06-28','0.520','2026-06-28','10:54:27','PLG0030028','554000','554000','0','554000','554000','kasir','2026-06-28 10:54:26','F32628105426');
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-28','F326281054262','2026-06-28','10:54:27','SIN','554000','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-260628-0009','D','2026-06-28','10:54:27','kasir','PENJUALAN','F326281054262','6010664000','554000','6011218000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281054262' 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 ('F326281106001','kasir','1',' MEB1 CM PE','TOKO','PM-B','B1E-YCAE-90-0','GW TUSUK MODEL APEL VAR CM PE 8K ','','0.560','1','100.00','596000','0','0','15000','597000','0','0','0','597000','FIT','00343206','B1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YCAE-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='B1E-YCAE-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281106001','2026-06-28','0.560','2026-06-28','11:06:01','PLG0030029','597000','597000','0','597000','597000','kasir','2026-06-28 11:06:00','F32628110600');
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-28','F326281106001','2026-06-28','11:06:01','FIT','597000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0010','D','2026-06-28','11:06:01','kasir','PENJUALAN','F326281106001','6011218000','597000','6011815000');
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 ('F326281201101','kasir','1',' MDA1D LG ','TOKO','PM-A','A1D-ZFBX-519-0','AT MODEL SLEP VAR LG 8K ','','0.830','1','100.00','867000','0','0','15000','868000','0','0','0','868000','FIT','00409536','A1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFBX-519-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='A1D-ZFBX-519-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281201101','2026-06-28','0.830','2026-06-28','12:01:10','PLG0030030','868000','868000','0','868000','868000','kasir','2026-06-28 12:01:10','F32628120110');
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-28','F326281201101','2026-06-28','12:01:10','FIT','868000','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-260628-0011','D','2026-06-28','12:01:10','kasir','PENJUALAN','F326281201101','6011815000','868000','6012683000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='868000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281201101' 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 ('F326281201102','kasir',' 1',' MDE1D CM 2','TOKO','PM-E','E1D-ZFXE-208-0','CC MODEL DAUN SLEP CM 20 8K ','','1.000','1','100.00','1045000','0','0','15000','1045000','0','0','0','1045000','FIT','00407460','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-208-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1D-ZFXE-208-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281201102','2026-06-28','1.000','2026-06-28','12:01:10','PLG0030031','1045000','1045000','0','1045000','1045000','kasir','2026-06-28 12:01:10','F32628120110');
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-28','F326281201102','2026-06-28','12:01:10','FIT','1045000','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-260628-0012','D','2026-06-28','12:01:10','kasir','PENJUALAN','F326281201102','6012683000','1045000','6013728000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281201102' 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 ('F326281232561','kasir','1',' MGE1 5K YT','TOKO','PM-E','E1G-ZDBE-398-0','CC ANAK BONEKA CAT VAR YT 8K ','','0.350','1','100.00','387000','0','0','15000','387000','0','5000','0','392000','SIN','00401166','E1G','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZDBE-398-0' 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-28' AND kode_barang='E1G-ZDBE-398-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281232561','2026-06-28','0.350','2026-06-28','12:32:56','PLG0030032','387000','387000','5000','392000','392000','kasir','2026-06-28 12:32:56','F32628123256');
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-28','F326281232561','2026-06-28','12:32:56','SIN','392000','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-260628-0013','D','2026-06-28','12:32:56','kasir','PENJUALAN','F326281232561','6013728000','392000','6014120000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='392000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281232561' 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 ('F326281232562','kasir',' 1',' MEA1 CM ','TOKO','PM-A','A1E-YLCX-357-0','AT MODEL BOLA ARESO VAR CM 8K ','','0.520','1','100.00','554000','0','0','15000','554000','0','0','0','554000','SIN','00383762','A1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLCX-357-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='A1E-YLCX-357-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281232562','2026-06-28','0.520','2026-06-28','12:32:56','PLG0030033','554000','554000','0','554000','554000','kasir','2026-06-28 12:32:56','F32628123256');
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-28','F326281232562','2026-06-28','12:32:56','SIN','554000','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-260628-0014','D','2026-06-28','12:32:56','kasir','PENJUALAN','F326281232562','6014120000','554000','6014674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281232562' 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 ('F326281239581','kasir','1',' MFA1 UB ','TOKO','PM-A','A1F-XIXI-140-0','AT MODEL ITALY PANJANG VAR UB 8K ','','1.050','1','100.00','1139000','0','0','15000','1140000','0','0','0','1140000','AAT','00316537','A1F','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-XIXI-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='A1F-XIXI-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326281239581','2026-06-28','1.050','2026-06-28','12:39:59','PLG0030034','1140000','1140000','0','1140000','1140000','kasir','2026-06-28 12:39:58','F32628123958');
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-28','F326281239581','2026-06-28','12:39:59','AAT','1140000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0015','D','2026-06-28','12:39:59','kasir','PENJUALAN','F326281239581','6014674000','1140000','6015814000');
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 ('F326280100231','kasir','1',' MDE1D CM 1','TOKO','PM-E','E1D-ZFXB-92-0','CC MODEL SLEP CM 16 8K','','1.460','1','100.00','1526000','0','0','15000','1525000','0','0','0','1525000','AAT','00406484','E1D','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXB-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1D-ZFXB-92-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280100231','2026-06-28','1.460','2026-06-28','13:00:23','PLG0030035','1525000','1525000','0','1525000','1525000','kasir','2026-06-28 13:00:23','F32628010023');
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-28','F326280100231','2026-06-28','13:00:23','AAT','1525000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0016','D','2026-06-28','13:00:23','kasir','PENJUALAN','F326280100231','6015814000','1525000','6017339000');
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 ('F326280105071','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-ZEBH-169-0','CC X MODEL MATA PM 18 8K ','','1.460','1','100.00','1526000','0','0','15000','1526000','0','0','0','1526000','LIS','00405387','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E2D-ZEBH-169-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280105071','2026-06-28','1.460','2026-06-28','13:05:07','PLG0030036','1526000','1526000','0','1526000','1526000','kasir','2026-06-28 13:05:07','F32628010507');
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-28','F326280105071','2026-06-28','13:05:07','LIS','1526000','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-260628-0017','D','2026-06-28','13:05:07','kasir','PENJUALAN','F326280105071','6017339000','1526000','6018865000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280105071' 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 ('F326280105072','kasir',' 1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFAI-79-0','CC MODEL BANGKOK SLEP HT 16 8K ','','0.570','1','100.00','607000','0','0','15000','607000','0','0','0','607000','LIS','00409384','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-79-0' 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-28' AND kode_barang='E1E-ZFAI-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280105072','2026-06-28','0.570','2026-06-28','13:05:07','PLG0030037','607000','607000','0','607000','607000','kasir','2026-06-28 13:05:07','F32628010507');
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-28','F326280105072','2026-06-28','13:05:07','LIS','607000','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-260628-0018','D','2026-06-28','13:05:07','kasir','PENJUALAN','F326280105072','6018865000','607000','6019472000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='607000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280105072' 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 ('F326280110591','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-ZFBX-521-0','AT DAISY LG 8K ','','0.570','1','100.00','607000','0','0','15000','608000','0','0','0','608000','FIT','00409538','A1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBX-521-0' 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-28' AND kode_barang='A1E-ZFBX-521-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280110591','2026-06-28','0.570','2026-06-28','13:11:00','PLG0030038','608000','608000','0','608000','608000','kasir','2026-06-28 13:10:59','F32628011059');
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-28','F326280110591','2026-06-28','13:11:00','FIT','608000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0019','D','2026-06-28','13:11:00','kasir','PENJUALAN','F326280110591','6019472000','608000','6020080000');
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-00019502','X-00019502','CC X VELG KACA YS 10 8K','GR','---','E1D','BELI','BELI001','950000','2026-06-28','0.970','1','kasir','2026-06-28 13:30:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019502','X-00019502');
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-260628-0002','F326240813211','AAT','1','BELI','BELI001','E1D', 'X-00019502', 'CC X VELG KACA YS 10 8K','0.970','0.970','100.00','1043000','950000','979381','1045000','1','950000','950000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260628-0002','2026-06-28','2026-06-28','13:30:30','AAT','---','0.970','950000','950000','950000','950000','950000','kasir','2026-06-28 13:30:31','FB-260628-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260628-0002','BU SIMI','KENTENG PURWANTORO','','','','kasir','2026-06-28 13:30:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-28' 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-260628-0020','K','2026-06-28','13:30:30','kasir','PEMBELIAN UMUM','FB-260628-0002','6020080000','950000','6019130000');
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 ('F326280134511','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZFAH-154-0','CC X POLOS CM 22 8K ','','0.950','1','100.00','993000','0','0','15000','993000','0','0','0','993000','LIS','00409161','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAH-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1D-ZFAH-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280134511','2026-06-28','0.950','2026-06-28','13:34:52','PLG0030039','993000','993000','0','993000','993000','kasir','2026-06-28 13:34:51','F32628013451');
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-28','F326280134511','2026-06-28','13:34:52','LIS','993000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260628-0021','D','2026-06-28','13:34:52','kasir','PENJUALAN','F326280134511','6019130000','993000','6020123000');
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 ('F326280211311','kasir','1',' MEE1E CM 1','TOKO','PM-E','E1E-ZFBE-143-0','CC MODEL SLEP CM 16 8K ','','0.500','1','100.00','532000','0','0','15000','533000','0','0','0','533000','LIS','00410420','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-143-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='E1E-ZFBE-143-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280211311','2026-06-28','0.500','2026-06-28','14:11:32','PLG0030040','533000','533000','0','533000','533000','kasir','2026-06-28 14:11:31','F32628021131');
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-28','F326280211311','2026-06-28','14:11:32','LIS','533000','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-260628-0022','D','2026-06-28','14:11:32','kasir','PENJUALAN','F326280211311','6020123000','533000','6020656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280211311' 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 ('F326280211312','kasir',' 1',' MEE1E CM 1','TOKO','PM-E','E1E-ZFBE-141-0','CC MODEL SLEP CM 16 8K ','','0.610','1','100.00','650000','0','0','15000','650000','0','0','0','650000','LIS','00410418','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-141-0' 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-28' AND kode_barang='E1E-ZFBE-141-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326280211312','2026-06-28','0.610','2026-06-28','14:11:32','PLG0030041','650000','650000','0','650000','650000','kasir','2026-06-28 14:11:31','F32628021131');
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-28','F326280211312','2026-06-28','14:11:32','LIS','650000','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-260628-0023','D','2026-06-28','14:11:32','kasir','PENJUALAN','F326280211312','6020656000','650000','6021306000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280211312' LIMIT 1;
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-00019503','X-00019503','CC MODEL DAUN MATA VAR CM 10 8K','GR','---','E2D','BELI','BELI001','1010000','2026-06-28','1.040','1','kasir','2026-06-28 14:12:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019503','X-00019503');
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-260628-0003','F326260123231','SIN','1','BELI','BELI001','E2D', 'X-00019503', 'CC MODEL DAUN MATA VAR CM 10 8K','1.040','1.040','100.00','1280000','1010000','971154','1045000','1','1010000','1010000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260628-0003','2026-06-28','2026-06-28','14:12:38','SIN','---','1.040','1010000','1010000','1010000','1010000','1010000','kasir','2026-06-28 14:12:38','FB-260628-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260628-0003','INDAH','LEMAHBANG','','','','kasir','2026-06-28 14:12:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-28' 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-260628-0024','K','2026-06-28','14:12:38','kasir','PEMBELIAN UMUM','FB-260628-0003','6021306000','1010000','6020296000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260628-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260628-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260628-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260628-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260628-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260628-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280100231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280100231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280100231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280105071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280105071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280105071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280105072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280105072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280105072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280110591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280110591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280110591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280134511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280134511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280134511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280211311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280211312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280211312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280946091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280946091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280946091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280946092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280946092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280946092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280958321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280958321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280958321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280958322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280958322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280958322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281035011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281035011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281035011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281054261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281054261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281054261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281054262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281054262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281054262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281106001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281106001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281106001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281201101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281201101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281201101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281201102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281201102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281201102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281232561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281232561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281232561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281232562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281232562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281232562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281239581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281239581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281239581';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-28';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','15:09:53','SYSTEM','SALDO AWAL','SALDO AWAL','0','6020296000','6020296000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','15:09:53','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','15:09:53','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','15:09:53','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-29';