本文整理汇总了PHP中QQueryBuilder类的典型用法代码示例。如果您正苦于以下问题:PHP QQueryBuilder类的具体用法?PHP QQueryBuilder怎么用?PHP QQueryBuilder使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了QQueryBuilder类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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));
}
}
开发者ID:vaibhav-kaushal,项目名称:qc-framework,代码行数:13,代码来源:QPgQuery.class.php
示例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');
}
开发者ID:alcf,项目名称:chms,代码行数:22,代码来源:EmailMessageRouteGen.class.php
示例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');
}
开发者ID:alcf,项目名称:chms,代码行数:26,代码来源:SignupPaymentGen.class.php
示例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');
}
开发者ID:proxymoron,项目名称:tracmor,代码行数:24,代码来源:RoleEntityQtypeBuiltInAuthorizationGen.class.php
示例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');
}
开发者ID:qcodo,项目名称:qcodo-website,代码行数:21,代码来源:IssueFieldOptionGen.class.php
示例6: __construct
public function __construct(QQueryBuilder $objBuilder)
{
parent::__construct($objBuilder->objDatabase, $objBuilder->strRootTableName);
$this->objParentBuilder = $objBuilder;
$this->strColumnAliasArray =& $objBuilder->strColumnAliasArray;
$this->strTableAliasArray =& $objBuilder->strTableAliasArray;
}
开发者ID:qcodo,项目名称:qcodo,代码行数:7,代码来源:QQuery.class.php
示例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');
}
}
开发者ID:hiptc,项目名称:dle2wordpress,代码行数:24,代码来源:DleMailLogGen.class.php
示例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');
}
开发者ID:proxymoron,项目名称:tracmor,代码行数:22,代码来源:RoleGen.class.php
示例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');
}
开发者ID:alcf,项目名称:chms,代码行数:27,代码来源:SignupEntryGen.class.php
示例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`');
}
开发者ID:heshuai64,项目名称:einv2,代码行数:32,代码来源:ShipmentGen.class.php
示例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');
}
}
开发者ID:hiptc,项目名称:dle2wordpress,代码行数:28,代码来源:DlePollGen.class.php
示例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');
}
开发者ID:alcf,项目名称:chms,代码行数:22,代码来源:CommunicationListGen.class.php
示例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');
}
开发者ID:alcf,项目名称:chms,代码行数:18,代码来源:CommentCategoryGen.class.php
示例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');
}
开发者ID:proxymoron,项目名称:tracmor,代码行数:23,代码来源:RoleTransactionTypeAuthorizationGen.class.php
示例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');
}
开发者ID:sarapsg,项目名称:prayuj,代码行数:35,代码来源:MyassetsGen.class.php
示例16: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this ShippingAccount
* @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 = '`shipping_account`';
$strAliasPrefix = '`';
}
$objBuilder->AddSelectItem($strTableName . '.`shipping_account_id` AS ' . $strAliasPrefix . 'shipping_account_id`');
$objBuilder->AddSelectItem($strTableName . '.`courier_id` AS ' . $strAliasPrefix . 'courier_id`');
$objBuilder->AddSelectItem($strTableName . '.`short_description` AS ' . $strAliasPrefix . 'short_description`');
$objBuilder->AddSelectItem($strTableName . '.`access_id` AS ' . $strAliasPrefix . 'access_id`');
$objBuilder->AddSelectItem($strTableName . '.`access_code` AS ' . $strAliasPrefix . 'access_code`');
$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`');
}
开发者ID:heshuai64,项目名称:einv2,代码行数:24,代码来源:ShippingAccountGen.class.php
示例17: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this DleFlood
* @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_flood';
$strAliasPrefix = '';
}
if ($objSelect) {
$objBuilder->AddSelectItem($strTableName, 'f_id', $strAliasPrefix . 'f_id');
$objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix);
} else {
$objBuilder->AddSelectItem($strTableName, 'f_id', $strAliasPrefix . 'f_id');
$objBuilder->AddSelectItem($strTableName, 'ip', $strAliasPrefix . 'ip');
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'flag', $strAliasPrefix . 'flag');
}
}
开发者ID:hiptc,项目名称:dle2wordpress,代码行数:24,代码来源:DleFloodGen.class.php
示例18: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this TransactionType
* @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 = '`transaction_type`';
$strAliasPrefix = '`';
}
$objBuilder->AddSelectItem($strTableName . '.`transaction_type_id` AS ' . $strAliasPrefix . 'transaction_type_id`');
$objBuilder->AddSelectItem($strTableName . '.`short_description` AS ' . $strAliasPrefix . 'short_description`');
$objBuilder->AddSelectItem($strTableName . '.`asset_flag` AS ' . $strAliasPrefix . 'asset_flag`');
$objBuilder->AddSelectItem($strTableName . '.`inventory_flag` AS ' . $strAliasPrefix . 'inventory_flag`');
}
开发者ID:heshuai64,项目名称:einv2,代码行数:19,代码来源:TransactionTypeGen.class.php
示例19: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this Articlemusictracks
* @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 = 'articlemusictracks';
$strAliasPrefix = '';
}
$objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
$objBuilder->AddSelectItem($strTableName, 'ReferenceId', $strAliasPrefix . 'ReferenceId');
$objBuilder->AddSelectItem($strTableName, 'DiscNumber', $strAliasPrefix . 'DiscNumber');
$objBuilder->AddSelectItem($strTableName, 'TrackNumber', $strAliasPrefix . 'TrackNumber');
$objBuilder->AddSelectItem($strTableName, 'TrackTitle', $strAliasPrefix . 'TrackTitle');
}
开发者ID:sarapsg,项目名称:prayuj,代码行数:20,代码来源:ArticlemusictracksGen.class.php
示例20: GetSelectFields
/**
* Updates a QQueryBuilder with the SELECT fields for this ClassVariable
* @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 = '`class_variable`';
$strAliasPrefix = '`';
}
$objBuilder->AddSelectItem($strTableName . '.`id` AS ' . $strAliasPrefix . 'id`');
$objBuilder->AddSelectItem($strTableName . '.`qcodo_class_id` AS ' . $strAliasPrefix . 'qcodo_class_id`');
$objBuilder->AddSelectItem($strTableName . '.`variable_group_id` AS ' . $strAliasPrefix . 'variable_group_id`');
$objBuilder->AddSelectItem($strTableName . '.`protection_type_id` AS ' . $strAliasPrefix . 'protection_type_id`');
$objBuilder->AddSelectItem($strTableName . '.`variable_id` AS ' . $strAliasPrefix . 'variable_id`');
$objBuilder->AddSelectItem($strTableName . '.`read_only_flag` AS ' . $strAliasPrefix . 'read_only_flag`');
$objBuilder->AddSelectItem($strTableName . '.`static_flag` AS ' . $strAliasPrefix . 'static_flag`');
}
开发者ID:qcodo,项目名称:qcodo-api,代码行数:22,代码来源:ClassVariableGen.class.php
注:本文中的QQueryBuilder类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论