heloo semua... saya coba lagi script.... clas_rekap.php dari reporting untuk
menampilkan jumlah judul di lokasi. seperti ini :
break;
case 'location' :
$recapby = __('Location');
/* LOCATION */
$loc_q = $dbs->query("SELECT DISTINCT location_id, location_name
FROM mst_location");
while ($loc_d = $loc_q->fetch_row()) {
$row_class = ($row_class ==
'alterCellPrinted')?'alterCellPrinted2':'alterCellPrinted';
$output .= '<tr><td class="'.$row_class.'"><strong
style="font-size: 1.5em;">'.$loc_d[1].'</strong></td>';
// count by title
$bytitle_q = $dbs->query("SELECT DISTINCT biblio_id FROM item
AS i WHERE i.location_id=".$loc_d[0]."");
$output .= '<td class="'.$row_class.'"><strong
style="font-size: 1.3em;">'.$bytitle_d[0].'</strong></td>';
// count by item
$byitem_q = $dbs->query("SELECT COUNT(item_id) FROM item AS i
WHERE i.location_id=".$loc_d[0]);
$byitem_d = $byitem_q->fetch_row();
$output .= '<td class="'.$row_class.'"><strong
style="font-size: 1.3em;">'.$byitem_d[0].'</strong></td>';
$output .= '</tr>';
}
/* LOCATION END */
break;
hasilnya belum berhasil ada tuh, mohon masukan para develop slim, mas ari, mas
hendro, mas pur, mas indra setiadi, kira2 kesalahan dimananya yah...
case 'location' ========>udah betul belum yah?
salam
[Non-text portions of this message have been removed]
------------------------------------
--
Towards cyber libraries to support information society in Indonesia.
Joining ICS-isis by sending mailto:[email protected]
Visit ICS-Portal at http://digilib.binus.ac.id/ics/index.phpYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ics-isis/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ics-isis/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
