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 ('F326070939091','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZFXD-337-0','GL CAPELA SPECTRA VAR SLEP HW 8K ','','3.800','1','100.00','4245000','0','0','15000','4245000','0','0','0','4245000','AAT','00407216','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-337-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='F3E-ZFXD-337-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 ('F326070939091','2026-06-07','3.800','2026-06-07','09:39:10','PLG0029616','4245000','4245000','0','4245000','4245000','input','2026-06-07 09:39:09','F32607093909');
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-07','F326070939091','2026-06-07','09:39:10','AAT','4245000','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-260607-0002','D','2026-06-07','09:39:10','input','PENJUALAN','F326070939091','5502372000','4245000','5506617000');
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 ('F326070948161','input','1',' MEF3E PM ','TOKO','PM-F','F3E-YJAD-44-0','GL KREPYAK VENNETA SLEP PM 8K ','','3.010','1','100.00','3362000','0','0','15000','3363000','0','0','0','3363000','SIN','00373085','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAD-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='F3E-YJAD-44-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 ('F326070948161','2026-06-07','3.010','2026-06-07','09:48:16','PLG0029617','3363000','3363000','0','3363000','3363000','input','2026-06-07 09:48:16','F32607094816');
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-07','F326070948161','2026-06-07','09:48:16','SIN','3363000','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-260607-0003','D','2026-06-07','09:48:16','input','PENJUALAN','F326070948161','5506617000','3363000','5509980000');
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 ('F326070958331','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZFXE-193-0','GL CASTELI SPECTRA SLEP HW 8K ','','1.440','1','100.00','1609000','0','0','15000','1608000','0','0','0','1608000','SIN','00407445','F3E','0','0','-','1','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXE-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='F3E-ZFXE-193-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 ('F326070958331','2026-06-07','1.440','2026-06-07','09:58:34','PLG0029618','1608000','1608000','0','1608000','1608000','input','2026-06-07 09:58:33','F32607095833');
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-07','F326070958331','2026-06-07','09:58:34','SIN','1608000','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-260607-0004','D','2026-06-07','09:58:34','input','PENJUALAN','F326070958331','5509980000','1608000','5511588000');
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 ('F326071012201','input','1',' MEF2 X UB ','TOKO','PM-F','F2E-ZDBI-71-0','GL X PIPA MATA ROSE UB 54 8K ','','3.980','1','100.00','4446000','0','0','15000','4447000','0','0','0','4447000','AAT','00401717','F2E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZDBI-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.980',berat_jual_asli=berat_jual_asli+'3.980',stock_jual='1',berat_akhir=berat_akhir-'3.980',berat_akhir_asli=berat_akhir_asli-'3.980',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='F2E-ZDBI-71-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 ('F326071012201','2026-06-07','3.980','2026-06-07','10:12:21','PLG0029619','4447000','4447000','0','4447000','4447000','input','2026-06-07 10:12:20','F32607101220');
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-07','F326071012201','2026-06-07','10:12:21','AAT','4447000','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-260607-0005','D','2026-06-07','10:12:21','input','PENJUALAN','F326071012201','5511588000','4447000','5516035000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4447000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071012201' 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 ('F326071012202','input',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZDAH-201-0','CC X MODEL MATA CM 10 8K ','','0.800','1','100.00','878000','0','0','15000','878000','0','0','0','878000','AAT','00399902','E2D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAH-201-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E2D-ZDAH-201-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 ('F326071012202','2026-06-07','0.800','2026-06-07','10:12:21','PLG0029620','878000','878000','0','878000','878000','input','2026-06-07 10:12:20','F32607101220');
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-07','F326071012202','2026-06-07','10:12:21','AAT','878000','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-260607-0006','D','2026-06-07','10:12:21','input','PENJUALAN','F326071012202','5516035000','878000','5516913000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='878000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071012202' 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 ('F326071020201','kasir','1',' TEE2 X LG ','TOKO','PT-E','E2TE-XDAB-21-T','CC X MODEL MATA VAR LG 8 17K ','','1.700','1','100.00','3485000','0','0','15000','3485000','0','0','0','3485000','AAT','T0056291','E2TE','0','0','-','0','2050000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-XDAB-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E2TE-XDAB-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326071020201','2026-06-07','1.700','2026-06-07','10:20:20','PLG0029621','3485000','3485000','0','3485000','3485000','kasir','2026-06-07 10:20:20','F32607102020');
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-07','F326071020201','2026-06-07','10:20:20','AAT','3485000','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-260607-0007','D','2026-06-07','10:20:20','kasir','PENJUALAN','F326071020201','5516913000','3485000','5520398000');
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 ('F326071033241','kasir','1',' MEE1 X LG ','TOKO','PM-E','E1E-XEAG-296-0','CC X MODEL SLEP LG 16 8K ','','1.430','1','100.00','1597000','0','0','15000','1597000','0','0','0','1597000','AAT','00298488','E1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-XEAG-296-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E1E-XEAG-296-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 ('F326071033241','2026-06-07','1.430','2026-06-07','10:33:24','PLG0029622','1597000','1597000','0','1597000','1597000','kasir','2026-06-07 10:33:24','F32607103324');
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-07','F326071033241','2026-06-07','10:33:24','AAT','1597000','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-260607-0008','D','2026-06-07','10:33:24','kasir','PENJUALAN','F326071033241','5520398000','1597000','5521995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1597000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071033241' 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 ('F326071033242','kasir',' 1',' MDE1 X LG ','TOKO','PM-E','E1D-ZDBA-171-0','CC X MODEL SLEP LG 20 8K ','','2.690','1','100.00','2951000','0','0','15000','2953000','0','0','0','2953000','AAT','00400454','E1D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBA-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E1D-ZDBA-171-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 ('F326071033242','2026-06-07','2.690','2026-06-07','10:33:24','PLG0029623','2953000','2953000','0','2953000','2953000','kasir','2026-06-07 10:33:24','F32607103324');
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-07','F326071033242','2026-06-07','10:33:24','AAT','2953000','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-260607-0009','D','2026-06-07','10:33:24','kasir','PENJUALAN','F326071033242','5521995000','2953000','5524948000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2953000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071033242' 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 ('F326071102581','kasir','1',' MEA1E DG ','TOKO','PM-A','A1E-ZDAG-168-0','AT GYPSY ANAK DG 8K ','','0.500','1','100.00','558000','0','0','15000','558000','0','0','0','558000','SIN','00399697','A1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDAG-168-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-07' AND kode_barang='A1E-ZDAG-168-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 ('F326071102581','2026-06-07','0.500','2026-06-07','11:02:59','PLG0029624','558000','558000','0','558000','558000','kasir','2026-06-07 11:02:58','F32607110258');
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-07','F326071102581','2026-06-07','11:02:59','SIN','558000','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-260607-0010','D','2026-06-07','11:02:59','kasir','PENJUALAN','F326071102581','5524948000','558000','5525506000');
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-00019314','X-00019314','AT X HUGGIES MATA VAR LT 8K','GR','---','A1D','BELI','BELI001','1195000','2026-06-07','1.160','1','kasir','2026-06-07 11:20:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019314','X-00019314');
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-260607-0001','F326141006043','AAT','1','BELI','BELI001','A1D', 'X-00019314', 'AT X HUGGIES MATA VAR LT 8K','1.160','1.160','100.00','1340000','1195000','1030172','1107000','1','1195000','1195000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260607-0001','2026-06-07','2026-06-07','11:20:54','AAT','---','1.160','1195000','1195000','1195000','1195000','1195000','kasir','2026-06-07 11:20:54','FB-260607-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0001','SINDY','CRABAK GAMBIRANOM','','','085728450819','kasir','2026-06-07 11:20:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0011','K','2026-06-07','11:20:54','kasir','PEMBELIAN UMUM','FB-260607-0001','5525506000','1195000','5524311000');
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-00019315','X-00019315','GL XXX CAPELLA SLEP UB 8K','GR','---','F3E','BELI','BELI001','3807000','2026-06-07','3.620','1','kasir','2026-06-07 11:21:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019315','X-00019315');
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-260607-0002','F326160901441','FIT','1','BELI','BELI001','F3E', 'X-00019315', 'GL XXX CAPELLA SLEP UB 8K','3.620','3.620','100.00','4008000','3807000','1051657','1127000','1','3807000','3807000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.620',berat_beli_asli=berat_beli_asli+'3.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.620',berat_akhir_asli=berat_akhir_asli+'3.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' 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-260607-0002','2026-06-07','2026-06-07','11:21:49','FIT','---','3.620','3807000','3807000','3807000','3807000','3807000','kasir','2026-06-07 11:21:50','FB-260607-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0002','NURI','DOMAS BULUKERTO','','','081337047137','kasir','2026-06-07 11:21:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0012','K','2026-06-07','11:21:49','kasir','PEMBELIAN UMUM','FB-260607-0002','5524311000','3807000','5520504000');
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-00019316','X-00019316','GL XXX SHOGUN KACA HW 60 8K','GR','---','F1E','BELI','BELI001','2900000','2026-06-07','2.710','1','kasir','2026-06-07 11:23:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019316','X-00019316');
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-260607-0003','F326110958281','SIN','1','BELI','BELI001','F1E', 'X-00019316', 'GL XXX SHOGUN KACA HW 60 8K','2.710','2.710','100.00','3103000','2900000','1070111','1127000','1','2900000','2900000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.710',berat_beli_asli=berat_beli_asli+'2.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.710',berat_akhir_asli=berat_akhir_asli+'2.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260607-0003','2026-06-07','2026-06-07','11:23:14','SIN','---','2.710','2900000','2900000','2900000','2900000','2900000','kasir','2026-06-07 11:23:14','FB-260607-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0003','PURWANTI','WATES BULUKERTO','','','085803687216','kasir','2026-06-07 11:23:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0013','K','2026-06-07','11:23:14','kasir','PEMBELIAN UMUM','FB-260607-0003','5520504000','2900000','5517604000');
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-00019317','X-00019317','CC X BONEKA ANAK CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','440000','2026-06-07','0.420','1','kasir','2026-06-07 11:23:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019317','X-00019317');
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-260607-0004','F326011144091','SIN','1','BELI','BELI001','E2E', 'X-00019317', 'CC X BONEKA ANAK CAT MATA LG 8K','0.420','0.420','100.00','485000','440000','1047619','1127000','1','440000','440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260607-0004','2026-06-07','2026-06-07','11:23:46','SIN','---','0.420','440000','440000','440000','440000','440000','kasir','2026-06-07 11:23:47','FB-260607-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0004','LING LING','JERUK PACITAN','','','','kasir','2026-06-07 11:23:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0014','K','2026-06-07','11:23:46','kasir','PEMBELIAN UMUM','FB-260607-0004','5517604000','440000','5517164000');
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 ('F326071127491','kasir','1',' MDE1D LG 1','TOKO','PM-E','E1D-ZFXE-211-0','CC MODEL SLEP LG 16 8K ','','1.210','1','100.00','1327000','0','0','15000','1328000','0','0','0','1328000','AAT','00407463','E1D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-211-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E1D-ZFXE-211-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 ('F326071127491','2026-06-07','1.210','2026-06-07','11:27:49','PLG0029625','1328000','1328000','0','1328000','1328000','kasir','2026-06-07 11:27:49','F32607112749');
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-07','F326071127491','2026-06-07','11:27:49','AAT','1328000','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-260607-0015','D','2026-06-07','11:27:49','kasir','PENJUALAN','F326071127491','5517164000','1328000','5518492000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1328000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071127491' 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 ('F326071127492','kasir',' 1',' MDA1D X TD','TOKO','PM-A','A1D-ZEBG-212-0','AT X MODEL SPECTRA HITAM VAR TD 8K ','','1.070','1','100.00','1174000','0','0','15000','1175000','0','10000','0','1185000','AAT','00405211','A1D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-212-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='A1D-ZEBG-212-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 ('F326071127492','2026-06-07','1.070','2026-06-07','11:27:49','PLG0029626','1175000','1175000','10000','1185000','1185000','kasir','2026-06-07 11:27:49','F32607112749');
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-07','F326071127492','2026-06-07','11:27:49','AAT','1185000','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-260607-0016','D','2026-06-07','11:27:49','kasir','PENJUALAN','F326071127492','5518492000','1185000','5519677000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1185000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326071127492' 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-00019318','X-00019318','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','915000','2026-06-07','0.900','1','kasir','2026-06-07 11:38:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019318','X-00019318');
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-260607-0005','F326231250151','SIN','1','BELI','BELI001','E2D', 'X-00019318', 'CC WEDDING MATA CM 20 8K','0.900','0.900','100.00','1008000','915000','1016667','1107000','1','915000','915000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' 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-260607-0005','2026-06-07','2026-06-07','11:38:03','SIN','---','0.900','915000','915000','915000','915000','915000','kasir','2026-06-07 11:38:04','FB-260607-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0005','ASIH','BANGSRI PWO','','','','kasir','2026-06-07 11:38:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0017','K','2026-06-07','11:38:03','kasir','PEMBELIAN UMUM','FB-260607-0005','5519677000','915000','5518762000');
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-00019319','X-00019319','CC X MODEL CAT MATA YT 14 8K','GR','---','E2D','BELI','BELI001','1000000','2026-06-07','0.970','1','kasir','2026-06-07 13:12:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019319','X-00019319');
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-260607-0006','F326310254071','AAT','1','BELI','BELI001','E2D', 'X-00019319', 'CC X MODEL CAT MATA YT 14 8K','0.970','0.970','100.00','1183000','1000000','1030928','1107000','1','1000000','1000000','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-07' 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-260607-0006','2026-06-07','2026-06-07','13:12:29','AAT','---','0.970','1000000','1000000','1000000','1000000','1000000','kasir','2026-06-07 13:12:29','FB-260607-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0006','MARCILINA','JATISRONO','','','085868074357','kasir','2026-06-07 13:12:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0018','K','2026-06-07','13:12:29','kasir','PEMBELIAN UMUM','FB-260607-0006','5518762000','1000000','5517762000');
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 ('F326070116191','kasir','1',' MEF3E XXX ','TOKO','PM-F','F3E-ZFXC-174-0','GL XXX TIFF SLEP KH 8K ','','1.970','1','100.00','2201000','0','0','15000','2141000','0','0','0','2141000','SIN','00406717','F3E','0','0','-','1','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-174-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='F3E-ZFXC-174-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 ('F326070116191','2026-06-07','1.970','2026-06-07','13:16:19','PLG0029627','2141000','2141000','0','2141000','2141000','kasir','2026-06-07 13:16:19','F32607011619');
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-07','F326070116191','2026-06-07','13:16:19','SIN','2141000','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-260607-0019','D','2026-06-07','13:16:19','kasir','PENJUALAN','F326070116191','5517762000','2141000','5519903000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2141000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070116191' 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 ('F326070116192','kasir',' 1',' MDE2D UB 1','TOKO','PM-E','E2D-ZEBB-120-T','CC MODEL MATA SLEP UB 16 8K ','','1.090','1','100.00','1196000','0','0','15000','1196000','0','0','0','1196000','SIN','T0079883','E2D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBB-120-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E2D-ZEBB-120-T' 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 ('F326070116192','2026-06-07','1.090','2026-06-07','13:16:19','PLG0029628','1196000','1196000','0','1196000','1196000','kasir','2026-06-07 13:16:19','F32607011619');
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-07','F326070116192','2026-06-07','13:16:19','SIN','1196000','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-260607-0020','D','2026-06-07','13:16:19','kasir','PENJUALAN','F326070116192','5519903000','1196000','5521099000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1196000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070116192' 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 ('F326070123381','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZEBE-197-0','KL X SANTA KH 44 8K ','','5.060','1','100.00','5652000','0','0','15000','5640000','0','0','0','5640000','FIT','00404896','H1E','0','0','-','1','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-197-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.060',berat_jual_asli=berat_jual_asli+'5.060',stock_jual='1',berat_akhir=berat_akhir-'5.060',berat_akhir_asli=berat_akhir_asli-'5.060',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='H1E-ZEBE-197-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326070123381','2026-06-07','5.060','2026-06-07','13:23:38','PLG0029629','5640000','5640000','0','5640000','5640000','kasir','2026-06-07 13:23:38','F32607012338');
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-07','F326070123381','2026-06-07','13:23:38','FIT','5640000','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-260607-0021','D','2026-06-07','13:23:38','kasir','PENJUALAN','F326070123381','5521099000','5640000','5526739000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5640000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070123381' 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 ('F326070123382','kasir',' 1',' MDD2D X CM','TOKO','PM-D','D2D-ZCXG-302-0','LT X MODEL MATA CM 8K ','','0.870','1','100.00','954000','0','0','15000','950000','0','0','0','950000','FIT','00392738','D2D','0','0','-','1','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCXG-302-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='D2D-ZCXG-302-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326070123382','2026-06-07','0.870','2026-06-07','13:23:38','PLG0029630','950000','950000','0','950000','950000','kasir','2026-06-07 13:23:38','F32607012338');
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-07','F326070123382','2026-06-07','13:23:38','FIT','950000','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-260607-0022','D','2026-06-07','13:23:38','kasir','PENJUALAN','F326070123382','5526739000','950000','5527689000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='950000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070123382' 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 ('F326070134431','kasir','1',' MEH1E UB 5','TOKO','PM-H','H1E-ZEBB-110-T','KL NORY SEMI UB 54 8K ','','4.020','1','100.00','4490000','0','0','15000','4490000','0','0','0','4490000','FIT','T0079873','H1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBB-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='H1E-ZEBB-110-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326070134431','2026-06-07','4.020','2026-06-07','13:34:43','PLG0029631','4490000','4490000','0','4490000','4490000','kasir','2026-06-07 13:34:43','F32607013443');
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-07','F326070134431','2026-06-07','13:34:43','FIT','4490000','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-260607-0023','D','2026-06-07','13:34:43','kasir','PENJUALAN','F326070134431','5527689000','4490000','5532179000');
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-00019320','X-00019320','GL X OVAL GELOMBANG C SLEP YT 60 8K','GR','---','F1E','BELI','BELI001','3873000','2026-06-07','3.820','1','kasir','2026-06-07 13:44:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019320','X-00019320');
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-260607-0007','F326171028271','FIT','1','BELI','BELI001','F1E', 'X-00019320', 'GL X OVAL GELOMBANG C SLEP YT 60 8K','3.820','3.820','100.00','4165000','3873000','1013874','1127000','1','3873000','3873000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.820',berat_beli_asli=berat_beli_asli+'3.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.820',berat_akhir_asli=berat_akhir_asli+'3.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260607-0007','2026-06-07','2026-06-07','13:44:44','FIT','---','3.820','3873000','3873000','3873000','3873000','3873000','kasir','2026-06-07 13:44:44','FB-260607-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0007','AJENG','GONDANG PWT','','','','kasir','2026-06-07 13:44:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0024','K','2026-06-07','13:44:44','kasir','PEMBELIAN UMUM','FB-260607-0007','5532179000','3873000','5528306000');
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 ('F326070204211','input','1',' MEB1E X UB','TOKO','PM-B','B1E-ZEXI-73-0','GW X TIFF ARESO VAR UB 8K','','0.420','1','100.00','469000','0','0','15000','470000','0','0','0','470000','SIN','00402894','B1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXI-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='B1E-ZEXI-73-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 ('F326070204211','2026-06-07','0.420','2026-06-07','14:04:22','PLG0029632','470000','470000','0','470000','470000','input','2026-06-07 14:04:21','F32607020421');
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-07','F326070204211','2026-06-07','14:04:22','SIN','470000','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-260607-0025','D','2026-06-07','14:04:22','input','PENJUALAN','F326070204211','5528306000','470000','5528776000');
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 ('F326070235081','kasir','1',' MEE1 5K CM','TOKO','PM-E','E1E-ZDBH-45-0','CC MODEL PITA PASIR VAR CM 14 8K ','','0.700','1','100.00','782000','0','0','15000','782000','0','5000','0','787000','SIN','00401616','E1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E1E-ZDBH-45-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 ('F326070235081','2026-06-07','0.700','2026-06-07','14:35:09','PLG0029633','782000','782000','5000','787000','787000','kasir','2026-06-07 14:35:08','F32607023508');
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-07','F326070235081','2026-06-07','14:35:09','SIN','787000','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-260607-0026','D','2026-06-07','14:35:09','kasir','PENJUALAN','F326070235081','5528776000','787000','5529563000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='787000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070235081' 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 ('F326070235082','kasir',' 1',' MEE1E LG19','TOKO','PM-E','E1E-ZEBB-112-T','CC BANGKOK SLEP LG 19 8K ','','0.530','1','100.00','592000','0','0','15000','593000','0','0','0','593000','SIN','T0079875','E1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBB-112-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-07' AND kode_barang='E1E-ZEBB-112-T' 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 ('F326070235082','2026-06-07','0.530','2026-06-07','14:35:09','PLG0029634','593000','593000','0','593000','593000','kasir','2026-06-07 14:35:08','F32607023508');
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-07','F326070235082','2026-06-07','14:35:09','SIN','593000','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-260607-0027','D','2026-06-07','14:35:09','kasir','PENJUALAN','F326070235082','5529563000','593000','5530156000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326070235082' 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-00019321','X-00019321','CC X WEDDING MATA CM 22 8K','GR','---','E2E','BELI','BELI001','1365000','2026-06-07','1.870','1','kasir','2026-06-07 14:43:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019321','X-00019321');
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-260607-0008','F324110201041','FIT','1','BELI','BELI001','E2E', 'X-00019321', 'CC X WEDDING MATA CM 22 8K','1.870','1.870','100.00','1203000','1365000','729947','1127000','1','1365000','1365000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.870',berat_beli_asli=berat_beli_asli+'1.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.870',berat_akhir_asli=berat_akhir_asli+'1.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260607-0008','2026-06-07','2026-06-07','14:43:16','FIT','---','1.870','1365000','1365000','1365000','1365000','1365000','kasir','2026-06-07 14:43:17','FB-260607-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0008','PUTRI','GESING KISMANTORO','','','','kasir','2026-06-07 14:43:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0028','K','2026-06-07','14:43:16','kasir','PEMBELIAN UMUM','FB-260607-0008','5530156000','1365000','5528791000');
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-00019322','X-00019322','GL FANCY MODEL CLOVER SLEP 3C VAR HW 8K','GR','---','F3E','BELI','BELI001','1600000','2026-06-07','2.180','1','kasir','2026-06-07 14:45:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019322','X-00019322');
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-260607-0009','F324301159031','FIT','1','BELI','BELI001','F3E', 'X-00019322', 'GL FANCY MODEL CLOVER SLEP 3C VAR HW 8K','2.180','2.180','100.00','1300000','1600000','733945','1127000','1','1600000','1600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.180',berat_beli_asli=berat_beli_asli+'2.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.180',berat_akhir_asli=berat_akhir_asli+'2.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-07' 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-260607-0009','2026-06-07','2026-06-07','14:45:22','FIT','---','2.180','1600000','1600000','1600000','1600000','1600000','kasir','2026-06-07 14:45:22','FB-260607-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260607-0009','DENI YUSPITA','NAWANGAN','','','','kasir','2026-06-07 14:45:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-07' 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-260607-0029','K','2026-06-07','14:45:22','kasir','PEMBELIAN UMUM','FB-260607-0009','5528791000','1600000','5527191000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260607-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260607-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070116191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070116191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070116191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070116192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070116192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070116192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070123381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070123381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070123381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070123382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070123382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070123382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070134431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070134431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070134431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070204211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070204211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070204211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070235081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070235081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070235081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070235082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070235082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070235082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070939091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070939091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070939091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070948161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070948161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070948161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326070958331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326070958331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326070958331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071012201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071012201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071012201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071012202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071012202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071012202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071020201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071020201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071020201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071033241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071033241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071033241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071033242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071033242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071033242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071102581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071102581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071102581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071127491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071127491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071127491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326071127492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326071127492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326071127492';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-07';
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-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-07';
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-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-07' 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-260608-0001','D','2026-06-08','15:12:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','5527191000','5527191000');
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-260608-0001','D','2026-06-08','15:12:10','BCA','SALDO AWAL','SALDO AWAL','0','715799000','715799000');
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-260608-0001','D','2026-06-08','15:12:10','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-260608-0001','D','2026-06-08','15:12:10','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-08';