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 ('F226270956041','kasir','1',' MDE1 LG 12','TOKO','SMBK-E','E1D-ZEAE-19-T','CINCIN MODEL LINEA LG 12 8K ','','1.000','1','100.00','1085000','0','0','15000','1090000','0','0','0','1090000','TIN','T0079445','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='E1D-ZEAE-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 ('F226270956041','2026-05-27','1.000','2026-05-27','09:56:04','PLG0080442','1090000','1090000','0','1090000','1090000','kasir','2026-05-27 09:56:04','F22627095604');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226270956041','2026-05-27','09:56:04','TIN','1090000','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-260527-0002','D','2026-05-27','09:56:04','kasir','PENJUALAN','F226270956041','10122187000','1090000','10123277000');
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 ('F226271009301','kasir','1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZEAE-24-T','CINCIN MODEL LINEA SLEP LG 12 8K ','OL','0.450','1','100.00','497000','0','0','15000','504000','0','5000','0','509000','TIN','T0079450','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='E1E-ZEAE-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 ('F226271009301','2026-05-27','0.450','2026-05-27','10:09:31','PLG0080443','504000','504000','5000','509000','0','kasir','2026-05-27 10:09:30','F22627100930');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226271009301','2026-05-27','10:09:31','TIN','509000','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-260527-0001','2026-05-27','2026-05-27 10:09:30','PENJUALAN : F226271009301','4545566757','BCA','509000','509000','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-260527-0002','D','2026-05-27','10:09:31','BCA','PENJUALAN','F226271009301','4458059888','509000','4458568888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('4545566757','SUCI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='509000' WHERE no_faktur_jual='F226271009301' 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 ('F226271033421','kasir','1',' MEF3E X LT','TOKO','SMBK-F','F3E-YLAE-94-0','GL X TIFF HATI SLEP VAR LT 8K ','','1.200','1','100.00','1326000','0','0','15000','1332000','0','0','0','1332000','LUS','00381072','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAE-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='F3E-YLAE-94-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 ('F226271033421','2026-05-27','1.200','2026-05-27','10:33:42','PLG0080444','1332000','1332000','0','1332000','1332000','kasir','2026-05-27 10:33:42','F22627103342');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226271033421','2026-05-27','10:33:42','LUS','1332000','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-260527-0003','D','2026-05-27','10:33:42','kasir','PENJUALAN','F226271033421','10123277000','1332000','10124609000');
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 ('F226271114121','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZEAE-95-T','KL KOREA UB 44CM 8K ','OL','1.460','1','100.00','1613000','0','0','15000','1628000','0','7000','0','1635000','TJ','T0079521','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEAE-95-T' 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-05-27' AND kode_barang='H1E-ZEAE-95-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 ('F226271114121','2026-05-27','1.460','2026-05-27','11:14:13','PLG0080445','1628000','1628000','7000','1635000','1635000','kasir','2026-05-27 11:14:12','F22627111412');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226271114121','2026-05-27','11:14:13','TJ','1635000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260527-0004','D','2026-05-27','11:14:13','kasir','PENJUALAN','F226271114121','10124609000','1635000','10126244000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270956041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270956041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270956041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271009301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271009301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271009301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271033421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271033421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271033421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271114121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271114121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271114121';
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-00005394','X-00005394','CC POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','1827000','2026-05-27','2.010','1','kasir','2026-05-27 14:50:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005394','X-00005394');
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-260527-0001','F225150943011','TIN','1','BELI','BELI001','E1D', 'X-00005394', 'CC POLOS CM 22 8K','2.010','2.010','100.00','2030000','1827000','908955','1100000','1','1827000','1827000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-27' 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-260527-0001','2026-05-27','2026-05-27','14:50:51','TIN','---','2.010','1827000','1827000','1827000','1827000','1827000','kasir','2026-05-27 14:50:51','FB-260527-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260527-0001','AZIZ','BULULOR JAMBON','','','081335657123','kasir','2026-05-27 14:50:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-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-260527-0005','K','2026-05-27','14:50:51','kasir','PEMBELIAN UMUM','FB-260527-0001','10126244000','1827000','10124417000');
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 ('F226270311341','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBF-14-T','CC MODEL ISYANA SLEP LG 12 8K ','','0.480','1','100.00','538000','0','0','15000','533000','0','0','0','533000','LUS','T0079897','E1E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='E1E-ZEBF-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 ('F226270311341','2026-05-27','0.480','2026-05-27','15:11:35','PLG0080446','533000','533000','0','533000','533000','kasir','2026-05-27 15:11:34','F22627031134');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226270311341','2026-05-27','15:11:35','LUS','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) VALUES ('KM-260527-0006','D','2026-05-27','15:11:35','kasir','PENJUALAN','F226270311341','10124417000','533000','10124950000');
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 ('F226270322501','kasir','1',' MEF1 X TD ','TOKO','SMBK-F','F1E-ZAXE-78-0','GL X OVAL C GELOMBANG SLEP TD 60 8K ','','3.050','1','100.00','3370000','0','0','15000','3386000','0','0','0','3386000','TIN','00383999','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXE-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='F1E-ZAXE-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226270322501','2026-05-27','3.050','2026-05-27','15:22:51','PLG0080447','3386000','3386000','0','3386000','3386000','kasir','2026-05-27 15:22:50','F22627032250');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226270322501','2026-05-27','15:22:51','TIN','3386000','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-260527-0007','D','2026-05-27','15:22:51','kasir','PENJUALAN','F226270322501','10124950000','3386000','10128336000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3386000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270322501' 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 ('F226270322502','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZBAD-72-T','CC MODEL SLEP VAR CM 16 8K ','','0.860','1','100.00','933000','0','0','15000','937000','0','0','0','937000','TIN','T0077361','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAD-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-27' AND kode_barang='E1D-ZBAD-72-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 ('F226270322502','2026-05-27','0.860','2026-05-27','15:22:51','PLG0080448','937000','937000','0','937000','937000','kasir','2026-05-27 15:22:50','F22627032250');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-27','F226270322502','2026-05-27','15:22:51','TIN','937000','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-260527-0008','D','2026-05-27','15:22:51','kasir','PENJUALAN','F226270322502','10128336000','937000','10129273000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='937000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270322502' 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-00005395','X-00005395','LT X MODEL HURUF MATA LG L 8K','GR','---','D2E','BELI','BELI001','393000','2026-05-27','0.430','1','kasir','2026-05-27 15:39:20');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00005395','X-00005395');
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-260527-0002','F225060115261','LUS','1','BELI','BELI001','D2E', 'X-00005395', 'LT X MODEL HURUF MATA LG L 8K','0.430','0.430','100.00','428000','393000','913953','1120000','1','393000','393000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260527-0002','2026-05-27','2026-05-27','15:39:20','LUS','---','0.430','393000','393000','393000','393000','393000','kasir','2026-05-27 15:39:20','FB-260527-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260527-0002','APRIL','HK','','','','kasir','2026-05-27 15:39:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-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-260527-0009','K','2026-05-27','15:39:20','kasir','PEMBELIAN UMUM','FB-260527-0002','10129273000','393000','10128880000');
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-00005396','X-00005396','LT CHARM MODEL BONEKA SLEP VAR YT','GR','---','D1G','BELI','BELI001','238000','2026-05-27','0.300','1','kasir','2026-05-27 15:40:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00005396','X-00005396');
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-260527-0003','00320600','LUS','1','BELI','BELI001','D1G', 'X-00005396', 'LT CHARM MODEL BONEKA SLEP VAR YT','0.360','0.300','100.00','243000','238000','793333','1160000','1','238000','238000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260527-0003','2026-05-27','2026-05-27','15:40:49','LUS','---','0.300','238000','238000','238000','238000','238000','kasir','2026-05-27 15:40:50','FB-260527-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260527-0003','APRIL','HK','','','','kasir','2026-05-27 15:40:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-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-260527-0010','K','2026-05-27','15:40:49','kasir','PEMBELIAN UMUM','FB-260527-0003','10128880000','238000','10128642000');
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-00005397','X-00005397','GL FANCY VAR PITA HW 8K','GR','---','F3E','BELI','BELI001','2025000','2026-05-27','2.280','1','kasir','2026-05-27 15:41:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005397','X-00005397');
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-260527-0004','F226041103591','TIN','1','BELI','BELI001','F3E', 'X-00005397', 'GL FANCY VAR PITA HW 8K','2.280','2.280','100.00','2861000','2025000','888158','1120000','1','2025000','2025000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.280',berat_beli_asli=berat_beli_asli+'2.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.280',berat_akhir_asli=berat_akhir_asli+'2.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-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-260527-0004','2026-05-27','2026-05-27','15:41:39','TIN','---','2.280','2025000','2025000','2025000','2025000','2025000','kasir','2026-05-27 15:41:40','FB-260527-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260527-0004','VERLYANA','CINDEWILIS GG 1 NO 6','','','089503883398','kasir','2026-05-27 15:41:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-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-260527-0011','K','2026-05-27','15:41:39','kasir','PEMBELIAN UMUM','FB-260527-0004','10128642000','2025000','10126617000');
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-00005398','X-00005398','CC MODEL SPECTRA SLEP BM 12 8K','GR','---','E1E','BELI','BELI001','427000','2026-05-27','0.430','1','kasir','2026-05-27 15:42:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005398','X-00005398');
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-260527-0005','F226231255441','LUS','1','BELI','BELI001','E1E', 'X-00005398', 'CC MODEL SPECTRA SLEP BM 12 8K','0.430','0.430','100.00','475000','427000','993023','1120000','1','427000','427000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260527-0005','2026-05-27','2026-05-27','15:42:58','LUS','---','0.430','427000','427000','427000','427000','427000','kasir','2026-05-27 15:42:59','FB-260527-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260527-0005','FINA','BETON','','','085792385933','kasir','2026-05-27 15:42:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-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-260527-0012','K','2026-05-27','15:42:58','kasir','PEMBELIAN UMUM','FB-260527-0005','10126617000','427000','10126190000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270311341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270311341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270311341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270322501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270322501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270322501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270322502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270322502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270322502';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260527-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260527-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260527-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260527-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260527-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260527-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260527-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260527-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260527-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260527-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-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-05-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-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-260528-0001','D','2026-05-28','16:11:27','SYSTEM','SALDO AWAL','SALDO AWAL','0','10126190000','10126190000');
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-260528-0001','D','2026-05-28','16:11:27','BCA','SALDO AWAL','SALDO AWAL','0','4458568888','4458568888');
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-260528-0001','D','2026-05-28','16:11:27','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260528-0001','D','2026-05-28','16:11:27','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-260528-0001','D','2026-05-28','16:11:27','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-260528-0001','D','2026-05-28','16:11:27','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-05-28';