PromedioView Class Reference

#include <promedioview.h>

Inheritance diagram for PromedioView:

Public Member Functions
	PromedioView (Company *emp, QWidget *parent=0)
	~PromedioView ()
Company *	companyact ()
int	cargar (QString)
Private Attributes
Company *	m_companyact

---

Detailed Description

Definition at line 32 of file promedioview.h.

---

Constructor & Destructor Documentation

PromedioView::PromedioView	(	Company *	comp,
		QWidget *	parent = 0
	)

Parameters:

	comp
	parent

Definition at line 34 of file promedioview.cpp.

References _depura(), m_companyact, and Ui_PromedioBase::setupUi().

        : QWidget(parent) ,dialogChanges(this), DBRecord(comp) {
    _depura("PromedioView::INIT_constructor()", 0);
    setAttribute(Qt::WA_DeleteOnClose);
    m_companyact = comp;
    setupUi(this);
    _depura("PromedioView::END_constructor()", 0);
}

PromedioView::~PromedioView

(

)

Definition at line 47 of file promedioview.cpp.

References _depura(), m_companyact, and EmpresaBase::sacaWindow().

                            {
    _depura("PromedioView::INIT_destructor()\n", 0);
    m_companyact->sacaWindow(this);
    _depura("PromedioView::END_destructor()\n", 0);
}

---

Member Function Documentation

Company* PromedioView::companyact

(

)

[inline]

Definition at line 41 of file promedioview.h.

References m_companyact.

                          {
        return m_companyact;
    };

int PromedioView::cargar

(

QString

idarticulo

)

[virtual]

Parameters:

idarticulo

Returns:

Reimplemented from DBRecord.

Definition at line 63 of file promedioview.cpp.

References _depura(), postgresiface2::cargacursor(), cursor2::eof(), m_companyact, Ui_PromedioBase::mui_avgcompras, Ui_PromedioBase::mui_avgventas, Ui_PromedioBase::mui_mayorcompras, Ui_PromedioBase::mui_mayorventas, Ui_PromedioBase::mui_menorcompras, Ui_PromedioBase::mui_menorventas, Ui_PromedioBase::mui_totalcompras, Ui_PromedioBase::mui_totalventas, Ui_PromedioBase::mui_undavgcompras, Ui_PromedioBase::mui_undavgventas, Ui_PromedioBase::mui_undcompras, Ui_PromedioBase::mui_undmayorcompras, Ui_PromedioBase::mui_undmayorventas, Ui_PromedioBase::mui_undmenorcompras, Ui_PromedioBase::mui_undmenorventas, Ui_PromedioBase::mui_undventas, and cursor2::valor().

Referenced by ArticuloView_cargar().

                                           {
    _depura("PromedioView::cargar(" + idarticulo + ")", 0);

    cursor2 *cur = m_companyact->cargacursor("SELECT sum(pvplalbaranp*cantlalbaranp)::NUMERIC(12,2) AS tot, sum(cantlalbaranp) as und, max(pvplalbaranp) AS mayor, min(pvplalbaranp) AS menor, avg(pvplalbaranp)::NUMERIC(12,2) AS media, max(cantlalbaranp) as undmayorcompras, min(cantlalbaranp) AS undmenorcompras, avg(cantlalbaranp)::NUMERIC(12,2) AS undavgcompras  FROM lalbaranp WHERE idarticulo=" + idarticulo);
    if (!cur->eof()) {
        mui_totalcompras->setText(cur->valor("tot"));
        mui_mayorcompras->setText(cur->valor("mayor"));
        mui_menorcompras->setText(cur->valor("menor"));
        mui_avgcompras->setText(cur->valor("media"));
        mui_undcompras->setText(cur->valor("und"));
        mui_undmayorcompras->setText(cur->valor("undmayorcompras"));
        mui_undmenorcompras->setText(cur->valor("undmenorcompras"));
        mui_undavgcompras->setText(cur->valor("undavgcompras"));
    } // end if
    delete cur;


    cursor2 *cur1 = m_companyact->cargacursor("SELECT sum(pvplalbaran*cantlalbaran)::NUMERIC(12,2) AS tot, sum(cantlalbaran) as und, max(pvplalbaran) AS mayor, min(pvplalbaran) AS menor, avg(pvplalbaran)::NUMERIC(12,2) AS media, max(cantlalbaran) as undmayorventas, min(cantlalbaran) AS undmenorventas, avg(cantlalbaran)::NUMERIC(12,2) AS undavgventas  FROM lalbaran WHERE idarticulo=" + idarticulo);
    if (!cur1->eof()) {
        mui_totalventas->setText(cur1->valor("tot"));
        mui_mayorventas->setText(cur1->valor("mayor"));
        mui_menorventas->setText(cur1->valor("menor"));
        mui_avgventas->setText(cur1->valor("media"));
        mui_undventas->setText(cur1->valor("und"));
        mui_undmayorventas->setText(cur1->valor("undmayorventas"));
        mui_undmenorventas->setText(cur1->valor("undmenorventas"));
        mui_undavgventas->setText(cur1->valor("undavgventas"));
    } // end if
    delete cur1;

    _depura("END PromedioView::cargar()", 0);
    return 0;
}

---

Field Documentation

Company* PromedioView::m_companyact [private]

Definition at line 36 of file promedioview.h.

Referenced by cargar(), companyact(), PromedioView(), and ~PromedioView().

---

The documentation for this class was generated from the following files:

• bulmafact/plugins/pluginpromedios/promedioview.h
• bulmafact/plugins/pluginpromedios/promedioview.cpp

---