change_information_set.js 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726
  1. 'use strict';
  2. /**
  3. * 变更令详细页js
  4. *
  5. * @author EllisRan.
  6. * @date 2018/11/22
  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])) {
  19. return code1[i].charCodeAt() - code2[i].charCodeAt();
  20. } else {
  21. return parseInt(code1[i]) - parseInt(code2[i]);
  22. }
  23. } else if (i+1 == code1length && code1[i] == code2[i]) {
  24. if (code1length == code2length) {
  25. return 0;
  26. } else {
  27. return code1length - code2length;
  28. }
  29. }
  30. } else {
  31. if (i+1 >= code1length) {
  32. return 1;
  33. } else {
  34. return -1;
  35. }
  36. }
  37. }
  38. }
  39. const is_numeric = (value) => {
  40. if (typeof(value) === 'object') {
  41. return false;
  42. } else {
  43. return !Number.isNaN(Number(value)) && value.toString().trim() !== '';
  44. }
  45. };
  46. $.event.special.valuechange = {
  47. teardown: function (namespaces) {
  48. $(this).unbind('.valuechange');
  49. },
  50. handler: function (e) {
  51. $.event.special.valuechange.triggerChanged($(this));
  52. },
  53. add: function (obj) {
  54. $(this).on('keyup.valuechange cut.valuechange paste.valuechange input.valuechange', obj.selector, $.event.special.valuechange.handler)
  55. },
  56. triggerChanged: function (element) {
  57. var current = element[0].contentEditable === 'true' ? element.html() : element.val()
  58. , previous = typeof element.data('previous') === 'undefined' ? element[0].defaultValue : element.data('previous');
  59. if (current !== previous) {
  60. element.trigger('valuechange', [element.data('previous')]);
  61. element.data('previous', current);
  62. }
  63. }
  64. };
  65. $(document).ready(() => {
  66. const style1 = new GC.Spread.Sheets.Style();
  67. style1.locked = true;
  68. const changeCol = {
  69. getValue: {
  70. unit_price: function(data) {
  71. return ZhCalc.round(data.unit_price, unitPriceUnit);
  72. },
  73. oa_tp: function (data) {
  74. return ZhCalc.round(ZhCalc.mul(data.unit_price, data.oamount), totalPriceUnit);
  75. },
  76. ca_tp: function (data) {
  77. return ZhCalc.round(ZhCalc.mul(data.unit_price, data.camount), totalPriceUnit);
  78. },
  79. oamount: function (data) {
  80. return ZhCalc.round(data.oamount, findDecimal(data.unit));
  81. },
  82. camount: function (data) {
  83. return ZhCalc.round(data.camount, findDecimal(data.unit));
  84. },
  85. del_list: function (data) {
  86. return '移除';
  87. }
  88. },
  89. readOnly: {
  90. isEdit: function (data) {
  91. return !readOnly && data.lid != 0;
  92. },
  93. },
  94. };
  95. const changeSpreadObj = {
  96. makeSjsFooter: function () {
  97. // 增加汇总行并设为锁定禁止编辑状态
  98. changeSpreadSheet.addRows(changeSpreadSheet.getRowCount(), 1);
  99. changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 0, '合计');
  100. changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1);
  101. changeSpreadObj.countSum();
  102. },
  103. countSum: function() {
  104. const rowCount = changeSpreadSheet.getRowCount();
  105. let oSum = 0,
  106. cSum = 0;
  107. for(var i = 0; i < rowCount - 1; i++){
  108. oSum = ZhCalc.add(oSum, changeSpreadSheet.getValue(i, 7));
  109. cSum = ZhCalc.add(cSum, changeSpreadSheet.getValue(i, 9));
  110. }
  111. changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 7, oSum !== 0 ? oSum : null);
  112. changeSpreadSheet.setValue(changeSpreadSheet.getRowCount() - 1, 9, cSum !== 0 ? cSum : null);
  113. },
  114. add: function () {
  115. postData(window.location.pathname + '/save', {type: 'add'}, function (result) {
  116. if (result) {
  117. changeList.push(result);
  118. changeSpreadSheet.addRows(changeList.length - 1, 1);
  119. SpreadJsObj.reLoadRowData(changeSpreadSheet, changeList.length - 1);
  120. changeSpreadSheet.setStyle(changeSpreadSheet.getRowCount() - 1, -1, style1);
  121. changeSpreadSheet.setSelection(changeList.length - 1, 0, 1, 1);
  122. }
  123. });
  124. },
  125. del: function () {
  126. const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
  127. const index = changeList.indexOf(select);
  128. if (index > -1) {
  129. postData(window.location.pathname + '/save', {type: 'del', id: select.id}, function (result) {
  130. changeList.splice(index, 1);
  131. changeSpreadSheet.deleteRows(index, 1);
  132. const sel = changeSpreadSheet.getSelections();
  133. changeSpreadSheet.setSelection(0, 0, 1, 1);
  134. if (select.lid != 0) {
  135. tableDataRemake(changeListData);
  136. }
  137. changeSpreadObj.countSum();
  138. });
  139. }
  140. },
  141. selectionChanged: function (e, info) {
  142. const sel = info.sheet.getSelections()[0];
  143. const col = info.sheet.zh_setting.cols[sel.col];
  144. const data = SpreadJsObj.getSelectObject(info.sheet);
  145. if (col.field === 'del_list') {
  146. changeSpreadObj.del();
  147. }
  148. },
  149. editEnded: function (e, info) {
  150. if (info.sheet.zh_setting) {
  151. const select = SpreadJsObj.getSelectObject(info.sheet);
  152. const col = info.sheet.zh_setting.cols[info.col];
  153. if (col.field === 'del_list') {
  154. return;
  155. }
  156. // 未改变值则不提交
  157. let validText = is_numeric(info.editingText) ? parseFloat(info.editingText) : (info.editingText ? trimInvalidChar(info.editingText) : null);
  158. const orgValue = select[col.field];
  159. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  160. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  161. return;
  162. }
  163. // 判断部分值是否输入的是数字判断和数据计算
  164. if (col.type === 'Number') {
  165. if (isNaN(validText)) {
  166. toastr.error('不能输入其它非数字类型字符');
  167. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  168. return;
  169. }
  170. if (col.field === 'unit_price') {
  171. validText = ZhCalc.round(validText, unitPriceUnit);
  172. } else {
  173. validText = ZhCalc.round(validText, findDecimal(select.unit)) || 0;
  174. }
  175. }
  176. if (col.field === 'unit') {
  177. select.camount = ZhCalc.round(select.camount, findDecimal(validText)) || 0;
  178. select.oamount = ZhCalc.round(select.oamount, findDecimal(validText)) || 0;
  179. }
  180. select[col.field] = validText;
  181. if(col.field === 'camount') {
  182. select.spamount = ZhCalc.round(select.camount, findDecimal(validText)) || 0;
  183. }
  184. console.log(select);
  185. // 更新至服务器
  186. postData(window.location.pathname + '/save', { type:'update', updateData: select }, function (result) {
  187. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  188. changeSpreadObj.countSum();
  189. }, function () {
  190. select[col.field] = orgValue;
  191. if(col.field === 'camount') {
  192. select.spamount = orgValue;
  193. }
  194. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  195. });
  196. }
  197. },
  198. clipboardPasted(e, info) {
  199. const hint = {
  200. cellError: {type: 'error', msg: '粘贴内容超出了表格范围'},
  201. numberExpr: {type: 'error', msg: '不能粘贴其它非数字类型字符'},
  202. };
  203. const range = info.cellRange;
  204. const sortData = info.sheet.zh_data || [];
  205. if (info.cellRange.row + info.cellRange.rowCount > sortData.length) {
  206. toastMessageUniq(hint.cellError);
  207. // SpreadJsObj.loadSheetData(materialSpread.getActiveSheet(), SpreadJsObj.DataType.Data, materialBillsData);
  208. SpreadJsObj.reLoadSheetHeader(changeSpreadSheet);
  209. SpreadJsObj.reLoadSheetData(changeSpreadSheet);
  210. return;
  211. }
  212. if (sortData.length > 0 && range.col + range.colCount > 10) {
  213. toastMessageUniq(hint.cellError);
  214. SpreadJsObj.reLoadSheetHeader(changeSpreadSheet);
  215. SpreadJsObj.reLoadSheetData(changeSpreadSheet);
  216. return;
  217. }
  218. const data = [];
  219. // const rowData = [];
  220. for (let iRow = 0; iRow < range.rowCount; iRow++) {
  221. let bPaste = true;
  222. const curRow = range.row + iRow;
  223. // const materialData = JSON.parse(JSON.stringify(sortData[curRow]));
  224. const cLData = { id: sortData[curRow].id };
  225. const hintRow = range.rowCount > 1 ? curRow : '';
  226. let sameCol = 0;
  227. for (let iCol = 0; iCol < range.colCount; iCol++) {
  228. const curCol = range.col + iCol;
  229. const colSetting = info.sheet.zh_setting.cols[curCol];
  230. if (!colSetting) continue;
  231. let validText = info.sheet.getText(curRow, curCol);
  232. validText = is_numeric(validText) ? parseFloat(validText) : (validText ? trimInvalidChar(validText) : null);
  233. const orgValue = sortData[curRow][colSetting.field];
  234. if (orgValue == validText || ((!orgValue || orgValue === '') && (validText === ''))) {
  235. sameCol++;
  236. if (range.colCount === sameCol) {
  237. bPaste = false;
  238. }
  239. continue;
  240. }
  241. if (colSetting.type === 'Number') {
  242. if (isNaN(validText)) {
  243. toastMessageUniq(getPasteHint(hint.numberExpr, hintRow));
  244. bPaste = false;
  245. continue;
  246. }
  247. if (colSetting.field === 'unit_price') {
  248. validText = ZhCalc.round(validText, unitPriceUnit);
  249. } else {
  250. validText = ZhCalc.round(validText, findDecimal(sortData[curRow].unit)) || 0;
  251. }
  252. }
  253. if (colSetting.field === 'unit') {
  254. cLData.camount = ZhCalc.round(sortData[curRow].camount, findDecimal(validText)) || 0;
  255. cLData.oamount = ZhCalc.round(sortData[curRow].oamount, findDecimal(validText)) || 0;
  256. }
  257. cLData[colSetting.field] = validText;
  258. sortData[curRow][colSetting.field] = validText;
  259. cLData.spamount = ZhCalc.round(sortData[curRow].camount, findDecimal(validText)) || 0;
  260. }
  261. if (bPaste) {
  262. data.push(cLData);
  263. // rowData.push(curRow);
  264. } else {
  265. SpreadJsObj.reLoadRowData(info.sheet, curRow);
  266. }
  267. }
  268. if (data.length === 0) {
  269. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  270. return;
  271. }
  272. console.log(data);
  273. // 更新至服务器
  274. postData(window.location.pathname + '/save', { type:'paste', updateData: data }, function (result) {
  275. changeList = result;
  276. SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
  277. changeSpreadObj.makeSjsFooter();
  278. }, function () {
  279. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  280. return;
  281. });
  282. },
  283. };
  284. const preUrl = window.location.pathname.split('/').slice(0, 4).join('/');
  285. let changeListData;
  286. let gclGatherData;
  287. postData(preUrl + '/defaultBills', {}, function (result) {
  288. gclGatherModel.loadLedgerData(result.bills);
  289. gclGatherModel.loadPosData(result.pos);
  290. gclGatherData = gclGatherModel.gatherGclData();
  291. gclGatherData = _.filter(gclGatherData, function (item) {
  292. return item.leafXmjs && item.leafXmjs.length !== 0;
  293. });
  294. for (const ggd in gclGatherData) {
  295. if (gclGatherData[ggd].leafXmjs && gclGatherData[ggd].leafXmjs.length === 0) {
  296. gclGatherData.splice(ggd, 1);
  297. }
  298. gclGatherData[ggd].code = gclGatherData[ggd].b_code;
  299. }
  300. // 数组去重
  301. const dealBillList = result.dealBills;
  302. for (const db of gclGatherData) {
  303. const exist_index = dealBillList.findIndex(function (item) {
  304. return item.code === db.code && item.name === db.name && item.unit === db.unit && item.unit_price === db.unit_price;
  305. });
  306. if (exist_index !== -1) {
  307. dealBillList.splice(exist_index, 1);
  308. }
  309. }
  310. changeListData = gclGatherData.concat(dealBillList).sort(sortByCode);
  311. // 先加载台账数据
  312. let listHtml = '';
  313. let list_index = 1;
  314. let gcl_index = 0;
  315. for (const gcl of changeListData) {
  316. const unit = gcl.unit !== undefined && gcl.unit !== null ? gcl.unit : '';
  317. const quantity = gcl.quantity !== null && gcl.quantity !== undefined ? (unit !== '' ? ZhCalc.round(gcl.quantity, findDecimal(gcl.unit)) : gcl.quantity) : 0;
  318. const unit_price = gcl.unit_price !== null && gcl.unit_price !== undefined ? gcl.unit_price : 0;
  319. let gclhtml = gcl.leafXmjs !== undefined && gcl.leafXmjs !== null ? ' data-gcl="' + gcl_index + '"' : '';
  320. gcl_index = gclhtml !== '' ? ++gcl_index : gcl_index;
  321. const lid = gcl.leafXmjs !== undefined && gcl.leafXmjs !== null ? (gcl.leafXmjs.length !== 0 ? gcl.leafXmjs[0].gcl_id : false) : gcl.id;
  322. if (lid) {
  323. listHtml += '<tr data-lid="' + lid + '"' + gclhtml + ' data-index="' + list_index + '" data-bwmx="">' +
  324. '<td class="text-center">' + list_index + '</td>' +
  325. '<td>' + gcl.code + '</td>' +
  326. '<td class="text-left">' + gcl.name + '</td>' +
  327. '<td class="text-center">' + unit + '</td>' +
  328. '<td class="text-right">' + ZhCalc.round(unit_price, unitPriceUnit) + '</td>' +
  329. '<td class="text-right">' + quantity + '</td>' +
  330. '</tr>';
  331. list_index++;
  332. }
  333. }
  334. $('#table-list-select').html(listHtml);
  335. tableDataRemake(changeListData);
  336. SpreadJsObj.initSpreadSettingEvents(changeSpreadSetting, changeCol);
  337. SpreadJsObj.initSheet(changeSpreadSheet, changeSpreadSetting);
  338. SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
  339. changeSpreadObj.makeSjsFooter();
  340. });
  341. if (!readOnly) {
  342. $('#add-white-btn').click(changeSpreadObj.add);
  343. changeSpread.bind(spreadNS.Events.EditEnded, changeSpreadObj.editEnded);
  344. changeSpread.bind(spreadNS.Events.SelectionChanged, changeSpreadObj.selectionChanged);
  345. changeSpread.bind(spreadNS.Events.ClipboardPasted, changeSpreadObj.clipboardPasted);
  346. changeSpreadSheet.getCell(-1, 10).foreColor('#dc3545');
  347. // 右键菜单
  348. $.contextMenu({
  349. selector: '#change-spread',
  350. build: function ($trigger, e) {
  351. const target = SpreadJsObj.safeRightClickSelection($trigger, e, changeSpread);
  352. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  353. },
  354. items: {
  355. 'createList': {
  356. name: '添加台账清单',
  357. icon: 'fa-sign-in',
  358. callback: function (key, opt) {
  359. $('#addlist').modal('show');
  360. },
  361. },
  362. 'createAdd': {
  363. name: '添加空白清单',
  364. icon: 'fa-sign-in',
  365. callback: function (key, opt) {
  366. changeSpreadObj.add(changeSpreadSheet);
  367. },
  368. },
  369. 'delete': {
  370. name: '删除',
  371. icon: 'fa-remove',
  372. callback: function (key, opt) {
  373. changeSpreadObj.del(changeSpreadSheet);
  374. },
  375. disabled: function (key, opt) {
  376. const select = SpreadJsObj.getSelectObject(changeSpreadSheet);
  377. const sel = changeSpreadSheet.getSelections()[0];
  378. console.log(select, sel);
  379. if (!readOnly && select && sel.row !== changeSpreadSheet.getRowCount() - 1) {
  380. return false;
  381. } else {
  382. return true;
  383. }
  384. }
  385. },
  386. }
  387. });
  388. }
  389. // 清单选中和移除
  390. $('body').on('click', '#table-list-select tr', function () {
  391. $('#table-list-select tr').removeClass('table-warning');
  392. $(this).addClass('table-warning');
  393. const isCheck = $(this).hasClass('table-success') ? true : false;
  394. const data_bwmx = $(this).attr('data-bwmx').split('$#$');
  395. const isDeal = $(this).data('gcl') !== undefined ? true : false;
  396. let codeHtml = '<tr quantity="'+ $(this).children('td').eq(5).text() +'"><td colspan="7" class="colspan_1">&nbsp;</td><td class="colspan_2"><input type="checkbox"></td></tr>';
  397. if (isDeal) {
  398. const lid = $(this).data('lid');
  399. let gcl = _.find(gclGatherData, function (item) {
  400. return item.leafXmjs && item.leafXmjs[0].gcl_id === lid;
  401. });
  402. if (!gcl) {
  403. gcl = gclGatherData[$(this).data('gcl')];
  404. }
  405. codeHtml = '';
  406. for (const leaf of gcl.leafXmjs) {
  407. const quantity = leaf.quantity !== undefined && leaf.quantity !== null ? leaf.quantity : 0;
  408. const bwmx = leaf.bwmx !== undefined ? leaf.bwmx : '';
  409. const isChecked = data_bwmx.indexOf(leaf.code + '!_!' + (leaf.jldy ? leaf.jldy : '') + '!_!' + (bwmx !== '' ? bwmx : leaf.jldy ? leaf.jldy : '') + '*;*' + quantity) !== -1 && isCheck ? 'checked' : '';
  410. codeHtml += '<tr quantity="' + quantity + '"><td>' + leaf.code + '</td>' +
  411. '<td>' + (leaf.jldy ? leaf.jldy: '') + '</td>' +
  412. '<td>' + (leaf.dwgc ? leaf.dwgc : '') + '</td>' +
  413. '<td>' + (leaf.fbgc ? leaf.fbgc : '') + '</td>' +
  414. '<td>' + (leaf.fxgc ? leaf.fxgc : '') + '</td>' +
  415. '<td>' + bwmx + '</td>' +
  416. '<td class="text-right">' + ZhCalc.round(quantity, findDecimal(gcl.unit)) + '</td>' +
  417. '<td class="text-center"><input type="checkbox"' + isChecked +
  418. '></td></tr>';
  419. }
  420. } else if (!isDeal && isCheck) {
  421. codeHtml = '<tr quantity="'+ $(this).children('td').eq(5).text() +'"><td colspan="7" class="colspan_1">&nbsp;</td><td class="colspan_2"><input type="checkbox" checked></td></tr>';
  422. }
  423. $('#code-list').attr('data-index', $(this).children('td').eq(0).text());
  424. $('#code-input').val('');
  425. $('#code-input').siblings('a').hide();
  426. $('#code-list').html(codeHtml);
  427. });
  428. // 右边项目节选择
  429. $('body').on('click', '#code-list input', function () {
  430. let index = $('#code-list').attr('data-index');
  431. if ($(this).is(':checked')) {
  432. // 去除其它可能已选的checked
  433. // $('#code-list input').prop('checked', false);
  434. $(this).prop('checked', true);
  435. // 左边表单传值并添加class
  436. $('#table-list-select tr[data-index="' + index + '"]').addClass('table-success');
  437. // 去除部分data-detail值
  438. let data_bwmx = [];
  439. $('#code-list input:checked').each(function () {
  440. const tr = $(this).parents('tr');
  441. const length = tr.children('td').length;
  442. const bwmx = length === 8 ? tr.children('td').eq(0).text() + '!_!' + tr.children('td').eq(1).text() + '!_!' + (tr.children('td').eq(5).text() !== '' ? tr.children('td').eq(5).text() : tr.children('td').eq(1).text()) : '0';
  443. const quantity = tr.attr('quantity');
  444. const de_qu = bwmx + '*;*' + quantity;
  445. data_bwmx.push(de_qu);
  446. });
  447. data_bwmx = data_bwmx.join('$#$');
  448. $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx);
  449. } else {
  450. // 判断还有无选中项目节编号
  451. if ($('#code-list input').is(':checked')) {
  452. // 去除部分data-detail值
  453. let data_bwmx = [];
  454. $('#code-list input:checked').each(function () {
  455. const tr = $(this).parents('tr');
  456. const length = tr.children('td').length;
  457. const bwmx = length === 8 ? tr.children('td').eq(0).text() + '!_!'+ tr.children('td').eq(1).text() + '!_!' + (tr.children('td').eq(5).text() !== '' ? tr.children('td').eq(5).text() : tr.children('td').eq(1).text()) : '0';
  458. const quantity = tr.attr('quantity');
  459. const de_qu = bwmx + '*;*' + quantity;
  460. data_bwmx.push(de_qu);
  461. });
  462. data_bwmx = data_bwmx.join('$#$');
  463. $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', data_bwmx);
  464. } else {
  465. $('#table-list-select tr[data-index="' + index + '"]').removeClass('table-success');
  466. $('#table-list-select tr[data-index="' + index + '"]').attr('data-bwmx', '');
  467. }
  468. }
  469. });
  470. // 添加空白清单or签约清单
  471. $('.add-list-btn').on('click', function () {
  472. remakeChangeSpread();
  473. SpreadJsObj.loadSheetData(changeSpreadSheet, SpreadJsObj.DataType.Data, changeList);
  474. changeSpreadObj.makeSjsFooter();
  475. $('#addlist').modal('hide');
  476. });
  477. // 选中input所有值
  478. $('body').on('focus', ".clist input", function() {
  479. $(this).select();
  480. });
  481. // 取消选中清单
  482. $('#cancel-list-btn').click(function () {
  483. // $('#table-list-select tr').removeClass('table-success');
  484. // $('#table-list-select tr').attr('data-bwmx', '');
  485. // $('#code-list').html('');
  486. tableDataRemake(changeListData);
  487. });
  488. // 自动编号
  489. $('.reduction-code').click(function () {
  490. const code = $(this).attr('data-code');
  491. $('input[name="code"]').val(code);
  492. });
  493. $('#list-input').on('valuechange', function (e, previous) {
  494. const value = $(this).val();
  495. let showListData = changeListData;
  496. if (value !== '') {
  497. $(this).siblings('a').show();
  498. showListData = _.filter(changeListData, function (c) {
  499. return (c.code && c.code.indexOf(value) !== -1) || (c.name && c.name.indexOf(value) !== -1);
  500. });
  501. } else {
  502. $(this).siblings('a').hide();
  503. }
  504. makeListTable(changeListData, showListData);
  505. $('#table-list-select tr').removeClass('table-warning');
  506. $('#code-input').val('');
  507. $('#code-input').siblings('a').hide();
  508. $('#code-list').html('');
  509. });
  510. $('#code-input').on('valuechange', function (e, previous) {
  511. const value = $(this).val();
  512. if (value !== '') {
  513. $(this).siblings('a').show();
  514. } else {
  515. $(this).siblings('a').hide();
  516. }
  517. makeCodeTable($(this).val());
  518. });
  519. $('.remove-btn').on('click', function () {
  520. $(this).hide();
  521. $(this).siblings('input').val('');
  522. if ($(this).data('btn') === 'list') {
  523. makeListTable(changeListData);
  524. $('#table-list-select tr').removeClass('table-warning');
  525. $('#code-list').html('');
  526. } else {
  527. makeCodeTable();
  528. }
  529. })
  530. });
  531. function findDecimal(unit) {
  532. let value = precision.other.value;
  533. const changeUnits = precision;
  534. for (const d in changeUnits) {
  535. if (changeUnits[d].unit !== undefined && changeUnits[d].unit === unit) {
  536. value = changeUnits[d].value;
  537. break;
  538. }
  539. }
  540. return value;
  541. }
  542. function tableDataRemake(changeListData) {
  543. $('#table-list-select tr').removeClass('table-warning');
  544. $('#table-list-select tr').removeClass('table-success');
  545. $('#table-list-select tr').attr('data-bwmx', '');
  546. $('#code-list').html('');
  547. // 根据已添加的清单显示
  548. if (changeList.length > 0 && changeList[0]) {
  549. for (const [index,clinfo] of changeList.entries()) {
  550. if (clinfo.lid != 0) {
  551. let listinfo = changeListData.find(function (item) {
  552. return (item.id !== undefined && item.id == clinfo.lid) || (item.id === undefined && item.leafXmjs !== undefined && item.leafXmjs.length !== 0 && item.leafXmjs[0].gcl_id == clinfo.lid);
  553. });
  554. if (listinfo === undefined) {
  555. // 针对旧数据获取清单信息
  556. listinfo = changeListData[clinfo.lid - 1];
  557. if (listinfo === undefined) {
  558. toastr.warning('台账清单列表已不存在'+ clinfo.code +',已更新变更清单列表');
  559. changeList.splice(index, 1);
  560. continue;
  561. }
  562. $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').addClass('table-success');
  563. let pushbwmx = '0*;*0';
  564. if (listinfo.leafXmjs !== undefined) {
  565. const leafInfo = listinfo.leafXmjs.find(function (item) {
  566. return (item.bwmx === undefined || item.bwmx === clinfo.bwmx) && (item.quantity !== null ? item.quantity === parseFloat(clinfo.oamount) : 0 === parseFloat(clinfo.oamount));
  567. });
  568. console.log(leafInfo);
  569. if (leafInfo) {
  570. pushbwmx = leafInfo.code + '!_!' + (leafInfo.jldy !== undefined ? leafInfo.jldy : '') + '!_!' + (leafInfo.bwmx !== undefined ? leafInfo.bwmx : '') + '*;*' + (leafInfo.quantity !== null ? leafInfo.quantity : 0);
  571. } else {
  572. toastr.warning('台账清单列表已不存在'+ clinfo.code +',已更新变更清单列表');
  573. changeList.splice(index, 1);
  574. continue;
  575. }
  576. } else {
  577. pushbwmx = '0*;*' + (listinfo.quantity !== null ? listinfo.quantity : 0);
  578. }
  579. const bwmx = $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx');
  580. if (bwmx) {
  581. const bwmxArray = bwmx.split('$#$');
  582. bwmxArray.push(pushbwmx);
  583. $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$'));
  584. } else {
  585. $('#table-list-select tr[data-index="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx);
  586. }
  587. } else {
  588. $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').addClass('table-success');
  589. let pushbwmx = '0*;*0';
  590. if (listinfo.leafXmjs !== undefined) {
  591. const leafInfo = listinfo.leafXmjs.find(function (item) {
  592. return (item.bwmx === undefined || item.bwmx === clinfo.bwmx || item.jldy === clinfo.bwmx) && (item.quantity !== null ? item.quantity === parseFloat(clinfo.oamount) : 0 === parseFloat(clinfo.oamount));
  593. });
  594. if (leafInfo) {
  595. pushbwmx = leafInfo.code + '!_!' + (leafInfo.jldy !== undefined ? leafInfo.jldy : '') + '!_!' + (leafInfo.bwmx !== undefined ? leafInfo.bwmx : (leafInfo.jldy ? leafInfo.jldy : '')) + '*;*' + (leafInfo.quantity !== null ? leafInfo.quantity : 0);
  596. } else {
  597. toastr.warning('台账清单列表已不存在'+ clinfo.code +',已更新变更清单列表');
  598. changeList.splice(index, 1);
  599. continue;
  600. }
  601. } else {
  602. pushbwmx = '0*;*' + (listinfo.quantity !== null ? listinfo.quantity : 0);
  603. }
  604. const bwmx = $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx');
  605. if (bwmx) {
  606. const bwmxArray = bwmx.split('$#$');
  607. bwmxArray.push(pushbwmx);
  608. $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', bwmxArray.join('$#$'));
  609. } else {
  610. $('#table-list-select tr[data-lid="'+ clinfo.lid +'"]').attr('data-bwmx', pushbwmx);
  611. }
  612. }
  613. }
  614. }
  615. }
  616. }
  617. // 清单搜索隐藏清单table部分值
  618. function makeListTable(changeListData, showListData = changeListData) {
  619. // 先加载台账数据
  620. let listHtml = '';
  621. let list_index = 1;
  622. let gcl_index = 0;
  623. for (const [index,gcl] of changeListData.entries()) {
  624. const isShow = _.find(showListData, gcl);
  625. $('#table-list-select tr').eq(index).css('display', (isShow ? 'table-row' : 'none'));
  626. }
  627. }
  628. // 项目节搜索隐藏code-table部分值
  629. function makeCodeTable(search = '') {
  630. if (search === '') {
  631. $('#code-list tr').css('display', 'table-row');
  632. return;
  633. }
  634. for(let i = 0; i < $('#code-list tr').length; i++) {
  635. const length = $('#code-list tr').eq(i).children('td').length;
  636. if (length === 8) {
  637. const code = $('#code-list tr').eq(i).children('td').eq(0).text();
  638. const name = $('#code-list tr').eq(i).children('td').eq(1).text();
  639. const jldy = $('#code-list tr').eq(i).children('td').eq(5).text();
  640. console.log(code, name, jldy, search, code.indexOf(search) !== -1 || name.indexOf(search) !== -1 || jldy.indexOf(search) !== -1);
  641. const isShow = code.indexOf(search) !== -1 || name.indexOf(search) !== -1 || jldy.indexOf(search) !== -1;
  642. $('#code-list tr').eq(i).css('display', (isShow ? 'table-row' : 'none'));
  643. } else {
  644. return;
  645. }
  646. }
  647. }
  648. function remakeChangeSpread() {
  649. const newTableList = [];
  650. // 获取选中的签约清单判断并插入到原有清单中
  651. $('#table-list-select .table-success').each(function(){
  652. let code = $(this).children('td').eq(1).text();
  653. let name = $(this).children('td').eq(2).text();
  654. let unit = $(this).children('td').eq(3).text();
  655. let price = $(this).children('td').eq(4).text();
  656. // let oamount = $(this).children('td').eq(5).text();
  657. // 根据单位获取数量的位数,并得出
  658. // let numdecimal = findDecimal(unit);
  659. // let scnum = makedecimalzero(numdecimal);
  660. let scnum = 0;
  661. // let detail = $(this).attr('data-detail') != 0 ? $(this).attr('data-detail').split('_')[1] : '';
  662. let lid = $(this).data('lid');
  663. let lindex = $(this).data('index');
  664. // 原清单和数量改变
  665. let data_bwmx = $(this).attr('data-bwmx').split('$#$');
  666. for (const b of data_bwmx) {
  667. const oamount = b.split('*;*')[1] != '' ? b.split('*;*')[1] : 0;
  668. let bwmx = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[2] : '';
  669. let xmj_code = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[0] : '';
  670. let xmj_jldy = b.split('*;*')[0] != 0 ? b.split('*;*')[0].split('!_!')[1] : '';
  671. let trlist = {
  672. code,
  673. name,
  674. bwmx,
  675. unit,
  676. unit_price: price,
  677. oamount,
  678. camount: scnum,
  679. detail: '',
  680. lid,
  681. xmj_code,
  682. xmj_jldy,
  683. };
  684. const radionInfo = changeList.find(function (info) {
  685. return info.code === code && (info.lid == lid || parseInt(info.lid) === parseInt(lindex)) && info.bwmx === bwmx;
  686. });
  687. if (radionInfo) {
  688. trlist.camount = radionInfo.camount;
  689. trlist.detail = radionInfo.detail;
  690. }
  691. newTableList.push(trlist);
  692. }
  693. });
  694. const changeWhiteList = _.filter(changeList, function (item) {
  695. return item.lid == 0;
  696. });
  697. console.log(newTableList);
  698. changeList = newTableList.concat(changeWhiteList);
  699. }