2156

pending completion

Build # 2156

Build Type

Pull #597

travis-ci

Committed by

web-flow

Commit Message

<a href="https://github.com/cross-solution/YAWIK/commit/<a class=hub.com/cross-solution/YAWIK/commit/<a class="double-link" href="https://git"><a class=hub.com/cross-solution/YAWIK/commit/<a class="double-link" href="https://git"><a class=hub.com/cross-solution/YAWIK/commit/<a class="double-link" href="https://git"><a class=hub.com/cross-solution/YAWIK/commit/8a3bf2a8e8d9f8df91722288c1e432a57ffd0457">8a3bf2a8e">&lt;a href=&quot;https://github.com/cross-solution/YAWIK/commit/</a><a class="double-link" href="https://github.com/cross-solution/YAWIK/commit/&lt;a class=&quot;double-link&quot; href=&quot;https://git">&lt;a class=</a>hub.com/cross-solution/YAWIK/commit/&lt;a class=&quot;double-link&quot; href=&quot;https://git">&lt;a class=</a>hub.com/cross-solution/YAWIK/commit/&lt;a class=&quot;double-link&quot; href=&quot;https://git">&lt;a class=</a>hub.com/cross-solution/YAWIK/commit/&lt;a class=&quot;double-link&quot; href=&quot;https://git">&lt;a class=</a>hub.com/cross-solution/YAWIK/commit/8a3bf2a8e8d9f8df91722288c1e432a57ffd0457">8a3bf2a8e</a><a href="https://github.com/cross-solution/YAWIK/commit/8a3bf2a8e8d9f8df91722288c1e432a57ffd0457">&quot;&gt;&amp;lt;a href=&amp;quot;https://github.com/cross-solution/YAWIK/commit/&lt;/a&gt;&lt;a class=&quot;double-link&quot; href=&quot;https://github.com/cross-solution/YAWIK/commit/&amp;lt;a class=&amp;quot;double-link&amp;quot; href=&amp;quot;https://git&quot;&gt;&amp;lt;a class=&lt;/a&gt;hub.com/cross-solution/YAWIK/commit/&amp;lt;a class=&amp;quot;double-link&amp;quot; href=&amp;quot;https://git&quot;&gt;&amp;lt;a class=&lt;/a&gt;hub.com/cross-solution/YAWIK/commit/&amp;lt;a class=&amp;quot;double-link&amp;quot; href=&amp;quot;https://git&quot;&gt;&amp;lt;a class=&lt;/a&gt;hub.com/cross-solution/YAWIK/commit/&amp;lt;a class=&amp;quot;double-link&amp;quot; href=&amp;quot;https://git&quot;&gt;&amp;lt;a class=&lt;/a&gt;hub.com/cross-solution/YAWIK/commit/8a3bf2a8e8d9f8df91722288c1e432a57ffd0457&quot;&gt;8a3bf2a8e&lt;/a&gt;&lt;a href=&quot;https://github.com/cross-solution/YAWIK/commit/8a3bf2a8e8d9f8df91722288c1e432a57ffd0457&quot;&gt;&amp;quot;&amp;gt;&amp;amp;lt;a href=&amp;amp;quot;https://github.com/cross-solution/YAWIK/commit/&amp;lt;/a&amp;gt;&amp;lt;a class=&amp;quot;double-link&amp;quot; href=&amp;quot;https://gi... (continued)

Pull Request Pull Request #597: Issue 591

Run Details

974 of 974 new or added lines in 103 files covered. (100.0%)

8807 of 22733 relevant lines covered (38.74%)

1.17 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

45.71

/module/Organizations/src/Repository/Filter/PaginationQuery.php

<?php
/**
 * YAWIK
 *
 * @copyright https://yawik.org/COPYRIGHT.php
 * @license   MIT
 */

namespace Organizations\Repository\Filter;

use Auth\AuthenticationService;
use Auth\Entity\UserInterface;
use Core\Repository\Filter\AbstractPaginationQuery;
use Jobs\Entity\StatusInterface;
use Organizations\Entity\Organization;
use Jobs\Repository\Job as JobRepository;
use Laminas\Stdlib\Parameters;

/**
 * maps query parameters to entity attributes
 *
 * @package Organizations
 * @author Mathias Weitz <weitz@cross-solution.de>
 * @author Anthonius Munthi <me@itstoni.com>
 */
class PaginationQuery extends AbstractPaginationQuery
{
    const PAGE_TYPE_PROFILE = 'profile';
    const PAGE_TYPE_LIST    = 'list';

    /**
     * Repository to query
     *
     * @var String
     */
    protected $repositoryName="Organizations/Organization";

    /**
     * Sortable fields
     *
     * @var array
     */
    protected $sortPropertiesMap = array(
        'date' => 'dateCreated.date',
    );

    /**
     * @var JobRepository
     */
    protected $jobRepository;

    /**
     * @var AuthenticationService
     */
    private $authService;

    /**
     * Constructs pagination query.
     *
     * @param JobRepository         $jobRepository
     * @param AuthenticationService $auth
     */
    public function __construct(
        JobRepository $jobRepository,
        AuthenticationService $auth
    ) {
        $this->jobRepository = $jobRepository;
        $this->authService = $auth;
    }

    /**
     * Creates a query for filtering organizations
     *
     * @see \Core\Repository\Filter\AbstractPaginationQuery::createQuery()
     * @param $params
     * @param \Doctrine\ODM\MongoDB\Query\Builder $queryBuilder
     * @return mixed
     */
    public function createQuery($params, $queryBuilder)
    {
        if ($params instanceof Parameters) {
            $value = $params->toArray();
        } else {
            $value = $params;
        }

        /*
         * if user is recruiter or admin
         * filter query based on permissions.view
         */
        $auth = $this->authService;
        $user = $auth->getUser();
        $ignored = [null,'guest',UserInterface::ROLE_USER];
        if (!in_array($user->getRole(), $ignored)) {
            $queryBuilder->field('permissions.view')->equals($user->getId());
        }

        if (isset($params['q']) && $params['q'] && $params['q'] != 'en/organizations/profile') {
            $queryBuilder->text($params['q'])->language('none');
        }

        if (!isset($value['sort'])) {
            $value['sort'] = '-date';
        }

        $queryBuilder->sort($this->filterSort($value['sort']));

        if (isset($params['type']) && $params['type'] === 'profile') {
            //@TODO: we should use aggregate query here
            $queryBuilder->field('profileSetting')
                ->in([Organization::PROFILE_ALWAYS_ENABLE,Organization::PROFILE_ACTIVE_JOBS])
            ;

            $filters = $this->getOrganizationProfileFilters($queryBuilder);
            if (count($filters) > 0) {
                $queryBuilder->field('id')->notIn($filters);
            }
        }

        return $queryBuilder;
    }

    /**
     * @param \Doctrine\ODM\MongoDB\Query\Builder $queryBuilder $queryBuilder
     * @return array
     */
    private function getOrganizationProfileFilters($queryBuilder)
    {
        /* @var \Organizations\Entity\Organization $organization */
        $jobRepository = $this->jobRepository;
        $results = $queryBuilder->getQuery()->execute();

        $filters = [];
        foreach ($results->toArray() as $organization) {
            if ($organization->getProfileSetting()==Organization::PROFILE_ACTIVE_JOBS) {
                $qb = $jobRepository->createQueryBuilder();
                $qb
                    ->field('organization')->equals($organization->getId())
                    ->field('status.name')->notIn([StatusInterface::EXPIRED, StatusInterface::INACTIVE])
                    ->field('isDraft')->notEqual(true)
                ;
                // FIXME: count method
                $count = count($qb->getQuery()->toArray());
                if ($count == 0) {
                    $filters[] = $organization->getId();
                }
            }
        }

        return $filters;
    }
}

1	<?php
2	/**
3	* YAWIK
4	*
5	* @copyright https://yawik.org/COPYRIGHT.php
6	* @license MIT
7	*/
8
9	namespace Organizations\Repository\Filter;
10
11	use Auth\AuthenticationService;
12	use Auth\Entity\UserInterface;
13	use Core\Repository\Filter\AbstractPaginationQuery;
14	use Jobs\Entity\StatusInterface;
15	use Organizations\Entity\Organization;
16	use Jobs\Repository\Job as JobRepository;
17	use Laminas\Stdlib\Parameters;
18
19	/**
20	* maps query parameters to entity attributes
21	*
22	* @package Organizations
23	* @author Mathias Weitz <weitz@cross-solution.de>
24	* @author Anthonius Munthi <me@itstoni.com>
25	*/
26	class PaginationQuery extends AbstractPaginationQuery
27	{
28	const PAGE_TYPE_PROFILE = 'profile';
29	const PAGE_TYPE_LIST = 'list';
30
31	/**
32	* Repository to query
33	*
34	* @var String
35	*/
36	protected $repositoryName="Organizations/Organization";
37
38	/**
39	* Sortable fields
40	*
41	* @var array
42	*/
43	protected $sortPropertiesMap = array(
44	'date' => 'dateCreated.date',
45	);
46
47	/**
48	* @var JobRepository
49	*/
50	protected $jobRepository;
51
52	/**
53	* @var AuthenticationService
54	*/
55	private $authService;
56
57	/**
58	* Constructs pagination query.
59	*
60	* @param JobRepository $jobRepository
61	* @param AuthenticationService $auth
62	*/
63	public function __construct(
64	JobRepository $jobRepository,
65	AuthenticationService $auth
66	) {
67	$this->jobRepository = $jobRepository;	1✔
68	$this->authService = $auth;	1✔
69	}
70
71	/**
72	* Creates a query for filtering organizations
73	*
74	* @see \Core\Repository\Filter\AbstractPaginationQuery::createQuery()
75	* @param $params
76	* @param \Doctrine\ODM\MongoDB\Query\Builder $queryBuilder
77	* @return mixed
78	*/
79	public function createQuery($params, $queryBuilder)
80	{
81	if ($params instanceof Parameters) {	1✔
82	$value = $params->toArray();	×
83	} else {
84	$value = $params;	1✔
85	}
86
87	/*
88	* if user is recruiter or admin
89	* filter query based on permissions.view
90	*/
91	$auth = $this->authService;	1✔
92	$user = $auth->getUser();	1✔
93	$ignored = [null,'guest',UserInterface::ROLE_USER];	1✔
94	if (!in_array($user->getRole(), $ignored)) {	1✔
95	$queryBuilder->field('permissions.view')->equals($user->getId());	1✔
96	}
97
98	if (isset($params['q']) && $params['q'] && $params['q'] != 'en/organizations/profile') {	1✔
99	$queryBuilder->text($params['q'])->language('none');	1✔
100	}
101
102	if (!isset($value['sort'])) {	1✔
103	$value['sort'] = '-date';	1✔
104	}
105
106	$queryBuilder->sort($this->filterSort($value['sort']));	1✔
107
108	if (isset($params['type']) && $params['type'] === 'profile') {	1✔
109	//@TODO: we should use aggregate query here
110	$queryBuilder->field('profileSetting')	×
111	->in([Organization::PROFILE_ALWAYS_ENABLE,Organization::PROFILE_ACTIVE_JOBS])	×
112	;
113
114	$filters = $this->getOrganizationProfileFilters($queryBuilder);	×
115	if (count($filters) > 0) {	×
116	$queryBuilder->field('id')->notIn($filters);	×
117	}
118	}
119
120	return $queryBuilder;	1✔
121	}
122
123	/**
124	* @param \Doctrine\ODM\MongoDB\Query\Builder $queryBuilder $queryBuilder
125	* @return array
126	*/
127	private function getOrganizationProfileFilters($queryBuilder)
128	{
129	/* @var \Organizations\Entity\Organization $organization */
130	$jobRepository = $this->jobRepository;	×
131	$results = $queryBuilder->getQuery()->execute();	×
132
133	$filters = [];	×
134	foreach ($results->toArray() as $organization) {	×
135	if ($organization->getProfileSetting()==Organization::PROFILE_ACTIVE_JOBS) {	×
136	$qb = $jobRepository->createQueryBuilder();	×
137	$qb
138	->field('organization')->equals($organization->getId())	×
139	->field('status.name')->notIn([StatusInterface::EXPIRED, StatusInterface::INACTIVE])	×
140	->field('isDraft')->notEqual(true)	×
141	;
142	// FIXME: count method
143	$count = count($qb->getQuery()->toArray());	×
144	if ($count == 0) {	×
145	$filters[] = $organization->getId();	×
146	}
147	}
148	}
149
150	return $filters;	×
151	}
152	}

cross-solution / YAWIK / 2156

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous