Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var count = 0;
- db.claims.find(
- { "docSendDate": { $exists: false }, "resultStatus": { $exists: true }, "claimCreate": { $gte: ISODate("2017-01-01T00:00:00.000+0000"), $lte: ISODate("2017-07-09T23:59:59.999+0000") }, "consultation": false }).addOption(DBQuery.Option.noTimeout).forEach(function(claim) {
- var id = claim._id;
- var claimId = id.valueOf();
- var status = db.claims_status.find({
- "claimId": claimId,
- "statusCode": {
- $in: ['3', '4']
- }
- }).sort( { "statusDate" : 1 } )[0];
- 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,
- "tmpMKUChanged_docSendDate": 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