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 ('F325070800031','input','1',' MEF1 X CM ','TOKO','PM-F','F1E-YKBB-186-0','GL X OVAL DAUN SLEP CM 54 8K ','','3.260','1','100.00','3348000','0','0','15000','3350000','0','0','0','3350000','FIT','00378335','F1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKBB-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.260',berat_jual_asli=berat_jual_asli+'3.260',stock_jual='1',berat_akhir=berat_akhir-'3.260',berat_akhir_asli=berat_akhir_asli-'3.260',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='F1E-YKBB-186-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 ('F325070800031','2025-12-07','3.260','2025-12-07','08:00:04','PLG0026055','3350000','3350000','0','3350000','3350000','input','2025-12-07 08:00:03','F32507080003');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070800031','2025-12-07','08:00:04','FIT','3350000','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-251207-0002','D','2025-12-07','08:00:04','input','PENJUALAN','F325070800031','1028261000','3350000','1031611000');
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 ('F325070856291','input','1',' TFE2 X MT ','TOKO','PT-E','E2TF-WAXC-108-T','CC X WEDDING MATA MT 8 ','','2.110','1','100.00','3998000','0','0','15000','4000000','0','0','0','4000000','SIN','T0041160','E2TF','0','0','-','0','1895000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TF-WAXC-108-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E2TF-WAXC-108-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 ('F325070856291','2025-12-07','2.110','2025-12-07','08:56:29','PLG0026056','4000000','4000000','0','4000000','4000000','input','2025-12-07 08:56:29','F32507085629');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070856291','2025-12-07','08:56:29','SIN','4000000','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-251207-0003','D','2025-12-07','08:56:29','input','PENJUALAN','F325070856291','1031611000','4000000','1035611000');
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 ('F325070857101','input','1',' MDA1 UB ','TOKO','PM-A','A1D-YDXE-134-0','AT MODEL PITA MATA VAR UB 8K ','','1.090','1','100.00','1098000','0','0','15000','1098000','0','0','0','1098000','FIT','00348144','A1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YDXE-134-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='A1D-YDXE-134-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 ('F325070857101','2025-12-07','1.090','2025-12-07','08:57:10','PLG0026057','1098000','1098000','0','1098000','1098000','input','2025-12-07 08:57:10','F32507085710');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070857101','2025-12-07','08:57:10','FIT','1098000','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-251207-0004','D','2025-12-07','08:57:10','input','PENJUALAN','F325070857101','1035611000','1098000','1036709000');
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 ('F325070903181','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-YLXD-16-0','KL X SANTA KH 42 8K ','','2.050','1','100.00','2105000','0','0','15000','2105000','0','0','0','2105000','AAT','00379602','H1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='H1E-YLXD-16-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 ('F325070903181','2025-12-07','2.050','2025-12-07','09:03:18','PLG0026058','2105000','2105000','0','2105000','2105000','input','2025-12-07 09:03:18','F32507090318');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070903181','2025-12-07','09:03:18','AAT','2105000','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-251207-0005','D','2025-12-07','09:03:18','input','PENJUALAN','F325070903181','1036709000','2105000','1038814000');
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 ('F325070911091','input','1',' MDA1D X CM','TOKO','PM-A','A1D-YHXI-33-0','AT X MODEL KLIP MATA CM 8K ','','1.180','1','100.00','1188000','0','0','15000','1188000','0','0','0','1188000','FIT','00364897','A1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YHXI-33-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='2025-12-07' AND kode_barang='A1D-YHXI-33-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 ('F325070911091','2025-12-07','1.180','2025-12-07','09:11:10','PLG0026059','1188000','1188000','0','1188000','1188000','input','2025-12-07 09:11:09','F32507091109');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070911091','2025-12-07','09:11:10','FIT','1188000','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-251207-0006','D','2025-12-07','09:11:10','input','PENJUALAN','F325070911091','1038814000','1188000','1040002000');
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 ('F325070915241','input','1',' MEF3E X KH','TOKO','PM-F','F3E-YEAI-86-0','GL X TIFF MATA VAR KH 8K ','','3.380','1','100.00','3471000','0','0','15000','3470000','0','0','0','3470000','AAT','00354570','F3E','0','0','-','1','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YEAI-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='F3E-YEAI-86-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 ('F325070915241','2025-12-07','3.380','2025-12-07','09:15:25','PLG0026060','3470000','3470000','0','3470000','3470000','input','2025-12-07 09:15:24','F32507091524');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070915241','2025-12-07','09:15:25','AAT','3470000','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-251207-0007','D','2025-12-07','09:15:25','input','PENJUALAN','F325070915241','1040002000','3470000','1043472000');
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 ('F325070920331','input','1',' MFD1F X BW','TOKO','PM-D','D1F-XCAF-277-0','LT X MODEL BOLA PASIR BW 8K ','','0.560','1','100.00','586000','0','0','15000','587000','0','0','0','587000','FIT','00286486','D1F','0','0','-','0','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-XCAF-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='D1F-XCAF-277-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325070920331','2025-12-07','0.560','2025-12-07','09:20:33','PLG0026061','587000','587000','0','587000','587000','input','2025-12-07 09:20:33','F32507092033');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070920331','2025-12-07','09:20:33','FIT','587000','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-251207-0008','D','2025-12-07','09:20:33','input','PENJUALAN','F325070920331','1043472000','587000','1044059000');
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 ('F325070920591','input','1',' MFH1 UB 42','TOKO','PM-H','H1F-YKBB-28-0','KL MILANO UB 42 8K ','','2.070','1','100.00','2167000','0','0','15000','2168000','0','0','0','2168000','FIT','00378177','H1F','0','0','-','0','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YKBB-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='H1F-YKBB-28-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 ('F325070920591','2025-12-07','2.070','2025-12-07','09:20:59','PLG0026062','2168000','2168000','0','2168000','2168000','input','2025-12-07 09:20:59','F32507092059');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070920591','2025-12-07','09:20:59','FIT','2168000','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-251207-0009','D','2025-12-07','09:20:59','input','PENJUALAN','F325070920591','1044059000','2168000','1046227000');
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 ('F325070930571','input','1',' MDE1 CM 16','TOKO','PM-E','E1D-YKBH-102-0','CC MODEL DAUN VAR CM 16 8K ','','1.150','1','100.00','1158000','0','0','15000','1160000','0','0','0','1160000','FIT','00378963','E1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBH-102-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='2025-12-07' AND kode_barang='E1D-YKBH-102-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 ('F325070930571','2025-12-07','1.150','2025-12-07','09:30:57','PLG0026063','1160000','1160000','0','1160000','1160000','input','2025-12-07 09:30:57','F32507093057');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070930571','2025-12-07','09:30:57','FIT','1160000','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-251207-0010','D','2025-12-07','09:30:57','input','PENJUALAN','F325070930571','1046227000','1160000','1047387000');
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 ('F325070936111','input','1',' MDE1 CM 16','TOKO','PM-E','E1D-YKBI-187-0','CC MODEL BOLA SLEP VAR CM 16 8K ','','2.160','1','100.00','2175000','0','0','15000','2155000','0','0','0','2155000','FIT','00379153','E1D','0','0','-','1','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBI-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E1D-YKBI-187-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 ('F325070936111','2025-12-07','2.160','2025-12-07','09:36:11','PLG0026064','2155000','2155000','0','2155000','2155000','input','2025-12-07 09:36:11','F32507093611');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070936111','2025-12-07','09:36:11','FIT','2155000','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-251207-0011','D','2025-12-07','09:36:11','input','PENJUALAN','F325070936111','1047387000','2155000','1049542000');
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 ('F325070938331','input','1',' MFE1 X LG ','TOKO','PM-E','E1F-YIBC-361-0','CC X BABY PLAT LG 8K ','','0.550','1','100.00','576000','0','0','15000','575000','0','0','0','575000','SIN','00370332','E1F','0','0','-','1','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YIBC-361-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='2025-12-07' AND kode_barang='E1F-YIBC-361-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 ('F325070938331','2025-12-07','0.550','2025-12-07','09:38:33','PLG0026065','575000','575000','0','575000','575000','input','2025-12-07 09:38:33','F32507093833');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070938331','2025-12-07','09:38:33','SIN','575000','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-251207-0012','D','2025-12-07','09:38:33','input','PENJUALAN','F325070938331','1049542000','575000','1050117000');
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 ('F325070939191','input','1',' MEE2 5K LG','TOKO','PM-E','E2E-YLXA-8-0','CC MODEL BONEKA ANAK CAT MATA LG 8K ','','0.480','1','100.00','493000','0','0','15000','493000','0','5000','0','498000','SIN','00379166','E2E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLXA-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E2E-YLXA-8-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 ('F325070939191','2025-12-07','0.480','2025-12-07','09:39:19','PLG0026066','493000','493000','5000','498000','498000','input','2025-12-07 09:39:19','F32507093919');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070939191','2025-12-07','09:39:19','SIN','498000','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-251207-0013','D','2025-12-07','09:39:19','input','PENJUALAN','F325070939191','1050117000','498000','1050615000');
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 ('F325070941491','input','1',' MEA1E 5K L','TOKO','PM-A','A1E-YLXC-233-0','AT BONEKA ANAK CAT MATA VAR LG 8K ','','0.520','1','100.00','534000','0','0','15000','535000','0','5000','0','540000','AAT','00379549','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='A1E-YLXC-233-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 ('F325070941491','2025-12-07','0.520','2025-12-07','09:41:49','PLG0026067','535000','535000','5000','540000','540000','input','2025-12-07 09:41:49','F32507094149');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070941491','2025-12-07','09:41:49','AAT','540000','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-251207-0014','D','2025-12-07','09:41:49','input','PENJUALAN','F325070941491','1050615000','540000','1051155000');
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 ('F325070951031','input','1',' MEE2 X AY ','TOKO','PM-E','E2E-YHXI-249-0','CC X MODEL MATA AY 14 8K ','','0.680','1','100.00','698000','0','0','15000','700000','0','5000','0','705000','FIT','00365113','E2E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXI-249-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E2E-YHXI-249-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 ('F325070951031','2025-12-07','0.680','2025-12-07','09:51:03','PLG0026068','700000','700000','5000','705000','705000','input','2025-12-07 09:51:03','F32507095103');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070951031','2025-12-07','09:51:03','FIT','705000','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-251207-0015','D','2025-12-07','09:51:03','input','PENJUALAN','F325070951031','1051155000','705000','1051860000');
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 ('F325071013321','input','1',' MEF3E X HW','TOKO','PM-F','F3E-YEXE-289-0','GL X TIFF SLEP VAR HW 8K ','','1.800','1','100.00','1849000','0','0','15000','1850000','0','0','0','1850000','FIT','00353172','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YEXE-289-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='F3E-YEXE-289-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 ('F325071013321','2025-12-07','1.800','2025-12-07','10:13:32','PLG0026069','1850000','1850000','0','1850000','1850000','input','2025-12-07 10:13:32','F32507101332');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325071013321','2025-12-07','10:13:32','FIT','1850000','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-251207-0016','D','2025-12-07','10:13:32','input','PENJUALAN','F325071013321','1051860000','1850000','1053710000');
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-00017620','X-00017620','CC X MODEL MATA CM 18 8K','GR','---','E2D','BELI','BELI001','677000','2025-12-07','0.900','1','kasir','2025-12-07 10:20:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017620','X-00017620');
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-251207-0001','F325080111361','SIN','1','BELI','BELI001','E2D', 'X-00017620', 'CC X MODEL MATA CM 18 8K','0.900','0.900','100.00','730000','677000','752222','1017000','1','677000','677000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251207-0001','2025-12-07','2025-12-07','10:20:17','SIN','---','0.900','677000','677000','677000','677000','677000','kasir','2025-12-07 10:20:18','FB-251207-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0001','DIAS','PUHPELEM','','','','kasir','2025-12-07 10:20:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0017','K','2025-12-07','10:20:17','kasir','PEMBELIAN UMUM','FB-251207-0001','1053710000','677000','1053033000');
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-00017621','X-00017621','CC COR M 8K','GR','---','E2E','BELI','BELI001','480000','2025-12-07','0.300','1','kasir','2025-12-07 10:21:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017621','X-00017621');
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-251207-0002','F323130230331','FIT','1','BELI','BELI001','E2E', 'X-00017621', 'CC COR M 8K','0.830','0.300','100.00','375000','480000','1600000','1037000','1','480000','480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251207-0002','2025-12-07','2025-12-07','10:21:32','FIT','---','0.300','480000','480000','480000','480000','480000','kasir','2025-12-07 10:21:33','FB-251207-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0002','YANTI','SUMBER','','','','kasir','2025-12-07 10:21:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0018','K','2025-12-07','10:21:32','kasir','PEMBELIAN UMUM','FB-251207-0002','1053033000','480000','1052553000');
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-00017622','X-00017622','CC COR M 8K','GR','---','E2E','BELI','BELI001','555000','2025-12-07','0.850','1','kasir','2025-12-07 10:25:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017622','X-00017622');
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-251207-0003','F323241226571','FIT','1','BELI','BELI001','E2E', 'X-00017622', 'CC COR M 8K','0.850','0.850','100.00','383000','555000','652941','1037000','1','555000','555000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251207-0003','2025-12-07','2025-12-07','10:25:32','FIT','---','0.850','555000','555000','555000','555000','555000','kasir','2025-12-07 10:25:33','FB-251207-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0003','YANTI','SUMBER','','','','kasir','2025-12-07 10:25:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0019','K','2025-12-07','10:25:32','kasir','PEMBELIAN UMUM','FB-251207-0003','1052553000','555000','1051998000');
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-00017623','X-00017623','CC X MODEL MATA VAR CSA 10 17K','GR','---','E2TE','BELI','BELI001','2130000','2025-12-07','1.550','1','kasir','2025-12-07 10:26:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017623','X-00017623');
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-251207-0004','F325020141151','AAT','1','BELI','BELI001','E2TE', 'X-00017623', 'CC X MODEL MATA VAR CSA 10 17K','1.550','1.550','100.00','2170000','2130000','1374194','1875000','1','2130000','2130000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251207-0004','2025-12-07','2025-12-07','10:26:09','AAT','---','1.550','2130000','2130000','2130000','2130000','2130000','kasir','2025-12-07 10:26:09','FB-251207-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0004','IKA','TERBIS KISMANTORO','','','','kasir','2025-12-07 10:26:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0020','K','2025-12-07','10:26:09','kasir','PEMBELIAN UMUM','FB-251207-0004','1051998000','2130000','1049868000');
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-00017624','X-00017624','CC X MODEL SLEP BM CM 8','GR','---','E1TE','BELI','BELI001','2955000','2025-12-07','2.000','1','kasir','2025-12-07 10:27:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00017624','X-00017624');
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-251207-0005','F325020141152','AAT','1','BELI','BELI001','E1TE', 'X-00017624', 'CC X MODEL SLEP BM CM 8','2.000','2.000','100.00','2800000','2955000','1477500','1875000','1','2955000','2955000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-251207-0005','2025-12-07','2025-12-07','10:27:55','AAT','---','2.000','2955000','2955000','2955000','2955000','2955000','kasir','2025-12-07 10:27:56','FB-251207-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0005','IKA','TERBIS KISMANTORO','','','','kasir','2025-12-07 10:27:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0021','K','2025-12-07','10:27:55','kasir','PEMBELIAN UMUM','FB-251207-0005','1049868000','2955000','1046913000');
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-00017625','X-00017625','AT X MODEL MATA UB','GR','---','A1E','BELI','BELI001','590000','2025-12-07','1.030','1','kasir','2025-12-07 10:38:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017625','X-00017625');
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-251207-0006','F322021246182','FIT','1','BELI','BELI001','A1E', 'X-00017625', 'AT X MODEL MATA UB','1.030','1.030','100.00','425000','590000','572816','1037000','1','590000','590000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' 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-251207-0006','2025-12-07','2025-12-07','10:38:29','FIT','---','1.030','590000','590000','590000','590000','590000','kasir','2025-12-07 10:38:30','FB-251207-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0006','SUNDARI','JATISARI BITING','','','','kasir','2025-12-07 10:38:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0022','K','2025-12-07','10:38:29','kasir','PEMBELIAN UMUM','FB-251207-0006','1046913000','590000','1046323000');
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 ('F325071109551','kasir','1',' MEH1 X LT ','TOKO','PM-H','H1E-YKXH-124-0','KL X TRIXIE MATA VAR LT 8K ','','3.050','1','100.00','3132000','0','0','15000','3133000','0','0','0','3133000','SIN','00376907','H1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXH-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='H1E-YKXH-124-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 ('F325071109551','2025-12-07','3.050','2025-12-07','11:09:55','PLG0026070','3133000','3133000','0','3133000','3133000','kasir','2025-12-07 11:09:55','F32507110955');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325071109551','2025-12-07','11:09:55','SIN','3133000','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-251207-0023','D','2025-12-07','11:09:55','kasir','PENJUALAN','F325071109551','1046323000','3133000','1049456000');
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-00017626','X-00017626','CC WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1337000','2025-12-07','1.500','1','kasir','2025-12-07 11:34:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017626','X-00017626');
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-251207-0007','F325090935091','FIT','1','BELI','BELI001','E2D', 'X-00017626', 'CC WEDDING MATA CM 18 8K','1.500','1.500','100.00','1455000','1337000','891333','1017000','1','1337000','1337000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251207-0007','2025-12-07','2025-12-07','11:34:32','FIT','---','1.500','1337000','1337000','1337000','1337000','1337000','kasir','2025-12-07 11:34:33','FB-251207-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0007','ELA','MIRI KISMANTORO','','','','kasir','2025-12-07 11:34:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0024','K','2025-12-07','11:34:32','kasir','PEMBELIAN UMUM','FB-251207-0007','1049456000','1337000','1048119000');
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-00017627','X-00017627','CC X MODEL MATA CM 12 8K','GR','---','E2D','BELI','BELI001','785000','2025-12-07','0.830','1','kasir','2025-12-07 11:35:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017627','X-00017627');
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-251207-0008','F325250908371','FIT','1','BELI','BELI001','E2D', 'X-00017627', 'CC X MODEL MATA CM 12 8K','0.830','0.830','100.00','860000','785000','945783','1017000','1','785000','785000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251207-0008','2025-12-07','2025-12-07','11:35:38','FIT','---','0.830','785000','785000','785000','785000','785000','kasir','2025-12-07 11:35:39','FB-251207-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0008','ANGGIT','SLOGOHIMO','','','088221829071','kasir','2025-12-07 11:35:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0025','K','2025-12-07','11:35:38','kasir','PEMBELIAN UMUM','FB-251207-0008','1048119000','785000','1047334000');
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-00017628','X-00017628','LT MODEL CAT KUPU LG 8K','GR','---','D1E','BELI','BELI001','477000','2025-12-07','0.510','1','kasir','2025-12-07 11:36:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00017628','X-00017628');
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-251207-0009','F325191144301','FIT','1','BELI','BELI001','D1E', 'X-00017628', 'LT MODEL CAT KUPU LG 8K','0.510','0.510','100.00','520000','477000','935294','1037000','1','477000','477000','CUCI');
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 ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-251207-0009','2025-12-07','2025-12-07','11:36:09','FIT','---','0.510','477000','477000','477000','477000','477000','kasir','2025-12-07 11:36:09','FB-251207-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0009','DENA','JERUK','','','','kasir','2025-12-07 11:36:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0026','K','2025-12-07','11:36:09','kasir','PEMBELIAN UMUM','FB-251207-0009','1047334000','477000','1046857000');
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-00017629','X-00017629','KL X NORY ANAK KH 34 8K','GR','---','H1E','BELI','BELI001','1845000','2025-12-07','2.080','1','kasir','2025-12-07 11:37:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017629','X-00017629');
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-251207-0010','F325191144011','FIT','1','BELI','BELI001','H1E', 'X-00017629', 'KL X NORY ANAK KH 34 8K','2.100','2.080','100.00','2143000','1845000','887019','1037000','1','1845000','1845000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.080',berat_beli_asli=berat_beli_asli+'2.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.080',berat_akhir_asli=berat_akhir_asli+'2.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' 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-251207-0010','2025-12-07','2025-12-07','11:37:11','FIT','---','2.080','1845000','1845000','1845000','1845000','1845000','kasir','2025-12-07 11:37:11','FB-251207-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0010','DENA','JERUK','','','','kasir','2025-12-07 11:37:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0027','K','2025-12-07','11:37:11','kasir','PEMBELIAN UMUM','FB-251207-0010','1046857000','1845000','1045012000');
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-00017630','X-00017630','LT MODEL CAT KUDAPONI LG 8K','GR','---','D1E','BELI','BELI001','220000','2025-12-07','0.350','1','kasir','2025-12-07 11:37:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00017630','X-00017630');
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-251207-0011','F325250203232','FIT','1','BELI','BELI001','D1E', 'X-00017630', 'LT MODEL CAT KUDAPONI LG 8K','0.360','0.350','100.00','303000','220000','628571','1037000','1','220000','220000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-251207-0011','2025-12-07','2025-12-07','11:37:54','FIT','---','0.350','220000','220000','220000','220000','220000','kasir','2025-12-07 11:37:55','FB-251207-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0011','DENA','JERUK','','','087757332105','kasir','2025-12-07 11:37:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0028','K','2025-12-07','11:37:54','kasir','PEMBELIAN UMUM','FB-251207-0011','1045012000','220000','1044792000');
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-00017631','X-00017631','CC X BANGKOK SLEP CM 16','GR','---','E1F','BELI','BELI001','407000','2025-12-07','0.610','1','kasir','2025-12-07 11:38:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00017631','X-00017631');
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-251207-0012','F322250254222','FIT','1','BELI','BELI001','E1F', 'X-00017631', 'CC X BANGKOK SLEP CM 16','0.620','0.610','100.00','280000','407000','667213','1057000','1','407000','407000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-07' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-251207-0012','2025-12-07','2025-12-07','11:38:34','FIT','---','0.610','407000','407000','407000','407000','407000','kasir','2025-12-07 11:38:35','FB-251207-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251207-0012','SRI','NGANDONG','','','','kasir','2025-12-07 11:38:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-07' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251207-0029','K','2025-12-07','11:38:34','kasir','PEMBELIAN UMUM','FB-251207-0012','1044792000','407000','1044385000');
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 ('F325071204011','kasir','1',' MDE1 CM 16','TOKO','PM-E','E1D-YKAI-200-0','CC MODEL SLEP VAR CM 16 8K ','','1.330','1','100.00','1339000','0','0','15000','1340000','0','0','0','1340000','SIN','00378121','E1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAI-200-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E1D-YKAI-200-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 ('F325071204011','2025-12-07','1.330','2025-12-07','12:04:02','PLG0026071','1340000','1340000','0','1340000','1340000','kasir','2025-12-07 12:04:01','F32507120401');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325071204011','2025-12-07','12:04:02','SIN','1340000','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-251207-0030','D','2025-12-07','12:04:02','kasir','PENJUALAN','F325071204011','1044385000','1340000','1045725000');
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 ('F325070104381','kasir','1',' MEH1 KH 42','TOKO','PM-H','H1E-YKBB-24-0','KL NORY KH 42 8K ','','2.100','1','100.00','2157000','0','0','15000','2158000','0','0','0','2158000','FIT','00378173','H1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBB-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='H1E-YKBB-24-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 ('F325070104381','2025-12-07','2.100','2025-12-07','13:04:38','PLG0026072','2158000','2158000','0','2158000','2158000','kasir','2025-12-07 13:04:38','F32507010438');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070104381','2025-12-07','13:04:38','FIT','2158000','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-251207-0031','D','2025-12-07','13:04:38','kasir','PENJUALAN','F325070104381','1045725000','2158000','1047883000');
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 ('F325070142551','kasir','1',' MFF3F UB ','TOKO','PM-F','F3F-YJAF-37-T','GL KOREA UB 8K ','','0.460','1','100.00','482000','0','0','15000','483000','0','0','0','483000','FIT','T0074163','F3F','0','0','-','0','1057000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJAF-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='F3F-YJAF-37-T' 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 ('F325070142551','2025-12-07','0.460','2025-12-07','13:42:56','PLG0026073','483000','483000','0','483000','483000','kasir','2025-12-07 13:42:55','F32507014255');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070142551','2025-12-07','13:42:56','FIT','483000','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-251207-0032','D','2025-12-07','13:42:56','kasir','PENJUALAN','F325070142551','1047883000','483000','1048366000');
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 ('F325070239051','input','1',' MDE1 CM 12','TOKO','PM-E','E1D-YJCX-86-0','CC WEDDING POLOS CM 12 8K ','','1.020','1','100.00','1027000','0','0','15000','1028000','0','0','0','1028000','SIN','00375298','E1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJCX-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='E1D-YJCX-86-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 ('F325070239051','2025-12-07','1.020','2025-12-07','14:39:05','PLG0026074','1028000','1028000','0','1028000','1028000','input','2025-12-07 14:39:05','F32507023905');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070239051','2025-12-07','14:39:05','SIN','1028000','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-251207-0033','D','2025-12-07','14:39:05','input','PENJUALAN','F325070239051','1048366000','1028000','1049394000');
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 ('F325070239341','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-YIAC-8-0','CC X VELG POLOS CM 18 8K ','','1.000','1','100.00','1007000','0','0','15000','1007000','0','0','0','1007000','SIN','00369092','E1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIAC-8-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='2025-12-07' AND kode_barang='E1D-YIAC-8-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 ('F325070239341','2025-12-07','1.000','2025-12-07','14:39:34','PLG0026075','1007000','1007000','0','1007000','1007000','input','2025-12-07 14:39:34','F32507023934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070239341','2025-12-07','14:39:34','SIN','1007000','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-251207-0034','D','2025-12-07','14:39:34','input','PENJUALAN','F325070239341','1049394000','1007000','1050401000');
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 ('F325070245221','input','1',' MEB1 X HK ','TOKO','PM-B','B1E-YKXA-116-0','GW X MODEL TAUGE MATA HK 8K ','','0.400','1','100.00','411000','0','0','15000','410000','0','0','0','410000','FIT','00375686','B1E','0','0','-','1','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXA-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-12-07' AND kode_barang='B1E-YKXA-116-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 ('F325070245221','2025-12-07','0.400','2025-12-07','14:45:22','PLG0026076','410000','410000','0','410000','410000','input','2025-12-07 14:45:22','F32507024522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-07','F325070245221','2025-12-07','14:45:22','FIT','410000','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-251207-0035','D','2025-12-07','14:45:22','input','PENJUALAN','F325070245221','1050401000','410000','1050811000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251207-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251207-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070104381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070104381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070104381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070142551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070142551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070142551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070239051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070239051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070239051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070239341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070239341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070239341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070245221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070245221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070245221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070800031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070800031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070800031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070856291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070856291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070856291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070857101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070857101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070857101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070903181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070903181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070903181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070911091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070911091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070911091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070915241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070915241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070915241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070920331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070920331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070920331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070920591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070920591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070920591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070930571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070930571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070930571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070936111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070936111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070936111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070938331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070938331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070938331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070939191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070939191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070939191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070941491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070941491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325070951031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325070951031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325070951031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071013321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071013321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071013321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071109551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071109551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071109551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325071204011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325071204011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325071204011';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-07';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251208-0001','D','2025-12-08','15:13:00','SYSTEM','SALDO AWAL','SALDO AWAL','0','1050811000','1050811000');
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-251208-0001','D','2025-12-08','15:13:00','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-251208-0001','D','2025-12-08','15:13:00','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-251208-0001','D','2025-12-08','15:13:00','BCA','SALDO AWAL','SALDO AWAL','0','694074000','694074000');
UPDATE tp_system SET tgl_system='2025-12-08';