glj_view.js 54 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364
  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: 90, 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. newval = scMathUtil.roundTo(newval,-2);
  782. projectObj.project.ration_ass.updateActualValue(me.assSheetData,args.row,newval)
  783. }else {
  784. newval = recode.actualValue;
  785. me.assSheet.getCell(args.row, args.col).value(newval);
  786. }
  787. },
  788. updateRationCoe:function (args,newval) {
  789. var me = gljOprObj;
  790. var recode = me.coeSheetData[args.row];
  791. projectObj.project.ration_coe.adjustCoeClick(recode,newval);
  792. },
  793. numberValueChecking:function (val) {
  794. var newval = Number(val);
  795. if(number_util.isNumber(newval)){
  796. return newval;
  797. }else {
  798. if(val){
  799. alert('您输入的数据类型不正确,请重新输入。');
  800. }
  801. newval = null;
  802. }
  803. return newval;
  804. },
  805. checkingActualValue(record,newval){
  806. var minExist = record.minValue&&record.minValue!='0'?true:false;
  807. var maxExist = record.maxValue&&record.maxValue!='0'?true:false;
  808. var minValue = parseFloat(record.minValue);
  809. var maxValue = parseFloat(record.maxValue);
  810. var stdVale = parseFloat(record.stdValue);
  811. if(!maxExist&&minExist){
  812. if(newval<minValue){
  813. alert('实际值应≥'+minValue);
  814. return false;
  815. }
  816. }
  817. if(maxExist&&!minExist){
  818. if(newval>maxValue){
  819. alert('实际值应≤'+maxValue);
  820. return false;
  821. }
  822. }
  823. if(maxExist&&minExist){
  824. if(newval<minValue||newval>maxValue){
  825. alert('实际值应介于'+minValue+'~'+maxValue+'之间');
  826. return false;
  827. }
  828. }
  829. return true;
  830. },
  831. showLibGLJSheetData:function () {
  832. this.gljLibSheetData=_.sortBy(this.gljLibSheetData, 'code');
  833. this.gljLibSheet.setRowCount(this.gljLibSheetData.length);
  834. sheetCommonObj.showData(this.gljLibSheet,this.gljLibSheetSetting,this.gljLibSheetData,gljOprObj.distTypeTree);
  835. },
  836. filterLibGLJSheetData:function () {
  837. let me=this;
  838. let val = $("input[name='glj']:checked").val();
  839. if(val=='allGljs'){
  840. me.gljLibSheetData =me.stdGLJ.concat(me.complementaryGLJs);
  841. }else {
  842. me.gljLibSheetData=me[val];
  843. }
  844. if($('#actionType').val()=='replace'||$('#actionType').val()=='m_replace'){
  845. me.filterLibGLJByType();
  846. }
  847. if(me.gljCurTypeId==undefined){
  848. return;
  849. }
  850. if (me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  851. me.gljLibSheetData= _.filter(me.gljLibSheetData, function(n) {
  852. return _.includes(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId],n.gljClass);
  853. });
  854. } else {
  855. me.gljLibSheetData = _.filter(me.gljLibSheetData,{'gljClass':me.gljCurTypeId});
  856. }
  857. },
  858. setGLJSelection:function (args,newVal) {
  859. if($('#actionType').val()=='add'||$('#actionType').val()=='insert'){
  860. this.addGLJsSelection(args,newVal);
  861. }else {
  862. this.replaceGLJSelection(args,newVal);
  863. }
  864. },
  865. addGLJsSelection:function (args,newVal) {
  866. var con_key = this.getIndex(this.gljLibSheetData[args.row],['code','name','specs','unit','gljType'])
  867. if(newVal==1){
  868. this.GLJSelection.push(con_key);
  869. this.gljLibSheetData[args.row].select=1;
  870. }else if(newVal==0){
  871. _.pull(this.GLJSelection,con_key);
  872. this.gljLibSheetData[args.row].select=0;
  873. }
  874. },
  875. replaceGLJSelection:function (args,newVal) {
  876. var me =this;
  877. var oldSelection=this.GLJSelection[0];
  878. if(newVal==0){
  879. args.sheet.getCell(args.row, args.col).value(1);
  880. return;
  881. }
  882. this.GLJSelection=[me.getIndex(this.gljLibSheetData[args.row],['code','name','specs','unit','gljType'])];
  883. this.gljLibSheetData[args.row].select=1;
  884. var oindex = _.findIndex(this.gljLibSheetData,function (item) {
  885. var i_key = me.getIndex(item,['code','name','specs','unit','gljType']);
  886. return oldSelection==i_key;
  887. });
  888. if(oindex!=-1){
  889. args.sheet.getCell(oindex, args.col).value(0);
  890. this.gljLibSheetData[oindex].select=0;
  891. }else {
  892. var oldData = _.find(gljOprObj.AllRecode,function (item) {
  893. var i_key = me.getIndex(item,['code','name','specs','unit','gljType']);
  894. return oldSelection==i_key;
  895. });
  896. oldData?oldData.select=0:"";
  897. }
  898. },
  899. filterLibGLJByType:function () {
  900. var me=this;
  901. var selected=me.sheetData[gljContextMenu.selectedRow];
  902. me.gljLibSheetData=_.filter(me.gljLibSheetData,{'gljType':selected.type});
  903. },
  904. getComboData: function (gljDistType) {
  905. let me = this;
  906. let distType;
  907. let distTypeTree = {
  908. prefix : 'gljType',
  909. distTypes: {},
  910. comboDatas: [],
  911. distTypesArr: []
  912. };
  913. gljDistType.forEach(function (typeData) {
  914. let typeObj = {
  915. data: typeData,
  916. children: [],
  917. parent: null
  918. }
  919. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  920. distTypeTree.distTypesArr.push(typeObj);
  921. });
  922. gljDistType.forEach(function (typeData) {
  923. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  924. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  925. if(parent){
  926. distType.parent = parent;
  927. parent.children.push(distType);
  928. }
  929. });
  930. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  931. if(distTypeObj.data.fullName !== '材料' && distTypeObj.data.fullName !== '机械'){
  932. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  933. }
  934. });
  935. return distTypeTree;
  936. },
  937. doInsertGLJ:function () {
  938. var selected = projectObj.project.mainTree.selected;
  939. var project= projectObj.project;
  940. console.log(gljOprObj.GLJSelection);
  941. },
  942. doAddGLJ:function () {
  943. var selected = projectObj.project.mainTree.selected;
  944. var project= projectObj.project;
  945. gljOprObj.GLJSelection= _.filter(gljOprObj.GLJSelection,function (n) {
  946. var rg = _.find(gljOprObj.sheetData,function (item) {
  947. var i_key = gljOprObj.getIndex(item,['code','name','specs','unit','type']);
  948. return n==i_key
  949. })
  950. return rg?false:true;
  951. })
  952. if(gljOprObj.GLJSelection.length>0&&selected&&selected.sourceType==ModuleNames.ration){
  953. $("#glj_tree_div").modal('hide');
  954. project.ration_glj.addGLJByLib(gljOprObj.GLJSelection,selected.data,function (result) {
  955. if(result){
  956. selected.data.adjustState=result.adjustState;
  957. //project.ration_glj.datas = project.ration_glj.datas.concat(result.newRecodes);//显示和缓存统一,这样的话就不用更新两个位置了
  958. project.ration_glj.datas = project.ration_glj.datas.concat(result.showData);
  959. gljOprObj.sheetData = gljOprObj.sheetData.concat(result.showData);
  960. gljOprObj.showRationGLJSheetData();
  961. project.ration_glj.addToMainTree(result.showData);
  962. project.projectGLJ.loadData();
  963. projectObj.mainController.refreshTreeNode([selected]);
  964. $.bootstrapLoading.end();
  965. }
  966. });//doc.rationID=selected.data.ID;
  967. }else {
  968. $("#glj_tree_div").modal('hide');
  969. }
  970. },
  971. doReplaceGLJ:function () {
  972. var me=this;
  973. var oldData=me.sheetData[gljContextMenu.selectedRow];
  974. var project= projectObj.project;
  975. var selectCode=gljOprObj.GLJSelection[0];
  976. var selected = projectObj.project.mainTree.selected;
  977. $("#glj_tree_div").modal('hide');
  978. project.ration_glj.replaceGLJ(selectCode,oldData,function (result) {
  979. if(result){
  980. //result.adjustState;
  981. var data =result.data;
  982. var index = _.findIndex(gljOprObj.sheetData,{'ID':data.ID});
  983. var nodes = [selected];
  984. gljOprObj.sheetData[index]=data;
  985. gljOprObj.showRationGLJSheetData();
  986. if(project.ration_glj.needShowToTree(data)){//当替换的是主材或设备时,刷新对应的树节点
  987. var node = project.ration_glj.findTreeNodeByID(data.ID);
  988. if(node){
  989. project.ration_glj.transferToNodeData(data);
  990. node.source = data;
  991. node.data = data;
  992. }
  993. node?nodes.push(node):"";
  994. }
  995. //project.ration_glj.addToMainTree(data);
  996. project.projectGLJ.loadData();
  997. selected.data.adjustState=result.adjustState;
  998. projectObj.mainController.refreshTreeNode(nodes);
  999. }
  1000. $.bootstrapLoading.end();
  1001. })
  1002. },
  1003. doMReplaceGLJ:function () {
  1004. var me=this;
  1005. var oldData=me.sheetData[gljContextMenu.selectedRow];
  1006. var project= projectObj.project;
  1007. var selectCode=me.GLJSelection[0];
  1008. $("#glj_tree_div").modal('hide');
  1009. project.ration_glj.mReplaceGLJ(selectCode,oldData,function (result) {
  1010. var data=result.data;
  1011. var stateList= result.stateList;
  1012. var n_index = me.getIndex(data.query,['code','name','specs','unit','type']);
  1013. var nodes=[];
  1014. _.forEach(project.ration_glj.datas,function (t) {
  1015. var t_index =me.getIndex(t,['code','name','specs','unit','type']);
  1016. if(n_index==t_index){
  1017. me.updateProperty(t,data.doc);
  1018. if(project.ration_glj.needShowToTree(t)){//如果是造价书中的树节点,则也须刷新
  1019. project.ration_glj.transferToNodeData(t);
  1020. var node = project.ration_glj.findTreeNodeByID(t.ID);
  1021. nodes.push(node);
  1022. }
  1023. }
  1024. })
  1025. me.showRationGLJSheetData();
  1026. project.projectGLJ.loadData();
  1027. me.refreshStateAfterMreplace(stateList,nodes);
  1028. $.bootstrapLoading.end();
  1029. })
  1030. },
  1031. updateProperty:function (obj,doc) {
  1032. _.forEach(doc, function(n, key) {
  1033. obj[key] = n;
  1034. });
  1035. },
  1036. refreshStateAfterMreplace:function (stateList,gljNodes) {
  1037. var nodes=[];
  1038. _.forEach(stateList,function (s) {
  1039. var node = _.find(projectObj.project.mainTree.items,function (n) {
  1040. return n.sourceType==ModuleNames.ration&&n.data.ID==s.rationID;
  1041. })
  1042. if(node){
  1043. node.data.adjustState=s.adjustState;
  1044. nodes.push(node);
  1045. }
  1046. });
  1047. gljNodes.length>0?nodes = nodes.concat(gljNodes):"";
  1048. projectObj.mainController.refreshTreeNode(nodes);
  1049. },
  1050. refreshView:function () {
  1051. this.showRationGLJData();
  1052. },
  1053. //
  1054. refreshTreeNode:function (obj) {
  1055. if(!obj){
  1056. return;
  1057. }
  1058. var objectArray =[];
  1059. var nodes =[];
  1060. if(obj instanceof Array){
  1061. objectArray.concat(obj);
  1062. }else {
  1063. objectArray.push(obj);
  1064. }
  1065. for(let o of objectArray ){
  1066. var node = _.find(projectObj.project.mainTree.items,function (n) {
  1067. return n.sourceType==o.type&&n.data.ID==o.ID;
  1068. })
  1069. if(node){
  1070. for (var k in o.data){
  1071. node.data[k] = o.data[k];
  1072. }
  1073. nodes.push(node);
  1074. }
  1075. }
  1076. projectObj.mainController.refreshTreeNode(nodes);
  1077. },
  1078. getTreeNodeCellType:function (data) {
  1079. var ns = GC.Spread.Sheets;
  1080. var rectW = 10;
  1081. var rectH = 10;
  1082. var margin = 3;
  1083. function TreeNodeCellType() {
  1084. }
  1085. function drowRect(ctx,x,y,w,h) {
  1086. ctx.save();
  1087. ctx.strokeStyle = "gray";
  1088. ctx.translate(0.5,0.5);
  1089. ctx.beginPath();
  1090. var rectX = x+margin;
  1091. var rectY = y+ Math.round(h/2)-rectH/2;
  1092. ctx.moveTo(rectX, rectY);
  1093. ctx.lineTo(rectX, rectY+rectH);
  1094. ctx.lineTo(rectX+rectW, rectY+rectH);
  1095. ctx.lineTo(rectX+rectW, rectY);
  1096. ctx.lineTo(rectX, rectY);
  1097. ctx.moveTo(rectX+rectW, y+Math.round(h/2));
  1098. ctx.lineTo(rectX+rectW+5, y+Math.round(h/2));
  1099. ctx.stroke();
  1100. ctx.restore();
  1101. }
  1102. function drowSymbol(ctx,x,y,w,h,collapsed) {
  1103. ctx.save();
  1104. ctx.strokeStyle = "#000000";
  1105. ctx.translate(0.5, 0.5);
  1106. ctx.beginPath();
  1107. ctx.moveTo(x+margin+2, y+Math.round(h/2));
  1108. ctx.lineTo(x+margin+8, y+Math.round(h/2));
  1109. var rectY = y+ Math.round(h/2)-rectH/2;
  1110. if(collapsed){
  1111. ctx.moveTo(x+margin+rectW/2,rectY+2);
  1112. ctx.lineTo(x+margin+rectW/2,rectY+2+6);
  1113. }
  1114. ctx.stroke();
  1115. ctx.restore();
  1116. }
  1117. function drowSubItem(ctx,x,y,w,h,offset,nextItem) {
  1118. offset+=6;
  1119. ctx.save();
  1120. ctx.strokeStyle = "gray";
  1121. ctx.translate(0.5, 0.5);
  1122. ctx.beginPath();
  1123. ctx.moveTo(x+offset, y);
  1124. ctx.lineTo(x+offset, y+Math.round(h/2));
  1125. offset+=9;
  1126. ctx.lineTo(x+offset, y+Math.round(h/2));
  1127. if(nextItem&&nextItem.isMixRatio){
  1128. ctx.moveTo(x+offset-9, y+Math.round(h/2));
  1129. ctx.lineTo(x+offset-9, y+h);
  1130. }
  1131. ctx.stroke();
  1132. ctx.restore();
  1133. return offset;
  1134. }
  1135. TreeNodeCellType.prototype = new ns.CellTypes.Text();
  1136. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  1137. if(value!=null){
  1138. var offset = margin+rectW+6;
  1139. var recode = data[options.row];
  1140. if(recode&&recode.hasOwnProperty('subList')){
  1141. drowRect(ctx,x,y,w,h);
  1142. var collapsed = recode.collapsed==undefined?true:recode.collapsed;//options.sheet.getTag(options.row,options.col);
  1143. drowSymbol(ctx,x,y,w,h,collapsed);
  1144. }else if(recode&&recode.isMixRatio){
  1145. offset= drowSubItem(ctx,x,y,w,h,offset,data[options.row+1]);
  1146. offset+=1;
  1147. }
  1148. ctx.fillText(value,x+offset+ctx.measureText(value).width,y+h-5);
  1149. }
  1150. };
  1151. // override getHitInfo to allow cell type get mouse messages
  1152. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  1153. return {
  1154. x: x,
  1155. y: y,
  1156. row: context.row,
  1157. col: context.col,
  1158. cellStyle: cellStyle,
  1159. cellRect: cellRect,
  1160. sheetArea: context.sheetArea
  1161. };
  1162. }
  1163. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  1164. var recode = data[hitinfo.row];
  1165. if(recode&&recode.hasOwnProperty('subList')){
  1166. var hoffset= hitinfo.cellRect.x+3;
  1167. if (hitinfo.x > hoffset && hitinfo.x < hoffset + 10){
  1168. var collapsed = recode.collapsed==undefined?true:recode.collapsed;
  1169. collapsed = !collapsed
  1170. recode.collapsed=collapsed;
  1171. //hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,collapsed);
  1172. hitinfo.sheet.getRange(hitinfo.row+1, -1, recode.subList.length, -1).visible(!collapsed);
  1173. hitinfo.sheet.invalidateLayout();
  1174. hitinfo.sheet.repaint();
  1175. }
  1176. }
  1177. };
  1178. return new TreeNodeCellType()
  1179. },
  1180. marketPriceReadOnly:function(node){
  1181. 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
  1182. }
  1183. }
  1184. $(function(){
  1185. $('#glj_tree_div').on('shown.bs.modal', function (e) {
  1186. if(gljOprObj.gljLibSpresd==undefined){
  1187. gljOprObj.gljLibSpresd=sheetCommonObj.buildSheet($('#gljLibSheet')[0], gljOprObj.gljLibSheetSetting, gljOprObj.stdGLJ.length+gljOprObj.complementaryGLJs.length);
  1188. gljOprObj.gljLibSpresd.bind(GC.Spread.Sheets.Events.ButtonClicked,gljOprObj.onButtonClick);
  1189. gljOprObj.gljLibSheet = gljOprObj.gljLibSpresd.getSheet(0);
  1190. gljOprObj.gljLibSheet.options.isProtected = true;
  1191. gljOprObj.gljLibSheet.name('glj_lib');
  1192. }
  1193. gljOprObj.gljLibSheetData =gljOprObj.AllRecode;
  1194. var selected=null;
  1195. if($('#actionType').val()=='add'||$('#actionType').val()=='insert'){
  1196. gljOprObj.GLJSelection=[];
  1197. }else {
  1198. selected=gljOprObj.sheetData[gljContextMenu.selectedRow];
  1199. var connect_key = gljOprObj.getIndex(selected,['code','name','specs','unit','type'])
  1200. gljOprObj.GLJSelection=[connect_key];
  1201. gljOprObj.filterLibGLJByType();
  1202. }
  1203. if(selected!=null){
  1204. var s_key = gljOprObj.getIndex(selected,['code','name','specs','unit','gljType']);
  1205. var r = _.find(gljOprObj.gljLibSheetData,function (item) {
  1206. var item_key = gljOprObj.getIndex(item,['code','name','specs','unit','type']);
  1207. return s_key == item_key;
  1208. });
  1209. r?r.select=1:"";
  1210. }
  1211. gljOprObj.showLibGLJSheetData();
  1212. });
  1213. $('.glj-radio').change(function () {
  1214. let val = $("input[name='glj']:checked").val();
  1215. if(val=='allGljs'){
  1216. gljOprObj.gljLibSheetData =gljOprObj.AllRecode;
  1217. gljOprObj.filterLibGLJSheetData();
  1218. gljOprObj.showLibGLJSheetData();
  1219. }else {
  1220. gljOprObj.gljLibSheetData=gljOprObj[val];
  1221. gljOprObj.filterLibGLJSheetData();
  1222. gljOprObj.showLibGLJSheetData();
  1223. }
  1224. })
  1225. $('#glj_selected_conf').click(function () {
  1226. if(gljOprObj.GLJSelection.length<1){
  1227. return;
  1228. }
  1229. if($('#actionType').val()=='insert'){ //造价书页面中插入定额类型的工料机
  1230. gljOprObj.doInsertGLJ();
  1231. }else if($('#actionType').val()=='add'){ //添加工料机
  1232. gljOprObj.doAddGLJ();
  1233. }else if($('#actionType').val()=='replace'){//替换工料机
  1234. gljOprObj.doReplaceGLJ();
  1235. }else if($('#actionType').val()=='m_replace'){//批量替换工料机
  1236. gljOprObj.doMReplaceGLJ();
  1237. }
  1238. })
  1239. $('#class_selected_conf').click(function () {
  1240. var gljClass = $('#selected_class').val();
  1241. var glj = gljOprObj.selectedGLJClass;
  1242. if(glj&&gljClass&&gljClass!=""){
  1243. //保存到我的工料机库
  1244. /*1 检查是否有组成物
  1245. * 2 如果有,则检查组成物中是否有新增的记录,如果有,查看是否已经保存了,没有的话,要先添加组成物到补充工料机库
  1246. * 3 保存
  1247. * */
  1248. var newItem={
  1249. code:glj.code,
  1250. name:glj.name,
  1251. specs:glj.specs,
  1252. unit:glj.unit,
  1253. basePrice:glj.basePrice,
  1254. gljType:glj.type,
  1255. shortName:glj.shortName,
  1256. component:[],
  1257. gljClass:gljClass
  1258. };
  1259. if(glj.hasOwnProperty("subList")&&glj.subList.length>0){//有组成物,检查组成物信息,目前组成物不允许修改,所以暂时不用考虑组成物是新增的情况
  1260. for(var i=0;i<glj.subList.length;i++ ){
  1261. let tem={
  1262. ID:glj.subList[i].GLJID,
  1263. consumeAmt:glj.rationItemQuantity,
  1264. isStd:true
  1265. }
  1266. newItem.component.push(tem);
  1267. }
  1268. }
  1269. var data = getcmpUpdateData([newItem]);
  1270. $.bootstrapLoading.start();
  1271. var callback = function (data) {
  1272. $("#glj_class_div").modal('hide');
  1273. $.bootstrapLoading.end();
  1274. }
  1275. CommonAjax.post("complementartGlj/api/mixUpdateGljItems", data, callback, function () {
  1276. $.bootstrapLoading.end();
  1277. });
  1278. }
  1279. })
  1280. $('#glj_class_div').on('hidden.bs.modal', function (e){
  1281. gljOprObj.selectedGLJClass=null;
  1282. $('#class_selected_conf').attr("disabled","disabled");
  1283. $('#selected_class').val("");
  1284. })
  1285. function getcmpUpdateData(items) {
  1286. var data ={
  1287. "updateItems": [],
  1288. "removeIds": []
  1289. }
  1290. data.addItems = items;
  1291. return data;
  1292. }
  1293. })
  1294. function getDecimal(fieldID,node) {
  1295. if(node){
  1296. return decimalObj.decimal(fieldID,node);
  1297. }else if(fieldID.indexOf(".")!=-1){
  1298. var keyArray = fieldID.split(".");
  1299. return decimalObj[keyArray[0]][keyArray[1]];
  1300. }else {
  1301. return decimalObj.decimal(fieldID);
  1302. }
  1303. }
  1304. function getFormatter(decimal) {
  1305. var pre = "0.";
  1306. if(decimal<=0){
  1307. return "0";
  1308. }
  1309. for(i=0;i<decimal;i++){
  1310. pre += "0"
  1311. }
  1312. return pre;
  1313. }
  1314. function sortRationGLJ(list) {
  1315. list= _.sortByAll(list,[function (item) {
  1316. return item.type+"";
  1317. },"code"])
  1318. return list;
  1319. }
  1320. function compareRationGLJ(a,b) {
  1321. if((a.type+"")<(b.type+"")){
  1322. return true
  1323. }
  1324. if((a.type+"")==(b.type+"")){
  1325. if (a.code<b.code){
  1326. return true
  1327. }
  1328. }
  1329. return false;
  1330. }