[insert_php]
require_once (‘impactia/db.php’);
global $user;
$conn = imp_connect();
$sql = «SELECT agh.id from usuario_hospital as uh, ag_hospital as agh, usuarios as u
where u.name = ‘».$user->name.»‘ and u.id = uh.usuario and uh.hospital = agh.id»;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$centro = $row[‘id’];
$sql = «select name from ag_hospital where id=$centro»;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$name = $row[‘name’];
[/insert_php]
Ver sólo los documentos: aceptados, rechazados, pendientes de revisión, todos. [insert_php]
$sql = «SELECT distinct wr.id, wr.title, wr.auth_affi, wr.document_type, wr.journal, wr.year, wr.page_start, wr.page_end, wr.computa, wr.observaciones
from article_sin_dup as asd, article as wr
where asd.id = wr.id
and wr.hospital = $centro order by id desc»;
$result = mysql_query($sql);
$number = mysql_num_rows($result);
[/insert_php]
ID | Titulo | Tipo doc. | Revista | Año | Estado | Observaciones |
---|---|---|---|---|---|---|
«.$row[‘id’].» | «.$row[‘title’].» | » .$row[‘document_type’].» |
«.$row[‘journal’].» | «.$row[‘year’].» | » .$estado.» |
«.$row[‘observaciones’].» |
«;
imp_close($conn);
[/insert_php]