ration_facade.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. /**
  2. * Created by zhang on 2018/2/9.
  3. */
  4. let mongoose = require('mongoose');
  5. import SearchDao from '../../complementary_ration_lib/models/searchModel';
  6. const scMathUtil = require('../../../public/scMathUtil').getUtil();
  7. let ration_glj_facade = require("../../ration_glj/facade/ration_glj_facade")
  8. let quantity_detail = require("../facade/quantity_detail_facade");
  9. let ration_glj = mongoose.model('ration_glj');
  10. let ration_coe = mongoose.model('ration_coe');
  11. let ration_model = require('../models/ration');
  12. let bill_model = require('../models/bills');
  13. let decimal_facade = require('./decimal_facade');
  14. import installationFeeModel from "../models/installation_fee";
  15. import rationInstallationModel from "../models/ration_installation";
  16. const uuidV1 = require('uuid/v1');
  17. let std_glj_lib_gljList_model = mongoose.model('std_glj_lib_gljList');
  18. let coeMolde = mongoose.model('std_ration_lib_coe_list');
  19. let _= require('lodash');
  20. module.exports = {
  21. replaceRations: replaceRations,
  22. addNewRation:addNewRation
  23. };
  24. async function addNewRation(data) {
  25. let query = data.itemQuery;
  26. let stdRation = null;
  27. if(query){
  28. let searchDao = new SearchDao();
  29. stdRation = await searchDao.getRationItem(query.userID,query.rationRepId,query.code);
  30. data.newData.code = query.code;
  31. }
  32. if(data.brUpdate.length>0){
  33. await updateSerialNo(data.brUpdate);
  34. }
  35. let newRation =await insertNewRation(data.newData,stdRation,data.calQuantity);
  36. if(stdRation){
  37. return await addRationSubList(stdRation,newRation);
  38. }else {
  39. return {ration:newRation};
  40. }
  41. }
  42. async function updateSerialNo(serialNoUpdate){
  43. let tasks=[];
  44. for(let data of serialNoUpdate){
  45. let task={
  46. updateOne:{
  47. filter:{
  48. ID:data.ID,
  49. projectID:data.projectID
  50. },
  51. update :{
  52. serialNo:data.serialNo
  53. }
  54. }
  55. };
  56. tasks.push(task);
  57. }
  58. await ration_model.model.bulkWrite(tasks);
  59. }
  60. async function insertNewRation(newData,std,calQuantity) {//插入新的定额
  61. if(std){
  62. newData.name = std.name;
  63. newData.caption = std.caption;
  64. newData.unit = std.unit;
  65. newData.libID = std.rationRepId;
  66. newData.content = std.jobContent;
  67. if (std.chapter) {
  68. newData.comments = std.chapter.explanation;
  69. newData.ruleText = std.chapter.ruleText;
  70. }
  71. newData.from = std.type === 'complementary' ? 'cpt' : 'std';
  72. newData.programID = std.feeType;
  73. newData.rationAssList = createRationAss(std);
  74. // calculate ration Quantity
  75. }
  76. if(calQuantity){
  77. await CalculateQuantity(newData,newData.billsItemID,newData.projectID);
  78. }
  79. let newRation = await ration_model.model.create(newData);
  80. return newRation;
  81. }
  82. async function replaceRations(userID,data) {
  83. let searchDao = new SearchDao();
  84. let recodes = [];
  85. for(let recode of data.nodeInfo){
  86. let stdRation = await searchDao.getRationItem(userID,data.libID,recode.newCode);
  87. let newRecode = await replaceRation(recode,stdRation,data.projectID,data.calQuantity);
  88. if(newRecode){
  89. recodes.push(newRecode);
  90. }else {
  91. break;
  92. }
  93. }
  94. return recodes;
  95. }
  96. async function replaceRation(nodeInfo,stdRation,projectID,calQuantity) {
  97. if(stdRation){
  98. await deleRationSubRecode(projectID,nodeInfo.ID);
  99. let newRation = await updateRation(stdRation,nodeInfo.ID,nodeInfo.billsItemID,projectID,calQuantity);//生成并插入新的定额
  100. return await addRationSubList(stdRation,newRation);
  101. }else {
  102. return null;
  103. }
  104. }
  105. async function addRationSubList(stdRation,newRation) {
  106. let ration_gljs = await addRationGLJ(stdRation,newRation);
  107. let ration_coes = await addRationCoe(stdRation,newRation);
  108. let ration_installs = await addRationInstallFee(stdRation,newRation);
  109. return {ration:newRation,ration_gljs:ration_gljs,ration_coes:ration_coes,ration_installs:ration_installs};
  110. }
  111. async function addRationInstallFee(std,newRation) {
  112. let install_fee_list = [];
  113. if(std.hasOwnProperty('rationInstList') && std.rationInstList.length > 0){
  114. let installFee = await installationFeeModel.findOne({'projectID': newRation.projectID});
  115. for(let ri of std.rationInstList){
  116. let feeItem = _.find(installFee.installFeeItem,{'ID':ri.feeItemId});
  117. let section = _.find(installFee.installSection,{'ID':ri.sectionId});
  118. if(feeItem&&section){
  119. let tem_r_i = {
  120. libID:installFee.libID,
  121. projectID:newRation.projectID,
  122. rationID:newRation.ID,
  123. feeItemId:feeItem.ID,
  124. sectionId:section.ID,
  125. itemName:feeItem.feeItem,
  126. feeType:feeItem.feeType,
  127. sectionName:section.name,
  128. unifiedSetting:1,
  129. ruleId:''
  130. };
  131. if(feeItem.isCal==1&&section.feeRuleId&&section.feeRuleId!=''){//勾选记取时并且有规则ID时才读取
  132. let feeRule = _.find(installFee.feeRule,{'ID':section.feeRuleId});
  133. if(feeRule){
  134. tem_r_i.ruleId = feeRule.ID;
  135. }
  136. }
  137. tem_r_i.ID = uuidV1();
  138. install_fee_list.push(tem_r_i);
  139. }
  140. }
  141. if(install_fee_list.length>0){
  142. await rationInstallationModel.insertMany(install_fee_list);
  143. }
  144. }
  145. return install_fee_list;
  146. }
  147. async function addRationCoe(std,newRation) {
  148. let ration_coe_list = [];
  149. let seq = 0;
  150. if(std.hasOwnProperty('rationCoeList')&&std.rationCoeList.length>0){//添加标准库的工料机
  151. for(let sub of std.rationCoeList){
  152. let libCoe = await coeMolde.findOne({'libID':std.rationRepId,'ID':sub.ID,"$or": [{"isDeleted": null}, {"isDeleted": false}]});//std.rationRepId;
  153. if(libCoe){
  154. let newCoe = {};
  155. newCoe.ID = uuidV1();
  156. newCoe.coeID = sub.ID;
  157. newCoe.seq = seq;
  158. newCoe.name = libCoe.name;
  159. newCoe.content = libCoe.content;
  160. newCoe.isAdjust=0;
  161. newCoe.coes = libCoe.coes;
  162. newCoe.rationID = newRation.ID;
  163. newCoe.projectID = newRation.projectID;
  164. seq++;
  165. ration_coe_list.push(newCoe);
  166. }
  167. }
  168. }
  169. let lastCoe ={
  170. coeID:-1,
  171. name : '自定义系数',
  172. content:'人工×1,材料×1,机械×1,主材×1,设备×1',
  173. isAdjust:0,
  174. seq:seq,
  175. rationID : newRation.ID,
  176. projectID : newRation.projectID
  177. };
  178. lastCoe.ID = uuidV1();
  179. lastCoe.coes = getCustomerCoeData();
  180. ration_coe_list.push(lastCoe);
  181. await ration_coe.insertMany(ration_coe_list);
  182. return ration_coe_list;
  183. }
  184. function getCustomerCoeData() {
  185. var coeList = [];
  186. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'定额'});
  187. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'人工'});
  188. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'材料'});
  189. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'机械'});
  190. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'主材'});
  191. coeList.push({ amount:1, operator:'*', gljCode:null, coeType:'设备'});
  192. return coeList;
  193. };
  194. async function addRationGLJ(std,newRation) {
  195. let newRationGLJList = [];
  196. let rationGLJShowList = [];
  197. if(std.hasOwnProperty('rationGljList') && std.rationGljList.length > 0){
  198. for(let sub of std.rationGljList){
  199. let newGLJ = {};
  200. newGLJ.ID = uuidV1();
  201. newGLJ.projectID = newRation.projectID;
  202. newGLJ.GLJID = sub.gljId;
  203. newGLJ.rationID = newRation.ID;
  204. newGLJ.billsItemID = newRation.billsItemID;
  205. newGLJ.rationItemQuantity = sub.consumeAmt;
  206. newGLJ.quantity = sub.consumeAmt;
  207. newGLJ.glj_repository_id = std.rationRepId;
  208. let std_glj = await std_glj_lib_gljList_model.findOne({'ID':sub.gljId});
  209. if(std_glj){
  210. newGLJ.name = std_glj.name;
  211. newGLJ.code = std_glj.code;
  212. newGLJ.original_code = std_glj.code;
  213. newGLJ.unit = std_glj.unit;
  214. newGLJ.specs = std_glj.specs;
  215. newGLJ.basePrice = std_glj.basePrice;
  216. newGLJ.shortName = std_glj.shortName;
  217. newGLJ.type = std_glj.gljType;
  218. newGLJ.repositoryId = std_glj.repositoryId;
  219. newGLJ.adjCoe = std_glj.adjCoe;
  220. let info = await ration_glj_facade.getInfoFromProjectGLJ(newGLJ);
  221. newGLJ = ration_glj_facade.createNewRecord(info);
  222. newRationGLJList.push(newGLJ);
  223. rationGLJShowList.push(info);
  224. }
  225. }
  226. }
  227. if(newRationGLJList.length>0){
  228. await ration_glj.insertMany(newRationGLJList);
  229. }
  230. return rationGLJShowList;
  231. }
  232. async function deleRationSubRecode(projectID,rationID) {//删除挂在定额下的数据,如工程量明细,定额工料机等
  233. let delete_query={projectID: projectID, rationID: rationID};
  234. //删除工程量明细
  235. await quantity_detail.deleteByQuery(delete_query) ;
  236. await ration_coe.deleteMany(delete_query);//删除附注条件
  237. await ration_glj.deleteMany(delete_query);//删除定额工料机
  238. await rationInstallationModel.deleteMany(delete_query);//删除安装增加费
  239. }
  240. async function updateRation(std,rationID,billsItemID,projectID,calQuantity) {
  241. // insertNewRation
  242. let ration ={};
  243. ration.code = std.code;
  244. ration.name = std.name;
  245. ration.caption = std.caption;
  246. ration.unit = std.unit;
  247. ration.libID = std.rationRepId;
  248. ration.content = std.jobContent;
  249. ration.adjustState = '';
  250. ration.isFromDetail=0;
  251. ration.isSubcontract=false;
  252. ration.fees=[];
  253. if (std.chapter) {
  254. ration.comments = std.chapter.explanation;
  255. ration.ruleText = std.chapter.ruleText;
  256. }
  257. ration.from = std.type === 'complementary' ? 'cpt' : 'std';
  258. ration.programID = std.feeType;
  259. ration.rationAssList = createRationAss(std);//生成辅助定额
  260. if(calQuantity){
  261. await CalculateQuantity(ration,billsItemID,projectID);
  262. }
  263. let unsetObject = {
  264. "marketUnitFee":1,
  265. 'marketTotalFee':1,
  266. "maskName":1
  267. }
  268. let newRation = await ration_model.model.findOneAndUpdate({ID:rationID,projectID:projectID},{"$set":ration,"$unset":unsetObject},{new: true});//;
  269. return newRation;
  270. }
  271. function createRationAss(std) {
  272. let rationAssList = [];//生成辅助定额
  273. if(std.hasOwnProperty('rationAssList')&&std.rationAssList.length>0){
  274. for(let i=0;i<std.rationAssList.length;i++){
  275. let ass = std.rationAssList[i];
  276. ass.actualValue = ass.stdValue;
  277. rationAssList.push(ass);
  278. }
  279. }
  280. return rationAssList;
  281. }
  282. async function CalculateQuantity (ration,billsItemID,projectID) {
  283. // calculate ration Quantity
  284. let decimalObject =await decimal_facade.getProjectDecimal(projectID);
  285. let quantity_decimal = (decimalObject&&decimalObject.ration&&decimalObject.ration.quantity)?decimalObject.ration.quantity:3;
  286. let pbill = await bill_model.model.findOne({projectID:projectID,ID:billsItemID});
  287. let billsQuantity = pbill.quantity ? pbill.quantity : 0;
  288. let bill_decimal = await decimal_facade.getBillsQuantityDecimal(projectID,pbill.unit);
  289. billsQuantity=scMathUtil.roundForObj(billsQuantity,bill_decimal);
  290. ration.quantityEXP="QDL";
  291. ration.quantity = scMathUtil.roundForObj(billsQuantity / FilterNumberFromUnit(ration.unit),quantity_decimal);//不管是否打勾都做转换
  292. ration.contain = scMathUtil.roundForObj(ration.quantity/billsQuantity,6);
  293. };
  294. function FilterNumberFromUnit (unit) {
  295. let reg = new RegExp('^[0-9]+');
  296. if (reg.test(unit)) {
  297. return parseInt(unit.match(reg)[0]);
  298. } else {
  299. return 1;
  300. }
  301. };