123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509 |
- /**
- * Created by Zhong on 2017/8/11.
- */
- import {gljMapModel, gljModel, gljClassModel, gljClassTemplateModel} from "./schemas";
- import {OprDao} from "./gljMapModel";
- import moment from "moment";
- import counter from "../../../public/counter/counter";
- import async from "async";
- class GljDao extends OprDao{
- getGljTypes (gljLibId, callback){
- gljClassModel.find({"repositoryId": gljLibId, "$or": [{"isDeleted": null}, {"isDeleted": false}, {deleted: false} ]},function(err,data){
- if(data.length) {
- callback(0, data);
- }
- else if(err) callback("获取工料机类型错误!",false)
- else {
- gljClassTemplateModel.find({'$or': [{isDeleted: null}, {isDeleted: false}, {deleted: false}]}, function (err, datas) {
- if(err){
- callback("获取工料机类型错误!", false);
- }
- else{
- let rst = [];
- async.each(datas, function (data, cb) {
- let newClassObj = {};
- newClassObj.ID = data.ID;
- newClassObj.ParentID = data.ParentID;
- newClassObj.NextSiblingID = data.NextSiblingID;
- newClassObj.Name = data.Name;
- newClassObj.repositoryId = gljLibId;
- newClassObj.deleted = false;
- gljClassModel.create(newClassObj, function(err){
- if(err)cb(err);
- else{
- rst.push(newClassObj);
- cb(null);
- }
- });
- }, function (err) {
- if(err) callback("新增工料机类型错误!", false);
- else callback(0, rst);
- });
- }
- });
- }
- })
- }
- _exist(data, attr){
- return data && data[attr] !== 'undefined' && data[attr];
- }
- sortToNumber(datas){
- for(let i = 0, len = datas.length; i < len; i++){
- let data = datas[i]._doc;
- if(this._exist(data, 'basePrice')){
- data['basePrice'] = parseFloat(data['basePrice']);
- }
- if(this._exist(data, 'component')){
- for(let j = 0, jLen = data['component'].length; j < jLen; j++){
- let comGljObj = data['component'][j]._doc;
- if(this._exist(comGljObj, 'consumeAmt')){
- comGljObj['consumeAmt'] = parseFloat(comGljObj['consumeAmt']);
- }
- }
- }
- }
- }
- async getGljItemsByRep(repositoryId,callback = null){
- /* let me = this;
- if (callback === null) {
- return gljModel.find({"repositoryId": repositoryId});
- } else {
- gljModel.find({"repositoryId": repositoryId},function(err,data){
- if(err) callback(true, "")
- else {
- me.sortToNumber(data);
- callback(false,data);
- }
- })
- }*/
- let me = this;
- let rst = [];
- //批量获取异步
- let functions = [];
- let count = await gljModel.find({repositoryId: repositoryId, $or: [{deleted: null}, {deleted: false}]}).count();
- let findCount = Math.ceil(count/500);
- for(let i = 0, len = findCount; i < len; i++){
- functions.push((function(flag) {
- return function (cb) {
- gljModel.find({repositoryId: repositoryId, deleted: null}, cb).skip(flag).sort({ID: 1}).limit(500);
- }
- })(i*500));
- }
- async.parallel(functions, function (err, results) {
- if(err){
- callback(err, null);
- }
- else{
- for(let stdGljs of results){
- rst = rst.concat(stdGljs);
- }
- me.sortToNumber(rst);
- callback(0, rst);
- }
- });
- }
- getGljItemByType (repositoryId, type, callback){
- let me = this;
- gljModel.find({"repositoryId": repositoryId, "gljType": type},function(err,data){
- if(err) callback(true, "");
- else {
- me.sortToNumber(data);
- callback(false, data);
- }
- })
- };
- getGljItem (repositoryId, code, callback){
- let me = this;
- gljModel.find({"repositoryId": repositoryId, "code": code},function(err,data){
- if(err) callback(true, "")
- else {
- me.sortToNumber(data);
- callback(false, data);
- }
- })
- };
- getGljItems (gljIds, callback){
- let me = this;
- gljModel.find({"ID": {"$in": gljIds}},function(err,data){
- if(err) callback(true, "")
- else {
- me.sortToNumber(data);
- callback(false, data);
- }
- })
- };
- getGljItemsByCode (repositoryId, codes, callback){
- let me = this;
- gljModel.find({"repositoryId": repositoryId,"code": {"$in": codes}},function(err,data){
- if(err) callback(true, "");
- else {
- me.sortToNumber(data);
- callback(false, data);
- }
- })
- };
- updateComponent(libId, oprtor, updateArr, callback){
- let parallelFucs = [];
- for(let i = 0; i < updateArr.length; i++){
- parallelFucs.push((function(obj){
- return function (cb) {
- if(typeof obj.component === 'undefined'){
- obj.component = [];
- }
- gljModel.update({repositoryId: libId, ID: obj.ID}, obj, function (err, result) {
- if(err){
- cb(err);
- }
- else{
- cb(null, obj);
- }
- })
- }
- })(updateArr[i]));
- }
- parallelFucs.push((function () {
- return function (cb) {
- GljDao.updateOprArr({ID: libId}, oprtor, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- })());
- async.parallel(parallelFucs, function (err, result) {
- if(err){
- callback(err, '更新组成物错误!', null);
- }
- else{
- callback(null, '成功!', result);
- }
- });
- }
- mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
- if (updateItems.length == 0 && rIds.length == 0) {
- GljDao.addGljItems(repId, lastOpr, addItems, callback);
- }
- else if(rIds.length > 0 && updateItems.length > 0){
- async.parallel([
- function (cb) {
- GljDao.removeGljItems(repId, lastOpr, rIds, cb);
- },
- function (cb) {
- GljDao.updateGljItems(repId, lastOpr, updateItems, cb);
- }
- ], function (err) {
- if(err){
- callback(true, "Fail to update and delete", false)
- }
- else{
- callback(false, "Save successfully", false);
- }
- })
- }
- else if (rIds.length > 0 && updateItems.length === 0) {
- GljDao.removeGljItems(repId, lastOpr, rIds, callback);
- }
- else if(updateItems.length > 0 || addItems.length > 0){
- GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
- if (err) {
- callback(true, "Fail to update", false);
- } else {
- if (addItems && addItems.length > 0) {
- GljDao.addGljItems(repId, lastOpr, addItems, callback);
- } else {
- callback(false, "Save successfully", results);
- }
- }
- });
- }
- }
- /*mixUpdateGljItems (repId, lastOpr, updateItems, addItems, rIds, callback) {
- if (updateItems.length == 0 && rIds.length == 0) {
- GljDao.addGljItems(repId, lastOpr, addItems, callback);
- } else if (rIds.length > 0) {
- GljDao.removeGljItems(repId, lastOpr, rIds, function(err, message, docs) {
- });
- }else{
- GljDao.updateGljItems(repId, lastOpr, updateItems, function(err, results){
- if (err) {
- callback(true, "Fail to update", false);
- } else {
- if (addItems && addItems.length > 0) {
- GljDao.addGljItems(repId, lastOpr, addItems, callback);
- } else {
- callback(false, "Save successfully", results);
- }
- }
- });
- }
- };*/
- static removeGljItems (repId, lastOpr, rIds, callback) {
- if (rIds && rIds.length > 0) {
- gljModel.collection.remove({ID: {$in: rIds}}, null, function(err, docs){
- if (err) {
- callback(true, "Fail to remove", false);
- } else {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- callback(true, "Fail to update operator", false);
- }
- else{
- callback(false, "Remove successfully", docs);
- }
- });
- }
- })
- } else {
- callback(false, "No records were deleted!", null);
- }
- }
- static addGljItems (repId, lastOpr, items, callback) {
- if (items && items.length > 0) {
- counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, items.length, function(err, result){
- var maxId = result.value.sequence_value;
- var arr = [];
- for (var i = 0; i < items.length; i++) {
- var obj = new gljModel(items[i]);
- obj.ID = (maxId - (items.length - 1) + i);
- obj.repositoryId = repId;
- arr.push(obj);
- }
- gljModel.collection.insert(arr, null, function(err, docs){
- if (err) {
- callback(true, "Fail to add", false);
- } else {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- callback(true, "Fail to update Operator", false);
- }
- else{
- callback(false, "Add successfully", docs);
- }
- });
- }
- })
- });
- } else {
- callback(true, "No source", false);
- }
- }
- static updateGljItems(repId, lastOpr, items, callback) {
- var functions = [];
- for (var i=0; i < items.length; i++) {
- functions.push((function(doc) {
- return function(cb) {
- var filter = {};
- if (doc.ID) {
- filter.ID = doc.ID;
- } else {
- filter.repositoryId = repId;
- filter.code = doc.code;
- }
- gljModel.update(filter, doc, cb);
- };
- })(items[i]));
- }
- functions.push((function () {
- return function (cb) {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- })());
- async.parallel(functions, function(err, results) {
- callback(err, results);
- });
- }
- getRationGljIds(rationLibs, callback){
- }
- updateNodes (updateData, lastOpr, callback) {
- let functions = [];
- for (let i = 0, len = updateData.length; i < len; i++) {
- functions.push((function(doc) {
- return function(cb) {
- if(doc.updateType === 'update'){
- gljClassModel.update({repositoryId: doc.updateData.repositoryId, ID: doc.updateData.ID}, doc.updateData, function (err) {
- if(err){
- cb(err);
- }
- else {
- cb(null);
- }
- });
- }
- else if(doc.updateType === 'new'){
- gljClassModel.create(doc.updateData, function (err) {
- if(err){
- cb(err);
- }
- else {
- cb(null);
- }
- });
- }
- };
- })(updateData[i]));
- }
- if(updateData.length > 0){
- functions.push((function () {
- return function (cb) {
- GljDao.updateOprArr({ID: updateData[0].updateData.rationRepId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- })());
- }
- async.parallel(functions, function(err, results) {
- if(!err){
- err = 0;
- }
- callback(err, results);
- });
- }
- /* updateNodes (repId, lastOpr, nodes, callback) {
- var functions = [];
- for (var i=0; i < nodes.length; i++) {
- functions.push((function(doc) {
- return function(cb) {
- gljClassModel.update({ID: doc.ID}, doc, cb);
- };
- })(nodes[i]));
- }
- functions.push((function () {
- return function (cb) {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- })());
- async.parallel(functions, function(err, results) {
- callback(err, results);
- });
- }*/
- removeNodes (repId, lastOpr, nodeIds, preNodeId, preNodeNextId, callback){
- var functions = [];
- if (preNodeId != -1) {
- functions.push((function(nodeId, nextId) {
- return function(cb) {
- gljClassModel.update({ID: nodeId}, {"NextSiblingID": nextId}, cb);
- };
- })(preNodeId, preNodeNextId));
- }
- for (var i=0; i < nodeIds.length; i++) {
- functions.push((function(nodeId) {
- return function(cb) {
- gljClassModel.update({ID: nodeId}, {"isDeleted": true}, cb);
- };
- })(nodeIds[i]));
- }
- functions.push((function () {
- return function (cb) {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- })());
- async.parallel(functions, function(err, results) {
- callback(err, results);
- });
- }
- createNewNode(repId, lastOpr, lastNodeId, nodeData, callback) {
- return counter.counterDAO.getIDAfterCount(counter.moduleName.GLJ, 1, function(err, result){
- nodeData.repositoryId = repId;
- nodeData.ID = result.value.sequence_value;
- var node = new gljModel(nodeData);
- async.parallel([
- function (cb) {
- node.save(function (err, result) {
- if (err) {
- cb("章节树ID错误!", false);
- } else {
- if (lastNodeId > 0) {
- gljClassModel.update({ID: lastNodeId}, {"NextSiblingID": nodeData.ID}, function(err, rst){
- if (err) {
- cb("章节树ID错误!", false);
- } else {
- cb(false, result);
- }
- });
- } else cb(false, result);
- }
- });
- },
- function (cb) {
- GljDao.updateOprArr({ID: repId}, lastOpr, moment(Date.now()).format('YYYY-MM-DD HH:mm:ss'), function (err) {
- if(err){
- cb(err);
- }
- else{
- cb(null);
- }
- })
- }
- ], function (err, result) {
- if(err){
- callback(true, "章节树错误!", false);
- }
- else{
- callback(false, '', result[0]);
- }
- })
- });
- }
- getGljItemsOccupied(repId, occupation, callback){
- gljModel.find({repositoryId: repId}, occupation, function (err, result) {
- if(err) callback(true, 'fail', null);
- else callback(false, 'sc', result);
- });
- }
- async getGljItemsByRepId(repositoryId){
- return gljModel.find({"repositoryId": repositoryId});
- }
- }
- export default GljDao;
|