/**
* Get a count of all resources
*
* @param integer $gid Group ID
* @param string $authorized Authorization level
* @return integer
*/
public static function getResourcesCount($gid = NULL, $authorized)
{
if (!$gid) {
return 0;
}
$database = App::get('db');
include_once PATH_CORE . DS . 'components' . DS . 'com_resources' . DS . 'tables' . DS . 'resource.php';
$rr = new \Components\Resources\Tables\Resource($database);
$database->setQuery("SELECT COUNT(*) FROM " . $rr->getTableName() . " AS r WHERE r.group_owner=" . $database->quote($gid));
return $database->loadResult();
}
/**
* Get a list of resource IDs associated with this group
*
* @param string $gid Group alias
* @return array
*/
private function getResourceIDs($gid = NULL)
{
if (!$gid) {
return array();
}
$database = App::get('db');
$rr = new \Components\Resources\Tables\Resource($database);
$database->setQuery("SELECT id FROM " . $rr->getTableName() . " AS r WHERE r.group_owner=" . $database->quote($gid));
return $database->loadObjectList();
}
/**
* Display module content
*
* @return void
*/
public function display()
{
if (User::isGuest()) {
return false;
}
include_once Component::path('com_resources') . DS . 'tables' . DS . 'resource.php';
include_once Component::path('com_resources') . DS . 'tables' . DS . 'type.php';
$this->steps = array('Type', 'Compose', 'Attach', 'Authors', 'Tags', 'Review');
$database = App::get('db');
$rr = new \Components\Resources\Tables\Resource($database);
$rt = new \Components\Resources\Tables\Type($database);
$query = "SELECT r.*, t.type AS typetitle\n\t\t\tFROM " . $rr->getTableName() . " AS r\n\t\t\tLEFT JOIN " . $rt->getTableName() . " AS t ON r.type=t.id\n\t\t\tWHERE r.published=2 AND r.standalone=1 AND r.type!=7 AND r.created_by=" . User::get('id');
$database->setQuery($query);
$this->rows = $database->loadObjectList();
if ($this->rows) {
include_once Component::path('com_resources') . DS . 'tables' . DS . 'assoc.php';
include_once Component::path('com_resources') . DS . 'tables' . DS . 'contributor.php';
include_once Component::path('com_resources') . DS . 'helpers' . DS . 'tags.php';
}
require $this->getLayoutPath();
}
