quantity_edit_view.js 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. /**
  2. * Created by zhang on 2018/7/20.
  3. */
  4. let quantityEditObj = {
  5. spread:null,
  6. datas:[],
  7. setting:{
  8. header:[
  9. {headerName: "基数名称", headerWidth: 250, dataCode: "name", dataType: "String"},
  10. {headerName: "代码", headerWidth: 150, dataCode: "code", dataType: "String"},
  11. ],
  12. view: {
  13. lockColumns: [0,1]
  14. }
  15. },
  16. initSpread:function () {
  17. if(!this.spread){
  18. this.spread = SheetDataHelper.createNewSpread($("#quantityEditSpread")[0]);
  19. this.initSheet();
  20. }else {
  21. this.spread.refresh();
  22. }
  23. this.showData();
  24. },
  25. initSheet:function () {
  26. this.sheet = this.spread .getSheet(0);
  27. sheetCommonObj.initSheet( this.sheet, this.setting, 30);
  28. this.sheet.bind(GC.Spread.Sheets.Events.CellDoubleClick,this.onCellDoubleClick);
  29. this.sheet.name('quantityEdit');
  30. // console.log(cell.value());
  31. },
  32. showData:function () {
  33. this.datas = [];//{name:'工程量明细合计',code:'GCLMXHJ'}这里暂时只有清单量一个选项
  34. let selected = projectObj.project.mainTree.selected;
  35. if(selected.sourceType == ModuleNames.ration){
  36. this.datas.push({name:'清单量',code:'QDL'});
  37. }
  38. sheetCommonObj.showData(this.sheet, this.setting,this.datas);
  39. this.sheet.setRowCount(this.datas.length);
  40. },
  41. onCellDoubleClick:function (e,info) {
  42. if(quantityEditObj.datas[info.row]){
  43. $("#quantityEXPValue").focus();
  44. quantityEditObj.setToQuantityEXP(quantityEditObj.datas[info.row].code);
  45. quantityEditObj.spread.focus(false);
  46. }
  47. },
  48. setToQuantityEXP:function (value) {
  49. let oldVal = $("#quantityEXPValue").val();
  50. let startIndex = getCursor($("#quantityEXPValue")[0]);//取光标位置
  51. let strartString = oldVal.substring(0,startIndex);
  52. let endString = oldVal.substring(startIndex);
  53. $("#quantityEXPValue").val(strartString+value+endString);
  54. setCursor($("#quantityEXPValue")[0],startIndex+value.length);//设置回光标位置
  55. },
  56. getQuantityEditCellType:function () {//这个需配合整个表的selection change事件,当change的时候会repaint,按钮会显示
  57. var ns = GC.Spread.Sheets;
  58. function QuantityEditCellType() {
  59. var init=false;
  60. this.clickTime = 0; //点击事件时间戳
  61. }
  62. QuantityEditCellType.prototype = new ns.CellTypes.Text();
  63. QuantityEditCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  64. if(!projectReadOnly){
  65. if(options.sheet.getActiveRowIndex()==options.row&&options.sheet.getActiveColumnIndex()==options.col){
  66. var image = document.getElementById('f_btn'),imageMagin = 3;
  67. var imageHeight = 15;
  68. var imageWidth = 25;
  69. var imageX = x + w - imageWidth- imageMagin, imageY = y + h / 2 - imageHeight / 2;
  70. ctx.save();
  71. ctx.fillStyle = style.backColor;
  72. ctx.fillRect(x,y,w,h);
  73. ctx.drawImage(image, imageX, imageY,imageWidth,imageHeight);
  74. ctx.beginPath();
  75. ctx.arc(imageX+imageWidth/2,imageY+imageHeight/2,1,0,360,false);
  76. ctx.arc(imageX+imageWidth/2-4,imageY+imageHeight/2,1,0,360,false);
  77. ctx.arc(imageX+imageWidth/2+4,imageY+imageHeight/2,1,0,360,false);
  78. ctx.fillStyle="black";//填充颜色,默认是黑色
  79. ctx.fill();//画实心圆
  80. ctx.closePath();
  81. ctx.restore();
  82. w = w - imageWidth - imageMagin;
  83. }
  84. }
  85. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  86. };
  87. QuantityEditCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  88. return {
  89. x: x,
  90. y: y,
  91. row: context.row,
  92. col: context.col,
  93. cellStyle: cellStyle,
  94. cellRect: cellRect,
  95. sheetArea: context.sheetArea
  96. };
  97. };
  98. //2018 -09 -26 修改工程量这个输入控件,删除悬浮提示注释,还原时通过git 历史
  99. QuantityEditCellType.prototype.processMouseDown = function (hitinfo) {
  100. let me=quantityEditObj;
  101. if(hitinfo.sheet.getActiveRowIndex()==hitinfo.row&&hitinfo.sheet.getActiveColumnIndex()==hitinfo.col){
  102. var offset=hitinfo.cellRect.x+hitinfo.cellRect.width-6;
  103. var imageWidth = 25;
  104. if(hitinfo.x<offset&&hitinfo.x>offset-imageWidth){
  105. if(!projectReadOnly){
  106. me.showSelectModal(hitinfo);
  107. }
  108. }
  109. }
  110. };
  111. return new QuantityEditCellType();
  112. },
  113. showSelectModal:function (hitinfo) {
  114. //锁定的清单不显示
  115. let project = projectObj.project;
  116. if(project.mainTree.selected.sourceType == ModuleNames.bills && project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected)){
  117. return;
  118. }
  119. this.initModalContent(hitinfo);
  120. $("#quantityEXPEdit").modal({show:true});
  121. },
  122. initModalContent:function (hitinfo) {
  123. //现在改成有可能点击时,还没选中节点,所以要靠row来判断
  124. let selected = projectObj.project.mainTree.items[hitinfo.row];
  125. if(selected.sourceType == ModuleNames.ration){//暂时只有定额才有基数选择,所以其它的先隐藏表格
  126. $("#quantityEditSpread").show();//quantityEditSpread
  127. }else {
  128. $("#quantityEditSpread").hide();
  129. }
  130. $("#quantityEXPValue").val(selected.data.quantityEXP);
  131. selected.data.quantityEXP == "GCLMXHJ" || selected.data.quantityEXP =="MBGCL"?$("#quantityEXPValue").attr("disabled","disabled"):$("#quantityEXPValue").removeAttr("disabled");
  132. },
  133. checkingAndUpdate(quantityEXP,node){
  134. let me = this;
  135. /* if(quantityEXP === node.data.quantityEXP){ //没有变化,不做任何操作
  136. projectObj.mainController.refreshTreeNode([node]);
  137. return true;
  138. }*/
  139. quantityEXP = quantityEXP?quantityEXP.toUpperCase():'';//非空判断
  140. quantityEXP =replaceAll('(','(',quantityEXP);//转换中文左右符号
  141. quantityEXP =replaceAll(')',')',quantityEXP);
  142. let value = me.evalQuantityExp(quantityEXP,node);
  143. if(value!=='evalError'){
  144. if(node.data.hasOwnProperty('isFromDetail')&&node.data.isFromDetail==1){
  145. if(quantityEXP!="GCLMXHJ"){
  146. hintBox.infoBox('操作确认', '已有工程量明细,是否清空明细表?', 2, function () {
  147. node.data.isFromDetail=0;
  148. me.updateQuantityEXP(value,quantityEXP,node);
  149. }, function () {
  150. projectObj.mainController.refreshTreeNode([node]);
  151. },['确定','取消'],false);
  152. }else {//表达式已经是工程量明细合计了,重新刷新就可
  153. projectObj.mainController.refreshTreeNode([node]);
  154. }
  155. return true;
  156. }
  157. if(quantityEXP=="MBGCL") {
  158. projectObj.mainController.refreshTreeNode([node]);
  159. return true;
  160. }
  161. me.updateQuantityEXP(value,quantityEXP,node);
  162. return true;
  163. }else {
  164. projectObj.mainController.refreshTreeNode([node]);
  165. }
  166. return false;
  167. },
  168. evalQuantityExp(quantityEXP,node){
  169. let evalString = quantityEXP;
  170. if( node.sourceType == ModuleNames.ration && quantityEXP.indexOf('QDL')!=-1){
  171. let billNode = node.parent;
  172. let bQuantity = billNode.data.quantity?scMathUtil.roundForObj(billNode.data.quantity,getDecimal("quantity",billNode)):0;
  173. evalString = replaceAll("QDL","("+bQuantity+")",evalString);
  174. }
  175. try {
  176. let value = undefined;
  177. if(evalString&&evalString!=""){
  178. let exp = new Expression('');
  179. exp.Expression(evalString);
  180. value = Number(exp.Evaluate());
  181. }
  182. return value;
  183. }catch (error){
  184. alert("输入的表达式有误,请重新输入!");
  185. return "evalError";
  186. }
  187. },
  188. updateQuantityEXP:function (value,quantityEXP,node) {
  189. let quantity_detail = projectObj.project.quantity_detail;
  190. quantity_detail.cleanQuantityDetail(node,true);
  191. if(node.sourceType === ModuleNames.bills){
  192. quantity_detail.updateBillQuantity(value,node,quantityEXP,quantityEXP);
  193. }else {
  194. quantity_detail.updateRationQuantity(value,node,quantityEXP,quantityEXP);
  195. }
  196. }
  197. };
  198. $(function(){
  199. $('#quantityEXPEdit').on('shown.bs.modal', function (e) {
  200. projectObj.mainSpread.focus(false);
  201. quantityEditObj.initSpread();
  202. $("#quantityEXPValue").focus();
  203. });
  204. $('#operation_p').children("button").bind('click',function (){
  205. quantityEditObj.setToQuantityEXP($(this).text());
  206. $("#quantityEXPValue").focus();
  207. });
  208. $("#quantityEditConf").bind('click',function () {
  209. let selected = projectObj.project.mainTree.selected;
  210. let result = quantityEditObj.checkingAndUpdate($("#quantityEXPValue").val(),selected);
  211. if(result == true){
  212. $("#quantityEXPEdit").modal('hide');
  213. }
  214. })
  215. $('#quantityEXPEdit').bind('keypress', function (event) {
  216. if(event.keyCode === 13){
  217. $("#quantityEditConf").click();
  218. event.preventDefault();
  219. }
  220. });
  221. });
  222. function getCursor(elem) {
  223. //IE 9 ,10,其他浏览器
  224. if (elem.selectionStart !== undefined) {
  225. return elem.selectionStart;
  226. } else { //IE 6,7,8
  227. var range = document.selection.createRange();
  228. range.moveStart("character", -elem.value.length);
  229. var len = range.text.length;
  230. return len;
  231. }
  232. }
  233. function setCursor(elem, index) {
  234. //IE 9 ,10,其他浏览器
  235. if (elem.selectionStart !== undefined) {
  236. elem.selectionStart = index;
  237. elem.selectionEnd = index;
  238. } else { //IE 6,7,8
  239. var range = elem.createTextRange();
  240. range.moveStart("character", -elem.value.length); //左边界移动到起点
  241. range.move("character", index); //光标放到index位置
  242. range.select();
  243. }
  244. }
  245. function setSelection(elem, leftIndex, rightIndex) {
  246. if (elem.selectionStart !== undefined) { //IE 9 ,10,其他浏览器
  247. elem.selectionStart = leftIndex;
  248. elem.selectionEnd = rightIndex;
  249. } else { //IE 6,7,8
  250. var range = elem.createTextRange();
  251. range.move("character", -elem.value.length); //光标移到0位置。
  252. //这里一定是先moveEnd再moveStart
  253. //因为如果设置了左边界大于了右边界,那么浏览器会自动让右边界等于左边界。
  254. range.moveEnd("character", rightIndex);
  255. range.moveStart("character", leftIndex);
  256. range.select();
  257. }
  258. }