Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var count = 0;
- db.claims.find(
- { "resultStatus": { $exists: true }, "oktmo": /^46.*/i, "consultation": false, "creatorDeptId": { $exists: true }, "deadlineDate": { $exists: true }, "claimCreate": { $gte: ISODate("2017-05-01T00:00:00.744+0000"), $lte: ISODate("2017-06-29T23:59:59.744+0000") }, "senderCode" : "RRTR01001" }
- ).addOption(DBQuery.Option.noTimeout).forEach(function(claim) {
- var id = claim._id;
- var claimId = id.valueOf();
- var status = db.claims_status.findOne({
- "claimId": claimId,
- "statusCode": {
- $in: ['3', '4']
- }
- });
- if (status == null || status == undefined) {
- print("Sfu: " + id + "result: SHIT!");
- return;
- } else {
- var resultStatus = status.statusCode;
- var docSendDate = status.statusDate;
- //setDaysToDeadline(days < 1 ? (int) Math.ceil(days) : (int) days);
- //var daysToDeadline = NumberInt(Math.floor((claim.deadlineDate - docSendDate) / 1000 / 60 / 60 / 24));
- var days = (claim.deadlineDate - docSendDate)/ 1000 / 60 / 60 / 24;
- var daysToDeadline = days < 1 ? NumberInt(Math.ceil(days)) : NumberInt(days);
- if(docSendDate != null && docSendDate != undefined){
- var update = db.claims.update(
- {
- "_id": id
- },
- {
- $set: {
- //"resultStatus": resultStatus,
- "docSendDate": docSendDate,
- "daysToDeadline" : daysToDeadline,
- "tmpMKUChanged": true
- //"currStatus" : status
- }
- }
- );
- count = count + update.nModified;
- }
- print("Updated claim: " + claim.customClaimNumber);
- }
- });
- print("Updated total " + count + " claim(s).");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement