ration_glj.js 9.8 KB

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