Membership Report & Collection Statistic

Write here for anything about reporting module in SLiMS.

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

Post Reply
fixxxer
Posts: 1
Joined: 29 May 2012, 23:30

Membership Report & Collection Statistic

Post by 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...

Post Reply