MQTTvue/mqtt-vue-dashboard/server/dist/models/device.d.ts

export interface Device {
    id?: number;
    clientid: string;
    device_name?: string;
    username?: string;
    firmware_version?: string;
    device_ip_port?: string;
    last_ip_port?: string;
    status?: 'online' | 'offline' | 'unknown';
    last_event_time?: Date;
    last_online_time?: Date;
    last_offline_time?: Date;
    online_duration?: number;
    connect_count?: number;
    rssi?: number;
    created_at?: Date;
    updated_at?: Date;
}
export declare class DeviceModel {
    static getAll(limit?: number, offset?: number): Promise<Device[]>;
    static getByStatus(status: string): Promise<Device[]>;
    static getByClientId(clientid: string): Promise<Device | null>;
    static getBySearch(searchTerm: string): Promise<Device[]>;
    static getCountByStatus(status: string): Promise<number>;
    static getCountBySearch(searchTerm: string): Promise<number>;
    static getCount(): Promise<number>;
    static getStatusStats(): Promise<any[]>;
    static getDeviceStats(): Promise<any>;
    static create(deviceData: Omit<Device, 'id' | 'created_at' | 'updated_at'>): Promise<Device>;
    static update(clientId: string, updateData: Partial<Omit<Device, 'id' | 'created_at' | 'clientid'>>): Promise<boolean>;
    static updateOnlineDuration(clientId: string, duration: number): Promise<boolean>;
    static deleteByClientId(clientId: string): Promise<boolean>;
}
//# sourceMappingURL=device.d.ts.map