Tag: Allenamento

Training anno “.$year_display .”

\n”);
if ($option == 0 ){
printf(“Statistiche settimanali – ”
.”Statistiche mensili\n”);
}
elseif ($option == 2){
printf(“Elenco sessioni – ”
.”Statistiche mensili\n”);
}
elseif ($option == 1){
printf(“Elenco sessioni – ”
.”Statistiche settimanali\n”);
}
elseif ($option == 3){
printf(“Elenco sessioni – ”
.”Statistiche mensili – ”
.”Statistiche settimanali\n”);
}
printf(“

”
,$prev,($year_display-1));
printf(“

”
,$next,($year_display+1));

$db= mysqli_connect($db_host, $db_user, $db_password, $db_name);

if (!$db) {
echo “Error: Unable to connect to MySQL.” . PHP_EOL;
echo “Debugging errno: ” . mysqli_connect_errno() . PHP_EOL;
echo “Debugging error: ” . mysqli_connect_error() . PHP_EOL;
exit;
}

mysqli_select_db($db, $db_name) or die(‘Errore db’);

//—————————————————————————————————
// ELENCO DELLE ATTIVITA’
//—————————————————————————————————
if ($option == 0)
{
$query = “SELECT
S.id as session_id
, S.session_date
, S.training_path_id
, S.training_type_id
, S.session_length
, S.session_time
, S.note as session_note
, S.is_race
, P.tracking_system_id
, P.ext_tracking_id
, P.path_name
, P.path_length
, P.note as path_note
, T.description
FROM TRAINING_SESSIONS S LEFT JOIN TRAINING_PATHS P on S.training_path_id=P.id
LEFT JOIN TRAINING_TYPES T on S.training_type_id=T.id
WHERE YEAR(S.session_date) = “.$year_display.”
ORDER BY S.session_date desc”;

printf(“

“);
printf(“

“);
printf(“

“);
printf(“

“);
printf(“

“);
printf(“

\n”);
// printf(“

\n”);

$result = mysqli_query( $db, $query);
while ($row = mysqli_fetch_array($result))
{
$session_id = $row[‘session_id’];
$session_date = $row[‘session_date’];
$training_path_id = $row[‘training_path_id’];
$training_type_id = $row[‘training_type_id’];
$session_length = ( $row[‘session_length’] == NULL ) ? NULL :$row[‘session_length’];
$session_time = $row[‘session_time’];
$session_note = $row[‘session_note’];
$tracking_system_id = $row[‘tracking_system_id’];
$ext_tracking_id = $row[‘ext_tracking_id’];
$path_name = ( $row[‘path_name’] == NULL ) ?
(($session_note == “”) ? “Percorso senza nome”:$session_note)
:$row[‘path_name’];
$path_length = ( $row[‘path_length’] == NULL ) ? NULL : $row[‘path_length’] ;
$path_note = $row[‘path_note’];
$description = $row[‘description’];
$converted_time = NULL;
if ($session_time != NULL){
$session_time_h=(int)($session_time/60/60);
$session_time_m=(int)($session_time/60)-$session_time_h*60;
$session_time_s=$session_time-$session_time_h*60*60-$session_time_m*60;
$converted_time = sprintf(“%02d.%02d.%02d”,$session_time_h,$session_time_m,$session_time_s);
}
$length = ($session_length == NULL) ? $path_length : $session_length;
$converted_length = ( $length == NULL ) ? NULL :number_format($length,2,”,”,”.”);
$average = NULL;
if ($session_time != NULL && $length != NULL) {
$time_second=$session_time/$length;
$average_mm=(int)($time_second/60);
$average_ss=(int)($time_second-$average_mm*60);
$average_ms=(int)(($time_second-(int)($time_second))*100);
$average = sprintf(“%01d.%02d,%d”,$average_mm,$average_ss,$average_ms);
}

$name_link = ““.$path_name.”“;

$note = ($session_note == NULL) ? $path_note : $session_note;
printf(“

“,$session_date);
printf(“

“,$name_link );
printf(“

“,$converted_length);
printf(“

“,$converted_time );
printf(“

“,$average );
printf(“

\n”,$description );
// printf(“

\n”,$note );
}
printf(“

\n”);
}
//—————————————————————————————————
// STATISTICHE MENSILI
//—————————————————————————————————
if ($option == 1)
{
$query = “SELECT count(*) num_sessions
, ifnull(sum(ifnull(S.session_length,P.path_length)),0) len_sessions
, ifnull(sum(S.session_time),0) time_sessions
, NULL week
, month(S.session_date) month
FROM TRAINING_SESSIONS S LEFT JOIN TRAINING_PATHS P on S.training_path_id=P.id
LEFT JOIN TRAINING_TYPES T on S.training_type_id=T.id
where YEAR(S.session_date) = “.$year_display.”
group by month(S.session_date) order by 4,5 “;

printf(“

“);
printf(“

“);
printf(“

“);
printf(“

\n”);

$result = mysqli_query( $db, $query);
$count = 1;
while ($row = mysqli_fetch_array($result))
{
$num_sessions = $row[‘num_sessions’];
$len_sessions = $row[‘len_sessions’];
$time_sessions = $row[‘time_sessions’];
$week = $row[‘week’];
$month = $row[‘month’];
$limit = $month;
while ($count<$limit) { printf("

“,$count);
printf(“

“);
printf(“

“);
printf(“

\n”);
$count++;
}

$count++;
$converted_time = NULL;
if ($time_sessions != NULL){
$time_sessions_h=(int)($time_sessions/60/60);
$time_sessions_m=(int)($time_sessions/60)-$time_sessions_h*60;
$time_sessions_s=$time_sessions-$time_sessions_h*60*60-$time_sessions_m*60;
$converted_time = sprintf(“%02d.%02d.%02d”,$time_sessions_h,$time_sessions_m,$time_sessions_s);
}

$converted_length = ( $len_sessions == NULL ) ? NULL :number_format($len_sessions,2,”,”,”.”);
printf(“

“,$month);
printf(“

“,$num_sessions);
printf(“

“,$converted_length);
printf(“

\n”,$converted_time);
}

while ($count<=12) { printf("

“,$count);
printf(“

“);
printf(“

“);
printf(“

\n”);
$count++;
}
printf(“

\n”);

}

//—————————————————————————————————
// STATISTICHE SETTIMANALI
//—————————————————————————————————
if ($option == 2)
{
$query = “SELECT count(*) num_sessions
, ifnull(sum(ifnull(S.session_length,P.path_length)),0) len_sessions
, ifnull(sum(S.session_time),0) time_sessions
, week(S.session_date) week
, NULL month
FROM TRAINING_SESSIONS S LEFT JOIN TRAINING_PATHS P on S.training_path_id=P.id
LEFT JOIN TRAINING_TYPES T on S.training_type_id=T.id
where YEAR(S.session_date) = “.$year_display.”
group by week(S.session_date) order by 4,5 “;

printf(“

“);
printf(“

“);
printf(“

“);
printf(“

\n”);

$result = mysqli_query( $db, $query);
$count = 1;
while ($row = mysqli_fetch_array($result))
{
$num_sessions = $row[‘num_sessions’];
$len_sessions = $row[‘len_sessions’];
$time_sessions = $row[‘time_sessions’];
$week = $row[‘week’];
$month = $row[‘month’];
$limit = $month;
while ($count<$limit) { printf("

“,$count);
printf(“

“);
printf(“

“);
printf(“

\n”);
$count++;
}

$count++;
$converted_time = NULL;
if ($time_sessions != NULL){
$time_sessions_h=(int)($time_sessions/60/60);
$time_sessions_m=(int)($time_sessions/60)-$time_sessions_h*60;
$time_sessions_s=$time_sessions-$time_sessions_h*60*60-$time_sessions_m*60;
$converted_time = sprintf(“%02d.%02d.%02d”,$time_sessions_h,$time_sessions_m,$time_sessions_s);
}

$converted_length = ( $len_sessions == NULL ) ? NULL :number_format($len_sessions,2,”,”,”.”);
printf(“

“,$week);
printf(“

“,$num_sessions);
printf(“

“,$converted_length);
printf(“

\n”,$converted_time);
}

printf(“

\n”);
}

//—————————————————————————————————
// SINGOLA SESSIONE
//—————————————————————————————————
if ($option==3)
{
$query = “SELECT
S.id as session_id
, S.session_date
, S.training_path_id
, S.training_type_id
, S.session_length
, S.session_time
, S.note as session_note
, S.is_race
, S.tracking_system_id as session_tracking_system_id
, S.ext_tracking_id as session_ext_tracking_id
, P.tracking_system_id as path_tracking_system_id
, P.ext_tracking_id as path_ext_tracking_id
, P.path_name
, P.path_length
, P.note as path_note
, T.description
, Y.description as track_desciption
, Y.homepage as track_homepage
, Y.link_roule as track_roule
, Y.include_roule as track_include
, Z.description as path_track_desciption
, Z.homepage as path_track_homepage
, Z.link_roule as path_track_roule
, Z.include_roule as path_track_include
FROM TRAINING_SESSIONS S
LEFT JOIN TRAINING_PATHS P on S.training_path_id=P.id
LEFT JOIN TRAINING_TYPES T on S.training_type_id=T.id
LEFT JOIN TRACKING_SYSTEMS Y on Y.id = S.tracking_system_id
LEFT JOIN TRACKING_SYSTEMS Z on Z.id = P.tracking_system_id
WHERE YEAR(S.session_date) = “.$year_display.”
AND S.id = “.$session_id.”
ORDER BY S.session_date desc”;

printf(“

“);
printf(“

“);
printf(“

“);
printf(“

“);
printf(“

“);
printf(“

\n”);

$result = mysqli_query( $db, $query);
while ($row = mysqli_fetch_array($result))
{
$session_id = $row[‘session_id’];
$session_date = $row[‘session_date’];
$training_path_id = $row[‘training_path_id’];
$training_type_id = $row[‘training_type_id’];
$session_length = ( $row[‘session_length’] == NULL ) ? NULL :$row[‘session_length’];
$session_tracking_system_id = $row[‘session_tracking_system_id’];
$session_ext_tracking_id = $row[‘session_ext_tracking_id’];
$session_time = $row[‘session_time’];
$session_note = $row[‘session_note’];
$path_tracking_system_id = $row[‘path_tracking_system_id’];
$path_ext_tracking_id = $row[‘path_ext_tracking_id’];
$path_name = ( $row[‘path_name’] == NULL ) ?
(($session_note == “”) ? “Percorso senza nome”:$session_note)
:$row[‘path_name’];
$path_length = ( $row[‘path_length’] == NULL ) ? NULL : $row[‘path_length’] ;
$path_note = $row[‘path_note’];
$description = $row[‘description’];
$track_desciption = $row[‘track_desciption’];
$track_homepage = $row[‘track_homepage’];
$track_roule = $row[‘track_roule’];
$track_include = $row[‘track_include’];

$path_track_desciption = $row[‘path_track_desciption’];
$path_track_homepage = $row[‘path_track_homepage’];
$path_track_roule = $row[‘path_track_roule’];
$path_track_include = $row[‘path_track_include’];

$converted_time = NULL;
if ($session_time != NULL){
$session_time_h=(int)($session_time/60/60);
$session_time_m=(int)($session_time/60)-$session_time_h*60;
$session_time_s=$session_time-$session_time_h*60*60-$session_time_m*60;
$converted_time = sprintf(“%02d.%02d.%02d”,$session_time_h,$session_time_m,$session_time_s);
}
$length = ($session_length == NULL) ? $path_length : $session_length;
$converted_length = ( $length == NULL ) ? NULL :number_format($length,2,”,”,”.”);
$average = NULL;
if ($session_time != NULL && $length != NULL) {
$time_second=$session_time/$length;
$average_mm=(int)($time_second/60);
$average_ss=(int)($time_second-$average_mm*60);
$average_ms=(int)(($time_second-(int)($time_second))*100);
$average = sprintf(“%01d.%02d,%d”,$average_mm,$average_ss,$average_ms);
}

$name_link = ““.$path_name.”“;
$note = ($session_note == NULL) ? $path_note : $session_note;
printf(“

“,$session_date);
printf(“

“,$name_link );
printf(“

“,$converted_length);
printf(“

“,$converted_time );
printf(“

“,$average );
printf(“

\n”,$description );
printf(“

\n”,$note );
}
printf(“

\n”);

if (isset($track_roule) && isset($session_ext_tracking_id))
{
$path_link = str_replace(‘[]’,$session_ext_tracking_id,$track_roule);
printf(“Vai alla mappa\n”,$path_link);
}
elseif (isset($path_track_roule) && isset($path_ext_tracking_id))
{
$path_link = str_replace(‘[]’,$path_ext_tracking_id,$path_track_roule);
printf(“Vai alla mappa\n”,$path_link);
}
if (isset($track_include) && isset($session_ext_tracking_id))
{
$path_include=str_replace(‘[]’,$session_ext_tracking_id,$track_include);
printf(“%s\n”,$path_include );
}
elseif (isset($path_track_include) && isset($path_ext_tracking_id))
{
$path_include=str_replace(‘[]’,$path_ext_tracking_id,$path_track_include);
printf(“

\n”,$path_include );
}
}

?>