public function getIncidents()
{
$incidents = ITP::select(['ID', 'Title', 'ReportingOrg', 'ImpactDescription', 'BriefDescription', 'IncidentLevel', 'Date', 'Section', 'IncidentOwner', 'Engineer', 'IncidentStatus']);
$datatables = Datatables::of($incidents)->editColumn('BriefDescription', function ($incident) {
return '
<div class="text-semibold"><a href="./incident/' . $incident->ID . '/edit">' . str_limit($incident->Title, 40) . '</a></div>
<div class="text-muted">' . str_limit($incident->BriefDescription, 80) . '</div>
';
})->removeColumn('Title');
if ($months = $datatables->request->get('months')) {
$datatables->where(function ($query) use($months) {
foreach ($months as $month) {
$query->orWhereRaw('MONTH(Date) = ' . $month);
}
});
}
if ($quarters = $datatables->request->get('quarters')) {
$datatables->where(function ($query) use($quarters) {
foreach ($quarters as $quarter) {
$query->orWhereRaw('MONTH(Date) = ' . $quarter);
}
});
}
if ($years = $datatables->request->get('years')) {
$datatables->where(function ($query) use($years) {
foreach ($years as $year) {
$query->orWhereRaw('YEAR(Date) = ' . $year);
}
});
}
return $datatables->make(true);
}
public function time()
{
$timeString = ITP::select('ID', 'ImpactDuration')->get();
foreach ($timeString as $time) {
preg_match('([a-Z])', $time->ImpactDuration, $matches);
echo $time->ID . " ";
// print_r($matches);
echo filter_var($time->ImpactDuration, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
echo " ";
print_r($matches);
echo "<br>";
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
ITP::where('ID', $id)->update($request->except(['_method', '_token']));
$json['header'] = "Updated";
$json['message'] = "The record was updated in the database";
return json_encode($json);
}
