Membership Report & Collection Statistic

Write here for anything about reporting module in SLiMS.

Moderators: wynerst, buitenzorg812, purwoko, sutriadi, ido, Dicarve, ridorido

Membership Report & Collection Statistic

Postby fixxxer » 10 Apr 2014, 14:47

Salam...
Mau tanya tentang SLiMS meranti, apakah bisa untuk Melihat Laporan Anggota itu laporan perbulan? karena sudah 2 tahun 10 peminjam terbanyak ya cuma itu" saja,
Pernah saya coba rubah code pada /admin/modules/reporting/member_report.php
Code Asli
Code: Select all
// 10 most active member
$report_q = $dbs->query('SELECT m.member_name, m.member_id, COUNT(loan_id) FROM loan AS l
    INNER JOIN member AS m ON m.member_id=l.member_id
    WHERE TO_DAYS(expire_date)>TO_DAYS(\''.date('Y-m-d').'\')
    GROUP BY l.member_id ORDER BY COUNT(loan_id) DESC LIMIT 10');
$report_d = '<ul>';
while ($data = $report_q->fetch_row()) {
    $report_d .= '<li>'.$data[0].' ('.$data[1].')</li>';
}
$loan_report[__('10 Anggota Teraktif')] = $report_d;

Menjadi:
Code: Select all
// 10 most active member
$report_q = $dbs->query('SELECT m.member_name, m.member_id, COUNT(loan_id) FROM loan AS l
    INNER JOIN member AS m ON m.member_id=l.member_id
    WHERE TO_DAYS(2017-03-31)>TO_DAYS(\''.date('Y-m-d').'\')
    GROUP BY l.member_id ORDER BY COUNT(loan_id) DESC LIMIT 10');
$report_d = '<ul>';
while ($data = $report_q->fetch_row()) {
    $report_d .= '<li>'.$data[0].' ('.$data[1].')</li>';
}
$loan_report[__('10 Anggota Teraktif')] = $report_d;

Tetapi malah tidak ada reportnya...
dan juga dibagian Collection Statistic, kenapa 10 Most Popular Titles bukunya itu" saja dari dua tahun yang lalu?
Thx...
fixxxer
 
Posts: 1
Joined: 29 May 2012, 23:30

Return to Reporting Module

Who is online

Users browsing this forum: No registered users and 2 guests

cron