<?php
require_once "../Common.php";

initDatabase();
foreach( $argv as $argument ) {
    if( $argument == $argv[ 0 ] ) continue;

    $pair = explode( "=", $argument );
    $variableName = substr( $pair[ 0 ], 2 );
    $variableValue = $pair[ 1 ];
    echo $variableName . " = " . $variableValue . "\n";
    // Optionally store the variable in $_REQUEST
    $_REQUEST[ $variableName ] = $variableValue;
}

$use_trading_date_today = $_REQUEST['tradingdate'] == 'today';
$trading_date_to_use = "";
if (preg_match("/^\d{4}-\d{2}-\d{2}$/", $_REQUEST['trading_date'])) {
    $trading_date_to_use = $_REQUEST['trading_date'];
}
$url_base = $_REQUEST['url_base'];
$date = $_REQUEST['date'];

$pretend = $_REQUEST['pretend'];

$strategies = get_strategies($date, $url_base);
$strategy_count = count($strategies);
echo "Found $strategy_count strategies\n";
foreach ($strategies as $strategy) {
    $config = $strategy['config'];
    $strategy_id = $strategy['id'];
    $optimize_date = $strategy['DATE'];
    $trading_date = get_trading_date($strategy['DATE']);
    if ($trading_date_to_use) {
        $trading_date = $trading_date_to_use;
    }
    echo "Checking strategy: $strategy_id, $optimize_date, $config\n";
    if (preg_match("/^\d+$/", $strategy_id)) {
        $sql = "SELECT id FROM ai_strategies WHERE strategy_id = $strategy_id AND trading_date = '$trading_date'";
        $result = mysql_query($sql);
        $row = mysql_fetch_row($result);
        if ($row[0]) {
            $id = $row[0];
            $sql = "UPDATE ai_strategies SET
                strategy_id = $strategy_id,
                name = '" . mysql_escape_string($strategy['NAME']) . "',
                creation = NOW(),
                optimize_date = '" . mysql_escape_string($strategy['DATE']) . "',
                trading_date = '" . mysql_escape_string($trading_date) . "',
                trading_date_ymd = '" . mysql_escape_string($trading_date) . "',
                settings = '" . mysql_escape_string(get_settings($strategy['CONFIG'])) . "',
                cloud_link = '" . mysql_escape_string(get_cloud_link($strategy['CLOUD_LINK'])) . "',
                is_long = " . ($strategy['DIRECTION'] == "L" ? 1 : 0) . ",
                timeframe = '" . mysql_escape_string($strategy['TIMEFRAME']) . "',
                score = '" . mysql_escape_string($strategy['SYSTEM_SCORE']) . "',
                total_trades = '" . mysql_escape_string($strategy['TOTAL_TRADES']) . "',
                max_trades_per_day = '" . mysql_escape_string($strategy['MAX_TRADES_PER_DAY']) . "',
                is_winrate = '" . mysql_escape_string($strategy['IS_WINRATE']) . "',
                is_profit_factor = '" . mysql_escape_string($strategy['IS_PROFIT_FACTOR']) . "',
                oos_winrate = '" . mysql_escape_string($strategy['OOS_WINRATE']) . "',
                oos_profit_factor = '" . mysql_escape_string($strategy['OOS_PROFIT_FACTOR']) . "' WHERE id = $id";
            echo "Updating $sql\n";
            if (!$pretend) {
                $result = mysql_query($sql);
                if (!$result) {
                    echo "Error updating: " . mysql_error() . "\n";
                }
            }
        } else {
            $sql = "INSERT INTO ai_strategies (strategy_id, name, creation, optimize_date, trading_date, trading_date_ymd,
                settings, cloud_link, is_long, timeframe, score, total_trades, max_trades_per_day, is_winrate,
                is_profit_factor, oos_winrate, oos_profit_factor) VALUES (
                    $strategy_id, '" . mysql_escape_string($strategy['NAME']) . "', NOW(),
                '" . mysql_escape_string($strategy['DATE']) . "',
                '" . mysql_escape_string($trading_date) . "',
                '" . mysql_escape_string($trading_date) . "',
                '" . mysql_escape_string(get_settings($strategy['CONFIG'])) . "',
                '" . mysql_escape_string(get_cloud_link($strategy['CLOUD_LINK'])) . "',
                " . ($strategy['DIRECTION'] == "L" ? 1 : 0) . ",
                '" . mysql_escape_string($strategy['TIMEFRAME']) . "',
                '" . mysql_escape_string($strategy['SYSTEM_SCORE']) . "',
                '" . mysql_escape_string($strategy['TOTAL_TRADES']) . "',
                '" . mysql_escape_string($strategy['MAX_TRADES_PER_DAY']) . "',
                '" . mysql_escape_string($strategy['IS_WINRATE']) . "',
                '" . mysql_escape_string($strategy['IS_PROFIT_FACTOR']) . "',
                '" . mysql_escape_string($strategy['OOS_WINRATE']) . "',
                '" . mysql_escape_string($strategy['OOS_PROFIT_FACTOR']) . "')";
            echo "Inserting $sql\n";
            if (!$pretend) {
                $result = mysql_query($sql);
                if (!$result) {
                    echo "Error inserting: " . mysql_error() . "\n";
                }
            }
        }

        $ai_admin_sql = "REPLACE INTO ai_admin (strategy_id, strategy_name, creation, trading_date) VALUES (
            $strategy_id, '" . mysql_escape_string($strategy['NAME']) . "', NOW(),
            '" . mysql_escape_string($trading_date) . "')";
        $ai_admin_result = mysql_query($ai_admin_sql);
        if ($ai_admin_result) {
            echo "Success replacing into: $ai_admin_sql\n";
        } else {
            echo "Error replacing into using $ai_admin_sql: " . mysql_error() . "\n";
        }
    }
}

function get_xml_from_url($url) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_USERPWD, "TIPro:sNbhh8FWF86DMkmA");
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); //see link below
    $result = curl_exec($ch);
    curl_close($ch);
    //echo "Got $result\n";
    $xml = simplexml_load_string($result);
    #echo "Got XML\n";
    return $xml;
}

function get_strategies($date = "", $url_base = "") {
    $to_return = array();
    if ($url_base == "") {
        $url_base = "https://secure.trade-ideas.com/cms_static/ai_channel";
    }
    #$layout_xml = simplexml_load_file("/var/www/alldocs/main/autooptimize/strategy_layout.xml");
    #$layout_xml = simplexml_load_file("http://will.trade-ideas.com/autooptimize/strategy_layout.test.xml");
    #$layout_xml = simplexml_load_file("http://will.trade-ideas.com/autooptimize/strategy_layout.xml");
    $layout_url = "$url_base/strategy_layout.xml";
    if ($date != "") {
        $layout_url = "$url_base/strategy_layout.$date.xml";
    }
    echo "Using layout url: $layout_url\n";
    $layout_xml = get_xml_from_url($layout_url);
    $strategy_layouts = array();
    $strategy_id = 0;
    $variables = array("DATE", "NAME", "DIRECTION", "TIMEFRAME", "CONFIG", "TOTAL_TRADES", "MAX_TRADES_PER_DAY", "SYSTEM_SCORE", "IS_WINRATE", "IS_PROFIT_FACTOR", "OOS_WINRATE", "OOS_PROFIT_FACTOR", "CLOUD_LINK", "CREATION_DATE");
    foreach ($layout_xml as $strategy_node) {
        $window = $strategy_node->WINDOW;
        $form_type = $window['FORM_TYPE'];
        $config = $window['CONFIG'];
        parse_str($config, $configParts);
        $window_name = $configParts['WN'];
        $odds_maker_config = $window->ODDSMAKER;
        if ($config && $odds_maker_config) {
            $strategy_layouts[$window_name] = fix_oddsmaker_config_values($odds_maker_config);
        }
    }
    #$strategy_xml = simplexml_load_file("http://will.trade-ideas.com/autooptimize/strategies.xml");
    $strategy_url = "$url_base/strategies.xml";
    if ($date != "") {
        $strategy_url = "$url_base/strategies.$date.xml";
    }
    echo "Using strategy url: $strategy_url\n";
    $strategy_xml = get_xml_from_url($strategy_url);
    foreach ($strategy_xml as $strategy_node) {
        $config = $strategy_node['CONFIG'];
        $config = strtr($config, array("http://www.trade-ideas.com/View.php?" => ""));
        parse_str($config, $configParts);
        $window_name = $configParts['WN'];
        if ($strategy_layouts[$window_name]) {
            $strategy = array();
            $strategy['config'] = $config;
            $strategy['window_name'] = $window_name;
            $strategy['oddsmaker'] = $strategy_layouts[$window_name];
            $strategy['id'] = $strategy_id;
            foreach ($variables as $variable) {
                $strategy[$variable] = (string)$strategy_node[$variable];
            }
            array_push($to_return, $strategy);
            $strategy_id++;
        }
    }
    #print_r($to_return);
    return $to_return;
}

# boolean values get imported as "True" or "False" which PHP interprets as true.  This fixes it.
function fix_oddsmaker_config_values($oddsmaker) {
    $booleanValues = array(
        "LONG",
        "RDO_EXIT_AT_THE_CLOSE",
        "RDO_EXIT_TIME_FUTURE_CLOSE",
        "RDO_EXIT_TIME_AT_THE_OPEN",
        "RDO_BY_AT_LEAST_DOLLAR",
        "RDO_BY_AT_LEAST_PERCENT",
        "RDO_EXIT_COND_NONE",
        "RDO_EXIT_COND_PERCENT",
        "RDO_EXIT_COND_BARS",
        "RDO_EXIT_TIME_MINUTES_AFTER",
        "RDO_EXIT_COND_ANOTHER_ALERT",
        "CHK_PROFIT_TARGET",
        "CHK_STOP_LOSS",
        "CHK_WIGGLE",
        "IS_NEW",
    );
    $numberValues = array(
        "DAYS_OF_TEST",
        "DAYS_TO_SKIP",
        "EXIT_TIME_CLOSE_DAYS",
        "EXIT_TIME_OPEN_DAYS",
        "EXIT_TIME_MINUTES_BEFORE",
        "EXIT_TIME_MINUTES_AFTER",
        "TXT_ENTRY_HOURS_START",
        "TXT_ENTRY_MINUTES_START",
        "TXT_ENTRY_HOURS_END",
        "TXT_ENTRY_MINUTES_END",
        "TXT_EXIT_COND_PERCENT",
        "TXT_EXIT_COND_BARS",
        "TXT_PROFIT_TARGET",
        "TXT_STOP_LOSS",
        "TXT_BY_AT_LEAST_DOLLARS",
        "TXT_BY_AT_LEAST_PERCENT",
        "EXIT_CONDITION",
        "CBO_LOCATION",
    );
    $to_return = array();
    foreach ($booleanValues as $booleanValue) {
        $to_return[$booleanValue] = $oddsmaker[$booleanValue] == "True";
    }
    foreach ($numberValues as $numberValue) {
        $to_return[$numberValue] = (string)$oddsmaker[$numberValue];
    }

    return $to_return;
}

function get_cloud_link($full_link) {
    $parts = explode("=", $full_link);
    return $parts[1];
}

function get_settings($full_settings) {
    $settings = str_replace("http://www.trade-ideas.com/View.php?", "", $full_settings);
    return $settings;
}

function get_trading_date($optimized) {
    global $use_trading_date_today;
    if ($use_trading_date_today) {
        return date("Y-m-d");
    }
    $optimize_date = strtotime($optimized);
    $optimize_ymd = date("Y-m-d", $optimize_date);
    $dow = date("w", $optimize_date);
    $days_to_add = 1;
    if ($dow == 5) {
        $days_to_add = 3;
    } else if ($dow == 6) {
        $days_to_add = 2;
    }
    $trading_date = date("Y-m-d", strtotime($optimize_ymd . " + $days_to_add days"));
    echo "Returning $trading_date\n";
    return $trading_date;
}
?>