Layer: DAO · Source: lib/dao/CommentDao.php:20 (lines 20–392)
class CommentDao extends Dao
| Tag | Value |
|---|---|
@category | Dao Class |
@author | M.Noermoehammad |
@license | MIT |
@version | 1.0 |
@since | Since Release 1.0 |
| Relation | Type | Meaning |
|---|---|---|
| extends | ''Dao'' | parent class/interface |
None.
| Visibility | Type | Name | Default | Line |
|---|---|---|---|---|
private | (untyped) | $selected | 22 |
| Visibility | Method | Summary | Line |
|---|---|---|---|
| public | __construct() | Constructor | 28 |
| public | findComments() | Find Comments | 46 |
| public | findApprovedCommentsPaginated() | Find approved comments with pagination for API | 85 |
| public | countApprovedComments() | Count approved comments | 123 |
| public | findComment() | Find Comment | 149 |
| public | updateComment() | Update Comment | 178 |
| public | deleteComment() | DeleteComment | 201 |
| public | anonymizeComment() | Anonymize comment by replacing author info | 218 |
| public | anonymizeCommentsByEmail() | Anonymize all comments by user email | 241 |
| public | checkCommentId() | CheckCommentId | 267 |
| public | dropDownCommentStatement() | DropDownCommentStatement | 284 |
| public | totalCommentRecords() | TotalCommentRecords | 306 |
| public | countReplies() | Count Replies for a Comment | 319 |
| public | findCommentWithPost() | Find a single comment with post info (no sanitize required). | 333 |
| public | insertCommentApi() | Insert a comment with the given data and return the new ID. | 349 |
| public | updateCommentApi() | Update specific comment fields. | 362 |
| public | deleteCommentWithReplies() | Delete replies for a comment, then the comment itself. | 373 |
| public | getPostCommentStatus() | Get comment_status for a post. | 385 |
public function __construct()
lines 28–31 (4)
Constructor
Takes no parameters.
public function findComments($orderBy = 'ID', $email = null)
lines 46–73 (28)
Find Comments
When an email is provided, only comments authored by that email are returned (used by GDPR data export so the whole table is never loaded into memory and filtered in PHP).
| Parameter | Type | Default | Description |
|---|---|---|---|
$orderBy | (untyped) | 'ID' | – default order By Id |
$email | (untyped) | null | – optional comment author email filter |
Returns: (none declared) — array
public function findApprovedCommentsPaginated($limit, $offset, $sortBy = 'ID', $sortOrder = 'DESC', $postId = null)
lines 85–115 (31)
Find approved comments with pagination for API
| Parameter | Type | Default | Description |
|---|---|---|---|
$limit | (untyped) | required | none |
$offset | (untyped) | required | none |
$sortBy | (untyped) | 'ID' | none |
$sortOrder | (untyped) | 'DESC' | none |
$postId | (untyped) | null | none |
Returns: (none declared) — array
public function countApprovedComments($postId = null)
lines 123–138 (16)
Count approved comments
| Parameter | Type | Default | Description |
|---|---|---|---|
$postId | (untyped) | null | none |
Returns: (none declared) — integer
public function findComment($id, $sanitize)
lines 149–167 (19)
Find Comment
| Parameter | Type | Default | Description |
|---|---|---|---|
$id | (untyped) | required | none |
$sanitize | (untyped) | required | none |
Returns: (none declared) — array
public function updateComment($sanitize, $bind, $ID)
lines 178–191 (14)
Update Comment
| Parameter | Type | Default | Description |
|---|---|---|---|
$sanitize | (untyped) | required | none |
$bind | (untyped) | required | none |
$ID | (untyped) | required | none |
Returns: (none declared)
public function deleteComment($id, $sanitize)
lines 201–209 (9)
DeleteComment
| Parameter | Type | Default | Description |
|---|---|---|---|
$id | (untyped) | required | none |
$sanitize | (untyped) | required | none |
Returns: (none declared)
public function anonymizeComment($commentId)
lines 218–233 (16)
Anonymize comment by replacing author info
Used for GDPR data deletion (Right to be Forgotten)
| Parameter | Type | Default | Description |
|---|---|---|---|
$commentId | (untyped) | required | none |
Returns: (none declared) — bool
public function anonymizeCommentsByEmail($email)
lines 241–256 (16)
Anonymize all comments by user email
| Parameter | Type | Default | Description |
|---|---|---|---|
$email | (untyped) | required | none |
Returns: (none declared) — bool
public function checkCommentId($id, $sanitize)
lines 267–274 (8)
CheckCommentId
| Parameter | Type | Default | Description |
|---|---|---|---|
$id | (untyped) | required | none |
$sanitize | (untyped) | required | none |
Returns: (none declared) — integer|numeric
public function dropDownCommentStatement($selected = '')
lines 284–297 (14)
DropDownCommentStatement
| Parameter | Type | Default | Description |
|---|---|---|---|
$selected | (untyped) | '''''' | none |
Returns: (none declared) — mixed
public function totalCommentRecords($data = null)
lines 306–311 (6)
TotalCommentRecords
| Parameter | Type | Default | Description |
|---|---|---|---|
$data | (untyped) | null | none |
Returns: (none declared) — numeric|int
public function countReplies($commentId)
lines 319–325 (7)
Count Replies for a Comment
| Parameter | Type | Default | Description |
|---|---|---|---|
$commentId | (untyped) | required | none |
Returns: (none declared) — int
public function findCommentWithPost($commentId)
lines 333–341 (9)
Find a single comment with post info (no sanitize required).
| Parameter | Type | Default | Description |
|---|---|---|---|
$commentId | (untyped) | required | none |
Returns: (none declared) — array|false
public function insertCommentApi(array $data)
lines 349–353 (5)
Insert a comment with the given data and return the new ID.
| Parameter | Type | Default | Description |
|---|---|---|---|
$data | array | required | none |
Returns: (none declared) — int
public function updateCommentApi($commentId, array $data)
lines 362–365 (4)
Update specific comment fields.
| Parameter | Type | Default | Description |
|---|---|---|---|
$commentId | (untyped) | required | none |
$data | array | required | none |
Returns: (none declared) — void
public function deleteCommentWithReplies($commentId)
lines 373–377 (5)
Delete replies for a comment, then the comment itself.
| Parameter | Type | Default | Description |
|---|---|---|---|
$commentId | (untyped) | required | none |
Returns: (none declared) — void
public function getPostCommentStatus($postId)
lines 385–391 (7)
Get comment_status for a post.
| Parameter | Type | Default | Description |
|---|---|---|---|
$postId | (untyped) | required | none |
Returns: (none declared) — string|null
| Alias | Fully-qualified name |
|---|---|
Dao | ''Scriptlog\Core\Dao'' |
This page is generated from source by 'tools/gendoc'. Edits will be overwritten.