canalview.cpp

Go to the documentation of this file.

/***************************************************************************
 *   Copyright (C) 2003 by Tomeu Borras Riera                              *
 *   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  "canalview.h"
#include  "empresa.h"
#include  "selectcanalview.h"



canalview::canalview(Empresa  *emp, QWidget *parent)
        : FichaBc(emp, parent) {
    _depura("canalview::canalview", 0);

    setTitleName(tr("Canal"));
    setDBTableName("canal");

    this->setAttribute(Qt::WA_DeleteOnClose);
    setupUi(this);
    mui_idcanal->setEmpresaBase(emp);
    mui_idcanal->setidcanal("0");

    m_nomcanal = new QLineEdit();
    m_nomcanal->setText("");
    m_desccanal = new QTextEdit();
    m_desccanal->setPlainText("");

    idcanal = 0;
    dialogChanges_setQObjectExcluido(mui_idcanal);
    dialogChanges_cargaInicial();
    on_mui_idcanal_valueChanged(0);
    empresaBase()->meteWindow(windowTitle(), this);
    _depura("END canalview::canalview", 0);
}



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



void canalview::pintar() {
    _depura("canalview::pintar", 0);
    if (idcanal != 0) {
        mui_nomcanal->setEnabled(TRUE);
        mui_desccanal->setEnabled(TRUE);
        mostrarplantilla();
    } else {
        idcanal = mui_idcanal->idcanal().toInt();
        mostrarplantilla();
    } // end if

    selectcanalview *scanal = empresaBase()->getselcanales();
    scanal->cargacanales();
    _depura("END canalview::pintar", 0);
}



void canalview::on_mui_idcanal_valueChanged(QString numcombo) {
    _depura("canalview::on_mui_idcanal_valueChanged", 0);
    int idcanal1 = numcombo.toInt();
    static bool flipflop = FALSE;

    if (dialogChanges_hayCambios() && flipflop) {
        if (QMessageBox::warning(this,
                                 tr("Guardar canal"),
                                 tr("Desea guardar los cambios."),
                                 tr("&Guardar"), tr("&Cancelar"), 0 , 0, 1) == 0)
            on_mui_guardar_clicked();
    } // end if

    if (idcanal1 == 0) {
        mui_nomcanal->setText("");
        mui_nomcanal->setEnabled(FALSE);
        mui_desccanal->setPlainText("");
        mui_desccanal->setEnabled(FALSE);
        flipflop = FALSE;
        return;
    } else {
        mui_nomcanal->setEnabled(TRUE);
        mui_desccanal->setEnabled(TRUE);
    } // end if

    flipflop = TRUE;
    idcanal = idcanal1;
    mostrarplantilla();
    _depura("END canalview::on_mui_idcanal_valueChanged", 0);
}



void canalview::mostrarplantilla() {
    _depura("canalview::mostrarplantilla", 0);
    QString query;
    QTextStream(&query) << "SELECT * from canal WHERE idcanal = '" << idcanal << "'";
    cursor2 *cursorcanal = empresaBase()->cargacursor(query);
    if (!cursorcanal->eof()) {
        mui_nomcanal->setText(cursorcanal->valor("nombre"));
        mui_desccanal->setPlainText(cursorcanal->valor("descripcion"));
    } // end if
    mui_idcanal->setidcanal(QString::number(idcanal));
    dialogChanges_cargaInicial();
    _depura("END canalview::mostrarplantilla", 0);

}



void canalview::on_mui_guardar_clicked() {
    _depura("canalview::on_mui_guardar_clicked", 0);
    QString nom = mui_nomcanal->text();
    QString desc = mui_desccanal->toPlainText();
    QString query;
    QTextStream(&query) << "UPDATE canal SET nombre = '"
                        << empresaBase()->sanearCadena(nom).toAscii().constData()
                        << "', descripcion = '"
                        << empresaBase()->sanearCadena(desc).toAscii().constData()
                        << "' WHERE idcanal = '" << idcanal << "'";
    empresaBase()->ejecuta(query);
    dialogChanges_cargaInicial();
    pintar();
    _depura("END canalview::on_mui_guardar_clicked", 0);
}



void canalview::on_mui_crear_clicked() {
    _depura("canalview::on_mui_crear_clicked", 0);
    if (dialogChanges_hayCambios()) {
        if (QMessageBox::warning(this,
                                 tr("Guardar canal"),
                                 tr("Desea guardar los cambios."),
                                 tr("&Guardar"), tr("&Cancelar"), 0 , 0, 1) == 0)
            on_mui_guardar_clicked();
    } // end if
    QString query = "";
    QTextStream(&query) << "INSERT INTO canal (nombre, descripcion) VALUES ('" << tr("Nuevo canal") << "', '" << tr("Escriba su descripcion") << "')";
    empresaBase()->begin();
    empresaBase()->ejecuta(query);
    query = "";
    QTextStream(&query) << "SELECT MAX(idcanal) AS id FROM canal";
    cursor2 *cur = empresaBase()->cargacursor(query, "queryy");
    idcanal = atoi(cur->valor("id").toAscii());
    delete cur;
    empresaBase()->commit();
    pintar();
    _depura("END canalview::on_mui_crear_clicked", 0);
}



void canalview::on_mui_borrar_clicked() {
    _depura("canalview::on_mui_borrar_clicked", 0);
    switch (QMessageBox::warning(this,
                                 tr("Borrar canal"),
                                 tr("Se va a borrar este canal.\nEsto puede ocasionar perdida de datos."),
                                 tr("&Borrar"), tr("&Cancelar"), 0 , 0, 1)) {
    case 0: 
        QString query;
        query.sprintf("DELETE FROM canal WHERE idcanal = %d", idcanal);
        empresaBase()->begin();
        empresaBase()->ejecuta(query);
        empresaBase()->commit();
        idcanal = 0;
        pintar();
    } // end switch
    _depura("END canalview::on_mui_borrar_clicked", 0);
}



void canalview::closeEvent(QCloseEvent *e) {
    _depura("ccosteview::closeEvent", 0);
    if (dialogChanges_hayCambios()) {
        int val = QMessageBox::warning(this,
                                       tr("Guardar canal"),
                                       tr("Desea guardar los cambios?"),
                                       tr("&Si"), tr("&No"), tr("&Cancelar"), 0, 2);
        if (val == 0)
            on_mui_guardar_clicked();
        if (val == 2)
            e->ignore();
    } // end if
    _depura("END ccosteview::closeEvent", 0);
}

---