billingdatabase.h

#ifndef BILLINGDATABASE_H
#define BILLINGDATABASE_H

#include "models/billing.h"
#include "database.h"
#include "utils/log.h"
#include "utils/string.h"
#include "gui/widgets/widgetsmodels/billingstablemodel.h"

using namespace Exceptions;
using namespace Utils;
using namespace Gui::Widgets;

namespace Databases {
class BillingDatabase : public Database
{
public:
    static BillingDatabase* instance()throw(DbException*);

    Models::Billing *getBilling(const int pId);

    WdgModels::BillingsTableModel *getBillingsTable(const int idProject)
        throw(DbException*);

    int addBilling(const Models::Billing&);

    void updateBilling(const Models::Billing&);

    void removeBilling(const int pId);

    void addBillingProject(
            const int idProject, const int idBilling, const int idContributory);

    bool isBillingPaid(const int pId);

    void removeBillingProject(
            const int idProject, const int idBilling, const int idContributory);

    int getMaxBillingNumber();

    int getMaxQuoteNumber();

    int getMaxBillingNumberOfCustomer(const int idCustomer);

    int getMaxQuoteNumberOfCustomer(const int idCustomer);

    QSharedPointer<Models::Billing> getBilling(QSqlQuery &q);

    QMap<Project *, Billing *> getAllBillingsOfProject();

    QList<Billing> getBillsBetweenDates(QDate begin, QDate end);

    QList<Billing> getBills(const int projectId = 0);

    QList<Billing> getBillsPaid(const int projectId = 0);

    int getNbBills(const int customerId = 0);

    int getNbBillsPaid(const int customerId = 0);

    int getNbQuotes(const int customerId = 0);

    int getNbDocs(const int customerId  = 0);

private:
    static BillingDatabase* _instance;

    BillingDatabase() throw(DbException*) ;
};
}
#endif // BILLINGDATABASE_H