/**
* [getReqDataByKeywork description]
* @param [type] $keyword [description]
* @param [type] $req_type [description]
* @param [type] $perPage [description]
* @return [type] [description]
*/
public function getReqDataByKeywork($keyword, $perPage)
{
if ($keyword != 'all') {
$reqdata = RequestData::whereRaw('data.data_name like ? or agency.tname like ? or usernhc.fname like ? or v_user_info.role_name like ?', array('%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%', '%' . $keyword . '%'))->join('agency', 'agency.code', '=', 'request_data.agency_code')->join('data', 'data.id', '=', 'request_data.data_id')->join('condition', 'condition.id', '=', 'request_data.cond_id')->join('usernhc', 'usernhc.id', '=', 'request_data.send_userid')->join('v_user_info', 'v_user_info.user_id', '=', 'usernhc.id')->select('agency.tname as agency_name', 'data.data_name', 'condition.cond_name', 'request_data.req_status', 'usernhc.fname', 'usernhc.lname', 'v_user_info.role_name', 'request_data.send_agencyid', 'request_data.created_at', 'request_data.id', 'request_data.downloaded', 'request_data.req_type')->orderBy('request_data.downloaded', 'asc')->paginate($perPage);
} else {
$reqdata = RequestData::join('agency', 'agency.code', '=', 'request_data.agency_code')->join('data', 'data.id', '=', 'request_data.data_id')->join('condition', 'condition.id', '=', 'request_data.cond_id')->join('usernhc', 'usernhc.id', '=', 'request_data.send_userid')->join('v_user_info', 'v_user_info.user_id', '=', 'usernhc.id')->select('agency.tname as agency_name', 'data.data_name', 'condition.cond_name', 'request_data.req_status', 'usernhc.fname', 'usernhc.lname', 'v_user_info.role_name', 'request_data.send_agencyid', 'request_data.created_at', 'request_data.id', 'request_data.downloaded', 'request_data.req_type')->orderBy('request_data.downloaded', 'asc')->paginate($perPage);
}
return $reqdata;
}
