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 ('F326190846481','input','1',' MEF2 X LT ','TOKO','PM-F','F2E-YLAF-154-0','GL X PIPA SLEP LT 56 8K ','','4.010','1','100.00','4150000','0','0','15000','4150000','0','0','0','4150000','FIT','00381338','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAF-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.010',berat_jual_asli=berat_jual_asli+'4.010',stock_jual='1',berat_akhir=berat_akhir-'4.010',berat_akhir_asli=berat_akhir_asli-'4.010',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='F2E-YLAF-154-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 ('F326190846481','2026-07-19','4.010','2026-07-19','08:46:49','PLG0030384','4150000','4150000','0','4150000','4150000','input','2026-07-19 08:46:48','F32619084648');
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-07-19','F326190846481','2026-07-19','08:46:49','FIT','4150000','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-260719-0002','D','2026-07-19','08:46:49','input','PENJUALAN','F326190846481','6386924000','4150000','6391074000');
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 ('F326190851311','input','1',' MEF2 X HA ','TOKO','PM-F','F2E-YIBD-157-0','GL X PIPA MATA HA 54 8K ','','3.040','1','100.00','3146000','0','0','15000','3148000','0','0','0','3148000','FIT','00370578','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YIBD-157-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='F2E-YIBD-157-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 ('F326190851311','2026-07-19','3.040','2026-07-19','08:51:31','PLG0030385','3148000','3148000','0','3148000','3148000','input','2026-07-19 08:51:31','F32619085131');
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-07-19','F326190851311','2026-07-19','08:51:31','FIT','3148000','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-260719-0003','D','2026-07-19','08:51:31','input','PENJUALAN','F326190851311','6391074000','3148000','6394222000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190846481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190846481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190846481';
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 ('F326191001041','kasir','1',' TEF3 LT ','TOKO','PT-F','F3TE-ZGAG-62-T','GL RANTAI HOLLOW SLEP LT 17K ','','2.030','1','100.00','3857000','0','0','15000','3858000','0','0','0','3858000','SIN','T0081285','F3TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZGAG-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='F3TE-ZGAG-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326191001041','2026-07-19','2.030','2026-07-19','10:01:05','PLG0030386','3858000','3858000','0','3858000','3858000','kasir','2026-07-19 10:01:04','F32619100104');
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-07-19','F326191001041','2026-07-19','10:01:05','SIN','3858000','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-260719-0005','D','2026-07-19','10:01:05','kasir','PENJUALAN','F326191001041','6390072000','3858000','6393930000');
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 ('F326191008191','kasir','1',' MEE1 LG 19','TOKO','PM-E','E1E-ZFXA-130-0','CC BANGKOK SLEP LG 19 8K ','','0.550','1','100.00','569000','0','0','15000','570000','0','0','0','570000','SIN','00406298','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXA-130-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-07-19' AND kode_barang='E1E-ZFXA-130-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 ('F326191008191','2026-07-19','0.550','2026-07-19','10:08:19','PLG0030387','570000','570000','0','570000','570000','kasir','2026-07-19 10:08:19','F32619100819');
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-07-19','F326191008191','2026-07-19','10:08:19','SIN','570000','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-260719-0006','D','2026-07-19','10:08:19','kasir','PENJUALAN','F326191008191','6393930000','570000','6394500000');
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 ('F326191013011','kasir','1',' MDA1 HW ','TOKO','PM-A','A1D-ZDBC-214-0','AT MODEL BOLA ARESO HW 8K ','','0.820','1','100.00','832000','0','0','15000','833000','0','0','0','833000','FIT','00400936','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDBC-214-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='A1D-ZDBC-214-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 ('F326191013011','2026-07-19','0.820','2026-07-19','10:13:02','PLG0030388','833000','833000','0','833000','833000','kasir','2026-07-19 10:13:01','F32619101301');
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-07-19','F326191013011','2026-07-19','10:13:02','FIT','833000','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-260719-0007','D','2026-07-19','10:13:02','kasir','PENJUALAN','F326191013011','6394500000','833000','6395333000');
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 ('F326191038161','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZEBE-81-0','CC X BANGKOK SLEP CM 20 8K ','','1.000','1','100.00','1015000','0','0','15000','1015000','0','0','0','1015000','LIS','00404780','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBE-81-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-07-19' AND kode_barang='E1D-ZEBE-81-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 ('F326191038161','2026-07-19','1.000','2026-07-19','10:38:17','PLG0030389','1015000','1015000','0','1015000','1015000','kasir','2026-07-19 10:38:16','F32619103816');
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-07-19','F326191038161','2026-07-19','10:38:17','LIS','1015000','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-260719-0008','D','2026-07-19','10:38:17','kasir','PENJUALAN','F326191038161','6395333000','1015000','6396348000');
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 ('F326191101221','kasir','1',' MDB1 X LG ','TOKO','PM-B','B1D-YCAH-313-0','GW X MODEL MATA LG PE 8K ','','0.950','1','100.00','964000','0','0','15000','965000','0','0','0','965000','FIT','00343762','B1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YCAH-313-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='B1D-YCAH-313-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 ('F326191101221','2026-07-19','0.950','2026-07-19','11:01:22','PLG0030390','965000','965000','0','965000','965000','kasir','2026-07-19 11:01:22','F32619110122');
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-07-19','F326191101221','2026-07-19','11:01:22','FIT','965000','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-260719-0009','D','2026-07-19','11:01:22','kasir','PENJUALAN','F326191101221','6396348000','965000','6397313000');
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-00019674','X-00019674','CC X MODEL MATA LG 6 8K','GR','---','E2D','BELI','BELI001','952000','2026-07-19','1.000','1','kasir','2026-07-19 11:10:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019674','X-00019674');
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-260719-0001','F326120938071','FIT','1','BELI','BELI001','E2D', 'X-00019674', 'CC X MODEL MATA LG 6 8K','1.000','1.000','100.00','1155000','952000','952000','1025000','1','952000','952000','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-07-19' 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-260719-0001','2026-07-19','2026-07-19','11:10:06','FIT','---','1.000','952000','952000','952000','952000','952000','kasir','2026-07-19 11:10:06','FB-260719-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0001','FATMI','SIGERENG TEGALREJO','','','','kasir','2026-07-19 11:10:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0010','K','2026-07-19','11:10:06','kasir','PEMBELIAN UMUM','FB-260719-0001','6397313000','952000','6396361000');
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-00019675','X-00019675','CC MODEL PITA PASIR VAR CM 16 8K','GR','---','E1D','BELI','BELI001','792000','2026-07-19','0.840','1','kasir','2026-07-19 11:11:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019675','X-00019675');
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-260719-0002','F326040116182','FIT','1','BELI','BELI001','E1D', 'X-00019675', 'CC MODEL PITA PASIR VAR CM 16 8K','0.840','0.840','100.00','925000','792000','942857','1025000','1','792000','792000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.840',berat_beli_asli=berat_beli_asli+'0.840',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.840',berat_akhir_asli=berat_akhir_asli+'0.840',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0002','2026-07-19','2026-07-19','11:11:15','FIT','---','0.840','792000','792000','792000','792000','792000','kasir','2026-07-19 11:11:15','FB-260719-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0002','SUSI SUSANTI','BADEGAN','','','','kasir','2026-07-19 11:11:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0011','K','2026-07-19','11:11:15','kasir','PEMBELIAN UMUM','FB-260719-0002','6396361000','792000','6395569000');
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-00019676','X-00019676','GL X GUCCI UB 8K','GR','---','F3F','BELI','BELI001','575000','2026-07-19','0.580','1','kasir','2026-07-19 11:11:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00019676','X-00019676');
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-260719-0003','F326120924511','SIN','1','BELI','BELI001','F3F', 'X-00019676', 'GL X GUCCI UB 8K','0.580','0.580','100.00','620000','575000','991379','1055000','1','575000','575000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260719-0003','2026-07-19','2026-07-19','11:11:33','SIN','---','0.580','575000','575000','575000','575000','575000','kasir','2026-07-19 11:11:34','FB-260719-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0003','MURNI','SAMBENG KISMANTORO','','','','kasir','2026-07-19 11:11:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0012','K','2026-07-19','11:11:33','kasir','PEMBELIAN UMUM','FB-260719-0003','6395569000','575000','6394994000');
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-00019677','X-00019677','CC MODEL MATA VAR CM 14 8K','GR','---','E2E','BELI','BELI001','482000','2026-07-19','0.760','1','kasir','2026-07-19 11:13:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019677','X-00019677');
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-260719-0004','F324180129221','SIN','1','BELI','BELI001','E2E', 'X-00019677', 'CC MODEL MATA VAR CM 14 8K','0.760','0.760','100.00','460000','482000','634211','1045000','1','482000','482000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.760',berat_beli_asli=berat_beli_asli+'0.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.760',berat_akhir_asli=berat_akhir_asli+'0.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0004','2026-07-19','2026-07-19','11:13:07','SIN','---','0.760','482000','482000','482000','482000','482000','kasir','2026-07-19 11:13:08','FB-260719-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0004','VITO','BANGSRI WATESWETAN','','','','kasir','2026-07-19 11:13:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0013','K','2026-07-19','11:13:07','kasir','PEMBELIAN UMUM','FB-260719-0004','6394994000','482000','6394512000');
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-00019678','X-00019678','LT X MODEL HURUF MATA LG Y 8K','GR','---','D2E','BELI','BELI001','560000','2026-07-19','0.570','1','kasir','2026-07-19 11:16:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00019678','X-00019678');
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-260719-0005','F326180248191','LIS','1','BELI','BELI001','D2E', 'X-00019678', 'LT X MODEL HURUF MATA LG Y 8K','0.570','0.570','100.00','590000','560000','982456','1045000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.570',berat_beli_asli=berat_beli_asli+'0.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.570',berat_akhir_asli=berat_akhir_asli+'0.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260719-0005','2026-07-19','2026-07-19','11:16:20','LIS','---','0.570','560000','560000','560000','560000','560000','kasir','2026-07-19 11:16:21','FB-260719-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0005','YUNI','SINDERAN PURWANTORO','','','087875866457','kasir','2026-07-19 11:16:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0014','K','2026-07-19','11:16:20','kasir','PEMBELIAN UMUM','FB-260719-0005','6394512000','560000','6393952000');
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-00019679','X-00019679','KL X SANTA UB 42 8K','GR','---','H1E','BELI','BELI001','3030000','2026-07-19','3.080','1','kasir','2026-07-19 11:16:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019679','X-00019679');
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-260719-0006','F326180248192','LIS','2','BELI','BELI001','H1E', 'X-00019679', 'KL X SANTA UB 42 8K','3.080','3.080','100.00','3188000','3030000','983766','1045000','1','3030000','3030000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.080',berat_beli_asli=berat_beli_asli+'3.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.080',berat_akhir_asli=berat_akhir_asli+'3.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0006','2026-07-19','2026-07-19','11:16:20','LIS','---','3.080','3030000','3030000','3030000','3030000','3030000','kasir','2026-07-19 11:16:21','FB-260719-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0006','YUNI','SINDERAN PURWANTORO','','','087875866457','kasir','2026-07-19 11:16:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0015','K','2026-07-19','11:16:20','kasir','PEMBELIAN UMUM','FB-260719-0006','6393952000','3030000','6390922000');
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-00019680','X-00019680','GL X MEDAN SLEP UB 8K','GR','---','F3F','BELI','BELI001','2030000','2026-07-19','2.050','1','kasir','2026-07-19 11:25:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00019680','X-00019680');
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-260719-0007','F326150102311','LIS','1','BELI','BELI001','F3F', 'X-00019680', 'GL X MEDAN SLEP UB 8K','2.050','2.050','100.00','2368000','2030000','990244','1055000','1','2030000','2030000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260719-0007','2026-07-19','2026-07-19','11:25:06','LIS','---','2.050','2030000','2030000','2030000','2030000','2030000','kasir','2026-07-19 11:25:07','FB-260719-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0007','RATI','BANGSRI','','','','kasir','2026-07-19 11:25:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0016','K','2026-07-19','11:25:06','kasir','PEMBELIAN UMUM','FB-260719-0007','6390922000','2030000','6388892000');
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 ('F326191150491','kasir','1',' MGA1G DG ','TOKO','PM-A','A1G-ZGAE-78-0','AT TINDIK BABY DG 8K ','','0.250','1','100.00','269000','0','0','15000','270000','0','0','0','270000','SIN','00413685','A1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='A1G-ZGAE-78-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 ('F326191150491','2026-07-19','0.250','2026-07-19','11:50:50','PLG0030391','270000','270000','0','270000','270000','kasir','2026-07-19 11:50:49','F32619115049');
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-07-19','F326191150491','2026-07-19','11:50:50','SIN','270000','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-260719-0017','D','2026-07-19','11:50:50','kasir','PENJUALAN','F326191150491','6388892000','270000','6389162000');
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-00019681','X-00019681','AT COR 8K','GR','---','A1D','BELI','BELI001','915000','2026-07-19','0.970','1','kasir','2026-07-19 11:52:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019681','X-00019681');
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-260719-0008','00404436','SIN','1','BELI','BELI001','A1D', 'X-00019681', 'AT COR 8K','0.970','0.970','100.00','1077000','915000','943299','1025000','1','915000','915000','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-07-19' 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-260719-0008','2026-07-19','2026-07-19','11:52:29','SIN','---','0.970','915000','915000','915000','915000','915000','kasir','2026-07-19 11:52:30','FB-260719-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0008','RINA','BUNGKAL','','','','kasir','2026-07-19 11:52:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0018','K','2026-07-19','11:52:29','kasir','PEMBELIAN UMUM','FB-260719-0008','6389162000','915000','6388247000');
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-00019682','X-00019682','CC X SPIRAL MATA UB 14 8K','GR','---','E1D','BELI','BELI001','802000','2026-07-19','0.980','1','kasir','2026-07-19 11:55:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019682','X-00019682');
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-260719-0009','F326260902211','FIT','1','BELI','BELI001','E1D', 'X-00019682', 'CC X SPIRAL MATA UB 14 8K','0.980','0.980','100.00','1088000','802000','818367','1025000','1','802000','802000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0009','2026-07-19','2026-07-19','11:55:13','FIT','---','0.980','802000','802000','802000','802000','802000','kasir','2026-07-19 11:55:13','FB-260719-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0009','SISKA','GIRIHARJO','','','081215817654','kasir','2026-07-19 11:55:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0019','K','2026-07-19','11:55:13','kasir','PEMBELIAN UMUM','FB-260719-0009','6388247000','802000','6387445000');
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-00019683','X-00019683','CC X SOLITAIRE MATA YT 11 8K','GR','---','E2D','BELI','BELI001','780000','2026-07-19','0.820','1','kasir','2026-07-19 11:55:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019683','X-00019683');
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-260719-0010','F326250306532','FIT','2','BELI','BELI001','E2D', 'X-00019683', 'CC X SOLITAIRE MATA YT 11 8K','0.820','0.820','100.00','927000','780000','951220','1025000','1','780000','780000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0010','2026-07-19','2026-07-19','11:55:13','FIT','---','0.820','780000','780000','780000','780000','780000','kasir','2026-07-19 11:55:13','FB-260719-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0010','SISKA','GIRIHARJO','','','081215817654','kasir','2026-07-19 11:55:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0020','K','2026-07-19','11:55:13','kasir','PEMBELIAN UMUM','FB-260719-0010','6387445000','780000','6386665000');
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 ('F326191159371','kasir','1',' MIH2 X UB ','TOKO','PM-H','H2I-ZDBX-153-0','KL X SANTA PANJANG UB 58 9K ','','4.800','1','100.00','5352000','0','0','15000','5352000','0','0','0','5352000','LIS','00400090','H2I','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZDBX-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.800',berat_jual_asli=berat_jual_asli+'4.800',stock_jual='1',berat_akhir=berat_akhir-'4.800',berat_akhir_asli=berat_akhir_asli-'4.800',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='H2I-ZDBX-153-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 ('F326191159371','2026-07-19','4.800','2026-07-19','11:59:38','PLG0030392','5352000','5352000','0','5352000','5352000','kasir','2026-07-19 11:59:37','F32619115937');
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-07-19','F326191159371','2026-07-19','11:59:38','LIS','5352000','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-260719-0021','D','2026-07-19','11:59:38','kasir','PENJUALAN','F326191159371','6386665000','5352000','6392017000');
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 ('F326191201321','kasir','1',' MEE2 5K LG','TOKO','PM-E','E2E-ZDBE-395-0','CC ANAK OSROT BONEKA CAT MATA LG 8K ','','0.530','1','100.00','549000','0','0','15000','550000','0','5000','0','555000','SIN','00401163','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBE-395-0' 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-07-19' AND kode_barang='E2E-ZDBE-395-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 ('F326191201321','2026-07-19','0.530','2026-07-19','12:01:32','PLG0030393','550000','550000','5000','555000','555000','kasir','2026-07-19 12:01:32','F32619120132');
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-07-19','F326191201321','2026-07-19','12:01:32','SIN','555000','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-260719-0022','D','2026-07-19','12:01:32','kasir','PENJUALAN','F326191201321','6392017000','555000','6392572000');
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-00019684','X-00019684','CC X MODEL MATA IW 18 8K','GR','---','E2D','BELI','BELI001','1200000','2026-07-19','1.260','1','kasir','2026-07-19 12:59:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019684','X-00019684');
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-260719-0011','F326130808081','LIS','1','BELI','BELI001','E2D', 'X-00019684', 'CC X MODEL MATA IW 18 8K','1.260','1.260','100.00','1385000','1200000','952381','1025000','1','1200000','1200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' 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-260719-0011','2026-07-19','2026-07-19','12:59:27','LIS','---','1.260','1200000','1200000','1200000','1200000','1200000','kasir','2026-07-19 12:59:28','FB-260719-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0011','SINTA','JANGGIR','','','085646328323','kasir','2026-07-19 12:59:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0023','K','2026-07-19','12:59:27','kasir','PEMBELIAN UMUM','FB-260719-0011','6392572000','1200000','6391372000');
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-00019685','X-00019685','AT X KLIP MODEL MATA VAR LG','GR','---','A1TE','BELI','BELI001','2900000','2026-07-19','2.150','1','kasir','2026-07-19 14:24:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00019685','X-00019685');
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-260719-0012','F324181008021','FIT','1','BELI','BELI001','A1TE', 'X-00019685', 'AT X KLIP MODEL MATA VAR LG','2.150','2.150','100.00','2312000','2900000','1348837','1900000','1','2900000','2900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.150',berat_beli_asli=berat_beli_asli+'2.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.150',berat_akhir_asli=berat_akhir_asli+'2.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-260719-0012','2026-07-19','2026-07-19','14:24:37','FIT','---','2.150','2900000','2900000','2900000','2900000','2900000','kasir','2026-07-19 14:24:37','FB-260719-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0012','ENI','KISMANTORO','','','','kasir','2026-07-19 14:24:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0024','K','2026-07-19','14:24:37','kasir','PEMBELIAN UMUM','FB-260719-0012','6391372000','2900000','6388472000');
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 ('F326190227431','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZGXF-4-0','GL CASTELI SLEP HW 8K ','','1.070','1','100.00','1107000','0','0','15000','1108000','0','0','0','1108000','SIN','00412385','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXF-4-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-07-19' AND kode_barang='F3E-ZGXF-4-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 ('F326190227431','2026-07-19','1.070','2026-07-19','14:27:44','PLG0030394','1108000','1108000','0','1108000','1108000','kasir','2026-07-19 14:27:43','F32619022743');
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-07-19','F326190227431','2026-07-19','14:27:44','SIN','1108000','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-260719-0025','D','2026-07-19','14:27:44','kasir','PENJUALAN','F326190227431','6388472000','1108000','6389580000');
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 ('F326190231011','kasir','1',' MEF2 X YT ','TOKO','PM-F','F2E-XIAB-194-0','GL X OVAL MATA YT 54 8K ','','2.060','1','100.00','2132000','0','0','15000','2133000','0','0','0','2133000','FIT','00317438','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-XIAB-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='F2E-XIAB-194-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 ('F326190231011','2026-07-19','2.060','2026-07-19','14:31:02','PLG0030395','2133000','2133000','0','2133000','2133000','kasir','2026-07-19 14:31:01','F32619023101');
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-07-19','F326190231011','2026-07-19','14:31:02','FIT','2133000','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-260719-0026','D','2026-07-19','14:31:02','kasir','PENJUALAN','F326190231011','6389580000','2133000','6391713000');
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 ('F326190242491','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCAI-534-0','CC X WEDDING POLOS CM 12 8K ','','1.000','1','100.00','1015000','0','0','15000','1015000','0','0','0','1015000','LIS','00395932','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAI-534-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-07-19' AND kode_barang='E1D-ZCAI-534-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 ('F326190242491','2026-07-19','1.000','2026-07-19','14:42:50','PLG0030396','1015000','1015000','0','1015000','1015000','kasir','2026-07-19 14:42:49','F32619024249');
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-07-19','F326190242491','2026-07-19','14:42:50','LIS','1015000','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-260719-0027','D','2026-07-19','14:42:50','kasir','PENJUALAN','F326190242491','6391713000','1015000','6392728000');
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-00019686','X-00019686','CC COR M 8K','GR','---','E2F','BELI','BELI001','302000','2026-07-19','0.510','1','kasir','2026-07-19 14:55:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00019686','X-00019686');
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-260719-0013','F323270250591','SIN','1','BELI','BELI001','E2F', 'X-00019686', 'CC COR M 8K','0.530','0.510','100.00','250000','302000','592157','1055000','1','302000','302000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-260719-0013','2026-07-19','2026-07-19','14:55:24','SIN','---','0.510','302000','302000','302000','302000','302000','kasir','2026-07-19 14:55:24','FB-260719-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260719-0013','AMAR','PAKISBARU','','','','kasir','2026-07-19 14:55:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-19' 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-260719-0028','K','2026-07-19','14:55:24','kasir','PEMBELIAN UMUM','FB-260719-0013','6392728000','302000','6392426000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260719-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260719-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190227431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190227431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190227431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190231011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190231011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190231011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190242491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190242491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190242491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326190851311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326190851311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326190851311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191001041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191001041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191001041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191008191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191008191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191008191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191013011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191013011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191013011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191038161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191038161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191038161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191101221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191101221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191101221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191150491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191150491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191150491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191159371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191159371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191159371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326191201321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326191201321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326191201321';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-19';
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-07-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-19' 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-260720-0001','D','2026-07-20','15:08:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','6392426000','6392426000');
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-260720-0001','D','2026-07-20','15:08:30','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-260720-0001','D','2026-07-20','15:08:30','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-260720-0001','D','2026-07-20','15:08:30','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
UPDATE tp_system SET tgl_system='2026-07-20';