public function run($id, $offset = 0)
{
$reportTask = ReportTask::builder()->find($id);
// run task
$response = Cron::executeReportTask($reportTask, 'download');
if (!$response) {
return redirect()->route($this->routeSuffix, $offset)->with(['msg' => 2, 'txtMsg' => trans('pulsar::pulsar.message_error_has_not_results', ['name' => $reportTask->subject_023])]);
} else {
return redirect()->route($this->routeSuffix, $offset)->with(['msg' => 1, 'txtMsg' => trans('pulsar::pulsar.action_successful', ['name' => $reportTask->subject_023])]);
}
}
public function downloadAReportTask(Request $request)
{
// get parameters from url route
$parameters = $request->route()->parameters();
$reportTask = ReportTask::builder()->find(Crypt::decrypt($parameters['token']));
$filename = Crypt::decrypt($parameters['filename']);
if ($reportTask === null) {
abort(404);
}
return response()->download(storage_path('exports') . '/' . $filename . '.' . $reportTask->extension_file_023);
}
public function testing()
{
$reportTasks = ReportTask::builder()->get();
foreach ($reportTasks as $reportTask) {
// Execute query from report task
$response = DB::select(DB::raw($reportTask->sql_023));
// if has results from query
if (count($response) === 0) {
dd('no hay resultados');
}
// format response to manage with collections
$response = collect(array_map(function ($item) {
return $item;
}, $response));
dd($response);
}
}
/**
* Function to manage reports task to delivery
*
* @return null
*/
public static function checkReportTaskDelivery()
{
// get report tasks
$reportTasks = ReportTask::builder()->get();
foreach ($reportTasks as $reportTask) {
// check if report task has to be executed
if ($reportTask->next_run_023 != null && $reportTask->next_run_023 < date('U')) {
self::executeReportTask($reportTask);
}
}
}
