CambiaCtaView Class Reference

#include <cambiactaview.h>

Inheritance diagram for CambiaCtaView:

Public Slots
virtual void	accept ()
Public Member Functions
	CambiaCtaView (Empresa *, QWidget *, Qt::WFlags flag=0)
	~CambiaCtaView ()

---

Detailed Description

Definition at line 31 of file cambiactaview.h.

---

Constructor & Destructor Documentation

CambiaCtaView::CambiaCtaView	(	Empresa *	emp,
		QWidget *	parent,
		Qt::WFlags	flag = 0
	)

Parameters:

	emp
	parent
	flag

Definition at line 34 of file cambiactaview.cpp.

References _depura(), Ui_CambiaCuentaBase::mui_codigodestino, Ui_CambiaCuentaBase::mui_codigoorigen, BusquedaCuenta::setEmpresaBase(), and Ui_CambiaCuentaBase::setupUi().

        : QDialog(parent, flag), PEmpresaBase(emp) {
    _depura("CambiaCtaView::CambiaCtaView", 0);
    setupUi(this);
    mui_codigoorigen->setEmpresaBase(emp);
    mui_codigodestino->setEmpresaBase(emp);
    _depura("END CambiaCtaView::CambiaCtaView", 0);
}

CambiaCtaView::~CambiaCtaView

(

)

Definition at line 47 of file cambiactaview.cpp.

References _depura().

                              {
    _depura("CambiaCtaView::~CambiaCtaView", 0);
    _depura("END CambiaCtaView::~CambiaCtaView", 0);
}

---

Member Function Documentation

void CambiaCtaView::accept

(

)

[virtual, slot]

Definition at line 56 of file cambiactaview.cpp.

References _depura(), Ui_CambiaCuentaBase::asientofinal, Ui_CambiaCuentaBase::asientoinicial, postgresiface2::begin(), postgresiface2::commit(), postgresiface2::ejecuta(), PEmpresaBase::empresaBase(), Ui_CambiaCuentaBase::fechafinal, Ui_CambiaCuentaBase::fechainicial, Ui_CambiaCuentaBase::mui_codigodestino, Ui_CambiaCuentaBase::mui_codigoorigen, BusquedaFecha::text(), and BusquedaCuenta::text().

                           {
    _depura("CambiaCtaView::accept", 0);
    QString origen = mui_codigoorigen->text();
    QString destino = mui_codigodestino->text();
    QString ainicial = asientoinicial->text();
    QString afinal = asientofinal->text();
    QString finicial = fechainicial->text();
    QString ffinal = fechafinal->text();
    QString query = "UPDATE borrador SET idcuenta = id_cuenta('" + destino + "') WHERE idcuenta = id_cuenta('" + origen + "')";
    if (ainicial != "") {
        query = query + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento >= " + ainicial + ")";
    } // end if
    if (afinal != "") {
        query = query + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento <= " + afinal + ")";
    } // end if
    if (finicial != "") {
        query = query + " AND fecha >= '" + finicial + "'";
    } // end if
    if (ffinal != "") {
        query = query + " AND fecha <= '" + ffinal + "'";
    } // end if

    QString query2 = "UPDATE borrador SET contrapartida = id_cuenta('" + destino + "') WHERE contrapartida = id_cuenta('" + origen + "')";
    if (ainicial != "") {
        query2 = query2 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento >= " + ainicial + ")";
    } // end if
    if (afinal != "") {
        query2 = query2 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento <= " + afinal + ")";
    } // end if
    if (finicial != "") {
        query2 = query2 + " AND fecha >= '" + finicial + "'";
    } // end if
    if (ffinal != "") {
        query2 = query2 + " AND fecha <= '" + ffinal + "'";
    } // end if

    QString query1 = "UPDATE apunte SET idcuenta = id_cuenta('" + destino + "') WHERE idcuenta = id_cuenta('" + origen + "')";
    if (ainicial != "") {
        query1 = query1 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento >= " + ainicial + ")";
    } // end if
    if (afinal != "") {
        query1 = query1 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento <= " + afinal + ")";
    } // end if
    if (finicial != "") {
        query1 = query1 + " AND fecha >= '" + finicial + "'";
    } // end if
    if (ffinal != "") {
        query1 = query1 + " AND fecha <= '" + ffinal + "'";
    } // end if

    QString query3 = "UPDATE apunte SET contrapartida = id_cuenta('" + destino + "') WHERE contrapartida = id_cuenta('" + origen + "')";
    if (ainicial != "") {
        query3 = query3 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento >= "+ainicial+")";
    } // end if
    if (afinal != "") {
        query3 = query3 + " AND idasiento IN (SELECT idasiento FROM asiento WHERE ordenasiento <= "+afinal+")";
    } // end if
    if (finicial != "") {
        query3 = query3 + " AND fecha >= '" + finicial + "'";
    } // end if
    if (ffinal != "") {
        query3 = query3 + " AND fecha <= '" + ffinal + "'";
    } // end if

    QString query4 = "UPDATE registroiva SET contrapartida = id_cuenta('" + destino + "') WHERE contrapartida = id_cuenta('" + origen + "')";
    if (ainicial != "") {
        query4 = query4 + " AND idborrador IN (SELECT idborrador FROM borrador,asiento WHERE ordenasiento >= " + ainicial + " AND borrador.idasiento = asiento.idasiento)";
    } // end if
    if (afinal != "") {
        query4 = query4 + " AND idborrador IN (SELECT idborrador FROM borrador,asiento WHERE ordenasiento <= " + afinal + " AND borrador.idasiento = asiento.idasiento)";
    } // end if
    if (finicial != "") {
        query4 = query4 + " AND ffactura >= '" + finicial + "'";
    } // end if
    if (ffinal != "") {
        query4 = query4 + " AND ffactura <= '" + ffinal + "'";
    } // end if
    empresaBase()->begin();
    empresaBase()->ejecuta(query);
    empresaBase()->ejecuta(query1);
    empresaBase()->ejecuta(query2);
    empresaBase()->ejecuta(query3);
    empresaBase()->ejecuta(query4);
    empresaBase()->commit();
    done(1);
    _depura("END CambiaCtaView::accept", 0);
}

---

The documentation for this class was generated from the following files:

• bulmacont/src/cambiactaview.h
• bulmacont/src/cambiactaview.cpp

---