Esempio n. 1
0
 function set_borrowship_first_level()
 {
     $borrows_rel_id = get_borrows_relationship_id($this->admin_page->type_id);
     if (!empty($this->admin_page->request['unborrow'])) {
         //do query removing borrowship
         delete_borrowed_relationship($this->admin_page->site_id, $this->admin_page->id, $borrows_rel_id);
     } else {
         //do query creating borrowship
         create_relationship($this->admin_page->site_id, $this->admin_page->id, $borrows_rel_id);
     }
 }
Esempio n. 2
0
 function show_borrowing_sites($entity)
 {
     $es = new entity_selector();
     $es->add_type(id_of('site'));
     $es->add_left_relationship($entity->id(), get_borrows_relationship_id($entity->get_value('type')));
     $results = $es->run_one();
     echo '<h3>Sites that borrow Entity</h3>' . "\n";
     if (count($results) > 0) {
         echo '<table class="entityInfoTable">' . "\n";
         echo '<tr>' . "\n";
         echo '<th>Site Name</th>' . "\n";
         echo '<th>ID #</th>' . "\n";
         echo '</tr>' . "\n";
         foreach ($results as $site) {
             echo '<tr>' . "\n";
             echo '<td>' . $site->get_value('name') . '</td>' . "\n";
             echo '<td>' . $this->get_id_markup($site->id()) . '</td>' . "\n";
             echo '</tr>' . "\n";
         }
         echo '</table>' . "\n";
     } else {
         echo '<p>(none)</p>' . "\n";
     }
 }
Esempio n. 3
0
/**
 * Set up a dbselector object for grabbing Reason entities
 *
 * @param integer $type the id of the type to grab
 * @param mixed $site_id an site id (integer) or an array of site ids
 * @param string $sharing either "owns", "borrows", "owns borrows", or ""
 * @param array $table_mod tables to be included or excluded
 * @param string $table_action either "include" or "exclude" -- specifies what to do with tables given in $table_mod
 */
function get_entities_by_type_object($type, $site_id = '', $sharing = 'owns', $table_mod = array(), $table_action = '')
{
    if (!($type = (int) $type)) {
        trigger_error('get_entities_by_type_object() requires an integer type id as its first parameter.');
        return '';
    }
    $dbq = new DBSelector();
    if ($table_action == 'include') {
        $tables = $table_mod;
    } else {
        $tables = get_entity_tables_by_type($type);
    }
    if ($table_action == 'exclude') {
        $tables = array_diff($tables, $table_mod);
    }
    foreach ($tables as $table) {
        $dbq->add_field($table, '*');
        $dbq->add_table($table);
        // don't match entity table against itself
        if ($table != 'entity') {
            $dbq->add_relation('`entity`.`id` = `' . $table . '`.`id`');
        }
    }
    $dbq->add_relation('`entity`.`type` = "' . $type . '"');
    if ($site_id && $sharing) {
        $dbq->add_table('r', 'relationship');
        if (!reason_relationship_names_are_unique()) {
            $dbq->add_table('ar', 'allowable_relationship');
        }
        if (is_array($site_id)) {
            array_walk($site_id, 'db_prep_walk');
            $dbq->add_relation('r.entity_a IN (' . implode(',', $site_id) . ')');
        } else {
            $dbq->add_relation('r.entity_a = "' . reason_sql_string_escape($site_id) . '"');
        }
        $dbq->add_relation('r.entity_b = entity.id');
        if (!reason_relationship_names_are_unique()) {
            $dbq->add_relation('r.type = ar.id');
        }
        if (preg_match('/owns/', $sharing) && preg_match('/borrows/', $sharing)) {
            if (reason_relationship_names_are_unique()) {
                $owns_rel_id = get_owns_relationship_id($type);
                $borrows_rel_id = get_borrows_relationship_id($type);
                $dbq->add_relation('(r.type = ' . $owns_rel_id . ' OR r.type = ' . $borrows_rel_id . ')');
            } else {
                $dbq->add_relation('(ar.name = "owns" OR ar.name = "borrows")');
            }
        } elseif (preg_match('/borrows/', $sharing)) {
            if (reason_relationship_names_are_unique()) {
                $borrows_rel_id = get_borrows_relationship_id($type);
                $dbq->add_relation('(r.type = ' . $borrows_rel_id . ')');
            } else {
                $dbq->add_relation('ar.name = "borrows"');
            }
        } else {
            if (reason_relationship_names_are_unique()) {
                $owns_rel_id = get_owns_relationship_id($type);
                $dbq->add_relation('(r.type = ' . $owns_rel_id . ')');
            } else {
                $dbq->add_relation('ar.name = "owns"');
            }
        }
    }
    return $dbq;
}
Esempio n. 4
0
	/**
	 * Create a new allowable relationship
	 *
	 * Checks to make sure we are not duplicating an existing allowable relationship before creating new one.
	 * 
	 * Checks include: 
	 * 1. the type ids must be the ids of existing reason types
	 * 2. the name must be a nonempty string containing only numbers, letters, and underscores that does not already exist in the allowable relationship table (exception: borrows and owns)
	 * 3. for borrows or owns relationships, the type must not already have an allowable relationship of that type
	 *
	 * @param integer $a_side_type_id The id of the type on the left side of the relationship
	 * @param integer $b_side_type_id The id of the type on the right side of the relationship
	 * @param string $name The unique name of the allowable relationship (or "owns" or "borrows")
	 * @param array $other_data Additional data to be stored in the allowable_relationship table, keyed by field name
	 * @return mixed id of newly created relationship if successful; false if failure
	 *
	 * @todo update to do verification and handling of new "type" field
	 */
	function create_allowable_relationship($a_side_type_id,$b_side_type_id,$name,$other_data = array())
	{
		// validate data
		
		$a_side_type_id = turn_into_int($a_side_type_id);
		$b_side_type_id = turn_into_int($b_side_type_id);
		$name = turn_into_string($name);
		
		if(empty($a_side_type_id))
		{
			trigger_error('$a_side_type_id must be a nonzero integer in create_allowable_relationship()');
			return false;
		}
		$a_ent = new entity($a_side_type_id);
		if(!empty($a_ent))
		{
			if($a_ent->get_value('type') != id_of('type'))
			{
				trigger_error('$a_side_type_id must be the ID of a Reason type entity');
				return false;
			}
		}
		else
		{
			trigger_error('$a_side_type_id is not the ID of a Reason entity');
			return false;
		}
		if(empty($b_side_type_id))
		{
			trigger_error('$b_side_type_id must be a nonzero integer in create_allowable_relationship()');
			return false;
		}
		$b_ent = new entity($b_side_type_id);
		if(!empty($b_ent))
		{
			if($b_ent->get_value('type') != id_of('type'))
			{
				trigger_error('$b_side_type_id must be the ID of a Reason type entity');
				return false;
			}
		}
		else
		{
			trigger_error('$b_side_type_id is not the ID of a Reason entity');
			return false;
		}
		if(empty($name))
		{
			trigger_error('$name must be a string in create_allowable_relationship()');
			return false;
		}
		if( !preg_match( "|^[0-9a-z_]*$|i" , $name ) )
		{
			trigger_error('$name must only contain numbers, letters, and underscores');
			return false;
		}
		
		if (!reason_relationship_names_are_unique())
		{
			$repeatable_names = array('borrows','owns');
			if( !in_array($name,$repeatable_names) && reason_relationship_name_exists($name, false) )
			{
				trigger_error('Unable to create allowable relationship named '.$name.' because there is already an allowable relationship with that name in Reason');
				return false;
			}
			if(in_array($name,$repeatable_names))
			{
				if($a_side_type_id != id_of('site'))
				{
					trigger_error('The a_side_type_id of borrows and owns relationships must be the id of the site type');
					return false;
				}
				// check to see if an owns/borrows relationship already exists for this type
				if ( (($name == 'owns') && get_owns_relationship_id($b_side_type_id)) ||
					 (($name == 'borrows') && get_borrows_relationship_id($b_side_type_id)) )
				{
					trigger_error($name.' relationship already exists between '.$a_side_type_id.' and '.$b_side_type_id.'.');
					return false;
				}
			}
		}
		else
		{
			if (reason_relationship_name_exists($name, false))
			{
				trigger_error('Unable to create allowable relationship named '.$name.' because there is already an allowable relationship with that name in Reason');
				return false;
			}
			if (isset($other_data['type']) && ( ($other_data['type'] == 'owns') || ($other_data['type'] == 'borrows') ) )
			{
				if ($a_side_type_id != id_of('site'))
				{
					trigger_error('The a_side_type_id of borrows and owns relationships must be the id of the site type');
					return false;
				}
				// enforce our naming convention
				$owns_name_should_be = $a_ent->get_value('unique_name') . '_owns_' . $b_ent->get_value('unique_name');
				$borrows_name_should_be = $a_ent->get_value('unique_name') . '_borrows_' . $b_ent->get_value('unique_name');
				if ( ($other_data['type'] == 'owns') && ($name != $owns_name_should_be) )
				{
					trigger_error('A new allowable relationship of type owns must follow the naming convention a_side_unique_name_owns_b_side_entity_unique_name');
					return false;
				}
				elseif ( ($other_data['type'] == 'borrows') && ($name != $borrows_name_should_be) )
				{
					trigger_error('A new allowable relationship of type borrows must follow the naming convention a_side_unique_name_borrows_b_side_entity_unique_name');
					return false;
				}
			}
			if (isset($other_data['type']) && ($other_data['type'] == 'archive'))
			{
				if ($a_side_type_id != $b_side_type_id)
				{
					trigger_error('The a_side_type_id and b_side_type_id of archive relationships must be the same.');
					return false;
				}
				$archive_name_should_be = $a_ent->get_value('unique_name') . '_archive';
				if ($name != $archive_name_should_be)
				{
					trigger_error('A new allowable relationship of type archive must follow the naming convention type_unique_name_archive');
					return false;
				}
			}
		}
		
		// do the creation of the allowable relationship
		
		$default_values = array(
								'directionality'=>'unidirectional',
								'is_sortable'=>'no',
								'connections'=>'many_to_many',
								'required'=>'no',
		);
		if (reason_relationship_names_are_unique()) $default_values['type'] = 'association';
		$values = array_merge($default_values,$other_data);
		$values['relationship_a'] = $a_side_type_id;
		$values['relationship_b'] = $b_side_type_id;
		$values['name'] = $name;
		
		$sqler = new SQLER();
		if($sqler->insert('allowable_relationship',$values))
		{
			$insert_id = mysql_insert_id();
			reason_refresh_relationship_names();
			return $insert_id;
		}
		else
		{
			return false;
		}
	}
Esempio n. 5
0
 /**
  * Returns the relationship entity of the borrowing relationship for the type of the argument $item.
  *
  * If $item is an image, this would be site_borrows_image, for example.
  */
 function get_borrowing_sites($item)
 {
     $borrowing_relations = null;
     if ($item->has_right_relation_of_type(get_borrows_relationship_id($item->get_value('type')))) {
         $borrowing_relations = $item->get_right_relationship(get_borrows_relationship_id($item->get_value('type')));
     }
     return $borrowing_relations;
 }
Esempio n. 6
0
 /**
  * Returns true if entity is owned or borrowed by site in first argument
  * @param integer $site_id
  * @return bool
  */
 function owned_or_borrowed_by($site_id)
 {
     $site = new entity($site_id);
     $owner = $this->get_owner();
     if ($owner->id() == $site->id() || $this->has_right_relation_with_entity($site, get_borrows_relationship_id($this->get_value('type')))) {
         return true;
     } else {
         return false;
     }
 }
 function sync_with_old_catalog($year)
 {
     $courses = array();
     $es = new entity_selector();
     $es->description = 'Selecting courses';
     $factory = new CourseTemplateEntityFactory();
     $es->set_entity_factory($factory);
     $es->add_type(id_of('course_template_type'));
     $es->set_order('course_number');
     $results = $es->run_one();
     connectdb('reg_catalog_new');
     foreach ($results as $id => $entity) {
         $query = 'SELECT id FROM course' . $year . ' WHERE visible = 1 AND course_id = "' . $entity->get_value('sourced_id') . '"';
         if ($result = mysql_query($query)) {
             if (mysql_num_rows($result)) {
                 connectdb(REASON_DB);
                 create_relationship($this->site_id, $entity->id(), get_borrows_relationship_id(id_of('course_template_type')));
                 connectdb('reg_catalog_new');
             }
         }
     }
     connectdb(REASON_DB);
 }
Esempio n. 8
0
 function process()
 {
     $nobody_group = new entity(id_of('nobody_group'));
     //check to see if posting or commenting have been enabled while still being associated with the nobody group
     if ($this->get_value('allow_front_end_posting') && $this->entity->has_left_relation_with_entity($nobody_group, 'publication_to_authorized_posting_group')) {
         $this->delete_associations_of_type('publication_to_authorized_posting_group');
     }
     if ($this->get_value('allow_comments') && $this->entity->has_left_relation_with_entity($nobody_group, 'publication_to_authorized_commenting_group')) {
         $this->delete_associations_of_type('publication_to_authorized_commenting_group');
     }
     //check to see if posting or commenting have been disabled
     if (!$this->get_value('allow_front_end_posting') || !$this->get_value('allow_comments')) {
         //if they are, check to make sure that we've borrowed or own the nobody group.
         if (!(site_borrows_entity($this->get_value('site_id'), id_of('nobody_group')) || site_owns_entity($this->get_value('site_id'), id_of('nobody_group')))) {
             //if not, borrow it.
             create_relationship($this->get_value('site_id'), id_of('nobody_group'), get_borrows_relationship_id(id_of('group_type')));
         }
         //check to see if we've got the appropriate relationship(s) with the nobody group.	If we don't, create the relationship.
         if (!$this->get_value('allow_front_end_posting') && !$this->entity->has_left_relation_with_entity($nobody_group, 'publication_to_authorized_posting_group')) {
             $this->associate_with_nobody_group('publication_to_authorized_posting_group');
         }
         if (!$this->get_value('allow_comments') && !$this->entity->has_left_relation_with_entity($nobody_group, 'publication_to_authorized_commenting_group')) {
             $this->associate_with_nobody_group('publication_to_authorized_commenting_group');
         }
     }
     // make sure the group type is available to the site if commenting or front-end posting are available
     if ($this->get_value('allow_front_end_posting') || $this->get_value('allow_comments')) {
         if (!$this->site_has_type(id_of('group_type'))) {
             $this->add_type_to_site(id_of('group_type'));
         }
     }
     if ($this->get_value('allow_comments')) {
         if (!$this->site_has_type(id_of('comment_type'))) {
             $this->add_type_to_site(id_of('comment_type'));
         }
     }
     if ($this->get_value('has_issues') == 'yes' && !$this->site_has_type(id_of('issue_type'))) {
         $this->add_type_to_site(id_of('issue_type'));
     }
     if ($this->get_value('has_sections') == 'yes' && !$this->site_has_type(id_of('news_section_type'))) {
         $this->add_type_to_site(id_of('news_section_type'));
     }
     if (!$this->site_has_type(id_of('news'))) {
         // publicatons don't make much sense without news
         $this->add_type_to_site(id_of('news'));
     }
     parent::process();
 }
 function ensure_nobody_group_is_on_site()
 {
     $site_id = $this->get_site_id();
     if ($site_id) {
         if (!(site_borrows_entity($site_id, id_of('nobody_group')) || site_owns_entity($site_id, id_of('nobody_group')))) {
             // borrow it
             create_relationship($site_id, id_of('nobody_group'), get_borrows_relationship_id(id_of('group_type')));
         }
         return true;
     }
     return false;
 }
 function run_job()
 {
     $new_site_id = (int) $this->config('new_site_id');
     $b_entities = (array) $this->config('b_entities');
     $b_entities_str = implode(",", $b_entities);
     $q = 'SELECT id, entity_a, site FROM relationship ' . 'WHERE entity_b IN (' . $b_entities_str . ') ' . 'AND site > 0';
     $result = db_query($q, 'Unable to select relationships');
     $count = mysql_num_rows($result);
     if ($count > 0) {
         $q2 = 'UPDATE relationship SET site=' . $this->config('new_site_id') . ' ' . 'WHERE entity_b IN (' . $b_entities_str . ') ' . 'AND site > 0';
         $result2 = db_query($q2, 'Unable to change relationships');
         //using the original result set take care of borrowing and site_to_type changes
         $borrowed_count = $site_has_type_count = 0;
         while ($row = mysql_fetch_assoc($result)) {
             $this->report_item[] = 'Changed site context of rel id ' . $row['id'] . ' from ' . $row['site'] . ' to ' . $this->config('new_site_id') . '.';
             $site_has_type = $borrowed = false;
             // figure out if $row['site'] borrows $row['entity_a']
             if (site_borrows_entity($row['site'], $row['entity_a'])) {
                 $entity_a = new entity($row['entity_a']);
                 $entity_a_type = $entity_a->get_value('type');
                 $borrowed = create_relationship($this->config('new_site_id'), $row['entity_a'], get_borrows_relationship_id($entity_a_type));
                 if (!isset($this->_ensured_site_has_type[$entity_a_type])) {
                     $site_has_type = create_relationship($this->config('new_site_id'), $entity_a_type, relationship_id_of('site_to_type'));
                     $this->_ensured_site_has_type[$entity_a_type] = true;
                 }
             }
             if ($borrowed) {
                 $this->report_item[] = 'New site id ' . $this->config('new_site_id') . ' borrowed entity id ' . $row['entity_a'] . '.';
             }
             if ($site_has_type) {
                 $this->report_item[] = 'New site id ' . $this->config('new_site_id') . ' now has access to type ' . $entity_a_type . '.';
             }
         }
         if (count($this->report_item) > 0) {
             if (count($this->report_item) > 1) {
                 $this->set_report('<p>Job did some work:</p><ul><li>' . implode("</li><li>", $this->report_item) . '</li></ul>');
             } else {
                 $this->set_report(reset($this->report_item));
             }
         }
     }
     return true;
 }
Esempio n. 11
0
 /**
  * Adds a new field to the entity which is actually not a field of entity, but rather a field of 
  * an entity which is related to the current entities.  The entities selected by the ES will be 
  * on the right side of the relationship.
  * Will return multiples of an entity if it has multiples of the same relationship.  Not sure
  * how to change this.
  * @param string $rel_name the name of the relationship between the entities
  * @param string $table the table where the field is
  * @param string $field the name of the field to be selected
  * @param string $alias that alias for the field
  * @param mixed $limit_results true return only row for which the related value is defined
  * 							   false to return all results even if the value does not exist
  *							   string or array to limit results to the values passed
  * @return void
  */
 function add_right_relationship_field($rel_name, $table, $field, $alias, $limit_results = true)
 {
     if ($rel_name != "owns" && $rel_name != "borrows" && !empty($rel_name)) {
         $rel_type_id = relationship_id_of($rel_name);
     } elseif ($rel_name == 'owns' || $rel_name == 'borrows') {
         if (empty($this->type)) {
             $call_info = array_shift(debug_backtrace());
             $code_line = $call_info['line'];
             $file = array_pop(explode('/', $call_info['file']));
             $msg = 'entity selector method add_right_relationship_field called by ' . $file . ' on line ' . $code_line . ' on a generic "owns" or "borrows" relationship when the type has not been set on the entity selector.';
             trigger_error($msg, WARNING);
             return false;
         } elseif ($rel_name == "owns") {
             $rel_type_id = get_owns_relationship_id(reset($this->type));
         } elseif ($rel_name == "borrows") {
             $rel_type_id = get_borrows_relationship_id(reset($this->type));
         }
     }
     if (empty($rel_type_id)) {
         trigger_error('add_right_relationship_field failed - an id could not be determined from the relationship name provided');
         return false;
     }
     if ($limit_results === false) {
         $cur_es = carl_clone($this);
         $this->union = true;
     }
     $es = new entity_selector();
     $es->add_table('relationship', 'relationship');
     $es->add_table('__entity__', 'entity');
     if ($table != 'entity') {
         $es->add_table($table);
     }
     $tables = $this->merge_tables($es);
     if (!empty($tables['relationship'])) {
         $r = $tables['relationship'];
     } else {
         $r = 'relationship';
     }
     if (!empty($tables['__entity__'])) {
         $e = $tables['__entity__'];
     } else {
         $e = '__entity__';
     }
     if ($table == 'entity') {
         $t = $e;
     } else {
         if (!empty($tables[$table])) {
             $t = $tables[$table];
         } else {
             $t = $table;
         }
     }
     if ($e != $t) {
         $this->add_relation($e . '.id = ' . $t . '.id');
     }
     $this->add_relation($e . '.id = ' . $r . '.entity_a');
     $this->add_relation('entity.id = ' . $r . '.entity_b');
     $this->add_relation($r . '.type = ' . $rel_type_id);
     $this->add_field($t, $field, $alias);
     if ($this->_env['restrict_site'] and !empty($this->_env['site'])) {
         $this->add_relation('(' . $r . '.site=0 OR ' . $r . '.site=' . addslashes($this->_env['site']) . ')');
     }
     if ($limit_results === false) {
         $this->union_fields[end($this->fields)] = '0 as ' . $alias;
         $this->diff['fields'][] = array_diff_assoc($this->fields, $cur_es->fields);
         $this->diff['tables'][] = array_diff_assoc($this->tables, $cur_es->tables);
         $this->diff['relations'][] = array_diff_assoc($this->relations, $cur_es->relations);
     } elseif (is_string($limit_results) || is_array($limit_results)) {
         if (is_array($limit_results) && empty($limit_results)) {
             $this->add_relation('0 = 1');
         } else {
             $limit_values = is_string($limit_results) ? array($limit_results) : $limit_results;
             array_walk($limit_values, 'db_prep_walk');
             $this->add_relation($t . '.' . $field . ' IN (' . implode(',', $limit_values) . ')');
         }
     }
     return array($alias => array('table_orig' => $table, 'table' => $t, 'field' => $field));
 }
reason_include_once('scripts/move/move_entities_among_sites_helper.php');
reason_include_once('classes/job.php');
force_secure_if_available();
$current_user = check_authentication();
$current_user_id = get_user_id($current_user);
if (empty($current_user_id)) {
    die('<h1>Sorry.</h1><p>You do not have permission to move entities among sites.</p><p>Only Reason admins may do that.</p></body></html>');
} elseif (!reason_user_has_privs($current_user_id, 'db_maintenance')) {
    die('<h1>Sorry.</h1><p>You do not have permission to move entities among sites.</p><p>Only Reason admins who have database maintenance privs may do that.</p></body></html>');
}
if (!empty($_REQUEST['new_site_ids']) && !empty($_REQUEST['old_site_id']) && !empty($_REQUEST['allowable_relationship_id']) && !empty($_REQUEST['type_id'])) {
    $new_site_ids = (array) $_REQUEST['new_site_ids'];
    $old_site_id = (int) $_REQUEST['old_site_id'];
    $type_id = (int) $_REQUEST['type_id'];
    $allowable_relationship_id = (int) $_REQUEST['allowable_relationship_id'];
    $borrows_relationship_id = get_borrows_relationship_id($type_id);
    $type_name = unique_name_of($type_id);
    $pre_process_method_exists = method_exists('MoveEntitiesPreProcess', $type_name);
    $post_process_method_exists = method_exists('MoveEntitiesPostProcess', $type_name);
} else {
    header('Location: ' . securest_available_protocol() . '://' . REASON_HOST . REASON_HTTP_BASE_PATH . 'scripts/move/move_entities_among_sites.php');
    die;
}
$job_stack = new ReasonJobStack();
foreach ($new_site_ids as $entity_id => $new_site_id) {
    $entity_id = (int) $entity_id;
    $new_site_id = (int) $new_site_id;
    if ($new_site_id != $old_site_id) {
        // if a pre_process function exists for the type, run it
        if ($pre_process_method_exists) {
            $info = array('entity_id' => $entity_id, 'new_site_id' => $new_site_id, 'allowable_relationship_id' => $allowable_relationship_id, 'borrows_relationship_id' => $borrows_relationship_id);