config_material_view.js 49 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548
  1. /**
  2. * Created by zhang on 2019/9/10.
  3. */
  4. let configMaterialObj = {
  5. GLJIDMap: {},
  6. relateFilterAgain: false,
  7. configSpread: null,
  8. relatedSpread: null,
  9. evaluateMaterialDatas: [],
  10. bidMaterialDatas: [],
  11. evaluateMaterialSetting: {
  12. header: [{
  13. headerName: "关联",
  14. headerWidth: 80,
  15. dataCode: "is_related",
  16. dataType: "String",
  17. cellType: 'checkBox'
  18. },
  19. {
  20. headerName: "序号",
  21. headerWidth: 80,
  22. dataCode: "seq",
  23. dataType: "String",
  24. formatter: "@"
  25. },
  26. {
  27. headerName: "材料号",
  28. headerWidth: 80,
  29. dataCode: "code",
  30. dataType: "String",
  31. formatter: "@"
  32. },
  33. {
  34. headerName: "材料名称",
  35. headerWidth: 160,
  36. dataCode: "name",
  37. dataType: "String",
  38. cellType: 'tipsCell'
  39. },
  40. {
  41. headerName: "规格型号",
  42. headerWidth: 120,
  43. dataCode: "specs",
  44. hAlign: "left",
  45. dataType: "String",
  46. cellType: 'tipsCell'
  47. },
  48. {
  49. headerName: "单位",
  50. headerWidth: 45,
  51. dataCode: "unit",
  52. hAlign: "center",
  53. dataType: "String"
  54. },
  55. {
  56. headerName: "数量",
  57. headerWidth: 90,
  58. dataCode: "quantity",
  59. hAlign: "right",
  60. dataType: "Number",
  61. validator: "number"
  62. }, //decimalField:'glj.quantity'
  63. {
  64. headerName: "暂定价",
  65. headerWidth: 70,
  66. dataCode: "marketPrice",
  67. hAlign: "right",
  68. dataType: "Number",
  69. validator: "number"
  70. },
  71. {
  72. headerName: "合价",
  73. headerWidth: 90,
  74. dataCode: "totalPrice",
  75. hAlign: "right",
  76. dataType: "Number",
  77. validator: "number",
  78. decimalField: 'bills.totalPrice'
  79. },
  80. {
  81. headerName: "锁定",
  82. headerWidth: 80,
  83. dataCode: "locked",
  84. hAlign: "left",
  85. dataType: "String",
  86. cellType: 'checkBox'
  87. },
  88. {
  89. headerName: "产地",
  90. headerWidth: 80,
  91. dataCode: "originPlace",
  92. hAlign: "left",
  93. dataType: "String",
  94. visible: false
  95. },
  96. {
  97. headerName: "厂家",
  98. headerWidth: 80,
  99. dataCode: "vender",
  100. hAlign: "left",
  101. dataType: "String",
  102. visible: false
  103. },
  104. {
  105. headerName: "备注",
  106. headerWidth: 100,
  107. dataCode: "remark",
  108. hAlign: "left",
  109. dataType: "String"
  110. }
  111. ],
  112. view: {
  113. lockColumns: ["is_related", "totalPrice", "originPlace", "vender", "quantity"]
  114. }
  115. },
  116. bidMaterialSetting: {
  117. header: [{
  118. headerName: "关联",
  119. headerWidth: 80,
  120. dataCode: "is_related",
  121. dataType: "String",
  122. cellType: 'checkBox'
  123. },
  124. {
  125. headerName: "序号",
  126. headerWidth: 80,
  127. dataCode: "seq",
  128. dataType: "String",
  129. formatter: "@"
  130. },
  131. {
  132. headerName: "材料号",
  133. headerWidth: 80,
  134. dataCode: "code",
  135. dataType: "String",
  136. formatter: "@"
  137. },
  138. {
  139. headerName: "材料名称",
  140. headerWidth: 160,
  141. dataCode: "name",
  142. dataType: "String",
  143. cellType: 'tipsCell'
  144. },
  145. {
  146. headerName: "规格型号",
  147. headerWidth: 120,
  148. dataCode: "specs",
  149. hAlign: "left",
  150. dataType: "String",
  151. cellType: 'tipsCell'
  152. },
  153. {
  154. headerName: "单位",
  155. headerWidth: 45,
  156. dataCode: "unit",
  157. hAlign: "center",
  158. dataType: "String"
  159. },
  160. {
  161. headerName: "数量",
  162. headerWidth: 90,
  163. dataCode: "quantity",
  164. hAlign: "right",
  165. dataType: "Number",
  166. validator: "number"
  167. }, //decimalField:'glj.quantity'
  168. {
  169. headerName: "单价",
  170. headerWidth: 70,
  171. dataCode: "marketPrice",
  172. hAlign: "right",
  173. dataType: "Number",
  174. validator: "number"
  175. },
  176. {
  177. headerName: "合价",
  178. headerWidth: 90,
  179. dataCode: "totalPrice",
  180. hAlign: "right",
  181. dataType: "Number",
  182. validator: "number",
  183. decimalField: 'bills.totalPrice'
  184. },
  185. {
  186. headerName: "产地",
  187. headerWidth: 80,
  188. dataCode: "originPlace",
  189. hAlign: "left",
  190. dataType: "String",
  191. visible: false
  192. },
  193. {
  194. headerName: "厂家",
  195. headerWidth: 80,
  196. dataCode: "vender",
  197. hAlign: "left",
  198. dataType: "String",
  199. visible: false
  200. },
  201. {
  202. headerName: "备注",
  203. headerWidth: 100,
  204. dataCode: "remark",
  205. hAlign: "left",
  206. dataType: "String"
  207. }
  208. ],
  209. view: {
  210. lockColumns: ["is_related", "totalPrice", "originPlace", "vender", "quantity"]
  211. }
  212. },
  213. evaluateRelateSetting: {
  214. header: [{
  215. headerName: "关联",
  216. headerWidth: 80,
  217. dataCode: "is_related",
  218. dataType: "String",
  219. cellType: 'checkBox'
  220. },
  221. {
  222. headerName: "编码",
  223. headerWidth: 80,
  224. dataCode: "code",
  225. dataType: "String"
  226. },
  227. {
  228. headerName: "类别",
  229. headerWidth: 45,
  230. dataCode: "short_name",
  231. hAlign: "center",
  232. dataType: "String"
  233. },
  234. {
  235. headerName: "名称",
  236. headerWidth: 160,
  237. dataCode: "name",
  238. dataType: "String",
  239. cellType: 'tipsCell'
  240. },
  241. {
  242. headerName: "规格型号",
  243. headerWidth: 120,
  244. dataCode: "specs",
  245. hAlign: "left",
  246. dataType: "String",
  247. cellType: 'tipsCell'
  248. },
  249. {
  250. headerName: "单位",
  251. headerWidth: 45,
  252. dataCode: "unit",
  253. hAlign: "center",
  254. dataType: "String"
  255. },
  256. {
  257. headerName: "数量",
  258. headerWidth: 90,
  259. dataCode: "quantity",
  260. hAlign: "right",
  261. dataType: "Number",
  262. decimalField: 'glj.quantity'
  263. },
  264. {
  265. headerName: "定额价",
  266. headerWidth: 70,
  267. dataCode: "basePrice",
  268. hAlign: "right",
  269. dataType: "Number",
  270. validator: "number"
  271. },
  272. {
  273. headerName: "市场价",
  274. headerWidth: 70,
  275. dataCode: "marketPrice",
  276. hAlign: "right",
  277. dataType: "Number",
  278. validator: "number"
  279. },
  280. {
  281. headerName: "合价",
  282. headerWidth: 90,
  283. dataCode: "totalPrice",
  284. hAlign: "right",
  285. dataType: "Number",
  286. validator: "number",
  287. decimalField: 'bills.totalPrice'
  288. },
  289. /* {headerName: "供货方式", headerWidth: 70, dataCode: "supply", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:supplyComboMap},
  290. {headerName: "产地", headerWidth: 80, dataCode: "originPlace", hAlign: "left", dataType: "String"},
  291. {headerName: "厂家", headerWidth: 80, dataCode: "vender", hAlign: "left", dataType: "String"}, */
  292. {
  293. headerName: "备注",
  294. headerWidth: 100,
  295. dataCode: "remark",
  296. hAlign: "left",
  297. dataType: "String"
  298. }
  299. ],
  300. view: {
  301. lockColumns: ["code", "type", "name", "specs", "unit", "quantity", "marketPrice", "basePrice", "supply", "originPlace", "vender", "remark"]
  302. }
  303. },
  304. initSpread: function () {
  305. if (!this.configSpread) {
  306. this.configSpread = SheetDataHelper.createNewSpread($("#config_material_sheet")[0], 4);
  307. sheetCommonObj.spreadDefaultStyle(this.configSpread);
  308. this.relatedSpread = SheetDataHelper.createNewSpread($("#related_sheet")[0], 4);
  309. sheetCommonObj.spreadDefaultStyle(this.relatedSpread);
  310. }
  311. this.initEvaluateMaterialSheet();
  312. this.initbidMaterialSheet();
  313. this.initEvaluateRelateSheet();
  314. //打开别人分享的项目,只读
  315. if (projectReadOnly) {
  316. sheetCommonObj.disableSpread(this.configSpread);
  317. sheetCommonObj.disableSpread(this.relatedSpread);
  318. } else {
  319. this.initRightClick();
  320. }
  321. },
  322. initEvaluateMaterialSheet: function () {
  323. this.evaluateMaterialSheet = this.configSpread.getSheet(0);
  324. sheetCommonObj.initSheet(this.evaluateMaterialSheet, this.evaluateMaterialSetting, 30);
  325. this.evaluateMaterialSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onEvaluateMaterialValueChange);
  326. this.evaluateMaterialSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onEvaluateMaterialSelectionChange);
  327. this.evaluateMaterialSheet.bind(GC.Spread.Sheets.Events.EditStarting, this.onEvaluateMaterialEditStarting);
  328. this.evaluateMaterialSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onSheetRangeChange);
  329. this.evaluateMaterialSheet.name('evaluateMaterialSheet');
  330. this.evaluateMaterialSheet.setRowHeight(0, 36, 1);
  331. },
  332. initbidMaterialSheet: function () {
  333. this.bidMaterialSheet = this.configSpread.getSheet(1);
  334. sheetCommonObj.initSheet(this.bidMaterialSheet, this.bidMaterialSetting, 30);
  335. this.bidMaterialSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onBidEvaluateMaterialValueChange);
  336. this.bidMaterialSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, this.onEvaluateMaterialSelectionChange);
  337. this.bidMaterialSheet.bind(GC.Spread.Sheets.Events.EditStarting, this.onBitMaterialEditStarting);
  338. this.bidMaterialSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onSheetRangeChange);
  339. this.bidMaterialSheet.name('bidMaterialSheet');
  340. this.bidMaterialSheet.setRowHeight(0, 36, 1);
  341. },
  342. initEvaluateRelateSheet: function () {
  343. this.evaluateRelateSheet = this.relatedSpread.getSheet(0);
  344. sheetCommonObj.initSheet(this.evaluateRelateSheet, this.evaluateRelateSetting, 30);
  345. this.evaluateRelateSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onEvaluateRelateValueChange);
  346. this.evaluateRelateSheet.bind(GC.Spread.Sheets.Events.EditStarting, this.onEvaluateRelateEditStarting);
  347. //this.evaluateRelateSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onSheetRangeChange);
  348. this.evaluateRelateSheet.name('evaluateRelateSheet');
  349. this.evaluateRelateSheet.setRowHeight(0, 36, 1);
  350. },
  351. showEvaluateMaterialDatas: function () {
  352. this.configSpread.setActiveSheetIndex(0);
  353. let sel = this.evaluateMaterialSheet.getSelections()[0];
  354. let oldData = sel.row < this.evaluateMaterialDatas.length ? this.evaluateMaterialDatas[sel.row] : "";
  355. this.evaluateMaterialDatas = this.getEvaluateMaterialDatas();
  356. sheetCommonObj.showData(this.evaluateMaterialSheet, this.evaluateMaterialSetting, this.evaluateMaterialDatas);
  357. this.evaluateMaterialSheet.setRowCount(this.evaluateMaterialDatas.length);
  358. sel.row = oldData ? _.findIndex(this.evaluateMaterialDatas, {
  359. 'ID': oldData.ID
  360. }) : '';
  361. this.evaluateMaterialSheet.setSelection(sel.row == -1 ? 0 : sel.row, sel.col, sel.rowCount, sel.colCount);
  362. },
  363. showBidMaterialDatas: function () {
  364. this.configSpread.setActiveSheetIndex(1);
  365. let sel = this.bidMaterialSheet.getSelections()[0];
  366. let oldData = sel.row < this.bidMaterialDatas.length ? this.bidMaterialDatas[sel.row] : "";
  367. this.bidMaterialDatas = this.getBidMaterialDatas();
  368. sheetCommonObj.showData(this.bidMaterialSheet, this.bidMaterialSetting, this.bidMaterialDatas);
  369. this.bidMaterialSheet.setRowCount(this.bidMaterialDatas.length);
  370. sel.row = oldData ? _.findIndex(this.bidMaterialDatas, {
  371. 'ID': oldData.ID
  372. }) : '';
  373. this.bidMaterialSheet.setSelection(sel.row == -1 ? 0 : sel.row, sel.col, sel.rowCount, sel.colCount);
  374. },
  375. showEvaluateRelateDatas: function () {
  376. this.relatedSpread.setActiveSheetIndex(0);
  377. this.evaluateRelateDatas = this.getEvaluateRelateDatas();
  378. sheetCommonObj.showData(this.evaluateRelateSheet, this.evaluateRelateSetting, this.evaluateRelateDatas);
  379. this.evaluateRelateSheet.setRowCount(this.evaluateRelateDatas.length);
  380. },
  381. refreshSheetDatas: function () {
  382. if (projectGljObject.displayType == filterType.ZGCL) {
  383. this.showEvaluateMaterialDatas();
  384. } else if (projectGljObject.displayType == filterType.PBCL) {
  385. this.showBidMaterialDatas();
  386. }
  387. this.showEvaluateRelateDatas();
  388. },
  389. setNavLinkText: function (type) {
  390. let text = "关联暂估材料";
  391. switch (type) {
  392. case filterType.ZGCL:
  393. text = "关联暂估材料";
  394. break;
  395. case filterType.PBCL:
  396. text = "关联评标材料";
  397. break;
  398. case filterType.AMAE:
  399. text = "关联材料";
  400. break;
  401. }
  402. $("#related_link").text(text);
  403. },
  404. getEvaluateRelateDatas: function () {
  405. //$('filterGljName')
  406. let name = '',
  407. datas = [],
  408. sheet = null,
  409. field = '',
  410. rdata = [];
  411. switch (projectGljObject.displayType) {
  412. case filterType.ZGCL:
  413. sheet = this.evaluateMaterialSheet;
  414. datas = this.evaluateMaterialDatas;
  415. field = "is_evaluate";
  416. break;
  417. case filterType.PBCL:
  418. sheet = this.bidMaterialSheet;
  419. datas = this.bidMaterialDatas;
  420. field = "is_eval_material";
  421. break;
  422. case filterType.AMAE:
  423. sheet = materialAdjustObj.getSheet();
  424. datas = materialAdjustObj.getSheetDatas();
  425. field = "is_contractor_material";
  426. }
  427. let sel = sheet.getSelections()[0];
  428. let srow = sel.row == -1 || sel.row == "" ? 0 : sel.row;
  429. if (gljUtil.isDef(srow) && datas.length > srow) {
  430. name = this.relateFilterAgain == true ? $('#filterGljName').val() : datas[srow].name;
  431. rdata = this.filterEvaluateRelate(name, datas[srow].projectGLJID, field);
  432. }
  433. if (this.relateFilterAgain == false) $('#filterGljName').val(name);
  434. return rdata;
  435. },
  436. filterEvaluateRelate: function (name, projectGLJID, relateField) {
  437. let datas = [];
  438. let projectGLJ = projectObj.project.projectGLJ;
  439. let materialIdList = projectGLJ.datas.constData.materialIdList;
  440. for (let d of projectGLJ.datas.gljList) {
  441. if (parseFloat(d.quantity) > 0) { //材料类型//materialIdList.indexOf(d.type) >= 0 &&
  442. if (projectGljObject.displayType != filterType.AMAE) {
  443. if (materialIdList.indexOf(d.type) == -1) continue;
  444. }
  445. if (d[relateField] == 1 && d.id != projectGLJID) continue; //排除其它已被关联的工料机
  446. if (name != '') { //name为''时不做过滤
  447. if (d.name.indexOf(name) == -1) {
  448. if (!(d[relateField] == 1 && d.id == projectGLJID)) continue; //虽然不匹配,但是是关联的暂估材料,这时应该显示
  449. }
  450. }
  451. let t = {
  452. id: d.id,
  453. code: d.code,
  454. type: d.type,
  455. short_name: projectGLJ.getShortNameByID(d.type),
  456. name: d.name,
  457. specs: d.specs,
  458. unit: d.unit,
  459. quantity: d.quantity,
  460. supply: d.supply,
  461. originPlace: d.originPlace,
  462. vender: d.vender,
  463. remark: d.remark,
  464. from: d
  465. };
  466. t.is_related = d[relateField] ? 1 : 0;
  467. gljOprObj.setGLJPrice(t, d);
  468. t.totalPrice = scMathUtil.roundForObj(t.quantity * t.marketPrice, getDecimal('bills.totalPrice'));
  469. datas.push(t);
  470. }
  471. }
  472. return _.sortByAll(datas, 'code');
  473. },
  474. getEvaluateMaterialDatas: function (projectGLJList, evaluateList, decimalObj) {
  475. projectGLJList = projectGLJList ? projectGLJList : projectObj.project.projectGLJ.datas.gljList;
  476. evaluateList = evaluateList ? evaluateList : projectObj.project.evaluate_list.datas;
  477. const billsDecimal = decimalObj ? decimalObj.bills.totalPrice : getDecimal('bills.totalPrice');
  478. let datas = [];
  479. let gljMap = _.indexBy(projectGLJList, 'id');
  480. for (let e of evaluateList) {
  481. let t = {
  482. ID: e.ID,
  483. projectID: e.projectID,
  484. is_related: e.is_related, //关联,1关,0不关
  485. projectGLJID: e.projectGLJID, //关联工料机ID
  486. seq: e.seq, //序号
  487. code: e.code,
  488. name: e.name,
  489. specs: e.specs,
  490. unit: e.unit,
  491. type: e.type,
  492. marketPrice: e.market_price,
  493. quantity: e.quantity,
  494. locked: e.locked, //锁定,1锁,0不锁
  495. remark: e.remark,
  496. originPlace: e.originPlace, //产地
  497. vender: e.vender //厂家
  498. };
  499. let pglj = gljMap[e.projectGLJID];
  500. if (e.is_related && pglj) {
  501. gljOprObj.setGLJPrice(t, pglj);
  502. t.originPlace = pglj.originPlace;
  503. t.vender = pglj.vender;
  504. t.brand = pglj.brand;
  505. t.qualityGrace = pglj.qualityGrace;
  506. t.remark = pglj.remark;
  507. t.quantity = pglj.quantity;
  508. }
  509. t.totalPrice = scMathUtil.roundForObj(parseFloat(t.quantity) * parseFloat(t.marketPrice), billsDecimal);
  510. datas.push(t);
  511. }
  512. return _.sortByAll(datas, 'code');
  513. },
  514. getBidMaterialDatas: function (projectGLJList, bidEvaluationList, decimalObj) {
  515. projectGLJList = projectGLJList ? projectGLJList : projectObj.project.projectGLJ.datas.gljList;
  516. bidEvaluationList = bidEvaluationList ? bidEvaluationList : projectObj.project.bid_evaluation_list.datas;
  517. const billsDecimal = decimalObj ? decimalObj.bills.totalPrice : getDecimal('bills.totalPrice');
  518. let datas = [];
  519. let gljMap = _.indexBy(projectGLJList, 'id');
  520. for (let e of bidEvaluationList) {
  521. let t = {
  522. ID: e.ID,
  523. projectID: e.projectID,
  524. is_related: e.is_related, //关联,1关,0不关
  525. projectGLJID: e.projectGLJID, //关联工料机ID
  526. seq: e.seq, //序号
  527. code: e.code,
  528. name: e.name,
  529. specs: e.specs,
  530. unit: e.unit,
  531. type: e.type,
  532. marketPrice: e.market_price,
  533. quantity: e.quantity,
  534. remark: e.remark,
  535. originPlace: e.originPlace, //产地
  536. is_evaluate: 0,
  537. vender: e.vender //厂家
  538. };
  539. let pglj = gljMap[e.projectGLJID];
  540. if (e.is_related && pglj) {
  541. gljOprObj.setGLJPrice(t, pglj);
  542. t.originPlace = pglj.originPlace;
  543. t.vender = pglj.vender;
  544. t.brand = pglj.brand;
  545. t.qualityGrace = pglj.qualityGrace;
  546. t.quantity = pglj.quantity;
  547. t.is_evaluate = pglj.is_evaluate;
  548. }
  549. t.totalPrice = scMathUtil.roundForObj(parseFloat(t.quantity) * parseFloat(t.marketPrice), billsDecimal);
  550. datas.push(t);
  551. }
  552. return _.sortByAll(datas, 'code');
  553. },
  554. updateConfigMaterial: function (dataCode, value, recode) {
  555. let task = [];
  556. for (let t of projectObj.project.projectGLJ.datas.gljList) {
  557. this.GLJIDMap[t.id] = t;
  558. }
  559. let glj = this.GLJIDMap[recode.id];
  560. if (!glj) return;
  561. let pdata = {
  562. doc: {},
  563. action: 'update'
  564. };
  565. pdata['type'] = 'glj_list';
  566. pdata.doc[dataCode] = value;
  567. pdata['id'] = glj.id;
  568. task.push(pdata);
  569. this.getEvaluateUpdateTasks(value, glj, dataCode, task);
  570. this.updateEvaluateMaterial(task, dataCode == "is_evaluate");
  571. },
  572. updateEvaluateMaterial: async function (data, refreshEvaluate = true) {
  573. try {
  574. $.bootstrapLoading.start();
  575. let result = await ajaxPost('/glj/updateEvaluateMaterial', {
  576. tasks: data
  577. });
  578. //先刷新缓存
  579. let [gljs, sendPriceChange] = this.refreshCache(data);
  580. if (refreshEvaluate == true) {
  581. let [rationNodes, impactGLJs] = projectObj.project.projectGLJ.batchChangeIsEvaluate(gljs);
  582. projectObj.project.calcProgram.calcNodesAndSave(rationNodes, function () {
  583. projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
  584. });
  585. }
  586. projectGljObject.refreshViewsData();
  587. gljOprObj.refreshView();
  588. if (sendPriceChange == true) projectGljObject.onUnitFileChange();
  589. } catch (e) {
  590. console.log(e)
  591. } finally {
  592. $.bootstrapLoading.end();
  593. }
  594. },
  595. refreshCache: function (tasks) {
  596. let gljs = [];
  597. let sendPriceChange = false;
  598. for (let t of tasks) {
  599. if (t.type == "evaluate_list") {
  600. refreshDatas(projectObj.project.evaluate_list.datas, t);
  601. } else if (t.type == "bid_evaluation_list") {
  602. refreshDatas(projectObj.project.bid_evaluation_list.datas, t);
  603. } else if (t.type == "contractor_list") {
  604. refreshDatas(projectObj.project.contractor_list.datas, t);
  605. } else {
  606. if (_.isEmpty(this.GLJIDMap)) this.GLJIDMap = _.indexBy(projectObj.project.projectGLJ.datas.gljList, 'id');
  607. //剩下两个类型只有更新操作
  608. if (t.type == "unit_price") {
  609. let g = this.GLJIDMap[t.projectGLJID];
  610. if (g) {
  611. let f = updateProperty(g.unit_price, t.doc);
  612. if (f == true) sendPriceChange = true;
  613. gljs.push(g);
  614. }
  615. }
  616. if (t.type == "glj_list") {
  617. let g = this.GLJIDMap[t.id];
  618. if (g) {
  619. let f = updateProperty(g, t.doc);
  620. if (f == true) sendPriceChange = true;
  621. gljs.push(g);
  622. }
  623. }
  624. }
  625. }
  626. this.GLJIDMap = {};
  627. return [gljs, sendPriceChange];
  628. function refreshDatas(datas, t_t) {
  629. if (t_t.action == "update") {
  630. let e = _.find(datas, {
  631. 'ID': t_t.ID
  632. });
  633. if (e) updateProperty(e, t_t.doc);
  634. }
  635. if (t_t.action == "add") datas.push(t_t.doc);
  636. if (t_t.action == "delete") _.remove(datas, {
  637. 'ID': t_t.ID
  638. });
  639. }
  640. function updateProperty(obj, doc) {
  641. let updatePrice = false;
  642. for (let k in doc) {
  643. obj[k] = doc[k];
  644. if (k == 'base_price' || k == 'market_price') updatePrice = true;
  645. }
  646. return updatePrice;
  647. }
  648. },
  649. getEvaluateUpdateTasks: function (value, glj, dataCode, task) {
  650. let dataList = [],
  651. modelType = 'evaluate_list';
  652. if (dataCode == 'is_evaluate') {
  653. dataList = projectObj.project.evaluate_list.datas;
  654. modelType = 'evaluate_list';
  655. } else if (dataCode == 'is_eval_material') {
  656. dataList = projectObj.project.bid_evaluation_list.datas;
  657. modelType = 'bid_evaluation_list';
  658. }
  659. if (value == 1) { //勾选暂估选项,查看已有的暂估材料列表中是否有名称,编号等完全相同的记录,有则直接关联,无则添加
  660. let evaluate = null;
  661. let pindex = gljUtil.getIndex(glj, gljUtil.materialKeyArray);
  662. for (let e of dataList) {
  663. let eIndex = gljUtil.getIndex(e, gljUtil.materialKeyArray);
  664. if (pindex == eIndex) {
  665. evaluate = e;
  666. break;
  667. }
  668. }
  669. if (evaluate) { //有找到则更新,没有则添加
  670. let edata = {
  671. type: modelType,
  672. doc: {},
  673. action: "update",
  674. ID: evaluate.ID
  675. };
  676. edata.doc = {
  677. projectGLJID: glj.id,
  678. is_related: 1
  679. };
  680. task.push(edata);
  681. if (dataCode == 'is_evaluate') {
  682. let udata = {
  683. type: 'unit_price',
  684. doc: {},
  685. action: "update",
  686. projectGLJID: glj.id,
  687. id: glj.unit_price.id
  688. };
  689. //if(evaluate.base_price != glj.unit_price.base_price) udata.doc['base_price'] = evaluate.base_price;
  690. if (evaluate.market_price != glj.unit_price.market_price) udata.doc['market_price'] = evaluate.market_price;
  691. if (!_.isEmpty(udata.doc)) task.push(udata);
  692. }
  693. } else {
  694. let ndata = {
  695. type: modelType,
  696. doc: {},
  697. action: "add"
  698. };
  699. ndata.doc['ID'] = uuid.v1();
  700. ndata.doc['projectGLJID'] = glj.id;
  701. ndata.doc['is_related'] = 1;
  702. if (dataCode == 'is_evaluate') ndata.doc['locked'] = 0;
  703. ndata.doc['seq'] = glj.code;
  704. ndata.doc['projectID'] = glj.project_id;
  705. ndata.doc['code'] = glj.code;
  706. ndata.doc['name'] = glj.name;
  707. ndata.doc['specs'] = glj.specs;
  708. ndata.doc['unit'] = glj.unit;
  709. ndata.doc['quantity'] = glj.quantity;
  710. ndata.doc['type'] = glj.type;
  711. ndata.doc['market_price'] = glj.unit_price.market_price;
  712. ndata.doc['originPlace'] = glj.originPlace;
  713. ndata.doc['vender'] = glj.vender;
  714. ndata.doc['remark'] = glj.remark;
  715. task.push(ndata);
  716. }
  717. } else if (value == 0) {
  718. let t_evaluate = null;
  719. for (let e of dataList) {
  720. if (e.projectGLJID == glj.id && e.is_related == 1) {
  721. t_evaluate = e;
  722. break;
  723. }
  724. }
  725. if (t_evaluate) {
  726. let tdata = {
  727. type: modelType,
  728. doc: {
  729. is_related: 0,
  730. quantity: '0'
  731. },
  732. action: "update",
  733. ID: t_evaluate.ID
  734. };
  735. task.push(tdata);
  736. }
  737. }
  738. },
  739. onEvaluateMaterialSelectionChange: function (sender, args) {
  740. let me = configMaterialObj;
  741. let newSel = args.newSelections[0];
  742. let oldSel = args.oldSelections ? args.oldSelections[0] : {};
  743. if (newSel.row != oldSel.row) {
  744. me.showEvaluateRelateDatas();
  745. me.relateFilterAgain = false;
  746. }
  747. },
  748. onBidEvaluateMaterialValueChange: function (e, info) {
  749. let me = configMaterialObj,
  750. row = info.row,
  751. col = info.col;
  752. let dataCode = me.bidMaterialSetting.header[col].dataCode;
  753. let value = info.newValue;
  754. let bid = me.bidMaterialDatas[row];
  755. if (value && !sheetCommonObj.checkData(col, me.bidMaterialSetting, value)) {
  756. alert('输入的数据类型不对,请重新输入!');
  757. return me.showBidMaterialDatas();
  758. }
  759. if (dataCode == 'marketPrice') {
  760. dataCode = 'market_price';
  761. if (bid.is_related) { //关联的情况下,直接修改工料机价格
  762. if (bid.is_evaluate == 1) {
  763. alert("当前材料市场价已被锁定,修改请先返回人材机汇总界面解除锁定。");
  764. return me.showBidMaterialDatas();
  765. }
  766. return projectObj.project.projectGLJ.updatePrice(bid, dataCode, value, 'rg', projectGljObject.refreshViewsData);
  767. }
  768. value = scMathUtil.roundToString(value, getDecimal('glj.unitPrice'));
  769. }
  770. if (value && dataCode === 'quantity') { //修改数量需做4舍5入
  771. value = scMathUtil.roundToString(value, getDecimal('glj.quantity'));
  772. }
  773. let edata = {
  774. type: 'bid_evaluation_list',
  775. doc: {},
  776. action: "update",
  777. ID: bid.ID
  778. };
  779. if (bid[dataCode] == value) return me.showBidMaterialDatas();
  780. edata.doc[dataCode] = value;
  781. me.updateEvaluateMaterial([edata], false);
  782. },
  783. onSheetRangeChange: function (e, args) {
  784. let me = configMaterialObj,
  785. updateMap = {},
  786. modelType = '',
  787. setting = {},
  788. datas = [],
  789. tasks = [];
  790. switch (projectGljObject.displayType) {
  791. case filterType.ZGCL:
  792. modelType = "evaluate_list";
  793. setting = me.evaluateMaterialSetting;
  794. datas = me.evaluateMaterialDatas;
  795. break;
  796. case filterType.PBCL:
  797. modelType = "bid_evaluation_list";
  798. setting = me.bidMaterialSetting;
  799. datas = me.bidMaterialDatas;
  800. break;
  801. }
  802. for (let c of args.changedCells) {
  803. let dataCode = setting.header[c.col].dataCode;
  804. let value = args.sheet.getCell(c.row, c.col).text();
  805. let recode = datas[c.row];
  806. if (me.editChecking(recode, dataCode, modelType == "evaluate_list") == false) {
  807. me.refreshSheetDatas();
  808. return;
  809. }
  810. if (value && !sheetCommonObj.checkData(c.col, setting, value)) {
  811. alert('输入的数据类型不对,请重新输入!');
  812. me.refreshSheetDatas();
  813. return;
  814. }
  815. if (dataCode == 'marketPrice') {
  816. dataCode = 'market_price';
  817. if (recode.is_related) { //关联的情况下,直接修改工料机价格 暂时不支持批量修改
  818. return projectObj.project.projectGLJ.updatePrice(recode, dataCode, value, 'rg', null, projectGljObject.refreshViewsData);
  819. }
  820. } else {
  821. let tem = updateMap[recode.ID] ? updateMap[recode.ID] : {};
  822. if (value && dataCode === 'quantity') value = scMathUtil.roundToString(value, getDecimal('glj.quantity')); //修改数量需做4舍5入
  823. if (value == recode[dataCode]) continue;
  824. tem[dataCode] = value;
  825. updateMap[recode.ID] = tem;
  826. }
  827. }
  828. for (let ID in updateMap) {
  829. let edata = {
  830. type: modelType,
  831. doc: updateMap[ID],
  832. action: "update",
  833. ID: ID
  834. };
  835. tasks.push(edata);
  836. }
  837. if (tasks.length > 0) me.updateEvaluateMaterial(tasks, false);
  838. },
  839. onEvaluateMaterialValueChange: function (e, info) {
  840. let me = configMaterialObj,
  841. row = info.row,
  842. col = info.col;
  843. let dataCode = me.evaluateMaterialSetting.header[col].dataCode;
  844. let value = info.newValue;
  845. let evaluate = me.evaluateMaterialDatas[row];
  846. if (value && !sheetCommonObj.checkData(col, me.evaluateMaterialSetting, value)) {
  847. alert('输入的数据类型不对,请重新输入!');
  848. return me.showEvaluateMaterialDatas();
  849. }
  850. if (dataCode == 'locked') value = value == true ? 1 : 0;
  851. if (dataCode == 'marketPrice') {
  852. dataCode = 'market_price';
  853. if (evaluate.is_related) { //关联的情况下,直接修改工料机价格
  854. return projectObj.project.projectGLJ.updatePrice(evaluate, dataCode, value, 'rg', projectGljObject.refreshViewsData);
  855. }
  856. }
  857. if (value && dataCode === 'quantity') { //修改数量需做4舍5入
  858. value = scMathUtil.roundToString(value, getDecimal('glj.quantity'));
  859. }
  860. let edata = {
  861. type: 'evaluate_list',
  862. doc: {},
  863. action: "update",
  864. ID: evaluate.ID
  865. };
  866. if (evaluate[dataCode] == value) return me.showEvaluateMaterialDatas();
  867. edata.doc[dataCode] = value;
  868. me.updateEvaluateMaterial([edata], false);
  869. },
  870. onEvaluateRelateValueChange: function (e, info) {
  871. let me = configMaterialObj,
  872. row = info.row,
  873. col = info.col;
  874. let value = info.newValue;
  875. let sheet = null,
  876. datas = [],
  877. field = "",
  878. type = "";
  879. switch (projectGljObject.displayType) {
  880. case filterType.ZGCL:
  881. sheet = me.evaluateMaterialSheet;
  882. datas = me.evaluateMaterialDatas;
  883. field = "is_evaluate";
  884. type = "evaluate_list";
  885. break;
  886. case filterType.PBCL:
  887. sheet = me.bidMaterialSheet;
  888. datas = me.bidMaterialDatas;
  889. field = "is_eval_material";
  890. type = "bid_evaluation_list";
  891. break;
  892. case filterType.AMAE:
  893. sheet = materialAdjustObj.getSheet();
  894. datas = materialAdjustObj.getSheetDatas();
  895. field = "is_contractor_material";
  896. type = "contractor_list";
  897. }
  898. let sel = sheet.getSelections()[0];
  899. let srow = sel.row == -1 || sel.row == "" ? 0 : sel.row;
  900. let task = [];
  901. value = value == true ? 1 : 0;
  902. if (datas.length > srow) {
  903. let evaluate = datas[srow];
  904. let relate = me.evaluateRelateDatas[row];
  905. let pdata = {
  906. id: relate.id,
  907. doc: {},
  908. action: 'update',
  909. type: "glj_list"
  910. };
  911. pdata.doc[field] = value;
  912. task.push(pdata);
  913. let tdata = {
  914. type: type,
  915. doc: {},
  916. action: "update",
  917. ID: evaluate.ID
  918. };
  919. if (value == 0) { //如果是0的话
  920. tdata.doc = {
  921. is_related: 0,
  922. quantity: '0'
  923. };
  924. } else {
  925. if (relate.unit != evaluate.unit) { //检查单位是否相同,如果不同不能关联
  926. alert("单位不一致,不允许关联!");
  927. return me.showEvaluateRelateDatas();
  928. }
  929. //如果已经关联了其它项目工料机,要把那个项目工料机的是否暂估标记为否
  930. if (evaluate.is_related == 1) {
  931. let tdoc = {};
  932. tdoc[field] = 0;
  933. task.push({
  934. id: evaluate.projectGLJID,
  935. doc: tdoc,
  936. action: 'update',
  937. type: "glj_list"
  938. });
  939. }
  940. //更新暂估材料的工料机ID,和关联标记
  941. tdata.doc = {
  942. projectGLJID: relate.id,
  943. is_related: 1
  944. };
  945. if (projectGljObject.displayType == filterType.ZGCL) {
  946. //更新新关联工料机的市场价格
  947. let udata = {
  948. type: 'unit_price',
  949. doc: {},
  950. action: "update",
  951. projectGLJID: relate.from.id,
  952. id: relate.from.unit_price.id
  953. };
  954. //if(evaluate.base_price != relate.from.unit_price.base_price) udata.doc['base_price'] = evaluate.base_price;
  955. if (evaluate.marketPrice != relate.from.unit_price.market_price) udata.doc['market_price'] = evaluate.marketPrice;
  956. if (!_.isEmpty(udata.doc)) task.push(udata);
  957. }
  958. }
  959. task.push(tdata);
  960. me.updateEvaluateMaterial(task);
  961. }
  962. },
  963. deleteMaterial: function (row) {
  964. let me = configMaterialObj;
  965. let evaluate = {},
  966. task = [],
  967. type = '',
  968. field = '';
  969. switch (projectGljObject.displayType) {
  970. case filterType.ZGCL:
  971. evaluate = me.evaluateMaterialDatas[row];
  972. field = "is_evaluate";
  973. type = "evaluate_list";
  974. break;
  975. case filterType.PBCL:
  976. evaluate = me.bidMaterialDatas[row];
  977. field = "is_eval_material";
  978. type = "bid_evaluation_list";
  979. break;
  980. case filterType.AMAE:
  981. let t_datas = materialAdjustObj.getSheetDatas();
  982. evaluate = t_datas[row];
  983. field = "is_contractor_material";
  984. type = "contractor_list";
  985. }
  986. if (evaluate) {
  987. task.push({
  988. type: type,
  989. action: "delete",
  990. ID: evaluate.ID
  991. });
  992. if (evaluate.is_related == 1) { //如果关联了工料机,则要把工料机标记为不是暂估
  993. let tdoc = {};
  994. tdoc[field] = 0;
  995. task.push({
  996. id: evaluate.projectGLJID,
  997. doc: tdoc,
  998. action: 'update',
  999. type: "glj_list"
  1000. })
  1001. }
  1002. me.updateEvaluateMaterial(task);
  1003. }
  1004. },
  1005. onEvaluateMaterialEditStarting: function (sender, args) {
  1006. let me = configMaterialObj;
  1007. let row = args.row,
  1008. col = args.col;
  1009. let evaluate = me.evaluateMaterialDatas[row];
  1010. let dataCode = me.evaluateMaterialSetting.header[col].dataCode;
  1011. if (me.editChecking(evaluate, dataCode, true) == false) args.cancel = true;
  1012. },
  1013. editChecking: function (record, dataCode, checkLock = false) { //return false 为不能编辑
  1014. if (checkLock && record.locked) return false;
  1015. if ((dataCode == 'quantity' || dataCode == 'unit') && record.is_related) return false; //在关联的情况下,数量和单位不可编辑
  1016. return true;
  1017. },
  1018. onBitMaterialEditStarting: function (sender, args) {
  1019. let me = configMaterialObj;
  1020. let row = args.row,
  1021. col = args.col;
  1022. let bid = me.bidMaterialDatas[row];
  1023. let dataCode = me.bidMaterialSetting.header[col].dataCode;
  1024. if (me.editChecking(bid, dataCode) == false) args.cancel = true;
  1025. },
  1026. onEvaluateRelateEditStarting: function (sender, args) {
  1027. let me = configMaterialObj;
  1028. let row = args.row,
  1029. col = args.col;
  1030. args.cancel = true;
  1031. },
  1032. insertEmptyRow: function () {
  1033. let m_t = "";
  1034. switch (projectGljObject.displayType) {
  1035. case filterType.ZGCL:
  1036. m_t = "evaluate_list";
  1037. break;
  1038. case filterType.PBCL:
  1039. m_t = "bid_evaluation_list";
  1040. break;
  1041. }
  1042. let ndata = {
  1043. type: m_t,
  1044. doc: {},
  1045. action: "add"
  1046. };
  1047. ndata.doc['ID'] = uuid.v1();
  1048. ndata.doc['is_related'] = 0;
  1049. if (m_t == "evaluate_list") ndata.doc['locked'] = 0;
  1050. ndata.doc['seq'] = "";
  1051. ndata.doc['projectID'] = projectObj.project.ID();
  1052. ndata.doc['code'] = "";
  1053. ndata.doc['name'] = "";
  1054. ndata.doc['unit'] = "";
  1055. ndata.doc['originPlace'] = "";
  1056. ndata.doc['vender'] = "";
  1057. ndata.doc['remark'] = "";
  1058. configMaterialObj.updateEvaluateMaterial([ndata], false);
  1059. },
  1060. initRightClick: function () {
  1061. let me = this;
  1062. $.contextMenu({
  1063. selector: '#config_material_sheet',
  1064. build: function ($trigger, e) {
  1065. me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.configSpread);
  1066. return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
  1067. me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  1068. },
  1069. items: {
  1070. "addFromGLJ": {
  1071. name: '从人材机汇总中选择',
  1072. icon: 'fa-sign-in',
  1073. disabled: function () {
  1074. return false;
  1075. },
  1076. callback: function (key, opt) {
  1077. if (projectGljObject.displayType == filterType.AMAE) {
  1078. materialAdjustObj.checkedDefualtOption("glj_sel_input");
  1079. $("#selectFromGLJ").modal('show');
  1080. } else {
  1081. // materialAdjustObj.checkedDefualtOption("pglj_sel_input"); 暂时没有这个
  1082. $("#selectPGLJ").modal('show');
  1083. }
  1084. }
  1085. },
  1086. "insertRow": {
  1087. name: '插入',
  1088. icon: 'fa-sign-in',
  1089. disabled: function () {
  1090. return false;
  1091. },
  1092. callback: function (key, opt) {
  1093. if (projectGljObject.displayType == filterType.AMAE) {
  1094. materialAdjustObj.insertEmptyRow();
  1095. } else {
  1096. configMaterialObj.insertEmptyRow();
  1097. }
  1098. }
  1099. },
  1100. "deleteAdjust": {
  1101. name: "删除",
  1102. icon: 'fa-trash-o',
  1103. disabled: function () {
  1104. return me.rightClickTarget.row === undefined;
  1105. },
  1106. callback: function (key, opt) {
  1107. let row = me.rightClickTarget.row;
  1108. me.deleteMaterial(row);
  1109. }
  1110. }
  1111. }
  1112. });
  1113. }
  1114. };
  1115. let pgljSelObj = {
  1116. spread: null,
  1117. sheet: null,
  1118. datas: [],
  1119. setting: {
  1120. header: [{
  1121. headerName: "选择",
  1122. headerWidth: 45,
  1123. dataCode: "select",
  1124. hAlign: "center",
  1125. dataType: "String",
  1126. cellType: 'checkBox'
  1127. },
  1128. {
  1129. headerName: "编码",
  1130. headerWidth: 80,
  1131. dataCode: "code",
  1132. dataType: "String"
  1133. },
  1134. {
  1135. headerName: "类型",
  1136. headerWidth: 30,
  1137. dataCode: "short_name",
  1138. hAlign: "center",
  1139. dataType: "String"
  1140. },
  1141. {
  1142. headerName: "名称",
  1143. headerWidth: 160,
  1144. dataCode: "name",
  1145. dataType: "String",
  1146. cellType: 'tipsCell'
  1147. },
  1148. {
  1149. headerName: "规格型号",
  1150. headerWidth: 100,
  1151. dataCode: "specs",
  1152. hAlign: "left",
  1153. dataType: "String",
  1154. cellType: 'tipsCell'
  1155. },
  1156. {
  1157. headerName: "单位",
  1158. headerWidth: 45,
  1159. dataCode: "unit",
  1160. hAlign: "center",
  1161. dataType: "String"
  1162. },
  1163. {
  1164. headerName: "总消耗量",
  1165. headerWidth: 90,
  1166. dataCode: "quantity",
  1167. hAlign: "right",
  1168. dataType: "Number",
  1169. decimalField: 'glj.quantity'
  1170. },
  1171. {
  1172. headerName: "市场价",
  1173. headerWidth: 70,
  1174. dataCode: "marketPrice",
  1175. hAlign: "right",
  1176. dataType: "Number",
  1177. validator: "number"
  1178. }, //,decimalField:"glj.unitPrice"
  1179. {
  1180. headerName: "供货方式",
  1181. headerWidth: 70,
  1182. dataCode: "supply",
  1183. hAlign: "center",
  1184. dataType: "String",
  1185. cellType: 'comboBox',
  1186. editorValueType: true,
  1187. options: supplyComboMap
  1188. },
  1189. {
  1190. headerName: "暂估",
  1191. headerWidth: 45,
  1192. dataCode: "is_evaluate",
  1193. hAlign: "center",
  1194. dataType: "String",
  1195. cellType: 'checkBox'
  1196. },
  1197. /* {
  1198. headerName: "产地",
  1199. headerWidth: 80,
  1200. dataCode: "originPlace",
  1201. hAlign: "left",
  1202. dataType: "String"
  1203. },
  1204. {
  1205. headerName: "厂家",
  1206. headerWidth: 80,
  1207. dataCode: "vender",
  1208. hAlign: "left",
  1209. dataType: "String"
  1210. }, */
  1211. {
  1212. headerName: "备注",
  1213. headerWidth: 100,
  1214. dataCode: "remark",
  1215. hAlign: "left",
  1216. dataType: "String"
  1217. }
  1218. ],
  1219. view: {
  1220. lockColumns: ["is_evaluate"]
  1221. }
  1222. },
  1223. checkType: "取消", //记住点击过的按钮的text
  1224. initSpread: function () {
  1225. if (!this.spread) {
  1226. this.spread = SheetDataHelper.createNewSpread($("#pglj_from_sheet")[0]);
  1227. sheetCommonObj.spreadDefaultStyle(this.spread);
  1228. } else {
  1229. this.spread.refresh();
  1230. }
  1231. this.sheet = this.spread.getSheet(0);
  1232. sheetCommonObj.initSheet(this.sheet, this.setting);
  1233. this.sheet.bind(GC.Spread.Sheets.Events.EditStarting, this.onEditStarting);
  1234. this.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, this.onClipboardPasting);
  1235. this.sheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onValueChanged);
  1236. this.sheet.setRowHeight(0, 36, 1);
  1237. disableRightMenu("pglj_from_sheet", this.spread);
  1238. },
  1239. onEditStarting: function (e, args) {
  1240. args.cancel = true;
  1241. },
  1242. onClipboardPasting: function (e, args) {
  1243. args.cancel = true;
  1244. },
  1245. onValueChanged: function (e, args) {
  1246. let me = pgljSelObj;
  1247. let value = args.newValue;
  1248. value = value == true ? 1 : 0;
  1249. me.datas[args.row].select = value;
  1250. },
  1251. showDatas: function () {
  1252. this.datas = [];
  1253. let gljList = projectObj.project.projectGLJ.datas.gljList;
  1254. gljList = this.filterGLJ(gljList);
  1255. gljList = sortProjectGLJ(gljList);
  1256. for (let glj of gljList) {
  1257. this.datas.push(this.getSheetDatas(glj));
  1258. }
  1259. this.refreshDatas();
  1260. },
  1261. filterGLJ: function (gljList) {
  1262. let typeMap = {};
  1263. for (let ch of $(".pglj_sel_input:checked")) {
  1264. typeMap[$(ch).val()] = true;
  1265. }
  1266. let inputV = $("#pglj_sel_input").val();
  1267. return _.filter(gljList, function (item) {
  1268. if (item.quantity === 0 || item.quantity === '0') return false;
  1269. let firstS = (item.type + "").substring(0, 1);
  1270. if (!typeMap[firstS]) return false;
  1271. if (inputV != "") { //输入的关键字过滤
  1272. if (item.code.indexOf(inputV) == -1 && item.name.indexOf(inputV) == -1) return false
  1273. }
  1274. return true;
  1275. });
  1276. },
  1277. refreshDatas: function () {
  1278. this.checkByType(this.checkType);
  1279. sheetCommonObj.showData(this.sheet, this.setting, this.datas);
  1280. this.sheet.setRowCount(this.datas.length);
  1281. },
  1282. getSheetDatas(glj) {
  1283. let projectGLJ = projectObj.project.projectGLJ;
  1284. let materialIdList = projectGLJ.datas.constData.materialIdList;
  1285. let data = this.getCommonObject(glj);
  1286. data.select = projectGljObject.displayType == filterType.ZGCL ? glj.is_evaluate : glj.is_eval_material;
  1287. if (!gljUtil.isDef(data.select)) data.select = 0;
  1288. data.from = glj;
  1289. data.short_name = projectGLJ.getShortNameByID(glj.type);
  1290. // 只有材料才显示是否暂估
  1291. // if (materialIdList.indexOf(glj.type) >= 0) data.is_evaluate = glj.is_evaluate;
  1292. data.is_eval_material = glj.is_eval_material;
  1293. data.is_evaluate = glj.is_evaluate;
  1294. return data;
  1295. },
  1296. getCommonObject: function (glj) {
  1297. let data = {
  1298. select: 0,
  1299. id: glj.id,
  1300. code: glj.code,
  1301. name: glj.name,
  1302. specs: glj.specs,
  1303. unit: glj.unit,
  1304. type: glj.type,
  1305. quantity: glj.quantity,
  1306. supply: glj.supply,
  1307. originPlace: glj.originPlace,
  1308. vender: glj.vender,
  1309. brand: glj.brand,
  1310. remark: glj.remark
  1311. };
  1312. gljOprObj.setGLJPrice(data, glj);
  1313. return data;
  1314. },
  1315. checkByType: function (type) {
  1316. for (let d of this.datas) {
  1317. d.select = 0;
  1318. switch (type) {
  1319. case "全选":
  1320. d.select = 1;
  1321. break;
  1322. case "全选主材":
  1323. if (d.type == 4) d.select = 1;
  1324. break;
  1325. case "全选设备":
  1326. if (d.type == 5) d.select = 1;
  1327. break;
  1328. case "取消":
  1329. d.select = projectGljObject.displayType == filterType.ZGCL ? d.is_evaluate : d.is_eval_material;
  1330. if (!gljUtil.isDef(d.select)) d.select = 0;
  1331. break;
  1332. }
  1333. }
  1334. //this.refreshDatas();
  1335. },
  1336. confirmSelect: function () {
  1337. let tasks = [];
  1338. let datas = [],
  1339. modelType = '',
  1340. field = '';
  1341. switch (projectGljObject.displayType) {
  1342. case filterType.ZGCL:
  1343. datas = projectObj.project.evaluate_list.datas;
  1344. field = "is_evaluate";
  1345. modelType = "evaluate_list";
  1346. break;
  1347. case filterType.PBCL:
  1348. datas = projectObj.project.bid_evaluation_list.datas;
  1349. field = "is_eval_material";
  1350. modelType = "bid_evaluation_list";
  1351. break;
  1352. }
  1353. let evaluateMap = _.indexBy(datas, "projectGLJID");
  1354. let evaluateKeyMap = {}; //关键字映射表
  1355. for (let e of datas) {
  1356. let eIndex = gljUtil.getIndex(e, gljUtil.materialKeyArray);
  1357. evaluateKeyMap[eIndex] = e;
  1358. }
  1359. for (let d of this.datas) {
  1360. if (d.select == 1) { //如果是选中状态
  1361. if (d[field] == 1) { //如果已经标记为暂估或评标材料,查看是否已经存在关联的材料
  1362. let evl = evaluateMap[d.id];
  1363. if (evl) {
  1364. //这里应该是错误检查的保证,按正常是不应该出现这种情况的
  1365. if (evl.is_related != 1) tasks.push({
  1366. type: modelType,
  1367. doc: {
  1368. projectGLJID: d.id,
  1369. is_related: 1
  1370. },
  1371. action: "update",
  1372. ID: evl.ID
  1373. });
  1374. } else {
  1375. tasks.push(getNewEval(d, modelType))
  1376. }
  1377. } else { //如果不是暂估,要改成暂估
  1378. let pdata = {
  1379. id: d.id,
  1380. doc: {},
  1381. action: 'update',
  1382. type: "glj_list"
  1383. };
  1384. pdata.doc[field] = 1;
  1385. tasks.push(pdata);
  1386. let evaluate = evaluateKeyMap[gljUtil.getIndex(d, gljUtil.materialKeyArray)];
  1387. if (evaluate) { //如果已经存在5个关键字相同的暂估材料,则自动关联起来
  1388. let edata = {
  1389. type: modelType,
  1390. doc: {
  1391. projectGLJID: d.id,
  1392. is_related: 1
  1393. },
  1394. action: "update",
  1395. ID: evaluate.ID
  1396. };
  1397. tasks.push(edata);
  1398. if (modelType == 'evaluate_list') {
  1399. let udata = {
  1400. type: 'unit_price',
  1401. doc: {},
  1402. action: "update",
  1403. projectGLJID: d.id,
  1404. id: d.from.unit_price.id
  1405. };
  1406. if (evaluate.market_price != d.from.unit_price.market_price) udata.doc['market_price'] = evaluate.market_price;
  1407. if (!_.isEmpty(udata.doc)) tasks.push(udata);
  1408. }
  1409. } else { //如果不存在,则生成一条新的
  1410. tasks.push(getNewEval(d, modelType));
  1411. }
  1412. }
  1413. } else { //未选中状态的,检查一下是否存在关联的情况,取消关联
  1414. let tdoc = {};
  1415. tdoc[field] = 0;
  1416. if (d[field] == 1) tasks.push({
  1417. id: d.id,
  1418. doc: tdoc,
  1419. action: 'update',
  1420. type: "glj_list"
  1421. });
  1422. let evl = evaluateMap[d.id];
  1423. if (evl) {
  1424. if (evl.is_related == 1) tasks.push({
  1425. type: modelType,
  1426. doc: {
  1427. is_related: 0
  1428. },
  1429. action: "update",
  1430. ID: evl.ID
  1431. });
  1432. }
  1433. let evaluate = evaluateKeyMap[gljUtil.getIndex(d, gljUtil.materialKeyArray)];
  1434. if (evaluate) {
  1435. if (evaluate.is_related == 1) tasks.push({
  1436. type: modelType,
  1437. doc: {
  1438. is_related: 0
  1439. },
  1440. action: "update",
  1441. ID: evaluate.ID
  1442. });
  1443. }
  1444. }
  1445. }
  1446. if (tasks.length > 0) configMaterialObj.updateEvaluateMaterial(tasks);
  1447. function getNewEval(d, m_t) {
  1448. let ndata = {
  1449. type: m_t,
  1450. doc: {},
  1451. action: "add"
  1452. };
  1453. ndata.doc['ID'] = uuid.v1();
  1454. ndata.doc['projectGLJID'] = d.id;
  1455. ndata.doc['is_related'] = 1;
  1456. if (m_t == "evaluate_list") ndata.doc['locked'] = 0;
  1457. ndata.doc['seq'] = d.code;
  1458. ndata.doc['projectID'] = d.from.project_id;
  1459. ndata.doc['code'] = d.code;
  1460. ndata.doc['name'] = d.name;
  1461. ndata.doc['specs'] = d.specs;
  1462. ndata.doc['unit'] = d.unit;
  1463. ndata.doc['quantity'] = d.quantity;
  1464. ndata.doc['type'] = d.type;
  1465. ndata.doc['market_price'] = d.from.unit_price.market_price;
  1466. ndata.doc['originPlace'] = d.originPlace;
  1467. ndata.doc['vender'] = d.vender;
  1468. ndata.doc['remark'] = d.remark;
  1469. return ndata;
  1470. }
  1471. }
  1472. };
  1473. $(function () {
  1474. $("#filterAgain").click(function () {
  1475. configMaterialObj.relateFilterAgain = true; //重新过滤标记
  1476. configMaterialObj.showEvaluateRelateDatas();
  1477. })
  1478. $('#selectPGLJ').on('shown.bs.modal', function (e) {
  1479. pgljSelObj.checkType = "取消";
  1480. pgljSelObj.initSpread();
  1481. pgljSelObj.showDatas();
  1482. });
  1483. $(".pglj_sel_input").change(function () {
  1484. let check = $(this).prop("checked");
  1485. if ($(this).val() == 0) { //勾选的是全选,其它的勾选项跟着改变
  1486. for (let a of $(".pglj_sel_input")) {
  1487. $(a).prop("checked", check)
  1488. }
  1489. } else { //勾选其它选项
  1490. let a_checked = true;
  1491. for (let o of $(".pglj_sel_input_other")) { //如果其它的有一个不勾选,则所有项也不打勾
  1492. if ($(o).prop("checked") === false) {
  1493. a_checked = false;
  1494. break;
  1495. }
  1496. }
  1497. $("#pglj_sel_all").prop("checked", a_checked);
  1498. }
  1499. pgljSelObj.showDatas();
  1500. });
  1501. $("#pglj_sel_btn_find").click(function () {
  1502. pgljSelObj.showDatas();
  1503. });
  1504. $(".pglj_sel_check_btn").click(function () {
  1505. pgljSelObj.checkType = $(this).text();
  1506. pgljSelObj.refreshDatas();
  1507. })
  1508. $("#pglj_sel_confirm").click(function () {
  1509. pgljSelObj.confirmSelect();
  1510. })
  1511. });