<?php

/**
 * Subclass for performing query and update operations on the 'invoice_customer' table.
 *
 * 
 *
 * @package lib.model
 */ 
class InvoiceCustomerPeer extends BaseInvoiceCustomerPeer
{
	public static function getTotalConsumption($customerid)
	{
		$c = new Criteria();
		$c->clearSelectColumns()->addSelectColumn('SUM('.InvoiceReadingPeer::CONSUMPTION.')');
		$c->add(self::CUSTOMER_ID,$customerid);
		
		$c->addJoin(self::INVOICE_ID,InvoicePeer::ID);
		$c->addJoin(InvoicePeer::ID,InvoiceReadingPeer::INVOICE_ID);
		$c->add(InvoicePeer::IS_CANCELED,0);
		$c->addGroupByColumn(self::CUSTOMER_ID);
		$rs = self::doSelectRS($c);
		$cons = 0;
		while($rs->next())
		{
			$cons = $rs->getFloat(1);
		}
		return $cons;
	}
	
}