CDBListView.h

/*
╔══════════════════════════════════════════════════════════════════════════════╗
║                       SIMPLY POWERFUL TOOLKIT (SPTK)                         ║
╟──────────────────────────────────────────────────────────────────────────────╢
║  copyright            © 1999-2022 Alexey Parshin. All rights reserved.       ║
║  email                alexeyp@gmail.com                                      ║
╚══════════════════════════════════════════════════════════════════════════════╝
┌──────────────────────────────────────────────────────────────────────────────┐
│   This library is free software; you can redistribute it and/or modify it    │
│   under the terms of the GNU Library General Public License as published by  │
│   the Free Software Foundation; either version 2 of the License, or (at your │
│   option) any later version.                                                 │
│                                                                              │
│   This library is distributed in the hope that it will be useful, but        │
│   WITHOUT ANY WARRANTY; without even the implied warranty of                 │
│   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library   │
│   General Public License for more details.                                   │
│                                                                              │
│   You should have received a copy of the GNU Library General Public License  │
│   along with this library; if not, write to the Free Software Foundation,    │
│   Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.               │
│                                                                              │
│   Please report all bugs and problems to alexeyp@gmail.com.                  │
└──────────────────────────────────────────────────────────────────────────────┘
*/
 
#pragma once
 
#include <sptk5/DateTime.h>
#include <sptk5/db/Query.h>
#include <sptk5/gui/CListView.h>
 
namespace sptk {
 
class SP_EXPORT CDBListView
    : public CListView
{
    Query m_fullRefreshQuery;
 
    Query m_fastRefreshQuery;
 
    Query m_recordCountQuery;
 
    String m_keyField;
 
    bool m_fastRefreshEnabed;
 
    DateTime m_lastRefresh;
 
    uint32_t m_maxRecords;
 
    bool m_recordsLimited;
 
public:
    CDBListView(const char* label = nullptr, int layoutSize = 20,
                CLayoutAlign layoutAlign = CLayoutAlign::TOP);
 
#ifdef __COMPATIBILITY_MODE__
    CDBListView(int x, int y, int w, int h, const char* label = 0);
#endif
 
    ~CDBListView() override;
 
    void database(PoolDatabaseConnection* db);
 
    PoolDatabaseConnection* database() const;
 
    void sql(const String& sql, const String& recordCountSql = "", const String& fastRefreshSQL = "");
 
    String sql();
 
    QueryParameter& param(const char* paramName, CRefreshKind refreshKind = CRefreshKind::LV_REFRESH_FULL);
 
    void keyField(const String& fieldName);
 
    String keyField() const
    {
        return m_keyField;
    }
 
    void setup(PoolDatabaseConnection* db, const String& sql, const String& keyField);
 
    void refreshData(CRefreshKind refreshKind = CRefreshKind::LV_REFRESH_FULL);
 
    DateTime lastRefresh() const
    {
        return m_lastRefresh;
    }
 
    void maxRecords(uint32_t mr)
    {
        m_maxRecords = mr;
    }
 
    uint32_t maxRecords() const
    {
        return m_maxRecords;
    }
 
    bool recordsLimited() const
    {
        return m_recordsLimited;
    }
 
    static CLayoutClient* creator(const xdoc::SNode& node);
};
} // namespace sptk