character_content_view.js 64 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572
  1. /**
  2. * Created by Zhong on 2017/8/31.
  3. * 特征及内容
  4. */
  5. let contentOprObj = {
  6. workBook: null,
  7. currentCache: [],//按照serialNo排序
  8. setting: {
  9. header: [
  10. {headerName:"工作内容", headerWidth: 360, rateWidth:0.93, dataCode:"content", dataType: "String", hAlign: "left", vAlign: "center", formatter: '@'},
  11. {headerName:"输出", headerWidth: 40, rateWidth: null, dataCode:"isChecked", cellType:"checkBox", hAlign: "center", vAlign: "center"}
  12. ]
  13. },
  14. buildSheet: function(container) {
  15. let me = contentOprObj;
  16. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
  17. //获取工作内容列比例
  18. let workBookWidth = pageCCOprObj.getWorkBookWidth();
  19. me.setRateWith(workBookWidth);
  20. sheetCommonObj.setColumnWidthByRate(workBookWidth, me.workBook, me.setting.header);
  21. me.workBook.options.allowUserDragDrop = false;
  22. me.workBook.getSheet(0).setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  23. me.workBook.options.allowCopyPasteExcelStyle = false;
  24. if(!projectReadOnly){
  25. me.onContextmenuOpr();//右键菜单
  26. }
  27. me.bindEvents(me.workBook);
  28. },
  29. setRateWith: function (workBookWidth) {
  30. let me = this;
  31. let otherWidthRate = scMathUtil.roundTo(me.setting.header[1]['headerWidth'] / workBookWidth, -3);
  32. let contentWidthRate = 1 - otherWidthRate;
  33. me.setting.header[0]['rateWidth'] = contentWidthRate;
  34. },
  35. bindEvents: function (workBook) {
  36. let sheet = workBook.getActiveSheet(), me = contentOprObj;
  37. const EVENTS = GC.Spread.Sheets.Events;
  38. workBook.bind(EVENTS.ButtonClicked, me.onButtonClicked);
  39. sheet.bind(EVENTS.EditStarting, me.onEditStart);
  40. sheet.bind(EVENTS.ValueChanged, me.onValueChanged);
  41. sheet.bind(EVENTS.ClipboardPasting, me.onClipboardPasting);
  42. sheet.bind(EVENTS.ClipboardPasted, me.onClipboardPasted);
  43. sheet.bind(EVENTS.SelectionChanged, me.onSelectionChanged);
  44. workBook.bind(EVENTS.RangeChanged, me.onRangeChanged);
  45. me.bindTools();
  46. },
  47. bindTools: function () {
  48. let me = contentOprObj;
  49. let sheet = me.workBook.getActiveSheet();
  50. $('#jobAdd').click(function () {
  51. me.insertContent(sheet, me.currentCache.length, '');
  52. me.workBook.focus();
  53. });
  54. $('#jobInsert').click(function(){
  55. me.insertContent(sheet, sheet.getActiveRowIndex(), '');
  56. me.workBook.focus();
  57. });
  58. $('#jobDel').click(function(){
  59. me.deleteContent(sheet.getActiveRowIndex());
  60. me.workBook.focus();
  61. });
  62. $('#jobUp').click(function(){
  63. me.upMove({row: sheet.getActiveRowIndex(), col: sheet.getActiveColumnIndex()});
  64. me.workBook.focus();
  65. });
  66. $('#jobDown').click(function(){
  67. me.downMove({row: sheet.getActiveRowIndex(), col: sheet.getActiveColumnIndex()});
  68. me.workBook.focus();
  69. });
  70. },
  71. //将从清单库中添加的清单,把标准清单的工作内容转化成清单的工作内容
  72. buildJobContent: function (jobs) {
  73. let jobContent = [];
  74. for(let i = 0, len = jobs.length; i < len; i++){
  75. let newJob = {serialNo: i + 1, content: jobs[i].content, isChecked: true};//从清单库添加过来的默认输出
  76. jobContent.push(newJob);
  77. }
  78. return jobContent;
  79. },
  80. //显示在jobSpread的数据
  81. showContentData: function (sheet, setting, datas) {
  82. sheetCommonObj.showData(sheet, setting, datas);
  83. sheet.suspendPaint();
  84. sheet.suspendEvent();
  85. for(let i = 0, len = datas.length; i < len; i++){
  86. sheet.getCell(i, 0).locked(true);
  87. }
  88. sheet.resumePaint();
  89. sheet.suspendEvent();
  90. },
  91. //显示到清单工作内容列的数据
  92. getColData: function (jobsArr) {
  93. let me = contentOprObj;
  94. let rstStr = "", count = 0;
  95. for(let i = 0, len = jobsArr.length; i < len; i++){
  96. if(jobsArr[i].isChecked === true){
  97. count ++;
  98. /* if(count === 1){
  99. rstStr += "“";
  100. }
  101. else{
  102. rstStr += " ";
  103. }*/
  104. rstStr += count + ". " + jobsArr[i].content + "\n";
  105. }
  106. }
  107. if(rstStr.trim().length > 0){
  108. let reg = /\n+$/g;
  109. let newStr = rstStr.replace(reg, "");
  110. return newStr;
  111. }
  112. return null;
  113. },
  114. //新增行
  115. addRow: function (idx, sheet) {
  116. let checkBox = new GC.Spread.Sheets.CellTypes.CheckBox();
  117. checkBox.isThreeState = false;
  118. sheet.addRows(idx, 1);
  119. sheet.getCell(idx - 1, 1).cellType(checkBox);
  120. },
  121. upMove: function (cell) {
  122. let me = contentOprObj;
  123. let thisObj = me.currentCache[cell.row],
  124. preObj = me.currentCache[cell.row - 1],
  125. temp, contentTxt;
  126. temp = thisObj.serialNo;
  127. thisObj.serialNo = preObj.serialNo;
  128. preObj.serialNo = temp;
  129. me.sortCache(me.currentCache);
  130. me.save(function () {
  131. me.workBook.focus();
  132. me.workBook.getSheet(0).setActiveCell(cell.row - 1, cell.col);
  133. me.initSelection(cell.row - 1);
  134. });
  135. },
  136. downMove: function (cell) {
  137. let me = contentOprObj;
  138. let thisObj = me.currentCache[cell.row],
  139. nextObj = me.currentCache[cell.row + 1],
  140. temp, contentTxt;
  141. temp = thisObj.serialNo;
  142. thisObj.serialNo = nextObj.serialNo;
  143. nextObj.serialNo = temp;
  144. me.sortCache(me.currentCache);
  145. me.save(function () {
  146. me.workBook.focus();
  147. me.workBook.getSheet(0).setActiveCell(cell.row + 1, cell.col);
  148. me.initSelection(cell.row + 1);
  149. });
  150. },
  151. deleteContent: function (rowIdx) {
  152. let me = contentOprObj;
  153. me.currentCache.splice(rowIdx, 1);
  154. me.save();
  155. me.workBook.focus();
  156. },
  157. //更新
  158. updateContent: function (job, newContent, save = true) {
  159. let me = contentOprObj;
  160. job.content = newContent;
  161. if(save){
  162. me.save();
  163. }
  164. },
  165. //新增
  166. insertContent: function (sheet, idx, content) {
  167. let me = contentOprObj;
  168. me.addRow(idx, sheet);
  169. let newObj = {content: content, isChecked: true};
  170. me.currentCache.splice(idx, 0, newObj);
  171. //重新排序赋值
  172. pageCCOprObj.resortNo(me.currentCache);
  173. me.save();
  174. me.workBook.focus();
  175. },
  176. save: function (callback) {
  177. let selectedNode = projectObj.mainController.tree.selected;
  178. const setting = projectObj.project.property.addRule !== undefined ? projectObj.project.property.addRule : getAddRuleSetting();
  179. pageCCOprObj.setCharacterBySetting(selectedNode, setting, callback, contentOprObj);
  180. },
  181. // 获取默认清单工作内容文本
  182. getDefaultContent: function (billsNode) {
  183. if (!billsNode || !Array.isArray(billsNode.data.jobContent)) {
  184. return '';
  185. }
  186. return billsNode.data.jobContent[0].content;
  187. },
  188. // 从清单节点获取工作内容文本数据
  189. getContentTexts: function (billsNode) {
  190. if (!billsNode || !Array.isArray(billsNode.data.jobContent)) {
  191. return [];
  192. }
  193. let contents = billsNode.data.jobContent.map(data => data.content);
  194. // 去重
  195. return [...new Set(contents)];
  196. },
  197. // 对于定额工作内容与清单工作内容相关联的费用定额来说
  198. // 操作工作内容后,需要处理定额的工作内容
  199. // 若清单的工作内容修改后,定额的工作内容在清单工作内容中找不到,则把定额的工作内容设置为''
  200. getUpdateRations: function (billsNode) {
  201. // 获取清单工作内容文本数组
  202. let contents = this.getContentTexts(billsNode);
  203. // 查看清单下的定额,哪些定额需要更新(工作内容无法匹配)
  204. let projectID = projectObj.project.ID(),
  205. updates = [];
  206. for (let rNode of billsNode.children) {
  207. if (!rNode.data.jobContentText) {
  208. continue;
  209. }
  210. // 匹配不到,定额工作内容置空
  211. if (!contents.includes(rNode.data.jobContentText)) {
  212. updates.push({
  213. updateType: 'ut_update',
  214. updateData: {
  215. ID: rNode.data.ID,
  216. projectID,
  217. jobContentText: ''
  218. }
  219. });
  220. }
  221. }
  222. return updates.length
  223. ? {
  224. project_id: projectID,
  225. user_id: userID,
  226. date: new Date(),
  227. operation: 'updateBills',
  228. update_data: [{
  229. moduleName: 'ration',
  230. data: updates
  231. }]
  232. }
  233. : null;
  234. },
  235. onEditStart(sender, args){
  236. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  237. args.cancel = true;
  238. return;
  239. }
  240. },
  241. onValueChanged: function (sender, args) {
  242. let me = contentOprObj;
  243. if(me.setting.header[args.col].dataCode === 'isChecked'){
  244. return;
  245. }
  246. args.newValue = args.newValue ? args.newValue : '';
  247. //更新
  248. if(args.row < me.currentCache.length){
  249. let job = me.currentCache[args.row];
  250. me.updateContent(job, args.newValue);
  251. }
  252. },
  253. //复选框控制输出
  254. onButtonClicked: function (sender, args) {
  255. let me = contentOprObj, contentTxt;
  256. if(args.sheet.isEditing()){
  257. args.sheet.endEdit(true);
  258. }
  259. let isChecked = args.sheet.getValue(args.row, args.col);
  260. // 锁定清单值不变
  261. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  262. args.sheet.setValue(args.row, args.col, !isChecked);
  263. return;
  264. }
  265. if(me.currentCache.length > args.row){
  266. me.currentCache[args.row].isChecked = isChecked;
  267. me.save();
  268. }
  269. //else的情况就是新增
  270. else{
  271. //还没数据清空复选框
  272. args.sheet.setValue(args.row, args.col, 0);
  273. }
  274. },
  275. onRangeChanged: function (sender, args) {
  276. let me = contentOprObj;
  277. let rangeCell = isDef(args.changedCells[0]) ? args.changedCells[0] : null;
  278. if(!rangeCell){
  279. return;
  280. }
  281. let rangeData = isDef(me.currentCache[rangeCell.row]) ? me.currentCache[rangeCell.row] : null;
  282. if(!rangeData){
  283. return;
  284. }
  285. if(rangeCell.col === 0){//工作内容
  286. me.updateContent(rangeData, '');
  287. }
  288. else if(rangeCell.col === 1){//输出
  289. rangeData.isChecked = false;
  290. me.save();
  291. }
  292. },
  293. //复制粘贴
  294. onClipboardPasting: function (sender, args) {
  295. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  296. args.cancel = true;
  297. return;
  298. }
  299. if(args.cellRange.colCount > 1 || args.cellRange.col !== 0){
  300. args.cancel = true;
  301. }
  302. },
  303. onClipboardPasted: function (sender, args) {
  304. let me = contentOprObj;
  305. let items = sheetCommonObj.analyzePasteData(me.setting, args);
  306. let toSave = false;
  307. for(let i = 0, len = items.length; i < len; i++){
  308. let rowIdx = args.cellRange.row + i;
  309. //更新
  310. if(rowIdx < me.currentCache.length){
  311. toSave = true;
  312. me.updateContent(me.currentCache[rowIdx], items[i].content, false);
  313. }
  314. }
  315. if(toSave){
  316. me.save();
  317. }
  318. },
  319. onSelectionChanged: function (sender, args) {
  320. let me = contentOprObj;
  321. if(args.newSelections && args.newSelections.length > 0){
  322. me.initSelection(args.newSelections[0].row);
  323. }
  324. },
  325. initSelection: function (row) {
  326. let me = contentOprObj;
  327. let disObj = {jobAdd: false, jobInsert: true, jobDel: true, jobUp: true, jobDown: true};
  328. disObj.jobAdd = !pageCCOprObj.canAddType();
  329. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  330. disObj.jobAdd = true;
  331. disObj.jobInsert = true;
  332. disObj.jobDel = true;
  333. disObj.jobUp = true;
  334. disObj.jobDown = true;
  335. }
  336. else{
  337. if(row !== -1){
  338. //在表内
  339. if(row < me.currentCache.length){
  340. disObj.jobDel = false;
  341. disObj.jobInsert = false;
  342. if(row !== 0){
  343. disObj.jobUp = false;
  344. }
  345. if(row !== me.currentCache.length - 1){
  346. disObj.jobDown = false;
  347. }
  348. }
  349. }
  350. }
  351. me.refreshTools(disObj);
  352. },
  353. //刷新工具条
  354. refreshTools: function (disObj) {
  355. for(let o in disObj){
  356. let jqSel = $(`#${o}`);
  357. jqSel.removeClass('disabled');
  358. if(disObj[o]){
  359. jqSel.addClass('disabled');
  360. }
  361. }
  362. },
  363. sortCache: function (cacheArr) {
  364. cacheArr.sort(function (a, b) {
  365. let rst = 0;
  366. if(a.serialNo > b.serialNo){
  367. rst = 1;
  368. }
  369. else if(a.serialNo < b.serialNo){
  370. rst = -1;
  371. }
  372. return rst;
  373. });
  374. },
  375. onContextmenuOpr: function () {//右键菜单
  376. let me = contentOprObj;
  377. $.contextMenu({
  378. selector: '#jobSpread',
  379. build: function($triggerElement, e){
  380. //控制允许右键菜单在哪个位置出现
  381. let target = SheetDataHelper.safeRightClickSelection($triggerElement, e, me.workBook);
  382. let sheet = me.workBook.getSheet(0);
  383. let addDis = pageCCOprObj.canAddType() ? false : true, insertDis = false, delDis = false, upDis = false, downDis = false;
  384. if(target.hitTestType === 3){//在表格内&& typeof target.row !== 'undefined' && typeof target.col !== 'undefined'
  385. //清单锁定,不可用
  386. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  387. addDis = true;
  388. insertDis = true;
  389. delDis = true;
  390. upDis = true;
  391. downDis = true;
  392. }
  393. else{
  394. if(typeof target.row !== 'undefined'){
  395. //控制按钮是否可用
  396. sheet.setActiveCell(target.row, target.col);
  397. if(!me.currentCache ||target.row >= me.currentCache.length){//右键定位在有数据的行,删除键才显示可用
  398. insertDis = true;
  399. delDis = true;
  400. downDis = true;
  401. upDis = true;
  402. }
  403. else{//有数据
  404. if(typeof target.col === 'undefined'){//定位不在表格内
  405. insertDis = true;
  406. downDis = true;
  407. upDis = true;
  408. delDis = true;
  409. }
  410. else{//定位在表格内
  411. if(target.row === me.currentCache.length -1){//定位在最后一行,不可下移
  412. downDis = true;
  413. }
  414. if(target.row === 0){//定位在第一行,不可上移
  415. upDis = true;
  416. }
  417. }
  418. }
  419. }
  420. else{
  421. insertDis = true;
  422. delDis = true;
  423. downDis = true;
  424. upDis = true;
  425. }
  426. }
  427. me.refreshTools({jobAdd: addDis, jobInsert: insertDis, jobDel: delDis, jobUp: upDis, jobDown: downDis});
  428. return {
  429. callback: function(){},
  430. items: {
  431. "insert": {name: "插入", disabled: insertDis, icon: "fa-sign-in", callback: function (key, opt) {
  432. me.insertContent(sheet, sheet.getActiveRowIndex(), '');
  433. }},
  434. "add": {name: "添加", disabled: addDis, icon: "fa-plus", callback: function (key, opt) {
  435. me.insertContent(sheet, me.currentCache.length, '');
  436. }},
  437. "delete": {name: "删除", disabled: delDis, icon: "fa-remove", callback: function (key, opt) {
  438. me.deleteContent(target.row);
  439. }},
  440. "upMove": {name: "上移", disabled: upDis, icon: "fa-arrow-up", callback: function (key, opt) {
  441. me.upMove({row: target.row, col: target.col});
  442. }},
  443. "downMove": {name: "下移", disabled: downDis, icon: "fa-arrow-down", callback: function (key, opt) {
  444. me.downMove({row: target.row, col: target.col});
  445. }}
  446. }
  447. };
  448. }
  449. else{
  450. me.refreshTools({jobAdd: addDis, jobInsert: insertDis, jobDel: delDis, jobUp: upDis, jobDown: downDis});
  451. return false;
  452. }
  453. }
  454. });
  455. }
  456. };
  457. let characterOprObj = {
  458. workBook: null,
  459. currentCache: [],
  460. setting: {
  461. header: [
  462. {headerName:"项目特征",headerWidth:120, rateWidth:0.9, dataCode:"character", dataType: "String", hAlign: "left", vAlign: "center", formatter: '@'},
  463. {headerName:"特征值",headerWidth:160,dataCode:"eigenvalue", dataType: "String", cellType: "comboBox", hAlign: "left", vAlign: "center", formatter: '@'},
  464. {headerName:"输出",headerWidth:40,dataCode:"isChecked", cellType:"checkBox", hAlign: "center", vAlign: "center"}
  465. ]
  466. },
  467. buildSheet: function(container) {
  468. let me = characterOprObj;
  469. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30);
  470. //获取项目特征列比例
  471. let workBookWidth = pageCCOprObj.getWorkBookWidth();
  472. me.setRateWith(workBookWidth);
  473. sheetCommonObj.setColumnWidthByRate(workBookWidth, me.workBook, me.setting.header);
  474. me.workBook.options.allowUserDragDrop = false;
  475. me.workBook.getSheet(0).setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  476. me.workBook.options.allowCopyPasteExcelStyle = false;
  477. if(!projectReadOnly){
  478. me.onContextmenuOpr();
  479. }
  480. me.bindEvents(me.workBook);
  481. },
  482. setRateWith: function (workBookWidth) {
  483. let me = this;
  484. let otherWidthRate = (me.setting.header[1]['headerWidth'] + me.setting.header[2]['headerWidth']) / workBookWidth;
  485. let contentWidthRate = 1 - otherWidthRate;
  486. me.setting.header[0]['rateWidth'] = contentWidthRate;
  487. },
  488. bindEvents: function (workBook) {
  489. let sheet = workBook.getActiveSheet(), me = characterOprObj;
  490. const EVENTS = GC.Spread.Sheets.Events;
  491. workBook.bind(EVENTS.ButtonClicked, me.onButtonClicked);
  492. sheet.bind(EVENTS.EnterCell, me.onEnterCell);
  493. sheet.bind(EVENTS.ValueChanged, me.onValueChanged);
  494. sheet.bind(EVENTS.EditStarting, me.onEditStart);
  495. sheet.bind(EVENTS.ClipboardPasting, me.onClipboardPasting);
  496. sheet.bind(EVENTS.ClipboardPasted, me.onClipboardPasted);
  497. sheet.bind(EVENTS.SelectionChanged, me.onSelectionChanged);
  498. workBook.bind(EVENTS.RangeChanged, me.onRangeChanged);
  499. me.bindTools();
  500. },
  501. bindTools: function () {
  502. let me = characterOprObj;
  503. let sheet = me.workBook.getActiveSheet();
  504. $('#itemAdd').click(function () {
  505. me.insertCharacter(sheet, me.currentCache.length, '');
  506. me.workBook.focus();
  507. });
  508. $('#itemInsert').click(function(){
  509. me.insertCharacter(sheet, sheet.getActiveRowIndex(), '');
  510. me.workBook.focus();
  511. });
  512. $('#itemDel').click(function(){
  513. me.deleteCharacter(sheet.getActiveRowIndex());
  514. me.workBook.focus();
  515. });
  516. $('#itemUp').click(function(){
  517. me.upMove({row: sheet.getActiveRowIndex(), col: sheet.getActiveColumnIndex()});
  518. me.workBook.focus();
  519. });
  520. $('#itemDown').click(function(){
  521. me.downMove({row: sheet.getActiveRowIndex(), col: sheet.getActiveColumnIndex()});
  522. me.workBook.focus();
  523. });
  524. },
  525. //将从清单库中添加的清单,把标准清单的项目特征转化成清单的项目特征
  526. buildItemCharactet: function (items) {//从清单库过来的默认不输出
  527. let itemCharacter = [];
  528. for(let i = 0, len = items.length; i < len; i++){
  529. let newItem = {serialNo: i + 1, character: items[i].content, eigenvalue: [], isChecked: false};
  530. let eigenvalues = items[i].itemValue;
  531. for(let j = 0, len = eigenvalues.length; j < len; j++){
  532. let newValue = {value: eigenvalues[j].value, isSelected: false};
  533. newItem.eigenvalue.push(newValue);
  534. }
  535. itemCharacter.push(newItem);
  536. }
  537. return itemCharacter;
  538. },
  539. //显示在itemSpread的数据
  540. showCharacterData: function (sheet, setting, datas) {
  541. let me = characterOprObj;
  542. sheetCommonObj.showData(sheet, setting, datas);
  543. sheet.suspendPaint();
  544. sheet.suspendEvent();
  545. for(let i = 0, len = datas.length; i < len; i++){
  546. let comboObj = me.getComboBox(datas[i]);
  547. comboObj.combo.editable(false);//不可编辑
  548. sheet.getCell(i, 1).cellType(comboObj.combo).value(typeof comboObj.selectedValue !== 'undefined' ? comboObj.selectedValue : '');
  549. sheet.getCell(i, 0).locked(true);
  550. }
  551. sheet.resumePaint();
  552. sheet.suspendEvent();
  553. },
  554. //获得项目特征特征值comboBox
  555. getComboBox: function (characterItem) {
  556. let rst = {};
  557. let combo = sheetCommonObj.getDynamicCombo();
  558. let comboItems = [], eigenvalues = characterItem.eigenvalue;
  559. for(let i = 0, len = eigenvalues.length; i < len; i++){
  560. comboItems.push(eigenvalues[i].value);
  561. if(eigenvalues[i].isSelected){
  562. rst.selectedValue = eigenvalues[i].value;
  563. }
  564. }
  565. combo.items(comboItems);
  566. rst.combo = combo;
  567. return rst;
  568. },
  569. //获得当前行选中的特征值
  570. getCurrentSelected: function (item) {
  571. let rst = null;
  572. for(let i = 0, len = item.eigenvalue.length; i < len; i++){
  573. if(item.eigenvalue[i].isSelected){
  574. rst = item.eigenvalue[i].value;
  575. break;
  576. }
  577. }
  578. return rst;
  579. },
  580. //显示到清单项目特征列的数据
  581. getColData: function (itemsArr) {
  582. let me = characterOprObj;
  583. let rstStr = "", count = 0;
  584. for(let i = 0, len = itemsArr.length; i < len; i++){
  585. if(itemsArr[i].isChecked === true){
  586. //获取选中的特征值
  587. let eigenvalueStr = "";
  588. let eigenvalue = itemsArr[i].eigenvalue;
  589. for(let j = 0, vLen = eigenvalue.length; j < vLen; j++){
  590. if(eigenvalue[j].isSelected){
  591. eigenvalueStr += eigenvalue[j].value;
  592. break;
  593. }
  594. }
  595. count ++;
  596. /*if(count === 1){
  597. rstStr += "“";
  598. }
  599. else{
  600. rstStr += " ";
  601. }*/
  602. rstStr += count + ". " + itemsArr[i].character + ": " + eigenvalueStr + "\n";
  603. }
  604. }
  605. if(rstStr.trim().length > 0){
  606. let reg = /\n+$/g;
  607. let newStr = rstStr.replace(reg, "");
  608. return newStr;
  609. }
  610. return null;
  611. },
  612. addRow: function (idx, sheet) {
  613. let checkBox = new GC.Spread.Sheets.CellTypes.CheckBox(),
  614. combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  615. checkBox.isThreeState = false;
  616. combo.editable(true);
  617. sheet.addRows(idx, 1);
  618. sheet.getCell(idx, 1).cellType(combo);
  619. sheet.getCell(idx, 2).cellType(checkBox);
  620. },
  621. upMove: function (cell) {
  622. let me = characterOprObj;
  623. let thisObj = me.currentCache[cell.row],
  624. preObj = me.currentCache[cell.row - 1],
  625. temp;
  626. temp = thisObj.serialNo;
  627. thisObj.serialNo = preObj.serialNo;
  628. preObj.serialNo = temp;
  629. contentOprObj.sortCache(me.currentCache);
  630. me.save(function () {
  631. me.workBook.getSheet(0).setActiveCell(cell.row - 1, cell.col);
  632. me.workBook.focus();
  633. me.initSelection(cell.row - 1);
  634. });
  635. },
  636. downMove: function (cell) {
  637. let me = characterOprObj;
  638. let thisObj = me.currentCache[cell.row],
  639. nextObj = me.currentCache[cell.row + 1],
  640. temp;
  641. temp = thisObj.serialNo;
  642. thisObj.serialNo = nextObj.serialNo;
  643. nextObj.serialNo = temp;
  644. contentOprObj.sortCache(me.currentCache);
  645. me.save(function () {
  646. me.workBook.getSheet(0).setActiveCell(cell.row + 1, cell.col);
  647. me.workBook.focus();
  648. me.initSelection(cell.row + 1);
  649. });
  650. },
  651. deleteCharacter: function (rowIdx) {
  652. let me = characterOprObj;
  653. me.currentCache.splice(rowIdx, 1);
  654. me.save();
  655. me.workBook.focus();
  656. },
  657. //取消选择的特征值
  658. unsetSelected: function (item) {
  659. for(let i = 0, len = item.eigenvalue.length; i < len; i++){
  660. if(item.eigenvalue[i].isSelected){
  661. item.eigenvalue[i].isSelected = false;
  662. }
  663. }
  664. },
  665. //设置选中的特征值
  666. setSelected: function (item, value) {
  667. for(let i = 0, len = item.eigenvalue.length; i < len; i++){
  668. if(item.eigenvalue[i].value === value){
  669. item.eigenvalue[i].isSelected = true;
  670. }
  671. }
  672. },
  673. //改变选择特征值
  674. changeSelected: function (item, value) {
  675. let me = characterOprObj;
  676. me.unsetSelected(item);
  677. me.setSelected(item, value);
  678. },
  679. insertValue: function (item, value) {
  680. let me = characterOprObj;
  681. me.unsetSelected(item);
  682. let newValue = {value: value, isSelected: true};
  683. item.eigenvalue.push(newValue);
  684. },
  685. updateCharacter: function (item, character, value, save = true) {
  686. let me = characterOprObj;
  687. if(character !== undefined && character !== null){
  688. item.character = character;
  689. }
  690. if(value !== undefined && value !== null){
  691. if(value !== ''){
  692. let isExist = false;
  693. for(let i = 0, len = item.eigenvalue.length; i < len; i++){
  694. if(item.eigenvalue[i].value === value){
  695. isExist = true;
  696. break;
  697. }
  698. }
  699. //不存在,新增进eigenvalue,自动打勾输出
  700. if(!isExist){
  701. //更新selected
  702. me.insertValue(item, value);
  703. item.isChecked = true;
  704. }
  705. //存在,选择特征值,自动打勾输出
  706. else{
  707. me.changeSelected(item, value);
  708. item.isChecked = true;
  709. }
  710. }
  711. else {
  712. me.unsetSelected(item);
  713. }
  714. }
  715. if(save){
  716. me.save();
  717. }
  718. },
  719. insertCharacter: function (sheet, idx, character) {
  720. let me = characterOprObj;
  721. me.addRow(idx, sheet);
  722. let newObj = {character: character, eigenvalue: [], isChecked: false};
  723. me.currentCache.splice(idx, 0, newObj);
  724. pageCCOprObj.resortNo(me.currentCache);
  725. me.save();
  726. me.workBook.focus();
  727. },
  728. save: function (callback) {
  729. let selectedNode = projectObj.mainController.tree.selected;
  730. const setting = projectObj.project.property.addRule !== undefined ? projectObj.project.property.addRule : getAddRuleSetting();
  731. pageCCOprObj.setCharacterBySetting(selectedNode, setting, callback, characterOprObj);
  732. },
  733. onEditStart: function (sender, args) {
  734. let me = characterOprObj;
  735. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  736. args.cancel = true;
  737. return;
  738. }
  739. if(args.col === 1){//改变选择的特征值
  740. me.currentSelectedValue = me.currentCache.length > args.row ? me.getCurrentSelected(me.currentCache[args.row]) : null;
  741. }
  742. },
  743. onEnterCell: function (sender, args) {
  744. args.sheet.repaint();
  745. },
  746. onValueChanged: function (sender, args) {
  747. let me = characterOprObj;
  748. args.newValue = args.newValue ? args.newValue : '';
  749. //更新
  750. if(args.row < me.currentCache.length){
  751. let thisCha = me.currentCache[args.row];
  752. if(args.col === 0){//特征
  753. me.updateCharacter(thisCha, args.newValue, null);
  754. }
  755. else if(args.col === 1){//特征值
  756. me.updateCharacter(thisCha, null, args.newValue);
  757. }
  758. }
  759. },
  760. onClipboardPasting: function (sender, args) {
  761. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  762. args.cancel = true;
  763. }
  764. if(args.cellRange.col + args.colCount - 1 > 1){
  765. args.cancel = true;
  766. }
  767. },
  768. onClipboardPasted: function (sender, args) {
  769. let me = characterOprObj;
  770. let items = sheetCommonObj.analyzePasteData(me.setting, args);
  771. let toSave = false;
  772. for(let i = 0, len = items.length; i < len; i++){
  773. //更新
  774. let rowIdx = args.cellRange.row + i;
  775. if(me.currentCache.length > rowIdx){
  776. toSave = true;
  777. me.updateCharacter(me.currentCache[rowIdx], items[i].character, items[i].eigenvalue, false);
  778. }
  779. }
  780. if(toSave){
  781. me.save();
  782. }
  783. },
  784. onRangeChanged: function (sender, args) {
  785. let me = characterOprObj;
  786. let rangeCell = isDef(args.changedCells[0]) ? args.changedCells[0] : null;
  787. if(!rangeCell){
  788. return;
  789. }
  790. let rangeData = isDef(me.currentCache[rangeCell.row]) ? me.currentCache[rangeCell.row] : null;
  791. if(!rangeData){
  792. return;
  793. }
  794. if(rangeCell.col === 0){//特征
  795. me.updateCharacter(rangeData, '', null);
  796. }
  797. else if(rangeCell.col === 1){//特征值
  798. me.updateCharacter(rangeData, null, '');
  799. }
  800. else if(rangeCell.col === 2){
  801. rangeData.isChecked = false;
  802. me.save();
  803. }
  804. /*if(rangeCell.col === 1){//特征值
  805. rangeData.isChecked = false;
  806. for(let value of rangeData.eigenvalue){
  807. value.isSelected = false;
  808. }
  809. }*/
  810. //me.save();
  811. },
  812. //复选框控制输出
  813. onButtonClicked: function (sender, args) {
  814. let me = characterOprObj, characterTxt;
  815. if(args.sheet.isEditing()){
  816. args.sheet.endEdit(true);
  817. }
  818. let isChecked = args.sheet.getValue(args.row, args.col);
  819. // 锁定清单值不变
  820. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  821. args.sheet.setValue(args.row, args.col, !isChecked);
  822. return;
  823. }
  824. if(me.currentCache.length > args.row){
  825. me.currentCache[args.row].isChecked = isChecked;
  826. me.save();
  827. }
  828. //else的情况就是新增
  829. else{
  830. args.sheet.setValue(args.row, args.col, 0);
  831. }
  832. },
  833. onSelectionChanged: function (sender, args) {
  834. let me = characterOprObj;
  835. if(args.newSelections && args.newSelections.length > 0){
  836. me.initSelection(args.newSelections[0].row);
  837. }
  838. },
  839. initSelection: function (row) {
  840. let me = characterOprObj;
  841. let disObj = {itemAdd: false, itemInsert: true, itemDel: true, itemUp: true, itemDown: true};
  842. disObj.itemAdd = !pageCCOprObj.canAddType();
  843. //清单锁定,不可用
  844. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  845. disObj.itemAdd = true;
  846. disObj.itemInsert = true;
  847. disObj.itemDel = true;
  848. disObj.itemUp = true;
  849. disObj.itemDown = true;
  850. }
  851. else{
  852. if(row !== -1){
  853. //在表内
  854. if(row < me.currentCache.length){
  855. disObj.itemDel = false;
  856. disObj.itemInsert = false;
  857. if(row !== 0){
  858. disObj.itemUp = false;
  859. }
  860. if(row !== me.currentCache.length - 1){
  861. disObj.itemDown = false;
  862. }
  863. }
  864. }
  865. }
  866. me.refreshTools(disObj);
  867. },
  868. //刷新工具条
  869. refreshTools: function (disObj) {
  870. for(let o in disObj){
  871. let jqSel = $(`#${o}`);
  872. jqSel.removeClass('disabled');
  873. if(disObj[o]){
  874. jqSel.addClass('disabled');
  875. }
  876. }
  877. },
  878. onContextmenuOpr: function () {//右键菜单
  879. let me = characterOprObj;
  880. $.contextMenu({
  881. selector: '#itemSpread',
  882. build: function($triggerElement, e){
  883. //控制允许右键菜单在哪个位置出现
  884. let target = SheetDataHelper.safeRightClickSelection($triggerElement, e, me.workBook);
  885. let sheet = me.workBook.getSheet(0);
  886. let addDis = pageCCOprObj.canAddType() ? false : true, insertDis = false, delDis = false, upDis = false, downDis = false;
  887. if(target.hitTestType === 3){//在表格内 && typeof target.row !== 'undefined' && typeof target.col !== 'undefined'
  888. //清单锁定,则不可用
  889. if(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  890. addDis = true;
  891. insertDis = true;
  892. delDis = true;
  893. upDis = true;
  894. downDis = true;
  895. }
  896. else{
  897. if(typeof target.row !== 'undefined'){
  898. //控制按钮是否可用
  899. sheet.setActiveCell(target.row, target.col);
  900. if(!me.currentCache ||target.row >= me.currentCache.length){//右键定位在有数据的行,删除键才显示可用
  901. insertDis = true;
  902. delDis = true;
  903. downDis = true;
  904. upDis = true;
  905. }
  906. else{//有数据
  907. if(typeof target.col === 'undefined'){//定位在表格外
  908. insertDis = true;
  909. downDis = true;
  910. upDis = true;
  911. delDis = true;
  912. }
  913. else{
  914. if(target.row === me.currentCache.length -1){//定位在最后一行,不可下移
  915. downDis = true;
  916. }
  917. if(target.row === 0){//定位在第一行,不可上移
  918. upDis = true;
  919. }
  920. }
  921. }
  922. }
  923. else{
  924. insertDis = true;
  925. delDis = true;
  926. downDis = true;
  927. upDis = true;
  928. }
  929. }
  930. me.refreshTools({itemAdd: addDis, itemInsert: insertDis, itemDel: delDis, itemUp: upDis, itemDown: downDis});
  931. return {
  932. callback: function(){},
  933. items: {
  934. "insert": {name: "插入", disabled: insertDis, icon: "fa-sign-in", callback: function (key, opt) {
  935. me.insertCharacter(sheet, sheet.getActiveRowIndex(), '');
  936. }},
  937. "add": {name: "添加", disabled: addDis, icon: "fa-plus", callback: function (key, opt) {
  938. me.insertCharacter(sheet, me.currentCache.length, '');
  939. }},
  940. "delete": {name: "删除", disabled: delDis, icon: "fa-remove", callback: function (key, opt) {
  941. me.deleteCharacter(target.row);
  942. }},
  943. "upMove": {name: "上移", disabled: upDis, icon: "fa-arrow-up", callback: function (key, opt) {
  944. me.upMove({row: target.row, col: target.col});
  945. }},
  946. "downMove": {name: "下移", disabled: downDis, icon: "fa-arrow-down", callback: function (key, opt) {
  947. me.downMove({row: target.row, col: target.col});
  948. }}
  949. }
  950. };
  951. }
  952. else{
  953. me.refreshTools({jobAdd: addDis, jobInsert: insertDis, jobDel: delDis, jobUp: upDis, jobDown: downDis});
  954. return false;
  955. }
  956. }
  957. });
  958. }
  959. };
  960. let pageCCOprObj = {
  961. // 记录清单节点-工作内容文本数组的映射关系
  962. // 定额-动态工作内容下拉项需要
  963. contentCache: {},
  964. currentFindSet: null,
  965. mainActiveCell: null,//mainSpread焦点单元格
  966. nameCache: '',
  967. //重新赋serialNo
  968. resortNo: function (items) {
  969. let count = 1;
  970. for(let item of items){
  971. item.serialNo = count++;
  972. }
  973. },
  974. //可以添加的类型:分项、补项、清单
  975. canAddType: function () {
  976. let rst = false;
  977. let selectedNode = projectObj.mainController.tree.selected;
  978. if(selectedNode && selectedNode.sourceType === projectObj.project.Bills.getSourceType() &&
  979. (selectedNode.data.type === billType.FX || selectedNode.data.type === billType.BX || selectedNode.data.type === billType.BILL)){//为清单
  980. rst = true
  981. }
  982. return rst;
  983. },
  984. setItemContentNode: function (node, jobs, items, name = '') {
  985. let theCont = contentOprObj, theCha = characterOprObj,
  986. jobContent, itemCharacter, contentTxt, characterTxt;
  987. jobContent = theCont.buildJobContent(jobs);
  988. itemCharacter = theCha.buildItemCharactet(items);
  989. // contentTxt = theCont.getColData(jobContent);
  990. // characterTxt = theCha.getColData(itemCharacter);
  991. node.data.jobContent = jobContent;
  992. node.data.itemCharacter = itemCharacter;
  993. this.nameCache = name;
  994. // 根据规则设置对应特征、内容、名称格式
  995. const setting = projectObj.project.property.addRule !== undefined ? projectObj.project.property.addRule : getAddRuleSetting();
  996. const updateData = pageCCOprObj.getCharacterUpdateData(setting, node);
  997. node.data.jobContentText = updateData.jobContentText;
  998. node.data.itemCharacterText = updateData.itemCharacterText;
  999. node.data.name = updateData.name;
  1000. },
  1001. safeItemCharater: function (itemCharater) {
  1002. return characterOprObj.buildItemCharactet(itemCharater);
  1003. },
  1004. //设置特征及内容currentCache
  1005. setCacheAndShow: function (node) {
  1006. if(!projectReadOnly){
  1007. this.refreshRuleTools(projectObj.project.isBillsLocked());
  1008. }
  1009. if(node && node.sourceType === projectObj.project.Bills.getSourceType()){
  1010. let theCont = contentOprObj, theCha = characterOprObj;
  1011. node.data.jobContent = node && typeof node.data.jobContent !== 'undefined' ? node.data.jobContent : [];
  1012. node.data.itemCharacter = node && typeof node.data.itemCharacter !== 'undefined' ? node.data.itemCharacter : [];
  1013. theCont.currentCache = node.data.jobContent;
  1014. theCha.currentCache = node.data.itemCharacter;
  1015. this.currentFindSet = node && typeof node.data.ID !== 'undefined' && typeof node.data.projectID ? {ID: node.data.ID, projectID: node.data.projectID} : null;
  1016. this.showData(theCont.workBook.getSheet(0), theCont.setting, theCont.currentCache);
  1017. this.showData(theCha.workBook.getSheet(0), theCha.setting, theCha.currentCache);
  1018. }
  1019. else{
  1020. this.clearData();
  1021. }
  1022. },
  1023. //contentSpread、itemSpread展示数据用
  1024. showData: function(sheet, setting, data) {
  1025. let me = this, ch = GC.Spread.Sheets.SheetArea.viewport;
  1026. sheet.suspendPaint();
  1027. sheet.suspendEvent();
  1028. sheet.clear(0, 0, sheet.getRowCount(), sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  1029. sheet.setRowCount(data.length);
  1030. for (let col = 0; col < setting.header.length; col++) {
  1031. var hAlign = "left", vAlign = "center";
  1032. if (setting.header[col].hAlign) {
  1033. hAlign = setting.header[col].hAlign;
  1034. } else if (setting.header[col].dataType !== "String"){
  1035. hAlign = "right";
  1036. }
  1037. vAlign = setting.header[col].vAlign?setting.header[col].vAlign:vAlign;
  1038. sheetCommonObj.setAreaAlign(sheet.getRange(-1, col, -1, 1), hAlign, vAlign);
  1039. if (setting.header[col].formatter) {
  1040. sheet.setFormatter(-1, col, setting.header[col].formatter, GC.Spread.Sheets.SheetArea.viewport);
  1041. }
  1042. for (let row = 0; row < data.length; row++) {
  1043. sheet.getCell(row, 0).locked(true);//locked
  1044. let val = data[row][setting.header[col].dataCode];
  1045. if(setting.header[col].cellType === "checkBox"){
  1046. let checkBox = new GC.Spread.Sheets.CellTypes.CheckBox();
  1047. checkBox.isThreeState(false);
  1048. sheet.getCell(row, col).cellType(checkBox).value(val);
  1049. }
  1050. else if(setting.header[col].cellType === 'comboBox'){
  1051. let comboObj = characterOprObj.getComboBox(data[row]);
  1052. comboObj.combo.editable(true);//可编辑
  1053. sheet.getCell(row, 1).cellType(comboObj.combo).value(typeof comboObj.selectedValue !== 'undefined' ? comboObj.selectedValue : '');
  1054. }
  1055. else{
  1056. sheet.setValue(row, col, val, ch);
  1057. }
  1058. sheet.getCell(row, col).wordWrap(true);
  1059. sheet.autoFitRow(row);
  1060. }
  1061. }
  1062. contentOprObj.initSelection(contentOprObj.workBook.getSheet(0).getActiveRowIndex());
  1063. characterOprObj.initSelection(characterOprObj.workBook.getSheet(0).getActiveRowIndex());
  1064. sheet.resumeEvent();
  1065. sheet.resumePaint();
  1066. },
  1067. clearData: function () {
  1068. let theCon = contentOprObj, theCha = characterOprObj;
  1069. theCon.workBook.getSheet(0).setRowCount(0);
  1070. theCon.refreshTools({jobAdd: true, jobInsert: true, jobDel: true, jobUp: true, jobDown: true});
  1071. theCha.workBook.getSheet(0).setRowCount(0);
  1072. theCha.refreshTools({itemAdd: true, itemInsert: true, itemDel: true, itemUp: true, itemDown: true});
  1073. sheetCommonObj.cleanSheet(theCon.workBook.getSheet(0), theCon.setting, -1);
  1074. sheetCommonObj.cleanSheet(theCha.workBook.getSheet(0), theCha.setting, -1);
  1075. projectObj.mainSpread.focus(true);
  1076. },
  1077. //锁定/解锁清单后添加规则的改变
  1078. refreshRuleTools: function (lockBills) {
  1079. $('#use-to-current').removeClass('disabled');
  1080. $('#use-to-all').removeClass('disabled');
  1081. if(lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected)){
  1082. $('#use-to-current').addClass('disabled');
  1083. $('#use-to-all').addClass('disabled');
  1084. }
  1085. },
  1086. //更新特征及内容数据
  1087. updateCharacterContent: function (findSet, updateObj, txtObj, oprObj, callback) {
  1088. let me = pageCCOprObj, updateCol;
  1089. if(txtObj){
  1090. updateCol = txtObj.field === 'itemCharacterText' ? 4 : 5;//更新清单行特征列或内容列
  1091. }
  1092. else{
  1093. updateCol = null;
  1094. }
  1095. let url = '/bills/updateCharacterContent';
  1096. let postData = {
  1097. findSet: findSet,
  1098. updateObj: updateObj,
  1099. txtObj: txtObj
  1100. };
  1101. CommonAjax.post(url, postData, function (rstData) {
  1102. //更新节点数据
  1103. if(updateCol){
  1104. // 已当前选中行更新数据
  1105. let selectedNode = projectObj.mainController.tree.selected;
  1106. selectedNode.data[updateObj.field] = updateObj.updateArr;
  1107. selectedNode.data[txtObj.field] = txtObj.text;
  1108. me.showData(oprObj.workBook.getSheet(0), oprObj.setting, oprObj.currentCache);//刷新特征及内容Spread
  1109. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1110. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, updateCol, txtObj.text + ''); //刷新输出显示
  1111. projectObj.mainSpread.getActiveSheet().autoFitRow(activeCell.row);
  1112. if(callback){
  1113. callback();
  1114. }
  1115. }
  1116. });
  1117. },
  1118. /**
  1119. * 更新bill数据
  1120. *
  1121. * @param {Object} findSet - 更新条件
  1122. * @param {Object} updateData - 更新数据
  1123. * @param {Function} callback - 回调函数
  1124. * @return {void}
  1125. */
  1126. updateBill: function(findSet, updateData, callback) {
  1127. if (!updateData instanceof Array || updateData.length <= 0) {
  1128. return;
  1129. }
  1130. let url = '/bills/updateBill';
  1131. let postData = { findSet, updateData };
  1132. CommonAjax.post(url, postData, function (response) {
  1133. callback(response);
  1134. });
  1135. },
  1136. /**
  1137. * 刷新节点数据
  1138. *
  1139. * @param {Object} node - 节点数据
  1140. * @param {Object} refreshData - 刷新的数据
  1141. * @return {void}
  1142. */
  1143. refreshView: function(node, refreshData) {
  1144. // 更新清单行特征列或内容列
  1145. let updateCol = [
  1146. { name: 'itemCharacterText', col: colSettingObj.getColByField('itemCharacterText')},
  1147. { name: 'jobContentText', col: colSettingObj.getColByField('jobContentText')},
  1148. { name: 'name', col: colSettingObj.getColByField('name')}
  1149. ];
  1150. if (updateCol === '') {
  1151. return;
  1152. }
  1153. const row = node.serialNo();
  1154. // 刷新输出显示
  1155. for (const tmp of updateCol) {
  1156. // 没有默认的数据则跳过刷新
  1157. if (refreshData[tmp.name] === undefined) {
  1158. continue;
  1159. }
  1160. projectObj.mainSpread.getActiveSheet().setValue(row, tmp.col, refreshData[tmp.name] + '');
  1161. }
  1162. projectObj.mainSpread.getActiveSheet().autoFitRow(row);
  1163. },
  1164. bulkSetCharacterBySetting: function(nodes, setting) {
  1165. $.bootstrapLoading.start();
  1166. let me = this;
  1167. let updateDatas = [];
  1168. let updateNodes = [];
  1169. let updateMapping = {};
  1170. for(let node of nodes){
  1171. if(!node || node.sourceType !== projectObj.project.Bills.getSourceType()){
  1172. continue;
  1173. }
  1174. let findSet = {ID: node.data.ID, projectID: node.data.projectID};
  1175. let updateData = this.getCharacterUpdateData(setting, node);
  1176. updateData.jobContent = node.data.jobContent;
  1177. updateData.itemCharacter = node.data.itemCharacter;
  1178. let orgName = isDef(node.data.name) ? node.data.name : '';
  1179. let orgItemCharacterText = isDef(node.data.itemCharacterText) ? node.data.itemCharacterText : '';
  1180. let orgJobContentText = isDef(node.data.jobContentText) ? node.data.jobContentText : '';
  1181. if(orgName == updateData.name && orgItemCharacterText == updateData.itemCharacterText && orgJobContentText == updateData.jobContentText){
  1182. continue;
  1183. }
  1184. updateMapping[node.data.ID] = updateData;
  1185. updateNodes.push(node);
  1186. updateDatas.push({findSet: findSet, updateData: updateData});
  1187. }
  1188. if(updateDatas.length > 0){
  1189. CommonAjax.post('/bills/updateBills', {updateDatas: updateDatas}, function (rstData) {
  1190. for(let node of updateNodes){
  1191. let mainSheet = projectObj.mainSpread.getActiveSheet();
  1192. mainSheet.suspendPaint();
  1193. mainSheet.suspendEvent();
  1194. me.refreshView(node, updateMapping[node.data.ID]);
  1195. node.data.name = updateMapping[node.data.ID]['name'];
  1196. node.data.itemCharacterText = updateMapping[node.data.ID]['itemCharacterText'];
  1197. node.data.jobContentText = updateMapping[node.data.ID]['jobContentText'];
  1198. mainSheet.resumePaint();
  1199. mainSheet.resumeEvent();
  1200. }
  1201. $.bootstrapLoading.end();
  1202. }, function () {
  1203. $.bootstrapLoading.end();
  1204. });
  1205. }
  1206. else {
  1207. $.bootstrapLoading.end();
  1208. }
  1209. },
  1210. /**
  1211. * 根据配置设置清单项目特征
  1212. *
  1213. * @param {Object} node - 选中的node节点
  1214. * @param {Object} setting - 设置
  1215. * @return {void}
  1216. */
  1217. setCharacterBySetting: function(node, setting, callback = null, oprObj = null, usedToAll = null) {
  1218. if(!node || node.sourceType !== projectObj.project.Bills.getSourceType()){
  1219. return;
  1220. }
  1221. let self = this;
  1222. // 保存的条件数据
  1223. const findSet = { ID: node.data.ID, projectID: node.data.projectID };
  1224. const updateData = this.getCharacterUpdateData(setting, node);
  1225. let saveObj = [];
  1226. for (const index in updateData) {
  1227. saveObj.push({field: index, value: updateData[index]});
  1228. }
  1229. //saveObj.push({field: 'addRule', value: setting});
  1230. saveObj.push({field: 'jobContent', value: node.data.jobContent});
  1231. saveObj.push({field: 'itemCharacter', value: node.data.itemCharacter});
  1232. if(usedToAll){
  1233. //应用到所有清单、过滤,只更新会发生变化的清单
  1234. let orgName = isDef(node.data.name) ? node.data.name : '';
  1235. let orgItemCharacterText = isDef(node.data.itemCharacterText) ? node.data.itemCharacterText : '';
  1236. let orgJobContentText = isDef(node.data.jobContentText) ? node.data.jobContentText : '';
  1237. if(orgName == updateData.name && orgItemCharacterText == updateData.itemCharacterText && orgJobContentText == updateData.jobContentText){
  1238. return;
  1239. }
  1240. }
  1241. // 更新到数据库
  1242. pageCCOprObj.updateBill(findSet, saveObj, function(response) {
  1243. self.refreshView(node, updateData);
  1244. // 更新项目属性的配置
  1245. //projectObj.project.property.addRule = setting;
  1246. // 更新节点数据
  1247. node.data.name = updateData.name;
  1248. node.data.itemCharacterText = updateData.itemCharacterText;
  1249. node.data.jobContentText = updateData.jobContentText;
  1250. if (oprObj) {
  1251. pageCCOprObj.showData(oprObj.workBook.getSheet(0), oprObj.setting, oprObj.currentCache);//刷新特征及内容Spread
  1252. }
  1253. if(callback){
  1254. callback();
  1255. }
  1256. // 操作工作内容时更新定额显示(工作内容下拉)
  1257. if (_compilationConfig.dynamicRationWorkContent &&
  1258. oprObj === contentOprObj) {
  1259. let updateData = contentOprObj.getUpdateRations(node);
  1260. if (updateData) {
  1261. ajaxPost('/project/save', updateData).then(() => {
  1262. updateData.update_data[0].data.forEach(rData => {
  1263. let thisUpdate = rData.updateData;
  1264. let rationNode = projectObj.project.mainTree.nodes['id_' + thisUpdate.ID];
  1265. if (rationNode) {
  1266. rationNode.data.jobContentText = thisUpdate.jobContentText;
  1267. }
  1268. });
  1269. TREE_SHEET_HELPER.massOperationSheet(projectObj.mainController.sheet, function () {
  1270. TREE_SHEET_HELPER.refreshTreeNodeData(projectObj.mainController.setting,
  1271. projectObj.mainController.sheet, node.children, false);
  1272. });
  1273. });
  1274. } else {
  1275. TREE_SHEET_HELPER.massOperationSheet(projectObj.mainController.sheet, function () {
  1276. TREE_SHEET_HELPER.refreshTreeNodeData(projectObj.mainController.setting,
  1277. projectObj.mainController.sheet, node.children, false);
  1278. });
  1279. }
  1280. }
  1281. });
  1282. },
  1283. /**
  1284. * 格式化序号格式
  1285. *
  1286. * @param {Number} type - 格式化的类型
  1287. * @param {String} serialNo - 待格式化的序号
  1288. * @return {String} - 返回格式化后的字符
  1289. */
  1290. formatSerialNumber: function(type, serialNo) {
  1291. const letter = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r',
  1292. 's', 't', 'u', 'v', 'w', 'x', 'y', 'z'];
  1293. switch (type) {
  1294. case '1':
  1295. // 数字
  1296. serialNo = serialNo + '. ';
  1297. break;
  1298. case '2':
  1299. // 英文字母(小写)
  1300. serialNo = letter[serialNo - 1] !== undefined ? letter[serialNo - 1] + '. ' : '';
  1301. break;
  1302. case '3':
  1303. // 英文字母(大写)
  1304. serialNo = letter[serialNo - 1] !== undefined ? letter[serialNo - 1].toUpperCase() + '. ' : '';
  1305. break;
  1306. default:
  1307. serialNo = '';
  1308. break;
  1309. }
  1310. return serialNo;
  1311. },
  1312. /**
  1313. * 查找选中的树节点中定额子目数据
  1314. *
  1315. * @param {Object} selectNode - 选中的节点
  1316. * @param {Object} setting - 设置
  1317. * @return {Array} - 返回定额子目数组
  1318. */
  1319. getRationChapter: function(selectNode, setting) {
  1320. let result = [];
  1321. if (selectNode.children === undefined || selectNode.children.length <= 0) {
  1322. return result;
  1323. }
  1324. // 查找对应的定额数据
  1325. let count = 1;
  1326. for (const tmp of selectNode.children) {
  1327. if (tmp.sourceType !== 'ration') {
  1328. continue;
  1329. }
  1330. const serialNo = this.formatSerialNumber(setting.serialType, count.toString());
  1331. if(setting.childDisplayFormat === '1'){
  1332. }
  1333. let code = isDef(tmp.data.code) ? tmp.data.code : '';
  1334. let name = isDef(tmp.data.name) ? tmp.data.name : '';
  1335. setting.childDisplayFormat === "1" ? result.push(code + ':' + name) : result.push(serialNo + name);
  1336. count++;
  1337. }
  1338. return result;
  1339. },
  1340. /**
  1341. * 获取默认数据
  1342. *
  1343. * @param {Object} node - 节点数据
  1344. * @param {Object} setting - 设置
  1345. * @return {Object}
  1346. */
  1347. getDataBySetting: function(node, setting) {
  1348. let result = {};
  1349. try {
  1350. if (node.data === undefined) {
  1351. throw '数据错误';
  1352. }
  1353. const itemCharacter = node.data.itemCharacter;
  1354. const itemJob = node.data.jobContent;
  1355. /* if (itemCharacter === undefined || itemCharacter.length <= 0 || itemJob === undefined || itemJob.length <= 0) {
  1356. throw '内部数据错误';
  1357. }*/
  1358. if (itemCharacter === undefined || itemJob === undefined) {
  1359. throw '内部数据错误';
  1360. }
  1361. // 默认名称
  1362. result['name'] = this.nameCache;
  1363. // 特征
  1364. let characterArray = [];
  1365. let count = 1;
  1366. for (const tmp of itemCharacter) {
  1367. if (!tmp.isChecked) {
  1368. continue;
  1369. }
  1370. if(tmp.eigenvalue === undefined || tmp.eigenvalue.length <= 0){
  1371. tmp.eigenvalue = [];
  1372. }
  1373. // 获取选中的特征值
  1374. let selectedEigen = '';
  1375. for (const eigen of tmp.eigenvalue) {
  1376. if (eigen.isSelected) {
  1377. selectedEigen = eigen.value;
  1378. }
  1379. }
  1380. // 匹配设置的序号格式
  1381. const serialNo = this.formatSerialNumber(setting.serialType, count.toString());
  1382. let characterString = '';
  1383. // 特征生成方式
  1384. switch (setting.characterFormat) {
  1385. case '1':
  1386. // 特征值
  1387. characterString = serialNo + selectedEigen;
  1388. break;
  1389. case '2':
  1390. // 特征:特征值
  1391. characterString = serialNo + tmp.character + ': ' + selectedEigen;
  1392. break;
  1393. }
  1394. characterArray.push(characterString);
  1395. count++;
  1396. }
  1397. result['character'] = characterArray;
  1398. // 内容部分
  1399. let jobArray = [];
  1400. count = 1;
  1401. for (const tmp of itemJob) {
  1402. if (!tmp.isChecked) {
  1403. continue;
  1404. }
  1405. // 匹配设置的序号格式
  1406. const serialNo = this.formatSerialNumber(setting.serialType, count.toString());
  1407. jobArray.push(serialNo + tmp.content);
  1408. count++;
  1409. }
  1410. result['content'] = jobArray;
  1411. } catch (error) {
  1412. console.log(error);
  1413. result = {};
  1414. }
  1415. return result;
  1416. },
  1417. /**
  1418. * 获取特征内容名称更新的数据
  1419. *
  1420. * @param {Object} setting - 设置
  1421. * @param {Object} node - 节点数据
  1422. * @return {Object} - 返回更新的数据
  1423. */
  1424. getCharacterUpdateData: function(setting, node) {
  1425. let updateData = {
  1426. itemCharacterText: '',
  1427. jobContentText: '',
  1428. name: node.data.name ? node.data.name : '',
  1429. };
  1430. /* let updateData = {
  1431. itemCharacterText: '',
  1432. jobContentText: '',
  1433. name: '',
  1434. };*/
  1435. if(!node.data.itemCharacter){
  1436. node.data.itemCharacter = [];
  1437. }
  1438. if(!node.data.jobContent){
  1439. node.data.jobContent = [];
  1440. }
  1441. if(setting.addContent !== '5'){
  1442. if (node.data.name === undefined || (node.data.itemCharacter.length <= 0 && node.data.jobContent.length <= 0)) {
  1443. return updateData;
  1444. }
  1445. }
  1446. // 获取原名称
  1447. const name = isDef(node.data.name) ? node.data.name.split("\n") : '';
  1448. this.nameCache = name[0] !== undefined ? name[0] : "";
  1449. updateData.name = this.nameCache;
  1450. let contentArray = [];
  1451. // 获取当前设置数据
  1452. const currentData = this.getDataBySetting(node, setting);
  1453. // 组合数据
  1454. let content = '';
  1455. switch (setting.addContent) {
  1456. case "1":
  1457. // 项目特征+工作内容
  1458. contentArray.push('[项目特征]');
  1459. contentArray.push.apply(contentArray, currentData.character);
  1460. contentArray.push('[工作内容]');
  1461. contentArray.push.apply(contentArray, currentData.content);
  1462. break;
  1463. case "2":
  1464. // 工作内容+项目特征
  1465. contentArray.push('[工作内容]');
  1466. contentArray.push.apply(contentArray, currentData.content);
  1467. contentArray.push('[项目特征]');
  1468. contentArray.push.apply(contentArray, currentData.character);
  1469. break;
  1470. case "3":
  1471. // 项目特征
  1472. contentArray.push.apply(contentArray, currentData.character);
  1473. break;
  1474. case "4":
  1475. // 工作内容
  1476. contentArray.push.apply(contentArray, currentData.content);
  1477. break;
  1478. case "5":
  1479. // 定额子目
  1480. const rationChapter = this.getRationChapter(node, setting);
  1481. contentArray.push.apply(contentArray, rationChapter);
  1482. break;
  1483. case "":
  1484. // 无
  1485. break;
  1486. }
  1487. // 显示格式
  1488. switch (setting.displayFormat) {
  1489. case "1":
  1490. // 换行分隔
  1491. content = contentArray.join("\n");
  1492. currentData.character = currentData.character.join("\n");
  1493. currentData.content = currentData.content.join("\n");
  1494. break;
  1495. case "2":
  1496. // 逗号分隔
  1497. content = contentArray.join(',');
  1498. currentData.character = currentData.character.join(",");
  1499. currentData.content = currentData.content.join(",");
  1500. break;
  1501. case "3":
  1502. // 括号分隔
  1503. content = '(' + contentArray.join(',') + ')';
  1504. break;
  1505. }
  1506. // 添加到对应位置
  1507. switch (setting.position) {
  1508. case "1":
  1509. // 添加到项目特征列
  1510. updateData.itemCharacterText = content;
  1511. break;
  1512. case "2":
  1513. // 添加到清单名称列
  1514. content = content !== '' ? this.nameCache + "\n" + content : this.nameCache;
  1515. updateData.name = content;
  1516. break;
  1517. case "3":
  1518. // 添加到工作内容列
  1519. updateData.jobContentText = content;
  1520. break;
  1521. case "4":
  1522. updateData = {
  1523. itemCharacterText: currentData.character,
  1524. jobContentText: currentData.content,
  1525. name: currentData.name,
  1526. };
  1527. break;
  1528. }
  1529. return updateData;
  1530. },
  1531. //获取特征及内容工作簿宽度
  1532. getWorkBookWidth: function () {
  1533. return ($(window).width() - $('.main-nav').width() - $('.main-side').width()) / 3 - 50;
  1534. },
  1535. resizeWidth: function () {
  1536. let workBookWidth = pageCCOprObj.getWorkBookWidth();
  1537. contentOprObj.setRateWith($('#jobDiv').width() - 45);
  1538. sheetCommonObj.setColumnWidthByRate($('#jobDiv').width() - 55, contentOprObj.workBook, contentOprObj.setting.header);
  1539. characterOprObj.setRateWith($('#itemDiv').width() - 45);
  1540. sheetCommonObj.setColumnWidthByRate($('#itemDiv').width() - 48, characterOprObj.workBook, characterOprObj.setting.header);
  1541. }
  1542. }
  1543. /*
  1544. $(window).resize(function () {
  1545. pageCCOprObj.resizeWidth();
  1546. });*/