$p = db_getRow( "SELECT * FROM organisation WHERE id=?", $pub_id );

if( 0 ) {

/* recent articles */

$arts = db_getAll( "SELECT id,title,pubdate,permalink FROM article WHERE srcorg=? ORDER BY pubdate DESC LIMIT 10", $pub_id );

foreach( $arts as &$a ) {

article_augment( $a );

}

unset( $a );

$p['recent_articles'] = $arts;

}

/* principles */

if( $p['sop_url'] ) {

$p['principles'] = array( 'name'=>$p['sop_name'], 'url'=>$p['sop_url'] );

} else {

$p['principles'] = null;

}

unset( $p['sop_url'] );

unset( $p['sop_name'] );

/* recent journos */

$sql = <<<EOT

SELECT DISTINCT j.ref, j.prettyname, j.lastname FROM

( ( journo j INNER JOIN journo_attr attr ON j.id=attr.journo_id )

INNER JOIN article a ON a.id=attr.article_id)

WHERE a.srcorg=?

AND a.status='a'

AND a.pubdate > NOW() - INTERVAL '1 week'

ORDER BY j.lastname;

EOT;

$journos = db_getAll( $sql, $pub_id );

$p['recent_journos'] = $journos;

/* address (vcard adr fields) */

$foo = db_getOne( "SELECT adr FROM pub_adr WHERE pub_id=?", $pub_id );

$p['adr'] = $foo ? vcard_parse_adr( $foo ) : NULL;

/* telephone (assume type='voice' for now) */

$p['tel'] = db_getOne( "SELECT phone FROM pub_phone WHERE pub_id=?", $pub_id );

return $p;

$pubs = db_getAll( "SELECT id,shortname,prettyname FROM organisation ORDER BY prettyname" );

?>

<div class="main">

<div class="head"><h2>Publications</h2></div>

<div class="body">

<ul>

<?php foreach( $pubs as $pub ) { ?>

<li><?= publication_link( $pub ) ?></li>

<?php } ?>

</ul>

</div>

<div class="foot"></div>

</div> <!-- end main -->

<?php