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