| 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;};
 |