Matching only new QSLs via QRZ download

[stevendodd]

By adding an additional filter in the first step of the process_qrz_batch

    // Step 1: Build WHERE clause for fetching potential matches
    $this->db->select($this->config->item('table_name').'.COL_PRIMARY_KEY, '.$this->config->item('table_name').'.COL_CALL, '.$this->config->item('table_name').'.COL_TIME_ON, '.$this->config->item('table_name').'.COL_BAND, '.$this->config->item('table_name').'.COL_MODE, '.$this->config->item('table_name').'.COL_QRZCOM_QSO_DOWNLOAD_STATUS, ');
    $this->db->from($this->config->item('table_name'));
    $this->db->group_start(); // Start grouping OR conditions
    foreach ($batch_data as $record) {
      $this->db->or_group_start(); // Start group for this record's AND conditions
      $this->db->where($this->config->item('table_name').'.COL_CALL', $record['call']);
      $this->db->where($this->config->item('table_name').'.COL_TIME_ON', $record['time_on']);
      $this->db->where($this->config->item('table_name').'.COL_BAND', $record['band']);
      $this->db->where($this->config->item('table_name').'.COL_QRZCOM_QSO_DOWNLOAD_STATUS !=', 'Y');
      $this->db->group_end(); // End group for this record's AND conditions
    }
    $this->db->group_end(); // End grouping OR conditions

The update/write time will be reduced significantly and potentially allow you to return a table of just the new matches by moving the build table row code into the section of code that is executed when only a matches found:

      if (isset($indexed_results[$match_key])) {
        $primary_key = $indexed_results[$match_key];
        $log_status = '<span class="badge text-bg-success">Confirmed</span>';

        // Prepare data for batch update
        $update_batch_data[] = [
          'COL_PRIMARY_KEY' => $primary_key,
          'COL_QRZCOM_QSO_DOWNLOAD_DATE' => $record['qsl_date'],
          'COL_QRZCOM_QSO_DOWNLOAD_STATUS' => $record['qsl_rcvd'] // Should be 'Y' if confirmed
        ];
    //  } 

        // Build table row
        $table .= "<tr>";
        $table .= "<td>" . $record['station_callsign'] . "</td>";
        $table .= "<td>" . $record['time_on'] . "</td>";
        $table .= "<td>" . $record['call'] . "</td>";
        $table .= "<td>" . $record['mode'] . "</td>";
        $table .= "<td>" . $record['qsl_date'] . "</td>";
        $table .= "<td>" . ($record['qsl_rcvd'] == 'Y' ? '<span class="badge text-bg-success">Yes</span>' : '<span class="badge text-bg-danger">No</span>') . "</td>";
        $table .= "</tr>";
       }
    }

The title of the table is currently 'QRZ ADIF Information' which would potentially need to be changed