123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387 |
-
- BemsWebApplication.MaterialStockStatus2 = function (params, viewInfo) {
- "use strict";
- var materialFactory = BemsWebApplication.Factory.Material;
- var imagefileUrl = ko.observable();
- var SiteID = BWA.UserInfo.SiteId();
- var materialClassForSearch = ko.observableArray();
- var materialClass = ko.observableArray();
- var searchFacilityClassValues = [ko.observable(), ko.observable(), ko.observable()];
- var searchFacilityClasses = [ko.observableArray(), ko.observableArray(), ko.observableArray()];
- var facilityClasses = [ko.observableArray(), ko.observableArray(), ko.observableArray()];
- var MaterialCodeClassDataSource = BemsWebApplication.db.createDataSource('FmsMaterialCodeClass');
- var eq = BWA.DataUtil.constructEqualFilter, and = BWA.DataUtil.andFilter;
- var businessFieldDataSource = BemsWebApplication.db.createDataSource('CmBusinessField', true, true, true),
- materialClassDataSource = BemsWebApplication.db.createDataSource('FmsMaterialCodeClass', true, true),
- materialTypeDataSource = BemsWebApplication.db.createDataSource('FmsMaterialCodeType', true, true),
- tradeCompanyDataSource = BemsWebApplication.db.createDataSource('FmsMaterialTradeCompany', true, true),
- warehouseDataSource = BemsWebApplication.db.createDataSource('FmsMaterialWarehouse', true, true),
- locationDataSource = BemsWebApplication.db.createDataSource('FmsMaterialCodeLocation', true, true);
- var materialClasses = [ko.observableArray(), ko.observableArray(), ko.observableArray()],
- businessFields = ko.observableArray(),
- materialTypes = ko.observableArray(),
- tradeCompanies = ko.observableArray(),
- warehouses = ko.observableArray(),
- locations = ko.observableArray();
- var materialClassesForSearch = [ko.observableArray(), ko.observableArray(), ko.observableArray()],
- materialTypesForSearch = ko.observableArray(),
- materialClassValuesForSearch = [ko.observable(), ko.observable(), ko.observable()],
- businessFieldsForSearch = ko.observableArray(),
- materialTypeIdForSearch = ko.observable(),
- businessFieldIdForSearch = ko.observable();
- var deferredForSearch = new $.Deferred();
- var defaultSearchClassArray = $SearchView.createDefaultArray('MaterialClassId');
- function initializeSearchClasses(onlyThird) {
- if (onlyThird === undefined || onlyThird === false) {
- searchFacilityClasses[1](defaultSearchClassArray.slice(0));
- searchFacilityClassValues[1](0);
- }
- searchFacilityClasses[2](defaultSearchClassArray.slice(0));
- searchFacilityClassValues[2](0);
- }
- var handleFirstClassChangedValueInSearchView = function (e) {
- if (e.value === 0) {
- initializeSearchClasses();
- return;
- }
- BWA.DataUtil.setArrayDataSourceFilter(MaterialCodeClassDataSource, 'ParentMaterialClassId', e.value, searchFacilityClasses[1], defaultSearchClassArray);
- };
- var handleSecondClassChangedValueInSearchView = function (e) {
- if (searchFacilityClassValues[1]() == null) {
- initializeSearchClasses();
- BWA.DataUtil.setArrayDataSourceFilter(MaterialCodeClassDataSource, 'ParentMaterialClassId', 0, searchFacilityClasses[1], defaultSearchClassArray);
- }
- if (e.value === 0) {
- initializeSearchClasses(true);
- return;
- }
- BWA.DataUtil.setArrayDataSourceFilter(MaterialCodeClassDataSource, 'ParentMaterialClassId', e.value, searchFacilityClasses[2], defaultSearchClassArray);
- };
- var viewModel = BWA.DataGrid.createViewWithDataGrid(params, viewInfo, 'FmsMaterial', {
- dataSourceOptions: {
- store: BemsWebApplication.odata.FmsMaterialEx,
- select: [
- 'SiteId',
- 'BusinessFieldId',
- 'MaterialId',
- 'MaterialCode',
- 'Name',
- 'FirstClassId',
- 'SecondClassId',
- 'ThirdClassId',
- 'LocationId',
- 'MaterialTypeId',
- 'TradeCompanyId',
- 'WarehouseId',
- 'WHouseName',
- 'Rfid',
- 'Unit',
- 'DurableYears',
- 'ReasonableStockCount',
- 'Manufacturer',
- 'Standard',
- 'FinalPrice',
- 'ImageFileId',
- 'Note',
- 'IsDiscontinued',
- 'IsUse',
- 'FinalStockCount',
- 'FinalTotalStockAmount',
- 'StockCount',
- 'StockAmount',
- 'CmBusinessField/Name',
- 'FmsMaterialCodeType/Name',
- ],
- filter: [
- ['SiteId', '=', SiteID]
- ],
- expand: [
- 'CmBusinessField',
- 'FmsMaterialCodeType',
- ],
- extendOptions: {
- forceOriginalField: true
- }
- },
- columns: [
- { dataField: 'MaterialId', caption: $G('number'), width: '10%', alignment: 'center', allowFiltering: false, sortOrder: 'desc' },
- { dataField: 'CmBusinessField/Name', caption: $G('businessFieldName'), width: '10%', alignment: 'center', },
- {
- dataField: 'FirstClassId', width: '15%', caption: '자재(대)', alignment: 'center',
- customizeText: function (cellInfo) {
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == cellInfo.value) {
- return materialClassForSearch()[i].Name();
- }
- }
- }
- },
- {
- dataField: 'SecondClassId', width: '15%', caption: '자재(중)', alignment: 'center',
- customizeText: function (cellInfo) {
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == cellInfo.value) {
- return materialClassForSearch()[i].Name();
- }
- }
- }
- },
- {
- dataField: 'ThirdClassId', width: '15%', caption: '자재(소)', alignment: 'center',
- customizeText: function (cellInfo) {
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == cellInfo.value) {
- return materialClassForSearch()[i].Name();
- }
- }
- }
- },
- { dataField: 'Name', caption: '자재명', width: '30%', alignment: 'center' },
- { dataField: 'Standard', caption: '규격', width: '30%', alignment: 'center' },
- { dataField: 'Unit', caption: '단위', width: '10%', alignment: 'center' },
- { dataField: 'ReasonableStockCount', caption: '적정재고수량', width: '15%', alignment: 'center', format: 'fixedPoint' },
- { dataField: 'StockCount', caption: '재고수량', width: '10%', alignment: 'center', format: 'fixedPoint' },
- { dataField: 'StockAmount', caption: '재고금액', width: '10%', alignment: 'center', format: 'fixedPoint' },
- { dataField: 'WHouseName', caption: '창고', width: '10%', alignment: 'center' },
- ],
- paging: {
- pageSize: 18,
- enabled: true
- },
- pager: {},
- "export": {
- enabled: true,
- fileName: '재고 현황',
- },
- onExporting: function (e) {
- e.component.columnOption("MaterialId", "visible", false);
- },
- onExported: function (e) {
- e.component.columnOption("MaterialId", "visible", true);
- },
- wordWrapEnabled: true,
- searchViewItems: [
- { id: 'MaterialCode' },
- { id: 'Name' },
- { id: 'Standard' },
- { id: 'Unit' },
- { id: 'FirstClassId', ignoreValue: 0, defaultValue: 0, value: searchFacilityClassValues[0], dataSource: searchFacilityClasses[0], handleChangedValue: handleFirstClassChangedValueInSearchView },
- { id: 'SecondClassId', ignoreValue: 0, defaultValue: 0, withCheckId: 'FirstClassId', value: searchFacilityClassValues[1], dataSource: searchFacilityClasses[1], handleChangedValue: handleSecondClassChangedValueInSearchView },
- { id: 'ThirdClassId', ignoreValue: 0, defaultValue: 0, withCheckId: 'FirstClassId', value: searchFacilityClassValues[2], dataSource: searchFacilityClasses[2] },
- ],
- promiseDataInSearchView: deferredForSearch.promise(),
- handleViewShowing: function () {
- MaterialCodeClassDataSource.filter([
- ['SiteId', '=', SiteID]
- ]);
- $.when(
- MaterialCodeClassDataSource.load()
- ).done(function (Result) {
- materialClass = ko.observableArray();
- var cnt = 0;
- for (var i = 0; i < Result.length; i++) {
- materialClass.push(Result[i]);
- if (Result[i].Depth() == 0) {
- if (cnt == 0) {
- searchFacilityClasses[0](defaultSearchClassArray.slice(0).concat(Result[i]));
- cnt++;
- }
- else {
- searchFacilityClasses[0].push(Result[i]);
- }
- }
- }
- facilityClasses[0](Result[0]);
- materialClassForSearch($SearchView.createArrayOfSelectBox('MaterialClassId', materialClass()));
- });
- materialClassDataSource.filter([
- ['SiteId', '=', SiteID],
- 'and',
- ['ParentMaterialClassId', '=', null]
- ]);
- materialClassDataSource.filter([
- ['SiteId', '=', SiteID],
- 'and',
- ['ParentMaterialClassId', '=', null]
- ]);
- var useBusinessFiltering = BWA.UserInfo.isDependBusinessField(viewInfo.viewName)
- if (useBusinessFiltering) {
- this.dataSourceOptions.filter.push([eq('BusinessFieldId', BWA.UserInfo.BusinessFieldId()), 'or', eq('BusinessFieldId', 1)]);
- businessFieldDataSource.filter([
- eq('SiteId', SiteID),
- and,
- [eq('BusinessFieldId', BWA.UserInfo.BusinessFieldId()), 'or', eq('BusinessFieldId', 1)]
- ]);
- }
- $.when(
- businessFieldDataSource.load(),
- materialClassDataSource.load(),
- materialTypeDataSource.load(),
- tradeCompanyDataSource.load(),
- warehouseDataSource.load(),
- locationDataSource.load()
- ).done(function (dbBusinessFields, dbMaterialClasses, dbMaterialTypes, dbTradeCompanies, dbWarehouses, dbLocations) {
- dbBusinessFields = dbBusinessFields[0];
- dbMaterialClasses = dbMaterialClasses[0];
- dbMaterialTypes = dbMaterialTypes[0];
- dbTradeCompanies = dbTradeCompanies[0];
- dbWarehouses = dbWarehouses[0];
- dbLocations = dbLocations[0];
- materialClasses[0](dbMaterialClasses);
- materialClassesForSearch[0]($SearchView.createArrayOfSelectBox('MaterialClassId', dbMaterialClasses));
- initializeSearchClasses();
- businessFields(dbBusinessFields);
- materialTypes(dbMaterialTypes);
- tradeCompanies(dbTradeCompanies);
- warehouses(dbWarehouses);
- locations(dbLocations);
- businessFieldsForSearch($SearchView.createArrayOfSelectBox('BusinessFieldId', dbBusinessFields));
- materialTypesForSearch($SearchView.createArrayOfSelectBox('MaterialTypeId', dbMaterialTypes));
- deferredForSearch.resolve();
- });
- },
- handleViewShown: function (dataViewModel, isEditModeInPopup) {
- },
- handleSaveSuccess: function () {
- },
- handleAfterLoadingModelByKey: function (data, dataViewModel, isNewInPopup) {
- if (isNewInPopup() == false) {
- BWA.DataUtil.setArrayDataSourceFilter(materialClassDataSource, 'ParentMaterialClassId', dataViewModel.FirstClassId(), materialClasses[1]).done(function () {
- BWA.DataUtil.setArrayDataSourceFilter(materialClassDataSource, 'ParentMaterialClassId', dataViewModel.SecondClassId(), materialClasses[2]);
- });
- BWA.DataUtil.setArrayDataSourceFilter(warehouseDataSource, 'BusinessFieldId', dataViewModel.BusinessFieldId(), warehouses);
- if (_.isNull(dataViewModel.ImageFileId()) === false) {
- imagefileUrl('{0}/CmFile(SiteId={1},FileId={2})/$value'.formati(BWA.db._url, dataViewModel.SiteId(), dataViewModel.ImageFileId()));
- }
- else {
- imagefileUrl("images/default.png");
- }
- }
- },
- handlePopupShowing: function (isNewInPopup) {
- if (isNewInPopup() == false) {
- // 이전 이미지 잔상 문제로 인한 방어코드
- // 이미지 경로 강제 초기화
- imagefileUrl(undefined);
- }
- viewModel.toolbarItems[1].options.visible(false);
- viewModel.toolbarItems[2].options.visible(false);
- },
- handleDataGridRowClick: function (id, dataGrid, clickRow, popupVisible) {
- dataGrid.clearSelection();
- viewModel.isNewInPopup(false);
- var data = clickRow.data;
- var dataModel = viewModel.dataModel;
- var firstClassname, secondClassname, thirdClassname, companyname;
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == data.FirstClassId()) {
- firstClassname = materialClassForSearch()[i].Name();
- break;
- }
- }
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == data.SecondClassId()) {
- secondClassname = materialClassForSearch()[i].Name();
- break;
- }
- }
- for (var i = 1; i < materialClassForSearch().length; i++) {
- if (materialClassForSearch()[i].MaterialClassId() == data.ThirdClassId()) {
- thirdClassname = materialClassForSearch()[i].Name();
- break;
- }
- }
- dataModel.ClassName = $KoSet(dataModel.ClassName, materialFactory.formatClassName(firstClassname, secondClassname, thirdClassname));
- dataModel.Note = $KoSet(dataModel.Note, data['Note']);
- dataModel.BusinessFieldName = $KoSet(dataModel.BusinessFieldName, data['CmBusinessField/Name']);
- dataModel.Name = $KoSet(dataModel.Name, data['Name']);//자재명
- dataModel.Standard = $KoSet(dataModel.Standard, data['Standard']);// 규격
- dataModel.Unit = $KoSet(dataModel.Unit, data['Unit']); //단위
- dataModel.Rfid = $KoSet(dataModel.Rfid, data['Rfid']);
- dataModel.IsDiscontinued = $KoSet(dataModel.IsDiscontinued, data['IsDiscontinued']);//단종여부
- dataModel.ReasonableStockCount = $KoSet(dataModel.ReasonableStockCount, data['ReasonableStockCount']);//적정재고량
- dataModel.DurableYears = $KoSet(dataModel.DurableYears, data['DurableYears']); //내용연수
- dataModel.FinalPrice = $KoSet(dataModel.FinalPrice, data['FinalPrice']); //단가
- dataModel.MaterialTypeName = $KoSet(dataModel.MaterialTypeName, data['FmsMaterialCodeType/Name']); //자재구분
- dataModel.IsUse(true);
- dataModel.Manufacturer = $KoSet(dataModel.Manufacturer, data['Manufacturer']);
- popupVisible(true);
- }
- });
- viewModel.handleSelectBoxChangeBusinessField = function (e) {
- BWA.DataUtil.setArrayDataSourceFilter(warehouseDataSource, 'BusinessFieldId', e.value, warehouses);
- viewModel.dataModel.WarehouseId(null);
- }
- viewModel.handleSelectBoxChangeFirstClass = function (e) {
- BWA.DataUtil.setArrayDataSourceFilter(materialClassDataSource, 'ParentMaterialClassId', e.value, materialClasses[1]);
- viewModel.dataModel.SecondClassId(null);
- viewModel.dataModel.ThirdClassId(null);
- }
- viewModel.handleSelectBoxChangeSecondClass = function (e) {
- BWA.DataUtil.setArrayDataSourceFilter(materialClassDataSource, 'ParentMaterialClassId', e.value, materialClasses[2]);
- viewModel.dataModel.ThirdClassId(null);
- }
- viewModel.dataModel.ClassName = ko.observable();
- viewModel.materialClasses = materialClasses;
- viewModel.materialTypes = materialTypes;
- viewModel.tradeCompanies = tradeCompanies;
- viewModel.warehouses = warehouses;
- viewModel.locations = locations;
- viewModel.businessFields = businessFields;
- viewModel.dataModel.BusinessFieldName = ko.observable();
- viewModel.dataModel.Note = ko.observable();
- viewModel.dataModel.MaterialTypeName = ko.observable();
- viewModel.dataModel.Standard = ko.observable();// 규격
- viewModel.dataModel.Unit = ko.observable();//단위
- viewModel.dataModel.DurableYears = ko.observable();//내용연수
- viewModel.dataModel.Rfid = ko.observable();
- viewModel.dataModel.TradeCompanyName = ko.observable();
- viewModel.dataModel.FinalPrice = ko.observable(); //단가
- viewModel.dataModel.ReasonableStockCount = ko.observable(); //적정재고량
- viewModel.dataModel.IsDiscontinued = ko.observable();//단종여부
- viewModel.dataModel.IsUse = ko.observable();//사용여부
- viewModel.imagefileUrl = imagefileUrl;
- viewModel.handleFirstClassChangedValueInSearchView = handleFirstClassChangedValueInSearchView;
- viewModel.handleSecondClassChangedValueInSearchView = handleSecondClassChangedValueInSearchView;
- return viewModel;
- };
|