Example #1
0
/**
 * Add a new user into a given project
 * 
 * @param Integer $group_id Project id
 * @param User    $user     User to add
 * 
 * @return Boolean
 */
function account_add_user_obj_to_group($group_id, User $user)
{
    //user was found but if it's a pending account adding
    //is not allowed
    if (!$user->isActive() && !$user->isRestricted()) {
        $GLOBALS['Response']->addFeedback('error', $GLOBALS['Language']->getText('include_account', 'account_notactive', $user->getUserName()));
        return false;
    }
    //if not already a member, add it
    $res_member = db_query("SELECT user_id FROM user_group WHERE user_id=" . $user->getId() . " AND group_id='" . db_ei($group_id) . "'");
    if (db_numrows($res_member) < 1) {
        //not already a member
        db_query("INSERT INTO user_group (user_id,group_id) VALUES (" . db_ei($user->getId()) . "," . db_ei($group_id) . ")");
        //if no unix account, give them a unix_uid
        if ($user->getUnixStatus() == 'N' || !$user->getUnixUid()) {
            $user->setUnixStatus('A');
            $um = UserManager::instance();
            $um->assignNextUnixUid($user);
            $um->updateDb($user);
        }
        // Raise an event
        $em = EventManager::instance();
        $em->processEvent('project_admin_add_user', array('group_id' => $group_id, 'user_id' => $user->getId(), 'user_unix_name' => $user->getUserName()));
        $GLOBALS['Response']->addFeedback('info', $GLOBALS['Language']->getText('include_account', 'user_added'));
        account_send_add_user_to_group_email($group_id, $user->getId());
        group_add_history('added_user', $user->getUserName(), $group_id, array($user->getUserName()));
        return true;
    } else {
        $GLOBALS['Response']->addFeedback('error', $GLOBALS['Language']->getText('include_account', 'user_already_member'));
    }
    return false;
}
Example #2
0
 /**
  * add identifier
  *
  * @author Matthias Pfefferle
  * @param User $pUser
  * @param AuthToken $pAuthToken
  * @return OnlineIdentity
  */
 public function addIdentifier($pUser, $pCode)
 {
     $lAccessToken = $this->getAccessToken($pCode);
     // get params
     $lParamsArray = array();
     // extract params
     parse_str($lAccessToken, $lParamsArray);
     $lJsonObject = json_decode(UrlUtils::sendGetRequest("https://graph.facebook.com/me?access_token=" . $lParamsArray['access_token'] . "&locale=en_US"));
     // facebook identifier
     $lIdentifier = "http://www.facebook.com/profile.php?id=" . $lJsonObject->id;
     // ask for online identity
     $lOnlineIdentity = OnlineIdentityTable::retrieveByAuthIdentifier($lIdentifier);
     // check if user already exists
     if ($lOnlineIdentity) {
         if ($lOnlineIdentity->getUserId() && $pUser->getId() == $lOnlineIdentity->getUserId()) {
             if (!$lOnlineIdentity->getActive()) {
                 $lOnlineIdentity->setActive(true);
             } else {
                 throw new sfException("online identity already added", 1);
             }
         } elseif ($lOnlineIdentity->getUserId() && $pUser->getId() != $lOnlineIdentity->getUserId()) {
             throw new sfException("online identity already added by someone else", 2);
         }
     } else {
         // check online identity
         $lOnlineIdentity = OnlineIdentityTable::addOnlineIdentity($lJsonObject->link, $lJsonObject->id, $this->aCommunityId);
     }
     // use api complete informations
     $this->completeOnlineIdentity($lOnlineIdentity, $lJsonObject, $pUser, $lIdentifier);
     // signup,add new
     AuthTokenTable::saveToken($pUser->getId(), $lOnlineIdentity->getId(), $lParamsArray['access_token'], null, true);
     // signup,add new
     return $lOnlineIdentity;
 }
 private function _makeOperation()
 {
     $this->user = new oldUser($this->userLogin, $this->userPass);
     $this->userId = $this->user->getId();
     $options = array('user_id' => $this->userId, 'chain_id' => 999, 'date' => date('Y-m-d', time() - 86400));
     // Правильные операции, на вчера
     CreateObjectHelper::makeOperation($options);
     CreateObjectHelper::makeOperation($options);
     CreateObjectHelper::makeOperation($options);
     // Операция не выполнена
     $data = $options;
     $data['accepted'] = 0;
     CreateObjectHelper::makeOperation($data);
     // Дата операции установлена на завтра
     $data = $options;
     $data['accepted'] = 0;
     $data['date'] = date('Y-m-d', time() + 86400);
     CreateObjectHelper::makeOperation($data);
     // Дата операции установлена на завтра, но она отмечена выполненной
     $data = $options;
     $data['accepted'] = 1;
     $data['date'] = date('Y-m-d', time() + 86400);
     CreateObjectHelper::makeOperation($data);
     // Удалённая операция
     $data = $options;
     $data['accepted'] = 0;
     $data['deleted_at'] = '2010-02-02 02:02:02';
     CreateObjectHelper::makeOperation($data);
     // Обычная операция, вне цепочки
     unset($options['deleted_at']);
     unset($options['chain_id']);
     CreateObjectHelper::makeOperation($options);
 }
 /**
  * add identifier
  *
  * @author Matthias Pfefferle
  * @param User $pUser
  * @param AuthToken $pAuthToken
  * @return OnlineIdentity
  */
 public function addIdentifier($pUser, $pOAuthToken)
 {
     $lAccessToken = $this->getAccessToken($pOAuthToken);
     // get params
     $lParams = $lAccessToken->params;
     $lParamsArray = array();
     // extract params
     parse_str($lParams, $lParamsArray);
     // twitter identifier
     $lIdentifier = "http://twitter.com/account/profile?user_id=" . $lParamsArray['user_id'];
     // ask for online identity
     $lOnlineIdentity = OnlineIdentityTable::retrieveByAuthIdentifier($lIdentifier);
     // check if user already exists
     if ($lOnlineIdentity) {
         if ($lOnlineIdentity->getUserId() && $pUser->getId() == $lOnlineIdentity->getUserId()) {
             if (!$lOnlineIdentity->getActive()) {
                 $lOnlineIdentity->setActive(true);
             } else {
                 throw new sfException("online identity already added", 1);
             }
         } elseif ($lOnlineIdentity->getUserId() && $pUser->getId() != $lOnlineIdentity->getUserId()) {
             throw new sfException("online identity already added by someone else", 2);
         }
     } else {
         // check online identity
         $lOnlineIdentity = OnlineIdentityTable::addOnlineIdentity("http://twitter.com/" . $lParamsArray['screen_name'], $lParamsArray['user_id'], $this->aCommunityId);
     }
     // get api informations
     $lJson = OAuthClient::get($this->getConsumer(), $lParamsArray['oauth_token'], $lParamsArray['oauth_token_secret'], "https://api.twitter.com/1.1/users/show.json?user_id=" . $lParamsArray['user_id']);
     $lJsonObject = json_decode($lJson);
     $this->completeOnlineIdentity($lOnlineIdentity, $lJsonObject, $pUser, $lIdentifier);
     AuthTokenTable::saveToken($pUser->getId(), $lOnlineIdentity->getId(), $lParamsArray['oauth_token'], $lParamsArray['oauth_token_secret'], true);
     return $lOnlineIdentity;
 }
 /**
  * Делаем основную работу
  * @param User $user
  * @return bool false в случае ошибки
  */
 public function execute(User $user)
 {
     $this->_csvDataSource = new File_CSV_DataSource($this->_csvFileName);
     if (!$this->_testStructure()) {
         return false;
     }
     foreach ($this->_hydrateArrayHash() as $k => $csvOperation) {
         $csvOperation['ReceiptDate'] = preg_replace("/^[\\s\\S]*?(\\d{2})\\.(\\d{2})\\.(\\d{4})[\\s\\S]*?\$/", "\$3-\$2-\$1", $csvOperation['ReceiptDate']);
         $csvOperation['Value'] = str_replace(',', '.', $csvOperation['Value']);
         $account = array('user_id' => $user->getId(), 'name' => sprintf("%s (%s)", $csvOperation['Account'], $csvOperation['Currency']), 'currency_id' => $this->_getCurrencyId($csvOperation['Currency']), 'type_id' => 1);
         $category = !$csvOperation['Category'] ? null : array('user_id' => $user->getId(), 'name' => $csvOperation['Category'], 'custom' => 1, 'type' => $csvOperation['TransactionType'] == 'Доход' ? 1 : -1);
         switch ($csvOperation['TransactionType']) {
             case 'Доход':
             case 'Расход':
                 $operation = array('user_id' => $user->getId(), 'date' => $csvOperation['ReceiptDate'], 'amount' => $csvOperation['Value'], 'comment' => $csvOperation['Comment'], 'type' => $csvOperation['TransactionType'] == 'Доход' ? Operation::TYPE_PROFIT : Operation::TYPE_EXPENSE, 'Account' => $this->_getRecordPointer('Account', $account['name'], $account), 'Category' => $this->_getRecordPointer('Category', $category['name'], $category));
                 break;
             case 'Перевод списание':
                 $operation = array_merge($operation, array('user_id' => $user->getId(), 'date' => $csvOperation['ReceiptDate'], 'amount' => $csvOperation['Value'], 'comment' => $csvOperation['Comment'], 'type' => Operation::TYPE_TRANSFER, 'Account' => $this->_getRecordPointer('Account', $account['name'], $account)));
                 break;
             case 'Перевод зачисление':
                 $operation['transfer_amount'] = $csvOperation['Value'];
                 $operation['TransferAccount'] = $this->_getRecordPointer('Account', $account['name'], $account);
                 break;
         }
         if (isset($operation['TransferAccount']) && isset($operation['Account']) || isset($operation['type']) && $operation['type'] != 2) {
             $this->_getRecordPointer('Operation', $k, $operation);
             $operation = array();
         }
     }
     $this->_setYmlData();
     return true;
 }
 /**
  * Привязываем счёт к счёту в банке
  *
  * @return void
  */
 function binding()
 {
     if ($this->_user->getId() == 0) {
         $errorMessage = 'Необходимо авторизироваться';
     }
     if (isset($_POST['account_id'])) {
         $account_id = (int) $_POST['account_id'];
         if ($account_id <= 0) {
             $errorMessage = 'Неверный идентификатор счёта';
         }
     } else {
         $errorMessage = 'Необходимо указать счёт';
     }
     if (!isset($errorMessage)) {
         $debetCard = new Account_DebetCard();
         if (!$debetCard->binding($account_id)) {
             $errorMessage = 'Ошибка при привязывании счёта';
         }
     }
     if (isset($errorMessage)) {
         $this->renderJsonError($errorMessage);
     } else {
         $this->renderJsonSuccess('Счёт успешно привязан');
     }
 }
Example #7
0
 /**
  * add identifier
  *
  * @author Matthias Pfefferle
  * @param User $pUser
  * @param AuthToken $pAuthToken
  * @return OnlineIdentity
  */
 public function addIdentifier($pUser, $pOAuthToken)
 {
     $lAccessToken = $this->getAccessToken($pOAuthToken);
     // get api informations
     $lJson = OAuthClient::get($this->getConsumer(), $lParamsArray['oauth_token'], $lParamsArray['oauth_token_secret'], "http://api.yigg.local/profiles/me");
     $lJsonObject = json_decode($lJson);
     // ask for online identity
     $lOnlineIdentity = OnlineIdentityTable::retrieveByOriginalId($lJsonObject->id, $this->aCommunityId);
     // check if user already exists
     if ($lOnlineIdentity) {
         if ($lOnlineIdentity->getUserId() && $pUser->getId() == $lOnlineIdentity->getUserId()) {
             if (!$lOnlineIdentity->getActive()) {
                 $lOnlineIdentity->setActive(true);
             } else {
                 throw new sfException("online identity already added", 1);
             }
         } elseif ($lOnlineIdentity->getUserId() && $pUser->getId() != $lOnlineIdentity->getUserId()) {
             throw new sfException("online identity already added by someone else", 2);
         }
     } else {
         // get auth identifier
         foreach ($lJsonObject->urls as $url) {
             if ($url['type'] == "profile") {
                 $lIdentifier = $url['value'];
             }
         }
         // check online identity
         $lOnlineIdentity = OnlineIdentityTable::addOnlineIdentity($lIdentifier, $lJsonObject->id, $this->aCommunityId);
     }
     $this->completeOnlineIdentity($lOnlineIdentity, $lJsonObject, $pUser, $lIdentifier);
     AuthTokenTable::saveToken($pUser->getId(), $lOnlineIdentity->getId(), $lParamsArray['oauth_token'], $lParamsArray['oauth_token_secret'], true);
     return $lOnlineIdentity;
 }
 /**
  * Авторизовать пользователя
  *
  * @param  User $user
  * @param  bool $remember
  * @return void
  */
 public function signIn(User $user, $remember = false)
 {
     $this->user = $user;
     $this->setAttribute('id', $user->getId(), 'user');
     $this->setAuthenticated(true);
     $this->clearCredentials();
     if ($remember) {
         $now = new DateTime();
         $expired = clone $now;
         $expired->modify("-" . $this->getExpiration() . " sec");
         // убить все старые кючи
         Doctrine::getTable('myAuthRememberKey')->removeOldKeys($expired)->execute();
         // убить все ключи этого пользователя
         Doctrine::getTable('myAuthRememberKey')->removeKeysByUserId($user->getId())->execute();
         // создать новый ключ
         $key = $this->generateRandomKey();
         // сохранить ключ
         $rk = new myAuthRememberKey();
         $rk->setRememberKey($key);
         $rk->setUser($user);
         $rk->setIpAddress($_SERVER['REMOTE_ADDR']);
         $rk->save();
         // отдать ключ в виде печенья
         sfContext::getInstance()->getResponse()->setCookie($this->getCookieName(), $key, time() + $this->getExpiration());
     }
 }
Example #9
0
 /**
  * Adds this new notification object to the backend storage.
  */
 protected function insert()
 {
     global $wgEchoBackend, $wgEchoNotifications;
     $row = array('notification_event' => $this->event->getId(), 'notification_user' => $this->user->getId(), 'notification_anon_ip' => $this->user->isAnon() ? $this->user->getName() : $this->user->getId(), 'notification_timestamp' => $this->timestamp, 'notification_read_timestamp' => $this->readTimestamp, 'notification_bundle_hash' => '', 'notification_bundle_display_hash' => '');
     // Get the bundle key for this event if web bundling is enabled
     $bundleKey = '';
     if (!empty($wgEchoNotifications[$this->event->getType()]['bundle']['web'])) {
         wfRunHooks('EchoGetBundleRules', array($this->event, &$bundleKey));
     }
     if ($bundleKey) {
         $hash = md5($bundleKey);
         $row['notification_bundle_hash'] = $hash;
         $lastStat = $wgEchoBackend->getLastBundleStat($this->user, $hash);
         // Use a new display hash if:
         // 1. there was no last bundle notification
         // 2. last bundle notification with the same hash was read
         if ($lastStat && !$lastStat->notification_read_timestamp) {
             $row['notification_bundle_display_hash'] = $lastStat->notification_bundle_display_hash;
         } else {
             $row['notification_bundle_display_hash'] = md5($bundleKey . '-display-hash-' . wfTimestampNow());
         }
     }
     $wgEchoBackend->createNotification($row);
     wfRunHooks('EchoCreateNotificationComplete', array($this));
 }
 public function hasPersonalAnnotations()
 {
     if (!isset($this->hasPersonalAnnotations)) {
         $this->hasPersonalAnnotations = !$this->viewerUser->isAnon() && $this->viewerUser->getId() == $this->ownerUser->getId() && AchAwardingService::canEarnBadges($this->viewerUser) && !$this->viewerUser->getGlobalPreference('hidepersonalachievements');
     }
     return $this->hasPersonalAnnotations;
 }
Example #11
0
 /**
  * @return bool|int|null
  */
 protected function saveContent()
 {
     global $wgLogRestrictions;
     $dbw = wfGetDB(DB_MASTER);
     $log_id = $dbw->nextSequenceValue('logging_log_id_seq');
     $this->timestamp = $now = wfTimestampNow();
     $data = array('log_id' => $log_id, 'log_type' => $this->type, 'log_action' => $this->action, 'log_timestamp' => $dbw->timestamp($now), 'log_user' => $this->doer->getId(), 'log_user_text' => $this->doer->getName(), 'log_namespace' => $this->target->getNamespace(), 'log_title' => $this->target->getDBkey(), 'log_page' => $this->target->getArticleId(), 'log_comment' => $this->comment, 'log_params' => $this->params);
     $dbw->insert('logging', $data, __METHOD__);
     $newId = !is_null($log_id) ? $log_id : $dbw->insertId();
     # And update recentchanges
     if ($this->updateRecentChanges) {
         $titleObj = SpecialPage::getTitleFor('Log', $this->type);
         RecentChange::notifyLog($now, $titleObj, $this->doer, $this->getRcComment(), '', $this->type, $this->action, $this->target, $this->comment, $this->params, $newId);
     } elseif ($this->sendToUDP) {
         # Don't send private logs to UDP
         if (isset($wgLogRestrictions[$this->type]) && $wgLogRestrictions[$this->type] != '*') {
             return true;
         }
         # Notify external application via UDP.
         # We send this to IRC but do not want to add it the RC table.
         $titleObj = SpecialPage::getTitleFor('Log', $this->type);
         $rc = RecentChange::newLogEntry($now, $titleObj, $this->doer, $this->getRcComment(), '', $this->type, $this->action, $this->target, $this->comment, $this->params, $newId);
         $rc->notifyRC2UDP();
     }
     return $newId;
 }
Example #12
0
 /**
  * add identifier
  *
  * @author Matthias Pfefferle
  * @param User $pUser
  * @param AuthToken $pAuthToken
  * @return OnlineIdentity
  */
 public function addIdentifier($pUser, $pCode)
 {
     $lAccessToken = $this->getAccessToken($pCode);
     // get params
     $lParamsArray = array();
     // extract params
     $lAccessToken = json_decode($lAccessToken, true);
     $lJsonObject = json_decode(UrlUtils::sendGetRequest("https://api.flattr.com/rest/v2/user", array("Authorization: Bearer " . $lAccessToken["access_token"])));
     // facebook identifier
     $lIdentifier = $lJsonObject->link;
     // ask for online identity
     $lOnlineIdentity = OnlineIdentityTable::retrieveByAuthIdentifier($lIdentifier);
     // check if user already exists
     if ($lOnlineIdentity) {
         if ($lOnlineIdentity->getUserId() && $pUser->getId() == $lOnlineIdentity->getUserId()) {
             if (!$lOnlineIdentity->getActive()) {
                 $lOnlineIdentity->setActive(true);
             } else {
                 throw new sfException("online identity already added", 1);
             }
         } elseif ($lOnlineIdentity->getUserId() && $pUser->getId() != $lOnlineIdentity->getUserId()) {
             throw new sfException("online identity already added by someone else", 2);
         }
     } else {
         // check online identity
         $lOnlineIdentity = OnlineIdentityTable::addOnlineIdentity($lJsonObject->link, $lJsonObject->username, $this->aCommunityId, $lIdentifier);
     }
     // use api complete informations
     $this->completeOnlineIdentity($lOnlineIdentity, $lJsonObject, $pUser, $lIdentifier);
     // signup,add new
     AuthTokenTable::saveToken($pUser->getId(), $lOnlineIdentity->getId(), $lAccessToken["access_token"], null, true);
     // signup,add new
     return $lOnlineIdentity;
 }
 /**
  * Updates the aa_lastlogin value for the specified user
  *
  * @param User $user the user that just logged in
  *
  * @return bool return True to continue processing hooks
  */
 static function updateLastLogin(User $user)
 {
     if (wfReadOnly()) {
         return true;
     }
     $now = time();
     $db = wfGetDB(DB_MASTER);
     $method = __METHOD__;
     $requestMethod = self::ACCESS_METHOD_DEFAULT;
     if (class_exists("MobileContext") && MobileContext::singleton()->shouldDisplayMobileView()) {
         $requestMethod = self::ACCESS_METHOD_MOBILE;
     }
     $db->onTransactionIdle(function () use($user, $requestMethod, $now, $db, $method) {
         if ($db->getType() === 'mysql') {
             // MySQL-specific implementation
             $db->query("INSERT INTO " . $db->tableName('accountaudit_login') . "( aa_user, aa_method, aa_lastlogin ) VALUES (" . $db->addQuotes($user->getId()) . ", " . $db->addQuotes($requestMethod) . ", " . $db->addQuotes($db->timestamp($now)) . ") ON DUPLICATE KEY UPDATE aa_lastlogin = " . $db->addQuotes($db->timestamp($now)), $method);
         } else {
             $db->update('accountaudit_login', array('aa_lastlogin' => $db->timestamp($now)), array('aa_user' => $user->getId(), 'aa_method' => $requestMethod), $method);
             if ($db->affectedRows() == 0) {
                 // no row existed for that user, method
                 $db->insert('accountaudit_login', array('aa_user' => $user->getId(), 'aa_method' => $requestMethod, 'aa_lastlogin' => $db->timestamp($now)), $method, array('IGNORE'));
             }
         }
     });
     // always return true, this should be a non-blocking hook on failure
     return true;
 }
Example #14
0
 public function addUserToHistory(User $user)
 {
     $ids = $this->getAttribute('user_history', array());
     if (!in_array($user->getId(), $ids)) {
         array_unshift($ids, $user->getId());
         $this->setAttribute('user_history', array_slice($ids, 0, 5));
     }
 }
 /**
  * Добавочное условие объединения: по ID пользователя
  *
  * @param   User    $user
  * @param   string  $joinAlias
  * @return  myOperationQuery
  */
 protected function addJoinAccountByUser(User $user, $joinAlias)
 {
     $rootAlias = $this->getRootAlias();
     $this->modifyJoinAccountCondition("{$joinAlias}.user_id = ?", $joinAlias);
     $this->_params['join'][] = $user->getId();
     $this->andWhere("{$rootAlias}.user_id = ?", $user->getId());
     return $this;
 }
 /**
  * Запрос для выборки зарезервированных средств
  *
  * @param  array  $accountIds массив ID счетов
  * @param  User   $user
  * @param  string $alias
  * @return Doctrine_Query
  */
 public function queryCountReserves(array $accountIds, User $user = null, $alias = 't')
 {
     $q = $this->createQuery($alias)->select("{$alias}.account_id, SUM({$alias}.amount) reserve")->innerJoin("{$alias}.Target tg")->andWhere("tg.done = 0")->andWhereIn("{$alias}.account_id", $accountIds)->groupBy("{$alias}.account_id");
     if ($user) {
         $q->andWhere("{$alias}.user_id = ? AND tg.user_id = ?", array((int) $user->getId(), (int) $user->getId()));
     }
     return $q;
 }
Example #17
0
 public function testSetId()
 {
     $oldid = $this->User->getId();
     $this->User->setId(666);
     if ($this->User->getId() != 666) {
         $this->fail();
     }
     $this->User->setId($oldid);
 }
Example #18
0
 /**
  * @covers User::setId
  * @covers User::getId
  */
 public function testSetId()
 {
     $id = 3;
     $actual = $this->user->getId();
     $this->assertNotEquals($id, $actual);
     $this->user->setId($id);
     $actual = $this->user->getId();
     $this->assertEquals($id, $actual);
 }
Example #19
0
 /**
  * Deletes all permissions for a user
  * @param User $user
  */
 public function deleteForUser($user)
 {
     try {
         $this->db->delete("users_permissions", $this->db->quoteInto("userId = ?", $user->getId()));
         Logger::info("dropped all permissions for user " . $user->getId());
     } catch (Exception $e) {
         throw $e;
     }
 }
 /**
  * @param $user
  * @return Category или NULL
  */
 public static function getDebtCategoryInstance(User $user)
 {
     static $debtCategoryByUserId = array();
     if (!array_key_exists($user->getId(), $debtCategoryByUserId)) {
         $category = Doctrine::getTable('Category')->findOneBySystemIdAndUserId(Category::DEBT_SYSTEM_CATEGORY_ID, $user->getId());
         $debtCategoryByUserId[$user->getId()] = $category !== false ? $category : null;
     }
     return $debtCategoryByUserId[$user->getId()];
 }
Example #21
0
 /**
  * Speichert den aktuellen Tipp in der Datenbank
  * @return bool true, wenn das Speichern erfolgreich war, false sonst
  */
 public function save()
 {
     $db = Database::getDbObject();
     $stmt = $db->prepare("INSERT INTO `tipps`(`uid`, `spiel_id`, `heim`, `auswaerts`)\n            VALUES(?, ?, ?, ?);");
     $stmt->bind_param('iiii', $this->user->getId(), $this->spiel->getId(), $this->heim, $this->auswaerts);
     if (!$stmt->execute()) {
         return false;
     }
     return true;
 }
 /**
  * Проверяем что из csv получился yaml
  */
 public function testExecuteProducesYaml()
 {
     $csvImport = new myImportCsvVkoshelke($this->_csvData);
     $success = $csvImport->execute($this->_user);
     $this->assertTrue($success, 'Импорт должен завершиться успешно');
     $yaml = $csvImport->getYmlData();
     $yamlParser = new sfYamlParser();
     $data = $yamlParser->parse($yaml);
     $this->assertEquals(array('user_id' => $this->_user->getId(), 'date' => '2010-06-08', 'amount' => '20000.00', 'comment' => 'Тане', 'type' => 0, 'Account' => 'Account_1', 'Category' => 'Category_1'), $data['Operation']['Operation_1']);
     $this->assertEquals(array('user_id' => $this->_user->getId(), 'date' => '2010-06-06', 'amount' => '100.00', 'comment' => '', 'type' => 2, 'Account' => 'Account_2', 'transfer_amount' => '300000.00', 'TransferAccount' => 'Account_1'), $data['Operation']['Operation_4']);
 }
Example #23
0
 public function validate($value)
 {
     $records = DB::getDataList(get_class($this->changedRecord), array('Email' => $value));
     foreach ($records as $record) {
         if ($record->getId() == $this->changedRecord->getId()) {
             continue;
         }
         return false;
     }
     return true;
 }
 public static function onDeleteAccount(User &$oldUser)
 {
     $dbw = wfGetDB(DB_MASTER);
     // Use master to be up to date
     $row = $dbw->selectRow('accountaudit_login', array('aa_user'), array('aa_user' => $oldUser->getId()));
     if ($row !== false) {
         $dbw->onTransactionIdle(function () use($dbw, $oldUser) {
             $dbw->delete('accountaudit_login', array('aa_user' => $oldUser->getId()), 'AccountAuditHooks::onDeleteAccount');
         });
     }
 }
 /**
  * Get params for a user
  * @param User $user
  * @return array|null
  */
 public static function getParams(User $user)
 {
     if ($user->getId()) {
         if (!isset($user->fr_user_params)) {
             // process cache...
             $user->fr_user_params = self::getUserParams($user->getId());
         }
         return $user->fr_user_params;
     }
     return null;
 }
Example #26
0
    private function getUsers()
    {
        $users = User::select("1");
        foreach ($users as $u) {
            $user = new User($u);
            $this->users .= <<<FFF
                <tr id="{$user->getId()}user">
                    <td class="name">{$user->getUsername()}</td>
                    <td><span class="delUser" userid="{$user->getId()}">Trinti</span></td>
                </tr>
FFF;
        }
    }
Example #27
0
 public function __construct()
 {
     $this->view = ViewManager::getInstance();
     // get the current user and put it to the view
     if (session_status() == PHP_SESSION_NONE) {
         session_start();
     }
     if (isset($_SESSION["currentuser"])) {
         $this->currentUser = new User($_SESSION["currentuser"]);
         //add current user to the view, since some views require it
         $this->view->setVariable("currentusername", $this->currentUser->getId());
     }
 }
 /**
  * Return recent activities for selected user of all active projects
  *
  * @param User $user
  * @param integer $count
  * @return array
  */
 function paginateActivitiesByUser($user, $page = 1, $per_page = 30)
 {
     $objects_table = TABLE_PREFIX . 'project_objects';
     $logs_table = TABLE_PREFIX . 'activity_logs';
     $total_activities = array_var(db_execute_one("SELECT COUNT({$logs_table}.id) AS 'row_count' FROM {$logs_table}, {$objects_table} WHERE {$logs_table}.object_id = {$objects_table}.id AND {$logs_table}.created_by_id = ?", $user->getId()), 'row_count');
     if ($total_activities) {
         $offset = ($page - 1) * $per_page;
         $activities = ActivityLogs::findBySQL("SELECT {$logs_table}.* FROM {$logs_table}, {$objects_table} WHERE {$logs_table}.object_id = {$objects_table}.id AND {$logs_table}.created_by_id = ? ORDER BY {$logs_table}.created_on DESC LIMIT {$offset}, {$per_page}", array($user->getId()));
     } else {
         $activities = null;
     }
     // if
     return array($activities, new Pager($page, $total_activities, $per_page));
 }
Example #29
0
 public function executeRegister()
 {
     //If the user is logged in, don't let them register
     if ($this->getUser()->isAuthenticated()) {
         $this->error = 'You are already logged in. You can not register again.';
         return sfView::ERROR;
     }
     if (!$this->hasRequestParameter('name') || !$this->hasRequestParameter('email') || !$this->hasRequestParameter('password')) {
         $this->error = 'Invalid Request.';
         return sfView::ERROR;
     }
     $this->requestedUserType = '1';
     //Create and populate the User object
     $user = new User();
     $userName = str_replace(' ', '', strtolower($this->getRequestParameter('name')));
     $user->setName($this->getRequestParameter('name'));
     $user->setEmail($this->getRequestParameter('email'));
     $user->setPassword($this->getRequestParameter('password'));
     $_SESSION['question'] = $this->getRequestParameter('question');
     //$user->setPoints('10.11');
     $user->setTypeUnconfirmed($this->requestedUserType);
     /* Username Duplication Check */
     $unamequery = mysql_query("select * from user where username='" . $userName . "'");
     $unamecount = mysql_num_rows($unamequery);
     $dupval = 2;
     duplicationCheck:
     if ($unamecount >= 1) {
         $newUsername = $userName . $dupval;
         $unamequery = mysql_query("select * from user where username='" . $newUsername . "'");
         $unamecount = mysql_num_rows($unamequery);
         if ($unamecount >= 1) {
             $dupval++;
             goto duplicationCheck;
         } else {
             $userName = $newUsername;
         }
     }
     $user->setUsername($userName);
     //Try to save the User... throw an exception if something messes up
     if (!$user->save()) {
         throw new PropelException('User creation failed');
     }
     mysql_query("insert into expert_category(user_id,category_id) values('" . $user->getId() . "','1')") or die(mysql_error());
     mysql_query("insert into user_score(user_id,score) values('" . $user->getId() . "','1')") or die(mysql_error());
     $this->sendConfirmationEmail($user, $_SESSION['question']);
     $this->user = $user;
     $this->forward('quickreg', 'confirmationcode');
     //$this->redirect(sfConfig::get('app_rayku_url')."/quickreg/confirmationcodesent");
 }
 /**
  * Наполняет список операций из БД за период
  * @param DateTime $startDate
  * @param DateTime $endDate
  * @return void
  */
 public function fill()
 {
     $alias = 'op';
     $query = Doctrine::getTable('Operation')->createQuery($alias)->innerJoin("{$alias}.Account")->leftJoin("{$alias}.TransferAccount")->leftJoin("{$alias}.Category")->andWhere("{$alias}.user_id = ? ", $this->_user->getId());
     if ($this->_periodStartDate) {
         $query = $query->andWhere("{$alias}.date >= ? ", $this->_periodStartDate->format('Y-m-d'));
     }
     if ($this->_periodEndDate) {
         $query = $query->andWhere("{$alias}.date <= ? ", $this->_periodEndDate->format('Y-m-d'));
     }
     if ($this->_acceptedOnly) {
         $query = $query->andWhere("{$alias}.accepted = 1");
     }
     $this->_operations = $query->execute(array())->getData();
 }