import * as React from 'react'; import Box from "@mui/material/Box"; import 'handsontable/dist/handsontable.full.min.css'; //import 'handsontable/styles/ht-theme-main.min.css'; import { HandsonTable } from 'handsontable/base'; import {HotTable} from "@handsontable/react"; //import { registerAllModules } from 'handsontable/registry'; import {RichTreeView } from "@mui/x-tree-view/RichTreeView"; import { Grid } from '@mui/material'; import Tab from "@mui/material/Tab"; import TabContext from "@mui/lab/TabContext"; import TabList from "@mui/lab/TabList"; import TabPanel from "@mui/lab/TabPanel"; import Stack from "@mui/material/Stack"; //import { registerPlugin, NestedRows } from 'handsontable/plugins'; //registerPlugin(NestedRows); import Service from './Service'; import {TabulatorFull as Tabulator} from "tabulator-tables"; //import Tabulator library import "tabulator-tables/dist/css/tabulator.min.css"; //import Tabulator stylesheet import './Tabulator.css'; import { DataGrid } from '@mui/x-data-grid'; import {extractFuzhu, match_target} from './utils'; import Button from '@mui/material/Button'; import {shanchu_djcs, undo_djcs, redo_djcs, danxiangdinge_djcs, updateDercj_djcs, changguidinge_djcs, handleBeizhu_djcs, huan, updateShuliang_djcs} from './editor'; import { textRenderer, registerRenderer } from 'handsontable/renderers'; import { Table, ConfigProvider, Button as AButton } from "antd"; import zhCN from 'antd/locale/zh_CN'; function number_equal(a, b) { if (Number(a) - Number(b) < 0.0001 && Number(a) - Number(b) > -0.0001) { return true; } return false; } export default function Djcs2({name, bh, rgde, jxde, clde, beizhu, beizhuFK, clickCallback, loadingCallback, dingeclick}) { const lastClickRef = React.useRef(null); const afterOnCellMouseDown = (event, coord, TD) => { if (lastClickRef.current == null) { lastClickRef.current = Date.now(); } else { let origin = lastClickRef.current; lastClickRef.current = Date.now(); let delta = lastClickRef.current - origin; if (delta < 300 && coord.col == 1 && coord.row > 0 && !isQdrcj.current){//300 ms -> 换 //tihuanCallback(coord.row, coord.col); } } }; var editCheck = function(cell){ //cell - the cell component for the editable cell //get row data //console.log(cell); if(cell._cell.row.data['序号']) return false; return true; } function handleSelect(row){ //e - the click event object //cell - cell component console.log('rowSelected'); selectedRowKeysTable.current = [row._row['data']['key']]; let bt = "Djcs" ; if (row._row.data['序号'] != null && row._row.data['序号'].length >0) { selectedRowKeysTableParent.current = row._row['data']['key']; setFuzhu([]); Service.generateQingdanrcj(name, bh,bt,row._row.data['清单编码']).then(x=>{ setRcjhl(x); isQdrcj.current=true; highlight.current = []; }); Service.generateQingdanTuijian(name, bh,bt,row._row.data['清单编码']).then(x=>{ setTuijian(x); }); } else { let row_parent = row._row; while(row_parent.modules.dataTree.parent) { row_parent = row_parent.modules.dataTree.parent; } debmRef.current = row._row['data']['清单编码']; selectedRowKeysTableParent.current = row_parent['data']['key']; clickCallback(row_parent['data']['清单编码'], row._row['data']['清单编码']); Service.generateDingercj(name, bh,bt,row_parent['data']['清单编码'], row._row['data']['清单编码']).then(x=>{ setRcjhl(x[0]); isQdrcj.current = false; setFuzhuEnable(x[1]); let toHighlight = []; for(let i = 1; i < x[0].length; i++) { let entry = x[0][i]; let bianhao = entry[1]; let rcjlb = entry[8]; if (Number(rcjlb) == 1 && rgdeRef.current ) { for (let j = 0;j < rgdeRef.current.length; j++) { if (rgdeRef.current[j]["CLBH"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , rgdeRef.current[j]["YSJG"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5, }); } let hanliang = Number(entry[10]); if (!number_equal(hanliang , rgdeRef.current[j]["gr"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10, }); } } } } if (Number(rcjlb) == 3 && jxdeRef.current ) { for (let j = 0; j < jxdeRef.current.length; j++) { if (jxdeRef.current[j]["jxbh"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , jxdeRef.current[j]["tbdj"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5, }); } let hanliang = Number(entry[10]); if (!number_equal(hanliang , jxdeRef.current[j]["sl"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10, }); } } } } if (Number(rcjlb) == 2 && cldeRef.current ) { for (let j = 0; j < cldeRef.current.length; j++) { if (cldeRef.current[j]["CLBH"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , cldeRef.current[j]["YSJG"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5, }); } let hanliang = Number(entry[10]); if (!number_equal(hanliang , cldeRef.current[j]["SL"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10, }); } } } } } highlight.current = toHighlight; }); } } registerRenderer('customStylesRenderer', (hotInstance, TD, row, column, prop, value, ...rest) => { let newValue = value; if ((column == 10 || column == 11 || column == 5) && row > 0) { newValue = Number(value).toFixed(2).toString(); } textRenderer(hotInstance, TD, row, column, prop, newValue, ...rest); for (let i = 0; i < highlight.current.length; i++) { let entry = highlight.current[i]; if (entry.row == row && entry.col == column) { TD.style.fontWeight = 'bold'; TD.style.color = 'green'; TD.style.background = '#d7f1e1'; } } }); const [detail, setDetail] = React.useState([ ]); const hotRcjRef = React.useRef(null); const myRef = React.useRef(null); const myTable = React.useRef(null); const [value, setValue] = React.useState("1"); const [rcjhl, setRcjhl] = React.useState([]); const [rcjhl2, setRcjhl2] = React.useState([]); const [fuzhu, setFuzhu] = React.useState([]); const [tuijian, setTuijian] = React.useState([]); const beizhuFKRef = React.useRef(null); const [fuzhuEnable, setFuzhuEnable] = React.useState(false); const [selectedRowKeys, setSelectedRowKeys] = React.useState([]); const onSelectChange = (newSelectedRowKeys) => { console.log('selectedRowKeys changed: ', newSelectedRowKeys); setSelectedRowKeys(newSelectedRowKeys); const [newData, newHl] = handleBeizhu_djcs(beizhuFKRef.current, selectedRowKeysTable.current[0], newSelectedRowKeys, fuzhu); if (newData) { myTable.current.updateData(newData.filter(x=>x['key'] == selectedRowKeysTableParent.current)); setRcjhl(newHl); } }; const rowSelection = { selectedRowKeys, onChange: onSelectChange, getCheckboxProps: (record) => { return { disabled: !fuzhuEnable }; } }; const highlight = React.useRef([]); const rgdeRef = React.useRef(null); const jxdeRef = React.useRef(null); const cldeRef = React.useRef(null); const isQdrcj = React.useRef(false); const debmRef = React.useRef(null); const selectedRowKeysTable = React.useRef([]); const selectedRowKeysTableParent = React.useRef(null); const afterChange = (changes, source) => { if (changes == null || changes.every(x=>x[2] == x[3])) { } else { let data = hotRcjRef.current?.hotInstance?.getData(); for(let i = 1; i < data.length; i++) { data[i][11] = Number(data[i][10]) * Number(data[i][5]); } setRcjhl(data); let newData = updateDercj_djcs(selectedRowKeysTable.current[0], data); myTable.current.updateData(newData.filter(x=>x['key'] == selectedRowKeysTableParent.current)).then(function() { let getRow = myTable.current.getSelectedRows(); //get array of currently selected row components. //getRow[0].select(); handleSelect(getRow[0]); }); } }; React.useEffect(() => { myTable.current = new Tabulator(myRef.current, { index: "key", height: 380, data: detail, //link data to table reactiveData: false, //enable data reactivity dataTreeStartExpanded:true, dataTree: true, selectableRows:1, //make rows selectable editTriggerEvent:"dblclick", //trigger edit on double click dataTreeStartExpanded:function(row, level){ //console.log(row); //console.log(level); return true; //expand rows where the "driver" data field is true; }, columns: [ //Define Table Columns {title:"序号", field:"序号", width:80, headerSort:false, frozen: true}, //never hide this column {title:"清单编码", field:"清单编码", width:120,headerSort:false, frozen: true }, {title:"名称", field:"名称", width:150, headerSort:false, formatter:"textarea"}, //hide this column first {title:"项目特征", field:"项目特征", width:150 , headerSort:false, formatter:"textarea"}, {title:"计算规则", field:"计算规则", width:150, headerSort:false, formatter:"textarea"}, {title:"单位", field:"单位", width:100, headerSort:false}, {title:"数量", field:"数量", width:100, headerSort:false, editor: "input", editable: editCheck }, {title:"综合单价", field:"综合单价", width:100, headerSort:false, formatter:"money"}, {title:"合价", field:"合价", width:100, headerSort:false, formatter:"money"}, {title:"人工费", field:"人工费", width:100, headerSort:false, formatter:"money"}, {title:"主材费", field:"主材费", width:100, headerSort:false, formatter:"money"}, {title:"设备费", field:"设备费", width:100, headerSort:false, formatter:"money"}, {title:"辅材费", field:"辅材费", width:100, headerSort:false, formatter:"money"}, {title:"材料费", field:"材料费", width:100, headerSort:false, formatter:"money"}, {title:"机械费", field:"机械费", width:100, headerSort:false, formatter:"money"}, {title:"管理费", field:"管理费", width:100, headerSort:false, formatter:"money"}, {title:"利润", field:"利润", width:100, headerSort:false, formatter:"money"}, {title:"暂估价", field:"暂估价", width:100, headerSort:false, formatter:"money"}, {title:"综合人工工日", field:"综合人工工日", width:100, headerSort:false}, ] }); myTable.current.on("cellDblClick", function(e, cell){ //e - the click event object //cell - cell component console.log(cell); }); myTable.current.on("rowSelected", handleSelect); myTable.current.on("cellEdited", function(cell){ //console.log("edited"); //console.log(); let key = cell._cell.row.data['key']; myTable.current.deselectRow(); let [success, data] = updateShuliang_djcs(cell._cell.row.data['数量'], selectedRowKeysTable.current[0]); if (success) { myTable.current.updateData(data.filter(x=>x['key'] == selectedRowKeysTableParent.current)).then(function() { let getRow = myTable.current.getRows(); //get array of currently selected row components. let component = null; for(let i = 0; i < getRow.length; i++) { let entry = getRow[i]._row.modules.dataTree.children; for(let j = 0; j < entry.length; j++) { let child = entry[j]; if(child.data['key'] == key) { //console.log(child); component = child.component; break; } } } component.select(); handleSelect(component); //handleSelect(getRow[0]); }); } }); myTable.current.on("tableBuilt", () => { Service.generateDjcs(name, bh).then(x=>{ myTable.current.replaceData(x); }); }); }, [bh]); React.useEffect( () => { beizhuFKRef.current = beizhuFK; }, [beizhuFK] ); React.useEffect( () => { console.log(beizhu); let result = []; if (beizhu != null) { let keys = Object.keys(beizhu["BZBH"]); for(let i = 0; i < keys.length; i++) { let key = keys[i]; result.push({'key': i+1, '序号': i+1, '编号': beizhu["BZBH"][key], '说明': beizhu["SM"][key]});//序号很重要 } setFuzhu(result); let newSelect = extractFuzhu(debmRef.current); setSelectedRowKeys(newSelect); //setSelectedRowKeys([1]); } }, [beizhu] ); React.useEffect( () => { myTable.current.deselectRow(); //console.log(dingeclick); if (selectedRowKeysTable.current.length > 0 ) { const [success, data, key] = changguidinge_djcs(JSON.parse(dingeclick), selectedRowKeysTable.current[0]); if (success) { myTable.current.updateData(data.filter(x=>x['key'] == selectedRowKeysTableParent.current)).then(function(){ let getRow = myTable.current.getRows(); //get array of currently selected row components. let component = null; for(let i = 0; i < getRow.length; i++) { let entry = getRow[i]._row.modules.dataTree.children; for(let j = 0; j < entry.length; j++) { let child = entry[j]; if(child.data['key'] == key) { //console.log(child); component = child.component; break; } } } component.select(); handleSelect(component); }); } } }, [dingeclick]//常规添加定额 ); React.useEffect( () => { console.log("rgde changed"); console.log(rgde); rgdeRef.current = rgde; jxdeRef.current = jxde; cldeRef.current = clde; if (isQdrcj.current) { highlight.current = []; } else { let toHighlight = []; for(let i = 1; i < rcjhl.length; i++) { let entry = rcjhl[i]; let bianhao = entry[1]; let rcjlb = entry[8]; if (Number(rcjlb) == Number(1) && rgde) { for (let j = 0; j < rgde.length; j++) { if (rgde[j]["CLBH"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , rgde[j]["YSJG"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5}); } let hanliang = Number(entry[10]); if (!number_equal(hanliang , rgde[j]["gr"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10}); } } } } if (Number(rcjlb) == Number(3) && jxde ) { for (let j = 0; j < jxde.length; j++) { if (jxde[j]["jxbh"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , jxde[j]["tbdj"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5, }); } let hanliang = Number(entry[10]); if (!number_equal(hanliang , jxde[j]["sl"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10, }); } } } } if (Number(rcjlb) == Number(2) && clde ) { for (let j = 0; j < clde.length; j++) { if (clde[j]["CLBH"] == bianhao) { let danjia = Number(entry[5]); if (!number_equal(danjia , clde[j]["YSJG"])) { console.log(`[${i},5]danjia bu yizhi`); toHighlight.push({row: i, col: 5, }); } let hanliang = Number(entry[10]); if (!number_equal(hanliang ,clde[j]["SL"])) { console.log(`[${i}, 10]hanliang bu yizhi`); toHighlight.push({row: i, col: 10, }); } } } } } console.log(toHighlight); highlight.current = toHighlight; } let bzrcjhl = [["人材机编码", "名称", "单位", "单价", "合价", "含量"]] if (rgde) for (let i = 0; i < rgde.length; i++) { bzrcjhl.push([rgde[i]["CLBH"], rgde[i]["CLMC"], rgde[i]["JLDW"], rgde[i]["YSJG"], rgde[i]["gf"], rgde[i]["gr"]]); } if (clde) for (let i = 0; i < clde.length; i++) { bzrcjhl.push([clde[i]["CLBH"], clde[i]["CLMC"], clde[i]["JLDW"], clde[i]["YSJG"], clde[i]["HJ"], clde[i]["SL"]]); } if (jxde) for (let i = 0; i < jxde.length; i++) { bzrcjhl.push([jxde[i]["jxbh"], jxde[i]["jxmc"], jxde[i]["DW"], jxde[i]["tbdj"], jxde[i]["hj"], jxde[i]["sl"]]); } setRcjhl2(bzrcjhl); }, [rgde, jxde, clde] ); const handleChange = (event, newValue) => { setValue(newValue); }; return (
{ if (isQdrcj.current) return {readOnly: true, renderer: "customStylesRenderer"}; if (col == 8) { return { readOnly: true, renderer: "customStylesRenderer" }; } if (col <= 1 || col >= 11) { return { readOnly: true, renderer: "customStylesRenderer" }; } else if (row == 0){ return { readOnly: true, renderer: "customStylesRenderer" }; } else { return { readOnly: false, renderer: "customStylesRenderer" }; } }} afterChange={afterChange} ref = {hotRcjRef} manualColumnResize={true} rowHeaders={true} colHeaders={true} height="200" afterOnCellMouseDown={afterOnCellMouseDown} readOnly={true} fixedRowsTop={1} selectionMode="single" autoWrapRow={false} autoWrapCol={false} licenseKey="non-commercial-and-evaluation" // for non-commercial use only /> ); }