Permalink
Cannot retrieve contributors at this time
Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Sign up
Fetching contributors…
Cannot retrieve contributors at this time
| <?php | |
| /** | |
| * PageLoadUtils assists the SurvLoop-level routing processes in SurvRoutes and AdminController. | |
| * | |
| * SurvLoop - All Our Data Are Belong | |
| * @package wikiworldorder/survloop | |
| * @author Morgan Lesko <wikiworldorder@protonmail.com> | |
| * @since v0.0.18 | |
| */ | |
| namespace SurvLoop\Controllers; | |
| use DB; | |
| use Auth; | |
| use Cache; | |
| use Storage; | |
| use Illuminate\Http\Request; | |
| use Illuminate\Routing\Controller; | |
| use App\Models\User; | |
| use App\Models\SLNode; | |
| use App\Models\SLTree; | |
| use App\Models\SLDefinitions; | |
| use App\Models\SLSess; | |
| use SurvLoop\Controllers\Globals\GlobalsCache; | |
| use SurvLoop\Controllers\Globals\Globals; | |
| class PageLoadUtils extends Controller | |
| { | |
| protected $isAdminPage = false; | |
| public $dashPrfx = ''; | |
| public $domainPath = 'http://survloop.local'; | |
| public $custAbbr = 'SurvLoop'; | |
| public $dbID = 1; | |
| public $treeID = 1; | |
| public $cacheKey = ''; | |
| public $pageContent = ''; | |
| public function __construct($isAdminPage = false) | |
| { | |
| $this->isAdminPage = $isAdminPage; | |
| if ($isAdminPage) { | |
| $this->dashPrfx = '/dash'; | |
| } | |
| } | |
| public function loadDomain() | |
| { | |
| $appUrl = SLDefinitions::select('DefDescription') | |
| ->where('DefDatabase', 1) | |
| ->where('DefSet', 'System Settings') | |
| ->where('DefSubset', 'app-url') | |
| ->first(); | |
| if ($appUrl && isset($appUrl->DefDescription)) { | |
| $this->domainPath = $appUrl->DefDescription; | |
| } | |
| return $this->domainPath; | |
| } | |
| public function checkHttpsDomain(Request $request) | |
| { | |
| if (isset($this->domainPath) | |
| && strpos($request->fullUrl(), $this->domainPath) === false) { | |
| $pos1 = strpos($this->domainPath, 'https://'); | |
| $pos2 = strpos($request->fullUrl(), | |
| str_replace('https://', 'http://', $this->domainPath)); | |
| if ($pos1 !== false && $pos2 !== false) { | |
| header("Location: " . str_replace('http://', 'https://', | |
| $request->fullUrl())); | |
| exit; | |
| } | |
| } | |
| return true; | |
| } | |
| public function loadAbbr() | |
| { | |
| $chk = SLDefinitions::select('DefDescription') | |
| ->where('DefDatabase', 1) | |
| ->where('DefSet', 'System Settings') | |
| ->where('DefSubset', 'cust-abbr') | |
| ->first(); | |
| if ($chk && isset($chk->DefDescription)) { | |
| $this->custAbbr = trim($chk->DefDescription); | |
| } | |
| return $this->custAbbr; | |
| } | |
| public function syncDataTrees(Request $request, $dbID = 1, $treeID = 1) | |
| { | |
| $this->dbID = $dbID; | |
| $this->treeID = $treeID; | |
| $GLOBALS["SL"] = new Globals($request, $dbID, $treeID, $treeID); | |
| return true; | |
| } | |
| protected function userHasTreePerms($treeOpts = 1) | |
| { | |
| if ($treeOpts%Globals::TREEOPT_ADMIN == 0) { | |
| return $this->isUserAdmin(); | |
| } | |
| if ($treeOpts%Globals::TREEOPT_STAFF == 0) { | |
| return ($this->isUserStaff() || $this->isUserAdmin()); | |
| } | |
| if ($treeOpts%Globals::TREEOPT_PARTNER == 0) { | |
| return ($this->isUserPartn() | |
| || $this->isUserStaff() || $this->isUserAdmin()); | |
| } | |
| if ($treeOpts%Globals::TREEOPT_VOLUNTEER == 0) { | |
| return ($this->isUserVolun() || $this->isUserPartn() | |
| || $this->isUserStaff() || $this->isUserAdmin()); | |
| } | |
| return true; | |
| } | |
| public function getMaxPermsPrime() | |
| { | |
| $ret = ((!Auth::user() || !isset(Auth::user()->id)) ? -1 : 0); | |
| if (Auth::user()) { | |
| if (Auth::user()->hasRole('administrator')) { | |
| $ret = Globals::TREEOPT_ADMIN; | |
| } elseif (Auth::user()->hasRole('staff|databaser|brancher')) { | |
| $ret = Globals::TREEOPT_STAFF; | |
| } elseif (Auth::user()->hasRole('partner')) { | |
| $ret = Globals::TREEOPT_PARTNER; | |
| } elseif (Auth::user()->hasRole('volunteer')) { | |
| $ret = Globals::TREEOPT_VOLUNTEER; | |
| } | |
| } | |
| return $ret; | |
| } | |
| public function getPermOpts() | |
| { | |
| $ret = []; | |
| if (Auth::user() && isset(Auth::user()->id) && intVal(Auth::user()->id) > 0) { | |
| $list = 'administrator'; | |
| if (Auth::user()->hasRole($list)) { | |
| $ret[] = Globals::TREEOPT_ADMIN; | |
| } | |
| $list .= '|staff|databaser|brancher'; | |
| if (Auth::user()->hasRole($list)) { | |
| $ret[] = Globals::TREEOPT_STAFF; | |
| } | |
| $list .= '|partner'; | |
| if (Auth::user()->hasRole($list)) { | |
| $ret[] = Globals::TREEOPT_PARTNER; | |
| } | |
| $list .= '|volunteer'; | |
| if (Auth::user()->hasRole($list)) { | |
| $ret[] = Globals::TREEOPT_VOLUNTEER; | |
| } | |
| } | |
| return $ret; | |
| } | |
| public function getPageDashPrefix($treeOpts = 1) | |
| { | |
| if ($treeOpts%Globals::TREEOPT_ADMIN == 0 | |
| || $treeOpts%Globals::TREEOPT_STAFF == 0 | |
| || $treeOpts%Globals::TREEOPT_PARTNER == 0 | |
| || $treeOpts%Globals::TREEOPT_VOLUNTEER == 0) { | |
| return '/dash'; | |
| } | |
| return ''; | |
| } | |
| public function chkNoTreePerms($tree) | |
| { | |
| if (!$tree || !isset($tree->TreeOpts)) { | |
| return false; | |
| } | |
| return ($tree->TreeOpts%Globals::TREEOPT_ADMIN > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_STAFF > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_PARTNER > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_VOLUNTEER > 0); | |
| } | |
| public function loadTreeByID(Request $request, $treeID = -3) | |
| { | |
| if (intVal($treeID) > 0) { | |
| $tree = SLTree::find($treeID); | |
| if ($tree && isset($tree->TreeOpts)) { | |
| if ($this->okToLoadTree($tree->TreeOpts)) { | |
| $this->syncDataTrees( | |
| $request, | |
| $tree->TreeDatabase, | |
| $treeID | |
| ); | |
| return true; | |
| } | |
| } | |
| } | |
| return false; | |
| } | |
| public function hasParamEdit(Request $request) | |
| { | |
| return ($request->has('edit') | |
| && intVal($request->get('edit')) == 1); | |
| } | |
| public function loadTreeBySlug(Request $request, $treeSlug = '', $type = 'Survey') | |
| { | |
| if (trim($treeSlug) != '') { | |
| $urlTrees = SLTree::where('TreeType', $type) | |
| ->where('TreeSlug', $treeSlug) | |
| ->orderBy('TreeID', 'asc') | |
| ->get(); | |
| if ($urlTrees->isNotEmpty()) { | |
| foreach ($urlTrees as $t) { | |
| if ($t && isset($t->TreeOpts) | |
| && $this->okToLoadTree($t->TreeOpts)) { | |
| $this->syncDataTrees( | |
| $request, | |
| $t->TreeDatabase, | |
| $t->TreeID | |
| ); | |
| return true; | |
| } | |
| } | |
| } | |
| } | |
| return false; | |
| } | |
| public function searchRun(Request $request) | |
| { | |
| $searchTree = null; | |
| if ($request->has('searchData') && is_array($request->get('searchData'))) { | |
| $perms = $this->getPermOpts(); | |
| $searchDataTbl = $request->get('searchData'); | |
| if (sizeof($searchDataTbl) == 1 && intVal($searchDataTbl[0]) > 0) { | |
| $trees = DB::table('SL_Tree') | |
| ->join('SL_Node', function ($join) { | |
| $join->on('SL_Tree.TreeID', '=', 'SL_Node.NodeTree') | |
| ->where('SL_Node.NodeParentID', '<=', 0) | |
| ->where('SL_Node.NodeType', 'Page'); | |
| }) | |
| ->where('SL_Tree.TreeType', 'Page') | |
| ->where('SL_Tree.TreeCoreTable', intVal($searchDataTbl[0])) | |
| ->select('SL_Tree.*', 'SL_Node.NodeResponseSet') | |
| ->get(); | |
| $searchTree = $this->chkSearchRunTrees($trees, $perms); | |
| } | |
| if ($searchTree === null) { | |
| $trees = SLTree::where('TreeType', 'Page') | |
| ->get(); | |
| $searchTree = $this->chkSearchRunTrees($trees, $perms); | |
| } | |
| if ($searchTree !== null | |
| && isset($searchTree->TreeOpts)) { | |
| $redir = $this->getPageDashPrefix($searchTree->TreeOpts) | |
| . '/' . $searchTree->TreeSlug | |
| . '?s=' . (($request->has('s')) | |
| ? $request->get('s') : ''); | |
| if ($request->has('sFilt') | |
| && trim($request->get('sFilt')) != '') { | |
| $redir .= '&sFilt=' . $request->get('sFilt'); | |
| } | |
| if ($request->has('sSort') | |
| && trim($request->get('sSort')) != '') { | |
| $redir .= '&sSort=' . $request->get('sSort'); | |
| } | |
| if ($request->has('sSortDir') | |
| && trim($request->get('sSortDir')) != '') { | |
| $redir .= '&sSortDir=' . $request->get('sSortDir'); | |
| } | |
| if ($request->has('sView') | |
| && trim($request->get('sView')) != '') { | |
| $redir .= '&sView=' . $request->get('sView'); | |
| } | |
| return redirect($redir); | |
| } | |
| } | |
| $this->loadDomain(); | |
| return redirect($this->domainPath . '/'); | |
| } | |
| protected function chkSearchRunTrees($trees, $perms) | |
| { | |
| $searchTree = $searchTreeHome = null; | |
| if ($trees->isNotEmpty()) { | |
| if (sizeof($perms) > 0) { | |
| foreach ($perms as $perm) { | |
| if ($searchTree === null) { | |
| foreach ($trees as $tree) { | |
| if ($searchTree === null | |
| && $tree->TreeOpts%$perm == 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_SEARCH == 0) { | |
| if ($tree->TreeOpts%Globals::TREEOPT_HOMEPAGE == 0) { | |
| $searchTreeHome = $tree; | |
| } else { | |
| $searchTree = $tree; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| } | |
| if ($searchTree === null) { | |
| foreach ($trees as $tree) { | |
| if ($searchTree === null | |
| && $tree->TreeOpts%Globals::TREEOPT_SEARCH == 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_ADMIN > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_STAFF > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_PARTNER > 0 | |
| && $tree->TreeOpts%Globals::TREEOPT_VOLUNTEER > 0) { | |
| if ($tree->TreeOpts%Globals::TREEOPT_HOMEPAGE == 0) { | |
| $searchTreeHome = $tree; | |
| } else { | |
| $searchTree = $tree; | |
| } | |
| } | |
| } | |
| } | |
| } | |
| if ($searchTree === null && $searchTreeHome !== null) { | |
| $searchTree = $searchTreeHome; | |
| } | |
| return $searchTree; | |
| } | |
| protected function chkPageRedir($treeSlug = '') | |
| { | |
| if (trim($treeSlug) != '') { | |
| $redirTree = SLTree::where('TreeSlug', $treeSlug) | |
| ->where('TreeType', 'Redirect') | |
| ->orderBy('TreeID', 'asc') | |
| ->first(); | |
| if ($redirTree && isset($redirTree->TreeDesc) | |
| && trim($redirTree->TreeDesc) != '') { | |
| $redirURL = $redirTree->TreeDesc; | |
| if (strpos($redirURL, $this->domainPath) === false | |
| && substr($redirURL, 0, 1) != '/' | |
| && strpos($redirURL, 'http://') === false | |
| && strpos($redirURL, 'https://') === false) { | |
| $redirURL = '/' . $redirURL; | |
| } | |
| return $redirURL; | |
| } | |
| } | |
| return $treeSlug; | |
| } | |
| public function loadNodeTreeURL(Request $request, $treeSlug = '') | |
| { | |
| return $this->loadNodeTreeURLInner($request, $treeSlug); | |
| } | |
| public function loadNodeTreeURLedit(Request $request, $cid = -3, $treeSlug = '') | |
| { | |
| return $this->loadNodeTreeURLInner($request, $treeSlug, $cid); | |
| } | |
| public function loadNodeTreeURLInner(Request $request, $treeSlug = '', $cid = -3) | |
| { | |
| $this->loadDomain(); | |
| $this->checkHttpsDomain($request); | |
| if (trim($treeSlug) != '') { | |
| $urlTrees = SLTree::where('TreeSlug', $treeSlug) | |
| ->get(); | |
| if ($urlTrees->isNotEmpty()) { | |
| foreach ($urlTrees as $t) { | |
| if ($t && isset($t->TreeOpts) | |
| && $this->okToLoadTree($t->TreeOpts)) { | |
| $rootNode = SLNode::find($t->TreeFirstPage); | |
| if ($rootNode && isset($t->TreeSlug) | |
| && isset($rootNode->NodePromptNotes)) { | |
| return $this->loadNodeTreeURLredir( | |
| $request, | |
| $t, | |
| $rootNode, | |
| $cid | |
| ); | |
| } | |
| } | |
| } | |
| } | |
| } | |
| return redirect($this->domainPath . '/'); | |
| } | |
| protected function loadNodeTreeURLredir(Request $request, $tree, $rootNode, $cid = -3) | |
| { | |
| $redir = $this->dashPrfx . '/u/' . $tree->TreeSlug | |
| . '/' . $rootNode->NodePromptNotes; | |
| if ($cid > 0) { | |
| $redir .= '?cid=' . $cid; | |
| } else { | |
| $redir .= '?start=1&new=' . rand(100000000, 1000000000); | |
| } | |
| $paramTxt = str_replace($this->domainPath . '/start/' . $tree->TreeSlug, '', | |
| str_replace($this->domainPath . '/dashboard/start/' . $tree->TreeSlug, '', | |
| $request->fullUrl())); | |
| if (substr($paramTxt, 0, 1) == '/') { | |
| $paramTxt = substr($paramTxt, 1); | |
| } | |
| if (trim($paramTxt) != '' && substr($paramTxt, 0, 1) == '?') { | |
| $redir .= '&' . substr($paramTxt, 1); | |
| } | |
| if (intVal($cid) > 0) { | |
| $this->loadPageCID($request, $tree, $cid); | |
| } | |
| return redirect($this->domainPath . $redir); | |
| } | |
| public function loadPageCID(Request $request, $tree, $cid) | |
| { | |
| if ($cid > 0 && $tree | |
| && isset($tree->TreeID)) { | |
| $sess = SLSess::where('SessUserID', | |
| Auth::user()->id) | |
| ->where('SessTree', $tree->TreeID) | |
| ->where('SessCoreID', $cid) | |
| ->where('SessIsActive', 1) | |
| ->orderBy('updated_at', 'desc') | |
| ->first(); | |
| if (!$sess || !isset($sess->SessID)) { | |
| $sess = new SLSess; | |
| $sess->SessUserID = Auth::user()->id; | |
| $sess->SessTree = $tree->TreeID; | |
| $sess->SessCoreID = $cid; | |
| $sess->SessIsActive = 1; | |
| $sess->save(); | |
| } | |
| if ($request->has("n") | |
| && intVal($request->get("n")) > 0) { | |
| $sess->update([ | |
| 'SessCurrNode' => intVal($request->get("n")) | |
| ]); | |
| } elseif ($sess->SessCurrNode == -86) { | |
| // last session deactivate (hopefully completed) | |
| $sess->update([ 'SessCurrNode' => $tree->TreeRoot ]); | |
| } | |
| session()->put('sessID' . $tree->TreeID, $sess->SessID); | |
| session()->put('coreID' . $tree->TreeID, $cid); | |
| } | |
| return true; | |
| } | |
| public function loadPageURLrawID(Request $request, $pageSlug = '', $cid = -3, $view = '') | |
| { | |
| return $this->loadPageURL($request, $pageSlug, $cid, $view, true); | |
| } | |
| protected function chkGenCacheKey() | |
| { | |
| if (trim($this->cacheKey) == '') { | |
| return $this->topGenCacheKey(); | |
| } | |
| return $this->cacheKey; | |
| } | |
| protected function topGenCacheKey() | |
| { | |
| $sffx = '-visitor'; | |
| if ($this->isUserAdmin()) { | |
| $sffx = '-admin'; | |
| } elseif ($this->isUserStaff()) { | |
| $sffx = '-staff'; | |
| } elseif ($this->isUserPartn()) { | |
| $sffx = '-partner'; | |
| } elseif ($this->isUserVolun()) { | |
| $sffx = '-volun'; | |
| } elseif (Auth::user() && Auth::user()->id > 0) { | |
| $sffx = '-user'; | |
| } | |
| if (isset($GLOBALS["SL"])) { | |
| $sffx .= $GLOBALS["SL"]->getCacheSffxAdds(); | |
| $GLOBALS["SL"]->cacheSffx = $sffx; | |
| } | |
| $uri = substr(str_replace('?refresh=1', '', | |
| str_replace('&refresh=1', '', | |
| $_SERVER["REQUEST_URI"])), 1); | |
| $this->cacheKey = 'page-' . $uri . $sffx . '.html'; | |
| return $this->cacheKey; | |
| } | |
| public function topCheckCache(Request $request, $type = '') | |
| { | |
| $this->topGenCacheKey(); | |
| $cache = new GlobalsCache; | |
| if ($request->has('refresh')) { | |
| $cache->forgetCache($this->cacheKey, $type); | |
| return false; | |
| } | |
| $content = $cache->chkCache($this->cacheKey, $type); | |
| if (!$this->checkCacheProblem($content, $type)) { | |
| $this->pageContent = $content; | |
| return true; | |
| } | |
| return false; | |
| } | |
| public function checkCacheProblem($content = '', $type = '') | |
| { | |
| if (trim(strip_tags($content)) == '') { | |
| return true; | |
| } | |
| $cache = new GlobalsCache; | |
| $problem = false; | |
| $pos = strpos($content, 'id="dynCss"'); | |
| if ($pos > 0) { | |
| $pos = strpos($content, '/sys/dyna/', $pos); | |
| $pos2 = strpos($content, '"', $pos); | |
| if ($pos > 0 && $pos2 > 0) { | |
| $file = substr($content, $pos+10, $pos2-$pos-10); | |
| $chk = trim($cache->getCachePageCss($file)); | |
| if ($chk == '') { | |
| $problem = true; | |
| } | |
| } | |
| } | |
| $pos = strpos($content, 'id="dynJs"'); | |
| if ($pos > 0) { | |
| $pos = strpos($content, '/sys/dyna/', $pos); | |
| $pos2 = strpos($content, '"', $pos); | |
| if ($pos > 0 && $pos2 > 0) { | |
| $file = substr($content, $pos+10, $pos2-$pos-10); | |
| $chk = trim($cache->getCachePageJs($file)); | |
| if ($chk == '') { | |
| $problem = true; | |
| } | |
| } | |
| } | |
| return $problem; | |
| } | |
| protected function topSaveCache($treeID = 0, $treeType = '') | |
| { | |
| $this->chkGenCacheKey(); | |
| $cache = new GlobalsCache; | |
| $cache->putCache( | |
| $this->cacheKey, | |
| $this->pageContent, | |
| $treeType, | |
| $treeID, | |
| ((isset($GLOBALS["SL"]->coreID)) | |
| ? $GLOBALS["SL"]->coreID : 0) | |
| ); | |
| return true; | |
| } | |
| public function addAdmCodeToPage($pageContent) | |
| { | |
| $extra = ''; | |
| if (Auth::user() && isset(Auth::user()->id) | |
| && Auth::user()->hasRole('administrator|staff|brancher')) { | |
| $extra .= ' setTimeout(\'addSideNavItem(' | |
| . '"Edit Page", "?edit=1")\', 2000); '; | |
| } | |
| if (trim($extra) != '') { | |
| $extra = '<script async defer type="text/javascript"> ' | |
| . $extra . ' </script>'; | |
| } | |
| return str_replace("</body>", $extra . "\n</body>", $pageContent); | |
| } | |
| public function addSessAdmCodeToPage(Request $request, $pageContent) | |
| { | |
| if (!isset($GLOBALS["SL"])) { | |
| $this->syncDataTrees($request, 1, 1); | |
| } | |
| return $this->addAdmCodeToPage($GLOBALS["SL"]->swapSessMsg($pageContent)); | |
| } | |
| protected function okToLoadTree($treeOpts = 1) | |
| { | |
| return ($this->treeRightType($treeOpts) | |
| && $this->userHasTreePerms($treeOpts)); | |
| } | |
| protected function treeRightType($treeOpts = 1) | |
| { | |
| if ($this->isAdminPage) { | |
| return ($treeOpts%Globals::TREEOPT_ADMIN == 0 | |
| || $treeOpts%Globals::TREEOPT_STAFF == 0 | |
| || $treeOpts%Globals::TREEOPT_PARTNER == 0 | |
| || $treeOpts%Globals::TREEOPT_VOLUNTEER == 0); | |
| } | |
| return ($treeOpts%Globals::TREEOPT_ADMIN > 0 | |
| && $treeOpts%Globals::TREEOPT_STAFF > 0 | |
| && $treeOpts%Globals::TREEOPT_PARTNER > 0 | |
| && $treeOpts%Globals::TREEOPT_VOLUNTEER > 0); | |
| } | |
| public function isUserAdmin() | |
| { | |
| return (Auth::user() && Auth::user()->hasRole('administrator')); | |
| } | |
| protected function isUserStaff() | |
| { | |
| return (Auth::user() && Auth::user()->hasRole('staff')); | |
| } | |
| protected function isUserVolun() | |
| { | |
| return (Auth::user() && Auth::user()->hasRole('volunteer')); | |
| } | |
| protected function isUserPartn() | |
| { | |
| return (Auth::user() && Auth::user()->hasRole('partner')); | |
| } | |
| protected function urlNotResourceFile($str) | |
| { | |
| $types = [ | |
| 'css', | |
| 'js', | |
| 'png', | |
| 'jpg', | |
| 'jpeg', | |
| 'gif', | |
| 'svg', | |
| 'woff', | |
| 'woff2' | |
| ]; | |
| $str = trim($str); | |
| if ($str == '') { | |
| return false; | |
| } | |
| $dot = strrpos($str, '.'); | |
| if ($dot > 0) { | |
| $sffx = substr($str, $dot); | |
| if (in_array(strtolower($sffx), $types)) { | |
| return false; | |
| } | |
| } | |
| return true; | |
| } | |
| } |