/**
* Create a new ConsumerExperience if not exist else update
* @param String $objConEx: a json object containing info of ConsumerExperience
*/
public static function updateConsumerExperience($objConEx)
{
$response = array();
$conEx = array();
try {
$rs = SharcConsumerExperience::where('userId', $objConEx['userId'])->where('experienceId', $objConEx['experienceId'])->get();
if ($rs->count() == 0) {
//Not exists -> add a new row
$conEx = SharcConsumerExperience::create(array('userId' => $objConEx['userId'], 'experienceId' => $objConEx['experienceId'], 'lastVisitedDate' => date('Y-m-d')));
} else {
//exists -> update lastLogin and generate new apiKey
$conEx = $rs[0];
$conEx->lastVisitedDate = date('Y-m-d');
}
$result = $conEx->save();
if ($result) {
//= 1 success
$response["status"] = SUCCESS;
$response["data"] = $conEx->toArray();
} else {
//error
$response["status"] = ERROR;
$response["data"] = INTERNAL_SERVER_ERROR;
}
} catch (Exception $e) {
$response["status"] = ERROR;
$response["data"] = Utils::getExceptionMessage($e);
}
return $response;
}
/**
* Get experiences consumed by a user
* @param String $id: id of the user
*/
public static function getExperienceOfConsumer($id)
{
$response = array();
$experiences = array();
try {
$response["status"] = SUCCESS;
if ($id == ADMIN_ID) {
//admin
$experiences = SharcConsumerExperience::all();
} else {
$experiences = SharcConsumerExperience::where('userId', $id)->get();
}
$i = 0;
for ($i = 0; $i < $experiences->count(); $i++) {
//echo SharcExperience::find($experiences[$i]->experienceId)->toJson();
$experiences[$i] = SharcExperience::find($experiences[$i]->experienceId);
}
$response["data"] = $experiences->toArray();
} catch (Exception $e) {
$response["status"] = ERROR;
$response["data"] = Utils::getExceptionMessage($e);
}
return $response;
}
