silverstripe / silverstripe-forum

 * Lists the Number of people who have signed up in the past months categorized

 * by month.

 */

class ForumReport_MemberSignups extends SS_Report

{

    public function title()

    {

        return _t('Forum.FORUMSIGNUPS', 'Forum Signups by Month');

    }

    public function sourceRecords($params = array())

    {

        $membersQuery = new SQLQuery();

        $membersQuery->setFrom('"Member"');

        $membersQuery->setSelect(array(

            'Month' => DB::getConn()->formattedDatetimeClause('"Created"', '%Y-%m'),

            'Signups' => 'COUNT("Created")'

        ));

        $membersQuery->setGroupBy('"Month"');

        $membersQuery->setOrderBy('"Month"', 'DESC');

        $members = $membersQuery->execute();

        $output = ArrayList::create();

        foreach ($members as $member) {

            $member['Month'] = date('Y F', strtotime($member['Month']));

            $output->add(ArrayData::create($member));

        }

        return $output;

    }

    public function columns()

    {

        $fields = array(

            'Month' => 'Month',

            'Signups' => 'Signups'

        );

        return $fields;

    }

    public function group()

    {

        return 'Forum Reports';

 * Lists the Number of Posts made in the forums in the past months categorized

 * by month.

 */

class ForumReport_MonthlyPosts extends SS_Report

{

    public function title()

    {

        return _t('Forum.FORUMMONTHLYPOSTS', 'Forum Posts by Month');

    }

    public function sourceRecords($params = array())

    {

        $postsQuery = new SQLQuery();

        $postsQuery->setFrom('"Post"');

        $postsQuery->setSelect(array(

            'Month' => DB::getConn()->formattedDatetimeClause('"Created"', '%Y-%m'),

            'Posts' => 'COUNT("Created")'

        ));

        $postsQuery->setGroupBy('"Month"');

        $postsQuery->setOrderBy('"Month"', 'DESC');

        $posts = $postsQuery->execute();

        $output = ArrayList::create();

        foreach ($posts as $post) {

            $post['Month'] = date('Y F', strtotime($post['Month']));

            $output->add(ArrayData::create($post));

        }

        return $output;

    }

    public function columns()

    {

        $fields = array(

            'Month' => 'Month',

            'Posts' => 'Posts'

        );

        return $fields;

    }

    public function group()

    {

        return 'Forum Reports';