id_bills_po); $bpo = BillsPo::create([ 'id_project' => $request->switch_to, 'bill' => $bills_po->bill, 'bill_date' => $request->date, 'due_date' => $bills_po->due_date, 'amount' => 0, 'status' => 'open', ]); $amount = 0; if ($request->id_detail) { foreach ($request->id_detail as $key => $value) { $bill_po_d = BillsPoDetail::where('id',$value)->first(); $bill_po_d->qty -= str_replace(',', '.', $request->qty[$key]); $bill_po_d->save(); BillsPoDetail::create([ 'id_bills_po' => $bpo->id, 'id_crap' => $bill_po_d->id_crap, 'harga' => $bill_po_d->harga, 'qty' => str_replace(',', '.', $request->qty[$key]), ]); $amount += $bill_po_d->harga * str_replace(',', '.', $request->qty[$key]); } } $bills_po->amount = $bills_po->amount - $amount; $bills_po->save(); $bpo->amount = $amount; $bpo->save(); return redirect()->route('bills_po.index')->with('msg','Bills PO berhasil di switch'); } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show(Request $request,$id) { if (\Request::ajax()) { if (isset($_GET['act'])) { if ($_GET['act'] == 'switchmdata') { $columns = array( 0 => 'id', ); $totalData = Project::count(); $totalFiltered = $totalData; $limit = $request->input('length'); $start = $request->input('start'); $order = $columns[$request->input('order.0.column')]; $dir = $request->input('order.0.dir'); if (empty($request->input('search.value'))) { $projects = Project::offset($start) ->limit($limit) ->orderBy($order, $dir) ->get(); }else{ $search = $request->input('search.value'); $projects = Project::where('projects.name', 'LIKE', "%{$search}%") ->offset($start) ->limit($limit) ->orderBy($order, $dir) ->get(); $totalFiltered = Project::where('projects.name', 'LIKE', "%{$search}%") ->count(); } $data = array(); if (!empty($projects)) { foreach ($projects as $row) { $nestedData['project'] = $row->name; $nestedData['opsi'] = "

"; $nestedData['opsi'] .= " detail

"; $data[] = $nestedData; } } $json_data = array( "draw" => intval($request->input('draw')), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data, ); echo json_encode($json_data); }elseif ($_GET['act'] == 'billDetail') { $bills_po = BillsPo::with('billsPoDetail','billsPoDetail.crap','billsPoDetail.crap.material','billsPoDetail.crap.vendor')->findOrFail($id); return response()->json(['bills_po' => $bills_po]); } } }else{ $project = Project::findOrFail($id); $projects = Project::where('id','<>',$id)->get(); $bills_po = BillsPo::whereHas('purchaseOrder.purchaseRequest',function($q) use ($id){ $q->where('id_project',$id); })->whereHas('purchaseOrder',function($q){ $q->where('status','billed')->orWhere('status','closed'); })->get(); return view('staff.switch-material-detail',compact('project','bills_po','projects')); } } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // } }