File "elo_double_compare02.php"
Full Path: /home/analogde/www/Freebox/CHESS_ON/elo_double_compare02.php
File size: 11.32 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('database.php');
DB_connexion();
header('Content-Type: text/html; charset=utf-8');
header("Refresh: 5;URL=ddd.php");
//$strJsonFileContents = file_get_contents("elo_combine.json");
?>
<script src="Charts_2022/js/fusioncharts.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<div id="chart-container">FusionCharts will render here</div>
<!--
https://www.fundaofwebit.com/jquery/reload-a-div-without-reloading-the-entire-page
How To Refresh Page Without Reloading In Php
https://stackoverflow.com/questions/22577457/update-data-on-a-page-without-refreshing
-->
<script>
/*$(document).ready(function () {
setInterval( function() {
alert("bingo");
$("#chart-container").load(location.href + " #chart-container");
}, 1000 );
});
*/
//function jsfunction()
//{
// window.location = window.location
function showMessage()
{
alert("click here");
location = location.href;
//setInterval('refreshMyPage()', 5000);
}
function refreshMyPage()
{
// setting the location to current file location
alert("zoulou...");
location = location.href;
}
var schema = [{
"name": "Time",
"type": "date",
//format: "%Y/%m/%d"
format: "%d-%b-%Y"
}, {
"name": "ELO",
"type": "number"
}];
for (i = 0; i < data.length; i++)
document.writeln((i+1) + ": " + data[i]);
var plouf = <?php echo $strJsonFileContents; ?>;
var fusionTable = new FusionCharts.DataStore().createDataTable(plouf, schema); // data
chart = new FusionCharts({
type: 'timeseries',
renderAt: 'chart-container',
width: "90%",
height: 600,
dataSource: {
data: fusionTable,
chart: {
yAxisName: 'Quarter',
exportEnabled: 0,
},
/*navigator: {
enabled: 0
},*/
caption: {
text: "Evolution de votre score ELO"
},
yAxis: [{
plot: [{
value: 'ELO',
connectNullData: true,
type: 'line',
}],
"min": "1000",
"max": "2000",
format: {
defaultFormat: 0,
},
//"min": "130",
// "max": "9800",
}],
xAxis: {
binning: {
year: [],
month: [],
day: [1],
hour: [],
minute: [],
second: [],
millisecond: []
}
}
}
}).render();
//}
</script>
<!--
<div id="chart-container">FusionCharts will render here</div>
-->
<?php
echo " Extraction des parties et élaboration du graphique....";
echo "<br><br>";
$playerID = "12";
$J1_data = extract_data($playerID);
//echo "<pre>";
//print_r($J1_data);
//echo "</pre>";
$playerID = "9";
$J2_data = extract_data($playerID);
//echo "<pre>";
//print_r($J2_data);
//echo "</pre>";
/**/
$J1_nb_parties = count($J1_data);
echo "NB " .$J1_nb_parties;
echo "<br><br>";
$J1_start_timestamp = $J1_data[0]["aaa"];
$J1_start_date = $J1_data[0]["bbb"];
echo "Start " .$J1_start_timestamp ." " .$J1_start_date;
echo "<br><br>";
$J1_stop_timestamp = $J1_data[$J1_nb_parties-1]["aaa"];
$J1_stop_date = $J1_data[$J1_nb_parties-1]["bbb"];
echo "Stop " .$J1_stop_timestamp ." " .$J1_stop_date;
echo "<br><br>";
/**/
$J2_nb_parties = count($J2_data);
echo "NB " .$J2_nb_parties;
echo "<br><br>";
$J2_start_timestamp = $J2_data[0]["aaa"];
$J2_start_date = $J2_data[0]["bbb"];
echo "Start " .$J2_start_timestamp ." " .$J2_start_date;
echo "<br><br>";
$J2_stop_timestamp = $J2_data[$J2_nb_parties-1]["aaa"];
$J2_stop_date = $J2_data[$J2_nb_parties-1]["bbb"];
echo "Stop " .$J2_stop_timestamp ." " .$J2_stop_date;
echo "<br><br>";
if( $J1_start_timestamp < $J2_start_timestamp)
{
$date_start = $J1_start_date;
}
else
{
$date_start = $J2_start_date;
}
if( $J1_stop_timestamp < $J2_stop_timestamp)
{
$date_stop = $J2_stop_date;
}
else
{
$date_stop = $J1_stop_date;
}
echo " +++ " .$date_start ." " .$date_stop;
$tab_timestamp = interval( date_formatted($date_start), date_formatted($date_stop));
//echo "<pre>";
//print_r($tab_timestamp);
//echo "</pre>";
$J1_elo_data = array();
for ($i = 0; $i < count($tab_timestamp)-1; $i++)
{
$timestamp = strtotime($tab_timestamp[$i]);
$tmp =array( $timestamp, "J1", "val");
$J1_elo_data[] = $tmp;
}
//echo " J1 data";
//echo "<br><br>";
//echo "<pre>";
//print_r($J1_elo_data);
//echo "</pre>";
//echo "<br><br>";
for ($i = 0; $i < count($tab_timestamp)-1; $i++)
{
$timestamp = strtotime($tab_timestamp[$i]);
$tmp =array( $timestamp, "J2", "val");
$J2_elo_data[] = $tmp;
}
//echo " J2 data";
//echo "<br><br>";
//echo "<pre>";
//print_r($J2_elo_data);
//echo "</pre>";
//echo "<br><br>";
$cpt = 1;
for ($i = 0; $i < count($J1_elo_data); $i++)
{
$find_timestamp = $J1_elo_data[$i][0];
$find = 0;
for ($j = 0; $j < count($J1_data); $j++)
{
$key = "aaa";
if( $J1_data[$j][$key] == $find_timestamp)
{
//echo " +++++ " .$cpt . " " .$find_timestamp . " " .$J1_data[$j]["ccc"];
//echo "<br>";
$cpt++;
$find = 1;
$J1_elo_data[$i][2] = $J1_data[$j]["ccc"];
break;
}
}
if( $find == 0)
{
if($i == 0)
{
$J1_elo_data[$i][2] = "1400";
}
else
{
$J1_elo_data[$i][2] = $J1_elo_data[$i-1][2];
}
}
}
//echo "------ J1 ---------";
//echo "<br><br>";
//echo "<pre>";
//print_r($J1_elo_data);
//echo "</pre>";
/****/
$cpt = 1;
for ($i = 0; $i < count($J2_elo_data); $i++)
{
$find_timestamp = $J2_elo_data[$i][0];
$find = 0;
for ($j = 0; $j < count($J2_data); $j++)
{
$key = "aaa";
if( $J2_data[$j][$key] == $find_timestamp)
{
//echo " +++++ " .$cpt . " " .$find_timestamp . " " .$J2_data[$j]["ccc"];
//echo "<br>";
$cpt++;
$find = 1;
$J2_elo_data[$i][2] = $J2_data[$j]["ccc"];
break;
}
}
if( $find == 0)
{
if($i == 0)
{
$J2_elo_data[$i][2] = "1400";
}
else
{
$J2_elo_data[$i][2] = $J2_elo_data[$i-1][2];
}
}
}
//echo "------ J2 ---------";
//echo "<br><br>";
//echo "<pre>";
//print_r($J2_elo_data);
// echo "</pre>";
///
for ($i = 0; $i < count($J1_elo_data); $i++)
{
$transformation = date('d-M-Y', $J1_elo_data[$i][0]);
$J1_elo_data[$i][0] = $transformation;
$J2_elo_data[$i][0] = $transformation;
}
$elo_combine = array();
for ($i = 0; $i < count($J1_elo_data); $i++)
{
$elo_combine[] = $J1_elo_data[$i];
$elo_combine[] = $J2_elo_data[$i];
}
$json = json_encode($elo_combine);
file_put_contents("elo_combine.json", $json);
echo "Fin ...";
echo '<script>', 'showMessage();', '</script>';
// echo '<script type="text/javascript">jsfunction();</script>';
//echo $strJsonFileContents;
//echo " +++++++ ";
/*echo '<script type="text/javascript">',
'jsfunction();',
'</script>';*/
//echo '<a href="ddd.php"><input type="submit"/> </a>';
// echo '<a href="ddd.php">Index Page</a>';
///
function extract_data($playerID)
{
$sql = "SELECT * FROM parties_new WHERE w_playerID = '$playerID' OR b_playerID = '$playerID' ORDER by date asc ";
//echo $sql;
//echo "<br><br>";
$graph_data = array();
$result = mysql_query($sql);
$retid = mysql_query($sql);
$id = 1;
while ($row = mysql_fetch_array($retid))
{
$white = $row["w_playerID"];
$w_name=$row["w_name"];
$black = $row["b_playerID"];
$b_name=$row["b_name"];
$w_rating = $row["w_arating"];
$b_rating = $row["b_arating"];
$w_brating = $row["w_brating"];
$b_brating = $row["b_brating"];
$result=$row["result"];
//$date =$row["date"];
//$date=date("d F Y",$date);
//$date_convert = strftime('%d-%m-%Y',strtotime($date));
$timestamp = $row["date"];
$date= date("d F Y",$timestamp);
$date_convert = strftime('%d-%h-%Y',strtotime($date));
$diff_w = $w_rating - $w_brating;
$diff_b = $b_rating - $b_brating;
if($white==$playerID)
{
if ($result==1)
{
//$pipo =array( $timestamp, $date_convert , $w_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$w_rating);
}
if($result==2)
{
//$pipo =array($timestamp, $date_convert , $w_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$w_rating);
}
if ($result==3)
{
//$pipo =array( $timestamp, $date_convert , $w_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$w_rating);
}
}
if ($black==$playerID)
{
if($result==1)
{
//$pipo =array( $timestamp, $date_convert , $b_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$b_rating);
}
if ($result==2)
{
//$pipo =array( $timestamp, $date_convert , $b_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$b_rating);
}
if ($result==3)
{
//$pipo =array( $timestamp, $date_convert , $b_rating);
$pipo = array("aaa"=>$timestamp,"bbb"=>$date_convert,"ccc"=>$b_rating);
}
}
$graph_data[] = $pipo;
$id = $id + 1;
}
return $graph_data;
}
function interval($date1, $date2)
{
//$date1 = '01-10-2010';
//$date2 = '05-10-2010';
// Declare an empty array
$array = array();
// Use strtotime function
$variable1 = strtotime($date1);
$variable2 = strtotime($date2);
// Use for loop to store dates into array
// 86400 sec = 24 hrs = 60*60*24 = 1 day
for ($currentDate = $variable1; $currentDate <= $variable2; $currentDate += (86400))
{
$store = date('Y-m-d', $currentDate);
$array[] = $store;
}
return $array;
}
function date_formatted($date)
{
$pieces = explode("-", $date);
switch ($pieces[1])
{
case 'Jan':
$detected_month = "01";
break;
case 'Feb':
$detected_month = "02";
break;
case 'Mar':
$detected_month = "03";
break;
case 'Apr':
$detected_month = "04";
break;
case 'May':
$detected_month = "05";
break;
case 'Jun':
$detected_month = "06";
break;
case 'Jul':
$detected_month = "07";
break;
case 'Aug':
$detected_month = "08";
break;
case 'Sep':
$detected_month = "09";
break;
case 'Oct':
$detected_month = "10";
break;
case 'Nov':
$detected_month = "11";
break;
case 'Dec':
$detected_month = "12";
break;
}
$date_str = $pieces[2] ."-" .$detected_month ."-" .$pieces[0];
return $date_str;
}
?>