====== CommentDao ======

**Layer:** ''DAO'' · **Source:** ''lib/dao/CommentDao.php:20'' (lines 20–392)

----
<code>
class CommentDao extends Dao
</code>

======= Docblock Metadata =======

^ Tag ^ Value ^
| ''@category'' | Dao Class |
| ''@author'' | M.Noermoehammad |
| ''@license'' | MIT |
| ''@version'' | 1.0 |
| ''@since'' | Since Release 1.0 |

======= Inheritance =======

^ Relation ^ Type ^ Meaning ^
| extends | [[scriptlog:lib:core:dao|''Dao'']] | parent class/interface |

======= Constants (0) =======

//None.//

======= Properties (1) =======

^ Visibility ^ Type ^ Name ^ Default ^ Line ^
| ''private'' | ''(untyped)'' | ''$selected'' |  | 22 |

======= Methods (18) =======

^ 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 |


======== __construct() ========

<code>
public function __construct()
</code>

//lines 28–31 (4)//

Constructor

//Takes no parameters.//


======== findComments() ========

<code>
public function findComments($orderBy = &#039;ID&#039;, $email = null)
</code>

//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


======== findApprovedCommentsPaginated() ========

<code>
public function findApprovedCommentsPaginated($limit, $offset, $sortBy = &#039;ID&#039;, $sortOrder = &#039;DESC&#039;, $postId = null)
</code>

//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


======== countApprovedComments() ========

<code>
public function countApprovedComments($postId = null)
</code>

//lines 123–138 (16)//

Count approved comments

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$postId'' |  ''(untyped)'' |  ''null'' |  //none// |

**Returns:** ''(none declared)'' — integer


======== findComment() ========

<code>
public function findComment($id, $sanitize)
</code>

//lines 149–167 (19)//

Find Comment

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$id'' |  ''(untyped)'' |  //required// |  //none// |
|  ''$sanitize'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — array


======== updateComment() ========

<code>
public function updateComment($sanitize, $bind, $ID)
</code>

//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)''


======== deleteComment() ========

<code>
public function deleteComment($id, $sanitize)
</code>

//lines 201–209 (9)//

DeleteComment

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$id'' |  ''(untyped)'' |  //required// |  //none// |
|  ''$sanitize'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)''


======== anonymizeComment() ========

<code>
public function anonymizeComment($commentId)
</code>

//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


======== anonymizeCommentsByEmail() ========

<code>
public function anonymizeCommentsByEmail($email)
</code>

//lines 241–256 (16)//

Anonymize all comments by user email

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$email'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — bool


======== checkCommentId() ========

<code>
public function checkCommentId($id, $sanitize)
</code>

//lines 267–274 (8)//

CheckCommentId

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$id'' |  ''(untyped)'' |  //required// |  //none// |
|  ''$sanitize'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — integer&#124;numeric


======== dropDownCommentStatement() ========

<code>
public function dropDownCommentStatement($selected = &#039;&#039;)
</code>

//lines 284–297 (14)//

DropDownCommentStatement

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$selected'' |  ''(untyped)'' |  '''''' |  //none// |

**Returns:** ''(none declared)'' — mixed


======== totalCommentRecords() ========

<code>
public function totalCommentRecords($data = null)
</code>

//lines 306–311 (6)//

TotalCommentRecords

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$data'' |  ''(untyped)'' |  ''null'' |  //none// |

**Returns:** ''(none declared)'' — numeric&#124;int


======== countReplies() ========

<code>
public function countReplies($commentId)
</code>

//lines 319–325 (7)//

Count Replies for a Comment

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$commentId'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — int


======== findCommentWithPost() ========

<code>
public function findCommentWithPost($commentId)
</code>

//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&#124;false


======== insertCommentApi() ========

<code>
public function insertCommentApi(array $data)
</code>

//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


======== updateCommentApi() ========

<code>
public function updateCommentApi($commentId, array $data)
</code>

//lines 362–365 (4)//

Update specific comment fields.

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$commentId'' |  ''(untyped)'' |  //required// |  //none// |
|  ''$data'' |  ''array'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — void


======== deleteCommentWithReplies() ========

<code>
public function deleteCommentWithReplies($commentId)
</code>

//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


======== getPostCommentStatus() ========

<code>
public function getPostCommentStatus($postId)
</code>

//lines 385–391 (7)//

Get comment_status for a post.

^  Parameter ^  Type ^  Default ^  Description ^
|  ''$postId'' |  ''(untyped)'' |  //required// |  //none// |

**Returns:** ''(none declared)'' — string&#124;null

======= Imports =======

^ Alias ^ Fully-qualified name ^
| ''Dao'' | [[scriptlog:lib:core:dao|''Scriptlog\Core\Dao'']] |


----

//This page is generated from source by 'tools/gendoc'. Edits will be overwritten.//