public function files($job)
{
$find = Filessearch::where('jobid', '=', $job)->get();
$find = $find->toArray();
if (empty($find)) {
$filessearch = new Filessearch();
$files = Files::select(array($this->tables['path'] . '.path', $this->tables['filename'] . '.name as filename', 'jobid'))->join($this->tables['filename'], $this->tables['file'] . '.filenameid', '=', $this->tables['filename'] . '.filenameid')->join($this->tables['path'], $this->tables['file'] . '.pathid', '=', $this->tables['path'] . '.pathid')->where('jobid', '=', $job)->remember(10)->get();
// ->where('jobid','=', $job);
$files = $files->toArray();
if (!empty($files)) {
foreach (array_chunk($files, 1000) as $chunked_files) {
$t = Filessearch::insert($chunked_files);
}
}
//$filessearch->getConnection()->insert("INSERT INTO ".($filessearch->getTable())." (path, filename, jobid) ".$files->toSql(), array($job));
}
/* Mostra o log do Job */
$logs = Logs::select(array('logtext'))->where('jobid', '=', $job)->get();
$logs2 = "";
foreach ($logs as $log) {
$logs2[] = preg_replace("/[\t\n]+/", '</br>', $log->logtext);
}
//////
$files = Filessearch::select(array('path', 'filename'))->where('jobid', '=', $job)->orderBy('path', 'asc');
$files = $files->get();
//->toArray();
//$files="";
if (empty($files)) {
foreach ($files as $file) {
$ficheiro[$file->path . $file->name] = '';
}
$tree = $this->explodeTree($ficheiro, "/");
$tree = $this->recursion($tree);
} else {
$tree = "";
}
// $menu = $this->recursion($tree);
return View::make('files', array('jobid' => $job, 'logs' => implode($logs2), 'menu' => $menu = $tree));
}
public function showoneAction()
{
$user = $this->session->getCurrentUser();
if (is_null($this->request->getProperty('id'))) {
throw new \Exception('Страница не найдена!');
}
$id = (int) $this->request->getProperty('id');
$tasksModel = new Tasks();
$this->view->task = $tasksModel->getOneMyTask($user, $id);
$this->view->user = $user;
$timelineModel = new Timeline();
$seconds = $timelineModel->getTimeSumByTask($id);
$hours = floor($seconds / 3600);
$mins = floor(($seconds - $hours * 3600) / 60);
$this->view->timesum = $hours . ' часов ' . $mins . ' минут';
$taskstatusModel = new Taskstatus();
$this->view->statuses = $taskstatusModel->select();
$filesModel = new Files();
$filesModel->setWhere(array('tasks_id' => $id));
$this->view->files = $filesModel->select();
}
