/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create($id, Request $request) { $salesinvoices = SalesInvoice::where('client_id', $id)->where('status', '!=', 'Collected')->where('status', '!=', 'Draft')->where('status', '!=', 'Pending')->orderBy('status', 'asc')->get(); $actionOptions = []; $actionOptions['Text'] = 'Text'; $actionOptions['Call'] = 'Call'; $actionOptions['Fax'] = 'Fax'; $actionOptions['Send SOA'] = 'Send SOA'; $actionOptions['Email'] = 'Email'; $actionOptions['Visit'] = 'Visit'; $actionOptions['Call and Send SOA'] = 'Call and Send SOA'; $reasonOptions = Reason::lists('reason', 'id'); $statusOptions = []; $statusOptions['To Do'] = 'To Do'; $statusOptions['Done'] = 'Done'; $method = 'post'; return view('collection_logs.create', compact('id', 'method', 'actionOptions', 'statusOptions', 'reasonOptions', 'id', 'salesinvoices')); }
public function filter() { $input = Request::all(); $filter = $input['filter']; if ($filter == 'All') { return redirect()->action('CollectiblesController@index'); } $clients = Client::where('status', $filter)->paginate(10); $overdue = new SalesInvoice(); $delivered = new SalesInvoice(); $check = new SalesInvoice(); $salesinvoice = new SalesInvoice(); $salesinvoice2 = new SalesInvoice(); $salesinvoice3 = new SalesInvoice(); $salesinvoiceTotal; foreach ($clients as $client) { $overdue[$client->id] = SalesInvoice::where('client_id', $client->id)->where('status', 'Overdue')->count(); $delivered[$client->id] = SalesInvoice::where('client_id', $client->id)->where('status', 'Delivered')->count(); $check[$client->id] = SalesInvoice::where('client_id', $client->id)->where('status', 'Check on Hand')->count(); // $salesinvoice[$client->id] = DB::SELECT("SELECT sum(total_amount) as total FROM sales_invoices // WHERE (status = 'Overdue' or status = 'Delivered') and client_id = '$client->id'"); $salesinvoice = SalesInvoice::where('status', '=', 'Overdue')->where('client_id', '=', $client->id)->sum('total_amount'); $salesinvoice2 = SalesInvoice::where('status', 'Delivered')->where('client_id', $client->id)->sum('total_amount'); $salesinvoice3 = SalesInvoice::where('status', 'Check on Hand')->where('client_id', $client->id)->sum('total_amount'); $salesinvoiceTotal[$client->id] = $salesinvoice + $salesinvoice2 + $salesinvoice3; } // for ($x = $clients[0]; $x < count($clients)+1; $x++) // { // $overdue[$x] = SalesInvoice::where('client_id', $x)->where('status', 'Overdue')->count(); // $delivered[$x] = SalesInvoice::where('client_id', $x)->where('status', 'Delivered')->count(); // $pending[$x] = SalesInvoice::where('client_id', $x)->where('status', 'Pending')->count(); // } if ($clients == "[]") { return redirect()->action('CollectiblesController@index'); } $clients->appends(Request::only('filter')); return view('collectibles.index', compact('clients', 'overdue', 'delivered', 'check', 'salesinvoiceTotal')); }
public function filter() { $input = Request::all(); if (isset($input['filter_status'])) { if ($input['filter_status'] == "All") { return redirect()->action('SalesInvoicesController@index'); } else { $filter_status = $input['filter_status']; $sales_invoices = SalesInvoice::where('status', $filter_status)->paginate(10); $sales_invoices->appends(Request::only('filter_status')); } } else { if ($input['filter_date'] == "All") { return redirect()->action('SalesInvoicesController@index'); } else { $filter_date = $input['filter_date']; $sales_invoices = SalesInvoice::where('due_date', $filter_date)->where('status', '!=', 'Collected')->paginate(10); //and where status !== collected $sales_invoices->appends(Request::only('filter_date')); } } // if ($input['filter_status'] == "[]") // { // return redirect()->action('SalesInvoicesController@index'); // } $dates = SalesInvoice::where('status', '!=', 'Collected')->where('status', '!=', 'Draft')->orderBy('due_date', 'desc')->lists('due_date', 'due_date'); return view('sales_invoices.index', compact('sales_invoices', 'dates')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $client = Client::find($id); // $sales_invoices = DB::select("SELECT * FROM sales_invoices si JOIN clients c ON si.client_id = c.id WHERE c.id='$id'"); // $sales_invoices = SalesInvoice::where('client_id', $id); $sales_invoices = SalesInvoice::where('client_id', $id)->orderby('date', 'desc')->paginate(10); return view('clients.show', compact('client', 'sales_invoices')); }