| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299 |
- /**
- * Created by CSL on 2017-05-12.
- */
- var gljOprObj = {
- sheet: null,
- libID: null,
- ration: null,
- sheetData: [],
- checkb: null,
- rationGljEditObj: null, //编辑定额工料机还没提交的缓存数据
- cancelUpdate: true,
- mainTreeSelectedChange: false,
- detailSheet: null,
- detailData: [],
- GLJSelection: [],
- selectedGLJClass: null,
- parentNodeIds: {},
- preActiveTab: "", //提升焦点变换性能 2019年4月15日
- activeTab: "#linkGLJ",
- rationTab: "#linkGLJ",
- billsTab: "#linkGCLMX",
- setting: {},
- detailSetting: {
- header: [
- {
- headerName: "名称",
- headerWidth: 100,
- dataCode: "name",
- dataType: "String",
- },
- {
- headerName: "计算式",
- headerWidth: 120,
- dataCode: "regex",
- dataType: "String",
- },
- {
- headerName: "结果(C)",
- headerWidth: 120,
- dataCode: "result",
- dataType: "Number",
- decimalField: "quantity_detail",
- },
- {
- headerName: "累加",
- headerWidth: 120,
- dataCode: "isSummation",
- dataType: "String",
- cellType: "checkBox",
- },
- {
- headerName: "图号及备注",
- headerWidth: 120,
- dataCode: "memo",
- dataType: "String",
- },
- ],
- view: {
- lockColumns: [2, 3],
- rowHeaderWidth: 25,
- },
- },
- gljTreeSetting: {
- view: {
- expandSpeed: "",
- selectedMulti: false,
- },
- edit: {
- enable: false,
- editNameSelectAll: true,
- showRemoveBtn: true,
- showRenameBtn: true,
- removeTitle: "删除节点",
- renameTitle: "更改名称",
- },
- data: {
- keep: {
- parent: true,
- leaf: true,
- },
- key: {
- children: "items",
- name: "Name",
- },
- simpleData: {
- enable: false,
- idKey: "ID",
- pIdKey: "ParentID",
- rootPId: -1,
- },
- },
- callback: {
- onClick: function (event, treeId, treeNode) {
- if (treeId == "gljTree") {
- let me = gljOprObj,
- gljTypeId = treeNode.ID;
- if (treeNode.ID) {
- me.gljCurTypeId = treeNode.ID;
- me.filterLibGLJSheetData();
- me.showLibGLJSheetData();
- gljOprObj.initSelection({
- row: me.gljLibSheet.getActiveRowIndex(),
- });
- }
- } else {
- if (treeNode.isParent) {
- $("#class_selected_conf").attr("disabled", "disabled");
- $("#selected_class").val("");
- } else {
- $("#class_selected_conf").removeAttr("disabled");
- $("#selected_class").val(treeNode.ID);
- }
- }
- },
- },
- },
- gljLibSheetSetting: {
- owner: "gljTree",
- header: [
- {
- headerName: "选择",
- headerWidth: 40,
- dataCode: "select",
- hAlign: "center",
- vAlign: "center",
- cellType: "checkBox",
- },
- {
- headerName: "编码",
- headerWidth: 80,
- dataCode: "code",
- dataType: "String",
- formatter: "@",
- hAlign: "left",
- vAlign: "center",
- },
- {
- headerName: "名称",
- headerWidth: 160,
- dataCode: "name",
- dataType: "String",
- hAlign: "left",
- vAlign: "center",
- },
- {
- headerName: "规格型号",
- headerWidth: 160,
- dataCode: "specs",
- dataType: "String",
- hAlign: "left",
- vAlign: "center",
- },
- {
- headerName: "单位",
- headerWidth: 40,
- dataCode: "unit",
- dataType: "String",
- hAlign: "center",
- vAlign: "center",
- },
- {
- headerName: "单价",
- headerWidth: 55,
- dataCode: "basePrice",
- dataType: "Number",
- formatter: "0.00",
- hAlign: "right",
- vAlign: "center",
- },
- {
- headerName: "类型",
- headerWidth: 60,
- dataCode: "gljType",
- dataType: "String",
- hAlign: "center",
- vAlign: "center",
- },
- {
- headerName: "新增",
- headerWidth: 40,
- dataCode: "isComplementary",
- dataType: "String",
- hAlign: "center",
- vAlign: "center",
- cellType: "checkBox",
- },
- ],
- view: {
- lockColumns: [0, 1, 2, 3, 4, 5, 6],
- },
- },
- gljLibSheet: null,
- scopeSetting: {},
- scopeSpread: null,
- scopeSheet: null,
- scopeDatas: [],
- scopeSelectedIDMap: {},
- initSheet: function (sheet, name = "ration_glj") {
- var me = this;
- me.sheet = sheet;
- sheetCommonObj.initSheet(me.sheet, me.setting, 30);
- sheet.name(name);
- me.bindSheetEvent(sheet);
- sheet.bind(GC.Spread.Sheets.Events.CellDoubleClick, me.onCellDoubleClick);
- sheet.bind(GC.Spread.Sheets.Events.ClipboardChanged, me.onClipboardChanged);
- subSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, me.onButtonClick);
- if (!projectReadOnly) {
- gljContextMenu.loadGLJSpreadContextMenu();
- me.bindGLJEnterKey(subSpread, sheet);
- }
- sheet.bind(
- GC.Spread.Sheets.Events.SelectionChanged,
- me.onRationGLJSelectionChange
- );
- sheet.bind(GC.Spread.Sheets.Events.CellClick, function () {
- //这里主要记录是否点击了sheet以外的地方,如果点击了sheet里的单元格,则将cancelUpdate设置为true不触发提交更新操作
- me.cancelUpdate = true; //取消延时任务由selection change 事件处理
- });
- },
- onRationGLJSelectionChange: function (sender, args) {
- let me = gljOprObj;
- let selected = args.newSelections[0]
- ? args.newSelections[0]
- : { row: 0, col: 0 };
- //这主要记录是否点击了sheet以外的地方,如果点击了sheet里的单元格,则将cancelUpdate设置为true不触发提交更新操作
- me.cancelUpdate = true; //取消延时任务由这里进行判断处理
- me.sheetInitSelection(selected);
- if (me.rationGljEditObj) {
- if (ifNeedUpdate(selected)) {
- me.updateGljFromCache();
- }
- }
- function ifNeedUpdate(selected) {
- let navigationRightCol = me.setting.navigationRightCol,
- fieldID = me.setting.header[selected.col].dataCode;
- if (
- me.rationGljEditObj.row == selected.row &&
- navigationRightCol.indexOf(fieldID) != -1
- ) {
- //如果换行或者超出了三个编辑列,则提交更新
- return false;
- }
- return true;
- }
- },
- updateGljFromCache: function () {
- let me = this;
- if (me.rationGljEditObj) {
- projectObj.project.ration_glj.submitChange(
- me.rationGljEditObj.recode,
- me.rationGljEditObj.doc
- );
- }
- me.rationGljEditObj = null;
- },
- bindGLJEnterKey: function (spread, sheet) {
- let me = this;
- subSpread.commandManager().register("myEnter", enterKeyAction);
- subSpread
- .commandManager()
- .setShortcutKey(
- null,
- GC.Spread.Commands.Key.enter,
- false,
- false,
- false,
- false
- );
- subSpread
- .commandManager()
- .setShortcutKey(
- "myEnter",
- GC.Spread.Commands.Key.enter,
- false,
- false,
- false,
- false
- );
- function enterKeyAction(spd, sheeName) {
- let editRow = sheet.getActiveRowIndex(),
- orgCol = sheet.getActiveColumnIndex();
- let fieldID = me.setting.header[orgCol].dataCode;
- if (
- sheeName == "ration_glj" &&
- me.setting.navigationRightCol.indexOf(fieldID) != -1
- ) {
- if (sheet.isEditing()) sheet.endEdit();
- GC.Spread.Sheets.Commands.navigationRight.execute(spd, sheeName);
- } else {
- GC.Spread.Sheets.Commands.commitInputNavigationDown.execute(
- spd,
- sheeName
- );
- }
- }
- },
- sheetInitSelection: function (selected) {
- let me = gljOprObj;
- let style = {};
- if (selected.row < me.sheetData.length) {
- if (me.setting.getStyle)
- style = me.setting.getStyle(me.sheetData[selected.row]);
- me.sheet.setStyle(selected.row, -1, me.getSelStyle(true, style));
- }
- me.sheet.repaint();
- if (me.preGljSelection && me.preGljSelection.row !== selected.row) {
- if (me.setting.getStyle && me.preGljSelection.row < me.sheetData.length)
- style = me.setting.getStyle(me.sheetData[me.preGljSelection.row]);
- me.sheet.setStyle(
- me.preGljSelection.row,
- -1,
- me.getSelStyle(false, style)
- );
- }
- me.preGljSelection = selected;
- },
- initDetailSheet: function (sheet) {
- var me = this;
- me.detailSheet = sheet;
- sheetCommonObj.initSheet(me.detailSheet, me.detailSetting, 30);
- // me.detailSheet.selectionUnit(0);//0 cell,1 row,2 col;
- sheet.name("quantity_detail");
- me.bindSheetEvent(sheet);
- },
- detailSheetReadonly: function () {
- let selected = projectObj.project.mainTree.selected;
- let Bills = projectObj.project.Bills;
- if (selected) {
- //清单锁定时只读
- if (
- selected.sourceType == ModuleNames.bills &&
- projectObj.project.isBillsLocked() &&
- projectObj.project.withinBillsLocked(selected)
- ) {
- return true;
- }
- //大项费用、分部节点层次时,工程量明细只读。
- if (
- indicativeInfoObj.isDXFY(selected) ||
- indicativeInfoObj.isFB(selected)
- ) {
- return true;
- }
- //是主材或者是设备时只读
- if (selected.sourceType == ModuleNames.ration_glj) {
- return true;
- } else if (gljOprObj.isInstallationNode(selected)) {
- //是补项或者是安装类型的定额时只读
- return true;
- }
- return false;
- }
- return true;
- },
- bindSheetEvent: function (sheet) {
- var me = this;
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
- sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded);
- sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
- sheet.bind(GC.Spread.Sheets.Events.EditStarting, me.startEditChecking);
- // sheet.bind(GC.Spread.Sheets.Events.CellClick, me.onCellClick);
- },
- onClipboardPasting: function (sender, args) {
- var me = gljOprObj;
- if (
- args.sheetName != "quantity_detail" &&
- (args.cellRange.rowCount != 1 || args.cellRange.colCount != 1)
- ) {
- //工程量明细做特殊处理
- args.cancel = true;
- }
- },
- onClipboardPasted: function (e, info) {
- var me = gljOprObj;
- console.log("past");
- // if (!me.ration) {return;};
- // your code...
- },
- startEditChecking: function (sender, args) {
- let me = gljOprObj;
- let selected = projectObj.project.mainTree.selected;
- if ($.bootstrapLoading.isLoading()) args.cancel = true;
- if (selected) {
- if (me.isInstallationNode(selected) == true) {
- args.cancel = true;
- } else {
- if (args.sheetName == "quantity_detail") {
- //工程量明细表
- if (me.detailSheetReadonly()) {
- args.cancel = true;
- } else {
- if (args.sheet.getValue(args.row, args.col) == null) {
- //这里是为了解决当单元格里的值是null的时候,在单元格里输入数据,按键盘箭头移动光标的时候,会直接结束编辑,跳到另外的单元格。
- args.sheet.setValue(args.row, args.col, "");
- }
- }
- }
- if (args.sheetName == "ration_glj") {
- //定额工料机表
- if (!me.rationGLJEditCheck(args)) args.cancel = true;
- }
- }
- } else {
- args.cancel = true;
- }
- },
- isInstallationNode: function (node) {
- if (
- node.sourceType == ModuleNames.ration &&
- node.data.type == rationType.install
- ) {
- //是定额安装费类型时只读,原先是补项的时候也是控制只读的||(node.sourceType == ModuleNames.bills&&node.data.type==billType.BX)){//是定额安装费类型或者补项
- return true;
- }
- return false;
- },
- onEditEnded: function (sender, args) {
- var me = gljOprObj;
- if (args.sheetName == "ration_glj") {
- me.onEditGLJSheet(args);
- }
- if (args.sheetName == "quantity_detail") {
- me.onEditDetailSheet(args);
- }
- },
- onEditDetailSheet: function (args, callback) {
- var me = gljOprObj;
- if (args.row > me.detailData.length) {
- return;
- }
- if (args.row == me.detailData.length && args.editingText == null) {
- return;
- }
- var selected = projectObj.project.mainTree.selected; //因为使用了延时方法,所以要先取得选中行;
- var detailList = me.detailData;
- if (args.editingText) {
- args.editingText = args.editingText.replace(/(/g, "("); //替换中文左右括号;
- args.editingText = args.editingText.replace(/)/g, ")");
- }
- if (args.row == detailList.length) {
- projectObj.project.quantity_detail.saveQuantityDetail(
- args,
- me.detailSetting.header[args.col].dataCode,
- selected,
- callback
- );
- }
- if (args.row < detailList.length) {
- projectObj.project.quantity_detail.updateQuantityDetail(
- args,
- me.detailSetting.header[args.col].dataCode,
- detailList[args.row],
- selected,
- callback
- );
- }
- },
- onEditGLJSheet: function (args) {
- var me = gljOprObj;
- if (args.row >= me.sheetData.length) {
- me.sheet.getCell(args.row, args.col).value(null);
- return;
- }
- me.updateRationGLJ(args);
- },
- onSelectionChanged: function (sender, args) {
- let me = gljOprObj;
- me.initSelection(
- args.newSelections.length > 0
- ? { row: args.newSelections[0].row }
- : { row: 0 }
- );
- },
- getSelStyle: function (selected, settingStyle, rcolor) {
- let style = new GC.Spread.Sheets.Style();
- if (settingStyle) {
- for (let key in settingStyle) {
- style[key] = settingStyle[key];
- }
- }
- style.borderLeft = new GC.Spread.Sheets.LineBorder(
- "#D4D4D4",
- GC.Spread.Sheets.LineStyle.thin
- );
- style.borderTop = new GC.Spread.Sheets.LineBorder(
- "#D4D4D4",
- GC.Spread.Sheets.LineStyle.thin
- );
- style.borderRight = new GC.Spread.Sheets.LineBorder(
- "#D4D4D4",
- GC.Spread.Sheets.LineStyle.thin
- );
- style.borderBottom = new GC.Spread.Sheets.LineBorder(
- "#D4D4D4",
- GC.Spread.Sheets.LineStyle.thin
- );
- let colorOpts = optionsOprObj.getOption(
- optionsOprObj.optionsTypes.COLOROPTS
- );
- if (!colorOpts) colorOpts = { SELECTED: { backColor: "#FFFACD" } };
- let selectedColor = colorOpts.SELECTED.backColor,
- recColor = rcolor ? rcolor : "White";
- style.backColor = selected ? selectedColor : recColor;
- return style;
- },
- initSelection: function (sel) {
- let me = gljOprObj;
- if (sel) {
- sel.row = !sel.row || sel.row == -1 ? 0 : sel.row;
- me.gljLibSheet.setStyle(sel.row, -1, me.getSelStyle(true));
- }
- if (me.preGljLibSelection && me.preGljLibSelection.row !== sel.row) {
- me.gljLibSheet.setStyle(
- me.preGljLibSelection.row,
- -1,
- me.getSelStyle(false)
- );
- }
- me.preGljLibSelection = sel;
- },
- onButtonClick: function (sender, args) {
- if (args.sheet.isEditing()) {
- args.sheet.endEdit();
- }
- var me = gljOprObj;
- var sheet = args.sheet,
- row = args.row,
- col = args.col;
- var cellType = sheet.getCellType(row, col);
- if (cellType instanceof GC.Spread.Sheets.CellTypes.Button) {
- if (args.sheetName == "rationInstallSheet") {
- installationFeeObj.onPositionButtonClick(sender, args);
- }
- } else {
- me.onCheckBoxClick(sender, args);
- }
- },
- onCheckBoxClick: function (sender, args) {
- if (typeof projectObj != "undefined") {
- let selected = projectObj.project.mainTree.selected;
- if (selected.sourceType == ModuleNames.ration_glj) {
- //选中的是工料机时不可编辑
- return;
- }
- if (gljOprObj.isInstallationNode(selected) == true) {
- return;
- }
- }
- let checkboxValue = args.sheet.getCell(args.row, args.col).value();
- if (args.sheetName == "rationInstallSheet" && checkboxValue) {
- return;
- }
- let newval = checkboxValue ? 0 : 1;
- args.sheet.getCell(args.row, args.col).value(newval);
- if (args.sheetName == "ration_glj") {
- gljOprObj.updateIsEstimate(args, newval);
- } else if (args.sheetName == "quantity_detail") {
- projectObj.project.quantity_detail.isSummationUpdate(
- args,
- gljOprObj.detailData,
- newval
- );
- } else if (args.sheetName == "glj_lib") {
- if (gljOprObj.gljLibSheetSetting.header[args.col].dataCode === "select") {
- gljOprObj.setGLJSelection(args, newval);
- }
- } else if (args.sheetName == "rationInstallSheet") {
- args.newValue = newval;
- installationFeeObj.onRationInstallValueChange(sender, args);
- }
- },
- onCellDoubleClick: function (sender, args) {
- // 含组成物的材料市场价改为只读,改为双击无反应不提示
- /* var me = gljOprObj;
- var header = me.setting.header;
- if (args.row >= me.sheetData.length) {
- return;
- }
- if (header[args.col] && header[args.col].dataCode == 'marketPrice') {
- if(me.hasComposition(me.sheetData[args.row])){
- alert("当前工料机的市场价由组成物计算得出,不可直接修改。");
- }
- }
- if (header[args.col] && header[args.col].dataCode == 'basePrice') {
- var isAdd = me.sheetData[args.row].isAdd;
- if(isAdd==1){//是新增但没有组成物时允许修改定额价
- if(me.hasComposition(me.sheetData[args.row])){//如果有组成物,不可修改
- alert("当前工料机的定额价由组成物计算得出,不可直接修改。");
- }
- }
- }*/
- },
- onClipboardChanged: function (sender, info) {
- let cDatas = sheetCommonObj.getTableData(info.sheet, null);
- sheetCommonObj.copyTextToClipboard(cDatas);
- return;
- },
- rationGLJEditCheck: function (args) {
- //true 可以编辑,false 不能编辑
- let me = gljOprObj,
- header = me.setting.header;
- let dataCode =
- header[args.col] && header[args.col].dataCode
- ? header[args.col].dataCode
- : null,
- recode = me.sheetData[args.row];
- if (me.sheet.getTag(args.row, args.col) == "locked") return false; //如果是双击树节点编号里设置了锁定标记,不能编辑
- if (_.includes(me.setting.view.lockColumns, args.col)) return false; //如果是锁定的列,不能编辑
- if (recode != undefined) {
- if (recode.isMixRatio) {
- //对于组成物列
- return dataCode == "marketPrice"; //允许修改组成物市单价,其它的不可以
- } else {
- if (dataCode && dataCode == "marketPrice") {
- return !me.marketPriceReadOnly({ data: me.sheetData[args.row] });
- }
- if (dataCode && dataCode == "basePrice") {
- var isAdd = recode.isAdd;
- if (isAdd == 1) {
- //是新增但没有组成物时允许修改定额价
- return !me.marketPriceReadOnly({ data: recode }); //如果有组成物,不可修改
- } else {
- return false;
- }
- }
- if (
- me.isExtraType(recode.type) &&
- (dataCode == "name" || dataCode == "specs" || dataCode == "unit")
- ) {
- //人材机窗口中的“企业管理费”“利润”“一般风险费”的名称、规格、单位改为只读。
- return false;
- }
- return true;
- }
- } else {
- return false;
- }
- },
- hasComposition: function (ration_glj, isRationType) {
- //判断是否有组成物,有则返回true 现在主材类型的工料机也有可能有组成物。
- return gljUtil.hasComposition(ration_glj, isRationType);
- },
- onRangeChanged: function (sender, args) {
- var me = gljOprObj;
- if (args.sheetName == "quantity_detail") {
- me.batchUpdateQuantityDetail(args);
- } else {
- if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
- args.editingText = null;
- } else if (args.action == GC.Spread.Sheets.RangeChangedAction.paste) {
- args.editingText = args.sheet.getCell(args.row, args.col).value();
- } else {
- return;
- }
- if (args.sheetName == "ration_glj") {
- me.onEditGLJSheet(args);
- }
- }
- },
- batchUpdateQuantityDetail: function (args) {
- let me = gljOprObj;
- let updateArray = [];
- for (let i = 0; i < args.changedCells.length; i++) {
- let c = args.changedCells[i];
- let tem = {
- row: c.row,
- col: c.col,
- editingText: args.sheet.getCell(c.row, c.col).text(),
- sheet: args.sheet,
- sheetName: args.sheetName,
- index: i,
- };
- updateArray.push(tem);
- }
- if (updateArray.length > 0) {
- updateArray.length == 1
- ? me.onEditDetailSheet(updateArray[0])
- : me.onEditDetailSheet(updateArray[0], updateCallback);
- }
- function updateCallback(i_args) {
- let index = i_args.index;
- if (index < updateArray.length - 1) {
- let nextIndex = index + 1;
- updateArray[nextIndex].replace = i_args.replace;
- if (nextIndex == updateArray.length - 1) {
- //是最后一个,则不用调callback了
- me.onEditDetailSheet(updateArray[nextIndex]);
- } else {
- me.onEditDetailSheet(updateArray[nextIndex], updateCallback);
- }
- }
- }
- },
- showDataIfRationSelect: function (node, selectedNodeId) {
- this.sheet.suspendPaint();
- this.sheet.suspendEvent();
- var isShow = false;
- if (projectReadOnly && this.setting.view.lockColumns) {
- this.setting.view.lockColumns = null;
- }
- if (selectedNodeId) {
- this.selectedNodeId = selectedNodeId;
- }
- if (node) {
- if (this.selectedNodeId && this.selectedNodeId == node.getID()) {
- return;
- } else {
- //恢复底色
- this.sheet.setStyle(
- this.sheet.getActiveRowIndex(),
- -1,
- this.getSelStyle(false, this.setting.style)
- );
- this.selectedNodeId = node.getID();
- }
- if (node.sourceType == "ration") {
- if (node.data.type == rationType.gljRation) {
- if ($("#linkGLJ").hasClass("active")) this.showMixRatio(node);
- subObj.showGljSubTabData();
- } else {
- if ($("#linkGLJ").hasClass("active")) {
- this.showRationGLJData(node);
- subObj.showGljSubTabData();
- // MaterialController.showReplaceDiv(node);
- }
- if ($("#linkAZZJF").hasClass("active"))
- installationFeeObj.showRationInstallationData(node);
- if ($("#linkMBZM").hasClass("active")) mbzm_obj.showMBZMData(node);
- }
- isShow = true;
- }
- if (node.sourceType == ModuleNames.ration_glj) {
- if ($("#linkGLJ").hasClass("active")) this.showMixRatio(node);
- MaterialController.hideReplaceDiv();
- isShow = true;
- }
- if ($("#linkGCLMX").hasClass("active")) this.showQuantityDetailData(node);
- } else {
- this.selectedNodeId = null;
- }
- if (!isShow) {
- this.clearSheetData();
- MaterialController.hideReplaceDiv();
- }
- this.sheet.resumeEvent();
- this.sheet.resumePaint();
- },
- showMixRatio: function (node) {
- //显示组成物到定额工料机
- let mixRatioMap = projectObj.project.projectGLJ.datas.mixRatioMap;
- let projectGljs = projectObj.project.projectGLJ.datas.gljList;
- let indexArray =
- node.sourceType == ModuleNames.ration ? rationKeyArray : gljKeyArray;
- let connect_index = this.getIndex(node.data, indexArray);
- let gljList = [];
- if (mixRatioMap[connect_index]) {
- //说明是有组成物的类型
- gljList = this.getMixRationShowDatas(
- mixRatioMap[connect_index],
- projectGljs
- );
- }
- if (gljList.length > 0) {
- //计算总消耗量
- if (node.sourceType == ModuleNames.ration) {
- this.calcMixRationTotalQuantity(gljList, node.data.quantity);
- } else {
- let totalQuantity = this.getTotalQuantity(node.data);
- this.calcMixRationTotalQuantity(gljList, totalQuantity);
- }
- }
- this.sheetData = gljList;
- this.sheet.setRowCount(0);
- this.sheetData = gljUtil.sortRationGLJ(this.sheetData);
- this.sheet.getRange(-1, 0, -1, 1).cellType(this.getTreeNodeCellType([]));
- sheetCommonObj.showData(this.sheet, this.setting, this.sheetData);
- //初始选择
- this.preGljSelection = null;
- this.sheetInitSelection({ row: this.sheet.getActiveRowIndex(), col: 0 });
- this.sheet.getRange(-1, 0, -1, this.setting.header.length).locked(true); //锁住定额工料机的所有列
- this.detailSheet
- .getRange(-1, 0, -1, this.detailSetting.header.length)
- .locked(true); //锁住工程量明细的所有列
- },
- showRationGLJData: function (node) {
- let gljList = [];
- let ration_glj = projectObj.project.ration_glj;
- node = node ? node : projectObj.project.mainTree.selected;
- if (node.sourceType == ModuleNames.ration) {
- if (node.data.type == rationType.gljRation) {
- this.showMixRatio(node);
- } else {
- let ration = node.data;
- gljList = this.filterGljByRation(ration, ration_glj.datas);
- this.showInSheet(gljList);
- }
- } else if (node.sourceType == ModuleNames.ration_glj) {
- this.showMixRatio(node);
- }
- },
- showRationGLJSheetData: function (init) {
- let me = this;
- let selected = this.sheet.getSelections();
- this.combineWithProjectGlj(this.sheetData);
- this.sheet.setRowCount(0);
- this.sheetData = gljUtil.sortRationGLJ(this.sheetData);
- this.sumQuantity(); //计算总消耗量
- this.addMixRatioToShow(); //显示组成物信息
- this.initRationTree(init, this.getUnitPriceCodeMap());
- sheetCommonObj.showData(
- this.sheet,
- this.setting,
- this.sheetData,
- null,
- function () {
- if (me.mainTreeSelectedChange == true) {
- me.sheet.setSelection(0, 1, 1, 1); //默认选中第一行,第二列(名称列)
- me.mainTreeSelectedChange = false;
- } else if (selected) {
- //定位光标到之前的位置
- me.sheet.setSelection(
- selected[0].row,
- selected[0].col,
- selected[0].rowCount,
- selected[0].colCount
- );
- }
- //初始选择
- me.preGljSelection = null;
- me.sheetInitSelection({
- row: me.sheet.getActiveRowIndex(),
- col: me.sheet.getActiveColumnIndex(),
- });
- }
- );
- },
- getSelectedRationGlj: function () {
- let selected = this.sheet.getSelections()[0];
- let ration_glj = this.sheetData[selected.row];
- return ration_glj;
- },
- getUnitPriceCodeMap: function () {
- //取单价文件中,编码前缀一样的映射表
- let codeMap = {};
- let priceMap = projectObj.project.projectGLJ.datas.unitPriceMap;
- if (priceMap) {
- for (let connectKey in priceMap) {
- let code = priceMap[connectKey].code;
- let name = priceMap[connectKey].name;
- let specs = priceMap[connectKey].specs;
- if (code) {
- let displayText = code + " " + name + " " + specs;
- let preCode = code.split("-")[0];
- if (codeMap[preCode]) {
- codeMap[preCode].push({ text: displayText, value: connectKey });
- } else {
- codeMap[preCode] = [{ text: displayText, value: connectKey }];
- }
- }
- }
- }
- return codeMap;
- },
- initRationTree: function (init, codeMap) {
- this.sheet.suspendPaint();
- this.sheet.suspendEvent();
- this.sheet.setRowCount(
- this.sheetData.length > 30 ? this.sheetData.length : 30
- );
- for (var i = 0; i < this.sheetData.length; i++) {
- let options = this.getCodeOptions(this.sheetData[i], codeMap);
- this.sheet.setCellType(
- i,
- 0,
- this.getTreeNodeCellType(this.sheetData, options),
- GC.Spread.Sheets.SheetArea.viewport
- );
- if (this.sheetData[i].hasOwnProperty("subList")) {
- var collapsed =
- this.sheetData[i].collapsed == undefined
- ? true
- : this.sheetData[i].collapsed;
- if (collapsed == true) {
- this.sheet
- .getRange(i + 1, -1, this.sheetData[i].subList.length, -1)
- .visible(false);
- }
- }
- }
- this.sheet.resumeEvent();
- this.sheet.resumePaint();
- },
- getCodeOptions: function (recode, codeMap) {
- let options = [];
- if (recode.isMixRatio === true) {
- return null;
- }
- let code = recode.code;
- if (code) {
- let preCode = code.split("-")[0];
- if (codeMap[preCode]) options = codeMap[preCode];
- if (options.length > 0)
- _.remove(options, { value: gljOprObj.getIndex(recode, gljKeyArray) }); //去掉本身
- }
- return _.sortBy(options, "text");
- },
- filterGljByRation: function (ration, datas) {
- var gljList = [];
- if (datas && datas.length > 0) {
- gljList = _.filter(datas, { rationID: ration.ID });
- }
- return gljList;
- },
- showInSheet: function (gljList) {
- this.sheetData = gljList;
- this.showRationGLJSheetData(true);
- },
- sumQuantity: function (node) {
- if (this.sheetData.length > 0) {
- node = node ? node : projectObj.project.mainTree.selected;
- let ration = node.data;
- for (let glj of this.sheetData) {
- glj.totalQuantity = this.getTotalQuantity(glj, ration);
- }
- }
- },
- getTotalQuantity: function (glj, ration) {
- if (glj.isMixRatio == true) return; //如果是用于显示的组成物,则不用计算,跳过
- ration = ration
- ? ration
- : _.find(projectObj.project.Ration.datas, { ID: glj.rationID });
- glj.totalQuantity = gljUtil.getTotalQuantity(
- glj,
- ration,
- getDecimal("ration.quantity"),
- getDecimal("glj.quantity")
- );
- if (glj.hasOwnProperty("subList")) {
- //需要计算glj下挂的组成物的总消耗量
- this.calcMixRationTotalQuantity(glj.subList, glj.totalQuantity);
- }
- return glj.totalQuantity;
- },
- calcMixRationTotalQuantity(mList, pTotal) {
- //计算组成物的总消耗量
- for (let subG of mList) {
- subG.rationItemQuantity = scMathUtil.roundForObj(
- subG.rationItemQuantity,
- getDecimal("glj.quantity")
- );
- subG.totalQuantity =
- scMathUtil.roundForObj(
- subG.rationItemQuantity * pTotal,
- getDecimal("glj.quantity")
- ) + "";
- }
- },
- addMixRatioToShow: function () {
- var newList = [];
- _.remove(this.sheetData, { isMixRatio: true });
- for (var i = 0; i < this.sheetData.length; i++) {
- newList.push(this.sheetData[i]);
- if (this.sheetData[i].hasOwnProperty("subList")) {
- newList = newList.concat(this.sheetData[i].subList);
- }
- }
- this.sheetData = newList;
- },
- combineWithProjectGlj: function (
- ration_gljs,
- needRatio = true,
- ration,
- p_gljMap
- ) {
- let projectGLJData = projectObj.project.projectGLJ.datas;
- let projectGljs = projectGLJData.gljList;
- let mixRatioMap = projectGLJData.mixRatioMap;
- if (
- ration_gljs &&
- ration_gljs.length > 0 &&
- projectGljs &&
- projectGljs.length > 0
- ) {
- let pgljMap = p_gljMap ? p_gljMap : _.indexBy(projectGljs, "id");
- for (let i = 0; i < ration_gljs.length; i++) {
- let glj = pgljMap[ration_gljs[i].projectGLJID];
- if (glj) {
- if (
- projectObj.project.projectGLJ.isEstimateType(ration_gljs[i].type)
- ) {
- ration_gljs[i].isEstimate = glj.is_evaluate;
- }
- ration_gljs[i].shortName =
- projectObj.project.projectGLJ.getShortNameByID(ration_gljs[i].type);
- ration_gljs[i].isAdd = glj.unit_price.is_add;
- ration_gljs[i] = this.setGLJPrice(ration_gljs[i], glj, false); //设置工料机价格
- let connect_index = this.getIndex(glj, gljKeyArray);
- if (needRatio == true && mixRatioMap.hasOwnProperty(connect_index)) {
- let mixRatios = this.getMixRationShowDatas(
- mixRatioMap[connect_index],
- projectGljs
- );
- ration_gljs[i].subList = mixRatios;
- }
- if (needRatio == false) {
- //不需要组成物的情况,目前应该是复制整块那里用到,这里加上毛重系数等信息,一起复制
- ration_gljs[i].grossWeightCoe = glj.unit_price.grossWeightCoe;
- ration_gljs[i].purchaseStorageRate =
- glj.unit_price.purchaseStorageRate;
- ration_gljs[i].offSiteTransportLossRate =
- glj.unit_price.offSiteTransportLossRate;
- ration_gljs[i].handlingLossRate = glj.unit_price.handlingLossRate;
- }
- if (ration) gljOprObj.getTotalQuantity(ration_gljs[i], ration);
- } else {
- //计算程序中量价也会放到这里进来,量价是没有对应的项目工料机的
- //if(ration_gljs[i].type != rationType.volumePrice) console.log("没有找到工料机:"+ration_gljs[i].name)
- }
- }
- }
- return ration_gljs;
- },
- setGLJPrice: function (data, glj, isRadio = false, ext) {
- //isRadio 标记是否算组成物的价格
- let proGLJ = projectObj.project.projectGLJ;
- let calcOptions = projectObj.project.projectInfo.property.calcOptions;
- let decimalObj = projectObj.project.projectInfo.property.decimal;
- let labourCoeDatas = projectObj.project.labourCoe.datas;
- glj = glj ? glj : _.find(proGLJ.datas.gljList, { id: data.projectGLJID });
- if (glj) {
- let tenderCoe = projectObj.project.projectGLJ.getTenderPriceCoe(glj);
- let result = gljUtil.getGLJPrice(
- glj,
- proGLJ.datas,
- calcOptions,
- labourCoeDatas,
- decimalObj,
- isRadio,
- _,
- scMathUtil,
- ext,
- tenderCoe
- );
- data.marketPrice = result.marketPrice;
- data.basePrice = result.basePrice;
- data.adjustPrice = result.adjustPrice;
- data.marketUnitFee = data.marketPrice; //更新树节点市场单价列的值
- data.tenderPrice = result.tenderPrice;
- }
- return data;
- },
- getBasePrice: function (treeNode) {
- //造价书中的工料机修改的节点要用到
- let proGLJ = projectObj.project.projectGLJ;
- let glj = _.find(proGLJ.datas.gljList, { id: treeNode.data.projectGLJID });
- if (this.calcPriceDiff(glj) == true) {
- return proGLJ.getBasePrice(glj);
- } else {
- return scMathUtil.roundForObj(
- treeNode.data.marketUnitFee,
- getDecimal("glj.unitPrice")
- );
- }
- },
- getMarketPrice: function (treeNode) {
- //造价书中的工料机修改的节点要用到
- let proGLJ = projectObj.project.projectGLJ;
- let glj = _.find(proGLJ.datas.gljList, { id: treeNode.data.projectGLJID });
- return proGLJ.getMarketPrice(glj);
- },
- calcPriceDiff: function (glj) {
- let calcOptions = projectObj.project.projectInfo.property.calcOptions;
- return gljUtil.calcPriceDiff(glj, calcOptions);
- },
- getIndex(obj, pops) {
- return gljUtil.getIndex(obj, pops);
- },
- getConditionByKey(conKey) {
- //将连接字符串转换成对象
- let valueArray = conKey.split("|-|");
- let obj = {};
- for (let i = 0; i < valueArray.length; i++) {
- if (valueArray[i] != "null") {
- if (gljKeyArray[i] == "type") {
- valueArray[i] = parseInt(valueArray[i]);
- }
- obj[gljKeyArray[i]] = valueArray[i];
- }
- }
- return obj;
- },
- getMixRationShowDatas: function (mixRatioList, projectGljs) {
- var temRationGLJs = [];
- for (var i = 0; i < mixRatioList.length; i++) {
- let mIndex = gljOprObj.getIndex(mixRatioList[i], gljKeyArray);
- let pgljMap = projectObj.project.projectGLJ.datas.gljMap;
- let pg = null;
- if (pgljMap) {
- pg = pgljMap[mIndex];
- }
- if (!pg) {
- pg = _.find(projectGljs, function (item) {
- return gljOprObj.getIndex(item, gljKeyArray) == mIndex;
- }); //改关联关系
- }
- if (pg) {
- let tem = {
- projectGLJID: pg.id,
- code: pg.code,
- name: pg.name,
- specs: pg.specs,
- unit: pg.unit,
- type: mixRatioList[i].type,
- shortName: projectObj.project.projectGLJ.getShortNameByID(
- mixRatioList[i].type
- ),
- consumption: mixRatioList[i].consumption,
- rationItemQuantity: mixRatioList[i].consumption,
- // quantity:mixRatioList[i].consumption,
- /* basePrice: pg.unit_price.base_price,
- marketPrice: pg.unit_price.market_price,
- adjustPrice: pg.adjust_price,*/
- //isEstimate: pg.is_evaluate,
- isMixRatio: true,
- isAdd: pg.unit_price.is_add,
- GLJID: pg.glj_id,
- };
- if (projectObj.project.projectGLJ.isEstimateType(pg.type)) {
- tem.isEstimate = pg.is_evaluate;
- }
- this.setGLJPrice(tem, pg);
- temRationGLJs.push(tem);
- } else {
- console.log("没有找到工料机:" + mIndex);
- }
- }
- temRationGLJs = gljUtil.sortMixRatio(temRationGLJs);
- return temRationGLJs;
- },
- showQuantityDetailData: function (node) {
- node = node ? node : projectObj.project.mainTree.selected;
- var quantity_detail = projectObj.project.quantity_detail;
- let field = node.sourceType == ModuleNames.ration ? "rationID" : "billID";
- let details = quantity_detail.getListByID(node.data.ID, field);
- sheetCommonObj.showData(this.detailSheet, this.detailSetting, details);
- this.detailData = details;
- if (MainTreeCol.readOnly.forQuantifyDetail(node)) {
- this.detailSheet
- .getRange(-1, 0, -1, this.detailSetting.header.length)
- .locked(true);
- }
- },
- clearSheetData: function () {
- if ($("#linkGLJ").hasClass("active")) {
- sheetCommonObj.showData(this.sheet, this.setting, []);
- }
- if ($("#linkAZZJF").hasClass("active")) {
- installationFeeObj.rationInstallSheet.setRowCount(0); //清除combobox cell
- sheetCommonObj.showData(
- installationFeeObj.rationInstallSheet,
- installationFeeObj.rationInstallSetting,
- []
- );
- }
- // sheetCommonObj.showData(this.detailSheet,this.detailSetting,[]);
- this.sheetData = [];
- installationFeeObj.rationInstallData = [];
- //this.detailData=[];
- },
- updateRationGLJ: function (args) {
- var me = this;
- var updateField = me.setting.header[args.col].dataCode;
- var recode = me.sheetData[args.row];
- var newval;
- if (!me.rationGLJEditCheck(args)) {
- recode
- ? me.sheet.getCell(args.row, args.col).value(recode[updateField])
- : me.sheet.getCell(args.row, args.col).value(null);
- return;
- }
- if (args.editingText) {
- args.editingText = args.editingText.replace(/[\r\n]/g, ""); //去掉回车换行等字符;
- me.sheet.getCell(args.row, args.col).value(args.editingText);
- }
- if (
- updateField == "marketPrice" ||
- updateField == "customQuantity" ||
- updateField == "basePrice"
- ) {
- if (args.editingText == null) {
- updateField == "marketPrice" ? (newval = 0) : (newval = "");
- } else {
- var decimal =
- updateField == "customQuantity" ? getDecimal("glj.quantity") : 6; //对于市场价和定额价,这里只是中间的小数位数,后面更新前会根据有没有组成物再取值
- newval = number_util.checkNumberValue(args.editingText, decimal);
- if (newval == null) {
- me.sheet.getCell(args.row, args.col).value(recode[updateField]);
- return;
- }
- }
- } else {
- if (updateField == "name" || updateField == "unit") {
- if (args.editingText === null) {
- alert(me.setting.header[args.col].headerName + "不能为空!");
- me.sheet.getCell(args.row, args.col).value(recode[updateField]);
- return;
- }
- }
- if (updateField == "code") {
- if (
- !gljUtil.isDef(args.editingText) ||
- args.editingText == "" ||
- args.editingText.indexOf("|-|") === -1 ||
- this.isRationGLJExit(args.editingText)
- ) {
- //说明是选中自已,或者是已存在的工料机
- me.sheet.getCell(args.row, args.col).value(recode[updateField]);
- return;
- }
- }
- newval = args.editingText == null ? "" : args.editingText;
- }
- if (newval === recode[updateField]) {
- //如果值完全相等,则不需要更新
- return;
- }
- if (updateField == "marketPrice" || updateField == "basePrice") {
- projectObj.project.projectGLJ.updatePriceFromRG(
- recode,
- updateField,
- newval
- );
- } else if (updateField == "code") {
- //替换单价文件中已经有的工料机
- projectObj.project.ration_glj.updateRationGLJByChangeCode(
- recode,
- updateField,
- newval
- );
- } else if (me.setting.navigationRightCol.indexOf(updateField) != -1) {
- //对于名称、规格、单位先跳到下一列,保存至缓存
- me.setToEditCache(recode, updateField, newval, args);
- } else {
- projectObj.project.ration_glj.updateRationGLJByEdit(
- recode,
- updateField,
- newval
- );
- }
- },
- setToEditCache: function (recode, updateField, value, args) {
- let me = this;
- if (me.rationGljEditObj == null) {
- me.rationGljEditObj = {
- recode: recode,
- doc: {},
- row: args.row,
- };
- me.rationGljEditObj.doc[updateField] = value;
- } else {
- if (me.rationGljEditObj.recode.ID == recode.ID) {
- //确保编辑的是同一条数据
- me.rationGljEditObj.doc[updateField] = value;
- }
- }
- },
- isRationGLJExit: function (connectKey) {
- for (let rg of gljOprObj.sheetData) {
- if (rg.isMixRatio == true) {
- continue;
- }
- if (gljOprObj.getIndex(rg, gljKeyArray) == connectKey) {
- //存在一样的工料机
- return true;
- }
- }
- return false;
- },
- updateRationTypeGLJ: function (value, node, fieldName, editingText) {
- let newval;
- let updatePrice = false;
- if (
- fieldName == "marketUnitFee" ||
- fieldName == "feesIndex.common.unitFee"
- ) {
- updatePrice = true;
- if (value == null) {
- newval = 0;
- } else {
- var decimal = getDecimal("glj.unitPrice");
- newval = number_util.checkNumberValue(value, decimal);
- }
- } else {
- if (value != null) {
- projectObj.project.projectGLJ.updatePropertyFromMainSpread(
- node,
- fieldName,
- value,
- editingText
- );
- return;
- }
- }
- if (newval && updatePrice == true) {
- projectObj.project.projectGLJ.updatePriceFromRG(
- node.data,
- "marketPrice",
- newval
- );
- return;
- }
- projectObj.mainController.refreshTreeNode([node]);
- },
- updateIsEstimate: function (args, newval) {
- var me = gljOprObj;
- if (me.setting.header[args.col].dataCode == "isEstimate") {
- var pspread = new ProjectGLJSpread();
- var recode = me.sheetData[args.row];
- let projectGljs = projectObj.project.projectGLJ.datas.gljList;
- let glj = _.find(projectGljs, { id: recode.projectGLJID });
- if (glj) {
- glj["is_evaluate"] = newval;
- args.fromRG = true;
- pspread.postUpdate(
- recode.projectGLJID,
- "is_evaluate",
- newval,
- args,
- null,
- successTrigger
- );
- }
- }
- },
- showLibGLJSheetData: function () {
- //this.gljLibSheetData = _.sortBy(this.gljLibSheetData, 'code');
- sheetCommonObj.showData(
- this.gljLibSheet,
- this.gljLibSheetSetting,
- this.gljLibSheetData,
- gljOprObj.distTypeTree
- );
- this.gljLibSheet.setRowCount(this.gljLibSheetData.length);
- },
- filterLibGLJSheetData: function () {
- let me = this;
- const selectLibID = $("#glj-lib-select").val();
- const cptLibReg = new RegExp(commonConstants.COMPLEMENTARY_LIB);
- me.gljLibSheetData = cptLibReg.test(selectLibID)
- ? me.complementaryGLJs
- : me.stdGLJ;
- if (
- $("#actionType").val() == "replace" ||
- $("#actionType").val() == "m_replace"
- ) {
- me.filterLibGLJByType();
- } else if (
- $("#actionType").val() == "addMix" ||
- $("#actionType").val() == "unitPriceAddMix"
- ) {
- projectGljObject.filterLibGLJForMixRatio();
- }
- //文本筛选
- let searchStr = $("#gljSearchKeyword").val();
- if (searchStr && searchStr.trim() != "") {
- let reg = new RegExp(searchStr);
- me.gljLibSheetData = _.filter(me.gljLibSheetData, function (data) {
- return reg.test(data.code) || reg.test(data.name);
- });
- }
- if (me.gljCurTypeId == undefined) {
- return;
- }
- if (me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
- me.gljLibSheetData = _.filter(me.gljLibSheetData, function (n) {
- return _.includes(
- me.parentNodeIds["_pNodeId_" + me.gljCurTypeId],
- n.gljClass
- );
- });
- } else {
- me.gljLibSheetData = _.filter(me.gljLibSheetData, {
- gljClass: me.gljCurTypeId,
- });
- }
- },
- setGLJSelection: function (args, newVal) {
- if (
- $("#actionType").val() == "add" ||
- $("#actionType").val() == "insert" ||
- $("#actionType").val() == "insertEquipment" ||
- $("#actionType").val() == "addMix" ||
- $("#actionType").val() == "unitPriceAddMix"
- ) {
- this.addGLJsSelection(args, newVal);
- } else {
- this.replaceGLJSelection(args, newVal);
- }
- },
- addGLJsSelection: function (args, newVal) {
- var con_key = this.getIndex(this.gljLibSheetData[args.row], gljLibKeyArray);
- if (newVal == 1) {
- this.GLJSelection.push(con_key);
- this.gljLibSheetData[args.row].select = 1;
- } else if (newVal == 0) {
- _.pull(this.GLJSelection, con_key);
- this.gljLibSheetData[args.row].select = 0;
- }
- },
- replaceGLJSelection: function (args, newVal) {
- var me = this;
- var oldSelection = this.GLJSelection[0];
- if (newVal == 0) {
- args.sheet.getCell(args.row, args.col).value(1);
- return;
- }
- this.GLJSelection = [
- me.getIndex(this.gljLibSheetData[args.row], gljLibKeyArray),
- ];
- this.gljLibSheetData[args.row].select = 1;
- var oindex = _.findIndex(this.gljLibSheetData, function (item) {
- var i_key = me.getIndex(item, gljLibKeyArray);
- return oldSelection == i_key;
- });
- if (oindex != -1) {
- args.sheet.getCell(oindex, args.col).value(0);
- this.gljLibSheetData[oindex].select = 0;
- } else {
- var oldData = _.find(gljOprObj.AllRecode, function (item) {
- var i_key = me.getIndex(item, gljLibKeyArray);
- return oldSelection == i_key;
- });
- oldData ? (oldData.select = 0) : "";
- }
- },
- filterLibGLJByType: function () {
- var me = this;
- var selected = me.sheetData[gljContextMenu.selectedRow];
- let materialTypes = [
- gljType.CONCRETE,
- gljType.MORTAR,
- gljType.MIX_RATIO,
- gljType.COMMERCIAL_CONCRETE,
- gljType.COMMERCIAL_MORTAR,
- ]; //混凝土、砂浆、配合比、商品混凝土、商品砂浆
- let normalTypes = [
- gljType.GENERAL_MATERIAL,
- gljType.PURCHASE_COMPONENT,
- gljType.GREEN_SEEDLING,
- ]; //普通材料、外购砼构件、绿化苗木;
- let filterTypes = [selected.type];
- //当前人材机类型是“混凝土、砂浆、配合比、商品混凝土、商品砂浆”时,筛选的可替换的人材机类型应是“混凝土、或砂浆、或配合比、或商品混凝土、或商品砂浆”。
- if (materialTypes.includes(selected.type)) filterTypes = materialTypes;
- //当前人材机类型是普通材料、外购砼构件、绿化苗木
- if (normalTypes.includes(selected.type)) filterTypes = normalTypes;
- me.gljLibSheetData = _.filter(me.gljLibSheetData, function (data) {
- return filterTypes.includes(data.gljType);
- });
- },
- getComboData: function (gljDistType) {
- let me = this;
- let distType;
- let distTypeTree = {
- prefix: "gljType",
- distTypes: {},
- comboDatas: [],
- distTypesArr: [],
- };
- gljDistType.forEach(function (typeData) {
- let typeObj = {
- data: typeData,
- children: [],
- parent: null,
- };
- distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
- distTypeTree.distTypesArr.push(typeObj);
- });
- gljDistType.forEach(function (typeData) {
- distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
- let parent =
- distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
- if (parent) {
- distType.parent = parent;
- parent.children.push(distType);
- }
- });
- distTypeTree.distTypesArr.forEach(function (distTypeObj) {
- if (
- distTypeObj.data.fullName !== "材料" &&
- distTypeObj.data.fullName !== "机械"
- ) {
- distTypeTree.comboDatas.push({
- text: distTypeObj.data.fullName,
- value: distTypeObj.data.ID,
- });
- }
- });
- return distTypeTree;
- },
- doInsertGLJ: function (insertType) {
- var me = this;
- var selected = projectObj.project.mainTree.selected;
- var project = projectObj.project;
- if (me.GLJSelection.length <= 0) {
- return;
- }
- $.bootstrapLoading.start();
- project.ration_glj.insertGLJAsRation(
- me.GLJSelection,
- selected,
- insertType,
- function (parentNodeID, nextNodeID, data) {
- let newNode = null;
- for (let r_glj of data) {
- r_glj.quantity = r_glj.quantity + "";
- project.Ration.datas.push(r_glj);
- } //要先更新树节点工程量,加载项目工料机并计算消耗量才有值
- project.projectGLJ.loadData(function () {
- for (let r_glj of data) {
- r_glj = me.setGLJPrice(r_glj); //设置工料机价格
- newNode = project.mainTree.insert(
- parentNodeID,
- nextNodeID,
- r_glj.ID
- );
- newNode.source = r_glj;
- newNode.sourceType = project.Ration.getSourceType();
- newNode.data = r_glj;
- ProjectController.syncDisplayNewNode(
- projectObj.mainController,
- newNode
- );
- }
- project.calcProgram.calcLeafAndSave(newNode.parent); //计算父级清单的所有子节点
- projectObj.mainController.refreshTreeNode([newNode]);
- if (me.hasComposition(newNode.data, true)) {
- me.showMixRatio(newNode);
- } else {
- me.showRationGLJSheetData();
- }
- projectObj.refreshBaseActn(project.mainTree);
- $.bootstrapLoading.end();
- });
- }
- );
- },
- doAddGLJ: function () {
- var selected = projectObj.project.mainTree.selected;
- var project = projectObj.project;
- gljOprObj.GLJSelection = _.filter(gljOprObj.GLJSelection, function (n) {
- var rg = _.find(gljOprObj.sheetData, function (item) {
- if (item.isMixRatio == true) {
- return false;
- }
- var i_key = gljOprObj.getIndex(item, gljKeyArray);
- return n == i_key;
- });
- return rg ? false : true;
- });
- if (
- gljOprObj.GLJSelection.length > 0 &&
- selected &&
- selected.sourceType == ModuleNames.ration
- ) {
- project.ration_glj.addGLJByLib(
- gljOprObj.GLJSelection,
- selected.data,
- function (result) {
- if (result) {
- selected.data.adjustState = result.adjustState;
- project.ration_glj.datas = project.ration_glj.datas.concat(
- result.newRecodes
- ); //显示和缓存统一,这样的话就不用更新两个位置了
- //project.ration_glj.datas = project.ration_glj.datas.concat(result.showData);
- //gljOprObj.sheetData = gljOprObj.sheetData.concat(result.showData);
- project.projectGLJ.loadNewProjectGLJToCaches(
- result.projectGLJList,
- true
- );
- project.ration_glj.addToMainTree(result.showData); //组成物不会显示到造价书页面
- project.calcProgram.calcAndSave(selected);
- projectObj.mainController.refreshTreeNode([selected]);
- gljOprObj.refreshView();
- $.bootstrapLoading.end();
- }
- }
- ); //doc.rationID=selected.data.ID;
- }
- },
- concreteTypeReplaceChecking: function (selectCode, oldData, selected) {
- //selected为空,表示批量替换 混凝土替换前的检查,是否给出确认提示
- let allGLJ = gljOprObj.AllRecode;
- let glj = _.find(allGLJ, function (item) {
- let i_key = gljOprObj.getIndex(item, gljLibKeyArray);
- return i_key == selectCode;
- });
- if (!glj) return false;
- if (gljUtil.isConcreteToCommercialConcrete(oldData.type, glj.gljType)) {
- //被替换的是混凝土,替换成商品砼或商品砂浆
- if (selected) {
- //如果有选中的,说明是替换,还要判断是否有辅助定额, 批量替换不用判断
- return selected.data.rationAssList &&
- selected.data.rationAssList.length > 0
- ? true
- : false;
- }
- return true;
- }
- return false;
- },
- replaceGLJConfirm: function (mreplace = false) {
- let me = this;
- let oldData = me.sheetData[gljContextMenu.selectedRow];
- let selectCode = gljOprObj.GLJSelection[0];
- let selected =
- mreplace == true ? null : projectObj.project.mainTree.selected;
- if (me.concreteTypeReplaceChecking(selectCode, oldData, selected)) {
- hintBox.infoBox(
- "操作确认",
- "请先调整厚度,再替换商品砼。确定要继续吗?",
- 2,
- function () {
- mreplace == true
- ? $("#mreplace_next_div").modal("show")
- : me.doReplaceGLJ(selectCode, oldData, selected);
- },
- null,
- ["确定", "取消"],
- false
- );
- } else {
- mreplace == true
- ? $("#mreplace_next_div").modal("show")
- : me.doReplaceGLJ(selectCode, oldData, selected);
- }
- },
- doReplaceGLJ: function (selectCode, oldData, selected, is) {
- let me = this;
- let project = projectObj.project;
- let oldType = oldData.type;
- project.ration_glj.replaceGLJ(selectCode, oldData, function (result) {
- if (result) {
- //result.adjustState;
- project.ration_glj.setDatasAfterReplace(result);
- let data = result.data;
- let nodes = [selected];
- let node = project.ration_glj.updateGLJNodeAfterReplace(data);
- if (node) nodes.push(node);
- /*if (project.ration_glj.needShowToTree(data)) {//当替换的是主材或设备时,刷新对应的树节点
- var node = project.ration_glj.findGLJNodeByID(data.ID);
- if (node) {
- project.ration_glj.transferToNodeData(data);
- node.source = data;
- node.data = data;
- }
- node ? nodes.push(node) : "";
- }*/
- //project.ration_glj.addToMainTree(data);
- selected.data.adjustState = result.adjustState;
- selected.data.name = result.name;
- projectObj.mainController.refreshTreeNode(nodes);
- project.calcProgram.calcAndSave(selected, function () {
- me.replaceProgramInfo(oldType, result.projectGLJ.type);
- });
- gljOprObj.refreshView();
- $.bootstrapLoading.end();
- }
- });
- },
- replaceProgramInfo: function (oldType, newType) {
- //检查是否由混凝土替换为商品砼或者商品砂浆
- if (gljUtil.isConcreteToCommercialConcrete(oldType, newType)) {
- const showCompilations1 = [
- "浙江养护(2005)",
- "内蒙古养护(2019)",
- "内蒙古高速公路养护(2022)",
- "安徽养护(2018)",
- "山东养护(2016/2024)",
- ];
- const showMsg1 = "请手动修改取费类别为构造物III";
- const showCompilations2 = ["广西养护(2020)", "广西日常养护(2020)"];
- const showMsg2 = "请手动修改取费类别为商混及外构件";
- const showCompilations3 = ["河南养护(2022)", "河南日常养护(2022)"];
- const showMsg3 = "请手动修改取费类别为商品混凝土及外构件";
- if (showCompilations1.includes(compilationName)) {
- // 隐藏,不显示
- } else if (showCompilations2.includes(compilationName)) {
- setTimeout(() => {
- alert(showMsg2);
- }, 300);
- } else if (showCompilations3.includes(compilationName)) {
- setTimeout(() => {
- alert(showMsg3);
- }, 300);
- } else {
- setTimeout(() => {
- alert(showMsg1);
- }, 300);
- }
- }
- },
- doMReplaceGLJ: function () {
- let me = this;
- let project = projectObj.project;
- let oldData = me.sheetData[gljContextMenu.selectedRow];
- let selectCode = gljOprObj.GLJSelection[0];
- let oldType = oldData.type;
- project.ration_glj.mReplaceGLJ(
- selectCode,
- oldData,
- function (result, updateMap) {
- if (result == null) {
- return;
- }
- let data = result.data;
- let stateList = result.stateList;
- //let n_index = me.getIndex(data.query, gljKeyArray);
- let nodes = [];
- let quantityMap = {};
- for (let gr of result.glj_result) {
- quantityMap[gr.query.ID] = gr.doc;
- }
- //添加\删除混凝土组成物定额工料机
- project.ration_glj.addAndDeleteDatas(
- result.newRecodes,
- result.deleteList
- );
- _.forEach(project.ration_glj.datas, function (t) {
- // let t_index = me.getIndex(t, gljKeyArray);
- if (updateMap[t.ID]) {
- if (updateMap[t.ID].code) me.updateProperty(t, data.doc); //说明这条不是只更新自定义消耗量的,才要更新项目工料机
- me.updateProperty(t, updateMap[t.ID]);
- if (project.ration_glj.needShowToTree(t)) {
- //如果是造价书中的树节点,则也须刷新
- project.ration_glj.transferToNodeData(t);
- var node = project.ration_glj.findGLJNodeByID(t.ID);
- node ? nodes.push(node) : "";
- }
- }
- if (quantityMap[t.ID]) {
- //更新消耗量
- me.updateProperty(t, quantityMap[t.ID]);
- }
- });
- project.projectGLJ.loadNewProjectGLJToCaches([result.projectGLJ], true);
- var rationNodes = me.refreshStateAfterMreplace(stateList, nodes);
- project.calcProgram.calcNodesAndSave(rationNodes, function () {
- me.replaceProgramInfo(oldType, result.projectGLJ.type);
- });
- me.refreshView();
- $.bootstrapLoading.end();
- }
- );
- },
- updateProperty: function (obj, doc) {
- gljUtil.updateProperty(obj, doc);
- },
- refreshStateAfterMreplace: function (stateList, gljNodes) {
- let nodes = [];
- let rationNodes = [];
- _.forEach(stateList, function (s) {
- let node = _.find(projectObj.project.mainTree.items, function (n) {
- return n.sourceType == ModuleNames.ration && n.data.ID == s.rationID;
- });
- if (node) {
- node.data.adjustState = s.adjustState;
- node.data.name = s.name;
- nodes.push(node);
- rationNodes.push(node);
- }
- });
- gljNodes.length > 0 ? (nodes = nodes.concat(gljNodes)) : "";
- projectObj.mainController.refreshTreeNode(nodes);
- return rationNodes;
- },
- refreshView: function () {
- let node = projectObj.project.mainTree.selected;
- this.showDataIfRationSelect(node, "111111");
- },
- refreshTreeNode: function (obj) {
- if (!obj) {
- return;
- }
- let objectArray = [];
- let nodes = [];
- if (obj instanceof Array) {
- objectArray.concat(obj);
- } else {
- objectArray.push(obj);
- }
- for (let o of objectArray) {
- let node = this.updateDataNodeProperty(o.ID, o.data);
- if (node) {
- nodes.push(node);
- }
- }
- projectObj.mainController.refreshTreeNode(nodes);
- return nodes;
- },
- updateDataNodeProperty: function (nodeID, data) {
- let node = projectObj.project.mainTree.findNode(nodeID);
- if (node) {
- for (let k in data) {
- node.data[k] = data[k];
- }
- }
- return node;
- },
- getTreeNodeCellType: function (data, comboboxOptions) {
- let ns = GC.Spread.Sheets;
- let rectW = 10;
- let rectH = 10;
- let margin = 3;
- function TreeNodeCellType() {
- this.ctx = null;
- }
- TreeNodeCellType.prototype = comboboxOptions
- ? sheetCommonObj.getDynamicCombo()
- : new ns.CellTypes.Text();
- TreeNodeCellType.prototype.paint = function (
- ctx,
- value,
- x,
- y,
- w,
- h,
- style,
- options
- ) {
- this.ctx = ctx;
- if (style.backColor) {
- //先画背景色
- ctx.save();
- ctx.fillStyle = style.backColor;
- ctx.fillRect(x, y, w, h);
- ctx.restore();
- } else {
- ctx.clearRect(x, y, w, h);
- }
- if (value != null) {
- let offset = margin + rectW + 6;
- let recode = data[options.row];
- if (recode && recode.hasOwnProperty("subList")) {
- sheetCommonObj.drowRect(ctx, x, y, w, h, rectW, rectH, margin);
- let collapsed =
- recode.collapsed == undefined ? true : recode.collapsed; //options.sheet.getTag(options.row,options.col);
- sheetCommonObj.drowSymbol(
- ctx,
- x,
- y,
- w,
- h,
- rectW,
- rectH,
- margin,
- collapsed
- );
- } else if (recode && recode.isMixRatio) {
- let hasNext =
- data[options.row + 1] && data[options.row + 1].isMixRatio;
- offset = sheetCommonObj.drowSubItem(ctx, x, y, w, h, offset, hasNext);
- offset += 1;
- }
- arguments[2] = x + offset;
- arguments[4] = w - offset;
- //x = x + offset;
- //w = w - offset;
- GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments);
- }
- };
- TreeNodeCellType.prototype.getHitInfo = function (
- x,
- y,
- cellStyle,
- cellRect,
- context
- ) {
- if (x < cellRect.x + cellRect.width - 15) {
- //这里要判断点击的位置来决定return的内容,不能直接用combobox的方法
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheetArea: context.sheetArea,
- };
- } else {
- return GC.Spread.Sheets.CellTypes.ComboBox.prototype.getHitInfo.apply(
- this,
- arguments
- );
- }
- };
- TreeNodeCellType.prototype.processMouseDown = function (hitinfo) {
- let recode = data[hitinfo.row];
- if (hitinfo.x < hitinfo.cellRect.x + hitinfo.cellRect.width - 15) {
- hitinfo.sheet.setTag(hitinfo.row, hitinfo.col, "locked"); //通过这个来控制除了点击下拉框的三角形,点击其它地方不充许进入编辑状态,不然不好控制下拉框超出页面后调整滚动条
- }
- if (recode && recode.hasOwnProperty("subList")) {
- let hoffset = hitinfo.cellRect.x + 3;
- if (hitinfo.x > hoffset && hitinfo.x < hoffset + 10) {
- let collapsed =
- recode.collapsed == undefined ? true : recode.collapsed;
- collapsed = !collapsed;
- recode.collapsed = collapsed;
- //hitinfo.sheet.setTag(hitinfo.row,hitinfo.col,collapsed);
- hitinfo.sheet
- .getRange(hitinfo.row + 1, -1, recode.subList.length, -1)
- .visible(!collapsed);
- hitinfo.sheet.invalidateLayout();
- hitinfo.sheet.repaint();
- return;
- }
- }
- if (
- comboboxOptions &&
- hitinfo.x > hitinfo.cellRect.x + hitinfo.cellRect.width - 15
- ) {
- //点击了下拉框按钮,这里要判断下拉框是否会被挡住,从而决定是否自动调整滚动条
- hitinfo.sheet.setTag(hitinfo.row, hitinfo.col, "");
- sheetCommonObj.scrollSheetForOption(
- hitinfo.sheet,
- this.ctx,
- hitinfo.cellRect,
- hitinfo.row,
- comboboxOptions
- ); //下拉框超出显示后自动调整滚动条
- GC.Spread.Sheets.CellTypes.ComboBox.prototype.processMouseDown.apply(
- this,
- arguments
- );
- }
- };
- let cellType = new TreeNodeCellType();
- if (comboboxOptions) {
- cellType.editorValueType(
- GC.Spread.Sheets.CellTypes.EditorValueType.value
- );
- cellType.itemHeight(comboboxOptions.length).items(comboboxOptions);
- }
- return cellType;
- },
- marketPriceReadOnly: function (node) {
- let isRationType =
- node.sourceType == ModuleNames.ration &&
- node.data.type == rationType.gljRation;
- let type = isRationType == true ? node.data.subType : node.data.type;
- if (gljUtil.isConcreteType(type)) return true;
- return this.hasComposition(node.data, isRationType); //2018-9-14 需求变更暂估工料机也能修改市场价原语句:return hasCom|| node.data.isEstimate == 1
- },
- locateZTree: function (ID) {
- let zTree = $.fn.zTree.getZTreeObj("gljTree");
- let node = null;
- if (ID) node = zTree.getNodesByParam("ID", ID, null)[0];
- if (!node) {
- node = zTree.getNodeByTId("gljTree_1");
- ID = node.ID;
- }
- zTree.selectNode(node);
- gljOprObj.gljCurTypeId = ID;
- gljOprObj.filterLibGLJSheetData();
- gljOprObj.showLibGLJSheetData();
- },
- isExtraType: function (type) {
- return _.includes(gljUtil.extraType, type);
- },
- setNodeShowTab: function () {
- let node = projectObj.project.mainTree.selected;
- if (node && node.sourceType == ModuleNames.ration) {
- gljOprObj.rationTab = gljOprObj.activeTab;
- } else {
- gljOprObj.billsTab = gljOprObj.activeTab;
- }
- },
- //初始化分类树
- //@param {String}type(标准或补充) {Array}treeData(树数据)
- initClassTree: function (type, treeData, initSel = false) {
- let me = this;
- if (me.treeObj) {
- me.treeObj.destroy();
- me.parentNodeIds = {};
- }
- zTreeHelper.createTree(treeData, me.gljTreeSetting, "gljTree", me);
- if (initSel) {
- let rootNode = me.treeObj.getNodes()[0];
- if (rootNode && rootNode.isParent && rootNode.isFirstNode) {
- me.rootNode = rootNode;
- }
- if (me.rootNode) {
- me.treeObj.selectNode(me.rootNode);
- me.gljTreeSetting.callback.onClick(null, "gljTree", me.rootNode);
- }
- }
- },
- initScopeSpread: function () {
- if (this.scopeSpread) return this.scopeSpread.repaint();
- this.scopeSpread = SheetDataHelper.createNewSpread($("#scopeSpread")[0]);
- sheetCommonObj.spreadDefaultStyle(this.scopeSpread);
- this.scopeTree = idTree.createNew({
- id: "ID",
- pid: "ParentID",
- nid: "NextSiblingID",
- rootId: -1,
- autoUpdate: false,
- });
- this.scopeTreeController = TREE_SHEET_CONTROLLER.createNew(
- this.scopeTree,
- this.scopeSpread.getActiveSheet(),
- this.scopeSetting
- );
- this.scopeSheet = this.scopeSpread.getActiveSheet();
- this.scopeSpread.bind(
- GC.Spread.Sheets.Events.ButtonClicked,
- this.onScopeChecked
- );
- },
- showScopeDatas: function () {
- this.initScopeSpread();
- this.scopeDatas = this.getScopeDatas();
- this.scopeTree.loadDatas(this.scopeDatas);
- this.scopeTreeController.showTreeData();
- },
- getScopeDatas: function () {
- let controller = projectObj.mainController,
- project = projectObj.project;
- let allNodes = [],
- datas = [];
- for (let rootNode of controller.tree.roots) {
- allNodes.push(rootNode);
- controller.tree.getAllSubNode(rootNode.source, allNodes);
- }
- for (let n of allNodes) {
- let temData = {
- ID: n.data.ID,
- NextSiblingID: n.data.NextSiblingID,
- ParentID: n.data.ParentID,
- unit: n.data.unit,
- code: n.data.code,
- selected: 0,
- name: n.data.name,
- quantity: calcTools.uiNodeQty(n) ? calcTools.uiNodeQty(n) : "",
- };
- if (n.data.feesIndex && n.data.feesIndex.common) {
- temData.unitPrice = n.data.feesIndex.common.unitFee;
- temData.totalPrice = n.data.feesIndex.common.totalFee;
- }
- datas.push(temData);
- }
- return datas;
- },
- onScopeChecked: function (e, args) {
- let me = gljOprObj,
- nodes = [];
- var checkboxValue = args.sheet.getCell(args.row, args.col).value();
- var newval = checkboxValue ? 0 : 1;
- let node = me.scopeTree.items[args.row];
- setNodeAndChildreSelected(node, newval, nodes);
- me.scopeTreeController.refreshTreeNode(nodes);
- function setNodeAndChildreSelected(n, val, arr) {
- n.data.selected = val;
- nodes.push(n);
- for (let c of n.children) {
- setNodeAndChildreSelected(c, val, arr);
- }
- }
- },
- setScopeSelection: function () {
- for (let node of this.scopeTree.items) {
- //挑出选中数,过滤父节点
- if (node.data.selected == 1 && node.children.length == 0)
- this.scopeSelectedIDMap[node.data.ID] = true;
- }
- },
- };
- $(function () {
- $("#glj_tree_div").on("shown.bs.modal", function (e) {
- gljContextMenu.initGLJSelectView();
- });
- $("#mreplace_next_div").on("shown.bs.modal", function (e) {
- gljOprObj.scopeSelectedIDMap = {};
- gljOprObj.showScopeDatas();
- });
- $("#glj_tree_div").on("hidden.bs.modal", function () {
- $("#gljSearchKeyword").val("");
- });
- $(".glj-radio").change(function () {
- let val = $("input[name='glj']:checked").val();
- if (val == "allGljs") {
- gljOprObj.gljLibSheetData = gljOprObj.AllRecode;
- gljOprObj.filterLibGLJSheetData();
- gljOprObj.showLibGLJSheetData();
- } else {
- if (val === "stdGLJ") {
- gljOprObj.initClassTree("std", gljOprObj.treeData.std, true);
- } else {
- gljOprObj.initClassTree("comple", gljOprObj.treeData.comple, true);
- }
- gljOprObj.initSelection({ row: 0 });
- }
- });
- // 更改选择库
- $("#glj-lib-select").change(function () {
- let getLibFun = null;
- if (typeof unitPriceObj != "undefined")
- getLibFun = unitPriceObj.getGLJLibData;
- getGLJData("change", false, getLibFun);
- });
- /* //工料机搜索
- $('#gljSearchKeyword').change(function () {
- gljOprObj.filterLibGLJSheetData();
- gljOprObj.showLibGLJSheetData();
- });
- $('#gljSearchKeyword').bind('keypress', function (e) {
- if(e.keyCode === 13){
- alert('2');
- $(this).blur();
- return false;
- }
- });*/
- $("#gljSearchKeyword").bind("keyup", function (e) {
- gljOprObj.filterLibGLJSheetData();
- gljOprObj.showLibGLJSheetData();
- gljOprObj.initSelection({ row: 0 });
- });
- $("#glj_selected_conf").click(function () {
- if (gljOprObj.GLJSelection.length < 1) {
- return;
- }
- if (["insert", "insertEquipment"].includes($("#actionType").val())) {
- //造价书页面中插入定额类型的工料机
- gljOprObj.doInsertGLJ($("#actionType").val());
- } else if ($("#actionType").val() == "add") {
- //添加工料机
- gljOprObj.doAddGLJ();
- } else if ($("#actionType").val() == "replace") {
- //替换工料机
- gljOprObj.replaceGLJConfirm(false);
- } else if ($("#actionType").val() == "m_replace") {
- //批量替换工料机
- gljOprObj.replaceGLJConfirm(true);
- } else if ($("#actionType").val() == "addMix") {
- projectGljObject.addMixRatio();
- } else if ($("#actionType").val() == "unitPriceAddMix") {
- unitPriceObj.addMixRatio();
- }
- $("#glj_tree_div").modal("hide");
- });
- $("#scope_position_confirm").click(function () {
- gljOprObj.setScopeSelection();
- gljOprObj.doMReplaceGLJ();
- });
- $("#replace_next_btn").click(function () {
- $("#glj_tree_div").modal("hide");
- gljOprObj.replaceGLJConfirm(true);
- });
- $("#class_selected_conf").click(function () {
- var gljClass = $("#selected_class").val();
- var glj = gljOprObj.selectedGLJClass;
- if (glj && gljClass && gljClass != "") {
- //保存到我的工料机库
- /*1 检查是否有组成物
- * 2 如果有,则检查组成物中是否有新增的记录,如果有,查看是否已经保存了,没有的话,要先添加组成物到补充工料机库
- * 3 保存
- * */
- var newItem = {
- code: glj.code,
- name: glj.name,
- specs: glj.specs,
- unit: glj.unit,
- basePrice: glj.basePrice,
- gljType: glj.type,
- shortName: glj.shortName,
- component: [],
- gljClass: gljClass,
- };
- if (glj.hasOwnProperty("subList") && glj.subList.length > 0) {
- //有组成物,检查组成物信息,目前组成物不允许修改,所以暂时不用考虑组成物是新增的情况
- for (var i = 0; i < glj.subList.length; i++) {
- let tem = {
- ID: glj.subList[i].GLJID,
- consumeAmt: glj.rationItemQuantity,
- isStd: true,
- };
- newItem.component.push(tem);
- }
- }
- var data = getcmpUpdateData([newItem]);
- $.bootstrapLoading.start();
- var callback = function (data) {
- $("#glj_class_div").modal("hide");
- $.bootstrapLoading.end();
- };
- CommonAjax.post(
- "complementartGlj/api/mixUpdateGljItems",
- data,
- callback,
- function () {
- $.bootstrapLoading.end();
- }
- );
- }
- });
- $("#glj_class_div").on("hidden.bs.modal", function (e) {
- gljOprObj.selectedGLJClass = null;
- $("#class_selected_conf").attr("disabled", "disabled");
- $("#selected_class").val("");
- });
- $("#subSpread").focusout(function (e) {
- //当本身或子元素失去焦点时这个事件都会发生,而且不好判断点击的是哪里。
- if (gljOprObj.rationGljEditObj) {
- gljOprObj.cancelUpdate = false;
- gljOprObj.timeStamp = e.timeStamp; //设置时间戳,有可能用户在表格上乱点,这个事件被触发多次
- setTimeout(function () {
- //延时执行提交操作,如果点击的是spread里的地方,会把cancelUpdate改成true,这样的话就不执行提交操作
- if (
- gljOprObj.timeStamp == e.timeStamp &&
- gljOprObj.cancelUpdate !== true
- ) {
- //时间戳要相同
- gljOprObj.updateGljFromCache();
- }
- }, 200);
- }
- });
- function getcmpUpdateData(items) {
- var data = {
- updateItems: [],
- removeIds: [],
- };
- data.addItems = items;
- return data;
- }
- });
- function operationWithRound(value1, value2, field, symble) {
- let decimal = getDecimal(field);
- value1 = scMathUtil.roundForObj(value1, decimal);
- value2 = scMathUtil.roundForObj(value2, decimal);
- let result;
- switch (symble) {
- case "+":
- result = scMathUtil.roundForObj(value1 + value2, decimal);
- break;
- case "-":
- result = scMathUtil.roundForObj(value1 - value2, decimal);
- break;
- case "*":
- result = scMathUtil.roundForObj(value1 * value2, decimal);
- break;
- case "/":
- result = scMathUtil.roundForObj(value1 / value2, decimal);
- break;
- }
- return result;
- }
- function getDecimal(fieldID, node) {
- if (node) {
- return decimalObj.decimal(fieldID, node);
- } else if (fieldID.indexOf(".") != -1) {
- var keyArray = fieldID.split(".");
- return decimalObj[keyArray[0]][keyArray[1]];
- } else {
- return decimalObj.decimal(fieldID);
- }
- }
- function compareRationGLJ(a, b) {
- if (a.type + "" < b.type + "") {
- return true;
- }
- if (a.type + "" == b.type + "") {
- if (a.code < b.code) {
- return true;
- }
- }
- return false;
- }
|