<?php

define_class(__FILE__, 'App_Location_Invoice_Admin_Obj');

require_once('app/Invoice/AbstractObj.php');

class App_Location_Invoice_Admin_Obj extends App_Invoice_AbstractObj
{
    var $delMethod  = DB_OBJ_DEL_METHOD_LOGICAL;
    var $fileFields = array('attachment');
    var $ownersName = 'locations';
    protected $_objectReferenceField = 'id_location';
    var $_filterFields = array(
        '`Invoice`.`number`', 
        '`Location`.`nrds_id`',
        '`Location`.`name`'
    );
    
    function _getWhat4Grid($opt = array())
	{
        $sql = parent::_getWhat4Grid($opt);
        $sql .= ", `Location`.`name` AS `location_name`";
        return $sql;
	}
    
    function _getJoin4Grid()
	{
        $sql = '';
        $sql .= 'JOIN `' . $this->db->tblLocation . '` AS `Location` '
              . 'ON `Location`.`id` = `' . $this->tableName . '`.`id_location`';
		return $sql;
	}
    
    function getTotalAmountDue()
    {
        $sql = 'SELECT SUM(`' . $this->tableName . '`.`amount`) '
             . 'FROM `' . $this->tableNameDB . '` AS `' . $this->tableName . '` '
             . $this->_getJoin4Grid() . ' '
             . 'WHERE 1 AND `' . $this->tableName . '`.`paid` = \'n\'';
        $sql .= $this->_getWhereDeleted();
        $filter = array_intersect_key($this->_filter, array_fill_keys(array('id_member', 'id_location'), ''));
        $sql .= $this->_getWhereFilter($filter);
        $res = $this->db->queryOne($sql);
        $this->isDBError($res);
        return $res;
    }
    
    function getAmountOverdue()
    {
        $sql = 'SELECT SUM(`' . $this->tableName . '`.`amount`) '
             . 'FROM `' . $this->tableNameDB . '` AS `' . $this->tableName . '` '
             . $this->_getJoin4Grid() . ' '
             . 'WHERE 1 AND `' . $this->tableName . '`.`paid` = \'n\'';
        $sql .= ' AND `' . $this->tableName . '`.`date_due` < CURRENT_DATE()';
        $sql .= $this->_getWhereDeleted();
        $filter = array_intersect_key($this->_filter, array_fill_keys(array('id_member', 'id_location', 'id_member_or_location'), ''));
        $sql .= $this->_getWhereFilter($filter);
        $res = $this->db->queryOne($sql);
        $this->isDBError($res);
        return $res;
    }
}