Example #1
0
 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');
 }
Example #2
0
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');