inventariosview.cpp

Go to the documentation of this file.

/***************************************************************************
 *   Copyright (C) 2005 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 <QMessageBox>
#include <QFile>
#include <QTextStream>

#include "inventariosview.h"
#include "company.h"
#include "funcaux.h"
#include "inventarioview.h"



void InventariosView::on_mui_listado_itemDoubleClicked(QTableWidgetItem *) {
    _depura("InventariosView::on_mui_listado_itemDoubleClicked", 0);
    on_mui_editar_clicked();
    _depura("END InventariosView::on_mui_listado_itemDoubleClicked", 0);
}



void InventariosView::on_mui_crear_clicked() {
            _depura("InventariosView::on_mui_crear_clicked", 0);
            InventarioView *bud = new InventarioView((Company *) empresaBase(), 0);
            if (bud->cargar("0"))
                return;
            empresaBase()->m_pWorkspace->addWindow(bud);
            bud->show();
            bud->mui_nominventario->setFocus();
            _depura("END InventariosView::on_mui_crear_clicked", 0);
}



void InventariosView::on_mui_listado_itemDoubleClicked() {
    _depura("InventariosView::on_mui_listado_itemDoubleClicked", 0);
    on_mui_editar_clicked();
    _depura("END InventariosView::on_mui_listado_itemDoubleClicked", 0);
}



void InventariosView::presentar() {
    _depura("InventariosView::presentar", 0);
    mui_listado->cargar();
    _depura("END InventariosView::presentar", 0);
}


InventariosView::InventariosView(Company *comp, QWidget *parent, Qt::WFlags flag, edmode editmode)
        : Listado(comp, parent, flag, editmode) {
    _depura("InventariosView::InventariosView", 0);
    setAttribute(Qt::WA_DeleteOnClose);
    setupUi(this);
    mui_listado->setEmpresaBase(comp);
    mui_listado->cargar();
    if (modoEdicion()) {
        empresaBase()->meteWindow(windowTitle(), this);
    } else {
        setWindowTitle(tr("Selector de Inventarios"));
    } // end if
    _depura("END InventariosView::InventariosView", 0);
}



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



void InventariosView::on_mui_editar_clicked() {
    _depura("InventariosView::on_mui_editar_clicked", 0);
    int a = mui_listado->currentRow();
    if (a < 0) {
        mensajeInfo(tr("Tiene que seleccionar un inventario"));
        return;
    } else {
        QString idinventario = mui_listado->DBvalue("idinventario");
        if (idinventario != "") {
            InventarioView *bud = new InventarioView((Company *) empresaBase(), 0);
            if (bud->cargar(idinventario))
                return;
            empresaBase()->m_pWorkspace->addWindow(bud);
            bud->show();
            bud->mui_nominventario->setFocus();
        } // end if
    } // end if
    _depura("END InventariosView::on_mui_editar_clicked", 0);
}



void InventariosView::on_mui_borrar2_clicked() {
    _depura("InventariosView::on_mui_borrar2_clicked", 0);
    int a = mui_listado->currentRow();
    if (a < 0) {
        mensajeInfo(tr("Tiene que seleccionar un inventario"));
        return;
    } else {
        QString idinventario = mui_listado->DBvalue("idinventario");
        if (idinventario != "") {
            InventarioView *inv = new InventarioView((Company *) empresaBase(), 0);
            empresaBase()->m_pWorkspace->addWindow(inv);
            inv->cargar(idinventario);
            inv->on_mui_borrar_clicked();
            mui_listado->cargar();
        } // end if
    } // end if
    _depura("END InventariosView::on_mui_borrar2_clicked", 0);
}



void InventariosView::on_mui_imprimir_clicked() {
        _depura("InventariosView::on_mui_imprimir_clicked", 0);

   QString archivo = confpr->valor(CONF_DIR_OPENREPORTS) + "listado.rml";
    QString archivod = confpr->valor(CONF_DIR_USER) + "listado.rml";
    QString archivologo = confpr->valor(CONF_DIR_OPENREPORTS) + "logo.jpg";

#ifdef WINDOWS

    archivo = "copy " + archivo + " " + archivod;
#else

    archivo = "cp " + archivo + " " + archivod;
#endif

    system (archivo.toAscii().constData());
#ifdef WINDOWS

    archivologo = "copy " + archivologo + " " + confpr->valor(CONF_DIR_USER) + "logo.jpg";
#else

    archivologo = "cp " + archivologo + " " + confpr->valor(CONF_DIR_USER) + "logo.jpg";
#endif

    system(archivologo.toAscii().constData());


    QFile file;
    file.setFileName(archivod);
    file.open(QIODevice::ReadOnly);
    QTextStream stream(&file);
    QString buff = stream.readAll();
    file.close();


        QString txt = "<blockTable style=\"tabla\" repeatRows=\"1\">\n";
        txt += "<tr>\n\t<td></td>\n";
        
        QString query = "SELECT * FROM articulo ";
        cursor2 *almacenes = empresaBase()->cargacursor("SELECT * FROM almacen");
        while (!almacenes->eof()) {
                QString idalmacen = almacenes->valor("idalmacen");
                query += " LEFT JOIN ( SELECT stock AS stock"+idalmacen+", idarticulo FROM stock_almacen WHERE idalmacen="+almacenes->valor("idalmacen")+") AS t" + idalmacen +" ON " + " t"+idalmacen+".idarticulo = articulo.idarticulo";

                txt += "\t<td>" + almacenes->valor("nomalmacen") + "</td>\n";
                almacenes->siguienteregistro();
        } // end while
        txt += "</tr>\n";
        query += " WHERE articulo.stockarticulo <> 0";


        cursor2 *cstock = empresaBase()->cargacursor(query);
        while (!cstock->eof()) {
                txt += "<tr>\n";
                txt += "\t<td>" + cstock->valor("nomarticulo")+"</td>\n";
                almacenes->primerregistro();
                while(!almacenes->eof()) {
                        txt += "\t<td>"+cstock->valor("stock"+almacenes->valor("idalmacen"))+"</td>\n";
                        almacenes->siguienteregistro();
                } // end while
                cstock->siguienteregistro();
                txt += "</tr>\n";
        } // end while
        delete cstock;
        delete almacenes;
        txt += "</blockTable>\n";

    buff.replace("[story]", txt);
    buff.replace("[titulo]", "Listado de Stocks");


    if (file.open(QIODevice::WriteOnly)) {
        QTextStream stream(&file);
        stream << buff;
        file.close();
    } // end if

    invocaPDF("listado");
        _depura("END InventariosView::on_mui_imprimir_clicked", 0);
}





void InventariosSubForm::cargar() {
    _depura("InventariosSubForm::cargar", 0);
    QString SQLQuery = "SELECT * FROM inventario";
    SubForm3::cargar(SQLQuery);
    _depura("END InventariosSubForm::cargar", 0);
}



InventariosSubForm::InventariosSubForm(QWidget *parent) : SubForm2Bf(parent) {
    _depura("InventariosSubForm::InventariosSubForm", 0);
    setDBTableName("inventario");
    setDBCampoId("idinventario");
    addSHeader("idinventario", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNoView, tr("Id inventario"));
    addSHeader("nominventario", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Nombre del inventario"));
    addSHeader("fechainventario", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Fecha del inventario"));
    setinsercion(FALSE);
    setDelete(FALSE);
    setSortingEnabled(TRUE);
    _depura("END InventariosSubForm::InventariosSubForm", 0);
}

---