material.js 118 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364
  1. 'use strict';
  2. /**
  3. * 材料调差 - 调差工料
  4. *
  5. * @author Mai
  6. * @date 2019/1/16
  7. * @version
  8. */
  9. // 编号排序,多重判断
  10. function sortByCode(a, b) {
  11. let code1 = a.code.split('-');
  12. let code2 = b.code.split('-');
  13. let code1length = code1.length;
  14. let code2length = code2.length;
  15. for (let i = 0; i < code1length; i ++) {
  16. if (i+1 <= code2length) {
  17. if (code1[i] != code2[i]) {
  18. if (/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
  19. return parseInt(code1[i]) - parseInt(code2[i]);
  20. } else if (!/^\d+$/.test(code1[i]) && /^\d+$/.test(code2[i])) {
  21. return 1;
  22. } else if (/^\d+$/.test(code1[i]) && !/^\d+$/.test(code2[i])) {
  23. return -1;
  24. } else {
  25. const str1length = code1[i].length;
  26. const str2length = code2[i].length;
  27. for (let j = 0; j < str1length; j++) {
  28. if (j+1 <= str2length) {
  29. if (code1[i].charAt(j) != code2[i].charAt(j)) {
  30. return code1[i].charAt(j).charCodeAt() - code2[i].charAt(j).charCodeAt();
  31. } else if (j+1 == str1length && code1[i].charAt(j) == code2[i].charAt(j)) {
  32. if (str1length == str2length) {
  33. return 0;
  34. } else {
  35. return str1length - str2length;
  36. }
  37. }
  38. } else {
  39. if (j+1 >= str1length) {
  40. return 1;
  41. } else {
  42. return -1;
  43. }
  44. }
  45. }
  46. }
  47. } else if (i+1 == code1length && code1[i] == code2[i]) {
  48. if (code1length == code2length) {
  49. return 0;
  50. } else {
  51. return code1length - code2length;
  52. }
  53. }
  54. } else {
  55. if (i+1 >= code1length) {
  56. return 1;
  57. } else {
  58. return -1;
  59. }
  60. }
  61. }
  62. }
  63. function loadUpdateMaterials(newMaterial, fields) {
  64. const newMaterials = newMaterial instanceof Array ? newMaterial : [newMaterial];
  65. for (const nm of newMaterials) {
  66. const om = _.find(materialBillsData, {id: nm.id});
  67. for (const prop in nm) {
  68. if (!fields || fields.indexOf(prop) >= 0) {
  69. om[prop] = nm[prop];
  70. }
  71. }
  72. }
  73. }
  74. function DatePickerCellType() {
  75. }
  76. DatePickerCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();
  77. DatePickerCellType.prototype.createEditorElement = function () {
  78. //Create input presenter.
  79. var input = document.createElement("input");
  80. return input;
  81. };
  82. DatePickerCellType.prototype.activateEditor = function (editorContext, cellStyle, cellRect) {
  83. //Initialize input editor.
  84. if (editorContext) {
  85. const $editor = $(editorContext);
  86. GC.Spread.Sheets.CellTypes.Base.prototype.activateEditor.apply(this, arguments);
  87. $editor.datepicker({});
  88. $editor.css("position", "absolute");
  89. $editor.attr("gcUIElement", "gcEditingInput");
  90. $(".ui-datepicker").attr("gcUIElement", "gcEditingInput");
  91. }
  92. }
  93. DatePickerCellType.prototype.deactivateEditor = function (editorContext) {
  94. //Remove input editor when end editor status.
  95. if (editorContext) {
  96. var element = editorContext;
  97. // $(element).datepicker().data('datepicker').hide();
  98. // $(element).datepicker().data('datepicker').destroy();
  99. $(element).datepicker("hide");
  100. $(element).datepicker("destroy");
  101. }
  102. GC.Spread.Sheets.CellTypes.Base.prototype.deactivateEditor.apply(this, arguments)
  103. };
  104. DatePickerCellType.prototype.setEditorValue = function (editor, value) {
  105. //Sync value from Cell value to editor value.
  106. // console.log($(editor), value);
  107. $(editor).datepicker("setDate", value);
  108. // $(editor).datepicker().data('datepicker').selectDate(value ? new Date(value) : new Date());
  109. };
  110. DatePickerCellType.prototype.getEditorValue = function (editor, context) {
  111. // console.log($(editor).datepicker().data('datepicker'), context);
  112. //Sync value from editor value to cell value.
  113. // console.log($(editor).datepicker("getDate"));
  114. // return $(editor).datepicker("getDate");
  115. return $(editor).val();
  116. };
  117. DatePickerCellType.prototype.updateEditor = function (editorContext, cellStyle, cellRect) {
  118. if (editorContext) {
  119. const $editor = $(editorContext);
  120. $editor.css("width", cellRect.width - 1);
  121. $editor.css("height", cellRect.height - 3);
  122. }
  123. };
  124. function resetTpTable() {
  125. $('#tp_set').find('td').eq(1).text(ZhCalc.round(m_tp, materialDecimal.tp));
  126. $('#tp_set').find('td').eq(2).text(ZhCalc.add(pre_tp, ZhCalc.round(m_tp, materialDecimal.tp)));
  127. let sum = 0;
  128. if (isStageSelf) {
  129. let html = '';
  130. const rate = $('#rateInput').val();
  131. for (const ms of materialStageData) {
  132. if (!materialTax) {
  133. sum = ZhCalc.add(sum, ZhCalc.round(ZhCalc.mul(ms.m_tp, 1+rate/100), materialDecimal.tp));
  134. }
  135. const taxHtml = ' <td class="text-center">' + (materialTax ? (ms.m_tax_tp !== null ? ms.m_tax_tp : '') : ZhCalc.round(ZhCalc.mul(ms.m_tp, 1+rate/100), materialDecimal.tp) ) + '</td>\n';
  136. html += '<tr><td>第' + ms.order + '期</td><td class="text-center">' + (ms.m_tp !== null ? ms.m_tp : '') + '</td>\n' +
  137. taxHtml +
  138. ' </tr>';
  139. }
  140. const allTaxHtml = ' <td class="text-center">' + (materialTax ? m_tax_tp : sum) + '</td>\n';
  141. html += '<tr><td>合计</td><td class="text-center">' + m_tp + '</td>\n' +
  142. allTaxHtml +
  143. ' </tr>';
  144. $('#materialStageTable').html(html);
  145. }
  146. if (materialTax) {
  147. $('#tax_rate_set').find('td').eq(1).text(ZhCalc.round(m_tax_tp, materialDecimal.tp));
  148. $('#tax_rate_set').find('td').eq(2).text(ZhCalc.add(m_tax_pre_tp, ZhCalc.round(m_tax_tp, materialDecimal.tp)));
  149. } else {
  150. const rate = $('#rateInput').val();
  151. const bqhs = isStageSelf ? sum : ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
  152. const jzbqhs = ZhCalc.add(pre_tp_hs, bqhs);
  153. $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
  154. $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
  155. }
  156. }
  157. function getPasteHint (str, row = '') {
  158. let returnObj = str;
  159. if (row) {
  160. returnObj.msg = '工料第' + (row+1) + '行' + str.msg;
  161. }
  162. return returnObj;
  163. }
  164. const is_numeric = (value) => {
  165. if (typeof(value) === 'object') {
  166. return false;
  167. } else {
  168. return !Number.isNaN(Number(value)) && value.toString().trim() !== '';
  169. }
  170. };
  171. $(document).ready(() => {
  172. autoFlashHeight();
  173. const materialSpread = SpreadJsObj.createNewSpread($('#material-spread')[0]);
  174. const materialSpreadSetting = {
  175. emptyRows: 0,
  176. headRows: 2,
  177. headRowHeight: [25, 32],
  178. defaultRowHeight: 21,
  179. headerFont: '12px 微软雅黑',
  180. font: '12px 微软雅黑',
  181. readOnly: readOnly,
  182. };
  183. let materialSpreadSettingCols = [
  184. {title: '调差类型', colSpan: '1', rowSpan: '2', field: 't_type', hAlign: 1, width: 60, formatter: '@', readOnly: 'readOnly.isUsed', cellType: 'customizeCombo', comboItems: materialType.t_type, cellTypeKey: 1},
  185. {title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: 'readOnly.isUsed'},
  186. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: 'readOnly.isEdit'},
  187. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: 'readOnly.isEdit'},
  188. {title: '规格', colSpan: '1', rowSpan: '2', field: 'spec', hAlign: 0, width: 150, formatter: '@', readOnly: 'readOnly.isEdit'},
  189. {title: '工料分类', colSpan: '1', rowSpan: '2', field: 'm_type', hAlign: 1, width: 60, readOnly: 'readOnly.isEdit', cellType: 'customizeCombo', comboItems: materialType.m_type, cellTypeKey: 2},
  190. ];
  191. if (materialTax) {
  192. materialSpreadSettingCols.push({title: '税率(%)', colSpan: '1', rowSpan: '2', field: 'm_tax', hAlign: 2, width: 50, type: 'Number', readOnly: editTaxPermission ? 'readOnly.remark' : 'readOnly.isEdit'});
  193. }
  194. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  195. {title: '上涨 幅度(%)', colSpan: '1', rowSpan: '2', field: 'm_up_risk', hAlign: 2, width: 50, type: 'Number', readOnly: 'readOnly.isEdit'},
  196. {title: '下跌 幅度(%)', colSpan: '1', rowSpan: '2', field: 'm_down_risk', hAlign: 2, width: 50, type: 'Number', readOnly: 'readOnly.isEdit'},
  197. {title: '基准价', colSpan: '1', rowSpan: '2', field: 'basic_price', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.isEdit'},
  198. {title: '基准时间', colSpan: '1', rowSpan: '2', field: 'basic_times', hAlign: 0, width: 70, formatter: '@', readOnly: 'readOnly.remark'},
  199. {title: '本期信息价|单价', colSpan: '3|1', rowSpan: '1|1', field: 'msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: 'readOnly.msg_tp'},
  200. {title: '|时间', colSpan: '|1', rowSpan: '|1', field: 'msg_times', hAlign: 0, width: 80, formatter: '@', readOnly: 'readOnly.remark'},
  201. {title: '|单价差', colSpan: '|1', rowSpan: '|1', field: 'msg_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.msg_spread'},]
  202. );
  203. if (materialTax) {
  204. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  205. {title: '本期材料调差|有效价差', colSpan: '4|1', rowSpan: '1|1', field: 'm_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
  206. {title: '|本期应耗数量', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 90, type: 'Number', readOnly: true},
  207. {title: '|调差金额', colSpan: '|1', rowSpan: '|1', field: 'm_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
  208. {title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'm_tax_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tax_tp'},
  209. {title: '截止上期|调差金额', colSpan: '2|1', rowSpan: '1|1', field: 'pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  210. {title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'tax_pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  211. ]);
  212. if (!isStageSelf) {
  213. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  214. {title: '截止本期|调差金额', colSpan: '2|1', rowSpan: '1|1', field: 'end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.end_tp'},
  215. {title: '|调差金额(材料税)', colSpan: '|1', rowSpan: '|1', field: 'tax_end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.tax_end_tp'},
  216. ]);
  217. }
  218. } else {
  219. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  220. {title: '本期材料调差|有效价差', colSpan: '3|1', rowSpan: '1|1', field: 'm_spread', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue: 'getValue.m_spread'},
  221. {title: '|本期应耗数量', colSpan: '|1', rowSpan: '|1', field: 'quantity', hAlign: 2, width: 90, type: 'Number', readOnly: true},
  222. {title: '|调差金额', colSpan: '|1', rowSpan: '|1', field: 'm_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.m_tp'},
  223. {title: '截止上期|调差金额', colSpan: '1|1', rowSpan: '1|1', field: 'pre_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true},
  224. ]);
  225. if (!isStageSelf) {
  226. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  227. {title: '截止本期|调差金额', colSpan: '1|1', rowSpan: '1|1', field: 'end_tp', hAlign: 2, width: 100, type: 'Number', readOnly: true, getValue: 'getValue.end_tp'},
  228. ]);
  229. }
  230. }
  231. materialSpreadSettingCols = _.concat(materialSpreadSettingCols, [
  232. {title: '备注', colSpan: '1', rowSpan: '2', field: 'remark', hAlign: 0, width: 50, formatter: '@', cellType: 'ellipsisAutoTip', readOnly: 'readOnly.remark'},
  233. {title: '是否汇总', colSpan: '1', rowSpan: '2', field: 'is_summary', hAlign: 1, width: 60, cellType: 'checkbox', readOnly: 'readOnly.isEdit'},
  234. ]);
  235. materialSpreadSetting.cols = materialSpreadSettingCols;
  236. const spCol = _.find(materialSpreadSetting.cols, {field: 'quantity'});
  237. spCol.readOnly = true;
  238. spCol.cellType = 'activeImageBtn';
  239. spCol.normalImg = '#ellipsis-icon';
  240. spCol.indent = 5;
  241. spCol.showImage = function (data) {
  242. // return !readOnly && data.t_type === 2 && data.mid === materialID;
  243. return data && data.t_type === 2;
  244. };
  245. materialSpreadSetting.imageClick = function (data) {
  246. if (data.t_type === 2) {
  247. $('#bcyy').modal('show');
  248. $('#materialbillsId').val(data.id);
  249. $('#expr').val(data.expr);
  250. if (!readOnly) {
  251. $('#expr').attr('readOnly', false);
  252. $('#expr_btn').show();
  253. $('#expr_select').show();
  254. } else {
  255. $('#expr').attr('readOnly', true);
  256. $('#expr_btn').hide();
  257. $('#expr_select').hide();
  258. }
  259. }
  260. };
  261. const materialBase = {
  262. isUsed: function (data) {
  263. if (data.t_type === 2) {
  264. return data.mid === materialID;
  265. } else {
  266. const mlInfo = _.find(materialListData, { mb_id: data.id });
  267. return data.mid === materialID && mlInfo === undefined;
  268. }
  269. },
  270. isEdit: function (data) {
  271. // if (data.t_type === 2) {
  272. // return data.mid === materialID;
  273. // } else {
  274. // const mlInfo = _.find(materialListData, { mb_id: data.id });
  275. // return data.mid === materialID && mlInfo === undefined;
  276. // }
  277. return data.mid === materialID;
  278. },
  279. // isStage: function (data) {
  280. // return data.mid === materialID;
  281. // }
  282. }
  283. const materialCol = {
  284. getValue: {
  285. msg_spread: function (data) {
  286. return ZhCalc.round(ZhCalc.sub(data.msg_tp, data.basic_price), materialDecimal.up);
  287. },
  288. m_spread : function (data) {
  289. const msg_spread = materialCol.getValue.msg_spread(data);
  290. 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));
  291. return Math.abs(msg_spread) > Math.abs(cor) ? (msg_spread > 0 ? ZhCalc.round(ZhCalc.sub(msg_spread, cor), materialDecimal.up) : ZhCalc.round(ZhCalc.add(msg_spread, cor), materialDecimal.up)) : 0;
  292. },
  293. m_tp: function (data) {
  294. return ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), materialDecimal.tp);
  295. },
  296. m_tax_tp: function (data) {
  297. const m_tp = ZhCalc.round(ZhCalc.mul(materialCol.getValue.m_spread(data), data.quantity), materialDecimal.tp);
  298. return data.m_tax ? ZhCalc.round(ZhCalc.mul(m_tp, (1+ZhCalc.div(data.m_tax, 100))), materialDecimal.tp) : m_tp;
  299. },
  300. end_tp: function (data) {
  301. return ZhCalc.add(data.m_tp, data.pre_tp) || '';
  302. },
  303. tax_end_tp: function (data) {
  304. return ZhCalc.add(data.m_tax_tp, data.tax_pre_tp) || '';
  305. }
  306. },
  307. readOnly: {
  308. isEdit: function (data) {
  309. return !(!readOnly && materialBase.isEdit(data));
  310. },
  311. isUsed: function (data) {
  312. return !(!readOnly && materialBase.isUsed(data));
  313. },
  314. remark: function () {
  315. return readOnly;
  316. },
  317. msg_tp: function () {
  318. return !(!readOnly && months.length === 0);
  319. }
  320. },
  321. };
  322. const needUpdateArray = ['quantity', 'expr', 'msg_tp', 'msg_times', 'msg_spread', 'm_spread', 'm_tp', 'm_tax_tp', 'is_summary', 'remark'];
  323. const materialSpreadObj = {
  324. getMaterialBillsData: function () {
  325. if (isStageSelf) {
  326. // 当前选中nav id
  327. const ms_id = $('#myTab').find('.active').data('msid');
  328. const msbList = _.filter(materialStageBillsData, { ms_id });
  329. for (const mb of materialBillsData) {
  330. mb.ms_id = ms_id;
  331. const msbInfo = _.find(msbList, { mb_id: mb.mb_id ? mb.mb_id : mb.id });
  332. if (msbInfo) {
  333. for (const nu of needUpdateArray) {
  334. mb[nu] = msbInfo[nu];
  335. }
  336. }
  337. }
  338. }
  339. return materialBillsData;
  340. },
  341. updateOneMaterialBill: function (data) {
  342. const ms_id = $('#myTab').find('.active').data('msid');
  343. const msbInfo = _.find(materialStageBillsData, { ms_id, mb_id: data.id });
  344. console.log(msbInfo);
  345. data.ms_id = ms_id;
  346. for (const nu of needUpdateArray) {
  347. data[nu] = msbInfo[nu];
  348. }
  349. return data;
  350. },
  351. updateMaterialData: function (datas) {
  352. if (datas.stageData && datas.stageData.length > 0) {
  353. if (datas.stageData.length === materialStageData.length) {
  354. // 全体替换
  355. materialStageData = datas.stageData;
  356. } else {
  357. // 替换对应的stage数据
  358. for (const s of datas.stageData) {
  359. const index = _.findIndex(materialStageData, { id: s.id });
  360. materialStageData.splice(index, 1, s);
  361. }
  362. }
  363. }
  364. if (datas.pushStageBillsData && datas.pushStageBillsData.length > 0) {
  365. materialStageBillsData = _.concat(materialStageBillsData, datas.pushStageBillsData);
  366. }
  367. if (datas.removeStageBillsData && datas.removeStageBillsData.length > 0) {
  368. materialStageBillsData = _.remove(materialStageBillsData, function (item) {
  369. return _.findIndex(datas.removeStageBillsData, { id: item.mb_id }) === -1
  370. })
  371. }
  372. if (datas.stageBillsData && datas.stageBillsData.length > 0) {
  373. if (datas.stageBillsData.length === materialStageBillsData.length) {
  374. // 全体替换
  375. materialStageBillsData = datas.stageBillsData;
  376. } else {
  377. // 替换对应的stage数据
  378. for (const s of datas.stageBillsData) {
  379. const index = _.findIndex(materialStageBillsData, { id: s.id });
  380. materialStageBillsData.splice(index, 1, s);
  381. }
  382. }
  383. }
  384. if (datas.billsData && datas.billsData.length > 0) {
  385. if (datas.billsData.length === materialBillsData.length) {
  386. // 全体替换
  387. materialBillsData = datas.billsData;
  388. materialSpreadObj.getMaterialBillsData();
  389. } else {
  390. for (const b of datas.billsData) {
  391. const index = _.findIndex(materialBillsData, {id: b.id});
  392. materialBillsData.splice(index, 1, b);
  393. materialSpreadObj.updateOneMaterialBill(materialBillsData[index]);
  394. }
  395. }
  396. }
  397. },
  398. materialSheetReset: function (redo = false) {
  399. let newMaterialBillsData = _.cloneDeep(materialBillsData);
  400. if($('#bills0_list').is(':checked')) {
  401. newMaterialBillsData = _.filter(materialBillsData, function (item) {
  402. return item.quantity !== null && item.quantity !== 0;
  403. });
  404. }
  405. if (redo) {
  406. materialSpread.getActiveSheet().reset();
  407. SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
  408. SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
  409. }
  410. console.log(newMaterialBillsData);
  411. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
  412. materialSpreadObj.refreshActn();
  413. },
  414. refreshActn: function (rowCount = 1) {
  415. const setObjEnable = function (obj, enable) {
  416. if (enable) {
  417. obj.removeClass('disabled');
  418. } else {
  419. obj.addClass('disabled');
  420. }
  421. };
  422. const sheet = materialSpread.getActiveSheet();
  423. const select = SpreadJsObj.getSelectObject(sheet);
  424. const selection = sheet.getSelections();
  425. const sel = selection ? selection[0] : sheet.getSelections()[0];
  426. const row = sel ? sel.row : -1;
  427. const first = materialBillsData[row];
  428. let last = first;
  429. if (sel.rowCount > 1 && first) {
  430. for (let r = 1; r < sel.rowCount; r++) {
  431. const rNode = materialBillsData[sel.row + r];
  432. if (!rNode) break;
  433. last = rNode;
  434. }
  435. }
  436. const preNode = materialBillsData[row - 1];
  437. // 还需判断是否已被调差清单调用
  438. setObjEnable($('#del'), !readOnly && select && materialBase.isUsed(select) && rowCount === 1);
  439. setObjEnable($('#up-move'), !readOnly && first && preNode && materialBillsData.indexOf(last) > 0 && sel.row + sel.rowCount <= materialBillsData.length && !$('#bills0_list').is(':checked'));
  440. setObjEnable($('#down-move'), !readOnly && first && materialBillsData.indexOf(last) < materialBillsData.length - 1 && sel.row + sel.rowCount <= materialBillsData.length && !$('#bills0_list').is(':checked'));
  441. },
  442. add: function () {
  443. const sheet = materialSpread.getActiveSheet();
  444. postData(window.location.pathname + '/save', {type: 'add'}, function (result) {
  445. if (result) {
  446. materialBillsData.push(result.info);
  447. if (isStageSelf) {
  448. materialSpreadObj.updateMaterialData(result);
  449. materialSpreadObj.getMaterialBillsData();
  450. }
  451. // sheet.addRows(materialBillsData.length - 1, 1);
  452. // SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
  453. let newMaterialBillsData = materialBillsData;
  454. if($('#bills0_list').is(':checked')) {
  455. newMaterialBillsData = _.filter(materialBillsData, function (item) {
  456. return item.quantity !== null && item.quantity !== 0;
  457. });
  458. }
  459. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
  460. // materialSpreadObj.materialSheetReset();
  461. sheet.setSelection(newMaterialBillsData.length - 1, 0, 1, 1);
  462. console.log(sheet);
  463. materialSpreadObj.refreshActn();
  464. // 月信息价需要同时添加空白的list
  465. if (months.length > 0) {
  466. const one_month ={ mb_id: result.info.id, code: '', name: null, origin: null, unit: null, order: result.info.order };
  467. for (const m of months) {
  468. one_month[m] = null;
  469. }
  470. monthsList.push(one_month);
  471. // const newMonthsList = _.filter(monthsList, function (item) {
  472. // return _.findIndex(newMaterialBillsData, { code: item.code }) !== -1;
  473. // });
  474. // materialMonthSpread.getActiveSheet().addRows(newMonthsList.length - 1, 1);
  475. // SpreadJsObj.reLoadRowData(materialMonthSpread.getActiveSheet(), newMonthsList.length - 1);
  476. monthFunGather.monthsListSet();
  477. // materialMonthSpreadObj.monthsListSet();
  478. }
  479. }
  480. });
  481. },
  482. del: function () {
  483. const sheet = materialSpread.getActiveSheet();
  484. const select = SpreadJsObj.getSelectObject(sheet);
  485. const sel = sheet.getSelections();
  486. postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
  487. m_tp = result.m_tp;
  488. if (materialTax) {
  489. m_tax_tp = result.m_tax_tp;
  490. }
  491. const index = _.findIndex(materialBillsData, { id: select.id });
  492. materialBillsData.splice(index, 1);
  493. if (isStageSelf) {
  494. result.removeStageBillsData = [{ id: select.id }];
  495. materialSpreadObj.updateMaterialData(result);
  496. materialSpreadObj.getMaterialBillsData();
  497. }
  498. let newMaterialBillsData = materialBillsData;
  499. let newIndex = index;
  500. if($('#bills0_list').is(':checked')) {
  501. newMaterialBillsData = _.filter(materialBillsData, function (item) {
  502. return item.quantity !== null && item.quantity !== 0;
  503. });
  504. newIndex = _.findIndex(newMaterialBillsData, { id: select.id });
  505. }
  506. // sheet.deleteRows(newIndex, 1);
  507. // sheet.zh_data.splice(newIndex, 1);
  508. materialSpreadObj.materialSheetReset(true);
  509. resetTpTable();
  510. // SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  511. sheet.setSelection(newIndex > 0 ? newIndex - 1 : 0, sel.length > 0 ? sel[0].col : 0, 1, 1);
  512. materialSpreadObj.refreshActn();
  513. // 月信息价需要同时删除
  514. if (months.length > 0) {
  515. monthsList.splice(index, 1);
  516. materialMonthSpread.getActiveSheet().deleteRows(newIndex, 1);
  517. // SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  518. }
  519. });
  520. },
  521. upMove: function () {
  522. if($('#bills0_list').is(':checked')) {
  523. return;
  524. }
  525. const data = {
  526. type: 'changeOrder',
  527. postData: [],
  528. };
  529. const sheet = materialSpread.getActiveSheet();
  530. const selection = sheet.getSelections();
  531. const row = selection[0].row, count = selection[0].rowCount;
  532. const first = sheet.zh_data[row];
  533. if (!first) {
  534. materialSpreadObj.refreshActn();
  535. return false;
  536. }
  537. const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id};
  538. for (let iRow = 0; iRow < count; iRow++) {
  539. const posData = sheet.zh_data[iRow + row];
  540. if (posData) {
  541. data.postData.push({id: posData.id, order: sheet.zh_data[iRow + row - 1].order});
  542. preUpdate.order = posData.order;
  543. }
  544. }
  545. console.log(monthsList);
  546. data.postData.push(preUpdate);
  547. console.log(data);
  548. if (data.postData.length > 0) {
  549. postData(window.location.pathname + '/save', data, function () {
  550. _.forEach(data.postData, function (item) {
  551. const cl = _.find(materialBillsData, { id: item.id });
  552. cl.order = item.order;
  553. });
  554. materialBillsData.sort(function (a, b) {
  555. return a.order - b.order
  556. });
  557. SpreadJsObj.reLoadSheetData(sheet);
  558. const sel = selection[0];
  559. if (sel) {
  560. sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
  561. }
  562. if (months.length > 0) {
  563. _.forEach(data.postData, function (item) {
  564. const cl = _.find(monthsList, { mb_id: item.id });
  565. cl.order = item.order;
  566. });
  567. monthsList.sort(function (a, b) {
  568. return a.order - b.order
  569. });
  570. const materialMonthSheet = materialMonthSpread.getActiveSheet();
  571. SpreadJsObj.reLoadSheetData(materialMonthSheet);
  572. }
  573. materialSpreadObj.refreshActn();
  574. });
  575. }
  576. },
  577. downMove: function () {
  578. if($('#bills0_list').is(':checked')) {
  579. return;
  580. }
  581. const data = {
  582. type: 'changeOrder',
  583. postData: [],
  584. };
  585. const sheet = materialSpread.getActiveSheet();
  586. const selection = sheet.getSelections();
  587. const row = selection[0].row, count = selection[0].rowCount;
  588. const first = sheet.zh_data[row];
  589. if (!first) {
  590. materialSpreadObj.refreshActn();
  591. return false;
  592. }
  593. const next = sheet.zh_data[row + count], nextUpdate = {id: next.id};
  594. for (let iRow = count - 1; iRow >= 0; iRow--) {
  595. const posData = sheet.zh_data[iRow + row];
  596. if (posData) {
  597. data.postData.push({id: posData.id, order: sheet.zh_data[iRow + row + 1].order});
  598. nextUpdate.order = posData.order;
  599. }
  600. }
  601. data.postData.push(nextUpdate);
  602. console.log(data);
  603. if (data.postData.length > 0) {
  604. postData(window.location.pathname + '/save', data, function () {
  605. _.forEach(data.postData, function (item) {
  606. const cl = _.find(materialBillsData, { id: item.id });
  607. cl.order = item.order;
  608. });
  609. materialBillsData.sort(function (a, b) {
  610. return a.order - b.order
  611. });
  612. SpreadJsObj.reLoadSheetData(sheet);
  613. const sel = selection[0];
  614. if (sel) {
  615. sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
  616. }
  617. if (months.length > 0) {
  618. _.forEach(data.postData, function (item) {
  619. const cl = _.find(monthsList, { mb_id: item.id });
  620. cl.order = item.order;
  621. });
  622. monthsList.sort(function (a, b) {
  623. return a.order - b.order
  624. });
  625. const materialMonthSheet = materialMonthSpread.getActiveSheet();
  626. SpreadJsObj.reLoadSheetData(materialMonthSheet);
  627. }
  628. materialSpreadObj.refreshActn();
  629. });
  630. }
  631. },
  632. selectionChanged: function (e, info) {
  633. const sel = info.sheet.getSelections()[0];
  634. const col = info.sheet.zh_setting.cols[sel.col];
  635. materialSpreadObj.refreshActn(sel.rowCount);
  636. const data = SpreadJsObj.getSelectObject(info.sheet);
  637. materialSpreadObj.setReadOnly(true);
  638. // console.log(data);
  639. setCurBillSourceList(data ? (data.mb_id || data.id) : null, $('#myTab').find('.active').data('msid') || null);
  640. },
  641. editEnded: function (e, info) {
  642. if (info.sheet.zh_setting) {
  643. const select = SpreadJsObj.getSelectObject(info.sheet);
  644. const col = info.sheet.zh_setting.cols[info.col];
  645. if (col.field === 'is_summary') {
  646. return;
  647. }
  648. // 未改变值则不提交
  649. let validText = (col.type === 'Number' || col.field === 'm_type' || col.field === 't_type') && is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
  650. const orgValue = select[col.field];
  651. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  652. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  653. return;
  654. }
  655. // 判断部分值是否输入的是数字判断和数据计算
  656. if (col.field === 'basic_price') {
  657. if (isNaN(validText)) {
  658. toastr.error('不能输入其它非数字类型字符');
  659. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  660. return;
  661. }
  662. let num = parseFloat(validText);
  663. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  664. if (validText !== null && (num < 0 || !reg.test(num))) {
  665. toastr.warning('已保留'+ materialDecimal.up +'位小数');
  666. validText = ZhCalc.round(num, materialDecimal.up);
  667. }
  668. }
  669. if (col.field === 'msg_tp') {
  670. if (isNaN(validText)) {
  671. toastr.error('不能输入其它非数字类型字符');
  672. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  673. return;
  674. }
  675. const num = parseFloat(validText);
  676. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  677. if (validText !== null && (num < 0 || !reg.test(num))) {
  678. toastr.warning('已保留'+ materialDecimal.up +'位小数');
  679. validText = ZhCalc.round(num, materialDecimal.up);
  680. }
  681. }
  682. if (col.field === 'm_up_risk' || col.field === 'm_down_risk' || col.field === 'm_tax') {
  683. // 只能输入正整数
  684. if (isNaN(validText)) {
  685. toastr.error('不能输入其它非数字类型字符');
  686. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  687. return;
  688. }
  689. const num = parseFloat(validText);
  690. if (validText !== null && (num < 0 || num > 100 || !/^\d+$/.test(num))) {
  691. toastr.error('只能输入0-100的正整数');
  692. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  693. return;
  694. }
  695. }
  696. if (col.field === 't_type') {
  697. if (validText === 1) {
  698. select.quantity = null;
  699. select.expr = null;
  700. select.m_tp = null;
  701. }
  702. }
  703. select[col.field] = validText;
  704. select.msg_spread = materialCol.getValue.msg_spread(select);
  705. select.m_spread = materialCol.getValue.m_spread(select);
  706. select.m_tp = materialCol.getValue.m_tp(select);
  707. select.m_tax_tp = materialCol.getValue.m_tax_tp(select);
  708. delete select.waitingLoading;
  709. // console.log(select);
  710. // 更新至服务器
  711. postData(window.location.pathname + '/save', { type:'update', updateData: select, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
  712. m_tp = result.m_tp;
  713. if (materialTax) {
  714. m_tax_tp = result.m_tax_tp;
  715. }
  716. if (isStageSelf) {
  717. materialSpreadObj.updateMaterialData(result);
  718. }
  719. resetTpTable();
  720. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  721. // 判断如果是更改了编号,名称,单位,月信息价需要跟着改变值
  722. if (months.length > 0 && (col.field === 'code' || col.field === 'name' || col.field === 'unit')) {
  723. const index = _.findIndex(materialBillsData, { id: select.id });
  724. monthsList[index][col.field] = validText;
  725. monthFunGather.monthsListSet();
  726. }
  727. }, function () {
  728. select[col.field] = orgValue;
  729. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  730. });
  731. }
  732. },
  733. buttonClicked: function (e, info) {
  734. if (info.sheet.zh_setting) {
  735. const select = SpreadJsObj.getSelectObject(info.sheet);
  736. const col = info.sheet.zh_setting.cols[info.col];
  737. if (materialCol.readOnly.isEdit(select)) {
  738. return;
  739. }
  740. if (col.field === 'is_summary') {
  741. if (info.sheet.isEditing()) {
  742. info.sheet.endEdit(true);
  743. }
  744. select.is_summary = info.sheet.getValue(info.row, info.col) ? 1 : 0;
  745. delete select.waitingLoading;
  746. // 更新至服务器
  747. postData(window.location.pathname + '/save', { type:'update', updateData: select, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
  748. m_tp = result.m_tp;
  749. if (materialTax) {
  750. m_tax_tp = result.m_tax_tp;
  751. }
  752. if (isStageSelf) {
  753. materialSpreadObj.updateMaterialData(result);
  754. }
  755. resetTpTable();
  756. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  757. }, function () {
  758. select.is_summary = info.sheet.getValue(info.row, info.col) ? 0 : 1;
  759. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  760. });
  761. }
  762. }
  763. },
  764. deletePress: function (sheet) {
  765. return;
  766. },
  767. clipboardPasted(e, info) {
  768. const hint = {
  769. cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
  770. codeEmpty: {type: 'error', msg: '请先输入编号,并且不超过15个字符'},
  771. codeUsed: {type: 'error', msg: '该编号已存在,请重新输入。'},
  772. codeError: {type: 'error', msg: '编号为纯数字时,不能为小数'},
  773. numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
  774. riskCan: {type: 'error', msg: '只能粘贴0-100的正整数'},
  775. numberCan: {type: 'warning', msg: '已保留'+ materialDecimal.up +'位小数'},
  776. };
  777. const range = info.cellRange;
  778. const sortData = info.sheet.zh_data || [];
  779. if (info.cellRange.row + info.cellRange.rowCount > sortData.length) {
  780. toastMessageUniq(hint.cellError);
  781. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  782. SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
  783. SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  784. return;
  785. }
  786. if (sortData.length > 0 && range.col + range.colCount > 18) {
  787. toastMessageUniq(hint.cellError);
  788. SpreadJsObj.reLoadSheetHeader(materialSpread.getActiveSheet());
  789. SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  790. return;
  791. }
  792. const data = [];
  793. // const rowData = [];
  794. for (let iRow = 0; iRow < range.rowCount; iRow++) {
  795. let bPaste = true;
  796. const curRow = range.row + iRow;
  797. // const materialData = JSON.parse(JSON.stringify(sortData[curRow]));
  798. const materialData = { id: sortData[curRow].id };
  799. const hintRow = range.rowCount > 1 ? curRow : '';
  800. let sameCol = 0;
  801. for (let iCol = 0; iCol < range.colCount; iCol++) {
  802. const curCol = range.col + iCol;
  803. const colSetting = info.sheet.zh_setting.cols[curCol];
  804. if (!colSetting) continue;
  805. let validText = info.sheet.getText(curRow, curCol);
  806. validText = (colSetting.type === 'Number' || colSetting.field === 'm_type' || colSetting.field === 't_type') && is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
  807. const orgValue = sortData[curRow][colSetting.field];
  808. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  809. sameCol++;
  810. if (range.colCount === sameCol) {
  811. bPaste = false;
  812. }
  813. continue;
  814. }
  815. if (colSetting.field === 'code' && (validText === '' || validText.length > 15)) {
  816. toastMessageUniq(getPasteHint(hint.codeEmpty, hintRow));
  817. bPaste = false;
  818. continue;
  819. }
  820. if (colSetting.field === 'code' && validText.toString().indexOf('.') !== -1) {
  821. toastMessageUniq(getPasteHint(hint.codeError, hintRow));
  822. bPaste = false;
  823. continue;
  824. }
  825. if (colSetting.field === 'code' && _.find(sortData, { code: validText.toString() })) {
  826. toastMessageUniq(getPasteHint(hint.codeUsed, hintRow));
  827. bPaste = false;
  828. continue;
  829. }
  830. if (colSetting.field === 't_type' || colSetting.field === 'm_type') {
  831. continue;
  832. }
  833. if (colSetting.field === 'basic_price' || colSetting.field === 'msg_tp'
  834. || colSetting.field === 'm_up_risk' || colSetting.field === 'm_down_risk') {
  835. if (isNaN(validText)) {
  836. toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
  837. bPaste = false;
  838. continue;
  839. }
  840. const num = parseFloat(validText);
  841. if (colSetting.field === 'basic_price' || colSetting.field === 'msg_tp') {
  842. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  843. if (validText !== null && (num < 0 || !reg.test(num))) {
  844. toastMessageUniq(getPasteHint(hint.numberCan, hintRow));
  845. validText = ZhCalc.round(num, materialDecimal.up);
  846. }
  847. } else if (colSetting.field === 'm_up_risk' || colSetting.field === 'm_down_risk' || colSetting.field === 'm_tax') {
  848. if (validText !== null && (num < 0 || num > 100 || !/^\d+$/.test(num))) {
  849. toastMessageUniq(getPasteHint(hint.riskCan, hintRow));
  850. bPaste = false;
  851. continue;
  852. }
  853. }
  854. }
  855. materialData[colSetting.field] = validText;
  856. sortData[curRow][colSetting.field] = validText;
  857. }
  858. if (materialData.code === '' || materialData.code === null) {
  859. toastMessageUniq(getPasteHint(hint.codeEmpty, hintRow));
  860. bPaste = false;
  861. }
  862. if (bPaste) {
  863. materialData.msg_spread = materialCol.getValue.msg_spread(sortData[curRow]);
  864. materialData.m_spread = materialCol.getValue.m_spread(sortData[curRow]);
  865. materialData.m_tp = materialCol.getValue.m_tp(sortData[curRow]);
  866. materialData.m_tax_tp = materialCol.getValue.m_tax_tp(sortData[curRow]);
  867. data.push(materialData);
  868. // rowData.push(curRow);
  869. } else {
  870. SpreadJsObj.reLoadRowData(info.sheet, curRow);
  871. }
  872. }
  873. if (data.length === 0) {
  874. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  875. return;
  876. }
  877. // console.log(data);
  878. // 更新至服务器
  879. postData(window.location.pathname + '/save', { type:'paste', updateData: data, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
  880. materialBillsData = result.info;
  881. m_tp = result.m_tp;
  882. if (materialTax) {
  883. m_tax_tp = result.m_tax_tp;
  884. }
  885. if (isStageSelf) {
  886. materialSpreadObj.updateMaterialData(result);
  887. materialSpreadObj.getMaterialBillsData();
  888. }
  889. // SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  890. materialSpreadObj.materialSheetReset();
  891. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  892. // for (const row in rowData) {
  893. // materialBillsData.splice(index, 1, result.info[row]);
  894. // SpreadJsObj.reLoadRowData(info.sheet, row);
  895. // }
  896. if (months.length > 0) {
  897. for (const [i,m] of monthsList.entries()) {
  898. m.code = materialBillsData[i].code;
  899. m.name = materialBillsData[i].name;
  900. m.unit = materialBillsData[i].unit;
  901. m.origin = materialBillsData[i].origin;
  902. }
  903. // SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, monthsList);
  904. monthFunGather.monthsListSet();
  905. // SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  906. }
  907. resetTpTable();
  908. // materialSpreadObj.refreshActn();
  909. }, function () {
  910. // materialSpreadObj.refreshActn();
  911. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  912. return;
  913. });
  914. },
  915. setReadOnly: function(readOnly) {
  916. // SpreadJsObj.resetFieldReadOnly(materialSpread.getActiveSheet(), 'msg_spread', 'm_spread', 'm_tp', 'pre_tp', readOnly);
  917. }
  918. };
  919. materialSpread.bind(spreadNS.Events.SelectionChanged, materialSpreadObj.selectionChanged);
  920. materialSpread.bind(spreadNS.Events.ClipboardPasted, materialSpreadObj.clipboardPasted);
  921. SpreadJsObj.addDeleteBind(materialSpread, materialSpreadObj.deletePress);
  922. materialSpread.bind(spreadNS.Events.EditEnded, materialSpreadObj.editEnded);
  923. materialSpread.bind(spreadNS.Events.ButtonClicked, materialSpreadObj.buttonClicked);
  924. const sheet = materialSpread.getActiveSheet();
  925. sheet.suspendPaint();
  926. // materialSpreadObj.refreshActn();
  927. // const basic_range = sheet.getRange(-1, 8, -1, 1);
  928. // basic_range.cellType(new DatePickerCellType());
  929. // basic_range.formatter("yyyy-MM-dd");
  930. // const msg_range = sheet.getRange(-1, 10, -1, 1);
  931. // msg_range.cellType(new DatePickerCellType());
  932. // msg_range.formatter("yyyy-MM-dd");
  933. sheet.resumePaint();
  934. const static_cols = [
  935. {title: '编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 60, formatter: '@', readOnly: true},
  936. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 100, formatter: '@', readOnly: true},
  937. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  938. {title: '来源地', colSpan: '1', rowSpan: '2', field: 'origin', hAlign: 0, width: 70, formatter: '@', readOnly: 'readOnly.isEdit'},
  939. {title: '平均单价', colSpan: '1', rowSpan: '2', field: 'average_msg_tp', hAlign: 2, width: 60, type: 'Number', readOnly: true, getValue:'getValue.average_msg_tp'},
  940. ];
  941. // 月信息价方法集合
  942. const monthFunGather = {
  943. _setMonthHtml: function() {
  944. let html = '';
  945. let qihtml = '';
  946. for (const m of months) {
  947. html += '<div class="custom-control custom-checkbox mb-2">\n' +
  948. ' <input type="checkbox" name="del_month" value="' + m + '" class="custom-control-input" id="month_' + m + '">\n' +
  949. ' <label class="custom-control-label" for="month_' + m + '">' + m + '月</label>\n' +
  950. ' </div>';
  951. qihtml += parseInt(m.split('-')[1]) + '月,';
  952. }
  953. if (months.length > 0) {
  954. qihtml = '<span class="mx-2 text-muted">/</span>本期月信息价:' + qihtml;
  955. qihtml = qihtml.substring(0, qihtml.length-1);
  956. }
  957. $('#show_month').html(html);
  958. $('#qi-month').html(qihtml);
  959. },
  960. _monthHeaderSet: function() {
  961. const newMonths = [];
  962. for (const m of months) {
  963. const year = m.split('-')[0];
  964. const month = parseInt(m.split('-')[1]);
  965. let one = _.find(newMonths, { 'year': year });
  966. let oneIndex = _.findIndex(newMonths, { 'year': year });
  967. if (one) {
  968. one.month.push(month);
  969. newMonths.splice(oneIndex, 1, one);
  970. } else {
  971. one = {
  972. year: year,
  973. month: [ month ],
  974. };
  975. newMonths.push(one);
  976. }
  977. }
  978. const pushMonth = [];
  979. for(const mo of newMonths) {
  980. for (let i in mo.month) {
  981. i = parseInt(i);
  982. const newCols = {
  983. title: (i === 0 ? mo.year: '') + '|' + mo.month[i] + '月',
  984. colSpan: (i === 0 ? (mo.month.length === 1 ? '0' : mo.month.length) : '') + '|1',
  985. rowSpan: i === 0 ? '1|1' : '|1',
  986. field: mo.year + '-' + (mo.month[i] < 10 ? '0' + mo.month[i] : mo.month[i]),
  987. hAlign: 2, width: 60, type: '@', readOnly: 'readOnly.isEdit'};
  988. pushMonth.push(newCols);
  989. }
  990. }
  991. return pushMonth;
  992. },
  993. monthSheetReset: function (ml = monthsList) {
  994. const monthCols = monthFunGather._monthHeaderSet();
  995. const newMonthSpreadHeaderCols = static_cols.concat(monthCols);
  996. materialMonthSpreadSetting.cols = newMonthSpreadHeaderCols;
  997. // 表头变化需要重新绘制,不然报错;
  998. materialMonthSpread.getActiveSheet().reset();
  999. SpreadJsObj.initSpreadSettingEvents(materialMonthSpreadSetting, materialMonthCol);
  1000. SpreadJsObj.initSheet(materialMonthSpread.getActiveSheet(), materialMonthSpreadSetting);
  1001. SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, ml);
  1002. monthFunGather._setMonthHtml();
  1003. },
  1004. monthsListSet: function (ml = materialBillsData, checked = true) {
  1005. if($('#bills0_list').is(':checked') && checked) {
  1006. ml = _.filter(materialBillsData, function (item) {
  1007. return item.quantity === null || item.quantity === 0;
  1008. });
  1009. }
  1010. const newMonthsList = _.filter(monthsList, function (item) {
  1011. return _.findIndex(ml, { code: item.code }) !== -1;
  1012. });
  1013. monthFunGather.monthSheetReset(newMonthsList);
  1014. }
  1015. };
  1016. const materialMonthSpread = SpreadJsObj.createNewSpread($('#material-month-spread')[0]);
  1017. const materialMonthSpreadSetting = {
  1018. cols: static_cols,
  1019. emptyRows: 0,
  1020. headRows: 2,
  1021. headRowHeight: [25, 25],
  1022. defaultRowHeight: 21,
  1023. headerFont: '12px 微软雅黑',
  1024. font: '12px 微软雅黑',
  1025. readOnly: readOnly,
  1026. };
  1027. if (months.length > 0) {
  1028. const monthCols = monthFunGather._monthHeaderSet();
  1029. const monthSpreadHeaderCols = static_cols.concat(monthCols);
  1030. materialMonthSpreadSetting.cols = monthSpreadHeaderCols;
  1031. }
  1032. const materialMonthCol = {
  1033. getValue: {
  1034. average_msg_tp: function (data) {
  1035. let msg_tp = 0;
  1036. let hadnum = 0;
  1037. for (const m of months) {
  1038. msg_tp += data[m];
  1039. if (data[m] !== null && data[m] !== '' && data[m] !== 0) {
  1040. hadnum++;
  1041. }
  1042. }
  1043. const average_tp = hadnum !== 0 ? ZhCalc.round(ZhCalc.div(msg_tp, hadnum), materialDecimal.up) : ZhCalc.round(ZhCalc.div(msg_tp, months.length), materialDecimal.up);
  1044. return average_tp;
  1045. },
  1046. },
  1047. readOnly: {
  1048. isEdit: function (data) {
  1049. return readOnly;
  1050. },
  1051. },
  1052. };
  1053. materialMonthSpread.getActiveSheet().frozenColumnCount(5);
  1054. materialMonthSpread.getActiveSheet().options.frozenlineColor = '#f1f1f1';
  1055. SpreadJsObj.initSpreadSettingEvents(materialMonthSpreadSetting, materialMonthCol);
  1056. SpreadJsObj.initSheet(materialMonthSpread.getActiveSheet(), materialMonthSpreadSetting);
  1057. SpreadJsObj.loadSheetData(materialMonthSpread.getActiveSheet(), SpreadJsObj.DataType.Data, monthsList);
  1058. const materialMonthSpreadObj = {
  1059. editEnded: function (e, info) {
  1060. if (info.sheet.zh_setting) {
  1061. const select = SpreadJsObj.getSelectObject(info.sheet);
  1062. const col = info.sheet.zh_setting.cols[info.col];
  1063. // 未改变值则不提交
  1064. let validText = is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
  1065. const orgValue = select[col.field];
  1066. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  1067. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1068. return;
  1069. }
  1070. if (col.field === 'origin') {
  1071. select[col.field] = validText;
  1072. postData(window.location.pathname + '/month/save', { type:'updateOrigin', updateData: { mb_id: select.mb_id, value: validText } }, function (result) {
  1073. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1074. materialBillsData = result.materialBillsData;
  1075. materialSpreadObj.materialSheetReset();
  1076. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1077. }, function () {
  1078. select[col.field] = orgValue;
  1079. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1080. });
  1081. } else {
  1082. // 判断部分值是否输入的是数字判断和数据计算
  1083. if (isNaN(validText)) {
  1084. toastr.error('不能输入其它非数字类型字符');
  1085. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1086. return;
  1087. }
  1088. const num = parseFloat(validText);
  1089. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  1090. if (validText !== null && (num < 0 || !reg.test(num))) {
  1091. toastr.warning('已保留'+ materialDecimal.up +'位小数');
  1092. validText = ZhCalc.round(num, materialDecimal.up);
  1093. }
  1094. select[col.field] = validText;
  1095. // 更新至服务器
  1096. postData(window.location.pathname + '/month/save', { type:'update', updateData: { mb_id: select.mb_id, yearmonth: col.field, value: validText } }, function (result) {
  1097. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1098. materialBillsData = result.materialBillsData;
  1099. materialSpreadObj.materialSheetReset();
  1100. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1101. m_tp = result.m_tp;
  1102. if (materialTax) {
  1103. m_tax_tp = result.m_tax_tp;
  1104. }
  1105. resetTpTable();
  1106. }, function () {
  1107. select[col.field] = orgValue;
  1108. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1109. });
  1110. }
  1111. }
  1112. },
  1113. deletePress: function (sheet) {
  1114. // if (sheet.zh_setting && sheet.zh_data) {
  1115. // const sel = sheet.getSelections()[0];
  1116. // if (!sel) return;
  1117. //
  1118. // const col = sheet.zh_setting.cols[sel.col];
  1119. // const select = SpreadJsObj.getSelectObject(sheet);
  1120. // const orgValue = select[col.field];
  1121. // if (sel.colCount > 1 || sel.rowCount > 1) {
  1122. // toastr.warning('请勿同时删除多行或多列数据');
  1123. // }
  1124. // console.log(sel, select, col);
  1125. // if (orgValue === null || col.field === 'type' || col.field === 'is_summary') {
  1126. // return;
  1127. // }
  1128. // select[col.field] = null;
  1129. // select.calc_num = materialExponentCol.getValue.calc_num(select);
  1130. // console.log(select);
  1131. // 更新至服务器
  1132. // postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
  1133. // ex_tp = result.ex_tp;
  1134. // ex_expr = result.ex_expr;
  1135. // resetExTpTable();
  1136. // SpreadJsObj.reLoadRowData(sheet, sel.row);
  1137. // materialExponentData.splice(sel.row, 1, select);
  1138. // }, function () {
  1139. // select[col.field] = orgValue;
  1140. // SpreadJsObj.reLoadRowData(sheet, sel.row);
  1141. // });
  1142. // }
  1143. return;
  1144. },
  1145. clipboardPasted(e, info) {
  1146. const hint = {
  1147. cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
  1148. numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
  1149. numberCan: {type: 'warning', msg: '已保留'+ materialDecimal.up +'位小数'},
  1150. };
  1151. const range = info.cellRange;
  1152. const sortData = info.sheet.zh_data || [];
  1153. if (info.cellRange.row + info.cellRange.rowCount > sortData.length) {
  1154. toastMessageUniq(hint.cellError);
  1155. SpreadJsObj.reLoadSheetHeader(materialMonthSpread.getActiveSheet());
  1156. SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  1157. return;
  1158. }
  1159. if (sortData.length > 0 && range.col + range.colCount > 5 + months.length) {
  1160. toastMessageUniq(hint.cellError);
  1161. SpreadJsObj.reLoadSheetHeader(materialMonthSpread.getActiveSheet());
  1162. SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  1163. return;
  1164. }
  1165. const data = [];
  1166. let pasteOrigin = false;
  1167. for (let iRow = 0; iRow < range.rowCount; iRow++) {
  1168. let bPaste = true;
  1169. const curRow = range.row + iRow;
  1170. const materialMonthData = sortData[curRow];
  1171. const hintRow = range.rowCount > 1 ? curRow : '';
  1172. let sameCol = 0;
  1173. for (let iCol = 0; iCol < range.colCount; iCol++) {
  1174. const curCol = range.col + iCol;
  1175. const colSetting = info.sheet.zh_setting.cols[curCol];
  1176. if (!colSetting) continue;
  1177. let validText = info.sheet.getText(curRow, curCol);
  1178. validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
  1179. const orgValue = sortData[curRow][colSetting.field];
  1180. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  1181. sameCol++;
  1182. if (range.colCount === sameCol) {
  1183. bPaste = false;
  1184. }
  1185. continue;
  1186. }
  1187. if (colSetting.field === 'origin') {
  1188. pasteOrigin = true;
  1189. } else {
  1190. const num = parseFloat(validText);
  1191. if (isNaN(validText)) {
  1192. toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
  1193. bPaste = false;
  1194. continue;
  1195. }
  1196. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  1197. if (validText !== null && (num < 0 || !reg.test(num))) {
  1198. toastMessageUniq(getPasteHint(hint.numberCan, hintRow));
  1199. validText = ZhCalc.round(num, materialDecimal.up);
  1200. }
  1201. }
  1202. materialMonthData[colSetting.field] = validText;
  1203. sortData[curRow][colSetting.field] = validText;
  1204. }
  1205. if (bPaste) {
  1206. data.push(materialMonthData);
  1207. } else {
  1208. SpreadJsObj.reLoadRowData(info.sheet, curRow);
  1209. }
  1210. }
  1211. if (data.length === 0) {
  1212. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1213. return;
  1214. }
  1215. // console.log(data);
  1216. if (pasteOrigin) {
  1217. // 更新至服务器
  1218. postData(window.location.pathname + '/month/save', { type:'pasteOrigin', updateData: data }, function (result) {
  1219. SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  1220. materialBillsData = result.materialBillsData;
  1221. }, function () {
  1222. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1223. return;
  1224. });
  1225. } else {
  1226. // 更新至服务器
  1227. postData(window.location.pathname + '/month/save', { type:'paste', updateData: data }, function (result) {
  1228. SpreadJsObj.reLoadSheetData(materialMonthSpread.getActiveSheet());
  1229. materialBillsData = result.materialBillsData;
  1230. materialSpreadObj.materialSheetReset();
  1231. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1232. m_tp = result.m_tp;
  1233. if (materialTax) {
  1234. m_tax_tp = result.m_tax_tp;
  1235. }
  1236. resetTpTable();
  1237. }, function () {
  1238. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1239. return;
  1240. });
  1241. }
  1242. },
  1243. };
  1244. // 应耗来源sjs
  1245. const material_source_cols = [
  1246. {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 100, formatter: '@'},
  1247. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 150, formatter: '@'},
  1248. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 70, formatter: '@'},
  1249. {title: '本期应耗', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 100, formatter: '@'},
  1250. ];
  1251. const materialSourceSpread = SpreadJsObj.createNewSpread($('#material-source-spread')[0]);
  1252. const materialSourceSpreadSetting = {
  1253. cols: material_source_cols,
  1254. emptyRows: 0,
  1255. headRows: 1,
  1256. headRowHeight: [32],
  1257. defaultRowHeight: 21,
  1258. headerFont: '12px 微软雅黑',
  1259. font: '12px 微软雅黑',
  1260. readOnly: true,
  1261. };
  1262. SpreadJsObj.initSheet(materialSourceSpread.getActiveSheet(), materialSourceSpreadSetting);
  1263. SpreadJsObj.loadSheetData(materialSourceSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
  1264. // 项目节汇总sjs
  1265. const material_xmj_gather_cols = [
  1266. {title: '单位工程', colSpan: '1', rowSpan: '2', field: 'dwgc', hAlign: 0, width: 80, formatter: '@', visible: false},
  1267. {title: '分部工程', colSpan: '1', rowSpan: '2', field: 'fbgc', hAlign: 0, width: 80, formatter: '@', visible: false},
  1268. {title: '分项工程', colSpan: '1', rowSpan: '2', field: 'fxgc', hAlign: 0, width: 80, formatter: '@', visible: false},
  1269. {title: '细目', colSpan: '1', rowSpan: '2', field: 'jldy', hAlign: 0, width: 80, formatter: '@', visible: false},
  1270. {title: '计量单元', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 80, formatter: '@'},
  1271. {title: '本期应耗数量', colSpan: '1', rowSpan: '2', field: 'quantity', hAlign: 2, width: 100, type: 'Number'},
  1272. {title: '本期调差金额', colSpan: '1', rowSpan: '2', field: 'm_tp', hAlign: 2, width: 100, type: 'Number'},
  1273. ];
  1274. const materialXmjGatherSpread = SpreadJsObj.createNewSpread($('#material-xmj-gather-spread')[0]);
  1275. const materialXmjGatherSpreadSetting = {
  1276. cols: material_xmj_gather_cols,
  1277. emptyRows: 0,
  1278. headRows: 1,
  1279. headRowHeight: [32],
  1280. defaultRowHeight: 21,
  1281. headerFont: '12px 微软雅黑',
  1282. font: '12px 微软雅黑',
  1283. readOnly: true,
  1284. localCache: {
  1285. key: 'material-gather-gatherLeafXmj',
  1286. colWidth: true,
  1287. }
  1288. };
  1289. if (thousandth) sjsSettingObj.setTpThousandthFormat(materialXmjGatherSpreadSetting);
  1290. const materialXmjGatherSheet = materialXmjGatherSpread.getActiveSheet();
  1291. SpreadJsObj.initSheet(materialXmjGatherSheet, materialXmjGatherSpreadSetting);
  1292. // SpreadJsObj.loadSheetData(materialXmjGatherSpread.getActiveSheet(), SpreadJsObj.DataType.Data, []);
  1293. // 下部设置显示相关
  1294. $('a', '[id=material-bills-tab]').click(function() {
  1295. const relaTab = this.getAttribute('href');
  1296. const optionTab = $('#optionTab').children();
  1297. for (const ot of optionTab) {
  1298. if (ot.getAttribute('rela-tab') === relaTab) {
  1299. $(ot).show();
  1300. } else {
  1301. $(ot).hide();
  1302. }
  1303. }
  1304. setTimeout(refreshRelaSpread, 100);
  1305. });
  1306. $('[name=gather-xmj]').change(function() {
  1307. const checkOption = $('[name=gather-xmj]:checked');
  1308. if (checkOption.length === 0) {
  1309. toastr.warning('请至少选择一个汇总条件');
  1310. $(this).prop('checked', true);
  1311. return;
  1312. }
  1313. const fields = [];
  1314. for (const co of checkOption) {
  1315. fields.push(co.value);
  1316. }
  1317. for (const col of materialXmjGatherSpreadSetting.cols) {
  1318. col.visible = col.type === 'Number' || fields.indexOf(col.field) >= 0;
  1319. }
  1320. gatherFields = fields;
  1321. SpreadJsObj.refreshColumnVisible(materialXmjGatherSheet);
  1322. const data = SpreadJsObj.getSelectObject(materialSpread.getActiveSheet());
  1323. setCurBillSourceList(data ? (data.mb_id || data.id) : null, $('#myTab').find('.active').data('msid') || null, fields);
  1324. });
  1325. function refreshRelaSpread() {
  1326. materialSourceSpread.refresh();
  1327. materialXmjGatherSpread.refresh();
  1328. }
  1329. let first = true;
  1330. function setListsData(sid = null, ms_id = null) {
  1331. if (first) {
  1332. // 加载清单数据 - 暂时统一加载,如有需要,切换成动态加载并缓存
  1333. postData(window.location.pathname + '/list/load', {sid}, async function (result) {
  1334. ledger = result.ledger;
  1335. curLedgerData = result.curLedgerData;
  1336. pos = result.pos;
  1337. curPosData = result.curPosData;
  1338. materialListData2 = result.materialListData;
  1339. gclList = result.gclList;
  1340. notJoinList = result.materialNotJoinListData;
  1341. selfList = result.materialSelfListData;
  1342. materialChecklistData = result.materialChecklistData;
  1343. if (isStageSelf) {
  1344. const newGclGatherListData = [];
  1345. for (const [index, s] of result.ledgerListData.entries()) {
  1346. gclGatherModel.loadLedgerData(_.cloneDeep(ledger), s);
  1347. gclGatherModel.loadPosData(_.cloneDeep(pos), result.posListData[index]);
  1348. const oneGclGatherData = gclGatherModel.gatherGclData().filter(item => {
  1349. return item.qc_qty || item.contract_qty || item.qc_minus_qty
  1350. });
  1351. newGclGatherListData.push(oneGclGatherData);
  1352. }
  1353. gclGatherListData = newGclGatherListData;
  1354. }
  1355. // 解析清单汇总数据
  1356. gclGatherModel.loadLedgerData(_.cloneDeep(ledger), curLedgerData);
  1357. gclGatherModel.loadPosData(_.cloneDeep(pos), curPosData);
  1358. gclGatherData = gclGatherModel.gatherGclData();
  1359. gclGatherData = gclGatherData.filter(item => {
  1360. return item.qc_qty || item.contract_qty || item.qc_minus_qty
  1361. });
  1362. if (openMaterialChecklist) {
  1363. // 取交集
  1364. const selfListGcl = _.uniq(_.map(selfList, 'gcl_id'));
  1365. gclGatherData = _.filter(gclGatherData, function (item) {
  1366. if (_.find(materialChecklistData, {
  1367. b_code: item.b_code,
  1368. name: item.name,
  1369. unit: item.unit,
  1370. unit_price: item.unit_price
  1371. })) {
  1372. return true;
  1373. } else {
  1374. const gcl_ids = item.leafXmjs ? _.uniq(_.map(item.leafXmjs, 'gcl_id')) : [];
  1375. const jiaoji = _.intersection(gcl_ids, selfListGcl);
  1376. if (jiaoji.length > 0) {
  1377. return true;
  1378. }
  1379. }
  1380. });
  1381. }
  1382. // calculateJiaCha(gclGatherData);
  1383. console.log(gclGatherData);
  1384. setCurBillSourceList(materialBillsData[0] ? materialBillsData[0].mb_id || materialBillsData[0].id : null, ms_id);
  1385. first = false;
  1386. // 判断是否需要更新contract_qty、qc_qty和qc_minus_qty
  1387. if (!materialIsNewQty && !readOnly && !editForAudit) {
  1388. let needUpdateList = [];
  1389. if (materialListData2.length > 0) {
  1390. if (isStageSelf) {
  1391. for (const msIndex in materialStageData) {
  1392. const materialStageList = _.filter(materialListData2, { ms_id: materialStageData[msIndex].id });
  1393. const gclIdList = _.uniq(_.map(materialListData2, 'gcl_id'));
  1394. let leafXmjList = [];
  1395. for (const id of gclIdList) {
  1396. const gcl = _.find(gclGatherListData[msIndex], function (item) {
  1397. return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, {gcl_id: id}) !== -1;
  1398. });
  1399. if (gcl) leafXmjList = [...leafXmjList, ...gcl.leafXmjs];
  1400. }
  1401. for (const ml of materialStageList) {
  1402. const leafXmjInfo = _.find(leafXmjList, function (item) {
  1403. return item.gcl_id === ml.gcl_id && item.id === ml.xmj_id && (item.mx_id === undefined || (item.mx_id !== undefined && item.mx_id === ml.mx_id));
  1404. });
  1405. if (leafXmjInfo) {
  1406. needUpdateList.push({ id: ml.id, contract_qty: leafXmjInfo.contract_qty, qc_qty: leafXmjInfo.qc_qty, qc_minus_qty: leafXmjInfo.qc_minus_qty });
  1407. }
  1408. }
  1409. }
  1410. } else {
  1411. // 找出所有gcl相同的,方便搜索gclGatherData值
  1412. const gclIdList = _.uniq(_.map(materialListData2, 'gcl_id'));
  1413. let leafXmjList = [];
  1414. for (const id of gclIdList) {
  1415. const gcl = _.find(gclGatherData, function (item) {
  1416. return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, {gcl_id: id}) !== -1;
  1417. });
  1418. if (gcl) leafXmjList = [...leafXmjList, ...gcl.leafXmjs];
  1419. }
  1420. for (const ml of materialListData2) {
  1421. const leafXmjInfo = _.find(leafXmjList, function (item) {
  1422. return item.gcl_id === ml.gcl_id && item.id === ml.xmj_id && (item.mx_id === undefined || (item.mx_id !== undefined && item.mx_id === ml.mx_id));
  1423. });
  1424. if (leafXmjInfo) {
  1425. needUpdateList.push({ id: ml.id, contract_qty: leafXmjInfo.contract_qty, qc_qty: leafXmjInfo.qc_qty, qc_minus_qty: leafXmjInfo.qc_minus_qty });
  1426. }
  1427. }
  1428. }
  1429. }
  1430. console.log(needUpdateList);
  1431. postData(window.location.pathname + '/save', { type: 'qty_update', needUpdateList }, function (result) {
  1432. materialListData2 = result.materialListData;
  1433. });
  1434. }
  1435. });
  1436. } else {
  1437. const i = _.findIndex(materialStageData, { sid });
  1438. gclGatherData = gclGatherListData[i];
  1439. gclGatherData = gclGatherData.filter(item => {
  1440. return item.qc_qty || item.contract_qty || item.qc_minus_qty
  1441. });
  1442. if (openMaterialChecklist) {
  1443. // 取交集
  1444. const selfListGcl = _.uniq(_.map(selfList, 'gcl_id'));
  1445. gclGatherData = _.filter(gclGatherData, function (item) {
  1446. if (_.find(materialChecklistData, {
  1447. b_code: item.b_code,
  1448. name: item.name,
  1449. unit: item.unit,
  1450. unit_price: item.unit_price
  1451. })) {
  1452. return true;
  1453. } else {
  1454. const gcl_ids = item.leafXmjs ? _.uniq(_.map(item.leafXmjs, 'gcl_id')) : [];
  1455. const jiaoji = _.intersection(gcl_ids, selfListGcl);
  1456. if (jiaoji.length > 0) {
  1457. return true;
  1458. }
  1459. }
  1460. });
  1461. }
  1462. // calculateJiaCha(gclGatherData);
  1463. console.log(gclGatherData);
  1464. }
  1465. }
  1466. setListsData(isStageSelf ? materialStageData[0].sid : null, isStageSelf ? materialStageData[0].id : null);
  1467. SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
  1468. SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
  1469. materialSpreadObj.getMaterialBillsData();
  1470. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1471. materialSpreadObj.refreshActn();
  1472. materialMonthSpread.bind(spreadNS.Events.ClipboardPasted, materialMonthSpreadObj.clipboardPasted);
  1473. SpreadJsObj.addDeleteBind(materialMonthSpread, materialMonthSpreadObj.deletePress);
  1474. materialMonthSpread.bind(spreadNS.Events.EditEnded, materialMonthSpreadObj.editEnded);
  1475. // 期切换
  1476. $('#myTab a[data-toggle="tab"]').on('shown.bs.tab', function (e) {
  1477. e.preventDefault();
  1478. showWaitingView();
  1479. setTimeout(function () {
  1480. materialSpreadObj.getMaterialBillsData();
  1481. materialSpreadObj.materialSheetReset(true);
  1482. // SpreadJsObj.reLoadSheetData(materialSpread.getActiveSheet());
  1483. // 消耗量表格更新
  1484. let html = '';
  1485. calcBase = _.find(calcBaseList, { ms_id: $('#myTab').find('.active').data('msid') }).calcBase;
  1486. for (let iBase = 0; iBase < calcBase.length; iBase++) {
  1487. if (!calcBase[iBase].cType || (calcBase[iBase].cType && calcBase[iBase].cType === 1 && calcBase[iBase].value)) {
  1488. html += '<tr><td>' + calcBase[iBase].name + '</td><td>' + calcBase[iBase].code + '</td><td>' + calcBase[iBase].value + '</td></tr>';
  1489. }
  1490. }
  1491. $('#calcBase').html(html);
  1492. const ms_id = parseInt($('#myTab').find('.active').data('msid'));
  1493. const msInfo = _.find(materialStageData, { id: ms_id });
  1494. setListsData(msInfo.sid, ms_id);
  1495. const data = SpreadJsObj.getSelectObject(materialSpread.getActiveSheet());
  1496. setCurBillSourceList(data ? (data.mb_id || data.id) : null, ms_id);
  1497. closeWaitingView();
  1498. }, 1000);
  1499. });
  1500. // 本条工料应耗来源数据信息
  1501. function setCurBillSourceList(mb_id, ms_id = null, fields = gatherFields) {
  1502. const showSourceList = [];
  1503. const showXmjList = [];
  1504. if (mb_id) {
  1505. const list = _.filter(materialListData2, function (item) {
  1506. return item.mb_id === mb_id && item.ms_id === ms_id && (item.is_join === 1 || item.is_join === 2);
  1507. });
  1508. console.log(list);
  1509. if (list.length > 0) {
  1510. for (const l of list) {
  1511. const gcl = _.find(gclGatherData, function (item) {
  1512. return item.leafXmjs && item.leafXmjs.length > 0 && _.findIndex(item.leafXmjs, { gcl_id: l.gcl_id }) !== -1;
  1513. });
  1514. if (gcl) {
  1515. const index = _.findIndex(showSourceList, { code: gcl.b_code, name: gcl.name, unit: gcl.unit });
  1516. if (index === -1) {
  1517. showSourceList.push({
  1518. code: gcl.b_code,
  1519. name: gcl.name,
  1520. unit: gcl.unit,
  1521. quantity: ZhCalc.mul(calcQty(l), l.quantity),
  1522. });
  1523. } else {
  1524. showSourceList[index].quantity = ZhCalc.add(showSourceList[index].quantity, ZhCalc.mul(calcQty(l), l.quantity));
  1525. }
  1526. // const indexXmj = _.findIndex(showXmjList, { gcl_id: l.gcl_id, xmj_id: l.xmj_id, mx_id: l.mx_id });
  1527. const xmj = _.find(gcl.leafXmjs, { gcl_id: l.gcl_id, id: l.xmj_id, mx_id: l.mx_id });
  1528. if (xmj) {
  1529. const condition = {};
  1530. for (const f of fields) {
  1531. condition[f] = xmj[f];
  1532. }
  1533. let glx = _.find(showXmjList, condition);
  1534. if (!glx) {
  1535. const newGcl = _.cloneDeep(xmj);
  1536. newGcl.quantity = ZhCalc.mul(calcQty(l), l.quantity);
  1537. showXmjList.push(newGcl);
  1538. } else {
  1539. glx.quantity = ZhCalc.add(glx.quantity, ZhCalc.mul(calcQty(l), l.quantity));
  1540. }
  1541. }
  1542. }
  1543. }
  1544. }
  1545. const data = SpreadJsObj.getSelectObject(materialSpread.getActiveSheet());
  1546. for (const xmj of showXmjList) {
  1547. const m_spread = data ? (data.m_spread || data.spread) : 0;
  1548. xmj.m_tp = ZhCalc.mul(m_spread, xmj.quantity);
  1549. }
  1550. }
  1551. // 按清单编号排序
  1552. SpreadJsObj.loadSheetData(materialSourceSpread.getActiveSheet(), SpreadJsObj.DataType.Data, showSourceList.sort(sortByCode));
  1553. console.log(showXmjList);
  1554. SpreadJsObj.loadSheetData(materialXmjGatherSheet, SpreadJsObj.DataType.Data, showXmjList);
  1555. }
  1556. function calcQty(info) {
  1557. let qty = '';
  1558. switch (qtySource) {
  1559. case qtySourceValueConst.gather_qty: qty = info.gather_qty; break;
  1560. case qtySourceValueConst.contract_qty: qty = info.contract_qty; break;
  1561. case qtySourceValueConst.gather_minus_qty: qty = ZhCalc.add(info.gather_qty, info.qc_minus_qty); break;
  1562. default: throw '未配置计量来源出错';
  1563. }
  1564. if (qtySource !== qtySourceValueConst.contract_qty && info.is_join === 2) {
  1565. qty = info.contract_qty;
  1566. }
  1567. return qty;
  1568. }
  1569. if (!readOnly || editForAudit) {
  1570. $('#expr_select button').on('click', function () {
  1571. const code = $(this).text();
  1572. // $('#expr').val($('#expr').val() + code);
  1573. $('#expr').insertAtCaret(code);
  1574. });
  1575. const ExprObj = {
  1576. _checkExprValid(expr, invalidParam) {
  1577. if (!expr) return [true, null];
  1578. const param = [];
  1579. let num = '', base = '';
  1580. for (let i = 0, iLen = expr.length; i < iLen; i++) {
  1581. if (/^[\d\.%]+/.test(expr[i])) {
  1582. if (base !== '') {
  1583. param.push({type: 'base', value: base});
  1584. base = '';
  1585. }
  1586. num = num + expr[i];
  1587. } else if (/^[a-z]/.test(expr[i])) {
  1588. if (num !== '') {
  1589. param.push({type: 'num', value: num});
  1590. num = '';
  1591. }
  1592. base = base + expr[i];
  1593. } else if (expr[i] === '(') {
  1594. if (num !== '') {
  1595. param.push({type: 'num', value: num});
  1596. num = '';
  1597. }
  1598. if (base !== '') {
  1599. param.push({type: 'base', value: base});
  1600. base = '';
  1601. }
  1602. param.push({type: 'left', value: '('});
  1603. } else if (expr[i] === ')') {
  1604. if (num !== '') {
  1605. param.push({type: 'num', value: num});
  1606. num = '';
  1607. }
  1608. if (base !== '') {
  1609. param.push({type: 'base', value: base});
  1610. base = '';
  1611. }
  1612. param.push({type: 'right', value: ')'});
  1613. } else if (/^[\+\-*\/]/.test(expr[i])) {
  1614. if (num !== '') {
  1615. param.push({type: 'num', value: num});
  1616. num = '';
  1617. }
  1618. if (base !== '') {
  1619. param.push({type: 'base', value: base});
  1620. base = '';
  1621. }
  1622. param.push({type: 'calc', value: expr[i]});
  1623. } else {
  1624. return [false, '输入的表达式含有非法字符: ' + expr[i]];
  1625. }
  1626. }
  1627. if (num !== '') {
  1628. param.push({type: 'num', value: num});
  1629. num = '';
  1630. }
  1631. if (base !== '') {
  1632. param.push({type: 'base', value: base});
  1633. base = '';
  1634. }
  1635. if (param.length === 0) return true;
  1636. if (param.length > 1) {
  1637. if (param[0].value === '-' && param[1].type === 'num') {
  1638. param[1].value = '-' + param[1].value;
  1639. param.shift();
  1640. }
  1641. }
  1642. const iLen = param.length;
  1643. let iLeftCount = 0, iRightCount = 0;
  1644. for (const [i, p] of param.entries()) {
  1645. if (p.type === 'calc') {
  1646. if (i === 0 || i === iLen - 1)
  1647. return [false, '输入的表达式非法:计算符号' + p.value + '前后应有数字或计算基数'];
  1648. }
  1649. if (p.type === 'num') {
  1650. num = p.value.replace('%', '');
  1651. if (p.value.length - num.length > 1)
  1652. return [false, '输入的表达式非法:' + p.value + '不是一个有效的数字'];
  1653. num = _.toNumber(num);
  1654. if (num === undefined || num === null || _.isNaN(num))
  1655. return [false, '输入的表达式非法:' + p.value + '不是一个有效的数字'];
  1656. if (i > 0) {
  1657. if (param[i - 1].type !== 'calc' && param[i - 1].type !== 'left') {
  1658. return [false, '输入的表达式非法:' + p.value + '前应有运算符'];
  1659. } else if (param[i - 1].value === '/' && num === 0) {
  1660. return [false, '输入的表达式非法:请勿除0'];
  1661. }
  1662. }
  1663. }
  1664. if (p.type === 'base') {
  1665. const baseParam = _.find(calcBase, {code: p.value});
  1666. if (!baseParam)
  1667. return [false, '输入的表达式非法:不存在计算基数' + p.value];
  1668. if (invalidParam && invalidParam.indexOf(p.value) >= 0)
  1669. return [false, '不可使用计算基数' + p.value];
  1670. if (i > 0 && (param[i - 1].type === 'num' || param[i - 1].type === 'right'))
  1671. return [false, '输入的表达式非法:' + p.value + '前应有运算符'];
  1672. }
  1673. if (p.type === 'left') {
  1674. iLeftCount += 1;
  1675. if (i !== 0 && param[i-1].type !== 'calc')
  1676. return [false, '输入的表达式非法:(前应有运算符'];
  1677. }
  1678. if (p.type === 'right') {
  1679. iRightCount += 1;
  1680. if (i !== iLen - 1 && param[i+1].type !== 'calc')
  1681. return [false, '输入的表达式非法:)后应有运算符'];
  1682. if (iRightCount > iLeftCount)
  1683. return [false, '输入的表达式非法:")"前无对应的"("'];
  1684. }
  1685. }
  1686. if (iLeftCount > iRightCount)
  1687. return [false, '输入的表达式非法:"("后无对应的")"'];
  1688. return [true, ''];
  1689. },
  1690. _checkExpr: function (text) {
  1691. if (text) {
  1692. const num = _.toNumber(text);
  1693. if (num) {
  1694. console.log(num);
  1695. } else {
  1696. const expr = text.replace('=', '').toLowerCase();
  1697. const [valid, msg] = this._checkExprValid(expr);
  1698. if (!valid) return [valid, msg];
  1699. }
  1700. }
  1701. return [true, ''];
  1702. },
  1703. };
  1704. $('#expr_btn').click(function () {
  1705. const expr = $('#expr').val();
  1706. // 判断表达式格式
  1707. const [valid, msg] = ExprObj._checkExpr(expr);
  1708. if (!valid) {
  1709. toastr.error(msg);
  1710. return false;
  1711. }
  1712. postData(window.location.pathname + '/save', { type:'expr', id: $('#materialbillsId').val(), expr: expr, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
  1713. m_tp = result.m_tp;
  1714. if (materialTax) {
  1715. m_tax_tp = result.m_tax_tp;
  1716. }
  1717. const sheet = materialSpread.getActiveSheet();
  1718. const select = SpreadJsObj.getSelectObject(sheet);
  1719. const index = _.findIndex(materialBillsData, { id: select.id });
  1720. let newIndex = index;
  1721. if (isStageSelf) {
  1722. materialSpreadObj.updateMaterialData(result);
  1723. result.info = materialSpreadObj.updateOneMaterialBill(result.info);
  1724. }
  1725. if($('#bills0_list').is(':checked')) {
  1726. const newMaterialBillsData = _.filter(materialBillsData, function (item) {
  1727. return item.quantity !== null && item.quantity !== 0;
  1728. });
  1729. newIndex = _.findIndex(newMaterialBillsData, { id: select.id });
  1730. // newIndex = newMaterialBillsData.indexOf(select);
  1731. newMaterialBillsData.splice(newIndex, 1, result.info);
  1732. sheet.zh_data[newIndex] = result.info;
  1733. }
  1734. materialBillsData.splice(index, 1, result.info);
  1735. sheet.zh_data.splice(newIndex, 1, result.info);
  1736. SpreadJsObj.reLoadRowData(sheet, newIndex);
  1737. resetTpTable();
  1738. $('#bcyy').modal('hide');
  1739. });
  1740. });
  1741. }
  1742. if (!readOnly && !editForAudit) {
  1743. $('#add').click(materialSpreadObj.add);
  1744. $('#del').click(materialSpreadObj.del);
  1745. $('#up-move').click(materialSpreadObj.upMove);
  1746. $('#down-move').click(materialSpreadObj.downMove);
  1747. // 右键菜单
  1748. $.contextMenu({
  1749. selector: '#material-spread',
  1750. build: function ($trigger, e) {
  1751. const target = SpreadJsObj.safeRightClickSelection($trigger, e, materialSpread);
  1752. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  1753. },
  1754. items: {
  1755. 'create': {
  1756. name: '新增材料',
  1757. icon: 'fa-sign-in',
  1758. callback: function (key, opt) {
  1759. materialSpreadObj.add(materialSpread.getActiveSheet());
  1760. },
  1761. },
  1762. 'delete': {
  1763. name: '删除材料',
  1764. icon: 'fa-remove',
  1765. callback: function (key, opt) {
  1766. materialSpreadObj.del(materialSpread.getActiveSheet());
  1767. },
  1768. disabled: function (key, opt) {
  1769. const sheet = materialSpread.getActiveSheet();
  1770. const select = SpreadJsObj.getSelectObject(sheet);
  1771. const sel = sheet.getSelections()[0];
  1772. materialSpreadObj.refreshActn(sel.rowCount);
  1773. if (!readOnly && select && materialBase.isUsed(select) && sel.rowCount === 1) {
  1774. return false;
  1775. } else {
  1776. return true;
  1777. }
  1778. }
  1779. },
  1780. }
  1781. });
  1782. $('.changeRate').click(function () {
  1783. $('#rateInput').val(parseInt($(this).data('value')));
  1784. $('#rateInput').siblings('.dropdown-menu').hide();
  1785. });
  1786. $('#rateInput').click(function () {
  1787. $(this).siblings('.dropdown-menu').show();
  1788. })
  1789. // 回车提交
  1790. $('#rateInput').on('keypress', function () {
  1791. if(window.event.keyCode === 13) {
  1792. $(this).blur();
  1793. }
  1794. });
  1795. $('#rateInput').blur(function () {
  1796. const _self = $(this);
  1797. setTimeout(function () {
  1798. let rate = parseFloat(_self.val());
  1799. if (_.isNaN(rate)) {
  1800. toastr.error('请输入0-100之前的整数值');
  1801. $('#rateInput').val(materialRate);
  1802. return;
  1803. }
  1804. rate = _.round(rate);
  1805. if(rate < 0 || rate > 100) {
  1806. toastr.error('请输入0-100之前的整数值');
  1807. $('#rateInput').val(materialRate);
  1808. return;
  1809. }
  1810. $('#rateInput').siblings('.dropdown-menu').hide();
  1811. console.log(rate, materialRate);
  1812. if (rate !== materialRate) {
  1813. postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
  1814. const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
  1815. // const exbqhs = ZhCalc.round(ZhCalc.mul(ex_tp, 1+rate/100), materialDecimal.tp);
  1816. const jzbqhs = ZhCalc.round(ZhCalc.add(pre_tp_hs, bqhs), materialDecimal.tp);
  1817. // const exjzbqhs = ZhCalc.round(ZhCalc.add(ex_pre_tp_hs, exbqhs), materialDecimal.tp);
  1818. $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
  1819. $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
  1820. // $('#rate_set').find('td').eq(3).text(exbqhs !== 0 ? exbqhs : '');
  1821. // $('#rate_set').find('td').eq(4).text(exjzbqhs !== 0 ? exjzbqhs : '');
  1822. materialRate = rate;
  1823. $('#rateInput').val(rate);
  1824. });
  1825. } else {
  1826. $('#rateInput').val(rate);
  1827. }
  1828. }, 500);
  1829. });
  1830. // $('#changeRate').change(function () {
  1831. // const rate = parseInt($(this).val());
  1832. // postData(window.location.pathname + '/save', { type:'rate', rate: rate }, function (result) {
  1833. // const bqhs = ZhCalc.round(ZhCalc.mul(m_tp, 1+rate/100), materialDecimal.tp);
  1834. // const exbqhs = ZhCalc.round(ZhCalc.mul(ex_tp, 1+rate/100), materialDecimal.tp);
  1835. // const jzbqhs = ZhCalc.round(ZhCalc.add(pre_tp_hs, bqhs), materialDecimal.tp);
  1836. // const exjzbqhs = ZhCalc.round(ZhCalc.add(ex_pre_tp_hs, exbqhs), materialDecimal.tp);
  1837. // $('#rate_set').find('td').eq(1).text(bqhs !== 0 ? bqhs : '');
  1838. // $('#rate_set').find('td').eq(2).text(jzbqhs !== 0 ? jzbqhs : '');
  1839. // $('#rate_set').find('td').eq(3).text(exbqhs !== 0 ? exbqhs : '');
  1840. // $('#rate_set').find('td').eq(4).text(exjzbqhs !== 0 ? exjzbqhs : '');
  1841. // });
  1842. // });
  1843. // 创建月信息价
  1844. $('#make-month').click(function() {
  1845. const yearmonth = $('#months').val();
  1846. const yearmonths = [];
  1847. if (yearmonth === '') {
  1848. toastr.error('请选择正确的信息价月份');
  1849. return false;
  1850. } else if (_.indexOf(yearmonth, '~') !== -1) {
  1851. const yearmonthArr = yearmonth.split('~');
  1852. // 对比两个年月,找出中间值年月push
  1853. const startYearMonth = yearmonthArr[0].trim();
  1854. const endYearMonth = yearmonthArr[1].trim();
  1855. const startYear = parseInt(startYearMonth.split('-')[0]);
  1856. const startMonth = parseInt(startYearMonth.split('-')[1]);
  1857. const endYear = parseInt(endYearMonth.split('-')[0]);
  1858. const endMonth = parseInt(endYearMonth.split('-')[1]);
  1859. if (startYear > endYear || (startYear === endYear && startMonth > endMonth)) {
  1860. toastr.error('请选择正确的信息价月份');
  1861. return false;
  1862. }
  1863. for (let i = startYear; i <= endYear; i++) {
  1864. for (let j = (i === startYear ? startMonth : 1); j <= (i === endYear ? endMonth : 12); j++) {
  1865. const monthStr = j < 10 ? `0${j}` : j;
  1866. const yearmonthStr = `${i}-${monthStr}`;
  1867. if (_.indexOf(yearmonths, yearmonthStr) === -1 && months.indexOf(yearmonthStr) === -1) {
  1868. yearmonths.push(yearmonthStr);
  1869. }
  1870. }
  1871. }
  1872. if (yearmonths.length === 0) {
  1873. toastr.error('调差期已创建过所选月区间所有的信息价');
  1874. return false;
  1875. }
  1876. } else {
  1877. const result = yearmonth.match(/^(\d{1,4})(-|\/)(\d{1,2})$/);
  1878. if (result === null) {
  1879. toastr.error('请选择正确的信息价月份');
  1880. return false;
  1881. }
  1882. if (months.indexOf(yearmonth) !== -1) {
  1883. toastr.error('调差期已创建过本月的信息价');
  1884. return false;
  1885. }
  1886. yearmonths.push(yearmonth);
  1887. }
  1888. console.log(yearmonths);
  1889. if (months.length + yearmonths.length > 24) {
  1890. toastr.error('月信息价不能超过24个月');
  1891. return false;
  1892. }
  1893. postData(window.location.pathname + '/month/save', { type: 'adds', updateData: { yearmonths } }, function (data) {
  1894. months.push(...yearmonths);
  1895. months.sort();
  1896. monthsList = data.monthsList;
  1897. monthFunGather.monthsListSet();
  1898. // 工料表单价显示也要更新
  1899. materialBillsData = data.materialBillsData;
  1900. materialSpreadObj.materialSheetReset();
  1901. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1902. m_tp = data.m_tp;
  1903. if (materialTax) {
  1904. m_tax_tp = data.m_tax_tp;
  1905. }
  1906. resetTpTable();
  1907. $('#add-month').modal('hide');
  1908. });
  1909. });
  1910. // 删除月信息价
  1911. $('#del-month').click(function () {
  1912. const del_month_array = [];
  1913. $("input[name='del_month']:checked").each(function () {
  1914. del_month_array.push($(this).val());
  1915. });
  1916. if (del_month_array.length === 0) {
  1917. toastr.error('请选择要移除的月信息价');
  1918. return false;
  1919. }
  1920. postData(window.location.pathname + '/month/save', { type: 'del', updateData: { del_yearmonth: del_month_array } }, function (data) {
  1921. for (const dm of del_month_array) {
  1922. // _.remove(materialMonthSpreadSetting.cols, function (n) {
  1923. // return n.field === dm;
  1924. // });
  1925. _.remove(months, function (n) {
  1926. return n === dm;
  1927. });
  1928. }
  1929. monthsList = data.monthsList;
  1930. monthFunGather.monthsListSet();
  1931. // 工料表单价显示也要更新
  1932. materialBillsData = data.materialBillsData;
  1933. materialSpreadObj.materialSheetReset();
  1934. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  1935. m_tp = data.m_tp;
  1936. if (materialTax) {
  1937. m_tax_tp = data.m_tax_tp;
  1938. }
  1939. resetTpTable();
  1940. $('#remove-month').modal('hide');
  1941. });
  1942. });
  1943. // 导入功能
  1944. let importFile = null;
  1945. $('#upload-xls-file').change(function () {
  1946. const file = this.files[0];
  1947. importFile = file;
  1948. });
  1949. $('#import-bills-btn').click(function() {
  1950. if (!importFile) {
  1951. toastr.error('请选择excel文件再确定');
  1952. return;
  1953. }
  1954. const ext = importFile.name.toLowerCase().split('.').splice(-1)[0];
  1955. const imgStr = /(xls|xlsx|XLS|XLSX)$/;
  1956. if (!imgStr.test(ext)) {
  1957. toastr.error('请导入正确格式的excel文件。');
  1958. return
  1959. }
  1960. const fileReader = new FileReader();
  1961. fileReader.onload = async function(ev) {
  1962. try{
  1963. const data = ev.target.result;
  1964. let tree = [];
  1965. const includeSpec = $('#xls-spec').is(':checked');
  1966. if (/(xls|xlsx|XLS|XLSX)$/.test(ext)) {
  1967. const workbook = XLSX.read(data, {type: 'binary'}); // 以二进制流方式读取得到整份excel表格对象
  1968. const jsonData = transExcel(XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[0]], { defval: null }));
  1969. console.log(jsonData);
  1970. if (!(jsonData[0] && jsonData[0].code !== undefined && jsonData[0].code !== null && jsonData[0].unit !== undefined && jsonData[0].name !== undefined &&
  1971. jsonData[0].spec !== undefined && jsonData[0].msg_tp !== undefined && jsonData[0].msg_times !== undefined)) {
  1972. throw 'excel必须按指定格式内容上传';
  1973. }
  1974. // 去重
  1975. tree = _.unionWith(jsonData, function (item1, item2) {
  1976. return item1.code === item2.code && item1.name === item2.name && item1.unit === item2.unit && (!includeSpec || (includeSpec && item1.spec === item2.spec));
  1977. });
  1978. }
  1979. if (tree.length === 0) {
  1980. throw '该excel不存在导入的数据';
  1981. }
  1982. // 判断msg_tp格式,不符合则无法导入,还有excel日期转换问题
  1983. for (const t of tree) {
  1984. t.code = t.code.toString();
  1985. if (t.msg_tp) {
  1986. if (_.isNumber(t.msg_tp)) {
  1987. const num = parseFloat(t.msg_tp);
  1988. const reg = materialDecimal.up ? new RegExp("^\\d+(\\.\\d{1,"+ materialDecimal.up +"})?$") : new RegExp("^\\d+?$");
  1989. if (num < 0 || !reg.test(num)) {
  1990. t.msg_tp = ZhCalc.round(num, materialDecimal.up);
  1991. }
  1992. } else {
  1993. throw '信息价数据存在非数字字符,无法导入';
  1994. }
  1995. }
  1996. if (_.isNumber(t.msg_times)) {
  1997. t.msg_times = formatDate(t.msg_times, '/');
  1998. }
  1999. t.spec = t.spec === null ? '' : t.spec;
  2000. }
  2001. console.log(tree);
  2002. postData(window.location.pathname + '/save', { type:'export', postData: tree, includeSpec, ms_id: $('#myTab').find('.active').data('msid') || null }, function (result) {
  2003. m_tp = result.m_tp;
  2004. if (materialTax) {
  2005. m_tax_tp = result.m_tax_tp;
  2006. }
  2007. materialBillsData = result.billsData;
  2008. if (isStageSelf) {
  2009. materialStageData = result.stageData;
  2010. materialStageBillsData = result.stageBillsData;
  2011. }
  2012. materialSpreadObj.getMaterialBillsData();
  2013. materialSpreadObj.materialSheetReset(true);
  2014. if (months.length > 0) {
  2015. monthsList = result.monthsList;
  2016. monthFunGather.monthsListSet();
  2017. }
  2018. resetTpTable();
  2019. if (result.addNum || result.updateNum) {
  2020. let msg = [];
  2021. if (result.addNum !== undefined && result.addNum !== 0) {
  2022. msg.push('成功导入工料 ' + result.addNum + ' 条');
  2023. }
  2024. if (result.updateNum !== undefined && result.updateNum !== 0) {
  2025. msg.push('成功更新工料 ' + result.updateNum + ' 条');
  2026. }
  2027. toastr.success(msg.length > 1 ? msg.join(',并') : msg[0]);
  2028. } else {
  2029. toastr.warning('不存在可导入的信息价数据');
  2030. }
  2031. $('#import-info').modal('hide');
  2032. });
  2033. } catch (error) {
  2034. console.log(error);
  2035. toastr.error(error);
  2036. return
  2037. }
  2038. };
  2039. // 以二进制方式打开文件
  2040. fileReader.readAsBinaryString(importFile);
  2041. $('#upload-xls-file').val('');
  2042. importFile = null;
  2043. });
  2044. } else {
  2045. // SpreadJsObj.forbiddenSpreadContextMenu('#material-spread', materialSpread);
  2046. }
  2047. // 筛选调差工料本期应耗数量为0
  2048. $('#bills0_list').click(function () {
  2049. const isCheck = $(this).is(':checked');
  2050. let newMaterialBillsData = materialBillsData;
  2051. if (isCheck) {
  2052. newMaterialBillsData = _.filter(materialBillsData, function (item) {
  2053. return item.quantity !== null && item.quantity !== 0;
  2054. });
  2055. SpreadJsObj.initSpreadSettingEvents(materialSpreadSetting, materialCol);
  2056. SpreadJsObj.initSheet(materialSpread.getActiveSheet(), materialSpreadSetting);
  2057. }
  2058. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
  2059. monthFunGather.monthsListSet(newMaterialBillsData, false);
  2060. materialSpreadObj.refreshActn();
  2061. });
  2062. let gljLib;
  2063. const gljLibCellDoubleClick = function (e, info) {
  2064. if (readOnly || editForAudit) return;
  2065. const gljSheet = info.sheet;
  2066. if (!gljSheet.zh_setting || !gljSheet.zh_tree) { return; }
  2067. const gljTree = gljSheet.zh_tree;
  2068. const gljNode = gljTree.nodes[info.row];
  2069. const sheet = materialSpread.getActiveSheet();
  2070. const select = SpreadJsObj.getSelectObject(sheet);
  2071. if (!gljNode) return;
  2072. if (gljNode && gljNode.is_leaf === 0) {
  2073. toastr.warning('非最底层项目下,不应添加');
  2074. return;
  2075. }
  2076. postData(window.location.pathname + '/save', { type:'add-glj', postData: gljNode, order: select ? select.order : null }, function (result) {
  2077. if (result) {
  2078. // 比order大的+1
  2079. const maxData = select ? _.filter(materialBillsData, (item) => { return item.order > select.order }) : [];
  2080. _.forEach(maxData, function (item) {
  2081. const cl = _.find(materialBillsData, { id: item.id });
  2082. cl.order = item.order + 1;
  2083. });
  2084. materialBillsData.push(result.info);
  2085. materialBillsData.sort(function (a, b) {
  2086. return a.order - b.order
  2087. });
  2088. console.log(materialBillsData);
  2089. if (isStageSelf) {
  2090. materialSpreadObj.updateMaterialData(result);
  2091. materialSpreadObj.getMaterialBillsData();
  2092. }
  2093. // sheet.addRows(materialBillsData.length - 1, 1);
  2094. // SpreadJsObj.reLoadRowData(sheet, materialBillsData.length - 1);
  2095. let newMaterialBillsData = materialBillsData;
  2096. if($('#bills0_list').is(':checked')) {
  2097. newMaterialBillsData = _.filter(materialBillsData, function (item) {
  2098. return item.quantity !== null && item.quantity !== 0;
  2099. });
  2100. }
  2101. SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, newMaterialBillsData);
  2102. // materialSpreadObj.materialSheetReset();
  2103. sheet.setSelection(sheet.zh_data.indexOf(select) + 1, 0, 1, 1);
  2104. materialSpreadObj.refreshActn();
  2105. // 月信息价需要同时添加空白的list
  2106. if (months.length > 0) {
  2107. const one_month ={ mb_id: result.info.id, code: result.info.code, name: result.info.name, origin: result.info.origin, unit: result.info.unit, order: result.info.order };
  2108. for (const m of months) {
  2109. one_month[m] = null;
  2110. }
  2111. _.forEach(maxData, function (item) {
  2112. const cl = _.find(monthsList, { mb_id: item.id });
  2113. cl.order = item.order + 1;
  2114. });
  2115. monthsList.push(one_month);
  2116. monthsList.sort(function (a, b) {
  2117. return a.order - b.order
  2118. });
  2119. console.log(monthsList);
  2120. // const newMonthsList = _.filter(monthsList, function (item) {
  2121. // return _.findIndex(newMaterialBillsData, { code: item.code }) !== -1;
  2122. // });
  2123. // materialMonthSpread.getActiveSheet().addRows(newMonthsList.length - 1, 1);
  2124. // SpreadJsObj.reLoadRowData(materialMonthSpread.getActiveSheet(), newMonthsList.length - 1);
  2125. monthFunGather.monthsListSet();
  2126. // materialMonthSpreadObj.monthsListSet();
  2127. }
  2128. }
  2129. });
  2130. };
  2131. const gljLibSetting = {
  2132. selector: '#material-tab',
  2133. stdType: 'glj',
  2134. libs: gljLists,
  2135. treeSetting: {
  2136. id: 'glj_id',
  2137. pid: 'glj_pid',
  2138. order: 'order',
  2139. level: 'level',
  2140. rootId: -1,
  2141. keys: ['id', 'list_id', 'glj_id'],
  2142. },
  2143. spreadSetting: {
  2144. cols: [
  2145. {title: '编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  2146. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  2147. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  2148. {title: '参考上涨幅度', field: 'rise_range', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  2149. {title: '参考下跌幅度', field: 'fall_range', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  2150. ],
  2151. treeCol: 0,
  2152. emptyRows: 0,
  2153. headRows: 1,
  2154. headRowHeight: [32],
  2155. defaultRowHeight: 21,
  2156. headerFont: '12px 微软雅黑',
  2157. font: '12px 微软雅黑',
  2158. headColWidth: [30],
  2159. selectedBackColor: '#fffacd',
  2160. },
  2161. spreadClassCss: 'sjs-material',
  2162. cellDoubleClick: gljLibCellDoubleClick,
  2163. page: 'material',
  2164. tid: window.location.pathname.split('/')[2],
  2165. };
  2166. $.subMenu({
  2167. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  2168. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  2169. key: 'menu.1.0.0',
  2170. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  2171. callback: function (info) {
  2172. if (info.mini) {
  2173. $('.panel-title').addClass('fluid');
  2174. $('#sub-menu').removeClass('panel-sidebar');
  2175. } else {
  2176. $('.panel-title').removeClass('fluid');
  2177. $('#sub-menu').addClass('panel-sidebar');
  2178. }
  2179. autoFlashHeight();
  2180. materialSpread.refresh();
  2181. }
  2182. });
  2183. $.divResizer({
  2184. select: '#right-spr',
  2185. callback: function () {
  2186. materialSpread.refresh();
  2187. materialMonthSpread.refresh();
  2188. if (gljLib) gljLib.spread.refresh();
  2189. const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
  2190. setLocalCache('material_month_' + materialID, width);
  2191. }
  2192. });
  2193. $.divResizer({
  2194. select: '#main-resize',
  2195. callback: function () {
  2196. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  2197. $(".sp-wrap").height(bcontent-30);
  2198. const height = $('.bcontent-wrap').height();
  2199. const cutHeight = isStageSelf ? getObjHeight($('#myTab')) : 0;
  2200. $('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
  2201. updateSjsHeight();
  2202. materialSpread.refresh();
  2203. materialMonthSpread.refresh();
  2204. if (gljLib) gljLib.spread.refresh();
  2205. setLocalCache('material_bills_' + materialID, height);
  2206. }
  2207. });
  2208. // 展开收起月信息价并浏览器记住本期展开收起
  2209. $('a', '.right-nav').bind('click', function () {
  2210. //const main = $('#main-view'), tool = $('#tools-view');
  2211. const tab = $(this), tabPanel = $(tab.attr('content'));
  2212. if (!tab.hasClass('active')) {
  2213. $('a', '.side-menu').removeClass('active');
  2214. $('#right-view .tab-content .tab-pane').removeClass('active');
  2215. tab.addClass('active');
  2216. tabPanel.addClass('active');
  2217. showSideTools(tab.hasClass('active'));
  2218. if (tab.attr('content') === '#month-tab') {
  2219. const width = (($('#right-view').width()/$('#right-view').parent('div').width())*100).toFixed();
  2220. setLocalCache('material_month_' + materialID, width);
  2221. materialMonthSpread.refresh();
  2222. } else if (tab.attr('content') === '#material-tab') {
  2223. if (!gljLib) {
  2224. gljLib = $.gljLib(gljLibSetting);
  2225. }
  2226. updateSjsHeight();
  2227. gljLib.spread.refresh();
  2228. }
  2229. } else {
  2230. removeLocalCache('material_month_' + materialID);
  2231. tab.removeClass('active');
  2232. tabPanel.removeClass('active');
  2233. showSideTools(tab.hasClass('active'));
  2234. }
  2235. materialSpread.refresh();
  2236. // materialMonthSpread.refresh();
  2237. });
  2238. // 根据浏览器记录展开收起
  2239. if (getLocalCache('material_month_' + materialID) && !isStageSelf) {
  2240. const tab = $('.right-nav a[content="#month-tab"]'), tabPanel = $(tab.attr('content'));
  2241. $('a', '.side-menu').removeClass('active');
  2242. $('#right-view .tab-content .tab-pane').removeClass('active');
  2243. tab.addClass('active');
  2244. tabPanel.addClass('active');
  2245. $('#right-view').width(getLocalCache('material_month_' + materialID) + '%');
  2246. showSideTools(tab.hasClass('active'));
  2247. materialSpread.refresh();
  2248. materialMonthSpread.refresh();
  2249. }
  2250. const cutHeight = isStageSelf ? getObjHeight($('#myTab')) : 0;
  2251. if (getLocalCache('material_bills_' + materialID)) {
  2252. $('.bcontent-wrap').height(getLocalCache('material_bills_' + materialID));
  2253. const cHeader = getObjHeight($(".c-header"));
  2254. const bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  2255. $(".sp-wrap").height(bcontent-30);
  2256. $('.sjs-height-1').height($(window).height()-cHeader-bcontent-90+53);
  2257. $('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
  2258. updateSjsHeight();
  2259. materialSpread.refresh();
  2260. materialMonthSpread.refresh();
  2261. if (gljLib) gljLib.spread.refresh();
  2262. } else {
  2263. $('.sjs-height-material').height($('.sjs-height-1').height() - cutHeight);
  2264. updateSjsHeight();
  2265. materialSpread.refresh();
  2266. materialMonthSpread.refresh();
  2267. if (gljLib) gljLib.spread.refresh();
  2268. }
  2269. function updateSjsHeight() {
  2270. $('.sjs-height-material-month').height($('.sjs-height-1').height() - getObjHeight($('.sjs-bar-1')));
  2271. $('.material-table-height').height($('.bcontent-wrap').height() - getObjHeight($('.bc-bar')));
  2272. $('.sjs-material').height($('.sjs-height-1').height() - getObjHeight($('.sjs-bar')));
  2273. }
  2274. function getObjHeight(select) {
  2275. return select.length > 0 ? select.outerHeight() : 0;
  2276. }
  2277. function formatDate(numb, format) {
  2278. const old = numb - 1;
  2279. const t = Math.round((old - Math.floor(old)) * 24 * 60 * 60);
  2280. const time = new Date(1900, 0, old, 0, 0, t);
  2281. const year = time.getFullYear();
  2282. const month = time.getMonth() + 1;
  2283. const date = time.getDate();
  2284. return year + format + (month < 10 ? '0' + month : month) + format + (date < 10 ? '0' + date : date);
  2285. }
  2286. function transExcel(results) {
  2287. const mapInfo = {
  2288. '编号': 'code',
  2289. '名称': 'name',
  2290. '单位': 'unit',
  2291. '规格': 'spec',
  2292. '信息价': 'msg_tp',
  2293. '时间': 'msg_times',
  2294. };
  2295. return results.map(zhObj => {
  2296. const enObj = {}
  2297. const zhKeys = Object.keys(zhObj);
  2298. zhKeys.forEach(zhKey => {
  2299. const enKey = mapInfo[zhKey];
  2300. enObj[enKey] = zhObj[zhKey] && _.isString(zhObj[zhKey]) ? _.trim(zhObj[zhKey]) : zhObj[zhKey];
  2301. });
  2302. return enObj
  2303. })
  2304. }
  2305. });