demo20230512/Browser_Local/js/LCA/DetailSurveyForm/LCAVehicleController.js
2023-05-12 10:20:28 +08:00

618 lines
28 KiB
JavaScript
Raw Permalink Blame History

/*
** Views/Partial/LCA/GasolineEquipment.cshtml is using this controller
*/
angular.module('CarbonFootprint')
.controller('LCAVehicleCtrl', ['$scope', '$http', '$routeParams', 'ParameterCacheService', 'JoinSurveyItemAndParameter', '$q', 'MultiLanguageService', 'ExportCsvService',
function ($scope, $http, $routeParams, ParameterService, JoinService, $q, MultiLanguageService, ExportCsvService) {
// Multi-language resource object
var resource;
var options;
$scope.modalFormOption = {};
$scope.model = [];
$scope.summary = [];
$scope.sumKgCO2e = 0;
$scope.selectedUnit = "";
$scope.$watch('selectRow.toBeEdit.FuelType', function (newValue) {
if (newValue) {
var fuelTypeArray = newValue.split("KgCO2e/");
if (fuelTypeArray.length >= 2) {
$scope.selectedUnit = fuelTypeArray[1];
}
else {
$scope.selectedUnit = "";
}
}
else {
$scope.selectedUnit = "";
}
}, true);
// set $scope.baseUrl
var baseUrl = $scope.baseUrl;
if (typeof (baseUrl) === 'undefined' || baseUrl == null) {
var arr = window.location.href.split("/");
if (arr[3].indexOf('app') == 0)
baseUrl = '';
else
baseUrl = '/' + arr[3];
$scope.baseUrl = baseUrl;
}
$scope.createProcess = function () {
// Create an object & select it
var toBeCreated = {};
var formData = new FormData();
var hasFile = false;
var fileIndex = -1;
var hasPhoto = false;
var photoIndex = -1;
toBeCreated.ID = 0;
toBeCreated.LCAID = $routeParams.LCAID;
toBeCreated.activityDataType = 0;
toBeCreated.emitParaType = 0;
// Reset fuel types and years dropdown list options
$scope.fuelTypes = [];
$scope.years = [];
// For modal form
$scope.selectRow.toBeEdit = toBeCreated;
$scope.selectFile = function (file) {
fileIndex = fileIndex > photoIndex ? fileIndex + 1 : photoIndex + 1;
formData.append('vf' + "_lca" + $routeParams.LCAID + "_" + fileIndex, file);
hasFile = true;
};
$scope.selectPhoto = function (photo) {
photoIndex = fileIndex > photoIndex ? fileIndex + 1 : photoIndex + 1;
formData.append('vp' + "_lca" + $routeParams.LCAID + "_" + photoIndex, photo);
hasPhoto = true;
};
$scope.modalFormOption.show = true;
$scope.dataQualityOption = {};
$scope.dataQualityOption.data = {};
$scope.isEdit = false;
$scope.save = function () {
JoinService.joinAsync([toBeCreated]).then(function () {
//setKgCO2e([toBeCreated]);
$http.post($scope.baseUrl+'/api/Upload', formData, {
transformRequest: angular.identity,
headers: { 'Content-Type': undefined }
}).success(function (urlList) {
if (hasFile)
toBeCreated.ReferenceFileUrl = $scope.baseUrl +urlList[fileIndex];
if (hasPhoto)
toBeCreated.ReferencePhotoUrl = $scope.baseUrl +urlList[photoIndex];
$http.post($scope.baseUrl+'/api/Vehicle/Save/' + $routeParams.LCAID + "/" + toBeCreated.ID, toBeCreated)
.success(function (data) {
data.Area = getArea(options[toBeCreated.ParameterID]);
data.FuelType = getFuelType(options[toBeCreated.ParameterID]);
data.Year = getYear(options[toBeCreated.ParameterID]);
$scope.model.unshift(data);
calcTotalKgCO2e();
$scope.modalFormOption.show = false;
});
});
});
};
};
$scope.editProcess = function (selected) {
var toBeEdit = $scope.selectRow.toBeEdit = angular.copy(selected);
var formData = new FormData();
var hasFile = false;
var fileIndex = -1;
var hasPhoto = false;
var photoIndex = -1;
// Reset fuel types and years dropdown list options
$scope.fuelTypes = [];
$scope.years = [];
$scope.selectFile = function (file) {
fileIndex = fileIndex > photoIndex ? fileIndex + 1 : photoIndex + 1;
formData.append('vf' + "_lca" + $routeParams.LCAID + "_" + fileIndex, file);
hasFile = true;
};
$scope.selectPhoto = function (photo) {
photoIndex = fileIndex > photoIndex ? fileIndex + 1 : photoIndex + 1;
formData.append('vp' + "_lca" + $routeParams.LCAID + "_" + photoIndex, photo);
hasPhoto = true;
};
/*
angular.forEach(options, function (value) {
if (value.search(toBeEdit.Area) !== -1 && toBeEdit.Area) {
var fuelType = getFuelType(value);
$scope.fuelTypes.push(fuelType);
}
});
$scope.fuelTypes = filterDuplicatedData($scope.fuelTypes);
angular.forEach(options, function (value) {
if (toBeEdit.Area && toBeEdit.FuelType &&
value.search(toBeEdit.Area) !== -1 &&
value.search(toBeEdit.FuelType) !== -1) {
var year = getYear(value);
$scope.years.push(year);
}
});
$scope.years = filterDuplicatedData($scope.years);
*/
ParameterService.onAreaChanged(options, $scope, $scope.selectRow.toBeEdit);
ParameterService.onFuelTypeChanged(options, $scope, $scope.selectRow.toBeEdit);
setTimeout(function () {
$('#edit_year').val(selected.Year);
}, 500);
$scope.modalFormOption.show = true;
$scope.dataQualityOption = {};
$scope.dataQualityOption.data = {};
$scope.isEdit = true;
$('#activityDataType').val(selected.activityDataType);
$('#emitParaType').val(selected.emitParaType);
$scope.save = function () {
JoinService.joinAsync([toBeEdit]).then(function () {
//setKgCO2e([toBeEdit]);
$http.post($scope.baseUrl+'/api/Upload', formData, {
transformRequest: angular.identity,
headers: { 'Content-Type': undefined }
}).success(function (urlList) {
if (hasFile)
toBeEdit.ReferenceFileUrl = $scope.baseUrl +urlList[fileIndex];
if (hasPhoto)
toBeEdit.ReferencePhotoUrl = $scope.baseUrl +urlList[photoIndex];
$http.post($scope.baseUrl+'/api/Vehicle/Save/' + toBeEdit.LCAID + "/" + toBeEdit.ID, toBeEdit)
.success(function (data) {
//console.log('after save', data);
angular.copy(data, selected);
//console.log(selected.ParameterID, options);
selected.Area = getArea(options[selected.ParameterID]);
selected.FuelType = getFuelType(options[selected.ParameterID]);
selected.Year = getYear(options[selected.ParameterID]);
calcTotalKgCO2e();
$scope.modalFormOption.show = false;
});
});
});
};
};
$scope.dataQualityShow = function (selected) {
$http.get($scope.baseUrl+'/api/DataQualityLevel/GetByTableId/LCACommonSurveyForm_Vehicles/' + selected.ID
).success(function (data) {
angular.copy(data, $scope.dataQualityOption.data);
$scope.dataQualityOption.data.Name = selected.Name;
$scope.dataQualityOption.data.LCAID = selected.LCAID;
//todo !!... load pre saved data
//$scope.dataQualityOption.Fi = 0.0123;//test only;
//todo !!... <20>ٻݭn<DDAD>`<60>ұƶq<C6B6>~<7E><><EFBFBD><EFBFBD><EFBFBD>X <20>ұƶq<C6B6><71><EFBFBD><EFBFBD>
$scope.dataQualityOption.showSaveBtn = $scope.lcaDetail.Status == 1;
$scope.dataQualityOption.show = true;
}).error(function (data, status) {
alert(data.ExceptionMessage);
});
};
$scope.deleteProcess = function (selected) {
var isConfirm = confirm(resource.DeleteItemMsg);
if (isConfirm) {
$http.delete($scope.baseUrl+"/api/Vehicle/Delete/" + selected.ID)
.success(function () {
var index = $scope.model.indexOf(selected);
$scope.model.splice(index, 1);
calcTotalKgCO2e();
// This operate is base on selectRow directive in TableEdit.js file
$scope.selectRow.unSelect();
});
}
};
/* modelBuilder for create & export */
/** Caution!: The 'ParameterID' property depends on 'options'.
This modelBuilder is binded with this controller.
Refactoring modelBuilder.create() with more arugments will be better **/
$scope.modelBuilder = {
create: function (data, LCAID) {
try {
// Get TypeID by TypeName
var typeID;
var typeName = data[0];
if (typeName == resource['OfficialCar']) {
typeID = 0;
} else if (typeName == resource['LeasingAndPrivateCar']) {
typeID = 1;
}
var model = {
Type: typeID,
ProcessName: data[1],
ResponsibleUnit: data[2],
Name: data[3],
CarPlateNo: data[4],
ParameterID: getKeyByValue(options, data[5] + ',' + data[6] + ',' + data[7]),
Scalar: parseFloat(data[8]) ? data[8] : 0,
LCAID: LCAID
};
// check imported data length and model length (-1 for LCAID, +2 for ParameterID)
if (data.length !== getObjectSize(model) + 1) {
throw resource['EXCELFileFormatWrong'];
}
// if find incorrect Type
if (model.Type === undefined) {
throw resource['VehicleVehicleType'] + ' Error';
}
// if find incorrect ParameterID
if (model.ParameterID === undefined) {
throw resource['Area'] + '/' + resource['FuelType'] + '/' + resource['StaticLabelGlobal_Years'] + ' Error';
}
return model;
} catch (err) {
return { error: err };
}
},
export: function (list) {
var data = [];
// header
data.push([resource['VehicleVehicleType'],
resource['FactoryAndProcessItems'],
resource['ResponsibleUnit'],
resource['OfficialDepotVehicleModel'],
resource['CarPlateNo'],
resource['Area'],
resource['FuelType'],
resource['StaticLabelGlobal_Years'],
resource['FuelConsumptionDuringInterrogation']]);
// body
angular.forEach(list, function (entry) {
var csv = [];
//column 1
if (entry.Type == 0) {
csv.push(resource['OfficialCar']);
} else {
csv.push(resource['LeasingAndPrivateCar']);
}
//column 2
csv.push(entry.ProcessName);
//column 3
csv.push(entry.ResponsibleUnit);
//column 4
csv.push(entry.Name);
//column 5
csv.push(entry.CarPlateNo);
//column 6
csv.push(entry.Area);
//column 7
csv.push(entry.FuelType);
//column 8
csv.push(entry.Year);
//column 9
csv.push(entry.Scalar);
data.push(csv);
});
ExportCsvService.startExport(data, "Export_Vehicle.csv");
}
};
/* file import options & modal control */
$scope.fileImportOptions = {
modelBuilder: $scope.modelBuilder,
saveAsync: batchCreateAndUpdateCache
};
$scope.fileImportModal = {
show: false
};
/* quote options & modal control */
$scope.quoteOptions = {
queryDataAsyncFn: function (LCAID) {
var deferred = $q.defer();
getAllDataAsync(LCAID).then(function (data) {
deferred.resolve(data.Vehicles);
})
return deferred.promise;
},
saveAsyncFn: batchCreateAndUpdateCache
};
$scope.quoteModal = {
show: false
};
// Get data and prepare $scope.model
getAllDataAsync($routeParams.LCAID)
.then(function (response) {
options = response.Options;
var sheetHeader = response.SheetHeader ? response.SheetHeader : {};
if (response.Vehicles) {
$scope.model = response.Vehicles;
}
// Get each model's area, fuel type, year by "ParameterID"
angular.forEach($scope.model, function (model) {
//console.log(model);
if (model.ParameterID in options) {
model.Area = getArea(options[model.ParameterID]);
model.FuelType = getFuelType(options[model.ParameterID]);
model.Year = getYear(options[model.ParameterID]);
}
//model.ActivityDataType = model.ac
});
calcTotalKgCO2e();
/*
// Sources of dropdown lists
$scope.areas = [];
// Extract area from array "options"
angular.forEach(options, function (value) {
var area = getArea(value);
//console.log(area);
$scope.areas.push(area);
});
// Filter duplicated area
$scope.areas = filterDuplicatedData($scope.areas);
*/
$scope.areas = ParameterService.getAreasFromParameters(options);
//console.log('options areas', options, $scope.areas);
// $scope.sheetHeader is parent's object
$scope.sheetHeader.SheetFillerName = sheetHeader.SheetFillerName;
$scope.sheetHeader.Phone = sheetHeader.Phone;
$scope.sheetHeader.Department = sheetHeader.Department;
$scope.activityOptions = response.ActivityOptions;
$scope.emitParaOptions = response.EmitParaOptions;
//console.log($scope.activityOptions);
//console.log($scope.emitParaOptions);
}, function (error) {
console.log(error);
});
// Get multilanguage resource
MultiLanguageService.getResourceAsync()
.then(function (response) {
resource = response;
}, function (error) {
console.log(error);
});
/**
* Private function: save all async
* @param {[Array]} : array of parsed objects
* @return {[promise]}
*/
function batchCreateAndUpdateCache(parsedList) {
var deferred = $q.defer();
// Calculate KgCO2e and sava all
JoinService.joinAsync(parsedList)
.then(function () {
// update KgCO2e properties
//setKgCO2e(parsedList);
$http.post($scope.baseUrl+'/api/Vehicle/SaveAll/', parsedList)
.success(function (data) {
// close modals
$scope.fileImportModal.show = false;
$scope.quoteModal.show = false;
// Get each model's area, fuel type, year by "ParameterID"
angular.forEach(data.result, function (model) {
model.Area = getArea(options[model.ParameterID]);
model.FuelType = getFuelType(options[model.ParameterID]);
model.Year = getYear(options[model.ParameterID]);
});
// concat created data and $scope.model
$scope.model = data.result.concat($scope.model);
calcTotalKgCO2e();
deferred.resolve(data);
})
.error(function (e) {
console.log(e.Message);
});
});
return deferred.promise;
}
/**
* Update the KgCO2e property of the model objects
* @param {[Array]} : array of model objects
*/
function setKgCO2e(models) {
angular.forEach(models, function (entry) {
if (entry.parameterResult && entry.Scalar) {
entry.KgCO2e = entry.parameterResult * entry.Scalar;
}
});
}
/* Private function: get all list data from server */
function getAllDataAsync(LCAID) {
var deferred = $q.defer();
$http.get($scope.baseUrl+'/api/Vehicle/GetByLcaId/' + LCAID)
.success(function (data) {
deferred.resolve(data);
})
.error(function () {
deferred.resolve(null);
})
return deferred.promise;
}
// Update "fuelTypes" dropdown list
$scope.$watch('selectRow.toBeEdit.Area', function (area) {
ParameterService.onAreaChanged(options, $scope, $scope.selectRow.toBeEdit);
/*
$scope.fuelTypes = ParameterService.getFuelTypesByArea(options, area);
$scope.years = ParameterService.getYearsByAreaAndFuelType(options, area, $scope.selectRow.toBeEdit.FuelType);
$scope.selectRow.toBeEdit.ParameterID = ParameterService.getParameterIDByAreaAndFuelTypeAndYear(options, $scope.selectRow.toBeEdit.FuelType, )
angular.forEach(options, function (value) {
if (value.search(area) !== -1 && area) {
var fuelType = getFuelType(value);
$scope.fuelTypes.push(fuelType);
}
});
$scope.fuelTypes = filterDuplicatedData($scope.fuelTypes);
*/
}, true);
// Update "years" dropdown list
$scope.$watch('selectRow.toBeEdit.FuelType', function () {
ParameterService.onFuelTypeChanged(options, $scope, $scope.selectRow.toBeEdit);
/*
var area = $scope.selectRow.toBeEdit.Area;
var fuelType = $scope.selectRow.toBeEdit.FuelType;
$scope.years = [];
angular.forEach(options, function (value) {
if (area && fuelType &&
value.search(area) !== -1 &&
value.search(fuelType) !== -1) {
var year = getYear(value);
$scope.years.push(year);
}
});
$scope.years = filterDuplicatedData($scope.years);
*/
}, true);
// Update "ParameterID" attribute.
// There might be some different "ParameterID" match to multiple identical "Value"
// Here, we always return the last match (the biggest "ParameterID")
$scope.$watch('selectRow.toBeEdit.Year', function () {
ParameterService.onYearChanged(options, $scope, $scope.selectRow.toBeEdit);
/*
var area = $scope.selectRow.toBeEdit.Area,
fuelType = $scope.selectRow.toBeEdit.FuelType,
year = $scope.selectRow.toBeEdit.Year;
angular.forEach(options, function (value, key) {
if (value.search(area) !== -1 &&
value.search(fuelType) !== -1 &&
value.search(year) !== -1) {
$scope.selectRow.toBeEdit.ParameterID = key;
}
});
*/
}, true);
/**
* Get substring "area" from a string
* @parem String
* @returns String
*/
function getArea(value) {
return value.slice(0, value.indexOf(','));
}
/**
* Get substring "fuelType" from a string
* @parem String
* @returns String
*/
function getFuelType(value) {
return value.slice(value.indexOf(',') + 1, value.lastIndexOf(','));
}
/**
* Get substring "year" from a string
* @parem String
* @returns String
*/
function getYear(value) {
return value.slice(value.lastIndexOf(',') + 1, value.length);
}
/**
* Remove identical element from the array
* @parem Array
* @returns Array
function filterDuplicatedData(array) {
var filteredArray = [];
angular.forEach(array, function (value) {
if ($.inArray(value, filteredArray) === -1) {
filteredArray.push(value);
}
});
return filteredArray;
}
*/
function calcTotalKgCO2e() {
$scope.summary = Enumerable.From($scope.model).GroupBy("$.FuelType", "$.KgCO2e", function (key, group) {
return { fuelType: key, totalKgCO2e: Enumerable.From(group).Sum(), AllocationKgCO2e: Enumerable.From(group).Sum() * $scope.Ratio };
}).ToArray();
var sumKgCO2e = 0;
angular.forEach($scope.summary, function (item) {
sumKgCO2e += item.totalKgCO2e;
});
$scope.sumKgCO2e = sumKgCO2e;
}
$scope.onAllocationChange = function (Allocation) {
$scope.Allocation = Allocation
if ($scope.Allocation == 0) //<2F><><EFBFBD>q<EFBFBD><71><EFBFBD>t
//$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, $scope.product.Weight, $scope.lcaDetail.FabProductionWeight);
$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs * $scope.product.Weight / $scope.lcaDetail.FabProductionWeight, 1, $scope.lcaDetail.ProductProductionPcs);
else if ($scope.Allocation == 1) //<2F><><EFBFBD>n<EFBFBD><6E><EFBFBD>t
//$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, $scope.product.AreaSize, $scope.lcaDetail.FabProductionArea);
$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs * $scope.product.AreaSize / $scope.lcaDetail.FabProductionArea, 1, $scope.lcaDetail.ProductProductionPcs);
else if ($scope.Allocation == 2) //<2F><><EFBFBD>q<EFBFBD><71><EFBFBD>t
//$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, 1, $scope.lcaDetail.FabProductionPcs);
$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, 1, $scope.lcaDetail.FabProductionPcs);
else if ($scope.Allocation == 3) //<2F>g<EFBFBD>٤<EFBFBD><D9A4>t
//$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, $scope.lcaDetail.ProductProductionEconomic, $scope.lcaDetail.FabProductionEconomic);
$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs * $scope.lcaDetail.ProductProductionEconomic / $scope.lcaDetail.FabProductionEconomic, 1, $scope.lcaDetail.ProductProductionPcs);
else if ($scope.Allocation == 4) //<2F>u<EFBFBD>ɤ<EFBFBD><C9A4>t
//$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs, $scope.lcaDetail.ProductProductionHour, $scope.lcaDetail.FabProductionHour);
$scope.Ratio = $scope.calculate($scope.lcaDetail.ProductProductionPcs * $scope.lcaDetail.ProductProductionHour / $scope.lcaDetail.FabProductionHour, 1, $scope.lcaDetail.ProductProductionPcs);
else if ($scope.Allocation == 99)
$scope.Ratio = 1;
$http.post($scope.baseUrl+'/api/LCA/SaveAllocation/' + $routeParams.LCAID + '/' + $routeParams.DetailType + '/' + $scope.Allocation)
.success(function (data) {
calcTotalKgCO2e();
$scope.modifyCacheAllocation();
})
}
}]);