<?php
include(__DIR__ . "/../../init.php");


$vm_id = array('084_KZ_KISLOV', '099_IK_SAIDZHONOV');
$date_from = '2018-08-01';

$MASTER_BK = "pinnacle";
$SLAVE_BK = "fonbet";


echo __("[#] VM_IDS: %s\n", implode(", ", $vm_id));

echo __("[+] Loading bets from `forks_stakes` ... "); $t0 = microtime(true);
$fs = DB()->fetchAll("

    SELECT bet_result, fork_id, bk_name, event_name, bet_type, bet_name, cf, fork_income, game_score, added_at, UNIX_TIMESTAMP(added_at) as added_at_uts, margin1, margin2, limits_indicator, in_event_count
    FROM forks_stakes
    WHERE vm_id IN ('%s') AND DATE(added_at) >= '%s' AND bet_result IN (1,-1) AND 25 > margin1 > 0 AND 25 > margin2 > 0
      AND bet_type NOT IN ('WIN', 'HALF_WIN', 'TOTALS_CORNERS', 'HALF_TOTALS_CORNERS', 'HANDICAP_CORNERS', 'HALF_HANDICAP_CORNERS', 'WIN_CORNERS')
      #AND bet_result = -1
     GROUP BY event_name, bet_name
     ORDER BY added_at
", implode("','", $vm_id), $date_from);
#$CFS1 = parseCfsRows($r1);
echo __("%s row(s) [%.2fs]\n", number_format(count($fs)), microtime(true)-$t0);
#print_r($fs); exit;

$fork_ids = array();
foreach($fs as $r){
    $fork_ids[] = $r['fork_id'];
}

#$fork_ids = array(11663533);


echo __("[+] Loading data from `forks/forks_01` ... "); $t0 = microtime(true);
$forks = DB()->fetchAll("
    SELECT
      id, bet_type, added_at, UNIX_TIMESTAMP(added_at) as added_at_uts,
      #income, IF(BK1_name='$SLAVE_BK', BK1_coef, BK2_coef) as slave_cf,
      IF(BK1_name='$MASTER_BK', BK1_game, BK2_game) as master_event_name,
      IF(BK1_name='$SLAVE_BK', BK1_game, BK2_game) as slave_event_name,
      IF(BK1_name='$MASTER_BK', BK1_league, BK2_league) as master_league_name,
      IF(BK1_name='$SLAVE_BK', BK1_league, BK2_league) as slave_league_name,
      IF(BK1_name='$MASTER_BK', BK1_is_initiator, BK2_is_initiator) as master_is_initiator,
      IF(BK1_name='$SLAVE_BK', BK1_is_initiator, BK2_is_initiator) as slave_is_initiator,
      IF(BK1_name='$MASTER_BK', BK1_forks_count, BK2_forks_count) as master_forks_count,
      IF(BK1_name='$SLAVE_BK', BK1_forks_count, BK2_forks_count) as slave_forks_count
    FROM (
        SELECT * FROM forks_01 WHERE id IN (%s)
          UNION
        SELECT * FROM forks WHERE id IN (%s)
    ) as t
   WHERE '%s' IN (BK1_name, BK2_name) and '%s' IN (BK1_name, BK2_name)
   ORDER BY added_at

", implode(",", $fork_ids), implode(",", $fork_ids), $MASTER_BK, $SLAVE_BK);
echo __("%s row(s) [%.2fs]\n", number_format(count($forks)), microtime(true)-$t0);

$_forks=array();
foreach($forks as $r){
    $_forks[$r['id']] = $r;
}
#print_r($forks); exit;


echo __("[+] Cleaning data from ... ");
$_bets = array();
foreach($fs as $_b){
    if(!isset($_forks[$_b['fork_id']]) or !($_f=$_forks[$_b['fork_id']])){
        continue;
    }
    if($_b['event_name'] != $_f['slave_event_name']){
        continue;
    }
    $_bets[] = $_b;
}
echo __("%s row(s)\n\n", number_format(count($_bets)));
#print_r($_bets); exit;


#shuffle($_bets);


$out_keys = array();
foreach($_bets as $_b){
    $_f=$_forks[$_b['fork_id']];

    $_o = prepareStepOne($_b, $_f);
    if(count($out_keys) == 0){
        $out_keys = array_keys($_o);
        #echo implode(",", $out_keys) . "\n";
    }
    $_v = array();
    foreach($out_keys as $_k){
        $_v[] = $_o[$_k];
    }
    echo implode(",", $_v) . "\n";
}

function prepareStepOne($_b, $_f){


    $BET_TYPES = array('HANDICAP', 'TOTALS', 'TEAM_TOTALS', 'TEAM_GOALS', 'HALF_TOTALS', 'HALF_HANDICAP', 'WIN', "HALF_WIN");
    $BET_TYPES2 = array('HANDICAP'=>1, 'TOTALS'=>2, 'TEAM_TOTALS'=>2, 'TEAM_GOALS'=>2, 'HALF_TOTALS'=>2, 'HALF_HANDICAP'=>1, 'WIN'=>3, "HALF_WIN"=>3);
    if(($_bet_type = array_search($_b['bet_type'], $BET_TYPES)) === false or !isset($BET_TYPES2[$_b['bet_type']]) or ($_bet_type2 = $BET_TYPES2[$_b['bet_type']]) === false){
        die(__("ERROR: prepareStepOne(): cant find bet_type '%s'", $_b['bet_type']));
    }



    $_out = array(
        'bet_result' => (intval($_b['bet_result']) == 1 ? 1.0 : 0.0),
        'cf' => $_b['cf'],
        'cf2' => __("%.6f", 1/floatval($_b['cf'])),
        'cf3' => __("%.6f", 1/floatval($_b['cf']) - floatval($_b['margin2'])/2/100),
        'fork_income' => $_b['fork_income'],
        'overw_v3' => floatval($_b['fork_income'])+floatval($_b['margin2'])/2,
        'bet_type' => $_bet_type,
        'bet_type2' => $_bet_type2,
        'bet_type3' => 0,
        'time_wday' => intval(date('w', $_b['added_at_uts'])),
        'time_hour' => intval(date('H', $_b['added_at_uts'])) + intval(date('i', $_b['added_at_uts']))/100,
        'time_intraday' => __("%.6f", (intval(date('H', $_b['added_at_uts']))*60 + intval(date('i', $_b['added_at_uts'])))/(60*24)),
        'margin1' => $_b['margin1'],
        'margin2' => $_b['margin2'],
        'limits_indicator' => $_b['limits_indicator'],
        'in_event_count' => $_b['in_event_count'],
        'added_at_diff' => intval($_b['added_at_uts'])-intval($_f['added_at_uts'])-15,
        'master_is_initiator' => $_f['master_is_initiator'],
        'slave_is_initiator' => $_f['slave_is_initiator'],
        'master_forks_count' => $_f['master_is_initiator'],
        'slave_forks_count' => $_f['slave_forks_count'],
        'score_goals_total' => -1,
        'score_goals_diff' => -1,
        'score_match_min' => -1,
        'score_match_period' => 1,
        #'added_at' => $_b['added_at']
    );
    if(preg_match("!^([0-9]+):([0-9]+)( |$)(\(([0-9]+):([0-9]+)\))?!", $_b['game_score'], $_sc)){
        #print_r($_sc); exit;
        $_out['score_goals_total'] = $_sc[1]+$_sc[2];
        $_out['score_goals_diff'] = abs($_sc[1]-$_sc[2]);
        if(isset($_sc[4]) and $_sc[4] != ''){
            #var_dump($_sc);
            $_out['score_match_period'] = 2;
        }
    }
    if(preg_match("! ([0-9]{1,2}):([0-5][0-9])$!", $_b['game_score'], $_sc)){
        #print_r($_sc); exit;
        $_out['score_match_min'] = $_sc[1]+1;
    }
    #$_out['game_score'] = $_b['game_score'];

    $_BET_TYPES2 = array(
        '__GOALS__YES' => 2,
        '__GOALS__NO' => 1,
        'HANDICAP__P[12]\(\-' => 2,
        'HANDICAP__P[12]\(0' => 3,
        'HANDICAP__P[12]\([0-9]' => 1,
        'TOTALS__UNDER' => 1,
        'TOTALS__OVER' => 2
    );
    foreach($_BET_TYPES2 as $_rg => $_v){
        if(preg_match("!$_rg!", $_b['bet_name'])){
            $_out['bet_type3'] = $_v;
            break;
        }
    }
    #$_out['___'] = $_b['bet_name'];

    #print_r($_b); print_r($_f); print_r($_out); exit;

    return $_out;
}