public function getDataTable()
{
$moo = LotDef::where('map_id', 2)->pluck('id')->toArray();
$lotinfos = collect(LotInfo::whereIn('lot_id', $moo)->get(array('lot_num', 'lot_name', 'status_id', 'critical_issue_flag', 'build_type_id', 'notes', 'builder_date', 'adjust_date_to', 'created_at', 'verify_no_update', 'user_id')));
$lotinfos = $lotinfos->sortByDesc('created_at');
$lotinfos = $lotinfos->unique('lot_num');
$lotinfos = $lotinfos->values();
return Datatable::collection($lotinfos)->showColumns('lot_num', 'lot_name')->addColumn('status_id', function ($model) {
return $model->statusdef->label;
})->showColumns('critical_issue_flag')->addColumn('build_type_id', function ($model) {
return $model->buildtype->label;
})->showColumns('notes', 'builder_date', 'adjust_date_to', 'created_at', 'verify_no_update')->addColumn('user_id', function ($model) {
return $model->user->name;
})->searchColumns('lot_num')->orderColumns('lot_num')->make();
}
public function index()
{
$data = LotInfo::all();
return view('reports.dgrid1');
}
public function alpha()
{
$lotmap = LotMap::latest()->get();
$lotdefs = LotDef::where('map_id', '=', 2)->get();
$lds = $lotdefs->select('id')->distinct()->pluck('id');
$lotinfos = LotInfo::whereIn('id', $lds);
// $lotinfos = LotInfo::all();
$statusdefs = StatusDef::where('build_type_id', '=', 3)->orderBy('order', 'DESC')->get();
//dd(compact('lotmap', 'lotdefs', 'lotinfos'));
return view('lot_master_alpha', compact('lotmap', 'lotdefs', 'lotinfos', 'statusdefs'));
}
