本文整理汇总了PHP中DatabaseCompatibilityUtil::concat方法的典型用法代码示例。如果您正苦于以下问题:PHP DatabaseCompatibilityUtil::concat方法的具体用法?PHP DatabaseCompatibilityUtil::concat怎么用?PHP DatabaseCompatibilityUtil::concat使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DatabaseCompatibilityUtil
的用法示例。
在下文中一共展示了DatabaseCompatibilityUtil::concat方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getUsersByPartialFullName
/**
* For a give User name, run a partial search by
* full name and retrieve user models.
*
*/
public static function getUsersByPartialFullName($partialName, $pageSize)
{
assert('is_string($partialName)');
assert('is_int($pageSize)');
$personTableName = RedBeanModel::getTableName('Person');
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('User');
$joinTablesAdapter->addFromTableAndGetAliasName($personTableName, "{$personTableName}_id");
$fullNameSql = DatabaseCompatibilityUtil::concat(array('person.firstname', '\' \'', 'person.lastname'));
$where = " (person.firstname like lower('{$partialName}%') or " . " person.lastname like lower('{$partialName}%') or " . " {$fullNameSql} like lower('{$partialName}%')) ";
return User::getSubset($joinTablesAdapter, null, $pageSize, $where, "person.firstname, person.lastname");
}
示例2: getModelsByFullName
public static function getModelsByFullName($modelClassName, $fullName)
{
assert('is_string($modelClassName)');
assert('is_subclass_of($modelClassName, "Person") && $modelClassName != "Person" ||' . '$modelClassName == "User"');
assert('is_string($fullName)');
$personTableName = RedBeanModel::getTableName('Person');
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter($modelClassName);
$joinTablesAdapter->addFromTableAndGetAliasName($personTableName, "{$personTableName}_id");
$fullNameSql = DatabaseCompatibilityUtil::concat(array('person.firstname', '\' \'', 'person.lastname'));
$where = "{$fullNameSql} = '{$fullName}'";
return $modelClassName::getSubset($joinTablesAdapter, null, null, $where);
}
示例3: testConcat
public function testConcat()
{
$res = DatabaseCompatibilityUtil::concat(array('column1', 'column2'));
$this->assertEquals('concat(column1, column2)', $res);
}
示例4: addWherePartByClauseInformationForConcatedAttributes
/**
* Add a sql string to the where array base on the $operatorType, $value and $tableAliasAndColumnNames concated
* together. How the sql string is built depends on if the value is a string or not.
* @param string $operatorType
* @param mixed $value
* @param array $where
* @param integer $whereKey
* @param array $tableAliasAndColumnNames
*/
protected static function addWherePartByClauseInformationForConcatedAttributes($operatorType, $value, &$where, $whereKey, $tableAliasAndColumnNames)
{
assert('is_string($operatorType)');
assert('is_array($where)');
assert('is_int($whereKey)');
assert('is_array($tableAliasAndColumnNames) && count($tableAliasAndColumnNames) == 2');
$quote = DatabaseCompatibilityUtil::getQuote();
if (is_string($value) || is_array($value) && count($value) > 0 || $value !== null) {
$first = ModelJoinBuilder::makeColumnNameWithTableAlias($tableAliasAndColumnNames[0][0], $tableAliasAndColumnNames[0][1]);
$second = ModelJoinBuilder::makeColumnNameWithTableAlias($tableAliasAndColumnNames[1][0], $tableAliasAndColumnNames[1][1]);
$concatedSqlPart = DatabaseCompatibilityUtil::concat(array($first, '\' \'', $second));
$where[$whereKey] = "({$concatedSqlPart} " . DatabaseCompatibilityUtil::getOperatorAndValueWherePart($operatorType, $value) . ")";
}
}
示例5: getWherePartForPartialNameSearchByPartialName
protected static function getWherePartForPartialNameSearchByPartialName($partialName)
{
assert('is_string($partialName)');
$fullNameSql = DatabaseCompatibilityUtil::concat(array('person.firstname', '\' \'', 'person.lastname'));
return " (person.firstname like '{$partialName}%' or " . " person.lastname like '{$partialName}%' or " . " {$fullNameSql} like '{$partialName}%') ";
}
示例6: getWherePartForFullNameSearch
/**
* Gets where part for full name search
* @param string $fullName
* @return string
*/
protected static function getWherePartForFullNameSearch($fullName)
{
assert('is_string($fullName)');
static::sanitizeSearchTerm($fullName);
$fullNameSql = DatabaseCompatibilityUtil::concat(array('person.firstname', '\' \'', 'person.lastname'));
return "{$fullNameSql} = '{$fullName}'";
}