import { Repository } from 'typeorm';
import { Certificate } from './certificate.entity';
import { Codebook } from './codebook.entity';
export interface CertReportQuery {
    cert_no?: string;
    company_name?: string;
    standard?: string;
    status?: string;
    from_date?: string;
    to_date?: string;
}
export declare class ExcelReportService {
    private readonly certificateRepo;
    private readonly codebookRepo;
    constructor(certificateRepo: Repository<Certificate>, codebookRepo: Repository<Codebook>);
    private fetchData;
    private fmt;
    generateExcel(query: CertReportQuery): Promise<Buffer>;
    generatePdf(query: CertReportQuery): Promise<Buffer>;
    getPreview(query: CertReportQuery): Promise<{
        totalRecords: number;
        active: number;
        expired: number;
        byStandard: Record<string, number>;
        sampleRows: Certificate[];
    }>;
}