sya sedang menambahkan script di slimmatoa, maaf lho suhu senayan, mohon
bantuannya yaitu dengan rencananya saya ingin menambahkan reporting dengan
pilihan "Location". saya masukan tambahan script kedalam file class_rekap.php
scriptnya sebagai berikut:
dibagian filter saya tambahkan :
$recapby_options[] = array('location', __('LOCATION'));
di bagian script PHP :
saya tambahkan
break;
case 'location' :
$recapby = __('location');
/* LOCATION */
$location_q = $dbs->query("SELECT DISTINCT location_id,
location_name FROM mst_location");
while ($location_d = $location_q->fetch_row()) {
$row_class = ($row_class ==
'alterCellPrinted')?'alterCellPrinted2':'alterCellPrinted';
$output .= '<tr><td class="'.$row_class.'"><strong
style="font-size: 1.5em;">'.$location_d[1].'</strong></td>';
// count by title
$bytitle_q = $dbs->query("SELECT COUNT(biblio_id) FROM item AS
i WHERE i.location_id='".$location_d[0]."'");
$bytitle_d = $bytitle_q->fetch_row();
$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
INNER JOIN biblio AS i
WHERE b.location_id=".$location_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 */
jdi hasilnya tidak ada tuh (kosong), mhon bantuan sahabat slim ya, maaf mhon
bantuan bank hendro n bannk ari, lagi belajar nih
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/
