0 && $rffid == $ff_id ) { $sel = 1; } // echo "

$kind - $ftid - $name - " . $row["ff_id"] . " - '$rffid' => $sel

"; if( !isset( $tags[$kind] ) ) { $tags[$kind] = array(); } $tags[$kind][] = array( $ftid, $name, $descr, $sel ); if( $kind == FTK_DATE ) { if( $date == $name ) { $dateid = $ftid; $datefound = 2; } else if( $datefound < 2 && strlen( $name ) == 23 ) { $datefrom = substr( $name, 0, 10 ); $datetill = substr( $name, 13 ); if( $date >= $datefrom && $date <= $datetill ) { $dateid = $ftid; $datefound = 1; } } } $row = pg_fetch_array( $ress, NULL, PGSQL_ASSOC ); } } return $dateid; } function tags_list( $conn, $sel_kind=0 ) { global $FTK_NAMES; global $FTK_ORDER; tags_read_all( $conn, $tags ); foreach( $FTK_ORDER as $kind ) { if( isset( $tags[$kind] ) ) { echo "

" . htmlentities($FTK_NAMES[$kind]) . "

\n\n"; } } echo "

\n"; ?> \n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
kind: date from/till: " . " / " . " (yyyy-mm-dd)
name: " . "
descr: " . "
" . "
\n"; echo "\n"; echo "

\n"; } function tags_edit( $conn ) { } function tags_save( $conn ) { if( !var_int( "P", "kind", $kind, 1, FTK_MAX ) ) { return; } $havename = var_string( "P", "name", $name, 1, 40 ); if( $kind == FTK_DATE ) { if( !var_date( "P", "date_from", $name ) ) { echo "

date from not given.

\n"; return; } if( var_date( "P", "date_till", $date_till ) ) { $name .= " - " . $date_till; } } else if( !$havename ) { echo "

name not given.

\n"; return; } var_string( "P", "descr", $descr, 1, 200 ); $id = sql_next_id( $conn, "fotolib_tag", "ft_id" ); if( $id === null ) { return; } $sql = "insert into fotolib_tag ( " . "ft_id, ft_kind, ft_name, ft_descr, ft_timestamp " . ") values ( " . "\$1, \$2, \$3, \$4, current_timestamp " . ")"; $values = array( 1 => $id, 2 => $kind, 3 => $name, 4 => $descr ); pg_query_params( $conn, $sql, $values ); tags_list( $conn, $kind ); } function tags_show_dated( $conn ) { $sql = "select " . "t.ft_id, " . "t.ft_kind, " . "t.ft_name, " . "t.ft_descr " . "from " . "fotolib_tag t " . "where " . "t.ft_kind = " . FTK_DATE . " and " . "exists ( " . "select ft_id from fotolib_foto_tag r " . "where r.ft_id = t.ft_id " . ") " . "order by " . "t.ft_name, " . "t.ft_descr"; // $ress = pg_query_params( $conn, $sql, $values ); //echo "{{{$sql}}}"; $ress = pg_query( $conn, $sql ); if( !$ress ) { return; } $row = pg_fetch_array( $ress, NULL, PGSQL_ASSOC ); if( !$row ) { echo "

No data found.

\n"; return; } echo "\n"; } ?>