Scriptlog Docs

Scriptlog Documentation

Code reference for the Scriptlog codebase

User Tools

Site Tools

You are here: start » scriptlog » lib » dao » postdao
Trace: • basemodel
scriptlog:lib:dao:postdao

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

scriptlog:lib:dao:postdao [2026/09/26 09:09] – admin adminscriptlog:lib:dao:postdao [2026/09/26 09:16] (current) – admin admin
Line 10: Line 10:
 ======= Docblock Metadata ======= ======= Docblock Metadata =======
  
-  ^ Tag ^ Value ^ +^ Tag ^ Value ^ 
-  | ''@category'' | Dao Class | +| ''@category'' | Dao Class | 
-  | ''@author'' | M.Noermoehammad | +| ''@author'' | M.Noermoehammad | 
-  | ''@license'' | MIT | +| ''@license'' | MIT | 
-  | ''@version'' | 1.0 | +| ''@version'' | 1.0 | 
-  | ''@since'' | Since Release 1.0 |+| ''@since'' | Since Release 1.0 |
  
 ======= Inheritance ======= ======= Inheritance =======
  
-  ^ Relation ^ Type ^ Meaning ^ +^ Relation ^ Type ^ Meaning ^ 
-  | extends | [[scriptlog:lib:core:dao|''Dao'']] | parent class/interface |+| extends | [[scriptlog:lib:core:dao|''Dao'']] | parent class/interface |
  
 ======= Constants (3) ======= ======= Constants (3) =======
  
-  ^ Visibility ^ Name ^ Value ^ Line ^ +^ Visibility ^ Name ^ Value ^ Line ^ 
-  | ''private'' | ''ALLOWED_SORT_COLUMNS'' | ''['ID', 'post_date', 'post_title', 'post_modified'];'' | 30 | +| ''private'' | ''ALLOWED_SORT_COLUMNS'' | ''['ID', 'post_date', 'post_title', 'post_modified'];'' | 30 | 
-  | ''private'' | ''PUBLISHED_FILTER'' | ''"p.post_status = 'publish' AND p.post_visibility = 'public'";'' | 38 | +| ''private'' | ''PUBLISHED_FILTER'' | ''"p.post_status = 'publish' AND p.post_visibility = 'public'";'' | 38 | 
-  | ''private'' | ''SELECT_PUBLISHED_COLUMNS'' | ''"p.ID, p.media_id, p.post_author, p.post_date, p.post_modified, p.post_title, p.post_slug…'' | 45 |+| ''private'' | ''SELECT_PUBLISHED_COLUMNS'' | ''"p.ID, p.media_id, p.post_author, p.post_date, p.post_modified, p.post_title, p.post_slug…'' | 45 |
  
 ======= Properties (0) ======= ======= Properties (0) =======
Line 35: Line 35:
 ======= Methods (31) ======= ======= Methods (31) =======
  
-  ^ Visibility ^ Method ^ Summary ^ Line ^ +^ Visibility ^ Method ^ Summary ^ Line ^ 
-  | public | ''__construct()'' | (undocumented) | 50 | +| public | ''__construct()'' | (undocumented) | 50 | 
-  | public | ''findPosts()'' | findPosts | 65 | +| public | ''findPosts()'' | findPosts | 65 | 
-  | public | ''findPublishedPostsPaginated()'' | Find published posts with pagination for API endpoints. | 121 | +| public | ''findPublishedPostsPaginated()'' | Find published posts with pagination for API endpoints. | 121 | 
-  | public | ''countPublishedPosts()'' | Count published posts. | 158 | +| public | ''countPublishedPosts()'' | Count published posts. | 158 | 
-  | public | ''findPublishedPostById()'' | Find a single published post by ID. | 186 | +| public | ''findPublishedPostById()'' | Find a single published post by ID. | 186 | 
-  | public | ''getPostById()'' | Retrieve a single post by its ID regardless of status/visibility. | 216 | +| public | ''getPostById()'' | Retrieve a single post by its ID regardless of status/visibility. | 216 | 
-  | public | ''findAdjacentPost()'' | Find the adjacent published blog post relative to the given ID. | 251 | +| public | ''findAdjacentPost()'' | Find the adjacent published blog post relative to the given ID. | 251 | 
-  | public | ''findPost()'' | findPost() | 281 | +| public | ''findPost()'' | findPost() | 281 | 
-  | public | ''createPost()'' | createPost | 333 | +| public | ''createPost()'' | createPost | 333 | 
-  | public | ''updatePost()'' | updatePost | 385 | +| public | ''updatePost()'' | updatePost | 385 | 
-  | public | ''publishDueScheduledPosts()'' | Publish all scheduled posts whose post_date has passed. | 460 | +| public | ''publishDueScheduledPosts()'' | Publish all scheduled posts whose post_date has passed. | 460 | 
-  | public | ''nextScheduledPostDate()'' | Get the earliest post_date among still-scheduled posts. | 502 | +| public | ''nextScheduledPostDate()'' | Get the earliest post_date among still-scheduled posts. | 502 | 
-  | public | ''deletePost()'' | DeletePost | 519 | +| public | ''deletePost()'' | DeletePost | 519 | 
-  | public | ''anonymizePostAuthor()'' | Reassign every post authored by $authorId to a fallback author. | 549 | +| public | ''anonymizePostAuthor()'' | Reassign every post authored by $authorId to a fallback author. | 549 | 
-  | public | ''checkPostId()'' | checkPostId | 565 | +| public | ''checkPostId()'' | checkPostId | 565 | 
-  | public | ''totalPostRecords()'' | Total posts records. | 585 | +| public | ''totalPostRecords()'' | Total posts records. | 585 | 
-  | public | ''findArchiveIndex()'' | Get distinct year-month combinations with post counts for archive index. | 607 | +| public | ''findArchiveIndex()'' | Get distinct year-month combinations with post counts for archive index. | 607 | 
-  | public | ''findPostsByYear()'' | Find published posts by year with pagination. | 637 | +| public | ''findPostsByYear()'' | Find published posts by year with pagination. | 637 | 
-  | public | ''countPostsByYear()'' | Count published posts for a given year. | 664 | +| public | ''countPostsByYear()'' | Count published posts for a given year. | 664 | 
-  | public | ''findPostsByYearMonth()'' | Find published posts by year and month with pagination. | 691 | +| public | ''findPostsByYearMonth()'' | Find published posts by year and month with pagination. | 691 | 
-  | public | ''countPostsByYearMonth()'' | Count published posts for a given year and month. | 720 | +| public | ''countPostsByYearMonth()'' | Count published posts for a given year and month. | 720 | 
-  | public | ''searchPostsApi()'' | Search posts with LIKE for API query endpoint. | 745 | +| public | ''searchPostsApi()'' | Search posts with LIKE for API query endpoint. | 745 | 
-  | public | ''findTopicsByPostId()'' | Find topics/categories attached to a post. | 788 | +| public | ''findTopicsByPostId()'' | Find topics/categories attached to a post. | 788 | 
-  | public | ''findActiveTopicsByPostId()'' | Find active topics/categories attached to a post. | 814 | +| public | ''findActiveTopicsByPostId()'' | Find active topics/categories attached to a post. | 814 | 
-  | public | ''deletePostTopics()'' | Delete all topic relationships for a post. | 833 | +| public | ''deletePostTopics()'' | Delete all topic relationships for a post. | 833 | 
-  | public | ''setPostTopics()'' | Replace all topic relationships for a post. | 849 | +| public | ''setPostTopics()'' | Replace all topic relationships for a post. | 849 | 
-  | public | ''deletePostComments()'' | Delete all comments for a post. | 867 | +| public | ''deletePostComments()'' | Delete all comments for a post. | 867 | 
-  | public | ''insertPostApi()'' | Insert a post with the given data and return the new ID. | 879 | +| public | ''insertPostApi()'' | Insert a post with the given data and return the new ID. | 879 | 
-  | public | ''updatePostApi()'' | Update specific post fields. | 894 | +| public | ''updatePostApi()'' | Update specific post fields. | 894 | 
-  | private | ''resolveSortColumn()'' | Resolve a safe ORDER BY column from a user-supplied sort key. | 907 | +| private | ''resolveSortColumn()'' | Resolve a safe ORDER BY column from a user-supplied sort key. | 907 | 
-  | private | ''resolveSortDirection()'' | Resolve a safe ORDER BY direction ('ASC' or 'DESC'). | 922 |+| private | ''resolveSortDirection()'' | Resolve a safe ORDER BY direction ('ASC' or 'DESC'). | 922 |
  
  
Line 92: Line 92:
 Retrieving all records from table posts Retrieving all records from table posts
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$orderBy'' | ''string'' | '''ID''' | //none// | +|  ''$orderBy'' |  ''string'' |  '''ID''' |  //none// | 
-  | ''$author'' | ''?int'' | ''null'' | //none// | +|  ''$author'' |  ''?int'' |  ''null'' |  //none// | 
-  | ''$onlyPublished'' | ''bool'' | ''true'' | //none// |+|  ''$onlyPublished'' |  ''bool'' |  ''true'' |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 112: Line 112:
 Find published posts with pagination for API endpoints. Find published posts with pagination for API endpoints.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$limit'' | ''int'' | //required// | //none// | +|  ''$limit'' |  ''int'' |  //required// |  //none// | 
-  | ''$offset'' | ''int'' | //required// | //none// | +|  ''$offset'' |  ''int'' |  //required// |  //none// | 
-  | ''$sortBy'' | ''string'' | '''ID''' | //none// | +|  ''$sortBy'' |  ''string'' |  '''ID''' |  //none// | 
-  | ''$sortOrder'' | ''string'' | '''DESC''' | //none// | +|  ''$sortOrder'' |  ''string'' |  '''DESC''' |  //none// | 
-  | ''$author'' | ''?int'' | ''null'' | //none// |+|  ''$author'' |  ''?int'' |  ''null'' |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 134: Line 134:
 Count published posts. Count published posts.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$author'' | ''?int'' | ''null'' | //none// |+|  ''$author'' |  ''?int'' |  ''null'' |  //none// |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 152: Line 152:
 Find a single published post by ID. Find a single published post by ID.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''?array'' — array|null **Returns:** ''?array'' — array|null
Line 173: Line 173:
 class internals (setSQL/findRow) to read a post. class internals (setSQL/findRow) to read a post.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''?array'' — array|null **Returns:** ''?array'' — array|null
Line 195: Line 195:
 when 'next' it returns the post with the smallest ID above $postId. when 'next' it returns the post with the smallest ID above $postId.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | The reference post ID. | +|  ''$postId'' |  ''int'' |  //required// |  The reference post ID. | 
-  | ''$direction'' | ''string'' | '''previous''' | 'previous' or 'next'. |+|  ''$direction'' |  ''string'' |  '''previous''' |  'previous' or 'next'. |
  
 **Returns:** ''?array'' — array|null Adjacent post row (ID, post_title, post_slug) or null. **Returns:** ''?array'' — array|null Adjacent post row (ID, post_title, post_slug) or null.
Line 216: Line 216:
 Retrieving a single post record by its ID. Retrieving a single post record by its ID.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$ID'' | ''int'' | //required// | //none// | +|  ''$ID'' |  ''int'' |  //required// |  //none// | 
-  | ''$sanitize'' | [[scriptlog:lib:core:sanitize|''Sanitize'']] | //required// | //none// | +|  ''$sanitize'' |  [[scriptlog:lib:core:sanitize|''Sanitize'']] |  //required// |  //none// | 
-  | ''$author'' | ''?int'' | ''null'' | //none// | +|  ''$author'' |  ''?int'' |  ''null'' |  //none// | 
-  | ''$onlyPublished'' | ''bool'' | ''true'' | //none// |+|  ''$onlyPublished'' |  ''bool'' |  ''true'' |  //none// |
  
 **Returns:** ''?array'' — array|null **Returns:** ''?array'' — array|null
Line 239: Line 239:
 Insert a new post record together with its topic relationships. Insert a new post record together with its topic relationships.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$bind'' | ''array'' | //required// | //none// | +|  ''$bind'' |  ''array'' |  //required// |  //none// | 
-  | ''$topicId'' | ''(untyped)'' | //required// | //none// |+|  ''$topicId'' |  ''(untyped)'' |  //required// |  //none// |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 260: Line 260:
 Updating an existing post record together with its topic relationships. Updating an existing post record together with its topic relationships.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$sanitize'' | [[scriptlog:lib:core:sanitize|''Sanitize'']] | //required// | //none// | +|  ''$sanitize'' |  [[scriptlog:lib:core:sanitize|''Sanitize'']] |  //required// |  //none// | 
-  | ''$bind'' | ''array'' | //required// | //none// | +|  ''$bind'' |  ''array'' |  //required// |  //none// | 
-  | ''$ID'' | ''int'' | //required// | //none// | +|  ''$ID'' |  ''int'' |  //required// |  //none// | 
-  | ''$topicId'' | ''(untyped)'' | //required// | //none// |+|  ''$topicId'' |  ''(untyped)'' |  //required// |  //none// |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 285: Line 285:
 and clears the page cache when any post is promoted. and clears the page cache when any post is promoted.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$now'' | ''string'' | //required// | Current datetime in site timezone ('Y-m-d H:i:s') |+|  ''$now'' |  ''string'' |  //required// |  Current datetime in site timezone ('Y-m-d H:i:s') |
  
 **Returns:** ''int'' — int Number of posts promoted **Returns:** ''int'' — int Number of posts promoted
Line 318: Line 318:
 DeletePost DeletePost
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$ID'' | ''int'' | //required// | //none// | +|  ''$ID'' |  ''int'' |  //required// |  //none// | 
-  | ''$sanitize'' | [[scriptlog:lib:core:sanitize|''Sanitize'']] | //required// | //none// |+|  ''$sanitize'' |  [[scriptlog:lib:core:sanitize|''Sanitize'']] |  //required// |  //none// |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 341: Line 341:
 compatibility with existing callers. compatibility with existing callers.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$authorId'' | ''int'' | //required// | The author whose posts are being reassigned | +|  ''$authorId'' |  ''int'' |  //required// |  The author whose posts are being reassigned | 
-  | ''$fallbackAuthorId'' | ''int'' | ''1'' | The author the posts are reassigned to |+|  ''$fallbackAuthorId'' |  ''int'' |  ''1'' |  The author the posts are reassigned to |
  
 **Returns:** ''bool'' — bool **Returns:** ''bool'' — bool
Line 358: Line 358:
 checkPostId checkPostId
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$ID'' | ''int'' | //required// | //none// | +|  ''$ID'' |  ''int'' |  //required// |  //none// | 
-  | ''$sanitize'' | [[scriptlog:lib:core:sanitize|''Sanitize'']] | //required// | //none// |+|  ''$sanitize'' |  [[scriptlog:lib:core:sanitize|''Sanitize'']] |  //required// |  //none// |
  
 **Returns:** ''bool'' — bool **Returns:** ''bool'' — bool
Line 377: Line 377:
 Total posts records. Total posts records.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$author'' | ''?int'' | ''null'' | //none// |+|  ''$author'' |  ''?int'' |  ''null'' |  //none// |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 412: Line 412:
 Find published posts by year with pagination. Find published posts by year with pagination.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$year'' | ''int'' | //required// | //none// | +|  ''$year'' |  ''int'' |  //required// |  //none// | 
-  | ''$limit'' | ''int'' | //required// | //none// | +|  ''$limit'' |  ''int'' |  //required// |  //none// | 
-  | ''$offset'' | ''int'' | //required// | //none// | +|  ''$offset'' |  ''int'' |  //required// |  //none// | 
-  | ''$sortBy'' | ''string'' | '''ID''' | //none// | +|  ''$sortBy'' |  ''string'' |  '''ID''' |  //none// | 
-  | ''$sortOrder'' | ''string'' | '''DESC''' | //none// |+|  ''$sortOrder'' |  ''string'' |  '''DESC''' |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 434: Line 434:
 Count published posts for a given year. Count published posts for a given year.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$year'' | ''int'' | //required// | //none// |+|  ''$year'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 452: Line 452:
 Find published posts by year and month with pagination. Find published posts by year and month with pagination.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$year'' | ''int'' | //required// | //none// | +|  ''$year'' |  ''int'' |  //required// |  //none// | 
-  | ''$month'' | ''int'' | //required// | //none// | +|  ''$month'' |  ''int'' |  //required// |  //none// | 
-  | ''$limit'' | ''int'' | //required// | //none// | +|  ''$limit'' |  ''int'' |  //required// |  //none// | 
-  | ''$offset'' | ''int'' | //required// | //none// | +|  ''$offset'' |  ''int'' |  //required// |  //none// | 
-  | ''$sortBy'' | ''string'' | '''ID''' | //none// | +|  ''$sortBy'' |  ''string'' |  '''ID''' |  //none// | 
-  | ''$sortOrder'' | ''string'' | '''DESC''' | //none// |+|  ''$sortOrder'' |  ''string'' |  '''DESC''' |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 475: Line 475:
 Count published posts for a given year and month. Count published posts for a given year and month.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$year'' | ''int'' | //required// | //none// | +|  ''$year'' |  ''int'' |  //required// |  //none// | 
-  | ''$month'' | ''int'' | //required// | //none// |+|  ''$month'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 494: Line 494:
 Search posts with LIKE for API query endpoint. Search posts with LIKE for API query endpoint.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$keyword'' | ''string'' | //required// | //none// | +|  ''$keyword'' |  ''string'' |  //required// |  //none// | 
-  | ''$type'' | ''string'' | '''all''' | 'blog', 'page', or 'all' | +|  ''$type'' |  ''string'' |  '''all''' |  'blog', 'page', or 'all' | 
-  | ''$limit'' | ''int'' | ''50'' | //none// |+|  ''$limit'' |  ''int'' |  ''50'' |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 514: Line 514:
 Find topics/categories attached to a post. Find topics/categories attached to a post.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 535: Line 535:
 topic_status flag is 'Y' (visible on the frontend). topic_status flag is 'Y' (visible on the frontend).
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''array'' — array **Returns:** ''array'' — array
Line 553: Line 553:
 Delete all topic relationships for a post. Delete all topic relationships for a post.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 572: Line 572:
 Used by the API layer to persist a post's category assignments. Used by the API layer to persist a post's category assignments.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// | +|  ''$postId'' |  ''int'' |  //required// |  //none// | 
-  | ''$topicIds'' | ''array'' | //required// | List of topic IDs. |+|  ''$topicIds'' |  ''array'' |  //required// |  List of topic IDs. |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 591: Line 591:
 Delete all comments for a post. Delete all comments for a post.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// |+|  ''$postId'' |  ''int'' |  //required// |  //none// |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 607: Line 607:
 Insert a post with the given data and return the new ID. Insert a post with the given data and return the new ID.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$data'' | ''array'' | //required// | Column => value pairs |+|  ''$data'' |  ''array'' |  //required// |  Column => value pairs |
  
 **Returns:** ''int'' — int **Returns:** ''int'' — int
Line 625: Line 625:
 Update specific post fields. Update specific post fields.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$postId'' | ''int'' | //required// | //none// | +|  ''$postId'' |  ''int'' |  //required// |  //none// | 
-  | ''$data'' | ''array'' | //required// | Column => value pairs |+|  ''$data'' |  ''array'' |  //required// |  Column => value pairs |
  
 **Returns:** ''void'' — void **Returns:** ''void'' — void
Line 646: Line 646:
 Returns a fallback of 'ID' when the requested column is not whitelisted. Returns a fallback of 'ID' when the requested column is not whitelisted.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$sortBy'' | ''string'' | //required// | //none// |+|  ''$sortBy'' |  ''string'' |  //required// |  //none// |
  
 **Returns:** ''string'' — string **Returns:** ''string'' — string
Line 664: Line 664:
 Any value other than ASC falls back to DESC. Any value other than ASC falls back to DESC.
  
-  ^ Parameter ^ Type ^ Default ^ Description ^ +^  Parameter ^  Type ^  Default ^  Description ^ 
-  | ''$sortOrder'' | ''string'' | //required// | //none// |+|  ''$sortOrder'' |  ''string'' |  //required// |  //none// |
  
 **Returns:** ''string'' — string **Returns:** ''string'' — string
Line 671: Line 671:
 ======= Imports ======= ======= Imports =======
  
-  ^ Alias ^ Fully-qualified name ^ +^ Alias ^ Fully-qualified name ^ 
-  | ''Dao'' | [[scriptlog:lib:core:dao|''Scriptlog\Core\Dao'']] | +| ''Dao'' | [[scriptlog:lib:core:dao|''Scriptlog\Core\Dao'']] | 
-  | ''DbException'' | [[scriptlog:lib:core:dbexception|''Scriptlog\Core\DbException'']] | +| ''DbException'' | [[scriptlog:lib:core:dbexception|''Scriptlog\Core\DbException'']] | 
-  | ''LogError'' | [[scriptlog:lib:core:logerror|''Scriptlog\Core\LogError'']] | +| ''LogError'' | [[scriptlog:lib:core:logerror|''Scriptlog\Core\LogError'']] | 
-  | ''Sanitize'' | [[scriptlog:lib:core:sanitize|''Scriptlog\Core\Sanitize'']] |+| ''Sanitize'' | [[scriptlog:lib:core:sanitize|''Scriptlog\Core\Sanitize'']] |
  
  
scriptlog/lib/dao/postdao.1790413760.txt.gz · Last modified: by admin