</tr>
<?php
}
?>
</tbody>
</table>
</form>
<br />
<?php
$person_form = generate_formarray('person', 'view');
$act_form = generate_formarray('act', 'view');
$inv_form = generate_formarray('involvement', 'view');
$person = new Person();
$act = new Act();
$inv = new Involvement();
//travers through
foreach ($vp_list as $key => $record) {
echo '<br /><h3>' . _t('ACT_') . ++$key . ' : ' . get_mt_term($record['type_of_act']) . '</h3><br />';
//print victim details
echo '<h4>' . _t('VICTIM') . ' : ' . $record['vname'] . '</h4><br />';
$person->LoadFromRecordNumber($record['victim_record_number']);
$person->LoadRelationships();
popuate_formArray($person_form, $person);
shn_form_get_html_labels($person_form, false);
echo "<br class='page_break' />";
//print act details
echo '<h4>' . _t('ACT_DETAILS') . ' : ' . get_mt_term($record['type_of_act']) . '</h4><br />';
$act->LoadFromRecordNumber($record['act_record_number']);
$act->LoadRelationships();
popuate_formArray($act_form, $act);
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;
}
public function act_delete_act()
{
if (isset($_POST['no'])) {
set_redirect_header('events', 'vp_list');
return;
}
if ($_GET['act_id']) {
$act_ids = array($_GET['act_id']);
} else {
$act_ids = $_POST['acts'];
}
$this->act_ids = $act_ids;
$this->del_confirm = true;
if (isset($_POST['yes'])) {
if (isset($_POST['act'])) {
array_push($act_ids, $_POST['act']);
} else {
if (isset($_POST['inv'])) {
array_push($_POST['invs'], $_POST['inv']);
}
}
//if multiplt events are selected
if (is_array($act_ids)) {
foreach ($act_ids as $act) {
$c = new Act();
$c->DeleteFromRecordNumber($act);
}
} else {
if (is_array($_POST['invs'])) {
foreach ($_POST['invs'] as $inv) {
$i = new Involvement();
$i->DeleteFromRecordNumber($inv);
}
}
}
set_redirect_header('events', 'vp_list');
return;
}
if (isset($act_ids)) {
$this->vp_list = Browse::getVpListArray($act_ids);
} else {
if (isset($_POST['invs'])) {
$this->vp_list = Browse::getVpListInvArray($_POST['invs']);
}
}
}