{{db("test_packages")->where("test_package_number", "<>", "")->count()}} / {{db("test_packages")->whereNotNull("test_date")->count()}}

{{e2("Test Packages")}}

whereNotNull('dr1.drawing_no') ->where('dr1.drawing_no', '<>', '') ->whereRaw('dr1.revision_no = ( SELECT MAX(dr2.revision_no) FROM document_revisions dr2 WHERE dr2.drawing_no = dr1.drawing_no )') ->where(function($q) { $q->where('dr1.discipline', 'LIKE', '%Piping%') ->orWhereNull('dr1.discipline'); }) ->count(); ?>

{{$currentRevisionsCount}} / {{apply_welded_filter(db("weld_logs"))->distinct()->count('iso_number')}}

{{e2("Isometry")}}

{{db("w_p_s")->count()}}

{{db("naks_welders")->distinct('welder_id')->count()}}

{{e2("Welder")}}

{{apply_welded_filter(db("weld_logs"))->count()}}

{{e2("Weld Logs")}}

{{setting("repairRateAll")}} %

{{e2("Repair Rate")}}

whereNull('repair_date')->count(); echo $nullRepairDateCount; ?>

{{e2("Repair QTY")}}

{{col("col-md-5","General Progress", 8)}}

@include("admin.dashboard.chart.general-progress")

{{_col()}} {{col("col-md-7","Progress", 6)}} @include("admin.dashboard.chart.monthly-progress") {{_col()}} {{col("col-md-6","Spool Status", 5)}} @include("admin.type.spool-release.spool-list-chart") {{_col()}} {{col("col-md-6","NDT Backlog", 10)}} @include("admin.dashboard.chart.ndt-backlog") {{_col()}} {{col("col-md-6","Test Status", 11)}} @include("admin.dashboard.chart.test-status") {{_col()}} {{col("col-md-6","Punch Status", 12)}} @include("admin.dashboard.chart.punch-status") {{_col()}}