src/snac/server/database/SQL.php
/**
     * select other IDs
     *
     * These were originally ID values of merged records. DBUtils has code that adds an otherRecordID to a
     * Constellation object.
     *
     * @param string[] $vhInfo associative list with keys: version, ic_id
     *
     * @return string[] Return an associative ist of otherid rows with keys: id, version, ic_id, text, uri,
     * type, link_type. otherid.type is an integer fk id from vocabulary, not that we need to concern
     * ourselves with that here.
     *
     */
select other IDs
These were originally ID values of merged records. DBUtils has code that adds an otherRecordID to a
Constellation object.

@param string[] $vhInfo associative list with keys: version, ic_id

@return string[] Return an associative ist of otherid rows with keys: id, version, ic_id, text, uri,
type, link_type. otherid.type is an integer fk id from vocabulary, not that we need to concern
ourselves with that here.
select other IDs These were originally ID values of merged records . DBUtils has code that adds an otherRecordID to a Constellation object . @param string [] $vhInfo associative list with keys : version ic_id @return string [] Return an associative ist of otherid rows with keys : id version ic_id text uri type link_type . otherid . type is an integer fk id from vocabulary not that we need to concern ourselves with that here .
public function selectOtherID($vhInfo)
    {
        $qq = 'sorid';
        $this->sdb->prepare($qq,
                            'select
                            aa.id, aa.version, aa.ic_id, aa.text, aa.uri, aa.type
                            from otherid as aa,
                            (select id,max(version) as version from otherid where version<=$1 and ic_id=$2 group by id) as bb
                            where not aa.is_deleted and
                            aa.id = bb.id and
                            aa.version = bb.version order by id asc');
        $all = array();
        $result = $this->sdb->execute($qq, array($vhInfo['version'], $vhInfo['ic_id']));
        while($row = $this->sdb->fetchrow($result))
        {
            array_push($all, $row);
        }
        $this->sdb->deallocate($qq);
        return $all;
    }
public function selectOtherID ( $ vhInfo ) { $ qq = 'sorid' ; $ this -> sdb -> prepare ( $ qq , 'select
                            aa.id, aa.version, aa.ic_id, aa.text, aa.uri, aa.type
                            from otherid as aa,
                            (select id,max(version) as version from otherid where version<=$1 and ic_id=$2 group by id) as bb
                            where not aa.is_deleted and
                            aa.id = bb.id and
                            aa.version = bb.version order by id asc' ) ; $ all = array ( ) ; $ result = $ this -> sdb -> execute ( $ qq , array ( $ vhInfo [ 'version' ] , $ vhInfo [ 'ic_id' ] ) ) ; while ( $ row = $ this -> sdb -> fetchrow ( $ result ) ) { array_push ( $ all , $ row ) ; } $ this -> sdb -> deallocate ( $ qq ) ; return $ all ; }
select other IDs
 These were originally ID values of merged records.
select other IDs These were originally ID values of merged records .