</tr> </thead> <tbody> <?php foreach ($interventions as $record) { ?> <tr <?php echo $i++ % 2 == 1 ? 'class="odd"' : ''; ?> > <td><?php echo $record['intervention_record_number']; ?> </td> <td><?php echo get_mt_term($record['impact_on_the_situation']); ?> </td> <td><?php echo $record['date_of_intervention']; ?> </td> <td><?php echo $record['remarks']; ?> </td> </tr> <?php } ?>
echo $add; ?> ' class='delete'/></td> <td><a href="<?php echo get_url('person', 'address_list', null, array('address_id' => $add)); ?> "><?php echo get_mt_term($address->address_type); ?> </a></td> <td><?php echo $address->address; ?> </td> <td><?php echo get_mt_term($address->country); ?> </td> <td><?php echo $address->phone; ?> </td> <td><?php echo $address->cellular; ?> </td> <td><?php echo $address->fax; ?> </td> <td><?php
?> "><?php echo $record['person_name']; ?> </a></td> <td> <a href="<?php get_url('events', 'intv_list', null, array('type' => 'intv', 'intervention_id' => $record['intervention_record_number'])); ?> "> <?php echo "<ul>"; $types = Browse::getIntvTypes($record['intervention_record_number']); foreach ($types as $type) { echo "<li>" . get_mt_term($type['type_of_intervention']) . "</li>"; } echo "</ul>"; ?> </a> </td> </tr> <?php } ?> <tr class='actions'> <td colspan='8'><button type='submit' class='btn btn-grey' name='delete' > <i class="icon-trash"></i> <?php echo _t('DELETE');
?> </td> <td><?php echo $record['vname']; ?> </td> <td><?php echo get_mt_term($record['type_of_act']); ?> </td> <td><?php echo $record['pname']; ?> </td> <td><?php echo get_mt_term($record['degree_of_involvement']); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } } else { shnMessageQueue::addInformation(_t('NO_RECORDS_WERE_SELECTED_')); echo shnMessageQueue::renderMessages(); }
} if ($_GET['row'] == $i) { echo 'active'; } ?> ' > <td><?php echo $record['date_of_intervention']; ?> </td> <td><?php echo $record['name']; ?> </td> <td><?php echo get_mt_term($record['type_of_intervention']); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } ?> <center> <a class="btn" href="<?php echo get_url('events', 'intv_list', null, array('eid' => $event_id)); ?>
if ($i++ % 2 == 1) { echo "odd "; } if ($_GET['row'] == $i) { echo 'active'; } ?> ' > <td><a href="<?php echo get_url('person', 'person', null, array('pid' => $bio['related_person'])); ?> "><?php echo "<strong>" . $bio['person_name'] . "</strong>"; ?> </a><?php echo " is a/an <strong>" . get_mt_term(get_biography_reverse($bio['relationship_type'])) . "</strong> of this person"; ?> </td> </tr> <?php } ?> </tbody> </table> <br /> <?php } ?> </div>
function _shn_get_coe_records($eid) { $res = Browse::getEventCOE($eid); if (count($res) != 0) { ?> <table class="table table-bordered table-striped table-hover"> <thead> <tr> <th><?php echo _t('THE_EVENT_IS_LINKED'); ?> </th> </tr> </thead> <tbody> <?php foreach ($res as $record) { ?> <tr> <td><?php echo " By "; ?> <a href="<?php echo get_url('events', 'get_event', null, array('eid' => $record['event'])); ?> "><?php echo $record['event_title']; ?> </a> <?php echo " as "; ?> <?php echo "<strong>" . get_mt_term($record['type_of_chain_of_events']) . "</strong>"; ?> </td> </tr> <?php } ?> </tbody> </table> <?php } }
<td><input name="biographics[]" type='checkbox' value='<?php echo $bio['biographic_details_record_number']; ?> ' class='delete'/></td> <td><a href="<?php echo get_url('person', 'biography_list', null, array('biography_id' => $bio['biographic_details_record_number'], 'type' => 'bd', 'reverse' => 1)); ?> "><?php echo $bio['biographic_details_record_number']; ?> </a></td> <td><a href="<?php echo get_url('person', 'biography_list', null, array('biography_id' => $bio['biographic_details_record_number'], 'type' => 'bd', 'reverse' => 1)); ?> "><?php echo get_mt_term(get_biography_reverse($bio['relationship_type'])); ?> </a></td> <td><a href="<?php echo get_url('person', 'biography_list', null, array('biography_id' => $bio['biographic_details_record_number'], 'type' => 'rp', 'reverse' => 1)); ?> "><?php echo $bio['person_name']; ?> </a></td> <td><?php echo $bio['initial_date']; ?> </td> <td><?php echo $bio['final_date'];
<tr <?php if ($i++ % 2 == 1) { echo "class='odd'"; } ?> > <td><?php echo $record['initial_date']; ?> </td> <td><?php echo $record['event_title']; ?> </td> <td><?php echo get_mt_term($record['type_of_chain_of_events']); ?> </td> </tr> <?php } ?> </tbody> </table> <?php } ?> <center> <a class="btn" href="<?php echo get_url('events', 'coe_list', null, array('eid' => $event_id));
<td><?php echo get_mt_term(get_chaintype_reverse($record['type_of_chain_of_events'])); ?> </td> </tr> <?php } ?> </tbody> </table> <?php $coe_form = generate_formarray('chain_of_events', 'view'); $coe = new ChainOfEvents(); foreach ($related_events as $key => $record) { echo '<br /><h3>' . _t('CHANE_OF_EVENTS_') . ++$key . ' : ' . get_mt_term($record['type_of_chain_of_events']) . '</h3>'; echo '<h3>' . _t('RELATED_EVENT') . $key . ' : ' . $record['event_title'] . '</h3><br />'; //print victim details $coe->LoadFromRecordNumber($record['coe_id']); $coe->LoadRelationships(); popuate_formArray($coe_form, $coe); shn_form_get_html_labels($coe_form, false); echo "<br class='page_break' />"; } } ?> </div> <?php if ($conf['print_event_sidebar']) { echo "<div class='span3'>" . $conf['print_event_sidebar'] . "</div>"; }
<td><?php echo $record['initial_date']; ?> </td> <td><a href="<?php get_url('events', 'coe_list', null, array('type' => 'coe', 'coe_id' => $record['coe_id'], 'related_event' => $record['event'], 'reverse' => 1)); ?> "><?php echo $record['event_title']; ?> </a></td> <td><a href="<?php get_url('events', 'coe_list', null, array('type' => 'coe_view', 'coe_id' => $record['coe_id'])); ?> "><?php echo get_mt_term(get_chaintype_reverse($record['type_of_chain_of_events'])); ?> </a></td> </tr> <?php } ?> <tr class='actions'> <td colspan='8'> <button type='submit' class='btn btn-grey' name='delete' ><i class="icon-trash"></i> <?php echo _t('DELETE'); ?> </button> </td> </tr>
public function act_facetsearchresults() { global $global, $conf; $searchparams = $_GET['searchparams']; $searchparams = json_decode($searchparams); $resp = array(); if ($searchparams) { $domaindata = $this->getEntityFields(); $query = new stdClass(); $ents = array(); $additionalFields = array(); if (count((array) $searchparams->selected_terms)) { $fieldCounts = array(); foreach ($searchparams->selected_terms as $entity => $fields) { foreach ($fields as $field => $terms) { if (!$terms) { continue; } $ents[] = $entity; if ($domaindata->{$entity}->ac_type) { $selEntity2 = $domaindata->{$entity}->ac_type; } else { $selEntity2 = $entity; } $condition = new stdClass(); $condition->entity = $entity; $condition->field = $field; $condition->operator = "in"; $condition->value = implode(",", $terms); $condition->link = "and"; if ($domaindata->{$selEntity2}->fields->{$field}->field_type == "mt_tree") { $condition->operator = "subin"; } else { $condition->operator = "in"; } $query->conditions[] = $condition; } } } $selEntity = $selEntityOriginal = $searchparams->entities[0]; //var_dump($selEntity);exit; if ($domaindata->{$selEntity}->ac_type) { $selEntity = $domaindata->{$selEntity}->ac_type; } $selectFields = array(); foreach ($query->conditions as $cond) { $sel = new stdClass(); $sel->entity = $cond->entity; $sel->field = $cond->field; $selectFields[] = $sel; } if ($searchparams->facets) { foreach ($searchparams->facets as $facet) { $sel = new stdClass(); $sel->entity = $facet->entity; $sel->field = $facet->field; $selectFields[] = $sel; } } foreach ($domaindata->{$selEntity}->fields as $field) { if ($field->select == "y") { $sel = new stdClass(); $sel->entity = $selEntityOriginal; $sel->field = $field->value; $selectFields[] = $sel; } } $selectFields = array_unique($selectFields, SORT_REGULAR); foreach ($selectFields as $sfield) { if (!in_array($sfield->entity, $ents)) { $ents[] = $sfield->entity; $condition = new stdClass(); $entt = $sfield->entity; $selEntt = $entt; if ($domaindata->{$entt}->ac_type) { $selEntt = $domaindata->{$entt}->ac_type; } $fields = (array) $domaindata->{$selEntt}; $f = (array) $domaindata->{$selEntt}->fields; $pkey = get_primary_key($selEntt); if ($f[$pkey]) { $f = $f[$pkey]; } else { $f = array_shift($f); } $condition->entity = $entt; $condition->field = $f->value; $condition->operator = "contains"; $condition->value = ""; $query->conditions[] = $condition; } } foreach ($ents as $ent) { $recField = get_primary_key($ent); $sel = new stdClass(); $sel->entity = $ent; $sel->field = $recField; if (!in_array($sel, $selectFields)) { $selectFields[] = $sel; $additionalFields[$sel->entity][] = $recField; } } $selectFields = array_unique($selectFields, SORT_REGULAR); $query->select = $selectFields; function entitySort($a, $b) { $enord = array('event', 'act', 'intervention', 'arrest', 'torture', 'killing', 'destruction', 'victim', 'involvement', 'perpetrator', 'information', 'source', 'chain_of_events', 'intervening_party', 'address', 'biographic_details', 'supporting_docs_meta'); $aorder = array_search($a->entity, $enord); $border = array_search($b->entity, $enord); return $border - $aorder; } usort($query->select, "entitySort"); usort($query->conditions, "entitySort"); $from = (int) $searchparams->paging->from; $size = (int) $searchparams->paging->size; if ($from < 0) { $from = 0; } if ($size < 1) { $size = 20; } $records = array(); include_once 'searchSql.php'; $start = $from; $limit = $size; $sidx = $_GET['sidx']; if (!$sidx) { $sidx = 1; } $sord = $_GET['sord']; $fields_array = array(); $entities = analysis_get_search_entities(); $fieldTitles = array(); //if the query is a search put select fields to the array foreach ($query->select as $field) { if (in_array($field->field, $additionalFields[$field->entity])) { continue; } $entity = isset($entities[$field->entity]['ac_type']) ? $entities[$field->entity]['ac_type'] : $field->entity; $mt = is_mt_field($entity, $field->field); array_push($fields_array, array('name' => $field->entity . '_' . $field->field, 'mt' => $mt)); $fieldname = $field->field; if (isset($domaindata->{$entity}->fields->{$fieldname}->label)) { $fieldTitles[] = $domaindata->{$entity}->fields->{$fieldname}->label; } else { $fieldTitles[] = $field->field; } } $records[0] = $fieldTitles; $searchSql = new SearchResultGenerator(); $sqlArray = $searchSql->sqlForJsonQuery(json_encode($query)); $count_query = "SELECT COUNT(*) FROM ({$sqlArray['result']}) as results"; try { $res_count = $global['db']->Execute($count_query); } catch (Exception $e) { $response->error = "error"; //$e->getMessage(); $res_count = null; } if ($res_count != null) { while (!$res_count->EOF) { $count = $res_count->fields[0]; $res_count->MoveNext(); } } $sql = $sqlArray['result']; if ($limit != -1) { $sql .= " LIMIT {$start} , {$limit}"; } try { $res = $global['db']->Execute($sql); } catch (Exception $e) { $response->error = "error"; //$e->getMessage(); } $resp = array("response" => array("start" => $from, "found" => $count)); $number_of_fields = count($fields_array); foreach ($res as $key => $val) { //$response->aaData[$i]['id'] = $val[$fields_array[0]]; $array_values = array(); for ($count = 0; $number_of_fields > $count; $count++) { $field_name = $fields_array[$count]['name']; $record_number_field = substr($field_name, strlen($field_name) - 13); $confidentiality_field = substr($field_name, strlen($field_name) - 15); $deceased_field = substr($field_name, strlen($field_name) - 8); $doc_field = substr($field_name, strlen($field_name) - 6); if ($confidentiality_field == 'confidentiality') { if ($val[$field_name] == 'y') { $val[$field_name] = _t('YES'); } elseif ($val[$field_name] == 'n') { $val[$field_name] = _t('NO'); } } if ($deceased_field == 'deceased') { if ($val[$field_name] == 'y') { $val[$field_name] = _t('YES'); } else { $val[$field_name] = _t('NO'); } } $string = null; if ($fields_array[$count]['mt']) { $list = explode(',', $val[$field_name]); //var_dump($val);exit; foreach ($list as $term) { $string = $string . ", " . get_mt_term(trim($term)); } $array_values[$field_name] = ltrim($string, ','); } else { if ($record_number_field == 'record_number' || $doc_field == 'doc_id') { if (preg_match('/event/', $field_name)) { $link_entity = 'event'; } else { if (preg_match('/act/', $field_name)) { $link_entity = 'act'; } else { if (preg_match('/source/', $field_name)) { $link_entity = 'source'; } else { if (preg_match('/perpetrator/', $field_name)) { $link_entity = 'perpetrator'; } else { if (preg_match('/victim/', $field_name)) { $link_entity = 'victim'; } else { if (preg_match('/involvement/', $field_name)) { $link_entity = 'involvement'; } else { if (preg_match('/information/', $field_name)) { $link_entity = 'information'; } else { if (preg_match('/intervention/', $field_name)) { $link_entity = 'intervention'; } else { if (preg_match('/intervening_party/', $field_name)) { $link_entity = 'intervening_party'; } else { if (preg_match('/person/', $field_name)) { $link_entity = 'person'; } else { if (preg_match('/biographic_details/', $field_name)) { $link_entity = 'biographic_details'; } else { if (preg_match('/supporting_docs_meta/', $field_name)) { $link_entity = 'supporting_docs_meta'; } else { if (preg_match('/address/', $field_name)) { $link_entity = 'address'; } } } } } } } } } } } } } if ($link_entity != 'address') { $url = get_record_url($val[$field_name], $link_entity); $array_values[$field_name] = "<a href='{$url}' target='_blank'>" . $val[$field_name] . "</a>"; } else { if ($val[$field_name]) { $array_values[$field_name] = $val[$field_name]; } else { $array_values[$field_name] = ""; } } } else { if ($val[$field_name]) { $array_values[$field_name] = $val[$field_name]; } else { $array_values[$field_name] = ""; } } } } $records[] = $array_values; $i++; } $resp["response"]["records"] = $records; $recField = get_primary_key($selEntity); // . "_record_number"; $charts = array(); $conditions = array(); if (count((array) $query->conditions)) { foreach ($query->conditions as $condition) { $condition2 = $condition; $conditions[$condition->entity][$condition->field][] = $condition2; } } //var_dump($conditions, $sqlArray['result']); if ($searchparams->facets) { foreach ($searchparams->facets as $facet) { $entity = $facet->entity; $field = $facet->field; if ($domaindata->{$entity}->ac_type) { $en = $domaindata->{$entity}->ac_type; $fields = $domaindata->{$en}->fields; } else { $fields = $domaindata->{$entity}->fields; } $fieldType = $fields->{$field}->field_type; $listCode = $fields->{$field}->list_code; //charts $entityForm = $searchSql->getEntityArray($entity); $fieldArray = $entityForm[$field]; $recField = get_primary_key($selEntityOriginal); $selEntt = $entity; if ($domaindata->{$selEntt}->ac_type) { $selEntt = $domaindata->{$selEntt}->ac_type; } $recFieldEnt = get_primary_key($searchSql->tableOfEntity($fieldArray['map']['entity'])); if ($fieldArray['map']['mlt'] && $fieldArray['type'] != "user_select") { $mltTable = 'mlt_' . $searchSql->tableOfEntity($fieldArray['map']['entity']) . '_' . $fieldArray['map']['field']; $sqlchart = "SELECT IFNULL(l.msgstr , english) as val, COUNT(t.record_number) AS count,m.vocab_number as vocab_number\n FROM ({$sqlArray['result']}) d LEFT JOIN {$mltTable} t on t.record_number=d.{$entity}_{$recFieldEnt} left join\n mt_vocab m on m.vocab_number=t.vocab_number\n LEFT JOIN mt_vocab_l10n l ON ( l.msgid = m.vocab_number AND l.locale = '{$conf['locale']}' ) GROUP BY t.vocab_number\n "; } elseif (is_management_field($fieldArray)) { $f = $entity . "_" . $fieldArray['map']['field']; $sqlchart = "SELECT IFNULL(l.msgstr , english) as val, COUNT(d.{$selEntityOriginal}_{$recField}) AS count,m.vocab_number as vocab_number\n FROM ({$sqlArray['result']}) d LEFT JOIN management t on t.entity_id=d.{$entity}_{$recFieldEnt} and t.entity_type='{$entity}'\n left join mt_vocab m on m.vocab_number=t.{$fieldArray['map']['field']}\n LEFT JOIN mt_vocab_l10n l ON ( l.msgid = m.vocab_number AND l.locale = '{$conf['locale']}' ) GROUP BY {$f}\n "; } else { $f = $entity . "_" . $fieldArray['map']['field']; if ($fieldType == "mt_select" || $fieldType == "mt_tree") { $sqlchart = "SELECT IFNULL(l.msgstr , english) as val, COUNT({$selEntityOriginal}_{$recField}) AS count,m.vocab_number as vocab_number\n FROM ({$sqlArray['result']}) d left join mt_vocab m on m.vocab_number=d.{$f}\n LEFT JOIN mt_vocab_l10n l ON ( l.msgid = m.vocab_number AND l.locale = '{$conf['locale']}' ) GROUP BY {$f}"; } else { $sqlchart = "SELECT d.{$f} as val, COUNT({$selEntityOriginal}_{$recField}) AS count,d.{$f} as vocab_number\n FROM ({$sqlArray['result']}) d GROUP BY {$f}"; } } $facetcounts = array(); if ($sqlchart) { try { $res = $global['db']->Execute($sqlchart); $chart = array(); $chart["type"] = "editchart"; $chart["editcharttype"] = "BarChart"; $chart["title"] = $fieldArray["label"]; $chart2 = $chart; $chart2["editcharttype"] = "PieChart"; foreach ($res as $val) { $vall = _t("Undefined"); if ($val[0]) { if ($val[0] == "y") { $vall = _t('YES'); } elseif ($val[0] == "n") { $vall = _t('NO'); } else { $vall = $val[0]; } } elseif (!(int) $val[1]) { continue; } $chart["data"][0][0] = $chart["title"]; $chart["data"][1][0] = ""; $chart["data"][0][] = $vall; $chart["data"][1][] = (int) $val[1]; $chart2["data"][0] = array($chart["title"], _t("COUNT")); $chart2["data"][] = array($vall, (int) $val[1]); $facetcounts[$val[2]] = (int) $val[1]; } //$resp["charts"][] = array($chart, $chart2); $resp["charts"][] = array($chart); $resp["charts"][] = array($chart2); } catch (Exception $e) { $response->error = "error"; //$e->getMessage(); } } $terms = array(); switch ($fieldType) { case 'radio': $label = _t('YES'); if (isset($facetcounts["y"])) { $label .= " (" . $facetcounts["y"] . ")"; } $resp["facets"][$field]["terms"][] = array('term' => 'y', 'label' => $label); $label = _t('NO'); if (isset($facetcounts["n"])) { $label .= " (" . $facetcounts["n"] . ")"; } $resp["facets"][$field]["terms"][] = array('term' => 'n', 'label' => $label); $resp["facets"][$field]["entity"] = $entity; break; case 'mt_select': $data_array = MtFieldWrapper::getMTList($listCode); $size = count($data_array); $options[''] = ' '; for ($i = 0; $i < $size; $i++) { $label = $data_array[$i]['label']; if (isset($facetcounts[$data_array[$i]['vocab_number']])) { $label .= " (" . $facetcounts[$data_array[$i]['vocab_number']] . ")"; } $terms[] = array('term' => $data_array[$i]['vocab_number'], 'label' => $label); } $resp["facets"][$field] = array("terms" => $terms, "entity" => $entity); break; case 'mt_tree': $data_array = MtFieldWrapper::getMTList($listCode); $count = count($data_array); for ($i = 0; $i < $count;) { $element1 = $data_array[$i]; $label = $element1['label']; if (isset($facetcounts[$element1['vocab_number']])) { $label .= " (" . $facetcounts[$element1['vocab_number']] . ")"; } $terms[] = array('term' => $element1['vocab_number'], 'label' => $label, 'level' => (int) $element1["term_level"]); $i++; } $resp["facets"][$field] = array("terms" => $terms, "field_type" => "mt_tree", "entity" => $entity); break; } } } $locationFields = Browse::getEntityLocationFields($selEntity); $field_names = array(); $fieldsArray = array(); $markers = array(); if ($locationFields) { $selectFields = array(); $sel = new stdClass(); $sel->entity = $selEntityOriginal; $sel->field = get_primary_key($selEntity); // . "_record_number"; $selectFields[] = $sel; foreach ($locationFields as $locationField) { $field_names[] = $locationField["field_name"]; /* $fieldsArray[] = $locationField["field_name"] . "_latitude"; $fieldsArray[] = $locationField["field_name"] . "_longitude"; */ $sel = new stdClass(); $sel->entity = $selEntityOriginal; $sel->field = $locationField["field_name"] . "_latitude"; $selectFields[] = $sel; $sel = new stdClass(); $sel->entity = $selEntityOriginal; $sel->field = $locationField["field_name"] . "_longitude"; $selectFields[] = $sel; } $query->select = $selectFields; $searchSql = new SearchResultGenerator(); $sqlArray = $searchSql->sqlForJsonQuery(json_encode($query)); $sql = $sqlArray['result']; if ($limit != -1) { // $sql .= " LIMIT $start , $limit"; } //$sql = "select " . $selEntity . "_record_number," . implode(",", $fieldsArray) . " from " . $selEntity; try { $res = $global['db']->GetAll($sql); } catch (Exception $e) { $response->error = "error"; //$e->getMessage(); } foreach ($res as $val) { $url = get_record_url($val[0], $selEntity); $i = 1; foreach ($field_names as $field_name) { if ($val[$i] && $val[$i + 1]) { $markers[] = array("latitude" => $val[$i], "longitude" => $val[$i + 1], "title" => $val[0], "content" => "<a href='" . $url . "' target='_blank'>" . $val[0] . "</a>"); } $i = $i + 2; } } } $resp["markers"] = $markers; } echo json_encode($resp); exit; }
public function act_add_involvement() { $involvement_form = involvement_form('new'); $this->involvement_form = $involvement_form; //if finish save and go to vp_list if (isset($_POST['finish'])) { $status = shn_form_validate($this->involvement_form); if ($status) { $this->save_involvement(); set_redirect_header('events', 'vp_list'); } } //if add more go to perpotrator if (isset($_POST['more'])) { $status = shn_form_validate($this->involvement_form); if ($status) { $this->save_involvement(); $this->act_add_perpetrator(); set_redirect_header('events', 'add_perpetrator', null, array('acts' => $_SESSION['acts'])); return; } } $acts_array = array(); foreach ($_SESSION['acts'] as $act_id) { $act = new Act(); $act->LoadFromRecordNumber($act_id); $victim = new Person(); $victim->LoadFromRecordNumber($act->victim); $perpetrator = new Person(); $perpetrator->LoadFromRecordNumber($_SESSION['vp']['perpetrator']); $act_array = array(); $act_array['act'] = $act; $act_array['act_name'] = get_mt_term($act->type_of_act); $act_array['perpetrator'] = $perpetrator; $acts_array[] = $act_array; } $this->acts = $acts_array; /* $this->act = new Act(); $this->act->LoadFromRecordNumber($_SESSION['act_id']); $this->act_name = get_mt_term($this->act->type_of_act); $this->perpetrator = new Person(); $this->perpetrator->LoadFromRecordNumber($_SESSION['vp']['perpetrator']); */ }