/**
* @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));
}
}
/**
* 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');
}
/**
* 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');
}
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');
}
}
/**
* 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');
}
/**
* 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');
}
/**
* 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`');
}
/**
* 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');
}
}
/**
* 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');
}
/**
* 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');
}
/**
* 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');
}
/**
* 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`');
}
/**
* 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');
}
}
/**
* 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');
}
/**
* 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`');
}
/**
* 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');
}
}
/**
* 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`');
}
/**
* 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`');
}
/**
* 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');
}
/**
* 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');
}
/**
* 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');
}
}
