[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]

[insert_php]
$i = 1;
while($row = mysql_fetch_array($result))
{

if($row[‘computa’] == “si” ){
$estado = “Aceptado”;
$color = “green”;
}elseif($row[‘computa’] == “pendiente”){
$estado = “pendiente”;
$color = “yellow”;
}elseif($row[‘computa’] == “no”){
$estado = “Rechazado”;
$color = “red”;
}else{
$estado = “Aceptado”;
$color = “green”;
}

echo “

“;
$i++;
}
echo “

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]