PHP Gpf_View_GridService::buildWhere示例

示例#1

文件： OnlineUsers.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     $this->_selectBuilder->where->add('l.logout', 'is', 'NULL', 'AND', false);
     $this->_selectBuilder->where->add(Gpf_Db_Table_LoginsHistory::LAST_REQUEST, '>', "('" . $this->createDatabase()->getDateString() . "' - INTERVAL 1800 SECOND)", 'AND', false);
     Gpf_Plugins_Engine::extensionPoint('Gpf_Report_OnlineUsers.buildWhere', $this->_selectBuilder->where);
 }

示例#2

文件： SentMailTemplatesGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     $this->_selectBuilder->where->add(Gpf_Db_Table_Accounts::ID, '=', Gpf_Application::getInstance()->getAccountId());
     $this->_selectBuilder->where->add(Gpf_Db_Table_MailTemplates::IS_CUSTOM, '=', Gpf::YES);
     $this->_selectBuilder->where->add(Gpf_Db_Table_MailTemplates::USERID, '=', Gpf_Session::getAuthUser()->getUserId());
 }

示例#3

文件： EditableCategoriesGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add('ni.' . Gpf_Db_Table_HierarchicalDataNodes::LFT, 'BETWEEN', 'p.'.Gpf_Db_Table_HierarchicalDataNodes::LFT.' AND p.'.Gpf_Db_Table_HierarchicalDataNodes::RGT, 'AND', false);
     $this->_selectBuilder->where->add('ni.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_CampaignsCategories_Main::CAMPAIGNS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     $this->_selectBuilder->where->add('p.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_CampaignsCategories_Main::CAMPAIGNS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     
     parent::buildWhere();
 }

示例#4

文件： AdminsGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     $this->_selectBuilder->where->add('u.deleted', '=', Gpf::NO);
     $this->_selectBuilder->where->add('u.rtype', '=', Pap_Application::ROLETYPE_MERCHANT);
     if ($this->accountId != null) {
         $this->_selectBuilder->where->add('a.accountid', '=', $this->accountId);
     }
     Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyWhere',
     new Gpf_Common_SelectBuilderCompoundRecord($this->_selectBuilder, new Gpf_Data_Record(array('columnPrefix'), array('a'))));
 }

示例#5

文件： CampaignInCategoriesGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add('ni.' . Gpf_Db_Table_HierarchicalDataNodes::LFT, 'BETWEEN', 'p.'.Gpf_Db_Table_HierarchicalDataNodes::LFT.' AND p.'.Gpf_Db_Table_HierarchicalDataNodes::RGT, 'AND', false);
     $this->_selectBuilder->where->add('ni.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_CampaignsCategories_Main::CAMPAIGNS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     $this->_selectBuilder->where->add('p.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_CampaignsCategories_Main::CAMPAIGNS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     $campaignFilter = $this->filters->getFilter("campaignid");
     if (count($campaignFilter) > 0) {
         $this->_selectBuilder->where->add('c.'.Pap_Db_Table_CampaignsInCategory::CAMPAIGNID,'=',$campaignFilter[0]->getValue());
     }
     parent::buildWhere();
 }

示例#6

文件： BannerInCategoriesGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add('ni.' . Gpf_Db_Table_HierarchicalDataNodes::LFT, 'BETWEEN', 'p.'.Gpf_Db_Table_HierarchicalDataNodes::LFT.' AND p.'.Gpf_Db_Table_HierarchicalDataNodes::RGT, 'AND', false);
     $this->_selectBuilder->where->add('ni.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_BannersCategories_Main::BANNERS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     $this->_selectBuilder->where->add('p.'.Gpf_Db_Table_HierarchicalDataNodes::TYPE,'=',Pap_Features_BannersCategories_Main::BANNERS_CATEGORIES_HIERARCHICAL_DATE_TYPE);
     $bannerFilter = $this->filters->getFilter('bannerid');
     if (count($bannerFilter) > 0) {
         $this->_selectBuilder->where->add('c.'.Pap_Db_Table_BannersInCategory::BANNERID,'=',$bannerFilter[0]->getValue());
     }
     parent::buildWhere();
 }

示例#7

文件： AffiliateGroupGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     $this->_selectBuilder->where->add('u.rtype', '=', Pap_Application::ROLETYPE_AFFILIATE);
     
     if ($this->_params->exists('commissiongroupid')) {
         $this->_selectBuilder->where->add('ucg.'.Pap_Db_Table_UserInCommissionGroup::COMMISSION_GROUP_ID, '=', $this->_params->get('commissiongroupid'));
     }
     if ($this->_params->exists('campaignid')) {
         $this->_selectBuilder->where->add('cg.'.Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $this->_params->get('campaignid'));
     }
 }

示例#8

文件： PayoutsHistoryGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     Gpf_Plugins_Engine::extensionPoint('AffiliateNetwork.modifyWhere',
     new Gpf_Common_SelectBuilderCompoundRecord($this->_selectBuilder, new Gpf_Data_Record(array('columnPrefix'), array('ph'))));
 }

示例#9

文件： RoleUsersGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     Gpf_Plugins_Engine::extensionPoint('Gpf_Role_RoleUsersGrid.buildWhere', new Gpf_Common_SelectBuilderCompoundRecord($this->_selectBuilder, new Gpf_Data_Record(array('columnPrefix'), array('u'))));
 }

示例#10

文件： RulesGrid.class.php 项目： AmineCherrai/rostanvo

	protected function buildWhere() {
		parent::buildWhere();
		$this->_selectBuilder->where->add('r.'.Pap_Db_Table_Rules::CAMPAIGN_ID, '=', $this->getCampaignId());
	}

示例#11

文件： DatabaseStatusGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     $this->_selectBuilder->where->add("TABLE_SCHEMA", "=", Gpf_Settings::get(Gpf_Settings_Gpf::DB_DATABASE));
 }

示例#12

文件： BroadcastsGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     $this->_selectBuilder->where->add(Gpf_Db_Table_Newsletters::ID, '=', $this->getParam(Gpf_Db_Table_Newsletters::ID));
 }

示例#13

文件： ChannelsGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add(Pap_Db_Table_Channels::USER_ID, '=', Gpf_Session::getAuthUser()->getPapUserId());
     parent::buildWhere();
 }

示例#14

文件： BannersGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add(Pap_Db_Table_BannersInRotators::PARENT_BANNER_ID, '=', $this->getBannerId());
     parent::buildWhere();
 }

示例#15

文件： CommissionGroupsGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     $this->_selectBuilder->where->add(Pap_Db_Table_CommissionGroups::IS_DEFAULT, '=', Gpf::NO);
     $this->_selectBuilder->where->add(Pap_Db_Table_CommissionGroups::CAMPAIGN_ID, '=', $this->getCampaignId());
     parent::buildWhere();
 }

示例#16

文件： LoginsHistory.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     Gpf_Plugins_Engine::extensionPoint('Gpf_Report_LoginsHistory.buildWhere', $this->_selectBuilder->where);
 }

示例#17

文件： PayoutOptionsGrid.class.php 项目： AmineCherrai/rostanvo

	protected function buildWhere() {
		parent::buildWhere();
		$this->_selectBuilder->where->add(Gpf_Db_Table_Accounts::ID, '=', Gpf_Application::getInstance()->getAccountId());
		$this->_selectBuilder->where->add(Gpf_Db_Table_FieldGroups::TYPE, '=', Pap_Common_Constants::FIELDGROUP_TYPE_PAYOUTOPTION);
	}

示例#18

文件： PendingTasksGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     $this->_selectBuilder->where->add(Gpf_Db_Table_Tasks::DATEFINISHED, '=', null);
 }

示例#19

文件： GadgetGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere()
 {
     parent::buildWhere();
     $this->_selectBuilder->where->add(Gpf_Db_Table_Gadgets::ACCOUNTUSERID, '=', Gpf_Session::getAuthUser()->getAccountUserId());
 }

示例#20

文件： FormFieldGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     $this->_selectBuilder->where->add(Gpf_Db_Table_FormFields::FORMID, '=', $this->getFormId());
 }

示例#21

文件： CouponsGrid.class.php 项目： AmineCherrai/rostanvo

 protected function buildWhere() {
     parent::buildWhere();
     $this->_selectBuilder->where->add('c.'.Pap_Db_Table_Coupons::BANNERID, '=', $this->getBannerID());
 }