plugininventario.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 <stdio.h>

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



myplugininv::myplugininv() {
    _depura("myplugininv::myplugininv", 0);
    _depura("END myplugininv::myplugininv", 0);
}



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



void myplugininv::elslot() {
    _depura("myplugininv::elslot", 0);
    InventariosView *tar = new InventariosView((Company *)empresaBase(), NULL);
    empresaBase()->m_pWorkspace->addWindow(tar);
    tar->show();
    _depura("END myplugininv::elslot", 0);
}



void myplugininv::inicializa(Bulmafact *bges) {
    _depura("myplugininv::inicializa", 0);
    m_bges = bges;
    setEmpresaBase(bges->getcompany());
    QAction *planCuentas = new QAction(tr("&Inventarios"), 0);
    planCuentas->setStatusTip(tr("Inventarios"));
    planCuentas->setWhatsThis(tr("Inventarios"));
    bges->menuArticulos->addSeparator();
    bges->menuArticulos->addAction(planCuentas);
    connect(planCuentas, SIGNAL(activated()), this, SLOT(elslot()));
    _depura("END myplugininv::inicializa", 0);
}



int entryPoint(Bulmafact *bges) {
    _depura("Punto de Entrada del plugin de Tarifas\n", 0);
    myplugininv *plug = new myplugininv();
    plug->inicializa(bges);
    return 0;
}



int ArticuloView_ArticuloView(ArticuloView *art) {
    _depura("ArticuloView_ArticuloView", 0);
    SubForm2Bf *l = new SubForm2Bf(art);
    l->setEmpresaBase(art->empresaBase());
    l->setObjectName(QString::fromUtf8("m_lmin"));
    art->mui_tab->addTab(l, "Minimos Almacen");

    l->setDBTableName("minimsalmacen");
    l->setDBCampoId("idminimsalmacen");
    l->addSHeader("nomalmacen", DBCampo::DBvarchar, DBCampo::DBNoSave, SHeader::DBNone , QApplication::translate("TrabajadorView", "Almacén"));
    l->addSHeader("idalmacen", DBCampo::DBint, DBCampo::DBNotNull, SHeader::DBNoWrite , QApplication::translate("TrabajadorView", "Id Almacen"));
    l->addSHeader("valminimsalmacen", DBCampo::DBnumeric, DBCampo::DBNotNull, SHeader::DBNone, QApplication::translate("TrabajadorView", "Minimo"));
    l->addSHeader("idminimsalmacen", DBCampo::DBint, DBCampo::DBPrimaryKey, SHeader::DBNoView | SHeader::DBNoWrite, QApplication::translate("TrabajadorView", "ID Validacion"));
    l->addSHeader("idarticulo", DBCampo::DBint, DBCampo::DBNotNull, SHeader::DBNoView | SHeader::DBNoWrite, QApplication::translate("TrabajadorView", "ID Trabajador"));
    l->setinsercion(TRUE);
    l->setDelete(TRUE);
    l->setSortingEnabled(FALSE);
    art->dialogChanges_setQObjectExcluido(l->mui_list);

    _depura("END ArticuloView_ArticuloView", 0);
    return 0;
}



int Ficha_cargar(Ficha *fich) {
    SubForm3 *form = fich->findChild<SubForm3 *>("m_lmin");
    if (form)
        form->cargar("SELECT * FROM minimsalmacen NATURAL LEFT JOIN almacen WHERE idarticulo = " + fich->DBvalue("idarticulo"));
    return 0;
}



int Ficha_guardar_Post(Ficha *fich) {
    SubForm3 *form = fich->findChild<SubForm3 *>("m_lmin");
    if (form) {
        form->setColumnValue("idarticulo", fich->DBvalue("idarticulo"));
        form->guardar();
    } // end if
    return 0;
}


int SubForm2Bf_on_mui_list_editFinished(SubForm2Bf *subform) {
    _depura("SubForm2Bf_on_mui_list_editFinished", 0);

    if (subform->currentColumn() < 1 ) {
        return 0;
    } // end if

    SDBCampo *camp = (SDBCampo *) subform->item(subform->currentRow(), subform->currentColumn()-1);
    camp->refresh();

    if (camp->nomcampo() == "cant"+subform->tableName()) {
        SDBRecord *rec = subform->lineaat(subform->currentRow());
        QObject *wid = subform->parent();
        while (wid
                && (wid->objectName() != "PresupuestoClienteBase")
                && (wid->objectName() != "PedidoClienteBase")
                && (wid->objectName() != "AlbaranClienteBase")
              ) {
            wid = wid->parent();
        } // end if

        if (!wid) return 0;

        Ficha *fich = (Ficha *) wid;
        QString idalmacen = fich->DBvalue("idalmacen");
        if (idalmacen == "") return 0;

        if (rec->DBvalue("idarticulo") == "") return 0;

        QString query1 = "SELECT * FROM stock_almacen where idarticulo=" +rec->DBvalue("idarticulo") + " AND idalmacen = " +idalmacen;
        cursor2 *cur1 = subform->empresaBase()->cargacursor(query1);
        Fixed stock("0");
        if (!cur1) return 0;
        if (!cur1->eof()) {
                stock = Fixed(cur1->valor("stock"));
        } // end if
        delete cur1;



        QString query = "SELECT * FROM minimsalmacen where idarticulo=" +rec->DBvalue("idarticulo") + " AND idalmacen = " +idalmacen;
        cursor2 *cur = subform->empresaBase()->cargacursor(query);
        if (!cur) return 0;
        if (!cur->eof()) {
            Fixed val = Fixed(cur->valor("valminimsalmacen"));
            Fixed valb = Fixed(camp->valorcampo());
            if (stock - valb <= val)
                mensajeAviso("Stock Minimo Superado");
        } // end if
        delete cur;
    } // end if
    return 0;
}

---