Page.php | searchcode

/api/db/Page.php

https://gitlab.com/x33n/respond
PHP | 788 lines | 536 code | 225 blank | 27 comment | 16 complexity | 3e054110ff3c7883bff5ffc4d70a6774 MD5 | raw file

<?php

// Page DAO
class Page{
    
	// adds a page
	public static function Add($friendlyId, $name, $description, $layout, $stylesheet, $pageTypeId, $siteId, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
    		
    		$pageId = uniqid();
            
            // cleanup friendlyid (escape, trim, remove spaces, tolower)
        	$friendlyId = trim($friendlyId);
    		$friendlyId = str_replace(' ', '', $friendlyId);
    		$friendlyId = strtolower($friendlyId);
    
    		// set defaults
    		$isActive = 0;
    		$image = '';
    		$keywords = '';
    		$tags = '';
    		$callout = '';
    		$timestamp = gmdate("Y-m-d H:i:s", time());
    	
    		$q = "INSERT INTO Pages (PageId, FriendlyId, Name, Description, Keywords, Tags, Callout, Layout, Stylesheet, PageTypeId, SiteId, LastModifiedBy, LastModifiedDate, Created, IsActive, Image) 
    			    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

            $s = $db->prepare($q);
            $s->bindParam(1, $pageId);
            $s->bindParam(2, $friendlyId);
            $s->bindParam(3, $name);
            $s->bindParam(4, $description);
            $s->bindParam(5, $keywords);
            $s->bindParam(6, $tags);
            $s->bindParam(7, $callout);
            $s->bindParam(8, $layout);
            $s->bindParam(9, $stylesheet);
            $s->bindParam(10, $pageTypeId);
            $s->bindParam(11, $siteId);
            $s->bindParam(12, $lastModifiedBy);
            $s->bindParam(13, $timestamp);
            $s->bindParam(14, $timestamp);
            $s->bindParam(15, $isActive);
            $s->bindParam(16, $image);
            
            $s->execute();
            
            return array(
                'PageId' => $pageId,
                'FriendlyId' => $friendlyId,
                'Name' => $name,
                'Description' => $description,
                'Keywords' => $keywords,
                'Callout' => $callout,
                'Tags' => $tags,
                'Layout' => $layout,
                'Stylesheet' => $stylesheet,
                'PageTypeId' => $pageTypeId,
                'SiteId' => $siteId,
                'LastModifiedBy' => $lastModifiedBy,
                'IsActive' => $isActive,
                'Image' => $image,
                'Thumb' => '',
                'LastModifiedDate' => $timestamp,
                );
                
        } catch(PDOException $e){
            die('[Page::Add] PDO Error: '.$e->getMessage());
        }
	}
	
	// determines whether a friendlyId is unique
	public static function IsFriendlyIdUnique($friendlyId, $pageTypeId, $siteId){
        
        try{

            $db = DB::get();
            
            // cleanup friendlyid (escape, trim, remove spaces, tolower)
        	$friendlyId = trim($friendlyId);
    		$friendlyId = str_replace(' ', '', $friendlyId);
    		$friendlyId = strtolower($friendlyId);
    
        	$count = 0;
    	
    		$q ="SELECT Count(*) as Count FROM Pages where FriendlyId = ? AND PageTypeId = ? AND SiteId=?";
    
        	$s = $db->prepare($q);
            $s->bindParam(1, $friendlyId);
            $s->bindParam(2, $pageTypeId);
            $s->bindParam(3, $siteId);
            
    		$s->execute();
    
    		$count = $s->fetchColumn();
    
    		if($count==0){
    			return true;
    		}
    		else{
    			return false;
    		}
            
        } catch(PDOException $e){
            die('[Page::IsFriendlyIdUnique] PDO Error: '.$e->getMessage());
        } 
	}
	
	// edits a page
	public static function EditImage($pageId, $image, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
    	    $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages SET
    				Image = ?,
					LastModifiedBy = ?,
					LastModifiedDate = ?
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $image);
            $s->bindParam(2, $lastModifiedBy);
            $s->bindParam(3, $timestamp);
            $s->bindParam(4, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditImage] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits tags for a page
	public static function EditTags($pageId, $tags, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
    	    $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages SET
    				Tags = ?,
					LastModifiedBy = ?,
					LastModifiedDate = ?
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $tags);
            $s->bindParam(2, $lastModifiedBy);
            $s->bindParam(3, $timestamp);
            $s->bindParam(4, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditTags] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits content for a page
	public static function EditContent($pageId, $content, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
    	    $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages SET
    				Content = ?,
					LastModifiedBy = ?,
					LastModifiedDate = ?
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $content);
            $s->bindParam(2, $lastModifiedBy);
            $s->bindParam(3, $timestamp);
            $s->bindParam(4, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditContent] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits draft for a page
	public static function EditDraft($pageId, $draft, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
    	    $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages SET
    				Draft = ?,
					LastModifiedBy = ?,
					LastModifiedDate = ?
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $draft);
            $s->bindParam(2, $lastModifiedBy);
            $s->bindParam(3, $timestamp);
            $s->bindParam(4, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditDraft] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits the timestamp for a page
	public static function EditTimestamp($pageId, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
    	    $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages SET
					LastModifiedBy = ?,
					LastModifiedDate = ?
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $lastModifiedBy);
            $s->bindParam(2, $timestamp);
            $s->bindParam(3, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditTimestamp] PDO Error: '.$e->getMessage());
        }
	}

	// edits the settings for a page
	public static function EditSettings($pageId, $name, $friendlyId, $description, $keywords, $callout, $beginDate, $endDate, $timeZone, $location, $latitude, $longitude, $layout, $stylesheet, $includeOnly, $lastModifiedBy){
	
		$gm_bdate = null;
		
		if(trim($beginDate) != ''){
			$time = strtotime($beginDate.' '.$timeZone);
			
			$gm_bdate = gmdate("Y-m-d H:i:s", $time);
		}
		
		$gm_edate = null;
		
		if(trim($endDate) != ''){
			$time = strtotime($endDate.' '.$timeZone);
        
			$gm_edate = gmdate("Y-m-d H:i:s", $time);
		}
		
		$latLong = '';
		
		if($latitude != '' && $longitude != ''){
			$latLong = 'POINT(' . $latitude . " " . $longitude . ')';
		}
		
        try{
            
            $db = DB::get();
            
            $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages 
    				SET Name = ?, 
					FriendlyId = ?, 
					Description = ?, 
					Keywords = ?, 
					Callout = ?, 
					BeginDate = ?,
					EndDate = ?,
					Location = ?,
					LatLong = PointFromText(?),
					Layout = ?, 
					Stylesheet = ?,
					IncludeOnly = ?, 
					LastModifiedBy = ?, 
					LastModifiedDate = ? 
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $name);
            $s->bindParam(2, $friendlyId);
            $s->bindParam(3, $description);
            $s->bindParam(4, $keywords);
            $s->bindParam(5, $callout);
            $s->bindParam(6, $gm_bdate);
            $s->bindParam(7, $gm_edate);
            $s->bindParam(8, $location);
            $s->bindParam(9, $latLong);
            $s->bindParam(10, $layout);
            $s->bindParam(11, $stylesheet);
            $s->bindParam(12, $includeOnly);
            $s->bindParam(13, $lastModifiedBy);
            $s->bindParam(14, $timestamp);
            $s->bindParam(15, $pageId);
            
            $s->execute();
           
            
		} catch(PDOException $e){
            die('[Page::EditSettings] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits the settings for a page
	public static function EditLayout($pageId, $layout, $lastModifiedBy){
		
        try{
            
            $db = DB::get();
            
            $timestamp = gmdate("Y-m-d H:i:s", time());
            
            $q = "UPDATE Pages 
    				SET  
					Layout = ?, 
					LastModifiedBy = ?, 
					LastModifiedDate = ? 
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $layout);
            $s->bindParam(2, $lastModifiedBy);
            $s->bindParam(3, $timestamp);
            $s->bindParam(4, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::EditLayout PDO Error: '.$e->getMessage());
        }
	}
	
	// edits IsActive
	public static function SetIsActive($pageId, $isActive){
	
        try{
            
            $db = DB::get();
            
            $q = "UPDATE Pages 
            		SET IsActive = ? 
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $isActive);
            $s->bindParam(2, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::SetIsActive] PDO Error: '.$e->getMessage());
        }
	}
	
	// edits IncludeOnly
	public static function SetIncludeOnly($pageId, $includeOnly){
	
        try{
            
            $db = DB::get();
            
            $q = "UPDATE Pages 
            		SET IncludeOnly = ? 
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $includeOnly);
            $s->bindParam(2, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::SetIncludeOnly] PDO Error: '.$e->getMessage());
        }
	}
	
	// removes a page
	public static function Remove($pageId){
		
        try{
            
            $db = DB::get();
            
            $q = "DELETE FROM Pages WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::Remove] PDO Error: '.$e->getMessage());
        }
        
	}
	
	// remove draft
	public static function RemoveDraft($pageId){
	
        try{
            
            $db = DB::get();
            
            $q = "UPDATE Pages 
            		SET Draft = NULL 
					WHERE PageId = ?";
     
            $s = $db->prepare($q);
            $s->bindParam(1, $pageId);
            
            $s->execute();
            
		} catch(PDOException $e){
            die('[Page::RemoveDraft] PDO Error: '.$e->getMessage());
        }
	}
	
	// gets all pages
	public static function GetPages($siteId, $pageTypeId, $pageSize, $pageNo, $orderBy, $activeOnly = false){
		
        try{

            $db = DB::get();
            
            $activeClause = '';

        	if($activeOnly==true){
    			$activeClause = ' AND Pages.IsActive=1';
    		}
    		
    		$next = $pageSize * $pageNo;
    
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, 
            		Pages.Description, Pages.Keywords, 
            		Pages.Content, Pages.Draft, Pages.Callout, 
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong),
        			Pages.Layout, Pages.Stylesheet, Pages.IncludeOnly,
        			Pages.SiteId,
        			Pages.LastModifiedBy, Pages.LastModifiedDate, 
        			Pages.IsActive, Pages.Image, Pages.PageTypeId,
        			Users.FirstName, Users.LastName, Users.PhotoUrl
        			FROM Pages LEFT JOIN Users ON Pages.LastModifiedBy = Users.UserId
        			WHERE Pages.SiteId = ? AND Pages.PageTypeId = ?".$activeClause." ORDER BY ".$orderBy." LIMIT ?, ?";
        			
            $s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            $s->bindParam(2, $pageTypeId);
            $s->bindValue(3, intval($next), PDO::PARAM_INT);
            $s->bindValue(4, intval($pageSize), PDO::PARAM_INT);
            
            $s->execute();
            
            $arr = array();
            
            while($row = $s->fetch(PDO::FETCH_ASSOC)) {  
                array_push($arr, $row);
            } 
            
            return $arr;
        
		} catch(PDOException $e){
            die('[Page::GetPages]'.'[next='.$next.'pageSize='.$pageSize.']---PDO Error: '.$e->getMessage().'trace='.$e->getTraceAsString());
        } 
        
	}
	
	// gets all pages for dates
	public static function GetPagesForDates($siteId, $pageTypeId, $pageSize, $pageNo, $orderBy, $activeOnly, $beginDate, $endDate){
		
        try{

            $db = DB::get();
            
            $activeClause = '';

        	if($activeOnly==true){
    			$activeClause = ' AND Pages.IsActive=1';
    		}
    		
    		$next = $pageSize * $pageNo;
    
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, 
            		Pages.Description, Pages.Keywords, 
            		Pages.Content, Pages.Draft, Pages.Callout,
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong),
        			Pages.Layout, Pages.Stylesheet, Pages.IncludeOnly,
        			Pages.SiteId,
        			Pages.LastModifiedBy, Pages.LastModifiedDate, 
        			Pages.IsActive, Pages.Image, Pages.PageTypeId,
        			Users.FirstName, Users.LastName, Users.PhotoUrl
        			FROM Pages LEFT JOIN Users ON Pages.LastModifiedBy = Users.UserId
        			WHERE Pages.SiteId = ? AND Pages.PageTypeId = ? AND"
        				." ((Pages.BeginDate BETWEEN '".$beginDate."' AND '".$endDate."') OR"
        				." (Pages.EndDate BETWEEN '".$beginDate."' AND '".$endDate."'))"
        				.$activeClause." ORDER BY "
        				.$orderBy." LIMIT ?, ?";
        			
            $s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            $s->bindParam(2, $pageTypeId);
            $s->bindValue(3, intval($next), PDO::PARAM_INT);
            $s->bindValue(4, intval($pageSize), PDO::PARAM_INT);
            
            $s->execute();
            
            $arr = array();
            
            while($row = $s->fetch(PDO::FETCH_ASSOC)) {  
                array_push($arr, $row);
            } 
            
            return $arr;
        
		} catch(PDOException $e){
            die('[Page::GetPages]'.'[next='.$next.'pageSize='.$pageSize.']---PDO Error: '.$e->getMessage().'trace='.$e->getTraceAsString());
        } 
        
	}
	
	// get the total number of pages
	public static function GetPagesCount($siteId, $pageTypeId, $activeOnly = false){
		
        try{

            $db = DB::get();
            
            $activeClause = '';

        	if($activeOnly==true){
    			$activeClause = ' AND Pages.IsActive=1';
    		}
    
        	$count = 0;
    	
    		$q = "SELECT Count(*) as Count
    		        FROM Pages
			        WHERE SiteId = ? AND PageTypeId = ?".$activeClause;
    
        	$s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            $s->bindParam(2, $pageTypeId);
            
    		$s->execute();
    
    		$count = $s->fetchColumn();
    
    		return $count;
            
        } catch(PDOException $e){
            die('[Page::GetPagesCount] PDO Error: '.$e->getMessage());
        }
        
	}

	// Gets all 
	public static function GetPagesForSite($siteId, $activeOnly = false){
		
        try{

            $db = DB::get();
            
            $activeClause = '';

            if($activeOnly==true){
    			$activeClause = ' AND Pages.IsActive=1';
    		}
    		
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, 
            		Pages.Description, Pages.Keywords, Pages.Tags,
            		Pages.Content, Pages.Draft, Pages.Callout, 
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong) AS LatLong,
        			Pages.Layout, Pages.Stylesheet, Pages.IncludeOnly,
        			Pages.SiteId, 
        			Pages.LastModifiedBy, Pages.LastModifiedDate, 
        			Pages.IsActive, Pages.Image, Pages.PageTypeId,
        			Users.FirstName, Users.LastName, Users.PhotoUrl 
        			FROM Pages LEFT JOIN Users ON Pages.LastModifiedBy = Users.UserId
        			WHERE Pages.SiteId = ?".$activeClause.
        			" ORDER BY Pages.Name ASC";
        			
        	//echo $q;
        	
            $s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            
            $s->execute();
            
            $arr = array();
            
            while($row = $s->fetch(PDO::FETCH_ASSOC)) {  
                array_push($arr, $row);
            } 
            
            return $arr;
        
		} catch(PDOException $e){
            die('[Page::GetPagesForSite] PDO Error: '.$e->getMessage());
        }
        
	}
	
	// gets all page for a given $site, pageTypeId
	public static function GetPagesForPageType($siteId, $pageTypeId){

        try{

            $db = DB::get();
		    
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, Pages.Description, Pages.Keywords, Pages.Tags,
            		Pages.Content, Pages.Draft, Pages.Callout, 
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong) AS LatLong, Pages.IncludeOnly,
            		Pages.SiteId,
        			Pages.LastModifiedBy, Pages.LastModifiedDate, 
        			Pages.IsActive, Pages.Image, Pages.PageTypeId,
        			Users.FirstName, Users.LastName, Users.PhotoUrl
        			FROM Users, Pages
        			WHERE Pages.LastModifiedBy = Users.UserId AND Pages.SiteId = ? AND Pages.PageTypeId = ?
        			ORDER BY Pages.Name ASC";
                  
            $s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            $s->bindParam(2, $pageTypeId);
            
            $s->execute();
            
            $arr = array();
            
            while($row = $s->fetch(PDO::FETCH_ASSOC)) {  
                array_push($arr, $row);
            } 
            
            return $arr;
        
		} catch(PDOException $e){
            die('[Page::GetPagesForPageType] PDO Error: '.$e->getMessage());
        } 
        
	}
	
	// gets all pages for a given $site, pageTypeId
	public static function GetRSS($siteId, $pageTypeId){
		
        try{

            $db = DB::get();
    	    
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, Pages.Description,
            		Pages.SiteId,
        			Pages.LastModifiedBy, Pages.LastModifiedDate, 
        			Pages.IsActive, Pages.Image, Pages.PageTypeId,
        			Users.FirstName, Users.LastName
        			FROM Users, Pages
        			WHERE Pages.LastModifiedBy = Users.UserId AND Pages.SiteId = ? AND Pages.PageTypeId = ?
        			ORDER BY Pages.LastModifiedDate DESC";
                    
            $s = $db->prepare($q);
            $s->bindParam(1, $siteId);
            $s->bindParam(2, $pageTypeId);
            
            $s->execute();
            
            $arr = array();
            
            while($row = $s->fetch(PDO::FETCH_ASSOC)) {  
                array_push($arr, $row);
            } 
            
            return $arr;
        
		} catch(PDOException $e){
            die('[Page::GetRSS] PDO Error: '.$e->getMessage());
        }
        
	}
	
	// gets a page for a specific $friendlyId and $siteId
	public static function GetByFriendlyId($friendlyId, $pageTypeId, $siteId){
		
        try{
        
            $db = DB::get();
            
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, Pages.Description, Pages.Keywords, Pages.Tags,
            		Pages.Content, Pages.Draft, Pages.Callout, 
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong) AS LatLong,
        			Pages.Layout, Pages.Stylesheet,
        			Pages.PageTypeId, Pages.SiteId, Pages.LastModifiedBy, Pages.LastModifiedDate,  
        			Pages.IsActive, Pages.Image, Pages.IncludeOnly
        		 	FROM Pages WHERE FriendlyId=? AND PageTypeId=? AND SiteId=?";
                    
            $s = $db->prepare($q);
            $s->bindParam(1, $friendlyId);
            $s->bindParam(2, $pageTypeId);
            $s->bindParam(3, $siteId);
            
            $s->execute();
            
            $row = $s->fetch(PDO::FETCH_ASSOC);        
    
    		if($row){
    			return $row;
    		}
        
        } catch(PDOException $e){
            die('[Page::GetByFriendlyId] PDO Error: '.$e->getMessage());
        }
        
	}
	
	// gets a page by its url
	public static function GetByUrl($url, $siteId){
	
		if(strpos($url, '/') !== false){ // get by
			$arr = explode('/', $url);
			
			$pageTypeFriendlyId = $arr[0];
			$pageFriendlyId = $arr[1];
			
			$pageType = PageType::GetByFriendlyId($pageTypeFriendlyId, $siteId);
			$page = Page::GetByFriendlyId($pageFriendlyId, $pageType['PageTypeId'], $siteId);
			
			return $page;
		}
		else{
			$pageFriendlyId = $url;
		
			$page = Page::GetByFriendlyId($pageFriendlyId, -1, $siteId);
			
			return $page;
		}
	
	
	}
	
	// gets a page for a specific $pageId
	public static function GetByPageId($pageId){
	
        try{
        
            $db = DB::get();
            
            $q = "SELECT Pages.PageId, Pages.FriendlyId, Pages.Name, Pages.Description, Pages.Keywords, Pages.Tags,
            		Pages.Content, Pages.Draft, Pages.Callout, 
            		Pages.BeginDate, Pages.EndDate, Pages.Location, AsText(Pages.LatLong) AS LatLong,
        			Pages.Layout, Pages.Stylesheet,
        			Pages.PageTypeId, Pages.SiteId, Pages.LastModifiedBy, Pages.LastModifiedDate,  
        			Pages.IsActive, Pages.Image, Pages.IncludeOnly
        		 	FROM Pages WHERE PageId=?";
                    
            $s = $db->prepare($q);
            $s->bindParam(1, $pageId);
            
            $s->execute();
            
            $row = $s->fetch(PDO::FETCH_ASSOC);        
    
    		if($row){
    			return $row;
    		}
        
        } catch(PDOException $e){
            die('[Page::GetByPageId] PDO Error: '.$e->getMessage());
        }
        
	}
	
}

?>