Inheritance: extends QBaseClass
 /**
  * @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));
     }
 }
Esempio n. 2
0
 /**
  * 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');
 }
Esempio n. 3
0
 /**
  * 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');
 }
 /**
  * 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');
 }
 /**
  * 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');
 }
Esempio n. 6
0
 public function __construct(QQueryBuilder $objBuilder)
 {
     parent::__construct($objBuilder->objDatabase, $objBuilder->strRootTableName);
     $this->objParentBuilder = $objBuilder;
     $this->strColumnAliasArray =& $objBuilder->strColumnAliasArray;
     $this->strTableAliasArray =& $objBuilder->strTableAliasArray;
 }
 /**
  * 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');
     }
 }
Esempio n. 8
0
 /**
  * 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');
 }
Esempio n. 9
0
 /**
  * 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');
 }
Esempio n. 10
0
 /**
  * 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`');
 }
Esempio n. 11
0
 /**
  * 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');
     }
 }
Esempio n. 12
0
 /**
  * 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');
 }
Esempio n. 13
0
 /**
  * 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');
 }
 /**
  * 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');
 }
Esempio n. 15
0
 /**
  * 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');
 }
Esempio n. 16
0
 /**
  * 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`');
 }
Esempio n. 17
0
 /**
  * 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');
     }
 }
Esempio n. 18
0
 /**
  * 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`');
 }
 /**
  * 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');
 }
Esempio n. 20
0
 /**
  * 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`');
 }
Esempio n. 21
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this Parameter
  * @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 = '`parameter`';
         $strAliasPrefix = '`';
     }
     $objBuilder->AddSelectItem($strTableName . '.`id` AS ' . $strAliasPrefix . 'id`');
     $objBuilder->AddSelectItem($strTableName . '.`operation_id` AS ' . $strAliasPrefix . 'operation_id`');
     $objBuilder->AddSelectItem($strTableName . '.`order_number` AS ' . $strAliasPrefix . 'order_number`');
     $objBuilder->AddSelectItem($strTableName . '.`variable_id` AS ' . $strAliasPrefix . 'variable_id`');
     $objBuilder->AddSelectItem($strTableName . '.`reference_flag` AS ' . $strAliasPrefix . 'reference_flag`');
 }
 /**
  * Updates a QQueryBuilder with the SELECT fields for this NarroSuggestionVote
  * @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 = 'narro_suggestion_vote';
         $strAliasPrefix = '';
     }
     if ($objSelect) {
         $objBuilder->AddSelectItem($strTableName, 'suggestion_id', $strAliasPrefix . 'suggestion_id');
         $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id');
         $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id');
         $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix);
     } else {
         $objBuilder->AddSelectItem($strTableName, 'suggestion_id', $strAliasPrefix . 'suggestion_id');
         $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id');
         $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id');
         $objBuilder->AddSelectItem($strTableName, 'vote_value', $strAliasPrefix . 'vote_value');
         $objBuilder->AddSelectItem($strTableName, 'created', $strAliasPrefix . 'created');
         $objBuilder->AddSelectItem($strTableName, 'modified', $strAliasPrefix . 'modified');
     }
 }
Esempio n. 23
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this Marriage
  * @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 = 'marriage';
         $strAliasPrefix = '';
     }
     $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
     $objBuilder->AddSelectItem($strTableName, 'linked_marriage_id', $strAliasPrefix . 'linked_marriage_id');
     $objBuilder->AddSelectItem($strTableName, 'person_id', $strAliasPrefix . 'person_id');
     $objBuilder->AddSelectItem($strTableName, 'married_to_person_id', $strAliasPrefix . 'married_to_person_id');
     $objBuilder->AddSelectItem($strTableName, 'marriage_status_type_id', $strAliasPrefix . 'marriage_status_type_id');
     $objBuilder->AddSelectItem($strTableName, 'date_start', $strAliasPrefix . 'date_start');
     $objBuilder->AddSelectItem($strTableName, 'date_end', $strAliasPrefix . 'date_end');
 }
 /**
  * Updates a QQueryBuilder with the SELECT fields for this DatagridColumnPreference
  * @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 = '`datagrid_column_preference`';
         $strAliasPrefix = '`';
     }
     $objBuilder->AddSelectItem($strTableName . '.`datagrid_column_preference_id` AS ' . $strAliasPrefix . 'datagrid_column_preference_id`');
     $objBuilder->AddSelectItem($strTableName . '.`datagrid_id` AS ' . $strAliasPrefix . 'datagrid_id`');
     $objBuilder->AddSelectItem($strTableName . '.`column_name` AS ' . $strAliasPrefix . 'column_name`');
     $objBuilder->AddSelectItem($strTableName . '.`user_account_id` AS ' . $strAliasPrefix . 'user_account_id`');
     $objBuilder->AddSelectItem($strTableName . '.`display_flag` AS ' . $strAliasPrefix . 'display_flag`');
 }
Esempio n. 25
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this InventoryModel
  * @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 = '`inventory_model`';
         $strAliasPrefix = '`';
     }
     $objBuilder->AddSelectItem($strTableName . '.`inventory_model_id` AS ' . $strAliasPrefix . 'inventory_model_id`');
     $objBuilder->AddSelectItem($strTableName . '.`category_id` AS ' . $strAliasPrefix . 'category_id`');
     $objBuilder->AddSelectItem($strTableName . '.`manufacturer_id` AS ' . $strAliasPrefix . 'manufacturer_id`');
     $objBuilder->AddSelectItem($strTableName . '.`inventory_model_code` AS ' . $strAliasPrefix . 'inventory_model_code`');
     $objBuilder->AddSelectItem($strTableName . '.`short_description` AS ' . $strAliasPrefix . 'short_description`');
     $objBuilder->AddSelectItem($strTableName . '.`long_description` AS ' . $strAliasPrefix . 'long_description`');
     $objBuilder->AddSelectItem($strTableName . '.`image_path` AS ' . $strAliasPrefix . 'image_path`');
     $objBuilder->AddSelectItem($strTableName . '.`price` AS ' . $strAliasPrefix . 'price`');
     $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`');
 }
Esempio n. 26
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this Timezone
  * @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 = 'timezone';
         $strAliasPrefix = '';
     }
     $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
     $objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name');
 }
 /**
  * Updates a QQueryBuilder with the SELECT fields for this AssetCustomFieldHelper
  * @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 = 'asset_custom_field_helper';
         $strAliasPrefix = '';
     }
     $objBuilder->AddSelectItem($strTableName, 'asset_id', $strAliasPrefix . 'asset_id');
 }
 /**
  * Updates a QQueryBuilder with the SELECT fields for this StewardshipContributionAmount
  * @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 = 'stewardship_contribution_amount';
         $strAliasPrefix = '';
     }
     $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
     $objBuilder->AddSelectItem($strTableName, 'stewardship_contribution_id', $strAliasPrefix . 'stewardship_contribution_id');
     $objBuilder->AddSelectItem($strTableName, 'stewardship_fund_id', $strAliasPrefix . 'stewardship_fund_id');
     $objBuilder->AddSelectItem($strTableName, 'amount', $strAliasPrefix . 'amount');
 }
Esempio n. 29
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this Librarydetails
  * @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 = 'librarydetails';
         $strAliasPrefix = '';
     }
     $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id');
     $objBuilder->AddSelectItem($strTableName, 'LibraryName', $strAliasPrefix . 'LibraryName');
     $objBuilder->AddSelectItem($strTableName, 'SummaryOfLibrary', $strAliasPrefix . 'SummaryOfLibrary');
     $objBuilder->AddSelectItem($strTableName, 'Creator', $strAliasPrefix . 'Creator');
 }
Esempio n. 30
0
 /**
  * Updates a QQueryBuilder with the SELECT fields for this WpOptions
  * @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 = 'wp_options';
         $strAliasPrefix = '';
     }
     if ($objSelect) {
         $objBuilder->AddSelectItem($strTableName, 'option_id', $strAliasPrefix . 'option_id');
         $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix);
     } else {
         $objBuilder->AddSelectItem($strTableName, 'option_id', $strAliasPrefix . 'option_id');
         $objBuilder->AddSelectItem($strTableName, 'option_name', $strAliasPrefix . 'option_name');
         $objBuilder->AddSelectItem($strTableName, 'option_value', $strAliasPrefix . 'option_value');
         $objBuilder->AddSelectItem($strTableName, 'autoload', $strAliasPrefix . 'autoload');
     }
 }