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; } } }