diarioview.cpp

Go to the documentation of this file.

/***************************************************************************
 *   Copyright (C) 2003 by Tomeu Borras                                    *
 *   tborras@conetxia.com                                                  *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program 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 General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/

#include <QWidget>
#include <QLineEdit>
#include <QColor>
#include <QLayout>
#include <QCheckBox>
#include <QPixmap>
#include <QTextStream>
#include <QFileDialog>

#include "empresa.h"
#include "diarioview.h"
#include "funcaux.h"
#include "diarioprintview.h"
#include "diarioprint.h"
#include "configuracion.h"
#include "asiento1view.h"
#include "extractoview1.h"
#include "balanceview.h"
#include "selectccosteview.h"
#include "selectcanalview.h"
#include "busquedafecha.h"



DiarioView::DiarioView(Empresa  *emp, QWidget *parent, int)
        : FichaBc(emp, parent) {
    _depura("DiarioView::DiarioView", 0);
    setupUi(this);

    setTitleName(tr("Diario"));
    setDBTableName("apunte");

    mui_list->setEmpresaBase(emp);
    mui_contrapartida->setEmpresaBase(emp);
    char cadena[10];
    sprintf(cadena, "%2.2d/%2.2d/%4.4d", 1, 1, QDate::currentDate().year());
    mui_fechainicial->setText(cadena);
    sprintf(cadena, "%2.2d/%2.2d/%4.4d", 31, 12, QDate::currentDate().year());
    mui_fechafinal->setText(cadena);
    meteWindow(windowTitle(), this);
    _depura("END DiarioView::DiarioView", 0);
}



DiarioView::~DiarioView() {
    _depura("DiarioView::~DiarioView", 0);
    empresaBase()->sacaWindow(this);
    _depura("END DiarioView::~DiarioView", 0);
}


void DiarioView::on_mui_actualizar_clicked() {
    _depura("DiarioView::on_mui_actualizar_clicked", 0);
    accept();
    _depura("END DiarioView::on_mui_actualizar_clicked", 0);
}



void DiarioView::on_mui_configurar_clicked() {
    _depura("DiarioView::on_mui_configurar_clicked", 0);
    mui_list->showConfig();
    _depura("END DiarioView::on_mui_configurar_clicked", 0);
}



void DiarioView::inicializa1(QString finicial, QString ffinal, int) {
    _depura("DiarioView::inicializa1", 0);
    QString s1, s2, s3;
    QDate fecha1aux;
    int dia, mes, ano;

    s1 = finicial;
    s2 = s1.mid(0, 2);
    dia = atoi(s2.toAscii());
    s2 = s1.mid(3, 2);
    mes = atoi(s2.toAscii());
    s2 = s1.mid(6, 4);
    ano = atoi(s2.toAscii());
    fecha1aux.setYMD(ano, mes, dia);
    QString cadena2;
    cadena2.sprintf("%2.2d/%2.2d/%4.4d", fecha1aux.day(), fecha1aux.month(), fecha1aux.year());
    mui_fechainicial->setText(cadena2);

    s1 = ffinal;
    s2 = s1.mid(0,2);
    dia = atoi(s2.toAscii());
    s2 = s1.mid(3,2);
    mes = atoi(s2.toAscii());
    s2 = s1.mid(6,4);
    ano = atoi(s2.toAscii());
    fecha1aux.setYMD(ano, mes, dia);
    cadena2.sprintf("%2.2d/%2.2d/%4.4d", fecha1aux.day(), fecha1aux.month(), fecha1aux.year());
    mui_fechafinal->setText(cadena2);
    _depura("END DiarioView::inicializa1", 0);
}



void DiarioView::boton_imprimir() {
    _depura("DiarioView::boton_imprimir", 0);
    DiarioPrintView *print = new DiarioPrintView(empresaBase(), 0);
    print->exec();
    _depura("END DiarioView::boton_imprimir", 0);
}



void DiarioView::boton_guardar() {
    _depura("DiarioView::boton_guardar", 0);
    QString fn = QFileDialog::getSaveFileName(this,
                 tr("Guardar Libro Diario"),
                 confpr->valor(CONF_DIR_USER),
                 tr("Diarios (*.txt)"));

    if (!fn.isEmpty()) {
        DiarioPrint diariop(empresaBase());
        QString finicial = mui_fechainicial->text();
        QString ffinal = mui_fechafinal->text();
        diariop.setEmpresaBase(empresaBase());
        diariop.inicializa1((char *) finicial.toAscii().constData(), (char *)ffinal.toAscii().constData());
        diariop.inicializa2((char *) fn.toAscii().constData());
        diariop.accept();
    } // end if
    _depura("END DiarioView::boton_guardar", 0);
}



void DiarioView::accept() {
    _depura("DiarioView::accept", 0);
    presentar();
    _depura("END DiarioView::accept", 0);
}



void DiarioView::presentar() {
    _depura("DiarioView::presentar", 0);
    cursor2 *cur = NULL;
    try {
        QString tabla = "apunte";
        mui_list->setDBTableName("apunte");
        mui_list->setDBCampoId("idapunte");
        if (mui_asAbiertos->isChecked()) {
            tabla = "borrador";
            mui_list->setDBTableName("borrador");
            mui_list->setDBCampoId("idborrador");
        } // end if

        QString query = "SELECT *, cuenta.descripcion AS descripcioncuenta FROM "+tabla+" LEFT JOIN cuenta ON cuenta.idcuenta = "+tabla+".idcuenta ";
        query += " LEFT JOIN (SELECT idc_coste, nombre AS nombrec_coste FROM c_coste) AS t1 ON t1.idc_coste = "+tabla+".idc_coste ";
        query += " LEFT JOIN (SELECT (ordenasiento || ' - ' || fecha) AS ordenasientoconfecha, ordenasiento, idasiento, fecha FROM asiento) AS t5 ON t5.idasiento = "+tabla+".idasiento";
        query += " LEFT JOIN (SELECT idcanal, nombre as nombrecanal FROM canal) AS t2 ON t2.idcanal = "+tabla+".idcanal";
        if (mui_asAbiertos->isChecked()) {
            query += " LEFT JOIN (SELECT idregistroiva, factura, idborrador FROM registroiva) AS t3 ON t3.idborrador = "+tabla+".idborrador ";
        } else {
            query += " LEFT JOIN (SELECT idregistroiva, factura, idborrador FROM registroiva) AS t3 ON t3.idborrador IN (SELECT idborrador FROM borrador WHERE idapunte = "+tabla+".idapunte)";
        } // end if
        query += " LEFT JOIN (SELECT idcuenta AS idcontrapartida, codigo AS codcontrapartida FROM cuenta) as t8 ON t8.idcontrapartida = "+tabla+".contrapartida";

        QString cad = "";
        QString cadwhere=" WHERE ";
        QString cadand = "";
        QString totalcadena = "";

        if (mui_fechainicial->text() != "") {
            cad += cadwhere + cadand + tabla + ".fecha >= '" + mui_fechainicial->text() + "'";
            cadwhere = "";
            cadand = " AND ";
        } // end if

        if (mui_fechafinal->text() != "") {
            cad += cadwhere + cadand + tabla + ".fecha <= '" + mui_fechafinal->text() + "'";
            cadwhere = "";
            cadand = " AND ";
        } // end if

        // Consideraciones para centros de coste y canales
        selectcanalview *scanal=empresaBase()->getselcanales();
        SelectCCosteView *scoste=empresaBase()->getselccostes();
        QString ccostes = scoste->cadcoste();
        if (ccostes != "") {
            ccostes = " " + tabla +".idc_coste IN (" + ccostes + ") ";
            cad += cadwhere + cadand + ccostes;
            cadwhere = "";
            cadand = " AND ";
        } // end if

        QString ccanales = scanal->cadcanal();
        if (ccanales != "") {
            ccanales = " " + tabla + ".idcanal IN (" + ccanales + ") ";
            cad += cadwhere + cadand + ccanales;
            cadwhere = "";
            cadand = " AND ";
        } // end if

        totalcadena = query + cad + " ORDER BY t5.fecha, t5.ordenasiento ";

        mui_list->cargar(totalcadena);

        cur = empresaBase()->cargacursor("SELECT sum(debe) as totaldebe, sum(haber) as totalhaber from " + tabla + cad);
        if (!cur->eof()) {
            totaldebe->setText(cur->valor("totaldebe"));
            totalhaber->setText(cur->valor("totalhaber"));
        } // end if
        delete cur;
        _depura("END DiarioView::presentar", 0);
    } catch (...) {
        mensajeInfo("Error en los calculos");
        if (cur) delete cur;
    }// end try
}


void DiarioView::on_mui_imprimir_clicked() {
    _depura("DiarioView::on_mui_imprimir_clicked", 0);
    mui_list->imprimirPDF("diario");
    _depura("END DiarioView::on_mui_imprimir_clicked", 0);
}

---