Skip to main content

​
Overview

The Operational Reports module provides comprehensive reporting capabilities for police operations, including daily shift reports (partes de novedades), statistical summaries, and operational analysis across jurisdictions. These reports are essential for command staff to monitor activities and make informed decisions.

​
Types of Reports

Shift Reports (Parte)

Daily reports documenting incidents, operations, and activities during specific shifts

Statistical Summaries

Aggregated data showing operations metrics across regions and time periods

Operations Listings

Detailed listings of operations filtered by various criteria

Integrated Operations

Reports specifically for multi-unit coordinated operations

​
Shift Reports (Parte de Novedades)

Shift reports document daily activities and incidents during specific time periods.

​
Creating a Shift Report

1

Access Shift Report Form

Navigate to parte1.php (07:00-19:00 shift) or parte2.php (19:00-07:00 shift)
2

Enter Report Date

Specify the date for the report (day-month-year format)
3

Select Jurisdiction

Choose the Regional Unit (Unidad Regional) and specific police station (Dependencia)
4

Document Incident Details

Complete all incident information fields
5

Save Report

Click GUARDAR to save the shift report to the database

​
Shift Report Fields

  • Fecha (Date): Day-month-year of the incident
  • Unidad Regional: Regional unit where incident occurred
  • Dependencia: Specific police station handling the incident
  • Of. Servicio/Jefe de Turno: Name of officer on duty or shift supervisor
  • Hecho (Incident Type): Select from predefined crime/incident types
  • Modalidad (Method): Select the modus operandi or method used
  • Novedad (Incident Details): Detailed narrative describing what occurred, actions taken, and outcomes

​
Shift Time Periods

The system supports two shift reporting periods:
  • Parte 1: 07:00 to 19:00 hours (day shift)
  • Parte 2: 19:00 to 07:00 hours (night shift)

​
Report Storage

Shift reports are stored in the est_parte database table: 
est_parte (
  ur,                      -- Regional unit ID
  depe,                    -- Police station ID
  novedades,               -- Incident narrative
  fecha,                   -- Date
  parte,                   -- Shift number (1 or 2)
  of_servicio_jefe_turno,  -- Supervising officer
  hecho,                   -- Incident type ID
  modus_operandi,          -- Method ID
  usuario,                 -- Username who created report
  fecha_carga              -- Timestamp of creation
)

​
Statistical Reports

​
Integrated Operations Statistics

Generate comprehensive statistics for integrated operations:
  • Path: detalle_operativo_integral.php
  • Data Source: operativos_integrales table

​
Report Categories

TOTAL GENERAL - System-wide aggregated metrics:
  • Detained contraventors
  • Detained persons with records
  • Detained prosecuted persons
  • Detained persons - family disposition
  • Gender breakdown (male/female)
  • Age breakdown (over 18 / under 18)

​
Regional Breakdown

Statistics can be filtered and aggregated by:

UR-I

Regional Unit I statistics

UR-X

Regional Unit X statistics

Control Vehicular

Vehicle control unit statistics

​
SQL Queries for Statistics

The system uses aggregate queries to generate statistics: 
SELECT 
  SUM(operativos_integrales.detenidos_contraventores),
  SUM(operativos_integrales.detenidos_antecedentes),
  SUM(operativos_integrales.detenidos_procesados),
  SUM(operativos_integrales.detenidos_masculinos),
  SUM(operativos_integrales.detenidos_femeninos),
  SUM(operativos_integrales.detenidos_mayor_18),
  SUM(operativos_integrales.detenidos_menor_18),
  SUM(operativos_integrales.secuestro_motovehiculo),
  SUM(operativos_integrales.secuestro_autovehiculo),
  SUM(operativos_integrales.secuestro_arma_blanca),
  SUM(operativos_integrales.secuestro_arma_fuego),
  SUM(operativos_integrales.secuestro_marihuana),
  SUM(operativos_integrales.secuestro_otras_sustancias),
  SUM(operativos_integrales.actas_infraccion_labradas),
  SUM(operativos_integrales.actas_retencion_autovehiculo),
  SUM(operativos_integrales.actas_retencion_motovehiculo),
  SUM(operativos_integrales.actas_retencion_otros),
  SUM(operativos_integrales.actas_licencias_retenidas),
  SUM(operativos_integrales.actas_alcoholemia_positiva),
  SUM(operativos_integrales.detenidos_disposicion_familiar),
  SUM(operativos_integrales.secuestro_otros)
FROM public.operativos_integrales
WHERE operativos_integrales.sector ILIKE '%UR-I%'

​
Operations Listing Reports

​
Generating Operations Lists

1

Access Query Interface

Navigate to consultaOperativos.php to access the filtering interface
2

Select Filters

Choose jurisdiction, police station, and date range
3

Generate Report

Click BUSCAR to generate the filtered operations list
4

View Results

Report opens in a new window (listado_operativos.php) showing filtered results

​
Filter Options

​
ur
select
default:"TODOS"
UNIDAD (Regional Unit)Select specific regional unit or “TODOS” for all units
​
dependencia
select
default:"TODOS"
COMISARIAS (Police Station)Select specific police station or “TODOS” for all stations (enabled after unit selection)
​
desde
date
required
DESDE (From Date)Start date for the report range
​
hasta
date
required
HASTA (To Date)End date for the report range
When selecting “TODOS” for both unit and station, the date range should not exceed 1 year to ensure optimal performance.

​
Report Output

The generated report displays:
  • Total number of operations found
  • Detailed table with all operation fields
  • Options to modify or delete operations (if authorized)
  • Button to register new operations

​
Report Display Format

​
Table Structure

Reports are displayed in HTML tables with the following characteristics:
  • Header Row: Column titles with gray background (#999999)
  • Data Rows: Alternating rows for easy reading
  • Centered Alignment: Most data is center-aligned for consistency
  • Font: Arial, Helvetica, sans-serif at 12px

​
Data Formatting

​
dates
string
Dates are formatted as DD-MM-YYYY
​
numbers
integer
Numeric values show “0” instead of empty fields
​
text
string
Text fields show ”-” when empty

​
Report Actions

​
Available Actions

From the operations list report, authorized users can:

Modify

Edit operation details by clicking MODIFICAR

Delete

Remove operations by clicking BORRAR (with confirmation)

Register New

Add new operations via “Registrar Operativo” button

Print

Use browser print function to print reports

​
Best Practices

  • Complete shift reports promptly at end of shift
  • Include all significant incidents and activities
  • Use clear, professional language in narratives
  • Verify officer names and jurisdictions are correct
  • Select appropriate incident types and methods
  • Review statistics regularly for trends and patterns
  • Compare regional data to identify disparities
  • Use date ranges that provide meaningful insights
  • Verify data accuracy with source operations
  • Share reports with relevant command staff
  • Use specific filters to narrow results
  • Export or print reports for meetings
  • Verify operation details are complete
  • Follow up on incomplete or missing data
  • Archive historical reports for reference
  • Ensure all operations are properly registered
  • Double-check numerical values in reports
  • Investigate anomalies or unexpected results
  • Update operations if information was missing
  • Maintain consistent data entry standards

​
Report Access Control

Access to different report types may be restricted based on user roles:
  • Shift Reports: Shift supervisors and operations personnel
  • Statistical Reports: Command staff and analysts
  • Operations Lists: Operations personnel with jurisdiction access
  • Modify/Delete: Supervisory personnel only

​
Technical Implementation

​
Database Aggregation

Reports use PostgreSQL aggregate functions:
  • SUM() - Total numerical values
  • COUNT() - Count records
  • GROUP BY - Organize by region/date
  • ORDER BY - Sort results

​
Report Generation Flow

Build docs developers (and LLMs) love

Get started for freeTalk to us