protected function searchResult($data)
{
require_once APPROOT . 'mod/analysis/analysisModule.class.php';
$analysisModule = new analysisModule();
$dataArray = array();
$_REQUEST['search_type'] = "event";
//var_dump($_REQUEST);
foreach ($_REQUEST as $key => $element) {
if ($_REQUEST[$key] != null) {
$_GET[$key] = $_REQUEST[$key];
}
}
$sqlStatement = $analysisModule->generateSqlforEntity('event', null, $_REQUEST, 'search');
$entity_type_form_results = generate_formarray('event', 'search_view');
$entity_type_form_results['event_record_number']['type'] = 'text';
$field_list = array();
foreach ($entity_type_form_results as $field_name => $field) {
$field_list[$field['map']['field']] = $field['label'];
}
foreach ($entity_type_form_results as $fieldName => &$field) {
$field['extra_opts']['help'] = null;
$field['label'] = null;
$field['extra_opts']['clari'] = null;
$field['extra_opts']['value'] = $_GET[$fieldName];
$field['extra_opts']['required'] = null;
}
$entity_fields_html = shn_form_get_html_fields($entity_type_form_results);
$htmlFields = array();
//iterate through the search fields, checking input values
foreach ($entity_type_form_results as $field_name => $x) {
// Generates the view's Label list
$htmlFields[$field_name] = $entity_fields_html[$field_name];
}
$result_pager = Browse::getExecuteSql($sqlStatement);
$columnValues = $result_pager->get_page_data();
$columnValues = set_links_in_recordset($columnValues, 'event');
set_huriterms_in_record_array($entity_type_form_results, $columnValues);
//rendering the view
$columnNames = $field_list;
$this->htmlFields = $htmlFields;
if ($columnValues != null && count($columnValues)) {
$result_pager->render_pages();
shn_form_get_html_event_search_ctrl($columnNames, $columnValues, $htmlFields, $_GET['mod'], $_GET['act']);
$result_pager->render_pages();
} else {
shnMessageQueue::addInformation(_t('NO_RECORDS_WERE_FOUND_'));
echo shnMessageQueue::renderMessages();
}
}
public function act_browse()
{
global $conf;
include_once APPROOT . 'inc/lib_form.inc';
require_once APPROOT . 'mod/analysis/analysisModule.class.php';
$analysisModule = new analysisModule();
$sqlStatement = $analysisModule->generateSqlforEntity('supporting_docs_meta', null, $_GET, 'browse');
$entity_type_form_results = generate_formarray('supporting_docs_meta', 'browse');
$entity_type_form_results['doc_id']['type'] = 'text';
if (isset($entity_type_form_results['format'])) {
$entity_type_form_results['format']['type'] = 'text';
}
$field_list = array();
foreach ($entity_type_form_results as $field_name => $field) {
// Generates the view's Label list
$field_list[$field['map']['field']] = $field['label'];
}
if (is_array($conf['browsefields']['supporting_docs_meta']) && in_array("eventslinks", $conf['browsefields']['supporting_docs_meta'])) {
$field_list['eventslinks'] = _t('LINKS');
}
foreach ($entity_type_form_results as $fieldName => &$field) {
$field['extra_opts']['help'] = null;
$field['label'] = null;
$field['extra_opts']['clari'] = null;
$field['extra_opts']['value'] = $_GET[$fieldName];
$field['extra_opts']['required'] = null;
$field['extra_opts']['class'] = "input-block-level";
}
$entity_fields_html = shn_form_get_html_fields($entity_type_form_results);
$htmlFields = array();
//iterate through the search fields, checking input values
foreach ($entity_type_form_results as $field_name => $x) {
// Generates the view's Label list
$htmlFields[$field_name] = $entity_fields_html[$field_name];
}
$this->result_pager = Browse::getExecuteSql($sqlStatement);
$this->result_pager->setArgumentEncoder($this->argumentEncoder);
$this->columnValues = $this->result_pager->get_page_data();
$this->columnValues = set_links_in_recordset($this->columnValues, 'supporting_docs_meta');
set_huriterms_in_record_array($entity_type_form_results, $this->columnValues);
foreach ($this->columnValues as $k => $v) {
$linksa = array();
$links = Browse::getDocumentLinks($v['doc_id'], 'event');
foreach ($links as $record) {
$linksa[] = "<a href=\"" . get_record_url($record['record_number'], "event") . "\" >" . $record['record_number'] . "</a>";
}
$this->columnValues[$k]['eventslinks'] = implode("<br/>", $linksa);
}
//rendering the view
$this->columnNames = $field_list;
$this->htmlFields = $htmlFields;
//var_dump($this->columnNames , $this->columnValues , $htmlFields );
}
protected function searchResult()
{
include_once APPROOT . 'inc/lib_form.inc';
require_once APPROOT . 'mod/analysis/analysisModule.class.php';
$analysisModule = new analysisModule();
$sqlStatement = $analysisModule->generateSqlforEntity('supporting_docs_meta', null, $_POST, 'search');
$entity_type_form_results = generate_formarray('supporting_docs_meta', 'browse');
$entity_type_form_results['doc_id']['type'] = 'text';
$field_list = array();
foreach ($entity_type_form_results as $field_name => $field) {
$field_list[$field['map']['field']] = $field['label'];
}
foreach ($entity_type_form_results as $fieldName => &$field) {
$field['extra_opts']['help'] = null;
$field['label'] = null;
$field['extra_opts']['clari'] = null;
$field['extra_opts']['value'] = $_GET[$fieldName];
$field['extra_opts']['required'] = null;
}
$entity_fields_html = shn_form_get_html_fields($entity_type_form_results);
$htmlFields = array();
//iterate through the search fields, checking input values
foreach ($entity_type_form_results as $field_name => $x) {
// Generates the view's Label list
$htmlFields[$field_name] = $entity_fields_html[$field_name];
}
$result_pager = Browse::getExecuteSql($sqlStatement);
$columnValues = $result_pager->get_page_data();
$columnValues = set_links_in_recordset($columnValues, 'supporting_docs_meta');
set_huriterms_in_record_array($entity_type_form_results, $columnValues);
//rendering the view
$columnNames = $field_list;
$this->htmlFields = $htmlFields;
if ($columnValues != null && count($columnValues)) {
$result_pager->render_post_pages();
shn_form_get_html_doc_search_ctrl($columnNames, $columnValues, $htmlFields);
$result_pager->render_post_pages();
} else {
shnMessageQueue::addInformation(_t('NO_RECORDS_WERE_FOUND_'));
echo shnMessageQueue::renderMessages();
}
}
public function act_browse_intervention()
{
include_once APPROOT . 'inc/lib_form.inc';
//$notIn = acl_list_acts_permissons();
$notIn = 'allowed_records';
// passed to generateSql function to use the temporary table to find the allowed records
require_once APPROOT . 'mod/analysis/analysisModule.class.php';
$analysisModule = new analysisModule();
$sqlStatement = $analysisModule->generateSqlforEntity('intervention', null, $_GET, 'browse');
$entity_type_form_results = generate_formarray('intervention', 'browse');
$entity_type_form_results['intervention_record_number']['type'] = 'text';
$field_list = array();
foreach ($entity_type_form_results as $field_name => $field) {
// Generates the view's Label list
$field_list[$field['map']['field']] = $field['label'];
}
foreach ($entity_type_form_results as $fieldName => &$field) {
$field['extra_opts']['help'] = null;
$field['label'] = null;
$field['extra_opts']['clari'] = null;
$field['extra_opts']['value'] = $_GET[$fieldName];
$field['extra_opts']['required'] = null;
$field['extra_opts']['class'] = "input-block-level";
}
$entity_fields_html = shn_form_get_html_fields($entity_type_form_results);
$htmlFields = array();
//iterate through the search fields, checking input values
foreach ($entity_type_form_results as $field_name => $x) {
// Generates the view's Label list
$htmlFields[$field_name] = $entity_fields_html[$field_name];
}
//var_dump($sqlStatement);
$this->result_pager = Browse::getExecuteSql($sqlStatement);
$this->columnValues = $this->result_pager->get_page_data();
$additionalurlfields = array();
$additionalurlfields["event"] = array("entity" => "event", "val" => "event");
$additionalurlfields["victim"] = array("entity" => "victim", "val" => "victim");
$additionalurlfields["intervening_party"] = array("entity" => "intervening_party", "val" => "intervening_party");
$this->columnValues = set_links_in_recordset($this->columnValues, 'intervention', $additionalurlfields);
// var_dump($this->columnValues);exit;
set_huriterms_in_record_array($entity_type_form_results, $this->columnValues);
//rendering the view
$this->columnNames = $field_list;
$this->htmlFields = $htmlFields;
}
