public static function getAll($desc_id = null, $choice_id = null, $tra_id = null, $option_status = null)
{
$qb = self::getQbBase();
if ($desc_id) {
$qb->andWhere('o.fk_desc_id = :desc_id')->setParameter('desc_id', $desc_id);
}
if ($choice_id) {
$qb->andWhere('o.fk_choice_id = :choice_id')->setParameter('choice_id', $choice_id);
}
if ($tra_id) {
$qb->andWhere('o.payutc_tra_id = :tra_id')->setParameter('tra_id', $tra_id);
}
if ($option_status) {
$qb->andWhere('o.option_status = :option_status')->setParameter('option_status', $option_status);
}
$ret = array();
foreach ($qb->execute()->fetchAll() as $data) {
$opt = new Option();
$opt->bind($data);
$ret[] = $opt;
}
return $ret;
}
