public function findAll($recruitID)
{
$sql = "select * from rfollow join user on rfollow.userID = user.userID where recruitID={$recruitID} ";
// echo $sql;
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
// foreach ($result as $row){
// Debug::dump($row);
// }
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new WHydrateResultset($this->hydrator, $this->rfollowPrototype, $this->prototypeArr);
$tmp = $resultSet->initialize($result);
// foreach ($resultSet as $row){
// Debug::dump($row);
// }
return $tmp;
}
return array();
}
public function findAll($secID, $ptype, $schID)
{
$sql = "select * from page ";
$sql = $sql . " join user on page.userID=user.userID ";
$sql = $sql . "where ";
if ($secID != 0) {
$sql = $sql . " secID={$secID} ";
if ($ptype != 0) {
$sql = $sql . ' and ';
}
}
if ($ptype != 0) {
$sql = $sql . " ptype={$ptype} ";
}
if ($ptype != 0 || $secID != 0) {
$sql = $sql . ' and ';
}
if ($schID != 0) {
$sql = $sql . '(pallow=1 or (pallow=0 and schID=' . $schID . ' ))';
} else {
$sql = $sql . '(pallow=1)';
}
// echo $sql;
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
// foreach ($result as $row){
// Debug::dump($row);
// }
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new WHydrateResultset($this->hydrator, $this->pagePrototype, $this->prototypeArr);
$tmp = $resultSet->initialize($result);
// foreach ($resultSet as $row){
// Debug::dump($row);
// }
return $tmp;
}
return array();
}
public function findRec()
{
if (WAuthUtil::get_auth() !== null) {
$userId = WAuthUtil::get_auth()->userID;
$sql = "select page.*,predictRating,user.* from (recs join page on recs.pageId = page.pageID)join user on recs.userId = user.userId where \n recs.userId = {$userId} and predictRating <> 0 order by predictRating desc";
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new WHydrateResultset($this->hydrator, $this->pagePrototype, $this->prototypeArr);
$tmp = $resultSet->initialize($result);
// foreach ($resultSet as $row){
// Debug::dump($row);
// }
return $tmp;
}
throw new \InvalidArgumentException("Forum with given ID:{$id} not found.");
} else {
return null;
}
}
public function findSimi($userId)
{
$sql = "select user.userID userID,username,recruitID,rtitle,faceimgpath from (recfris join recruit on recfris.friendId = recruit.userID) \n join user on recfris.friendId = user.userID\n where recfris.userId = {$userId} \n order by simi desc";
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
// foreach ($result as $row){
// Debug::dump($row);
// }
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new WHydrateResultset($this->hydrator, $this->recruitPrototype, $this->prototypeArr);
$tmp = $resultSet->initialize($result);
// foreach ($resultSet as $row){
// Debug::dump($row);
// }
return $tmp;
}
return array();
}