<?
$timestamp_phpstart = microtime(true);
error_reporting(E_ALL);
ini_set('display_errors', 1);
define('SHOW_DEBUG', true);

//setlocale(LC_ALL, "de_DE.utf-8");
ini_set('intl.default_locale', 'de-DE');
//echo Locale::getDefault();

define('PARENTBASEURL', "http://www.ivf.at");
define('BASEURL', "https://marketing.ivf.at");
define('ROOT', 'W:\www\marketing.ivf.at');
define('BASEURL_MT', "https://medical-training.ivf.at");
define('ROOT_MT', 'W:\www\medical-training.ivf.at');
define('BASEURL_BGZ', "https://www.ivf.at");
define('ROOT_BGZ', 'W:\www\ivf.at');
define('ROOT_FP_CONFIG_IVFCENTERS_XML', 'W:\www\ivf-singles.com\__config_ivf_centers\config_ivfcenters.xml');
define('ROOT_FP_CONFIG_IVFEMPLOYEES_XML', 'W:\www\ivf.at\data\config_employees_bgz.xml');
define('ROOT_FP_CONFIG_IVFEVENTS_XML', 'W:\www\ivf.at\data\config_events_bgz.xml');
define('SHOW_IVF_TOOLBAR', true);
define('DO_IVF_TRACKING', true);
define('LANG', 'de-DE');
define('CENTER_TOKEN', 'bgz');
//define('XML_FP_EVENTS', BASEURL.'/inc/config_events_'.CENTER_TOKEN.'.xml');
define('XML_FP_EVENTS', 'http://www.ivf.at/data/config_events_bgz.xml');


// SOLL SPÄTER AUS config_ivfcenters.xml KOMMEN!!   Id via CENTER_TOKEN
//   ===>
define('CENTER_CITY', 'Bregenz');
define('CENTER_FULLNAME', 'IVF Zentren Prof. Zech');
define('EMAIL', 'presse@ivf.at');
define('TEL', '+43 5574 44836');
//  <====
 
define('SYNC_DM', true);

$arr_allowedip = array('91.118.90.2', '91.141.3.109', '85.125.216.2','83.173.221.90', '85.31.155.18' );
define('CHECK_ALLOWED_IP', false);
define('NUM_KIWUAB_MAX', 2);
define('ARZTLIST_AUSSENDUNG_ROWS_MAX', 5);
 
// +-------+
// | MYSQL |
// +-------+

// server params 

// marketing.ivf.at
define('DB_SERVER', "localhost");
define('DB_USER', "marketing");
define('DB_PASS', "mark69ook13");
define('DB_DATABASE', "marketing");
// medical-training.ivf.at
define('DB2_SERVER', "localhost");
define('DB2_USER', "medicaltraining");
define('DB2_PASS', "fortbil3928fg");
define('DB2_DATABASE', "medicaltraining");
/* Zentrum BGZ (eg subscription for Micaela/Fertitravel) */	
define('ZENTR_BGZ_SERVER', "localhost");
define('ZENTR_BGZ_USER', "ivfadmin_bgz");
define('ZENTR_BGZ_PASS', "blastozystika400?");
define('ZENTR_BGZ_DATABASE', "ivfzentrum_bgz");
/* Zentrum NUZ (eg subscription for Micaela/Fertitravel) */	
define('ZENTR_NUZ_SERVER', "localhost");
define('ZENTR_NUZ_USER', "ivfadmin_nuz");
define('ZENTR_NUZ_PASS', "GmDb4RCT89PxpSYU");
define('ZENTR_NUZ_DATABASE', "ivfzentrum_nuz");
/* eizellspende.eu */	
define('EIZELLSPEU_SERVER', "localhost");
define('EIZELLSPEU_USER', "marketing");
define('EIZELLSPEU_PASS', "mark69ook13");
define('EIZELLSPEU_DATABASE', "eizellspende.eu");
/* Zentrum SBG */
define('ZENTR_SBG_SERVER', "localhost");
define('ZENTR_SBG_USER', "marketing");
define('ZENTR_SBG_PASS', "mark69ook13");
define('ZENTR_SBG_DATABASE', "ivfzentrum_sbg");
/* ..... dynamed interface db (subscribe serology)  ..................  */	
define('DB_DM_INTERFACE_SERVER', "localhost");
define('DB_DM_INTERFACE_USER', "marketing");
define('DB_DM_INTERFACE_PASS', "mark69ook13");
define('DB_DM_INTERFACE_DATABASE', "dm_interface");
/* infocenter.ivf.at FAQ DB */	
define('FAQDB_SERVER', "localhost");
define('FAQDB_USER', "ivfadmin_bgz");
define('FAQDB_PASS', "blastozystika400?");
define('FAQDB_DATABASE', "ivfzentrum_bgz");
/* ..... ivf_track db  ..................  */	
define('DB_IVFTRACK_SERVER', "localhost");
define('DB_IVFTRACK_USER', "ivfanalytics");
define('DB_IVFTRACK_PASS', "aRffMmygcgNquBgH");
define('DB_IVFTRACK_DATABASE', "ivf_analytics");
/* ..... marketing calendar db  ..................  */	
define('DB_MARKETINGCALENDAR_SERVER', "localhost");
define('DB_MARKETINGCALENDAR_USER', "marketing");
define('DB_MARKETINGCALENDAR_PASS', "mark69ook13");
define('DB_MARKETINGCALENDAR_DATABASE', "marketing_calendar");
// ----------------------------------------
$arr_db_subscription = array();
$arr_db_subscription['bgz']['DB_SERVER'] = 'localhost';
$arr_db_subscription['bgz']['DB_USER'] = 'ivfadmin_bgz';
$arr_db_subscription['bgz']['DB_PASS'] = 'blastozystika400?';
$arr_db_subscription['bgz']['DB_DATABASE'] = 'ivfzentrum_bgz';
$arr_db_subscription['sbg']['DB_SERVER'] = 'localhost';
$arr_db_subscription['sbg']['DB_USER'] = 'ivfadmin_sbg';
$arr_db_subscription['sbg']['DB_PASS'] = 'admi6900x50';
$arr_db_subscription['sbg']['DB_DATABASE'] = 'ivfzentrum_sbg';
$arr_db_subscription['kiwutalk']['DB_SERVER'] = 'localhost';
$arr_db_subscription['kiwutalk']['DB_USER'] = 'kiwucare';
$arr_db_subscription['kiwutalk']['DB_PASS'] = 'aqjvaIotLcvlkY6C';
$arr_db_subscription['kiwutalk']['DB_DATABASE'] = 'kiwucare';
$arr_db_subscription['sga']['DB_SERVER'] = 'localhost';
$arr_db_subscription['sga']['DB_USER'] = 'ivfadmin_nuz';
$arr_db_subscription['sga']['DB_PASS'] = 'GmDb4RCT89PxpSYU';
$arr_db_subscription['sga']['DB_DATABASE'] = 'ivfzentrum_nuz';


// FAQDB table names
define ("T_FAQ", "ivf_faq");
define ("T_FAQNEW", "ivf_faqnew");
define ("T_GLOSSAR", "ivf_glossar");
// -------------------------------------------
// DMI table names
define("T_DMI_APM", 'appointments'); 						//dynamed interface! apm = appointments
define("T_DMI_APM_RESERVATION", 'appointment_reservation'); //dynamed interface!
define("T_DMI_COUNTRY", 'country'); 						//dynamed interface!
define("T_DMI_GENDER", 'gender');							//dynamed interface!
define("T_DMI_MANDATOR", 'mandator');						//dynamed interface!
define("T_DMI_KIWUCARE_EMFPAENGER", 'kiwucare_empfaenger');						//dynamed interface!
// -------------------------------------------
// IVFTRACK table names
define ("T_TRACK", "ivf_track");  
define ("T_TRACKCAMPAIGN", "ivf_trackcampaign");
define ("T_TRACKBLACKLIST", "ivf_trackblacklist");
define ("T_TRACKCAMPAIGNDATACONSOLIDATED", "ivf_trackcampaigndataconsolidated");
// -------------------------------------------
// GENERAL TABLE NAMES
define ("T_SUBSCRIPTION", "ivf_subscription");  // also in other DB (kiwuab)
define ("T_ORDER", "ivf_order");
define ("T_ORDER_ARTICLES", "ivf_order_articles");
define ("T_SHIPPING", "ivf_order_shipping");
define ("T_SHIPPINGSTATUS", "ivf_order_shippingstatus");
define ("T_BROCHURESTOCK", "ivf_brochurestock");
define ("T_BROCHUREPRODUCTIONORDER", "ivf_brochureproductionorder");
define ("T_USER", "ivf_user");
define ("T_USER_CENTER", "ivf_user_center");
define ("T_LOG", "ivf_log");
define ("T_ARZT", "ivf_med_arzt");
//define ("T_ARZT", "ivf_med_arzt_test");
define ("T_ARZT_ORG", "ivf_med_arzt_org");
define ("T_ARZT_BILLING", "ivf_med_arzt_billing");
define ("T_ARZT_FACHGEBIET", "ivf_med_arzt_fachgebiet");
define ("T_ARZT_COOPERATION", "ivf_med_arzt_cooperation");
define ("T_ARZT_AUSSENDUNG", "ivf_aussendung_arztorg");  // before 2025-06-12: ivf_med_arzt_aussendung // T_ARZT_AUSSENDUNG => später löschen!
define ("T_AUSSENDUNG_ARZTORG", "ivf_aussendung_arztorg");  // neu seit 2025-06-12
define ("T_AUSSENDUNG_EMAIL", "ivf_aussendung_email");  // neu seit 2025-07-23
define ("T_ARZT_ORG_GROUP", "ivf_med_arzt_org_group");
//define ("T_ARZT_ORG_CACHE", "ivf_med_arzt_org_cache"); // neu seit 2025-07-23
define ("T_ARZT_ORG_SEARCHSTR", "ivf_med_arzt_searchstr"); // neu seit 2025-07-23
define ("T_ARZTBRIEF", "ivf_arztbrief");
define ("T_AUSSENDUNG", "ivf_aussendung");
define ("T_AUSSENDUNGSTATUS", "ivf_aussendungstatus");
define ("T_ORG", "ivf_med_org");
define ("T_ORGTYPE", "ivf_med_orgtype");
define ("T_EMAIL", "ivf_email");  
define ("T_EMAILTYPE", "ivf_emailtype");     // neu seit 2025-06-12
define ("T_BILLING", "ivf_med_billing");
define ("T_FACHGEBIET", "ivf_med_fachgebiet");
define ("T_COOPERATION", "ivf_med_cooperation");
define ("T_UEBERWEISUNG", "ivf_med_ueberweisung");
define ("T_VISIT", "ivf_visit");
define ("T_VISITTELKON", "ivf_visittelefonkontakt");
define ("T_VISITTELKON_TODO", "ivf_visittelefonkontakt_todo");
define ("T_BLACKLIST_ARZTORG", "ivf_blacklist_arztorg"); // before 2025-06-11: ivf_med_arzt_aussendung_blacklist
define ("T_BLACKLIST_EMAIL", "ivf_blacklist_email");
define ("T_COUNTRY", "ivf_countryiso3166");
define ("T_LANGUAGE", "ivf_languageiso639");
define ("T_PROVINCE", "ivf_country_province");
define ("T_VIDEO", "ivf_video");
define ("T_ARTICLE", "ivf_article");
define ("T_ARTICLETYP", "ivf_articletyp");
define ("T_SURVEY", "ivf_survey");
define ("T_SURVEYRETURN", "ivf_surveyreturn");
define ("T_SURVEYANSWERRETURN", "ivf_surveyanswerreturn");
define ("T_SURVEYANSWERCHOICE", "ivf_surveyanswerchoice");
define ("T_SURVEYQUESTION", "ivf_surveyquestion");
define ("T_NLEMPFAENGER", "ivf_nlempfaenger");
define ("T_NLAGENDA", "ivf_nlagenda");
define ("T_NLJOB", "ivf_nljob");
define ("T_NLE_NLS", "ivf_nle_nls");
define ("T_NLSZENARIO", "ivf_nlszenario");
define ("T_PUBLICATION", "ivf_publication");
define ("T_PUBTYPE", "ivf_pubtype");
define ("T_PRESSARTICLE", "ivf_press_article");
define ("T_PRESSARTICLEIMPORT", "ivf_press_articleimport");
define ("T_PRESSREQUEST", "ivf_press_request");
// replication from ZEIES:
define ("T_KUNDEN", "ivf_zeies_kunden_20210525");
define ("T_PROJEKTE", "not-yet-set");
// ------
define ("T_APPOINTMENTS_EG", "ivf_appointments_eg");
define ("T_APPOINTMENTS_I20", "ivf_appointments_i20");
// 
define ("T_KIWUTALK_EMPFAENGER_FINAL", "ivf_kiwutalk_empfaenger_final");
define ("T_KIWUTALK_EMPFAENGER_TEST", "ivf_kiwutalk_empfaenger_test");
define ("T_KIWUTALK_EMPFAENGER_DYNAMED_BAK", "ivf_kiwutalk_empfaenger_dynamed_bak");
define ("T_IVF_DMPATIENT", "ivf_dmpatient");

define ("T_LEAD", "ivf_lead");
define ("T_LEADTYPE", "ivf_leadtype");
define ("T_LEADSOURCE", "ivf_leadsource");
define ("T_LEADLOG", "ivf_leadlog");
//define ("T_LEADLOG", "ivf_leadlog_dev");
define ("T_LEADLOGACTION", "ivf_leadlogaction");
define ("T_LEADFEEDBACKKAT", "ivf_leadfeedbackkat");


define ("T_MARKETINGACTIVITY", "ivf_marketingactivity");
define ("T_MAAC_STATUSOPTION", "ivf_maac_statusoption");
define ("T_MAAC_TARGETGROUP", "ivf_maac_targetgroup");
define ("T_MAAC_TIMEINTERVALMEASUREMENT", "ivf_maac_timeintervalmeasurement");
define ("T_MAAC_FIELD", "ivf_maac_field");

// marketing_calendar
define ("T_CAL_EVENTS", "cal_events");
define ("T_CAL_CALENDAR", "cal_calendar");
define ("T_CAL_EVENTS_CATEGORIES", "cal_events_categories");







/*
// EMAIL
$arr_email_conf['IVFWWW2']['SMTP_Host'] = '172.16.13.177';
$arr_email_conf['IVFWWW2']['username'] = 'webserverIVFWWW2';
$arr_email_conf['IVFWWW2']['pwd'] = 'B:UBSS&aR4Qg@m#';
*/	
$arr_email_conf['IVFWWW2']['SMTP_Host'] = 'smtp.office365.com';
$arr_email_conf['IVFWWW2']['username'] = 'noreply@ivf.at';
$arr_email_conf['IVFWWW2']['pwd'] = '3yrP#eB*li';
//$arr_email_conf['IVFWWW2']['username'] = 'Noreply@next-clinics.com';
//$arr_email_conf['IVFWWW2']['pwd'] = 'Fab28282';


$arr_email_conf['marcom']['from'] = 'noreply@ivf.at';
$arr_email_conf['marcom']['fromname'] = 'noreply@ivf.at';
//$arr_email_conf['marcom']['from'] = 'newsletter@ivf.at';
//$arr_email_conf['marcom']['fromname'] = 'newsletter@ivf.at';
$arr_email_conf['marcom']['replyto'] = 'newsletter@ivf.at';
$arr_email_conf['marcom']['replytoname'] = 'newsletter@ivf.at';
$arr_email_conf['marcom']['arr_receiver_host'] = array('e.lechner@ivf.at', 'r.winsauer@ivf.at');

$arr_email_conf['brochureorder']['arr_receiver_host'] = array('e.lechner@ivf.at', 'rabia.yelkenci@ivf.at');
$arr_email_conf['brochureorder']['arr_receiver_forwardtogonadosan'] = array('office@fertilovit.com', 'e.lechner@ivf.at'); // office@fertilovit.com



$arr_email_conf['cron_notification']['from'] = 'noreply@ivf.at';
$arr_email_conf['cron_notification']['fromname'] = 'noreply@ivf.at';
//$arr_email_conf['cron_notification']['from'] = 'zech@ivf.at';
//$arr_email_conf['cron_notification']['fromname'] = 'zech@ivf.at';
$arr_email_conf['cron_notification']['replyto'] = 'zech@ivf.at';
$arr_email_conf['cron_notification']['replytoname'] = 'zech@ivf.at';
$arr_email_conf['cron_notification']['arr_receiver_host'] = array('e.lechner@ivf.at');


// COPY FROM ivf.at !!!!!
$arr_email_conf['kiwuab']['from'] = 'noreply@ivf.at';
$arr_email_conf['kiwuab']['from_name'] = 'noreply@ivf.at';
$arr_email_conf['kiwuab']['replyto'] = "zech@ivf.at";
$arr_email_conf['kiwuab']['replyto_name'] = 'Next Fertility IVF Prof. Zech Bregenz';
$arr_email_conf['kiwuab']['arr_receiver_host'] = array('zech@ivf.at');
// ----------------------


/*
$arr_email_conf['kiwuab']['from'] = 'noreply@ivf.at';
$arr_email_conf['kiwuab']['from_name'] = 'noreply@ivf.at';
//$arr_email_conf['kiwuab']['from'] = EMAIL;
//$arr_email_conf['kiwuab']['from_name'] = CENTER_FULLNAME;
$arr_email_conf['kiwuab']['replyto'] = EMAIL;
$arr_email_conf['kiwuab']['replyto_name'] = CENTER_FULLNAME;
//$arr_email_conf['kiwuab']['arr_receiver_host'] = array(EMAIL, 'e.lechner@ivf.at', 'r.das@kinderwunsch-ivf-koeln.de', 'n.feurstein@ivf.at');
$arr_email_conf['kiwuab']['arr_receiver_host'] = array('office@kinderwunsch-salzburg.at', 'e.lechner@ivf.at');
//$arr_email_conf['kiwuab']['arr_receiver_host'] = array('eric.lechner@gmx.net', 'e.lechner@ivf.at', 'eric@ericlechner.com');
//$arr_email_conf['kiwuab']['arr_receiver_host'] = array('e.lechner@ivf.at');
//$arr_email_conf['kiwuab']['smtp_host'] = 'smtp.server100.at';
//$arr_email_conf['kiwuab']['smtp_username'] = 'User100';
//$arr_email_conf['kiwuab']['smtp_password'] = 'Pass100';
//$arr_email_conf['cron_notice_to'] = '';


$eg_email = 'erstgespraech@ivf.at';
//$arr_email_conf['calendar_appointment_booking']['from'] = $eg_email;
$arr_email_conf['eg']['from'] = $eg_email;
$arr_email_conf['eg']['from_name'] = CENTER_FULLNAME; 
$arr_email_conf['eg']['replyto'] = $eg_email;
$arr_email_conf['eg']['replyto_name'] = CENTER_FULLNAME;
//$arr_email_conf['eg']['arr_receiver_host'][0] = 'e.lechner@ivf.at'; 
$arr_email_conf['eg']['arr_receiver_host'][0] = $eg_email; 
$arr_email_conf['eg']['arr_receiver_host'][1] = 'micaela.deugarte@fertitravel.com'; 
//$arr_email_conf['eg']['arr_receiver_host'][2] = 'eric@ericlechner.com'; 
//$arr_email_conf['eg']['arr_receiver_host'][3] = 's.seidel@kinderwunsch-ivf.de'; 
//$arr_email_conf['eg']['arr_receiver_host'][4] = 'r.winsauer@ivf.at'; 


$i20_email = 'informationsgespraech@ivf.at';
$arr_email_conf['i20']['from'] = $i20_email;
$arr_email_conf['i20']['from_name'] = CENTER_FULLNAME; 
$arr_email_conf['i20']['replyto'] = $i20_email;
$arr_email_conf['i20']['arr_receiver_host'][0] = $i20_email;
//$arr_email_conf['i20']['arr_receiver_host'][1] = 'e.lechner@ivf.at';

*/


?><?
// init.inc
// on marketing.ivf.at


session_start(); 
include(ROOT.'/class/ivf_server.class.php'); 
include(ROOT.'/class/ivf_debug.class.php');
include(ROOT.'/class/ivf_log.class.php');
include(ROOT.'/class/ivf_json.class.php');
include(ROOT.'/class/ivf_date.class.php');
include(ROOT.'/class/ivf_center.class.php');
include(ROOT.'/class/ivf_author.class.php'); 
//include(ROOT.'/class/ivf_employee.class.php');
include(ROOT.'/class/ivf_event.class.php');
include(ROOT.'/class/ivf_blog.class.php');
include(ROOT.'/class/ivf_template.class.php');
include(ROOT.'/class/ivf_page.class.php');
include(ROOT.'/class/ivf_brochure.class.php');
include(ROOT.'/class/db.class.php');			// main db
include(ROOT.'/class/db2.class.php'); 		// additional dbs with access
include(ROOT.'/class/ivf_track.class.php');
include(ROOT.'/class/ivf_subscription.class.php');
// PDF
require_once(ROOT.'/addons/fpdf17/fpdf.php');
require_once(ROOT.'/class/ivf_pdfgenerator.class.php');
// Login
include(ROOT.'/class/ivf_user.class.php');
include(ROOT.'/class/ivf_login.class.php');
// Mail
include(ROOT.'/class/PHPMailer/class.phpmailer.php');
include(ROOT.'/class/PHPMailer/class.smtp.php');
include(ROOT.'/class/ivf_mail.class.php');
// ----------

$timestamp_include_finished = microtime(true);
$db = new DB(DB_DATABASE, DB_SERVER, DB_USER, DB_PASS);
$timestamp_after_init_db = microtime(true);
$db_mt = new DB2(DB2_SERVER, DB2_DATABASE, DB2_USER, DB2_PASS); // connect to DB "medicaltraining" !!!
$db_marketingcalendar = new DB2(DB_MARKETINGCALENDAR_SERVER, DB_MARKETINGCALENDAR_DATABASE, DB_MARKETINGCALENDAR_USER, DB_MARKETINGCALENDAR_PASS);
$timestamp_after_init_db2 = microtime(true);
$server = new IVF_SERVER();
$timestamp_after_init_ivf_server = microtime(true);
$server->ReadAllQueryParams();
$timestamp_after_read_all_query_params = microtime(true);
$login = new IVF_LOGIN($db, $server, 'http://marketing.ivf.at/index.php', 'brochure_order.php', $arr_allowedip);
$log = new IVF_LOG($db);

function Debug ($v=false, $vname='') {
}

// return array anyway
function Arr ($v) {
  if (is_array($v)) {
    return $v;
  } else {
    return (array());
  }
}

// $str_k ... nested keys => array("k1","k2","k3") => $arr[$k1][$k2][$k3]
function ArrV ($arr, $arr_k) {
  $k = array_shift($arr_k);
  //Debug($k,'ArrV 1 Start $k');
  if (count($arr_k) == 0) { // last nested element reached
    //Debug($arr[$k],'ArrV 2 Value found');
    $v = $arr[$k];
  } else {
    //Debug($arr[$k],'ArrV 3 Call Recursive');
    if (array_key_exists($k, $arr)) {
      return ArrV($arr[$k],$arr_k); // wichtig auch hier return, da ansonsten $v verloren geht!
    } else {
      //Debug($arr, 'ArrV: key: "'.$k.'" not found in data array 773612. Return empty string.');
      return '';
    }
  }
  return $v;
}

//$kinderwunschblog = new IVF_Blog_Widget('http://www.kinderwunsch-blog.com/?feed=rss2', 'templ/feed_article_startpage.templ.php', 500);
//$authors = new IVF_AUTHORS();

$timestamp_before_init_ivf_center = microtime(true);
$ivf_center = new IVF_CENTER(ROOT_FP_CONFIG_IVFCENTERS_XML, CENTER_TOKEN);

// -------------------------------------------------------------------------
// employee class from ivf.at, loaded in inc/init_employee.inc.php
// employees (xml) loaded from different zentren homepage (=> section #Team)
$ivf_employee = false;
// -------------------------------------------------------------------------

$user = new IVF_USER($db, $server);
$page = new IVF_PAGE('', $ivf_center, $ivf_employee);
$page->SetObjLogin($login);
$event = false; 		  // events (xml) on zentren homepage, not in marketing.ivf.at
$subscription_mt = new IVF_SUBSCRIPTION($db_mt);  // subscription for medical-training (Fortbildungen), not KiWuAb! Use different DB from different site (medical-training.ivf.at)!
 
//public $ivf_center;
	

?>