<div>{{row.inquiry_details | concatFilter('assessment_all_value')}}</div>解释一下这段vue的语法
时间: 2024-06-02 19:08:12 浏览: 5
这段 Vue 代码中,{{}} 表示插值语法,用于将表达式的结果渲染到模板中。row 是一个数据对象,inquiry_details 是其中一个属性。concatFilter 是一个过滤器,用于将 inquiry_details 属性的值进行处理后返回。这里的 'assessment_all_value' 是 concatFilter 的参数,表示要进行拼接的字符串。整个代码的作用是将 inquiry_details 属性的值与 'assessment_all_value' 拼接后渲染到模板中的 div 元素中。
相关问题
使用uniapp框架,从一个list 数组, list每一项字段为inquiry_id, inqruiy_details=>{[0]:{'inquiry_detail'=>111,'assetment_all_value'=>1000}},通过搜索inquiry_id,定位到该条数据
可以使用uniapp提供的数组方法`find`来实现,具体代码如下:
```javascript
let list = [
{ inquiry_id: 1, inquiry_details: [{ inquiry_detail: 111, assessment_all_value: 1000 }] },
{ inquiry_id: 2, inquiry_details: [{ inquiry_detail: 222, assessment_all_value: 2000 }] },
{ inquiry_id: 3, inquiry_details: [{ inquiry_detail: 333, assessment_all_value: 3000 }] }
];
let inquiryId = 2; // 假设要搜索的inquiry_id为2
let targetData = list.find(item => item.inquiry_id === inquiryId);
console.log(targetData);
```
其中,`find`方法会返回数组中满足条件的第一项数据,如果找不到则返回`undefined`。上述代码会输出:
```
{ inquiry_id: 2, inquiry_details: [{ inquiry_detail: 222, assessment_all_value: 2000 }] }
```
如果要获取该条数据的`inquiry_details`字段,可以继续使用数组索引,例如:
```javascript
let inquiryDetails = targetData.inquiry_details[0];
console.log(inquiryDetails);
```
会输出:
```
{ inquiry_detail: 222, assessment_all_value: 2000 }
```
" SELECT `a`.`id`,`a`.`inquiry_no`,`a`.`type`,`a`.`is_multi`,`a`.`status`,`a`.`bank_name`,`a`.`sub_bank_name`,`a`.`branch_bank_name`,`a`.`customer_name`,`a`.`create_time`,`a`.`buss_username`,`a`.`estimate_no`,`a`.`evaluate_purpose`,`a`.`time_length`,a.business_no AS business_no,b.id as did,`b`.`inquiry_id`,`b`.`city`,`b`.`city_id`,`b`.`full_estate_name`,`b`.`size`,b.usage AS usage,`b`.`register_price`,`d`.`inquiry_detail`,d.appraiser_name AS response_username,`d`.`appraiser_id`,`d`.`appraise_level`,d.create_time AS response_time,`d`.`assessment_price`,`d`.`assessment_all_value`,`d`.`assessment_net_worth`,`d`.`assessment_net_worth_tow`,`d`.`total_tax1`,`d`.`total_tax2`,`d`.`internal_remarks`,d.id AS rid FROM `pg_inquiry` `a` LEFT JOIN `pg_inquiry_detail` `b` ON `b`.`inquiry_id`=`a`.`id` LEFT JOIN `pg_return_price` `d` ON `b`.`id`=`d`.`inquiry_detail` WHERE `a`.`status` > 0 AND `a`.`create_time` BETWEEN '2023-03-02 00:00:00' AND '2023-05-31 23:59:59' AND `is_simple` = 0 AND `is_automatic` = 0 ORDER BY `a`.`create_time` DESC,`d`.`create_time` DESC "报错:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, business_no, buss_username, ' at line 13,解决方法是什么
看起来 SQL 查询语句中有一个问题,'usage' 是 MySQL 中的保留关键字,不能用作列名。为了解决这个问题,可以将 'usage' 重命名为其他名称,例如 'property_usage'。修改后的 SQL 查询语句如下:
SELECT `a`.`id`,`a`.`inquiry_no`,`a`.`type`,`a`.`is_multi`,`a`.`status`,`a`.`bank_name`,`a`.`sub_bank_name`,`a`.`branch_bank_name`,`a`.`customer_name`,`a`.`create_time`,`a`.`buss_username`,`a`.`estimate_no`,`a`.`evaluate_purpose`,`a`.`time_length`,a.business_no AS business_no,b.id as did,`b`.`inquiry_id`,`b`.`city`,`b`.`city_id`,`b`.`full_estate_name`,`b`.`size`,`b`.`property_usage`,`b`.`register_price`,`d`.`inquiry_detail`,d.appraiser_name AS response_username,`d`.`appraiser_id`,`d`.`appraise_level`,d.create_time AS response_time,`d`.`assessment_price`,`d`.`assessment_all_value`,`d`.`assessment_net_worth`,`d`.`assessment_net_worth_tow`,`d`.`total_tax1`,`d`.`total_tax2`,`d`.`internal_remarks`,d.id AS rid FROM `pg_inquiry` `a` LEFT JOIN `pg_inquiry_detail` `b` ON `b`.`inquiry_id`=`a`.`id` LEFT JOIN `pg_return_price` `d` ON `b`.`id`=`d`.`inquiry_detail` WHERE `a`.`status` > 0 AND `a`.`create_time` BETWEEN '2023-03-02 00:00:00' AND '2023-05-31 23:59:59' AND `is_simple` = 0 AND `is_automatic` = 0 ORDER BY `a`.`create_time` DESC,`d`.`create_time` DESC
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)