/**
* Method called when posting the form. Saves the subscription details to the warehouse.
* @param $args
* @param $auth
* @throws \exception
*/
private static function subscribe($args, $auth)
{
$url = data_entry_helper::$base_url . 'index.php/services/species_alerts/register?';
$params = array('auth_token' => $auth['write_tokens']['auth_token'], 'nonce' => $auth['write_tokens']['nonce'], 'first_name' => $_POST['first_name'], 'surname' => $_POST['surname'], 'email' => $_POST['email'], 'website_id' => $args['website_id'], 'alert_on_entry' => $_POST['species_alert:alert_on_entry'] ? 't' : 'f', 'alert_on_verify' => $_POST['species_alert:alert_on_verify'] ? 't' : 'f');
if (!empty($_POST['species_alert:id'])) {
$params['id'] = $_POST['species_alert:id'];
}
if (!empty($_POST['species_alert:taxon_list_id'])) {
$params['taxon_list_id'] = $_POST['species_alert:taxon_list_id'];
}
if (!empty($_POST['species_alert:location_id'])) {
$params['location_id'] = $_POST['species_alert:location_id'];
}
if (!empty($_POST['user_id'])) {
$params['user_id'] = $_POST['user_id'];
}
if (!empty($_POST['taxa_taxon_list_id'])) {
// We've got a taxa_taxon_list_id in the post data. But, it is better to subscribe via a taxon
// meaning ID, or even better, the external key.
$taxon = data_entry_helper::get_population_data(array('table' => 'taxa_taxon_list', 'extraParams' => $auth['read'] + array('id' => $_POST['taxa_taxon_list_id'], 'view' => 'cache')));
if (count($taxon) !== 1) {
throw new exception('Unable to find unique taxon when attempting to subscribe');
}
$taxon = $taxon[0];
if (!empty($taxon['external_key'])) {
$params['external_key'] = $taxon['external_key'];
} else {
$params['taxon_meaning_id'] = $taxon['taxon_meaning_id'];
}
} elseif (!empty($_POST['species_alert:external_key'])) {
$params['external_key'] = $_POST['species_alert:external_key'];
} elseif (!empty($_POST['species_alert:taxon_meaning_id'])) {
$params['taxon_meaning_id'] = $_POST['species_alert:taxon_meaning_id'];
}
$url .= data_entry_helper::array_to_query_string($params, true);
$result = data_entry_helper::http_post($url);
if ($result['result']) {
hostsite_show_message(lang::get('Your subscription has been saved.'));
} else {
hostsite_show_message(lang::get('There was a problem saving your subscription.'));
if (function_exists('watchdog')) {
watchdog('iform', 'Species alert error on save: ' . print_r($result, true));
}
}
}
private static function get_success_page($args, $auth, $sample_id)
{
$reload = data_entry_helper::get_reload_link_parts();
if (isset($reload['params']['occurrence_id'])) {
unset($reload['params']['occurrence_id']);
}
if (isset($reload['params']['sample_id'])) {
unset($reload['params']['sample_id']);
}
$reload['params']['new'] = "1";
$newPath = $reload['path'] . '?' . data_entry_helper::array_to_query_string($reload['params']);
unset($reload['params']['new']);
$reload['params']['sample_id'] = $sample_id;
$reloadPath = $reload['path'] . '?' . data_entry_helper::array_to_query_string($reload['params']);
$attributes = data_entry_helper::getAttributes(array('valuetable' => 'sample_attribute_value', 'attrtable' => 'sample_attribute', 'key' => 'sample_id', 'fieldprefix' => 'smpAttr', 'extraParams' => $auth['read'] + array("untranslatedCaption" => "Shore Height"), 'survey_id' => $args['survey_id'], 'sample_method_id' => $args['transect_level_sample_method_id'], 'id' => $sample_id));
$shore = '';
foreach ($attributes as $attribute) {
if ($attribute['untranslatedCaption'] == 'Shore Height') {
$shore = ' (' . $attribute['displayValue'] . ' ' . $attribute['caption'] . ')';
}
}
$r = '<h1>' . lang::get('Thank you!') . '</h1>' . '<h2>' . lang::get('Your survey data is a valuable contribution to the Capturing Our Coast programme.') . '</h2>' . '<p>' . str_replace(array('{name}', '{date}', '{shore}'), array(data_entry_helper::$entity_to_load['sample:location_name'], data_entry_helper::$entity_to_load['sample:date'], $shore), lang::get('You have completed entering your data for Transect "{name}" {shore} on {date}. ' . 'You can now choose to do one of several different things:')) . '</p><ul>' . '<li>' . str_replace('{newpath}', $newPath, lang::get('You can enter visit details for a new Transect by clicking <a href="{newpath}">here</a>.')) . '</li>' . '<li>' . str_replace('{reloadpath}', $reloadPath, lang::get('You can go back into the Transect you have just entered, to modify the data or upload photos, by clicking <a href="{reloadpath}">here</a>.')) . '</li>' . '<li>' . lang::get('Alternatively, you can choose one of the options in the main menu above, e.g. to explore your records.') . '</li>' . '</ul>';
return $r;
}
/**
* Return the generated form output.
* @param array $args List of parameter values passed through to the form depending on how the form has been configured.
* This array always contains a value for language.
* @param object $node The Drupal node object.
* @param array $response When this form is reloading after saving a submission, contains the response from the service call.
* Note this does not apply when redirecting (in this case the details of the saved object are in the $_GET data).
* @return Form HTML.
*/
public static function get_form($args, $node, $response = null)
{
if (!($user_id = hostsite_get_user_field('indicia_user_id'))) {
return self::abort('Please ensure that you\'ve filled in your surname on your user profile before leaving a group.', $args);
}
if (empty($_GET['group_id'])) {
return self::abort('This form must be called with a group_id in the URL parameters.', $args);
}
$r = '';
$auth = data_entry_helper::get_read_write_auth($args['website_id'], $args['password']);
$group = data_entry_helper::get_population_data(array('table' => 'group', 'extraParams' => $auth['read'] + array('id' => $_GET['group_id']), 'nocache' => true));
if (count($group) !== 1) {
return self::abort('The group you\'ve requested membership of does not exist.', $args);
}
iform_load_helpers(array('submission_builder'));
$group = $group[0];
// Check for an existing group user record
$existing = data_entry_helper::get_population_data(array('table' => 'groups_user', 'extraParams' => $auth['read'] + array('group_id' => $_GET['group_id'], 'user_id' => $user_id), 'nocache' => true));
if (count($existing) !== 1) {
return self::abort('You are not a member of this group.', $args);
}
if (!empty($_POST['response']) && $_POST['response'] === lang::get('Cancel')) {
drupal_goto($args['groups_page_path']);
} elseif (!empty($_POST['response']) && $_POST['response'] === lang::get('Confirm')) {
$data = array('groups_user:id' => $existing[0]['id'], 'groups_user:group_id' => $group['id'], 'groups_user:user_id' => $user_id, 'deleted' => 't');
$wrap = submission_builder::wrap($data, 'groups_user');
$response = data_entry_helper::forward_post_to('groups_user', $wrap, $auth['write_tokens']);
if (isset($response['success'])) {
hostsite_show_message("You are no longer participating in {$group['title']}!");
drupal_goto($args['groups_page_path']);
} else {
return self::abort('An error occurred whilst trying to update your group membership.');
}
} else {
// First access of the form. Let's get confirmation
$reload = data_entry_helper::get_reload_link_parts();
$reloadpath = $reload['path'] . '?' . data_entry_helper::array_to_query_string($reload['params']);
$r = '<form action="' . $reloadpath . '" method="POST"><fieldset>';
$r .= '<legend>' . lang::get('Confirmation') . '</legend>';
$r .= '<input type="hidden" name="leave" value="1" />';
$r .= '<p>' . lang::get('Are you sure you want to stop participating in {1}?', $group['title']) . '</p>';
$r .= '<input type="submit" value="' . lang::get('Confirm') . '" name="response" />';
$r .= '<input type="submit" value="' . lang::get('Cancel') . '" name="response" />';
$r .= '</fieldset></form>';
}
return $r;
}
/**
* Save button takes us to the next transect.
*/
public static function get_redirect_on_success($values, $args)
{
if (!empty($values['next-zone']) && !empty($values['next-transect'])) {
return $args['redirect_on_success'] . '?' . data_entry_helper::array_to_query_string(array('table' => 'sample', 'id' => $values['sample:parent_id'], 'zone' => $values['next-zone'], 'transect' => $values['next-transect']));
} else {
return $args['front_page_path'];
}
}
public static function report_picker($args, $node, $readAuth)
{
$r = '<ul class="categories">';
$available = self::get_reports();
$regionTerm = self::get_region_term($args, $readAuth);
foreach ($available as $catName => $catDef) {
$catDef['title'] = str_replace('#main_location_layer_type#', $regionTerm, $catDef['title']);
$catTitleDone = false;
foreach ($catDef['reports'] as $report => $reportDef) {
$reportDef['title'] = str_replace('#main_location_layer_type#', $regionTerm, $reportDef['title']);
$reportDef['description'] = str_replace('#main_location_layer_type#', $regionTerm, $reportDef['description']);
$argName = "report_{$catName}_{$report}";
if (!empty($args[$argName]) && $args[$argName]) {
if (!$catTitleDone) {
$r .= "<li>\n";
$r .= "<h2>{$catDef['title']}</h2>\n<ul class=\"reports\">";
$catTitleDone = true;
}
$r .= "<li><h3>{$reportDef['title']}</h3><p>{$reportDef['description']}</p>";
$reload = data_entry_helper::get_reload_link_parts();
$path = $reload['path'] . '?' . data_entry_helper::array_to_query_string($reload['params'] + array('catname' => $catName, 'report' => $report));
$r .= '<ul class="report-outputs">';
foreach ($reportDef['outputs'] as $idx => $output) {
$outputLabel = str_replace('_', ' ', $output);
$r .= "<li><a class=\"link-{$output}\" href=\"{$path}&output={$output}\"/>View {$outputLabel}</a></li>";
}
$r .= '</ul>';
$r .= '</li>';
}
}
if ($catTitleDone) {
$r .= '</ul></li>';
}
}
$r .= '</ul>';
return $r;
}
/**
* Outputs the form for mapping columns to the import fields.
* @param array $options Options array passed to the import control.
*/
private static function upload_mappings_form($options)
{
//The Shorewatch importer only supports 4326 as this is required for the occurrence sample grid reference
//calculations to work. This can be hardcoded.
$_POST['sample:entered_sref_system'] = 4326;
$_SESSION['importSettingsToCarryForward'] = $_POST;
if (!file_exists($_SESSION['uploaded_file'])) {
return lang::get('upload_not_available');
}
data_entry_helper::add_resource('jquery_ui');
$filename = basename($_SESSION['uploaded_file']);
// If the last step was skipped because the user did not have any settings to supply, presetSettings contains the presets.
// Otherwise we'll use the settings form content which already in $_POST so will overwrite presetSettings.
if (isset($options['presetSettings'])) {
$settings = array_merge($options['presetSettings'], $_POST);
} else {
$settings = $_POST;
}
// only want defaults that actually have a value - others can be set on a per-row basis by mapping to a column
foreach ($settings as $key => $value) {
if (empty($value)) {
unset($settings[$key]);
}
}
//The Shorewatch importer only supports 4326 as this is required for the occurrence sample grid reference
//calculations to work. This can be hardcoded.
$settings['sample:entered_sref_system'] = 4326;
// cache the mappings
$metadata = array('settings' => json_encode($settings));
$post = array_merge($options['auth']['write_tokens'], $metadata);
$request = data_entry_helper::$base_url . "index.php/services/import/cache_upload_metadata?uploaded_csv={$filename}";
$response = data_entry_helper::http_post($request, $post);
if (!isset($response['output']) || $response['output'] != 'OK') {
return "Could not upload the settings metadata. <br/>" . print_r($response, true);
}
$request = data_entry_helper::$base_url . "index.php/services/import/get_import_fields/" . $options['model'];
$request .= '?' . data_entry_helper::array_to_query_string($options['auth']['read']);
// include survey and website information in the request if available, as this limits the availability of custom attributes
if (!empty($settings['website_id'])) {
$request .= '&website_id=' . trim($settings['website_id']);
}
if (!empty($settings['survey_id'])) {
$request .= '&survey_id=' . trim($settings['survey_id']);
}
$response = data_entry_helper::http_post($request, array());
$fields = json_decode($response['output'], true);
if (!is_array($fields)) {
return "curl request to {$request} failed. Response " . print_r($response, true);
}
$request = str_replace('get_import_fields', 'get_required_fields', $request);
$response = data_entry_helper::http_post($request);
$responseIds = json_decode($response['output'], true);
if (!is_array($responseIds)) {
return "curl request to {$request} failed. Response " . print_r($response, true);
}
$model_required_fields = self::expand_ids_to_fks($responseIds);
if (!empty($settings)) {
$preset_fields = self::expand_ids_to_fks(array_keys($settings));
} else {
$preset_fields = array();
}
if (!empty($preset_fields)) {
$unlinked_fields = array_diff_key($fields, array_combine($preset_fields, $preset_fields));
} else {
$unlinked_fields = $fields;
}
// only use the required fields that are available for selection - the rest are handled somehow else
$unlinked_required_fields = array_intersect($model_required_fields, array_keys($unlinked_fields));
ini_set('auto_detect_line_endings', 1);
$handle = fopen($_SESSION['uploaded_file'], "r");
$columns = fgetcsv($handle, 1000, ",");
$reload = data_entry_helper::get_reload_link_parts();
$reloadpath = $reload['path'] . '?' . data_entry_helper::array_to_query_string($reload['params']);
self::clear_website_survey_fields($unlinked_fields, $settings);
self::clear_website_survey_fields($unlinked_required_fields, $settings);
$savedFieldMappings = array();
// Note the Shorewatch importer doesn't currently support remembered fields, so set this to false (we are reusing a lot of the import_helper code, so leave the variable in the code as it already has proven reliability).
self::$rememberingMappings = false;
// if the user checked the Remember All checkbox, save it in a variable
if (isset($savedFieldMappings['RememberAll'])) {
$checked['RememberAll'] = 'checked';
}
$r = "<form method=\"post\" id=\"entry_form\" action=\"{$reloadpath}\" class=\"iform\">\n" . '<p>' . lang::get('column_mapping_instructions') . '</p>' . '<div class="ui-helper-clearfix import-mappings-table"><table class="ui-widget ui-widget-content">' . '<thead class="ui-widget-header">' . "<tr><th>Column in CSV File</th><th>Maps to attribute</th>";
if (self::$rememberingMappings) {
$r .= "<th id='remember-all-header' name='remember-all-header'>" . lang::get('Remember choice?') . "<br/><input type='checkbox' name='RememberAll' id='RememberAll' value='1' title='Tick all boxes to remember every column mapping next time you import.' {$checked['RememberAll']} onclick='\n if (this.checked) {\n \$(\".rememberField\").attr(\"checked\",\"checked\")\n } else {\n \$(\".rememberField\").removeAttr(\"checked\")\n }'/></th>";
}
$r .= '</tr></thead><tbody>';
foreach ($columns as $column) {
$colFieldName = preg_replace('/[^A-Za-z0-9]/', '_', $column);
$r .= "<tr><td>{$column}</td><td><select name=\"{$colFieldName}\" id=\"{$colFieldName}\">";
$r .= self::get_column_options($options['model'], $unlinked_fields, $column, ' ', $savedFieldMappings);
$r .= "</select></td></tr>\n";
}
$r .= '</tbody>';
$r .= '</table>';
$r .= '<div id="required-instructions" class="import-mappings-instructions"><h2>' . lang::get('Tasks') . '</h2><span>' . lang::get('The following database attributes must be matched to a column in your import file before you can continue') . ':</span><ul></ul><br/></div>';
$r .= '<div id="duplicate-instructions" class="import-mappings-instructions"><span id="duplicate-instruct">' . lang::get('There are currently two or more drop-downs allocated to the same value.') . '</span><ul></ul><br/></div></div>';
$r .= '<input type="hidden" name="import_step" value="2" />';
$r .= '<input type="submit" name="submit" id="submit" value="' . lang::get('Upload') . '" class="ui-corner-all ui-state-default button" />';
$r .= '</form>';
data_entry_helper::$javascript .= "function detect_duplicate_fields() {\n var valueStore = [];\n var duplicateStore = [];\n var valueStoreIndex = 0;\n var duplicateStoreIndex = 0;\n \$.each(\$('#entry_form select'), function(i, select) {\n if (valueStoreIndex==0) {\n valueStore[valueStoreIndex] = select.value;\n valueStoreIndex++;\n } else {\n for(i=0; i<valueStoreIndex; i++) {\n if (select.value==valueStore[i] && select.value != '<" . lang::get('Not imported') . ">') {\n duplicateStore[duplicateStoreIndex] = select.value;\n duplicateStoreIndex++;\n }\n \n }\n valueStore[valueStoreIndex] = select.value;\n valueStoreIndex++;\n } \n })\n if (duplicateStore.length==0) {\n DuplicateAllowsUpload = 1;\n \$('#duplicate-instruct').css('display', 'none');\n } else {\n DuplicateAllowsUpload = 0;\n \$('#duplicate-instruct').css('display', 'inline');\n }\n }\n";
data_entry_helper::$javascript .= "function update_required_fields() {\n // copy the list of required fields\n var fields = \$.extend(true, {}, required_fields);\n \$('#required-instructions li').remove();\n var sampleVagueDates = [];\n // strip out the ones we have already allocated\n \$.each(\$('#entry_form select'), function(i, select) {\n delete fields[select.value];\n // special case for vague dates - if we have a complete sample vague date, then can strike out the sample:date required field\n if (select.value.substr(0,12)=='sample:date_') {\n sampleVagueDates.push(select.value);\n }\n });\n if (sampleVagueDates.length==3) {\n // got a full vague date, so can remove the required date field\n delete fields['sample:date'];\n }\n var output = '';\n \$.each(fields, function(field, caption) {\n output += '<li>'+caption+'</li>';\n });\n if (output==='') {\n \$('#required-instructions').css('display', 'none');\n RequiredAllowsUpload = 1;\n } else {\n \$('#required-instructions').css('display', 'inline');\n RequiredAllowsUpload = 0;\n }\n if (RequiredAllowsUpload == 1 && DuplicateAllowsUpload == 1) {\n \$('#submit').attr('disabled', false);\n } else {\n \$('#submit').attr('disabled', true);\n }\n \$('#required-instructions ul').html(output);\n }\n";
data_entry_helper::$javascript .= "required_fields={};\n";
foreach ($unlinked_required_fields as $field) {
$caption = $unlinked_fields[$field];
if (empty($caption)) {
$tokens = explode(':', $field);
$fieldname = $tokens[count($tokens) - 1];
$caption = lang::get(self::leadingCaps(preg_replace(array('/^fk_/', '/_id$/'), array('', ''), $fieldname)));
}
$caption = self::translate_field($field, $caption);
data_entry_helper::$javascript .= "required_fields['{$field}']='{$caption}';\n";
}
data_entry_helper::$javascript .= "detect_duplicate_fields();\n";
data_entry_helper::$javascript .= "update_required_fields();\n";
data_entry_helper::$javascript .= "\$('#entry_form select').change(function() {detect_duplicate_fields(); update_required_fields();});\n";
return $r;
}
/**
* Code to output a standardised report filtering panel.
*
* Filters can be saved and loaded by each user. Additionally, filters can define permissions to a certain task, e.g. they can be used to define the
* context within which someone can verify. In this case they provide the "outer limit" of the available records.
* Requires a [map] control on the page. If you don't want a map, the current option is to include one anyway and use css to hide the #map-container div.
*
* @param array $readAuth Pass read authorisation tokens.
* @param array $options Options array with the following possibilities:
* sharing - define the record sharing task that is being filtered against. Options are reporting (default), peer_review, verification, moderation, data_flow.
* context_id - can also be passed as URL parameter. Force the initial selection of a particular context (a record which has defines_permissions=true in the
* filters table. Set to "default" to select their profile verification settings when sharing=verification.
* filter_id - can also be passed as URL parameter. Force the initial selection of a particular filter record in the filters table.
* filterTypes - allows control of the list of filter panels available, e.g. to turn one off. Associative array keyed by category
* so that the filter panels can be grouped (use a blank key if not required). The array values are an array of or strings with a comma separated list
* of the filter types to included in the category - options are what, where, when, who, quality, source.
* filter-#name# - set the initial value of a report filter parameter #name#.
* allowLoad - set to false to disable the load bar at the top of the panel.
* allowSave - set to false to disable the save bar at the foot of the panel.
* presets - provide an array of preset filters to provide in the filters drop down. Choose from my-records, my-groups (uses
* your list of taxon groups in the user account), my-locality (uses your recording locality from the user account),
* my-groups-locality (uses taxon groups and recording locality from the user account), my-queried-records, queried-records,
* answered-records, accepted-records, not-accepted-records.
* @param integer $website_id The current website's warehouse ID.
* @param string $hiddenStuff Output parameter which will contain the hidden popup HTML that will be shown
* using fancybox during filter editing. Should be appended AFTER any form element on the page as nested forms are not allowed.
* @return string HTML for the report filter panel
*/
function report_filter_panel($readAuth, $options, $website_id, &$hiddenStuff)
{
if (function_exists('iform_load_helpers')) {
iform_load_helpers(array('report_helper'));
} else {
//When running on warehouse we don't have iform_load_helpers
require_once DOCROOT . 'client_helpers/report_helper.php';
}
if (!empty($_POST['filter:sharing'])) {
$options['sharing'] = $_POST['filter:sharing'];
}
$options = array_merge(array('sharing' => 'reporting', 'admin' => false, 'adminCanSetSharingTo' => array('R' => 'reporting', 'V' => 'verification'), 'allowLoad' => true, 'allowSave' => true, 'redirect_on_success' => '', 'presets' => array('my-records', 'my-queried-records', 'my-queried-or-not-accepted-records', 'my-not-reviewed-records', 'my-accepted-records', 'my-groups', 'my-locality', 'my-groups-locality'), 'entity' => 'occurrence'), $options);
// Introduce some extra quick filters useful for verifiers.
if ($options['sharing'] === 'verification') {
$options['presets'] = array_merge(array('queried-records', 'answered-records', 'accepted-records', 'not-accepted-records'), $options['presets']);
}
if ($options['entity'] === 'sample') {
unset($options['presets']['my-groups']);
unset($options['presets']['my-groups-locality']);
}
//If in the warehouse we don't need to worry about the iform master list.
if (function_exists('variable_get')) {
$options = array_merge(array('taxon_list_id' => variable_get('iform_master_checklist_id', 0)), $options);
}
$options['sharing'] = report_filters_sharing_code_to_full_term($options['sharing']);
$options['sharingCode'] = report_filters_full_term_to_sharing_code($options['sharing']);
if (!preg_match('/^(reporting|peer_review|verification|data_flow|moderation)$/', $options['sharing'])) {
return 'The @sharing option must be one of reporting, peer_review, verification, data_flow or moderation (currently ' . $options['sharing'] . ').';
}
report_helper::add_resource('reportfilters');
report_helper::add_resource('validation');
report_helper::add_resource('fancybox');
if (function_exists('hostsite_add_library')) {
hostsite_add_library('collapse');
}
$filterData = report_filters_load_existing($readAuth, $options['sharingCode']);
$existing = '';
$contexts = '';
// add some preset filters in
//If in the warehouse we don't need to worry about user specific preferences when setting up milestones.
if (function_exists('hostsite_get_user_field')) {
foreach ($options['presets'] as $preset) {
$title = false;
switch ($preset) {
case 'my-records':
if (hostsite_get_user_field('id')) {
$title = lang::get('My records');
}
break;
case 'my-queried-records':
if (hostsite_get_user_field('id')) {
$title = lang::get('My queried records');
}
break;
case 'my-queried-or-not-accepted-records':
if (hostsite_get_user_field('id')) {
$title = lang::get('My not accepted or queried records');
}
break;
case 'my-not-reviewed-records':
if (hostsite_get_user_field('id')) {
$title = lang::get('My not reviewed records');
}
break;
case 'my-accepted-records':
if (hostsite_get_user_field('id')) {
$title = lang::get('My accepted records');
}
break;
case 'my-groups':
if (hostsite_get_user_field('taxon_groups', false, true)) {
$title = lang::get('Records in species groups I like to record');
}
break;
case 'my-locality':
if (hostsite_get_user_field('location')) {
$title = lang::get('Records in the locality I generally record in');
}
break;
case 'my-groups-locality':
if (hostsite_get_user_field('taxon_groups', false, true) && hostsite_get_user_field('location')) {
$title = lang::get('Records of my species groups in my locality');
}
break;
case 'queried-records':
$title = lang::get('Queried records');
break;
case 'answered-records':
$title = lang::get('Records with answers');
break;
case 'accepted-records':
$title = lang::get('Accepted records');
break;
case 'not-accepted-records':
$title = lang::get('Not accepted records');
break;
default:
throw new exception("Unsupported preset {$preset} for the filter panel");
}
if ($title) {
$presetFilter = array('id' => $preset, 'title' => $title, 'defines_permissions' => 'f');
$filterData[] = $presetFilter;
}
}
if (count($options['presets'])) {
if ($groups = hostsite_get_user_field('taxon_groups', false, true)) {
data_entry_helper::$javascript .= "indiciaData.userPrefsTaxonGroups='" . implode(',', $groups) . "';\n";
}
if ($location = hostsite_get_user_field('location')) {
data_entry_helper::$javascript .= "indiciaData.userPrefsLocation=" . $location . ";\n";
}
}
$contextDefs = array();
if ($options['sharing'] === 'verification') {
// apply legacy verification settings from their profile
$location_id = hostsite_get_user_field('location_expertise');
$taxon_group_ids = hostsite_get_user_field('taxon_groups_expertise', false, true);
$survey_ids = hostsite_get_user_field('surveys_expertise', false, true);
if ($location_id || $taxon_group_ids || $survey_ids) {
$selected = !empty($options['context_id']) && $options['context_id'] === 'default' ? 'selected="selected" ' : '';
$contexts .= "<option value=\"default\" {$selected}>" . lang::get('My verification records') . "</option>";
$def = array();
if ($location_id) {
// user profile geographic limits should always be based on an indexed location.
$def['indexed_location_id'] = $location_id;
}
if ($taxon_group_ids) {
$def['taxon_group_list'] = implode(',', $taxon_group_ids);
$def['taxon_group_names'] = array();
$groups = data_entry_helper::get_population_data(array('table' => 'taxon_group', 'extraParams' => $readAuth + array('id' => $taxon_group_ids)));
foreach ($groups as $group) {
$def['taxon_group_names'][$group['id']] = $group['title'];
}
}
if ($survey_ids) {
$def['survey_list'] = implode(',', array_filter($survey_ids));
}
$contextDefs['default'] = $def;
}
}
}
if (!empty($_GET['context_id'])) {
$options['context_id'] = $_GET['context_id'];
}
if (!empty($_GET['filter_id'])) {
$options['filter_id'] = $_GET['filter_id'];
}
if (!empty($_GET['filters_user_id'])) {
$options['filters_user_id'] = $_GET['filters_user_id'];
}
foreach ($filterData as $filter) {
if ($filter['defines_permissions'] === 't') {
$selected = !empty($options['context_id']) && $options['context_id'] == $filter['id'] ? 'selected="selected" ' : '';
$contexts .= "<option value=\"{$filter['id']}\" {$selected}>{$filter['title']}</option>";
$contextDefs[$filter['id']] = json_decode($filter['definition']);
} else {
$selected = !empty($options['filter_id']) && $options['filter_id'] == $filter['id'] ? 'selected="selected" ' : '';
$existing .= "<option value=\"{$filter['id']}\" {$selected}>{$filter['title']}</option>";
}
}
$r = '<div id="standard-params" class="ui-widget">';
if ($options['allowSave'] && $options['admin']) {
if (empty($_GET['filters_user_id'])) {
// new filter to create, so sharing type can be edited
$reload = data_entry_helper::get_reload_link_parts();
$reloadPath = $reload['path'];
if (count($reload['params'])) {
$reloadPath .= '?' . data_entry_helper::array_to_query_string($reload['params']);
}
$r .= "<form action=\"{$reloadPath}\" method=\"post\" >";
$r .= data_entry_helper::select(array('label' => lang::get('Select filter type'), 'fieldname' => 'filter:sharing', 'lookupValues' => $options['adminCanSetSharingTo'], 'afterControl' => '<input type="submit" value="Go"/>', 'default' => $options['sharingCode']));
$r .= '</form>';
} else {
// existing filter to edit, type is therefore fixed. JS will fill these values in.
$r .= '<p>' . lang::get('This filter is for <span id="sharing-type-label"></span>.') . '</p>';
$r .= data_entry_helper::hidden_text(array('fieldname' => 'filter:sharing'));
}
}
if ($options['allowLoad']) {
$r .= '<div class="header ui-toolbar ui-widget-header ui-helper-clearfix"><div><span id="active-filter-label">' . lang::get('New report') . '</span></div><span class="changed" style="display:none" title="This filter has been changed">*</span>';
$r .= '<div>';
if ($contexts) {
data_entry_helper::$javascript .= "indiciaData.filterContextDefs = " . json_encode($contextDefs) . ";\n";
if (count($contextDefs) > 1) {
$r .= '<label for="context-filter">' . lang::get('Context:') . "</label><select id=\"context-filter\">{$contexts}</select>";
} else {
$keys = array_keys($contextDefs);
$r .= '<input type="hidden" id="context-filter" value="' . $keys[0] . '" />';
}
}
$r .= '<label for="select-filter">' . lang::get('Filter:') . '</label><select id="select-filter"><option value="" selected="selected">' . lang::get('Select filter') . "...</option>{$existing}</select>";
$r .= '<button type="button" id="filter-apply">' . lang::get('Apply') . '</button>';
$r .= '<button type="button" id="filter-reset" class="disabled">' . lang::get('Reset') . '</button>';
$r .= '<button type="button" id="filter-build">' . lang::get('Create a filter') . '</button></div>';
$r .= '</div>';
$r .= '<div id="filter-details" style="display: none">';
$r .= '<img src="' . data_entry_helper::$images_path . 'nuvola/close-22px.png" width="22" height="22" alt="Close filter builder" title="Close filter builder" class="button" id="filter-done"/>' . "\n";
} else {
$r .= '<div id="filter-details">';
if (!empty($options['filter_id'])) {
$r .= "<input type=\"hidden\" id=\"select-filter\" value=\"{$options['filter_id']}\"/>";
} elseif (!empty($options['filters_user_id'])) {
$r .= "<input type=\"hidden\" id=\"select-filters-user\" value=\"{$options['filters_user_id']}\"/>";
}
}
$r .= '<div id="filter-panes">';
if ($options['entity'] === 'occurrence') {
$filters = array('filter_what' => new filter_what(), 'filter_where' => new filter_where(), 'filter_when' => new filter_when(), 'filter_who' => new filter_who(), 'filter_occurrence_id' => new filter_occurrence_id(), 'filter_quality' => new filter_quality(), 'filter_source' => new filter_source());
} elseif ($options['entity'] === 'sample') {
$filters = array('filter_where' => new filter_where(), 'filter_when' => new filter_when(), 'filter_who' => new filter_who(), 'filter_sample_id' => new filter_sample_id(), 'filter_quality' => new filter_quality_sample(), 'filter_source' => new filter_source());
}
if (!empty($options['filterTypes'])) {
$filterModules = array();
foreach ($options['filterTypes'] as $category => $list) {
// $list can be an array or comma separated list
if (is_array($list)) {
$list = implode(',', $list);
}
$paneNames = 'filter_' . str_replace(',', ',filter_', $list);
$paneList = explode(',', $paneNames);
$filterModules[$category] = array_intersect_key($filters, array_fill_keys($paneList, 1));
}
} else {
$filterModules = array('' => $filters);
}
foreach ($filterModules as $category => $list) {
if ($category) {
$r .= '<fieldset class="collapsible collapsed">' . '<legend>' . '<span class="fieldset-legend">' . $category . '</span>' . '</legend>' . '<div class="fieldset-wrapper">';
}
foreach ($list as $moduleName => $module) {
$r .= "<div class=\"pane\" id=\"pane-{$moduleName}\"><a class=\"fb-filter-link\" href=\"#controls-{$moduleName}\"><span class=\"pane-title\">" . $module->get_title() . '</span>';
$r .= '<span class="filter-desc"></span></a>';
$r .= "</div>";
}
if ($category) {
$r .= '</div></fieldset>';
}
}
$r .= '</div>';
// filter panes
$r .= '<div class="toolbar">';
if ($options['allowSave']) {
$r .= '<label for="filter:title">' . lang::get('Save filter as') . ':</label> <input id="filter:title" class="control-width-5"/>';
if ($options['admin']) {
$r .= '<br/>';
if (empty($options['adminCanSetSharingTo'])) {
throw new exception('Report standard params panel in admin mode so adminCanSetSharingTo option must be populated.');
}
$r .= data_entry_helper::autocomplete(array('label' => 'For who?', 'fieldname' => 'filters_user:user_id', 'table' => 'user', 'valueField' => 'id', 'captionField' => 'person_name', 'formatFunction' => "function(item) { return item.person_name + ' (' + item.email_address + ')'; }", 'extraParams' => $readAuth + array('view' => 'detail'), 'class' => 'control-width-5'));
$r .= data_entry_helper::textarea(array('label' => 'Description', 'fieldname' => 'filter:description'));
}
$r .= '<img src="' . data_entry_helper::$images_path . 'nuvola/save-22px.png" width="22" height="22" alt="Save filter" title="Save filter" class="button" id="filter-save"/>';
$r .= '<img src="' . data_entry_helper::$images_path . 'trash-22px.png" width="22" height="22" alt="Bin this filter" title="Bin this filter" class="button disabled" id="filter-delete"/>';
}
$r .= '</div></div>';
// toolbar + clearfix
if (!empty($options['filters_user_id'])) {
// if we are preloading based on a filter user ID, we need to get the information now so that the sharing mode can be known
// when loading controls
$fu = data_entry_helper::get_population_data(array('table' => 'filters_user', 'extraParams' => $readAuth + array('id' => $options['filters_user_id']), 'caching' => false));
if (count($fu) !== 1) {
throw new exception('Could not find filter user record');
}
$options['sharing'] = report_filters_sharing_code_to_full_term($fu[0]['filter_sharing']);
}
report_helper::$javascript .= "indiciaData.lang={pleaseSelect:\"" . lang::get('Please select') . "\"};\n";
// create the hidden panels required to populate the popups for setting each type of filter up.
$hiddenStuff = '';
foreach ($filterModules as $category => $list) {
foreach ($list as $moduleName => $module) {
$hiddenStuff .= "<div style=\"display: none\"><div class=\"filter-popup\" id=\"controls-{$moduleName}\"><form action=\"#\" class=\"filter-controls\"><fieldset>" . $module->get_controls($readAuth, $options) . '<button class="fb-close" type="button">Cancel</button>' . '<button class="fb-apply" type="submit">Apply</button></fieldset></form></div></div>';
$shortName = str_replace('filter_', '', $moduleName);
report_helper::$javascript .= "indiciaData.lang.NoDescription{$shortName}='" . lang::get('Click to Filter ' . ucfirst($shortName)) . "';\n";
}
}
$r .= '</div>';
report_helper::$js_read_tokens = $readAuth;
report_helper::$javascript .= "indiciaData.lang.CreateAFilter='" . lang::get('Create a filter') . "';\n";
report_helper::$javascript .= "indiciaData.lang.ModifyFilter='" . lang::get('Modify filter') . "';\n";
report_helper::$javascript .= "indiciaData.lang.FilterReport='" . lang::get('New report') . "';\n";
report_helper::$javascript .= "indiciaData.lang.FilterSaved='" . lang::get('The filter has been saved') . "';\n";
report_helper::$javascript .= "indiciaData.lang.FilterDeleted='" . lang::get('The filter has been deleted') . "';\n";
report_helper::$javascript .= "indiciaData.lang.ConfirmFilterChangedLoad='" . lang::get('Do you want to load the selected filter and lose your current changes?') . "';\n";
report_helper::$javascript .= "indiciaData.lang.FilterExistsOverwrite='" . lang::get('A filter with that name already exists. Would you like to overwrite it?') . "';\n";
report_helper::$javascript .= "indiciaData.lang.AutochecksFailed='" . lang::get('Automated checks failed') . "';\n";
report_helper::$javascript .= "indiciaData.lang.AutochecksPassed='" . lang::get('Automated checks passed') . "';\n";
report_helper::$javascript .= "indiciaData.lang.HasPhotos='" . lang::get('Records which have photos') . "';\n";
report_helper::$javascript .= "indiciaData.lang.ConfirmFilterDelete='" . lang::get('Are you sure you want to permanently delete the {title} filter?') . "';\n";
report_helper::$javascript .= "indiciaData.lang.MyRecords='" . lang::get('My records only') . "';\n";
if (function_exists('iform_ajaxproxy_url')) {
report_helper::$javascript .= "indiciaData.filterPostUrl='" . iform_ajaxproxy_url(null, 'filter') . "';\n";
report_helper::$javascript .= "indiciaData.filterAndUserPostUrl='" . iform_ajaxproxy_url(null, 'filter_and_user') . "';\n";
}
report_helper::$javascript .= "indiciaData.filterSharing='" . strtoupper(substr($options['sharing'], 0, 1)) . "';\n";
if (function_exists('hostsite_get_user_field')) {
report_helper::$javascript .= "indiciaData.user_id='" . hostsite_get_user_field('indicia_user_id') . "';\n";
} else {
report_helper::$javascript .= "indiciaData.user_id='" . $_SESSION['auth_user']->id . "';\n";
}
if (!empty($website_id)) {
report_helper::$javascript .= "indiciaData.website_id=" . $website_id . ";\n";
}
report_helper::$javascript .= "indiciaData.redirectOnSuccess='{$options['redirect_on_success']}';\n";
// load up the filter, BEFORE any AJAX load of the grid code. First fetch any URL param overrides.
$getParams = array();
$optionParams = array();
foreach ($_GET as $key => $value) {
if (substr($key, 0, 7) === 'filter-') {
$getParams[substr($key, 7)] = $value;
}
}
foreach ($options as $key => $value) {
if (substr($key, 0, 7) === 'filter-') {
$optionParams[substr($key, 7)] = $value;
}
}
$allParams = array_merge($optionParams, $getParams);
if (!empty($allParams)) {
$allParams = json_encode($allParams);
report_helper::$onload_javascript .= "var params = {$allParams};\n";
report_helper::$onload_javascript .= "indiciaData.filter.def=\$.extend(indiciaData.filter.def, params);\n";
report_helper::$onload_javascript .= "indiciaData.filter.orig=\$.extend({}, params);\n";
}
$getParams = empty($getParams) ? '{}' : json_encode($getParams);
if (!empty($options['filters_user_id'])) {
report_helper::$onload_javascript .= "loadFilterUser(" . json_encode($fu[0]) . ", {$getParams});\n";
} else {
report_helper::$onload_javascript .= "if (\$('#select-filter').val()) {\n" . " loadFilter(\$('#select-filter').val(), {$getParams});\n" . "} else {\n" . " applyFilterToReports(false);\n" . "}\n";
}
return $r;
}
