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 ('F326080808141','input','1',' MDE1 5K PM','TOKO','PM-E','E1D-ZFXE-195-0','CC BANGKOK SLEP PM 18 8K ','','1.150','1','100.00','1262000','0','0','15000','1262000','0','5000','0','1267000','SIN','00407447','E1D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-195-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1D-ZFXE-195-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 ('F326080808141','2026-06-08','1.150','2026-06-08','08:08:14','PLG0029635','1262000','1262000','5000','1267000','1267000','input','2026-06-08 08:08:14','F32608080814');
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-08','F326080808141','2026-06-08','08:08:14','SIN','1267000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0002','D','2026-06-08','08:08:14','input','PENJUALAN','F326080808141','5527191000','1267000','5528458000');
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 ('F326080825371','input','1',' MEF3E X YT','TOKO','PM-F','F3E-ZFXC-178-0','GL X SANTA DAUN SERUT VAR YT 8K','','2.000','1','100.00','2234000','0','0','15000','2235000','0','0','0','2235000','AAT','00406721','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXC-178-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 ('F326080825371','2026-06-08','2.000','2026-06-08','08:25:38','PLG0029636','2235000','2235000','0','2235000','2235000','input','2026-06-08 08:25:37','F32608082537');
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-08','F326080825371','2026-06-08','08:25:38','AAT','2235000','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-260608-0003','D','2026-06-08','08:25:38','input','PENJUALAN','F326080825371','5528458000','2235000','5530693000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2235000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080825371' 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 ('F326080825372','input',' 1',' MDA1D X LT','TOKO','PM-A','A1D-ZDAX-83-0','AT X ITALY MATA VAR LT 8K ','','1.000','1','100.00','1097000','0','0','15000','1097000','0','0','0','1097000','AAT','00398853','A1D','0','0','-','0','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDAX-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZDAX-83-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 ('F326080825372','2026-06-08','1.000','2026-06-08','08:25:38','PLG0029637','1097000','1097000','0','1097000','1097000','input','2026-06-08 08:25:37','F32608082537');
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-08','F326080825372','2026-06-08','08:25:38','AAT','1097000','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-260608-0004','D','2026-06-08','08:25:38','input','PENJUALAN','F326080825372','5530693000','1097000','5531790000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1097000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080825372' 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 ('F326080825373','input',' 1',' MEE2 X HW ','TOKO','PM-E','E2E-ZDBX-311-0','CC X MODEL MATA HW 17 8K ','','0.550','1','100.00','614000','0','0','15000','615000','0','0','0','615000','AAT','00400248','E2E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-311-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2E-ZDBX-311-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 ('F326080825373','2026-06-08','0.550','2026-06-08','08:25:38','PLG0029638','615000','615000','0','615000','615000','input','2026-06-08 08:25:37','F32608082537');
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-08','F326080825373','2026-06-08','08:25:38','AAT','615000','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-260608-0005','D','2026-06-08','08:25:38','input','PENJUALAN','F326080825373','5531790000','615000','5532405000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080825373' 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 ('F326080912111','input','1',' TEE1 LG 18','TOKO','PT-E','E1TE-YDAH-66-T','CC BANGKOK SLEP VAR LG 18 17K ','','0.530','1','100.00','1086000','0','0','15000','1086000','0','0','0','1086000','FIT','T0068752','E1TE','0','0','-','0','2050000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-YDAH-66-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-08' AND kode_barang='E1TE-YDAH-66-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 ('F326080912111','2026-06-08','0.530','2026-06-08','09:12:12','PLG0029639','1086000','1086000','0','1086000','1086000','input','2026-06-08 09:12:11','F32608091211');
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-08','F326080912111','2026-06-08','09:12:12','FIT','1086000','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-260608-0006','D','2026-06-08','09:12:12','input','PENJUALAN','F326080912111','5532405000','1086000','5533491000');
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 ('F326080918541','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZCAI-765-0','GL MODEL FANCY VAR HW 8K ','','1.530','1','100.00','1709000','0','0','15000','1710000','0','0','0','1710000','SIN','00396167','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-765-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZCAI-765-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 ('F326080918541','2026-06-08','1.530','2026-06-08','09:18:54','PLG0029640','1710000','1710000','0','1710000','1710000','input','2026-06-08 09:18:54','F32608091854');
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-08','F326080918541','2026-06-08','09:18:54','SIN','1710000','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-260608-0007','D','2026-06-08','09:18:54','input','PENJUALAN','F326080918541','5533491000','1710000','5535201000');
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-00019323','X-00019323','GL X CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1250000','2026-06-08','1.200','1','kasir','2026-06-08 10:41:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019323','X-00019323');
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-260608-0001','F326140957231','AAT','1','BELI','BELI001','F3E', 'X-00019323', 'GL X CAPELLA SLEP HW 8K','1.200','1.200','100.00','1345000','1250000','1041667','1127000','1','1250000','1250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0001','2026-06-08','2026-06-08','10:41:12','AAT','---','1.200','1250000','1250000','1250000','1250000','1250000','kasir','2026-06-08 10:41:12','FB-260608-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0001','SUSI','PUHPELEM','','','','kasir','2026-06-08 10:41:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0008','K','2026-06-08','10:41:12','kasir','PEMBELIAN UMUM','FB-260608-0001','5535201000','1250000','5533951000');
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-00019324','X-00019324','CC X POLOS CM 20 8K','GR','---','E1D','BELI','BELI001','1040000','2026-06-08','1.010','1','kasir','2026-06-08 10:41:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019324','X-00019324');
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-260608-0002','F326180917161','AAT','1','BELI','BELI001','E1D', 'X-00019324', 'CC X POLOS CM 20 8K','1.010','1.010','100.00','1178000','1040000','1029703','1107000','1','1040000','1040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0002','2026-06-08','2026-06-08','10:41:43','AAT','---','1.010','1040000','1040000','1040000','1040000','1040000','kasir','2026-06-08 10:41:43','FB-260608-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0002','MARSIYEM','PUCUNG KISMANTORO','','','081325944190','kasir','2026-06-08 10:41:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0009','K','2026-06-08','10:41:43','kasir','PEMBELIAN UMUM','FB-260608-0002','5533951000','1040000','5532911000');
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-00019325','X-00019325','AT ANAK MODEL BONEKA CAT VAR UB 8K','GR','---','A1E','BELI','BELI001','665000','2026-06-08','0.930','1','kasir','2026-06-08 10:42:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019325','X-00019325');
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-260608-0003','F325220108231','LIS','1','BELI','BELI001','A1E', 'X-00019325', 'AT ANAK MODEL BONEKA CAT VAR UB 8K','0.930','0.930','100.00','857000','665000','715054','1127000','1','665000','665000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260608-0003','2026-06-08','2026-06-08','10:42:17','LIS','---','0.930','665000','665000','665000','665000','665000','kasir','2026-06-08 10:42:18','FB-260608-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0003','IRMA','TEGALREJO','','','','kasir','2026-06-08 10:42:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0010','K','2026-06-08','10:42:17','kasir','PEMBELIAN UMUM','FB-260608-0003','5532911000','665000','5532246000');
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-00019326','X-00019326','GL XX PIPA MATA PM 56 8K','GR','---','F2E','BELI','BELI001','3100000','2026-06-08','2.950','1','kasir','2026-06-08 10:48:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00019326','X-00019326');
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-260608-0004','F326010140411','FIT','1','BELI','BELI001','F2E', 'X-00019326', 'GL XX PIPA MATA PM 56 8K','2.950','2.950','100.00','3570000','3100000','1050847','1127000','1','3100000','3100000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260608-0004','2026-06-08','2026-06-08','10:48:14','FIT','---','2.950','3100000','3100000','3100000','3100000','3100000','kasir','2026-06-08 10:48:14','FB-260608-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0004','SITI','SLOGOHIMO','','','','kasir','2026-06-08 10:48:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0011','K','2026-06-08','10:48:14','kasir','PEMBELIAN UMUM','FB-260608-0004','5532246000','3100000','5529146000');
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-00019327','X-00019327','CC EROPA STAMPEL DW 16','GR','---','E0TA','BELI','BELI001','5270000','2026-06-08','3.000','1','kasir','2026-06-08 10:49:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00019327','X-00019327');
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-260608-0005','F326211208502','LIS','1','BELI','BELI001','E0TA', 'X-00019327', 'CC EROPA STAMPEL DW 16','3.000','3.000','100.00','5730000','5270000','1756667','1960000','1','5270000','5270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-260608-0005','2026-06-08','2026-06-08','10:49:17','LIS','---','3.000','5270000','5270000','5270000','5270000','5270000','kasir','2026-06-08 10:49:17','FB-260608-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0005','FITRI','JANGGIR','','','082184428756','kasir','2026-06-08 10:49:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0012','K','2026-06-08','10:49:17','kasir','PEMBELIAN UMUM','FB-260608-0005','5529146000','5270000','5523876000');
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-00019328','X-00019328','GL X TIFF ARESO VAR YT 8K','GR','---','F3E','BELI','BELI001','1785000','2026-06-08','1.800','1','kasir','2026-06-08 10:50:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019328','X-00019328');
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-260608-0006','F326081008541','FIT','1','BELI','BELI001','F3E', 'X-00019328', 'GL X TIFF ARESO VAR YT 8K','2.000','1.800','100.00','2440000','1785000','991667','1127000','1','1785000','1785000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.800',berat_beli_asli=berat_beli_asli+'1.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.800',berat_akhir_asli=berat_akhir_asli+'1.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0006','2026-06-08','2026-06-08','10:50:28','FIT','---','1.800','1785000','1785000','1785000','1785000','1785000','kasir','2026-06-08 10:50:29','FB-260608-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0006','KARTI','SANGGRONG TEGALREJO','','','','kasir','2026-06-08 10:50:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0013','K','2026-06-08','10:50:28','kasir','PEMBELIAN UMUM','FB-260608-0006','5523876000','1785000','5522091000');
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-00019329','X-00019329','CC COR M 8K','GR','---','E2E','BELI','BELI001','470000','2026-06-08','0.750','1','kasir','2026-06-08 10:53:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019329','X-00019329');
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-260608-0007','F323260223351','SIN','1','BELI','BELI001','E2E', 'X-00019329', 'CC COR M 8K','0.750','0.750','100.00','340000','470000','626667','1127000','1','470000','470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0007','2026-06-08','2026-06-08','10:53:47','SIN','---','0.750','470000','470000','470000','470000','470000','kasir','2026-06-08 10:53:48','FB-260608-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0007','ISE','PLOSO KISMANTORO','','','085601039918','kasir','2026-06-08 10:53:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0014','K','2026-06-08','10:53:47','kasir','PEMBELIAN UMUM','FB-260608-0007','5522091000','470000','5521621000');
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-00019330','X-00019330','GL X BANGKOK TIMBUL SLEP UB 58 8K','GR','---','F1E','BELI','BELI001','9820000','2026-06-08','10.190','1','kasir','2026-06-08 10:56:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019330','X-00019330');
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-260608-0008','F326231123371','LIS','1','BELI','BELI001','F1E', 'X-00019330', 'GL X BANGKOK TIMBUL SLEP UB 58 8K','10.190','10.190','100.00','11158000','9820000','963690','1127000','1','9820000','9820000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.190',berat_beli_asli=berat_beli_asli+'10.190',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.190',berat_akhir_asli=berat_akhir_asli+'10.190',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0008','2026-06-08','2026-06-08','10:56:29','LIS','---','10.190','9820000','9820000','9820000','9820000','9820000','kasir','2026-06-08 10:56:30','FB-260608-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0008','LATINI','BITING BADEGAN','','','085235267722','kasir','2026-06-08 10:56:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0015','K','2026-06-08','10:56:29','kasir','PEMBELIAN UMUM','FB-260608-0008','5521621000','9820000','5511801000');
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-00019331','X-00019331','CC X MODEL SLEP CM 18 8K','GR','---','E1D','BELI','BELI001','1470000','2026-06-08','1.450','1','kasir','2026-06-08 10:56:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019331','X-00019331');
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-260608-0009','F326261103161','LIS','2','BELI','BELI001','E1D', 'X-00019331', 'CC X MODEL SLEP CM 18 8K','1.450','1.450','100.00','1580000','1470000','1013793','1107000','1','1470000','1470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0009','2026-06-08','2026-06-08','10:56:29','LIS','---','1.450','1470000','1470000','1470000','1470000','1470000','kasir','2026-06-08 10:56:30','FB-260608-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0009','LATINI','BITING BADEGAN','','','','kasir','2026-06-08 10:56:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0016','K','2026-06-08','10:56:29','kasir','PEMBELIAN UMUM','FB-260608-0009','5511801000','1470000','5510331000');
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-00019332','X-00019332','CC X MODEL MATA CM 20 8K','GR','---','E2D','BELI','BELI001','2320000','2026-06-08','2.320','1','kasir','2026-06-08 10:56:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019332','X-00019332');
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-260608-0010','F326231123372','LIS','3','BELI','BELI001','E2D', 'X-00019332', 'CC X MODEL MATA CM 20 8K','2.320','2.320','100.00','2495000','2320000','1000000','1107000','1','2320000','2320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.320',berat_beli_asli=berat_beli_asli+'2.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.320',berat_akhir_asli=berat_akhir_asli+'2.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0010','2026-06-08','2026-06-08','10:56:29','LIS','---','2.320','2320000','2320000','2320000','2320000','2320000','kasir','2026-06-08 10:56:30','FB-260608-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0010','LATINI','BITING BADEGAN','','','085235267722','kasir','2026-06-08 10:56:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0017','K','2026-06-08','10:56:29','kasir','PEMBELIAN UMUM','FB-260608-0010','5510331000','2320000','5508011000');
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-00019333','X-00019333','CC X MODEL MATA OR 20 8K','GR','---','E2D','BELI','BELI001','2270000','2026-06-08','2.270','1','kasir','2026-06-08 10:56:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019333','X-00019333');
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-260608-0011','F326240941131','LIS','4','BELI','BELI001','E2D', 'X-00019333', 'CC X MODEL MATA OR 20 8K','2.270','2.270','100.00','2440000','2270000','1000000','1107000','1','2270000','2270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.270',berat_beli_asli=berat_beli_asli+'2.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.270',berat_akhir_asli=berat_akhir_asli+'2.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0011','2026-06-08','2026-06-08','10:56:29','LIS','---','2.270','2270000','2270000','2270000','2270000','2270000','kasir','2026-06-08 10:56:30','FB-260608-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0011','LATINI','BITING BADEGAN','','','','kasir','2026-06-08 10:56:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0018','K','2026-06-08','10:56:29','kasir','PEMBELIAN UMUM','FB-260608-0011','5508011000','2270000','5505741000');
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-00019334','X-00019334','AT XXX ITALY SLEP VAR UB 8K','GR','---','A1D','BELI','BELI001','970000','2026-06-08','1.010','1','kasir','2026-06-08 11:00:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019334','X-00019334');
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-260608-0012','F325181002121','AAT','1','BELI','BELI001','A1D', 'X-00019334', 'AT XXX ITALY SLEP VAR UB 8K','1.010','1.010','100.00','1023000','970000','960396','1107000','1','970000','970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0012','2026-06-08','2026-06-08','11:00:16','AAT','---','1.010','970000','970000','970000','970000','970000','kasir','2026-06-08 11:00:17','FB-260608-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0012','IDA','PUHPELEM','','','085327927924','kasir','2026-06-08 11:00:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0019','K','2026-06-08','11:00:16','kasir','PEMBELIAN UMUM','FB-260608-0012','5505741000','970000','5504771000');
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-00019335','X-00019335','CC MODEL DAUN SLEP LG 16 8K','GR','---','E1E','BELI','BELI001','470000','2026-06-08','0.470','1','kasir','2026-06-08 12:12:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019335','X-00019335');
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-260608-0013','F326310146071','SIN','1','BELI','BELI001','E1E', 'X-00019335', 'CC MODEL DAUN SLEP LG 16 8K','0.470','0.470','100.00','522000','470000','1000000','1127000','1','470000','470000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0013','2026-06-08','2026-06-08','12:12:04','SIN','---','0.470','470000','470000','470000','470000','470000','kasir','2026-06-08 12:12:04','FB-260608-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0013','NATA','NAWANGAN PCT','','','','kasir','2026-06-08 12:12:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0020','K','2026-06-08','12:12:04','kasir','PEMBELIAN UMUM','FB-260608-0013','5504771000','470000','5504301000');
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-00019336','X-00019336','KL NORY ANAK UB 34 8K','GR','---','H1E','BELI','BELI001','998000','2026-06-08','1.050','1','kasir','2026-06-08 12:12:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019336','X-00019336');
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-260608-0014','F326040230351','LIS','1','BELI','BELI001','H1E', 'X-00019336', 'KL NORY ANAK UB 34 8K','1.050','1.050','100.00','1175000','998000','950476','1127000','1','998000','998000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260608-0014','2026-06-08','2026-06-08','12:12:51','LIS','---','1.050','998000','998000','998000','998000','998000','kasir','2026-06-08 12:12:51','FB-260608-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0014','DIO','KISMANTORO','','','085291009536','kasir','2026-06-08 12:12:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0021','K','2026-06-08','12:12:51','kasir','PEMBELIAN UMUM','FB-260608-0014','5504301000','998000','5503303000');
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 ('F326081214511','kasir','1',' MEH1E HW 3','TOKO','PM-H','H1E-ZFXD-305-0','KL SANTA ANAK HW 32 8K ','','1.100','1','100.00','1229000','0','0','15000','1230000','0','0','0','1230000','LIS','00407184','H1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-305-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZFXD-305-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 ('F326081214511','2026-06-08','1.100','2026-06-08','12:14:51','PLG0029641','1230000','1230000','0','1230000','1230000','kasir','2026-06-08 12:14:51','F32608121451');
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-08','F326081214511','2026-06-08','12:14:51','LIS','1230000','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-260608-0022','D','2026-06-08','12:14:51','kasir','PENJUALAN','F326081214511','5503303000','1230000','5504533000');
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-00019337','X-00019337','GL XXX OSROT BONEKA ANAK CAT LG 8K','GR','---','F1E','BELI','BELI001','1010000','2026-06-08','1.000','1','kasir','2026-06-08 12:43:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019337','X-00019337');
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-260608-0015','F326050913251','LIS','1','BELI','BELI001','F1E', 'X-00019337', 'GL XXX OSROT BONEKA ANAK CAT LG 8K','1.000','1.000','100.00','1065000','1010000','1010000','1127000','1','1010000','1010000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' 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-260608-0015','2026-06-08','2026-06-08','12:43:11','LIS','---','1.000','1010000','1010000','1010000','1010000','1010000','kasir','2026-06-08 12:43:11','FB-260608-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0015','CILIYA','GENENG BULUKERTO','','','083117520037','kasir','2026-06-08 12:43:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0023','K','2026-06-08','12:43:11','kasir','PEMBELIAN UMUM','FB-260608-0015','5504533000','1010000','5503523000');
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 ('F326080147431','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZDAH-95-0','GL X KREPYAK DAUN SLEP YT 8K ','','4.420','1','100.00','4937000','0','0','15000','4938000','0','0','0','4938000','LIS','00399796','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAH-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.420',berat_jual_asli=berat_jual_asli+'4.420',stock_jual='1',berat_akhir=berat_akhir-'4.420',berat_akhir_asli=berat_akhir_asli-'4.420',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZDAH-95-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 ('F326080147431','2026-06-08','4.420','2026-06-08','13:47:43','PLG0029642','4938000','4938000','0','4938000','4938000','kasir','2026-06-08 13:47:43','F32608014743');
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-08','F326080147431','2026-06-08','13:47:43','LIS','4938000','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-260608-0024','D','2026-06-08','13:47:43','kasir','PENJUALAN','F326080147431','5503523000','4938000','5508461000');
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 ('F326080213071','kasir','1',' MEH1 HW 36','TOKO','PM-H','H1E-ZDCX-1-0','KL ANAK MODEL FLIK HW 36CM 8K ','','1.180','1','100.00','1318000','0','0','15000','1318000','0','0','0','1318000','SIN','00401860','H1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDCX-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZDCX-1-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 ('F326080213071','2026-06-08','1.180','2026-06-08','14:13:08','PLG0029643','1318000','1318000','0','1318000','1318000','kasir','2026-06-08 14:13:07','F32608021307');
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-08','F326080213071','2026-06-08','14:13:08','SIN','1318000','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-260608-0025','D','2026-06-08','14:13:08','kasir','PENJUALAN','F326080213071','5508461000','1318000','5509779000');
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 ('F326080229411','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZFXC-166-0','GL X TIFF SLEP VAR HW 8K ','','1.710','1','100.00','1910000','0','0','15000','1910000','0','0','0','1910000','LIS','00406709','F3E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXC-166-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 ('F326080229411','2026-06-08','1.710','2026-06-08','14:29:41','PLG0029644','1910000','1910000','0','1910000','1910000','input','2026-06-08 14:29:41','F32608022941');
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-08','F326080229411','2026-06-08','14:29:41','LIS','1910000','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-260608-0026','D','2026-06-08','14:29:41','input','PENJUALAN','F326080229411','5509779000','1910000','5511689000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080229411' 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 ('F326080229412','input',' 1',' MEH1 KH 42','TOKO','PM-H','H1E-ZDAE-219-0','KL SIEM COBRA KH 42 8K ','','2.030','1','100.00','2268000','0','0','15000','2268000','0','0','0','2268000','LIS','00399505','H1E','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAE-219-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZDAE-219-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 ('F326080229412','2026-06-08','2.030','2026-06-08','14:29:41','PLG0029645','2268000','2268000','0','2268000','2268000','input','2026-06-08 14:29:41','F32608022941');
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-08','F326080229412','2026-06-08','14:29:41','LIS','2268000','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-260608-0027','D','2026-06-08','14:29:41','input','PENJUALAN','F326080229412','5511689000','2268000','5513957000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2268000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080229412' 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 ('F326080229413','input',' 1',' MDE1D CM 1','TOKO','PM-E','E1D-ZEBB-119-T','CC WEDDING MATA SLEP CM 14 8K ','','0.830','1','100.00','911000','0','0','15000','910000','0','10000','0','920000','LIS','T0079882','E1D','0','0','-','1','1107000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBB-119-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1D-ZEBB-119-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 ('F326080229413','2026-06-08','0.830','2026-06-08','14:29:41','PLG0029646','910000','910000','10000','920000','920000','input','2026-06-08 14:29:41','F32608022941');
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-08','F326080229413','2026-06-08','14:29:41','LIS','920000','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-260608-0028','D','2026-06-08','14:29:41','input','PENJUALAN','F326080229413','5513957000','920000','5514877000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='920000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080229413' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080147431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080147431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080147431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080213071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080213071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080213071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080229411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080229412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080229413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080229413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080808141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080808141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080808141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080825371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080825372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825373' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080825373' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080825373';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080912111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080912111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080912111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080918541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080918541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080918541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081214511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081214511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081214511';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-08';
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-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-08';
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-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-08' 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-260609-0001','D','2026-06-09','15:09:24','SYSTEM','SALDO AWAL','SALDO AWAL','0','5514877000','5514877000');
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-260609-0001','D','2026-06-09','15:09:24','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-260609-0001','D','2026-06-09','15:09:24','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-260609-0001','D','2026-06-09','15:09:24','BCA','SALDO AWAL','SALDO AWAL','0','715799000','715799000');
UPDATE tp_system SET tgl_system='2026-06-09';