DBStatic\DBStaticFleetACS

Complexity

Total Complexity

9

Size/Duplication

Total Lines	96
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	db_acs_get_by_group_id()	0	7	3
A	db_fleet_aks_purge()	0	9	1
A	db_acs_get_list()	0	5	1
A	db_acs_get_by_fleet()	0	5	1
A	db_acs_insert()	0	14	1
A	db_acs_update()	0	3	1
A	db_acs_delete_by_list()	0	9	1

<?php

namespace DBStatic;
use classLocale;
use classSupernova;
use mysqli_result;

class DBStaticFleetACS {

  /* ACS ****************************************************************************************************************/
  /**
   * @param $aks_id
   *
   * @return array
   */
  public static function db_acs_get_by_group_id($aks_id) {
    // TODO - safe
    $aks_id = intval($aks_id);
    $result = classSupernova::$db->doSelectFetch("SELECT * FROM {{aks}} WHERE id = '{$aks_id}' LIMIT 1 FOR UPDATE;");

    return is_array($result) && !empty($result) ? $result : array();
  }

  /**
   * Purges AKS list
   */
// USED AS CALLABLE - SEARCH FOR STRING!!!!!!!

48% of this comment could be valid code. Did you maybe forget this after debugging?

  public static function db_fleet_aks_purge() {
    classSupernova::$db->doDeleteSql(
      'DELETE FROM `{{aks}}` 
      WHERE 
        `id` NOT IN (
          SELECT DISTINCT `fleet_group` FROM `{{fleets}}`
        );'
    );
  }

  /**
   * @return array|bool|mysqli_result|null
   */
  public static function db_acs_get_list() {
    $aks_madnessred = classSupernova::$db->doSelect('SELECT * FROM `{{aks}}`;');

    return $aks_madnessred;
  }

  /**
   * @param $fleetid
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_acs_get_by_fleet($fleetid) {
    $aks = classSupernova::$db->doSelectFetch("SELECT * from `{{aks}}` WHERE `flotten` = {$fleetid} LIMIT 1;");

    return $aks;
  }

  /**
   * @param $fleetid
   * @param $userId
   * @param $objFleet
   */
  public static function db_acs_insert($fleetid, $userId, $objFleet) {
    classSupernova::$db->doInsertSet(TABLE_AKS, array(
      'name'           => classLocale::$lang['flt_acs_prefix'] . $fleetid,
      'teilnehmer'     => $userId,
      'flotten'        => $fleetid,
      'ankunft'        => $objFleet->time_arrive_to_target,
      'galaxy'         => $objFleet->fleet_end_galaxy,
      'system'         => $objFleet->fleet_end_system,
      'planet'         => $objFleet->fleet_end_planet,
      'planet_type'    => $objFleet->fleet_end_type,
      'eingeladen'     => $userId,
      'fleet_end_time' => $objFleet->time_return_to_source,
    ));
  }

  /**
   * @param $userToAddID
   * @param $fleetid
   *
   * @return array|bool|mysqli_result|null
   */
  public static function db_acs_update($userToAddID, $fleetid) {
    return classSupernova::$db->doUpdateReallyComplex("UPDATE `{{aks}}` SET `eingeladen` = concat(`eingeladen`, ',{$userToAddID}') WHERE `flotten` = {$fleetid};");
  }


  /**
   * @param $fleet_group_id_list
   */
  public static function db_acs_delete_by_list($fleet_group_id_list) {
    classSupernova::$db->doDeleteDanger(

The method db_mysql::doDeleteDanger() has been deprecated.

      TABLE_AKS,
      array(),
      array(
        "`id` IN ({$fleet_group_id_list})"
      )
    );
  }


}