character_content_view.js 55 KB

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