pm_facade.js 132 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146
  1. /**
  2. * Created by zhang on 2018/4/17.
  3. */
  4. const projectType = {
  5. folder: 'Folder',
  6. tender: 'Tender',
  7. project: 'Project',
  8. engineering: 'Engineering',
  9. };
  10. //先导出后require可以解决循环引用问题
  11. module.exports={
  12. prepareShareList,
  13. getShareList,
  14. addShareList,
  15. updateShareList,
  16. deleteShareList,
  17. getShareInfoMap,
  18. getRecentShareList,
  19. getProjectShareList,
  20. getReceiveLibList,
  21. getLibShareList,
  22. getUnreadShareListByCompilation,
  23. getShareTip,
  24. getShareState,
  25. markShareItemsRead,
  26. getShareInfoAfterChangePermission,
  27. moveProject:moveProject,
  28. accessToCopyProject,
  29. copyProject:copyProject,
  30. copyExample: copyExample,
  31. setupSummaryFields: setupSummaryFields,
  32. getSummaryInfo: getSummaryInfo,
  33. getSummaryInfoByTender: getSummaryInfoByTender,
  34. getIndexReportData: getIndexReportData,
  35. getTendersFeeInfo: getTendersFeeInfo,
  36. getConstructionProject: getConstructionProject,
  37. getFullPath: getFullPath,
  38. projectType: projectType,
  39. getPosterityProjects: getPosterityProjects,
  40. isShare: isShare,
  41. isFirst: isFirst,
  42. getShareInfo: getShareInfo,
  43. prepareInitialData: prepareInitialData,
  44. changeFile:changeFile,
  45. getBasicInfo: getBasicInfo,
  46. getProjectFeature: getProjectFeature,
  47. getProgressiveInterval: getProgressiveInterval,
  48. getProjectByGranularity: getProjectByGranularity,
  49. importProject: importProject,
  50. getProjectPlaceholder: getProjectPlaceholder,
  51. exportProject:exportProject,
  52. importProjects:importProjects,//建筑这里重名了,这比养护加多了个s
  53. initOverHeightItems: initOverHeightItems,
  54. uploadToken:uploadToken,
  55. downLoadProjectFile:downLoadProjectFile,
  56. importChongqingProject:importChongqingProject,
  57. importExampleProject:importExampleProject,
  58. importProcessChecking:importProcessChecking,
  59. copyConstructionProject,
  60. importInterface,
  61. isTenderOverrun,
  62. getWelcomeInfo:getWelcomeInfo
  63. };
  64. let mongoose = require('mongoose');
  65. let _ = require("lodash");
  66. let feeRate_facade = require('../../fee_rates/facade/fee_rates_facade');
  67. let glj_facade = require('../../glj/facade/glj_facade');
  68. let project_facade = require('../../main/facade/project_facade');
  69. let logger = require("../../../logs/log_helper").logger;
  70. const uuidV1 = require('uuid/v1');
  71. let projectModel = mongoose.model('projects');
  72. let projectSettingModel = mongoose.model('proj_setting');
  73. let billsModel = mongoose.model('bills');
  74. let rationModel = mongoose.model('ration');
  75. let gljListModel = mongoose.model("glj_list");
  76. let calcProgramsModel = mongoose.model('calc_programs');
  77. let labourCoesModel = mongoose.model('labour_coes');
  78. let feeRateModel = mongoose.model('fee_rates');
  79. let feeRateFileModel = mongoose.model('fee_rate_file');
  80. let unitPriceFileModel = mongoose.model("unit_price_file");
  81. let mixRatioModel = mongoose.model("mix_ratio");
  82. let unitPriceModel = mongoose.model("unit_price");
  83. let installationFeeModel = mongoose.model("installation_fee");
  84. let rationGLJModel = mongoose.model('ration_glj');
  85. let rationCoeModel = mongoose.model('ration_coe');
  86. let rationInstallationModel = mongoose.model('ration_installation');
  87. let quantityDetailModel = mongoose.model('quantity_detail');
  88. let rationTemplateModel = mongoose.model('ration_template');
  89. let userModel = mongoose.model('user');
  90. let compleGljSectionModel = mongoose.model('complementary_glj_section');
  91. let compleGljSectionTModel = mongoose.model('complementary_glj_section_templates');
  92. let compilationModel = mongoose.model('compilation');
  93. let engineeringModel = mongoose.model('engineering_lib');
  94. let basicInfoModel = mongoose.model('std_basic_info_lib');
  95. let projectFeatureModel = mongoose.model('std_project_feature_lib');
  96. let progressiveModel = mongoose.model('std_progressive_lib');
  97. let stdRationItemModel = mongoose.model('std_ration_lib_ration_items');
  98. let stdGljItemModel = mongoose.model('std_glj_lib_gljList');
  99. let evaluateListModel = mongoose.model("evaluate_list");
  100. let bidListModel = mongoose.model("bid_evaluation_list");
  101. let contractorListModel = mongoose.model("contractor_list");
  102. let featureLibModel = mongoose.model("std_project_feature_lib");
  103. let importLogsModel = mongoose.model("import_logs");
  104. const overHeightLibModel = mongoose.model('std_over_height_lib');
  105. const shareListModel = mongoose.model('share_list');
  106. const shareLibModel = mongoose.model('share_libs');
  107. let welcomeModel = mongoose.model("welcome_setting");
  108. let scMathUtil = require('../../../public/scMathUtil').getUtil();
  109. let counter = require('../../../public/counter/counter');
  110. const SectionTreeDao = require('../../complementary_ration_lib/models/sectionTreeModel');
  111. let sectionTreeDao = new SectionTreeDao();
  112. const CounterModel = require("../../glj/models/counter_model");
  113. const moment = require('moment-timezone');
  114. const { fixedFlag, SharePermissionChangeType } = require('../../../public/common_constants');
  115. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  116. const {
  117. defaultDecimal,
  118. billsQuantityDecimal,
  119. displaySetting,
  120. calcOptions,
  121. tenderSetting
  122. } = require('../models/project_property_template');
  123. let labourCoeFacade = require('../../main/facade/labour_coe_facade');
  124. let calcProgramFacade = require('../../main/facade/calc_program_facade');
  125. let mainColLibModel = mongoose.model('std_main_col_lib');
  126. const EngineeringLibModel = require("../../users/models/engineering_lib_model");
  127. let installationFacade = require('../../main/facade/installation_facade');
  128. let cipher = require('../../../public/cipher');
  129. let index = require("../../system_setting/model/index");
  130. let qiniu = require("qiniu");
  131. let fs = require("fs");
  132. let path = require("path");
  133. let request = require("request");
  134. const systemSettingModel = mongoose.model('system_setting');
  135. let qiniu_config = {
  136. "AccessKey": "_gR1ed4vi1vT2G2YITGSf4_H0fJu_nRS9Tzk3T4z",
  137. "SecretKey": "ty4zd0FHqgEDaiVzSLC8DfHlai99aS7bspLkw6s6",
  138. "Bucket": "yun-update",
  139. "Domain": "http://serverupdate.smartcost.com.cn"
  140. };
  141. let mac = new qiniu.auth.digest.Mac(qiniu_config.AccessKey, qiniu_config.SecretKey);
  142. // 重构了分享的数据结构,原本存在projects表的shareInfo数组中
  143. // 为了更好地适应新功能及以后拓展功能,现将分享信息存放在单独的share_list表中
  144. // 为了适应旧数据,需要在share_list没有数据的时候,将原本的分享信息复制到share_list中,同时生成联系人
  145. // TODO: 上线后这个方法执行过后,应该删除此方法
  146. async function prepareShareList() {
  147. const shareListCount = await shareListModel.count({});
  148. console.log(shareListCount);
  149. if (shareListCount) {
  150. return;
  151. }
  152. logger.info('================================enterPrepareShareList================================================');
  153. // 将项目的shareInfo数据复制到share_list表中
  154. const projects = await projectModel.find({'shareInfo.0': {$exists: true}}, '-_id ID userID shareInfo').lean();
  155. if (!projects.length) {
  156. return;
  157. }
  158. const shareList = [];
  159. const userMap = {}; // 给生成联系人做准备
  160. projects.forEach(project => {
  161. const ownerContacts = userMap[project.userID] || (userMap[project.userID] = []);
  162. project.shareInfo.forEach(shareItem => {
  163. if (!shareItem.shareDate) {
  164. return;
  165. }
  166. const receiverContacts = userMap[shareItem.userID] || (userMap[shareItem.userID] = []);
  167. receiverContacts.push(project.userID);
  168. const newItem = {
  169. ID: uuidV1(),
  170. projectID: project.ID,
  171. owner: project.userID,
  172. receiver: shareItem.userID,
  173. allowCopy: shareItem.allowCopy,
  174. allowCooperate: shareItem.allowCooperate,
  175. shareDate: shareItem.shareDate,
  176. updateDate: shareItem.shareDate
  177. };
  178. ownerContacts.push(shareItem.userID);
  179. shareList.push(newItem);
  180. });
  181. });
  182. // 插入分享信息
  183. const shareListPromise = shareListModel.insertMany(shareList);
  184. const tasks = [shareListPromise];
  185. // 更新用户信息
  186. const userTasks = [];
  187. Object.entries(userMap).forEach(([userID, contacts]) => {
  188. contacts = [...new Set(contacts)]
  189. .map(user => ({ userID: user }));
  190. const task = {
  191. updateOne: {
  192. filter: {
  193. _id: mongoose.Types.ObjectId(userID)
  194. },
  195. update: {
  196. contacts
  197. }
  198. }
  199. };
  200. userTasks.push(task);
  201. });
  202. if (userTasks.length) {
  203. tasks.push(userModel.bulkWrite(userTasks));
  204. }
  205. await Promise.all(tasks);
  206. }
  207. // 获取分享列表
  208. async function getShareList(query, isShareLib = false) {
  209. const model = isShareLib ? shareLibModel : shareListModel;
  210. return await model.find(query, '-_id').lean();
  211. }
  212. async function addShareList(docs, isShareLib = false) {
  213. const model = isShareLib ? shareLibModel : shareListModel;
  214. await model.insertMany(docs);
  215. }
  216. async function deleteShareList(query, isShareLib = false) {
  217. const model = isShareLib ? shareLibModel : shareListModel;
  218. await model.deleteMany(query);
  219. }
  220. async function updateShareList(updateData, isShareLib = false) {
  221. const model = isShareLib ? shareLibModel : shareListModel;
  222. const bulks = updateData.map(item => (
  223. {
  224. updateOne: {
  225. filter: item.query,
  226. update: item.update
  227. }
  228. }
  229. ));
  230. if (bulks.length) {
  231. await model.bulkWrite(bulks);
  232. }
  233. }
  234. // 根据项目ID获取项目shareInfo字段的数据映射(前端旧逻辑依赖项目本身的shareInfo字段)
  235. async function getShareInfoMap(projectIDs, shareList = null) {
  236. if (!shareList) {
  237. shareList = await getShareList({projectID: {$in: projectIDs}});
  238. }
  239. // 将相同项目的分享信息进行映射
  240. const map = {};
  241. shareList.forEach(item => {
  242. const shareInfo = map[item.projectID] || (map[item.projectID] = []);
  243. shareInfo.push({
  244. userID: item.receiver,
  245. shareDate: item.shareDate,
  246. updateDate: item.updateDate,
  247. allowCopy: item.allowCopy,
  248. allowCooperate: item.allowCooperate
  249. });
  250. });
  251. return map;
  252. }
  253. // 获取最近分享(只算分享出去的记录)
  254. async function getRecentShareList(userID, count) {
  255. // 合并分享的项目和库
  256. const shareProjectList = await getShareList({owner: userID});
  257. const shareLibList = await getShareList({owner: userID}, true);
  258. const shareList = [...shareProjectList, ...shareLibList];
  259. shareList.sort((a, b) => Date.parse(b.shareDate) - Date.parse(a.shareDate));
  260. const set = new Set();
  261. for(const item of shareList) {
  262. if (set.size === count) {
  263. break;
  264. }
  265. set.add(item.receiver);
  266. }
  267. const sortedIDList = [...set];
  268. const userIDList = sortedIDList.map(userID => mongoose.Types.ObjectId(userID));
  269. const users = await userModel.find({_id: {$in: userIDList}}, 'real_name mobile company').lean();
  270. users.sort((a, b) => sortedIDList.indexOf(a._id.toString()) - sortedIDList.indexOf(b._id.toString()));
  271. return users;
  272. }
  273. // 获取某项目的分享记录
  274. async function getProjectShareList(projectID, limit = null) {
  275. const sharedList = limit
  276. ? await shareListModel.find({ projectID }).lean().sort({ shareDate: -1 }).limit(limit)
  277. : await shareListModel.find({ projectID }).lean().sort({ shareDate: -1 });
  278. const userIDs = [];
  279. const userMap = {};
  280. sharedList.forEach((item, index) => {
  281. userIDs.push(item.receiver);
  282. userMap[item.receiver] = item;
  283. userMap[item.receiver].index = index;
  284. });
  285. const userObjectIDs = userIDs.map(userID => mongoose.Types.ObjectId(userID));
  286. const users = await userModel.find({_id: {$in: userObjectIDs}}, 'real_name mobile company').lean();
  287. users.forEach(user => {
  288. const matched = userMap[user._id];
  289. if (matched) {
  290. user.index = matched.index;
  291. user.allowCopy = matched.allowCopy;
  292. user.allowCooperate = matched.allowCooperate;
  293. }
  294. });
  295. users.sort((a, b) => a.index - b.index);
  296. return users;
  297. }
  298. async function getReceiveLibList(receiver, compilationID, libType) {
  299. const sharedList = await shareLibModel.find({ receiver, compilationID, libType }).lean().sort({ shareDate: -1 });
  300. const userIDs = [];
  301. const userMap = {};
  302. sharedList.forEach((item, index) => {
  303. userIDs.push(item.owner);
  304. userMap[item.owner] = item;
  305. userMap[item.owner].index = index;
  306. });
  307. const userObjectIDs = userIDs.map(userID => mongoose.Types.ObjectId(userID));
  308. const users = await userModel.find({ _id: { $in: userObjectIDs } }, 'real_name').lean();
  309. users.forEach(user => {
  310. const matched = userMap[user._id];
  311. if (matched) {
  312. user.index = matched.index;
  313. }
  314. });
  315. users.sort((a, b) => a.index - b.index);
  316. return users;
  317. }
  318. // 获取某库的分享记录
  319. async function getLibShareList(owner, compilationID, libType, limit = null) {
  320. const sharedList = limit
  321. ? await shareLibModel.find({ owner, compilationID, libType }).lean().sort({ shareDate: -1 }).limit(limit)
  322. : await shareLibModel.find({ owner, compilationID, libType }).lean().sort({ shareDate: -1 });
  323. const userIDs = [];
  324. const userMap = {};
  325. sharedList.forEach((item, index) => {
  326. userIDs.push(item.receiver);
  327. userMap[item.receiver] = item;
  328. userMap[item.receiver].index = index;
  329. });
  330. const userObjectIDs = userIDs.map(userID => mongoose.Types.ObjectId(userID));
  331. const users = await userModel.find({_id: {$in: userObjectIDs}}, 'real_name mobile company').lean();
  332. users.forEach(user => {
  333. const matched = userMap[user._id];
  334. if (matched) {
  335. user.index = matched.index;
  336. }
  337. });
  338. users.sort((a, b) => a.index - b.index);
  339. return users;
  340. }
  341. // 获取某用户某费用定额的未读的被分享记录
  342. async function getUnreadShareListByCompilation(userID, compilationID, isGetCount) {
  343. const fields = isGetCount ? '-_id projectID ' : '-_id';
  344. const list = await shareListModel.find({ receiver: userID, isRead: false }, fields);
  345. const idList = list.reduce((acc, cur) => {
  346. acc.push(cur.projectID);
  347. return acc;
  348. }, []);
  349. const notDeleted = [{ deleteInfo: null }, { 'deleteInfo.deleted': false }];
  350. const query = { ID: { $in: idList }, compilation: compilationID, $or: notDeleted };
  351. if (isGetCount) {
  352. return await projectModel.count(query)
  353. }
  354. const items = await projectModel.find(query, '-_id ID').lean();
  355. return items.map(item => item.ID);
  356. }
  357. // 获取分享的提示(造价书分享按钮tooltip使用)
  358. async function getShareTip(projectID, limit) {
  359. const task = [
  360. getProjectShareList(projectID, limit),
  361. shareListModel.count({ projectID })
  362. ];
  363. const [users, count] = await Promise.all(task);
  364. return users.reduce((acc, user, index) => {
  365. if (index === 0) {
  366. acc += '已分享给';
  367. acc += user.real_name;
  368. } else {
  369. acc += ` ${user.real_name}`;
  370. }
  371. if (index === users.length - 1 && count > limit) {
  372. acc += `等${count}人`;
  373. }
  374. return acc;
  375. }, '');
  376. }
  377. // 获取项目的分享状态
  378. // 分享项目的拷贝和编辑性,需要参考父项
  379. // 以项目链上最新更新的分享数据为准
  380. async function getShareState(projectID, receiver) {
  381. const projectIDs = await getUpChainIDs(projectID);
  382. const shareList = await shareListModel.find({ projectID: { $in: projectIDs }, receiver }).lean();
  383. shareList.sort((a, b) => Date.parse(b.updateDate) - Date.parse(a.updateDate));
  384. return {
  385. allowCopy: shareList[0] && shareList[0].allowCopy || false,
  386. allowCooperate: shareList[0] && shareList[0].allowCooperate || false
  387. };
  388. }
  389. // 自身及父链上的分享数据(链距离最近的一个)
  390. async function getUpChainShareData(projectID, receiver) {
  391. while (projectID != -1) {
  392. const shareData = await shareListModel.findOne({ projectID, receiver }).lean();
  393. if (shareData) {
  394. return shareData;
  395. }
  396. const project = await projectModel.findOne({ ID: projectID }, '-_id ParentID').lean();
  397. projectID = project ? project.ParentID : -1;
  398. }
  399. return null;
  400. }
  401. // 标记已读分享条目
  402. // 打开任意的单位工程,都会将其父分享条目标记和自身为已读
  403. // eg:被分享了一个建设项目,和其下一个单位工程,打开该一个单位工程,建设项目标记为已读、该单位工程也标记为已读
  404. async function markShareItemsRead(projectID, userID) {
  405. const upChainIDs = await getUpChainIDs(projectID);
  406. const unreadList = await shareListModel.find({ projectID: { $in: upChainIDs }, receiver: userID, isRead: false }, '-_id ID projectID').lean();
  407. const markReadProjectIDs = [];
  408. const bulks = [];
  409. unreadList.forEach(item => {
  410. markReadProjectIDs.push(item.projectID);
  411. bulks.push({
  412. updateOne: {
  413. filter: { ID: item.ID },
  414. update: { isRead: true }
  415. }
  416. });
  417. });
  418. if (bulks.length) {
  419. await shareListModel.bulkWrite(bulks);
  420. }
  421. return markReadProjectIDs;
  422. }
  423. /**
  424. * 分享权限变更后,根据变更操作,获取相关项目的分享权限信息
  425. * 不能简单根据某个项目的分享信息获得其权限,因为目前的分享可以重复分享(分享单位工程A、分享包含单位工程A的父项)
  426. * 最新的分享权限是由项目链上(所有子项、自身、父项...)最新的分享信息决定的
  427. * @param {Number} permissionType - 分享权限变更类型
  428. * @param {String} receiver - 用户ID
  429. * @param {Number} projectID - 项目ID
  430. */
  431. async function getShareInfoAfterChangePermission(permissionType, receiver, projectID) {
  432. const project = await projectModel.findOne({ ID: projectID }, '-_id ID projType').lean();
  433. if (!project) {
  434. return [];
  435. }
  436. // UPDATE_COPY不触发推送给主页面的消息
  437. const propChange = [SharePermissionChangeType.UPDATE_COOPERATE].includes(permissionType);
  438. const cancelShare = permissionType === SharePermissionChangeType.CANCEL;
  439. // 需要处理的单位工程
  440. if (propChange && project.projType === projectType.tender) {
  441. const shareData = await shareListModel.findOne({ projectID, receiver }, '-_id allowCooperate allowCopy updateDate').lean();
  442. const tender = { ID: projectID };
  443. if (shareData) {
  444. Object.assign(tender, shareData);
  445. }
  446. return [tender];
  447. }
  448. if (propChange && project.projType !== projectType.tender) {
  449. const projects = await getPosterityProjects([projectID], false, '-_id ID projType');
  450. const tenders = projects.filter(p => p.projType === projectType.tender);
  451. const shareData = await shareListModel.findOne({ projectID, receiver }, '-_id allowCooperate allowCopy updateDate').lean();
  452. if (shareData) {
  453. tenders.forEach(tender => Object.assign(tender, shareData));
  454. }
  455. return tenders
  456. }
  457. if (cancelShare && project.projType === projectType.tender) {
  458. const shareData = await getUpChainShareData(projectID, receiver);
  459. return shareData ? [] : [{ ID: projectID }];
  460. }
  461. if (cancelShare && project.projType !== projectType.tender) {
  462. const projects = await getPosterityProjects([projectID], false, '-_id ID projType');
  463. const tenders = [];
  464. for (const p of projects) {
  465. if (p.projType === projectType.tender) {
  466. const shareData = await getUpChainShareData(p.ID, receiver);
  467. if (!shareData) {
  468. tenders.push({ ID: p.ID });
  469. }
  470. }
  471. }
  472. return tenders;
  473. }
  474. return [];
  475. }
  476. //拷贝例题项目
  477. //@param {String}userID {Array}projIDs拷贝的例题项目ID(建设项目、文件夹)@return {Boolean}
  478. async function copyExample(userID, compilation, projIDs,nameMap){
  479. let allProjs = [],
  480. IDMapping = {},
  481. projMapping = {};
  482. //例题项目不可为单项工程、单位工程、只能是建设项目、文件夹,否则不自动新建例题项目(这里不报错,让用户没有感觉)
  483. let parentExample = await projectModel.find({ID: {$in: projIDs}, $or: notDeleted}).lean();
  484. if (parentExample.length === 0) {
  485. return false;
  486. }
  487. allProjs = allProjs.concat(parentExample);
  488. for (let i = 0; i < parentExample.length; i++) {
  489. let data = parentExample[i];
  490. if (data.projType === projectType.tender || data.projType === projectType.engineering) {
  491. return false;
  492. }
  493. //设置成顶节点,最后一个节点设置成末节
  494. data.ParentID = -1;
  495. if (i === parentExample.length - 1) {
  496. data.NextSiblingID = -1;
  497. }
  498. if(nameMap && nameMap[data.ID]) data.name = nameMap[data.ID];
  499. }
  500. //获取所有的子项目
  501. let posterityProjs = await getPosterityProjects(projIDs);
  502. allProjs = allProjs.concat(posterityProjs);
  503. let projCounter = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.project, allProjs.length);
  504. //旧ID与新ID映射
  505. for (let i = 0; i < allProjs.length; i++) {
  506. let data = allProjs[i];
  507. let newID = projCounter.sequence_value - (allProjs.length - 1) + i;
  508. IDMapping[data.ID] = newID;
  509. projMapping[newID] = data;
  510. }
  511. //return;
  512. //设置新的树结构数据
  513. let newDate = new Date(),
  514. parentBulks = [];
  515. const projectMaps = [];
  516. // 传入项目ID的新ID
  517. const newProjIDs = [];
  518. for (let data of allProjs) {
  519. let orgID = data.ID;
  520. data.ID = IDMapping[data.ID];
  521. if (projIDs.indexOf(orgID) >= 0) {
  522. newProjIDs.push(data.ID);
  523. }
  524. data.ParentID = IDMapping[data.ParentID] ? IDMapping[data.ParentID] : -1;
  525. data.NextSiblingID = IDMapping[data.NextSiblingID] ? IDMapping[data.NextSiblingID] : -1;
  526. data.createDateTime = newDate;
  527. data.userID = userID;
  528. data.compilation = compilation;
  529. data.shareInfo = [];
  530. if (data.projType !== projectType.tender) {
  531. let newData = _.cloneDeep(data);
  532. delete newData._id;
  533. // await projectModel.create(newData);
  534. parentBulks.push({insertOne: {document: newData}});
  535. } else {
  536. //拷贝单位工程
  537. let rootProjectID = projMapping[data.ParentID].ParentID;
  538. let projectMap = {
  539. copy: {
  540. document: {userID: userID, ID: orgID, NextSiblingID: data.NextSiblingID, ParentID: data.ParentID, name: data.name, shareInfo: [],
  541. compilation: compilation, fileVer: data.fileVer, projType: data.projType, property: {rootProjectID: rootProjectID}}
  542. }
  543. };
  544. await copyProject(userID, compilation, {projectMap}, data.ID, true);
  545. projectMaps.push(projectMap);
  546. }
  547. }
  548. //最末顶层项目(兼容测试时已存在有项目,正常用户第一次进费用定额,该费用定额不存在项目)
  549. let lastProj = await projectModel.findOne({userID: userID, compilation: compilation, ParentID: -1, NextSiblingID: -1, $or: notDeleted});
  550. if (lastProj) {
  551. parentBulks.push({updateOne: {filter: {ID: lastProj.ID}, update: {$set: {NextSiblingID: parentExample[0].ID}}}});
  552. }
  553. // 处理项目数据
  554. const projectTasks = [projectModel.bulkWrite(parentBulks), createProject(projectMaps)];
  555. await Promise.all(projectTasks);
  556. return newProjIDs;
  557. }
  558. async function accessToCopyProject(userID, compilationID, data, newProjectID) {
  559. const logData = {
  560. key: uuidV1(),
  561. content: '正在拷贝项目,请稍候……',
  562. userID,
  563. compilationID,
  564. status: 'start',
  565. create_time: +new Date()
  566. };
  567. await importLogsModel.create(logData);
  568. handleCopyProject(logData.key, userID, compilationID,data,newProjectID);
  569. return 'copying project';
  570. }
  571. async function handleCopyProject(key, userID, compilationID, data, newProjectID) {
  572. const doc = { status: 'finish' };
  573. try {
  574. const projectMap = await copyProject(userID, compilationID, data, newProjectID);
  575. doc.projectID = [projectMap.copy.document.ID];
  576. } catch (err) {
  577. doc.status = 'error';
  578. doc.errorMsg = String(err);
  579. } finally {
  580. await importLogsModel.update({ key }, doc);
  581. }
  582. }
  583. async function copyProject(userID, compilationID,data,newProjectID = null, delayProjectTask = false) {
  584. let projectMap = data.projectMap;
  585. let originalID = projectMap['copy'].document.ID;
  586. if (!newProjectID) {
  587. newProjectID = await getCounterID("projects");
  588. }
  589. let newFeeName = null,newUnitName = null;
  590. let calcProgramFileID = uuidV1();//新的计算程序文件ID
  591. let labourCoeFileID = uuidV1();//新的人工调整系数文件ID
  592. let feeRateFileID = uuidV1();//新的费率文件ID
  593. let unitPriceFileID = await getCounterID("unit_price_file");//新的单价文件ID
  594. let originalProject = await projectModel.findOne({'ID':originalID});//查找最新的那项目信息,前端缓存的数据有可能不是最新的
  595. if(!originalProject){
  596. throw new Error('没有找到对应的项目,复制失败!');
  597. }
  598. let property = originalProject.property;
  599. if(projectMap['copy'].document.property){//更新项目属性信息
  600. setProperty(property,projectMap['copy'].document.property);
  601. }
  602. let originalProperty = _.cloneDeep(property);
  603. projectMap['copy'].document.property = property;
  604. logger.info("复制项目: 旧项目ID: "+originalID+ " ------- 新项目ID: "+newProjectID);
  605. //费率文件、单价文件重名检查
  606. let feeRate = await feeRateFileModel.findOne({rootProjectID:originalProperty.rootProjectID,name:originalProperty.feeFile.name,deleteInfo:null});
  607. if(feeRate){//存在重名的文件
  608. newFeeName = originalProperty.feeFile.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '复制)';
  609. projectMap['copy'].document.property.feeFile.name = newFeeName;
  610. }
  611. let unitPriceFile = await unitPriceFileModel.findOne({root_project_id: originalProperty.rootProjectID,name:originalProperty.unitPriceFile.name,deleteInfo: null});
  612. if(unitPriceFile){//存在重名的文件
  613. newUnitName = originalProperty.unitPriceFile.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '复制)';
  614. projectMap['copy'].document.property.unitPriceFile.name = newUnitName;
  615. }
  616. //更新项目的属性;
  617. projectMap['copy'].document.ID = newProjectID;
  618. if(projectMap['copy'].document.property.calcProgramFile){
  619. projectMap['copy'].document.property.calcProgramFile.ID = calcProgramFileID;
  620. }
  621. if(projectMap['copy'].document.property.labourCoeFile){
  622. projectMap['copy'].document.property.labourCoeFile.ID = labourCoeFileID;
  623. }
  624. if(projectMap['copy'].document.property.feeFile){
  625. projectMap['copy'].document.property.feeFile.id = feeRateFileID;
  626. }
  627. if(projectMap['copy'].document.property.unitPriceFile){
  628. projectMap['copy'].document.property.unitPriceFile.id = unitPriceFileID;
  629. }
  630. projectMap['copy'].document.userID = userID;
  631. projectMap['copy'].document.compilation = compilationID;
  632. projectMap['copy'].document.createDateTime = new Date();
  633. //清单、定额ID生成任务
  634. let IDtasks = [
  635. createIDsAndReturn(originalID,billsModel),
  636. createIDsAndReturn(originalID,rationModel),
  637. getProjectGLJIDAndReturn(originalID,newProjectID)
  638. ];
  639. let [billMap,rationMap,projectGLJMap] = await Promise.all(IDtasks);
  640. //所有复制任务异步处理,提升效率 复制清单,定额,4个文件,项目工料机, 定额工料机,人工系数,工程量明细,定额安装增加费,安装增加费
  641. let copyTasks = [
  642. copyProjectSetting(originalID,newProjectID),
  643. copyBills(newProjectID,billMap),
  644. copyRations(newProjectID,billMap.uuidMaping,rationMap,projectGLJMap.IDMap),
  645. copyProjectGLJ(projectGLJMap.datas),
  646. copyInstallFee(originalID,newProjectID),
  647. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationGLJModel),
  648. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationCoeModel),
  649. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,quantityDetailModel),
  650. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationInstallationModel),
  651. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationTemplateModel),
  652. copyMaterialList(originalID,newProjectID,projectGLJMap.IDMap,evaluateListModel),
  653. copyMaterialList(originalID,newProjectID,projectGLJMap.IDMap,bidListModel),
  654. copyMaterialList(originalID,newProjectID,projectGLJMap.IDMap,contractorListModel),
  655. ];
  656. if(originalProperty.calcProgramFile){
  657. copyTasks.push(commonCopy(newProjectID,originalProperty.calcProgramFile.ID,calcProgramFileID,calcProgramsModel));
  658. }
  659. if(originalProperty.labourCoeFile){
  660. copyTasks.push(commonCopy(newProjectID,originalProperty.labourCoeFile.ID,labourCoeFileID,labourCoesModel));
  661. }
  662. if(originalProperty.feeFile){
  663. copyTasks.push(copyFeeRate(originalProperty.rootProjectID,userID,originalProperty.feeFile.id,feeRateFileID,newFeeName));
  664. }
  665. if(originalProperty.unitPriceFile){
  666. copyTasks.push(copyUnitPriceFile(newProjectID,originalProperty.rootProjectID,userID,originalProperty.unitPriceFile.id,unitPriceFileID,newUnitName));
  667. }
  668. await Promise.all(copyTasks);
  669. // 最后再处理项目数据
  670. // 可能会有最后再在外层方法插入项目数据的需求,如拷贝例题,暂时先不在这里插入项目数据
  671. if (delayProjectTask) {
  672. return [projectMap];
  673. } else {
  674. const projectMaps = await createProject([projectMap]);
  675. return projectMaps[0];
  676. }
  677. }
  678. async function createIDsAndReturn(originalID,model) {
  679. let uuidMaping = {};//做ID映射
  680. let datas = [];
  681. let result = await model.find({"projectID": originalID}, '-_id').lean();
  682. uuidMaping['-1'] = -1;
  683. //建立uuid-ID映射
  684. for(let d of result){
  685. uuidMaping[d.ID] = uuidV1();
  686. datas.push(d);
  687. }
  688. return{uuidMaping:uuidMaping,datas:datas};
  689. }
  690. async function getProjectGLJIDAndReturn(originalID,newProjectID) {
  691. let IDMap = {};
  692. let datas = [];
  693. let result = await gljListModel.find({project_id:originalID}, '-_id').lean();
  694. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, result.length);
  695. for(let i = 0; i < result.length; i++){
  696. let d = result[i];
  697. let newID = gljCount.sequence_value - (result.length - 1) + i;
  698. //let newID = await getCounterID("glj_list");
  699. IDMap[d.id] = newID;
  700. d.project_id = newProjectID;
  701. d.id = newID;
  702. datas.push(d);
  703. }
  704. return{IDMap:IDMap,datas:datas};
  705. }
  706. async function createProject(projectMaps) {//复制项目
  707. let tasks = [];
  708. for (const projectMap of projectMaps) {
  709. if(projectMap['update']){//如果复制后存在前一个节点,则更新其NextSiblingID
  710. tasks.push({updateOne:{filter : projectMap['update'].query, update : {NextSiblingID:projectMap['copy'].document.ID}}});
  711. }
  712. tasks.push({insertOne: {document: projectMap['copy'].document}});//复制任务
  713. }
  714. await projectModel.bulkWrite(tasks);
  715. return projectMaps;
  716. }
  717. async function copyProjectSetting(originalID,newProjectID) {
  718. let result = null;
  719. let setting = await projectSettingModel.findOne({"projectID": originalID}, '-_id');
  720. if(setting){
  721. setting._doc.projectID =newProjectID;
  722. result = await projectSettingModel.create(setting._doc);
  723. }
  724. return result;
  725. }
  726. async function copyBills(newProjectID,billMap) {
  727. let uuidMaping = billMap.uuidMaping;//做ID映射
  728. for(let doc of billMap.datas){
  729. doc = getCopyBillDatas(doc,newProjectID,uuidMaping);
  730. }
  731. await insertMany(billMap.datas,billsModel);
  732. return billMap.datas;
  733. }
  734. function getCopyBillDatas(doc,newProjectID,uuidMaping) {
  735. doc.projectID = newProjectID;
  736. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  737. doc.ParentID = uuidMaping[doc.ParentID] ? uuidMaping[doc.ParentID] : -1;
  738. doc.NextSiblingID = uuidMaping[doc.NextSiblingID] ? uuidMaping[doc.NextSiblingID] : -1;
  739. //对于有基数计算的节点,需要替换计算基数中引用的ID为新的ID
  740. if(doc.calcBase && doc.calcBase != ""){
  741. let idArr = scMathUtil.getFIDArr(doc.calcBase);
  742. for(let re of idArr){
  743. let oID = re.substr(1);//去掉开头的@字符
  744. if(!uuidMaping[oID]) continue;
  745. doc.calcBase = doc.calcBase.replace(new RegExp(oID, "g"),uuidMaping[oID]);
  746. }
  747. }
  748. return doc;
  749. }
  750. async function copyRations(newProjectID,billsIDMap,rationMap,projectGLJIDMap) {
  751. let uuidMaping = rationMap.uuidMaping;
  752. for(let doc of rationMap.datas){
  753. doc = getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap);
  754. }
  755. if(rationMap.datas.length > 0){
  756. await insertMany(rationMap.datas,rationModel);
  757. }
  758. return rationMap.datas;
  759. }
  760. function getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap){
  761. doc.projectID = newProjectID;
  762. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  763. if(doc.billsItemID){
  764. doc.billsItemID = billsIDMap[doc.billsItemID]?billsIDMap[doc.billsItemID]:-1;
  765. }
  766. if(doc.referenceRationID) doc.referenceRationID = uuidMaping[doc.referenceRationID]?uuidMaping[doc.referenceRationID]:undefined;
  767. //绑定定类型的工料机 项目工料机ID
  768. doc.type==3&&doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  769. return doc;
  770. }
  771. async function copyProjectGLJ(gljList) {
  772. await insertMany(gljList,gljListModel);
  773. }
  774. async function commonCopy(newProjectID,oldID,newID,model) { //对于只需更新ID和projectID的文件的复制
  775. let result = null;
  776. let file = await model.findOne({"ID": oldID}, '-_id');
  777. if(file){
  778. file._doc.ID = newID;
  779. file._doc.projectID =newProjectID;
  780. result = await model.create(file._doc);
  781. }
  782. return result;
  783. }
  784. async function copyFeeRate(rootProjectID,userID,originalFeeRateFileID,feeRateFileID,newName) {//复制费率和费率文件
  785. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(originalFeeRateFileID);
  786. let newFeeRateID = uuidV1();
  787. if(feeRate){
  788. feeRate._doc.ID = newFeeRateID;
  789. await feeRateModel.create(feeRate._doc);
  790. }
  791. if(feeRateFile){
  792. feeRateFile._doc.ID = feeRateFileID;
  793. newName?feeRateFile._doc.name = newName:'';
  794. feeRateFile._doc.userID = userID;
  795. feeRateFile._doc.rootProjectID = rootProjectID;
  796. feeRateFile._doc.feeRateID = newFeeRateID;
  797. await feeRateFileModel.create(feeRateFile._doc);
  798. }
  799. }
  800. async function copyUnitPriceFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName) {//复制单价文件、组成物
  801. let taskList = [
  802. copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName),
  803. copySubList(originaluUnitPriceFileID,unitPriceFileID,mixRatioModel),
  804. copySubList(originaluUnitPriceFileID,unitPriceFileID,unitPriceModel)
  805. ];
  806. return await Promise.all(taskList);
  807. async function copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName){
  808. let unitPriceFile = await unitPriceFileModel.findOne({id:originaluUnitPriceFileID}, '-_id');
  809. if(unitPriceFile){
  810. unitPriceFile._doc.id = unitPriceFileID;
  811. newName?unitPriceFile._doc.name = newName:'';
  812. unitPriceFile._doc.project_id = newProjectID;
  813. unitPriceFile._doc.user_id = userID;
  814. unitPriceFile._doc.root_project_id = rootProjectID
  815. }
  816. await unitPriceFileModel.create(unitPriceFile._doc);
  817. }
  818. async function copySubList(srcFID,newFID,model) {
  819. let mList = await model.find({unit_price_file_id: srcFID}, '-_id').lean();
  820. let rList = [];
  821. let IDcounter = await counter.counterDAO.getIDAfterCountSync(model.modelName, mList.length);
  822. let firstID = IDcounter.sequence_value - (mList.length - 1);
  823. for(let m of mList){
  824. m.unit_price_file_id = newFID;
  825. m.id = firstID;
  826. firstID+=1
  827. rList.push(m);
  828. }
  829. await insertMany(rList,model)
  830. }
  831. }
  832. async function copyInstallFee(originalPID,newProjectID) {
  833. let result = null;
  834. let installationFee = await installationFeeModel.find({projectID:originalPID}, '-_id');
  835. let newList = [];
  836. for(let i of installationFee ){
  837. i._doc.ID = uuidV1();
  838. i._doc.projectID = newProjectID;
  839. newList.push(i._doc);
  840. }
  841. if(newList.length >0){
  842. result = await installationFeeModel.insertMany(newList);
  843. }
  844. return result;
  845. }
  846. async function copyRationSubList(originalPID,newProjectID,billIDMap,rationIDMap,projectGLJIDMap,model) {// 定额工料机,附注条件,工程量明细,定额安装增加费,模板子目
  847. let first = +new Date();
  848. let subList = await model.find({projectID:originalPID}, '-_id').lean();
  849. let newList =[];
  850. for(let s of subList){
  851. s = getCopyRationSubData(s,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  852. newList.push(s);
  853. }
  854. if(newList.length > 0) await insertMany(newList,model);
  855. let last = +new Date();
  856. console.log(model.modelName+"-------"+newList.length+"--copyRationSubList - insert时间为-------------------------------"+(last-first));
  857. }
  858. async function copyMaterialList(originalPID,newProjectID,projectGLJIDMap,model) {//暂估材料等信息
  859. let materialList = await model.find({projectID:originalPID}, '-_id').lean();
  860. let newList = [];
  861. for(let m of materialList){
  862. newList.push(getNewMaterial(m,newProjectID,projectGLJIDMap))
  863. }
  864. await insertMany(newList,model);
  865. }
  866. function getNewMaterial(m,newProjectID,projectGLJIDMap) {
  867. m.ID = uuidV1();
  868. m.projectID = newProjectID;
  869. if(projectGLJIDMap[m.projectGLJID]) m.projectGLJID = projectGLJIDMap[m.projectGLJID];
  870. return m;
  871. }
  872. function getCopyRationSubData(doc,newProjectID,billIDMap,rationIDMap,projectGLJIDMap){
  873. doc.ID = uuidV1();
  874. doc.projectID = newProjectID;
  875. doc.rationID&&rationIDMap[doc.rationID]?doc.rationID = rationIDMap[doc.rationID]:'';
  876. doc.billID&&billIDMap[doc.billID]?doc.billID = billIDMap[doc.billID]:'';
  877. doc.billsItemID&&billIDMap[doc.billsItemID]?doc.billsItemID = billIDMap[doc.billsItemID]:'';
  878. doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  879. if(doc.templateList && doc.templateList.length > 0 ){
  880. for(let t of doc.templateList){
  881. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  882. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  883. }
  884. }
  885. return doc;
  886. }
  887. async function moveProject(data) {
  888. data = JSON.parse(data);
  889. let projectMap = data.projectMap,feeRateMap = data.feeRateMap,unitPriceMap = data.unitPriceMap;
  890. let projectTasks = [],feeRateTask=[],feeRateFileTask=[],unitPriceTask=[],unitPriceFileTask=[],mixRatioTask=[];
  891. let feeUniqMap=[],priceUniqMap={};//费率、单价文件唯一映射表当移动多个项目时,任务有可能出现重复的情况
  892. if(!_.isEmpty(feeRateMap)&&data.rootProjectID){//如果费率有修改
  893. let feeRates =await feeRate_facade.getFeeRatesByProject(data.rootProjectID);//取目标建设项目的所有费率文件,重名检查
  894. for(let projectID in feeRateMap){
  895. let rename = feeRateMap[projectID].name;
  896. let feeRateID = feeRateMap[projectID].query.ID;
  897. let checkFee = _.find(feeRates,{'name':rename});
  898. let newID = feeRateID;
  899. if(checkFee){//说明费率名字已存在,需要重命名
  900. rename = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  901. projectMap[projectID]['update']['property.feeFile.name'] = rename;
  902. if(feeRateMap[projectID].action == 'move'){
  903. feeRateMap[projectID].update.name = rename;
  904. }
  905. }
  906. if(feeRateMap[projectID].action == 'copy'){
  907. newID = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].ID:uuidV1();
  908. feeRateMap[projectID].name = rename;
  909. feeRateMap[projectID].ID = newID;
  910. projectMap[projectID]['update']['property.feeFile.id'] = newID;
  911. }
  912. if(!feeUniqMap[feeRateID]){
  913. await generateFeeRateTask(feeRateMap[projectID],feeRateTask,feeRateFileTask);
  914. feeUniqMap[feeRateID] = {name:rename,ID:newID};
  915. }
  916. }
  917. }
  918. if(!_.isEmpty(unitPriceMap)&&data.rootProjectID) {//如果单价文件有修改
  919. let unitPriceFiles = await unitPriceFileModel.find({root_project_id: data.rootProjectID, deleteInfo: null});
  920. for(let projectID in unitPriceMap){
  921. let checkUn = _.find(unitPriceFiles,{'name':unitPriceMap[projectID].name});
  922. let rename = unitPriceMap[projectID].name;
  923. let unitPriceID = unitPriceMap[projectID].query.id;
  924. let newID = unitPriceID;
  925. if(checkUn){//重名检查
  926. rename = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  927. projectMap[projectID]['update']['property.unitPriceFile.name'] = rename;
  928. if(unitPriceMap[projectID].action =='move'){
  929. unitPriceMap[projectID].update.name = rename;
  930. }
  931. }
  932. if(unitPriceMap[projectID].action =='copy'){
  933. newID = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].id: await getCounterID("unit_price_file");
  934. unitPriceMap[projectID].name = rename;
  935. unitPriceMap[projectID].id = newID;
  936. projectMap[projectID]['update']['property.unitPriceFile.id'] = newID;
  937. }
  938. if(!priceUniqMap[unitPriceID]){
  939. await generateUnitPriceTask(unitPriceMap[projectID],projectID,data.user_id,unitPriceTask,unitPriceFileTask,mixRatioTask);
  940. priceUniqMap[unitPriceID] = {name:rename,id:newID};
  941. }
  942. }
  943. }
  944. if(!_.isEmpty(projectMap)){
  945. for(let projectID in projectMap){
  946. projectTasks.push({updateOne:{filter : projectMap[projectID].query, update : projectMap[projectID].update}});
  947. }
  948. }
  949. projectTasks.length>0?await projectModel.bulkWrite(projectTasks):'';
  950. feeRateTask.length>0?await feeRateModel.bulkWrite(feeRateTask):'';
  951. feeRateFileTask.length>0?await feeRateFileModel.bulkWrite(feeRateFileTask):'';
  952. unitPriceFileTask.length>0?await unitPriceFileModel.bulkWrite(unitPriceFileTask):'';
  953. unitPriceTask.length>0?await insertMany(unitPriceTask,unitPriceModel):'';
  954. mixRatioTask.length>0?await insertMany(mixRatioTask,mixRatioModel):'';
  955. return projectMap;
  956. }
  957. async function generateFeeRateTask(data,feeRateTask,feeRateFileTask) {
  958. if(data.action == 'move'){
  959. let task = {
  960. updateOne:{
  961. filter : data.query,
  962. update : data.update
  963. }
  964. };
  965. feeRateFileTask.push(task);
  966. }
  967. if(data.action == 'copy'){//copy 费率的时候用insertOne方法
  968. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(data.query.ID);
  969. let newFeeRateID = uuidV1();
  970. let newFeeRate = {
  971. ID:newFeeRateID,
  972. rates:feeRate.rates
  973. };
  974. let newFeeRateFile = {
  975. ID:data.ID,
  976. rootProjectID:data.rootProjectID,
  977. userID:feeRateFile.userID,
  978. name:data.name,
  979. libID:feeRateFile.libID,
  980. libName:feeRateFile.libName,
  981. feeRateID:newFeeRateID
  982. };
  983. feeRateTask.push({insertOne :{document:newFeeRate}});
  984. feeRateFileTask.push({insertOne :{document:newFeeRateFile}});
  985. }
  986. }
  987. async function generateUnitPriceTask(data,projectID,user_id,unitPriceTask,unitPriceFileTask,mixRatioTask){
  988. if(data.action == 'move'){
  989. let task = {
  990. updateOne:{
  991. filter : data.query,
  992. update : data.update
  993. }
  994. };
  995. unitPriceFileTask.push(task);
  996. }
  997. if(data.action == 'copy'){
  998. let newUnitFile = {
  999. id:data.id,
  1000. name: data.name,
  1001. project_id:projectID,
  1002. user_id:user_id,
  1003. root_project_id: data.rootProjectID
  1004. };
  1005. unitPriceFileTask.push({insertOne :{document:newUnitFile}});
  1006. let mixRatios = await mixRatioModel.find({unit_price_file_id: data.query.id});
  1007. mixRatios = JSON.stringify(mixRatios);
  1008. mixRatios = JSON.parse(mixRatios);
  1009. for(let m of mixRatios){
  1010. delete m._id; // 删除原有id信息
  1011. delete m.id;
  1012. m.unit_price_file_id = data.id;
  1013. m.id = await getCounterID('mix_ratio');
  1014. mixRatioTask.push(m);
  1015. }
  1016. let unitPrices = await unitPriceModel.find({unit_price_file_id: data.query.id});//unit_price_file_id
  1017. unitPrices = JSON.stringify(unitPrices);
  1018. unitPrices = JSON.parse(unitPrices);
  1019. for(let u of unitPrices){
  1020. delete u._id; // 删除原有id信息
  1021. delete u.id;
  1022. u.unit_price_file_id = data.id;
  1023. u.id = await getCounterID('unit_price');
  1024. unitPriceTask.push(u);
  1025. }
  1026. }
  1027. }
  1028. async function getCounterID(collectionName){
  1029. let counterModel = new CounterModel();
  1030. return await counterModel.getId(collectionName);
  1031. }
  1032. async function insertMany(datas,model) {
  1033. /* while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入 2020-05-28 测试后发现没有限制,暂时先保留代码
  1034. let newList = datas.splice(0,1000);//一次插入1000条
  1035. await model.insertMany(newList);
  1036. } */
  1037. await model.insertMany(datas);
  1038. }
  1039. function setProperty(Obj,updateData) {
  1040. for(let ukey in updateData){
  1041. if(_.isObject(updateData[ukey]) && _.isObject(Obj[ukey])){
  1042. setProperty(Obj[ukey],updateData[ukey]);
  1043. }else {
  1044. Obj[ukey] = updateData[ukey];
  1045. }
  1046. }
  1047. }
  1048. function isDef(v){
  1049. return typeof v !== 'undefined' && v !== null;
  1050. }
  1051. function getTotalFee(bills, feeName) {
  1052. if(!isDef(bills)){
  1053. return 0;
  1054. }
  1055. if(!isDef(bills.fees) || bills.fees.length <= 0){
  1056. return 0;
  1057. }
  1058. for(let fee of bills.fees){
  1059. if(isDef(fee.fieldName) && fee.fieldName === feeName){
  1060. return isDef(fee.tenderTotalFee)
  1061. ? fee.tenderTotalFee
  1062. : isDef(fee.totalFee)
  1063. ? fee.totalFee
  1064. : 0;
  1065. }
  1066. }
  1067. return 0;
  1068. }
  1069. function summarizeToParent(parent, child, fields = null) {
  1070. const decimal = -2;
  1071. if (!fields) {
  1072. fields = ['engineeringCost', 'subEngineering', 'measure', 'safetyConstruction', 'other', 'charge', 'tax', 'estimate'];
  1073. }
  1074. for (let field of fields) {
  1075. parent[field] = scMathUtil.roundTo(parseFloat(parent[field]) + parseFloat(child[field]), decimal);
  1076. }
  1077. }
  1078. function getBuildingArea(projFeature){
  1079. if(!projFeature || projFeature.length === 0){
  1080. return null;
  1081. }
  1082. for(let f of projFeature){
  1083. if(f.key === 'buildingArea'){
  1084. return f.value;
  1085. }
  1086. }
  1087. return null;
  1088. }
  1089. //根据单位工程ID获取经济指标信息
  1090. //@param {Number}prj_id @return {Object}
  1091. async function getIndexReportData(prj_id, filters) {
  1092. return await project_facade.getIndexReportData(prj_id, filters);
  1093. }
  1094. // 根据树结构数据排序
  1095. function getSortedDataByTree(data) {
  1096. // NextSiblingID-数据映射
  1097. const mapping = {};
  1098. data.forEach(item => {
  1099. // 错误数据兼容处理
  1100. // 由于之前的导入建设项目,会导致最后的一个项目的NextSiblingID为空,为非正确的-1
  1101. // 因此把项目中NextSibling为空的数据设置为NextSiblingID为-1
  1102. if (!item.NextSiblingID) {
  1103. item.NextSiblingID = -1;
  1104. }
  1105. mapping[item.NextSiblingID] = item;
  1106. });
  1107. let lastItem = data.find(item => +item.NextSiblingID === -1);
  1108. if (!lastItem) {
  1109. return data;
  1110. }
  1111. const rst = [lastItem];
  1112. let preItem = mapping[lastItem.ID];
  1113. while (preItem) {
  1114. rst.unshift(preItem);
  1115. preItem = mapping[preItem.ID];
  1116. }
  1117. // 根据树结构排序形成的新数组与旧数组项数不同,说明树结构数据有问题(断链),则返回原本数据。
  1118. return rst.length === data.length ? rst : data;
  1119. }
  1120. //根据单位工程ID获取汇总信息
  1121. //@param {Number}tenderID {String}summaryType @return {Object}
  1122. async function getSummaryInfoByTender(tenderID, summaryType) {
  1123. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  1124. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  1125. let parent,
  1126. parentName,
  1127. compilationIllustration;
  1128. let summaryList = [];
  1129. if(!tender){
  1130. return null;
  1131. }
  1132. let engineering = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  1133. if(!engineering){
  1134. return null;
  1135. }
  1136. let project = await projectModel.findOne({ID: engineering.ParentID, $or: notDeleted});
  1137. if(!project){
  1138. return null;
  1139. }
  1140. let summaryInfo = await getSummaryInfo([project.ID]);
  1141. if(summaryType === projectType.engineering){ // 汇总到单项工程级别
  1142. parent = engineering;
  1143. let tenders = await projectModel.find({ParentID: engineering.ID, $or: notDeleted}).lean();
  1144. tenders = getSortedDataByTree(tenders);
  1145. for(let t of tenders){
  1146. if(summaryInfo[t.ID]){
  1147. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  1148. summaryList.push(summaryInfo[t.ID]);
  1149. }
  1150. }
  1151. } else { // 汇总到建设项目级别
  1152. parent = project;
  1153. let engs = await projectModel.find({ParentID: project.ID, $or: notDeleted}).lean();
  1154. engs = getSortedDataByTree(engs);
  1155. for(let e of engs){
  1156. if(summaryInfo[e.ID]){
  1157. summaryInfo[e.ID]['name'] = e.name ? e.name : '';
  1158. summaryList.push(summaryInfo[e.ID]);
  1159. }
  1160. }
  1161. }
  1162. // 项目名称
  1163. parentName = parent && parent.name
  1164. ? parent.name
  1165. : '';
  1166. // 编制说明
  1167. compilationIllustration = parent && parent.property && parent.property.compilationIllustration
  1168. ? parent.property.compilationIllustration
  1169. : '';
  1170. return {
  1171. parent: {
  1172. name: parentName,
  1173. compilationIllustration: compilationIllustration},
  1174. subList: summaryList
  1175. };
  1176. }
  1177. //获取单位工程的各标段费用信息(不进行汇总)
  1178. async function getTendersFeeInfo(tenders) {
  1179. let IDMapping = {};
  1180. //固定清单类别与汇总金额字段映射
  1181. let flagFieldMapping = {};
  1182. flagFieldMapping[fixedFlag.ENGINEERINGCOST] = 'engineeringCost';
  1183. flagFieldMapping[fixedFlag.SUB_ENGINERRING] = 'subEngineering';
  1184. flagFieldMapping[fixedFlag.MEASURE] = 'measure';
  1185. flagFieldMapping[fixedFlag.SAFETY_CONSTRUCTION] = 'safetyConstruction';
  1186. flagFieldMapping[fixedFlag.OTHER] = 'other';
  1187. flagFieldMapping[fixedFlag.CHARGE] = 'charge';
  1188. flagFieldMapping[fixedFlag.TAX] = 'tax';
  1189. let tenderIDs = [];
  1190. if(tenders.length > 0){
  1191. for(let tender of tenders){
  1192. tenderIDs.push(tender.ID);
  1193. IDMapping[tender.ID] = {engineeringCost: 0, subEngineering: 0, measure: 0, safetyConstruction: 0, other: 0, charge: 0, tax: 0, estimate: 0, rate: 0, buildingArea: '', perCost: ''};
  1194. IDMapping[tender.ID]['buildingArea'] = '';
  1195. }
  1196. //需要获取的清单固定类别综合合价:工程造价、分部分项、措施项目、安全文明施工专项、规费、其他项目、税金
  1197. let needFlags = [fixedFlag.ENGINEERINGCOST, fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE,
  1198. fixedFlag.SAFETY_CONSTRUCTION, fixedFlag.CHARGE, fixedFlag.OTHER, fixedFlag.TAX];
  1199. //获取单位工程汇总金额需要用到的所有清单
  1200. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: notDeleted},
  1201. '-_id projectID fees flags');
  1202. //进行单位工程级别的汇总
  1203. for(let bills of allBills){
  1204. let billsFlag = bills.flags[0]['flag'];
  1205. let costField = flagFieldMapping[billsFlag];
  1206. IDMapping[bills.projectID][costField] = getTotalFee(bills, 'common');
  1207. //暂估合价(工程造价暂估合价)
  1208. if (billsFlag === fixedFlag.ENGINEERINGCOST){
  1209. IDMapping[bills.projectID]['estimate'] = getTotalFee(bills, 'estimate');
  1210. }
  1211. }
  1212. //占造价比例、单方造价
  1213. for(let tender of tenders){
  1214. let tenderInfo = IDMapping[tender.ID];
  1215. tenderInfo.rate = '';
  1216. //单方造价
  1217. tenderInfo.perCost = '';
  1218. }
  1219. }
  1220. return IDMapping;
  1221. }
  1222. const defaultSummaryField = {
  1223. [fixedFlag.ENGINEERINGCOST]: {
  1224. items: [
  1225. { name: 'engineeringCost', feeName: 'common' },
  1226. { name: 'estimate', feeName: 'estimate' }
  1227. ]
  1228. },
  1229. [fixedFlag.SUB_ENGINERRING]: {
  1230. items: [{ name: 'subEngineering', feeName: 'common' }]
  1231. },
  1232. [fixedFlag.MEASURE]: {
  1233. items: [{ name: 'measure', feeName: 'common' }]
  1234. },
  1235. [fixedFlag.SAFETY_CONSTRUCTION]: {
  1236. items: [{ name: 'safetyConstruction', feeName: 'common' }]
  1237. },
  1238. [fixedFlag.OTHER]: {
  1239. items: [{ name: 'other', feeName: 'common' }]
  1240. },
  1241. [fixedFlag.CHARGE]: {
  1242. items: [{ name: 'charge', feeName: 'common' }]
  1243. },
  1244. [fixedFlag.TAX]: {
  1245. items: [{ name: 'tax', feeName: 'common' }]
  1246. }
  1247. };
  1248. // 项目管理界面需要显示的汇总字段
  1249. function setupSummaryFields(summaryInfo, projects, fields = null) {
  1250. if (!fields) {
  1251. fields = [
  1252. 'engineeringCost',
  1253. 'subEngineering',
  1254. 'measure',
  1255. 'safetyConstruction',
  1256. 'other',
  1257. 'charge',
  1258. 'tax',
  1259. 'rate',
  1260. 'buildingArea',
  1261. 'perCost'
  1262. ];
  1263. }
  1264. for(const proj of projects){
  1265. const summaryProj = summaryInfo[proj.ID];
  1266. if(summaryProj){
  1267. for (const field of fields) {
  1268. proj[field] = summaryProj[field];
  1269. }
  1270. }
  1271. }
  1272. }
  1273. async function getSummaryInfo(projectIDs, summaryField = defaultSummaryField){
  1274. function initFees(target, summaryField) {
  1275. for (const flag in summaryField) {
  1276. const summaryItem = summaryField[flag];
  1277. summaryItem.items.forEach(item => {
  1278. target[item.name] = 0;
  1279. });
  1280. }
  1281. }
  1282. //ID与汇总信息映射
  1283. let IDMapping = {};
  1284. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1285. //设置建设项目的总建筑面积
  1286. for(let project of projects){
  1287. let grossArea = '';
  1288. if(project.property && project.property.basicInformation){
  1289. for(let basicInfo of project.property.basicInformation){
  1290. if(basicInfo.key === 'basicInfo'){
  1291. for(let k of basicInfo.items){
  1292. if(k.key === 'grossArea'){
  1293. grossArea = k.value;
  1294. }
  1295. }
  1296. }
  1297. }
  1298. }
  1299. IDMapping[project.ID] = {rate: 0, buildingArea: grossArea, perCost: ''};
  1300. initFees(IDMapping[project.ID], summaryField);
  1301. }
  1302. //单项工程
  1303. let engineerings = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.engineering, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1304. let tenders = [];
  1305. let engIDs = [];
  1306. for(let eng of engineerings){
  1307. engIDs.push(eng.ID);
  1308. IDMapping[eng.ID] = {rate: 0, buildingArea: '', perCost: ''};
  1309. initFees(IDMapping[eng.ID], summaryField);
  1310. }
  1311. //单位工程
  1312. if(engIDs.length > 0){
  1313. tenders = await projectModel.find({ParentID: {$in : engIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1314. }
  1315. let tenderIDs = [];
  1316. if(tenders.length > 0){
  1317. for(let tender of tenders){
  1318. tenderIDs.push(tender.ID);
  1319. IDMapping[tender.ID] = {rate: 0, buildingArea: '', perCost: '', changeMark:tender.changeMark,property:tender.property};
  1320. initFees(IDMapping[tender.ID], summaryField);
  1321. let buildingArea = getBuildingArea(tender.property.projectFeature);
  1322. if(buildingArea){
  1323. IDMapping[tender.ID]['buildingArea'] = buildingArea;
  1324. }
  1325. }
  1326. //需要获取的清单固定类别综合合价:工程造价、分部分项、措施项目、安全文明施工专项、规费、其他项目、税金...
  1327. let needFlags = Object.getOwnPropertyNames(summaryField);
  1328. //获取单位工程汇总金额需要用到的所有清单
  1329. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  1330. '-_id projectID fees flags');
  1331. //进行单位工程级别的汇总
  1332. for(let bills of allBills){
  1333. let billsFlag = bills.flags[0]['flag'];
  1334. // 设置上单位工程需要汇总的字段金额
  1335. const summaryItem = summaryField[billsFlag];
  1336. summaryItem.items.forEach(costItem => {
  1337. IDMapping[bills.projectID][costItem.name] = getTotalFee(bills, costItem.feeName);
  1338. });
  1339. }
  1340. const summaryNames = [];
  1341. for (const flag in summaryField) {
  1342. summaryField[flag].items.forEach(item => summaryNames.push(item.name));
  1343. }
  1344. //进行单项工程级别的汇总
  1345. for(let tender of tenders){
  1346. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID], summaryNames);
  1347. }
  1348. //进行建设项目级别的汇总
  1349. for(let eng of engineerings){
  1350. summarizeToParent(IDMapping[eng.ParentID], IDMapping[eng.ID], summaryNames);
  1351. }
  1352. //占造价比例、单方造价
  1353. const rateDecimal = -2;
  1354. const perCostDecimal = -2;
  1355. for(let tender of tenders){
  1356. let tenderInfo = IDMapping[tender.ID];
  1357. let engInfo = IDMapping[tender.ParentID];
  1358. tenderInfo.rate = engInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(tenderInfo.engineeringCost * 100 / engInfo.engineeringCost, rateDecimal);
  1359. //单方造价
  1360. tenderInfo.perCost = tenderInfo.buildingArea.toString().trim() === '' || tenderInfo.buildingArea == 0
  1361. ? tenderInfo.buildingArea.toString().trim()
  1362. : scMathUtil.roundTo(tenderInfo.engineeringCost / tenderInfo.buildingArea, perCostDecimal);
  1363. }
  1364. for(let eng of engineerings){
  1365. let engInfo = IDMapping[eng.ID];
  1366. let projInfo = IDMapping[eng.ParentID];
  1367. engInfo.rate = !isDef(projInfo) || projInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(engInfo.engineeringCost * 100 / projInfo.engineeringCost, rateDecimal);
  1368. }
  1369. //建设项目占造价比例及单方造价
  1370. for(let project of projects){
  1371. let projectInfo = IDMapping[project.ID];
  1372. projectInfo.rate = 100;
  1373. projectInfo.perCost = projectInfo.buildingArea.toString().trim() === '' || projectInfo.buildingArea == 0
  1374. ? projectInfo.buildingArea.toString().trim()
  1375. : scMathUtil.roundTo(projectInfo.engineeringCost / projectInfo.buildingArea, perCostDecimal);
  1376. }
  1377. }
  1378. return IDMapping;
  1379. }
  1380. /* async function getSummaryInfo(projectIDs, feeFields = null, engineeringCostFields = null){
  1381. function initFees(obj, feeFields, engineeringCostFields) {
  1382. for (let data of feeFields) {
  1383. obj[data.v] = 0;
  1384. }
  1385. for (let data of engineeringCostFields) {
  1386. obj[data.k] = 0;
  1387. }
  1388. }
  1389. if (!feeFields) {
  1390. feeFields = [
  1391. {k: fixedFlag.ENGINEERINGCOST, v: 'engineeringCost'},
  1392. {k: fixedFlag.SUB_ENGINERRING, v: 'subEngineering'},
  1393. {k: fixedFlag.MEASURE, v: 'measure'},
  1394. {k: fixedFlag.SAFETY_CONSTRUCTION, v: 'safetyConstruction'},
  1395. {k: fixedFlag.OTHER, v: 'other'},
  1396. {k: fixedFlag.CHARGE, v: 'charge'},
  1397. {k: fixedFlag.TAX, v: 'tax'}
  1398. ];
  1399. }
  1400. // 项目总造价的各个费用,k为汇总的字段,v为工程造价的费用字段
  1401. if (!engineeringCostFields) {
  1402. engineeringCostFields = [{ k: 'estimate', v: 'estimate' }];
  1403. }
  1404. //ID与汇总信息映射
  1405. let IDMapping = {};
  1406. //固定清单类别与汇总金额字段映射
  1407. let flagFieldMapping = {};
  1408. for (let data of feeFields) {
  1409. flagFieldMapping[data.k] = data.v;
  1410. }
  1411. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1412. //设置建设项目的总建筑面积
  1413. for(let project of projects){
  1414. let grossArea = '';
  1415. if(project.property && project.property.basicInformation){
  1416. for(let basicInfo of project.property.basicInformation){
  1417. if(basicInfo.key === 'basicInfo'){
  1418. for(let k of basicInfo.items){
  1419. if(k.key === 'grossArea'){
  1420. grossArea = k.value;
  1421. }
  1422. }
  1423. }
  1424. }
  1425. }
  1426. IDMapping[project.ID] = {rate: 0, buildingArea: grossArea, perCost: ''};
  1427. initFees(IDMapping[project.ID], feeFields, engineeringCostFields);
  1428. console.log(IDMapping[project.ID]);
  1429. }
  1430. //单项工程
  1431. let engineerings = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.engineering, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1432. let tenders = [];
  1433. let engIDs = [];
  1434. for(let eng of engineerings){
  1435. engIDs.push(eng.ID);
  1436. IDMapping[eng.ID] = {rate: 0, buildingArea: '', perCost: ''};
  1437. initFees(IDMapping[eng.ID], feeFields, engineeringCostFields);
  1438. }
  1439. //单位工程
  1440. if(engIDs.length > 0){
  1441. tenders = await projectModel.find({ParentID: {$in : engIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  1442. }
  1443. let tenderIDs = [];
  1444. if(tenders.length > 0){
  1445. for(let tender of tenders){
  1446. tenderIDs.push(tender.ID);
  1447. IDMapping[tender.ID] = {rate: 0, buildingArea: '', perCost: '', changeMark:tender.changeMark,property:tender.property};
  1448. initFees(IDMapping[tender.ID], feeFields, engineeringCostFields);
  1449. let buildingArea = getBuildingArea(tender.property.projectFeature);
  1450. if(buildingArea){
  1451. IDMapping[tender.ID]['buildingArea'] = buildingArea;
  1452. }
  1453. }
  1454. //需要获取的清单固定类别综合合价:工程造价、分部分项、措施项目、安全文明施工专项、规费、其他项目、税金...
  1455. let needFlags = feeFields.map(data => data.k);
  1456. //获取单位工程汇总金额需要用到的所有清单
  1457. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  1458. '-_id projectID fees flags');
  1459. //进行单位工程级别的汇总
  1460. for(let bills of allBills){
  1461. let billsFlag = bills.flags[0]['flag'];
  1462. let costField = flagFieldMapping[billsFlag];
  1463. IDMapping[bills.projectID][costField] = getTotalFee(bills, 'common');
  1464. // 工程造价各费用
  1465. if (billsFlag === fixedFlag.ENGINEERINGCOST){
  1466. engineeringCostFields.forEach(({k, v}) => {
  1467. IDMapping[bills.projectID][k] = getTotalFee(bills, v);
  1468. });
  1469. }
  1470. }
  1471. let summaryFields = [...feeFields, ...engineeringCostFields].map(data => data.v);
  1472. //进行单项工程级别的汇总
  1473. for(let tender of tenders){
  1474. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID], summaryFields);
  1475. }
  1476. //进行建设项目级别的汇总
  1477. for(let eng of engineerings){
  1478. summarizeToParent(IDMapping[eng.ParentID], IDMapping[eng.ID], summaryFields);
  1479. }
  1480. //占造价比例、单方造价
  1481. const rateDecimal = -2;
  1482. const perCostDecimal = -2;
  1483. for(let tender of tenders){
  1484. let tenderInfo = IDMapping[tender.ID];
  1485. let engInfo = IDMapping[tender.ParentID];
  1486. tenderInfo.rate = engInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(tenderInfo.engineeringCost * 100 / engInfo.engineeringCost, rateDecimal);
  1487. //单方造价
  1488. tenderInfo.perCost = tenderInfo.buildingArea.toString().trim() === '' || tenderInfo.buildingArea == 0
  1489. ? tenderInfo.buildingArea.toString().trim()
  1490. : scMathUtil.roundTo(tenderInfo.engineeringCost / tenderInfo.buildingArea, perCostDecimal);
  1491. }
  1492. for(let eng of engineerings){
  1493. let engInfo = IDMapping[eng.ID];
  1494. let projInfo = IDMapping[eng.ParentID];
  1495. engInfo.rate = !isDef(projInfo) || projInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(engInfo.engineeringCost * 100 / projInfo.engineeringCost, rateDecimal);
  1496. }
  1497. //建设项目占造价比例及单方造价
  1498. for(let project of projects){
  1499. let projectInfo = IDMapping[project.ID];
  1500. projectInfo.rate = 100;
  1501. projectInfo.perCost = projectInfo.buildingArea.toString().trim() === '' || projectInfo.buildingArea == 0
  1502. ? projectInfo.buildingArea.toString().trim()
  1503. : scMathUtil.roundTo(projectInfo.engineeringCost / projectInfo.buildingArea, perCostDecimal);
  1504. }
  1505. }
  1506. return IDMapping;
  1507. } */
  1508. //根据项目ID获取所属建设项目
  1509. //@param {Number}projectID @return {Object}
  1510. async function getConstructionProject(projectID){
  1511. function returnProject(project){
  1512. if(!project || project.projType === projectType.folder){
  1513. return null;
  1514. }
  1515. if(project.projType === projectType.project){
  1516. return project;
  1517. }
  1518. }
  1519. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  1520. let returnV = returnProject(project);
  1521. if(returnV !== undefined){
  1522. return returnV;
  1523. }
  1524. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  1525. returnV = returnProject(parent);
  1526. if(returnV !== undefined){
  1527. return returnV;
  1528. }
  1529. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  1530. returnV = returnProject(grandParent);
  1531. return returnV !== undefined ? returnV : null;
  1532. }
  1533. //获取单位工程完整目录结构
  1534. //@param {Number}projectID @return {Arry}
  1535. async function getFullPath(projectID) {
  1536. let fullPath = [];
  1537. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  1538. if(project){
  1539. fullPath.push(project.name);
  1540. await getParent(project.ParentID);
  1541. }
  1542. fullPath = fullPath.reverse();
  1543. return fullPath;
  1544. async function getParent(ParentID) {
  1545. if(ParentID != -1){
  1546. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  1547. if(parent){
  1548. fullPath.push(parent.name);
  1549. await getParent(parent.ParentID);
  1550. }
  1551. }
  1552. }
  1553. }
  1554. //获取累进区间数据
  1555. async function getProgressiveInterval(libID) {
  1556. let lib = await progressiveModel.findOne({ID: libID});
  1557. return lib ? lib.data : [];
  1558. }
  1559. // 获取项目链上,自身、父项、爷爷项...的ID
  1560. async function getUpChainIDs(projectID) {
  1561. const rst = [];
  1562. while (projectID != -1) {
  1563. rst.push(projectID);
  1564. const project = await projectModel.findOne({ ID: projectID }, '-_id ParentID').lean();
  1565. projectID = project ? project.ParentID : -1;
  1566. }
  1567. return rst;
  1568. }
  1569. //获取projectIDs文件下所有子项目(默认不包括projectIDs本身)
  1570. async function getPosterityProjects(projectIDs, includeSelf = false, fields = '-_id') {
  1571. let rst = [];
  1572. if (includeSelf) {
  1573. const projects = await projectModel.find({ID: {$in: projectIDs}, $or: notDeleted}, fields).lean();
  1574. if (projects) {
  1575. rst.push(...projects);
  1576. }
  1577. }
  1578. async function getProjects(parentIDs) {
  1579. if (parentIDs.length > 0) {
  1580. let newIDs = [];
  1581. let projs = await projectModel.find({ParentID: {$in: parentIDs}, $or: notDeleted}, fields).lean();
  1582. for (let proj of projs) {
  1583. // 兼容旧的错误数据,可能ParentID和ID相同
  1584. if (parentIDs.includes(proj.ID)) {
  1585. continue;
  1586. }
  1587. rst.push(proj);
  1588. newIDs.push(proj.ID);
  1589. }
  1590. await getProjects(newIDs);
  1591. }
  1592. }
  1593. await getProjects(projectIDs);
  1594. return rst;
  1595. }
  1596. //根据项目获得分享信息(分享层级不一定在项目级)(以最新为准)
  1597. async function getShareInfo(userID, projectID) {
  1598. // 接受到的分享项目
  1599. const upChainIDs = await getUpChainIDs(projectID);
  1600. const shareList = await getShareList({receiver: userID, projectID: {$in: upChainIDs}});
  1601. // 返回最新的分享
  1602. //return shareList.sort((a, b) => Date.parse(b.shareDate) - Date.parse(a.shareDate))[0];
  1603. return shareList.sort((a, b) => Date.parse(b.updateDate) - Date.parse(a.updateDate))[0];
  1604. }
  1605. //打开的单位工程是否是被分享的.
  1606. async function isShare(userId, project){
  1607. //判断是否是打开分享的项目,属于分享文件的子项也算
  1608. while (project) {
  1609. for(let shareData of project.shareInfo){
  1610. if(shareData.userID === userId){
  1611. return true;
  1612. }
  1613. }
  1614. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  1615. }
  1616. return false;
  1617. }
  1618. //用户是否第一次进入费用定额
  1619. async function isFirst(userId, compilationId) {
  1620. let userData = await userModel.findOne({_id: mongoose.Types.ObjectId(userId)}, '-_id used_list');
  1621. let first = false;
  1622. if (userData) {
  1623. first = !_.find(userData.used_list, function (o) {
  1624. return o.compilationId === compilationId;
  1625. });;
  1626. }
  1627. return first;
  1628. }
  1629. async function copyConstructionProject(data){
  1630. let log_data = {
  1631. key:data.key,
  1632. content: '正在复制建设项目,请稍候……',
  1633. userID:data.user_id,
  1634. compilationID: data.session.sessionCompilation._id,
  1635. status:"start",
  1636. create_time:+new Date()
  1637. };
  1638. await importLogsModel.create(log_data);
  1639. doCopy(data.user_id,data.session.sessionCompilation._id,data.projectID,data.newName,data.key);
  1640. return "start copy";
  1641. async function doCopy(user_id,compilationId,projectID,newName,key) {
  1642. let doc = {status:"finish"};
  1643. try {
  1644. let nameMap={};
  1645. nameMap[projectID] = newName
  1646. let r = await copyExample(user_id,compilationId,[projectID],nameMap);
  1647. if(r == false){
  1648. doc.errorMsg = "复制失败,请检查项目是否存在!";
  1649. doc.status = "error";
  1650. }
  1651. }catch (error){
  1652. console.log(error);
  1653. doc.errorMsg = "复制失败,请检查项目是否存在!";
  1654. doc.status = "error";
  1655. }finally {
  1656. await importLogsModel.update({key:key},doc);
  1657. }
  1658. }
  1659. }
  1660. async function importChongqingProject(data) {
  1661. let log_data = {
  1662. key:data.key,
  1663. content: '正在导入例题,请稍候……',
  1664. userID:data.user_id,
  1665. compilationID: data.session.sessionCompilation._id,
  1666. status:"start",
  1667. create_time:+new Date()
  1668. };
  1669. await importLogsModel.create(log_data);
  1670. doImport(data.user_id,data.session.sessionCompilation._id,data.session.sessionCompilation.adProjects,data.key);
  1671. return "start importing";
  1672. }
  1673. //加载例题
  1674. async function importExampleProject(data) {
  1675. let log_data = {
  1676. key:data.key,
  1677. content: '正在导入例题,请稍候……',
  1678. userID:data.user_id,
  1679. compilationID: data.session.sessionCompilation._id,
  1680. status:"start",
  1681. create_time:+new Date()
  1682. };
  1683. await importLogsModel.create(log_data);
  1684. doImport(data.user_id,data.session.sessionCompilation._id,data.session.sessionCompilation.example,data.key);
  1685. return "start importing";
  1686. }
  1687. async function doImport(user_id,compilationId,projectIDs,key) {
  1688. let doc = {status:"finish"};
  1689. try {
  1690. let r = await copyExample(user_id,compilationId,projectIDs);
  1691. if(r == false){
  1692. doc.errorMsg = "导入失败,请检查项目是否存在!";
  1693. doc.status = "error";
  1694. } else {
  1695. doc.projectID = r;
  1696. }
  1697. }catch (error){
  1698. console.log(error);
  1699. doc.errorMsg = "导入失败,请检查项目是否存在!";
  1700. doc.status = "error";
  1701. }finally {
  1702. await importLogsModel.update({key:key},doc);
  1703. }
  1704. }
  1705. //用户第一次进入费用定额的数据准备
  1706. async function prepareInitialData(userId, compilation, example) {
  1707. let first = await isFirst(userId, compilation);
  1708. if (first) {
  1709. await updateUsedList(userId, compilation);
  1710. const logData = {
  1711. key: uuidV1(),
  1712. content: '正在初始化数据,请稍候……',
  1713. userID: userId,
  1714. compilationID: compilation,
  1715. status: 'start',
  1716. create_time: +new Date()
  1717. };
  1718. await importLogsModel.create(logData);
  1719. initData(logData.key, userId, compilation, example);
  1720. return 'start prepareInitialData';
  1721. }
  1722. async function initData(key, userId, compilation, example) {
  1723. const doc = { status: 'finish' };
  1724. try {
  1725. let prepareTask = [
  1726. copyCompleRationSection(userId, compilation),
  1727. copyCompleGljSection(userId, compilation)
  1728. ];
  1729. /* 2021-01-19 第一次的时候不自动加载例题,右键加载
  1730. if (example && example.length > 0) {
  1731. prepareTask.push(copyExample(userId, compilation, example));
  1732. } */
  1733. await Promise.all(prepareTask);
  1734. } catch (error) {
  1735. doc.errorMsg = '加载例题失败,请检查例题项目是否存在!';
  1736. doc.status = 'error';
  1737. } finally {
  1738. await importLogsModel.update({ key }, doc);
  1739. }
  1740. }
  1741. }
  1742. async function updateUsedList(userId, compilation) {
  1743. await userModel.update({_id: mongoose.Types.ObjectId(userId)}, {$push: {used_list: {compilationId: compilation}}});
  1744. }
  1745. //拷贝补充定额章节树
  1746. async function copyCompleRationSection(userId, compilationId) {
  1747. await sectionTreeDao.copyDataFromTemplate(userId, compilationId);
  1748. }
  1749. //拷贝补充人材机分类树
  1750. async function copyCompleGljSection(userId, compilationId) {
  1751. // 如果已有数据则不再生成
  1752. const count = await compleGljSectionModel.count({userId, compilationId});
  1753. if (count) {
  1754. return;
  1755. }
  1756. let templateData = await compleGljSectionTModel.find({compilationId: compilationId});
  1757. if (templateData.length > 0) {
  1758. let insertDatas = [],
  1759. uuidMapping = {};
  1760. //将ID替换成UUID
  1761. for (let temData of templateData) {
  1762. uuidMapping[temData.ID] = uuidV1();
  1763. }
  1764. for(let temData of templateData) {
  1765. let insertD = {
  1766. userId: userId,
  1767. compilationId: compilationId,
  1768. Name: temData.Name,
  1769. ID: uuidMapping[temData.ID],
  1770. ParentID: uuidMapping[temData.ParentID] || -1,
  1771. NextSiblingID: uuidMapping[temData.NextSiblingID] || -1,
  1772. };
  1773. insertDatas.push(insertD);
  1774. }
  1775. //插入数据
  1776. await compleGljSectionModel.insertMany(insertDatas);
  1777. }
  1778. }
  1779. async function changeFile(datas,userID,fileID,name,from,type){//from 费率或单价文件,type从单前建设项目还是从其它建设项目中复制
  1780. let projectIDs = [],newFile = {id:fileID,name:name};//计录从其它项目中复制的文件,选中多个的时候只需复制一次
  1781. let projectUpdateType = from == "feeRateFile"?"feeRate":"unitFile";
  1782. for(let d of datas){
  1783. let tem_file = from == "feeRateFile"? await feeRate_facade.changeFeeRateFile(d, newFile,type,userID):await glj_facade.changeUnitFile(d, newFile,type,userID);
  1784. if(type == 1 && tem_file){//从建设项目复制时,只有第一次需要复制,剩下的就相当于使用同个建设项目的情况了
  1785. let newID = from == "feeRateFile"?tem_file.ID:tem_file.id;
  1786. newFile = {id:newID,name:tem_file.name};
  1787. type = 0;
  1788. }
  1789. projectIDs.push({ID:d.projectID})
  1790. }
  1791. await project_facade.markProjectsToChange(projectIDs,projectUpdateType)//项目标记为待刷新状态
  1792. }
  1793. //获取费用定额绑定的基本信息库数据
  1794. async function getBasicInfo(compilationID, fileKind = null) {
  1795. let compilation = await compilationModel.findOne({_id: mongoose.Types.ObjectId(compilationID)});
  1796. if (!compilation) {
  1797. return null;
  1798. }
  1799. let billValuation = compilation.bill_valuation.find(function (data) {
  1800. return data.enable;
  1801. });
  1802. if (!billValuation) {
  1803. return null;
  1804. }
  1805. let engineerings = await engineeringModel.find({valuationID: billValuation.id});
  1806. let engineering = engineerings.find(function (data) {
  1807. return data.info_lib && data.info_lib.length > 0;
  1808. });
  1809. if (!engineering || !engineering.info_lib || !engineering.info_lib[0]) {
  1810. return null;
  1811. }
  1812. let infoLib = await basicInfoModel.findOne({ID: engineering.info_lib[0].id});
  1813. //提取文件类型中需要的数据 (投标项目可能不需要招标的一些信息)
  1814. if (fileKind && infoLib && infoLib.info && infoLib.info.length) {
  1815. let strMap = {
  1816. 1: '投标', //投标
  1817. 2: '招标', //招标
  1818. 3: '控制价' //控制价
  1819. };
  1820. let needfulData = infoLib.info.filter(data => !data.fileKind || data.fileKind === strMap[fileKind]);
  1821. needfulData.forEach(nData => {
  1822. let needfulSub = nData.items.filter(sData => !sData.fileKind || sData.fileKind === strMap[fileKind]);
  1823. nData.items = needfulSub;
  1824. });
  1825. infoLib.info = needfulData;
  1826. }
  1827. return infoLib;
  1828. }
  1829. async function getProjectFeature(valuationID, engineeringName, feeName) {
  1830. let engineering = await engineeringModel.findOne({valuationID: valuationID, name: engineeringName, feeName: feeName});
  1831. if (!engineering || !engineering.feature_lib || !engineering.feature_lib[0]) {
  1832. return null;
  1833. }
  1834. let featureLib = await projectFeatureModel.findOne({ID: engineering.feature_lib[0].id});
  1835. return featureLib;
  1836. }
  1837. //根据单位工程,获取建设项目-单项工程-单位工程,不包含无单位工程的单项工程
  1838. //@param {Number}tenderID(单位工程ID) {Number}granularity(颗粒度 1:建设项目 2:单项工程 3:单位工程)
  1839. async function getProjectByGranularity(tenderID, granularity, summaryField, userID, versionName) {
  1840. const GRANULARITY = {
  1841. PROJECT: 1,
  1842. ENGINEERING: 2,
  1843. TENDER: 3
  1844. };
  1845. let theTender = await projectModel.findOne({userID: userID, ID: tenderID}).lean(); //加上session的userID,防止tenderID被篡改过
  1846. if (!theTender) {
  1847. return null;
  1848. }
  1849. let theEngineering = await projectModel.findOne({ID: theTender.ParentID}).lean();
  1850. if (!theEngineering) {
  1851. return null;
  1852. }
  1853. let constructionProject = await projectModel.findOne({ID: theEngineering.ParentID}).lean();
  1854. if (!constructionProject) {
  1855. return null;
  1856. }
  1857. let engineerings;
  1858. if (granularity === GRANULARITY.PROJECT) {
  1859. engineerings = await projectModel.find({ParentID: constructionProject.ID, $or: notDeleted}).lean();
  1860. for (let eng of engineerings) {
  1861. eng.children = await projectModel.find({ParentID: eng.ID, $or: notDeleted}).lean();
  1862. }
  1863. } else {
  1864. engineerings = [theEngineering];
  1865. if (granularity === GRANULARITY.ENGINEERING) {
  1866. theEngineering.children = await projectModel.find({ParentID: theEngineering.ID, $or: notDeleted}).lean();
  1867. } else {
  1868. theEngineering.children = [theTender];
  1869. }
  1870. }
  1871. constructionProject.children = engineerings;
  1872. //获取汇总信息
  1873. constructionProject.summaryInfo = await getSummaryInfo([constructionProject.ID], summaryField);
  1874. //获取编制软件信息: 软件公司;软件名;版本号;授权信息; base64
  1875. const systemSetting = await systemSettingModel.findOne({});
  1876. let company = systemSetting.company || '珠海纵横创新软件有限公司',
  1877. version = systemSetting.version || '';
  1878. constructionProject.softInfo = `${company};${versionName};${version};${userID}`;
  1879. return constructionProject;
  1880. }
  1881. //获取项目数据占位ID
  1882. async function getProjectPlaceholder(data) {
  1883. let rst = {};
  1884. //项目本身数据
  1885. if (data.projectCount) {
  1886. let projectCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.project, data.projectCount);
  1887. rst.project = projectCount.sequence_value - data.projectCount + 1;
  1888. }
  1889. //项目人材机数据
  1890. if (data.projectGLJCount) {
  1891. let projectGLJCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJCount);
  1892. rst.projectGLJ = projectGLJCount.sequence_value - data.projectGLJCount + 1;
  1893. }
  1894. //组成物数据
  1895. if (data.ratioCount) {
  1896. let ratioCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.mix_ratio, data.ratioCount);
  1897. rst.ratio = ratioCount.sequence_value - data.ratioCount + 1;
  1898. }
  1899. //单价文件数据
  1900. if (data.unitPriceFileCount) {
  1901. let unitPriceFileCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.unit_price_file, data.unitPriceFileCount);
  1902. rst.unitPriceFile = unitPriceFileCount.sequence_value - data.unitPriceFileCount + 1;
  1903. }
  1904. //单价数据
  1905. if (data.unitPriceCount) {
  1906. let unitPriceCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.unit_price, data.unitPriceCount);
  1907. rst.unitPrice = unitPriceCount.sequence_value - data.unitPriceCount + 1;
  1908. }
  1909. return rst;
  1910. }
  1911. /*
  1912. * 接口导入 项目详细数据都导入完成了,再生成项目数据(项目管理界面数据)
  1913. * */
  1914. async function importProject(importObj, userID, compilationID, overWriteUrl) {
  1915. let toInsertProjects = [importObj]; //待新增项目数据
  1916. let billsCalcMode = 0;
  1917. if (overWriteUrl) {
  1918. const overWrite = require('../../..' + overWriteUrl);
  1919. if(overWrite.getBillsCalcMode) { // 重写清单计费取费方式
  1920. billsCalcMode = overWrite.getBillsCalcMode();
  1921. }
  1922. }
  1923. await setupProject(importObj);
  1924. //设置项目ID及相关数据
  1925. for (let curEng of importObj.engs) {
  1926. await setupProject(curEng);
  1927. toInsertProjects.push(curEng);
  1928. for (let curTender of curEng.tenders) {
  1929. await setupProject(curTender.tender);
  1930. //插入单位工程的详细数据
  1931. await importTenderDetail(curTender);
  1932. toInsertProjects.push(curTender.tender);
  1933. }
  1934. delete curEng.tenders;
  1935. }
  1936. delete importObj.engs;
  1937. //项目内部数据设置、新增完毕后,插入项目本身的数据,更新前节点数据
  1938. let bulks = [];
  1939. //如果有前节点,更新前节点
  1940. if (importObj.preID !== -1) {
  1941. bulks.push({
  1942. updateOne: {filter: {ID: importObj.preID}, update: {$set: {NextSiblingID: importObj.ID}}}
  1943. });
  1944. }
  1945. for (let insertP of toInsertProjects) {
  1946. bulks.push({
  1947. insertOne: {document: insertP}
  1948. });
  1949. }
  1950. if (bulks.length > 0) {
  1951. await projectModel.bulkWrite(bulks);
  1952. }
  1953. return importObj.ID; // 返回建设项目ID
  1954. // TODO 删除
  1955. let summaryInfo = await getSummaryInfo([importObj.ID]);
  1956. //设置汇总字段
  1957. for(let proj of toInsertProjects){
  1958. let summaryProj = summaryInfo[proj.ID];
  1959. if(summaryProj){
  1960. proj.engineeringCost = summaryProj.engineeringCost;
  1961. proj.subEngineering = summaryProj.subEngineering;
  1962. proj.measure = summaryProj.measure;
  1963. proj.safetyConstruction = summaryProj.safetyConstruction;
  1964. proj.other = summaryProj.other;
  1965. proj.charge = summaryProj.charge;
  1966. proj.tax = summaryProj.tax;
  1967. proj.rate = summaryProj.rate;
  1968. proj.buildingArea = summaryProj.buildingArea;
  1969. proj.perCost = summaryProj.perCost;
  1970. }
  1971. }
  1972. return toInsertProjects;
  1973. //给项目数据设置一些需要的数据
  1974. async function setupProject(data) {
  1975. data.userID = userID;
  1976. data.compilation = compilationID;
  1977. data.fileVer = await index.getVersion();
  1978. data.createDateTime = new Date();
  1979. if (data.projType === 'Project') {
  1980. await setupConstruct(data);
  1981. } else if (data.projType === 'Tender') {
  1982. await setupTender(data);
  1983. }
  1984. }
  1985. //给建设项目设置一些数据
  1986. async function setupConstruct(data) {
  1987. //更新基本信息, 按照key匹配
  1988. let infoLib = await getBasicInfo(data.compilation, data.property.fileKind);
  1989. if (infoLib) {
  1990. //标准基本信息库的数据打平
  1991. let flatDatas = [];
  1992. infoLib.info.forEach(ifData => flatDatas.push(...ifData.items));
  1993. data.basicInformation.forEach(importI => {
  1994. flatDatas.forEach(item => {
  1995. if (item.key === 'engineeringName') {
  1996. item.value = data.name;
  1997. } else if (item.key === 'fileKind') {
  1998. item.value = {'1': '投标', '2': '招标'}[data.property.fileKind]
  1999. } else if (item.key === 'taxModel') {
  2000. item.value = {'1': '一般计税法', '2': '简易计税法'}[data.property.taxType]
  2001. }
  2002. if (item.key === importI.key) {
  2003. item.value = importI.value;
  2004. }
  2005. });
  2006. });
  2007. }
  2008. data.property.basicInformation = infoLib ? infoLib.info : [];
  2009. }
  2010. //给单位工程设置一些数据
  2011. async function setupTender(data) {
  2012. // 将项目标记为通过接口导入的项目
  2013. data.importedByInterface = true;
  2014. if (!data.property.decimal) {
  2015. //小数位数 需要修改,所以深拷贝
  2016. data.property.decimal = JSON.parse(JSON.stringify(defaultDecimal));
  2017. // 定额工程量、人材机消耗量精度设为最大6
  2018. data.property.decimal.ration.quantity = 6;
  2019. data.property.decimal.glj.quantity = 6;
  2020. }
  2021. //清单工程量精度 需要修改,所以深拷贝
  2022. data.property.billsQuantityDecimal = JSON.parse(JSON.stringify(billsQuantityDecimal));
  2023. // 清单工程量精度默认为4
  2024. const billsQuantityDecimalValue = data.property.billsQuantityDecimalValue || 4;
  2025. data.property.billsQuantityDecimal.forEach(data => data.decimal = billsQuantityDecimalValue);
  2026. //呈现选项
  2027. data.property.displaySetting = displaySetting;
  2028. data.property.billsCalcMode = billsCalcMode;
  2029. data.property.zanguCalcMode = 0;
  2030. //计算选项
  2031. data.property.calcOptions = calcOptions;
  2032. //安装增加费
  2033. if(data.property.isInstall === true || data.property.isInstall === 'true'){//判断是否安装工程
  2034. await installationFacade.copyInstallationFeeFromLib(data.ID, data.property.engineering_id);
  2035. }
  2036. //锁定清单
  2037. data.property.lockBills = true;
  2038. //工料机单价调整系数
  2039. data.property.tenderSetting = tenderSetting;
  2040. //工程特征相关更新 (配对更新+追加)
  2041. let featureLib = await getProjectFeature(data.property.valuation, data.property.engineeringName, data.property.feeStandardName);
  2042. if (featureLib) {
  2043. //把导入的数据设置到默认生成的数据中,按名称匹配 (导入项不确定,因此无法确定获取项的key)
  2044. // 只匹配第一层
  2045. const unmatched = [];
  2046. data.projectFeature.forEach(importF => {
  2047. let matchData = featureLib.feature.find(f => f.dispName === importF.dispName);
  2048. if (matchData) {
  2049. matchData.value = importF.value;
  2050. if (importF.items) {
  2051. matchData.items = importF.items;
  2052. }
  2053. } else {
  2054. unmatched.push(importF);
  2055. }
  2056. });
  2057. featureLib.feature.push(...unmatched);
  2058. featureLib.feature.forEach(f => {
  2059. //设置工程专业的值为费用标准的值..
  2060. if (f.key === 'engineering') {
  2061. f.value = data.property.feeStandardName;
  2062. } else if (f.key === 'projType' && !f.value) {
  2063. const options = f.options && f.options.split('@') || [];
  2064. f.value = options[0] || '';
  2065. }
  2066. });
  2067. }
  2068. data.property.projectFeature = featureLib ? featureLib.feature : [];
  2069. // 累进数据
  2070. if (data.property.progressiveLibID) {
  2071. data.property.progressiveInterval = await getProgressiveInterval(data.property.progressiveLibID);
  2072. }
  2073. // 指标信息相关设置
  2074. await project_facade.setSEILibData(data.property);
  2075. }
  2076. }
  2077. //插入单位工程内部详细数据
  2078. async function importTenderDetail(tenderData) {
  2079. //单价文件
  2080. let upFile = {
  2081. id: tenderData.tender.property.unitPriceFile.id,
  2082. name: tenderData.tender.name,
  2083. project_id: tenderData.tender.ID,
  2084. user_id: tenderData.tender.userID,
  2085. root_project_id: tenderData.tender.property.rootProjectID
  2086. };
  2087. await unitPriceFileModel.create(upFile);
  2088. //费率文件
  2089. let feeRateFileID = await feeRate_facade.newFeeRateFile(tenderData.tender.userID, tenderData.tender);
  2090. tenderData.tender.property.feeFile = feeRateFileID ? feeRateFileID : -1;
  2091. //人工系数文件
  2092. let lcFile = await labourCoeFacade.newProjectLabourCoe(tenderData.tender);
  2093. tenderData.tender.property.labourCoeFile = lcFile ? lcFile : null;
  2094. let cpFile = await calcProgramFacade.newProjectCalcProgramFile(tenderData.tender);
  2095. tenderData.tender.property.calcProgramFile = cpFile ? cpFile : null;
  2096. //列设置
  2097. let engineeringModel = new EngineeringLibModel();
  2098. let engineering = await engineeringModel.getEngineering(tenderData.tender.property.engineering_id);
  2099. let mainTreeCol = await mainColLibModel.findOne({ID: tenderData.tender.property.colLibID});
  2100. await projectSettingModel.create({projectID: tenderData.tender.ID, main_tree_col: mainTreeCol.main_tree_col, glj_col: engineering.glj_col});
  2101. //清单
  2102. if (tenderData.bills.length) {
  2103. await billsModel.insertMany(tenderData.bills);
  2104. }
  2105. // 工程量明细
  2106. if (tenderData.quantityDetails && tenderData.quantityDetails.length) {
  2107. await quantityDetailModel.insertMany(tenderData.quantityDetails);
  2108. }
  2109. if (enterDetail(tenderData)) {
  2110. //匹配标准数据,更新一些标准数据
  2111. await setupStdData(tenderData);
  2112. }
  2113. let task = [];
  2114. //定额
  2115. if (tenderData.ration.length) {
  2116. task.push(rationModel.insertMany(tenderData.ration))
  2117. }
  2118. //定额人材机
  2119. if (tenderData.rationGLJ.length) {
  2120. task.push(rationGLJModel.insertMany(tenderData.rationGLJ));
  2121. }
  2122. //定额调整系数
  2123. if (tenderData.rationCoe.length) {
  2124. task.push(rationCoeModel.insertMany(tenderData.rationCoe));
  2125. }
  2126. //项目人材机
  2127. if (tenderData.projectGLJ.length) {
  2128. task.push(gljListModel.insertMany(tenderData.projectGLJ));
  2129. }
  2130. // 承包人材料
  2131. if (tenderData.contractorList.length) {
  2132. task.push(contractorListModel.insertMany(tenderData.contractorList));
  2133. }
  2134. // 评标材料表
  2135. if (tenderData.bidEvaluationList.length) {
  2136. task.push(bidListModel.insertMany(tenderData.bidEvaluationList));
  2137. }
  2138. // 暂估价材料表
  2139. if (tenderData.evaluationList.length) {
  2140. task.push(evaluateListModel.insertMany(tenderData.evaluationList));
  2141. }
  2142. //组成物
  2143. if (tenderData.mixRatio.length) {
  2144. task.push(mixRatioModel.insertMany(tenderData.mixRatio));
  2145. }
  2146. //单价文件
  2147. if (tenderData.unitPrice.length) {
  2148. task.push(unitPriceModel.insertMany(tenderData.unitPrice));
  2149. }
  2150. if (task.length) {
  2151. await Promise.all(task);
  2152. }
  2153. //继续处理定额等数据
  2154. function enterDetail(tenderData) {
  2155. return tenderData.ration.length ||
  2156. tenderData.rationGLJ.length ||
  2157. tenderData.projectGLJ.length ||
  2158. tenderData.mixRatio.length ||
  2159. tenderData.unitPrice.length;
  2160. }
  2161. }
  2162. //匹配标准数据,需要匹配标准定额,更新导入的定额人材机的定额消耗量等数据
  2163. async function setupStdData(tenderData) {
  2164. //获取标准定额数据 (定额子目的编码查找)
  2165. let matchRationCodes = [...new Set(tenderData.ration.map(ration => ration.code))];
  2166. if (!matchRationCodes.length) {
  2167. return;
  2168. }
  2169. //限制在当前费用定额可用的定额库里查找
  2170. let stdRations = await stdRationItemModel.find({code: {$in: matchRationCodes}, rationRepId: {$in: tenderData.tender.rationLibIDs}},
  2171. '-_id -rationAssList -rationCoeList -rationInstList');
  2172. //标准定额code - 映射
  2173. let stdRationCodeMap = {};
  2174. stdRations.forEach(stdRation => stdRationCodeMap[stdRation.code] = stdRation);
  2175. //获取标准人材机数据 (人材机汇总的编码查找)
  2176. let matchGLJCodes = [...new Set(tenderData.projectGLJ.map(pGLJ => pGLJ.original_code))];
  2177. if (!matchGLJCodes.length) {
  2178. return;
  2179. }
  2180. //限制在当前费用定额可用的人材机库里查找
  2181. let stdGLJs = await stdGljItemModel.find({code: {$in: matchGLJCodes}, repositoryId: {$in: tenderData.tender.gljLibIDs}},
  2182. '-_id -component -priceProperty');
  2183. //标准人材机code - 映射
  2184. let stdGLJCodeMap = {};
  2185. stdGLJs.forEach(stdGLJ => stdGLJCodeMap[stdGLJ.code] = stdGLJ);
  2186. // 取费ID-计算程序子目映射
  2187. const programIDCalculationMap = {};
  2188. //更新定额数据
  2189. const toSetFakeProgramIDData = [];
  2190. tenderData.ration.forEach(r => {
  2191. if (r.setFakeProgramID) {
  2192. toSetFakeProgramIDData.push(r);
  2193. delete r.setFakeProgramID;
  2194. }
  2195. let stdRation = stdRationCodeMap[r.code];
  2196. if (stdRation) {
  2197. r.caption = stdRation.caption;
  2198. r.from = 'std';
  2199. r.libID = stdRation.rationRepId;
  2200. r.stdID = stdRation.ID;
  2201. r.prefix = stdRation.rationRepId == tenderData.tender.defaultRationLib ? '' : '借';
  2202. r.content = stdRation.jobContent;
  2203. r.manageFeeRate = stdRation.manageFeeRate;
  2204. if (stdRation.feeType) {
  2205. r.programID = stdRation.feeType;
  2206. } else {
  2207. // 是标准定额,但是该标准定额取费专业为空,取定额取费专业(后台配置项)
  2208. r.programID = tenderData.tender.property.engineering;
  2209. }
  2210. } else {
  2211. r.from = 'cpt';
  2212. r.prefix = '补';
  2213. }
  2214. if (r.calculationItems && r.calculationItems.length > 0 && !programIDCalculationMap[r.programID]) {
  2215. programIDCalculationMap[r.programID] = r.calculationItems;
  2216. }
  2217. delete r.calculationItems;
  2218. });
  2219. // 更新计算程序
  2220. const newTemplates = [];
  2221. const calcFileID = tenderData.tender.property.calcProgramFile.ID;
  2222. let calcProgramFile = null;
  2223. if (Object.keys(programIDCalculationMap).length > 0) {
  2224. calcProgramFile = await calcProgramsModel.findOne({ ID: calcFileID }).lean();
  2225. if (calcProgramFile) {
  2226. for (const template of calcProgramFile.templates) {
  2227. const matched = programIDCalculationMap[template.ID];
  2228. if (!matched) {
  2229. newTemplates.push(template);
  2230. continue;
  2231. }
  2232. for (const newCalcItem of matched) {
  2233. for (const oldCalcItem of template.calcItems) {
  2234. if (newCalcItem.fieldName === oldCalcItem.fieldName &&
  2235. !(newCalcItem.feeRate === 100 && !oldCalcItem.feeRateID && !oldCalcItem.feeRate)) {
  2236. oldCalcItem.feeRate = newCalcItem.feeRate;
  2237. oldCalcItem.feeRateID = null; // feeRateID优先级比较高,不赋为空的话为被覆盖
  2238. }
  2239. }
  2240. }
  2241. newTemplates.push(template);
  2242. }
  2243. }
  2244. }
  2245. // 增加假的计算程序
  2246. if (toSetFakeProgramIDData.length) {
  2247. if (!calcProgramFile) {
  2248. calcProgramFile = await calcProgramsModel.findOne({ ID: calcFileID }).lean();
  2249. }
  2250. if (calcProgramFile) {
  2251. const programIDTemplateMap = {};
  2252. const programIDNewTemplateMap = {};
  2253. calcProgramFile.templates.forEach(template => programIDTemplateMap[template.ID] = template);
  2254. let curID = calcProgramFile.templates.length + 1;
  2255. toSetFakeProgramIDData.forEach(r => {
  2256. const matchedNewTempate = programIDNewTemplateMap[r.programID];
  2257. if (matchedNewTempate) {
  2258. r.programID = matchedNewTempate.ID;
  2259. return;
  2260. }
  2261. const matched = programIDTemplateMap[r.programID];
  2262. if (matched) {
  2263. const newData = {
  2264. ID: curID++,
  2265. name: `${matched.name}_1`,
  2266. calcItems: []
  2267. };
  2268. newTemplates.push(newData);
  2269. programIDNewTemplateMap[r.programID] = newData;
  2270. r.programID = newData.ID;
  2271. }
  2272. });
  2273. }
  2274. }
  2275. if (newTemplates.length) {
  2276. await calcProgramsModel.update({ ID: calcFileID }, { $set: { templates: newTemplates } });
  2277. }
  2278. //更新定额人材机数据
  2279. tenderData.rationGLJ.forEach(rGLJ => {
  2280. rGLJ.from = 'cpt';
  2281. //匹配定额
  2282. let stdRation = stdRationCodeMap[rGLJ.rationCode];
  2283. if (stdRation) {
  2284. //根据导入数据的定额人材机编码匹配人材机
  2285. let stdGLJ = stdGLJCodeMap[rGLJ.original_code];
  2286. if (stdGLJ) {
  2287. rGLJ.from = 'std';
  2288. rGLJ.GLJID = stdGLJ.ID;
  2289. rGLJ.type = stdGLJ.gljType;
  2290. rGLJ.shortName = stdGLJ.shortName;
  2291. rGLJ.repositoryId = stdGLJ.repositoryId;
  2292. rGLJ.model = stdGLJ.model;
  2293. rGLJ.adjCoe = stdGLJ.adjCoe;
  2294. //找匹配到的标准定额中定额人材机的相应人材机,更新定额消耗
  2295. let stdRationGLJ = stdRation.rationGljList.find(data => data.gljId === stdGLJ.ID);
  2296. if (stdRationGLJ) {
  2297. rGLJ.rationItemQuantity = stdRationGLJ.consumeAmt;
  2298. }
  2299. }
  2300. }
  2301. });
  2302. //更新人材机汇总数据
  2303. tenderData.projectGLJ.forEach(pGLJ => {
  2304. if (!pGLJ.specs) {
  2305. pGLJ.specs = null;
  2306. }
  2307. let stdGLJ = stdGLJCodeMap[pGLJ.original_code];
  2308. if (stdGLJ) {
  2309. pGLJ.glj_id = stdGLJ.ID;
  2310. pGLJ.model = stdGLJ.model;
  2311. if (pGLJ.type !== stdGLJ.gljType) { //更新组成物connect_key
  2312. let keyStr = [pGLJ.code || 'null', pGLJ.name || 'null', pGLJ.specs || 'null', pGLJ.unit || 'null', pGLJ.type].join('|-|');
  2313. let ratios = tenderData.mixRatio.filter(ratio =>
  2314. ratio.connect_key === keyStr);
  2315. let newKeyStr = [pGLJ.code || 'null', pGLJ.name || 'null', pGLJ.specs || 'null', pGLJ.unit || 'null', stdGLJ.gljType || 'null'].join('|-|');
  2316. ratios.forEach(ratio => ratio.connect_key = newKeyStr);
  2317. }
  2318. pGLJ.type = stdGLJ.gljType; //更新类型,标准的数据类型更准确,导入的类型数据有细分识别不了
  2319. }
  2320. });
  2321. //更新单价文件数据
  2322. tenderData.unitPrice.forEach(up => {
  2323. let stdGLJ = stdGLJCodeMap[up.original_code];
  2324. if (stdGLJ) {
  2325. up.glj_id = stdGLJ.ID;
  2326. up.type = stdGLJ.gljType;
  2327. up.short_name = stdGLJ.shortName;
  2328. if (stdGLJ.taxRate) {
  2329. up.taxRate = stdGLJ.taxRate;
  2330. }
  2331. }
  2332. });
  2333. //更新组成物数据
  2334. tenderData.mixRatio.forEach(ratio => {
  2335. let stdGLJ = stdGLJCodeMap[ratio.code] || stdGLJCodeMap[ratio.original_code];
  2336. if (stdGLJ) {
  2337. ratio.glj_id = stdGLJ.ID;
  2338. ratio.type = stdGLJ.gljType;
  2339. }
  2340. });
  2341. }
  2342. async function exportProject(userID,data){//导出建设项目
  2343. if(data.type == 'main'){
  2344. return await exportMainData(userID,data.projectID);
  2345. }else {
  2346. return await exportTenderData(data);
  2347. }
  2348. }
  2349. async function exportMainData(userID,projectID) {
  2350. let result = {userID:userID,projects:[],type:'Project'};//type 备用属性,表示导出的类型,目前导出的都是整个建设项目
  2351. let tenderIDs = [];
  2352. let project = await projectModel.findOne({ID:projectID});
  2353. if(!project) throw new Error("没有找到该建设项目:"+projectID);
  2354. result['compilationID'] = project.compilation;
  2355. result['from'] = "construction";
  2356. result.projects.push(project);
  2357. let subProjects = await projectModel.find({"$or": [{'ParentID':projectID}, {"property.rootProjectID": projectID}]});
  2358. for(let s of subProjects){
  2359. if(!s.deleteInfo || !s.deleteInfo.deleted){
  2360. result.projects.push(s);
  2361. if(s.projType =="Tender") tenderIDs.push(s.ID);
  2362. }
  2363. }
  2364. const constructions = result.projects.filter(item => item.projType === projectType.project);
  2365. resortImportProjectData(result.projects, constructions);
  2366. let files = {unitFiles:await exportUnitFiles(projectID),feeRateFiles:await exportFeeRateFiles(projectID)};
  2367. result.files = files;
  2368. result = cipher.aesEncrypt(JSON.stringify(result));
  2369. result +="|----|" +JSON.stringify(tenderIDs);
  2370. return result;
  2371. }
  2372. async function exportUnitFiles(rootProjectID){
  2373. let unitFiles = [];
  2374. let files = await unitPriceFileModel.find({root_project_id:rootProjectID});
  2375. for(let f of files){
  2376. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  2377. let tem = {unitFile:f};
  2378. tem.unitPrices = await unitPriceModel.find({unit_price_file_id:f.id});
  2379. tem.mixRatios = await mixRatioModel.find({unit_price_file_id:f.id});
  2380. unitFiles.push(tem);
  2381. }
  2382. return unitFiles;
  2383. }
  2384. async function exportFeeRateFiles(rootProjectID) {
  2385. let feeRateFiles = [];
  2386. let files = await feeRateFileModel.find({rootProjectID:rootProjectID});
  2387. for(let f of files){
  2388. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  2389. let tem = {feeRateFile:f};
  2390. tem.feeRate = await feeRateModel.findOne({ID:f.feeRateID});
  2391. feeRateFiles.push(tem);
  2392. }
  2393. return feeRateFiles;
  2394. }
  2395. async function exportTenderData(data){
  2396. let result = {};
  2397. let projectSetting = await projectSettingModel.findOne({"projectID": data.projectID}, '-_id');
  2398. if(projectSetting) result['projSetting'] = projectSetting;
  2399. result.bills = await billsModel.find({"projectID": data.projectID});
  2400. result.rations = await rationModel.find({'$or': [{projectID: data.projectID, deleteInfo: null}, {projectID: data.projectID, 'deleteInfo.deleted': {$in: [null, false]}}]});
  2401. result.projectGLJs = await gljListModel.find({'project_id':data.projectID});
  2402. result.installationFees = await installationFeeModel.find({projectID:data.projectID});
  2403. result.rationGLJs = await rationGLJModel.find({projectID:data.projectID});
  2404. result.rationCoes = await rationCoeModel.find({projectID:data.projectID});
  2405. result.quantityDetails = await quantityDetailModel.find({projectID:data.projectID});
  2406. result.rationInstallations = await rationInstallationModel.find({projectID:data.projectID});
  2407. result.rationTemplates = await rationTemplateModel.find({projectID:data.projectID});
  2408. result.calcProgramsFile = await calcProgramsModel.findOne({projectID:data.projectID});
  2409. result.labourCoes = await labourCoesModel.findOne({projectID:data.projectID});
  2410. result.evaluateList = await evaluateListModel.find({projectID:data.projectID}, '-_id').lean();
  2411. result.bidList = await bidListModel.find({projectID:data.projectID}, '-_id').lean();
  2412. result.contractorList = await contractorListModel.find({projectID:data.projectID}, '-_id').lean();
  2413. return cipher.aesEncrypt(JSON.stringify(result));
  2414. }
  2415. async function downLoadProjectFile(info) {
  2416. let result = {error:0};
  2417. let bucketManager2 = new qiniu.rs.BucketManager(mac, null);
  2418. let publicBucketDomain = qiniu_config.Domain;// "http://serverupdate.smartcost.com.cn";//这里不支持https
  2419. let deadline = parseInt(Date.now() / 1000) + 3600; // 1小时过期
  2420. let privateDownloadUrl = bucketManager2.privateDownloadUrl(publicBucketDomain, info.key, deadline);
  2421. console.log(privateDownloadUrl);
  2422. let data = {
  2423. key:info.key,
  2424. content: '正在导入建设项目,请稍候……',
  2425. userID:info.session.sessionUser.id,
  2426. compilationID: info.session.sessionCompilation._id,
  2427. status:"start",
  2428. create_time:+new Date()
  2429. };
  2430. await importLogsModel.create(data);
  2431. doDownLoadAndImport(privateDownloadUrl,info);
  2432. return result;
  2433. }
  2434. async function doDownLoadAndImport(privateDownloadUrl, info) {
  2435. let stream = fs.createWriteStream(path.join(__dirname, "../../../tmp/" + info.key));//
  2436. request(privateDownloadUrl)
  2437. .on('error', async function(err) {
  2438. await importLogsModel.update({ key: info.key }, { status: 'error', errorMsg: err.toString() });
  2439. })
  2440. .pipe(stream)
  2441. .on("close", async function () {
  2442. console.log("文件[" + info.key + "]下载完毕");
  2443. let doc = { status: "finish" };
  2444. try {
  2445. let data = fs.readFileSync(stream.path, 'utf-8');
  2446. let result = await importProjects(data, { session: info.session }, info.updateData);
  2447. if (result.error == 1) {
  2448. doc.errorMsg = result.msg;
  2449. doc.status = "error";
  2450. } else {
  2451. doc.projectID = [result.constructionProjectID];
  2452. }
  2453. } catch (error) {
  2454. console.log(error.message);
  2455. doc.errorMsg = "导入失败,请检查文件!";
  2456. doc.status = "error";
  2457. } finally {
  2458. await importLogsModel.update({ key: info.key }, doc);
  2459. fs.unlinkSync(stream.path);
  2460. }
  2461. })
  2462. .on('error', async function () {
  2463. await importLogsModel.update({ key: info.key }, { status: 'error', errorMsg: `文件[${info.key}]下载失败,请稍后再试。` });
  2464. });
  2465. }
  2466. async function importProcessChecking(data){
  2467. let result = {error:0};
  2468. const query = data.key ? { key: data.key } : { userID: data.userID, compilationID: data.compilationID };
  2469. let log = await importLogsModel.findOne(query);
  2470. if(log){
  2471. if(log.status == "finish"){
  2472. result.status = "complete";
  2473. await importLogsModel.remove(query);
  2474. // 获取导入的项目数据
  2475. if (log.projectID && log.projectID.length > 0) {
  2476. const projects = await getPosterityProjects(log.projectID, true);
  2477. if (!(projects.length === 1 && projects[0].projType === projectType.tender)) { // 处理的是建设项目数据
  2478. const summaryInfo = await getSummaryInfo(log.projectID);
  2479. setupSummaryFields(summaryInfo, projects);
  2480. }
  2481. result.data = projects;
  2482. }
  2483. /* if (log.projectID && log.projectID.length > 0) {
  2484. const projects = await getPosterityProjects([log.projectID], true);
  2485. if (!(projects.length === 1 && projects[0].projType === projectType.tender)) { // 处理的是建设项目数据
  2486. const summaryInfo = await getSummaryInfo([log.projectID]);
  2487. setupSummaryFields(summaryInfo, projects);
  2488. }
  2489. result.data = projects;
  2490. } */
  2491. }else if(log.status == "start"){
  2492. result.status = "processing";
  2493. result.content = log.content;
  2494. }else if(log.status == "error"){
  2495. result.error = 1;
  2496. result.msg = log.errorMsg;
  2497. await importLogsModel.remove(query);
  2498. }
  2499. }else {
  2500. result.status = "complete";
  2501. }
  2502. return result;
  2503. }
  2504. // 从cdn服务器下载文件,key就是文件名
  2505. async function downloadFileSync(key) {
  2506. const filePath = path.join(__dirname, '../../../tmp/', key);
  2507. const bucketManager2 = new qiniu.rs.BucketManager(mac, null);
  2508. const publicBucketDomain = qiniu_config.Domain; // "http://serverupdate.smartcost.com.cn";//这里不支持https
  2509. const deadline = parseInt(Date.now() / 1000) + 3600; // 1小时过期
  2510. const privateDownloadUrl = bucketManager2.privateDownloadUrl(publicBucketDomain, key, deadline);
  2511. const stream = fs.createWriteStream(filePath);
  2512. return new Promise((resolve, reject) => {
  2513. request(privateDownloadUrl)
  2514. .on('error', reject)
  2515. .pipe(stream)
  2516. .on('close', () => {
  2517. // 读取文件返回字符串
  2518. const srcData = fs.readFileSync(stream.path,'utf-8');
  2519. resolve({
  2520. path: stream.path,
  2521. srcData: srcData
  2522. });
  2523. })
  2524. .on('error', reject);
  2525. });
  2526. }
  2527. // 导入接口
  2528. async function importInterface(key, session) {
  2529. const logData = {
  2530. key: key,
  2531. content: '正在导入接口文件,请稍候……',
  2532. userID: session.sessionUser.id,
  2533. compilationID: session.sessionCompilation._id,
  2534. status: 'start',
  2535. create_time: +new Date()
  2536. };
  2537. await importLogsModel.create(logData);
  2538. handleImportInterface(key, session);
  2539. return 'importing interface';
  2540. }
  2541. async function handleImportInterface(key, session) {
  2542. const doc = { status: 'finish' };
  2543. // 源文件内容文本
  2544. let downloadFilePath = '';
  2545. try {
  2546. const { path, srcData } = await downloadFileSync(key);
  2547. downloadFilePath = path;
  2548. if (!srcData) {
  2549. throw '无有效数据';
  2550. }
  2551. const userID = session.sessionUser.id;
  2552. const compilationID = session.sessionCompilation._id;
  2553. const importData = JSON.parse(srcData);
  2554. let tenderCount = 0;
  2555. importData.engs.forEach(eng => {
  2556. eng.tenders.forEach(() => {
  2557. tenderCount += 1;
  2558. });
  2559. });
  2560. if (await isTenderOverrun(tenderCount, session)) {
  2561. throw '您创建的项目个数超限,请联系我们的客服人员,或者导出建设项目保存到本地备份,删除云上数据。';
  2562. }
  2563. const overWriteUrl = session.sessionCompilation.overWriteUrl;
  2564. const projectID = await importProject(importData, userID, compilationID, overWriteUrl);
  2565. doc.projectID = [projectID];
  2566. } catch (err) {
  2567. doc.errorMsg = typeof err === 'string' ? err : err.toString();
  2568. doc.status = 'error';
  2569. } finally {
  2570. await importLogsModel.update({ key }, doc);
  2571. fs.unlinkSync(downloadFilePath);
  2572. }
  2573. }
  2574. /* async function importInterface(key, session) {
  2575. // 源文件内容文本
  2576. let downloadFilePath = '';
  2577. try {
  2578. const { path, srcData } = await downloadFileSync(key);
  2579. downloadFilePath = path;
  2580. if (!srcData) {
  2581. throw '无有效数据';
  2582. }
  2583. const userID = session.sessionUser.id;
  2584. const compilationID = session.sessionCompilation._id;
  2585. const importData = JSON.parse(srcData);
  2586. let tenderCount = 0;
  2587. importData.engs.forEach(eng => {
  2588. eng.tenders.forEach(tender => {
  2589. tenderCount += 1;
  2590. });
  2591. });
  2592. if (await isTenderOverrun(tenderCount, session)) {
  2593. throw '您创建的项目个数超限,请联系我们的客服人员,或者导出建设项目保存到本地备份,删除云上数据。';
  2594. }
  2595. const projectData = await importProject(importData, userID, compilationID);
  2596. return projectData;
  2597. } catch (err) {
  2598. throw err;
  2599. } finally {
  2600. fs.unlinkSync(downloadFilePath);
  2601. }
  2602. } */
  2603. // 为防止导入的ybp源文件的树结构是错误的,进行重排
  2604. function resortImportProjectData(allData, curDepthData) {
  2605. curDepthData = project_facade.sortChildren(curDepthData);
  2606. curDepthData.forEach((cur, index) => {
  2607. cur.NextSiblingID = curDepthData[index + 1] && curDepthData[index + 1].ID || -1;
  2608. const nextDepthData = allData.filter(item => item.ParentID === cur.ID);
  2609. if (nextDepthData.length) {
  2610. resortImportProjectData(allData, nextDepthData);
  2611. }
  2612. });
  2613. }
  2614. async function importProjects(data,req,updateData) {
  2615. let result = {error:0};
  2616. let stringArr = data.split("|----|");
  2617. let datas = [];
  2618. let first = +new Date();
  2619. for(let s of stringArr){
  2620. datas.push(JSON.parse(cipher.aesDecrypt(s)));
  2621. }
  2622. let mainData = datas.length > 0 ?datas[0]:null;
  2623. if(mainData){
  2624. if(mainData.from && mainData.from != "construction"){
  2625. result.error = 1;
  2626. result.msg = "导入失败:您要导入的文件是由“纵横公路养护云版”导出,当前软件是“大司空云计价”,请选择正确的软件再进行操作!";
  2627. }else if(mainData.compilationID != req.session.sessionCompilation._id){
  2628. const fileCompilation = await compilationModel.findOne({_id: mongoose.Types.ObjectId(mainData.compilationID)}, 'name');
  2629. const fileCompilationName = fileCompilation ? fileCompilation.name : '未知的费用定额';
  2630. const curCompilationName = req.session.sessionCompilation.name;
  2631. result.error = 1;
  2632. result.msg = `导入失败:您要导入的文件是由“${fileCompilationName}”导出,当前软件是“${curCompilationName}”,请选择正确的费用定额再进行操作!`;
  2633. }else {
  2634. const tenders = mainData.projects.filter(item => item.projType === projectType.tender);
  2635. const tenderOverrun = await isTenderOverrun(tenders.length, req.session);
  2636. if (tenderOverrun) {
  2637. result.error = 1;
  2638. result.msg = `您创建的项目个数超限,请联系我们的客服人员,或者导出建设项目保存到本地备份,删除云上数据。`;
  2639. return result;
  2640. }
  2641. const constructions = mainData.projects.filter(item => item.projType === projectType.project);
  2642. resortImportProjectData(mainData.projects, constructions);
  2643. let [constructionProjectID,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap] = await handleMainProjectDatas(mainData,updateData,req.session.sessionUser.id);
  2644. result.constructionProjectID = constructionProjectID;
  2645. if(datas.length > 1 ){
  2646. let newProjectSettings=[],bills=[],rations=[],installationFees=[],projectGLJs=[],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[],evaluateList=[],bidList=[],contractorList=[],newCalcProgramsFiles=[],newLabourCoes=[]
  2647. for(let i = 1;i<datas.length;i++){
  2648. let [tnewProjectSetting,tbills,trations,tinstallationFees,tprojectGLJs,trationGLJs,trationCoes,tquantityDetails,trationInstallations,trationTemplates,tevaluateList,tbidList,tcontractorList,tnewCalcProgramsFile,tnewLabourCoe] = await handleEachProject(datas[i],projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap)
  2649. if(tnewProjectSetting) newProjectSettings.push(tnewProjectSetting);
  2650. if(tbills.length > 0) bills = bills.concat(tbills);
  2651. if(trations.length > 0) rations = rations.concat(trations);
  2652. if(tinstallationFees.length > 0) installationFees = installationFees.concat(tinstallationFees);
  2653. if(tprojectGLJs.length > 0) projectGLJs = projectGLJs.concat(tprojectGLJs);
  2654. if(trationGLJs.length > 0) rationGLJs = rationGLJs.concat(trationGLJs);
  2655. if(trationCoes.length > 0) rationCoes = rationCoes.concat(trationCoes);
  2656. if(tquantityDetails.length > 0) quantityDetails = quantityDetails.concat(tquantityDetails);
  2657. if(trationInstallations.length > 0) rationInstallations = rationInstallations.concat(trationInstallations);
  2658. if(trationTemplates.length > 0) rationTemplates = rationTemplates.concat(trationTemplates);
  2659. if(tevaluateList.length > 0) evaluateList = evaluateList.concat(tevaluateList);
  2660. if(tbidList.length > 0) bidList = bidList.concat(tbidList);
  2661. if(tcontractorList.length > 0) contractorList = contractorList.concat(tcontractorList);
  2662. if(tnewCalcProgramsFile) newCalcProgramsFiles.push(tnewCalcProgramsFile);
  2663. if(tnewLabourCoe) newLabourCoes.push(tnewLabourCoe);
  2664. }
  2665. if(newProjectSettings.length > 0) await insertMany(newProjectSettings,projectSettingModel)
  2666. if(bills.length > 0) await insertMany(bills,billsModel);
  2667. if(rations.length > 0) await insertMany(rations,rationModel);
  2668. if(installationFees.length > 0) await insertMany(installationFees,installationFeeModel);
  2669. if(projectGLJs.length > 0) await insertMany(projectGLJs,gljListModel);
  2670. if(rationGLJs.length > 0) await insertMany(rationGLJs,rationGLJModel);
  2671. if(rationCoes.length > 0) await insertMany(rationCoes,rationCoeModel);
  2672. if(quantityDetails.length > 0) await insertMany(quantityDetails,quantityDetailModel);
  2673. if(rationInstallations.length > 0) await insertMany(rationInstallations,rationInstallationModel);
  2674. if(rationTemplates.length > 0) await insertMany(rationTemplates,rationTemplateModel);
  2675. if(evaluateList.length > 0) await insertMany(evaluateList,evaluateListModel);
  2676. if(bidList.length > 0) await insertMany(bidList,bidListModel);
  2677. if(contractorList.length > 0) await insertMany(contractorList,contractorListModel);
  2678. if(newCalcProgramsFiles.length > 0) await insertMany(newCalcProgramsFiles,calcProgramsModel);
  2679. if(newLabourCoes.length > 0) await insertMany(newLabourCoes,labourCoesModel);
  2680. }
  2681. }
  2682. }
  2683. let finish = +new Date();
  2684. console.log("导入操作总时间为-------------------------------"+(finish-first));
  2685. return result;
  2686. }
  2687. async function handleEachProject(data,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap){
  2688. let bills = [],rations = [],projectGLJs = [],installationFees=[],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[],evaluateList=[],bidList=[],contractorList=[];
  2689. let newProjectSetting =null,newCalcProgramsFile = null,newLabourCoe = null;
  2690. let billsIDMap = {},projectGLJIDMap={},rationIDMap = {};
  2691. let newProjectID = projectIDMap[data.projSetting.projectID];
  2692. //生成安装增加费设置
  2693. if(data.installationFees && data.installationFees.length > 0){
  2694. for(let ins of data.installationFees){
  2695. delete ins._id;
  2696. ins.ID = uuidV1();
  2697. ins.projectID = newProjectID;
  2698. installationFees.push(ins);
  2699. }
  2700. }
  2701. //生成新的清单;
  2702. if(data.bills && data.bills.length > 0){
  2703. for(let b of data.bills){
  2704. billsIDMap[b.ID] = uuidV1();
  2705. }
  2706. for(let b of data.bills){
  2707. delete b._id;
  2708. b = getCopyBillDatas(b,newProjectID,billsIDMap);
  2709. bills.push(b);
  2710. }
  2711. }
  2712. //生成项目工料机数据
  2713. if(data.projectGLJs && data.projectGLJs.length > 0){
  2714. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJs.length);
  2715. for(let i = 0; i < data.projectGLJs.length; i++){
  2716. let d = data.projectGLJs[i];
  2717. delete d._id;
  2718. let newID = gljCount.sequence_value - (data.projectGLJs.length - 1) + i;
  2719. projectGLJIDMap[d.id] = newID;
  2720. d.project_id = newProjectID;
  2721. d.id = newID;
  2722. projectGLJs.push(d);
  2723. }
  2724. }
  2725. //生成新的定额
  2726. if(data.rations && data.rations.length > 0){
  2727. for(let r of data.rations){
  2728. rationIDMap[r.ID] = uuidV1();
  2729. }
  2730. for(let r of data.rations){
  2731. delete r._id;
  2732. r = getCopyRationData(r,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2733. rations.push(r);
  2734. }
  2735. }
  2736. //生成定额下挂的定额工料机等等数据
  2737. if(data.rationGLJs && data.rationGLJs.length > 0) rationGLJs = setRationSubList(data.rationGLJs,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2738. if(data.rationCoes && data.rationCoes.length > 0) rationCoes = setRationSubList(data.rationCoes,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2739. if(data.quantityDetails && data.quantityDetails.length > 0) quantityDetails = setRationSubList(data.quantityDetails,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2740. if(data.rationInstallations && data.rationInstallations.length > 0) rationInstallations = setRationSubList(data.rationInstallations,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2741. if(data.rationTemplates && data.rationTemplates.length > 0) rationTemplates = setRationSubList(data.rationTemplates,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  2742. if(data.evaluateList && data.evaluateList.length > 0) evaluateList = setMaterialList(data.evaluateList,newProjectID,projectGLJIDMap);
  2743. if(data.bidList && data.bidList.length > 0) bidList = setMaterialList(data.bidList,newProjectID,projectGLJIDMap);
  2744. if(data.contractorList && data.contractorList.length > 0) contractorList = setMaterialList(data.contractorList,newProjectID,projectGLJIDMap);
  2745. //生成projectSetting 文件
  2746. if(data.projSetting){
  2747. data.projSetting.projectID =newProjectID;
  2748. newProjectSetting = data.projSetting;
  2749. delete newProjectSetting._id;
  2750. }
  2751. //生成计算程序文件,系数文件
  2752. if(data.calcProgramsFile && calcProgramFileIDMap[data.calcProgramsFile.ID]){
  2753. data.calcProgramsFile.ID = calcProgramFileIDMap[data.calcProgramsFile.ID];
  2754. data.calcProgramsFile.projectID = newProjectID;
  2755. newCalcProgramsFile = data.calcProgramsFile;
  2756. delete newCalcProgramsFile._id;
  2757. }
  2758. if(data.labourCoes && labourCoeFileIDMap[data.labourCoes.ID]){
  2759. data.labourCoes.ID = labourCoeFileIDMap[data.labourCoes.ID];
  2760. data.labourCoes.projectID = newProjectID;
  2761. newLabourCoe = data.labourCoes;
  2762. delete newLabourCoe._id;
  2763. }
  2764. return [newProjectSetting,bills,rations,installationFees,projectGLJs,rationGLJs,rationCoes,quantityDetails,rationInstallations,rationTemplates,evaluateList,bidList,contractorList,newCalcProgramsFile,newLabourCoe]
  2765. }
  2766. function setMaterialList(datas,newProjectID,projectGLJIDMap){
  2767. let arrs = [];
  2768. for(let d of datas){
  2769. arrs.push(getNewMaterial(d,newProjectID,projectGLJIDMap))
  2770. }
  2771. return arrs
  2772. }
  2773. function setRationSubList(datas,newProjectID,billIDMap,rationIDMap,projectGLJIDMap) {
  2774. let arrs = [];
  2775. for(let d of datas){
  2776. delete d._id;
  2777. d = getCopyRationSubData(d,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  2778. arrs.push(d);
  2779. }
  2780. return arrs;
  2781. }
  2782. async function handleMainProjectDatas(mainData,updateData,userID) {
  2783. let mainProjectID = -1;
  2784. let projectIDMap = {},feeRateFileIDMap={},unitPriceFileIDMap={},labourCoeFileIDMap={},calcProgramFileIDMap={};
  2785. let tasks = [];
  2786. projectIDMap[-1] = -1;//最后一个项目的nextID为-1的情况
  2787. let constructionProjectID;
  2788. //生成新的projectID
  2789. for(let p of mainData.projects){
  2790. let newProjectID = await getCounterID("projects");
  2791. projectIDMap[p.ID] = newProjectID;
  2792. if(p.projType == "Project") {
  2793. mainProjectID = newProjectID;
  2794. constructionProjectID = newProjectID;
  2795. }
  2796. if(p.projType == "Tender"){
  2797. if(p.property.calcProgramFile) calcProgramFileIDMap[p.property.calcProgramFile.ID] = uuidV1();//新的计算程序文件ID
  2798. if(p.property.labourCoeFile) labourCoeFileIDMap[p.property.labourCoeFile.ID] = uuidV1();//新的人工调整系数文件ID
  2799. if(p.property.feeFile) feeRateFileIDMap[p.property.feeFile.id] = uuidV1();//新的费率文件ID
  2800. if(p.property.unitPriceFile) unitPriceFileIDMap[p.property.unitPriceFile.id] = await getCounterID("unit_price_file");//新的单价文件ID
  2801. }
  2802. }
  2803. if(mainProjectID == -1) throw new Error("文件里面没包含建设项目信息!");
  2804. //处理项目信息 ----- 费率文件,单价文件ID信息要重新生成----to do
  2805. for(let p of mainData.projects){
  2806. delete p._id;
  2807. delete p.__v;
  2808. p.ID = projectIDMap[p.ID];
  2809. if(p.ID == mainProjectID){//对于建设项目,要父和下一节点ID要使用前端传入的位置ID
  2810. p.ParentID = updateData.self.ParentID;
  2811. p.NextSiblingID = updateData.self.NextSiblingID;
  2812. if(updateData.update){//树节构中的上一节点的下一节点设置为本建设项目ID;
  2813. tasks.push({updateOne:{filter : updateData.update.query, update : {NextSiblingID:mainProjectID}}});
  2814. }
  2815. //查看是否重名;
  2816. let temp = await projectModel.findOne({userID:userID,ParentID:p.ParentID,name:p.name});
  2817. if(temp) p.name = p.name + '(' + moment(Date.now()).tz("Asia/Shanghai").format('MM-DD HH:mm:ss') + '导入)';
  2818. }else {
  2819. p.ParentID = projectIDMap[p.ParentID];
  2820. p.NextSiblingID = projectIDMap[p.NextSiblingID];
  2821. }
  2822. p.userID =userID;
  2823. p.shareInfo=[];
  2824. if(p.projType == "Tender"){
  2825. if(p.property.calcProgramFile) p.property.calcProgramFile.ID = calcProgramFileIDMap[p.property.calcProgramFile.ID];
  2826. if(p.property.labourCoeFile) p.property.labourCoeFile.ID = labourCoeFileIDMap[p.property.labourCoeFile.ID];
  2827. if(p.property.feeFile) p.property.feeFile.id = feeRateFileIDMap[p.property.feeFile.id];
  2828. if(p.property.unitPriceFile) p.property.unitPriceFile.id = unitPriceFileIDMap[p.property.unitPriceFile.id];
  2829. p.property.rootProjectID = mainProjectID
  2830. }
  2831. tasks.push({insertOne: {document: p}})
  2832. }
  2833. //项目树节构数据生成:
  2834. await projectModel.bulkWrite(tasks);
  2835. //生成所有的费率文件
  2836. await importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID);
  2837. //生成所有的单价文件
  2838. await importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID);
  2839. return [constructionProjectID,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap]
  2840. }
  2841. async function importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID) {
  2842. if(!mainData.files.unitFiles) return;
  2843. let unitFiles = [],unitPrices =[],mixRatios=[],freights=[],originals=[];
  2844. for(let f of mainData.files.unitFiles){
  2845. let file = f.unitFile,prices = f.unitPrices,mixs = f.mixRatios,fres = f.freights,ors = f.originals;
  2846. //生成单价文件
  2847. delete file._id;
  2848. file.id = unitPriceFileIDMap[file.id]?unitPriceFileIDMap[file.id]:await getCounterID("unit_price_file");
  2849. file.project_id = projectIDMap[file.project_id];
  2850. file.root_project_id = projectIDMap[file.root_project_id];
  2851. file.user_id = userID;
  2852. unitFiles.push(file);
  2853. //生成子数据
  2854. if(prices) await setSubList(prices,unitPrices,file.id,unitPriceModel);
  2855. if(mixs) await setSubList(mixs,mixRatios,file.id,mixRatioModel);
  2856. }
  2857. if(unitFiles.length > 0) await insertMany(unitFiles,unitPriceFileModel);
  2858. if(unitPrices.length > 0) await insertMany(unitPrices,unitPriceModel);
  2859. if(mixRatios.length > 0) await insertMany(mixRatios,mixRatioModel);
  2860. async function setSubList(oList,nList,fileID,model) {
  2861. let IDcounter = await counter.counterDAO.getIDAfterCountSync(model.modelName, oList.length);
  2862. let firstID = IDcounter.sequence_value - (oList.length - 1);
  2863. for(let o of oList){
  2864. delete o._id;
  2865. o.unit_price_file_id = fileID;
  2866. o.id = firstID;
  2867. firstID+=1
  2868. nList.push(o)
  2869. }
  2870. }
  2871. }
  2872. async function importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID) {
  2873. let feeRateFiles = [], feeRates = [];
  2874. if(!mainData.files.feeRateFiles) return;
  2875. for(let f of mainData.files.feeRateFiles){
  2876. //生成费率记录
  2877. let rate = f.feeRate;
  2878. delete rate._id;
  2879. rate.ID = uuidV1();
  2880. feeRates.push(rate);
  2881. //生成费率文件记录
  2882. let file = f.feeRateFile;
  2883. delete file._id;
  2884. file.ID = feeRateFileIDMap[file.ID]?feeRateFileIDMap[file.ID]:uuidV1();
  2885. file.userID = userID;
  2886. file.rootProjectID = projectIDMap[file.rootProjectID];
  2887. file.feeRateID = rate.ID;
  2888. feeRateFiles.push(file);
  2889. }
  2890. if(feeRateFiles.length > 0) await insertMany(feeRateFiles,feeRateFileModel);
  2891. if(feeRates.length > 0) await insertMany(feeRates,feeRateModel);
  2892. }
  2893. // 初始化
  2894. async function initOverHeightItems(engineeringID) {
  2895. const defaultData = [];
  2896. const engineering = await engineeringModel.findById(engineeringID);
  2897. const overHeightLibs = engineering.over_height_lib;
  2898. if (!overHeightLibs || !overHeightLibs.length) {
  2899. return defaultData;
  2900. }
  2901. const overHeightLibID = overHeightLibs[0].id;
  2902. const overHeightLib = await overHeightLibModel.findOne({ID: overHeightLibID});
  2903. return overHeightLib ? overHeightLib.list : defaultData;
  2904. }
  2905. function uploadToken() {
  2906. let options = {
  2907. scope: qiniu_config.Bucket,
  2908. deleteAfterDays: 1,
  2909. returnBody:
  2910. '{"key":"$(key)","hash":"$(etag)","fsize":$(fsize),"bucket":"$(bucket)","name":"$(x:name)"}'
  2911. };
  2912. let putPolicy = new qiniu.rs.PutPolicy(options);
  2913. let token = putPolicy.uploadToken(mac);
  2914. let result = {
  2915. uptoken: token,
  2916. domain: qiniu_config.Domain
  2917. }
  2918. return result
  2919. }
  2920. // 获取系统设置,这个系统设置正常情况下有存在session中
  2921. async function getSystemSetting() {
  2922. return await systemSettingModel.findOne({}).lean();
  2923. }
  2924. // 有些方法无法通过中间件就检查单位工程数量是否超限
  2925. // 需要到具体的业务代码中进行判断
  2926. // 这个方法就是具体业务代码中,需要检查单位工程数量是否超限用
  2927. async function isTenderOverrun(tenderCount, session) {
  2928. const userID = session.sessionUser.id;
  2929. const compilation = session.sessionCompilation._id;
  2930. const compilationVersion = session.compilationVersion || '免费';
  2931. let systemSetting = session.systemSetting || (session.systemSetting = await getSystemSetting());
  2932. // 这种情况只有在刚上线此功能时会出现,不考虑时间差
  2933. if (!systemSetting) {
  2934. return false;
  2935. }
  2936. const type = compilationVersion.includes('免费') ? 'normal' : 'professional';
  2937. const limit = systemSetting[type].project;
  2938. const curTenderCount = await projectModel.count({userID, compilation, projType: 'Tender', '$or':[{deleteInfo: null}, {'deleteInfo.completeDeleted': false}]});
  2939. return tenderCount + curTenderCount > limit;
  2940. }
  2941. async function getWelcomeInfo(compilationId,sessionUser,isFree=true) {
  2942. let welcom_setting = await welcomeModel.findOne({compilationId:compilationId});
  2943. let isShow = false;
  2944. let context = "";
  2945. let setting = null
  2946. if(welcom_setting){
  2947. setting = isFree? welcom_setting.normal:welcom_setting.professional;//区分专业版和免费版
  2948. }
  2949. if(setting){
  2950. if(setting.showType == 0) return [false,""];//关闭
  2951. context = setting.context;
  2952. if(setting.showType == 1){//每天一次
  2953. let dataString =moment(Date.now()).tz("Asia/Shanghai").format('YYYY-MM-DD');//今天的日期字符串
  2954. let userInfo =await userModel.findOne({_id: mongoose.Types.ObjectId(sessionUser.id)});
  2955. if (dataString != userInfo.welcomeShowTime){//今天没登录过
  2956. isShow = true;
  2957. await userModel.update({_id: mongoose.Types.ObjectId(sessionUser.id)},{welcomeShowTime:dataString})
  2958. }
  2959. }else if(setting.showType == 2){//每次登录显示
  2960. isShow = sessionUser.newLogin?true:false;
  2961. sessionUser.newLogin = false
  2962. }
  2963. }
  2964. return [isShow,context]
  2965. }