/**
* prepare backend integrations render
*
* @param moscomprofilerUser $user
* @param object $plugin
*/
private function showIntegrations( $user, $plugin ) {
global $_CB_framework, $_CB_database;
$paging = new cbgjPaging( 'integrations' );
$limit = $paging->getlimit( 30 );
$limitstart = $paging->getLimistart();
$search = $paging->getFilter( 'search' );
$access = $paging->getFilter( 'access' );
$state = $paging->getFilter( 'state' );
$id = $paging->getFilter( 'id' );
$where = array();
if ( isset( $search ) && ( $search != '' ) ) {
$where[] = '( ' . $_CB_database->NameQuote( 'name' ) . ' LIKE ' . $_CB_database->Quote( '%' . $_CB_database->getEscaped( $search, true ) . '%', false ) . ' )';
}
if ( isset( $access ) && ( ! in_array( $access, array( '', '-1' ) ) ) ) {
$where[] = '( ' . $_CB_database->NameQuote( 'access' ) . ' = ' . (int) $access . ' )';
}
if ( isset( $state ) && ( $state != '' ) ) {
$where[] = '( ' . $_CB_database->NameQuote( 'published' ) . ' = ' . (int) $state . ' )';
}
if ( isset( $id ) && ( $id != '' ) ) {
$where[] = '( ' . $_CB_database->NameQuote( 'id' ) . ' = ' . (int) $id . ' )';
}
$query = 'SELECT COUNT(*)'
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin' )
. "\n WHERE " . $_CB_database->NameQuote( 'type' ) . " = " . $_CB_database->Quote( 'user/plug_cbgroupjive/plugins' )
. ( count( $where ) ? "\n AND " . implode( "\n AND ", $where ) : null );
$_CB_database->setQuery( $query );
$total = $_CB_database->loadResult();
if ( $total <= $limitstart ) {
$limitstart = 0;
}
$pageNav = $paging->getPageNav( $total, $limitstart, $limit );
$query = 'SELECT *'
. "\n FROM " . $_CB_database->NameQuote( '#__comprofiler_plugin' )
. "\n WHERE " . $_CB_database->NameQuote( 'type' ) . " = " . $_CB_database->Quote( 'user/plug_cbgroupjive/plugins' )
. ( count( $where ) ? "\n AND " . implode( "\n AND ", $where ) : null )
. "\n ORDER BY " . $_CB_database->NameQuote( 'ordering' ) . " ASC";
$_CB_database->setQuery( $query, (int) $pageNav->limitstart, (int) $pageNav->limit );
$rows = $_CB_database->loadObjectList();
$input = array();
$accessLevels = $_CB_framework->acl->get_access_children_tree( true );
$listAccess = array();
$listAccess[] = moscomprofilerHTML::makeOption( '-1', CBTxt::T( '- Select Access -' ) );
$listAccess = array_merge( $listAccess, $accessLevels );
$input['access'] = $paging->getInputSelect( 'adminForm', 'access', $listAccess, ( in_array( $access, array( '', '-1' ) ) ? -1 : $access ), true );
$listState = array();
$listState[] = moscomprofilerHTML::makeOption( '', CBTxt::T( '- Select State -' ) );
$listState[] = moscomprofilerHTML::makeOption( '1', CBTxt::T( 'Published' ) );
$listState[] = moscomprofilerHTML::makeOption( '0', CBTxt::T( 'Unpublished' ) );
$input['state'] = $paging->getInputSelect( 'adminForm', 'state', $listState, $state );
$input['search'] = $paging->getInputText( 'adminForm', 'search', $search, '30' );
$input['id'] = $paging->getInputText( 'adminForm', 'id', $id, '6' );
$pageNav->searching = ( count( $where ) ? true : false );
HTML_cbgjAdmin::showIntegrations( $rows, $pageNav, $input, $accessLevels, $user, $plugin );
}
