| | |
| | | } |
| | | |
| | | /** |
| | | * @description 获取下拉搜索查询sql |
| | | * @description 获取下拉搜索查询条件 |
| | | * @return {String} item 搜索条件信息 |
| | | */ |
| | | static getSelectQuerySql (item) { |
| | | static getSelectQueryOptions (item) { |
| | | let arrfield = [item.valueField, item.valueText] |
| | | |
| | | if (item.type === 'link') { |
| | | arrfield.push(item.linkField) |
| | | } else if (item.type === 'select' && item.linkSubField && item.linkSubField.length > 0) { |
| | | arrfield.push(...item.linkSubField) |
| | | } |
| | | |
| | | arrfield = Array.from(new Set(arrfield)) |
| | | |
| | | let _datasource = item.dataSource |
| | | let sql = '' |
| | | let _field = item.valueField + ',' + item.valueText |
| | | |
| | | if (item.valueField === item.valueText) { |
| | | _field = item.valueField |
| | | } |
| | | |
| | | if (/\s/.test(_datasource)) { // 拼接别名 |
| | | _datasource = '(' + _datasource + ') tb' |
| | | } |
| | | |
| | | if (item.type === 'link') { |
| | | sql = 'select ' + _field + ',' + item.linkField + ' from ' + _datasource |
| | | } else { |
| | | let _linkSubField = '' // 下拉菜单关联表单 |
| | | if (item.linkSubField && item.linkSubField.length > 0) { |
| | | _linkSubField = ',' + item.linkSubField.join(',') |
| | | } |
| | | sql = 'select ' + _field + _linkSubField + ' from ' + _datasource |
| | | } |
| | | arrfield = arrfield.join(',') |
| | | |
| | | if (item.orderBy) { |
| | | sql = sql + ' order by ' + item.orderBy + ' ' + item.orderType |
| | | sql = 'select distinct ' + arrfield + ',' + item.orderBy + ' as orderfield from ' + _datasource + ' order by orderfield ' + item.orderType |
| | | } else { |
| | | sql = 'select distinct ' + arrfield + ' from ' + _datasource |
| | | } |
| | | |
| | | return sql |
| | | return { |
| | | sql: sql, |
| | | field: arrfield |
| | | } |
| | | } |
| | | |
| | | /** |