Passed
Push — master ( 0deb8f...f54565 )
by Goffy
04:13
created

index.php (2 issues)

Labels
Severity
1
<?php
2
/*
3
 You may not change or alter any portion of this comment or credits
4
 of supporting developers from this source code or any supporting source code
5
 which is considered copyrighted (c) material of the original comment or credit authors.
6
7
 This program is distributed in the hope that it will be useful,
8
 but WITHOUT ANY WARRANTY; without even the implied warranty of
9
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10
*/
11
12
/**
13
 * wgGitHub module for xoops
14
 *
15
 * @copyright      2020 XOOPS Project (https://xooops.org)
16
 * @license        GPL 2.0 or later
17
 * @package        wggithub
18
 * @since          1.0
19
 * @min_xoops      2.5.10
20
 * @author         Goffy - XOOPS Development Team - Email:<[email protected]> - Website:<https://wedega.com>
21
 */
22
23
use Xmf\Request;
24
use XoopsModules\Wggithub;
25
use XoopsModules\Wggithub\{
26
    Constants,
27
    Helper,
28
    Github\Github,
29
    Github\Repositories,
30
    Github\Releases
31
};
32
33
require __DIR__ . '/header.php';
34
$GLOBALS['xoopsOption']['template_main'] = 'wggithub_index.tpl';
35
include_once \XOOPS_ROOT_PATH . '/header.php';
36
37
// Permissions
38
$permGlobalView = $permissionsHandler->getPermGlobalView();
39
if (!$permGlobalView) {
40
    $GLOBALS['xoopsTpl']->assign('error', _NOPERM);
41
    require __DIR__ . '/footer.php';
42
}
43
$permGlobalRead = $permissionsHandler->getPermGlobalRead();
44
$permReadmeUpdate = $permissionsHandler->getPermReadmeUpdate();
45
46
$op            = Request::getCmd('op', 'list');
47
$filterRelease = Request::getString('release', 'all');
48
$filterSortby  = Request::getString('sortby', 'update');
49
50
$GLOBALS['xoopsTpl']->assign('release', $filterRelease);
51
$GLOBALS['xoopsTpl']->assign('sortby', $filterSortby);
52
53
// Define Stylesheet
54
$GLOBALS['xoTheme']->addStylesheet($style, null);
55
$GLOBALS['xoTheme']->addStylesheet(WGGITHUB_URL . '/assets/css/tabs.css', null);
56
$keywords = [];
57
// 
58
$GLOBALS['xoopsTpl']->assign('xoops_icons32_url', XOOPS_ICONS32_URL);
59
$GLOBALS['xoopsTpl']->assign('wggithub_url', WGGITHUB_URL);
60
$GLOBALS['xoopsTpl']->assign('wggithub_image_url', WGGITHUB_IMAGE_URL);
61
//
62
$GLOBALS['xoopsTpl']->assign('permReadmeUpdate', $permissionsHandler->getPermReadmeUpdate());
63
64
switch ($op) {
65
    case 'show':
66
    case 'list':
67
    case 'apiexceed':
68
    default:
69
        //check number of API calls
70
        $crRequests = new \CriteriaCompo();
0 ignored issues
show
The type CriteriaCompo was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
71
        $crRequests->add(new \Criteria('req_datecreated', (time() - 3600), '>'));
0 ignored issues
show
The type Criteria was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
72
        $requestsCount = $requestsHandler->getCount($crRequests);
73
        if ($permGlobalRead && $requestsCount < 60 && 'list' == $op) {
74
            executeUpdate();
75
        }
76
77
        unset($crRequests);
78
        $crRequests = new \CriteriaCompo();
79
        $crRequests->add(new \Criteria('req_result', 'OK'));
80
        $crRequests->setStart(0);
81
        $crRequests->setLimit(1);
82
        $crRequests->setSort('req_id');
83
        $crRequests->setOrder('DESC');
84
        $requestsAll = $requestsHandler->getAll($crRequests);
85
        foreach (\array_keys($requestsAll) as $i) {
86
            $lastUpdate = $requestsAll[$i]->getVar('req_datecreated');
87
            $GLOBALS['xoopsTpl']->assign('lastUpdate', \formatTimestamp($lastUpdate, 'm'));
88
        }
89
        unset($crRequests);
90
        $crRequests = new \CriteriaCompo();
91
        $crRequests->setStart(0);
92
        $crRequests->setLimit(1);
93
        $crRequests->setSort('req_id');
94
        $crRequests->setOrder('DESC');
95
        $requestsAll = $requestsHandler->getAll($crRequests);
96
        foreach (\array_keys($requestsAll) as $i) {
97
            if ($lastUpdate < $requestsAll[$i]->getVar('req_datecreated')) {
98
                if (\strpos($requestsAll[$i]->getVar('req_result'), 'API rate limit exceeded') > 0) {
99
                    $GLOBALS['xoopsTpl']->assign('apiexceed', true);
100
                } else {
101
                    $GLOBALS['xoopsTpl']->assign('apierror', true);
102
                }
103
            }
104
        }
105
        unset($crRequests);
106
107
        $github = Github::getInstance();
108
        $start = Request::getInt('start', 0);
109
        $limit = Request::getInt('limit', $helper->getConfig('userpager'));
110
        $menu  = Request::getInt('menu', 0);
111
112
        $crDirectories = new \CriteriaCompo();
113
        $crDirectories->add(new \Criteria('dir_online', 1));
114
        $directoriesCount = $directoriesHandler->getCount($crDirectories);
115
        $GLOBALS['xoopsTpl']->assign('directoriesCount', $directoriesCount);
116
        if ($directoriesCount > 0) {
117
            $directoriesAll = $directoriesHandler->getAll($crDirectories);
118
            // Get All Directories
119
            $directories = [];
120
            foreach (\array_keys($directoriesAll) as $i) {
121
                $directories[$i] = $directoriesAll[$i]->getValuesDirectories();
122
                $dirName = $directoriesAll[$i]->getVar('dir_name');
123
                $dirFilterRelease = (bool)$directoriesAll[$i]->getVar('dir_filterrelease');
124
                $repos = [];
125
                $crRepositories = new \CriteriaCompo();
126
                $crRepositories->add(new \Criteria('repo_user', $dirName));
127
                $repositoriesCountTotal = $repositoriesHandler->getCount($crRepositories);
128
                if ('any' === $filterRelease && $dirFilterRelease) {
129
                    $crRepositories->add(new \Criteria('repo_prerelease', 1) );
130
                    $crRepositories->add(new \Criteria('repo_release', 1), 'OR');
131
                }
132
                if ('final' === $filterRelease && $dirFilterRelease) {
133
                    $crRepositories->add(new \Criteria('repo_release', 1));
134
                }
135
                $repositoriesCount = $repositoriesHandler->getCount($crRepositories);
136
                $crRepositories->setStart($start);
137
                $crRepositories->setLimit($limit);
138
                switch ($filterSortby) {
139
                    case 'name':
140
                    default:
141
                        $crRepositories->setSort('repo_name');
142
                        $crRepositories->setOrder('ASC');
143
                        break;
144
                    case 'update':
145
                        $crRepositories->setSort('repo_updatedat');
146
                        $crRepositories->setOrder('DESC');
147
                        break;
148
                }
149
                if ($repositoriesCount > 0) {
150
                    $repositoriesAll = $repositoriesHandler->getAll($crRepositories);
151
                    foreach (\array_keys($repositoriesAll) as $j) {
152
                        $repoId = $repositoriesAll[$j]->getVar('repo_id');
153
                        $repos[$j] = $repositoriesAll[$j]->getValuesRepositories();
154
                        $repos[$j]['readme'] = ['content_clean' => _MA_WGGITHUB_README_NOFILE];
155
                        if ($repositoriesAll[$j]->getVar('repo_readme') > 0) {
156
                            $crReadmes = new \CriteriaCompo();
157
                            $crReadmes->add(new \Criteria('rm_repoid', $repoId));
158
                            $readmesAll = $readmesHandler->getAll($crReadmes);
159
                            foreach ($readmesAll as $readme) {
160
                                $repos[$j]['readme'] = $readme->getValuesReadmes();
161
                            }
162
                            unset($crReadmes, $readmesAll);
163
                        }
164
                        if ($repositoriesAll[$j]->getVar('repo_prerelease') > 0 || $repositoriesAll[$j]->getVar('repo_release') > 0) {
165
                            //$repos[$j]['releases'] = [];
166
                            $crReleases = new \CriteriaCompo();
167
                            $crReleases->add(new \Criteria('rel_repoid', $repoId));
168
                            $releasesAll = $releasesHandler->getAll($crReleases);
169
                            foreach ($releasesAll as $release) {
170
                                $repos[$j]['releases'][] = $release->getValuesReleases();
171
                            }
172
                            unset($crReleases, $releasesAll);
173
                        }
174
                    }
175
                    unset($crRepositories, $repositoriesAll);
176
                }
177
                if ($repositoriesCount === $repositoriesCountTotal) {
178
                    $directories[$i]['countRepos'] = str_replace(['%s', '%t'], [$dirName, $repositoriesCountTotal], _MA_WGGITHUB_REPOSITORIES_COUNT2);
179
                } else {
180
                    $directories[$i]['countRepos'] = str_replace(['%s', '%r', '%t'], [$dirName, $repositoriesCount, $repositoriesCountTotal], _MA_WGGITHUB_REPOSITORIES_COUNT1);
181
                }
182
                $directories[$i]['repos'] = $repos;
183
                $directories[$i]['previousRepos'] = $start > 0;
184
                $directories[$i]['previousOp'] = '&amp;start=' . ($start - $limit) . '&amp;limit=' . $limit . '&amp;release=' . $filterRelease . '&amp;sortby=' . $filterSortby;
185
                $directories[$i]['nextRepos'] = ($repositoriesCount - $start) > $limit;
186
                $directories[$i]['nextOp'] = '&amp;start=' . ($start + $limit) . '&amp;limit=' . $limit . '&amp;release=' . $filterRelease . '&amp;sortby=' . $filterSortby;
187
                $GLOBALS['xoopsTpl']->assign('start', $start);
188
                $GLOBALS['xoopsTpl']->assign('limit', $limit);
189
                $GLOBALS['xoopsTpl']->assign('menu', $menu);
190
191
                $GLOBALS['xoopsTpl']->assign('directories', $directories);
192
            }
193
194
            unset($crDirectories, $directories);
195
            // Display Navigation
196
            if ($directoriesCount > $limit) {
197
                include_once \XOOPS_ROOT_PATH . '/class/pagenav.php';
198
                $pagenav = new \XoopsPageNav($directoriesCount, $limit, $start, 'start', 'op=list&limit=' . $limit);
199
                $GLOBALS['xoopsTpl']->assign('pagenav', $pagenav->renderNav(4));
200
            }
201
            $GLOBALS['xoopsTpl']->assign('lang_thereare', \sprintf(\_MA_WGGITHUB_INDEX_THEREARE, $directoriesCount));
202
            $GLOBALS['xoopsTpl']->assign('divideby', $helper->getConfig('divideby'));
203
            $GLOBALS['xoopsTpl']->assign('numb_col', $helper->getConfig('numb_col'));
204
        }
205
206
        break;
207
    case 'update':
208
        // Permissions
209
        if (!$permGlobalRead) {
210
            $GLOBALS['xoopsTpl']->assign('error', _NOPERM);
211
            require __DIR__ . '/footer.php';
212
        }
213
        executeUpdate();
214
        break;
215
    case 'update_readme':
216
        // Permissions
217
        if (!$permReadmeUpdate) {
218
            $GLOBALS['xoopsTpl']->assign('error', _NOPERM);
219
            require __DIR__ . '/footer.php';
220
        }
221
        $repoId = Request::getInt('repo_id', 0);
222
        $repoUser  = Request::getString('repo_user', 'none');
223
        $repoName  = Request::getString('repo_name', 'none');
224
        $res = $helper->getHandler('Readmes')->updateReadmes($repoId, $repoUser, $repoName);
225
        break;
226
}
227
228
$GLOBALS['xoopsTpl']->assign('table_type', $helper->getConfig('table_type'));
229
// Breadcrumbs
230
$xoBreadcrumbs[] = ['title' => \_MA_WGGITHUB_INDEX];
231
// Keywords
232
wggithubMetaKeywords($helper->getConfig('keywords') . ', ' . \implode(',', $keywords));
233
unset($keywords);
234
// Description
235
wggithubMetaDescription(\_MA_WGGITHUB_INDEX_DESC);
236
$GLOBALS['xoopsTpl']->assign('xoops_mpageurl', WGGITHUB_URL.'/index.php');
237
$GLOBALS['xoopsTpl']->assign('xoops_icons32_url', XOOPS_ICONS32_URL);
238
$GLOBALS['xoopsTpl']->assign('wggithub_upload_url', WGGITHUB_UPLOAD_URL);
239
require __DIR__ . '/footer.php';
240
241
242
243
/**
244
 * Execute update of repositories and all related tables
245
 *
246
 * @return bool
247
 */
248
function executeUpdate(){
249
250
    $github = Github::getInstance();
251
    $helper = Helper::getInstance();
252
    $directoriesHandler = $helper->getHandler('Directories');
253
    $releasesHandler = $helper->getHandler('Releases');
254
    $readmesHandler = $helper->getHandler('Readmes');
255
    $crDirectories = new \CriteriaCompo();
256
    $crDirectories->add(new \Criteria('dir_autoupdate', 1));
257
    $crDirectories->add(new \Criteria('dir_online', 1));
258
    $directoriesAll = $directoriesHandler->getAll($crDirectories);
259
    // Get All Directories
260
    $directories = [];
261
    foreach (\array_keys($directoriesAll) as $i) {
262
        $directories[$i] = $directoriesAll[$i]->getValuesDirectories();
263
        if (1 === (int) $directoriesAll[$i]->getVar('dir_autoupdate')) {
264
            $dirName = $directoriesAll[$i]->getVar('dir_name');
265
            $repos = [];
266
            for ($j = 1; $j <= 9; $j++) {
267
                $repos[$j] = [];
268
                if (Constants::DIRECTORY_TYPE_ORG == $directoriesAll[$i]->getVar('dir_type')) {
269
                    $repos = $github->readOrgRepositories($dirName, 100, $j);
270
                } else {
271
                    $repos = $github->readUserRepositories($dirName, 100, $j);
272
                }
273
                if (false === $repos) {
274
                    return false;
275
                    break 1;
276
                }
277
                if (count($repos) > 0) {
278
                    $github->updateTableRepositories($dirName, $repos, true);
279
                } else {
280
                    break 1;
281
                }
282
                if (count($repos) < 100) {
283
                    break 1;
284
                }
285
            }
286
        }
287
    }
288
    unset($directories);
289
290
    $releasesHandler->updateRepoReleases();
291
    $readmesHandler->updateRepoReadme();
292
293
294
    return true;
295
}
296