public static function cmp($a, $b) { if ($a->parent_metadata_structure_id == $b->parent_metadata_structure_id) { if ($a->ordering == $b->ordering) { if ($a->name == $b->name) { return 0; } return $a->name < $b->name ? -1 : 1; } return $a->ordering < $b->ordering ? -1 : 1; } $lineageA = $a->getLineage(); $lineageAIds = Db_Linked::arrayOfAttrValues($lineageA, 'metadata_structure_id'); if (in_array($b->metadata_structure_id, $lineageAIds)) { // b is some kind of parent of a, therefore b comes before a, i.e. a > b return 1; } $lineageB = $b->getLineage(); $lineageBIds = Db_Linked::arrayOfAttrValues($lineageB, 'metadata_structure_id'); if (in_array($a->metadata_structure_id, $lineageBIds)) { // a is some kind of parent of b, therefore a comes before b, i.e. a < b return -1; } // util_prePrintR($lineageA); // util_prePrintR($lineageB); // trim off matching ancestories while ($lineageA[0]->metadata_structure_id == $lineageB[0]->metadata_structure_id) { array_shift($lineageA); array_shift($lineageB); // util_prePrintR($lineageA); // util_prePrintR($lineageB); } // return the cmp of the first descendents of the point of ancestral divergence return Metadata_Structure::cmp($lineageA[0], $lineageB[0]); }
public function getUsers() { $urs = User_Role::getAllFromDb(['role_id' => $this->role_id], $this->dbConnection); $user_ids = Db_Linked::arrayOfAttrValues($urs, 'user_id'); $users = User::getAllFromDb(['user_id' => $user_ids], $this->dbConnection); usort($users, 'User::cmp'); return $users; }
function testActionsMatchDatabase() { $all_db_actions = Action::getAllFromDb(['flag_delete' => FALSE], $this->DB); $this->assertEqual(count(Action::$VALID_ACTIONS), count($all_db_actions)); $action_db_names = Db_Linked::arrayOfAttrValues($all_db_actions, 'name'); foreach (Action::$VALID_ACTIONS as $va) { $this->assertTrue(in_array($va, $action_db_names), "'{$va}' missing from database"); } foreach ($action_db_names as $db_a) { $this->assertTrue(in_array($db_a, Action::$VALID_ACTIONS), "'{$db_a}' missing from VALID_ACTIONS"); } }
public function getAccessibleNotebooks($for_action, $debug_flag = 0) { if ($this->flag_is_system_admin) { if ($debug_flag) { echo "user is system admin<br/>\n"; } return Notebook::getAllFromDb(['flag_delete' => FALSE], $this->dbConnection); } if (is_string($for_action)) { global $ACTIONS; $for_action = $ACTIONS[$for_action]; } //util_prePrintR($this); $accessible_notebooks_ids = array(); if ($for_action->name == 'view' || $for_action->name == 'list') { $all_notebooks = Notebook::getAllFromDb(['flag_workflow_published' => TRUE, 'flag_workflow_validated' => TRUE, 'flag_delete' => FALSE], $this->dbConnection); $accessible_notebooks_ids = Db_Linked::arrayOfAttrValues($all_notebooks, 'notebook_id'); } $roles = $this->getRoles(); if ($debug_flag) { echo "user roles are<br/>\n"; util_prePrintR($roles); } foreach (Db_Linked::arrayOfAttrValues($roles, 'role_id') as $role_id) { $global_check = Role_Action_Target::getAllFromDb(['role_id' => $role_id, 'action_id' => $for_action->action_id, 'target_type' => 'global_notebook'], $this->dbConnection); if ($debug_flag) { echo "global_check is <br/>\n"; util_prePrintR($global_check); } if (count($global_check) > 0) { $all_notebooks = Notebook::getAllFromDb(['flag_delete' => FALSE], $this->dbConnection); $accessible_notebooks_ids = Db_Linked::arrayOfAttrValues($all_notebooks, 'notebook_id'); } $role_action_targets = Role_Action_Target::getAllFromDb(['role_id' => $role_id, 'action_id' => $for_action->action_id, 'target_type' => 'notebook'], $this->dbConnection); foreach ($role_action_targets as $rat) { if (!in_array($rat->target_id, $accessible_notebooks_ids)) { $accessible_notebooks_ids[] = $rat->target_id; } } } // util_prePrintR($accessible_notebooks_ids); $owned_notebooks = Notebook::getAllFromDb(['user_id' => $this->user_id], $this->dbConnection); $owned_notebook_ids = Db_Linked::arrayOfAttrValues($owned_notebooks, 'notebook_id'); $additional_notebook_ids = array(); foreach ($accessible_notebooks_ids as $an_id) { if (!in_array($an_id, $owned_notebook_ids)) { $additional_notebook_ids[] = $an_id; } } $additional_notebooks = array(); if (count($additional_notebook_ids) > 0) { $additional_notebooks = Notebook::getAllFromDb(['notebook_id' => $additional_notebook_ids], $this->dbConnection); } $ret = array_merge($owned_notebooks, $additional_notebooks); // util_prePrintR($accessible_notebooks_ids); return $ret; }
public function renderAsEdit() { $this->loadPageFields(); $this->loadSpecimens(); $n = $this->getNotebook(); $ap = ''; if ($this->notebook_page_id != 'NEW') { $ap = $this->getAuthoritativePlant(); } // util_prePrintR('TO BE IMPLEMENTED: handle auth plant for new pages (i.e. where auth plant id == 0)'); // util_prePrintR($this); global $USER, $ACTIONS; $actions_attribs = ''; // $add_field_button_li = ''; if ($USER->canActOnTarget($ACTIONS['edit'], $this)) { $actions_attribs .= ' data-can-edit="1"'; // $add_field_button_li = ' <li><a href="" id="btn-add-notebook-page-field" class="creation_link btn">'.util_lang('add_notebook_page_field').'</a></li>'."\n"; } $owner = $USER; if ($n->user_id != $USER->user_id) { $owner = $n->getUser(); } $rendered = '<div id="rendered_notebook_page_' . $this->notebook_page_id . '" class="rendered_notebook_page edit_rendered_notebook_page" ' . $this->fieldsAsDataAttribs() . $actions_attribs . ">\n" . '<form id="form-edit-notebook-page-base-data" action="' . APP_ROOT_PATH . '/app_code/notebook_page.php">' . "\n" . ' <input type="hidden" name="action" value="update"/>' . "\n" . ' <input type="hidden" id="notebook_page_id" name="notebook_page_id" value="' . $this->notebook_page_id . '"/>' . "\n" . ' <input type="hidden" id="notebook_id" name="notebook_id" value="' . $this->notebook_id . '"/>' . "\n"; $rendered .= ' <div id="actions">'; $rendered .= '<button id="edit-submit-control" class="btn btn-success" type="submit" name="edit-submit-control" value="update"><i class="icon-ok-sign icon-white"></i> ' . util_lang($this->notebook_page_id != 'NEW' ? 'update' : 'save', 'properize') . '</button>' . "\n"; if ($this->notebook_page_id != 'NEW') { $rendered .= ' <a id="edit-cancel-control" class="btn" href="' . APP_ROOT_PATH . '/app_code/notebook_page.php?action=view¬ebook_page_id=' . $this->notebook_page_id . '"><i class="icon-remove"></i> ' . util_lang('cancel', 'properize') . '</a>'; $rendered .= ' <a id="edit-delete-notebook-page-control" class="btn btn-danger" href="' . APP_ROOT_PATH . '/app_code/notebook_page.php?action=delete¬ebook_page_id=' . $this->notebook_page_id . '"><i class="icon-trash icon-white"></i> ' . util_lang('delete', 'properize') . '</a>'; } else { $rendered .= ' <a id="edit-cancel-control" class="btn" href="' . APP_ROOT_PATH . '/app_code/notebook.php?action=edit¬ebook_id=' . $this->notebook_id . '"><i class="icon-remove"></i> ' . util_lang('cancel', 'properize') . '</a>'; } $rendered .= '</div>' . "\n"; $rendered .= '<h4>' . util_lang('page_in_notebook', 'ucfirst') . ' <a href="' . APP_ROOT_PATH . '/app_code/notebook.php?action=view¬ebook_id=' . $n->notebook_id . '" id="parent-notebook-link">' . htmlentities($n->name) . '</a></h4>' . "\n"; if ($this->notebook_page_id != 'NEW') { $rendered .= '<a class="show-hide-control" href="#" data-for_elt_id="select_new_authoritative_plant_' . $this->notebook_page_id . '">' . util_lang('change_authoritative_plant') . '</a>'; $rendered .= ' <div id="select_new_authoritative_plant_' . $this->notebook_page_id . '" class="select_new_authoritative_plant">' . Authoritative_Plant::renderControlSelectAllAuthoritativePlants($this->notebook_page_id != 'NEW' ? $ap->authoritative_plant_id : 0) . '</div>' . "\n"; $rendered .= ' ' . $ap->renderAsViewEmbed() . "\n"; } else { $rendered .= ' <div id="select_new_authoritative_plant_' . $this->notebook_page_id . '" class="NEW_select_new_authoritative_plant">' . Authoritative_Plant::renderControlSelectAllAuthoritativePlants(0) . '</div>' . "\n"; } $rendered .= ' <div class="info-timestamps"><span class="created_at">' . util_lang('created_at') . ' ' . util_datetimeFormatted($this->created_at) . '</span>, <span class="updated_at">' . util_lang('updated_at') . ' ' . util_datetimeFormatted($this->updated_at) . "</span></div>\n" . ' <div class="info-owner">' . util_lang('owned_by') . ' <a href="' . APP_ROOT_PATH . '/app_code/user.php?action=view&user_id=' . $owner->user_id . '">' . htmlentities($owner->screen_name) . '</a></div>' . "\n"; $rendered .= '<div class="control-workflows">'; if ($this->notebook_page_id != 'NEW') { if ($USER->canActOnTarget('publish', $this)) { $rendered .= ' <span class="published_state workflow-control"><input id="notebook-page-workflow-publish-control" type="checkbox" name="flag_workflow_published" value="1"' . ($this->flag_workflow_published ? ' checked="checked"' : '') . ' /> ' . util_lang('publish') . '</span>,'; } else { $rendered .= ' <span class="published_state workflow-info">' . ($this->flag_workflow_published ? util_lang('published_true') : util_lang('published_false')) . '</span>,'; } if ($USER->canActOnTarget('verify', $this)) { $rendered .= ' <span class="verified_state verified_state_' . ($this->flag_workflow_validated ? 'true' : 'false') . ' workflow-control"><input id="notebook-page-workflow-validate-control" type="checkbox" name="flag_workflow_validated" value="1"' . ($this->flag_workflow_validated ? ' checked="checked"' : '') . ' /> ' . util_lang('verify') . '</span>'; } else { $rendered .= ' <span class="verified_state verified_state_' . ($this->flag_workflow_validated ? 'true' : 'false') . ' workflow-info">' . ($this->flag_workflow_validated ? util_lang('verified_true') : util_lang('verified_false')) . '</span>'; } $rendered .= '<br/>' . "\n"; } else { $rendered .= ' <span class="published_state workflow-info">' . ($this->flag_workflow_published ? util_lang('published_true') : util_lang('published_false')) . '</span>,'; $rendered .= ' <span class="verified_state verified_state_' . ($this->flag_workflow_validated ? 'true' : 'false') . ' workflow-info">' . ($this->flag_workflow_validated ? util_lang('verified_true') : util_lang('verified_false')) . '</span>'; } $rendered .= "</div>\n"; $rendered .= ' <div class="notebook_page_notes"><textarea id="notebook-page-notes" name="notes" rows="4" cols="120">' . htmlentities($this->notes) . '</textarea></div>' . "\n"; if ($this->notebook_page_id != 'NEW') { $rendered .= ' <h4>' . ucfirst(util_lang('metadata')) . "</h4>\n"; $rendered .= ' <ul class="notebook-page-fields">' . "\n"; $rendered .= ' <li><a href="#" id="add_new_notebook_page_field_button" class="btn">' . util_lang('add_notebook_page_field') . '</a></li>' . "\n"; if ($this->page_fields) { $prev_pf_structure_id = $this->page_fields[0]->label_metadata_structure_id; foreach ($this->page_fields as $pf) { $spacer_class = ''; if ($pf->label_metadata_structure_id != $prev_pf_structure_id) { $spacer_class = 'spacing-list-item'; } $rendered .= ' ' . $pf->renderAsListItemEdit('list_item-notebook_page_field_' . $pf->notebook_page_field_id, [$spacer_class]) . "\n"; $prev_pf_structure_id = $pf->label_metadata_structure_id; } } else { $rendered .= '<li>' . util_lang('no_metadata', 'ucfirst') . '</li>' . "\n"; } $rendered .= ' </ul>' . "\n"; $rendered .= Specimen::renderSpecimenListBlock($this->specimens); // $rendered .= ' <h4>'.ucfirst(util_lang('specimens'))."</h4>\n". // ' <ul class="specimens">'."\n"; // $rendered .= ' <li><a href="#" id="add_new_specimen_button" class="btn">'.util_lang('add_specimen').'</a></li>'."\n"; // if ($this->specimens) { // foreach ($this->specimens as $specimen) { // $rendered .= ' <li id="list_item-specimen_'.$specimen->specimen_id.'">'.$specimen->renderAsEditEmbed()."</li>\n"; // } // } else { // $rendered .= '<li>'.util_lang('no_metadata','ucfirst').'</li>'."\n"; // } // $rendered .= " </ul>\n"; $rendered .= '<input type="hidden" id="initial_page_field_ids" name="initial_page_field_ids" value="' . implode(',', Db_Linked::arrayOfAttrValues($this->page_fields, 'notebook_page_field_id')) . '"/>' . "\n"; $rendered .= '<input type="hidden" id="created_page_field_ids" name="created_page_field_ids" value=""/>' . "\n"; $rendered .= '<input type="hidden" id="deleted_page_field_ids" name="deleted_page_field_ids" value=""/>' . "\n"; $rendered .= '<input type="hidden" id="initial_specimen_ids" name="initial_specimen_ids" value="' . implode(',', Db_Linked::arrayOfAttrValues($this->specimens, 'specimen_id')) . '"/>' . "\n"; $rendered .= '<input type="hidden" id="created_specimen_ids" name="created_specimen_ids" value=""/>' . "\n"; $rendered .= '<input type="hidden" id="deleted_specimen_ids" name="deleted_specimen_ids" value=""/>' . "\n"; } $rendered .= '</form>' . "\n"; $rendered .= "</div>"; return $rendered; }
public function renderAsOption($flag_is_selected = false) { $this->cacheReferences(); $rendered = '<option data-metadata_term_value_id="' . $this->metadata_term_value_id . '" data-description="' . htmlentities($this->description) . '" data-ARRAY_metadata_reference_ids="' . implode(',', Db_Linked::arrayOfAttrValues($this->references, 'metadata_reference_id')) . '" title="' . htmlentities($this->description) . '" value="' . $this->metadata_term_value_id . '"' . ($flag_is_selected ? ' selected="selected"' : '') . '>' . htmlentities($this->name) . '</option>'; return $rendered; }
function testRenderAsOption() { // $flag_selected // $this->todo(); $mdtv = Metadata_Term_Value::getOneFromDb(['metadata_term_value_id' => 6210], $this->DB); $mdtv->loadReferences(); //-------------------------- $canonical_not_selected = '<option data-metadata_term_value_id="' . $mdtv->metadata_term_value_id . '" data-description="' . htmlentities($mdtv->description) . '" data-ARRAY_metadata_reference_ids="' . implode(',', Db_Linked::arrayOfAttrValues($mdtv->references, 'metadata_reference_id')) . '" title="' . htmlentities($mdtv->description) . '" value="' . $mdtv->metadata_term_value_id . '">' . htmlentities($mdtv->name) . '</option>'; $rendered = $mdtv->renderAsOption(); // echo "<pre>\n".htmlentities($canonical_not_selected)."\n-------\n".htmlentities($rendered)."\n</pre>"; $this->assertEqual($canonical_not_selected, $rendered); $this->assertNoPattern('/IMPLEMENTED/', $rendered); //-------------------------- $canonical_selected = '<option data-metadata_term_value_id="' . $mdtv->metadata_term_value_id . '" data-description="' . htmlentities($mdtv->description) . '" data-ARRAY_metadata_reference_ids="' . implode(',', Db_Linked::arrayOfAttrValues($mdtv->references, 'metadata_reference_id')) . '" title="' . htmlentities($mdtv->description) . '" value="' . $mdtv->metadata_term_value_id . '" selected="selected">' . htmlentities($mdtv->name) . '</option>'; $rendered = $mdtv->renderAsOption(true); // echo "<pre>\n".htmlentities($canonical_selected)."\n-------\n".htmlentities($rendered)."\n</pre>"; $this->assertEqual($canonical_selected, $rendered); $this->assertNoPattern('/IMPLEMENTED/', $rendered); }
function testRenderAsEdit_owner() { // $this->todo(); $np = Notebook_Page::getOneFromDb(['notebook_page_id' => 1101], $this->DB); $np->loadPageFields(); $np->loadSpecimens(); $n = $np->getNotebook(); $ap = $np->getAuthoritativePlant(); global $USER, $DB; $USER = User::getOneFromDb(['username' => TESTINGUSER], $this->DB); $DB = $this->DB; // $this->todo('add canonical code for how to handle authoritative plant selection'); // <h3 class="notebook_page_title">'.$n->renderAsLink().': '.$ap->renderAsShortText().'</h3> $canonical = '<div id="rendered_notebook_page_1101" class="rendered_notebook_page edit_rendered_notebook_page" ' . $np->fieldsAsDataAttribs() . ' data-can-edit="1"> <form id="form-edit-notebook-page-base-data" action="' . APP_ROOT_PATH . '/app_code/notebook_page.php"> <input type="hidden" name="action" value="update"/> <input type="hidden" id="notebook_page_id" name="notebook_page_id" value="' . $np->notebook_page_id . '"/> <input type="hidden" id="notebook_id" name="notebook_id" value="1001"/> <div id="actions"><button id="edit-submit-control" class="btn btn-success" type="submit" name="edit-submit-control" value="update"><i class="icon-ok-sign icon-white"></i> Update</button> <a id="edit-cancel-control" class="btn" href="/digitalfieldnotebooks/app_code/notebook_page.php?action=view¬ebook_page_id=1101"><i class="icon-remove"></i> Cancel</a> <a id="edit-delete-notebook-page-control" class="btn btn-danger" href="/digitalfieldnotebooks/app_code/notebook_page.php?action=delete¬ebook_page_id=1101"><i class="icon-trash icon-white"></i> Delete</a></div> <h4>' . util_lang('page_in_notebook', 'ucfirst') . ' <a href="' . APP_ROOT_PATH . '/app_code/notebook.php?action=view¬ebook_id=' . $n->notebook_id . '" id="parent-notebook-link">' . htmlentities($n->name) . '</a></h4> <a class="show-hide-control" href="#" data-for_elt_id="select_new_authoritative_plant_1101">select or change the plant</a> <div id="select_new_authoritative_plant_1101" class="select_new_authoritative_plant">' . Authoritative_Plant::renderControlSelectAllAuthoritativePlants($ap->authoritative_plant_id) . '</div> ' . $ap->renderAsViewEmbed() . ' <div class="info-timestamps"><span class="created_at">' . util_lang('created_at') . ' ' . util_datetimeFormatted($np->created_at) . '</span>, <span class="updated_at">' . util_lang('updated_at') . ' ' . util_datetimeFormatted($np->updated_at) . '</span></div> <div class="info-owner">' . util_lang('owned_by') . ' <a href="' . APP_ROOT_PATH . '/app_code/user.php?action=view&user_id=101">' . htmlentities($USER->screen_name) . '</a></div> <div class="control-workflows"> <span class="published_state workflow-control"><input id="notebook-page-workflow-publish-control" type="checkbox" name="flag_workflow_published" value="1" /> ' . util_lang('publish') . '</span>, <span class="verified_state verified_state_false workflow-info">' . util_lang('verified_false') . '</span><br/> </div> <div class="notebook_page_notes"><textarea id="notebook-page-notes" name="notes" rows="4" cols="120">testing notebook page the first in testnotebook1, owned by user 101</textarea></div> <h4>' . ucfirst(util_lang('metadata')) . '</h4> <ul class="notebook-page-fields"> '; $canonical .= ' <li><a href="#" id="add_new_notebook_page_field_button" class="btn">' . util_lang('add_notebook_page_field') . '</a></li>' . "\n"; if ($np->page_fields) { $prev_pf_structure_id = $np->page_fields[0]->label_metadata_structure_id; foreach ($np->page_fields as $pf) { $spacer_class = ''; if ($pf->label_metadata_structure_id != $prev_pf_structure_id) { $spacer_class = 'spacing-list-item'; } $canonical .= ' ' . $pf->renderAsListItemEdit('list_item-notebook_page_field_' . $pf->notebook_page_field_id, [$spacer_class]) . "\n"; $prev_pf_structure_id = $pf->label_metadata_structure_id; } } else { $canonical .= '<li>' . util_lang('no_metadata', 'ucfirst') . '</li>' . "\n"; } $canonical .= ' </ul> <h4>' . ucfirst(util_lang('specimens')) . '</h4> <ul class="specimens"> '; // $this->todo('refine canonical code for new page specimen'); $canonical .= ' <li><a href="#" id="add_new_specimen_button" class="btn">' . util_lang('add_specimen') . '</a></li>' . "\n"; foreach ($np->specimens as $specimen) { $canonical .= ' <li id="list_item-specimen_' . $specimen->specimen_id . '">' . $specimen->renderAsEditEmbed() . "</li>\n"; } $canonical .= ' </ul>' . "\n"; $canonical .= '<input type="hidden" id="initial_page_field_ids" name="initial_page_field_ids" value="' . implode(',', Db_Linked::arrayOfAttrValues($np->page_fields, 'notebook_page_field_id')) . '"/>' . "\n"; $canonical .= '<input type="hidden" id="created_page_field_ids" name="created_page_field_ids" value=""/>' . "\n"; $canonical .= '<input type="hidden" id="deleted_page_field_ids" name="deleted_page_field_ids" value=""/>' . "\n"; $canonical .= '<input type="hidden" id="initial_specimen_ids" name="initial_specimen_ids" value="' . implode(',', Db_Linked::arrayOfAttrValues($np->specimens, 'specimen_id')) . '"/>' . "\n"; $canonical .= '<input type="hidden" id="created_specimen_ids" name="created_specimen_ids" value=""/>' . "\n"; $canonical .= '<input type="hidden" id="deleted_specimen_ids" name="deleted_specimen_ids" value=""/>' . "\n"; $canonical .= '</form> </div>'; $rendered = $np->renderAsEdit(); // echo "<pre> //----------- //".htmlentities($canonical)." //----------- //".htmlentities($rendered)." //----------- //</pre>"; $this->assertEqual($canonical, $rendered); $this->assertNoPattern('/IMPLEMENTED/', $rendered); }