listcontrolstockview.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 "listcontrolstockview.h"



ListControlStockView::ListControlStockView(QWidget *parent, const char *)
        : SubForm2Bf(parent) {
    _depura("ListControlStockView::ListControlStockView", 0);
    setDBTableName("controlstock");
    setDBCampoId("idarticulo");
    addSHeader("punteocontrolstock", DBCampo::DBboolean, DBCampo::DBNothing, SHeader::DBNone, tr("Punteado"));
    addSHeader("codigoalmacen", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone, tr("Codigo almacen"));
    addSHeader("nomalmacen", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Nombre almacen"));
    addSHeader("codigocompletoarticulo", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Codigo completo articulo"));
    addSHeader("nomarticulo", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone | SHeader::DBNoWrite, tr("Nombre articulo"));
    addSHeader("stockantcontrolstock", DBCampo::DBnumeric, DBCampo::DBNothing, SHeader::DBNoWrite, tr("Stock anterior"));
    addSHeader("stocknewcontrolstock", DBCampo::DBnumeric, DBCampo::DBRequired, SHeader::DBNone, tr("Stock revisado"));
    addSHeader("idarticulo", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, tr("Id articulo"));
    addSHeader("idalmacen", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, "Id almacen");
    addSHeader("idinventario", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNone | SHeader::DBNoView, "Id inventario");
    addSHeader("idarticulopk", DBCampo::DBint, DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idarticulo");
    addSHeader("idalmacenpk", DBCampo::DBint,  DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idalmacen");
//    addSHeader("idinventariopk", DBCampo::DBint,  DBCampo::DBNoSave | DBCampo::DBDupPrimaryKey, SHeader::DBNone | SHeader::DBNoView | SHeader::DBBlockView, "idinventario");
    setinsercion(FALSE);
    _depura("END ListControlStockView::ListControlStockView", 0);
}



void ListControlStockView::cargar(QString idinventario) {
    _depura("ListControlStockView::cargar", 0);
    mdb_idinventario = idinventario;
    QString SQLQuery = "SELECT * FROM ";
    SQLQuery += " (SELECT idarticulo, idalmacen, nomarticulo, nomalmacen, codigocompletoarticulo, codigoalmacen FROM articulo, almacen) AS t1 ";
    SQLQuery += " LEFT JOIN (SELECT punteocontrolstock,stockantcontrolstock, stocknewcontrolstock, idarticulo AS idarticulopk, idalmacen AS idalmacenpk, idinventario FROM controlstock WHERE idinventario = " + idinventario + ") AS t2 ON t1.idarticulo = t2.idarticulopk AND t1.idalmacen = t2.idalmacenpk ";
    SQLQuery += " WHERE idarticulo IN (SELECT idarticulo from lalbaranp UNION SELECT idarticulo FROM lalbaran)";
    SQLQuery += " ORDER BY codigoalmacen, codigocompletoarticulo";
    SubForm2Bf::cargar(SQLQuery);
    _depura("END ListControlStockView::cargar", 0);
}



int ListControlStockView::borrar() {
    _depura("ListControlStockView::borrar", 0);
    empresaBase()->ejecuta("DELETE FROM controlstock WHERE idinventario = " + mdb_idinventario);
    _depura("END ListControlStockView::borrar", 0);
    return 0;
}



void ListControlStockView::pregenerar() {
    _depura("ListControlStockView::pregenerar", 0);
    QString query;
    query = "SELECT * FROM (SELECT * FROM articulo, almacen) AS t1 LEFT JOIN (SELECT stocknewcontrolstock, idarticulo AS idarticulopk, idalmacen AS idalmacenpk, idinventario AS idinventariopk FROM controlstock WHERE idinventario = 1) AS t2 ON t1.idarticulo = t2.idarticulopk AND t1.idalmacen = t2.idalmacenpk ORDER BY codigoalmacen, codigocompletoarticulo;";
    SubForm3::cargar(query);
    _depura("END ListControlStockView::pregenerar", 0);
}



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



int ListControlStockView::guardar() {
    _depura("ListControlStockView::guardar", 0);
    SubForm2Bf::guardar();
    _depura("END ListControlStockView::guardar", 0);
    return 0;
}

---