|
Training Template
|
|
Click here to hide your training template |
|
|
|
Day:
Type:
|
Distance: |
|
|
Time: Hrs.
min:
|
Comments:
|
|
|
");
if ( $hasScheduledWorkouts )
{
echo("
Click here to add a workout (from the above fields) to your workout template (shown below).
|
|
|
");
}
else
{
echo("
Click here to add a workout (from the above fields) to your workout template (shown below).
|
|
");
}
}
class CTrainingProgram
{
var $usUserName;
var $tpName = "";
var $tpGoal;
var $tpGoalDate;
var $tpTimeGoalHours;
var $tpTimeGoalMinutes;
var $template = FALSE;
function CTrainingProgram( $usUserName )
{
global $conn;
// Load all training program info.
$sql = "
SELECT
tpName, tpGoal, tpGoalDate, tpTimeGoal
FROM
trainingprogram
WHERE
usUserName = '$usUserName'
";
// if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
if ( list( $this->tpName, $this->tpGoal, $this->tpGoalDate, $tpTimeGoal ) = mysql_fetch_row( $result ) )
{
$this->tpTimeGoalHours = (int)floor( $tpTimeGoal/60 );
$this->tpTimeGoalMinutes .= $tpTimeGoal%60;
}
} // CTrainingProgram()
}
function CheckForScheduledWorkouts()
{
global $conn, $usUserName;
$sql = "
SELECT woId
FROM scheduledworkouts
WHERE usUserName = '$usUserName'
";
//echo("sql - $sql
");
// if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
if ( mysql_num_rows($result) > 0 )
return TRUE;
else
return FALSE;
}
function ShowScheduledWorkouts($tpName, $tpGoalDate)
{
echo("
| Week Start Date |
Total Workouts |
Total Time |
Total Distance |
|
|
");
$weekList = GetWeekList( $tpName, $tpGoalDate );
if ( is_array( $weekList ) )
{
while ( list( $firstDayOfWeek, $weekInfo ) = each( $weekList ) )
{
echo("
| $firstDayOfWeek |
$weekInfo[woCount] |
$weekInfo[woTime] |
$weekInfo[woDistance] |
Edit Week |
Delete Week |
");
}
}
echo("
|
");
}
function FetchTemplateWorkouts( &$template, &$count )
{
global $conn, $usUserName;
$sql = "
SELECT twoId, twoDay, twoTime, twoDistance, twoType, twoComments
FROM templateworkouts
WHERE usUserName = '$usUserName'
ORDER BY twoType, twoDay
";
//echo("sql - $sql
");
// if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
$count = 0;
$totalTime = 0;
$hasTemplate = FALSE;
while( list( $twoId, $twoDay, $twoTime, $twoDistance, $twoType, $twoComments ) = mysql_fetch_row($result) )
{
$hasTemplate = TRUE;
//"date, time, type - $twoDay, $twoTime, $twoType, $twoDistance
");
$template[$twoType][$twoDay][twoTime] = $twoTime;
$template[$twoType][$twoDay][twoDist] = $twoDistance;
$template[$twoType][twoTotalTime] += $twoTime;
$template[$twoType][twoTotalDist] += $twoDistance;
$template[$twoType][$twoDay][twoComments] = $twoComments;
$template[$twoType][$twoDay][twoId] = $twoId;
$count++;
$totalTime += $twoTime;
}
}
function ShowTemplateWorkOutWeek( $template, $count )
{
echo("
| Type |
Sun. |
Mon. |
Tues. |
Wed. |
Thur. |
Fri. |
Sat. |
Totals |
");
if ( $count > 0 )
{
while (list( $twoType, $twoDayInfo ) = each( $template ) )
{
echo("| $twoType | ");
for ( $i = 1; $i < 8; $i++ )
{
$twoTime = $twoDayInfo[$i][twoTime];
$twoDistance = $twoDayInfo[$i][twoDist];
$twoId = $twoDayInfo[$i][twoId];
if ( $twoId > 0 )
echo("Time: $twoTime Min.
Dist.: $twoDistance
edit | ");
else
echo(" | ");
}
$twoTotalTime = $twoDayInfo[twoTotalTime];
$totalTime += $twoTotalTime;
$twoTotalDist = $twoDayInfo[twoTotalDist];
echo("Time:$twoTotalTime
Dist.:$twoTotalDist | ");
}
}
$timeStr = GetTimeString( $totalTime );
if ( $count == "" ) $count = 0;
echo("
| |
Total Number |
$count |
Total Time |
$timeStr |
");
echo("
");
} // ShowTemplateWorkOutWeek()
?>
