public function address_form()
{
include_once APPROOT . 'inc/lib_form_util.inc';
echo "<h4>" . _t('ADDING_ADDRESS___') . "</h4>";
$address_form = address_form('new');
$fields = shn_form_get_html_fields($address_form);
$fields = place_form_elements($address_form, $fields);
foreach ($address_form as $field_id => $field_name) {
$validate_field_name = "validate_" . $field_id;
$validate_field_value = $field_name['extra_opts']['validation'][1];
echo "<input type='hidden' name='{$validate_field_name}' value='{$validate_field_value}'/>";
}
?>
<div class="control-group">
<div class="controls">
<button type="submit" class="btn" name="save_address" onclick="listAddress(); return false;" ><i class="icon-ok"></i> <?php
echo _t('SAVE_ADDRESS');
?>
</button>
<a class="btn" id="close_address_frm" href="#address_field"><i class="icon-remove"></i> <?php
echo _t('CLOSE');
?>
</a>
</div></div>
<?php
}
protected function showForm()
{
include_once APPROOT . 'inc/lib_form_util.inc';
include_once APPROOT . 'inc/lib_form.inc';
$person_form = person_form('search');
$address_form = address_form('search');
formArrayRefine($person_form);
//var_dump($person_form);
foreach ($person_form as $key => &$element) {
if ($_GET[$key] != null) {
$element['extra_opts']['value'] = $_GET[$key];
}
}
$fields = shn_form_get_html_fields($person_form);
if ($fields['person_addresses'] != null) {
formArrayRefine($address_form);
$address_fields = shn_form_get_html_fields($address_form);
}
if ($fields['person_addresses'] != null) {
$fields['person_addresses'] = null;
$fields = place_form_elements($person_form, $fields);
$address_fields = place_form_elements($address_form, $address_fields);
} else {
$fields = place_form_elements($person_form, $fields);
}
?>
<button type="submit" class="btn" name="search" ><i class="icon-search"></i> <?php
echo _t('SEARCH');
?>
</button>
<a class="btn" href="#" id="related_victim_search_close"><i class="icon-remove"></i> <?php
echo _t('CLOSE');
?>
</a>
<br/><br/>
<?php
}
echo html_tag('td', ' ', 'center', '', 'valign="top" width="1%"');
}
echo html_tag('td', ' <label for="' . $row['backend'] . '_' . urlencode($row['nickname']) . '">' . htmlspecialchars($row['nickname']) . '</label> ', 'left', '', 'valign="top" width="10%" nowrap') . html_tag('td', ' <label for="' . $row['backend'] . '_' . urlencode($row['nickname']) . '">' . htmlspecialchars($row['name']) . '</label> ', 'left', '', 'valign="top" width="10%" nowrap') . html_tag('td', '', 'left', '', 'valign="top" width="10%" nowrap') . ' ';
}
$email = $abook->full_address($row);
echo addHidden($row['backend'] . ':' . $row['nickname'], rawurlencode($email)) . makeComposeLink('src/compose.php?send_to=' . rawurlencode($email), htmlspecialchars($row['email'])) . ' </td>' . "\n" . html_tag('td', ' <label for="' . $row['backend'] . '_' . urlencode($row['nickname']) . '">' . htmlspecialchars($row['label']) . '</label> ', 'left', '', 'valign="top" width="10%"');
// add extra column if third party backend needs it
if ($abook->add_extra_field) {
echo html_tag('td', ' ' . (isset($row['extra']) ? $row['extra'] : '') . ' ', 'left', '', 'valign="top" width="10%"');
}
echo "</tr>\n";
$line++;
$count++;
}
/* End of list. Close table. */
if ($headerprinted) {
echo html_tag('tr', html_tag('td', addSubmit(_("Edit selected"), 'editaddr') . addSubmit(_("Delete selected"), 'deladdr') . addSubmit(_("Compose to selected"), 'compose_to', $javascript_on && $compose_new_win ? $compose_to_in_new_window_javascript : ''), 'center', '', "colspan=\"{$abook_fields}\""));
}
echo '</table></form>';
}
}
/* end of addresslist */
/* Display the "new address" form */
echo '<a name="AddAddress"></a>' . "\n" . addForm($form_url, 'post', 'f_add') . html_tag('table', html_tag('tr', html_tag('td', "\n" . '<strong>' . sprintf(_("Add to %s"), $abook->localbackendname) . '</strong>' . "\n", 'center', $color[0])), 'center', '', 'width="95%"') . "\n";
address_form('addaddr', _("Add address"), $defdata);
echo "</form>\n";
/* Add hook for anything that wants on the bottom */
do_hook('addressbook_bottom');
?>
</body></html>
protected function showForm()
{
include_once APPROOT . 'inc/lib_form_util.inc';
include_once APPROOT . 'inc/lib_uuid.inc';
$person_form = person_form('search');
$address_form = address_form('search');
formArrayRefine($person_form);
foreach ($person_form as $key => &$element) {
if ($_GET[$key] != null) {
$element['extra_opts']['value'] = $_GET[$key];
}
}
$fields = shn_form_get_html_fields($person_form);
if ($fields['person_addresses'] != null) {
formArrayRefine($address_form);
$address_fields = shn_form_get_html_fields($address_form);
}
if ($fields['person_addresses'] != null) {
$fields['person_addresses'] = null;
$fields = place_form_elements($person_form, $fields);
$address_fields = place_form_elements($address_form, $address_fields);
} else {
$fields = place_form_elements($person_form, $fields);
}
?>
<?php
echo $this->mod != null ? "<input type='hidden' name='mod' value='{$this->mod}'/>" : '';
echo $this->act != null ? "<input type='hidden' name='act' value='{$this->act}'/>" : '';
echo $this->view != null ? "<input type='hidden' name='view' value='{$this->view}'/>" : '';
echo $this->cancel != null ? "<input type='hidden' name='cancel' value='{$this->cancel}'/>" : '';
?>
<a class="btn" href="<?php
echo get_url($this->mod, $this->act, null, null);
?>
"><i class="icon-chevron-left"></i> <?php
echo _t('BACK');
?>
</a>
<a class="btn" href="<?php
echo get_url($this->mod, $this->cancel, null, null);
?>
"><i class="icon-remove-circle"></i> <?php
echo _t('CANCEL');
?>
</a>
<?php
if ($this->act == "add_victim") {
?>
<a class="btn" href="<?php
echo get_url($this->mod, $this->act, null, array("view" => "new_victim"));
?>
"><i class="icon-plus "></i> <?php
echo _t('ADD_NEW');
?>
</a>
<?php
}
?>
<button type="submit" class="btn"><i class="icon-search"></i> <?php
echo _t('SEARCH');
?>
</button>
<br /><br />
<?php
}
function get_data_array()
{
global $dataFile, $dataCols, $fields, $lists, $docsCount, $biosCount;
if (($handle = fopen($dataFile, "r")) === FALSE) {
return array();
}
$results = array();
$j = 0;
while (($cols = fgetcsv($handle, 0, "\t")) !== FALSE) {
$glData = array();
$row = array();
if ($cols && $cols[1]) {
//var_dump($cols);exit;
foreach ($cols as $key => $val) {
$val = trim($val, '"');
$val = trim($val);
$row[$key] = $val;
$entityField = $dataCols[$key];
if ($entityField) {
$ent = $entityField["ent"];
$list_code = $entityField['list_code'];
$type = $entityField['field_type'];
$mlt = trim($entityField['is_repeat']) == 'Y' || trim($entityField['is_repeat']) == 'y' ? true : false;
if ($list_code == 39) {
if ($val == "M") {
$val = "Hombre";
} elseif ($val == "F") {
$val = "Mujer";
}
}
if ($list_code && !$lists[$list_code]) {
$options = array();
$data_array = MtFieldWrapper::getMTList($list_code);
$size = count($data_array);
for ($i = 0; $i < $size; $i++) {
$options[$data_array[$i]['vocab_number']] = strtolower($data_array[$i]['label']);
}
$lists[$list_code] = $options;
}
if ($list_code) {
if ($mlt) {
$val2 = explode(";", $val);
$val = array();
foreach ($val2 as $v) {
$v = trim($v);
$vocab_number = array_search(strtolower($v), $lists[$list_code]);
if ($vocab_number) {
$val[] = $vocab_number;
}
}
} else {
$vocab_number = array_search(strtolower($val), $lists[$list_code]);
if ($vocab_number) {
$val = $vocab_number;
} else {
$val = null;
}
}
}
if ($type == "date") {
if ($val) {
$d = date_create_from_format("m/d/Y", $val);
if ($d) {
$val = date_format($d, 'Y-m-d');
} else {
$val = null;
}
} else {
$val = null;
}
} elseif ($type == "location") {
$val2 = explode(",", $val);
//$row[$entityField['field_name'] . "_latitude"] = -floatval($val2[0]);
//$row[$entityField['field_name'] . "_longitude"] = -floatval($val2[1]);
$glData[$ent][$entityField['field_name'] . "_latitude"] = -floatval($val2[0]);
$glData[$ent][$entityField['field_name'] . "_longitude"] = -floatval($val2[1]);
$val = null;
} elseif ($type == "radio") {
if ($val == "NO" || $val == "no") {
$val = "n";
} elseif ($val == "SÍ" || $val == "sí") {
$val = "y";
} else {
$val = null;
}
}
if (!is_null($val)) {
//$row[$entityField['field_name']] = $val;
$glData[$ent][$entityField['field_name']] = $val;
}
}
}
if (!$glData['act']['ubicacto']) {
$v = $row[25];
$vocab_number = array_search(strtolower($v), $lists[71]);
if ($vocab_number) {
$glData['act']['ubicacto'] = $vocab_number;
}
}
if (!$glData['act']['ubicacto']) {
$v = $row[24];
$vocab_number = array_search(strtolower($v), $lists[71]);
if ($vocab_number) {
$glData['act']['ubicacto'] = $vocab_number;
}
}
$browse = new Browse();
$rows = $browse->ExecuteQuery("select event_record_number as id from event where event_title='" . $glData['event']['event_title'] . "'");
if ($rows && $rows[0]['id']) {
$event = new Event();
$event->LoadFromRecordNumber($rows[0]['id']);
} else {
$form = event_form('new');
$event = new Event();
$event->event_record_number = shn_create_uuid('event');
form_objects($form, $event, $glData['event']);
$event->SaveAll();
}
$browse = new Browse();
$person = null;
if ($glData['person']['person_name'] != "NN") {
$rows = $browse->ExecuteQuery("select person_record_number as id from person where person_name='" . $glData['person']['person_name'] . "' \n\t\t\t\tand other_names='" . $glData['person']['other_names'] . "' ");
if ($rows && $rows[0]['id']) {
$person = new Person();
$person->LoadFromRecordNumber($rows[0]['id']);
}
}
if (!$person) {
$person_form = person_form('new');
$person = new Person();
form_objects($person_form, $person, $glData['person']);
$person->deceased = $person->deceased == 'on' ? 'y' : 'n';
if (isset($person->number_of_persons_in_group) && !$person->number_of_persons_in_group) {
$person->number_of_persons_in_group = Null;
}
if (isset($person->dependants) && !$person->dependants) {
$person->dependants = Null;
}
$person->SaveAll();
}
$victim = $person;
$act_form = act_form('new');
$act = new Act();
$act->act_record_number = shn_create_uuid('act');
$glData['act']['victim'] = $victim->person_record_number;
form_objects($act_form, $act, $glData['act']);
$act->event = $event->event_record_number;
$act->SaveAll();
if ($glData['perpetrator']['person_name']) {
$browse = new Browse();
$rows = $browse->ExecuteQuery("select person_record_number as id from person where person_name='" . $glData['perpetrator']['person_name'] . "' ");
if ($rows && $rows[0]['id']) {
$person = new Person();
$person->LoadFromRecordNumber($rows[0]['id']);
} else {
$person_form = person_form('new');
$person = new Person();
form_objects($person_form, $person, $glData['perpetrator']);
$person->deceased = $person->deceased == 'on' ? 'y' : 'n';
if (isset($person->number_of_persons_in_group) && !$person->number_of_persons_in_group) {
$person->number_of_persons_in_group = Null;
}
if (isset($person->dependants) && !$person->dependants) {
$person->dependants = Null;
}
$person->SaveAll();
}
$perpetrator = $person;
$inv = new Involvement();
$inv->involvement_record_number = shn_create_uuid('inv');
$inv->degree_of_involvement = "54010101001921";
//placeholder
$inv->event = $event->event_record_number;
$inv->act = $act->act_record_number;
$inv->perpetrator = $perpetrator->person_record_number;
$inv->SaveAll();
}
$supporting_documents = array();
if (trim($row[9])) {
$document_form = document_form('new');
unset($document_form['doc_id']);
$supporting_docs = new SupportingDocs();
$supporting_docs_meta = new SupportingDocsMeta();
$type = null;
$doc_uuid = shn_create_uuid('doc');
$supporting_docs->doc_id = $doc_uuid;
$supporting_docs_meta->doc_id = $doc_uuid;
$supporting_docs->uri = '';
form_objects($document_form, $supporting_docs, array('title' => $row[9]));
form_objects($document_form, $supporting_docs_meta, array('title' => $row[9]));
$supporting_docs_meta->format = $type;
$supporting_docs->Save();
$supporting_docs_meta->Save();
$supporting_documents[] = $doc_uuid;
}
for ($j = 1; $j <= $docsCount; $j++) {
if ($glData["supporting_docs_meta" . $j]) {
if (!$glData["supporting_docs_meta" . $j]['title']) {
continue;
}
$document_form = document_form('new');
unset($document_form['doc_id']);
$supporting_docs = new SupportingDocs();
$supporting_docs_meta = new SupportingDocsMeta();
$type = null;
$doc_uuid = shn_create_uuid('doc');
$supporting_docs->doc_id = $doc_uuid;
$supporting_docs_meta->doc_id = $doc_uuid;
$supporting_docs->uri = '';
form_objects($document_form, $supporting_docs, $glData["supporting_docs_meta" . $j]);
form_objects($document_form, $supporting_docs_meta, $glData["supporting_docs_meta" . $j]);
$supporting_docs_meta->format = $type;
$supporting_docs->Save();
$supporting_docs_meta->SaveAll();
$supporting_documents[] = $doc_uuid;
}
}
if ($supporting_documents) {
$act->supporting_documents = $supporting_documents;
$act->SaveDocs();
}
$bio_details = array();
for ($j = 1; $j <= $biosCount; $j++) {
if ($glData["bio_details" . $j] && $glData["bio_details" . $j]["type_of_relationship"]) {
$browse = new Browse();
$rows = $browse->ExecuteQuery("select person_record_number as id from person where person_name='" . $glData["bio_details" . $j]['person_name'] . "' \n\t\t\t\t\tand other_names='" . $glData['bio_details']['other_names'] . "' ");
if ($rows && $rows[0]['id']) {
$person = new Person();
$person->LoadFromRecordNumber($rows[0]['id']);
} else {
$person_form = person_form('new');
$person = new Person();
form_objects($person_form, $person, $glData["bio_details" . $j]);
$person->deceased = $person->deceased == 'on' ? 'y' : 'n';
if (isset($person->number_of_persons_in_group) && !$person->number_of_persons_in_group) {
$person->number_of_persons_in_group = Null;
}
if (isset($person->dependants) && !$person->dependants) {
$person->dependants = Null;
}
$person->SaveAll();
}
if ($glData["bio_details" . $j]["phone"] || $glData["bio_details" . $j]["email"]) {
$address = new Address();
$address_form = address_form('new');
form_objects($address_form, $address, $glData["bio_details" . $j]);
$address->person = $person->person_record_number;
$address->Save();
}
$biography_form = biographic_form('new');
$biography = new BiographicDetail();
//$biography->LoadfromRecordNumber();
$biography->biographic_details_record_number = shn_create_uuid('biography');
$glData["bio_details" . $j]['person_id'] = $person->person_record_number;
form_objects($biography_form, $biography, $glData["bio_details" . $j]);
$biography->person = $victim->person_record_number;
$biography->related_person = $person->person_record_number;
if ($biography->related_person == '') {
$biography->related_person = null;
}
$biography->SaveAll();
}
}
}
$results[] = $row;
$j++;
}
return $results;
}
/**
* Display the "new address" form
*
* Form is not closed and you must add closing form tag.
* @since 1.5.1
* @param string $form_url form action url
* @param string $name form name
* @param string $title form title
* @param string $button form button name
* @param array $defdata values of form fields
*/
function abook_create_form($form_url, $name, $title, $button, $defdata = array())
{
global $color;
echo addForm($form_url, 'post', 'f_add') . html_tag('table', html_tag('tr', html_tag('td', "\n" . '<strong>' . $title . '</strong>' . "\n", 'center', $color[0])), 'center', '', 'width="100%"') . "\n";
address_form($name, $button, $defdata);
}
private function generateCondition($fieldArray, $dataArray, $fieldName, &$sqlArray)
{
global $conf;
//var_dump('fieldArray type ' , $fieldArray );
$dataArray = array_map('addslashes_deep', $dataArray);
if (is_management_field($fieldArray)) {
$fieldArray['map']['entity'] = 'management';
}
switch ($fieldArray['type']) {
case 'hidden':
if ($conf['subbrowse']['biography_list'] && $fieldArray['map']['entity'] == 'biographic_details' && $fieldArray['map']['field'] == 'person') {
$condition = $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . " = '{$dataArray[$fieldName]}'";
} else {
$condition = $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . " LIKE '%{$dataArray[$fieldName]}%'";
}
//return $condition;
break;
case 'textarea':
$condition = $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . " LIKE '%{$dataArray[$fieldName]}%'";
//return $condition;
break;
case 'text':
$condition = $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . " LIKE '%{$dataArray[$fieldName]}%'";
//return $condition;
break;
case 'mt_select':
$condition = " {$fieldArray['map']['field']} = '{$dataArray[$fieldName]}' ";
//return $condition;
break;
case 'mt_tree':
$huriParent = rtrim(substr($dataArray[$fieldName], 0, 10), '0');
$condition = " {$fieldArray['map']['field']} LIKE '{$huriParent}%' ";
//return $condition;
break;
case 'date':
$condition = ' ' . $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . ' LIKE ' . "'%" . $dataArray[$fieldName] . "%'";
//return $condition;
break;
case 'document':
break;
case 'upload':
break;
case 'checkbox':
$compValue = "'n' , '0'";
if (strtolower($dataArray[$fieldName]) == 'on') {
$compValue = "'y' , '1' ";
}
$condition = $fieldArray['map']['entity'] . '.' . $fieldArray['map']['field'] . " IN ( {$compValue})";
break;
case 'address':
$condition = null;
$and = null;
$addressSearchForm = address_form('search');
//var_dump($addressSearchForm);
foreach ($addressSearchForm as $addressFieldName => $addressField) {
//var_dump($addressFieldName);
if (trim($dataArray[$addressFieldName]) != '') {
//var_dump($dataArray[ $addressFieldName ]);
$conditionPart = null;
$conditionPart = $this->generateCondition($addressField, $dataArray, $addressFieldName, $sqlArray);
if ($condition == null || trim($condition) == '') {
$and = '';
} else {
$and = ' AND ';
}
if ($conditionPart != null) {
$condition = $condition . $and . $conditionPart;
}
}
}
return $condition;
break;
}
//var_dump('generate condition' , $condition);
$sqlArray['where'][] = $condition;
return $condition;
}
public function act_edit_address()
{
$this->address = new Address();
$this->address_form = address_form('edit');
if (isset($_GET['address_id'])) {
$this->address->LoadfromRecordNumber($_GET['address_id']);
$address_form = address_form('view');
popuate_formArray($address_form, $this->address);
$this->address_form = $address_form;
}
if (isset($_POST['update'])) {
$status = shn_form_validate($this->address_form);
if ($status) {
form_objects($this->address_form, $this->address);
$this->address->person = $this->pid;
$this->address->Save();
set_url_args('pid', $this->pid);
set_redirect_header('person', 'address_list');
return;
}
}
}
