/home/nicolas/sources/yatish/yatishDBsqlite.h

Go to the documentation of this file.

/***************************************************************
 * Name:      yatishDBsqlite.h
 * Purpose:   Defines a sqlite controller
 * Author:    Nicolas Pérenne (nicolas.perenne@eif-services.eu)
 * Created:   2020-03-09
 * Copyright: EIF-services (https://www.eif-services.eu)
 * License:   GPLv3
 **************************************************************/

#ifndef YATISHDBSQLITE_H
#define YATISHDBSQLITE_H

#include <wx/listctrl.h>
#include "yatishDB.h"

class yatishDBsqlite : public yatishDB {
    public:
        yatishDBsqlite ();
        ~yatishDBsqlite ();
        bool FillChoice (wxChoice *, tableID);
        int ChoiceSelector (tableID, long);
        bool StartTimeslot (int, int, int);
        bool StopTimeslot ();
        int RunningTimeslots ();
        bool FillList (wxListCtrl *, tableID);
        void AddToFilter (tableID, int);
        void SetLimit (bool b, int i) { limitRow = b; rowLimit = i; }
        wxString FilteredTotal ();
        void ClearFilter () { filter.Clear(); }
        void SetFirstDay (const wxDateTime&);
        void SetLastDay (const wxDateTime&);
        wxDateTime First ();
        wxDateTime Last ();
        long LastActivity ();
        long Activity (long);
        bool Delete(tableID, long);
        wxString ReadName (tableID, long);
        bool ReadDates (long, wxDateTime&, wxDateTime&);
        bool RecordName (tableID, long, const wxString&);
        bool RecordProject (long, const wxString&, int);
        bool RecordActivity (long, int, int, int);
        bool RecordTimeslot (long, const wxDateTime&, const wxDateTime&, int, int, int);
    private:
        bool limitRow;
        int rowLimit;
        long currentTimeslotID, slotCount;
        wxArrayLong clientIDs, projectIDs, taskIDs, toolIDs;
        wxString firstDay, lastDay, filter;
        wxTimeSpan totalSpan;
};

#endif // YATISHDBSQLITE_H