| 1 |
yamaji |
1.1 |
<?php |
| 2 |
|
|
// $Revision: 1.11 $ // |
| 3 |
|
|
// ------------------------------------------------------------------------ // |
| 4 |
|
|
// // |
| 5 |
|
|
// OAI-PMH based Institutional Repository Introduction Module // |
| 6 |
|
|
// Copyright (C) 2005 Kazutsuna YAMAJI. All rights reserved. // |
| 7 |
|
|
// // |
| 8 |
|
|
// ------------------------------------------------------------------------ // |
| 9 |
|
|
// This program is free software; you can redistribute it and/or modify // |
| 10 |
|
|
// it under the terms of the GNU General Public License as published by // |
| 11 |
|
|
// the Free Software Foundation; either version 2 of the License, or // |
| 12 |
|
|
// (at your option) any later version. // |
| 13 |
|
|
// // |
| 14 |
|
|
// You may not change or alter any portion of this comment or credits // |
| 15 |
|
|
// of supporting developers from this source code or any supporting // |
| 16 |
|
|
// source code which is considered copyrighted (c) material of the // |
| 17 |
|
|
// original comment or credit authors. // |
| 18 |
|
|
// // |
| 19 |
|
|
// This program is distributed in the hope that it will be useful, // |
| 20 |
|
|
// but WITHOUT ANY WARRANTY; without even the implied warranty of // |
| 21 |
|
|
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // |
| 22 |
|
|
// GNU General Public License for more details. // |
| 23 |
|
|
// // |
| 24 |
|
|
// You should have received a copy of the GNU General Public License // |
| 25 |
|
|
// along with this program; if not, write to the Free Software // |
| 26 |
|
|
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // |
| 27 |
|
|
// ------------------------------------------------------------------------ // |
| 28 |
|
|
|
| 29 |
|
|
define( 'GRAPH_PERIOD', 60*60*24*364*1 ); |
| 30 |
|
|
# |
| 31 |
|
|
$mhandler =& xoops_gethandler('module'); |
| 32 |
|
|
$module = $mhandler->getByDirname( 'irview' ); |
| 33 |
|
|
$chandler = & xoops_gethandler('config'); |
| 34 |
|
|
$assoc = $chandler->getConfigsByCat(false, $module->mid()); |
| 35 |
|
|
$jpgraph_location = $assoc['jpgraph_location']; |
| 36 |
|
|
$tmpfile_location = $assoc['tmpfile_location']; |
| 37 |
|
|
|
| 38 |
|
|
|
| 39 |
|
|
include($jpgraph_location."jpgraph.php"); |
| 40 |
|
|
include($jpgraph_location."jpgraph_line.php"); |
| 41 |
|
|
include($jpgraph_location."jpgraph_bar.php"); |
| 42 |
|
|
include($jpgraph_location."jpgraph_date.php"); |
| 43 |
|
|
|
| 44 |
|
|
$table_meta = $xoopsDB->prefix( 'irview_metadata' ); |
| 45 |
|
|
$table_repo = $xoopsDB->prefix( 'irview_repositories' ); |
| 46 |
|
|
// |
| 47 |
|
|
// Count the active repository from the irview_repositories table |
| 48 |
|
|
$sql = "SELECT repo.repository_id, repo.repository_name, repo.URL, repo.metadata_formats FROM ${table_repo} AS repo WHERE repo.enabled=1 AND repo.deleted!=1 ORDER BY repo.repository_id"; |
| 49 |
|
|
$result = $xoopsDB->query( $sql ); |
| 50 |
|
|
while($row = $xoopsDB->fetchRow( $result )){ |
| 51 |
|
|
$repo_id[] = (int)$row[0]; |
| 52 |
|
|
$repo_name[] = $row[1]; |
| 53 |
|
|
$repo_url[] = $row[2]; |
| 54 |
|
|
$repo_formats[] = $row[3]; |
| 55 |
|
|
$graph_filename[] = tempnam( $tmpfile_location, "IRview_" ); |
| 56 |
|
|
} |
| 57 |
|
|
// |
| 58 |
|
|
// |
| 59 |
|
|
$endTime = strtotime(date('Y/m/d', time())) + 60*60*24; |
| 60 |
|
|
foreach ($repo_id as $repo_id_key => $repo_id_val) { |
| 61 |
|
|
// Data obraining |
| 62 |
|
|
$sql = "SELECT meta.datestamp FROM ${table_meta} AS meta WHERE meta.repository_id=${repo_id_val}"; |
| 63 |
|
|
$result = $xoopsDB->query( $sql ); |
| 64 |
|
|
|
| 65 |
|
|
if($result){ |
| 66 |
|
|
while($row = $xoopsDB->fetchRow( $result )){ |
| 67 |
|
|
$graph_data[$repo_id_key][] = (int)$row[0]; |
| 68 |
|
|
} |
| 69 |
|
|
// |
| 70 |
|
|
sort($graph_data[$repo_id_key]); |
| 71 |
|
|
|
| 72 |
|
|
$total_data = array(); |
| 73 |
|
|
$each_data = array(); |
| 74 |
|
|
$timestamp = array(); |
| 75 |
|
|
$startTime = $graph_data[$repo_id_key][0]; |
| 76 |
|
|
$date_count = 0; |
| 77 |
|
|
$total_data[$date_count] = 0; |
| 78 |
|
|
|
| 79 |
|
|
for ( $i = $startTime; $i <= $endTime; $i = $i + (60*60*24) ) { |
| 80 |
|
|
$each_data[$date_count] = 0; |
| 81 |
|
|
foreach ( $graph_data[$repo_id_key] as $data_tmp ) { |
| 82 |
|
|
if (($i <= $data_tmp) && ($data_tmp < ($i + (60*60*24)))) { |
| 83 |
|
|
$each_data[$date_count]++; |
| 84 |
|
|
$total_data[$date_count]++; |
| 85 |
|
|
} |
| 86 |
|
|
} |
| 87 |
|
|
$timestamp[$date_count] = $i; |
| 88 |
|
|
if( $i <= $endTime-(60*60*24) ){ |
| 89 |
|
|
$total_data[$date_count+1] = $total_data[$date_count]; |
| 90 |
|
|
} |
| 91 |
|
|
$date_count++; |
| 92 |
|
|
} |
| 93 |
|
|
$total_data_final = array(); |
| 94 |
|
|
$each_data_final = array(); |
| 95 |
|
|
$timestamp_final = array(); |
| 96 |
|
|
|
| 97 |
|
|
// Extracting 1 year data for drawing |
| 98 |
|
|
// Data will be stored reversely |
| 99 |
|
|
if(sizeof($timestamp) < GRAPH_PERIOD) { |
| 100 |
|
|
for ( $i = sizeof($timestamp)-1, $count = 0; 0 <= $i; $i--, $count++) { |
| 101 |
|
|
$total_data_final[$count] = $total_data[$i]; |
| 102 |
|
|
$each_data_final[$count] = $each_data[$i]; |
| 103 |
|
|
$timestamp_final[$count] = $timestamp[$i]; |
| 104 |
|
|
} |
| 105 |
|
|
} else { |
| 106 |
|
|
for ( $i = sizeof($timestamp)-1, $count = 0; $endTime-GRAPH_PERIOD < $timestamp[$i]; $i--, $count++) { |
| 107 |
|
|
$total_data_final[$count] = $total_data[$i]; |
| 108 |
|
|
$each_data_final[$count] = $each_data[$i]; |
| 109 |
|
|
$timestamp_final[$count] = $timestamp[$i]; |
| 110 |
|
|
} |
| 111 |
|
|
} |
| 112 |
|
|
//var_dump($total_data_final); |
| 113 |
|
|
//var_dump($each_data_final); |
| 114 |
|
|
//var_dump($timestamp_final); |
| 115 |
|
|
// Setup for drawing graph |
| 116 |
|
|
$graph = new Graph(200,100); |
| 117 |
|
|
$graph->img->SetMargin(40,45,15,35); |
| 118 |
|
|
$graph->SetScale("datint", 0, "auto", $endTime-GRAPH_PERIOD, $endTime); |
| 119 |
|
|
// X axis configuration |
| 120 |
|
|
$graph->xaxis->SetTitleMargin(0); |
| 121 |
|
|
$graph->xaxis->title->SetFont(FF_VERA, FS_NORMAL,8); |
| 122 |
|
|
$graph->xaxis->SetFont(FF_VERA, FS_NORMAL,6); |
| 123 |
|
|
$graph->xaxis->HideTicks(true, false); |
| 124 |
|
|
$graph->xaxis->SetTextLabelInterval(2); |
| 125 |
|
|
$graph->xaxis->SetLabelAngle(45); |
| 126 |
|
|
$graph->xaxis->scale->SetDateFormat("y-M"); |
| 127 |
|
|
$graph->xaxis->scale->SetTimeAlign(MINADJ_1); |
| 128 |
|
|
$graph->xgrid->Show(true,false); |
| 129 |
|
|
// Y axis configuration |
| 130 |
|
|
$graph->yaxis->SetTitle("Items/day ", "middle"); |
| 131 |
|
|
$graph->yaxis->SetTitleMargin(28); |
| 132 |
|
|
$graph->yaxis->title->SetFont(FF_VERA, FS_NORMAL, 8); |
| 133 |
|
|
$graph->yaxis->title->SetColor("deepskyblue3"); |
| 134 |
|
|
$graph->yaxis->SetFont(FF_VERA, FS_NORMAL, 6); |
| 135 |
|
|
$graph->ygrid->Show(true,true); |
| 136 |
|
|
// Y2 axis configuration |
| 137 |
|
|
$graph->SetY2Scale("int"); |
| 138 |
|
|
$graph->y2axis->SetTitle("Total items ", "middle"); |
| 139 |
|
|
$graph->y2axis->SetTitleMargin(27); |
| 140 |
|
|
$graph->y2axis->title->SetFont(FF_VERA,FS_NORMAL,8); |
| 141 |
|
|
$graph->y2axis->title->SetColor("darkorange"); |
| 142 |
|
|
$graph->y2axis->SetFont(FF_VERA,FS_NORMAL,6); |
| 143 |
|
|
// |
| 144 |
|
|
$bplot = new BarPlot($each_data_final, $timestamp_final); |
| 145 |
|
|
$bplot->SetAbsWidth(1); |
| 146 |
|
|
$bplot->SetColor("deepskyblue3"); |
| 147 |
|
|
$lplot = new LinePlot($total_data_final, $timestamp_final); |
| 148 |
|
|
$lplot->SetColor("darkorange"); |
| 149 |
|
|
|
| 150 |
|
|
$graph->Add($bplot); |
| 151 |
|
|
$graph->AddY2($lplot); |
| 152 |
|
|
$graph->img->SetImgFormat('png'); |
| 153 |
|
|
$graph->SetColor("lightyellow"); |
| 154 |
|
|
$graph->SetMarginColor("azure2"); |
| 155 |
|
|
$graph->SetBox(true,'black',2); |
| 156 |
|
|
//$graph->SetTickDensity(TICKD_VERYSPARSE); |
| 157 |
|
|
$graph->SetTickDensity(TICKD_SPARSE); |
| 158 |
|
|
$graph->SetFrameBevel(2,true,"azure4"); |
| 159 |
|
|
// |
| 160 |
|
|
// Temporary saved image in $tmpfile_location |
| 161 |
|
|
//$graph->Stroke( ); |
| 162 |
|
|
$graph->Stroke($graph_filename[$repo_id_key]); |
| 163 |
|
|
|
| 164 |
|
|
//var_dump($graph_filename); |
| 165 |
|
|
// Saved image from $tmpfile_location to Database |
| 166 |
|
|
$fp = fopen($graph_filename[$repo_id_key],'rb'); |
| 167 |
|
|
if($fp){ |
| 168 |
|
|
$graph_image = base64_encode(fread($fp, filesize($graph_filename[$repo_id_key]))); |
| 169 |
|
|
$sql = "UPDATE ${table_repo} SET record_graph='".$graph_image. |
| 170 |
|
|
"' WHERE repository_id='".$repo_id_val."'"; |
| 171 |
|
|
$result = $xoopsDB->queryF( $sql ); |
| 172 |
|
|
if(!$result){ |
| 173 |
|
|
echo "ERROR : "._MD_IRVIEW_GRAPH_MYSQL_QUERY_ERROR; |
| 174 |
|
|
} |
| 175 |
|
|
}else{ |
| 176 |
|
|
echo "ERROR : "._MD_IRVIEW_GRAPH_FILE_OPEN_ERROR; |
| 177 |
|
|
} |
| 178 |
|
|
fclose($fp); |
| 179 |
|
|
unlink($graph_filename[$repo_id_key]); |
| 180 |
|
|
}else{ |
| 181 |
|
|
echo "ERROR : "._MD_IRVIEW_GRAPH_MYSQL_QUERY_ERROR; |
| 182 |
|
|
} |
| 183 |
|
|
} |
| 184 |
|
|
?> |
Parent Directory
Revision Log
Revision Graph