| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394 |
- import React from 'react'
- import { Form, Input, Button, Select, Table, Checkbox, Icon, Tooltip, Row } from 'antd'
- import { connect } from 'dva'
- import COLUMN_TYPE from './columnType.json'
- import { Resizable } from 'react-resizable'
- import './columnConfig.less'
- const FormItem = Form.Item
- const SelectOption = Select.Option
- const ResizeableTitle = (props) => {
- const { onResize, width, ...restProps } = props;
- if (!width) {
- return <th {...restProps} />;
- }
- return (
- <Resizable width={width} height={0} onResize={onResize}>
- <th {...restProps} />
- </Resizable>
- );
- };
- class DataSourceColumnConfig extends React.Component {
- constructor(props) {
- super(props);
- this.state = {
- widths: [ 80, 300, 200, 100, 100 ],
- visibleConfirm: false,
- }
- }
- components = {
- header: {
- cell: ResizeableTitle,
- },
- };
- handleVisibleChange = (visible) => {
- const { columns } = this.props.dataSourceDetail;
- this.setState({ visibleConfirm: visible && (columns && columns.length > 0) });
- }
- handleResize = index => (e, { size }) => {
- this.setState(({ widths }) => {
- const nextWidths = [...widths];
- nextWidths[index] = size.width;
- return { widths: nextWidths };
- });
- };
- render() {
- const { dataSourceDetail, dispatch, fetching } = this.props;
- const { widths } = this.state;
- const columns = [{
- title: <div><Checkbox
- style={{ margin: '0 8px 0 0', display: dataSourceDetail.columns ? (dataSourceDetail.columns.length > 0 ? 'inline-block' : 'none') : 'none'}}
- indeterminate={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.using).length > 0 && dataSourceDetail.columns.filter(c => c.using).length < dataSourceDetail.columns.length) : false}
- checked={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.using).length === dataSourceDetail.columns.length) : false}
- onChange={(e) => {
- let target = e.target;
- let columns = dataSourceDetail.columns ? dataSourceDetail.columns.map(c => {
- c.using = target.checked;
- return c;
- }) : [];
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- />启用</div>,
- dataIndex: 'using',
- key: 'using',
- width: widths[0],
- render: (v, r) => <Checkbox
- dataKey={r.key}
- onChange={(e) => {
- let target = e.target;
- let key = target.dataKey;
- let columns = dataSourceDetail.columns.map(c => {
- if(c.key === key) {
- c.using = target.checked;
- }
- return c;
- });
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- checked={v}
- />
- }, {
- title: '列名',
- dataIndex: 'name',
- key: 'name',
- width: widths[1],
- // }, {
- // title: '备注',
- // dataIndex: 'description',
- // key: 'description',
- // width: widths[2],
- // }, {
- // title: '数据类型',
- // dataIndex: 'dataType',
- // key: 'dataType',
- // width: widths[3]
- }, {
- title: '分析类型',
- dataIndex: 'columnType',
- key: 'columnType',
- width: widths[2],
- render: (text, record) => {
- return (
- <Select
- style={{ width: '100%' }}
- value={text}
- onChange={(value) => {
- let columns = dataSourceDetail.columns.map(c => {
- if(c.key === record.key) {
- c.columnType = value;
- c.groupable = c.columnType === 'categorical';
- c.bucketizable = ['time', 'scale', 'ordinal'].indexOf(record.columnType) !== -1;
- }
- return c;
- });
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- >
- {
- COLUMN_TYPE.map( c => {
- let dataType = record.dataType;
- if(c.dataType.indexOf(dataType) !== -1) {
- return <SelectOption value={c.columnType} key={c.columnType}>{c.label}</SelectOption>
- }else {
- return null
- }
-
- }).filter((s)=>s!==null)
- }
- </Select>
- )
- }
- }, {
- title: <div><Checkbox
- style={{ margin: '0 8px 0 0', display: dataSourceDetail.columns ? (dataSourceDetail.columns.length > 0 ? 'inline-block' : 'none') : 'none'}}
- indeterminate={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.groupable).length > 0 && dataSourceDetail.columns.filter(c => c.groupable).length < dataSourceDetail.columns.length) : false}
- checked={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.groupable).length === dataSourceDetail.columns.length) : false}
- onChange={(e) => {
- let target = e.target;
- let columns = dataSourceDetail.columns ? dataSourceDetail.columns.map(c => {
- c.groupable = target.checked;
- return c;
- }) : [];
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- />允许分组</div>,
- dataIndex: 'groupable',
- key: 'groupable',
- width: widths[3],
- render: (v, r) => <Checkbox
- dataKey={r.key}
- onChange={(e) => {
- let target = e.target;
- let key = target.dataKey;
- let columns = dataSourceDetail.columns.map(c => {
- if(c.key === key) {
- c.groupable = target.checked;
- }
- return c;
- });
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- checked={v}
- />
- }, {
- title: <div><Checkbox
- style={{ margin: '0 8px 0 0', display: dataSourceDetail.columns ? (dataSourceDetail.columns.length > 0 ? 'inline-block' : 'none') : 'none'}}
- indeterminate={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.filterable).length > 0 && dataSourceDetail.columns.filter(c => c.filterable).length < dataSourceDetail.columns.length) : false}
- checked={dataSourceDetail.columns ? (dataSourceDetail.columns.filter(c => c.filterable).length === dataSourceDetail.columns.length) : false}
- onChange={(e) => {
- let target = e.target;
- let columns = dataSourceDetail.columns ? dataSourceDetail.columns.map(c => {
- c.filterable = target.checked;
- return c;
- }) : [];
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- />允许过滤</div>,
- dataIndex: 'filterable',
- key: 'filterable',
- width: widths[4],
- render: (v, r) => <Checkbox
- dataKey={r.key}
- onChange={(e) => {
- let target = e.target;
- let key = target.dataKey;
- let columns = dataSourceDetail.columns.map(c => {
- if(c.key === key) {
- c.filterable = target.checked;
- }
- return c;
- });
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- checked={v}
- />
- // }, {
- // title: '允许分组',
- // dataIndex: 'groupable',
- // key: 'groupable',
- // width: 50,
- // className: 'column-groupable',
- // render: (value, record) => <Switch disabled={record.columnType!=='categorical'} checked={value} onChange={(checked) => {
- // let columns = dataSourceDetail.columns.map(c => {
- // if(c.key === record.key) {
- // c.groupable = checked;
- // }
- // return c;
- // });
- // dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- // }}/>
- // }, {
- // title: '允许分段',
- // dataIndex: 'bucketizable',
- // key: 'bucketizable',
- // width: 50,
- // className: 'column-bucketizable',
- // render: (value, record) => <Switch
- // disabled={['time', 'scale', 'ordinal'].indexOf(record.columnType)===-1}
- // checked={value}
- // defaultChecked={true}
- // onChange={(checked) => {
- // let columns = dataSourceDetail.columns.map(c => {
- // if(c.key === record.key) {
- // c.bucketizable = checked;
- // }
- // return c;
- // });
- // dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- // }}
- // />
- }, {
- title: '别名',
- dataIndex: 'alias',
- key: 'alias',
- // width: widths[5],
- render: (text, record) => {
- return(
- <Input
- key={text}
- defaultValue={text}
- placeholder={record.description ? record.description.substring(0, 10) : record.name}
- onBlur={(e) => {
- const value = e.target.value;
- let columns = dataSourceDetail.columns.map(c => {
- if(c.key === record.key) {
- c['alias'] = value;
- }
- return c;
- });
-
- dispatch({ type: 'dataSourceDetail/setField', name: 'columns', value: columns });
- }}
- >
- </Input>
- )
- }
- // }, {
- // title: '允许过滤',
- // dataIndex: 'filterable',
- // key: 'filterable',
- // render: (value, record) => <Switch />
- }].map((col, index) => ({
- ...col,
- onHeaderCell: column => ({
- width: column.width,
- onResize: this.handleResize(index),
- }),
- }));
- return (
- <div className='column-config'>
- {
- dataSourceDetail.type==='database'?(
- <div className='sql-area'>
- <Row className='divider'>数据对象</Row>
- <Form size='small'>
- <FormItem className='textarea-target'>
- <Input.TextArea
- disabled={!dataSourceDetail.address}
- placeholder={dataSourceDetail.address ? '输入表名或查询SQL,注意不能以分号结尾' : '请先返回上一步选择数据库连接'}
- autosize={{ minRows: 3 }}
- // value={dataSourceDetail.target}
- defaultValue={dataSourceDetail.target}
- onBlur={(e) => {
- if(e.target.value !== dataSourceDetail.target) {
- dispatch({ type: 'dataSourceDetail/setFields', fields: [
- { name: 'target', value: e.target.value },
- { name: 'notice', value: '' },
- { name: 'targetDirty', value: true }
- ] });
- }
- }}
- // onChange={(e) => {
- // dispatch({ type: 'dataSourceDetail/setFields', fields: [
- // { name: 'target', value: e.target.value },
- // { name: 'notice', value: '' }
- // ] });
- // }}
- />
- </FormItem>
- <div className='buttons'>
- <div className='errormessage'>{dataSourceDetail.notice}</div>
- <Tooltip
- title={
- <div>
- <div className="ant-popover-message">
- <Icon type="exclamation-circle" theme="filled" style={{ color: '#faad14' }} />
- <div className="ant-popover-message-title">已存在列数据,确定要覆盖吗?</div>
- </div>
- <div className="ant-popover-buttons">
- <button type="button" className="ant-btn ant-btn-sm" onClick={() => {
- this.setState({
- visibleConfirm: false
- });
- }}>
- <span>取 消</span>
- </button>
- <button type="button" className="ant-btn ant-btn-primary ant-btn-sm" onClick={() => {
- this.setState({
- visibleConfirm: false
- });
- dispatch({ type: 'dataSourceDetail/importColumns', cover: true });
- }}>
- <span>全部覆盖</span>
- </button>
- <button type="button" className="ant-btn ant-btn-primary ant-btn-sm" onClick={() => {
- this.setState({
- visibleConfirm: false
- });
- dispatch({ type: 'dataSourceDetail/importColumns', cover: false });
- }}>
- <span>保留重复</span>
- </button>
- </div>
- </div>
- }
- visible={this.state.visibleConfirm}
- onVisibleChange={this.handleVisibleChange}
- trigger='click'
- >
- <Button type={!fetching && dataSourceDetail.targetDirty ? 'danger' : null} disabled={!dataSourceDetail.address || fetching} onClick={() => {
- if(!dataSourceDetail.columns || dataSourceDetail.columns.length === 0) {
- dispatch({ type: 'dataSourceDetail/importColumns', cover: true });
- }
- }}>
- {fetching && <Icon type="loading" theme="outlined" />}
- {!fetching && dataSourceDetail.targetDirty ? '重新获取数据列' : '获取数据列'}
- </Button>
- </Tooltip>
- </div>
- </Form>
- <Row className='divider'>数据列</Row>
- </div>
- ):null
- }
- <Table
- className='table-columnconfig'
- bordered
- components={this.components}
- dataSource={dataSourceDetail.columns}
- columns={columns}
- locale={{
- emptyText: '未连接到数据对象'
- }}
- />
- </div>
- );
- }
- }
- function mapStateToProps({ present: { dataSourceDetail, loading } }) {
- const fetching = loading.effects['dataSourceDetail/importColumns'];
- return {
- fetching,
- dataSourceDetail
- }
- }
- export default connect(mapStateToProps)(DataSourceColumnConfig);
|