addTableHeader();
$this->getDBParams($params);
$comments = ItemComment::newInstance()->search($this->resourceID, $this->start, $this->limit,
( $this->order_by['column_name'] ? $this->order_by['column_name'] : 'pk_i_id' ),
( $this->order_by['type'] ? $this->order_by['type'] : 'desc' ),
$this->showAll);
$this->processData($comments);
if($this->showAll) {
$this->total = ItemComment::newInstance()->countAll();
} else {
$this->total = ItemComment::newInstance()->countAll( '( c.b_active = 0 OR c.b_enabled = 0 OR c.b_spam = 1 )' );
}
if( $this->resourceID == null ) {
$this->total_filtered = $this->total;
} else {
$this->total_filtered = ItemComment::newInstance()->count( $this->resourceID );
}
return $this->getData();
}
private function addTableHeader()
{
$this->addColumn('status-border', '');
$this->addColumn('status', __('Status'));
$this->addColumn('bulkactions', '');
$this->addColumn('author', __('Author'));
$this->addColumn('comment', __('Comment'));
$this->addColumn('date', __('Date'));
$dummy = &$this;
osc_run_hook("admin_comments_table", $dummy);
}
private function processData($comments)
{
if(!empty($comments)) {
$csrf_token_url = osc_csrf_token_url();
foreach($comments as $aRow) {
$row = array();
$options = array();
$options_more = array();
View::newInstance()->_exportVariableToView('item', Item::newInstance()->findByPrimaryKey($aRow['fk_i_item_id']));
if( $aRow['b_enabled'] ) {
$options_more[] = '' . __('Block') . '';
} else {
$options_more[] = '' . __('Unblock') . '';
}
$options_more[] = '' . __('Delete') . '';
$options[] = '' . __('Edit') . '';
if( $aRow['b_active'] ) {
$options[] = '' . __('Deactivate') . '';
} else {
$options[] = '' . __('Activate') . '';
}
// more actions
$moreOptions = ''.PHP_EOL.''. __('Show more') .'...'. PHP_EOL .''. PHP_EOL;
foreach( $options_more as $actual ) {
$moreOptions .= '- '.$actual."
".PHP_EOL;
}
$moreOptions .= '
'. PHP_EOL .''.PHP_EOL;
// create list of actions
$auxOptions = ''.PHP_EOL;
foreach( $options as $actual ) {
$auxOptions .= '- '.$actual.'
'.PHP_EOL;
}
$auxOptions .= $moreOptions;
$auxOptions .= '
'.PHP_EOL;
$actions = ''.$auxOptions.'
'.PHP_EOL;
$status = $this->get_row_status($aRow);
$row['status-border'] = '';
$row['status'] = $status['text'];
$row['bulkactions'] = '';
if( empty($aRow['s_author_name']) ) {
$user = User::newInstance()->findByPrimaryKey( $aRow['fk_i_user_id'] );
$aRow['s_author_name'] = $user['s_email'];
}
$row['author'] = $aRow['s_author_name'] . ' (' . osc_item_title() . ')'. $actions;
$row['comment'] = $aRow['s_body'];
$row['date'] = osc_format_date($aRow['dt_pub_date']);
$row = osc_apply_filter('comments_processing_row', $row, $aRow);
$this->addRow($row);
$this->rawRows[] = $aRow;
}
}
}
private function getDBParams($_get)
{
$this->order_by['column_name'] = 'c.dt_pub_date';
$this->order_by['type'] = 'desc';
$this->showAll = Params::getParam('showAll')=='off'?false:true;
foreach($_get as $k => $v) {
if( ( $k == 'resourceId' ) && !empty($v) ) {
$this->resourceID = intval($v);
}
if( $k == 'iDisplayStart' ) {
$this->start = intval($v);
}
if( $k == 'iDisplayLength' ) {
$this->limit = intval($v);
}
}
// set start and limit using iPage param
$start = ((int)Params::getParam('iPage')-1) * $_get['iDisplayLength'];
$this->start = intval( $start );
$this->limit = intval( $_get['iDisplayLength'] );
}
public function row_class($class, $rawRow, $row)
{
$status = $this->get_row_status($rawRow);
$class[] = $status['class'];
return $class;
}
/**
* Get the status of the row. There are three status:
* - blocked
* - inactive
* - active
*
* @since 3.3
*
* @return array Array with the class and text of the status of the listing in this row. Example:
* array(
* 'class' => '',
* 'text' => ''
* )
*/
private function get_row_status($user)
{
if( $user['b_enabled']==0 ) {
return array(
'class' => 'status-blocked',
'text' => __('Blocked')
);
}
if( $user['b_active']==0 ) {
return array(
'class' => 'status-inactive',
'text' => __('Inactive')
);
}
return array(
'class' => 'status-active',
'text' => __('Active')
);
}
}
?>