当前位置: 首页>>代码示例>>PHP>>正文


PHP DatabaseCompatibilityUtil::concat方法代码示例

本文整理汇总了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");
 }
开发者ID:youprofit,项目名称:Zurmo,代码行数:16,代码来源:UserModelSearch.php

示例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);
 }
开发者ID:sandeep1027,项目名称:zurmo_,代码行数:12,代码来源:ZurmoModelSearch.php

示例3: testConcat

 public function testConcat()
 {
     $res = DatabaseCompatibilityUtil::concat(array('column1', 'column2'));
     $this->assertEquals('concat(column1, column2)', $res);
 }
开发者ID:youprofit,项目名称:Zurmo,代码行数:5,代码来源:DatabaseCompatibilityUtilTest.php

示例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) . ")";
     }
 }
开发者ID:RamaKavanan,项目名称:InitialVersion,代码行数:23,代码来源:ModelDataProviderUtil.php

示例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}%') ";
 }
开发者ID:sandeep1027,项目名称:zurmo_,代码行数:6,代码来源:ContactSearch.php

示例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}'";
 }
开发者ID:maruthisivaprasad,项目名称:zurmo,代码行数:12,代码来源:ContactSearch.php


注:本文中的DatabaseCompatibilityUtil::concat方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。