/**
* Created by zhang on 2018/3/13.
*/
projectGljObject={
showTag:'ration',//mixRatio/machine
showMixRatioMark:'',
displayType:filterType.ALL,
mixRatioType: [gljType.CONCRETE, gljType.MORTAR, gljType.MIX_RATIO,gljType.MAIN_MATERIAL],
machineType: [gljType.GENERAL_MACHINE],
projectGljSetting:{},
projectGljSpread:null,
projectGljSheet:null,
materialTreeSheet:null,
projectGljSheetData:[],
mixRatioSetting:{},
materialTreeSetting:{
"emptyRows":0,
"headRows":1,
"headRowHeight":[21],
"defaultRowHeight": 21,
"treeCol": 0,
"cols":[]
},
materialSetting:{
header:[
{headerName: "编码", headerWidth: 200, dataCode: "code", dataType: "String"},
{headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"},
{headerName: "规格型号", headerWidth: 160, dataCode: "specs", hAlign: "left", dataType: "String"},
{headerName: "单位", headerWidth: 45, dataCode: "unit", hAlign: "center", dataType: "String"},
{headerName: "定额价", headerWidth: 70, dataCode: "basePrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice'
{headerName: "市场价", headerWidth: 70, dataCode: "marketPrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice"
{headerName: "总消耗量", headerWidth: 70, dataCode: "quantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'},
{headerName: "三材系数", headerWidth: 70, dataCode: "materialCoe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'material'
{headerName: "三材量", headerWidth: 100, dataCode: "materialQuantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'},
{headerName: "三材类别", headerWidth: 70, dataCode: "materialType", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:materialComboMap}
],
view: {
lockColumns: [0,1,2,3,6,8]
}
},
mixRatioSpread:null,
mixRatioSheet:null,
mixRatioData:[],
usedTenderList:[],
usedUnitPriceInfo:null,
displayTypeMap:[
{ID:'LABOUR',text:'人工'},
{ID:'GENERAL_MATERIAL',text:'材料'},
{ID:'GENERAL_MACHINE',text:'机械'},
{ID:'MAIN_MATERIAL',text:'主材'},
{ID:'EQUIPMENT',text:'设备'}
],
initProjectGljSpread:function () {
if(!this.projectGljSpread){
this.projectGljSpread = SheetDataHelper.createNewSpread($("#project_glj_sheet")[0],2);
sheetCommonObj.spreadDefaultStyle(this.projectGljSpread);
}
this.projectGljSpread.bind(GC.Spread.Sheets.Events.RangeChanged, this.onProjectGljRangeChange);
this.initProjectGljSheet();
this.initMaterialTreeSheet();
disableRightMenu("project_glj_sheet",this.projectGljSpread,this.rightClickCallback);
//打开别人分享的项目,只读
if(projectReadOnly){
//锁定逻辑走disabledSpread里的
if(this.projectGljSetting.view.lockColumns){
this.projectGljSetting.view.lockColumns = null;
}
disableSpread(this.projectGljSpread);
}
},
initProjectGljSheet:function () {
this.projectGljSheet = this.projectGljSpread .getSheet(0);
this.initSheet(this.projectGljSheet,this.projectGljSetting);
this.projectGljSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onProjectGljSelectionChange);
this.projectGljSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting);
this.projectGljSheet.name('projectGljSheet');
this.projectGljSheet.setRowHeight(0, 45, 1);
},
initMixRatio:function () {
let me = projectGljObject;
if(me.mixRatioSpread==null){
me.initMixRatioSpread();
if(!projectReadOnly){
me.initRightClick();
}
}
},
initMixRatioSpread:function () {
this.mixRatioSpread = SheetDataHelper.createNewSpread($("#mix_ratio_sheet")[0]);
sheetCommonObj.spreadDefaultStyle(this.mixRatioSpread);
this.mixRatioSheet = this.mixRatioSpread .getSheet(0);
this.initSheet(this.mixRatioSheet,this.mixRatioSetting);
this.mixRatioSheet.name('mixRatioSheet');
this.mixRatioSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMixRatioRangeChange);
if(projectReadOnly){
if(this.mixRatioSetting.view.lockColumns){
this.mixRatioSetting.view.lockColumns = null;
}
disableSpread(this.mixRatioSpread);
}
},
initMaterialTreeSheet:function () {
this.materialTreeSheet = this.projectGljSpread.getSheet(1);
this.materialTreeSetting = this.createMaterialTreeSheetSetting();
this.materialTree = cacheTree.createNew(this);
this.materialTreeController = TREE_SHEET_CONTROLLER.createNew(this.materialTree, this.materialTreeSheet, this.materialTreeSetting);
this.materialTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, this.onSelectionChange);
this.materialTreeSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting);
this.materialTreeSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onProjectGLJValueChange);
this.materialTreeSheet.name('materialTreeSheet');
if(projectReadOnly && this.materialSetting.view.lockColumns){
if(this.materialSetting.view.lockColumns){
this.materialSetting.view.lockColumns = null;
}
}
},
createMaterialTreeSheetSetting:function () {
return sheetCommonObj.transferToTreeSetting(this.materialSetting,this.materialTreeSetting);
},
unitPriceFileInit:function() {
let me = this;
let projectGLJ = projectObj.project.projectGLJ;
let data = projectGLJ.datas;
me.usedTenderList = data.usedTenderList !== undefined ? data.usedTenderList : [];
me.usedUnitPriceInfo = data.constData.usedUnitPriceInfo !== undefined ?
data.constData.usedUnitPriceInfo : {};
$("#current-name").text(me.usedUnitPriceInfo.name);
let usedCount = me.usedTenderList.length <= 0 ? 1 : me.usedTenderList.length;
$("#used-project-count").text(usedCount);
},
getUsedTenderInfo:function() {
return projectGljObject.usedTenderList.join("
");
},
filterLibGLJForMixRatio:function () {
let me = this;
if(me.selectedProjectGLJ){
let showTypes = [];
if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){//对于主材,只显示没有组成物并且除了自已的主材
showTypes = [gljType.MAIN_MATERIAL];
}else if(_.includes(gljUtil.hasCompMaterial,me.selectedProjectGLJ.type)){//混凝土、砂浆、配合比
showTypes = [gljType.GENERAL_MATERIAL];
}else if(_.includes(gljUtil.hasCompMachine,me.selectedProjectGLJ.type)){//me.selectedProjectGLJ.type == gljType.GENERAL_MACHINE//机械中有组成物的类型
showTypes = gljUtil.machineComposition;
}
gljOprObj.gljLibSheetData = _.filter(gljOprObj.gljLibSheetData, function (item) {
if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){
let p_index = gljOprObj.getIndex(me.selectedProjectGLJ,gljKeyArray);
let i_index = gljOprObj.getIndex(item,gljLibKeyArray);
return item.gljType == gljType.MAIN_MATERIAL &&item.component.length == 0 && p_index!=i_index
}else {
return _.includes(showTypes,item.gljType);
}
});
}
},
addMixRatio:function () {
let me = this, projectGLJ = projectObj.project.projectGLJ;
for(let mix of me.mixRatioData){
let m_key = gljOprObj.getIndex(mix, gljKeyArray);
let t_index = gljOprObj.GLJSelection.indexOf(m_key);
t_index != -1?gljOprObj.GLJSelection.splice(t_index,1):'';
}
projectGLJ.addMixRatio(gljOprObj.GLJSelection,function (mixRatios) {
me.showMixRatioData();//这里添加的组成物的消耗量默认都是0,所以对父工料机的价格不会有影响,不用触发计算
projectGLJ.loadData(function () {
me.showProjectGljData();
gljOprObj.showRationGLJSheetData();
me.onUnitFileChange(me.selectedProjectGLJ);
});
});
},
showMixRatioData:function () {
let me = this,gljId = null,gljType = null;
let sheet = me.projectGljSpread.getActiveSheet();
let oldSel = me.mixRatioSheet.getSelections()[0];
if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表
let sel = me.projectGljSheet.getSelections()[0];
let srow = sel.row == -1||sel.row == ""?0:sel.row;
if(me.projectGljSheetData.length>srow){
gljId = me.projectGljSheetData[srow].id;
gljType = me.projectGljSheetData[srow].type;
}
}else if(sheet.name() == 'materialTreeSheet'){
if(this.materialTree.selected){
gljId = this.materialTree.selected.data.id;
gljType = this.materialTree.selected.data.type;
}
}
if(compositionTypes.indexOf(gljType)==-1){//如果不是有组成物的类型,工料机id设置为空,组成物表设置为空
gljId = null
}
projectObj.project.projectGLJ.getRatioData(gljId,function (data) {
if(gljId !== projectObj.project.projectGLJ.getRatioId){//两个id不一致说明不是最新的请求,不用往下执行。
return;
}
let rationList =[];
for(let glj of data){
rationList.push(me.getMixRatioSheetData(glj)) ;
}
me.mixRatioData = rationList;
me.mixRatioSheet.setRowCount(0);
sheetCommonObj.showData(me.mixRatioSheet, me.mixRatioSetting,me.mixRatioData);
me.mixRatioSheet.setRowCount(me.mixRatioData.length);
me.mixRatioSheet.setSelection(oldSel.row==-1?0:oldSel.row,oldSel.col,oldSel.rowCount,oldSel.colCount);
})
},
getMixRatioSheetData:function (glj) {
let data ={
id:glj.id,
mix_ratio_id:glj.ratio_data.id,
code:glj.code,
name:glj.name,
specs:glj.specs,
unit:glj.unit,
type:glj.type,
short_name:projectObj.project.projectGLJ.getShortNameByID(glj.type),
consumption:glj.ratio_data.consumption,
unit_price:glj.unit_price,
connect_key:glj.ratio_data.connect_key
};
gljOprObj.setGLJPrice(data,glj);
return data;
},
onProjectGljEditStarting:function (sender, args) {
let me = projectGljObject;
let row = args.row;
let col = args.col;
if(me.projectGljEditChecking(row,col)==false){
args.cancel = true;
}
},
projectGljEditChecking:function (row,col,isPaste=false) {//return false表示不能编辑
let me = projectGljObject;
let data = null, setting=null;
let sheet = me.projectGljSpread.getActiveSheet();
if(sheet.name() == 'projectGljSheet'){
if(row>=me.projectGljSheetData.length) return false;
data = me.projectGljSheetData[row];
setting = me.projectGljSetting;
}else if(sheet.name() == 'materialTreeSheet'){
data = me.materialTree.selected.data;
setting = me.materialSetting;
let notEditId= ['GC','GJ','MC','SN','SZ'];
if(notEditId.indexOf(data.id)!= -1){
return false;
}
}
let dataCode = setting.header[col].dataCode;
let lockColumns = setting.view.lockColumns;
if(lockColumns.indexOf(col)!= -1){
return false;
}
if(isPaste == false &&(dataCode=='is_adjust_price'||dataCode=='is_evaluate'||dataCode=='is_main_material')){//除了粘贴,拖动填充等操作,其它的都不能编辑
return false;
}
if(dataCode=='basePrice'||dataCode=='marketPrice'||dataCode=='supply'){//有组成物时,市场单价、定额价、供货方式不能修改
if (data.ratio_data && data.ratio_data.length > 0){
return false;
}
if(dataCode=='basePrice'&&data.is_add!=1){//如果不是新增,定额价不可修改。
return false;
}
}
if(dataCode == 'supply_quantity'){
if (data.supply != 1) {// 如果为部分甲供则甲供数量需要可编辑,其它的都不能编辑
return false;
}
}
if(dataCode == 'materialCoe'){//三材类别为空时,三材系数应只读,不允许输入。
if(data.materialType == undefined || data.materialType == null||data.materialType==''){
return false;
}
}
return true;
},
onSelectionChange:function (){
let me = projectGljObject;
me.showMixRatioData();
me.materialTreeSheet.repaint();
},
onProjectGljSelectionChange:function (sender, args) {
let me = projectGljObject;
let newSel = args.newSelections[0];
let oldSel = args.oldSelections?args.oldSelections[0]:{};
if(newSel.row != oldSel.row){
me.projectGljRowChang();
}
me.projectGljSheet.repaint();
},
projectGljRowChang:function(row){
let me = projectGljObject;
let sel = me.mixRatioSheet.getSelections()[0];
sel.row = -1;
sel.col = 0;
sel.rowCount = 1;
sel.colCount = 1;
me.showMixRatioData();
},
rightClickCallback:function (row) {
let me = projectGljObject;
let sheet = me.projectGljSpread.getActiveSheet();
if(sheet.name() == 'projectGljSheet'){
me.projectGljRowChang(row);
}else if(sheet.name() == 'materialTreeSheet'){
me.materialTreeController.setTreeSelected(me.materialTreeController.tree.items[row]);
}
},
onProjectGljRangeChange:function (sender,info) {
let me = projectGljObject;
let changeInfo=[];
let canChange = true;
if(info.action == GC.Spread.Sheets.RangeChangedAction.clear){
if(me.projectGljEditChecking(info.row,info.col) == false){
canChange = false;
}else {
info.newValue = null;
me.onProjectGLJValueChange(sender,info);
return ;
}
}
for(let c of info.changedCells){
let value= info.sheet.getCell(c.row, c.col).text();
changeInfo.push({row:c.row,col:c.col,value:value});
if(me.projectGljEditChecking(c.row,c.col,true)==false){//如果不能编辑
canChange = false;
break;
}
if (!me.checkData(c.col,me.projectGljSetting,value)) {
alert('输入的数据类型不对,请重新输入!');
canChange = false;
break;
}
}
if(canChange == false){//恢复原来的值
info.sheetName =="materialTreeSheet"?me.showMaterialTreeData():me.showProjectGljData();
}else if(info.sheetName =="projectGljSheet"){
me.batchUpdateProjectGLJ(changeInfo,info.sheetName);
}
},
onMixRatioRangeChange:function (sender,info){
let me = projectGljObject;
let canChange = true;
let changeInfo=[];
if (info.action == GC.Spread.Sheets.RangeChangedAction.clear) {
info.newValue = 0;
me.onMixRatioValueChange(sender,info);
info.sheet.getCell(info.row, info.col).text(0);
return ;
}
for(let c of info.changedCells){
let value = info.sheet.getCell(c.row, c.col).text();
if (!me.checkData(c.col,me.mixRatioSetting,value)) {
alert('输入的数据类型不对,请重新输入!');
canChange = false;
break;
}else {
changeInfo.push({row:c.row,col:c.col,value:value});
}
}
if(canChange == false){//数据类型不对
me.showMixRatioData();
}
if(changeInfo.length > 0){
me.batchUpdateConsumption(changeInfo);
}
},
batchUpdateProjectGLJ:function(changeInfo,sheetName){
let projectGLJ = projectObj.project.projectGLJ;
let me = projectGljObject;
let propertyCells=[],priceCells=[];
let setting = sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting;
for(let c of changeInfo){
c.dataCode = setting.header[c.col].dataCode;
if(c.dataCode == 'basePrice'||c.dataCode=='marketPrice'){
priceCells.push(c);
}else {
propertyCells.push(c);
}
}
me.batchUpdateGLJProperty(propertyCells,sheetName,function () {
//价格属于单价文件表,如果与项目工料机的其它属性一起的话计算起来会比较复杂,同时出现价格与其它属性一起更新的情况也会比较少;
projectGLJ.batchUpdatePrice(priceCells,sheetName,function (impactList) {
me.refreshBySheetName(sheetName);
gljOprObj.refreshView();
});
});
},
refreshBySheetName:function (sheetName) {
let me = projectGljObject;
if(sheetName =="projectGljSheet"){
me.showProjectGljData();
}else if(sheetName =="materialTreeSheet"){
me.showMaterialTreeData();
}
},
batchUpdateGLJProperty:function (changeInfo,sheetName,callback) {
let me = projectGljObject,updateMap = {};
let projectGLJ = projectObj.project.projectGLJ;
for(let c of changeInfo){
let recode = sheetName =="materialTreeSheet"?me.materialTree.items[c.row].data:me.projectGljSheetData[c.row];
if(recode[c.dataCode] == c.value){
continue;
}
me.getUpdateData(recode.id,c.value,c.dataCode,recode.quantity,updateMap);
}
if(_.isEmpty(updateMap)){
callback?callback():'';
return;
}
projectGLJ.batchUpdateGLJProperty(updateMap,callback);
},
getUpdateData :function (id,value,dataCode,quantity,updateMap) {
let me = projectGljObject;
let supplyMap = {"自行采购":0,"部分甲供":1,"完全甲供":2,"甲定乙供":3};
let materialMap = {"钢材":1,"钢筋":2,"木材":3,"水泥":4,"标准砖":5};
let data = updateMap[id]?updateMap[id]:{};
//供货方式 和三材类型 粘贴和填充过来的数据,要做对应转换,因为这里value只是中文文本,并不是实际的值
// 如果是供货方式则需要处理数据
if (dataCode === 'supply') {
if(supplyMap[value]!==undefined||supplyMap[value]!==null){
value = supplyMap[value];
}
data.supply_quantity = me.getSupplyQuantity(value,quantity);
}
if(dataCode === 'supply_quantity'){//修改数量需做4舍5入
value = scMathUtil.roundForObj(value,getDecimal('glj.quantity'));
}
if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){
value = value? 1:0;
}
if(dataCode === 'materialType'){//三材类型要做对应转换,因为这里value只是中文文本,并不是实际的值
if(materialMap[value]!==undefined||materialMap[value]!==null){
value = materialMap[value];
}
if(value == null || value==""){//删除三材类别时,清空三材系数
value = null;
data.materialCoe = null;
}
}
if(dataCode == 'materialCoe'){
value = scMathUtil.roundForObj(value,getDecimal("material"));
}
data[dataCode] = value ;
updateMap[id] = data;
},
batchUpdateConsumption:function(changeInfo){
let projectGLJ = projectObj.project.projectGLJ;
let me = projectGljObject;
let updateMap = {},updateData = [],parentBasePrice = 0,parentMarketPrice = 0;
let parentKey = '',unit_price_file_id=null;
for(let c of changeInfo){
let record = me.mixRatioData[c.row];
let value = scMathUtil.roundForObj(c.value,getDecimal("glj.quantity"));
updateMap[record.mix_ratio_id] = {consumption: value,record:record };
updateData.push({type:'mix_ratio',query:{id:record.mix_ratio_id},doc:{consumption:value}});
parentKey = record.connect_key;
unit_price_file_id = record.unit_price.unit_price_file_id;
}
for(let sub of me.mixRatioData){
let marketPrice = scMathUtil.roundForObj(sub.unit_price.market_price,getDecimal("process"));
let basePrice = scMathUtil.roundForObj(sub.unit_price.base_price,getDecimal("process"));
let consumption = updateMap[sub.mix_ratio_id]?updateMap[sub.mix_ratio_id].consumption:scMathUtil.roundForObj(sub.consumption,getDecimal("glj.quantity"));
parentMarketPrice = scMathUtil.roundForObj(marketPrice*consumption + parentMarketPrice,getDecimal("process"));
parentBasePrice = scMathUtil.roundForObj(basePrice*consumption + parentBasePrice,getDecimal("process"));
}
parentBasePrice = scMathUtil.roundForObj(parentBasePrice,getDecimal("glj.unitPrice"));
parentMarketPrice = scMathUtil.roundForObj(parentMarketPrice,getDecimal("glj.unitPrice"));
updateData.push({type:'parent',connect_key:parentKey,base_price:parentBasePrice,market_price:parentMarketPrice,unit_price_file_id:unit_price_file_id});
projectGLJ.batchUpdateConsumption(updateData,updateMap,function () {
//更新人材机汇总表
let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标
let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
me.refreshParentData(prow,prowData.id);
me.onUnitFileChange(updateData);
});
},
showProjectGljData:function () {
this.projectGljSpread.setActiveSheetIndex(0);
let sel = this.projectGljSheet.getSelections()[0];
let oldData = sel.row0){
gljList = _.filter(gljList,function (item) {
return me.displayTypeFilter(item);
});
}
return gljList;
},
displayTypeFilter:function (item) {
let me = this;
if(item.quantity !== 0 && item.quantity !== '0'){//过滤掉消耗量为0的工料机
if(me.displayType == filterType.ALL){//所有工料机
return true;
}else if(filterTypeArray.indexOf(me.displayType) != -1){//人工、材料、机械、主材、设备
let typeString = item.type+"";
return typeString.startsWith(me.displayType);
}else if(me.displayType == filterType.FBFX){//“分部分项总消耗量”≠0的工料机行
return item.subdivisionQuantity !== 0 && item.subdivisionQuantity !== '0';
}else if(me.displayType == filterType.TECH){//筛选“措施项目总消耗量”≠0的工料机行
return item.techQuantity !== 0 && item.techQuantity !== '0';
}else if(me.displayType == filterType.JGCL){//筛选“供货方式”=“完全甲供”或“部分甲供”的工料机行
return item.supply == supplyType.WQJG || item.supply == supplyType.BFJG;
}else if(me.displayType == filterType.ZGCL){//筛选“是否暂估”=“是”的工料机行。
return item.is_evaluate == 1;
}else if(me.displayType == filterType.ZYCL){//筛选“主要材料”=“是”的工料机行。
return item.is_main_material == 1;
}
}
return false;
},
getSheetDataByGLJ:function (glj) {
let projectGLJ = projectObj.project.projectGLJ;
let materialIdList = projectGLJ.datas.constData.materialIdList;
let data ={
id:glj.id,
code:glj.code,
name:glj.name,
specs:glj.specs,
unit:glj.unit,
type:glj.type,
short_name:projectGLJ.getShortNameByID(glj.type),
quantity:glj.quantity,
supply:glj.supply,
supply_quantity:glj.supply_quantity,
materialType:glj.materialType,
materialCoe:glj.materialCoe,
delivery:glj.delivery,
delivery_address:glj.delivery_address,
is_adjust_price:glj.is_adjust_price,
ratio_data:glj.ratio_data,
is_add:glj.unit_price.is_add,
bgColour:'white',
techQuantity:glj.techQuantity,
subdivisionQuantity:glj.subdivisionQuantity,
remark:glj.remark
};
gljOprObj.setGLJPrice(data,glj);
data.is_main_material = glj.is_main_material == 1?1:0;
//供货方式为完全甲供时设置甲供数量为总消耗量
if (data.supply == 2) {
data.supply_quantity = glj.quantity;
}
// 只有材料才显示是否暂估
if (materialIdList.indexOf(glj.type) >= 0) {
data.is_evaluate = glj.is_evaluate;
}
if(glj.materialCoe !== null && glj.materialCoe !==undefined){
data.materialCoe = scMathUtil.roundForObj(glj.materialCoe,getDecimal("material"));
}
//bgColour
if(data.basePrice == data.marketPrice){//如果定额价等于市场价时,改底色。 优先度低于有组成物时的底色
data.bgColour = "#C4CAFB";
}
if (gljUtil.notEditType.indexOf(glj.type) >= 0) {
if (data.ratio_data && data.ratio_data.length > 0){//有组成物时
//设置底色
data.bgColour = "#E0E0E0";
}
}
return data;
},
refreshProjectGljRow:function (row) {
let me = projectGljObject;
let rowData = me.projectGljSheetData[row];
let glj = projectObj.project.projectGLJ.getByID(rowData.id);
let newRow = null;
if(glj){
newRow = me.getSheetDataByGLJ(glj);
}
if(me.displayTypeFilter(newRow) == true){
me.projectGljSheetData[row] = newRow;
sheetCommonObj.showRowData(this.projectGljSheet, this.projectGljSetting,row,this.projectGljSheetData);
}else {
me.projectGljSheetData.splice(row,1);
me.projectGljSheet.deleteRows(row,1);
me.showMixRatioData();
}
//me.projectGljSheetData[row] = me.getSheetDataByGLJ(glj);
},
initSheet: function (sheet,setting) {
var me = this;
sheetCommonObj.initSheet(sheet, setting, 30);
sheet.bind(GC.Spread.Sheets.Events.ValueChanged, me.onSheetValueChange);
},
onSheetValueChange:function (e,info) {
let me = projectGljObject;
if(info.sheetName=='projectGljSheet'){
me.onProjectGLJValueChange(e,info);
}else if(info.sheetName == 'mixRatioSheet'){
me.onMixRatioValueChange(e,info);
}
},
onMixRatioValueChange:function (e,info){
let composition = projectObj.project.composition;
let me = projectGljObject,row = info.row, col = info.col;
let dataCode = me.mixRatioSetting.header[col].dataCode;
let recode = me.mixRatioData[row];
let value = info.newValue;
let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
if (!me.checkData(col,me.mixRatioSetting,value)) {
alert('输入的数据类型不对,请重新输入!');
me.mixRatioSheet.setValue(row, col, info.oldValue);
return false;
}
value = scMathUtil.roundToString(value,getDecimal("glj.quantity"));
let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('modify', row, value);
let updateData ={id: recode.mix_ratio_id, field: 'mix_ratio.' + dataCode, value: value, market_price: parentMarketPrice, base_price: parentBasePrice};
let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标
let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
composition.updateConsumption(updateData,recode,prowData.id,function (sid) {
/* if(parentSheet.name() == 'projectGljSheet'){ 之前是单行刷新,父工料机与组成物对应的工料机分开刷,发现这样比整个刷新慢所以先整个刷新,当以后数据量大的时候再测试
me.refreshProjectGljRowByID(sid);
}*/
projectObj.project.projectGLJ.calcQuantity();
me.refreshParentData(prow,prowData.id,sid);
me.onUnitFileChange(recode);
});
},
refreshParentData:function (row,pid,sid) {
let me = this;
let sheet = me.projectGljSpread.getActiveSheet();
let parantData = null;
if(sheet.name() == 'projectGljSheet'){
me.showProjectGljData();// me.refreshProjectGljRow(row) 这里原来是分开刷新的,现在整个统一刷新,先留着
//parantData = _.find(); //me.projectGljSheetData[row];
}else {
me.showMaterialTreeData();
//parantData = me.materialTree.items[row].data;
}
let pglj = _.find(projectObj.project.projectGLJ.datas.gljList,{'id':pid});
parantData = pglj?me.getSheetDataByGLJ(pglj):null;
//projectObj.project.projectGLJ.datas.gljList
// 更新组成物缓存
projectObj.project.composition.loadData();
//先查找使用了父项目工料机的定额工料机
let updateNodes=[];
let ration_gljs = _.filter(projectObj.project.ration_glj.datas,{'projectGLJID':pid});
for(let rg of ration_gljs){
let node = projectObj.project.mainTree.getNodeByID(rg.rationID);
if(node){
updateNodes.push(node);
}
}
//或者是使用了父项目工料机的工料机类型的定额
let rations = _.filter(projectObj.project.Ration.datas,{'type':3,'projectGLJID':pid});
for(let r of rations){
let r_node = projectObj.project.mainTree.getNodeByID(r.ID);
if(r_node){
r_node.data.marketUnitFee = parantData?parantData.marketPrice:'';//parentMarketPrice;//这里用显示的价格
updateNodes.push(r_node);
}
}
if(sid){
let subRations = calcTools.getRationsByProjectGLJ(sid);
updateNodes = updateNodes.concat(subRations);
}
if(updateNodes.length>0){
projectObj.project.calcProgram.calcNodesAndSave(updateNodes,function () {
projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
installationFeeObj.calcInstallationFee();//计算安装增加费
});
}
gljOprObj.refreshView();
},
onUnitFileChange:function (data) {
projectObj.project.markUpdateProject({projectID:projectObj.project.ID(),'unitFileID':socketObject.getUnitFileRoomID()},"unitFile",function(){
//socket.emit('unitFileChangeNotify', JSON.stringify(data));
socket.emit('unitFileChangeNotify', {projectID:projectObj.project.ID(),userID:userID,'unitFileID':socketObject.getUnitFileRoomID()});
});
},
deleteMixRatio:function (row) {
let me = this, deleteRecode = me.mixRatioData[row];
let consumption = deleteRecode.consumption;
let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('delete', row);
let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表
let prow= parentSheet.getActiveRowIndex();//取父机械或组成物的下标
let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data;
let updateData = {id: deleteRecode.mix_ratio_id, field: 'mix_ratio.consumption' , value: 0, market_price: parentMarketPrice, base_price: parentBasePrice};
projectObj.project.composition.deleteComposition(updateData,deleteRecode,prowData.id,function () {
_.remove(me.mixRatioData,{"mix_ratio_id":deleteRecode.mix_ratio_id});
me.refreshParentData(prow,prowData.id);
me.mixRatioSheet.deleteRows(row,1);
me.onUnitFileChange(deleteRecode);
});
},
getCompositionSumPrice : function(scene, affectRow, newValue = 0) {
let me = this;
let parentMarketPrice = 0;
let parentBasePrice = 0;
for(let i = 0;i < me.mixRatioData.length;i++){
let ratio = me.mixRatioData[i];
let marketPrice = ratio.unit_price.market_price;
let basePrice = ratio.unit_price.base_price;
// 如果是删除则忽略即将被删除的行数据
if (scene === 'delete' && affectRow === i) {
continue;
}
let consumption = i === affectRow ? newValue : ratio.consumption;
parentMarketPrice += operationWithRound(consumption,marketPrice,"glj.unitPrice","*");
parentBasePrice += operationWithRound(consumption,basePrice,"glj.unitPrice","*");
}
parentMarketPrice = parentMarketPrice.toDecimal(getDecimal("glj.unitPrice"));
parentBasePrice = parentBasePrice.toDecimal(getDecimal("glj.unitPrice"));
return [parentMarketPrice, parentBasePrice];
},
onProjectGLJValueChange:function (e,info) {//me.projectGljSetting
let projectGLJ = projectObj.project.projectGLJ;
let me = projectGljObject,row = info.row, col = info.col;
let setting = info.sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting;
let dataCode = setting.header[col].dataCode;
let recode = info.sheetName =="materialTreeSheet"?me.materialTree.selected.data:me.projectGljSheetData[row];
let value = info.newValue;
if(info.newValue === undefined ){
return;
}
if (value&&!me.checkData(col,setting,value)) {
alert('输入的数据类型不对,请重新输入!');
info.sheetName =="materialTreeSheet"?me.materialTreeController.refreshTreeNode([me.materialTree.selected]):me.refreshProjectGljRow(row);
return ;
}
let callback=function (impactList) {
info.sheet.suspendPaint();
info.sheet.suspendEvent();
if(info.sheetName =="materialTreeSheet"){
me.showMaterialTreeData();
}else {
me.refreshProjectGljRow(row);
for(let g of impactList){
me.refreshProjectGljRowByID(g.id,row);
}
}
info.sheet.resumeEvent();
info.sheet.resumePaint();
if (dataCode === 'supply' || dataCode === 'supply_quantity'){ // basePrice、marketPrice 有自己的计算代码,无需走这里重复计算
let rations = calcTools.getRationsByProjectGLJ(recode.id);
projectObj.project.calcProgram.calcNodesAndSave(rations, function () {
projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
});
}
gljOprObj.refreshView();
};
if(dataCode=='basePrice'||dataCode=='marketPrice'){//修改市场价和修改定额价时需要重新记算很多受影响的树节点,现在改成与定字额工料机那里调相同的方法。
let editField = dataCode === 'basePrice'?"base_price":"market_price";
projectObj.project.projectGLJ.updatePrice(recode,editField,value,'pg',callback);
}else {
let extend = {};
// 如果是供货方式则需要处理数据
if (dataCode === 'supply') {
extend.supply_quantity = me.getSupplyQuantity(value, recode.quantity);
}
if(dataCode === 'supply_quantity'){//修改数量需做4舍5入
value= scMathUtil.roundForObj(value,getDecimal('glj.quantity'));
}
if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){
if(value == true){
value = 1;
}else if(value == false){
value = 0;
}
}
if(dataCode === 'materialType' && (value == null || value=="")){//删除三材类别时,清空三材系数
value = null;
extend.materialCoe = null;
}
if(dataCode == 'materialCoe'){
value = scMathUtil.roundForObj(value,getDecimal("material"));
}
extend = Object.keys(extend).length > 0 ? JSON.stringify(extend) : '';
if(recode[dataCode] == value) return;
let updateData = {id: recode.id, field: dataCode, value: value, extend: extend};
projectGLJ.pGljUpdate(updateData,callback);
};
},
refreshProjectGljRowByID:function (ID,row) {//row 可以不传,如果row 和 index 相等就不刷新
let me = this;
let index = _.findIndex(me.projectGljSheetData, { 'id': ID});
if(index>=0&&index != row){
me.refreshProjectGljRow(index);
}
},
getSupplyQuantity : function(supplyType, quantity) {
// 自行采购和甲定乙供则把甲供数量设置为0,其余情况则设置为当前总消耗量
let supplyQuantity = supplyType == 0 || supplyType == 3 ? 0 : quantity;
supplyQuantity = parseFloat(supplyQuantity);
return supplyQuantity;
},
checkData : function(col,setting, value) {
let result = true;
let validator = setting.header[col].validator !== undefined ? setting.header[col].validator : null;
if (validator === null) {
return result;
}
switch (validator) {
case 'number':
let regular = /^\d+(\.\d+)?$/;
result = regular.test(value);
break;
case 'boolean':
let booleanValue = [true, false];
result = booleanValue.indexOf(value) >= 0;
break;
}
return result;
},
getProjectGLJSelected:function () {
let me = projectGljObject;
let sheet = me.projectGljSpread.getActiveSheet();
let selectedProjectGLJ = null;
if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表
let sel = me.projectGljSheet.getSelections()[0];
if(sel.row != -1 && me.projectGljSheetData.length>sel.row){
selectedProjectGLJ = me.projectGljSheetData[sel.row]
}
}else if(sheet.name() == 'materialTreeSheet' ){
if(me.materialTree.selected){
selectedProjectGLJ = me.materialTree.selected.data;
}
}
return selectedProjectGLJ;
},
initRightClick : function() {
let activeSheet = this.mixRatioSheet;
let me = this;
$.contextMenu({
selector: '#mix_ratio_sheet',
build: function ($trigger, e) {
me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.mixRatioSpread);
return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport ||
me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
},
items: {
"deleteMixRatio": {
name: "删除",
icon: 'fa-trash-o',
disabled: function () {
return me.rightClickTarget.row === undefined;
},
callback: function (key, opt) {
let row = me.rightClickTarget.row;
me.deleteMixRatio(row);
}
},
"addMixRatio":{
name: '添加',
icon: 'fa-sign-in',
disabled: function () {
let projectGLJ = projectGljObject.getProjectGLJSelected();
return !_.includes(compositionTypes,projectGLJ.type);
},
callback: function (key, opt) {
me.selectedProjectGLJ = projectGljObject.getProjectGLJSelected();
getGLJData('addMix');
}
}
}
});
},
changeFileCallback:function(){
projectGljObject.unitPriceFileInit();
projectGljObject.refreshDataSheet();
gljOprObj.refreshView();
projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll,function () {
if(socketObject.roomInfo){
let data ={
projectID:projectObj.project.ID(),
oldRoom:socketObject.roomInfo.unitFile,
newRoom:socketObject.getUnitFileRoomID(),
userID:userID,
name:'unitFile'
};
socket.emit('changeNewRoom',data);
socketObject.roomInfo.unitFile = socketObject.getUnitFileRoomID();
}
});
},
calcPartASupplyFeeByProjectGLJs: function (projectGLJsArr) {
for (let pGLJ of projectGLJsArr){
if (pGLJ.supply == supplyType.BFJG){
let rations = calcTools.getRationsByProjectGLJ(pGLJ.id);
projectObj.project.calcProgram.calcNodesAndSave(rations, function () {
projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
});
}
}
},
checkUnitFileName:function (name,callback) {
let projectGLJ = projectObj.project.projectGLJ;
projectGLJ.checkUnitFileName(name,function (data) {
if(data){
$("#save-as-tips").text('已存在同名单价文件').show();
$('#save-as-confirm').attr("disabled","disabled");
}else {
$("#save-as-tips").hide();
$('#save-as-confirm').removeAttr("disabled");
if(callback) callback();
}
});
},
initFilterTypeList:function () {//初始化人材机汇总工料机类型过滤列表
let htmlString = '';
for(let t of this.displayTypeMap){
htmlString += ''+t.text+'';
}
$('#ALL').after(htmlString);
}
};
function getProjectResizeEles() {
let pojGljResizeEles = {};
pojGljResizeEles.id = '#project-glj-main';
pojGljResizeEles.resize = $('#project-glj-main').find('.resize');
pojGljResizeEles.nearElement = $('#project-glj-main').find('.top-content');
pojGljResizeEles.nearSpread = pojGljResizeEles.nearElement.children(".main-data-top");
pojGljResizeEles.farElement = $('#project-glj-main').find('.bottom-content');
pojGljResizeEles.farSpread = pojGljResizeEles.farElement.children().find(".main-data-bottom");
pojGljResizeEles.nav = pojGljResizeEles.farElement.children('ul.nav');
return pojGljResizeEles;
}
function loadProjectGljSize() {
let me = projectGljObject;
let pojGljResizeEles = getProjectResizeEles();
loadSize(pojGljResizeEles, 'height', function () {
me.projectGljSpread?me.projectGljSpread.refresh():'';
me.mixRatioSpread?me.mixRatioSpread.refresh():'';
});
}
//从其他建设项目中复制中,建设项目的文件层次结构名称和顺序
function getFileHierarchyInfo(treeData){
let tree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1});
tree.loadDatas(treeData);
let items = tree.items;
let rst = [];
function getFileHierarchyName(node){
let nodeName = node.data.name;
let name = [];
while (node.parent){
name.push(node.parent.data.name ? node.parent.data.name : '');
node = node.parent;
}
name = name.reverse();
name.push(nodeName);
return name.join('\\');
}
for(let node of items){
if(node.children.length === 0 ){//project
rst.push({ID: node.data.ID, fileHierarchyName: getFileHierarchyName(node)})
}
}
return rst;
}
$(function () {
let pojGljResizeEles = getProjectResizeEles();
slideResize(pojGljResizeEles, {min: 170, max: 700}, 'height', function () {
projectGljObject.projectGljSpread.refresh();
projectGljObject.mixRatioSpread?projectGljObject.mixRatioSpread.refresh():'';
});
$('#tab_project_glj').on('shown.bs.tab', function (e) {
sessionStorage.setItem('mainTab', '#tab_project_glj');
let me = projectGljObject;
$(e.relatedTarget.hash).removeClass('active');
if(me.projectGljSpread==null){
me.initProjectGljSpread();
}
me.unitPriceFileInit();
me.initMixRatio();
//projectObj.project.projectGLJ.calcQuantity(); 在工程量有更新的地方调用
me.refreshDataSheet();
loadProjectGljSize();
});
/* $('#ration_link').on('shown.bs.tab', function (e) {
let me = projectGljObject;
me.showTag='ration';
me.showProjectGljData();
});
$('#mix_ratio_link').on('shown.bs.tab', function (e) {
let me = projectGljObject;
me.showTag='mixRatio';
me.showProjectGljData();
me.initMixRatio();
});
$('#machine_ratio_link').on('shown.bs.tab', function (e) {
let me = projectGljObject;
me.showTag='machine';
me.showProjectGljData();
me.initMixRatio();
});*/
$('#pop-used-list').tooltip({
placement: "bottom",
html: true,
trigger: "hover | focus",
title: projectGljObject.getUsedTenderInfo
}
);
// 单价文件切换弹框
$('#change-unitFile').on('shown.bs.modal', function () {
let rootProjectID = projectInfoObj.projectInfo.property.rootProjectID;
// 获取切换单价文件相关数据
$.ajax({
url: '/glj/get-project-info',
type: 'post',
data: {project_id: scUrlUtil.GetQueryString('project'),rootProjectID:rootProjectID},
dataType: 'json',
success: function (response) {
if (response.err === 1) {
alert('数据传输错误!');
return false;
}
let data = response.data;
projectGljObject.changeInfo = data;
$("#current-project-name").text(data.currentProjectName);
// 本项目中的单价文件
if (data.self.length > 0) {
let selfFileHtml = '';
for (let tmp of data.self) {
let select = usedUnitPriceInfo === tmp.id ? ' selected="selected"' : '';
selfFileHtml += '';
}
$("#self-file").html(selfFileHtml);
}
// 其他建设项目数据
let newDataOther = [];
if (data.other.length > 0) {
//转换成按项目管理顺序,名称包含文件夹层次
let fileHierarchyDatas = getFileHierarchyInfo(data.treeData);
for(let fileHierarchyData of fileHierarchyDatas){
let projData = _.find(data.other, {ID: fileHierarchyData.ID});
if(projData){
projData.name = fileHierarchyData.fileHierarchyName;
newDataOther.push(projData);
}
}
data.other = newDataOther;
let otherProjectHtml = '';
let otherFileHtml = '';
for (let tmp of data.other) {
otherProjectHtml += '';
otherFileData[tmp.ID] = tmp.unitPriceList;
if (otherFileHtml !== '') {
continue;
}
for (let unitPrice of tmp.unitPriceList) {
otherFileHtml += '';
}
}
$("#other-project").html(otherProjectHtml);
$("#other-file").html(otherFileHtml);
}
}
});
});
// 单价文件切换确认
$("#change-file-confirm").click(function () {
let type = $("input[name='change-type']:checked").val();
type = parseInt(type);
let changeUnitPriceId = 0;
$('#change-unitFile').modal("hide");
if (type === 0) {
// 从本项目中选择
changeUnitPriceId = $("#self-file").val();
if(!changeUnitPriceId){
alert('单价文件不可为空');
}
submitFileChange(changeUnitPriceId,type);
} else {
// 从其他项目中复制
changeUnitPriceId = $("#other-file").val();
let newName = $("#other-file").children("option:selected").text();
projectObj.project.projectGLJ.checkUnitFileName(newName,function (need_rename) {
if(need_rename){
$("#rename-unitFile").modal({show:true});
$("#newUnitFileID").val(changeUnitPriceId);
$("#newUnitFileName").val(newName);
}else {
submitFileChange(changeUnitPriceId,type);
}
});
}
function submitFileChange(changeUnitPriceId,type) {
let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: type};
projectObj.project.projectGLJ.changeFile(data,function () {
projectGljObject.changeFileCallback();
})
}
});
// 单价文件选项切换
$("input[name='change-type']").change(function () {
let type = $(this).val();
type = parseInt(type);
$("#change-unitFile .option").hide();
if (type === 0) {
$(".option.select").show();
} else {
$(".option.copy").show();
}
});
$("#unitFile-save-as").on('shown.bs.modal', function () {
// 获取当前建设项数据
$("#save-as-name").val(projectGljObject.usedUnitPriceInfo.name + '副本');
projectGljObject.checkUnitFileName(projectGljObject.usedUnitPriceInfo.name + '副本');
});
// 从其他建设项目中复制 选择建设项目
$("#other-project").change(function () {
let projectId = $(this).val();
if (otherFileData[projectId] === undefined) {
return false;
}
let otherFileHtml = '';
for (let unitPrice of otherFileData[projectId]) {
otherFileHtml += '';
}
$("#other-file").html(otherFileHtml);
});
$('#save-as-name').change(function () {
projectGljObject.checkUnitFileName(this.value);
});
$('#newUnitFileName').change(function () {
let projectGLJ = projectObj.project.projectGLJ;
projectGLJ.checkUnitFileName(this.value,function (data) {
if(data){
$("#renameError_unitFile").text('已存在同名单价文件').show();
//$('#renameUnitFileConfirm').attr("disabled","disabled");
}else {
$("#renameError_unitFile").hide();
// $('#renameUnitFileConfirm').removeAttr("disabled");
}
});
});
$("#renameUnitFileConfirm").click(function () {
let projectGLJ = projectObj.project.projectGLJ;
let newName = $('#newUnitFileName').val();
let changeUnitPriceId = $('#newUnitFileID').val();
projectGLJ.checkUnitFileName(newName,function (data) {
if(data){
$("#renameError_unitFile").text('已存在同名单价文件').show();
//$('#renameUnitFileConfirm').attr("disabled","disabled");
}else {
$("#renameError_unitFile").hide();
$('#rename-unitFile').modal('hide');
// $('#renameUnitFileConfirm').removeAttr("disabled");
let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: 1,newName:newName};
projectObj.project.projectGLJ.changeFile(data,function () {
projectGljObject.changeFileCallback();
})
}
});
});
// 单价文件另存为操作
$("#save-as-confirm").click(function () {
let projectGLJ = projectObj.project.projectGLJ;
let name = $("#save-as-name").val();
if (name === '') {
$("#save-as-tips").text('请填写单价文件名称').show();
return false;
}
let saveData = {name: name, project_id: scUrlUtil.GetQueryString('project')};
projectGljObject.checkUnitFileName(name,function () {
projectGLJ.saveAs(saveData,function () {
projectGljObject.changeFileCallback();
$("#unitFile-save-as").modal("hide");
});
});
});
$("#filterType").on("click","ul li a",function(e){
let children = $('#filterType a');
for(let c of children){
$(c).removeClass('active');
}
$(this).addClass('active');
let me = projectGljObject;
me.displayType = filterType[this.id];
me.refreshDataSheet();
});
});