glj_view.js 54 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363
  1. /**
  2. * Created by CSL on 2017-05-12.
  3. */
  4. var gljOprObj = {
  5. sheet: null,
  6. libID: null,
  7. ration: null,
  8. sheetData:[],
  9. coeSheetData:[],
  10. checkb:null,
  11. coeSheet:null,
  12. assSheet:null,
  13. assSheetData:[],
  14. detailSheet:null,
  15. detailData:[],
  16. GLJSelection:[],
  17. selectedGLJClass:null,
  18. parentNodeIds:{},
  19. activeTab:'#linkGLJ',
  20. setting: {
  21. header: [
  22. {headerName: "编码", headerWidth: 100, dataCode: "code", dataType: "String", formatter: "@"},
  23. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
  24. {headerName: "规格型号", headerWidth: 120, dataCode: "specs", dataType: "String", hAlign: "left"},
  25. {headerName: "单位", headerWidth: 45, dataCode: "unit", dataType: "String", hAlign: "center"},
  26. {headerName: "类型", headerWidth: 45, dataCode: "shortName", dataType: "String", hAlign: "center"},
  27. {headerName: "定额消耗", headerWidth: 80, dataCode: "rationItemQuantity", dataType: "Number", hAlign: "right",decimalField:"glj.quantity"}, // dataType: "Number", formatter: "0.00"
  28. {headerName: "自定消耗", headerWidth: 80, dataCode: "customQuantity", dataType: "Number", hAlign: "right",decimalField:"glj.quantity"},
  29. {headerName: "消耗量", headerWidth: 80, dataCode: "quantity", dataType: "Number", hAlign: "right",decimalField:"glj.quantity"},
  30. {headerName: "总消耗量", headerWidth: 80, dataCode: "totalQuantity", dataType: "Number", hAlign: "right",decimalField:"glj.quantity"},
  31. {headerName: "定额价", headerWidth: 80, dataCode: "basePrice", dataType: "Number", hAlign: "right",decimalField:"glj.unitPrice"},
  32. {headerName: "调整价", headerWidth: 80, dataCode: "adjustPrice", dataType: "Number", hAlign: "right",decimalField:"glj.unitPrice"},
  33. {headerName: "市场价", headerWidth: 80, dataCode: "marketPrice", dataType: "Number", hAlign: "right",decimalField:"glj.unitPrice"},
  34. {headerName: "是否暂估", headerWidth: 65, dataCode: "isEstimate", dataType: "String", hAlign: "center",vAlign:"center",cellType:"checkBox"}
  35. ],
  36. view: {
  37. comboBox: [{row: -1, col: 12, rowCount: -1, colCount: 1}],
  38. lockedCells: [{row: -1, col: 3, rowCount: -1, colCount: 1}],
  39. lockColumns:[0,4,5,7,8,9,10,12]
  40. },
  41. notEditedType: ['砼','桨','配比','机']
  42. },
  43. coeSetting:{
  44. header:[
  45. {headerName: "调整", headerWidth: 100, dataCode: "isAdjust", dataType: "String",cellType:"checkBox"},
  46. {headerName: "条件", headerWidth: 120, dataCode: "name", dataType: "String",cellType:"button"},
  47. {headerName: "内容", headerWidth: 350, dataCode: "content", dataType: "String", hAlign: "left"}
  48. ],
  49. view:{
  50. lockColumns:[0,1,2]
  51. }
  52. },
  53. assSetting:{
  54. header:[
  55. {headerName: "调整名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  56. {headerName: "定额值", headerWidth: 120, dataCode: "stdValue", hAlign: "right", dataType: "String"},
  57. {headerName: "实际值", headerWidth: 120, dataCode: "actualValue", hAlign: "right", dataType: "String"}
  58. ],
  59. view:{
  60. lockColumns:[0,1]
  61. }
  62. },
  63. detailSetting:{
  64. header:[
  65. {headerName: "名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  66. {headerName: "计算式", headerWidth: 120, dataCode: "regex", dataType: "String"},
  67. {headerName: "结果(C)", headerWidth: 120, dataCode: "result", dataType: "Number",decimalField:"quantity_detail"},
  68. {headerName: "累加", headerWidth: 120, dataCode: "isSummation", dataType: "String",cellType:"checkBox"}
  69. ],
  70. view:{
  71. lockColumns:[2,3]
  72. }
  73. },
  74. gljTreeSetting:{
  75. view: {
  76. //addHoverDom: gljTypeTreeOprObj.addHoverDom,
  77. //removeHoverDom: gljTypeTreeOprObj.removeHoverDom,
  78. expandSpeed: "",
  79. selectedMulti: false
  80. },
  81. edit: {
  82. enable: false,
  83. editNameSelectAll: true,
  84. showRemoveBtn: true,
  85. showRenameBtn: true,
  86. removeTitle: "删除节点",
  87. renameTitle: "更改名称"
  88. },
  89. data: {
  90. keep: {
  91. parent:true,
  92. leaf:true
  93. },
  94. key: {
  95. children: "items",
  96. name: "Name"
  97. },
  98. simpleData: {
  99. enable: false,
  100. idKey: "ID",
  101. pIdKey: "ParentID",
  102. rootPId: -1
  103. }
  104. },
  105. callback:{
  106. onClick: function(event,treeId,treeNode) {
  107. if(treeId=='gljTree'){
  108. let me = gljOprObj, gljTypeId = treeNode.ID;
  109. if(me.gljCurTypeId !== treeNode.ID){
  110. me.gljCurTypeId = treeNode.ID;
  111. me.filterLibGLJSheetData();
  112. me.showLibGLJSheetData();
  113. }
  114. }else {
  115. if(treeNode.isParent){
  116. $('#class_selected_conf').attr("disabled","disabled");
  117. $('#selected_class').val("");
  118. }else {
  119. $('#class_selected_conf').removeAttr("disabled");
  120. $('#selected_class').val(treeNode.ID);
  121. }
  122. }
  123. }
  124. }
  125. },
  126. gljLibSheetSetting:{
  127. owner:'gljTree',
  128. header: [
  129. {headerName:"选择", headerWidth: 40, dataCode: "select", hAlign: "center", vAlign: "center",cellType:"checkBox"},
  130. {headerName:"编码",headerWidth:80,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  131. {headerName:"名称",headerWidth:120,dataCode:"name", dataType: "String", hAlign: "left", vAlign: "center"},
  132. {headerName:"规格型号",headerWidth:80,dataCode:"specs", dataType: "String", hAlign: "center", vAlign: "center"},
  133. {headerName:"计量单位",headerWidth:80,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  134. {headerName:"单价",headerWidth:80,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  135. {headerName:"类型",headerWidth:80,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}
  136. ],
  137. view:{
  138. lockColumns:[0,1,2,3,4,5,6]
  139. }
  140. },
  141. gljLibSheet:null,
  142. initSheet: function(sheet) {
  143. var me = this;
  144. me.sheet = sheet;
  145. sheetCommonObj.initSheet(me.sheet, me.setting, 30);
  146. sheet.name('ration_glj');
  147. me.bindSheetEvent(sheet);
  148. sheet.bind(GC.Spread.Sheets.Events.CellClick, me.onCellClick);
  149. gljContextMenu.loadGLJSpreadContextMenu();
  150. },
  151. initCoeSheet:function (sheet) {
  152. var me = this;
  153. me.coeSheet = sheet;
  154. sheetCommonObj.initSheet(me.coeSheet, me.coeSetting, 30);
  155. sheet.name('ration_coe');
  156. me.bindSheetEvent(sheet);
  157. sheet.bind(GC.Spread.Sheets.Events.CellClick, me.onCoeCellClick);
  158. subSpread.bind(GC.Spread.Sheets.Events.ButtonClicked,me.onButtonClick);
  159. },
  160. initAssSheet: function(sheet) {
  161. var me = this;
  162. me.assSheet = sheet;
  163. sheetCommonObj.initSheet(me.assSheet, me.assSetting, 30);
  164. sheet.name('ration_ass');
  165. me.bindSheetEvent(sheet);
  166. },
  167. initDetailSheet: function(sheet) {
  168. var me = this;
  169. me.detailSheet = sheet;
  170. sheetCommonObj.initSheet(me.detailSheet, me.detailSetting, 30);
  171. // me.detailSheet.selectionUnit(0);//0 cell,1 row,2 col;
  172. sheet.name('quantity_detail');
  173. me.bindSheetEvent(sheet);
  174. },
  175. showCoeData:function(sheet,setting,datas){
  176. sheet.floatingObjects.remove("customerCoe");
  177. sheetCommonObj.showData(sheet,setting,datas);
  178. if(datas.length>0){
  179. var cus_index= _.findIndex(datas,function(item){
  180. return item.coeID==-1;
  181. })
  182. if(cus_index!=-1){
  183. this.addDropDownList();
  184. this.addCusButton(cus_index,1,datas[cus_index].name);
  185. }
  186. }
  187. },
  188. bindSheetEvent:function (sheet) {
  189. var me = this;
  190. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  191. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  192. sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  193. sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  194. // sheet.bind(GC.Spread.Sheets.Events.CellClick, me.onCellClick);
  195. },
  196. onClipboardPasting: function(sender, args) {
  197. var me = gljOprObj;
  198. if (!me.ration) {
  199. args.cancel = true;
  200. }
  201. },
  202. onClipboardPasted: function(e, info) {
  203. var me = gljOprObj;
  204. console.log('past');
  205. // if (!me.ration) {return;};
  206. // your code...
  207. },
  208. onEditEnded: function(sender,args){
  209. var me = gljOprObj;
  210. if(args.sheetName=='ration_glj'){
  211. me.onEditGLJSheet(args)
  212. }
  213. if(args.sheetName=='ration_ass'){
  214. me.onEditAssSheet(args);
  215. }
  216. if(args.sheetName=='quantity_detail'){
  217. me.onEditDetailSheet(args);
  218. }
  219. },
  220. onEditDetailSheet:function(args){
  221. var me = gljOprObj;
  222. if(args.row>me.detailData.length){
  223. return;
  224. }
  225. if(args.row==me.detailData.length&&args.editingText==null){
  226. return;
  227. }
  228. var selected = projectObj.project.mainTree.selected;//因为使用了延时方法,所以要先取得选中行;
  229. var detailList = me.detailData;
  230. args.editingText = args.editingText.replace(/(/g,"(");//替换中文左右括号;
  231. args.editingText = args.editingText.replace(/)/g,")");
  232. setTimeout(function () {//这里须用延时执行的办法,不然的弹窗确认窗口会和spreadjs 的事件有冲突,造成定额工料机数据不会根据树结点更新的问题
  233. if(args.row==detailList.length){
  234. projectObj.project.quantity_detail.saveQuantityDetail(args,me.detailSetting.header[args.col].dataCode,selected);
  235. }
  236. if(args.row<detailList.length){
  237. projectObj.project.quantity_detail.updateQuantityDetail(args,me.detailSetting.header[args.col].dataCode,detailList[args.row],selected);
  238. }
  239. },100);
  240. },
  241. onEditGLJSheet:function(args){
  242. var me = gljOprObj;
  243. if(args.row>=me.sheetData.length){
  244. me.sheet.getCell(args.row, args.col).value(null);
  245. return;
  246. }
  247. me.updateRationGLJ(args);
  248. },
  249. onEditAssSheet:function(args){
  250. var me = gljOprObj;
  251. if(args.row>=me.assSheetData.length){
  252. me.assSheet.getCell(args.row, args.col).value(null);
  253. return;
  254. }
  255. if(me.assSetting.header[args.col].dataCode=='actualValue'){//自定义消耗量
  256. me.updateRationAss(args);
  257. }
  258. },
  259. onButtonClick:function (sender,args) {
  260. var me = gljOprObj;
  261. var sheet = args.sheet, row = args.row, col = args.col;
  262. var cellType = sheet.getCellType(row, col);
  263. if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
  264. me.onCusButtonClick(sender,args);
  265. }else {
  266. me.onCheckBoxClick(sender,args)
  267. }
  268. },
  269. onCheckBoxClick:function(sender,args){
  270. if(args.sheetName=='ration_glj'){
  271. return;
  272. }
  273. var checkboxValue = args.sheet.getCell(args.row, args.col).value();
  274. var newval = 0;
  275. if(checkboxValue){
  276. newval = 0;
  277. args.sheet.getCell(args.row, args.col).value(newval);
  278. }else {
  279. newval=1
  280. args.sheet.getCell(args.row, args.col).value(newval);
  281. }
  282. if(args.sheetName=='ration_coe'){
  283. gljOprObj.updateRationCoe(args,newval)
  284. }else if(args.sheetName=='quantity_detail'){
  285. projectObj.project.quantity_detail.isSummationUpdate(args,gljOprObj.detailData,newval);
  286. }else if(args.sheetName=='glj_lib'){
  287. gljOprObj.setGLJSelection(args,newval);
  288. }
  289. },
  290. onCusButtonClick:function (sender,args){
  291. var me = gljOprObj;
  292. var floatingObject = me.coeSheet.floatingObjects.get('customerCoe');
  293. var isVisable = floatingObject.isVisible();
  294. if(!isVisable){
  295. me.coeSheet.getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  296. me.showFloationObject(floatingObject,me.coeSheetData[args.row]);
  297. }else {
  298. var result = me.checkIfNeedUpdate();
  299. if(result.isNeed){
  300. projectObj.project.ration_coe.updateCustomerCoe(result);
  301. }
  302. floatingObject.isVisible(false);
  303. }
  304. },
  305. onCellClick: function(sender,args){
  306. var me = gljOprObj;
  307. if(args.row>=me.sheetData.length){
  308. return;
  309. }
  310. me.editChecking(args);
  311. },
  312. onCoeCellClick:function (sender,args) {
  313. var me = gljOprObj;
  314. var floatingObject = me.coeSheet.floatingObjects.get('customerCoe');
  315. var isVisable = floatingObject.isVisible();
  316. /* if($('#dropdown').css("display") == 'none'){
  317. if(args.col==1&&me.coeSheetData.length>args.row&&me.coeSheetData[args.row].coeID==-1){
  318. me.showFloationObject(floatingObject,me.coeSheetData[args.row]);
  319. }
  320. }*/
  321. if(isVisable){
  322. var result = me.checkIfNeedUpdate();
  323. if(result.isNeed){
  324. projectObj.project.ration_coe.updateCustomerCoe(result);
  325. }
  326. floatingObject.isVisible(false);
  327. // $('#dropdown').hide();
  328. }
  329. },
  330. showFloationObject(floatingObject,data){
  331. floatingObject.isVisible(true);
  332. var sheet = this.coeSheet;
  333. var startRow = this.coeSheetData.length;
  334. var endRow = startRow+7;
  335. floatingObject.startRow(startRow);
  336. floatingObject.startColumn(1);
  337. floatingObject.endColumn(2);
  338. floatingObject.endRow(endRow);
  339. this.bindFloadingObjectValue(data);
  340. sheet.repaint();
  341. // var editPosition = $("#edit").offset();
  342. //$('#dropdown').show();
  343. //var top =editPosition.top>=825?825:editPosition.top
  344. //$('#dropdown').offset({left:editPosition.left,top:top});//top: 791px; left:70px;
  345. },
  346. bindFloadingObjectValue(data){
  347. $('#coe_ration').val(data.coes[0].amount);
  348. $('#manual').val(data.coes[1].amount);
  349. $('#material').val(data.coes[2].amount);
  350. $('#manchine').val(data.coes[3].amount);
  351. $('#mainM').val(data.coes[4].amount);
  352. $('#equipment').val(data.coes[5].amount);
  353. },
  354. onInputChange(id,name){
  355. var coe = _.find(gljOprObj.coeSheetData,function (c) {
  356. return c.coeID == -1;
  357. });
  358. var newValue = gljOprObj.numberValueChecking($('#'+id).val());
  359. if(newValue){
  360. newValue=_.round(newValue,2);
  361. if(newValue==coe.coes[name].amount) return;
  362. if(id=='coe_ration'){
  363. $('#coe_ration').val(newValue);
  364. $('#manual').val(newValue);
  365. $('#material').val(newValue);
  366. $('#manchine').val(newValue);
  367. $('#mainM').val(newValue);
  368. $('#equipment').val(newValue);
  369. }else {
  370. $('#'+id).val(newValue);
  371. }
  372. }else {
  373. $('#'+id).val(coe.coes[name].amount);
  374. }
  375. },
  376. checkIfNeedUpdate(){
  377. var data = _.find(gljOprObj.coeSheetData,function (c) {
  378. return c.coeID == -1;
  379. });
  380. var result = {
  381. isNeed:false
  382. }
  383. var coe_ration = $('#coe_ration').val();
  384. var manual=$('#manual').val();
  385. var material = $('#material').val();
  386. var manchine= $('#manchine').val();
  387. var mainM = $('#mainM').val();
  388. var equipment=$('#equipment').val();
  389. if(coe_ration!=data.coes[0].amount){
  390. result.isNeed =true;
  391. data.coes[0].amount =coe_ration;
  392. }
  393. if(manual!=data.coes[1].amount){
  394. result.isNeed =true;
  395. data.coes[1].amount =manual;
  396. }
  397. if(material!=data.coes[2].amount){
  398. result.isNeed =true;
  399. data.coes[2].amount =material;
  400. }
  401. if(manchine!=data.coes[3].amount){
  402. result.isNeed =true;
  403. data.coes[3].amount =manchine;
  404. }
  405. if(mainM!=data.coes[4].amount){
  406. result.isNeed =true;
  407. data.coes[4].amount =mainM;
  408. }
  409. if(equipment!=data.coes[5].amount){
  410. result.isNeed =true;
  411. data.coes[5].amount =equipment;
  412. }
  413. if(result.isNeed){
  414. result.doc = {
  415. coes:data.coes
  416. };
  417. result.query = {
  418. projectID:data.projectID,
  419. ID:data.ID,
  420. rationID:data.rationID
  421. };
  422. }
  423. return result;
  424. },
  425. editChecking:function (args) {
  426. var me = gljOprObj;
  427. var header = me.setting.header;
  428. var disable = null;
  429. if(me.sheetData[args.row]!=undefined){
  430. if(me.sheetData[args.row].isMixRatio){
  431. disable = true;
  432. }
  433. }
  434. if(header[args.col]&&header[args.col].dataCode=='marketPrice'){
  435. var type = me.sheetData[args.row].shortName;
  436. var index= _.indexOf(me.setting.notEditedType,type);
  437. disable=index==-1?false:true;
  438. }
  439. if(header[args.col]&&header[args.col].dataCode=='basePrice'){
  440. var isAdd= me.sheetData[args.row].isAdd;
  441. var type_b = me.sheetData[args.row].shortName;
  442. var index_b= _.indexOf(me.setting.notEditedType,type);
  443. disable=isAdd==1&&index_b==-1?false:true
  444. }
  445. if(disable!=null){
  446. me.sheet.getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport).locked(disable);
  447. }
  448. },
  449. addDropDownList:function () {
  450. var sheet = this.coeSheet;
  451. sheet.suspendPaint();
  452. var customFloatingObject = new GC.Spread.Sheets.FloatingObjects.FloatingObject("customerCoe");
  453. var div = document.createElement('div');
  454. div.innerHTML = this.generateHtmlString();
  455. customFloatingObject.startRow(1);
  456. customFloatingObject.startColumn(1);
  457. customFloatingObject.endColumn(2);
  458. customFloatingObject.endRow(2);
  459. $(div).css('background', 'white');
  460. customFloatingObject.content(div);
  461. sheet.floatingObjects.add(customFloatingObject);
  462. customFloatingObject.isVisible(false);
  463. sheet.resumePaint();
  464. },
  465. addCusButton:function(row,col,text){
  466. var cus_button = new GC.Spread.Sheets.CellTypes.Button();
  467. gljOprObj.coeSheet.setCellType(row, col, cus_button, GC.Spread.Sheets.SheetArea.viewport);
  468. cus_button.marginLeft(0);
  469. cus_button.marginTop(0);
  470. cus_button.marginRight(0);
  471. cus_button.marginBottom(0);
  472. cus_button.text(text);
  473. cus_button.buttonBackColor('white');
  474. gljOprObj.coeSheet.repaint();
  475. },
  476. onRangeChanged: function(sender, args) {
  477. var me = gljOprObj;
  478. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  479. args.editingText=null;
  480. if(args.sheetName=='ration_glj'){
  481. me.onEditGLJSheet(args);
  482. }
  483. if(args.sheetName=='ration_ass'){
  484. me.updateRationAss(args);
  485. }
  486. };
  487. },
  488. generateHtmlString:function () {
  489. // return "<div id='edit'><div>";
  490. var newString = "<form ><table border='1px' bordercolor='#CCCCCC' cellspacing='0px' style='border-collapse:collapse;font-size: 10px;>";
  491. //newString +="<tr><td style='height:15px' colspan='2'>自定义系数</td></tr>"
  492. newString += this.getOneRow('定额',0,'coe_ration');
  493. newString += this.getOneRow('人工',1,'manual');
  494. newString += this.getOneRow('材料',2,'material');
  495. newString += this.getOneRow('机械',3,'manchine');
  496. newString += this.getOneRow('主材',4,'mainM');
  497. newString += this.getOneRow('设备',5,'equipment');
  498. newString +="</table></form>";
  499. return newString;
  500. //"<form id='edit'><table border='1px' bordercolor='#CCCCCC' cellspacing='0px' style='border-collapse:collapse;font-size: 10px;><tr style='height:10px'><td style='width: 50px'>定额:</td><td style='width: 70px' align='right'><input type='text'value='1' name='ration' style='width:30px;border:0;height:14px' align='right'></td></tr><tr><td>定额:</td><td><input type='text' style='width:50px;border:0;height:10px'></td></tr><tr><td>定额:</td><td><input type='text' style='width:50px;border:0;height:10px'></td></tr><tr ><td>定额:</td><td><input type='text' style='width:50px;border:0;height:10px'></td></tr><tr><td>定额:</td><td><input type='text' style='width:50px;border:0;height:10px'></td></tr></table></form>";
  501. },
  502. getOneRow:function (text,name,id) {
  503. var rowstr = "<tr style='height:10px'><td style='width: 50px'>"+text
  504. +":</td><td style='width: 70px' align='right'><input type='text'value='1' name="+name
  505. +" style='width:30px;border:0;height:14px' align='right' id="+id+" onchange='gljOprObj.onInputChange(this.id,this.name)'></td></tr>";
  506. return rowstr;
  507. },
  508. showDataIfRationSelect:function (node) {
  509. var isShow = false;
  510. if(node){
  511. if(this.selectedNodeId&&this.selectedNodeId==node.getID()){
  512. return;
  513. }else {
  514. this.selectedNodeId=node.getID();
  515. }
  516. if(node.sourceType=="ration"){
  517. this.showRationGLJData(node);
  518. this.showRationCoeData(node);
  519. this.showRationAssData(node);
  520. isShow=true;
  521. }
  522. this.showQuantityDetailData(node);
  523. }else {
  524. this.selectedNodeId=null;
  525. }
  526. if(!isShow){
  527. this.clearSheetData();
  528. }
  529. //hide floatingObject
  530. var floatingObject = this.coeSheet.floatingObjects.get('customerCoe');
  531. if(floatingObject){
  532. floatingObject.isVisible(false);
  533. }
  534. // $('#dropdown').hide();
  535. },
  536. showRationGLJData:function (node) {
  537. var gljList = [];
  538. var ration_glj = projectObj.project.ration_glj;
  539. node=node?node:projectObj.project.mainTree.selected;
  540. if(node.sourceType==ModuleNames.ration){
  541. let ration = node.data;
  542. gljList=this.filterGljByRation(ration,ration_glj.datas);
  543. this.showInSheet(gljList);
  544. }
  545. },
  546. showRationGLJSheetData:function (init) {
  547. this.sheet.setRowCount(0);
  548. //console.log(+new Date())
  549. //this.sheet.getRange(0,-1,this.sheet.getRowCount(),-1).visible(true); //这个方法导致加载缓慢
  550. this.sheetData=sortRationGLJ(this.sheetData);
  551. this.sumQuantity();//计算总消耗量
  552. this.addMixRatioToShow();//显示组成物信息
  553. this.initRationTree(init);
  554. sheetCommonObj.showData(this.sheet,this.setting,this.sheetData);
  555. },
  556. initRationTree:function (init) {
  557. this.sheet.getRange(-1, 0, -1, 1).cellType(this.getTreeNodeCellType(this.sheetData));
  558. for(var i =0;i<this.sheetData.length;i++){
  559. if(this.sheetData[i].hasOwnProperty('subList')){
  560. var collapsed = false;
  561. if(init){
  562. this.sheetData[i].collapsed=true;
  563. collapsed = true;
  564. }else {
  565. collapsed = this.sheetData[i].collapsed==undefined?true:this.sheetData[i].collapsed;
  566. }
  567. if(collapsed==true){
  568. this.sheet.getRange(i+1, -1, this.sheetData[i].subList.length, -1).visible(false);
  569. }
  570. //this.sheet.getRange(i+1, -1, this.sheetData[i].subList.length, -1).visible(!collapsed);// this.sheet.getRange(i+1, -1, this.sheetData[i].subList.length, -1).locked(true);
  571. //这个方法导致加载缓慢
  572. }
  573. }
  574. },
  575. filterGljByRation:function (ration,datas) {
  576. var gljList=[];
  577. if(datas&&datas.length>0){
  578. gljList = _.filter(datas,{'rationID':ration.ID})
  579. }
  580. return gljList;
  581. },
  582. showInSheet:function(gljList){
  583. this.sheetData=this.combineWithProjectGlj(gljList);
  584. this.showRationGLJSheetData(true);
  585. },
  586. sumQuantity:function (node) {
  587. if(this.sheetData.length>0){
  588. node=node?node:projectObj.project.mainTree.selected;
  589. let ration = node.data;
  590. let quantity = ration.quantity;
  591. quantity = (quantity==0||quantity==undefined||quantity==null||quantity=="")?1:quantity;
  592. for(let glj of this.sheetData){
  593. if(glj.isMixRatio==true){//如果是用于显示的组成物,则不用计算,跳过
  594. continue;
  595. }
  596. glj.totalQuantity = scMathUtil.roundToString(quantity*glj.quantity,getDecimal("glj.quantity"));
  597. if(glj.hasOwnProperty('subList')){//需要计算glj下挂的组成物的总消耗量
  598. for(let subG of glj.subList){
  599. subG.totalQuantity = scMathUtil.roundToString(subG.rationItemQuantity*glj.totalQuantity,getDecimal("glj.quantity"));
  600. }
  601. }
  602. }
  603. }
  604. },
  605. addMixRatioToShow:function () {
  606. var newList=[];
  607. _.remove(this.sheetData,{'isMixRatio':true});
  608. for(var i =0;i<this.sheetData.length;i++){
  609. newList.push(this.sheetData[i]);
  610. if(this.sheetData[i].hasOwnProperty('subList')){
  611. newList = newList.concat(this.sheetData[i].subList);
  612. }
  613. }
  614. this.sheetData= newList;
  615. },
  616. combineWithProjectGlj:function (ration_gljs) {
  617. var projectGLJData = projectObj.project.projectGLJ.datas;
  618. var projectGljs = projectGLJData.gljList;
  619. var mixRatioMap = projectGLJData.mixRatioMap;
  620. if(ration_gljs&&ration_gljs.length>0&&projectGljs&&projectGljs.length>0){
  621. for(var i =0;i<ration_gljs.length;i++){
  622. var glj = _.find(projectGljs,{'id':ration_gljs[i].projectGLJID});
  623. if(glj){
  624. ration_gljs[i].basePrice=glj.unit_price.base_price;
  625. ration_gljs[i].marketPrice=glj.unit_price.market_price;
  626. //ration_gljs[i].adjustPrice=glj.adjust_price;
  627. ration_gljs[i].isEstimate=glj.is_evaluate;
  628. ration_gljs[i].isAdd=glj.unit_price.is_add;
  629. ration_gljs[i].adjustPrice=projectObj.project.projectGLJ.getAdjustPrice(glj);
  630. var connect_index = this.getIndex(glj,['code','name','specs','unit','type'])
  631. if(mixRatioMap.hasOwnProperty(connect_index)){
  632. var mixRatios = this.getMixRationShowDatas(mixRatioMap[connect_index],projectGljs);
  633. ration_gljs[i].subList = mixRatios;
  634. }
  635. }
  636. }
  637. }
  638. return ration_gljs;
  639. },
  640. getIndex(obj,pops){
  641. let t_index = '';
  642. let k_arr=[];
  643. for(let p of pops){
  644. let tmpK = (obj[p]==undefined||obj[p]==null||obj[p]=='')?'null':obj[p];
  645. k_arr.push(tmpK);
  646. }
  647. t_index=k_arr.join("|-|");
  648. return t_index;
  649. },
  650. getMixRationShowDatas:function (mixRatioList,projectGljs) {
  651. var temRationGLJs = [];
  652. for(var i =0;i<mixRatioList.length;i++){
  653. var pg = _.find(projectGljs,{'code':mixRatioList[i].code,'name':mixRatioList[i].name,'specs':mixRatioList[i].specs,'type':mixRatioList[i].type,'unit':mixRatioList[i].unit});//改关联关系
  654. var tem = {
  655. projectGLJID:pg.id,
  656. code:pg.code,
  657. name:pg.name,
  658. specs:pg.specs,
  659. unit:pg.unit,
  660. shortName:pg.unit_price.short_name,
  661. rationItemQuantity:mixRatioList[i].consumption,
  662. // quantity:mixRatioList[i].consumption,
  663. basePrice:pg.unit_price.base_price,
  664. marketPrice:pg.unit_price.market_price,
  665. adjustPrice:pg.adjust_price,
  666. isEstimate:pg.is_evaluate,
  667. isMixRatio:true,
  668. isAdd:pg.unit_price.is_add,
  669. GLJID:pg.glj_id
  670. }
  671. temRationGLJs.push(tem);
  672. }
  673. temRationGLJs=_.sortBy(temRationGLJs,'code');
  674. return temRationGLJs;
  675. },
  676. showRationCoeData:function (node) {
  677. var coeList = [];
  678. var ration_coe= projectObj.project.ration_coe;
  679. var ration = node.data;
  680. if(ration_coe.datas&&ration_coe.datas.length>0){
  681. coeList = _.filter(ration_coe.datas,{'projectID':ration.projectID,'rationID':ration.ID})
  682. }
  683. this.showCoeData(this.coeSheet,this.coeSetting,coeList);
  684. this.coeSheetData=coeList;
  685. },
  686. showRationAssData:function (node) {
  687. var assList = node.data.rationAssList ? node.data.rationAssList : [];
  688. sheetCommonObj.showData(this.assSheet,this.assSetting,assList);
  689. this.assSheetData =assList;
  690. },
  691. showQuantityDetailData:function (node) {
  692. var details=[];
  693. node =node?node:projectObj.project.mainTree.selected;
  694. var quantity_detail =projectObj.project.quantity_detail;
  695. if(node.sourceType==ModuleNames.ration){
  696. details=_.filter(quantity_detail.datas,{'rationID':node.data.ID});
  697. }else if(node.sourceType==ModuleNames.bills){
  698. details=_.filter(quantity_detail.datas,{'billID':node.data.ID});
  699. }
  700. details=_.sortBy(details,'seq');
  701. sheetCommonObj.showData(this.detailSheet,this.detailSetting,details);
  702. this.detailData = details;
  703. if(MainTreeCol.readOnly.forQuantifyDetail(node)){
  704. this.detailSheet.getRange(-1,0,-1,this.detailSetting.header.length).locked(true);
  705. }
  706. },
  707. clearSheetData:function () {
  708. sheetCommonObj.showData(this.sheet,this.setting,[]);
  709. sheetCommonObj.showData(this.coeSheet,this.coeSetting,[]);
  710. sheetCommonObj.showData(this.assSheet,this.assSetting,[]);
  711. // sheetCommonObj.showData(this.detailSheet,this.detailSetting,[]);
  712. this.sheetData = [];
  713. this.coeSheetData = [];
  714. this.assSheetData = [];
  715. //this.detailData=[];
  716. },
  717. /* lockRationGLJCell:function(){
  718. sheetCommonObj.lockCells(this.sheet,this.setting);
  719. },
  720. lockRationCoeCell:function () {
  721. sheetCommonObj.lockCells(this.coeSheet,this.coeSetting);
  722. /!* if(this.coeSheetData){
  723. for(var i =0;i<this.coeSheetData.length;i++){
  724. if(this.coeSheetData[i].coeID==-1){
  725. this.coeSheet.getCell(i, 1, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  726. }
  727. }
  728. }*!/
  729. },
  730. lockRationGLJCell:function(){
  731. sheetCommonObj.lockCells(this.sheet,this.setting);
  732. },*/
  733. updateRationGLJ:function (args) {
  734. var me=this;
  735. var updateField = me.setting.header[args.col].dataCode;
  736. var recode = me.sheetData[args.row];
  737. var newval;
  738. if(updateField=='marketPrice'||updateField=='customQuantity'||updateField=='basePrice'){
  739. if(args.editingText==null){
  740. updateField=='marketPrice'||updateField=='customQuantity'?newval=0:newval="";
  741. }else {
  742. var decimal = updateField=='customQuantity'?getDecimal("glj.quantity"):getDecimal("glj.unitPrice");
  743. newval = number_util.checkNumberValue(args.editingText,decimal);
  744. if(newval==null){
  745. me.sheet.getCell(args.row, args.col).value(recode[updateField]);
  746. return;
  747. }
  748. }
  749. }else {
  750. if(updateField=='name'||updateField=='unit'){
  751. if(args.editingText===null){
  752. alert(me.setting.header[args.col].headerName +'不能为空!');
  753. me.sheet.getCell(args.row, args.col).value(recode[updateField]);
  754. return;
  755. }
  756. }
  757. newval=args.editingText==null?"":args.editingText;
  758. }
  759. if(newval === recode[updateField]){//如果值完全相等,则不需要更新
  760. return
  761. }
  762. if(updateField=='marketPrice'||updateField=='basePrice'){
  763. projectObj.project.projectGLJ.updatePriceFromRG(recode,updateField,newval);
  764. } else {
  765. projectObj.project.ration_glj.updateRationGLJByEdit(recode,updateField,newval);
  766. }
  767. },
  768. updateRationAss:function (args) {
  769. var me = gljOprObj;
  770. var newval;
  771. newval = me.numberValueChecking(args.editingText);
  772. var recode = me.assSheetData[args.row];
  773. if(args.editingText===null){
  774. newval=parseFloat(recode.stdValue);
  775. }
  776. var isValidate = false;
  777. if(newval){
  778. isValidate = me.checkingActualValue(recode,newval)
  779. }
  780. if(isValidate){
  781. projectObj.project.ration_ass.updateActualValue(me.assSheetData,args.row,newval)
  782. }else {
  783. newval = recode.actualValue;
  784. me.assSheet.getCell(args.row, args.col).value(newval);
  785. }
  786. },
  787. updateRationCoe:function (args,newval) {
  788. var me = gljOprObj;
  789. var recode = me.coeSheetData[args.row];
  790. projectObj.project.ration_coe.adjustCoeClick(recode,newval);
  791. },
  792. numberValueChecking:function (val) {
  793. var newval = Number(val);
  794. if(number_util.isNumber(newval)){
  795. return newval;
  796. }else {
  797. if(val){
  798. alert('您输入的数据类型不正确,请重新输入。');
  799. }
  800. newval = null;
  801. }
  802. return newval;
  803. },
  804. checkingActualValue(record,newval){
  805. var minExist = record.minValue&&record.minValue!='0'?true:false;
  806. var maxExist = record.maxValue&&record.maxValue!='0'?true:false;
  807. var minValue = parseFloat(record.minValue);
  808. var maxValue = parseFloat(record.maxValue);
  809. var stdVale = parseFloat(record.stdValue);
  810. if(!maxExist&&minExist){
  811. if(newval<minValue){
  812. alert('实际值应≥'+minValue);
  813. return false;
  814. }
  815. }
  816. if(maxExist&&!minExist){
  817. if(newval>maxValue){
  818. alert('实际值应≤'+maxValue);
  819. return false;
  820. }
  821. }
  822. if(maxExist&&minExist){
  823. if(newval<minValue||newval>maxValue){
  824. alert('实际值应介于'+minValue+'~'+maxValue+'之间');
  825. return false;
  826. }
  827. }
  828. return true;
  829. },
  830. showLibGLJSheetData:function () {
  831. this.gljLibSheetData=_.sortBy(this.gljLibSheetData, 'code');
  832. this.gljLibSheet.setRowCount(this.gljLibSheetData.length);
  833. sheetCommonObj.showData(this.gljLibSheet,this.gljLibSheetSetting,this.gljLibSheetData,gljOprObj.distTypeTree);
  834. },
  835. filterLibGLJSheetData:function () {
  836. let me=this;
  837. let val = $("input[name='glj']:checked").val();
  838. if(val=='allGljs'){
  839. me.gljLibSheetData =me.stdGLJ.concat(me.complementaryGLJs);
  840. }else {
  841. me.gljLibSheetData=me[val];
  842. }
  843. if($('#actionType').val()=='replace'||$('#actionType').val()=='m_replace'){
  844. me.filterLibGLJByType();
  845. }
  846. if(me.gljCurTypeId==undefined){
  847. return;
  848. }
  849. if (me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  850. me.gljLibSheetData= _.filter(me.gljLibSheetData, function(n) {
  851. return _.includes(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId],n.gljClass);
  852. });
  853. } else {
  854. me.gljLibSheetData = _.filter(me.gljLibSheetData,{'gljClass':me.gljCurTypeId});
  855. }
  856. },
  857. setGLJSelection:function (args,newVal) {
  858. if($('#actionType').val()=='add'||$('#actionType').val()=='insert'){
  859. this.addGLJsSelection(args,newVal);
  860. }else {
  861. this.replaceGLJSelection(args,newVal);
  862. }
  863. },
  864. addGLJsSelection:function (args,newVal) {
  865. var con_key = this.getIndex(this.gljLibSheetData[args.row],['code','name','specs','unit','gljType'])
  866. if(newVal==1){
  867. this.GLJSelection.push(con_key);
  868. this.gljLibSheetData[args.row].select=1;
  869. }else if(newVal==0){
  870. _.pull(this.GLJSelection,con_key);
  871. this.gljLibSheetData[args.row].select=0;
  872. }
  873. },
  874. replaceGLJSelection:function (args,newVal) {
  875. var me =this;
  876. var oldSelection=this.GLJSelection[0];
  877. if(newVal==0){
  878. args.sheet.getCell(args.row, args.col).value(1);
  879. return;
  880. }
  881. this.GLJSelection=[me.getIndex(this.gljLibSheetData[args.row],['code','name','specs','unit','gljType'])];
  882. this.gljLibSheetData[args.row].select=1;
  883. var oindex = _.findIndex(this.gljLibSheetData,function (item) {
  884. var i_key = me.getIndex(item,['code','name','specs','unit','gljType']);
  885. return oldSelection==i_key;
  886. });
  887. if(oindex!=-1){
  888. args.sheet.getCell(oindex, args.col).value(0);
  889. this.gljLibSheetData[oindex].select=0;
  890. }else {
  891. var oldData = _.find(gljOprObj.AllRecode,function (item) {
  892. var i_key = me.getIndex(item,['code','name','specs','unit','gljType']);
  893. return oldSelection==i_key;
  894. });
  895. oldData?oldData.select=0:"";
  896. }
  897. },
  898. filterLibGLJByType:function () {
  899. var me=this;
  900. var selected=me.sheetData[gljContextMenu.selectedRow];
  901. me.gljLibSheetData=_.filter(me.gljLibSheetData,{'gljType':selected.type});
  902. },
  903. getComboData: function (gljDistType) {
  904. let me = this;
  905. let distType;
  906. let distTypeTree = {
  907. prefix : 'gljType',
  908. distTypes: {},
  909. comboDatas: [],
  910. distTypesArr: []
  911. };
  912. gljDistType.forEach(function (typeData) {
  913. let typeObj = {
  914. data: typeData,
  915. children: [],
  916. parent: null
  917. }
  918. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  919. distTypeTree.distTypesArr.push(typeObj);
  920. });
  921. gljDistType.forEach(function (typeData) {
  922. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  923. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  924. if(parent){
  925. distType.parent = parent;
  926. parent.children.push(distType);
  927. }
  928. });
  929. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  930. if(distTypeObj.data.fullName !== '材料' && distTypeObj.data.fullName !== '机械'){
  931. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  932. }
  933. });
  934. return distTypeTree;
  935. },
  936. doInsertGLJ:function () {
  937. var selected = projectObj.project.mainTree.selected;
  938. var project= projectObj.project;
  939. console.log(gljOprObj.GLJSelection);
  940. },
  941. doAddGLJ:function () {
  942. var selected = projectObj.project.mainTree.selected;
  943. var project= projectObj.project;
  944. gljOprObj.GLJSelection= _.filter(gljOprObj.GLJSelection,function (n) {
  945. var rg = _.find(gljOprObj.sheetData,function (item) {
  946. var i_key = gljOprObj.getIndex(item,['code','name','specs','unit','type']);
  947. return n==i_key
  948. })
  949. return rg?false:true;
  950. })
  951. if(gljOprObj.GLJSelection.length>0&&selected&&selected.sourceType==ModuleNames.ration){
  952. $("#glj_tree_div").modal('hide');
  953. project.ration_glj.addGLJByLib(gljOprObj.GLJSelection,selected.data,function (result) {
  954. if(result){
  955. selected.data.adjustState=result.adjustState;
  956. //project.ration_glj.datas = project.ration_glj.datas.concat(result.newRecodes);//显示和缓存统一,这样的话就不用更新两个位置了
  957. project.ration_glj.datas = project.ration_glj.datas.concat(result.showData);
  958. gljOprObj.sheetData = gljOprObj.sheetData.concat(result.showData);
  959. gljOprObj.showRationGLJSheetData();
  960. project.ration_glj.addToMainTree(result.showData);
  961. project.projectGLJ.loadData();
  962. projectObj.mainController.refreshTreeNode([selected]);
  963. $.bootstrapLoading.end();
  964. }
  965. });//doc.rationID=selected.data.ID;
  966. }else {
  967. $("#glj_tree_div").modal('hide');
  968. }
  969. },
  970. doReplaceGLJ:function () {
  971. var me=this;
  972. var oldData=me.sheetData[gljContextMenu.selectedRow];
  973. var project= projectObj.project;
  974. var selectCode=gljOprObj.GLJSelection[0];
  975. var selected = projectObj.project.mainTree.selected;
  976. $("#glj_tree_div").modal('hide');
  977. project.ration_glj.replaceGLJ(selectCode,oldData,function (result) {
  978. if(result){
  979. //result.adjustState;
  980. var data =result.data;
  981. var index = _.findIndex(gljOprObj.sheetData,{'ID':data.ID});
  982. var nodes = [selected];
  983. gljOprObj.sheetData[index]=data;
  984. gljOprObj.showRationGLJSheetData();
  985. if(project.ration_glj.needShowToTree(data)){//当替换的是主材或设备时,刷新对应的树节点
  986. var node = project.ration_glj.findTreeNodeByID(data.ID);
  987. if(node){
  988. project.ration_glj.transferToNodeData(data);
  989. node.source = data;
  990. node.data = data;
  991. }
  992. node?nodes.push(node):"";
  993. }
  994. //project.ration_glj.addToMainTree(data);
  995. project.projectGLJ.loadData();
  996. selected.data.adjustState=result.adjustState;
  997. projectObj.mainController.refreshTreeNode(nodes);
  998. }
  999. $.bootstrapLoading.end();
  1000. })
  1001. },
  1002. doMReplaceGLJ:function () {
  1003. var me=this;
  1004. var oldData=me.sheetData[gljContextMenu.selectedRow];
  1005. var project= projectObj.project;
  1006. var selectCode=me.GLJSelection[0];
  1007. $("#glj_tree_div").modal('hide');
  1008. project.ration_glj.mReplaceGLJ(selectCode,oldData,function (result) {
  1009. var data=result.data;
  1010. var stateList= result.stateList;
  1011. var n_index = me.getIndex(data.query,['code','name','specs','unit','type']);
  1012. var nodes=[];
  1013. _.forEach(project.ration_glj.datas,function (t) {
  1014. var t_index =me.getIndex(t,['code','name','specs','unit','type']);
  1015. if(n_index==t_index){
  1016. me.updateProperty(t,data.doc);
  1017. if(project.ration_glj.needShowToTree(t)){//如果是造价书中的树节点,则也须刷新
  1018. project.ration_glj.transferToNodeData(t);
  1019. var node = project.ration_glj.findTreeNodeByID(t.ID);
  1020. nodes.push(node);
  1021. }
  1022. }
  1023. })
  1024. me.showRationGLJSheetData();
  1025. project.projectGLJ.loadData();
  1026. me.refreshStateAfterMreplace(stateList,nodes);
  1027. $.bootstrapLoading.end();
  1028. })
  1029. },
  1030. updateProperty:function (obj,doc) {
  1031. _.forEach(doc, function(n, key) {
  1032. obj[key] = n;
  1033. });
  1034. },
  1035. refreshStateAfterMreplace:function (stateList,gljNodes) {
  1036. var nodes=[];
  1037. _.forEach(stateList,function (s) {
  1038. var node = _.find(projectObj.project.mainTree.items,function (n) {
  1039. return n.sourceType==ModuleNames.ration&&n.data.ID==s.rationID;
  1040. })
  1041. if(node){
  1042. node.data.adjustState=s.adjustState;
  1043. nodes.push(node);
  1044. }
  1045. });
  1046. gljNodes.length>0?nodes = nodes.concat(gljNodes):"";
  1047. projectObj.mainController.refreshTreeNode(nodes);
  1048. },
  1049. refreshView:function () {
  1050. this.showRationGLJData();
  1051. },
  1052. //
  1053. refreshTreeNode:function (obj) {
  1054. if(!obj){
  1055. return;
  1056. }
  1057. var objectArray =[];
  1058. var nodes =[];
  1059. if(obj instanceof Array){
  1060. objectArray.concat(obj);
  1061. }else {
  1062. objectArray.push(obj);
  1063. }
  1064. for(let o of objectArray ){
  1065. var node = _.find(projectObj.project.mainTree.items,function (n) {
  1066. return n.sourceType==o.type&&n.data.ID==o.ID;
  1067. })
  1068. if(node){
  1069. for (var k in o.data){
  1070. node.data[k] = o.data[k];
  1071. }
  1072. nodes.push(node);
  1073. }
  1074. }
  1075. projectObj.mainController.refreshTreeNode(nodes);
  1076. },
  1077. getTreeNodeCellType:function (data) {
  1078. var ns = GC.Spread.Sheets;
  1079. var rectW = 10;
  1080. var rectH = 10;
  1081. var margin = 3;
  1082. function TreeNodeCellType() {
  1083. }
  1084. function drowRect(ctx,x,y,w,h) {
  1085. ctx.save();
  1086. ctx.strokeStyle = "gray";
  1087. ctx.translate(0.5,0.5);
  1088. ctx.beginPath();
  1089. var rectX = x+margin;
  1090. var rectY = y+ Math.round(h/2)-rectH/2;
  1091. ctx.moveTo(rectX, rectY);
  1092. ctx.lineTo(rectX, rectY+rectH);
  1093. ctx.lineTo(rectX+rectW, rectY+rectH);
  1094. ctx.lineTo(rectX+rectW, rectY);
  1095. ctx.lineTo(rectX, rectY);
  1096. ctx.moveTo(rectX+rectW, y+Math.round(h/2));
  1097. ctx.lineTo(rectX+rectW+5, y+Math.round(h/2));
  1098. ctx.stroke();
  1099. ctx.restore();
  1100. }
  1101. function drowSymbol(ctx,x,y,w,h,collapsed) {
  1102. ctx.save();
  1103. ctx.strokeStyle = "#000000";
  1104. ctx.translate(0.5, 0.5);
  1105. ctx.beginPath();
  1106. ctx.moveTo(x+margin+2, y+Math.round(h/2));
  1107. ctx.lineTo(x+margin+8, y+Math.round(h/2));
  1108. var rectY = y+ Math.round(h/2)-rectH/2;
  1109. if(collapsed){
  1110. ctx.moveTo(x+margin+rectW/2,rectY+2);
  1111. ctx.lineTo(x+margin+rectW/2,rectY+2+6);
  1112. }
  1113. ctx.stroke();
  1114. ctx.restore();
  1115. }
  1116. function drowSubItem(ctx,x,y,w,h,offset,nextItem) {
  1117. offset+=6;
  1118. ctx.save();
  1119. ctx.strokeStyle = "gray";
  1120. ctx.translate(0.5, 0.5);
  1121. ctx.beginPath();
  1122. ctx.moveTo(x+offset, y);
  1123. ctx.lineTo(x+offset, y+Math.round(h/2));
  1124. offset+=9;
  1125. ctx.lineTo(x+offset, y+Math.round(h/2));
  1126. if(nextItem&&nextItem.isMixRatio){
  1127. ctx.moveTo(x+offset-9, y+Math.round(h/2));
  1128. ctx.lineTo(x+offset-9, y+h);
  1129. }
  1130. ctx.stroke();
  1131. ctx.restore();
  1132. return offset;
  1133. }
  1134. TreeNodeCellType.prototype = new ns.CellTypes.Text();
  1135. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  1136. if(value!=null){
  1137. var offset = margin+rectW+6;
  1138. var recode = data[options.row];
  1139. if(recode&&recode.hasOwnProperty('subList')){
  1140. drowRect(ctx,x,y,w,h);
  1141. var collapsed = recode.collapsed==undefined?true:recode.collapsed;//options.sheet.getTag(options.row,options.col);
  1142. drowSymbol(ctx,x,y,w,h,collapsed);
  1143. }else if(recode&&recode.isMixRatio){
  1144. offset= drowSubItem(ctx,x,y,w,h,offset,data[options.row+1]);
  1145. offset+=1;
  1146. }
  1147. ctx.fillText(value,x+offset+ctx.measureText(value).width,y+h-5);
  1148. }
  1149. };
  1150. // override getHitInfo to allow cell type get mouse messages
  1151. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  1152. return {
  1153. x: x,
  1154. y: y,
  1155. row: context.row,
  1156. col: context.col,
  1157. cellStyle: cellStyle,
  1158. cellRect: cellRect,
  1159. sheetArea: context.sheetArea
  1160. };
  1161. }
  1162. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  1163. var recode = data[hitinfo.row];
  1164. if(recode&&recode.hasOwnProperty('subList')){
  1165. var hoffset= hitinfo.cellRect.x+3;
  1166. if (hitinfo.x > hoffset && hitinfo.x < hoffset + 10){
  1167. var collapsed = recode.collapsed==undefined?true:recode.collapsed;
  1168. collapsed = !collapsed
  1169. recode.collapsed=collapsed;
  1170. //hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,collapsed);
  1171. hitinfo.sheet.getRange(hitinfo.row+1, -1, recode.subList.length, -1).visible(!collapsed);
  1172. hitinfo.sheet.invalidateLayout();
  1173. hitinfo.sheet.repaint();
  1174. }
  1175. }
  1176. };
  1177. return new TreeNodeCellType()
  1178. },
  1179. marketPriceReadOnly:function(node){
  1180. return node.data.type==gljType.CONCRETE||node.data.type==gljType.MORTAR||node.data.type==gljType.MIX_RATIO||node.data.type==gljType.GENERAL_MACHINE||node.data.isEstimate==1
  1181. }
  1182. }
  1183. $(function(){
  1184. $('#glj_tree_div').on('shown.bs.modal', function (e) {
  1185. if(gljOprObj.gljLibSpresd==undefined){
  1186. gljOprObj.gljLibSpresd=sheetCommonObj.buildSheet($('#gljLibSheet')[0], gljOprObj.gljLibSheetSetting, gljOprObj.stdGLJ.length+gljOprObj.complementaryGLJs.length);
  1187. gljOprObj.gljLibSpresd.bind(GC.Spread.Sheets.Events.ButtonClicked,gljOprObj.onButtonClick);
  1188. gljOprObj.gljLibSheet = gljOprObj.gljLibSpresd.getSheet(0);
  1189. gljOprObj.gljLibSheet.options.isProtected = true;
  1190. gljOprObj.gljLibSheet.name('glj_lib');
  1191. }
  1192. gljOprObj.gljLibSheetData =gljOprObj.AllRecode;
  1193. var selected=null;
  1194. if($('#actionType').val()=='add'||$('#actionType').val()=='insert'){
  1195. gljOprObj.GLJSelection=[];
  1196. }else {
  1197. selected=gljOprObj.sheetData[gljContextMenu.selectedRow];
  1198. var connect_key = gljOprObj.getIndex(selected,['code','name','specs','unit','type'])
  1199. gljOprObj.GLJSelection=[connect_key];
  1200. gljOprObj.filterLibGLJByType();
  1201. }
  1202. if(selected!=null){
  1203. var s_key = gljOprObj.getIndex(selected,['code','name','specs','unit','gljType']);
  1204. var r = _.find(gljOprObj.gljLibSheetData,function (item) {
  1205. var item_key = gljOprObj.getIndex(item,['code','name','specs','unit','type']);
  1206. return s_key == item_key;
  1207. });
  1208. r?r.select=1:"";
  1209. }
  1210. gljOprObj.showLibGLJSheetData();
  1211. });
  1212. $('.glj-radio').change(function () {
  1213. let val = $("input[name='glj']:checked").val();
  1214. if(val=='allGljs'){
  1215. gljOprObj.gljLibSheetData =gljOprObj.AllRecode;
  1216. gljOprObj.filterLibGLJSheetData();
  1217. gljOprObj.showLibGLJSheetData();
  1218. }else {
  1219. gljOprObj.gljLibSheetData=gljOprObj[val];
  1220. gljOprObj.filterLibGLJSheetData();
  1221. gljOprObj.showLibGLJSheetData();
  1222. }
  1223. })
  1224. $('#glj_selected_conf').click(function () {
  1225. if(gljOprObj.GLJSelection.length<1){
  1226. return;
  1227. }
  1228. if($('#actionType').val()=='insert'){ //造价书页面中插入定额类型的工料机
  1229. gljOprObj.doInsertGLJ();
  1230. }else if($('#actionType').val()=='add'){ //添加工料机
  1231. gljOprObj.doAddGLJ();
  1232. }else if($('#actionType').val()=='replace'){//替换工料机
  1233. gljOprObj.doReplaceGLJ();
  1234. }else if($('#actionType').val()=='m_replace'){//批量替换工料机
  1235. gljOprObj.doMReplaceGLJ();
  1236. }
  1237. })
  1238. $('#class_selected_conf').click(function () {
  1239. var gljClass = $('#selected_class').val();
  1240. var glj = gljOprObj.selectedGLJClass;
  1241. if(glj&&gljClass&&gljClass!=""){
  1242. //保存到我的工料机库
  1243. /*1 检查是否有组成物
  1244. * 2 如果有,则检查组成物中是否有新增的记录,如果有,查看是否已经保存了,没有的话,要先添加组成物到补充工料机库
  1245. * 3 保存
  1246. * */
  1247. var newItem={
  1248. code:glj.code,
  1249. name:glj.name,
  1250. specs:glj.specs,
  1251. unit:glj.unit,
  1252. basePrice:glj.basePrice,
  1253. gljType:glj.type,
  1254. shortName:glj.shortName,
  1255. component:[],
  1256. gljClass:gljClass
  1257. };
  1258. if(glj.hasOwnProperty("subList")&&glj.subList.length>0){//有组成物,检查组成物信息,目前组成物不允许修改,所以暂时不用考虑组成物是新增的情况
  1259. for(var i=0;i<glj.subList.length;i++ ){
  1260. let tem={
  1261. ID:glj.subList[i].GLJID,
  1262. consumeAmt:glj.rationItemQuantity,
  1263. isStd:true
  1264. }
  1265. newItem.component.push(tem);
  1266. }
  1267. }
  1268. var data = getcmpUpdateData([newItem]);
  1269. $.bootstrapLoading.start();
  1270. var callback = function (data) {
  1271. $("#glj_class_div").modal('hide');
  1272. $.bootstrapLoading.end();
  1273. }
  1274. CommonAjax.post("complementartGlj/api/mixUpdateGljItems", data, callback, function () {
  1275. $.bootstrapLoading.end();
  1276. });
  1277. }
  1278. })
  1279. $('#glj_class_div').on('hidden.bs.modal', function (e){
  1280. gljOprObj.selectedGLJClass=null;
  1281. $('#class_selected_conf').attr("disabled","disabled");
  1282. $('#selected_class').val("");
  1283. })
  1284. function getcmpUpdateData(items) {
  1285. var data ={
  1286. "updateItems": [],
  1287. "removeIds": []
  1288. }
  1289. data.addItems = items;
  1290. return data;
  1291. }
  1292. })
  1293. function getDecimal(fieldID,node) {
  1294. if(node){
  1295. return decimalObj.decimal(fieldID,node);
  1296. }else if(fieldID.indexOf(".")!=-1){
  1297. var keyArray = fieldID.split(".");
  1298. return decimalObj[keyArray[0]][keyArray[1]];
  1299. }else {
  1300. return decimalObj.decimal(fieldID);
  1301. }
  1302. }
  1303. function getFormatter(decimal) {
  1304. var pre = "0.";
  1305. if(decimal<=0){
  1306. return "0";
  1307. }
  1308. for(i=0;i<decimal;i++){
  1309. pre += "0"
  1310. }
  1311. return pre;
  1312. }
  1313. function sortRationGLJ(list) {
  1314. list= _.sortByAll(list,[function (item) {
  1315. return item.type+"";
  1316. },"code"])
  1317. return list;
  1318. }
  1319. function compareRationGLJ(a,b) {
  1320. if((a.type+"")<(b.type+"")){
  1321. return true
  1322. }
  1323. if((a.type+"")==(b.type+"")){
  1324. if (a.code<b.code){
  1325. return true
  1326. }
  1327. }
  1328. return false;
  1329. }