var companyIDs = ["4f2a1cf0cd1cb2d861000014"]; //list of company IDs
var campaignType = 3; // 1: Cross Promotion 2: Direct Deal 3: Network 4: Exchange
var marketType = "publisher"; //If the campaign_type is 3, this will be set to either "publisher" or "advertiser"

db.campaigns.find({
    user:{$in:companyIDs},
    campaign_type: campaignType,
    market_type: marketType,
    hidden: {$exists: false}
}).forEach(function(camp){

    if (camp.ignore_apps){
        camp.ignore_apps.forEach(function(blockedAdvApp){
            var appType = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).type;
            var storeURL = 'No Store URL available';
            var nickName = 'No Nick Name available';
            var appName = 'No Offical Name available';

            if (appType == 1) {
                storeURL = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).itunes_url;
                appName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).name;
                nickName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).nickName;
                print("CampaignID:,"+ camp._id + ",blocked Advertiser App ID:," + blockedAdvApp + ",Store URL:," + storeURL + ",Offical Name:," + appName + ",Nick Name:," + nickName);
            } else if (appType == 2){
                storeURL = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).market_url;
                appName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).name;
                nickName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).nickName;
                print("CampaignID:,"+ camp._id + ",blocked Advertiser App ID:," + blockedAdvApp + ",Store URL:," + storeURL + ",Offical Name:," + appName + ",Nick Name:," + nickName);

            } else {
                appName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).name;
                nickName = db.apps.findOne({_id:ObjectId(blockedAdvApp)}).nickName;
                print("CampaignID:,"+ camp._id + ",blocked Advertiser App ID:," + blockedAdvApp + ",Store URL:," + storeURL + ",Offical Name:," + appName + ",Nick Name:," + nickName);
            }
        });
    } else {
        print("CampaignID:," + camp._id + ",is not blocking any Advertiser Apps");
    }

    if (camp.ignored_company_ids){
        camp.ignored_company_ids.forEach(function(blockedAdvCompany){
            var companyName = db.users.findOne({_id:blockedAdvCompany}).company;
            print("CampaignID:,"+ camp._id + ",blocked Advertiser Company ID:," + blockedAdvCompany + ",Company Name:," + companyName);
        });
    } else {
        print("CampaignID:," + camp._id + ",is not blocking any Advertising Companys");
    }
});