public function getPrice($pricelist_id, $date, $qty = null) { $price = array('price' => 0, 'currency' => 'CNY'); $res = $this->fetchAll("pricelist_id = " . $pricelist_id . " and date <= '" . $date . "'", array("date desc")); if ($res->count() > 0) { $data = $res->toArray(); if ($qty) { $ladder_qty = new Erp_Model_Warehouse_Ladderqty(); $price_ladder_qty = $ladder_qty->getPrice($data[0]['id'], $qty); if ($price_ladder_qty['price'] > 0) { $price = $price_ladder_qty; } else { $price['price'] = $data[0]['price']; $price['currency'] = $data[0]['currency']; } } else { $price['price'] = $data[0]['price']; $price['currency'] = $data[0]['currency']; } } return $price; }