protected function getFieldOutputTextFK($foreignKeysArray, $value, $iar)
    {
        $query   = $this->sQueryGenericSelectKeyValue([
            '`' . $value['COLUMN_NAME'] . '`',
            $foreignKeysArray[$value['COLUMN_NAME']][2],
            $foreignKeysArray[$value['COLUMN_NAME']][0]
        ]);
        $inAdtnl = ['size' => 1];
        if ($value['IS_NULLABLE'] == 'YES') {
            $inAdtnl = array_merge($inAdtnl, ['include_null']);
        }
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        $slct = [
            'Options' => $this->setMySQLquery2Server($query, 'array_key_value')['result'],
            'Value'   => $this->getFieldValue($value),
        ];
        return $this->setArrayToSelect($slct['Options'], $slct['Value'], $value['COLUMN_NAME'], $inAdtnl);
    }
protected function getFieldOutputTextFK($foreignKeysArray, $value, $iar)
    {
        $query   = $this->sQueryGenericSelectKeyValue([
            '`' . $value['COLUMN_NAME'] . '`',
            $foreignKeysArray[$value['COLUMN_NAME']][2],
            $foreignKeysArray[$value['COLUMN_NAME']][0]
        ]);
        $inAdtnl = ['size' => 1];
        if ($value['IS_NULLABLE'] == 'YES') {
            $inAdtnl = array_merge($inAdtnl, ['include_null']);
        }
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        $slct = [
            'Options' => $this->setMySQLquery2Server($query, 'array_key_value')['result'],
            'Value'   => $this->getFieldValue($value),
        ];
        return $this->setArrayToSelect($slct['Options'], $slct['Value'], $value['COLUMN_NAME'], $inAdtnl);
    }
protected function getFieldOutputTextFK ( $ foreignKeysArray , $ value , $ iar ) { $ query = $ this -> sQueryGenericSelectKeyValue ( [ '`' . $ value [ 'COLUMN_NAME' ] . '`' , $ foreignKeysArray [ $ value [ 'COLUMN_NAME' ] ] [ 2 ] , $ foreignKeysArray [ $ value [ 'COLUMN_NAME' ] ] [ 0 ] ] ) ; $ inAdtnl = [ 'size' => 1 ] ; if ( $ value [ 'IS_NULLABLE' ] == 'YES' ) { $ inAdtnl = array_merge ( $ inAdtnl , [ 'include_null' ] ) ; } if ( $ iar !== [ ] ) { $ inAdtnl = array_merge ( $ inAdtnl , $ iar ) ; } $ slct = [ 'Options' => $ this -> setMySQLquery2Server ( $ query , 'array_key_value' ) [ 'result' ] , 'Value' => $ this -> getFieldValue ( $ value ) , ] ; return $ this -> setArrayToSelect ( $ slct [ 'Options' ] , $ slct [ 'Value' ] , $ value [ 'COLUMN_NAME' ] , $ inAdtnl ) ; }
Prepares the output of text fields defined w. FKs

@param array $foreignKeysArray
@param array $value
@param array $iar
@return string
Prepares the output of text fields defined w . FKs