/** * */ public function postDataUploaded(Request $req, $db) { $page = 1; if ($req->get('page')) { $page = $req->get('page'); } $rows = 10; if ($req->get('rows')) { $rows = $req->get('rows'); } $Files = File::with('user', 'import')->skip($page)->where('db_table', $db)->take($rows)->paginate(); $rows = []; $i = 0; foreach ($Files as $file) { $rows[$i] = $file; // $rows[$i]['oleh']=$file['user']['email']; $i++; $rows[$i]['user.email'] = !empty($file->user) ? $file->user->email : 'tidak diketahui '; $rows[$i]['import.status_import'] = !empty($file->import) ? $file->import->status_import : 'Belum'; // dd($file->import->user->email); $rows[$i]['import.user.email'] = !empty($file->import->user->email) ? $file->import->user->email : 'Belum'; $i++; // $rows[$i]['import.users.email']=(!empty($file['import']) && !empty($file['import']['users_id']) )? $file['import']['status_import']: '----'; $i++; } $result['total'] = $Files->toArray()['total']; // $result['rows']=$entries->toArray()['data']; $result['rows'] = $rows; return json_encode($result); }
/** * */ public function postDataImported(Request $req, $db) { $page = 1; if ($req->get('page')) { $page = $req->get('page'); } $rows = 10; if ($req->get('rows')) { $rows = $req->get('rows'); } $entries = File::with('user', 'import', 'eksport')->skip($page)->where('db_table', $db)->take($rows)->paginate(); // dd($rows); // dd($entries->toArray()); $newEntry = []; $i = 0; // foreach ($entries->toArray()['data'] as $entry) { foreach ($entries as $entry) { // dd($entry); $newEntry[$i] = $entry; // $newEntry[$i]['oleh']=$entry['user']['email']; $i++; $newEntry[$i]['email'] = !empty($entry->user) ? $entry->user->email : 'tidak diketahui '; $newEntry[$i]['import.status_import'] = !empty($entry->import) ? $entry->import->status_import : 'Belum'; // dd($entry->import->user->email); $newEntry[$i]['import.user.email'] = !empty($entry->import->user->email) ? $entry->import->user->email : 'Belum'; $newEntry[$i]['eksport.status_eksport'] = !empty($entry->eksport) ? $entry->eksport->status_eksport : 'Belum'; $newEntry[$i]['eksport.user.email'] = !empty($entry->eksport->user->email) ? $entry->eksport->user->email : 'Belum'; $newEntry[$i]['eksport.link_file'] = !empty($entry->eksport->link_file) ? '<a href="' . $entry->eksport->link_file . '">' . $entry->eksport->nama_file . '</a>' : 'Belum'; $i++; // $newEntry[$i]['import.users.email']=(!empty($entry['import']) && !empty($entry['import']['users_id']) )? $entry['import']['status_import']: '----'; $i++; } $result['total'] = $entries->toArray()['total']; // $result['rows']=$entries->toArray()['data']; $result['rows'] = $newEntry; return json_encode($result); }
public function showDashboard(Request $req) { $leftmenu['dashboard'] = 'active'; $files = File::with('client', 'technicien', 'laststatus.code.group', 'laststatus.technicien')->get(); $files = CodeStatus::getThemAllLastStatus($files->toArray()); return view('dashboard', ['leftmenu' => $leftmenu, 'files' => $files]); }
public static function dumpFile() { $result['reparation'] = ''; $result['commande'] = ''; $response = File::with('client', 'technicien')->get(); foreach ($response as $file) { $result['reparation'][] = ['id' => $file->id, 'intern_report' => $file->intern_report, 'client' => $file->intern_report]; } return $result; }
/** * Execute the console command. * * @return mixed */ public function handle() { clearstatcache(); $records = 0; $deleted = 0; foreach (File::with('item')->get() as $fileOb) { $file = $fileOb->getFilepath(); if ($this->checkExistance($file) || fileinode($file) !== $fileOb->inode) { $fileOb->delete(); $deleted++; } $records++; } foreach (Item::doesntHave('files')->get() as $item) { $file = $item->path; if ($this->checkExistance($file)) { $item->delete(); $deleted++; } $records++; } $this->line("{$records} processed"); $this->line("{$deleted} deleted"); }
public function index() { $files = File::with('client', 'technicien', 'laststatus.code')->get(); $repairs = Repair::with('device')->get(); $orders = Order::all(); $leftmenu['files'] = 'active'; return view('/files/index', ['leftmenu' => $leftmenu, 'files' => $files, 'repairs' => $repairs, 'orders' => $orders]); }