<?
/*****
* Installation procedures for local computer:
* 
* 1) create directories
* 
*/
ini_set('error_reporting', E_ALL & ~E_DEPRECATED);        // we write virtually all warnings.
ini_set('memory_limit', '2048M');                         // memory needed for image generation
ini_set('session.gc_maxlifetime', '1800');                // half an hours session
ini_set('zlib.output_compression', 'On');
ini_set('zlib.output_compression_level', '5');
ini_set('log_errors', 'On');

//
// following variables used for configuration only

// http://smm.loc - that the full address of my local application
//
$LOCAL_SITE_DOMAIN = 'smm.loc'; // set here name of your local site, for example showmark.loc
$LOCAL_SITE_PATH =  'c:\smg/'; // path to the local site, ending with backslash

$PRODUCTION_SITE_DOMAIN =  'www.showmark.com';
$PRODUCTION_SITE_PATH =    '/home/showmark/public_html/';

$CRM_SITE_DOMAIN =  'crm2.showmark.com'; /// @TODO: put corrcect domain here

$SITE_PATH = ''; // will contain a path to the website, main variable in use 

if(isset($_SERVER['DOCUMENT_ROOT']) && $_SERVER['DOCUMENT_ROOT'] != '')
	$SITE_PATH = $_SERVER['DOCUMENT_ROOT'].'/';
elseif (isset($_SERVER['HTTP_HOST']) && $_SERVER['HTTP_HOST'] === $LOCAL_SITE_DOMAIN)     // that's definition for developer local version. 
    $SITE_PATH = $LOCAL_SITE_PATH;
elseif (isset($_SERVER['HTTP_HOST']) &&  $_SERVER['HTTP_HOST'] === $PRODUCTION_SITE_DOMAIN) // that's definition for production website 
	$SITE_PATH = $PRODUCTION_SITE_PATH;
else 
{
    die ("Website path not defined for HTTP HOST".$_SERVER['HTTP_HOST']." Doc Root:[".$_SERVER['DOCUMENT_ROOT']."]. Config mismatch. Process halted.");
}    

$PHP_LOCAL_INI_PATH = $SITE_PATH.'data/logs/phperrors/phperrors-showmark-'.date('Y-m-d').'.txt';     // there are two php error logs, one is maintained hosting company 
ini_set('error_log', $PHP_LOCAL_INI_PATH);

// there are four configuration settings, that were used during different configuration exercises.  They can be replaced with the static values everywhere. 
$APP_DIR    = 'app/';
$FRONT_DIR  = 'front/';
$CUTILS_DIR = 'cutils/';
$ADMIN_DIR  = 'sadmin/';

// settings for GMAIL connection, not need to touch until GMAIL changes something    
$GMAIL_SMTP_HOST = "ssl://smtp.gmail.com:465";
$GMAIL_IMAP_HOSTNAME = '{imap.gmail.com:993/imap/ssl}INBOX';


// settings for accessing images or JS script stored on Amazon's S3
$IMAGES_URL_PREFIX = "https://showmark.s3.amazonaws.com/";
$CLOUD_GENERAL_URL = "https://showmark.s3.amazonaws.com/";         // *** ML used one time, not clear why needed
$CLOUD_ADMIN_IMAGES_URL = "https://showmark.s3.amazonaws.com/sadmin/images/";
$CLOUD_IMAGES_URL = "https://showmark.s3.amazonaws.com/images/"; // *** ML looks like not used any more


$HTTPS_SERVER_PATH = "https://".$_SERVER['HTTP_HOST']."/";
$SERVER_PATH       = "https://".$_SERVER['HTTP_HOST']."/"; // *** ML not clear when used 


$FCKEDITOR_PATH = $SERVER_PATH . 'sadmin/FCKeditor/';
$FCK_IMAGE_PREFIX_FOR_DISPLAY = $SERVER_PATH;
$FCK_IMAGE_PREFIX_FOR_STORAGE = $SERVER_PATH;
$CKFINDER_BASE_URL = $SERVER_PATH."data/";
$CKFINDER_BASE_DIR = $SITE_PATH.'data/';


$SERVER_PATH_PRODUCTION_SITE = "https://".$PRODUCTION_SITE_DOMAIN; // it's used when user tries to perform purchase on website that is not set fir ut
$SERVER_PATH_CRM_SITE = "https://crm.showmark.com/"; // contrary to the name, it's actually mail server site

$EMAILS_SERVER_PATH = $SERVER_PATH_PRODUCTION_SITE;        // used in emails for the path to the pictures or other built-in elements
$PATH_TO_IMAGEMAGICK_CONVERT_CMD = '/usr/local/bin/convert '; // 

$SITE_NAME_ONE = "showmark.com"; 
//$SITE_NAME_TWO = "smdisplays.com"; not used

// These two settings used when it's configured to exchange files on the local network which is set between those two servers. 
$SERVER_PATH_PRODUCTION_LOCAL = "http://192.168.10.3/";   
$SERVER_PATH_CRM_LOCAL = "http://192.168.10.2/";

$IS_DEVELOPER_SYSTEM = false;
$IS_LOCAL_DEVELOPER_SYSTEM = false;

// used by cron_backup and backup.php
$BACKUP_ENCRYPT_PASSWORD = "DantePintojkdf87345ytu9ey353ot87wlk8uyIxa";
$BACKUP_CORRECTION_PATH = ''; // this is correction, directory that will be substructed from full path of uploaded file when uploaded to Amazon
$today = date('d-m-Y-h-i');
$BACKUP_LOG_FILE = $SITE_PATH."data/logs/backup/backup_cron_log-$today.txt";
$BACKUP_DIRECTORY_PREFIX = ''; // directory where subdirectories with dates created for placement of backup files

// this command used on local Windows machibe to create archive
$BACKUP_ARCHIVE_WINDOWS_COMMAND =  '"C:\Program Files\7-Zip\7z.exe" a -tgzip'; // '"C:\Program Files\7-Zip\7z.exe" a -tgzip '.$file.'.gz  '.$file;            
$BACKUP_DB_AMOUNT_LIMIT = -1; // if it's set to some number, backup only makes this amount of tables archived, alphabetically, used for test purposes
$BACKUP_AMAZON_DIRECTORY = 'sql-backups/'.date('Y').'/'.date('m').'/';
$MYSQLDUMP_EXECUTABLE_DIRECTORY =  ''; // we expect that on local or windows machine, mysqldump will be in path, so no path needed to run it
$OPENSSL_EXECUTABLE_DIRECTORY = ''; // we expect that on local or windows machine, openssl will be in path, so no path needed to run it
       

$SQL_ERROR_EMAILS = array('binamica2@gmail.com'); // can be expanded to send MySQL to more 

//
// MYSQL custom log add-on setting -  no need to configure that 
// *** ML not sure it's fully working
//
$MYSQL_RUNTIME_LOG_ENABLED_FOR_EMAIL_SENT = false; //  if on, logs also email sendings scripts, that might increase load and slow system, as sending includes a lot of queries
$MYSQL_ERROR_LOG_DIRECTORY = $SITE_PATH.'data/logs/mysql/'; // $log_file = $MYSQL_ERROR_LOG_DIRECTORY.'mysql-errors.log';
$MYSQL_RUNTIME_LOG_DIRECTORY = $SITE_PATH.'data/logs/mysql/'; // 
$MYSQL_RUNTIME_LOG_ENABLED = false; // that's global variable that changed runtime through settings in DB, basically, for  not to check DB each time.
$MYSQL_RUNTIME_LOG_MINTIME_TO_RECORD = 0.5; // all scripts with less that this time will be ignored, in seconds
$MYSQL_RUNTIME_LOG_EXTRALONG_MINTIME_TO_RECORD = 5; // when it's more than this amount, special script written

                           
// below are definitions set for developer version on local account
// local  DEVELOPER version. PayPal, Converge.    
// !!! Attention, it looks like a real version of Amazon used !!!                                                                                 
//
if((isset($_SERVER['HTTP_HOST']) &&  (strpos($_SERVER['HTTP_HOST'], '.'.$LOCAL_SITE_DOMAIN) > 0) ||  
         ($_SERVER['HTTP_HOST'] === $LOCAL_SITE_DOMAIN) 
         ))  
{
    ini_set('error_reporting', E_ALL); // All errors trigger reporting.  
    ini_set('display_errors', 'On');   // It's a local version, so errors can be displayed with no problem. 
    ini_set('max_execution_time', 120);  // It's average execution time. It can be set longer on the real version. 
    ini_set('session.save_path', $SITE_PATH.'sessions');    // Just a configuration issue. Such directory should be present and writable. 
    
    $IS_DEVELOPER_SYSTEM = false;
    $IS_LOCAL_DEVELOPER_SYSTEM = true;
                                            
    $SERVER_PATH_CRM_SITE = $HTTPS_SERVER_PATH;
    
    // Below are settings for the test PayPal account. 
    $PAYPAL_USER_NAME = "igor.yakovets-facilitator_api1.gmail.com";
    $PAYPAL_USER_PWD = "XFQWP8J43NMZSPXG";
    $PAYPAL_USER_KEY = "Aueowvee7t6wjo8K4T-GGs3wJvPQAN.HoA0q9UxlaIjuo.XuvgeknZ2O";
    $REAL_PAYMENTS = false; // false is test mode
    
    // A test version of Converge Merchant. 
    $CONVERGE_MERCHANT_ID = '000127';
    $CONVERGE_USER_ID = 'ssltest';
    $CONVERGE_PIN = 'IERAOBEE5V0D6Q3Q6R51TG89XAIVGEQ3LGLKMKCKCVQBGGGAU7FN627GPA54P5HR';
    $CONVERGE_REAL_MODE = false;          
    
    // Attention, it looks like a real version of Amazon!!! 
    $AMAZON_ACCESS_KEY_ID = "AKIA3GJPCHP5DY6UQQOV";
    $AMAZON_SECRET_ACCESS_KEY = "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";
    $AMAZON_BUCKET_NAME = "showmark";
    $AMAZON_BUCKET_REGION = "us-east-1";                   
    $AMAZON_BUCKET_NAME_PRODUCTS = "showmark-products"; // This backend does exist. 
        

    define('IMAGEMAGICK_PATH_TO_CONVERT_CMD', '"c:/Program Files/ImageMagick-7.1.0-Q16-HDRI/convert.exe" ');   // Path to ImageMagick convert utility with a following space symbol. 
    
    $BACKUP_DIRECTORY_PREFIX = 'E:/showmark-local-test-backups/';
    $BACKUP_DB_AMOUNT_LIMIT = 5;
    $BACKUP_CORRECTION_PATH = $BACKUP_DIRECTORY_PREFIX;

    // TaxJar settings sandbox
    $TAXJAR_API_KEY = '8444f647b1843c4d25d3cda7f0df4107';
    $TAXJAR_API_URL = 'https://api.sandbox.taxjar.com/v2/'; // Sandbox URL
}
// --------------------------------------------
// real settings for production website
elseif (isset($_SERVER['HTTP_HOST']) &&  
       (strpos($_SERVER['HTTP_HOST'], $CRM_SITE_DOMAIN) > 0) || 
       ($_SERVER['HTTP_HOST'] == $CRM_SITE_DOMAIN)) 
{
	ini_set('display_errors', 'Off'); // We do not show any errors on the real production website. 

    $REAL_PAYPAL_PAYMENTS = true; // false is test mode
    
    
    // Real PayPal settings.             
	$PAYPAL_USER_NAME = "info_api1.showmark.com";
	$PAYPAL_USER_PWD = "9L5GGJP52XAPGMS9";
	$PAYPAL_USER_KEY = "Au0fCB3ohHcjU2SmQs-HoKVyTAJqA51f5cA3xsLkC3dKGRzW8EIg1lXK";

	
	$IS_DEVELOPER_SYSTEM = false; // it's real system, no test

    // Real Converge Merchant Settings. 
	$CONVERGE_MERCHANT_ID = '762366';
	$CONVERGE_USER_ID = 'webpage1';
	$CONVERGE_PIN = '65WG1DIIEZP25U57QORB6DTTG5NOI7YTA4KJVWGNHV0UT1BZWBG8DMPNAJ5KKGCO';
	$CONVERGE_REAL_MODE = true;
   
    // Real Amazon Connection Settings. 
    $AMAZON_ACCESS_KEY_ID = "AKIA3GJPCHP5DY6UQQOV";
    $AMAZON_SECRET_ACCESS_KEY = "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";
    $AMAZON_BUCKET_NAME = "showmark";
    $AMAZON_BUCKET_REGION = "us-east-1";
    
    // following Amazon settings for storage of products
    // *** ML - it looks like using Amazon for any storage of products has been deprecated. 
    //
    $AMAZON_BUCKET_NAME_PRODUCTS = "showmark-products"; // not used, no such bucket
    $AMAZON_URL_PREFIX = "https://showmark.s3.amazonaws.com/";
    $AMAZON_URL_PREFIX_PRODUCTS = "https://showmark-products.s3.amazonaws.com/";

    //
    // following settings define where SQL daily backup stored 
    // the cron job for a backup set under root user - as only root has access to /backup
    //
    $BACKUP_DIRECTORY_PREFIX = '/backup/fast_backups/';    
    $BACKUP_CORRECTION_PATH = '/backup/fast_backups/'; // that will be subtracted, so in S3 it will start from fast_backups_tryout
    
    // TaxJar settings.
    $TAXJAR_API_KEY = '35e6076f3f0f118cf4e2e8e5b3730776';
    $TAXJAR_API_URL = 'https://api.taxjar.com/v2/'; // Production URL

    define('IMAGEMAGICK_PATH_TO_CONVERT_CMD', '/usr/local/bin/convert ');
    
    if (PHP_OS_FAMILY === 'Linux')
                            $MYSQLDUMP_EXECUTABLE_DIRECTORY = '/usr/bin/';   // for some reason doesnt' work on LW server without it
    if (PHP_OS_FAMILY === 'Linux')
                            $OPENSSL_EXECUTABLE_DIRECTORY = '/opt/cpanel/ea-openssl11/bin/'; // for some reason doesnt' work on LW server without it                             
}
else
{
    echo "Died - TEST config defined.[".$_SERVER['HTTP_HOST'].']';
    die ("Remote hosting configuration mismatch");
}




/**
 * Function that returns database connection information
 *
 * @param bool $is_local_db - Whether to return local or remote database connection details
 * @param bool $is_archive_db - Whether to return connection details for an archive database
 * @param bool $is_mantis_db - Whether to return connection details for the Mantis database
 * @return array - Returns an associative array with connection details (host, user, db, pass)
 */
function GetDBConnectInfo($is_local_db = true, $is_archive_db = false, $is_mantis_db = false) 
{
    global $LOCAL_SITE_DOMAIN;
    
    $result = array();

    // Check if the request is coming from the local site domain
    if(isset($_SERVER['HTTP_HOST']) && ($_SERVER['HTTP_HOST'] == $LOCAL_SITE_DOMAIN)) 
    {
        if($is_archive_db) { 
            // Archive database connection details for local environment
            $result['host'] = "localhost";
            $result['user'] = "shmarchi_user";
            $result['db']   = "shmarchi_db";
            $result['pass'] = 'lizaakolvatestKepselXAgreenmood';
            $result['pass'] = substr($result['pass'], 14, 8); // Extracts a portion of the password
            
        } elseif($is_mantis_db) {
            // Mantis database connection details for local environment
            $result['host'] = "localhost";
            $result['user'] = "supportm_user";
            $result['db']   = "supportm_base";
            $result['pass'] = 'test1234';
            
        } else { 
            // Default local database connection
            $result['host'] = "localhost"; //:3308
            $result['user'] = "showmark_user";
            $result['db']   = "showmark_26_09_24";
            $result['pass'] = 'test1234';
        }
    } 
    else 
    {
        if($is_archive_db) {
            // Archive database connection details for remote environment
            $result['host'] = "192.168.10.3";
            $result['user'] = "shmarchi_user";
            $result['db']   = "shmarchi_db";
            $result['pass'] = '9jDGe5H$#%GqgQ%G$j52c8fPC?q[k#VluDVG5#d&f$2';
            $result['pass'] = substr($result['pass'], 19, 12);
            
        } elseif($is_local_db) {
            // Default remote database connection
            $result['host'] = "192.168.10.3";
            $result['user'] = "showmark_user";
            $result['db']   = "showmark_db";
            $result['pass'] = '8Bn131OXW30a';
            // echo "Remote database connection details are being used.<br/>";
            // $result['pass'] = '73}hi)n!@3pFMc8Bn(3=OXW^0a3SMs%QP$pD*M';
            // $result['pass'] = substr($result['pass'], 14, 12);
            
        } elseif($is_mantis_db) {
            // Mantis database connection details for remote environment
            $result['host'] = "localhost";
            $result['user'] = "supportm_user";
            $result['db']   = "supportm_base";
            $result['pass'] = 'k5f32Ft[7Fpn1etJPM2635INnO4KLmuFwsC5sKH';
            $result['pass'] = substr($result['pass'], 15, 15);
            
        } else {
            // Default remote database connection
            $result['host'] = "192.168.10.3";
            $result['user'] = "showmark_user";
            $result['db']   = "showmark_db";
            $result['pass'] = '73}hi)n!@3pFMc8Bn(3=OXW^0a3SMs%QP$pD*M';
            $result['pass'] = substr($result['pass'], 14, 12);
        }
    }
    
    return $result;    
}