ration_glj.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293
  1. /**
  2. * Created by Tony on 2017/4/28.
  3. */
  4. var rationGLJOprObj = {
  5. sheet: null,
  6. currentRationItem: null,
  7. distTypeTree: null,
  8. cache: {},
  9. setting: {
  10. header:[
  11. {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@"},
  12. {headerName:"名称",headerWidth:400,dataCode:"name", dataType: "String"},
  13. {headerName:"单位",headerWidth:160,dataCode:"unit", dataType: "String"},
  14. {headerName:"基价单位",headerWidth:160, dataCode:"basePrice", dataType: "Number", formatter:"0.00", precision: 2},
  15. {headerName:"定额消耗",headerWidth:160, dataCode:"consumeAmt", dataType: "Number", precision: 3},
  16. {headerName:"类型",headerWidth:160,dataCode:"gljType", dataType: "String"}
  17. ],
  18. view:{
  19. comboBox:[],
  20. lockColumns:[1,2,3,5,6]
  21. }
  22. },
  23. getDistTypeTree: function (gljDistType) {
  24. let me = this;
  25. let distType;
  26. let distTypeTree = {
  27. prefix : 'gljDistType',
  28. distTypes: {},
  29. comboDatas: [],
  30. distTypesArr: []
  31. };
  32. gljDistType.forEach(function (typeData) {
  33. let typeObj = {
  34. data: typeData,
  35. children: [],
  36. parent: null
  37. }
  38. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  39. distTypeTree.distTypesArr.push(typeObj);
  40. });
  41. gljDistType.forEach(function (typeData) {
  42. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  43. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  44. if(parent){
  45. distType.parent = parent;
  46. parent.children.push(distType);
  47. }
  48. });
  49. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  50. if(distTypeObj.children.length === 0 && distTypeObj.data.fullName !== '普通机械' &&distTypeObj.data.fullName !== '机械组成物'
  51. && distTypeObj.data.fullName !== '机上人工'){
  52. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  53. }
  54. if(distTypeObj.data.fullName === '机械'){
  55. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  56. }
  57. });
  58. //me.distTypeTree = distTypeTree;
  59. return distTypeTree;
  60. //return distTypeTree.comboDatas;
  61. },
  62. getGljDistType: function (callback) {
  63. let me = this;
  64. $.ajax({
  65. type: 'post',
  66. url: "api/getGljDistType",
  67. dataType: 'json',
  68. success: function (result) {
  69. if(!result.error && callback){
  70. me.distTypeTree = me.getDistTypeTree(result.data);
  71. callback();
  72. }
  73. }
  74. })
  75. },
  76. buildSheet: function(sheet) {
  77. var me = this;
  78. me.sheet = sheet;
  79. me.getGljDistType(function () {
  80. sheetCommonObj.initSheet(me.sheet, me.setting, 30);
  81. me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  82. me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  83. me.sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  84. me.sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  85. });
  86. },
  87. onRangeChanged: function(sender, args) {
  88. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  89. var me = rationGLJOprObj, updateArr = [], removeArr = [];
  90. if (args.col == 0) {
  91. if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
  92. var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
  93. for (var i = args.rowCount - 1; i >= 0; i--) {
  94. if (args.row + i < cacheArr.length) {
  95. cacheArr.splice(args.row + i, 1);
  96. }
  97. }
  98. me.updateRationItem();
  99. sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
  100. me.showGljItems(me.currentRationItem.ID);
  101. }
  102. }
  103. }
  104. },
  105. onClipboardPasting: function(sender, args) {
  106. var me = rationGLJOprObj;
  107. if (args.cellRange.colCount != 1 || args.cellRange.col != 0 || !(me.currentRationItem)) {
  108. args.cancel = true;
  109. }
  110. },
  111. onClipboardPasted: function(e, info) {
  112. var me = rationGLJOprObj, repId = storageUtil.getSessionCache("RationGrp","repositoryID");
  113. if (repId) {
  114. if (info.cellRange.col == 0) {
  115. var tmpCodes = sheetCommonObj.analyzePasteData({header:[{dataCode: "code"}] }, info);
  116. var codes = [];
  117. for (var i = 0; i < tmpCodes.length; i++) {
  118. codes.push(tmpCodes[i].code);
  119. }
  120. me.addGljItems(codes, repId);
  121. } else {
  122. //修改用量
  123. }
  124. }
  125. },
  126. onCellEditEnd: function(sender, args){
  127. var me = rationGLJOprObj;
  128. if (args.col != 0) {
  129. var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
  130. if (args.row < cacheArr.length) {
  131. var editGlj = cacheArr[args.row];
  132. if (editGlj["consumeAmt"] != args.editingText) {
  133. editGlj["consumeAmt"] = args.editingText;
  134. me.updateRationItem();
  135. }
  136. }
  137. } else {
  138. //重新更新工料机
  139. if (args.editingText == null || args.editingText.trim() == "") {
  140. //delete
  141. if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
  142. var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
  143. if (args.row < cacheArr.length) {
  144. cacheArr.splice(args.row, 1);
  145. me.updateRationItem();
  146. sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
  147. me.showGljItems(me.currentRationItem.ID);
  148. }
  149. }
  150. } else {
  151. var repId = storageUtil.getSessionCache("RationGrp","repositoryID");
  152. if (repId) {
  153. var codes = [];
  154. codes.push(args.editingText.trim());
  155. me.addGljItems(codes, repId);
  156. }
  157. }
  158. }
  159. },
  160. addGljItems: function(codes, repId) {
  161. var me = this;
  162. $.ajax({
  163. type:"POST",
  164. url:"api/getGljItemsByCodes",
  165. data:{"gljCodes": JSON.stringify(codes), repId: repId},
  166. dataType:"json",
  167. cache:false,
  168. timeout:5000,
  169. success:function(result){
  170. sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
  171. if (result) {
  172. var rstArr = [], dummyR = {gljId: 0, consumeAmt:0}, newAddArr = [];
  173. for (var i = 0; i < result.data.length; i++) {
  174. dummyR.gljId = result.data[i].ID;
  175. rstArr.push(me.createRationGljDisplayItem(dummyR, result.data[i]));
  176. }
  177. if (me.cache["_GLJ_" + me.currentRationItem.ID]) {
  178. var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
  179. for (var i = 0; i < rstArr.length; i++) {
  180. var hasDup = false;
  181. for (var j = 0; j < cacheArr.length; j++) {
  182. if (cacheArr[j].gljId == rstArr[i].gljId) {
  183. hasDup = true;
  184. break;
  185. }
  186. }
  187. if (!hasDup) {
  188. newAddArr.push(rstArr[i]);
  189. }
  190. }
  191. cacheArr.sort(function(a, b) {
  192. var rst = 0;
  193. if (a.code > b.code) rst = 1
  194. else if (a.code < b.code) rst = -1;
  195. return rst;
  196. });
  197. me.cache["_GLJ_" + me.currentRationItem.ID] = cacheArr.concat(newAddArr);
  198. }
  199. me.showGljItems(me.currentRationItem.ID);
  200. if (newAddArr.length > 0) {
  201. me.updateRationItem();
  202. }
  203. }
  204. sheetCommonObj.lockCells(me.sheet, me.setting);
  205. },
  206. error:function(err){
  207. alert(err);
  208. }
  209. })
  210. },
  211. updateRationItem: function() {
  212. var me = this, updateArr = [];
  213. if (me.currentRationItem) {
  214. me.currentRationItem.rationGljList = me.buildRationItemGlj();
  215. updateArr.push(me.currentRationItem);
  216. rationOprObj.mixUpdateRequest(updateArr, [], []);
  217. }
  218. },
  219. buildRationItemGlj: function(){
  220. var me = this, rst = [];
  221. if (me.currentRationItem && me.cache["_GLJ_" + me.currentRationItem.ID]) {
  222. var cacheArr = me.cache["_GLJ_" + me.currentRationItem.ID];
  223. for (var i = 0; i < cacheArr.length; i++) {
  224. rst.push({gljId: cacheArr[i].gljId, consumeAmt: cacheArr[i].consumeAmt, proportion: 0});
  225. }
  226. }
  227. return rst;
  228. },
  229. createRationGljDisplayItem: function(rItem, repGlj) {
  230. var rst = {};
  231. rst.gljId = rItem.gljId;
  232. rst.consumeAmt = rItem.consumeAmt;
  233. rst.code = repGlj.code;
  234. rst.name = repGlj.name;
  235. rst.specs = repGlj.specs;
  236. rst.unit = repGlj.unit;
  237. rst.basePrice = repGlj.basePrice;
  238. rst.gljType = repGlj.gljType;
  239. return rst;
  240. },
  241. getGljItems: function(rationItem) {
  242. var me = this, rationID = rationItem.ID, rationGljList = rationItem.rationGljList;
  243. me.currentRationItem = rationItem;
  244. if (me.cache["_GLJ_" + rationID]) {
  245. me.showGljItems(rationID);
  246. sheetCommonObj.lockCells(me.sheet, me.setting);
  247. } else {
  248. var gljIds = [];
  249. for (var i = 0; i < rationGljList.length; i++) {
  250. gljIds.push(rationGljList[i].gljId);
  251. }
  252. $.ajax({
  253. type:"POST",
  254. url:"api/getGljItemsByIds",
  255. data:{"gljIds": JSON.stringify(gljIds)},
  256. dataType:"json",
  257. cache:false,
  258. timeout:5000,
  259. success:function(result){
  260. sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
  261. if (result) {
  262. var cacheArr = [];
  263. for (var i = 0; i < result.data.length; i++) {
  264. for (var j = 0; j < rationGljList.length; j++) {
  265. if (rationGljList[j].gljId == result.data[i].ID) {
  266. cacheArr.push(me.createRationGljDisplayItem(rationGljList[j], result.data[i]));
  267. break;
  268. }
  269. }
  270. }
  271. me.cache["_GLJ_" + rationID] = cacheArr;
  272. me.showGljItems(rationID);
  273. }
  274. sheetCommonObj.lockCells(me.sheet, me.setting);
  275. },
  276. error:function(err){
  277. alert(err);
  278. }
  279. })
  280. }
  281. },
  282. showGljItems: function(rationID) {
  283. var me = this;
  284. if (me.cache["_GLJ_" + rationID]) {
  285. sheetCommonObj.showData(me.sheet, me.setting, me.cache["_GLJ_" + rationID], me.distTypeTree);
  286. }
  287. }
  288. }