Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/public_html/admin1/app/Traits/ |
Upload File : |
<?php
namespace App\Traits;
use App\Models\ContractSign;
use App\Models\Invoice;
use App\Models\Payment;
use App\Models\Project;
use App\Models\ProjectMilestone;
use App\Models\ProjectStatusSetting;
use App\Models\User;
use Illuminate\Support\Facades\DB;
/**
*
*/
trait ClientPanelDashboard
{
/**
* XXXXXXXXXXX
*
* @return \Illuminate\Http\Response
*/
public function clientPanelDashboard()
{
$viewInvoicePermission = user()->permission('view_invoices');
$this->modules = user_modules();
$this->counts = User::select(
DB::raw('(select count(projects.id) from `projects` where client_id = ' . $this->user->id . ' and deleted_at IS NULL and projects.company_id = '. company()->id .') as totalProjects'),
DB::raw('(select count(tickets.id) from `tickets` where (status="open" or status="pending") and user_id = ' . $this->user->id . ' and tickets.company_id = '. company()->id .' and deleted_at IS NULL) as totalUnResolvedTickets')
)
->first();
// Invoices paid
$this->totalPaidInvoice = Invoice::where(function ($query) {
$query->where('invoices.status', 'paid');
})
->where('invoices.client_id', user()->id)
->where('invoices.send_status', 1)
->where('invoices.credit_note', 0)
->select(
'invoices.id'
);
if ($viewInvoicePermission == 'added') {
$this->totalPaidInvoice = $this->totalPaidInvoice->where('invoices.added_by', user()->id);
}
$this->totalPaidInvoice = $this->totalPaidInvoice->count();
// Total Pending invoices
$this->totalUnPaidInvoice = Invoice::where(function ($query) {
$query->where('invoices.status', 'unpaid')
->orWhere('invoices.status', 'partial');
})
->where('invoices.client_id', user()->id)
->where('invoices.send_status', 1)
->where('invoices.credit_note', 0)
->select(
'invoices.id'
);
if ($viewInvoicePermission == 'added') {
$this->totalUnPaidInvoice = $this->totalUnPaidInvoice->where('invoices.added_by', user()->id);
}
$this->totalUnPaidInvoice = $this->totalUnPaidInvoice->count();
$this->totalContractsSigned = ContractSign::whereHas('contract', function ($query) {
$query->where('client_id', user()->id);
})->count();
$this->pendingMilestone = ProjectMilestone::with('project', 'currency')
->whereHas('project', function ($query) {
$query->where('client_id', user()->id);
})
->get();
$this->statusWiseProject = $this->projectStatusChartData();
return view('dashboard.client.index', $this->data);
}
public function projectStatusChartData()
{
$labels = ProjectStatusSetting::where('status', 'active')->pluck('status_name');
$data['labels'] = ProjectStatusSetting::where('status', 'active')->pluck('status_name');
$data['colors'] = ProjectStatusSetting::where('status', 'active')->pluck('color');
$data['values'] = [];
foreach ($labels as $label) {
$data['values'][] = Project::where('client_id', user()->id)->where('status', $label)->count();
}
return $data;
}
}