本文整理汇总了PHP中QQueryBuilder类的典型用法代码示例。如果您正苦于以下问题:PHP QQueryBuilder类的具体用法?PHP QQueryBuilder怎么用?PHP QQueryBuilder使用的例子?那么, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了QQueryBuilder类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: UpdateQueryBuilder
/**
* @param QQueryBuilder $objBuilder
*/
public function UpdateQueryBuilder(QQueryBuilder $objBuilder)
{
$mixOperand = $this->mixOperand;
if ($mixOperand instanceof QQNamedValue) {
/** @var QQNamedValue $mixOperand */
$objBuilder->AddWhereItem($this->objQueryNode->GetColumnAlias($objBuilder) . ' @> ' . $mixOperand->Parameter());
} else {
$objBuilder->AddWhereItem($this->objQueryNode->GetColumnAlias($objBuilder) . ' @> ' . $objBuilder->Database->SqlVariable($mixOperand));
}
}
示例2: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this EmailMessageRoute
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'email_message_route';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'email_message_id', $strAliasPrefix . 'email_message_id');
$objBuilder->AddSelectItem($strTableName, 'group_id', $strAliasPrefix . 'group_id');
$objBuilder->AddSelectItem($strTableName, 'communication_list_id', $strAliasPrefix . 'communication_list_id');
$objBuilder->AddSelectItem($strTableName, 'login_id', $strAliasPrefix . 'login_id');
$objBuilder->AddSelectItem($strTableName, 'communication_list_entry_id', $strAliasPrefix . 'communication_list_entry_id');
$objBuilder->AddSelectItem($strTableName, 'person_id', $strAliasPrefix . 'person_id');
}
示例3: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this SignupPayment
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'signup_payment';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'signup_entry_id', $strAliasPrefix . 'signup_entry_id');
$objBuilder->AddSelectItem($strTableName, 'signup_payment_type_id', $strAliasPrefix . 'signup_payment_type_id');
$objBuilder->AddSelectItem($strTableName, 'transaction_date', $strAliasPrefix . 'transaction_date');
$objBuilder->AddSelectItem($strTableName, 'transaction_description', $strAliasPrefix . 'transaction_description');
$objBuilder->AddSelectItem($strTableName, 'amount', $strAliasPrefix . 'amount');
$objBuilder->AddSelectItem($strTableName, 'funding_account', $strAliasPrefix . 'funding_account');
$objBuilder->AddSelectItem($strTableName, 'donation_stewardship_fund_id', $strAliasPrefix . 'donation_stewardship_fund_id');
$objBuilder->AddSelectItem($strTableName, 'amount_donation', $strAliasPrefix . 'amount_donation');
$objBuilder->AddSelectItem($strTableName, 'amount_non_donation', $strAliasPrefix . 'amount_non_donation');
$objBuilder->AddSelectItem($strTableName, 'credit_card_payment_id', $strAliasPrefix . 'credit_card_payment_id');
}
示例4: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this RoleEntityQtypeBuiltInAuthorization
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'role_entity_qtype_built_in_authorization';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'role_entity_built_in_id', $strAliasPrefix . 'role_entity_built_in_id');
$objBuilder->AddSelectItem($strTableName, 'role_id', $strAliasPrefix . 'role_id');
$objBuilder->AddSelectItem($strTableName, 'entity_qtype_id', $strAliasPrefix . 'entity_qtype_id');
$objBuilder->AddSelectItem($strTableName, 'authorization_id', $strAliasPrefix . 'authorization_id');
$objBuilder->AddSelectItem($strTableName, 'authorized_flag', $strAliasPrefix . 'authorized_flag');
$objBuilder->AddSelectItem($strTableName, 'created_by', $strAliasPrefix . 'created_by');
$objBuilder->AddSelectItem($strTableName, 'creation_date', $strAliasPrefix . 'creation_date');
$objBuilder->AddSelectItem($strTableName, 'modified_by', $strAliasPrefix . 'modified_by');
$objBuilder->AddSelectItem($strTableName, 'modified_date', $strAliasPrefix . 'modified_date');
}
示例5: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this IssueFieldOption
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'issue_field_option';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'issue_field_id', $strAliasPrefix . 'issue_field_id');
$objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name');
$objBuilder->AddSelectItem($strTableName, 'token', $strAliasPrefix . 'token');
$objBuilder->AddSelectItem($strTableName, 'order_number', $strAliasPrefix . 'order_number');
$objBuilder->AddSelectItem($strTableName, 'active_flag', $strAliasPrefix . 'active_flag');
}
示例6: __construct
public function __construct(QQueryBuilder $objBuilder)
{
parent::__construct($objBuilder->objDatabase, $objBuilder->strRootTableName);
$this->objParentBuilder = $objBuilder;
$this->strColumnAliasArray =& $objBuilder->strColumnAliasArray;
$this->strTableAliasArray =& $objBuilder->strTableAliasArray;
}
示例7: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this DleMailLog
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'dle_mail_log';
$strAliasPrefix = '';
}
if ($objSelect) {
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix);
} else {
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id');
$objBuilder->AddSelectItem($strTableName, 'mail', $strAliasPrefix . 'mail');
$objBuilder->AddSelectItem($strTableName, 'hash', $strAliasPrefix . 'hash');
}
}
示例8: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this Role
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'role';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'role_id', $strAliasPrefix . 'role_id');
$objBuilder->AddSelectItem($strTableName, 'short_description', $strAliasPrefix . 'short_description');
$objBuilder->AddSelectItem($strTableName, 'long_description', $strAliasPrefix . 'long_description');
$objBuilder->AddSelectItem($strTableName, 'created_by', $strAliasPrefix . 'created_by');
$objBuilder->AddSelectItem($strTableName, 'creation_date', $strAliasPrefix . 'creation_date');
$objBuilder->AddSelectItem($strTableName, 'modified_by', $strAliasPrefix . 'modified_by');
$objBuilder->AddSelectItem($strTableName, 'modified_date', $strAliasPrefix . 'modified_date');
}
示例9: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this SignupEntry
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'signup_entry';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'signup_form_id', $strAliasPrefix . 'signup_form_id');
$objBuilder->AddSelectItem($strTableName, 'person_id', $strAliasPrefix . 'person_id');
$objBuilder->AddSelectItem($strTableName, 'signup_by_person_id', $strAliasPrefix . 'signup_by_person_id');
$objBuilder->AddSelectItem($strTableName, 'signup_entry_status_type_id', $strAliasPrefix . 'signup_entry_status_type_id');
$objBuilder->AddSelectItem($strTableName, 'date_created', $strAliasPrefix . 'date_created');
$objBuilder->AddSelectItem($strTableName, 'date_submitted', $strAliasPrefix . 'date_submitted');
$objBuilder->AddSelectItem($strTableName, 'amount_total', $strAliasPrefix . 'amount_total');
$objBuilder->AddSelectItem($strTableName, 'amount_paid', $strAliasPrefix . 'amount_paid');
$objBuilder->AddSelectItem($strTableName, 'amount_balance', $strAliasPrefix . 'amount_balance');
$objBuilder->AddSelectItem($strTableName, 'internal_notes', $strAliasPrefix . 'internal_notes');
$objBuilder->AddSelectItem($strTableName, 'communications_entry_id', $strAliasPrefix . 'communications_entry_id');
}
示例10: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this Shipment
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = '`' . $strPrefix . '`';
$strAliasPrefix = '`' . $strPrefix . '__';
} else {
$strTableName = '`shipment`';
$strAliasPrefix = '`';
}
$objBuilder->AddSelectItem($strTableName . '.`shipment_id` AS ' . $strAliasPrefix . 'shipment_id`');
$objBuilder->AddSelectItem($strTableName . '.`shipment_number` AS ' . $strAliasPrefix . 'shipment_number`');
$objBuilder->AddSelectItem($strTableName . '.`transaction_id` AS ' . $strAliasPrefix . 'transaction_id`');
$objBuilder->AddSelectItem($strTableName . '.`from_company_id` AS ' . $strAliasPrefix . 'from_company_id`');
$objBuilder->AddSelectItem($strTableName . '.`from_contact_id` AS ' . $strAliasPrefix . 'from_contact_id`');
$objBuilder->AddSelectItem($strTableName . '.`from_address_id` AS ' . $strAliasPrefix . 'from_address_id`');
$objBuilder->AddSelectItem($strTableName . '.`to_company_id` AS ' . $strAliasPrefix . 'to_company_id`');
$objBuilder->AddSelectItem($strTableName . '.`to_contact_id` AS ' . $strAliasPrefix . 'to_contact_id`');
$objBuilder->AddSelectItem($strTableName . '.`to_address_id` AS ' . $strAliasPrefix . 'to_address_id`');
$objBuilder->AddSelectItem($strTableName . '.`courier_id` AS ' . $strAliasPrefix . 'courier_id`');
$objBuilder->AddSelectItem($strTableName . '.`tracking_number` AS ' . $strAliasPrefix . 'tracking_number`');
$objBuilder->AddSelectItem($strTableName . '.`ship_date` AS ' . $strAliasPrefix . 'ship_date`');
$objBuilder->AddSelectItem($strTableName . '.`shipped_flag` AS ' . $strAliasPrefix . 'shipped_flag`');
$objBuilder->AddSelectItem($strTableName . '.`created_by` AS ' . $strAliasPrefix . 'created_by`');
$objBuilder->AddSelectItem($strTableName . '.`creation_date` AS ' . $strAliasPrefix . 'creation_date`');
$objBuilder->AddSelectItem($strTableName . '.`modified_by` AS ' . $strAliasPrefix . 'modified_by`');
$objBuilder->AddSelectItem($strTableName . '.`modified_date` AS ' . $strAliasPrefix . 'modified_date`');
}
示例11: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this DlePoll
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'dle_poll';
$strAliasPrefix = '';
}
if ($objSelect) {
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix);
} else {
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'news_id', $strAliasPrefix . 'news_id');
$objBuilder->AddSelectItem($strTableName, 'title', $strAliasPrefix . 'title');
$objBuilder->AddSelectItem($strTableName, 'frage', $strAliasPrefix . 'frage');
$objBuilder->AddSelectItem($strTableName, 'body', $strAliasPrefix . 'body');
$objBuilder->AddSelectItem($strTableName, 'votes', $strAliasPrefix . 'votes');
$objBuilder->AddSelectItem($strTableName, 'multiple', $strAliasPrefix . 'multiple');
$objBuilder->AddSelectItem($strTableName, 'answer', $strAliasPrefix . 'answer');
}
}
示例12: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this CommunicationList
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'communication_list';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'email_broadcast_type_id', $strAliasPrefix . 'email_broadcast_type_id');
$objBuilder->AddSelectItem($strTableName, 'ministry_id', $strAliasPrefix . 'ministry_id');
$objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name');
$objBuilder->AddSelectItem($strTableName, 'token', $strAliasPrefix . 'token');
$objBuilder->AddSelectItem($strTableName, 'description', $strAliasPrefix . 'description');
$objBuilder->AddSelectItem($strTableName, 'subscribable', $strAliasPrefix . 'subscribable');
}
示例13: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this CommentCategory
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'comment_category';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'order_number', $strAliasPrefix . 'order_number');
$objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name');
}
示例14: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this RoleTransactionTypeAuthorization
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'role_transaction_type_authorization';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'role_transaction_type_authorization_id', $strAliasPrefix . 'role_transaction_type_authorization_id');
$objBuilder->AddSelectItem($strTableName, 'role_id', $strAliasPrefix . 'role_id');
$objBuilder->AddSelectItem($strTableName, 'transaction_type_id', $strAliasPrefix . 'transaction_type_id');
$objBuilder->AddSelectItem($strTableName, 'authorization_level_id', $strAliasPrefix . 'authorization_level_id');
$objBuilder->AddSelectItem($strTableName, 'created_by', $strAliasPrefix . 'created_by');
$objBuilder->AddSelectItem($strTableName, 'creation_date', $strAliasPrefix . 'creation_date');
$objBuilder->AddSelectItem($strTableName, 'modified_by', $strAliasPrefix . 'modified_by');
$objBuilder->AddSelectItem($strTableName, 'modified_date', $strAliasPrefix . 'modified_date');
}
示例15: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this Myassets
* @param QQueryBuilder $objBuilder the Query Builder object to update
* @param string $strPrefix optional prefix to add to the SELECT fields
*/
public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null)
{
if ($strPrefix) {
$strTableName = $strPrefix;
$strAliasPrefix = $strPrefix . '__';
} else {
$strTableName = 'myassets';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'ASIN', $strAliasPrefix . 'ASIN');
$objBuilder->AddSelectItem($strTableName, 'DetailPageURL', $strAliasPrefix . 'DetailPageURL');
$objBuilder->AddSelectItem($strTableName, 'Title', $strAliasPrefix . 'Title');
$objBuilder->AddSelectItem($strTableName, 'ProductGroup', $strAliasPrefix . 'ProductGroup');
$objBuilder->AddSelectItem($strTableName, 'ImageURL', $strAliasPrefix . 'ImageURL');
$objBuilder->AddSelectItem($strTableName, 'Author', $strAliasPrefix . 'Author');
$objBuilder->AddSelectItem($strTableName, 'NumberOfPages', $strAliasPrefix . 'NumberOfPages');
$objBuilder->AddSelectItem($strTableName, 'Publisher', $strAliasPrefix . 'Publisher');
$objBuilder->AddSelectItem($strTableName, 'ISBN', $strAliasPrefix . 'ISBN');
$objBuilder->AddSelectItem($strTableName, 'Actor', $strAliasPrefix . 'Actor');
$objBuilder->AddSelectItem($strTableName, 'Director', $strAliasPrefix . 'Director');
$objBuilder->AddSelectItem($strTableName, 'RunningTime', $strAliasPrefix . 'RunningTime');
$objBuilder->AddSelectItem($strTableName, 'Artist', $strAliasPrefix . 'Artist');
$objBuilder->AddSelectItem($strTableName, 'Label', $strAliasPrefix . 'Label');
$objBuilder->AddSelectItem($strTableName, 'NumberOfDiscs', $strAliasPrefix . 'NumberOfDiscs');
$objBuilder->AddSelectItem($strTableName, 'Tracks', $strAliasPrefix . 'Tracks');
$objBuilder->AddSelectItem($strTableName, 'Language', $strAliasPrefix . 'Language');
$objBuilder->AddSelectItem($strTableName, 'Genre', $strAliasPrefix . 'Genre');
$objBuilder->AddSelectItem($strTableName, 'Owner', $strAliasPrefix . 'Owner');
}