/**
* Method to fetch favorite record
*
* @param $favouriteBO
*/
public function getallfavourite($favouriteBO)
{
try {
$connection = new ConnectionManager();
$link = $connection->getConnection();
// select query for favourite table
$email_id = $favouriteBO->getEmailId();
$query = "SELECT tutorial_id FROM favourite WHERE email_id='{$email_id}' ORDER BY id ASC";
$result = mysql_query($query, $link) or die(mysql_error());
$favouritesArray = array();
while ($success = mysql_fetch_object($result)) {
$favourites = new FavouriteBO();
$favourites->setTutorialId($success->tutorial_id);
$favourites->getTutorialId();
//storing the objects in an array
$favouritesArray[] = $favourites;
}
return $favouritesArray;
//
} catch (Exception $e) {
throw new Exception("MESSAGE:" . $e->getMessage());
}
}
/**
* Method for fetching favourites
*
* @param email
* @return boolean
* @throws Exception
*/
public function getallfavourite()
{
try {
$data = json_decode($_REQUEST['data'], 'true');
$validArray = array('email_id' => '');
if (empty($data)) {
$error = array('status_code' => ERR_DATA_CODE, 'result_object' => '', 'status_message' => MSG_DATA_NOT_PROVIDED);
echo json_encode($error);
exit;
} else {
$this->checkData($validArray, $data);
$favouriteBL = new FavouriteBL();
$favouriteBO = new FavouriteBO();
$emailId = $data['email_id'];
$favouriteBO = new FavouriteBO();
$favouriteBO->setEmailId($emailId);
$success = $favouriteBL->getallfavourite($favouriteBO);
if (is_array($success) && count($success) > 0) {
foreach ($success as $favObject) {
$response['favourites'][]['tutorial_id'] = $favObject->getTutorialId();
}
$error = array('status_code' => ERRCODE_RESULT_SUCCESS, 'result_object' => $response, 'status_message' => MSG_RESULT_SUCCESS);
echo json_encode($error);
exit;
} else {
$response['favourites'] = $success;
$error = array('status_code' => ERRCODE_RESULT_SUCCESS, 'result_object' => $response, 'status_message' => MSG_RESULT_SUCCESS);
echo json_encode($error);
exit;
}
}
} catch (Exception $e) {
throw new Exception($e->getMessage());
}
}
