NULL, "ext_consortium_id" => $PENDING_CONSORTIUM_ID); $columns=array('site_id','name','enabled','date_created'); $sites = $api->GetSites( $filter, $columns); if (empty($sites)) { print("

No open join requests

"); return; } $headers = array(); $headers['id']='int'; $headers['Site Name']='string'; # trying the sortEnglishDateTime stuff - not too lucky so far # http://www.frequency-decoder.com/demo/table-sort-revisited/custom-sort-functions/ $headers['submitted']='sortEnglishDateTime'; $headers['enabled']='string'; $nifty=new PlekitNifty ('pending','sites-pending','medium'); $nifty->start(); $table=new PlekitTable ('pending',$headers,2, array('pagesize_area'=>FALSE,'pagesize'=>10000)); $table->start(); foreach($sites as $site) { $site_id=$site['site_id']; $link = $site['enabled'] ? l_site($site_id) : l_site_review_pending($site_id); $table->row_start(); $table->cell(href($link,$site['site_id'])); $table->cell(href($link,$site['name'])); $table->cell(date("dS F Y",$site['date_created']) . " at " . date("G:i",$site['date_created'])); $table->cell( $site['enabled'] ? plc_warning_html('yes') : 'no'); $table->row_end(); } $table->end(); $nifty->end(); } function render_join_request_review($api, $site_id) { $sites = $api->GetSites( array(intval($site_id)) ); if (empty($sites)) { print("

Invalid request with site_id=$site_id

"); return; } $site = $sites[0]; if ($site['enabled'] && $site['ext_consortium_id'] === $PENDING_CONSORTIUM_ID) { print("

This site is already enabled

"); return; } $addresses = $api->GetAddresses ($site['address_ids']); if (empty ($addresses)) { drupal_set_message("Site $site_id has no address - never mind"); $address=array('line1'=>''); $address_id=0; } else { $address = $addresses[0]; $address_id=$address['address_id']; } # just in case there is no person attached yet if (empty ($site['person_ids'])) { $persons=array(); } else { $person_ids = $site['person_ids']; $persons = $api->GetPersons( $person_ids, array( "person_id", "role_ids", "first_name", "last_name", "title", "email" , "phone") ); } $tech = Null; $pi = Null; foreach($persons as $person) { if ( in_array('20', $person['role_ids']) ) { $pi = $person; } if ( in_array('40', $person['role_ids']) ) { $tech = $person; } } $pi_id = $pi['person_id']; $tech_id = $tech['person_id']; print <<< EOF

Please review the join request below.

Warning: the PI email address that was provided in this form will not be checked automatically. We expect that as part of the handshake with the site, the support team has had an opportunity to use this address so it can be considered safe. Please check it manually if this is not the case.

EOF; // don't render the tech part if that was the same as the pi $site_form = build_site_form(FALSE); $input = array ('site' => $site, 'address'=> $address, 'pi' => $pi, 'tech' => $tech); $nifty=new PlekitNifty ('pending','site-pending','medium'); $nifty->start(); $details = new PlekitDetails(TRUE); $details->start(); // display the buttons $buttons_row =<< EOF; $details->tr($buttons_row,'center'); // render the form - not supposed to be empty form_render_details ($details,$site_form, $input, TRUE); // display the buttons again $details->tr($buttons_row,'center'); $details->end(); $nifty->end(); } function notify_enabled_pi ($api, $pi_id, $pi, $site_id, $site) { // notify the PI $template= <<NotifyPersons(array($pi_id),$subject,$body); } // find person roles $_person= $plc->person; $_roles= $_person['role_ids']; // only admins are allowed to view this page if( !in_array( '10', $_roles ) ) { print("

not allowed to view this page

"); } else if (get_array($_GET, 'review')) { //print review page drupal_set_title('Join Request - Review'); render_join_request_review($api, $_GET['site_id']); } else if (get_array($_POST, 'submitted')) { // parse the form $site_form = build_site_form(FALSE); $input = parse_form ($site_form, $_REQUEST, $input); // xxx should not happen ? $empty_form = $input['is_empty']; $error = ""; $messages= array(); if ( $empty_form ) { $error .= '

Internal error - empty form !?!

'; } if (empty ($error)) { $site=$input['site']; $address=$input['address']; $pi=$input['pi']; $tech=$input['tech']; // Look for missing/blank entries $error .= form_check_required ($site_form, $input); } if (empty($error)) { // get objects id from the request $site_id = intval(trim($_POST['site_id'])); $address_id = intval(trim($_POST['address_id'])); $pi_id = intval(trim($_POST['pi_id'])); $tech_id = intval(trim($_POST['tech_id'])); switch ($_POST['submitted']) { case 'Delete': { $api->DeleteSite ($site_id); $api_error=$api->error(); if (!empty($api_error)) { $error .= $api->error(); } else { $messages [] = "Site " . $site['name'] . " deleted"; } break; } case 'Update': { $api->begin(); $api->UpdateSite($site_id,$site); if ($address_id) $api->UpdateAddress($address_id,$address); else if(!empty($address)) $api->AddSiteAddress($site_id,$address); $api->UpdatePerson($pi_id,$pi); if ($tech_id != $pi_id) $api->UpdatePerson($tech_id,$tech); $api->commit(); $api_error=$api->error(); if (!empty($api_error)) { $error .= $api->error(); } else { $messages [] = "Join request updated for site " . $site['name'] ; } break; } case 'Approve': { // Thierry - august 22 2007 // keep it simple - the admin who approves is now supposed to check // the PI's email address, which makes the whole thing *a lot* simpler // enable the site, enable the PI, and VerifyPerson the thec if different from the PI $site['enabled'] = True; global $APPROVED_CONSORTIUM_ID; $site['ext_consortium_id'] = $APPROVED_CONSORTIUM_ID; $api->UpdateSite ($site_id,$site); $api_error=$api->error(); if (!empty($api_error)) { $error .= $api->error(); $messages [] = "Could not enable site"; } else { $messages[] = l_site_t ($site_id,"Site '" . $site['name'] . "' enabled"); } if (empty ($error) && $address_id) { // Update Address $api->UpdateAddress($address_id,$address); $api_error=$api->error(); if ( ! empty($api_error)) { $error .= $api->error(); $messages [] = "Could not update address"; } foreach ( array("Billing","Shipping") as $address_type) { $api->AddAddressTypeToAddress($address_type,$address_id); $api_error=$api->error(); if ( ! empty($api_error)) { $error .= $api->error(); $messages [] = "Could not add address type " . $address_type; } } // Update pi, and enable him $api->UpdatePerson ($pi_id,$pi); if ( $pi ['enabled' ] ) { $messages [] = "PI already enabled"; } else { $api->UpdatePerson ($pi_id,array("enabled"=>True)); $api_error=$api->error(); if (empty($api_error)) { $messages[] = "Enabled PI as " . $pi['email'] ; notify_enabled_pi ($api, $pi_id,$pi,$site_id, $site); $messages[] = "Notified PI by email"; } else { $error .= $api->error(); $messages [] = "Could not update PI"; } } if ($pi_id != $tech_id) { // Update tech, and VerifyPerson him if needed $api->UpdatePerson ($tech_id,$tech); if ( $tech [ 'enabled' ] ) { $messages [] = "Tech already enabled"; } else { $api->VerifyPerson($tech_id); $api_error=$api->error(); if (empty($api_error)) { $messages[] = "Created account registration for Tech as " . $tech['email']; } else { $error .= $api->error(); $messages [] = "Could not verify Tech"; } } } } break; } default: { $error .= '

Internal error - unexpected request

'; break; } } // end switch } // Show messages if (!empty($messages)) { print '

$line"; } print "

"; } // Show errors if any if (!empty($error)) { print '

' . $error . '

'; drupal_set_title('Join Request - Review'); render_join_request_review($api, $_POST['site_id']); } else { drupal_set_title('All currently pending join requests'); render_all_join_requests($api); } } else // list all pending requests { drupal_set_title('All currently pending join requests'); render_all_join_requests($api); } // Print footer include 'plc_footer.php'; ?>