Exemple #1
0
/**
 * Metainformation catalogue
 * --------------------------------------------------
 *
 * MICKA_LIB_INSERT.PHP for MicKa
 *
 * @link       http://www.bnhelp.cz
 * @package    Micka
 * @category   Metadata
 * @version    20101120
 * @authors		 DZ
 */
function deleteMd($user, $type, $value, $mode, $par = NULL)
{
    setMickaLog('micka_lib_insert.php (deleteMd)', 'DEBUG', "user={$user}, {$type}={$value}, mode={$mode}, par={$par}");
    $rs = FALSE;
    // autorizace
    if ($user == 'guest' || !canAction()) {
        return $rs;
    }
    $record = getMdHeader($type, $value, $col = '', $fetch = array('all', '='));
    if (isset($record[0]['RECNO']) && $record[0]['RECNO'] > -1) {
        if (!getMdRight('edit', $user, $record[0]['DATA_TYPE'], $record[0]['CREATE_USER'], $record[0]['EDIT_GROUP'], $record[0]['VIEW_GROUP'])) {
            return $rs;
        } else {
            $sql = array();
            if ($mode == 'all') {
                array_push($sql, 'DELETE FROM [md_values] WHERE [recno]=%i;', $record[0]['RECNO']);
                array_push($sql, 'DELETE FROM [md] WHERE [recno]=%i;', $record[0]['RECNO']);
            } elseif ($mode == 'value') {
                array_push($sql, 'DELETE FROM [md_values] WHERE [recno]=%i  AND md_id<>38;', $record[0]['RECNO']);
            }
            dibi::begin();
            try {
                dibi::query($sql);
                dibi::commit();
                $rs = TRUE;
            } catch (DibiException $e) {
                setMickaLog($e, 'ERROR', 'micka_lib_insert.php (deleteMd)');
                dibi::rollback();
            }
        }
    }
    //Debug::dump($rs);
    setMickaLog('micka_lib_insert.php (deleteMd)', 'DEBUG', "return={$rs}");
    return $rs;
}
Exemple #2
0
 public function setRecordAdmin($form_akce, $form_data)
 {
     $rs = 'error';
     if ($form_data['recno'] == '') {
         return $rs;
     }
     $del_lang = array();
     $recno = $form_data['recno'];
     $record = $this->getMdValues($recno, 'xxx', 0, 0);
     if ($record['report'] != 'ok' || $this->md_record['md']['RECNO'] != $recno) {
         setMickaLog($record['report'], 'ERROR', 'MdRecord.setRecordAdmin');
         //$rs['report'] = $md['report'];
         return $rs;
     }
     if ($this->md_record['user_right'] == 'r') {
         setMickaLog("Not edit rights", 'ERROR', 'MdRecord.setRecordAdmin');
         //$rs['report'] = 'Not rights';
         return $rs;
     }
     if (isset($record['md']['RECNO']) && $record['md']['RECNO'] > -1) {
         // jazyk metadat
         $md_lang = '';
         if ($record['md']['MD_STANDARD'] == 0 || $record['md']['MD_STANDARD'] == 10) {
             foreach ($record['md_values'] as $row) {
                 if ($row['MD_ID'] == 5527) {
                     $md_lang = $row['MD_VALUE'];
                     break;
                 }
             }
         }
         if ($md_lang != '' && strpos($form_data['lang'], $md_lang) === FALSE) {
             $form_data['lang'] = $form_data['lang'] == '' ? $md_lang : $md_lang . '|' . $form_data['lang'];
         }
         $langs = explode('|', $form_data['lang']);
         $orig_lang = explode('|', $record['md']['LANG']);
         foreach ($orig_lang as $kl => $hod) {
             $key = array_search($hod, $langs);
             if ($key === false) {
                 $del_lang[] = $hod;
             }
         }
         if ($form_akce == 'form' && count($del_lang) > 0) {
             $_SESSION['micka']['rec_admin']['recno'] = $form_data['recno'];
             $_SESSION['micka']['rec_admin']['edit_group'] = $form_data['edit_group'];
             $_SESSION['micka']['rec_admin']['view_group'] = $form_data['view_group'];
             //$_SESSION['micka']['rec_admin']['data_type'] = $form_data['data_type'];
             $_SESSION['micka']['rec_admin']['lang'] = $form_data['lang'];
             return 'warning';
         } elseif ($form_akce == 'warning' && count($del_lang) > 0) {
             $this->deleteMdValues($recno, -1, -1, -1, $del_lang);
         }
         if ($this->setMd($recno, $form_data)) {
             $rs = 'ok';
         }
     }
     return $rs;
 }
Exemple #3
0
 function getMdRecord($user, $uuid, $akce)
 {
     setMickaLog("user={$user}, uuid={$uuid}, akce={$akce}", 'DEBUG', 'MdDetail.getMdRecord.start');
     $rs = array();
     $rs['data'] = FALSE;
     $col = 'recno, uuid, md_standard, lang, data_type, create_user, edit_group, view_group, x1 ,x2, y1, y2, title, valid';
     $record = getMdHeader('uuid', $uuid, $col, array('all', '='));
     if (isset($record[0]['RECNO']) && $record[0]['RECNO'] > -1) {
         // autorizace
         if (!getMdRight('view', $user, $record[0]['DATA_TYPE'], $record[0]['CREATE_USER'], $record[0]['EDIT_GROUP'], $record[0]['VIEW_GROUP'])) {
             setMickaLog("Not right", 'ERROR', 'MdDetail.php (getMdRecord)');
             return $rs;
         }
         $rs['head']['edit'] = 0;
         if (getMdRight('edit', $user, $record[0]['DATA_TYPE'], $record[0]['CREATE_USER'], $record[0]['EDIT_GROUP'], $record[0]['VIEW_GROUP']) === TRUE) {
             $rs['head']['edit'] = 1;
         }
         $this->mds = $record[0]['MD_STANDARD'];
         $rs['head']['recno'] = $record[0]['RECNO'];
         $rs['head']['mds'] = $record[0]['MD_STANDARD'];
         $rs['head']['uuid'] = $record[0]['UUID'];
         $rs['head']['title'] = $record[0]['TITLE'];
         $rs['head']['valid'] = $record[0]['VALID'] != '' ? $record[0]['VALID'] : '';
         $rs['head']['x1'] = array_key_exists('X1', $record[0]) ? (string) str_replace(",", ".", $record[0]['X1']) : '';
         $rs['head']['y1'] = array_key_exists('Y1', $record[0]) ? (string) str_replace(",", ".", $record[0]['Y1']) : '';
         $rs['head']['x2'] = array_key_exists('X2', $record[0]) ? (string) str_replace(",", ".", $record[0]['X2']) : '';
         $rs['head']['y2'] = array_key_exists('Y2', $record[0]) ? (string) str_replace(",", ".", $record[0]['Y2']) : '';
         $rs['head']['hierarchy'] = '';
         if ($akce == 'detail') {
             if ($record[0]['MD_STANDARD'] == 0 || $record[0]['MD_STANDARD'] == 10) {
                 $rs['data'] = $this->getMdValuesMdId($record[0]['RECNO'], $record[0]['MD_STANDARD'], $this->getLangValue($record[0]['LANG']));
                 // Rodicovske zaznamy
                 $master = isset($rs['data'][121][0]) ? $rs['data'][121][0] : '';
                 $rs['head']['master'] = $this->getMdMaster($master);
                 // Je rodicem pro zaznamy
                 $rs['head']['slave'] = $this->getMdSlave($record[0]['UUID']);
                 $rs['head']['repre'] = $this->getSpatialRep($record[0]['RECNO']);
             } elseif ($record[0]['MD_STANDARD'] == 1) {
                 $rs['data'] = $this->getMdValuesMdId($record[0]['RECNO'], $record[0]['MD_STANDARD'], $this->getLangValue($record[0]['LANG']));
             } elseif ($record[0]['MD_STANDARD'] == 2) {
                 //$pom = $this->getMdValuesMdId($record[0]['RECNO'], $record[0]['MD_STANDARD'], $this->getLangValue($record[0]['LANG']), 'no_lang');
                 $pom = getMdValues($record[0]['RECNO'], $record[0]['MD_STANDARD'], $this->getLangValue($record[0]['LANG']), 'no_lang');
                 if (isset($pom[0][0])) {
                     $rs['data'] = $pom[0][0];
                 }
             }
         } elseif ($akce == 'detailall') {
             $rs['data'] = $this->getMdDetailView($record[0]['RECNO'], $record[0]['MD_STANDARD']);
             if ($record[0]['MD_STANDARD'] == 0 || $record[0]['MD_STANDARD'] == 10) {
                 foreach ($rs['data'] as $value) {
                     if ($value['id'] == 11 || $value['id'] == 5063) {
                         $rs['head']['title'] = $value['hodnota'];
                         break;
                     }
                 }
             }
         }
     }
     $rs['head']['hierarchy'] = $this->hierarchy;
     setMickaLog($rs, 'DEBUG', 'MdDetail.getMdRecord.return');
     return $rs;
 }
Exemple #4
0
function main_rec_admin($post)
{
    $rs = array();
    $rs['akce'] = 'error';
    $rs['ok'] = FALSE;
    $rs['report'] = '';
    $rs['data'] = '';
    //$recno = ($post['recno'] != '') ? htmlspecialchars($post['recno']) : -1;
    $recno = $_REQUEST['recno'] != '' ? htmlspecialchars($_REQUEST['recno']) : -1;
    if ($recno == -1) {
        setMickaLog('Recno=-1, not edit', 'ERROR', 'micka_main_lib.main_rec_admin');
        $rs['report'] = 'Bad input! (recno -1)';
        return $rs;
    }
    $form_akce = isset($post['form_akce']) ? htmlspecialchars($post['form_akce']) : 'new';
    $md_record = new MdRecord();
    $md_record->setTableMode('tmp');
    if ($form_akce == 'new') {
        // editační formulář
        $record = $md_record->getMdValues($recno, 'xxx', 0, 0);
        if (isset($record['report']) && $record['report'] != 'ok') {
            setMickaLog("Recno={$recno}, " . $record['report'], 'ERROR', 'micka_main_lib.main_rec_admin');
            $rs['report'] = $record['report'];
            return $rs;
        }
        $rs['ok'] = TRUE;
        $rs['akce'] = 'record_admin';
        $rs['data']['form_akce'] = 'new';
        $rs['data']['RECNO'] = $record['md']['RECNO'];
        //$rs['data']['DATA_TYPE'] = $record['md']['DATA_TYPE'];
        $rs['data']['LANG'] = $record['md']['LANG'];
        //$rs['data']['EDIT_GROUP'] = $record['md']['EDIT_GROUP'];
        //$rs['data']['VIEW_GROUP'] = $record['md']['VIEW_GROUP'];
        // jazyk metadat
        $rs['data']['md_lang'] = '';
        if ($record['md']['MD_STANDARD'] == 0 || $record['md']['MD_STANDARD'] == 10) {
            foreach ($record['md_values'] as $row) {
                if ($row['MD_ID'] == 5527) {
                    $rs['data']['md_lang'] = $row['MD_VALUE'];
                    break;
                }
            }
        }
    } elseif ($form_akce == 'form' && count($post) > 1) {
        $form_data['recno'] = $recno;
        //$form_data['edit_group'] = $post['edit_group'];
        //$form_data['view_group'] = $post['view_group'];
        //$form_data['data_type'] = isset($post['public']) ? 1 : 0;
        $form_data['lang'] = isset($post['rec_lang']) && count($post['rec_lang']) > 0 ? implode('|', $post['rec_lang']) : '';
        $rs['ok'] = TRUE;
        $rs['akce'] = 'record_admin';
        $rs['data']['form_akce'] = $md_record->setRecordAdmin($form_akce, $form_data);
        $rs['data']['RECNO'] = $recno;
        //$rs['data']['DATA_TYPE'] = '';
        $rs['data']['LANG'] = '';
        //$rs['data']['EDIT_GROUP'] = '';
        //$rs['data']['VIEW_GROUP'] = '';
    } elseif ($form_akce == 'form' && count($post) < 0) {
        setMickaLog('Not complete input!', 'ERROR', 'micka_main_lib.main_rec_admin');
        $rs['report'] = 'Not complete input!';
    } elseif ($form_akce == 'warning') {
        $recno = isset($post['recno']) ? htmlspecialchars($post['recno']) : -1;
        $form_data['recno'] = $_SESSION['micka']['rec_admin']['recno'];
        //$form_data['edit_group'] = $_SESSION['micka']['rec_admin']['edit_group'];
        //$form_data['view_group'] = $_SESSION['micka']['rec_admin']['view_group'];
        //$form_data['data_type'] = $_SESSION['micka']['rec_admin']['data_type'];
        $form_data['lang'] = $_SESSION['micka']['rec_admin']['lang'];
        unset($_SESSION['micka']['rec_admin']);
        $rs['ok'] = TRUE;
        $rs['akce'] = 'record_admin';
        $rs['data']['form_akce'] = $md_record->setRecordAdmin($form_akce, $form_data);
    }
    return $rs;
}
Exemple #5
0
function getMdIdFromMdPath($md_path)
{
    $rs = '';
    $md_path = substr($md_path, 0, strlen($md_path) - 1);
    $pom = explode('_', $md_path);
    if (count($pom) > 1) {
        $idx = count($pom) - 2;
        $rs = $pom[$idx];
    }
    if ($rs == '') {
        setMickaLog("BAD md_path={$md_path}", 'ERROR', 'micka_lib.getMdIdFromMdPath');
    }
    return $rs;
}
Exemple #6
0
 function checkProfilSelect($mdid, $profil)
 {
     setMickaLog("BEGIN", 'DEBUG', 'Tree.php (checkProfilSelect)');
     $sql = array();
     $rs = array();
     $sql[] = "SELECT profil_id,md_id FROM profil WHERE md_id IN ({$mdid}) AND profil_id IN ({$profil})";
     $result = _executeSql('select', $sql, array('all'));
     foreach ($result as $row) {
         $mdid = $row['MD_ID'];
         $profil = $row['PROFIL_ID'];
         $rs[$mdid][$profil] = $row['MD_ID'];
     }
     return $rs;
 }
Exemple #7
0
 public function getEditForm($mds, $recno, $md_langs, $profil, $package, $md_values)
 {
     setMickaLog("mds={$mds}, recno={$recno}, profil={$profil}, package={$package}", 'DEBUG', 'EditForm.getEditForm');
     $md_id_start = -1;
     $this->setMdLangs($md_langs);
     $this->setCodeListArray(getIsInspirePackage($mds, $profil));
     $this->setButtonLabelArray();
     $this->setFormValuesArray($md_values);
     if ($mds == 10 && $profil == -1 && $package == 1) {
         $md_id_start = 4752;
     }
     if ($mds == 0 && $profil == -1 && $package == 1) {
         $md_id_start = 1;
     }
     $this->recno = $recno;
     $this->mds = $mds;
     $this->profil = $profil;
     $this->package = $package;
     $this->getFormData($this->getMdTree($recno, $mds, $profil, $package, $md_id_start));
     $this->getRepeat(1, 1);
     return $this->form_data;
 }
Exemple #8
0
function updateXml($user, $type, $value)
{
    $rs = FALSE;
    $xsltemplate = 'micka2one19139.xsl';
    $recno = -1;
    $uuid = '';
    if ($type == 'uuid' && $value != '') {
        $uuid = $value;
    } elseif ($type == 'recno' && $value > -1) {
        $recno = $value;
        $uuid = getMdHeader($type, $value, 'uuid', array('single'));
        $type = 'uuid';
    }
    if ($type == 'uuid' && $uuid != '') {
        $xml = getXml($user, $uuid, $xsltemplate, 'data');
        if ($xml === FALSE || $xml == '') {
            setMickaLog('$xml === FALSE', 'ERROR', 'micka_lib_xml.php (updateXml)');
        } else {
            $sql = array();
            array_push($sql, "UPDATE md SET pxml=%s WHERE uuid=%s", $xml, $uuid);
            $rs = _executeSql('update', $sql, array('all'));
        }
    }
    return $rs;
}
Exemple #9
0
 public function getData($in)
 {
     setMickaLog($in, 'FUNCTION', "MdExport.getData.start");
     $rs = array();
     $rs['paginator']['records'] = 0;
     $this->xml_from = 'summary';
     $this->setQueryIn($in);
     $in = $this->query_in;
     $pom = $this->setQuery($in);
     if ($pom == -1) {
         setMickaLog('SQL == -1', 'ERROR', 'MdExport.getData');
         // TODO: návrat chyby
         /*
         if ($this->query_status === FALSE) {
         	//my_print_r($this->query_error);
         }
         */
         return -1;
     } elseif ($pom['paginator']['records'] > 0) {
         $result = dibi::query($pom['sql']);
         $rs['data'] = DB_DRIVER == 'oracle' ? setUpperColsName($result->fetchAssoc('RECNO,#,=')) : setUpperColsName($result->fetchAssoc('recno,#,='));
         $rs['paginator'] = $pom['paginator'];
     }
     if (isset($rs['data']) && count($rs['data']) > 0) {
         $rs['data'] = $this->setData2Micka($rs['data']);
     }
     setMickaLog($rs, 'DEBUG', "MdExport.getData.return");
     return $rs;
 }
Exemple #10
0
/**
 * Provedení sql dotazu a předání nalezených záznamů v požadovaném tvaru
 *
 * <b>Příklady:</b><br>
 * první políčko výsledku<br>
 * <code>_executeSql('select', $sql, array('single'));</code>
 * celá tabulka do indexovaného pole<br>
 * <code>_executeSql('select', $sql, array('all'));</code>
 * celá tabulka do asociativního pole a klíčem je políčko ‚recno‘
 * <code>_executeSql('select', array($pom['sql']), array('assoc', 'recno,#,='));</code>
 * asociativního pole klíč ⇒ hodnota
 * <code>_executeSql('select', array($pom['sql']), array('pairs', 'recno', 'xmldata'));</code>
 * update, insert, delete
 * <code>_executeSql('update', $sql, array());</code>
 *
 * @param string $type 'select', 'update', 'insert', 'delete'
 * @param array $sql
 * @param array $fetch 'single', 'all', 'assoc', 'pairs'
 */
function _executeSql($type, $sql, $fetch, $upper = TRUE)
{
    //setMickaLog("SQL TYPE=$type, fetch=" . $fetch[0], 'FUNCTION', 'micka_lib_db._executeSql.start');
    $rs = FALSE;
    if (count($sql) == 0) {
        setMickaLog("empty SQL", 'ERROR', 'micka_lib_db._executeSql');
        return $sql;
    }
    if (is_array($sql) && is_array($fetch) && $type == 'select') {
        $result = dibi::query($sql);
        setMickaLog(preg_replace("/\\s{2,}/", ' ', dibi::$sql), 'SQL', 'micka_lib_db._executeSql.sql');
        //Debugger::log('[micka_lib_db._executeSql.select] ' . dibi::$sql, 'INFO');
        //Debugger::log('[micka_lib_db._executeSql.select] ' . print_r($sql, true), 'INFO');
        if ($fetch[0] == 'single') {
            $rs = trim($result->fetchSingle());
        } elseif ($fetch[0] == 'all') {
            //setMickaLog("FETCH ALL START", 'DEBUG', 'micka_lib_db._executeSql');
            $blob = 'OCI-Lob';
            //if (count($result) > 0) { // FIXME: ORACLE - nefunguje
            foreach ($result as $n => $row) {
                foreach ($row as $key => $value) {
                    if (DB_DRIVER == 'oracle') {
                        if ($value instanceof $blob) {
                            $rs[$n][$key] = $value->load();
                        } else {
                            $rs[$n][$key] = is_string($value) ? rtrim($value) : $value;
                        }
                    } else {
                        $rs[$n][strtoupper($key)] = is_string($value) ? rtrim($value) : $value;
                    }
                }
            }
            //}
            //setMickaLog("FETCH ALL END", 'DEBUG', 'micka_lib_db._executeSql');
        } elseif ($fetch[0] == 'assoc') {
            $rs = setUpperColsName($result->fetchAssoc($fetch[1]));
        } elseif ($fetch[0] == 'pairs' && count($fetch) == 3) {
            if (DB_DRIVER == 'oracle') {
                $rs = $upper ? setUpperColsName($result->fetchPairs(strtoupper($fetch[1]), strtoupper($fetch[2]))) : $result->fetchPairs(strtoupper($fetch[1]), strtoupper($fetch[2]));
            } else {
                $rs = $upper ? setUpperColsName($result->fetchPairs($fetch[1], $fetch[2])) : $result->fetchPairs($fetch[1], $fetch[2]);
            }
        }
    } elseif (is_array($sql) && ($type == 'update' || $type == 'insert' || $type == 'delete')) {
        $rs = dibi::query($sql);
        setMickaLog(preg_replace("/\\s{2,}/", ' ', dibi::$sql), 'SQL', 'micka_lib_db._executeSql.sql');
        //Debugger::log('[micka_lib_db._executeSql.update] ' . dibi::$sql, 'INFO');
    } elseif (is_array($sql) && $type == 'pxml') {
        //Debugger::log('[micka_lib_db._executeSql.pxml] ' . $sql[0], 'INFO');
        $rs = dibi::query($sql[0]);
        //Debugger::log('[micka_lib_db._executeSql.pxml] OK', 'INFO');
    } else {
        setMickaLog("unknow TYPE SQL", 'ERROR', 'micka_lib_db._executeSql');
    }
    unset($result);
    setMickaLog("", 'FUNCTION', 'micka_lib_db._executeSql.end');
    return $rs;
}
Exemple #11
0
 private function addLogImport($fc, $text)
 {
     setMickaLog($text, 'DEBUG', "MdImport.{$fc}");
 }