project_property_basicInfo.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531
  1. /**
  2. * Created by Zhong on 2017/11/23.
  3. */
  4. let basicInfoView = {
  5. orgDatas: [],//for compare
  6. datas: [],//just for view
  7. workBook: null,
  8. setting:{
  9. header: [
  10. {name: '属性', dataCode: 'dispName', width: 200, vAlign: 'center', hAlign: 'left'},
  11. {name: '值', dataCode: 'value', width: 300, vAlign: 'center', hAlign: 'left'}
  12. ],
  13. options: {
  14. allowContextMenu: false,
  15. tabStripVisible: false,
  16. allowCopyPasteExcelStyle : false,
  17. allowExtendPasteRange: false,
  18. allowUserDragDrop : false,
  19. allowUserDragFill: false,
  20. scrollbarMaxAlign : true
  21. },
  22. dateRows: [],
  23. numRows: [],
  24. locked: {
  25. rows: [],
  26. cols: [0]
  27. }
  28. },
  29. renderSheetFuc: function (sheet, fuc) {
  30. sheet.suspendPaint();
  31. sheet.suspendEvent();
  32. fuc();
  33. sheet.resumePaint();
  34. sheet.resumeEvent();
  35. },
  36. setOptions: function (workbook, opts) {
  37. for(let opt in opts){
  38. workbook.options[opt] = opts[opt];
  39. }
  40. },
  41. getRowByField: function (field) {
  42. let me = basicInfoView;
  43. for(let i = 0; i < me.orgDatas.length; i++){
  44. let data = me.orgDatas[i];
  45. if(data.key === field){
  46. return i;
  47. }
  48. }
  49. return null;
  50. },
  51. setDatePicker: function (sheet, dateRows) {
  52. let me = this;
  53. this.renderSheetFuc(sheet, function () {
  54. for(let i = 0, len = dateRows.length; i < len; i++){
  55. sheet.getCell(dateRows[i], 1).cellType(me.getDatePickerCellType()).width(100).formatter('yyyy-mm-dd');
  56. }
  57. });
  58. },
  59. buildHeader: function (sheet, headers) {
  60. let me = basicInfoView;
  61. let fuc = function () {
  62. sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
  63. sheet.setColumnCount(headers.length);
  64. sheet.setRowHeight(0, 40, GC.Spread.Sheets.SheetArea.colHeader);
  65. for(let i = 0, len = headers.length; i < len; i++){
  66. sheet.setValue(0, i, headers[i].name, GC.Spread.Sheets.SheetArea.colHeader);
  67. sheet.setColumnWidth(i, headers[i].width, GC.Spread.Sheets.SheetArea.colHeader);
  68. sheet.getRange(-1, i, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign[headers[i]['hAlign']]);
  69. sheet.getRange(-1, i, -1, 1).vAlign(GC.Spread.Sheets.VerticalAlign[headers[i]['vAlign']]);
  70. }
  71. };
  72. me.renderSheetFuc(sheet, fuc);
  73. },
  74. buildSheet: function () {
  75. if(!this.workBook){
  76. this.workBook = new GC.Spread.Sheets.Workbook($('#basicInfoSpread')[0], {sheetCount: 1});
  77. sheetCommonObj.spreadDefaultStyle(this.workBook);
  78. sheetCommonObj.bindEscKey(this.workBook, [{sheet: this.workBook.getSheet(0), editStarting: this.onEditStarting, editEnded: this.onEditEnded}]);
  79. this.setOptions(this.workBook, this.setting.options);
  80. this.buildHeader(this.workBook.getActiveSheet(), this.setting.header);
  81. this.bindEvent(this.workBook);
  82. }
  83. },
  84. bindEvent: function (workBook) {
  85. const _events = GC.Spread.Sheets.Events;
  86. let sheet = workBook.getActiveSheet();
  87. sheet.bind(_events.EditStarting, this.onEditStarting);
  88. sheet.bind(_events.EditEnded, this.onEditEnded);
  89. sheet.bind(_events.EnterCell, this.onEnterCell);
  90. sheet.bind(_events.ClipboardPasting, this.onClipboardPasting);
  91. sheet.bind(_events.ClipboardPasted, this.onClipboardPasted);
  92. },
  93. showData(datas){
  94. let me = basicInfoView;
  95. let sheet = this.workBook.getActiveSheet();
  96. let cols = this.setting.header;
  97. let fuc = function () {
  98. sheet.setRowCount(datas.length);
  99. me.initTree(sheet, true, datas);
  100. sheet.setFormatter(-1, 1, '@');
  101. //兼容旧数据,旧数据可能没有设置cellType
  102. let compatNumKeys = ['grossArea'],
  103. compatDateKeys = ['constructionDate', 'establishDate'];
  104. for(let row = 0;row < datas.length ; row ++){
  105. if(datas[row].cellType == 'number' || compatNumKeys.includes(datas[row].key)){
  106. me.setting.numRows.push(row);
  107. } else if (datas[row].cellType === 'date' || compatDateKeys.includes(datas[row].key)) {
  108. me.setting.dateRows.push(row);
  109. } else if(datas[row].cellType === 'comboBox'){
  110. let options = datas[row].options ? datas[row].options.split("@") : [];
  111. projFeatureView.setCombo(sheet, row, options);
  112. }
  113. let readOnly = typeof datas[row].readOnly === 'string' ? JSON.parse(datas[row].readOnly) : datas[row].readOnly;
  114. if (readOnly || datas[row].items) {
  115. me.setting.locked.rows.push(row);
  116. }
  117. for(let col = 0;col < cols.length;col++){
  118. sheet.setValue(row, col, datas[row][cols[col]['dataCode']]);
  119. }
  120. }
  121. me.setDatePicker(sheet, me.setting.dateRows);
  122. };
  123. this.renderSheetFuc(sheet, fuc);
  124. },
  125. onEditStarting: function (sender, args) {
  126. let me = basicInfoView;
  127. if(args.col === 0){
  128. args.cancel = true;
  129. }
  130. if(me.setting.locked.rows.indexOf(args.row) !== -1){
  131. args.cancel = true;
  132. }
  133. },
  134. onEditEnded: function (sender, args) {
  135. let me = basicInfoView;
  136. let v = args.editingText ? args.editingText.toString().trim() : '';
  137. if(args.row < me.datas.length){
  138. let required = typeof me.datas[args.row].required === 'string' ? JSON.parse(me.datas[args.row].required) : me.datas[args.row].required;
  139. //date
  140. if (required && !v) {
  141. v = me.datas[args.row].value;
  142. args.sheet.setValue(args.row, args.col, v);
  143. } else if(me.setting.dateRows.indexOf(args.row) !== -1){
  144. if(v.length > 0){
  145. v = formatDate(new Date(v), 'yyyy-MM-dd');
  146. v = me.filtDate(v);
  147. if(!v){
  148. alert('请输入正确的日期格式yyyy-mm-dd');
  149. args.sheet.setValue(args.row, args.col, me.datas[args.row].value ? me.datas[args.row].value : '');
  150. return;
  151. }
  152. }
  153. } else if(me.setting.numRows.indexOf(args.row) !== -1){//控制数值
  154. if(!me.isNum(v)){
  155. alert('只能输入数值');
  156. v = me.datas[args.row].value && me.isNum(me.datas[args.row].value) ? me.datas[args.row].value : '';
  157. args.sheet.setValue(args.row, args.col, v);
  158. }
  159. }
  160. me.datas[args.row].value = v;
  161. }
  162. },
  163. onEnterCell: function (sender, args) {
  164. args.sheet.repaint();
  165. },
  166. onClipboardPasting: function (sender, args) {
  167. let me = basicInfoView;
  168. if(args.cellRange.col === 0){
  169. args.cancel = true;
  170. }
  171. },
  172. onClipboardPasted: function (sender, args) {
  173. let me = basicInfoView;
  174. let items = sheetCommonObj.analyzePasteData(me.setting, args);
  175. let recRows = [];
  176. for(let i = 0, len = items.length; i < len; i++){
  177. let row = i + args.cellRange.row;
  178. let comboItems = projFeatureView.getComboItemsByRow.call(me, row);
  179. let required = typeof me.datas[row].required === 'string' ? JSON.parse(me.datas[row].required) : me.datas[row].required;
  180. if(me.setting.locked.rows.indexOf(row) !== -1){
  181. recRows.push(row);
  182. } else if(comboItems && !comboItems.includes(items[i].value)){//粘贴下拉框数据过滤
  183. recRows.push(row);
  184. } else if(me.setting.dateRows.indexOf(row) !== -1){
  185. items[i].value = me.filtDate(items[i].value);
  186. if(!me.isDef(items[i].value)){
  187. recRows.push(row);
  188. } else {
  189. me.datas[row].value = items[i].value;
  190. }
  191. } else if(me.setting.numRows.indexOf(row) !== -1 && !me.isNum(items[i].value)){
  192. recRows.push(row);
  193. } else if (required && !items[i].value) {
  194. recRows.push(row);
  195. } else
  196. {me.datas[row].value = items[i].value;
  197. }
  198. }
  199. if(recRows.length > 0){
  200. me.renderSheetFuc(args.sheet, function () {
  201. for(let i = 0, len = recRows.length; i < len; i++){
  202. let staticV = me.datas[recRows[i]].value || '';
  203. args.sheet.setValue(recRows[i], args.cellRange.col, staticV);
  204. }
  205. });
  206. }
  207. },
  208. isDef: function (v) {
  209. return v !== undefined && v !== null;
  210. },
  211. isNum: function(v){
  212. return this.isDef(v) && !isNaN(v);
  213. },
  214. filtDate: function (v) {
  215. let re = /([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})-(((0[13578]|1[02])-(0[1-9]|[12][0-9]|3[01]))|((0[469]|11)-(0[1-9]|[12][0-9]|30))|(02-(0[1-9]|[1][0-9]|2[0-8])))/
  216. let reDate = re.exec(v);
  217. let rst = reDate ? reDate[0] : null;
  218. return rst;
  219. },
  220. copyObj: function(obj){
  221. let newObj = {};
  222. for(let attr in obj){
  223. newObj[attr] = obj[attr];
  224. }
  225. return newObj;
  226. },
  227. initDatas: function (datas) {
  228. this.datas = [];
  229. for(let i = 0, len = datas.length; i < len; i++){
  230. this.datas.push(this.copyObj(datas[i]));
  231. }
  232. },
  233. //数据库读到的数据转换为展示的结构
  234. toViewDatas: function (datas) {
  235. let rst = [];
  236. for(let i = 0, len = datas.length; i < len; i++){
  237. let items = datas[i].items || null;
  238. if(items){
  239. rst.push(datas[i]);
  240. for(let j = 0, jLen = items.length; j < jLen; j++){
  241. rst.push(items[j]);
  242. }
  243. }
  244. }
  245. return rst;
  246. },
  247. //展示的结构转换为入库的结构
  248. toSaveDatas: function (datas) {
  249. let rst = [];
  250. let index = -1;
  251. for(let i = 0, len = datas.length; i < len; i++){
  252. let items = datas[i].items || null;
  253. if(items){
  254. delete datas[i].collapsed;
  255. datas[i].items = [];
  256. rst.push(datas[i]);
  257. index++;
  258. }
  259. else {
  260. rst[index]['items'].push(datas[i]);
  261. }
  262. }
  263. return rst;
  264. },
  265. toUpdate: function (orgDatas, newDatas) {
  266. if(orgDatas.length !== newDatas.length){
  267. return true;
  268. }
  269. for(let i = 0, len = orgDatas.length; i < len; i++){
  270. let orgObj = orgDatas[i], newObj = newDatas[i];
  271. if(orgObj.value !== newObj.value){
  272. return true;
  273. }
  274. }
  275. return false;
  276. },
  277. a_updateInfo: function (datas) {
  278. let me = this;
  279. let url = '/pm/api/updateProjects',
  280. updateData = {
  281. updateType: 'update',
  282. updateData: {ID: parseInt(scUrlUtil.GetQueryString('project')), 'property.basicInformation': datas}
  283. },
  284. postData = {
  285. user_id: userID,
  286. updateData: [updateData]
  287. };
  288. CommonAjax.post(url, postData, function (rstData) {
  289. me.orgDatas = me.toViewDatas(datas);
  290. });
  291. },
  292. initTree:function (sheet, init, datas) {
  293. sheet.getRange(-1, 0, -1, 1).cellType(this.getTreeNodeCellType(datas));
  294. for(let i =0, len = datas.length; i < len; i++){
  295. if(datas[i].hasOwnProperty('items')){
  296. let collapsed = false;
  297. if(init){
  298. datas[i].collapsed=false;
  299. collapsed = true;
  300. }else {
  301. collapsed = datas[i].collapsed == undefined ? true : datas[i].collapsed;
  302. }
  303. //sheet.getRange(i+1, -1, datas[i].items.length, -1).visible(!collapsed);
  304. }
  305. }
  306. },
  307. getTreeNodeCellType:function (data) {
  308. var ns = GC.Spread.Sheets;
  309. var rectW = 10;
  310. var rectH = 10;
  311. var margin = 3;
  312. function TreeNodeCellType() {
  313. }
  314. function drowRect(ctx,x,y,w,h) {///
  315. ctx.save();
  316. ctx.strokeStyle = "gray";
  317. ctx.translate(0.5,0.5);
  318. ctx.beginPath();
  319. var rectX = x+margin;
  320. var rectY = y+ Math.round(h/2)-rectH/2;
  321. ctx.moveTo(rectX, rectY);
  322. ctx.lineTo(rectX, rectY+rectH);
  323. ctx.lineTo(rectX+rectW, rectY+rectH);
  324. ctx.lineTo(rectX+rectW, rectY);
  325. ctx.lineTo(rectX, rectY);
  326. ctx.moveTo(rectX+rectW, y+Math.round(h/2));
  327. ctx.lineTo(rectX+rectW+5, y+Math.round(h/2));
  328. ctx.stroke();
  329. ctx.restore();
  330. }
  331. function drowSymbol(ctx,x,y,w,h,collapsed) {
  332. ctx.save();
  333. ctx.strokeStyle = "#000000";
  334. ctx.translate(0.5, 0.5);
  335. ctx.beginPath();
  336. ctx.moveTo(x+margin+2, y+Math.round(h/2));
  337. ctx.lineTo(x+margin+8, y+Math.round(h/2));
  338. var rectY = y+ Math.round(h/2)-rectH/2;
  339. if(collapsed){
  340. ctx.moveTo(x+margin+rectW/2,rectY+2);
  341. ctx.lineTo(x+margin+rectW/2,rectY+2+6);
  342. }
  343. ctx.stroke();
  344. ctx.restore();
  345. }
  346. function drowSubItem(ctx,x,y,w,h,offset,nextItem) {
  347. offset+=6;
  348. ctx.save();
  349. ctx.strokeStyle = "gray";
  350. ctx.translate(0.5, 0.5);
  351. ctx.beginPath();
  352. ctx.moveTo(x+offset, y);
  353. ctx.lineTo(x+offset, y+Math.round(h/2));
  354. offset+=9;
  355. ctx.lineTo(x+offset, y+Math.round(h/2));
  356. if(nextItem&&!nextItem.hasOwnProperty('items')){
  357. ctx.moveTo(x+offset-9, y+Math.round(h/2));
  358. ctx.lineTo(x+offset-9, y+h);
  359. }
  360. ctx.stroke();
  361. ctx.restore();
  362. return offset;
  363. }
  364. TreeNodeCellType.prototype = new ns.CellTypes.Text();
  365. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  366. if(value!=null){
  367. var offset = margin+rectW+6;
  368. var recode = data[options.row];
  369. if(recode&&recode.hasOwnProperty('items')){
  370. drowRect(ctx,x,y,w,h);
  371. var collapsed = recode.collapsed==undefined?true:recode.collapsed;//options.sheet.getTag(options.row,options.col);
  372. drowSymbol(ctx,x,y,w,h,collapsed);
  373. }else if(recode&&!recode.hasOwnProperty('items')){
  374. offset= drowSubItem(ctx,x,y,w,h,offset,data[options.row+1]);
  375. offset+=1;
  376. }
  377. arguments[2] = x + offset;
  378. arguments[4] = w - offset;
  379. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  380. }
  381. };
  382. // override getHitInfo to allow cell type get mouse messages
  383. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  384. return {
  385. x: x,
  386. y: y,
  387. row: context.row,
  388. col: context.col,
  389. cellStyle: cellStyle,
  390. cellRect: cellRect,
  391. sheetArea: context.sheetArea
  392. };
  393. }
  394. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  395. var recode = data[hitinfo.row];
  396. let offset = -1,
  397. indent = 20,
  398. halfBoxLength = 5;
  399. let centerX = hitinfo.cellRect.x + offset + indent / 2;
  400. let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2
  401. if(recode&&recode.hasOwnProperty('items')){
  402. //方框外1像素内都有效
  403. const boxLengh = 10;
  404. if (hitinfo.x >= centerX - halfBoxLength - 1 && hitinfo.x <= centerX + halfBoxLength + 1 &&
  405. hitinfo.y >= centerY - halfBoxLength - 1 && hitinfo.y <= centerY + halfBoxLength + 1) {
  406. var collapsed = recode.collapsed==undefined?true:recode.collapsed;
  407. collapsed = !collapsed
  408. recode.collapsed=collapsed;
  409. //hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,collapsed);
  410. hitinfo.sheet.getRange(hitinfo.row+1, -1, recode.items.length, -1).visible(!collapsed);
  411. hitinfo.sheet.invalidateLayout();
  412. hitinfo.sheet.repaint();
  413. }
  414. }
  415. };
  416. return new TreeNodeCellType()
  417. },
  418. getDatePickerCellType: function () {
  419. let ns = GC.Spread.Sheets;
  420. function DatePickerCellType() {
  421. }
  422. DatePickerCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();
  423. DatePickerCellType.prototype.createEditorElement = function (context) {
  424. //Create input presenter.
  425. return document.createElement("input");
  426. };
  427. DatePickerCellType.prototype.activateEditor = function (editorContext, cellStyle, cellRect, context) {
  428. //Initialize input editor.
  429. if (editorContext) {
  430. $editor = $(editorContext);
  431. //DatePickerCellType.prototype.activateEditor.apply(this, arguments);
  432. $editor.datepicker({dateFormat: 'yy-mm-dd'});
  433. $editor.css("position", "absolute");
  434. $editor.attr("gcUIElement", "gcEditingInput");
  435. $(".ui-datepicker").attr("gcUIElement", "gcEditingInput");
  436. }
  437. }
  438. DatePickerCellType.prototype.deactivateEditor = function (editorContext, context) {
  439. //Remove input editor when end editor status.
  440. if (editorContext) {
  441. var element = editorContext;
  442. $(element).datepicker("hide");
  443. $(element).datepicker("destroy");
  444. }
  445. // DatePickerCellType.prototype.deactivateEditor.apply(this, arguments)
  446. };
  447. DatePickerCellType.prototype.setEditorValue = function (editor, value, context) {
  448. //Sync value from Cell value to editor value.
  449. $(editor).datepicker("setDate", value);
  450. };
  451. DatePickerCellType.prototype.getEditorValue = function (editor, context) {
  452. //Sync value from editor value to cell value.
  453. return $(editor).datepicker("getDate");
  454. };
  455. DatePickerCellType.prototype.updateEditor = function (editorContext, cellStyle, cellRect, context) {
  456. if (editorContext) {
  457. $editor = $(editorContext);
  458. $editor.css("width", cellRect.width - 1);
  459. $editor.css("height", cellRect.height - 3);
  460. }
  461. };
  462. return new DatePickerCellType();
  463. }
  464. };
  465. $(document).ready(function () {
  466. $('#poj-set').on('shown.bs.modal', function (e) {
  467. //init Spread
  468. basicInfoView.initDatas(basicInfoView.orgDatas);
  469. basicInfoView.buildSheet();
  470. basicInfoView.showData(basicInfoView.datas);
  471. if(projectReadOnly){
  472. disableSpread(basicInfoView.workBook);
  473. }
  474. });
  475. $('#poj-set').on('hidden.bs.modal', function (e) {
  476. //destroy Spread
  477. if(basicInfoView.workBook){
  478. basicInfoView.workBook.destroy();
  479. basicInfoView.workBook = null;
  480. }
  481. basicInfoView.datas = [];
  482. });
  483. $('#tab_poj-settings-basicInfo').on('shown.bs.tab', function () {
  484. basicInfoView.workBook.refresh();
  485. });
  486. $('#openProjSet').click(function () {
  487. $('[data-toggle="tooltip"]').tooltip('hide');
  488. $('#poj-set').modal('show');
  489. })
  490. /* $('#property_ok').bind('click', function () {
  491. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  492. basicInfoView.a_updateInfo(basicInfoView.toSaveDatas(basicInfoView.datas));
  493. }
  494. });*/
  495. });