+global\UBEReport::sn_ube_report_save()

Complexity

Conditions	8
Paths	19

Size

Total Lines	161
Code Lines	111

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	72

Importance

Changes	4
Bugs	0	Features	0

<?php
  public function sn_ube_report_save($ube) {
    // Если уже есть ИД репорта - значит репорт был взят из таблицы. С таким мы не работаем
    if($ube->get_cypher()) {
      return false;
    }

    // Генерируем уникальный секретный ключ и проверяем наличие в базе
    do {
      $ube->report_cypher = sys_random_string(32);
    } while(classSupernova::$db->doSelectFetchArray("SELECT ube_report_cypher FROM {{ube_report}} WHERE ube_report_cypher = '{$ube->report_cypher}' LIMIT 1 FOR UPDATE"));

The method db_mysql::doSelectFetchArray() has been deprecated with message: TODO - УДАЛИТЬ
Метод временно находится здесь - слишком много переписывать, что бы его отсюда вынести

    // Инициализация таблицы для пакетной вставки информации
    $sql_perform = array(
      'ube_report_player' => array(
        array(
          '`ube_report_id`',
          '`ube_report_player_player_id`',
          '`ube_report_player_name`',
          '`ube_report_player_attacker`',
          '`ube_report_player_bonus_attack`',
          '`ube_report_player_bonus_shield`',
          '`ube_report_player_bonus_armor`',
        ),
      ),

      'ube_report_fleet' => array(
        array(
          '`ube_report_id`',
          '`ube_report_fleet_player_id`',
          '`ube_report_fleet_fleet_id`',
          '`ube_report_fleet_planet_id`',
          '`ube_report_fleet_planet_name`',
          '`ube_report_fleet_planet_galaxy`',
          '`ube_report_fleet_planet_system`',
          '`ube_report_fleet_planet_planet`',
          '`ube_report_fleet_planet_planet_type`',
          '`ube_report_fleet_resource_metal`',
          '`ube_report_fleet_resource_crystal`',
          '`ube_report_fleet_resource_deuterium`',
          '`ube_report_fleet_bonus_attack`',
          '`ube_report_fleet_bonus_shield`',
          '`ube_report_fleet_bonus_armor`',
        ),
      ),

      'ube_report_outcome_fleet' => array(
        array(
          '`ube_report_id`',
          '`ube_report_outcome_fleet_fleet_id`',
          '`ube_report_outcome_fleet_resource_lost_metal`',
          '`ube_report_outcome_fleet_resource_lost_crystal`',
          '`ube_report_outcome_fleet_resource_lost_deuterium`',
          '`ube_report_outcome_fleet_resource_dropped_metal`',
          '`ube_report_outcome_fleet_resource_dropped_crystal`',
          '`ube_report_outcome_fleet_resource_dropped_deuterium`',
          '`ube_report_outcome_fleet_resource_loot_metal`',
          '`ube_report_outcome_fleet_resource_loot_crystal`',
          '`ube_report_outcome_fleet_resource_loot_deuterium`',
          '`ube_report_outcome_fleet_resource_lost_in_metal`',
        ),
      ),

      'ube_report_outcome_unit' => array(
        array(
          '`ube_report_id`',
          '`ube_report_outcome_unit_fleet_id`',
          '`ube_report_outcome_unit_unit_id`',
          '`ube_report_outcome_unit_restored`',
          '`ube_report_outcome_unit_lost`',
          '`ube_report_outcome_unit_sort_order`',
        ),
      ),

      'ube_report_unit' => array(
        array(
          '`ube_report_id`',
          '`ube_report_unit_round`',
          '`ube_report_unit_player_id`',
          '`ube_report_unit_fleet_id`',
          '`ube_report_unit_unit_id`',
          '`ube_report_unit_count`',
          '`ube_report_unit_boom`',
          '`ube_report_unit_attack`',
          '`ube_report_unit_shield`',
          '`ube_report_unit_armor`',
          '`ube_report_unit_attack_base`',
          '`ube_report_unit_shield_base`',
          '`ube_report_unit_armor_base`',
          '`ube_report_unit_sort_order`',
        ),
      ),
    );

    // Сохраняем общую информацию о бое
    classSupernova::$db->doInsertSet(TABLE_UBE_REPORT, array(
        'ube_report_cypher'             => (string)$ube->report_cypher,
        'ube_report_time_combat'        => (string)date(FMT_DATE_TIME_SQL, $ube->combat_timestamp),
        'ube_report_time_spent'         => (float)$ube->time_spent,
        'ube_report_combat_admin'       => (int)$ube->is_admin_in_combat,
        'ube_report_mission_type'       => (int)$ube->mission_type_id,
        'ube_report_combat_result'      => (int)$ube->combat_result,
        'ube_report_combat_sfr'         => (int)$ube->is_small_fleet_recce,
        'ube_report_planet_id'          => (int)$ube->ube_planet_info[PLANET_ID],
        'ube_report_planet_name'        => (string)$ube->ube_planet_info[PLANET_NAME],
        'ube_report_planet_size'        => (int)$ube->ube_planet_info[PLANET_SIZE],
        'ube_report_planet_galaxy'      => (int)$ube->ube_planet_info[PLANET_GALAXY],
        'ube_report_planet_system'      => (int)$ube->ube_planet_info[PLANET_SYSTEM],
        'ube_report_planet_planet'      => (int)$ube->ube_planet_info[PLANET_PLANET],
        'ube_report_planet_planet_type' => (int)$ube->ube_planet_info[PLANET_TYPE],
        'ube_report_capture_result'     => (int)$ube->capture_result,
      )
      + $ube->debris->report_generate_array()
      + $ube->moon_calculator->report_generate_array()
    );
    $ube_report_id = classSupernova::$db->db_insert_id();

    // Сохраняем общую информацию по игрокам
    $player_sides = $ube->players->get_player_sides();
    foreach($player_sides as $player_id => $player_side) {
      $sql_perform['ube_report_player'][] = array(
        $ube_report_id,
        $player_id,

        "'" . db_escape($ube->players[$player_id]->name) . "'",
        $ube->players[$player_id]->getSide() == UBE_PLAYER_IS_ATTACKER ? 1 : 0,

        (float)$ube->players[$player_id]->player_bonus->calcBonus(P_ATTACK),
        (float)$ube->players[$player_id]->player_bonus->calcBonus(P_SHIELD),
        (float)$ube->players[$player_id]->player_bonus->calcBonus(P_ARMOR),
      );
    }

    // Всякая информация по флотам
    foreach($ube->fleet_list->_container as $fleet_id => $UBEFleet) {
      // Сохраняем общую информацию по флотам
      $sql_perform['ube_report_fleet'][] = $UBEFleet->sql_generate_array($ube_report_id);

      // Сохраняем итоговую информацию по ресурсам флота - потеряно, выброшено, увезено
      $sql_perform['ube_report_outcome_fleet'][] = $UBEFleet->sql_generate_outcome_fleet_array($ube_report_id);

      // Сохраняем результаты по юнитам - потеряно и восстановлено
      $UBEFleet->sql_generate_outcome_unit_array($sql_perform['ube_report_outcome_unit'], $ube_report_id);
    }

    // Сохраняем информацию о раундах
    $ube->rounds->sql_generate_unit_array($sql_perform['ube_report_unit'], $ube_report_id, $ube->fleet_list);

    // Пакетная вставка данных
    // First row is a list of field names
    foreach($sql_perform as $table_name => &$table_data) {
      // If only field names in this table - doing nothing
      if(count($table_data) < 2) {
        continue;
      }
      // Picking up field names
      $fields = array_shift($table_data);
      classSupernova::$db->doInsertBatch($table_name, $table_data, $fields, DB_INSERT_PLAIN);

It seems like $fields defined by array_shift($table_data) on line 169 can also be of type null; however, db_mysql::doInsertBatch() does only seem to accept array, maybe add an additional type check?

    }

    return $ube->report_cypher;
  }