<?php

/**
 * TopJobPriceTable
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class TopJobPriceTable extends Doctrine_Table
{
    /**
     * Returns an instance of this class.
     *
     * @return object TopJobPriceTable
     */
    public static function getInstance()
    {
        return Doctrine_Core::getTable('TopJobPrice');
    }

    public function getPrices()
    {
        return $this->createQuery()->orderBy('days_min ASC')->execute();
    }

    public function getPriceOneForDays($value)
    {
        foreach($this->getPrices() as $price)
        {
            if($price->getDaysMin() >= $value)
            {
                return $price->getPriceDay();
            }
        }

        return 0;
    }

    public function getPriceAllForDays($value)
    {
        foreach($this->getPrices() as $price)
        {
            if($price->getDaysMin() >= $value)
            {
                return $price->getPriceDay() * $value;
            }
        }

        return 0;
    }
}