Inventario Class Reference

Administra los datos de inventario. More...

#include <inventario.h>

Inheritance diagram for Inventario:

FichaBf Ficha BLWidget DBRecord dialogChanges QWidget PEmpresaBase InventarioView

Public Member Functions

 Inventario (Company *comp, QWidget *parent)
virtual ~Inventario ()
void setListControlStock (ListControlStockView *a)
ListControlStockView * getlistalineas ()
virtual int cargar (QString)
 Esta funcion carga un Inventario.
void pintaInventario ()
virtual int guardar ()
virtual int borrar ()
void imprimirInventario ()
virtual void pintaidinventario (QString)
virtual void pintafechainventario (QString)
virtual void pintanominventario (QString)
virtual void pregenerar ()
void setidinventario (QString val)
void setfechainventario (QString val)
void setnominventario (QString val)
void vaciaInventario ()

Protected Attributes

ListControlStockView * listalineas
Company * companyact

Detailed Description

Administra los datos de inventario.

Definition at line 36 of file inventario.h.

Constructor & Destructor Documentation

Inventario::Inventario ( Company *  comp,
QWidget *  parent 
)

Parameters:
comp 
parent 

Definition at line 34 of file inventario.cpp.

References _depura(), DBRecord::addDBCampo(), companyact, DBCampo::DBdate, DBCampo::DBint, DBCampo::DBNothing, DBCampo::DBPrimaryKey, DBCampo::DBvarchar, DBRecord::setDBCampoId(), Ficha::setDBTableName(), and Ficha::setTitleName().

00034                                                      : FichaBf(comp, parent) {
00035     _depura("Inventario::Inventario", 0);
00036     companyact = comp;
00037     setTitleName(tr("Inventario"));
00038     setDBTableName("inventario");
00039     setDBCampoId("idinventario");
00040     addDBCampo("idinventario", DBCampo::DBint, DBCampo::DBPrimaryKey, QApplication::translate("Inventario", "Identificador inventario"));
00041     addDBCampo("fechainventario", DBCampo::DBdate, DBCampo::DBNothing, QApplication::translate("Inventario", "Fecha inventario"));
00042     addDBCampo("nominventario", DBCampo::DBvarchar, DBCampo::DBNothing, QApplication::translate("Inventario", "Nombre inventario"));
00043     _depura("END Inventario::Inventario", 0);
00044 }

Inventario::~Inventario (  )  [virtual]

Definition at line 50 of file inventario.cpp.

References _depura().

00050                         {
00051     _depura("Inventario::~Inventario", 0);
00052     _depura("END Inventario::~Inventario", 0);
00053 }

Member Function Documentation

void Inventario::setListControlStock ( ListControlStockView *  a  ) 

Parameters:
a 

Definition at line 158 of file inventario.cpp.

References _depura(), companyact, listalineas, and SubForm2Bf::setEmpresaBase().

Referenced by InventarioView::InventarioView().

00158                                                             {
00159     _depura("Inventario::setListControlStock", 0);
00160     listalineas = a;
00161     listalineas->setEmpresaBase(companyact);
00162     _depura("END Inventario::setListControlStock", 0);
00163 }

ListControlStockView * Inventario::getlistalineas (  ) 

Returns:

Reimplemented from FichaBf.

Definition at line 170 of file inventario.cpp.

References _depura(), and listalineas.

00170                                                  {
00171     _depura("Inventario::getlistalineas", 0);
00172     _depura("Inventario::getlistalineas", 0);
00173     return listalineas;
00174 }

int Inventario::cargar ( QString  idbudget  )  [virtual]

Esta funcion carga un Inventario.

Parameters:
idbudget 
Returns:

Reimplemented from Ficha.

Definition at line 106 of file inventario.cpp.

References postgresiface2::cargacursor(), ListControlStockView::cargar(), companyact, DBRecord::DBload(), cursor2::eof(), listalineas, and pintaInventario().

Referenced by guardar(), InventariosView::on_mui_borrar2_clicked(), InventariosView::on_mui_crear_clicked(), and InventariosView::on_mui_editar_clicked().

00106                                        {
00107     QString query = "SELECT * FROM inventario WHERE idinventario = " + idbudget;
00108     cursor2 * cur= companyact->cargacursor(query);
00109     if (!cur->eof()) {
00110         DBload(cur);
00111     } // end if
00112     delete cur;
00113     listalineas->cargar(idbudget);
00114     pintaInventario();
00115     return 0;
00116 }

void Inventario::pintaInventario (  ) 

Definition at line 91 of file inventario.cpp.

References _depura(), DBRecord::DBvalue(), pintafechainventario(), pintaidinventario(), and pintanominventario().

Referenced by cargar().

00091                                  {
00092     _depura("pintaInventario\n", 0);
00093     pintaidinventario(DBvalue("idinventario"));
00094     pintanominventario(DBvalue("nominventario"));
00095     pintafechainventario(DBvalue("fechainventario"));
00097     //listalineas->pintaListControlStock();
00098 }

int Inventario::guardar (  )  [virtual]

Returns:

Reimplemented from Ficha.

Definition at line 123 of file inventario.cpp.

References _depura(), postgresiface2::begin(), cargar(), postgresiface2::commit(), companyact, DBRecord::DBsave(), ListControlStockView::guardar(), listalineas, postgresiface2::rollback(), and setidinventario().

Referenced by InventarioView::on_mui_aceptar_clicked(), and InventarioView::on_mui_guardar2_clicked().

00123                         {
00124     _depura("Inventario::guardar()", 0);
00125     companyact->begin();
00126     try {
00127         QString id;
00128         DBsave(id);
00129         setidinventario(id);
00130         listalineas->guardar();
00131         companyact->commit();
00132         cargar(id);
00133         _depura("END Inventario::guardar()", 0);
00134         return 0;
00135     } catch (...) {
00136         _depura("Error guardando el inventario", 2);
00137         companyact->rollback();
00138     _depura("END Inventario::guardar()", 0);
00139         return -1;
00140     } // end try
00141 }

int Inventario::borrar (  )  [virtual]

Returns:

Reimplemented from Ficha.

Definition at line 60 of file inventario.cpp.

References _depura(), postgresiface2::begin(), ListControlStockView::borrar(), postgresiface2::commit(), companyact, DBRecord::DBvalue(), postgresiface2::ejecuta(), listalineas, and postgresiface2::rollback().

Referenced by InventarioView::on_mui_borrar2_clicked().

00060                        {
00061     if (DBvalue("idinventario") != "") {
00062         _depura("vamos a borrar las lineas del inventario", 0);
00063         companyact->begin();
00064 
00065         listalineas->borrar();
00066         _depura("Vamos a borrar el resto",0);
00067         int error = companyact->ejecuta("DELETE FROM inventario WHERE idinventario = " + DBvalue("idinventario"));
00068         if (error) {
00069             companyact->rollback();
00070             return -1;
00071         } // end if
00072         companyact->commit();
00073     } // end if
00074     return 0;
00075 }

void Inventario::imprimirInventario (  ) 

Definition at line 241 of file inventario.cpp.

References _depura(), postgresiface2::cargacursor(), companyact, cursor2::eof(), cursor2::numcampos(), cursor2::siguienteregistro(), and cursor2::valor().

00241                                     {
00242         _depura("Inventario::imprimirInventario", 0);
00243         QString txt = "<blockTable>\n";
00244         txt += "<tr><td></td>\n";
00245         
00246         QString query = "SELECT idarticulo, codigocompeltoarticulo, nomarticulo FROM articulo ";
00247         cursor2 *almacenes = companyact->cargacursor("SELECT * FROM almacen");
00248         while (!almacenes->eof()) {
00249                 QString idalmacen = almacenes->valor("idalmacen");
00250                 query += " LEFT JOIN ( SELECT stock, idarticulo FROM stock_almacen WHERE idalmacen="+almacenes->valor("idalmacen")+") AS t" + idalmacen +" ON " + " t"+idalmacen+".idarticulo = articulo.idarticulo";
00251                 txt += "<td>" + almacenes->valor("nomalmacen") + "</td>";
00252                 almacenes->siguienteregistro();
00253         } // end while
00254         delete almacenes;
00255         txt += "</tr>\n";
00256 
00257         cursor2 *cstock = companyact->cargacursor(query);
00258         while (!cstock->eof()) {
00259                 txt += "<tr>\n";
00260                 txt += "<td>" + cstock->valor("nomarticulo");
00261                 for (int i = 0; i < cstock->numcampos(); i++) {
00262                         txt += "<td>"+cstock->valor(i)+"</td>";
00263                 } // end for
00264                 cstock->siguienteregistro();
00265                 txt += "\n";
00266                 txt += "</tr>\n";
00267         } // end while
00268         delete cstock;
00269 
00270         _depura(txt, 2);
00271         _depura("END Inventario::imprimirInventario", 0);
00272 }

void Inventario::pintaidinventario ( QString   )  [virtual]

Reimplemented in InventarioView.

Definition at line 180 of file inventario.cpp.

References _depura().

Referenced by pintaInventario().

00180                                           {
00181     _depura("Inventario::pintaidinventario", 0);
00182     _depura("END Inventario::pintaidinventario", 0);
00183 }

void Inventario::pintafechainventario ( QString   )  [virtual]

Reimplemented in InventarioView.

Definition at line 189 of file inventario.cpp.

References _depura().

Referenced by pintaInventario().

00189                                              {
00190     _depura("Inventario::pintafechainventario", 0);
00191     _depura("END Inventario::pintafechainventario", 0);
00192 }

void Inventario::pintanominventario ( QString   )  [virtual]

Reimplemented in InventarioView.

Definition at line 198 of file inventario.cpp.

References _depura().

Referenced by pintaInventario().

00198                                            {
00199     _depura("Inventario::pintanominventario", 0);
00200     _depura("END Inventario::pintanominventario", 0);
00201 }

void Inventario::pregenerar (  )  [virtual]

Definition at line 147 of file inventario.cpp.

References _depura(), listalineas, and ListControlStockView::pregenerar().

Referenced by InventarioView::on_mui_pregenerar_clicked().

00147                             {
00148     _depura("Inventario::pregenerar", 0);
00149     listalineas->pregenerar();
00150     _depura("END Inventario::pregenerar", 0);
00151 }

void Inventario::setidinventario ( QString  val  ) 

Parameters:
val 

Definition at line 208 of file inventario.cpp.

References _depura(), listalineas, SubForm3::setColumnValue(), and DBRecord::setDBvalue().

Referenced by guardar().

00208                                             {
00209     _depura("Inventario::setidinventario", 0);
00210     setDBvalue("idinventario", val);
00211     listalineas->setColumnValue("idinventario", val);
00212     _depura("END Inventario::setidinventario", 0);
00213 }

void Inventario::setfechainventario ( QString  val  ) 

Parameters:
val 

Definition at line 220 of file inventario.cpp.

References _depura(), and DBRecord::setDBvalue().

Referenced by InventarioView::on_mui_aceptar_clicked(), and InventarioView::on_mui_guardar2_clicked().

00220                                                {
00221     _depura("Inventario::setfechainventario", 0);
00222     setDBvalue("fechainventario", val);
00223     _depura("END Inventario::setfechainventario", 0);
00224 }

void Inventario::setnominventario ( QString  val  ) 

Parameters:
val 

Definition at line 231 of file inventario.cpp.

References _depura(), and DBRecord::setDBvalue().

Referenced by InventarioView::on_mui_aceptar_clicked(), and InventarioView::on_mui_guardar2_clicked().

00231                                              {
00232     _depura("Inventario::setnominventario", 0);
00233     setDBvalue("nominventario", val);
00234     _depura("END Inventario::setnominventario", 0);
00235 }

void Inventario::vaciaInventario (  ) 

Definition at line 81 of file inventario.cpp.

References _depura(), and DBRecord::DBclear().

00081                                  {
00082     _depura("Inventario::vaciaInventario", 0);
00083     DBclear();
00084     _depura("END Inventario::vaciaInventario", 0);
00085 }

Field Documentation

ListControlStockView* Inventario::listalineas [protected]

Definition at line 38 of file inventario.h.

Referenced by borrar(), cargar(), getlistalineas(), guardar(), pregenerar(), setidinventario(), and setListControlStock().

Company* Inventario::companyact [protected]

Definition at line 39 of file inventario.h.

Referenced by borrar(), cargar(), guardar(), imprimirInventario(), Inventario(), InventarioView::sacaWindow(), and setListControlStock().

The documentation for this class was generated from the following files:
Generated on Sat Dec 15 00:01:55 2007 for BulmaGes by  doxygen 1.5.1