glj_view.js 51 KB

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