/**
* count the number of local author that joins monthly
* @param Integer $month month number
* @param Integer $year year
*
* @return Integer
*/
public function countMonthlyJoinedLocalAuthor($month, $year)
{
$isLocalAuthor = $this->constants->get('LOCAL_AUTHOR');
$sql = "SELECT count(author.id) FROM local_author author WHERE MONTH(author.date_joined) = {$month} AND YEAR(author.date_joined) = {$year} AND ( author.is_local_author = 1 )";
$stmt = $this->connection->prepare($sql);
$stmt->execute();
$count = $stmt->fetch(PDO::FETCH_NUM);
return $count[0];
}
/**
* Saves the posted review for local author
* @return Array
*/
public function saveLocalAuthorReview()
{
// $status = $this->constants->get('unviewed_review');
$status = $this->constants->get('approved_review');
$content = trim($this->params['content']);
$localAuthorId = $this->params['local_author'];
$localAuthor = $country = $this->entityManager->find('BugglMainBundle:LocalAuthor', $localAuthorId);
if (is_null($localAuthor)) {
return array('sucess' => false);
}
$reviewer = $this->securityContext->getToken()->getUser();
$review = new \Buggl\MainBundle\Entity\LocalAuthorReview();
$review->setReviewer($reviewer)->setContent($content)->setDateAdded(new \DateTime(date('Y-m-d H:i:s', time())))->setStatus($status)->setLocalAuthor($localAuthor);
$this->entityManager->persist($review);
$this->entityManager->flush();
return array('success' => true, 'review' => $review);
}
