public function getImports() { $imports = Import::where('status', '=', 'Activate')->get(); echo "<option value ='N/A' >N/A </option>"; foreach ($imports as $import) { echo "<option value = {$import->consignment_name} > {$import->consignment_name}</option> "; } }
public function getEdit($id) { $stockInvoices = StockInvoice::find($id); $branches = new Branch(); $branchAll = $branches->getBranchesDropDown(); $stockDetails = StockDetail::where('invoice_id', '=', $stockInvoices->invoice_id)->first(); $stockDetails2 = StockDetail::where('invoice_id', '=', $stockInvoices->invoice_id)->get(); // get all stocks $stockInfos = new StockInfo(); $allStockInfos = $stockInfos->getStockInfoDropDown(); $invoiceId = $stockInvoices->invoice_id; //$invoiceId = 's121513'; $buyersAll = 0; $imports = Import::where('status', '=', 'Activate')->get(); $productsName = Product::where('product_type', '=', $stockDetails->product_type)->where('branch_id', '=', $stockDetails->branch_id)->get(); return view('Stocks.edit2', compact('buyersAll', 'invoiceId', 'stockInvoices', 'stockDetails', 'productsName', 'stockDetails2', 'imports'))->with('branchAll', $branchAll)->with('allStockInfos', $allStockInfos); // return view('Stocks.edit',compact('stock')) // ->with('allStockInfos',$allStockInfos) // ->with('branchAll',$branchAll); }
/** * */ public function anyDeleteHasilImport(Request $req, $db) { $files_id = $req->get('files_id'); $mod = $this->mod($db)->where('files_id', $files_id); $response = array(); if ($mod->get()->count() >= 1) { if ($mod->delete()) { $pesan = "File \" {$files_id} \" Telah Dihapus dari Import "; $file = File::find($req->get('id')); if (Import::where('files_id', Import::where('files_id', $files_id)->delete())->delete()) { $pesan .= "Hasil Import Telah Terhapus dari DB !!"; } } $response['code'] = 200; $response['msg'] = $pesan; // return '{"code":200,"msg":"File bidang.xlsx Telah disimpan"}'; return json_encode($response); } $response['code'] = 404; $response['msg'] = "Gagal menghapus File " . $files_id . " !!"; return json_encode($response); }