mirror of
https://github.com/magicbug/Cloudlog
synced 2026-08-13 17:49:35 -04:00
928ef10efe
Inserted calls to user_model->validate_session() in all controller constructors to ensure user sessions are validated before authorization checks. This improves session handling and security across the application.
350 lines
12 KiB
PHP
350 lines
12 KiB
PHP
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
|
|
|
|
/*
|
|
Controller for generating monthly reports of amateur radio activity
|
|
*/
|
|
|
|
class Monthlyreport extends CI_Controller {
|
|
|
|
function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->load->helper(array('form', 'url'));
|
|
|
|
$this->load->model('user_model');
|
|
$this->user_model->validate_session();
|
|
if(!$this->user_model->authorize(2)) {
|
|
$this->session->set_flashdata('notice', 'You\'re not allowed to do that!');
|
|
redirect('dashboard');
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Index page - display report selection form
|
|
*/
|
|
public function index()
|
|
{
|
|
$this->load->model('logbooks_model');
|
|
|
|
$data['logbooks'] = $this->logbooks_model->show_all();
|
|
$data['page_title'] = "Monthly Report";
|
|
|
|
$this->load->view('interface_assets/header', $data);
|
|
$this->load->view('monthlyreport/index');
|
|
$this->load->view('interface_assets/footer');
|
|
}
|
|
|
|
/**
|
|
* Generate report for selected logbook and month
|
|
*/
|
|
public function generate()
|
|
{
|
|
$this->load->model('monthlyreport_model');
|
|
$this->load->model('logbooks_model');
|
|
|
|
// Get parameters from POST
|
|
$logbook_id = $this->input->post('logbook_id');
|
|
$year = $this->input->post('year');
|
|
$month = $this->input->post('month');
|
|
|
|
// Validate inputs
|
|
if (empty($logbook_id) || empty($year) || empty($month)) {
|
|
$this->session->set_flashdata('notice', 'Please select a logbook and month');
|
|
redirect('monthlyreport');
|
|
}
|
|
|
|
// Get logbook relationships (station locations)
|
|
$logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($logbook_id);
|
|
|
|
if (!$logbooks_locations_array) {
|
|
$this->session->set_flashdata('notice', 'No station locations found for this logbook');
|
|
redirect('monthlyreport');
|
|
}
|
|
|
|
// Generate report data
|
|
$data['report'] = $this->monthlyreport_model->generate_report($logbooks_locations_array, $year, $month);
|
|
$data['logbook_name'] = $this->logbooks_model->find_name($logbook_id);
|
|
$data['year'] = $year;
|
|
$data['month'] = $month;
|
|
$data['month_name'] = date('F', mktime(0, 0, 0, $month, 1));
|
|
$data['page_title'] = "Monthly Report - " . $data['month_name'] . " " . $year;
|
|
|
|
$this->load->view('interface_assets/header', $data);
|
|
$this->load->view('monthlyreport/report');
|
|
$this->load->view('interface_assets/footer');
|
|
}
|
|
|
|
/**
|
|
* Export report in AI-friendly format (JSON)
|
|
*/
|
|
public function export_json()
|
|
{
|
|
$this->load->model('monthlyreport_model');
|
|
$this->load->model('logbooks_model');
|
|
|
|
// Get parameters from POST
|
|
$logbook_id = $this->input->post('logbook_id');
|
|
$year = $this->input->post('year');
|
|
$month = $this->input->post('month');
|
|
|
|
// Get logbook relationships
|
|
$logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($logbook_id);
|
|
|
|
// Generate report data
|
|
$report = $this->monthlyreport_model->generate_report($logbooks_locations_array, $year, $month);
|
|
$logbook_name = $this->logbooks_model->find_name($logbook_id);
|
|
$month_name = date('F', mktime(0, 0, 0, $month, 1));
|
|
|
|
// Create AI-friendly export
|
|
$export = array(
|
|
'metadata' => array(
|
|
'logbook' => $logbook_name,
|
|
'period' => $month_name . ' ' . $year,
|
|
'generated_at' => date('Y-m-d H:i:s'),
|
|
'report_type' => 'monthly_amateur_radio_activity'
|
|
),
|
|
'summary' => array(
|
|
'total_qsos' => $report['total_qsos'],
|
|
'new_dxcc_entities' => count($report['new_dxcc']),
|
|
'new_dxcc_by_band_count' => count($report['new_dxcc_by_band']),
|
|
'new_dxcc_satellite' => count($report['new_dxcc_satellite']),
|
|
'new_dxcc_eme' => count($report['new_dxcc_eme']),
|
|
'new_gridsquares' => count($report['new_grids']),
|
|
'new_gridsquares_hf' => count($report['new_grids_hf']),
|
|
'new_gridsquares_satellite' => count($report['new_grids_satellite']),
|
|
'new_gridsquares_eme' => count($report['new_grids_eme']),
|
|
'unique_callsigns' => $report['unique_callsigns'],
|
|
'countries_worked' => count($report['countries_worked'])
|
|
),
|
|
'details' => array(
|
|
'new_countries' => $report['new_dxcc'],
|
|
'new_countries_by_band' => $report['new_dxcc_by_band'],
|
|
'new_countries_satellite' => $report['new_dxcc_satellite'],
|
|
'new_countries_eme' => $report['new_dxcc_eme'],
|
|
'new_gridsquares' => $report['new_grids'],
|
|
'new_gridsquares_by_band' => $report['new_grids_by_band'],
|
|
'new_gridsquares_hf' => $report['new_grids_hf'],
|
|
'new_gridsquares_satellite' => $report['new_grids_satellite'],
|
|
'new_gridsquares_eme' => $report['new_grids_eme'],
|
|
'callsigns_worked' => $report['callsign_list'],
|
|
'modes_used' => $report['modes'],
|
|
'bands_used' => $report['bands'],
|
|
'continents_worked' => $report['continents'],
|
|
'satellite_qsos' => $report['satellite_qsos'],
|
|
'eme_qsos' => $report['eme_qsos'],
|
|
'satellite_breakdown' => $report['satellite_breakdown']
|
|
),
|
|
'statistics' => array(
|
|
'qsos_per_day' => round($report['total_qsos'] / date('t', strtotime("$year-$month-01")), 2),
|
|
'most_active_band' => $report['top_band'],
|
|
'most_used_mode' => $report['top_mode']
|
|
),
|
|
'ai_prompt_suggestion' => "Write an engaging amateur radio blog post about my " . $month_name . " " . $year . " operating activity. I made " . $report['total_qsos'] . " contacts" .
|
|
(count($report['new_dxcc']) > 0 ? ", worked " . count($report['new_dxcc']) . " new countries" : "") .
|
|
(count($report['new_grids']) > 0 ? ", and confirmed " . count($report['new_grids']) . " new gridsquares" : "") .
|
|
". Focus on the highlights and make it sound exciting for fellow radio enthusiasts."
|
|
);
|
|
|
|
// Set headers for JSON download
|
|
$filename = "monthly_report_{$year}_{$month}.json";
|
|
$this->output
|
|
->set_content_type('application/json')
|
|
->set_header('Content-Disposition: attachment; filename="' . $filename . '"')
|
|
->set_output(json_encode($export, JSON_PRETTY_PRINT));
|
|
}
|
|
|
|
/**
|
|
* Export report as plain text for AI consumption
|
|
*/
|
|
public function export_text()
|
|
{
|
|
$this->load->model('monthlyreport_model');
|
|
$this->load->model('logbooks_model');
|
|
|
|
// Get parameters from POST
|
|
$logbook_id = $this->input->post('logbook_id');
|
|
$year = $this->input->post('year');
|
|
$month = $this->input->post('month');
|
|
|
|
// Get logbook relationships
|
|
$logbooks_locations_array = $this->logbooks_model->list_logbook_relationships($logbook_id);
|
|
|
|
// Generate report data
|
|
$report = $this->monthlyreport_model->generate_report($logbooks_locations_array, $year, $month);
|
|
$logbook_name = $this->logbooks_model->find_name($logbook_id);
|
|
$month_name = date('F', mktime(0, 0, 0, $month, 1));
|
|
|
|
// Create plain text report
|
|
$text = "AMATEUR RADIO MONTHLY ACTIVITY REPORT\n";
|
|
$text .= "========================================\n\n";
|
|
$text .= "Logbook: {$logbook_name}\n";
|
|
$text .= "Period: {$month_name} {$year}\n";
|
|
$text .= "Generated: " . date('Y-m-d H:i:s') . "\n\n";
|
|
|
|
$text .= "SUMMARY\n";
|
|
$text .= "-------\n";
|
|
$text .= "Total QSOs: {$report['total_qsos']}\n";
|
|
$text .= "Unique Callsigns Worked: {$report['unique_callsigns']}\n";
|
|
$text .= "New DXCC Entities: " . count($report['new_dxcc']) . "\n";
|
|
$text .= "New Gridsquares: " . count($report['new_grids']) . "\n";
|
|
$text .= "Countries Worked: " . count($report['countries_worked']) . "\n\n";
|
|
|
|
if (count($report['new_dxcc']) > 0) {
|
|
$text .= "NEW COUNTRIES THIS MONTH - OVERALL\n";
|
|
$text .= "----------------------------------\n";
|
|
foreach ($report['new_dxcc'] as $dxcc) {
|
|
$text .= "- {$dxcc['name']}\n";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if (!empty($report['new_dxcc_by_band'])) {
|
|
$text .= "NEW COUNTRIES BY BAND\n";
|
|
$text .= "---------------------\n";
|
|
// Bands already sorted in model
|
|
foreach ($report['new_dxcc_by_band'] as $band => $dxcc_list) {
|
|
$text .= "\n{$band} (" . count($dxcc_list) . " new):\n";
|
|
foreach ($dxcc_list as $dxcc) {
|
|
$text .= " - {$dxcc['name']}";
|
|
if (!empty($dxcc['callsign'])) {
|
|
$text .= " (worked {$dxcc['callsign']}";
|
|
if (!empty($dxcc['mode'])) {
|
|
$text .= " on {$dxcc['mode']}";
|
|
}
|
|
$text .= ")";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if (count($report['new_dxcc_satellite']) > 0) {
|
|
$text .= "NEW COUNTRIES VIA SATELLITE\n";
|
|
$text .= "---------------------------\n";
|
|
foreach ($report['new_dxcc_satellite'] as $dxcc) {
|
|
$text .= "- {$dxcc['name']}";
|
|
if (!empty($dxcc['callsign'])) {
|
|
$text .= " (worked {$dxcc['callsign']}";
|
|
if (!empty($dxcc['mode'])) {
|
|
$text .= " on {$dxcc['mode']}";
|
|
}
|
|
$text .= ")";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if (count($report['new_dxcc_eme']) > 0) {
|
|
$text .= "NEW COUNTRIES VIA EME (MOONBOUNCE)\n";
|
|
$text .= "----------------------------------\n";
|
|
foreach ($report['new_dxcc_eme'] as $dxcc) {
|
|
$text .= "- {$dxcc['name']}";
|
|
if (!empty($dxcc['callsign'])) {
|
|
$text .= " (worked {$dxcc['callsign']}";
|
|
if (!empty($dxcc['mode'])) {
|
|
$text .= " on {$dxcc['mode']}";
|
|
}
|
|
$text .= ")";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if (count($report['new_grids']) > 0) {
|
|
$text .= "NEW GRIDSQUARES THIS MONTH\n";
|
|
$text .= "--------------------------\n";
|
|
|
|
if (!empty($report['new_grids_by_band'])) {
|
|
foreach ($report['new_grids_by_band'] as $band => $grids_list) {
|
|
$text .= "\n{$band} (" . count($grids_list) . " new):\n";
|
|
foreach ($grids_list as $grid) {
|
|
$text .= " {$grid['grid']}";
|
|
if (!empty($grid['callsign'])) {
|
|
$text .= " ({$grid['callsign']}";
|
|
if (!empty($grid['satellite'])) {
|
|
$text .= " via {$grid['satellite']}";
|
|
}
|
|
if (!empty($grid['mode'])) {
|
|
$text .= " - {$grid['mode']}";
|
|
}
|
|
$text .= ")";
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
}
|
|
}
|
|
$text .= "\n";
|
|
} $text .= "MODES USED\n";
|
|
$text .= "----------\n";
|
|
foreach ($report['modes'] as $mode => $count) {
|
|
$text .= sprintf("%-10s %d QSOs\n", $mode, $count);
|
|
}
|
|
$text .= "\n";
|
|
|
|
$text .= "BANDS USED\n";
|
|
$text .= "----------\n";
|
|
foreach ($report['bands'] as $band => $count) {
|
|
$text .= sprintf("%-10s %d QSOs\n", $band, $count);
|
|
}
|
|
$text .= "\n";
|
|
|
|
if (!empty($report['continents'])) {
|
|
$text .= "CONTINENTAL DISTRIBUTION\n";
|
|
$text .= "------------------------\n";
|
|
foreach ($report['continents'] as $continent => $count) {
|
|
$text .= sprintf("%-15s %d QSOs\n", $continent, $count);
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if (!empty($report['callsign_list'])) {
|
|
$text .= "UNIQUE CALLSIGNS WORKED (" . count($report['callsign_list']) . ")\n";
|
|
$text .= "----------------------------\n";
|
|
foreach ($report['callsign_list'] as $callsign) {
|
|
$text .= sprintf("%-15s %d QSO%s\n", $callsign['callsign'], $callsign['qso_count'], $callsign['qso_count'] > 1 ? 's' : '');
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if ($report['satellite_qsos'] > 0) {
|
|
$text .= "SATELLITE ACTIVITY\n";
|
|
$text .= "------------------\n";
|
|
$text .= "Total Satellite QSOs: {$report['satellite_qsos']}\n";
|
|
|
|
if (!empty($report['satellite_breakdown'])) {
|
|
$text .= "\nQSOs per Satellite:\n";
|
|
foreach ($report['satellite_breakdown'] as $sat) {
|
|
$text .= sprintf(" %-20s %3d QSOs (%s%%)\n", $sat['satellite'], $sat['qso_count'], $sat['percentage']);
|
|
}
|
|
}
|
|
$text .= "\n";
|
|
}
|
|
|
|
if ($report['eme_qsos'] > 0) {
|
|
$text .= "EME (MOONBOUNCE) ACTIVITY\n";
|
|
$text .= "-------------------------\n";
|
|
$text .= "Total EME QSOs: {$report['eme_qsos']}\n\n";
|
|
}
|
|
|
|
$text .= "STATISTICS\n";
|
|
$text .= "----------\n";
|
|
$days_in_month = date('t', strtotime("$year-$month-01"));
|
|
$text .= "Average QSOs per day: " . round($report['total_qsos'] / $days_in_month, 2) . "\n";
|
|
$text .= "Most active band: {$report['top_band']}\n";
|
|
$text .= "Most used mode: {$report['top_mode']}\n\n";
|
|
|
|
$text .= "---\n";
|
|
$text .= "This report can be used to generate an article about your amateur radio activity.\n";
|
|
$text .= "Consider using an AI tool like ChatGPT or Claude to create an engaging blog post from this data.\n";
|
|
|
|
// Set headers for text download
|
|
$filename = "monthly_report_{$year}_{$month}.txt";
|
|
$this->output
|
|
->set_content_type('text/plain')
|
|
->set_header('Content-Disposition: attachment; filename="' . $filename . '"')
|
|
->set_output($text);
|
|
}
|
|
}
|