예제 #1
0
function createTermsOptions($config, $type)
{
    global $sourcedbname, $db_prefix, $dbPrefix, $is_h2;
    $sourcedb = $db_prefix . $sourcedbname;
    $entnames = getTerms();
    //in current database
    $entnames = $entnames['termsByDomainLookup'][$type];
    foreach ($entnames as $id => $name) {
        $entnames[$id] = $name[0];
    }
    $seloptions = createOptions("ot", $entnames);
    print "<h3>Term mappings ({$type}" . "s)" . "</h3>[Term code] <b>{$sourcedb}</b> ==> <b>{$dbPrefix}" . HEURIST_DBNAME . "</b><p>";
    // . "<p>";
    // Get the term mapping, by default assume that the code is unchanged so select the equivalent term if available
    if ($is_h2) {
        $query1 = "SELECT DISTINCT `rdl_id`,`rdl_id`,`rd_val` FROM `{$sourcedb}`.`rec_details`,`{$sourcedb}`.`rec_detail_lookups` " . "where (`rd_type`=`rdl_rdt_id`) AND (`rdl_value`=`rd_val`) AND (`rdl_related_rdl_id` is " . ($type != 'enum' ? "not" : "") . " null)";
    } else {
        if ($type != 'enum') {
            $type = 'relationtype';
        }
        $query1 = "SELECT DISTINCT `dtl_Value`,`trm_ID`,`trm_Label` FROM `{$sourcedb}`.`recDetails`,`{$sourcedb}`.`defTerms` " . "where (`dtl_Value`=`trm_ID`) AND (`dtl_DetailTypeID` in (select `dty_ID` from `{$sourcedb}`.`defDetailTypes` " . "where (`dty_Type`='{$type}') ))";
    }
    $res1 = mysql_query($query1);
    print "<table>";
    while ($row1 = mysql_fetch_array($res1)) {
        $tt = $row1[0];
        //0=trm_ID
        $selopts = $seloptions;
        //find the closest name
        $selectedId = getPresetId($config, "cbt" . $tt);
        if (!$selectedId) {
            //find the closest name
            $selectedId = findClosestName($row1[2], $entnames);
            //trm_Label
        }
        if ($selectedId) {
            $repl = "value='" . $selectedId . "'";
            $selopts = str_replace($repl, $repl . " selected='selected' ", $selopts);
        }
        print "<tr><td>[ {$tt} ] " . $row1[2] . " </td>" . "<td>==> <select id='cbt{$tt}' name='cbt{$tt}' class='terms'><option id='ot0' value='0'></option>" . $selopts . "</select></td></tr>\n";
    }
    // loop through terms
    print "</table>";
}
예제 #2
0
function createTagsOptions($config)
{
    global $sourcedbname, $db_prefix, $dbPrefix, $is_h2;
    $sourcedb = $db_prefix . $sourcedbname;
    $allusers = getUsers();
    //in current database
    $seloptions = createOptions("us", $allusers);
    print "<h3>User mappings for tag (keyword) import" . "</h3>" . " &nbsp;<b>{$sourcedb}</b> &nbsp;[User id] ==> <b>{$dbPrefix}" . HEURIST_DBNAME . "</b><p>";
    // . "<p>";
    // Get users with tags
    if ($is_h2) {
        $query1 = "select usr.Id, usr.Username, usr.Realname as fullname, count(kwl_rec_id)\n                    from `{$sourcedb}`.`Users` usr, `{$sourcedb}`.`keywords` kwd, `{$sourcedb}`.`keyword_links` kwl\n                    where usr.IsModelUser=0 and kwd.kwd_usr_id=usr.Id and kwl.kwl_kwd_id=kwd.kwd_id\n                    group by usr.Id\n                    order by fullname";
    } else {
        $query1 = "select usr.ugr_ID, usr.ugr_Name,\n                    concat(usr.ugr_FirstName, ' ', usr.ugr_LastName) as fullname,\n                    count(rtl_RecID)\n                    from `{$sourcedb}`.`sysUGrps` usr, `{$sourcedb}`.`usrTags` kwd, `{$sourcedb}`.`usrRecTagLinks` kwl\n                    where usr.ugr_Enabled='y' and usr.ugr_Type='user' and\n                    usr.ugr_IsModelUser=0 and kwd.tag_UGrpID=usr.ugr_ID and kwl.rtl_TagID=kwd.tag_ID\n                    group by usr.ugr_ID\n                    order by fullname";
    }
    $res1 = mysql_query($query1);
    print "<table>";
    while ($row1 = mysql_fetch_array($res1)) {
        $tt = $row1[0];
        //0=usr_ID
        $selopts = $seloptions;
        $bgcolor = "";
        $selectedId = null;
        if ($config) {
            $selectedId = getPresetId($config, "cbu" . $tt);
        } else {
            //    if(!$selectedId){    //find the closest name
            $selectedId = findClosestName($row1[1], $allusers);
            //ugr_Name
            if ($selectedId < 0) {
                //exact match
                $bgcolor = "style='background-color:#ccc;'";
                $selectedId = -$selectedId;
            }
        }
        if ($selectedId) {
            $repl = "value='" . $selectedId . "'";
            $selopts = str_replace($repl, $repl . " selected='selected' ", $selopts);
        }
        print "<tr {$bgcolor}><td><label id='lblu{$tt}'>" . $row1[1] . " &nbsp;[ {$tt} ] </label></td>" . "<td>==> <select id='cbu{$tt}' name='cbu{$tt}' class='users'><option id='ou0' value='0'></option>" . $selopts . "</select></td></tr>\n";
    }
    // loop through terms
    print "</table>";
}