ArthurGuy / BBMembershipSystem

     * @param string  $reason

     * @return mixed

     */

    public function latestUserPayment($userId, $reason = 'subscription')

    {

        return $this->model->where('user_id', $userId)

            ->whereRaw('reason = ? and (status = ? or status = ? or status = ?)', [$reason, 'paid', 'pending', 'withdrawn'])

            ->orderBy('created_at', 'desc')

            ->first();

    }

    /**

     * @param string $reason

     * @return mixed

     */

    public function getUserPaymentsByReason($userId, $reason)

    {

        return $this->model->where('user_id', $userId)

            ->whereRaw('reason = ? and (status = ? or status = ? or status = ?)', [$reason, 'paid', 'pending', 'withdrawn'])

            ->orderBy('created_at', 'desc')

            ->get();

    }

    /**

    /**

     * @param string $source

     */

    public function getUserPaymentsBySource($userId, $source)

    {

        return $this->model->where('user_id', $userId)

            ->whereRaw('source = ? and (status = ? or status = ? or status = ?)', [$source, 'paid', 'pending', 'withdrawn'])

            ->orderBy('created_at', 'desc')

            ->get();

    }

    /**

     * Get all payments with a specific reference

     * @param $userId

     * @return \Illuminate\Database\Eloquent\Collection

     */

    public function getBalancePaymentsPaginated($userId)

    {

        return $this->model->where('user_id', $userId)

            ->whereRaw('(source = ? or reason = ?) and (status = ? or status = ? or status = ?)', ['balance', 'balance', 'paid', 'pending', 'withdrawn'])

            ->orderBy('created_at', 'desc')

            ->simplePaginate($this->perPage);

    }

    /**

     * @param integer $userId

     * @return mixed

     */

    public function getStorageBoxPayments($userId)

    {

        return $this->model->where('user_id', $userId)

            ->whereRaw('reason = ? and (status = ? or status = ? or status = ?)', ['storage-box', 'paid', 'pending', 'withdrawn'])

            ->orderBy('created_at', 'desc')

            ->get();

    }

    public function dateFilter($startDate, $endDate)

    {