Angelov\Storgman\Members\Repositories\EloquentMembersRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	106
Duplicated Lines	45.28 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	store()	0	4	1
B	countByMembershipStatus()	0	24	1
A	getByBirthdayDate()	0	9	1
A	countNewMembersPerMonth()	48	48	2
A	getBoardMembers()	0	4	1
A	getUnapprovedMembers()	0	4	1

<?php

/**
 * Storgman - Student Organizations Management
 * Copyright (C) 2014-2016, Dejan Angelov <angelovdejan92@gmail.com>
 *
 * This file is part of Storgman.
 *
 * Storgman is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Storgman is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Storgman.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package Storgman
 * @copyright Copyright (C) 2014-2016, Dejan Angelov <angelovdejan92@gmail.com>
 * @license https://github.com/angelov/storgman/blob/master/LICENSE
 * @author Dejan Angelov <angelovdejan92@gmail.com>
 */

namespace Angelov\Storgman\Members\Repositories;

use Angelov\Storgman\Core\Repositories\AbstractEloquentRepository;
use Angelov\Storgman\Core\DateTime;
use Angelov\Storgman\Members\Member;
use Angelov\Storgman\Membership\Reports\MembershipStatusReport;
use Angelov\Storgman\Members\Reports\NewMembersPerMonthReport;
use DB;

class EloquentMembersRepository extends AbstractEloquentRepository implements MembersRepositoryInterface
{
    public function __construct(Member $entity)
    {
        parent::__construct($entity);
    }

    public function store(Member $member)
    {
        $member->save();
    }

    public function countByMembershipStatus()
    {
        $currentDate = DateTime::nowAsDateString();

        // The query works with both MySQL and PostgreSQL
        $result = (array)DB::select(
            '
                SELECT *
                FROM
                  (SELECT count(id) AS total
                   FROM members) tbl1,
                  (SELECT count(id) AS active
                   FROM members
                   WHERE id IN
                       (SELECT DISTINCT member_id
                        FROM fees
                        WHERE cast(to_date AS DATE) > ?)) tbl2
            ', [$currentDate]
        )[0];

        $report = new MembershipStatusReport($result['total'], $result['active']);

        return $report;
    }

    public function getByBirthdayDate(DateTime $date)
    {
        $members = Member::whereRaw(
            'EXTRACT(DAY from birthday) = ? and EXTRACT(MONTH from birthday) = ?',
            [$date->format('d'), $date->format('m')]
        )->get()->all();

        return $members;
    }

    public function countNewMembersPerMonth(DateTime $from, DateTime $to)

This method seems to be duplicated in your project.

    {
        $report = new NewMembersPerMonthReport($from, $to);

        $from = $from->toDateString();
        $to = $to->toDateString();

        // The query works with both MySQL and PostgreSQL
        $res = DB::select(
            '
                SELECT concat(YEAR, \'-\', lpad(cast(MONTH AS CHAR(2)), 2, \'0\')) AS month,
                       count(id) AS count
                FROM
                  (SELECT id,
                          email,
                          extract(MONTH
                                  FROM joined) AS MONTH,
                          extract(YEAR
                                  FROM joined) AS YEAR
                   FROM
                     (SELECT id,
                             email,
                             min(from_date) AS joined
                      FROM
                        (SELECT members.id,
                                members.email,
                                fees.from_date,
                                fees.to_date
                         FROM members,
                              fees
                         WHERE members.id = member_id
                           AND fees.from_date BETWEEN ? AND ?) tbl
                      GROUP BY id,
                               email) AS tbl2) tbl3
                GROUP BY concat(MONTH, YEAR),
                         MONTH,
                         YEAR;
            ',
            array($from, $to)
        );

        foreach ($res as &$current) {
            $current = (array)$current;
            $report->addMonth($current["month"], (int)$current["count"]);
        }

        return $report;
    }

    public function getBoardMembers()
    {
        return $this->entity->where('board_member', true)->get()->all();
    }

    public function getUnapprovedMembers()
    {
        return $this->entity->where('approved', false)->get()->all();
    }
}