<?php
//J:\awww\www\fwphp\glomodul4\blog\comments.php
//vendor_namesp_prefix \ processing (behavior) \ cls dir (POSITIONAL part of ns, CAREFULLY !)
namespace B12phpfw\dbadapter\post_comment ;
use B12phpfw\core\b12phpfw\Config_allsites as utl ;
use B12phpfw\core\b12phpfw\Db_allsites as utldb ;
use B12phpfw\dbadapter\post_comment\Tbl_crud as Tbl_crud_post_comment ;
//use B12phpfw\module\blog\Home_ctr ;
//$_SESSION["TrackingURL"]=$_SERVER["PHP_SELF"];
// 1. S U B M I T E D A C T I O N S
// 2. R E A D D B T B L R O W S see below
//http://www.mysqltutorial.org/mysql-null/
// 3. G U I (FRM) to get user action
//$title = 'Comments';
//require_once $pp1->shares_path . '/hdr.php'; //require
//require_once("navbar.php");
?>
<!-- HEADER -->
<!-- HEADER END -->
<!-- Main Area -->
<main class="container">
<div class="grid">
<section>
<!--h4>Manage Comments</h4-->
<?php
echo utl::msg_err_succ(__FILE__ .' '.', ln '. __LINE__);
?>
<!-- ********************** -->
<br /><h2 class="bg-dark">Un-Approved Comments</h2>
<!-- ********************** -->
<table class="table table-striped table-hover">
<thead class="thead-dark">
<tr>
<th>No. </th><th>Date&Time</th><th>Name</th><th>Comment</th><th>Appr</th><th>Del</th><th>Post</th>
</tr>
</thead>
<?php
$cursor_comments = Tbl_crud_post_comment::get_cursor( $pp1
, $dmlrr='*'
, $qrywhere="status='OFF' or status < '0' ORDER BY datetime desc"
, $binds=[], $other=['caller' => __FILE__ .' '.', ln '. __LINE__ ]
) ;
$SrNo = 0;
while ( $rcomment_disappr = utldb::rrnext( $cursor_comments
, $other=['caller' => __FILE__ .' '.', ln '. __LINE__ ] ) and $rcomment_disappr->rexists ):
{
$SrNo++; ?>
<tbody>
<tr>
<td><?php echo self::escp($SrNo); ?></td>
<td><?php echo self::escp($rcomment_disappr->datetime); ?></td>
<td><?php echo self::escp($rcomment_disappr->name); ?></td>
<td><?php
switch (utldb::getdbi()) {
case 'oracle' : echo self::escp($rcomment_disappr->commenttxt); break;
default: echo self::escp($rcomment_disappr->comment); break;
}
?>
</td>
<!-- Approve -->
<td>
<a title="Set status=ON"
href="<?=$pp1->upd_comment_stat?>id/<?=$rcomment_disappr->id?>/stat/ON/"
class="btn btn-success"><?=$rcomment_disappr->id?></a>
</td>
<td>
<a id="erase_row" class="btn btn-danger"
title = "Delete row id <?=$rcomment_disappr->id?>"
onclick="var yes ; yes = jsmsgyn('Erase row <?=$rcomment_disappr->id?>?','') ;
if (yes == '1') { location.href= '<?=$pp1->ldd_comments.$rcomment_disappr->id?>/'; }"
><?=$rcomment_disappr->id?></a>
</td>
<!-- See Post -->
<td style="min-width:140px;"> <a class="btn btn-primary"
title = "Show post id <?=$rcomment_disappr->post_id?>"
href="<?=$pp1->read_post?>id/<?=$rcomment_disappr->post_id?>" target="_blank">
<?=$rcomment_disappr->post_id?></a>
</td>
</tr>
</tbody>
<?php
} endwhile; ?>
</table>
<!-- ********************** -->
<h2 class="bg-dark">Approved Comments</h2>
<!-- ********************** -->
<table class="table table-striped table-hover">
<thead class="thead-dark">
<tr>
<th>No. </th><th>Date&Time</th><th>Name</th><th>Comment</th><th>ApprBy</th><th>Disapp</th><th></th><th>Post</th>
</tr>
</thead>
<?php
$cursor_comments = Tbl_crud_post_comment::get_cursor( $pp1
, $dmlrr='*'
, $qrywhere="status='ON' or status < '0' ORDER BY datetime desc"
, $binds=[], $other=['caller' => __FILE__ .' '.', ln '. __LINE__ ]
) ;
$SrNo = 0;
while ( $rcomment_appr = utldb::rrnext( $cursor_comments
, $other=['caller' => __FILE__ .' '.', ln '. __LINE__ ] ) and $rcomment_appr->rexists ):
{
$SrNo++;
?>
<tbody>
<tr>
<td><?php echo self::escp($SrNo); ?></td>
<td><?php echo self::escp($rcomment_appr->datetime); ?></td>
<td><?php echo self::escp($rcomment_appr->name); ?></td>
<td><?php
switch (utldb::getdbi()) {
case 'oracle' : echo self::escp($rcomment_appr->commenttxt); break;
default: echo self::escp($rcomment_appr->comment); break;
}
?>
</td>
<td><?php echo self::escp($rcomment_appr->approvedby); ?></td>
<!-- DisAprove -->
<td style="min-width:140px;">
<a title="Set status=OFF"
href="<?=$pp1->upd_comment_stat?>id/<?=$rcomment_appr->id?>/stat/OFF/"
class="btn btn-warning"> <?=$rcomment_appr->id?> </a>
</td>
<td>
</td>
<!-- go to Post page -->
<td style="min-width:140px;"> <a class="btn btn-primary"
href="<?=$pp1->read_post?>id/<?=$rcomment_appr->post_id?>" target="_blank">
<?=$rcomment_appr->post_id?></a> </td>
</tr>
</tbody>
<?php
} endwhile; ?>
</table>
</section>
</div><!-- class="grid" -->
</main><!-- Main Area End -->
<?php //require $pp1->shares_path . '/ftr.php'; ?>
<!--
//$sql = "S ELECT * FROM comments WHERE s tatus='ON' ORDER BY datetime desc";
//$this->p repareSQL($sql); $this->e xecute();;
//w hile ($rcom_approved = $this->f etchNext())
//$sql = "S ELECT * FROM comments WHERE s tatus='O FF' or s tatus < '0' ORDER BY datetime desc";
//$this->p repareSQL($sql); $this->e xecute();;
//while ($rcom_approved = $this->f etchNext())
-->
|
Download
