DBStaticPlanet::dbDeletePlanetsWithoutUsers() - Code Metrics - Inspection of "CODE-misc-43a15.12: Code refactoring" - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — trunk ( c0c172...91a948 )

by SuperNova.WS
created 2018-03-21 09:59 UTC
DBStaticPlanet::dbDeletePlanetsWithoutUsers() A

↳ Parent: DBStaticPlanet
Complexity

Conditions	1
Paths	1
Size

Total Lines	2
Code Lines	1
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	0
CRAP Score	2
Importance

Changes
Metric	Value
cc	1
eloc	1
c	0
b	0
f	0
nc	1
nop	0
dl	0
loc	2
ccs	0
cts	2
cp	0
crap	2
rs	10
<?php

class DBStaticPlanet {
namespace YourVendor;

class YourClass { }


  public static function db_planets_purge() {
    doquery("DELETE FROM {{planets}} WHERE id_owner NOT IN (SELECT `id` FROM {{users}});");
  }


  /**
   * @param int    $planet_id
   * @param bool   $for_update
   * @param string $fields
   *
   * @return array|null
   */
  public static function db_planet_by_id($planet_id, $for_update = false, $fields = '*') {
  public static function db_planet_by_id($planet_id, $for_update = false, /** @scrutinizer ignore-unused */ $fields = '*') {
    $result = SN::db_get_record_by_id(LOC_PLANET, $planet_id);

    return empty($result) ? null : $result;
  }

  /**
   * @param        $galaxy
   * @param        $system
   * @param        $planet
   * @param        $planet_type
   * @param bool   $for_update
   * @param string $fields
   *
   * @return bool|mixed
   */
  public static function db_planet_by_gspt_safe($galaxy, $system, $planet, $planet_type, $for_update = false, $fields = '*') {
  public static function db_planet_by_gspt_safe($galaxy, $system, $planet, $planet_type, $for_update = false, /** @scrutinizer ignore-unused */ $fields = '*') {
    return SN::db_get_record_list(LOC_PLANET,
      "{{planets}}.`galaxy` = {$galaxy} AND {{planets}}.`system` = {$system} AND {{planets}}.`planet` = {$planet} AND {{planets}}.`planet_type` = {$planet_type}", true);
  }

  public static function db_planet_by_gspt($galaxy, $system, $planet, $planet_type, $for_update = false, $fields = '*') {
    $galaxy = intval($galaxy);
    $system = intval($system);
    $planet = intval($planet);
    $planet_type = intval($planet_type);

    return DBStaticPlanet::db_planet_by_gspt_safe($galaxy, $system, $planet, $planet_type, $for_update, $fields);
  }

  public static function db_planet_by_vector($vector, $prefix = '', $for_update = false, $fields = '*') {
    $galaxy = isset($vector[$prefix . 'galaxy']) ? intval($vector[$prefix . 'galaxy']) : 0;
    $system = isset($vector[$prefix . 'system']) ? intval($vector[$prefix . 'system']) : 0;
    $planet = isset($vector[$prefix . 'planet']) ? intval($vector[$prefix . 'planet']) : 0;
    $planet_type = isset($vector[$prefix . 'planet_type']) ? intval($vector[$prefix . 'planet_type']) :
      (isset($vector[$prefix . 'type']) ? intval($vector[$prefix . 'type']) : 0);
    $planet_type = $planet_type == PT_DEBRIS ? PT_PLANET : $planet_type;

    return DBStaticPlanet::db_planet_by_gspt_safe($galaxy, $system, $planet, $planet_type, $for_update, $fields);
  }

//  /**

//   * @param Vector $vector
//   * @param bool   $for_update
//   * @param string $fields
//   *
//   * @return array
//   */
//  public static function db_planet_by_vector_object($vector, $for_update = false, $fields = '*') {
//    $planet_type = $vector->type == PT_DEBRIS ? PT_PLANET : $vector->type;
//    $result = DBStaticPlanet::db_planet_by_gspt_safe($vector->galaxy, $vector->system, $vector->planet, $planet_type, $for_update, $fields);
//
//    return !empty($result) ? $result : array();
//  }

  public static function db_planet_by_parent($parent_id, $for_update = false, $fields = '*') {
  public static function db_planet_by_parent($parent_id, $for_update = false, /** @scrutinizer ignore-unused */ $fields = '*') {
    if(!($parent_id = idval($parent_id))) {
      return false;
    }

    return SN::db_get_record_list(LOC_PLANET,
      "`parent_planet` = {$parent_id} AND `planet_type` = " . PT_MOON, true);
  }

  public static function db_planet_by_id_and_owner($planet_id, $owner_id, $for_update = false, $fields = '*') {
  public static function db_planet_by_id_and_owner($planet_id, $owner_id, $for_update = false, /** @scrutinizer ignore-unused */ $fields = '*') {
    if(!($planet_id = idval($planet_id)) || !($owner_id = idval($owner_id))) {
      return false;
    }
    return SN::db_get_record_list(LOC_PLANET,
      "`id` = {$planet_id} AND `id_owner` = {$owner_id}", true);
  }


  public static function db_planet_list_moon_other($user_id, $this_moon_id) {
    if(!($user_id = idval($user_id)) || !($this_moon_id = idval($this_moon_id))) {
      return false;
    }
    return SN::db_get_record_list(LOC_PLANET,
      "`planet_type` = " . PT_MOON . " AND `id_owner` = {$user_id} AND `id` != {$this_moon_id}");
  }

  public static function db_planet_list_in_system($galaxy, $system) {
    $galaxy = intval($galaxy);
    $system = intval($system);
    return SN::db_get_record_list(LOC_PLANET,
      "`galaxy` = {$galaxy} AND `system` = {$system}");
  }

  public static function db_planet_list_sorted($user_row, $skip_planet_id = false, $field_list = '', $conditions = '') {
  public static function db_planet_list_sorted($user_row, $skip_planet_id = false, /** @scrutinizer ignore-unused */ $field_list = '', $conditions = '') {
    if(!is_array($user_row)) {
      return false;
    }
    $conditions .= $skip_planet_id ? " AND `id` <> {$skip_planet_id} " : '';

    $sort_orders = array(
      SORT_ID       => '{{planets}}.`id`',
      SORT_LOCATION => '{{planets}}.`galaxy`, {{planets}}.`system`, {{planets}}.`planet`, {{planets}}.`planet_type`',
      SORT_NAME     => '`name`',
      SORT_SIZE     => '({{planets}}.`field_max`)',
    );
    $order_by = SN::$user_options[PLAYER_OPTION_PLANET_SORT];
    empty($sort_orders[$order_by]) ? $order_by = SORT_ID : false;
    $order_by = $sort_orders[$order_by] . ' ' . (SN::$user_options[PLAYER_OPTION_PLANET_SORT_INVERSE] == SORT_ASCENDING ? 'ASC' : 'DESC');

    // Compilating query
    return SN::db_get_record_list(LOC_PLANET,
      "`id_owner` = '{$user_row['id']}' {$conditions} ORDER BY {$order_by}");
  }

  public static function db_planet_list_by_user_or_planet($user_id, $planet_id) {
    if(!($user_id = idval($user_id)) && !($planet_id = idval($planet_id))) {
      return false;
    }

    return SN::db_get_record_list(LOC_PLANET,
      $planet_id = idval($planet_id) ? "{{planets}}.`id` = {$planet_id}" : "`id_owner` = {$user_id}", $planet_id);
  }

  public static function db_planet_set_by_id($planet_id, $set) {
    if(!($planet_id = idval($planet_id))) {
      return false;
    }
    return SN::db_upd_record_by_id(LOC_PLANET, $planet_id, $set);
  }

  public static function db_planet_set_by_gspt($ui_galaxy, $ui_system, $ui_planet, $ui_planet_type = PT_ALL, $set) {
    if(!($set = trim($set))) {
      return false;
    }

    $si_galaxy = intval($ui_galaxy);
    $si_system = intval($ui_system);
    $si_planet = intval($ui_planet);
    $si_planet_type = ($si_planet_type = intval($ui_planet_type)) ? "AND `planet_type` = {$si_planet_type}" : '';

    return SN::db_upd_record_list(LOC_PLANET, "`galaxy` = {$si_galaxy} AND `system` = {$si_system} AND `planet` = {$si_planet} {$si_planet_type}", $set);
  }

  public static function db_planet_set_by_parent($ui_parent_id, $ss_set) {
    if(!($si_parent_id = idval($ui_parent_id)) || !($ss_set = trim($ss_set))) {
      return false;
    }
    return SN::db_upd_record_list(LOC_PLANET, "`parent_planet` = {$si_parent_id}", $ss_set);
  }

  public static function db_planet_set_by_owner($ui_owner_id, $ss_set) {
    if(!($si_owner_id = idval($ui_owner_id)) || !($ss_set = trim($ss_set))) {
      return false;
    }
    return SN::db_upd_record_list(LOC_PLANET, "`id_owner` = {$si_owner_id}", $ss_set);
  }


  public static function db_planet_delete_by_id($planet_id) {
    if(!($planet_id = idval($planet_id))) {
      return false;
    }
    SN::db_del_record_by_id(LOC_PLANET, $planet_id);
    SN::db_del_record_list(LOC_UNIT, "`unit_location_type` = " . LOC_PLANET . " AND `unit_location_id` = " . $planet_id);
    // Очереди очистятся автоматически по FOREIGN KEY
    return true;
  }

  public static function db_planet_list_delete_by_owner($ui_owner_id) {
    if(!($si_owner_id = idval($ui_owner_id))) {
      return false;
    }
    SN::db_del_record_list(LOC_PLANET, "`id_owner` = {$si_owner_id}");
    SN::db_del_record_list(LOC_UNIT, "`unit_location_type` = " . LOC_PLANET . " AND `unit_player_id` = " . $si_owner_id);
    // Очереди очистятся автоматически по FOREIGN KEY
    return true;
  }


  public static function db_planet_count_by_type($ui_user_id, $ui_planet_type = PT_PLANET) {
    $si_user_id = idval($ui_user_id);
    $si_planet_type = intval($ui_planet_type);

    // Лочим запись-родителя - если она есть и еще не залочена
    $record_list = SN::db_get_record_list(LOC_PLANET, "`id_owner` = {$si_user_id} AND `planet_type` = {$si_planet_type}");
    return is_array($record_list) ? count($record_list) : 0;

  }

  public static function db_planet_list_resources_by_owner() {
    return doquery("SELECT `id_owner`, sum(metal) AS metal, sum(crystal) AS crystal, sum(deuterium) AS deuterium FROM {{planets}} WHERE id_owner <> 0 /*AND id_owner is not null*/ GROUP BY id_owner;");
  }

  public static function dbDeletePlanetsWithoutUsers() {
    SN::$db->doquery("DELETE FROM `{{planets}}` WHERE id_owner NOT IN (SELECT id FROM `{{users}}`)");
  }

}

supernova-ws / SuperNova

Push — trunk ( c0c172...91a948 )

DBStaticPlanet::dbDeletePlanetsWithoutUsers() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like
