/** * @return Gpf_Db_Table_UserAttributes */ public static function getInstance() { if (self::$instance === null) { self::$instance = new self(); } return self::$instance; }
/** * @param String_type $attributeName * @param String $defaultValue * @return String */ private function getSettingWithDefaultValue($attributeName, $defaultValue) { try { return Gpf_Db_Table_UserAttributes::getSetting($attributeName, $this->user->getAccountUserId()); } catch (Gpf_DbEngine_NoRowException $e) { } return $defaultValue; }
private function updateThemeExistingAffiliates($themeId) { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Gpf_Db_Table_UserAttributes::getName(), 'ua'); $update->from->addInnerJoin(Pap_Db_Table_Users::getName(), 'pu', 'ua.'.Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID.'=pu.'.Pap_Db_Table_Users::ACCOUNTUSERID); $update->set->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, $themeId); $update->where->add('ua.'.Gpf_Db_Table_UserAttributes::NAME, '=', Gpf_Auth_User::THEME_ATTRIBUTE_NAME); $update->where->add('pu.'.Pap_Db_Table_Users::TYPE, '=', Pap_Application::ROLETYPE_AFFILIATE); $update->update(); }
/** * @service affiliate_email_notification write * @param $fields */ public function save(Gpf_Rpc_Params $params) { $form = new Gpf_Rpc_Form($params); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_on_new_sale", $this->getFieldValue($form, "aff_notification_on_new_sale"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_on_change_comm_status", $this->getFieldValue($form, "aff_notification_on_change_comm_status"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_on_subaff_signup", $this->getFieldValue($form, "aff_notification_on_subaff_signup"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_on_subaff_sale", $this->getFieldValue($form, "aff_notification_on_subaff_sale"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_on_direct_link_enabled", $this->getFieldValue($form, "aff_notification_on_direct_link_enabled"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_daily_report", $this->getFieldValue($form, "aff_notification_daily_report"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_weekly_report", $this->getFieldValue($form, "aff_notification_weekly_report"), Gpf_Session::getAuthUser()->getAccountUserId()); Gpf_Db_Table_UserAttributes::setSetting("aff_notification_monthly_report", $this->getFieldValue($form, "aff_notification_monthly_report"), Gpf_Session::getAuthUser()->getAccountUserId()); $form->setInfoMessage($this->_("Email notifications saved")); return $form; }
/** * returns recordset of given attribute values for given array of users * * @param unknown_type $settingsNames * @param unknown_type $accountUserIds */ public static function getSettingsForGroupOfUsers($settingsNames, $accountUserIds) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID, "accountuserid"); $select->select->add(Gpf_Db_Table_UserAttributes::NAME, "name"); $select->select->add(Gpf_Db_Table_UserAttributes::VALUE, "value"); $select->from->add(Gpf_Db_Table_UserAttributes::getName()); $select->where->add(Gpf_Db_Table_UserAttributes::NAME, "IN", $settingsNames); $select->where->add(Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID, "IN", $accountUserIds); $recordSet = $select->getAllRows(); $results = array(); foreach ($recordSet as $record) { $results[$record->get('accountuserid')][$record->get('name')] = $record->get('value'); } return $results; }
protected function modifySelect(Gpf_SqlBuilder_SelectBuilder $selectBuilder) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('accountUsers.'.Gpf_Db_Table_Users::ID, '=', 'ua.'.Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID, 'AND', false); $condition->add('ua.'.Gpf_Db_Table_UserAttributes::NAME, '=', 'apply_vat_invoicing'); $selectBuilder->from->addLeftJoin(Gpf_Db_Table_UserAttributes::getName(), 'ua', $condition->toString()); if ($this->getVat() == Gpf::NO) { $condition = new Gpf_SqlBuilder_CompoundWhereCondition(); $condition->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', Gpf::NO, 'OR'); $condition->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', null, 'OR'); $selectBuilder->where->addCondition($condition); return; } $selectBuilder->where->add('ua.'.Gpf_Db_Table_UserAttributes::VALUE, '=', Gpf::YES); }
/** * @service affiliate_email_notification read * @param $fields */ public function load(Gpf_Rpc_Params $params) { $form = new Gpf_Rpc_Form($params); $this->attribute = Gpf_Db_Table_UserAttributes::getInstance(); $this->attribute->loadAttributes(Gpf_Session::getAuthUser()->getAccountUserId()); $data = new Gpf_Db_UserAttribute(); $data->setAccountUserId(Gpf_Session::getAuthUser()->getUserId()); $data->setName('RecipientsList'); try { $data->loadFromData(array(Gpf_Db_Table_UserAttributes::ACCOUNT_USER_ID,Gpf_Db_Table_UserAttributes::NAME)); $form->setField("recipients",$data->getValue()); } catch(Gpf_DbEngine_NoRowException $e) { $form->setField("recipients",""); } $form->setField('affEmail',Gpf_Session::getAuthUser()->getUsername()); return $form; }
private function loadPayoutSettings(Gpf_Rpc_Form $form) { $form->setField(Pap_Settings::SUPPORT_VAT_SETTING_NAME, Gpf_Settings::get(Pap_Settings::SUPPORT_VAT_SETTING_NAME)); $form->setField("applyVatInvoicing", $this->attribute->getAttributeWithDefaultValue("apply_vat_invoicing", "")); $defaultVatPercentage = Gpf_Settings::get(Pap_Settings::VAT_PERCENTAGE_SETTING_NAME); $vatPercentage = $this->attribute->getAttributeWithDefaultValue(Pap_Settings::VAT_PERCENTAGE_SETTING_NAME, ""); if($vatPercentage == '' || $vatPercentage == 0) { $vatPercentage = $defaultVatPercentage; } $form->setField("vatPercentage", $vatPercentage); $form->setField("vatNumber", $this->attribute->getAttributeWithDefaultValue("vat_number", "")); $form->setField("amountOfRegCapital", $this->attribute->getAttributeWithDefaultValue("amount_of_reg_capital", "")); $form->setField("regNumber", $this->attribute->getAttributeWithDefaultValue("reg_number", "")); $form->setField("currency", $this->attribute->getAttributeWithDefaultValue("currency_id", "")); $form->setField("minimumPayoutOptions", Gpf_Settings::get(Pap_Settings::PAYOUTS_PAYOUT_OPTIONS_SETTING_NAME)); $form->setField("minimumpayout", $this->getAffiliate()->getMinimumPayout()); return $form; }
/** * Get recordset of all selected wallpaper * * @param Gpf_Rpc_Params $params * @return Gpf_Data_RecordSet */ public function loadSelectedWallpaperNoRpc() { $response = new Gpf_Data_RecordSet(); $response->addColumn(self::WALLPAPER_TYPE); $response->addColumn(self::WALLPAPER_POSITION); $response->addColumn(self::BACKGROUND_COLOR); $response->addColumn("fileId"); $response->addColumn("url"); $record = $response->createRecord(); try { Gpf_Db_Table_UserAttributes::getInstance()->loadAttributes(Gpf_Session::getAuthUser()->getAccountUserId()); $wallpaperType = Gpf_Db_Table_UserAttributes::getInstance()->getAttributeWithDefaultValue(self::WALLPAPER_TYPE, self::TYPE_THEME); $theme = new Gpf_Desktop_Theme(); $wallpaperId = Gpf_Db_Table_UserAttributes::getInstance()->getAttributeWithDefaultValue(self::WALLPAPER, $theme->getDefaultWallpaper()); $position = Gpf_Db_Table_UserAttributes::getInstance()->getAttributeWithDefaultValue(self::WALLPAPER_POSITION, $theme->getDefaultWallpaperPosition()); $color = Gpf_Db_Table_UserAttributes::getInstance()->getAttributeWithDefaultValue(self::BACKGROUND_COLOR, $theme->getDefaultBackgroundColor()); $record->set(self::WALLPAPER_POSITION, $position); $record->set(self::BACKGROUND_COLOR, $color); $record->set(self::WALLPAPER_TYPE, $wallpaperType); if ($wallpaperType == self::TYPE_THEME) { $record->set("url", Gpf_Paths::getInstance()->getResourceUrl($wallpaperId, Gpf_Paths::IMAGE_DIR . Gpf_Paths::WALLPAPER_DIR)); } else { if ($wallpaperType == self::TYPE_CUSTOM) { $wallpaper = new Gpf_Db_Wallpaper(); $wallpaper->setPrimaryKeyValue($wallpaperId); $wallpaper->load(); $record->set("fileId", $wallpaper->getFileId()); $record->set("url", $wallpaper->getUrl()); } } } catch (Gpf_Exception $e) { $theme = new Gpf_Desktop_Theme(); $record->set(self::WALLPAPER_POSITION, "S"); $record->set(self::BACKGROUND_COLOR, "#000000"); $record->set(self::WALLPAPER_TYPE, self::TYPE_NONE); $record->set("fileId", null); $record->set("url", ""); } $response->addRecord($record); return $response; }
/** * @param String $affAttribute * @param String $changeableByAffSettingName * @param String $defaultValueSettingName * @return boolean */ private function hasNotifyEnabled($affAttribute, $changeableByAffSettingName, $defaultValueSettingName) { if ($this->accountSettings->get($changeableByAffSettingName) == Gpf::YES) { $isNotify = Gpf_Db_Table_UserAttributes::getInstance()->getAttributeWithDefaultValue($affAttribute, $this->accountSettings->get($defaultValueSettingName)); } else { $isNotify = $this->accountSettings->get($defaultValueSettingName); } return $isNotify === Gpf::YES; }
protected function loadAuthData(Gpf_Data_Record $data) { $this->username = $data->get("username"); $this->accountUserId = $data->get("accountuserid"); $this->authtoken = $data->get("authtoken"); $this->accountid = $data->get("accountid"); $this->roletypeid = $data->get("roletypeid"); $this->roleid = $data->get('roleid'); $this->authId = $data->get('authid'); $this->firstname = $data->get('firstname'); $this->lastname = $data->get('lastname'); $this->ip = $data->get('ip'); $attributes = Gpf_Db_Table_UserAttributes::getInstance(); $attributes->loadAttributes($this->accountUserId); $this->setLanguage($attributes->getAttributeWithDefaultValue(self::LANGUAGE_ATTRIBUTE_NAME, Gpf_Lang_Dictionary::getDefaultLanguage())); }
private function deleteAffiliates() { Pap3Compatibility_Migration_OutputWriter::logOnce(" Deleting affiliates ....."); // pap users $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Pap_Db_Table_Users::getName()); $sql->where->add('rtype', '=', 'A'); $sql->execute(); // g_users $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Pap_Db_Table_Users::ACCOUNTUSERID); $inSelect->from->add(Pap_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_Users::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_authusers $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::AUTHID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_AuthUsers::getName()); $sql->where->add('authid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_userattributes $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::ID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_UserAttributes::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_gadgets $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::ID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_Gadgets::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); Pap3Compatibility_Migration_OutputWriter::log("DONE<br/>"); }
protected function setQuickLaunchSetting($setting) { Gpf_Db_Table_UserAttributes::setSetting('quickLaunchSetting', $setting, $this->getAccountUserId()); }
protected function loadAttributes($accountUserId) { $attribute = Gpf_Db_Table_UserAttributes::getInstance(); $attribute->loadAttributes($accountUserId); return $attribute; }
/** * @return Gpf_Db_Table_UserAttributes */ protected function getUserAttributes() { $userAttributes = Gpf_Db_Table_UserAttributes::getInstance(); $userAttributes->loadAttributes($this->user->getAccountUserId()); return $userAttributes; }
protected function setDefaultLanguage() { Gpf_Db_Table_UserAttributes::setSetting(Gpf_Auth_User::LANGUAGE_ATTRIBUTE_NAME, Pap_Branding::DEFAULT_LANGUAGE_CODE, $this->getAccountUserId()); }
private function isNotify(Pap_Common_User $user, $defaultSetting, $enabledSetting, $settingName, $transactionStatus = null, $transactionStatusSettingName = null) { $isNotify = $this->accountSettings->get($defaultSetting); try { if ($this->accountSettings->get($enabledSetting) == Gpf::YES) { $isNotify = Gpf_Db_Table_UserAttributes::getSetting($settingName, $user->getAccountUserId()); } } catch(Gpf_Exception $e) { } if ($transactionStatus == null) { return $isNotify; } if (strstr($this->accountSettings->get($transactionStatusSettingName), $transactionStatus) === false) { return Gpf::NO; } return $isNotify; }
public function isOverwriteEnabled(Pap_Common_Campaign $campaignObject = null, Pap_Common_User $userObject = null) { if ($userObject != null) { try { switch (Gpf_Db_Table_UserAttributes::getSetting(Pap_Settings::OVERWRITE_COOKIE, $userObject->getAccountUserId())) { case GPF::YES: return true; case GPF::NO: return false; default: break; } } catch (Gpf_Exception $e) { } } $campaignOverwrite = 'D'; if($campaignObject != null) { $campaignOverwrite = $campaignObject->getOverwriteCookie(); } switch ($campaignOverwrite) { case GPF::YES: return true; case GPF::NO: return false; default: return $this->isGeneralOverwriteAllowed(); } }
protected function sendNewSubAffSignupMail(Pap_Common_User $parentUser, Pap_Common_User $newUser) { $attribute = Gpf_Db_Table_UserAttributes::getInstance(); $attribute->loadAttributes($parentUser->getAccountUserId()); if (Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_SUBAFF_SIGNUP_ENABLED_SETTING_NAME) == Gpf::YES) { $isNotify = $attribute->getAttributeWithDefaultValue('aff_notification_on_subaff_signup', Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_SUBAFF_SIGNUP_DEFAULT_SETTING_NAME)); } else { $isNotify = Gpf_Settings::get(Pap_Settings::AFF_NOTIFICATION_ON_SUBAFF_SIGNUP_DEFAULT_SETTING_NAME); } if ($isNotify == Gpf::YES) { $signupMail = new Pap_Mail_OnSubAffiliateSignup(); $signupMail->setUser($newUser); $signupMail->addRecipient($parentUser->getEmail()); $signupMail->sendNow(); } }
public function getUserAttributeWithDefaultValue($attributeName, $defaultValue) { try { $value = Gpf_Db_Table_UserAttributes::getSetting($attributeName); } catch (Gpf_DbEngine_NoRowException $e) { $value = $defaultValue; Gpf_Db_Table_UserAttributes::setSetting($attributeName, $defaultValue); } return $value; }
private function isRegistrationEmailSent(Pap_Common_User $user) { try { if (Gpf::YES == Gpf_Db_Table_UserAttributes::getSetting(self::AUTO_REGISTERED_AFFILIATE_REGISTRATION_EMAIL_SENT, $user->getAccountUserId())) { return true; } } catch (Gpf_DbEngine_NoRowException $e) { return false; } return false; }