public function executeGetSubject()
{
$input = $this->getRequestParameter('subject');
$sql = "select * from subject where concat(code, ' - ', name) like '%{$input}%'";
$connection = Propel::getConnection();
$statement = $connection->createStatement();
$result = $statement->executeQuery($sql, ResultSet::FETCHMODE_NUM);
$db_results = SubjectPeer::populateObjects($result);
$results = array();
foreach ($db_results as $row) {
#$results[ $row->getId() ] = $row->toString();
$results[$row->getId()] = $row->getName() . ' - ' . $row->getDepartment()->toString();
}
$this->results = $results;
}
public static function doSelect(Criteria $criteria, $con = null)
{
return SubjectPeer::populateObjects(SubjectPeer::doSelectRS($criteria, $con));
}
