Expand Up @@ -1162,29 +1162,34 @@ public function manageCustomRoutes() break;
default: if ($webEntryProperties->webentryRouteConfig->firstUrlSegment !== '') { $webentryRouteConfig = $webEntryProperties->webentryRouteConfig; try { WebentryRoute::updateOrCreate( [ 'process_id' => $this->id, 'node_id' => $webentryRouteConfig->nodeId, ], [ 'first_segment' => $webentryRouteConfig->firstUrlSegment, 'params' => $webentryRouteConfig->parameters, ] ); } catch (\Exception $e) { \Log::info('*** Error: ' . $e->getMessage()); } } $this->manageWebentryRoute($webEntryProperties); break; } } } }
private function manageWebentryRoute($webEntryProperties) { if ($webEntryProperties->webentryRouteConfig->firstUrlSegment !== '') { $webentryRouteConfig = $webEntryProperties->webentryRouteConfig; try { WebentryRoute::updateOrCreate( [ 'process_id' => $this->id, 'node_id' => $webentryRouteConfig->nodeId, ], [ 'first_segment' => $webentryRouteConfig->firstUrlSegment, 'params' => $webentryRouteConfig->parameters, ] ); } catch (Exception $e) { \Log::info('*** Error: ' . $e->getMessage()); } } }
/** * Get node element attributes * Expand Down Expand Up @@ -1250,7 +1255,7 @@ private function getStartEventPermissions(User $user) /** * Process events relationship. * * @return \ProcessMaker\Models\ProcessEvents * @return ProcessEvents */ public function events() { Expand Down Expand Up @@ -1287,7 +1292,7 @@ public function launchpad() /** * Assignments of the process. * * @return \Illuminate\Database\Eloquent\Relations\HasMany * @return HasMany */ public function assignments() { Expand Down Expand Up @@ -1616,7 +1621,7 @@ private function validateSchema(BpmnDocument $document) private function deleteUnusedCustomRoutes($url, $processId, $nodeId) { // Delete unused custom routes $customRoute = webentryRoute::where('process_id', $processId)->where('node_id', $nodeId)->first(); $customRoute = WebentryRoute::where('process_id', $processId)->where('node_id', $nodeId)->first(); if ($customRoute) { $customRoute->delete(); } Expand Down Expand Up @@ -1751,9 +1756,9 @@ public function scopeFilter($query, $filterStr) ->orWhere('processes.description', 'like', $filter) ->orWhere('processes.status', '=', $filterStr) ->orWhereHas('user', function ($query) use ($filter) { $query->where('firstname', 'like', $filter) ->orWhere('lastname', 'like', $filter); }) $query->where('firstname', 'like', $filter) ->orWhere('lastname', 'like', $filter); }) ->orWhereIn('processes.id', function ($qry) use ($filter) { $qry->select('assignable_id') ->from('category_assignments') Expand Down Expand Up @@ -1797,4 +1802,29 @@ public function hasAlternative() { return true; }
public function scopeOrderByRecentRequests($query) { return $query->orderByDesc( ProcessRequest::select('id') // User has participated ->whereHas('tokens', function ($q) { $q->where('user_id', Auth::user()->id); }) ->whereColumn('process_id', 'processes.id') ->orderByDesc('id') // using ID because created_at is not indexed ->limit(1) ); }
public function scopeWithRequestCount($query) { return $query->withCount(['requests' => function ($query) { return $query->where('status', 'ACTIVE') // User has participated ->whereHas('tokens', function ($q) { $q->where('user_id', Auth::user()->id); }); }]); } }