function mainInsert($post, $defaultValue = array())
{
//my_print_r($post);
$rs = array();
$md = array();
$rs['akce'] = 'error';
$rs['ok'] = FALSE;
$rs['report'] = '';
$rs['data'] = '';
$md_record = new MdRecord();
//$md_record->deleteTmpRecords();
if (count($post) == 0) {
setMickaLog('INSERT ERROR, POST is empty!', 'ERROR', 'micka_main_lib.main_insert');
$rs['report'] = 'Error, not complete data!';
//return $rs;
Debugger::log('[micka_main_lib.mainInsert] ' . 'POST is empty!', 'ERROR');
require PHPINC_DIR . '/templates/404_record.php';
}
$defaultEditGroup = array_key_exists('edit_group', $defaultValue) === TRUE ? $defaultValue['edit_group'] : MICKA_USER;
$defaultViewGroup = array_key_exists('view_group', $defaultValue) === TRUE ? $defaultValue['view_group'] : MICKA_USER;
// 0:ISO 19115 | 10:ISO 19119 | 1:DC | 2:FC | 99:import
$md['md_standard'] = isset($post['standard']) && $post['standard'] != '' ? htmlspecialchars($post['standard']) : 0;
// skupina pro prohlížení
$md['view_group'] = isset($post['group_v']) && $post['group_v'] != '' ? htmlspecialchars($post['group_v']) : $defaultEditGroup;
// skupina s právem editace
$md['edit_group'] = isset($post['group_e']) && $post['group_e'] != '' ? htmlspecialchars($post['group_e']) : $defaultViewGroup;
// hlavní jazyk záznamu
$lang_main = isset($post['lang_main']) && $post['lang_main'] != '' ? htmlspecialchars($post['lang_main']) : MICKA_LANG;
// seznam dalších jazyků
$md['lang'] = isset($post['languages']) ? htmlspecialchars(implode($post['languages'], "|")) : '';
if ($md['lang'] == '' && $lang_main != '') {
$md['lang'] = $lang_main;
}
// template s default hodnotami
$template = '';
if ($md['md_standard'] < 99) {
if ($md['md_standard'] == 0) {
$template = PHPCFG_DIR . '/templateMd.xml';
} elseif ($md['md_standard'] == 10) {
$template = PHPCFG_DIR . '/templateMs.xml';
} elseif ($md['md_standard'] == 1) {
$template = PHPCFG_DIR . '/templateDc.xml';
} elseif ($md['md_standard'] == 2) {
$template = PHPCFG_DIR . '/templateFc.xml';
}
if ($template != '' && file_exists($template)) {
$md['file_type'] = 'ISO19139';
$md['update_type'] = 'skip';
$md['md_standard'] = 99;
}
}
// IMPORT
if ($md['md_standard'] == 99) {
$md['file_type'] = isset($post['fileType']) && $post['fileType'] != '' ? htmlspecialchars($post['fileType']) : 'ISO19139';
$md['md_rec'] = isset($post['md_rec']) && $post['md_rec'] != '' ? htmlspecialchars($post['md_rec']) : '';
$md['fc'] = isset($post['fc']) && $post['fc'] != '' ? htmlspecialchars($post['fc']) : '';
$md['service_type'] = isset($post['serviceType']) && $post['serviceType'] != '' ? htmlspecialchars($post['serviceType']) : 'WMS';
$md['url'] = isset($post['url']) && $post['url'] != '' ? htmlspecialchars($post['url']) : '';
$md['url'] = $md['url'] != '' ? str_replace('&', '&', $md['url']) : '';
$md['update_type'] = isset($post['updateType']) && $post['updateType'] != '' ? htmlspecialchars($post['updateType']) : 'skip';
}
if ($md['md_standard'] < 99) {
// Vytvoření nového záznamu v tmp
$recno = $md_record->setNewRecord($md, $lang_main);
if ($recno > 0) {
$rs['akce'] = 'edit';
$rs['ok'] = TRUE;
$rs['data'] = $recno;
setEditId2Session('recno', 'new');
setEditId2Session('recnoTmp', $recno);
$redirectUrl = substr(htmlspecialchars($_SERVER['PHP_SELF']), 0, strrpos($_SERVER['PHP_SELF'], '/')) . '?ak=edit&recno=new';
setUrlEdit2Session($redirectUrl);
}
//return $rs;
return $redirectUrl;
}
if ($md['md_standard'] == 99) {
// Import ze souboru nebo url
require PHPPRG_DIR . '/micka_lib_php5.php';
require PHPPRG_DIR . '/micka_lib_insert.php';
require PHPPRG_DIR . '/MdImport.php';
//$prevod = DomainCodes2List();
$report = array();
$importer = new MetadataImport();
if (isset($_FILES['soubor']['tmp_name']) && $_FILES['soubor']['tmp_name'] != '' || $template != '') {
if ($_FILES['soubor']['tmp_name'] != '') {
if (!file_exists(PHPINC_DIR . '/temp/upload/')) {
mkdir(PHPINC_DIR . '/temp/upload/', 0777);
}
$tmpFileName = PHPINC_DIR . '/temp/upload/' . md5(uniqid(rand(), true)) . '.xml';
if (is_uploaded_file($_FILES['soubor']['tmp_name'])) {
move_uploaded_file($_FILES['soubor']['tmp_name'], $tmpFileName);
} else {
$tmpFileName = '';
}
} else {
$tmpFileName = $template;
}
if ($tmpFileName != '') {
//$prevod = DomainCodes2List();
$xmlstring = file_get_contents($tmpFileName);
$importer = new MetadataImport();
$importer->setTableMode('tmp');
$report = $importer->import($xmlstring, $md['file_type'], MICKA_USER, $md['edit_group'], $md['view_group'], $md['mds'] = 0, $md['lang'], $lang_main, $params = false, $md['update_type'], $md['md_rec']);
} else {
$rs['report'] = "File error!";
return $rs;
}
} elseif ($md['url'] != '') {
setMickaLog($md['url'], 'INFO', 'micka_main_lib.main_insert.url');
$importer->setTableMode('tmp');
$report = $importer->importService($md['url'], $md['service_type'], MICKA_USER, $md['edit_group'], $md['view_group'], $md['mds'] = 10, $md['lang'], $lang_main, $public = 0, $md['update_type']);
} else {
// není zadán soubor ani url
$rs['report'] = "Unknown import type!";
return $rs;
}
}
// zpracování reportu po importu
if ($report[0]['ok'] == 1) {
if (substr($report[0]['report'], 0, 11) == 'UUID exists') {
$rs['report'] = "UUID exists, stop import!";
$rs['akce'] = 'error';
$rs['data'] = $report[0];
return $rs;
} else {
$rs['ok'] = TRUE;
$rs['report'] = $report[0]['report'];
$md_record->setTableMode('tmp');
$record = $md_record->getMd('uuid', $report[0]['uuid']);
if (is_array($record) && count($record) > 1) {
$rs['akce'] = IMPORT_VALID ? 'import' : 'edit';
if ($rs['akce'] == 'edit') {
$rs['data'] = $record['md']['RECNO'];
} else {
$rs['data']['md'] = $record['md'];
}
}
}
} else {
$rs['report'] = $report[0]['report'];
$rs['data'] = $report[0];
return $rs;
}
if ($rs['akce'] == 'edit') {
$redirectUrl = substr(htmlspecialchars($_SERVER['PHP_SELF']), 0, strrpos($_SERVER['PHP_SELF'], '/')) . '?ak=edit&recno=new';
setUrlEdit2Session($redirectUrl);
} else {
// TODO: zatím jen editace
$redirectUrl = substr(htmlspecialchars($_SERVER['PHP_SELF']), 0, strrpos($_SERVER['PHP_SELF'], '/')) . '?ak=edit&recno=new';
setUrlEdit2Session($redirectUrl);
}
return $redirectUrl;
}
private function setRecordsValues()
{
$mode_md = FALSE;
if (count($this->md_head) > 0) {
$md_record = new MdRecord();
$md_record->setReportValidType($this->report_valid_type['type'], $this->report_valid_type['short']);
$md_record->setTableMode($this->table_mode);
foreach ($this->md_head as $key => $md) {
if ($this->table_mode == 'md' && canActionAcl('mds', $this->md_head[$key]['iso'], 'w') === FALSE) {
$this->md_head[$key]['action'] = 'skip';
$this->md_head[$key]['right'] = 'x';
$this->setReport($key, 'error', labelTranslation(MICKA_LANG, 'guest not right'));
continue;
}
$this->md_head[$key]['ok'] = 0;
$md_record->setRecordImporting(FALSE);
$this->addLogImport('setRecordsValues.MD', $md);
// zaznam existuje
if ($md['uuid'] != '') {
if ($this->micka_lite) {
$md_record->setTableMode('tmp');
} else {
$md_record->setTableMode('md');
$mode_md = TRUE;
}
$record = $md_record->getMd('uuid', $md['uuid']);
if ($mode_md === TRUE && $record['report'] == 'ok' && $record['right'] == 'w') {
$this->setReport($key, 'error', "INFO: " . labelTranslation(MICKA_LANG, 'The metadata record already exists. It will be replaced with the new one when you save it.'));
}
if ($this->micka_lite) {
$record_orig = $record;
} else {
$md_record->setTableMode($this->table_mode);
$record_orig = $md_record->getMd('uuid', $md['uuid']);
}
$this->addLogImport('setRecordsValues.origMD', $record_orig);
$this->addLogImport('setRecordsValues.table_mode', $this->table_mode);
if ($this->table_mode == 'tmp' && canActionAcl('mds', $this->md_head[$key]['iso'], 'w') === FALSE) {
if ($record_orig['report'] == 'ok' && $record_orig['report'] == 'ok') {
$this->md_head[$key]['action'] = 'update';
$this->md_head[$key]['recno'] = isset($record_orig['md']['RECNO']) && $record_orig['md']['RECNO'] > 0 ? $record_orig['md']['RECNO'] : -1;
} else {
$this->md_head[$key]['action'] = 'insert';
}
$this->md_head[$key]['right'] = 'w';
} elseif ($record['report'] == 'ok' && $record['right'] != 'w') {
$this->md_head[$key]['action'] = 'skip';
$this->md_head[$key]['right'] = 'x';
$this->setReport($key, 'error', labelTranslation(MICKA_LANG, 'Record exists, import cancelled. No update rights.'));
} elseif ($record['report'] == 'Not rights' && $record['right'] == 'x') {
$this->md_head[$key]['action'] = 'skip';
$this->md_head[$key]['right'] = 'x';
$this->setReport($key, 'error', labelTranslation(MICKA_LANG, 'Record exists, import cancelled. No update rights.'));
} elseif ($record['report'] == 'ok' && $record['right'] == 'w') {
if ($this->action == 'skip') {
$this->md_head[$key]['action'] = 'skip';
$this->md_head[$key]['right'] = 'w';
$this->setReport($key, 'error', labelTranslation(MICKA_LANG, 'Record exists, import cancelled.'));
} else {
// update
if ($record_orig['report'] == 'Record not found') {
// nový záznam v tmp
$this->md_head[$key]['action'] = 'insert';
$this->md_head[$key]['right'] = 'w';
} else {
$this->md_head[$key]['recno'] = isset($record_orig['md']['RECNO']) && $record_orig['md']['RECNO'] > 0 ? $record_orig['md']['RECNO'] : -1;
$this->md_head[$key]['action'] = 'update';
$this->md_head[$key]['right'] = 'w';
//$this->md_head[$key]['report'] = '';
//$this->setReport($key, 'error', "INFO: " . labelTranslation(MICKA_LANG, 'The metadata record already exists. It will be replaced with the new one when you save it.'));
$md['langs'] = $this->table_mode == 'tmp' ? getUniqueMdLangs($md['langs'], $record_orig['md']['LANG']) : $md['langs'];
$this->data_type = $this->data_type == -100 ? $record_orig['md']['DATA_TYPE'] : $this->data_type;
}
}
} elseif ($record['report'] == 'Record not found') {
$this->md_head[$key]['action'] = 'insert';
$this->md_head[$key]['right'] = 'w';
} else {
$this->md_head[$key]['action'] = 'skip';
$this->md_head[$key]['right'] = 'x';
$this->setReport($key, 'error', labelTranslation(MICKA_LANG, 'unknow error in MD'));
}
} else {
// Nový záznam
$this->md_head[$key]['action'] = 'insert';
$this->md_head[$key]['right'] = 'w';
}
// akce
$data = array();
switch ($md['iso']) {
case 'MD':
$data['md_standard'] = 0;
break;
case 'MS':
case 'MC':
$data['md_standard'] = 10;
break;
case 'DC':
$data['md_standard'] = 1;
break;
case 'FC':
$data['md_standard'] = 2;
break;
default:
$data['md_standard'] = $this->mds;
}
$data['lang'] = $md['langs'];
$data['server_name'] = $this->server_name;
if ($this->md_head[$key]['action'] == 'insert') {
// vytvoření záznamu v tabulce [md]
if ($md['uuid'] != '') {
$data['uuid'] = $md['uuid'];
} else {
$data['uuid'] = getUuid();
$this->md_head[$key]['uuid'] = $data['uuid'];
}
$data['edit_group'] = $this->group_e != '' ? $this->group_e : $this->user;
$data['view_group'] = $this->group_v != '' ? $this->group_v : $this->user;
$data['data_type'] = $this->data_type == -100 ? -1 : $this->data_type;
if ($this->table_mode == 'md') {
$this->md_head[$key]['recno'] = $md_record->setNewRecordMd($data, $md['lang'], $import = TRUE);
} else {
$this->md_head[$key]['recno'] = $md_record->setNewRecord($data, $md['lang'], $import = TRUE);
}
} elseif ($this->md_head[$key]['action'] == 'update' && $this->md_head[$key]['recno'] > 0) {
// Aktualizace [md]
if ($this->micka_lite === TRUE) {
if (array_key_exists('lang', $data) === TRUE) {
unset($data['lang']);
}
}
if ($this->micka_lite === FALSE) {
$data['data_type'] = $this->data_type;
}
$md_record->updateMdFromImport($this->md_head[$key]['recno'], $data);
// Smazání [md_values]
if ($this->micka_lite) {
$md_record->deleteMdIdFromMdValues($this->md_head[$key]['recno'], $md['langs'], $this->del_md_id[$key]);
} else {
$md_record->deleteMdValuesBeforeImport($this->md_head[$key]['recno']);
}
}
if ($this->md_head[$key]['action'] == 'insert' || $this->md_head[$key]['action'] == 'update') {
// Vložení nových hodnot
if ($this->md_head[$key]['recno'] > 0) {
$data = array();
foreach ($this->md_values[$key] as $md_values) {
$md_values['recno'] = $this->md_head[$key]['recno'];
if ($this->micka_lite === TRUE && isset($record_orig['md']['LANG']) && $md_values['lang'] != 'xxx') {
// pokud byl odstraněn nějaký jazyk, odstranit i data
if (strpos($record_orig['md']['LANG'], $md_values['lang']) !== FALSE) {
array_push($data, $md_values);
}
} else {
array_push($data, $md_values);
}
}
if ($this->micka_lite === FALSE) {
// zachovat původní datestamp
$md_record->setRecordImporting(TRUE);
}
$md_record->setMdValues($data);
$this->md_head[$key]['ok'] = 1;
$this->md_head[$key]['valid'] = $md_record->getReportValid();
}
}
}
}
}
