material.js 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290
  1. 'use strict';
  2. /**
  3. * 材料调差 - 调差工料
  4. *
  5. * @author Mai
  6. * @date 2019/1/16
  7. * @version
  8. */
  9. function loadUpdateMaterials(newMaterial, fields) {
  10. const newMaterials = newMaterial instanceof Array ? newMaterial : [newMaterial];
  11. for (const nm of newMaterials) {
  12. const om = _.find(materialBillsData, {id: nm.id});
  13. for (const prop in nm) {
  14. if (!fields || fields.indexOf(prop) >= 0) {
  15. om[prop] = nm[prop];
  16. }
  17. }
  18. }
  19. }
  20. $(document).ready(() => {
  21. autoFlashHeight();
  22. const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]);
  23. const materialSpreadSetting = {
  24. cols: [
  25. {title: '调差类型', colSpan: '1', rowSpan: '2', field: 't_type', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.t_type, cellTypeKey: 1},
  26. {title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
  27. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 180, formatter: '@', readOnly: 'readOnly.isEdit'},
  28. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
  29. {title: '规格', colSpan: '1', rowSpan: '2', field: 'spec', hAlign: 0, width: 180, formatter: '@', readOnly: 'readOnly.isEdit'},
  30. {title: '工料分类', colSpan: '1', rowSpan: '2', field: 'm_type', hAlign: 0, width: 60, readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.m_type, cellTypeKey: 2},
  31. {title: '本期应耗数量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  32. {title: '基准价', colSpan: '1', rowSpan: '2', field: 'basic_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
  33. {title: '基准时间', colSpan: '1', rowSpan: '2', field: 'basic_times', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
  34. {title: '本期信息价|单价', colSpan: '3|1', rowSpan: '1|1', field: 'msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
  35. {title: '|时间', colSpan: '|1', rowSpan: '|1', field: 'msg_times', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isEdit'},
  36. {title: '|价差', colSpan: '1', rowSpan: '1|1', field: 'msg_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.msg_spread'},
  37. {title: '本期材料调差|上涨幅度(%)', colSpan: '4|1', rowSpan: '1|1', field: 'm_up_risk', hAlign: 2, width: 100, type: 'Number', readOnly: 'readOnly.isEdit'},
  38. {title: '|下跌幅度(%)', colSpan: '|1', rowSpan: '|1', field: 'm_down_risk', hAlign: 2, width: 100, type: 'Number', readOnly: 'readOnly.isEdit'},
  39. {title: '|有效价差', colSpan: '|1', rowSpan: '|1', field: 'm_spread', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
  40. {title: '|调整金额', colSpan: '|1', rowSpan: '1|1', field: 'm_tp', hAlign: 2, width: 80, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
  41. {title: '截止上期调差金额', colSpan: '1', rowSpan: '2', field: 'pre_tp', hAlign: 2, width: 120, type: 'Number', readOnly: true},
  42. {title: '备注', colSpan: '1', rowSpan: '2', field: 'remark', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.remark'},
  43. ],
  44. emptyRows: 0,
  45. headRows: 2,
  46. headRowHeight: [25, 25],
  47. defaultRowHeight: 21,
  48. headerFont: '12px 微软雅黑',
  49. font: '12px 微软雅黑',
  50. readOnly: readOnly,
  51. };
  52. const materialBase = {
  53. isEdit: function (data) {
  54. return materialListData.find(function (item) {
  55. return item.mb_id === data.id;
  56. });
  57. },
  58. // isStage: function (data) {
  59. // return data.mid === materialID;
  60. // }
  61. }
  62. const materialCol = {
  63. getValue: {
  64. msg_spread: function (data) {
  65. return ZhCalc.round(ZhCalc.sub(data.msg_tp, data.basic_price), 2);
  66. },
  67. m_spread : function (data) {
  68. const msg_spread = materialCol.getValue.msg_spread(data);
  69. const cor = msg_spread >= 0 ? ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_up_risk, 100)) : ZhCalc.mul(data.basic_price, ZhCalc.div(data.m_down_risk, 100));
  70. return Math.abs(msg_spread) > Math.abs(cor) ? (msg_spread > 0 ? ZhCalc.round(ZhCalc.sub(msg_spread, cor), 2) : ZhCalc.round(ZhCalc.add(msg_spread, cor), 2)) : 0;
  71. },
  72. m_tp: function (data) {
  73. return ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), 2);
  74. }
  75. },
  76. readOnly: {
  77. isEdit: function (data) {
  78. return !(!readOnly && materialBase.isEdit(data) === undefined);
  79. },
  80. remark: function () {
  81. return readOnly;
  82. },
  83. },
  84. };
  85. SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
  86. SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
  87. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  88. const materialSpreadObj = {
  89. refreshActn: function () {
  90. const setObjEnable = function (obj, enable) {
  91. if (enable) {
  92. obj.removeClass('disabled');
  93. } else {
  94. obj.addClass('disabled');
  95. }
  96. };
  97. const sheet = materialSpread.getActiveSheet();
  98. const select = SpreadJsObj.getSelectObject(sheet);
  99. // 还需判断是否已被调差清单调用
  100. setObjEnable($('#del'), !readOnly && select && materialBase.isEdit(select) === undefined);
  101. },
  102. add: function () {
  103. const sheet = materialSpread.getActiveSheet();
  104. postData(window.location.pathname + '/save', {type: 'add'}, function (result) {
  105. if (result) {
  106. materialBillsData.push(result);
  107. sheet.addRows(materialBillsData.length - 1, 1);
  108. SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
  109. sheet.setSelection(materialBillsData.length - 1, 0, 1, 1);
  110. materialSpreadObj.refreshActn();
  111. }
  112. });
  113. },
  114. del: function () {
  115. const sheet = materialSpread.getActiveSheet();
  116. const select = SpreadJsObj.getSelectObject(sheet);
  117. postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
  118. const index = materialBillsData.indexOf(select);
  119. materialBillsData.splice(index, 1);
  120. sheet.deleteRows(index, 1);
  121. SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  122. const sel = sheet.getSelections();
  123. sheet.setSelection(index > 0 ? index - 1 : 0, sel.length > 0 ? sel[0].col : 0, 1, 1);
  124. materialSpreadObj.refreshActn();
  125. });
  126. },
  127. selectionChanged: function (e, info) {
  128. materialSpreadObj.refreshActn();
  129. const sel = info.sheet.getSelections()[0];
  130. const col = info.sheet.zh_setting.cols[sel.col];
  131. const data = SpreadJsObj.getSelectObject(info.sheet);
  132. materialSpreadObj.setReadOnly(true);
  133. },
  134. editEnded: function (e, info) {
  135. if (info.sheet.zh_setting) {
  136. const select = SpreadJsObj.getSelectObject(info.sheet);
  137. const col = info.sheet.zh_setting.cols[info.col];
  138. // 未改变值则不提交
  139. const validText = info.editingText ? (typeof(info.editingText) === 'String' ? info.editingText.replace('\n', '') : info.editingText) : null;
  140. const orgValue = select[col.field];
  141. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  142. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  143. return;
  144. }
  145. // 判断部分值是否输入的是数字判断和数据计算
  146. if (col.field === 'basic_price') {
  147. if (isNaN(validText)) {
  148. toastr.error('不能输入其它非数字类型字符');
  149. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  150. return;
  151. }
  152. const num = parseFloat(validText);
  153. if (num < 0 || !/^\d+(\.\d{1,3})?$/.test(num)) {
  154. toastr.error('请输入大于0并且小于3位小数的浮点数');
  155. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  156. return;
  157. }
  158. }
  159. if (col.field === 'msg_tp') {
  160. if (isNaN(validText)) {
  161. toastr.error('不能输入其它非数字类型字符');
  162. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  163. return;
  164. }
  165. const num = parseFloat(validText);
  166. if (num < 0 || !/^\d+(\.\d{1,3})?$/.test(num)) {
  167. toastr.error('请输入大于0并且小于3位小数的浮点数');
  168. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  169. return;
  170. }
  171. }
  172. if (col.field === 'm_up_risk') {
  173. // 只能输入正整数
  174. if (isNaN(validText)) {
  175. toastr.error('不能输入其它非数字类型字符');
  176. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  177. return;
  178. }
  179. const num = parseFloat(validText);
  180. if (num < 0 || num > 100 || !/^\d+$/.test(num)) {
  181. toastr.error('只能输入0-100的正整数');
  182. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  183. return;
  184. }
  185. }
  186. if (col.field === 'm_down_risk') {
  187. // 只能输入正整数
  188. if (isNaN(validText)) {
  189. toastr.error('不能输入其它非数字类型字符');
  190. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  191. return;
  192. }
  193. const num = parseFloat(validText);
  194. if (num < 0 || num > 100 || !/^\d+$/.test(num)) {
  195. toastr.error('只能输入0-100的正整数');
  196. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  197. return;
  198. }
  199. }
  200. select[col.field] = validText;
  201. select.msg_spread = materialCol.getValue.msg_spread(select);
  202. select.m_spread = materialCol.getValue.m_spread(select);
  203. select.m_tp = materialCol.getValue.m_tp(select);
  204. // 更新至服务器
  205. postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
  206. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  207. }, function () {
  208. select[col.field] = orgValue;
  209. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  210. });
  211. }
  212. },
  213. setReadOnly: function(readOnly) {
  214. SpreadJsObj.resetFieldReadOnly(materialSpread.getActiveSheet(), 'msg_spread', 'm_spread', 'm_tp', 'pre_tp', readOnly);
  215. }
  216. };
  217. materialSpreadObj.refreshActn();
  218. materialSpread.bind(spreadNS.Events.SelectionChanged, materialSpreadObj.selectionChanged);
  219. if (!readOnly) {
  220. $('#add').click(materialSpreadObj.add);
  221. $('#del').click(materialSpreadObj.del);
  222. materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded);
  223. // 右键菜单
  224. $.contextMenu({
  225. selector: '#material-spread',
  226. build: function ($trigger, e) {
  227. const target = SpreadJsObj.safeRightClickSelection($trigger, e, materialSpread);
  228. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  229. },
  230. items: {
  231. 'create': {
  232. name: '新增材料',
  233. icon: 'fa-sign-in',
  234. callback: function (key, opt) {
  235. materialSpreadObj.add(materialSpread.getActiveSheet());
  236. },
  237. },
  238. 'delete': {
  239. name: '删除材料',
  240. icon: 'fa-remove',
  241. callback: function (key, opt) {
  242. materialSpreadObj.del(materialSpread.getActiveSheet());
  243. },
  244. disabled: function (key, opt) {
  245. const sheet = materialSpread.getActiveSheet();
  246. const select = SpreadJsObj.getSelectObject(sheet);
  247. materialSpreadObj.refreshActn();
  248. if (!readOnly && select && materialBase.isEdit(select) === undefined) {
  249. return false;
  250. } else {
  251. return true;
  252. }
  253. }
  254. },
  255. }
  256. });
  257. $('#changeRate').change(function () {
  258. const rate = parseInt($(this).val());
  259. postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
  260. const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), 2);
  261. const jzbqhs = ZhCalc.round(ZhCalc.mul(ZhCalc.add(pre_tp, m_tp), 1+rate/100), 2);
  262. $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
  263. $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
  264. });
  265. })
  266. } else {
  267. // SpreadJsObj.forbiddenSpreadContextMenu('#material-spread', materialSpread);
  268. }
  269. $.subMenu({
  270. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  271. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  272. //key: 'stage.compare.memu.1.0.0',
  273. callback: function (info) {
  274. if (info.mini) {
  275. $('.panel-title').addClass('fluid');
  276. $('#sub-menu').removeClass('panel-sidebar');
  277. } else {
  278. $('.panel-title').removeClass('fluid');
  279. $('#sub-menu').addClass('panel-sidebar');
  280. }
  281. autoFlashHeight();
  282. materialSpread.refresh();
  283. }
  284. });
  285. });