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); } } }