public function GetHistoryCalls($model, $userID)
{
$checkUserrole = Common::UserRoles($userID);
$ServiceResponse = new ServiceResponse();
$LastIndex = 0;
$PageSize = 10;
$LastIndex = !empty($model->LastID) ? $model->LastID : $LastIndex;
$PageSize = !empty($model->PageSize) ? $model->PageSize : $PageSize;
$where = '1=1';
if (!empty($model->SearchText)) {
$where = "( and Script Like '%" . $model->SearchText . "%' OR InitiatingPrice Like '%" . $model->SearchText . "%' OR T1 Like '%" . $model->SearchText . "%' OR T2 Like '%" . $model->SearchText . "%' OR SL Like '%" . $model->SearchText . "%')";
}
if ($checkUserrole->RoleID == Constants::$RoleAdmin) {
$vwCallListEntity = vwCallListEntity::orderBy('UpdatedDate', Constants::$SortIndexDESC)->where("SegmentID", $model->SegmentID)->where('IsOpen', Constants::$Value_False)->whereRaw($where)->skip($LastIndex)->take($PageSize)->get();
} else {
$calIDs = DB::table('usercalls')->where('UserID', $userID)->lists('CallID');
if ($calIDs && count($calIDs) > 0) {
$vwCallListEntity = vwCallListEntity::orderBy('UpdatedDate', Constants::$SortIndexDESC)->where("SegmentID", $model->SegmentID)->where('IsOpen', Constants::$Value_False)->whereRaw($where)->whereIn('CallID', $calIDs)->skip($LastIndex)->take($PageSize)->get();
} else {
$vwCallListEntity = array();
}
}
if (count($vwCallListEntity) > 0) {
foreach ($vwCallListEntity as $vwCallList) {
$vwCallList->T1 = $vwCallList->T1 . '';
$vwCallList->T2 = $vwCallList->T2 . '';
$vwCallList->SL = $vwCallList->SL . '';
$vwCallList->InitiatingPrice = $vwCallList->InitiatingPrice . '';
$vwCallList->ResultID = $vwCallList->ResultID + 0;
$vwCallList->ResultName = $vwCallList->ResultName . '';
$vwCallList->ResultDescription = $vwCallList->ResultDescription ? $vwCallList->ResultDescription : '';
$vwCallList->ScriptName = $vwCallList->Script . '' . (!empty($vwCallList->Contract) ? ' (' . $vwCallList->Contract . ')' : '') . (!empty($vwCallList->SubSection) ? ' (' . $vwCallList->SubSection . ')' : '');
$vwCallList->Image = $vwCallList->Image ? asset(Constants::$Path_ScriptImages . $vwCallList->ScriptID . '/' . rawurlencode($vwCallList->Image)) : '';
$vwCallList->CreatedDate = date_format(date_create($vwCallList->CreatedDate), Constants::$DefaultDisplayDateTimeFormat);
}
}
$ServiceResponse->Data = array("CallList" => $vwCallListEntity);
$ServiceResponse->IsSuccess = TRUE;
return $ServiceResponse;
}