public function quotation($id) { $orders = DB::table('erporders')->join('erporderitems', 'erporders.id', '=', 'erporderitems.erporder_id')->join('items', 'erporderitems.item_id', '=', 'items.id')->join('clients', 'erporders.client_id', '=', 'clients.id')->where('erporders.id', '=', $id)->select('clients.name as client', 'items.name as item', 'quantity', 'clients.address as address', 'clients.phone as phone', 'clients.email as email', 'date', 'erporders.id as id', 'discount_amount', 'erporders.order_number as order_number', 'price', 'description')->get(); $txorders = DB::table('tax_orders')->join('erporders', 'tax_orders.order_number', '=', 'erporders.order_number')->join('taxes', 'tax_orders.tax_id', '=', 'taxes.id')->where('erporders.id', '=', $id)->get(); $count = DB::table('tax_orders')->count(); $erporder = Erporder::findorfail($id); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.quotation', compact('orders', 'erporder', 'txorders', 'count', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('quotation.pdf'); }
Route::get('erpquotations/cancel/{id}', function ($id) { $order = Erporder::findorfail($id); $order->status = 'cancelled'; $order->update(); return Redirect::to('quotationorders'); }); Route::get('erporders/show/{id}', function ($id) { $order = Erporder::findorfail($id); return View::make('erporders.show', compact('order')); }); Route::get('erppurchases/show/{id}', function ($id) { $order = Erporder::findorfail($id); return View::make('erppurchases.show', compact('order')); }); Route::get('erpquotations/show/{id}', function ($id) { $order = Erporder::findorfail($id); return View::make('erpquotations.show', compact('order')); }); Route::get('api/getrate', function () { $id = Input::get('option'); $tax = Tax::find($id); return $tax->rate; }); Route::get('morgue', function () { return View::make('morgue'); }); Route::resource('enquiries', 'EnquiriesController'); Route::get('enquiries/edit/{id}', 'EnquiriesController@edit'); Route::get('enquiries/delete/{id}', 'EnquiriesController@destroy'); Route::post('enquiries/update/{id}', 'EnquiriesController@update'); Route::get('enquiries/show/{id}', 'EnquiriesController@show');