namespace App\Livewire\Dashboard; use Livewire\Component; use Illuminate\Support\Facades\DB; class ActiveCalls extends Component { public $calls = []; public function loadCalls() { // Query Realtime Asterisk channel info $this->calls = DB::select(" SELECT channel, callerid_num, connected_line_num, uniqueid, state, application, duration FROM channels WHERE state != 'Hangup' "); } public function mount() { $this->loadCalls(); } public function refresh() { $this->loadCalls(); } public function render() { return view('livewire.dashboard.active-calls'); } }