DBStaticUser::db_user_list_to_celebrate() - Code Metrics - Inspection of "CODE-misc-41a7.59: Moved msg_sen_simple_message()..." - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — work-fleets ( e04805...964a94 )

by SuperNova.WS

created 2016-05-28 13:34 UTC

DBStaticUser::db_user_list_to_celebrate() B

↳ Parent: DBStaticUser

Complexity

Conditions	1
Paths	1

Size

Total Lines	35
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	6
Bugs	1	Features	0

Metric	Value
cc	1
eloc	18
c	6
b	1
f	0
nc	1
nop	1
dl	0
loc	35
rs	8.8571
ccs	0
cts	20
cp	0
crap	2

<?php

/**
 * Class DBStaticUser
 */
class DBStaticUser extends DBStaticRecord {

  public static $_table = 'users';
  public static $_idField = 'id';


  /**
   * @param int $playerId
   *
   * @return string[]
   */
  public static function getOnlineTime($playerId) {
    $row = static::getRecordById($playerId, array('username', 'onlinetime'));

    return !empty($row) ? $row : array();
  }

  // TODO - это вообще-то надо хранить в конфигурации
  /**
   * @return string
   */
  public static function getLastRegisteredUserName() {
    $result = static::fetchOne(
      static::buildSelectAll()
        ->fields('username')
        ->where(array('`user_as_ally` IS NULL'))
        ->orderBy(array('`id` DESC'))
    );

    return isset($result['username']) ? $result['username'] : '';
  }

  public static function db_player_list_export_blitz_info() {
    return static::execute(
      static::buildSelectAll()
        ->fields(array('id', 'username', 'total_rank', 'total_points', 'onlinetime',))
        ->where(array('`user_as_ally` IS NULL'))
        ->orderBy(array('`id`'))
    );
  }

  /**
   * @return array|bool|mysqli_result|null
   */
  public static function db_user_list_non_bots() {
//    $query = doquery("SELECT `id` FROM {{users}} WHERE `user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER . " FOR UPDATE;");

    $query = static::execute(
      static::buildSelectAll()
        ->fields('id')
        ->where(array(
          "`user_as_ally` IS NULL AND `user_bot` = " . USER_BOT_PLAYER . " FOR UPDATE;"
        ))
    );

    return $query;
  }

  public static function db_user_lock_with_target_owner_and_acs($user, $planet = array()) {
//    $query = "SELECT 1 FROM `{{users}}` WHERE `id` = :userId" .

//      (!empty($planet['id_owner']) ? ' OR `id` = :planetOwnerId' : '');

    $where = '`id` = :userId';
    if (!empty($planet['id_owner'])) {
      $where .= ' OR `id` = :planetOwnerId';
    }

    $query = static::buildSelectLock()
      ->where($where);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

    // TODO - FOR UPDATE
    return static::prepareExecute(
      $query,
      array(
        ':userId'        => idval($user['id']),
        ':planetOwnerId' => !empty($planet['id_owner']) ? idval($planet['id_owner']) : 0,
      )
    );
  }

  public static function db_user_count($online = false) {
//    $result = doquery('SELECT COUNT(id) AS user_count FROM {{users}} WHERE user_as_ally IS NULL' . ($online ? ' AND onlinetime > ' . (SN_TIME_NOW - classSupernova::$config->game_users_online_timeout) : ''), true);

//    return isset($result['user_count']) ? $result['user_count'] : 0;

//    $query =      'SELECT COUNT(`id`) AS `user_count` FROM `{{users}}` WHERE `user_as_ally` IS NULL' .

//      ($online ? ' AND `onlinetime` > :onlineTime' : '');

    $query = static::buildSelectCountId()
      ->where('`user_as_ally` IS NULL');
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
    if ($online) {
      $query->where('`onlinetime` > :onlineTime');
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
    }

    return static::prepareFetchValue($query, array(
      ':onlineTime' => SN_TIME_NOW - classSupernova::$config->game_users_online_timeout,
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
    ));
  }

  public static function db_user_list_admin_sorted($sort, $online = false) {
//    $query = "SELECT

//          u.*, COUNT(r.id) AS referral_count, SUM(r.dark_matter) AS referral_dm
//      FROM
//          {{users}} as u
//          LEFT JOIN
//              {{referrals}} as r on r.id_partner = u.id
//      WHERE " .
//      ($online ? "`onlinetime` >= :onlineTime" : 'user_as_ally IS NULL') .
//      " GROUP BY u.id
//        ORDER BY user_as_ally, {$sort} ASC";

    $query = static::buildSelect()
      ->fromAlias('u')
      ->field('u.*')
      ->fieldCount('r.id', 'referral_count')
      ->fieldSingleFunction('sum', 'r.dark_matter', 'referral_dm')
      ->join('LEFT JOIN {{referrals}} as r on r.id_partner = u.id')
      ->where($online ? "`onlinetime` >= :onlineTime" : 'user_as_ally IS NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->groupBy('u.id')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->orderBy("user_as_ally, {$sort} ASC");

    return static::prepareExecute(
      $query,
      array(
        ':onlineTime' => SN_TIME_NOW - classSupernova::$config->game_users_online_timeout,
<?php

/**
 * @property int $x
 * @property int $y
 * @property string $text
 */
class MyLabel
{
    private $properties;

    private $allowedProperties = array('x', 'y', 'text');

    public function __get($name)
    {
        if (isset($properties[$name]) && in_array($name, $this->allowedProperties)) {
            return $properties[$name];
        } else {
            return null;
        }
    }

    public function __set($name, $value)
    {
        if (in_array($name, $this->allowedProperties)) {
            $properties[$name] = $value;
        } else {
            throw new \LogicException("Property $name is not defined.");
        }
    }

}
      )
    );
  }

  public static function db_user_list_to_celebrate($config_user_birthday_range) {
//    $query = "SELECT

//        `id`, `username`, `user_birthday`, `user_birthday_celebrated`,
//        CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d')) AS `current_birthday`,
//        DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, '-%m-%d'))) AS `days_after_birthday`
//      FROM
//        `{{users}}`
//      WHERE
//        `user_birthday` IS NOT NULL
//        AND (`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)
//        AND `user_as_ally` IS NULL
//      HAVING
//        `days_after_birthday` >= 0 AND `days_after_birthday` < :birthdayRange FOR UPDATE";

    $query = static::buildSelect()
      ->field('id')
      ->field('username')
      ->field('user_birthday')
      ->field('user_birthday_celebrated')
      ->field(DbSqlLiteral::build()->literal('CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\')) AS `current_birthday`'))
      ->field(DbSqlLiteral::build()->literal('DATEDIFF(CURRENT_DATE, CONCAT(YEAR(CURRENT_DATE), DATE_FORMAT(`user_birthday`, \'-%m-%d\'))) AS `days_after_birthday`'))
      ->where('`user_birthday` IS NOT NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->where('(`user_birthday_celebrated` IS NULL OR DATE_ADD(`user_birthday_celebrated`, INTERVAL 1 YEAR) < CURRENT_DATE)')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->where('`user_as_ally` IS NULL')
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
      ->having('`days_after_birthday` >= 0')
      ->having('`days_after_birthday` < :birthdayRange')
      ->forUpdate();

    return static::prepareExecute(
      $query,
      array(
        ':birthdayRange' => $config_user_birthday_range,
      )
    );
  }

  public static function db_user_list_admin_multiaccounts() {
    $query = "SELECT COUNT(*) AS `ip_count`, `user_lastip`
      FROM `{{users}}`
      WHERE `user_as_ally` IS NULL
      GROUP BY `user_lastip`
      HAVING COUNT(*) > 1";

    return static::prepareExecute(
      $query
    );
  }

  public static function db_player_list_blitz_delete_players() {
    doquery("DELETE FROM `{{users}}` WHERE username LIKE 'Игрок%';");
  }

  public static function db_player_list_blitz_set_50k_dm() {
    doquery('UPDATE `{{users}}` SET dark_matter = 50000, dark_matter_total = 50000;');
  }


  /**
   * Выбирает записи игроков по списку их ID
   *
   * @param $user_id_list
   *
   * @return array
   */
  public static function db_user_list_by_id($user_id_list) {
    !is_array($user_id_list) ? $user_id_list = array($user_id_list) : false;

    $user_list = array();
    foreach ($user_id_list as $user_id_unsafe) {
      $user = DBStaticUser::db_user_by_id($user_id_unsafe);
      !empty($user) ? $user_list[$user_id_unsafe] = $user : false;
    }

    return $user_list;
  }


  public static function db_user_by_username($username_unsafe, $for_update = false, $fields = '*', $player = null, $like = false) {
    return classSupernova::db_get_user_by_username($username_unsafe, $for_update, $fields, $player, $like);
  }

  public static function db_user_list($user_filter = '', $for_update = false, $fields = '*') {

    return classSupernova::db_get_record_list(LOC_USER, $user_filter);
  }

  public static function db_user_set_by_id($user_id, $set) {
    return classSupernova::db_upd_record_by_id(LOC_USER, $user_id, $set);
  }

  public static function db_user_by_id($user_id_unsafe, $for_update = false, $fields = '*', $player = null) {
    return classSupernova::db_get_user_by_id($user_id_unsafe, $for_update, $fields, $player);
  }

  public static function db_user_list_set_mass_mail(&$owners_list, $set) {
    return classSupernova::db_upd_record_list(LOC_USER, !empty($owners_list) ? '`id` IN (' . implode(',', $owners_list) . ');' : '', $set);
  }

  public static function db_user_list_set_by_ally_and_rank($ally_id, $ally_rank_id, $set) {
    return classSupernova::db_upd_record_list(LOC_USER, "`ally_id`={$ally_id} AND `ally_rank_id` >= {$ally_rank_id}", $set);
  }

  public static function db_user_list_set_ally_deprecated_convert_ranks($ally_id, $i, $rank_id) {
    return classSupernova::db_upd_record_list(LOC_USER, "`ally_id` = {$ally_id} AND `ally_rank_id`={$rank_id}", "`ally_rank_id` = {$i}");
  }

//  public static function db_user_change_active_planet_to_capital($user_id, $captured_planet) {

//    return doquery("UPDATE {{users}} SET `current_planet` = `id_planet` WHERE `id` = {$user_id} AND `current_planet` = {$captured_planet};");
//  }

}


1			<?php
2
3			/**
4			* Class DBStaticUser
5			*/
6			class DBStaticUser extends DBStaticRecord {
7
8			public static $_table = 'users';
9			public static $_idField = 'id';
10
11
12			/**
13			* @param int $playerId
14			*
15			* @return string[]
16			*/
17			public static function getOnlineTime($playerId) {
18			$row = static::getRecordById($playerId, array('username', 'onlinetime'));
19
20			return !empty($row) ? $row : array();
21			}
22
23			// TODO - это вообще-то надо хранить в конфигурации
24			/**
25			* @return string
26			*/
27			public static function getLastRegisteredUserName() {
28			$result = static::fetchOne(
29			static::buildSelectAll()
30			->fields('username')
31			->where(array('`user_as_ally` IS NULL'))
32			->orderBy(array('`id` DESC'))
33			);
34
35			return isset($result['username']) ? $result['username'] : '';
36			}
37
38			public static function db_player_list_export_blitz_info() {
39			return static::execute(
40			static::buildSelectAll()

supernova-ws / SuperNova

Push — work-fleets ( e04805...964a94 )

DBStaticUser::db_user_list_to_celebrate() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like