yatishDBsqlite.h

Go to the documentation of this file.

/********************************************************************
 * Name:      yatishDBsqlite.h
 * Purpose:   Declares a sqlite controller
 * Author:    Nicolas Pérenne (nicolas.perenne@eif-services.eu)
 * Created:   2020-03-09
 * Copyright: EIF-services (https://www.eif-services.eu/yatish)
 * License:   GPLv3
 ********************************************************************/
 
#ifndef YATISHDBSQLITE_H
#define YATISHDBSQLITE_H
 
#include "wx_pch.h"
#include "yatishDB.h"
#include "yatishTypes.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 ();
        void SetLimit (bool b, int i) { limitRow = b; rowLimit = i; }
        bool FillList (wxListCtrl *, tableID);
        bool FillPlotData (RawData&);
        void AddToFilter (tableID, int);
        void AddToFilter (long);
        wxString GetFilter () const { return filter; };
        void ClearFilter () { filter.Clear(); }
        long FilteredTotal (wxTimeSpan &) const;
        wxString FilteredTotalFormatted ();
        void SetFirstDay (const wxDateTime&);
        void SetLastDay (const wxDateTime&);
        wxDateTime GetFirstDay () const { return wxFirstDay; }
        wxDateTime GetLastDay () const { return wxLastDay; }
        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;
        wxDateTime wxFirstDay, wxLastDay;
        wxTimeSpan totalSpan;
};
 
#endif // YATISHDBSQLITE_H