leadsWithTrashed()->whereRaw($dateWhere)->groupBy('entrypoint')->get(array(DB::raw('COUNT(id) as cntAll, SUM((CASE WHEN (deleted_at IS NULL) THEN 1 ELSE 0 END)) as cntIsNew, SUM((CASE WHEN (isbad != 1 AND deleted_at IS NOT NULL) THEN 1 ELSE 0 END)) as cntIsOk, entrypoint as name'))); ?>

Проект	Новые	В работе	Всего
name; ?> name): ?>    name; ?>    —	leads()->whereRaw($dateWhere)->count(); ?> cntIsNew; ?>	leadsWithTrashed()->whereIsbad(0)->whereNotNull('deleted_at')->whereRaw($dateWhere)->count(); ?> cntIsOk; ?>	leadsWithTrashed()->whereRaw($dateWhere)->count(); $projectdiff = $projectLeadCnt - $project->leads()->whereRaw('TIME(created_at)count(); ?> 0): ?>+ cntAll - $entrypoint->getBeforeCnt($project->id, $entrypoint->name, $date); ?> cntAll; ?>0): ?>+