---

HTML; // global totals if ($pg=="" or $pg=="1") { echo "[Total Gerais]  [Teses mais Acessadas]  "; echo "

"; echo <<

Totais gerais Total de downloads $d_total Total de teses $t_total

HTML; $bd_bio = bar($d_bio, $d_total, 'blue'); $bd_hum = bar($d_hum, $d_total, 'blue'); $bd_exa = bar($d_exa, $d_total, 'blue'); $bd_agr = bar($d_agr, $d_total, 'blue'); $bd_sau = bar($d_sau, $d_total, 'blue'); $bd_apl = bar($d_apl, $d_total, 'blue'); $bd_eng = bar($d_eng, $d_total, 'blue'); $bd_lin = bar($d_lin, $d_total, 'blue'); $bt_bio = bar($t_bio, $t_total, 'red'); $bt_hum = bar($t_hum, $t_total, 'red'); $bt_exa = bar($t_exa, $t_total, 'red'); $bt_agr = bar($t_agr, $t_total, 'red'); $bt_sau = bar($t_sau, $t_total, 'red'); $bt_apl = bar($t_apl, $t_total, 'red'); $bt_eng = bar($t_eng, $t_total, 'red'); $bt_lin = bar($t_lin, $t_total, 'red'); echo <<

Quantidade de downloads (azul) e de teses (vermelho) por área Área Porcentagem Quantidade Agrárias $bd_agr $d_agr $bt_agr $t_agr Biológicas $bd_bio $d_bio $bt_bio $t_bio Saúde $bd_sau $d_sau $bt_sau $t_sau Exatas e da Terra $bd_exa $d_exa $bt_exa $t_exa Humanas $bd_hum $d_hum $bt_hum $t_hum Sociais Aplicadas $bd_apl $d_apl $bt_apl $t_apl Engenharias $bd_eng $d_eng $bt_eng $t_eng Lingüistica, Letras e Artes $bd_lin $d_lin $bt_lin $t_lin

---

HTML; } if ($pg=="2") { echo "[Total Gerais]  [Teses mais Acessadas]  "; echo "

"; echo <<

HTML; $i = 0; $q = db_query("SELECT unit,COUNT(user_id) AS downloads FROM z_log GROUP BY unit ORDER BY downloads DESC"); echo "\n"; while ($a = db_fetch_array($q)) { // if (!($a['unit'] == 'IFGW')) { if (!($a['unit'] == 'x')) { if ($i++ & 1) echo "\n"; else echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } echo << Total de downloads por unidade Unidade Downloads {$unit[$a['unit']]} {$a['visits']}

HTML; // number of downloads per institution (max 40) echo <<

HTML; $q = db_query("SELECT U.institution,COUNT(L.user_id) AS downloads FROM z_log L,z_user U WHERE L.user_id=U.id GROUP BY U.institution ORDER BY downloads DESC LIMIT 40"); $i = 0; while ($a = db_fetch_array($q)) { if ($i++ & 1) echo "\n"; else echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo << Total de downloads por instituição Instituição/Empresa Downloads {$a['institution']} {$a['visits']}

---

HTML; } if ($pg=="3") { echo "[Total Gerais]  [Teses mais Acessadas]  "; echo "

"; echo <<

HTML; $i = 0; $lim = 10; //$q = db_query("SELECT code,unit,COUNT(user_id) AS downloads FROM z_log WHERE code LIKE 'vtls%' GROUP BY code,unit ORDER BY downloads DESC LIMIT 40"); // $q = pg_exec($db_conn2, "SELECT author, title, code, downloads FROM (Select author, title, code, downloads, visits FROM nr_document WHERE code LIKE 'vtls%' ORDER BY visits DESC LIMIT $lim) as ord ORDER BY downloads DESC"); //$q = pg_exec($db_conn2, "SELECT code, downloads FROM nr_document WHERE code LIKE 'vtls%' ORDER BY downloads DESC LIMIT 20"); //ORI $c = pg_connect("dbname=$cfg_other_base user=$cfg_user"); //NAO TINHA ESSA LINHA $q = pg_exec($c, "SELECT code, downloads FROM nr_document WHERE code LIKE 'vtls%' ORDER BY downloads DESC LIMIT 20"); while ($a = db_fetch_array($q)) { if (trim($a['unit']) != 'x') { if ($i++ & 1) echo "\n"; else echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } echo << Teses e dissertações com mais downloads Código Título Downloads {$a['code']} {$title[$a['code']]} {$vtls[$a['code']]}

---

HTML; } //--------------------------- echo "
Sistema Integrado de Bibliotecas - SIB / UEM - @ ltktanaka@uem.br"; echo << HTML; /*-------------- functions --------------*/ function bar ($value, $total, $color) { $p = round($value * 100 / $total); return " $p %\n"; } ?>