/**
* Standard Module init function
*
* @return void
*/
function init()
{
parent::init();
if (!reason_user_has_privs($this->admin_page->user_id, 'delete')) {
$this->_ok_to_run = false;
$this->_not_ok_message = 'Sorry; you don\'t have the privileges to delete items on this site.';
} elseif (empty($this->admin_page->site_id)) {
$this->_ok_to_run = false;
$this->_not_ok_message = 'Sorry; you need to specify a site before batch deleting items.';
} elseif (empty($this->admin_page->type_id)) {
$this->_ok_to_run = false;
$this->_not_ok_message = 'Sorry; you need to specify a type before batch deleting items.';
}
if ($this->_ok_to_run) {
$this->_type = new entity($this->admin_page->type_id);
$this->admin_page->title = 'Batch Delete ' . $this->_type->get_value('plural_name');
$es = new entity_selector($this->admin_page->site_id);
$es->add_type($this->admin_page->type_id);
$es->set_sharing('owns');
$es->set_order('entity.last_modified DESC');
// pray($this->admin_page->request);
if (isset($this->admin_page->request['state']) && $this->admin_page->request['state'] == 'pending') {
$status = 'Pending';
} else {
$status = 'Live';
}
$this->_items = $es->run_one('', $status);
foreach (array_keys($this->_items) as $id) {
if (!$this->admin_page->is_deletable($id)) {
unset($this->_items[$id]);
}
}
}
}
/**
* Determines whether or not the current user has access to the specified media work. If no username is provided, this function defaults to the currently-loggin-in username.
*
* @param string $username
* @return boolean user has access
*/
public function user_has_access_to_media($username = '')
{
// First, get the restricted group--if one exists
$es = new entity_selector();
$es->add_type(id_of('group_type'));
$es->add_right_relationship($this->media_work->id(), relationship_id_of('av_restricted_to_group'));
$group = current($es->run_one());
if (!empty($group)) {
$gh = new group_helper();
$gh->set_group_by_id($group->id());
if ($gh->requires_login()) {
if (!$username) {
$username = reason_check_authentication();
}
if ($username) {
if (!$gh->is_username_member_of_group($username)) {
return false;
}
} else {
return false;
}
}
}
return true;
// Return true if the user has access to view media work
}
function image_may_be_shown($id)
{
if ($this->params['alternate_source_page_id']) {
$page_id = $this->params['alternate_source_page_id'];
if (!($site_id = get_owner_site_id($page_id))) {
$site_id = $this->site_id;
}
} else {
$page_id = $this->cur_page->id();
$site_id = $this->site_id;
}
$es = new entity_selector();
$es->add_type(id_of('image'));
$es->set_env('site', $site_id);
$es->add_right_relationship($page_id, relationship_id_of('minisite_page_to_image'));
$es->add_relation('entity.id = ' . addslashes($id));
$result = $es->run_one();
//echo 'given id='.$id;
if (!empty($result)) {
//echo 'returning true';
return true;
} else {
//echo 'returning false';
return false;
}
}
function _produce_borrowing_nav()
{
$ret = '';
$nes = new entity_selector();
$nes->add_type(id_of('type'));
$nes->add_right_relationship($this->admin_page->site_id, relationship_id_of('site_cannot_edit_type'));
$nes->add_relation('`entity`.`id` = "' . addslashes($this->admin_page->type_id) . '"');
$nes->set_num(1);
$nes->limit_tables();
$nes->limit_fields();
$ns = $nes->run_one();
$show_edit = reason_user_has_privs($this->admin_page->user_id, 'edit') && !$this->admin_page->is_second_level() && empty($ns) ? true : false;
/* $type = new entity($this->admin_page->type_id);
$name = $type->get_value('plural_name') ? $type->get_value('plural_name') : $type->get_value('name');
if(function_exists('mb_strtolower'))
$name = mb_strtolower($name);
else
$name = strtolower($name); */
$ret .= '<div class="borrowNav">' . "\n";
$ret .= '<ul>';
if ($show_edit) {
$ret .= '<li><a href="' . $this->admin_page->get_owned_list_link($this->admin_page->type_id) . '"><img src="' . REASON_HTTP_BASE_PATH . 'silk_icons/bullet_edit.png" alt="" /> Add & edit</a></li>';
}
$ret .= '<li class="current"><strong><img src="' . REASON_HTTP_BASE_PATH . 'silk_icons/car.png" alt="" /> Borrow</strong></li>';
$ret .= '</ul>' . "\n";
$ret .= '</div>' . "\n";
// if(reason_user_has_privs($this->admin_page->user_id,'edit'))
return $ret;
}
/**
* Make sure that the model is configured with a valid URL.
*
* @return string json
*/
function build()
{
if ($site_id = $this->config('site_id')) {
$s = get_microtime();
$es = new entity_selector();
$es->add_type(id_of('social_account_type'));
$es->add_right_relationship($site_id, relationship_id_of('site_to_social_account'));
$es->add_rel_sort_field($site_id, relationship_id_of('site_to_social_account'));
$es->set_order('rel_sort_order ASC');
$es->limit_tables();
$es->limit_fields();
if ($results = $es->run_one()) {
$result_keys = array_keys($results);
$sih = reason_get_social_integration_helper();
foreach ($result_keys as $id) {
// get the integrator if it supports the SocialAccountProfileLinks interface
if ($integrator = $sih->get_social_account_integrator($id, 'SocialAccountProfileLinks')) {
$profile_links[$id]['icon'] = $integrator->get_profile_link_icon($id);
$profile_links[$id]['text'] = $integrator->get_profile_link_text($id);
$profile_links[$id]['href'] = $integrator->get_profile_link_href($id);
}
}
if (!empty($profile_links)) {
return $profile_links;
}
}
return false;
} else {
trigger_error('The ReasonSocialProfileLinksModel must be provided with the configuration parameter site_id.', FATAL);
}
}
function get_links()
{
$links = parent::get_links();
$es = new entity_selector($this->admin_page->site_id);
$es->add_type(id_of('event_type'));
$es->set_order('dated.datetime DESC');
$values = $es->run_one();
//should adjust so that can't rearrange slots for events that have only one or no registration slots.
//also, probably not for past events either.
if ($values) {
foreach ($values as $event_id => $event) {
$es2 = new entity_selector($this->admin_page->site_id);
$es2->add_type(id_of('registration_slot_type'));
$es2->add_right_relationship($event_id, relationship_id_of('event_type_to_registration_slot_type'));
$numSlots = $es2->get_one_count();
if ($numSlots > 1) {
$date = $event->get_value('datetime');
$name = 'Sort slots for ' . $event->get_value('name') . ' - ' . prettify_mysql_datetime($date);
$link = $this->admin_page->make_link(array('event_id' => $event->id(), 'default_sort' => false), true);
$links[$name] = $link;
}
}
$this->links = $links;
return $this->links;
}
}
function get_pages_needing_change()
{
if (!isset($this->pages_needing_change)) {
$es = new entity_selector();
$es->add_type(id_of('minisite_page'));
$es->enable_multivalue_results();
$es->limit_tables('page_node');
$es->limit_fields('custom_page');
$es->add_relation('page_node.custom_page = "blurb"');
$es->add_left_relationship_field('minisite_page_to_text_blurb', 'entity', 'id', 'blurb_id');
$result = $es->run_one();
foreach ($result as $k => $page) {
$blurbs = is_array($page->get_value('blurb_id')) ? $page->get_value('blurb_id') : array($page->get_value('blurb_id'));
foreach ($blurbs as $blurb_id) {
$blurb = new entity($blurb_id);
$content = $blurb->get_value('content');
$demoted_content = demote_headings($content, 1);
if ($content == $demoted_content) {
$pages_needing_page_type_change[$k] = $k;
}
}
}
$this->pages_needing_change = isset($pages_needing_page_type_change) ? array_keys($pages_needing_page_type_change) : false;
}
return $this->pages_needing_change;
}
function name_es($name)
{
$es = new entity_selector();
$es->add_type(id_of('content_table'));
$es->add_relation('entity.name = "' . $name . '"');
$results = $es->run_one();
return $results;
}
/**
* Standard Module init function
*
* Sets up page variables and runs the entity selctor that grabs the users
*
* @return void
*/
function init()
{
parent::init();
$this->site = new entity($this->admin_page->site_id);
$this->admin_page->title = 'Users with administrative access to ' . $this->site->get_value('name');
$es = new entity_selector();
$es->add_right_relationship($this->admin_page->site_id, relationship_id_of('site_to_user'));
$this->users = $es->run_one(id_of('user'));
}
protected function _link_in_db()
{
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('admin_link'));
$es->add_relation('`url` = "?cur_module=AdminTools"');
$es->set_num(1);
$results = $es->run_one();
return !empty($results);
}
/**
* @return object loki 1 entity if it exists
*/
protected function get_loki_1_entity()
{
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('html_editor_type'));
$es->add_relation('entity.name = "Loki 1"');
$es->set_num(1);
$result = $es->run_one();
return !empty($result) ? reset($result) : FALSE;
}
function get_minisite_template($theme_id)
{
$template = false;
$es = new entity_selector();
$es->add_type(id_of('minisite_template'));
$es->add_right_relationship($theme_id, relationship_id_of('theme_to_minisite_template'));
$tmp = $es->run_one();
return current($tmp);
}
function load_by_type($type_id, $id, $user_id)
{
$this->_id = $id;
$this->_original = new entity($this->_id);
// load all fields used by this type
$q = 'DESC entity';
$r = db_query($q, 'Unable to get entity description');
while ($row = mysql_fetch_array($r, MYSQL_ASSOC)) {
list($type, $args) = $this->plasmature_type_from_db_type($row['Field'], $row['Type']);
$this->add_element($row['Field'], $type, $args);
}
// get tables associated with this type
$es = new entity_selector();
$es->description = 'disco reason: load_by_type: tables to type';
$es->add_type(id_of('content_table'));
$es->add_right_relationship($type_id, relationship_id_of('type_to_table'));
$tables = $es->run_one();
unset($es);
// make an element for each field the type has
foreach ($tables as $tid => $table) {
// grab the type's entity tables and fields
$es = new entity_selector();
$es->description = 'disco reason 2: load_by_type: fields associated with table ' . $table->get_value('name');
$es->add_type(id_of('field'));
$es->add_left_relationship($tid, relationship_id_of('field_to_entity_table'));
$fields = $es->run_one('', 'Live', 'field es');
unset($es);
foreach ($fields as $fid => $field) {
$args = array();
$type = '';
// set the plasmature type if specified by the field, otherwise look up the default for the database type
list($type, $args) = $this->plasmature_type_from_db_type($field->get_value('name'), $field->get_value('db_type'));
if ($field->get_value('plasmature_type')) {
$type = $field->get_value('plasmature_type');
}
// hook for plasmature arguments here
$this->add_element($field->get_value('name'), $type, $args, $field->get_value('db_type'));
}
}
// load values
$elements = $this->_original->get_values();
foreach ($elements as $key => $val) {
if (isset($val)) {
$this->set_value($key, $val);
}
}
$this->init();
$this->change_element_type('type', 'hidden');
$this->set_value('type', $type_id);
$this->change_element_type('last_edited_by', 'hidden');
$this->set_value('last_edited_by', $user_id);
if (!reason_user_has_privs($user_id, 'edit_unique_names')) {
$this->change_element_type('unique_name', 'hidden');
} elseif ($this->get_value('unique_name')) {
$this->change_element_type('unique_name', 'solidText');
}
}
function run()
{
$site_id = $this->site_id;
$es = new entity_selector($site_id);
$es->add_type(id_of('google_map_type'));
$es->add_right_relationship($this->cur_page->id(), relationship_id_of('page_to_google_map'));
$es->add_rel_sort_field($this->cur_page->id(), relationship_id_of('page_to_google_map'));
$es->set_order('rel_sort_order');
$gmaps = $es->run_one();
draw_google_map($gmaps);
}
function init($args = array())
{
parent::init($args);
$s = new entity_selector();
$s->add_type(id_of('site'));
$s->set_order('entity.name');
$s->add_relation('site.site_state = "Live"');
$this->site_count = $s->get_one_count();
$this->sites = $s->run_one();
//pray($this->sites);
}
/**
* Initialize the module
* grabs all the blurbs associated with the current site
* @param $args array
*/
function init($args = array())
{
parent::init($args);
$master_admin_id = id_of('master_admin');
$es = new entity_selector($master_admin_id);
$es->limit_tables();
$es->limit_fields();
$es->add_type(id_of('text_blurb'));
$es->add_right_relationship($this->site_id, relationship_id_of('site_to_announcement_blurb'));
$es->set_env('site', $master_admin_id);
$this->blurbs = $es->run_one();
}
function init($args = array())
{
$es = new entity_selector($this->parent->site_id);
$es->description = 'Selecting blog/publications for this page';
$es->add_type(id_of('publication_type'));
$es->add_right_relationship($this->parent->cur_page->id(), relationship_id_of('page_to_publication'));
$es->set_num(1);
$blogs = $es->run_one();
if (!empty($blogs)) {
$this->blog = current($blogs);
}
}
function do_updates($mode, $reason_user_id)
{
if ($mode != 'run' && $mode != 'test') {
trigger_error('$mode most be either "run" or "test"');
return;
}
$messages = array();
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('view_type'));
$es->add_relation('url = "sections_and_issues.php"');
$es->set_num(1);
$view_types = $es->run_one();
if (empty($view_types)) {
if ('test' == $mode) {
echo '<p>Would have added the view type sections_and_issues.php and the Sections and Issues view</p>' . "\n";
return;
} else {
$view_type_id = reason_create_entity(id_of('master_admin'), id_of('view_type'), $reason_user_id, 'News Sections and Issues', array('url' => 'sections_and_issues.php'));
$view_type = new entity($view_type_id);
echo '<p>Added the view type sections_and_issues.php</p>' . "\n";
}
} else {
echo '<p>sections_and_issues.php view type already added</p>' . "\n";
$view_type = current($view_types);
}
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('view'));
$es->add_left_relationship($view_type->id(), relationship_id_of('view_to_view_type'));
$es->set_num(1);
$views = $es->run_one();
if (empty($views)) {
if ('test' == $mode) {
echo '<p>Would have added the Sections and Issues view</p>' . "\n";
} else {
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('field'));
$es->add_relation('entity.name = "status"');
$es->set_num(1);
$fields = $es->run_one();
$view_id = reason_create_entity(id_of('master_admin'), id_of('view'), $reason_user_id, 'News Sections and Issues', array('display_name' => 'Sections and Issues'));
create_relationship($view_id, $view_type->id(), relationship_id_of('view_to_view_type'));
create_relationship($view_id, id_of('news'), relationship_id_of('view_to_type'));
if (!empty($fields)) {
$field = current($fields);
create_relationship($view_id, $field->id(), relationship_id_of('view_columns'));
create_relationship($view_id, $field->id(), relationship_id_of('view_searchable_fields'));
}
echo '<p>Added sections and issue view</p>';
}
} else {
echo '<p>sections and issues view already added.</p>' . "\n";
}
}
function run_error_checks()
{
parent::run_error_checks();
$es = new entity_selector();
$es->add_relation('audience_integration.directory_service_value = "' . reason_sql_string_escape($this->get_value('directory_service_value')) . '"');
$es->add_relation('entity.id != ' . $this->get_value('id'));
$es->set_num(1);
$conflicts = $es->run_one(id_of('audience_type'));
if (!empty($conflicts)) {
$this->set_error('directory_service_value', 'The Directory Service Value you entered ("' . $this->get_value('directory_service_value') . '") is already in use. Each audience must have a unique directory service value.');
}
}
function run_job()
{
$es = new entity_selector($this->site_id);
$es->add_type(id_of('news'));
$result = $es->run_one();
if ($result) {
$ids = array_keys($result);
foreach ($result as $id => $item) {
reason_expunge_entity($id, $this->user_id);
}
}
$es = new entity_selector($this->site_id);
$es->add_type(id_of('publication_type'));
$result = $es->run_one();
if ($result) {
$ids = array_keys($result);
foreach ($result as $id => $item) {
reason_expunge_entity($id, $this->user_id);
}
}
$es = new entity_selector($this->site_id);
$es->add_type(id_of('category_type'));
$result = $es->run_one();
if ($result) {
$ids = array_keys($result);
foreach ($result as $id => $item) {
reason_expunge_entity($id, $this->user_id);
}
}
$es = new entity_selector($this->site_id);
$es->add_type(id_of('comment_type'));
$result = $es->run_one();
if ($result) {
$ids = array_keys($result);
foreach ($result as $id => $item) {
reason_expunge_entity($id, $this->user_id);
}
}
$es = new entity_selector($this->site_id);
$es->add_type(id_of('minisite_page'));
$result = $es->run_one();
if ($result) {
$root_page = root_finder($this->site_id);
$ids = array_keys($result);
foreach ($result as $id => $item) {
if ($id != $root_page) {
reason_expunge_entity($id, $this->user_id);
}
}
}
$this->set_report('Zapped all the news, publications, categories, comments, and pages from the site');
}
protected function _dynamic_site_id_option_exists()
{
$es = new entity_selector(id_of('master_admin'));
$es->add_type(id_of('admin_link'));
$es->set_num(1);
$result = $es->run_one();
if ($result) {
$ret = reset($result);
$values = $ret->get_values();
return array_key_exists('add_dynamic_site_id', $values);
}
return false;
}
/**
* Root finder:
* Takes a site id and returns the id of the root page.
* @param integer $site_id
* @return mixed page id integer if found; NULL if not found
*/
function root_finder( $site_id )
{
$es = new entity_selector( );
$es->add_type( id_of( 'minisite_page') );
$es->add_relation( 'entity.state = "Live"' );
$es->add_right_relationship( $site_id, get_owns_relationship_id(id_of('minisite_page')) );
$results = $es->run_one();
foreach( $results as $page )
{
$page_id = $page->get_value( 'id' );
if( is_site_root( $page_id ) )
return $page_id;
}
}
/**
* Determine if a site has access to the image type
* @param integer $site_id site to test
* @return boolean
*/
function site_can_manage_images($site_id)
{
$es = new entity_selector();
$es->add_type(id_of('type'));
$es->add_right_relationship($site_id, relationship_id_of('site_to_type'));
$es->add_relation('entity.unique_name = "image"');
$es->set_num(1);
$types = $es->run_one();
if (empty($types)) {
return false;
} else {
return true;
}
}
private static function _get_path_from_entities($media_file, $tmp_file_name, $media_work, $extra_dir)
{
if (!$media_work) {
$es = new entity_selector();
$es->add_type(id_of('av'));
$es->add_left_relationship($media_file->get_value('id'), relationship_id_of('av_to_av_file'));
$media_work = current(array_merge($es->run_one(), $es->run_one('', 'Pending', 'Deleted')));
}
if ($media_work) {
if ($tmp_file_name) {
$extension = end(explode('.', $tmp_file_name));
} else {
$extension = end(explode('.', $media_work->get_value('original_filename')));
}
if ($extension) {
return self::_generate_dir_path($media_work, $extra_dir) . self::_generate_name($media_work->get_value('original_filename'), $extension, $extra_dir, $media_file, $media_work);
} else {
trigger_error('Invalid filename: ' . $tmp_file_name . '. It has no extension.');
}
} else {
trigger_error('No Media Work is associated with Media File with id ' . $media_file->get_value('id'));
}
}
function init()
{
parent::init();
$this->admin_page->title = 'Download Links for Media Work';
$this->media_work = new entity($this->admin_page->id);
if ($this->media_work->get_value('integration_library') == 'kaltura') {
$this->kaltura_shim = new KalturaShim();
$this->user = new entity($this->admin_page->user_id);
// Grab the associated media files
$es = new entity_selector();
$es->add_type(id_of('av_file'));
$es->add_right_relationship($this->media_work->id(), relationship_id_of('av_to_av_file'));
$this->media_files = $es->run_one();
}
}
function init($args = array())
{
parent::init($args);
// find all the sites
$es = new entity_selector();
$es->description = "Getting all live sites";
$es->add_type(id_of('site'));
$es->add_relation('site.site_state = "Live"');
$this->sites = $es->run_one();
// find all non-reason sites
$es2 = new entity_selector();
$es2->description = 'Getting all non-reason sites';
$es2->add_type(id_of('non_reason_site_type'));
$this->non_reason_sites = $es2->run_one();
}
function get_form()
{
if (!isset($this->_form)) {
$this->_form = false;
// Get the form entity attached to the current page
$es = new entity_selector();
$es->add_type(id_of('form'));
$es->add_right_relationship($this->cur_page->id(), relationship_id_of('page_to_form'));
$es->set_num(1);
$result = $es->run_one();
if ($result) {
$this->_form = reset($result);
}
}
return $this->_form;
}
/**
* @return mixed array of slot data OR false.
*/
function get_site_slots_with_data()
{
if (!isset($this->_site_slots_with_data)) {
$es = new entity_selector($this->admin_page->site_id);
$es->add_type(id_of('registration_slot_type'));
$es->add_relation('( (registrant_data <> "") AND (registrant_data IS NOT NULL) )');
$result = $es->run_one();
if (!empty($result)) {
foreach ($result as $k => $v) {
$this->_site_slots_with_data[$k] = $v->get_value('name');
}
} else {
$this->_site_slots_with_data = FALSE;
}
}
return $this->_site_slots_with_data;
}
function get_description($site)
{
$es = new entity_selector($site->id());
$es->add_type(id_of('text_blurb'));
$es->add_relation('entity.name = "Site Description"');
$es->set_order('entity.last_modified DESC');
$descriptions = $es->run_one();
if (!empty($descriptions)) {
reset($descriptions);
$desc = current($descriptions);
return $desc->get_value('content');
} elseif ($site->get_value('description')) {
return $site->get_value('description');
} else {
return NULL;
}
}
function get_feed_relationship_url()
{
static $cache = array();
if (!array_key_exists($this->parent->cur_page->id(), $cache)) {
$es = new entity_selector($this->parent->site_id);
$es->add_type(id_of('external_url'));
$es->add_right_relationship($this->parent->cur_page->id(), relationship_id_of('page_to_feed_url'));
$es->set_num(1);
$urls = $es->run_one();
if (!empty($urls)) {
$url = current($urls);
$cache[$this->parent->cur_page->id()] = $url->get_value('url');
} else {
$cache[$this->parent->cur_page->id()] = '';
}
}
return $cache[$this->parent->cur_page->id()];
}
