// Check if this is a split or a parent session

$extra = array( "" , "" , "addlogentry" );

# show_log_table($athlete_id, $split, $extra );

# if ( $split == "no" )

# // Not a split so fire up the session adding form

session_form($parent_session, $athlete_id, $error_message, $start_date );

// The $extra variable was used to allow editing of the row within the table

// but I have changed my mind about this and will now use the pop-up edit window

$extra = array( "EDIT" , "$session_id" );

# show_log_table($athlete_id, "", $extra );

session_edit_form($session_id, $athlete_id, $error_message );

// See if this column is listed in log_field_names

// if it is then get data_type info from here

// otherwise just use the actual data type

$query = "select * from log_field_names where log_column='$colname'";

#$result = pg_query($query) or die('Query failed: ' . pg_last_error());

$result = do_sql($query) ;

if (pg_num_rows($result) > 0 ) {

// the result should only contain 1 row,

// we'll only use the first anyway.

$row = pg_fetch_array($result, null, PGSQL_ASSOC);

}

else{

// fake it

$row['log_col_short_name'] = $colname;

$row['log_col_long_name'] = $colname;

$row['log_col_description'] = $colname;

$query = "SELECT $colname from log limit 1";

#$result = pg_query($query) or die('Query failed: ' . pg_last_error());

$result = do_sql($query) ;

$row['data_type'] = pg_field_type($result,0);

}

return $row ;

// If start_date is not already set then use current date

$current_date=convert_date_from_pg($start_date);

if ( "X$start_date" == "X" )

$current_date= date("j/n/Y") ;

// or if parent session is set (ie this is a split) then use the parent's date

if ( $parent_session > 0 ) {

$result = do_sql("SELECT start_date,exercise_type FROM log WHERE session_id = '$parent_session'");

$row = pg_fetch_array($result, null, PGSQL_ASSOC);

$start_date = $row['start_date'];

$current_date = convert_date_from_pg($start_date) ;

$parent_ex_type = $row['exercise_type'];

}

# Put columns we never want to show in this array:

$do_not_show = array ("athlete_id", "session_id", "parent_session" ) ;

$columns = get_column_names() ;

# Get an array of fields user does want to display

$display_details = array();

$query = "SELECT detail from athlete_log_preferences

where athlete_id=$athlete_id ";

# ORDER BY display_sequence";

$result = do_sql($query) or die('Query failed: ' . pg_last_error());

# pg_fetch_array returns the next whole row as an array at each iteration

while ( $row = pg_fetch_array($result, null, PGSQL_ASSOC) )

{

foreach ( $row as $prev_detail ){

array_push( $display_details, $prev_detail ) ;

}

}

echo "\n<DIV id=mainlogentry name=addlogentry >\n";

echo "$error_message \n";

# Start Form and Table

echo "<a name=log_entry_form></a>";

echo "<FORM action=add_log_entry2.php method=post >";

echo "<input type=hidden name='parent_session' value=$parent_session>";

echo "<H2>\n";

if ( $parent_session > 0 ) {

echo "Splitting log entry for $current_date $parent_ex_type" ;

} else {

echo "Add Log Entry Details";

}

echo "</H2>\n";

echo "\n<TABLE class=mainlogentry ><TR><TD COLSPAN=4 >\n\n";

echo "<TR>\n";

// Display Entry fields

$notes_fields="";

$maxnumcols = 6 ;

$colcount = $maxnumcols ;

#foreach ( $columns as $colname ){

foreach ( $display_details as $colname ){

if ( (! in_array( $colname , $do_not_show ) ) && ( in_array( $colname , $display_details ) ) ) {

if ( $colcount-- == 0 ) { echo "\n</TR>\n" ; $colcount = $maxnumcols-1 ; }

$colinfo = get_column_info($colname);

$input_type = "text" ;

$default_value = "" ;

if ( preg_match("/^var/", $colinfo['data_type']) ) {

// Get the var length

$typearray = explode(" ",$colinfo['data_type'] ) ;

$varlen = $typearray[1];

}

if ( $colinfo['data_type'] == "date" ) {

$default_value=$current_date ;

$datepicker_number=$datepicker_number+1 ;

$input_id="\"cal".$datepicker_number."_container\"" ;

}

if ( preg_match("/^select/", $colinfo['data_type']) ) {

// We have a select list type. There should be a corresponding table

// which lists the select info

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

generate_select_form( $colname, $colinfo['data_type'], "X" );

}

elseif ( preg_match("/^pref/", $colinfo['data_type']) ) {

// We have a prefer select list type. There should be a corresponding table

// which lists the prefered select info

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

generate_prefer_select_form( $colname, $colinfo['data_type'], $value, $athlete_id);

}

// Generate Notes fields and add them beneath the smaller table entries

elseif ( ( $colinfo['data_type'] == "text" ) || ( $varlen >= 30 ) ) {

// Set maximum field size to 80

if ( $varlen <= 80 ) { $size = $varlen; } else { $size = 80 ; }

$notes_fields = "$notes_fields <TR><TD> ".$colinfo['log_col_long_name']."</TD> <TD colspan=20 ><INPUT type=text name =${colname} value='$value' size=$size > </TD></TR>\n";

}

else {

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

echo "<INPUT type=$input_type name=${colname} id=$input_id value='$default_value' size=10>\n";

unset($input_id);

}

echo "</font> </td>" ;

}

}

echo "</TR>\n";

echo "$notes_fields\n";

echo "\n</TABLE>\n\n";

#echo "<input type=submit value='Submit entries' onclick='refreshParent();' >\n";

echo "<input type=hidden name=parent_session value='$parent_session' >\n";

echo "<input type=submit value='Submit entries' >\n";

echo "</FORM>\n</DIV>\n\n";

## END of FUNCTION

// $value is the default selected value.

// the second part of the data_type field should have the name of

// the table which contains the list info

preg_match_all("/\w+/", $data_type , $matches );

$array=$matches[0];

$list_table="select_$array[1]" ;

$query = "SELECT list_data from $list_table " ;

$result = do_sql($query) or die('Query failed: ' . pg_last_error());

$list_data=array();

while ( $row = pg_fetch_array($result, null, PGSQL_ASSOC) ) {

array_push( $list_data , $row['list_data'] ) ;

}

//See if $value is set to something other than X, or nothing.

// if not then set a few common defaults

if ( "$value" == "X" || "Z$value" == "Z" ) {

switch($colname){

case "entry_type": $value="planned - done" ; break ;

case "effort_notes": $value="medium" ; break ;

case "effort_notes": $value="medium" ; break ;

case "session_type": $value="training" ; break ;

}

}

echo " <SELECT NAME='${colname}' >\n" ;

foreach ( $list_data as $list_item ) {

$selected = "" ;

if ( "$list_item" == "$value" ) { $selected = "SELECTED" ; }

echo "<OPTION VALUE='$list_item' $selected > $list_item </OPTION>\n";

}

echo "</SELECT>\n";

## END of FUNCTION

// This is used for generating a select list according to preferences

// selected by the user, when the log_field_names table col data_type

// starts with 'pref'

// $value is the default selected value.

// the second part of the data_type field should have the name of

// the table which contains the preferences list info

preg_match_all("/\w+/", $data_type , $matches );

$array=$matches[0];

$table="$array[1]" ;

$query = "SELECT detail from $table where athlete_id = $athlete_id " ;

$result = do_sql($query) or die('Query failed: ' . pg_last_error());

$list_data=array();

while ( $row = pg_fetch_array($result, null, PGSQL_ASSOC) ) {

array_push( $list_data , $row['detail'] ) ;

}

echo " <SELECT NAME='${colname}' >\n" ;

foreach ( $list_data as $list_item ) {

$selected = "" ;

if ( "$list_item" == "$value" ) { $selected = "SELECTED" ; }

echo "<OPTION VALUE='$list_item' $selected > $list_item </OPTION>\n";

}

echo "</SELECT>\n";

## END of FUNCTION

// Convert a pg date YYYY-MM-DD to nice date d/m/y

// first check it is actually in this format

if ( ! preg_match("/\d\d\d\d-\d\d-\d\d/", $pg_date) )

return $pg_date;

preg_match_all( "/\d+/", $pg_date, $matches);

$parts=$matches[0];

$yyyy = $parts[0];

$mm = $parts[1];

$dd = $parts[2];

$formatted_date = "$dd/$mm/$yyyy";

return $formatted_date ;

## END of FUNCTION

# Put columns we never want to show in this array:

$do_not_show = array ("athlete_id", "session_id", "parent_session" ) ;

$columns = get_column_names() ;

# Get an array of fields user does want to display

$display_details = array();

$query = "SELECT detail from athlete_log_preferences

where athlete_id=$athlete_id ";

# ORDER BY display_sequence";

$result = do_sql($query) or die('Query failed: ' . pg_last_error());

// pg_fetch_array returns the next whole row as an array at each iteration

while ( $row = pg_fetch_array($result, null, PGSQL_ASSOC) )

{

foreach ( $row as $prev_detail ){

array_push( $display_details, $prev_detail ) ;

}

}

echo "$error_message \n";

# Start Form and Table

echo "<DIV id=mainlogentry > <a name=log_entry_form></a>";

echo "<FORM action=update_log_entry.php method=post >\n";

echo "<input type=hidden name='session_id' value=$session_id>\n";

echo "\n\n<TABLE class=mainlogentry ><TR><TD>\n\n";

// Get Current row data

$query = "SELECT * from log

where session_id=$session_id ";

$result = do_sql($query) or die('Query failed: ' . pg_last_error());

// pg_fetch_array returns the next whole row as an array at each iteration

// there really should only be 1 row returned here.

// Check for date fields because we need to convert them

$date_fields = array() ;

$num = pg_num_fields($result) ;

for ( $fieldnum = 0 ; $fieldnum < $num ; $fieldnum++ ) {

if ( pg_field_type($result, $fieldnum) == 'date' ) {

// put names of all date fields into $date_fields

$fieldname = pg_field_name($result, $fieldnum);

array_push($date_fields, $fieldname);

}

}

// Now stick the info for the row the user wants to edit into an array

$session_details = pg_fetch_array($result, null, PGSQL_ASSOC);

// Check for date fields and convert them

// Get the fields names

foreach ( array_keys($session_details) as $field_name ) {

// and see if they are in the date_fields array

if ( in_array($field_name, $date_fields ) ) {

// If they are then convert the date from pg format to d/m/y

$session_details[$field_name] = convert_date_from_pg($session_details[$field_name]);

}

}

// Dates are converted //

// Display Entry fields

// Save text/notes fields (ie data_type text or var > 50 ) in a variable to

// display last

$notes_fields="";

echo "<TR>\n";

$maxnumcols = 6 ;

$colcount = $maxnumcols ;

foreach ( $display_details as $colname ){

if ( (! in_array( $colname , $do_not_show ) ) && ( in_array( $colname , $display_details ) ) ) {

if ( $colcount-- == 0 ) { echo "\n</TR>\n" ; $colcount = $maxnumcols-1 ; }

$colinfo = get_column_info($colname);

$input_type = "text" ;

$value = $session_details[$colname] ;

if ( preg_match("/^var/", $colinfo['data_type']) ) {

// Get the var length

$typearray = explode(" ",$colinfo['data_type'] ) ;

$varlen = $typearray[1];

}

if ( preg_match("/^select/", $colinfo['data_type']) ) {

// We have a select list type. There should be a corresponding table

// which lists the select info

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

generate_select_form( $colname, $colinfo['data_type'], $value);

}

elseif ( preg_match("/^pref/", $colinfo['data_type']) ) {

// We have a prefer select list type. There should be a corresponding table

// which lists the prefered select info

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

generate_prefer_select_form( $colname, $colinfo['data_type'], $value, $athlete_id);

}

// Generate Notes fields and add them beneath the smaller table entries

elseif ( ( $colinfo['data_type'] == "text" ) || ( $varlen >= 30 ) ) {

// Set maximum field size to 80

if ( $varlen <= 80 ) { $size = $varlen; } else { $size = 80 ; }

$notes_fields = "$notes_fields <TR><TD> ".$colinfo['log_col_long_name']."</TD> <TD colspan=20 ><INPUT type=text name =${colname} value='$value' size=$size > </TD></TR>\n";

}

else {

echo " <td align=center ><font size=1 > \n";

echo $colinfo['log_col_long_name']." <BR>\n";

echo "<INPUT type=$input_type name=${colname} value='$value' size=10>\n";

}

echo "</font> </td>\n" ;

}

}

echo "</TR>\n";

echo "$notes_fields\n";

echo "</TABLE>";

echo "<input type=submit value='Submit entries'>";

echo "</FORM>";

echo "</DIV>";

## END of FUNCTION