# Database Json config

Please add all the "json" snippets use fot configuration in database like alternative_views.params or licences.licence_config

## licences.licence_config

````json
{
  //for ERS only
  "ERS_EVENT_MANAGEMENT": {
    "synchroProgram": {
      "api_key": "",
      "api_url_base": ""
    },
    "tags": {
      "need_payment": "91"
    }
  },
  "API_TIMEOUT": {
    "GET_CONTACT": VALUE_IN_SECONDS,
    "GET_CONTACTS": VALUE_IN_SECONDS,
    "LIST_EVENT_REGISTRATION": VALUE_IN_SECONDS,
    "LIST_ACTIVITIES_REGISTRATION": VALUE_IN_SECONDS
  },
  "EXTERNAL_ANALYTICS": {
    "google_analytics_id": "G-XXXXXXXXXX",
    "microsoft_clarity_id": "xxxxxxxxxx"
  },
 
  //for all
  "USER_RELOAD_RIGHTS_ENABLED": bool,
  "MEDIA_IMPORT": {
    "public_url": "https://username:password@domain.com/path_to_ftp/",
    "local_ftp_path": "/path_to_ftp/"
  },
  "LIVE_SERVER": {
    "LIVE_CHANNELS_IGNORE_PUBLIC": true
  }
}
````
// Params licence for Digitalhub ("CHECK_HCP_STATUS" must be true only if country is UK) 
````json
{ "CONTENT_TYPE_TAG_ID": 1, 
  "DISEASES_TAG_TYPE_ID": 1,
  "PRODUCTS_TAG_TYPE_ID": 3, 
  "COUNTRY_SPECIFICS_PARAMETERS": {
    "CHECK_HCP_STATUS": true, 
    "PATIENT_URL_REDIRECT": "Custom url here"}
}
````
// ERS licences.licence_config (cron update media types and content type) + config Darwin
````json
{
  "TAG_TYPES": {
    "MEDIA_TYPE": {
      "id": 9,
      "content": {
        "videos": 76,
        "documents": 77,
        "audio_podcasts": 79,
        "external_links": {
          "id": 78,
          "ers_journals": {
            "ERS_JOURNAL_LINK_1": "https://erj.ersjournals.com/content/63/6/2301518"
          }
        }
      }
    },
    "CONTENT_TYPE": {
      "id": 8,
      "CHANNEL_ID_TO_TAG_ID": {
        "25": 344,
        "185": 343
      }
    }
  },
  "ALTERNATIVE_VIEW": {
    "cme_online_channel": 41
  },
  "DARWIN_VIDEO_INTELLIGENCE_API": {
    "DARWIN_VIDEO_INTELLIGENCE_API_LIMIT": 5, // must be >= 1 and <= 20 default 8 
    "DARWIN_VIDEO_INTELLIGENCE_API_MIN_RATE": 0.35 // must be > 0.0 and <= 1.0 default 0.0
  }
}
````
// CME Key for ERS 
````json
{
  "CUSTOM_FIELDS_CONFIG": {
     "CME_KEY": "cmeKey"  
  } 
}
````
// Params licence for Eccmid 2025 
````json
{
  "TAGS": {
    "TAG_ESCMID_CME": 134,
    "TAG_ESCMID_HIGHLIGHT": 134,
    "TAGTYPE_ESCMID_TRACKS": 4,
    "TAG_ESCMID_NOTRECORDED": 146
  }, "TYPES": {
    "TYPES_ESCMID_TO_HIDE": [
      41, 42
    ]
  }
}

````
## templates.tpl_color_scheme
````json
{
  "sidebar_bg_color": "#002454",
  "sidebar_text_color": "#FFFFFF",
  "navbar_bg_color": "#002454",
  "navbar_text_color": "#FFFFFF",
  "homepage_section_bg_color": "#FFFFFF",
  "homepage_section_text_color": "#000000",
  "homepage_section_title_color": "#000000"
}
````

## stats_extract_requests.filter_data
````json
{
    "anonymous_checkbox": "1",
    "licence_master_checkbox": "0",
    "stats_export_start_date": "01/01/2023",
    "stats_export_end_date": "09/10/2023",
    "stats_export_cat_id": null,
    "report" : {
      "Media pages rating": "1",
      "Media views": "1",
      "Platform connections": "1",
      "Booth treasure hunter": "1",
      "Media views by category": "1",
      "Pre-rolls": "1",
      "Banners": "1",
      "Pop-ups": "1",
      "Booths": "1",
      "Booth contact forms": "1",
      "Connection time per session per live": "1",
      "Live questions": "1",
      "Chatroom messages": "1",
      "Media pages views by category": "1",
      "Tracked links": "1",
      "Media pages visites": "1",
      "Media pages visites by category": "1",
      "Polls": "1"
    }
}
````

## enable agenda recommended sessions
````json
{
  "is_recommended_session_enabled": true
}
````

// Params licence for AdvanzPharma MI - Germany DocCheck HCP flow (fo-advanz-login-redirect.php + template advanzpharmami/vues/fo_header.vue.php)
  ````json
  {
    "COUNTRY_SPECIFICS_PARAMETERS": {
      "GERMANY": {
        "HCP_CONTENT_CHANNEL_URL": "/channel-27-hcp",
        "HCP_HOME_PAGE_CHOICE_URL": "/hp-7-1-german-choice-hcp-patient",
        "DOCKCHECK_FAIL_REDIRECT_URL": "/page-error-login"
      }
    }
  }
````