glj_view.js 80 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797
  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. checkb: null,
  10. rationGljEditObj:null,//编辑定额工料机还没提交的缓存数据
  11. cancelUpdate:true,
  12. mainTreeSelectedChange:false,
  13. detailSheet: null,
  14. detailData: [],
  15. GLJSelection: [],
  16. selectedGLJClass: null,
  17. parentNodeIds: {},
  18. preActiveTab: '', //提升焦点变换性能 2019年4月15日
  19. activeTab: '#linkGLJ',
  20. rationTab:'#linkGLJ',
  21. billsTab:'#linkGCLMX',
  22. setting: {},
  23. detailSetting: {
  24. header: [
  25. {headerName: "名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  26. {headerName: "计算式", headerWidth: 120, dataCode: "regex", dataType: "String"},
  27. {headerName: "结果(C)", headerWidth: 120, dataCode: "result", dataType: "Number", decimalField: "quantity_detail"},
  28. {headerName: "累加", headerWidth: 120, dataCode: "isSummation", dataType: "String", cellType: "checkBox"}
  29. ],
  30. view: {
  31. lockColumns: [2, 3],
  32. rowHeaderWidth:25
  33. }
  34. },
  35. gljTreeSetting: {
  36. view: {
  37. expandSpeed: "",
  38. selectedMulti: false
  39. },
  40. edit: {
  41. enable: false,
  42. editNameSelectAll: true,
  43. showRemoveBtn: true,
  44. showRenameBtn: true,
  45. removeTitle: "删除节点",
  46. renameTitle: "更改名称"
  47. },
  48. data: {
  49. keep: {
  50. parent: true,
  51. leaf: true
  52. },
  53. key: {
  54. children: "items",
  55. name: "Name"
  56. },
  57. simpleData: {
  58. enable: false,
  59. idKey: "ID",
  60. pIdKey: "ParentID",
  61. rootPId: -1
  62. }
  63. },
  64. callback: {
  65. onClick: function (event, treeId, treeNode) {
  66. if (treeId == 'gljTree') {
  67. let me = gljOprObj, gljTypeId = treeNode.ID;
  68. if (treeNode.ID) {
  69. me.gljCurTypeId = treeNode.ID;
  70. me.filterLibGLJSheetData();
  71. me.showLibGLJSheetData();
  72. gljOprObj.initSelection({row: me.gljLibSheet.getActiveRowIndex()});
  73. }
  74. } else {
  75. if (treeNode.isParent) {
  76. $('#class_selected_conf').attr("disabled", "disabled");
  77. $('#selected_class').val("");
  78. } else {
  79. $('#class_selected_conf').removeAttr("disabled");
  80. $('#selected_class').val(treeNode.ID);
  81. }
  82. }
  83. }
  84. }
  85. },
  86. gljLibSheetSetting: {
  87. owner: 'gljTree',
  88. header: [
  89. {headerName: "选择", headerWidth: 40, dataCode: "select", hAlign: "center", vAlign: "center", cellType: "checkBox"},
  90. {headerName: "编码", headerWidth: 80, dataCode: "code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  91. {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String", hAlign: "left", vAlign: "center"},
  92. {headerName: "规格型号", headerWidth: 160, dataCode: "specs", dataType: "String", hAlign: "left", vAlign: "center"},
  93. {headerName: "单位", headerWidth: 40, dataCode: "unit", dataType: "String", hAlign: "center", vAlign: "center"},
  94. {headerName: "单价", headerWidth: 55, dataCode: "basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  95. {headerName: "类型", headerWidth: 60, dataCode: "gljType", dataType: "String", hAlign: "center", vAlign: "center"},
  96. {headerName: "新增", headerWidth: 40, dataCode: "isComplementary", dataType: "String", hAlign: "center", vAlign: "center", cellType: "checkBox"}
  97. ],
  98. view: {
  99. lockColumns: [0, 1, 2, 3, 4, 5, 6]
  100. }
  101. },
  102. gljLibSheet: null,
  103. scopeSetting:{},
  104. scopeSpread:null,
  105. scopeSheet:null,
  106. scopeDatas:[],
  107. scopeSelectedIDMap:{},
  108. initSheet: function (sheet) {
  109. var me = this;
  110. me.sheet = sheet;
  111. sheetCommonObj.initSheet(me.sheet, me.setting, 30);
  112. sheet.name('ration_glj');
  113. me.bindSheetEvent(sheet);
  114. sheet.bind(GC.Spread.Sheets.Events.CellDoubleClick, me.onCellDoubleClick);
  115. sheet.bind(GC.Spread.Sheets.Events.ClipboardChanged, me.onClipboardChanged);
  116. subSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, me.onButtonClick);
  117. if(!projectReadOnly){
  118. gljContextMenu.loadGLJSpreadContextMenu();
  119. me.bindGLJEnterKey(subSpread,sheet);
  120. }
  121. sheet.bind(GC.Spread.Sheets.Events.SelectionChanged,me.onRationGLJSelectionChange);
  122. sheet.bind(GC.Spread.Sheets.Events.CellClick,function () {
  123. //这里主要记录是否点击了sheet以外的地方,如果点击了sheet里的单元格,则将cancelUpdate设置为true不触发提交更新操作
  124. me.cancelUpdate = true;//取消延时任务由selection change 事件处理
  125. });
  126. },
  127. onRationGLJSelectionChange:function(sender,args){
  128. let me = gljOprObj;
  129. let selected = args.newSelections[0] ? args.newSelections[0] : {row: 0, col: 0};
  130. //这主要记录是否点击了sheet以外的地方,如果点击了sheet里的单元格,则将cancelUpdate设置为true不触发提交更新操作
  131. me.cancelUpdate = true;//取消延时任务由这里进行判断处理
  132. me.sheetInitSelection(selected);
  133. if(me.rationGljEditObj){
  134. if(ifNeedUpdate(selected)){
  135. me.updateGljFromCache();
  136. }
  137. }
  138. function ifNeedUpdate(selected) {
  139. let navigationRightCol = me.setting.navigationRightCol , fieldID = me.setting.header[selected.col].dataCode;
  140. if(me.rationGljEditObj.row == selected.row && navigationRightCol.indexOf(fieldID)!= -1){//如果换行或者超出了三个编辑列,则提交更新
  141. return false;
  142. }
  143. return true;
  144. }
  145. },
  146. updateGljFromCache:function () {
  147. let me = this;
  148. if(me.rationGljEditObj){
  149. projectObj.project.ration_glj.submitChange(me.rationGljEditObj.recode, me.rationGljEditObj.doc);
  150. }
  151. me.rationGljEditObj = null;
  152. },
  153. bindGLJEnterKey:function (spread,sheet) {
  154. let me = this;
  155. subSpread.commandManager().register('myEnter', enterKeyAction);
  156. subSpread.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.enter, false, false, false, false);
  157. subSpread.commandManager().setShortcutKey('myEnter', GC.Spread.Commands.Key.enter, false, false, false, false);
  158. function enterKeyAction(spd,sheeName) {
  159. let editRow = sheet.getActiveRowIndex(),orgCol = sheet.getActiveColumnIndex();
  160. let fieldID = me.setting.header[orgCol].dataCode;
  161. if(sheeName=="ration_glj" && me.setting.navigationRightCol.indexOf(fieldID) != -1){
  162. if(sheet.isEditing()) sheet.endEdit();
  163. GC.Spread.Sheets.Commands.navigationRight.execute(spd,sheeName);
  164. }else {
  165. GC.Spread.Sheets.Commands.commitInputNavigationDown.execute(spd,sheeName);
  166. }
  167. }
  168. },
  169. sheetInitSelection: function (selected) {
  170. let me = gljOprObj;
  171. let style = {};
  172. if(selected.row < me.sheetData.length){
  173. if(me.setting.getStyle) style = me.setting.getStyle(me.sheetData[selected.row]);
  174. me.sheet.setStyle(selected.row, -1, me.getSelStyle(true,style));
  175. }
  176. me.sheet.repaint();
  177. if(me.preGljSelection && me.preGljSelection.row !== selected.row){
  178. if(me.setting.getStyle && me.preGljSelection.row < me.sheetData.length) style = me.setting.getStyle(me.sheetData[me.preGljSelection.row]);
  179. me.sheet.setStyle(me.preGljSelection.row, -1, me.getSelStyle(false,style));
  180. }
  181. me.preGljSelection = selected;
  182. },
  183. initDetailSheet: function (sheet) {
  184. var me = this;
  185. me.detailSheet = sheet;
  186. sheetCommonObj.initSheet(me.detailSheet, me.detailSetting, 30);
  187. // me.detailSheet.selectionUnit(0);//0 cell,1 row,2 col;
  188. sheet.name('quantity_detail');
  189. me.bindSheetEvent(sheet);
  190. },
  191. detailSheetReadonly:function () {
  192. let selected = projectObj.project.mainTree.selected;
  193. let Bills = projectObj.project.Bills;
  194. if(selected) {
  195. //清单锁定时只读
  196. if(selected.sourceType == ModuleNames.bills && projectObj.project.isBillsLocked() && projectObj.project.withinBillsLocked(selected)){
  197. return true;
  198. }
  199. //大项费用、分部节点层次时,工程量明细只读。
  200. if(indicativeInfoObj.isDXFY(selected) || indicativeInfoObj.isFB(selected)){
  201. return true;
  202. }
  203. //是主材或者是设备时只读
  204. if(selected.sourceType == ModuleNames.ration_glj){
  205. return true;
  206. }else if(gljOprObj.isInstallationNode(selected)){//是补项或者是安装类型的定额时只读
  207. return true;
  208. }
  209. return false;
  210. }
  211. return true;
  212. },
  213. bindSheetEvent: function (sheet) {
  214. var me = this;
  215. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  216. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  217. sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
  218. sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  219. sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.startEditChecking);
  220. // sheet.bind(GC.Spread.Sheets.Events.CellClick, me.onCellClick);
  221. },
  222. onClipboardPasting: function (sender, args) {
  223. var me = gljOprObj;
  224. if(args.sheetName!="quantity_detail"&&(args.cellRange.rowCount!=1||args.cellRange.colCount!=1)){//工程量明细做特殊处理
  225. args.cancel = true;
  226. }
  227. },
  228. onClipboardPasted: function (e, info) {
  229. var me = gljOprObj;
  230. console.log('past');
  231. // if (!me.ration) {return;};
  232. // your code...
  233. },
  234. startEditChecking:function (sender,args) {
  235. let me = gljOprObj;
  236. let selected = projectObj.project.mainTree.selected;
  237. if($.bootstrapLoading.isLoading()) args.cancel = true;
  238. if(selected){
  239. if(me.isInstallationNode(selected)==true){
  240. args.cancel = true;
  241. }else {
  242. if(args.sheetName == 'quantity_detail'){//工程量明细表
  243. if(me.detailSheetReadonly()){
  244. args.cancel = true;
  245. }else {
  246. if(args.sheet.getValue(args.row,args.col)==null){//这里是为了解决当单元格里的值是null的时候,在单元格里输入数据,按键盘箭头移动光标的时候,会直接结束编辑,跳到另外的单元格。
  247. args.sheet.setValue(args.row,args.col,"");
  248. }
  249. }
  250. }
  251. if(args.sheetName == 'ration_glj'){//定额工料机表
  252. if(!me.rationGLJEditCheck(args)) args.cancel = true;
  253. }
  254. }
  255. }else {
  256. args.cancel = true;
  257. }
  258. },
  259. isInstallationNode:function(node){
  260. if(node.sourceType == ModuleNames.ration&&node.data.type == rationType.install){//是定额安装费类型时只读,原先是补项的时候也是控制只读的||(node.sourceType == ModuleNames.bills&&node.data.type==billType.BX)){//是定额安装费类型或者补项
  261. return true;
  262. }
  263. return false
  264. },
  265. onEditEnded: function (sender, args) {
  266. var me = gljOprObj;
  267. if (args.sheetName == 'ration_glj') {
  268. me.onEditGLJSheet(args)
  269. }
  270. if (args.sheetName == 'quantity_detail') {
  271. me.onEditDetailSheet(args);
  272. }
  273. },
  274. onEditDetailSheet: function (args,callback) {
  275. var me = gljOprObj;
  276. if (args.row > me.detailData.length) {
  277. return;
  278. }
  279. if (args.row == me.detailData.length && args.editingText == null) {
  280. return;
  281. }
  282. var selected = projectObj.project.mainTree.selected;//因为使用了延时方法,所以要先取得选中行;
  283. var detailList = me.detailData;
  284. if(args.editingText){
  285. args.editingText = args.editingText.replace(/(/g, "(");//替换中文左右括号;
  286. args.editingText = args.editingText.replace(/)/g, ")");
  287. }
  288. if (args.row == detailList.length) {
  289. projectObj.project.quantity_detail.saveQuantityDetail(args, me.detailSetting.header[args.col].dataCode, selected,callback);
  290. }
  291. if (args.row < detailList.length) {
  292. projectObj.project.quantity_detail.updateQuantityDetail(args, me.detailSetting.header[args.col].dataCode, detailList[args.row], selected,callback);
  293. }
  294. },
  295. onEditGLJSheet: function (args) {
  296. var me = gljOprObj;
  297. if (args.row >= me.sheetData.length) {
  298. me.sheet.getCell(args.row, args.col).value(null);
  299. return;
  300. }
  301. me.updateRationGLJ(args);
  302. },
  303. onSelectionChanged: function (sender, args) {
  304. let me = gljOprObj;
  305. me.initSelection(args.newSelections.length > 0 ? {row: args.newSelections[0].row} : {row: 0});
  306. },
  307. getSelStyle: function (selected,settingStyle,rcolor) {
  308. let style = new GC.Spread.Sheets.Style();
  309. if(settingStyle){
  310. for(let key in settingStyle){
  311. style[key] = settingStyle[key];
  312. }
  313. }
  314. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  315. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  316. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  317. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  318. let colorOpts = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  319. let selectedColor = colorOpts.SELECTED.backColor,
  320. recColor = rcolor?rcolor:'White';
  321. style.backColor = selected ? selectedColor : recColor;
  322. return style;
  323. },
  324. initSelection: function (sel) {
  325. let me = gljOprObj;
  326. if(sel){
  327. sel.row = !sel.row || sel.row == -1 ? 0 : sel.row;
  328. me.gljLibSheet.setStyle(sel.row, -1, me.getSelStyle(true));
  329. }
  330. if(me.preGljLibSelection && me.preGljLibSelection.row !== sel.row){
  331. me.gljLibSheet.setStyle(me.preGljLibSelection.row, -1, me.getSelStyle(false));
  332. }
  333. me.preGljLibSelection = sel;
  334. },
  335. onButtonClick: function (sender, args) {
  336. if(args.sheet.isEditing()){
  337. args.sheet.endEdit();
  338. }
  339. var me = gljOprObj;
  340. var sheet = args.sheet, row = args.row, col = args.col;
  341. var cellType = sheet.getCellType(row, col);
  342. if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
  343. if(args.sheetName == 'rationInstallSheet'){
  344. installationFeeObj.onPositionButtonClick(sender,args);
  345. }
  346. } else {
  347. me.onCheckBoxClick(sender, args)
  348. }
  349. },
  350. onCheckBoxClick: function (sender, args) {
  351. let selected = projectObj.project.mainTree.selected;
  352. if(selected.sourceType == ModuleNames.ration_glj){//选中的是工料机时不可编辑
  353. return ;
  354. }
  355. let checkboxValue = args.sheet.getCell(args.row, args.col).value();
  356. if(args.sheetName == 'rationInstallSheet' && checkboxValue){
  357. return;
  358. }
  359. if(gljOprObj.isInstallationNode(selected)==true){
  360. return;
  361. }
  362. let newval = checkboxValue? 0:1;
  363. args.sheet.getCell(args.row, args.col).value(newval);
  364. if (args.sheetName == 'ration_glj') {
  365. gljOprObj.updateIsEstimate(args,newval);
  366. } else if (args.sheetName == 'quantity_detail') {
  367. projectObj.project.quantity_detail.isSummationUpdate(args, gljOprObj.detailData, newval);
  368. } else if (args.sheetName == 'glj_lib') {
  369. if(gljOprObj.gljLibSheetSetting.header[args.col].dataCode === 'select'){
  370. gljOprObj.setGLJSelection(args, newval);
  371. }
  372. }else if(args.sheetName == 'rationInstallSheet'){
  373. args.newValue = newval;
  374. installationFeeObj.onRationInstallValueChange(sender,args);
  375. }
  376. },
  377. onCellDoubleClick:function (sender, args) {
  378. // 含组成物的材料市场价改为只读,改为双击无反应不提示
  379. /* var me = gljOprObj;
  380. var header = me.setting.header;
  381. if (args.row >= me.sheetData.length) {
  382. return;
  383. }
  384. if (header[args.col] && header[args.col].dataCode == 'marketPrice') {
  385. if(me.hasComposition(me.sheetData[args.row])){
  386. alert("当前工料机的市场价由组成物计算得出,不可直接修改。");
  387. }
  388. }
  389. if (header[args.col] && header[args.col].dataCode == 'basePrice') {
  390. var isAdd = me.sheetData[args.row].isAdd;
  391. if(isAdd==1){//是新增但没有组成物时允许修改定额价
  392. if(me.hasComposition(me.sheetData[args.row])){//如果有组成物,不可修改
  393. alert("当前工料机的定额价由组成物计算得出,不可直接修改。");
  394. }
  395. }
  396. }*/
  397. },
  398. onClipboardChanged: function (sender, info) {
  399. let cDatas = sheetCommonObj.getTableData(info.sheet, null);
  400. sheetCommonObj.copyTextToClipboard(cDatas);
  401. return;
  402. },
  403. rationGLJEditCheck:function (args) {//true 可以编辑,false 不能编辑
  404. let me = gljOprObj,header = me.setting.header;
  405. let dataCode = header[args.col] && header[args.col].dataCode?header[args.col].dataCode:null,recode = me.sheetData[args.row];
  406. if(me.sheet.getTag(args.row,args.col)=="locked") return false;//如果是双击树节点编号里设置了锁定标记,不能编辑
  407. if (_.includes(me.setting.view.lockColumns, args.col)) return false;//如果是锁定的列,不能编辑
  408. if(recode != undefined){
  409. if(recode.isMixRatio){//对于组成物列
  410. return dataCode == 'marketPrice'//允许修改组成物市单价,其它的不可以
  411. }else {
  412. if (dataCode && dataCode == 'marketPrice') {
  413. return !me.marketPriceReadOnly({data:me.sheetData[args.row]});
  414. }
  415. if (dataCode && dataCode == 'basePrice') {
  416. var isAdd = recode.isAdd;
  417. if(isAdd==1){//是新增但没有组成物时允许修改定额价
  418. return !me.marketPriceReadOnly({data:recode});//如果有组成物,不可修改
  419. } else {
  420. return false;
  421. }
  422. }
  423. if(me.isExtraType(recode.type)&&(dataCode == 'name'||dataCode == 'specs'||dataCode == 'unit')){//人材机窗口中的“企业管理费”“利润”“一般风险费”的名称、规格、单位改为只读。
  424. return false;
  425. }
  426. return true;
  427. }
  428. }else {
  429. return false
  430. }
  431. },
  432. hasComposition:function (ration_glj,isRationType) {//判断是否有组成物,有则返回true 现在主材类型的工料机也有可能有组成物。
  433. return gljUtil.hasComposition(ration_glj,isRationType);
  434. },
  435. onRangeChanged: function (sender, args) {
  436. var me = gljOprObj;
  437. if(args.sheetName == 'quantity_detail'){
  438. me.batchUpdateQuantityDetail(args);
  439. }else {
  440. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  441. args.editingText = null;
  442. }else if(args.action == GC.Spread.Sheets.RangeChangedAction.paste){
  443. args.editingText = args.sheet.getCell(args.row,args.col).value();
  444. }else {
  445. return;
  446. }
  447. if (args.sheetName == 'ration_glj') {
  448. me.onEditGLJSheet(args);
  449. }
  450. }
  451. },
  452. batchUpdateQuantityDetail:function (args) {
  453. let me = gljOprObj;
  454. let updateArray = [];
  455. for(let i =0;i<args.changedCells.length;i++){
  456. let c = args.changedCells[i];
  457. let tem = {
  458. row:c.row,
  459. col:c.col,
  460. editingText:args.sheet.getCell(c.row,c.col).text(),
  461. sheet:args.sheet,
  462. sheetName:args.sheetName,
  463. index:i
  464. };
  465. updateArray.push(tem);
  466. }
  467. if(updateArray.length>0){
  468. updateArray.length == 1?me.onEditDetailSheet(updateArray[0]):me.onEditDetailSheet(updateArray[0],updateCallback);
  469. }
  470. function updateCallback(i_args) {
  471. let index = i_args.index;
  472. if(index < updateArray.length-1){
  473. let nextIndex = index+1;
  474. updateArray[nextIndex].replace = i_args.replace;
  475. if(nextIndex == updateArray.length-1){//是最后一个,则不用调callback了
  476. me.onEditDetailSheet(updateArray[nextIndex]);
  477. }else {
  478. me.onEditDetailSheet(updateArray[nextIndex],updateCallback);
  479. }
  480. }
  481. }
  482. },
  483. showDataIfRationSelect: function (node,selectedNodeId) {
  484. var isShow = false;
  485. if(projectReadOnly && this.setting.view.lockColumns){
  486. this.setting.view.lockColumns = null;
  487. }
  488. if(selectedNodeId){
  489. this.selectedNodeId = selectedNodeId;
  490. }
  491. if (node) {
  492. if (this.selectedNodeId && this.selectedNodeId == node.getID()) {
  493. return;
  494. } else {
  495. //恢复底色
  496. this.sheet.setStyle(this.sheet.getActiveRowIndex(), -1, this.getSelStyle(false,this.setting.style));
  497. this.selectedNodeId = node.getID();
  498. }
  499. if (node.sourceType == "ration") {
  500. if(node.data.type==rationType.gljRation){
  501. if($('#linkGLJ').hasClass('active')) this.showMixRatio(node);
  502. }else {
  503. if($('#linkGLJ').hasClass('active')){
  504. this.showRationGLJData(node);
  505. subObj.showGljSubTabData();
  506. // MaterialController.showReplaceDiv(node);
  507. }
  508. if($('#linkAZZJF').hasClass('active')) installationFeeObj.showRationInstallationData(node);
  509. if($('#linkMBZM').hasClass('active')) mbzm_obj.showMBZMData(node);
  510. }
  511. isShow = true;
  512. }
  513. if(node.sourceType == ModuleNames.ration_glj){
  514. if($('#linkGLJ').hasClass('active')) this.showMixRatio(node);
  515. MaterialController.hideReplaceDiv();
  516. isShow = true;
  517. }
  518. if($('#linkGCLMX').hasClass('active')) this.showQuantityDetailData(node);
  519. } else {
  520. this.selectedNodeId = null;
  521. }
  522. if (!isShow) {
  523. this.clearSheetData();
  524. MaterialController.hideReplaceDiv();
  525. }
  526. //子目换算
  527. //zmhs_obj.showZMHSData(node);
  528. // $('#dropdown').hide();
  529. },
  530. showMixRatio:function (node) {//显示组成物到定额工料机
  531. let mixRatioMap = projectObj.project.projectGLJ.datas.mixRatioMap;
  532. let projectGljs = projectObj.project.projectGLJ.datas.gljList;
  533. let indexArray =node.sourceType==ModuleNames.ration?rationKeyArray:gljKeyArray;
  534. let connect_index = this.getIndex(node.data,indexArray);
  535. let gljList=[];
  536. if(mixRatioMap[connect_index]){ //说明是有组成物的类型
  537. gljList = this.getMixRationShowDatas(mixRatioMap[connect_index], projectGljs);
  538. }
  539. if(gljList.length>0){//计算总消耗量
  540. if(node.sourceType==ModuleNames.ration){
  541. this.calcMixRationTotalQuantity(gljList,node.data.quantity);
  542. }else {
  543. let totalQuantity = this.getTotalQuantity(node.data);
  544. this.calcMixRationTotalQuantity(gljList,totalQuantity)
  545. }
  546. }
  547. this.sheetData = gljList;
  548. this.sheet.setRowCount(0);
  549. this.sheetData = gljUtil.sortRationGLJ(this.sheetData);
  550. this.sheet.getRange(-1, 0, -1, 1).cellType(this.getTreeNodeCellType([]));
  551. sheetCommonObj.showData(this.sheet, this.setting, this.sheetData);
  552. //初始选择
  553. this.preGljSelection = null;
  554. this.sheetInitSelection({row: this.sheet.getActiveRowIndex(), col: 0});
  555. this.sheet.getRange(-1, 0, -1, this.setting.header.length).locked(true);//锁住定额工料机的所有列
  556. this.detailSheet.getRange(-1, 0, -1, this.detailSetting.header.length).locked(true);//锁住工程量明细的所有列
  557. },
  558. showRationGLJData: function (node) {
  559. let gljList = [];
  560. let ration_glj = projectObj.project.ration_glj;
  561. node = node ? node : projectObj.project.mainTree.selected;
  562. if (node.sourceType == ModuleNames.ration) {
  563. if(node.data.type==rationType.gljRation){
  564. this.showMixRatio(node);
  565. }else {
  566. let ration = node.data;
  567. gljList = this.filterGljByRation(ration, ration_glj.datas);
  568. this.showInSheet(gljList);
  569. }
  570. }else if(node.sourceType == ModuleNames.ration_glj){
  571. this.showMixRatio(node);
  572. }
  573. },
  574. showRationGLJSheetData: function (init) {
  575. let me = this;
  576. let selected = this.sheet.getSelections();
  577. this.combineWithProjectGlj(this.sheetData);
  578. this.sheet.setRowCount(0);
  579. this.sheetData = gljUtil.sortRationGLJ(this.sheetData);
  580. this.sumQuantity();//计算总消耗量
  581. this.addMixRatioToShow();//显示组成物信息
  582. this.initRationTree(init,this.getUnitPriceCodeMap());
  583. sheetCommonObj.showData(this.sheet, this.setting, this.sheetData,null,function () {
  584. if(me.mainTreeSelectedChange == true){
  585. me.sheet.setSelection(0,1,1,1);//默认选中第一行,第二列(名称列)
  586. me.mainTreeSelectedChange = false;
  587. }else if(selected){//定位光标到之前的位置
  588. me.sheet.setSelection(selected[0].row,selected[0].col,selected[0].rowCount,selected[0].colCount);
  589. }
  590. //初始选择
  591. me.preGljSelection = null;
  592. me.sheetInitSelection({row: me.sheet.getActiveRowIndex(), col: me.sheet.getActiveColumnIndex()});
  593. });
  594. },
  595. getSelectedRationGlj:function () {
  596. let selected = this.sheet.getSelections()[0];
  597. let ration_glj = this.sheetData[selected.row];
  598. return ration_glj;
  599. },
  600. getUnitPriceCodeMap : function () {//取单价文件中,编码前缀一样的映射表
  601. let codeMap = {};
  602. let priceMap = projectObj.project.projectGLJ.datas.unitPriceMap;
  603. if(priceMap){
  604. for(let connectKey in priceMap){
  605. let code = priceMap[connectKey].code;
  606. let name = priceMap[connectKey].name;
  607. let specs = priceMap[connectKey].specs;
  608. if(code){
  609. let displayText = code +" "+name +" "+specs;
  610. let preCode = code.split("-")[0];
  611. if(codeMap[preCode]) {
  612. codeMap[preCode].push({text:displayText,value:connectKey});
  613. }else {
  614. codeMap[preCode]=[{text:displayText ,value:connectKey}];
  615. }
  616. }
  617. }
  618. }
  619. return codeMap;
  620. },
  621. initRationTree: function (init,codeMap) {
  622. this.sheet.suspendPaint();
  623. this.sheet.suspendEvent();
  624. this.sheet.setRowCount(this.sheetData.length >30?this.sheetData.length:30);
  625. for (var i = 0; i < this.sheetData.length; i++) {
  626. let options = this.getCodeOptions(this.sheetData[i],codeMap);
  627. this.sheet.setCellType(i, 0,this.getTreeNodeCellType(this.sheetData,options),GC.Spread.Sheets.SheetArea.viewport);
  628. if (this.sheetData[i].hasOwnProperty('subList')) {
  629. var collapsed = this.sheetData[i].collapsed == undefined ? true : this.sheetData[i].collapsed;
  630. if (collapsed == true) {
  631. this.sheet.getRange(i + 1, -1, this.sheetData[i].subList.length, -1).visible(false);
  632. }
  633. }
  634. }
  635. this.sheet.resumeEvent();
  636. this.sheet.resumePaint();
  637. },
  638. getCodeOptions:function (recode,codeMap) {
  639. let options = [];
  640. if(recode.isMixRatio ===true){
  641. return null;
  642. }
  643. let code = recode.code;
  644. if(code) {
  645. let preCode = code.split("-")[0];
  646. if( codeMap[preCode]) options = codeMap[preCode];
  647. if(options.length>0) _.remove(options,{'value':gljOprObj.getIndex(recode, gljKeyArray)})//去掉本身
  648. }
  649. return _.sortBy(options,'text');
  650. },
  651. filterGljByRation: function (ration, datas) {
  652. var gljList = [];
  653. if (datas && datas.length > 0) {
  654. gljList = _.filter(datas, {'rationID': ration.ID})
  655. }
  656. return gljList;
  657. },
  658. showInSheet: function (gljList) {
  659. this.sheetData = gljList;
  660. this.showRationGLJSheetData(true);
  661. },
  662. sumQuantity: function (node) {
  663. if (this.sheetData.length > 0) {
  664. node = node ? node : projectObj.project.mainTree.selected;
  665. let ration = node.data;
  666. for (let glj of this.sheetData) {
  667. glj.totalQuantity= this.getTotalQuantity(glj,ration);
  668. }
  669. }
  670. },
  671. getTotalQuantity:function(glj,ration){
  672. if (glj.isMixRatio == true) return;//如果是用于显示的组成物,则不用计算,跳过
  673. ration=ration?ration: _.find(projectObj.project.Ration.datas,{"ID":glj.rationID});
  674. glj.totalQuantity = gljUtil.getTotalQuantity(glj,ration,getDecimal("ration.quantity"),getDecimal("glj.quantity"));
  675. if (glj.hasOwnProperty('subList')) {//需要计算glj下挂的组成物的总消耗量
  676. this.calcMixRationTotalQuantity(glj.subList,glj.totalQuantity);
  677. }
  678. return glj.totalQuantity;
  679. },
  680. calcMixRationTotalQuantity(mList,pTotal){ //计算组成物的总消耗量
  681. for (let subG of mList) {
  682. subG.rationItemQuantity = scMathUtil.roundForObj(subG.rationItemQuantity, getDecimal("glj.quantity"));
  683. subG.totalQuantity = scMathUtil.roundToString(subG.rationItemQuantity * pTotal, getDecimal("glj.quantity"));
  684. }
  685. },
  686. addMixRatioToShow: function () {
  687. var newList = [];
  688. _.remove(this.sheetData, {'isMixRatio': true});
  689. for (var i = 0; i < this.sheetData.length; i++) {
  690. newList.push(this.sheetData[i]);
  691. if (this.sheetData[i].hasOwnProperty('subList')) {
  692. newList = newList.concat(this.sheetData[i].subList);
  693. }
  694. }
  695. this.sheetData = newList;
  696. },
  697. combineWithProjectGlj: function (ration_gljs,needRatio=true,ration,p_gljMap) {
  698. let projectGLJData = projectObj.project.projectGLJ.datas;
  699. let projectGljs = projectGLJData.gljList;
  700. let mixRatioMap = projectGLJData.mixRatioMap;
  701. if (ration_gljs && ration_gljs.length > 0 && projectGljs && projectGljs.length > 0) {
  702. let pgljMap = p_gljMap?p_gljMap:_.indexBy(projectGljs, 'id');
  703. for (let i = 0; i < ration_gljs.length; i++) {
  704. let glj = pgljMap[ration_gljs[i].projectGLJID];
  705. if (glj) {
  706. if(projectObj.project.projectGLJ.isEstimateType(ration_gljs[i].type )){
  707. ration_gljs[i].isEstimate = glj.is_evaluate;
  708. }
  709. ration_gljs[i].shortName =projectObj.project.projectGLJ.getShortNameByID(ration_gljs[i].type);
  710. ration_gljs[i].isAdd = glj.unit_price.is_add;
  711. ration_gljs[i]=this.setGLJPrice(ration_gljs[i],glj,false);//设置工料机价格
  712. let connect_index = this.getIndex(glj, gljKeyArray);
  713. if (needRatio==true&&mixRatioMap.hasOwnProperty(connect_index)) {
  714. let mixRatios = this.getMixRationShowDatas(mixRatioMap[connect_index], projectGljs);
  715. ration_gljs[i].subList = mixRatios;
  716. }
  717. if(needRatio == false){//不需要组成物的情况,目前应该是复制整块那里用到,这里加上毛重系数等信息,一起复制
  718. ration_gljs[i].grossWeightCoe = glj.unit_price.grossWeightCoe;
  719. ration_gljs[i].purchaseStorageRate = glj.unit_price.purchaseStorageRate;
  720. ration_gljs[i].offSiteTransportLossRate = glj.unit_price.offSiteTransportLossRate;
  721. ration_gljs[i].handlingLossRate = glj.unit_price.handlingLossRate
  722. }
  723. if(ration) gljOprObj.getTotalQuantity(ration_gljs[i], ration);
  724. }else {
  725. //计算程序中量价也会放到这里进来,量价是没有对应的项目工料机的
  726. if(ration_gljs[i].type != rationType.volumePrice) console.log("没有找到工料机:"+ration_gljs[i].name)
  727. }
  728. }
  729. }
  730. return ration_gljs;
  731. },
  732. setGLJPrice:function (data,glj,isRadio = false,ext) {//isRadio 标记是否算组成物的价格
  733. let proGLJ = projectObj.project.projectGLJ;
  734. let calcOptions=projectObj.project.projectInfo.property.calcOptions;
  735. let decimalObj = projectObj.project.projectInfo.property.decimal;
  736. let labourCoeDatas = projectObj.project.labourCoe.datas;
  737. glj = glj?glj:_.find(proGLJ.datas.gljList, {'id': data.projectGLJID});
  738. if(glj){
  739. let result = gljUtil.getGLJPrice(glj,proGLJ.datas,calcOptions,labourCoeDatas,decimalObj,isRadio,_,scMathUtil,ext);
  740. data.marketPrice = result.marketPrice;
  741. data.basePrice = result.basePrice;
  742. data.adjustPrice = result.adjustPrice;
  743. data.marketUnitFee = data.marketPrice;//更新树节点市场单价列的值
  744. }
  745. return data;
  746. },
  747. /* testMaterialRationFee:function () {
  748. let freightID = "8db5ff10-f495-11e9-bbf9-ef28356eebc5";
  749. let rationID = "da995300-05f1-11ea-8265-63369b476c76";
  750. let proGLJ = projectObj.project.projectGLJ;
  751. let freightList = proGLJ.datas.freightList;
  752. let calcOptions=projectObj.project.projectInfo.property.calcOptions;
  753. let decimalObj = projectObj.project.projectInfo.property.decimal;
  754. let labourCoeDatas = projectObj.project.labourCoe.datas;
  755. for(let f of freightList){
  756. if(f.ID == freightID){
  757. let r = null;
  758. let ration_gljs = [];
  759. for(let ration of f.rations){
  760. if(ration.ID == rationID) r = ration;
  761. }
  762. for(let rg of f.ration_gljs){
  763. if(rg.rationID == rationID) ration_gljs.push(rg);
  764. }
  765. gljUtil.setMaterialCalcRationFee(r,ration_gljs,proGLJ.datas,calcOptions,labourCoeDatas,decimalObj,_,scMathUtil)
  766. console.log(r);
  767. }
  768. }
  769. },*/
  770. getBasePrice:function (treeNode) {//造价书中的工料机修改的节点要用到
  771. let proGLJ = projectObj.project.projectGLJ;
  772. let glj =_.find(proGLJ.datas.gljList, {'id': treeNode.data.projectGLJID});
  773. if(this.calcPriceDiff(glj)==true){
  774. return proGLJ.getBasePrice(glj);
  775. }else {
  776. return scMathUtil.roundForObj(treeNode.data.marketUnitFee,getDecimal("glj.unitPrice"));
  777. }
  778. },
  779. getMarketPrice:function (treeNode) {//造价书中的工料机修改的节点要用到
  780. let proGLJ = projectObj.project.projectGLJ;
  781. let glj =_.find(proGLJ.datas.gljList, {'id': treeNode.data.projectGLJID});
  782. return proGLJ.getMarketPrice(glj);
  783. },
  784. calcPriceDiff:function (glj) {
  785. let calcOptions=projectObj.project.projectInfo.property.calcOptions;
  786. return gljUtil.calcPriceDiff(glj,calcOptions);
  787. },
  788. getIndex(obj, pops){
  789. return gljUtil.getIndex(obj,pops);
  790. },
  791. getConditionByKey(conKey){//将连接字符串转换成对象
  792. let valueArray = conKey.split("|-|");
  793. let obj ={};
  794. for(let i = 0;i<valueArray.length;i++){
  795. if(valueArray[i]!='null'){
  796. if(gljKeyArray[i]=='type'){
  797. valueArray[i] = parseInt(valueArray[i]);
  798. }
  799. obj[gljKeyArray[i]]=valueArray[i];
  800. }
  801. }
  802. return obj;
  803. },
  804. getMixRationShowDatas: function (mixRatioList, projectGljs) {
  805. var temRationGLJs = [];
  806. for (var i = 0; i < mixRatioList.length; i++) {
  807. let mIndex = gljOprObj.getIndex(mixRatioList[i],gljKeyArray);
  808. var pg = _.find(projectGljs, function (item) {
  809. return gljOprObj.getIndex(item,gljKeyArray) == mIndex
  810. });//改关联关系
  811. if(pg){
  812. let tem = {
  813. projectGLJID: pg.id,
  814. code: pg.code,
  815. name: pg.name,
  816. specs: pg.specs,
  817. unit: pg.unit,
  818. type:mixRatioList[i].type,
  819. shortName: projectObj.project.projectGLJ.getShortNameByID(mixRatioList[i].type),
  820. consumption:mixRatioList[i].consumption,
  821. rationItemQuantity: mixRatioList[i].consumption,
  822. // quantity:mixRatioList[i].consumption,
  823. /* basePrice: pg.unit_price.base_price,
  824. marketPrice: pg.unit_price.market_price,
  825. adjustPrice: pg.adjust_price,*/
  826. //isEstimate: pg.is_evaluate,
  827. isMixRatio: true,
  828. isAdd: pg.unit_price.is_add,
  829. GLJID: pg.glj_id
  830. };
  831. if(projectObj.project.projectGLJ.isEstimateType(pg.type)){
  832. tem.isEstimate = pg.is_evaluate;
  833. }
  834. this.setGLJPrice(tem,pg);
  835. temRationGLJs.push(tem);
  836. }else {
  837. console.log("没有找到工料机:"+mIndex)
  838. }
  839. }
  840. temRationGLJs = gljUtil.sortMixRatio(temRationGLJs);
  841. return temRationGLJs;
  842. },
  843. showQuantityDetailData: function (node) {
  844. node = node ? node : projectObj.project.mainTree.selected;
  845. var quantity_detail = projectObj.project.quantity_detail;
  846. let field = node.sourceType == ModuleNames.ration?'rationID':'billID';
  847. let details = quantity_detail.getListByID(node.data.ID,field);
  848. sheetCommonObj.showData(this.detailSheet, this.detailSetting, details);
  849. this.detailData = details;
  850. if (MainTreeCol.readOnly.forQuantifyDetail(node)) {
  851. this.detailSheet.getRange(-1, 0, -1, this.detailSetting.header.length).locked(true);
  852. }
  853. },
  854. clearSheetData: function () {
  855. if($('#linkGLJ').hasClass('active')){
  856. sheetCommonObj.showData(this.sheet, this.setting, []);
  857. }
  858. if($('#linkAZZJF').hasClass('active')){
  859. installationFeeObj.rationInstallSheet.setRowCount(0);//清除combobox cell
  860. sheetCommonObj.showData(installationFeeObj.rationInstallSheet, installationFeeObj.rationInstallSetting, []);
  861. }
  862. // sheetCommonObj.showData(this.detailSheet,this.detailSetting,[]);
  863. this.sheetData = [];
  864. installationFeeObj.rationInstallData = [];
  865. //this.detailData=[];
  866. },
  867. updateRationGLJ: function (args) {
  868. var me = this;
  869. var updateField = me.setting.header[args.col].dataCode;
  870. var recode = me.sheetData[args.row];
  871. var newval;
  872. if(!me.rationGLJEditCheck(args)){
  873. recode? me.sheet.getCell(args.row, args.col).value(recode[updateField]): me.sheet.getCell(args.row, args.col).value(null);
  874. return;
  875. }
  876. if(args.editingText){
  877. args.editingText = args.editingText.replace(/[\r\n]/g, "");//去掉回车换行等字符;
  878. me.sheet.getCell(args.row, args.col).value(args.editingText);
  879. }
  880. if (updateField == 'marketPrice' || updateField == 'customQuantity' || updateField == 'basePrice') {
  881. if (args.editingText == null) {
  882. updateField == 'marketPrice' ? newval = 0 : newval = "";
  883. } else {
  884. var decimal = updateField == 'customQuantity' ? getDecimal("glj.quantity") : 6;//对于市场价和定额价,这里只是中间的小数位数,后面更新前会根据有没有组成物再取值
  885. newval = number_util.checkNumberValue(args.editingText, decimal);
  886. if (newval == null) {
  887. me.sheet.getCell(args.row, args.col).value(recode[updateField]);
  888. return;
  889. }
  890. }
  891. } else {
  892. if (updateField == 'name' || updateField == 'unit') {
  893. if (args.editingText === null) {
  894. alert(me.setting.header[args.col].headerName + '不能为空!');
  895. me.sheet.getCell(args.row, args.col).value(recode[updateField]);
  896. return;
  897. }
  898. }
  899. if(updateField == 'code'){
  900. if (!gljUtil.isDef(args.editingText)||args.editingText==''||args.editingText.indexOf('|-|') === -1||this.isRationGLJExit(args.editingText)) {//说明是选中自已,或者是已存在的工料机
  901. me.sheet.getCell(args.row, args.col).value(recode[updateField]);
  902. return;
  903. }
  904. }
  905. newval = args.editingText == null ? "" : args.editingText;
  906. }
  907. if (newval === recode[updateField]) {//如果值完全相等,则不需要更新
  908. return
  909. }
  910. if (updateField == 'marketPrice' || updateField == 'basePrice') {
  911. projectObj.project.projectGLJ.updatePriceFromRG(recode, updateField, newval);
  912. }else if(updateField == 'code'){//替换单价文件中已经有的工料机
  913. projectObj.project.ration_glj.updateRationGLJByChangeCode(recode, updateField, newval);
  914. }else if(me.setting.navigationRightCol.indexOf(updateField) != -1){//对于名称、规格、单位先跳到下一列,保存至缓存
  915. me.setToEditCache(recode,updateField, newval,args);
  916. } else {
  917. projectObj.project.ration_glj.updateRationGLJByEdit(recode, updateField, newval);
  918. }
  919. },
  920. setToEditCache:function(recode,updateField,value,args){
  921. let me = this;
  922. if(me.rationGljEditObj == null){
  923. me.rationGljEditObj = {
  924. recode:recode,
  925. doc:{},
  926. row:args.row
  927. }
  928. me.rationGljEditObj.doc[updateField] = value;
  929. }else {
  930. if(me.rationGljEditObj.recode.ID == recode.ID){//确保编辑的是同一条数据
  931. me.rationGljEditObj.doc[updateField] = value;
  932. }
  933. }
  934. },
  935. isRationGLJExit:function (connectKey) {
  936. for(let rg of gljOprObj.sheetData){
  937. if(rg.isMixRatio == true){
  938. continue;
  939. }
  940. if(gljOprObj.getIndex(rg, gljKeyArray) == connectKey){//存在一样的工料机
  941. return true;
  942. }
  943. }
  944. return false;
  945. },
  946. updateRationTypeGLJ: function (value, node, fieldName,editingText) {
  947. let newval;
  948. let updatePrice = false;
  949. if (fieldName == "marketUnitFee" || fieldName == "feesIndex.common.unitFee") {
  950. updatePrice = true;
  951. if (value == null) {
  952. newval = 0;
  953. } else {
  954. var decimal = getDecimal("glj.unitPrice");
  955. newval = number_util.checkNumberValue(value, decimal);
  956. }
  957. }
  958. else {
  959. if (value != null) {
  960. projectObj.project.projectGLJ.updatePropertyFromMainSpread(node, fieldName, value,editingText);
  961. return;
  962. }
  963. }
  964. if (newval && updatePrice == true) {
  965. projectObj.project.projectGLJ.updatePriceFromRG(node.data, "marketPrice", newval);
  966. return
  967. }
  968. projectObj.mainController.refreshTreeNode([node]);
  969. },
  970. updateIsEstimate:function (args, newval) {
  971. var me = gljOprObj;
  972. if(me.setting.header[args.col].dataCode=="isEstimate"){
  973. var pspread= new ProjectGLJSpread();
  974. var recode = me.sheetData[args.row];
  975. let projectGljs = projectObj.project.projectGLJ.datas.gljList;
  976. let glj = _.find(projectGljs, {'id': recode.projectGLJID});
  977. if(glj){
  978. glj["is_evaluate"]=newval;
  979. args.fromRG=true;
  980. pspread.postUpdate(recode.projectGLJID,"is_evaluate",newval,args,null,successTrigger);
  981. }
  982. }
  983. },
  984. showLibGLJSheetData: function () {
  985. //this.gljLibSheetData = _.sortBy(this.gljLibSheetData, 'code');
  986. sheetCommonObj.showData(this.gljLibSheet, this.gljLibSheetSetting, this.gljLibSheetData, gljOprObj.distTypeTree);
  987. this.gljLibSheet.setRowCount(this.gljLibSheetData.length);
  988. },
  989. filterLibGLJSheetData: function () {
  990. let me = this;
  991. let val = $("input[name='glj']:checked").val();
  992. if (val == 'allGljs') {
  993. me.gljLibSheetData = me.stdGLJ.concat(me.complementaryGLJs);
  994. } else {
  995. me.gljLibSheetData = me[val];
  996. }
  997. if ($('#actionType').val() == 'replace' || $('#actionType').val() == 'm_replace') {
  998. me.filterLibGLJByType();
  999. }else if($('#actionType').val() == 'addMix'){
  1000. projectGljObject.filterLibGLJForMixRatio();
  1001. }
  1002. //文本筛选
  1003. let searchStr = $('#gljSearchKeyword').val();
  1004. if(searchStr && searchStr.trim() != ''){
  1005. let reg = new RegExp(searchStr);
  1006. me.gljLibSheetData = _.filter(me.gljLibSheetData, function (data) {
  1007. return reg.test(data.code) || reg.test(data.name);
  1008. });
  1009. }
  1010. if (me.gljCurTypeId == undefined) {
  1011. return;
  1012. }
  1013. if (me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  1014. me.gljLibSheetData = _.filter(me.gljLibSheetData, function (n) {
  1015. return _.includes(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId], n.gljClass);
  1016. });
  1017. } else {
  1018. me.gljLibSheetData = _.filter(me.gljLibSheetData, {'gljClass': me.gljCurTypeId});
  1019. }
  1020. },
  1021. setGLJSelection: function (args, newVal) {
  1022. if ($('#actionType').val() == 'add' || $('#actionType').val() == 'insert'|| $('#actionType').val() == 'insertEquipment' || $('#actionType').val() == 'addMix') {
  1023. this.addGLJsSelection(args, newVal);
  1024. } else {
  1025. this.replaceGLJSelection(args, newVal);
  1026. }
  1027. },
  1028. addGLJsSelection: function (args, newVal) {
  1029. var con_key = this.getIndex(this.gljLibSheetData[args.row], gljLibKeyArray);
  1030. if (newVal == 1) {
  1031. this.GLJSelection.push(con_key);
  1032. this.gljLibSheetData[args.row].select = 1;
  1033. } else if (newVal == 0) {
  1034. _.pull(this.GLJSelection, con_key);
  1035. this.gljLibSheetData[args.row].select = 0;
  1036. }
  1037. },
  1038. replaceGLJSelection: function (args, newVal) {
  1039. var me = this;
  1040. var oldSelection = this.GLJSelection[0];
  1041. if (newVal == 0) {
  1042. args.sheet.getCell(args.row, args.col).value(1);
  1043. return;
  1044. }
  1045. this.GLJSelection = [me.getIndex(this.gljLibSheetData[args.row], gljLibKeyArray)];
  1046. this.gljLibSheetData[args.row].select = 1;
  1047. var oindex = _.findIndex(this.gljLibSheetData, function (item) {
  1048. var i_key = me.getIndex(item, gljLibKeyArray);
  1049. return oldSelection == i_key;
  1050. });
  1051. if (oindex != -1) {
  1052. args.sheet.getCell(oindex, args.col).value(0);
  1053. this.gljLibSheetData[oindex].select = 0;
  1054. } else {
  1055. var oldData = _.find(gljOprObj.AllRecode, function (item) {
  1056. var i_key = me.getIndex(item, gljLibKeyArray);
  1057. return oldSelection == i_key;
  1058. });
  1059. oldData ? oldData.select = 0 : "";
  1060. }
  1061. },
  1062. filterLibGLJByType: function () {
  1063. var me = this;
  1064. var selected = me.sheetData[gljContextMenu.selectedRow];
  1065. let materialTypes = [gljType.CONCRETE,gljType.MORTAR,gljType.MIX_RATIO,gljType.COMMERCIAL_CONCRETE,gljType.COMMERCIAL_MORTAR];//混凝土、砂浆、配合比、商品混凝土、商品砂浆
  1066. let normalTypes = [gljType.GENERAL_MATERIAL,gljType.PURCHASE_COMPONENT,gljType.GREEN_SEEDLING];//普通材料、外购砼构件、绿化苗木;
  1067. let filterTypes = [selected.type];
  1068. //当前人材机类型是“混凝土、砂浆、配合比、商品混凝土、商品砂浆”时,筛选的可替换的人材机类型应是“混凝土、或砂浆、或配合比、或商品混凝土、或商品砂浆”。
  1069. if(materialTypes.includes(selected.type)) filterTypes = materialTypes;
  1070. //当前人材机类型是普通材料、外购砼构件、绿化苗木
  1071. if(normalTypes.includes(selected.type)) filterTypes = normalTypes;
  1072. me.gljLibSheetData = _.filter(me.gljLibSheetData, function (data) {
  1073. return filterTypes.includes(data.gljType);
  1074. });
  1075. },
  1076. getComboData: function (gljDistType) {
  1077. let me = this;
  1078. let distType;
  1079. let distTypeTree = {
  1080. prefix: 'gljType',
  1081. distTypes: {},
  1082. comboDatas: [],
  1083. distTypesArr: []
  1084. };
  1085. gljDistType.forEach(function (typeData) {
  1086. let typeObj = {
  1087. data: typeData,
  1088. children: [],
  1089. parent: null
  1090. }
  1091. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  1092. distTypeTree.distTypesArr.push(typeObj);
  1093. });
  1094. gljDistType.forEach(function (typeData) {
  1095. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  1096. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  1097. if (parent) {
  1098. distType.parent = parent;
  1099. parent.children.push(distType);
  1100. }
  1101. });
  1102. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  1103. if (distTypeObj.data.fullName !== '材料' && distTypeObj.data.fullName !== '机械') {
  1104. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  1105. }
  1106. });
  1107. return distTypeTree;
  1108. },
  1109. doInsertGLJ: function (insertType) {
  1110. var me = this;
  1111. var selected = projectObj.project.mainTree.selected;
  1112. var project = projectObj.project;
  1113. if (me.GLJSelection.length <= 0) {
  1114. return;
  1115. }
  1116. $.bootstrapLoading.start();
  1117. project.ration_glj.insertGLJAsRation(me.GLJSelection, selected,insertType ,function (parentNodeID,nextNodeID,data) {
  1118. let newNode=null;
  1119. for (let r_glj of data) {
  1120. r_glj.quantity = r_glj.quantity + "";
  1121. project.Ration.datas.push(r_glj);
  1122. }//要先更新树节点工程量,加载项目工料机并计算消耗量才有值
  1123. project.projectGLJ.loadData(function () {
  1124. for(let r_glj of data){
  1125. r_glj = me.setGLJPrice(r_glj);//设置工料机价格
  1126. newNode = project.mainTree.insert(parentNodeID, nextNodeID, r_glj.ID);
  1127. newNode.source = r_glj;
  1128. newNode.sourceType = project.Ration.getSourceType();
  1129. newNode.data = r_glj;
  1130. ProjectController.syncDisplayNewNode(projectObj.mainController, newNode);
  1131. }
  1132. project.calcProgram.calcLeafAndSave(newNode.parent);//计算父级清单的所有子节点
  1133. projectObj.mainController.refreshTreeNode([newNode]);
  1134. if(me.hasComposition(newNode.data,true)){
  1135. me.showMixRatio(newNode);
  1136. }else {
  1137. me.showRationGLJSheetData();
  1138. }
  1139. $.bootstrapLoading.end();
  1140. });
  1141. })
  1142. },
  1143. doAddGLJ: function () {
  1144. var selected = projectObj.project.mainTree.selected;
  1145. var project = projectObj.project;
  1146. gljOprObj.GLJSelection = _.filter(gljOprObj.GLJSelection, function (n) {
  1147. var rg = _.find(gljOprObj.sheetData, function (item) {
  1148. if(item.isMixRatio == true){
  1149. return false;
  1150. }
  1151. var i_key = gljOprObj.getIndex(item, gljKeyArray);
  1152. return n == i_key
  1153. });
  1154. return rg ? false : true;
  1155. })
  1156. if (gljOprObj.GLJSelection.length > 0 && selected && selected.sourceType == ModuleNames.ration) {
  1157. project.ration_glj.addGLJByLib(gljOprObj.GLJSelection, selected.data, function (result) {
  1158. if (result) {
  1159. selected.data.adjustState = result.adjustState;
  1160. project.ration_glj.datas = project.ration_glj.datas.concat(result.newRecodes);//显示和缓存统一,这样的话就不用更新两个位置了
  1161. //project.ration_glj.datas = project.ration_glj.datas.concat(result.showData);
  1162. //gljOprObj.sheetData = gljOprObj.sheetData.concat(result.showData);
  1163. project.projectGLJ.loadNewProjectGLJToCaches(result.projectGLJList,true);
  1164. project.ration_glj.addToMainTree(result.showData);//组成物不会显示到造价书页面
  1165. project.calcProgram.calcAndSave(selected);
  1166. projectObj.mainController.refreshTreeNode([selected]);
  1167. gljOprObj.refreshView();
  1168. $.bootstrapLoading.end();
  1169. }
  1170. });//doc.rationID=selected.data.ID;
  1171. }
  1172. },
  1173. concreteTypeReplaceChecking:function (selectCode, oldData,selected) {//selected为空,表示批量替换 混凝土替换前的检查,是否给出确认提示
  1174. let allGLJ = gljOprObj.AllRecode;
  1175. let glj = _.find(allGLJ, function (item) {
  1176. let i_key = gljOprObj.getIndex(item, gljLibKeyArray);
  1177. return i_key == selectCode;
  1178. });
  1179. if(! glj) return false;
  1180. if(gljUtil.isConcreteToCommercialConcrete(oldData.type,glj.gljType)){//被替换的是混凝土,替换成商品砼或商品砂浆
  1181. if(selected){ //如果有选中的,说明是替换,还要判断是否有辅助定额, 批量替换不用判断
  1182. return selected.data.rationAssList && selected.data.rationAssList.length > 0 ? true:false;
  1183. }
  1184. return true;
  1185. }
  1186. return false;
  1187. },
  1188. replaceGLJConfirm:function(mreplace = false){
  1189. let me = this;
  1190. let oldData = me.sheetData[gljContextMenu.selectedRow];
  1191. let selectCode = gljOprObj.GLJSelection[0];
  1192. let selected = mreplace == true?null:projectObj.project.mainTree.selected;
  1193. if(me.concreteTypeReplaceChecking(selectCode, oldData,selected)){
  1194. hintBox.infoBox('操作确认', '请先调整厚度,再替换商品砼。确定要继续吗?', 2, function () {
  1195. mreplace == true ? $("#mreplace_next_div").modal('show'):me.doReplaceGLJ(selectCode, oldData,selected);
  1196. }, null,['确定','取消'],false)
  1197. }else {
  1198. mreplace == true ? $("#mreplace_next_div").modal('show'):me.doReplaceGLJ(selectCode, oldData,selected);
  1199. }
  1200. },
  1201. doReplaceGLJ: function (selectCode, oldData,selected) {
  1202. let me = this;
  1203. let project = projectObj.project;
  1204. project.ration_glj.replaceGLJ(selectCode, oldData, function (result) {
  1205. if (result) {
  1206. //result.adjustState;
  1207. project.ration_glj.setDatasAfterReplace(result);
  1208. let data = result.data;
  1209. let nodes = [selected];
  1210. let node = project.ration_glj.updateGLJNodeAfterReplace(data);
  1211. if(node) nodes.push(node);
  1212. /*if (project.ration_glj.needShowToTree(data)) {//当替换的是主材或设备时,刷新对应的树节点
  1213. var node = project.ration_glj.findGLJNodeByID(data.ID);
  1214. if (node) {
  1215. project.ration_glj.transferToNodeData(data);
  1216. node.source = data;
  1217. node.data = data;
  1218. }
  1219. node ? nodes.push(node) : "";
  1220. }*/
  1221. //project.ration_glj.addToMainTree(data);
  1222. selected.data.adjustState = result.adjustState;
  1223. selected.data.name = result.name;
  1224. projectObj.mainController.refreshTreeNode(nodes);
  1225. project.calcProgram.calcAndSave(selected);
  1226. gljOprObj.refreshView();
  1227. $.bootstrapLoading.end();
  1228. }
  1229. })
  1230. },
  1231. doMReplaceGLJ: function () {
  1232. let me = this;
  1233. let project = projectObj.project;
  1234. let oldData = me.sheetData[gljContextMenu.selectedRow];
  1235. let selectCode = gljOprObj.GLJSelection[0];
  1236. project.ration_glj.mReplaceGLJ(selectCode, oldData, function (result,updateMap) {
  1237. if(result == null){
  1238. return;
  1239. }
  1240. let data = result.data;
  1241. let stateList = result.stateList;
  1242. //let n_index = me.getIndex(data.query, gljKeyArray);
  1243. let nodes = [];
  1244. let quantityMap = {};
  1245. for(let gr of result.glj_result){
  1246. quantityMap[gr.query.ID] = gr.doc;
  1247. }
  1248. //添加\删除混凝土组成物定额工料机
  1249. project.ration_glj.addAndDeleteDatas(result.newRecodes,result.deleteList);
  1250. _.forEach(project.ration_glj.datas, function (t) {
  1251. // let t_index = me.getIndex(t, gljKeyArray);
  1252. if (updateMap[t.ID]) {
  1253. if(updateMap[t.ID].code) me.updateProperty(t, data.doc);//说明这条不是只更新自定义消耗量的,才要更新项目工料机
  1254. me.updateProperty(t, updateMap[t.ID]);
  1255. if (project.ration_glj.needShowToTree(t)) {//如果是造价书中的树节点,则也须刷新
  1256. project.ration_glj.transferToNodeData(t);
  1257. var node = project.ration_glj.findGLJNodeByID(t.ID);
  1258. node ? nodes.push(node):'';
  1259. }
  1260. }
  1261. if(quantityMap[t.ID]){//更新消耗量
  1262. me.updateProperty(t,quantityMap[t.ID]);
  1263. }
  1264. })
  1265. project.projectGLJ.loadNewProjectGLJToCaches([result.projectGLJ],true);
  1266. var rationNodes = me.refreshStateAfterMreplace(stateList, nodes);
  1267. project.calcProgram.calcNodesAndSave(rationNodes);
  1268. me.refreshView();
  1269. $.bootstrapLoading.end();
  1270. })
  1271. },
  1272. updateProperty: function (obj, doc) {
  1273. gljUtil.updateProperty(obj,doc);
  1274. },
  1275. refreshStateAfterMreplace: function (stateList, gljNodes) {
  1276. let nodes = [];
  1277. let rationNodes = [];
  1278. _.forEach(stateList, function (s) {
  1279. let node = _.find(projectObj.project.mainTree.items, function (n) {
  1280. return n.sourceType == ModuleNames.ration && n.data.ID == s.rationID;
  1281. })
  1282. if (node) {
  1283. node.data.adjustState = s.adjustState;
  1284. node.data.name = s.name;
  1285. nodes.push(node);
  1286. rationNodes.push(node);
  1287. }
  1288. });
  1289. gljNodes.length > 0 ? nodes = nodes.concat(gljNodes) : "";
  1290. projectObj.mainController.refreshTreeNode(nodes);
  1291. return rationNodes;
  1292. },
  1293. refreshView: function () {
  1294. let node = projectObj.project.mainTree.selected;
  1295. this.showDataIfRationSelect(node,"111111");
  1296. },
  1297. refreshTreeNode: function (obj) {
  1298. if (!obj) {
  1299. return;
  1300. }
  1301. let objectArray = [];
  1302. let nodes = [];
  1303. if (obj instanceof Array) {
  1304. objectArray.concat(obj);
  1305. } else {
  1306. objectArray.push(obj);
  1307. }
  1308. for (let o of objectArray) {
  1309. let node = this.updateDataNodeProperty(o.ID,o.data);
  1310. if (node) {
  1311. nodes.push(node);
  1312. }
  1313. }
  1314. projectObj.mainController.refreshTreeNode(nodes);
  1315. return nodes;
  1316. },
  1317. updateDataNodeProperty:function(nodeID,data){
  1318. let node = projectObj.project.mainTree.findNode(nodeID);
  1319. if (node) {
  1320. for (let k in data) {
  1321. node.data[k] = data[k];
  1322. }
  1323. }
  1324. return node;
  1325. },
  1326. getTreeNodeCellType: function (data,comboboxOptions) {
  1327. let ns = GC.Spread.Sheets;
  1328. let rectW = 10;
  1329. let rectH = 10;
  1330. let margin = 3;
  1331. function TreeNodeCellType() {
  1332. this.ctx = null;
  1333. }
  1334. TreeNodeCellType.prototype = comboboxOptions?sheetCommonObj.getDynamicCombo():new ns.CellTypes.Text();
  1335. TreeNodeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
  1336. this.ctx= ctx;
  1337. if (style.backColor) {//先画背景色
  1338. ctx.save();
  1339. ctx.fillStyle = style.backColor;
  1340. ctx.fillRect(x, y, w, h);
  1341. ctx.restore();
  1342. } else {
  1343. ctx.clearRect(x, y, w, h);
  1344. }
  1345. if (value != null) {
  1346. let offset = margin + rectW + 6;
  1347. let recode = data[options.row];
  1348. if (recode && recode.hasOwnProperty('subList')) {
  1349. sheetCommonObj.drowRect(ctx, x, y, w, h,rectW,rectH,margin);
  1350. let collapsed = recode.collapsed == undefined ? true : recode.collapsed;//options.sheet.getTag(options.row,options.col);
  1351. sheetCommonObj.drowSymbol(ctx, x, y, w, h,rectW,rectH,margin, collapsed);
  1352. } else if (recode && recode.isMixRatio) {
  1353. let hasNext = data[options.row + 1] && data[options.row + 1].isMixRatio;
  1354. offset = sheetCommonObj.drowSubItem(ctx, x, y, w, h, offset,hasNext);
  1355. offset += 1;
  1356. }
  1357. arguments[2] = x + offset;
  1358. arguments[4] = w - offset;
  1359. //x = x + offset;
  1360. //w = w - offset;
  1361. GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
  1362. }
  1363. };
  1364. TreeNodeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
  1365. if(x < cellRect.x+cellRect.width -15){//这里要判断点击的位置来决定return的内容,不能直接用combobox的方法
  1366. return {
  1367. x: x,
  1368. y: y,
  1369. row: context.row,
  1370. col: context.col,
  1371. cellStyle: cellStyle,
  1372. cellRect: cellRect,
  1373. sheetArea: context.sheetArea
  1374. };
  1375. }else {
  1376. return GC.Spread.Sheets.CellTypes.ComboBox.prototype.getHitInfo.apply(this, arguments);
  1377. }
  1378. };
  1379. TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
  1380. let recode = data[hitinfo.row];
  1381. if(hitinfo.x < hitinfo.cellRect.x+hitinfo.cellRect.width -15){
  1382. hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,"locked")//通过这个来控制除了点击下拉框的三角形,点击其它地方不充许进入编辑状态,不然不好控制下拉框超出页面后调整滚动条
  1383. }
  1384. if (recode && recode.hasOwnProperty('subList')) {
  1385. let hoffset = hitinfo.cellRect.x + 3;
  1386. if (hitinfo.x > hoffset && hitinfo.x < hoffset + 10) {
  1387. let collapsed = recode.collapsed == undefined ? true : recode.collapsed;
  1388. collapsed = !collapsed
  1389. recode.collapsed = collapsed;
  1390. //hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,collapsed);
  1391. hitinfo.sheet.getRange(hitinfo.row + 1, -1, recode.subList.length, -1).visible(!collapsed);
  1392. hitinfo.sheet.invalidateLayout();
  1393. hitinfo.sheet.repaint();
  1394. return;
  1395. }
  1396. }
  1397. if(comboboxOptions&&hitinfo.x > hitinfo.cellRect.x+hitinfo.cellRect.width -15){//点击了下拉框按钮,这里要判断下拉框是否会被挡住,从而决定是否自动调整滚动条
  1398. hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,"");
  1399. sheetCommonObj.scrollSheetForOption(hitinfo.sheet,this.ctx,hitinfo.cellRect,hitinfo.row,comboboxOptions);//下拉框超出显示后自动调整滚动条
  1400. GC.Spread.Sheets.CellTypes.ComboBox.prototype.processMouseDown.apply(this, arguments);
  1401. }
  1402. };
  1403. let cellType = new TreeNodeCellType();
  1404. if(comboboxOptions){
  1405. cellType.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
  1406. cellType.itemHeight(comboboxOptions.length).items(comboboxOptions);
  1407. }
  1408. return cellType;
  1409. },
  1410. marketPriceReadOnly: function (node) {
  1411. let isRationType = node.sourceType==ModuleNames.ration&&node.data.type==rationType.gljRation;
  1412. let type = isRationType==true? node.data.subType:node.data.type;
  1413. if(gljUtil.isConcreteType(type)) return true;
  1414. return this.hasComposition(node.data,isRationType); //2018-9-14 需求变更暂估工料机也能修改市场价原语句:return hasCom|| node.data.isEstimate == 1
  1415. },
  1416. locateZTree: function(ID) {
  1417. let zTree = $.fn.zTree.getZTreeObj("gljTree");
  1418. let node = null;
  1419. if (ID) node = zTree.getNodesByParam('ID', ID, null)[0];
  1420. if (!node) node = zTree.getNodeByTId('gljTree_1');
  1421. zTree.selectNode(node);
  1422. gljOprObj.gljCurTypeId = ID;
  1423. gljOprObj.filterLibGLJSheetData();
  1424. gljOprObj.showLibGLJSheetData();
  1425. },
  1426. isExtraType:function (type) {
  1427. return _.includes(gljUtil.extraType,type)
  1428. },
  1429. setNodeShowTab:function () {
  1430. let node = projectObj.project.mainTree.selected;
  1431. if(node && node.sourceType==ModuleNames.ration){
  1432. gljOprObj.rationTab = gljOprObj.activeTab;
  1433. }else {
  1434. gljOprObj.billsTab = gljOprObj.activeTab;
  1435. }
  1436. },
  1437. //初始化分类树
  1438. //@param {String}type(标准或补充) {Array}treeData(树数据)
  1439. initClassTree: function (type, treeData, initSel = false) {
  1440. let me = this;
  1441. if (me.treeObj) {
  1442. me.treeObj.destroy();
  1443. me.parentNodeIds = {};
  1444. }
  1445. zTreeHelper.createTree(treeData, me.gljTreeSetting, "gljTree", me);
  1446. if (initSel) {
  1447. let rootNode = me.treeObj.getNodes()[0];
  1448. if(rootNode && rootNode.isParent && rootNode.isFirstNode){
  1449. me.rootNode = rootNode;
  1450. }
  1451. if(me.rootNode){
  1452. me.treeObj.selectNode(me.rootNode);
  1453. me.gljTreeSetting.callback.onClick(null, 'gljTree', me.rootNode);
  1454. }
  1455. }
  1456. },
  1457. initScopeSpread:function() {
  1458. if (this.scopeSpread) return this.scopeSpread.repaint();
  1459. this.scopeSpread = SheetDataHelper.createNewSpread($('#scopeSpread')[0]);
  1460. sheetCommonObj.spreadDefaultStyle(this.scopeSpread);
  1461. this.scopeTree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: false});
  1462. this.scopeTreeController = TREE_SHEET_CONTROLLER.createNew(this.scopeTree, this.scopeSpread.getActiveSheet(), this.scopeSetting);
  1463. this.scopeSheet = this.scopeSpread.getActiveSheet();
  1464. this.scopeSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, this.onScopeChecked);
  1465. },
  1466. showScopeDatas:function () {
  1467. this.initScopeSpread();
  1468. this.scopeDatas =this.getScopeDatas();
  1469. this.scopeTree.loadDatas(this.scopeDatas);
  1470. this.scopeTreeController.showTreeData();
  1471. },
  1472. getScopeDatas:function () {
  1473. let controller = projectObj.mainController, project = projectObj.project;
  1474. let allNodes = [],datas = []
  1475. for(let rootNode of controller.tree.roots){
  1476. allNodes.push(rootNode);
  1477. controller.tree.getAllSubNode(rootNode.source,allNodes);
  1478. }
  1479. for(let n of allNodes){
  1480. let temData = {
  1481. ID:n.data.ID,
  1482. NextSiblingID:n.data.NextSiblingID,
  1483. ParentID:n.data.ParentID,
  1484. unit : n.data.unit,
  1485. code : n.data.code,
  1486. selected:0,
  1487. name : n.data.name,
  1488. quantity:calcTools.uiNodeQty(n)?calcTools.uiNodeQty(n):"",
  1489. };
  1490. if(n.data.feesIndex && n.data.feesIndex.common){
  1491. temData.unitPrice = n.data.feesIndex.common.unitFee;
  1492. temData.totalPrice = n.data.feesIndex.common.totalFee;
  1493. }
  1494. datas.push(temData);
  1495. }
  1496. return datas;
  1497. },
  1498. onScopeChecked:function (e,args) {
  1499. let me = gljOprObj,nodes = [];
  1500. var checkboxValue = args.sheet.getCell(args.row, args.col).value();
  1501. var newval = checkboxValue?0:1;
  1502. let node = me.scopeTree.items[args.row];
  1503. setNodeAndChildreSelected(node,newval,nodes);
  1504. me.scopeTreeController.refreshTreeNode(nodes);
  1505. function setNodeAndChildreSelected(n,val,arr){
  1506. n.data.selected = val;
  1507. nodes.push(n);
  1508. for(let c of n.children){
  1509. setNodeAndChildreSelected(c,val,arr)
  1510. }
  1511. }
  1512. },
  1513. setScopeSelection:function () {
  1514. for(let node of this.scopeTree.items){
  1515. //挑出选中数,过滤父节点
  1516. if(node.data.selected == 1 && node.children.length == 0) this.scopeSelectedIDMap[node.data.ID] = true
  1517. }
  1518. }
  1519. };
  1520. $(function () {
  1521. $('#glj_tree_div').on('shown.bs.modal', function (e) {
  1522. if (gljOprObj.gljLibSpresd == undefined) {
  1523. gljOprObj.gljLibSpresd = sheetCommonObj.buildSheet($('#gljLibSheet')[0], gljOprObj.gljLibSheetSetting, gljOprObj.stdGLJ.length + gljOprObj.complementaryGLJs.length);
  1524. sheetCommonObj.spreadDefaultStyle(gljOprObj.gljLibSpresd);
  1525. gljOprObj.gljLibSpresd.bind(GC.Spread.Sheets.Events.ButtonClicked, gljOprObj.onButtonClick);
  1526. gljOprObj.gljLibSheet = gljOprObj.gljLibSpresd.getSheet(0);
  1527. gljOprObj.gljLibSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, gljOprObj.onSelectionChanged);
  1528. gljOprObj.gljLibSheet.setColumnWidth(0, 20, GC.Spread.Sheets.SheetArea.rowHeader);
  1529. gljOprObj.gljLibSheet.options.isProtected = true;
  1530. gljOprObj.gljLibSheet.name('glj_lib');
  1531. }
  1532. gljOprObj.gljLibSheetData = gljOprObj.AllRecode;
  1533. let gljClass = 0, selectMap = {};
  1534. if ($('#actionType').val() == 'add' || $('#actionType').val() == 'insert' || $('#actionType').val() == 'insertEquipment') {//插入,添加
  1535. gljOprObj.GLJSelection = [];
  1536. } else if($('#actionType').val() =='m_replace' || $('#actionType').val() == 'replace'){//替换、批量替换
  1537. let selected = gljOprObj.sheetData[gljContextMenu.selectedRow];
  1538. let connect_key = gljOprObj.getIndex(selected, gljKeyArray);
  1539. gljOprObj.GLJSelection = [connect_key];
  1540. selectMap[connect_key] = true;
  1541. gljOprObj.filterLibGLJByType();
  1542. }else if($('#actionType').val() =='addMix'){//添加组成物
  1543. gljOprObj.GLJSelection = [];
  1544. projectGljObject.filterLibGLJForMixRatio();
  1545. /*selections = projectGljObject.mixRatioData; 添加组成物的时候先不选中
  1546. gljOprObj.GLJSelection = [];
  1547. for(let s of selections){
  1548. let s_key = gljOprObj.getIndex(s, gljKeyArray);
  1549. selectMap[s_key] = true;
  1550. gljOprObj.GLJSelection.push(s_key);
  1551. }*/
  1552. }
  1553. for(let item of gljOprObj.gljLibSheetData){
  1554. let item_key = gljOprObj.getIndex(item, gljLibKeyArray);
  1555. if(selectMap[item_key]){
  1556. item.select = 1 ;
  1557. gljClass = item.gljClass;
  1558. }
  1559. }
  1560. //替换,焦点定位至当前选中人材机
  1561. if($('#actionType').val() =='m_replace' || $('#actionType').val() == 'replace'){
  1562. gljOprObj.locateZTree(gljClass);
  1563. let selected = gljOprObj.sheetData[gljContextMenu.selectedRow];
  1564. let index = _.findIndex(gljOprObj.gljLibSheetData, {code: selected.code});
  1565. gljOprObj.gljLibSheet.showRow(index, GC.Spread.Sheets.VerticalPosition.center);
  1566. gljOprObj.gljLibSheet.setActiveCell(index, 0);
  1567. gljOprObj.initSelection({row: index});
  1568. gljOprObj.gljLibSpresd.focus(true);
  1569. } else if ($('#actionType').val() === 'insertEquipment') {//右键插入设备,人材机选择窗口,应默认固定到分类"养护管理设备"。
  1570. let locateClass = gljOprObj.treeData.std.find(function (stdClass) {
  1571. return stdClass.Name === '养护管理设备';
  1572. });
  1573. if (locateClass) {
  1574. gljClass = locateClass.ID;
  1575. gljOprObj.locateZTree(gljClass);
  1576. gljOprObj.gljLibSheet.showRow(0, GC.Spread.Sheets.VerticalPosition.top);
  1577. gljOprObj.gljLibSheet.setActiveCell(0, 0);
  1578. gljOprObj.initSelection({row: 0});
  1579. }
  1580. } else if ($('#actionType').val() === 'add') {
  1581. gljOprObj.locateZTree(null);
  1582. gljOprObj.gljLibSheet.showRow(0, GC.Spread.Sheets.VerticalPosition.top);
  1583. gljOprObj.gljLibSheet.setActiveCell(0, 0);
  1584. gljOprObj.initSelection({row: 0});
  1585. } else {
  1586. gljOprObj.showLibGLJSheetData();
  1587. }
  1588. });
  1589. $('#mreplace_next_div').on('shown.bs.modal', function (e) {
  1590. gljOprObj.scopeSelectedIDMap = {};
  1591. gljOprObj.showScopeDatas();
  1592. });
  1593. $('#glj_tree_div').on('hidden.bs.modal', function () {
  1594. $('#gljSearchKeyword').val('');
  1595. });
  1596. $('.glj-radio').change(function () {
  1597. let val = $("input[name='glj']:checked").val();
  1598. if (val == 'allGljs') {
  1599. gljOprObj.gljLibSheetData = gljOprObj.AllRecode;
  1600. gljOprObj.filterLibGLJSheetData();
  1601. gljOprObj.showLibGLJSheetData();
  1602. } else {
  1603. if(val === 'stdGLJ') {
  1604. gljOprObj.initClassTree('std', gljOprObj.treeData.std, true);
  1605. } else {
  1606. gljOprObj.initClassTree('comple', gljOprObj.treeData.comple, true);
  1607. }
  1608. gljOprObj.initSelection({row: 0});
  1609. //gljOprObj.gljLibSheetData = gljOprObj[val];
  1610. /*gljOprObj.filterLibGLJSheetData();
  1611. gljOprObj.showLibGLJSheetData();*/
  1612. }
  1613. });
  1614. /* //工料机搜索
  1615. $('#gljSearchKeyword').change(function () {
  1616. gljOprObj.filterLibGLJSheetData();
  1617. gljOprObj.showLibGLJSheetData();
  1618. });
  1619. $('#gljSearchKeyword').bind('keypress', function (e) {
  1620. if(e.keyCode === 13){
  1621. alert('2');
  1622. $(this).blur();
  1623. return false;
  1624. }
  1625. });*/
  1626. $('#gljSearchKeyword').bind('keyup', function (e) {
  1627. gljOprObj.filterLibGLJSheetData();
  1628. gljOprObj.showLibGLJSheetData();
  1629. gljOprObj.initSelection({row: 0});
  1630. });
  1631. $('#glj_selected_conf').click(function () {
  1632. if (gljOprObj.GLJSelection.length < 1) {
  1633. return;
  1634. }
  1635. if (['insert', 'insertEquipment'].includes($('#actionType').val())) { //造价书页面中插入定额类型的工料机
  1636. gljOprObj.doInsertGLJ($('#actionType').val());
  1637. } else if ($('#actionType').val() == 'add') { //添加工料机
  1638. gljOprObj.doAddGLJ();
  1639. } else if ($('#actionType').val() == 'replace') {//替换工料机
  1640. gljOprObj.replaceGLJConfirm(false);
  1641. } else if ($('#actionType').val() == 'm_replace') {//批量替换工料机
  1642. gljOprObj.replaceGLJConfirm(true);
  1643. }else if($('#actionType').val() == 'addMix'){
  1644. projectGljObject.addMixRatio();
  1645. }
  1646. $("#glj_tree_div").modal('hide');
  1647. });
  1648. $('#scope_position_confirm').click(function () {
  1649. gljOprObj.setScopeSelection();
  1650. gljOprObj.doMReplaceGLJ();
  1651. });
  1652. $('#replace_next_btn').click(function () {
  1653. $("#glj_tree_div").modal('hide');
  1654. gljOprObj.replaceGLJConfirm(true);
  1655. });
  1656. $('#class_selected_conf').click(function () {
  1657. var gljClass = $('#selected_class').val();
  1658. var glj = gljOprObj.selectedGLJClass;
  1659. if (glj && gljClass && gljClass != "") {
  1660. //保存到我的工料机库
  1661. /*1 检查是否有组成物
  1662. * 2 如果有,则检查组成物中是否有新增的记录,如果有,查看是否已经保存了,没有的话,要先添加组成物到补充工料机库
  1663. * 3 保存
  1664. * */
  1665. var newItem = {
  1666. code: glj.code,
  1667. name: glj.name,
  1668. specs: glj.specs,
  1669. unit: glj.unit,
  1670. basePrice: glj.basePrice,
  1671. gljType: glj.type,
  1672. shortName: glj.shortName,
  1673. component: [],
  1674. gljClass: gljClass
  1675. };
  1676. if (glj.hasOwnProperty("subList") && glj.subList.length > 0) {//有组成物,检查组成物信息,目前组成物不允许修改,所以暂时不用考虑组成物是新增的情况
  1677. for (var i = 0; i < glj.subList.length; i++) {
  1678. let tem = {
  1679. ID: glj.subList[i].GLJID,
  1680. consumeAmt: glj.rationItemQuantity,
  1681. isStd: true
  1682. }
  1683. newItem.component.push(tem);
  1684. }
  1685. }
  1686. var data = getcmpUpdateData([newItem]);
  1687. $.bootstrapLoading.start();
  1688. var callback = function (data) {
  1689. $("#glj_class_div").modal('hide');
  1690. $.bootstrapLoading.end();
  1691. }
  1692. CommonAjax.post("complementartGlj/api/mixUpdateGljItems", data, callback, function () {
  1693. $.bootstrapLoading.end();
  1694. });
  1695. }
  1696. })
  1697. $('#glj_class_div').on('hidden.bs.modal', function (e) {
  1698. gljOprObj.selectedGLJClass = null;
  1699. $('#class_selected_conf').attr("disabled", "disabled");
  1700. $('#selected_class').val("");
  1701. })
  1702. $("#subSpread").focusout(function(e){//当本身或子元素失去焦点时这个事件都会发生,而且不好判断点击的是哪里。
  1703. if(gljOprObj.rationGljEditObj){
  1704. gljOprObj.cancelUpdate = false;
  1705. gljOprObj.timeStamp = e.timeStamp;//设置时间戳,有可能用户在表格上乱点,这个事件被触发多次
  1706. setTimeout(function () {//延时执行提交操作,如果点击的是spread里的地方,会把cancelUpdate改成true,这样的话就不执行提交操作
  1707. if(gljOprObj.timeStamp == e.timeStamp && gljOprObj.cancelUpdate !== true){//时间戳要相同
  1708. gljOprObj.updateGljFromCache();
  1709. }
  1710. },200)
  1711. }
  1712. });
  1713. function getcmpUpdateData(items) {
  1714. var data = {
  1715. "updateItems": [],
  1716. "removeIds": []
  1717. }
  1718. data.addItems = items;
  1719. return data;
  1720. }
  1721. })
  1722. function operationWithRound(value1,value2,field,symble) {
  1723. let decimal = getDecimal(field);
  1724. value1 = scMathUtil.roundForObj(value1,decimal);
  1725. value2 = scMathUtil.roundForObj(value2,decimal);
  1726. let result;
  1727. switch (symble){
  1728. case "+" :
  1729. result=scMathUtil.roundForObj(value1 + value2,decimal);
  1730. break;
  1731. case "-":
  1732. result=scMathUtil.roundForObj(value1 - value2,decimal);
  1733. break;
  1734. case "*":
  1735. result=scMathUtil.roundForObj(value1 * value2,decimal);
  1736. break;
  1737. case "/":
  1738. result=scMathUtil.roundForObj(value1 / value2,decimal);
  1739. break
  1740. }
  1741. return result;
  1742. }
  1743. function getDecimal(fieldID, node) {
  1744. if (node) {
  1745. return decimalObj.decimal(fieldID, node);
  1746. } else if (fieldID.indexOf(".") != -1) {
  1747. var keyArray = fieldID.split(".");
  1748. return decimalObj[keyArray[0]][keyArray[1]];
  1749. } else {
  1750. return decimalObj.decimal(fieldID);
  1751. }
  1752. }
  1753. function compareRationGLJ(a, b) {
  1754. if ((a.type + "") < (b.type + "")) {
  1755. return true
  1756. }
  1757. if ((a.type + "") == (b.type + "")) {
  1758. if (a.code < b.code) {
  1759. return true
  1760. }
  1761. }
  1762. return false;
  1763. }