json - Problems with rendering view when using DataTable in Laravel 5.2 -

-

i using datatables in laravel 5.2, seems can pass json data failed render view. dunno wrong here.

here datatable controller code:

public function getindex()     {         return view('event.report');     }      /**      * process datatables ajax request.      *      * @return \illuminate\http\jsonresponse      */     public function anydata(request $request)     {         //$developers = event::lists('developer','developer');         $events = event::select(['name','startdate','enddate','venue','developer','client','agency','allowance']);         return \datatables::of($events)             ->filter(function ($query) use ($request) {                 if ($request->input('developer')) {                     $query->where('developer', '=', "{$request->get('developer')}");                 }             })             ->make(true);     }

here view in event.report:

@extends('layouts.app')  @section('content')     <title>attender monthly report page</title>      <div class="container">         {{ form::open(['url' => '/getreport','id'=>'search']) }}         {{ form::label('name', 'select developer name:') }}         {{ form::select('developer', ['abc'=>'abc','def'=>'def','123'=>'123'],null,['id' => 'name']) }}         {{ form::submit('search', ['class' => 'btn btn-primary']) }}         {{ form::close() }}          <div class="search">         <a  href="{{ url('/excel') }}" class="btn btn-primary"><span class="glyphicon glyphicon-save" aria-hidden="true"></span>  export excel</a>         <table class="table table-hover" id="result">             <thead>             <tr>                 <th>event name</th>                 <th>start_date</th>                 <th>end_date</th>                 <th>venue</th>                 <th>attender</th>                 <th>client</th>                 <th>agency</th>                 <th>allowance</th>              </tr>             </thead>         </table>             </div>     </div> @endsection @push('scripts') <script>     var otable =             $('#result').datatable({                 processing: true,                 serverside: true,                 ajax: {                     url: '{{ url('/getreport') }}',                     data: function (d) {                         d.name = $('select[name=name]').val();                     }                 },                  columns: [                     { data: 'name', name: 'name' },                     { data: 'startdate', name: 'startdate' },                     { data: 'enddate', name: 'enddate' },                     { data: 'venue', name: 'venue' },                     { data: 'developer', name: 'developer' },                     { data: 'client', name: 'client' },                     { data: 'agency', name: 'agency' },                     { data: 'allowance', name: 'allowance' }                 ]             });      $('#search').on('submit', function(e) {         otable.draw();         e.preventdefault();     }); </script> @endpush

and here route:

route::post('/getreport','datatablescontroller@anydata'); route::get('/viewreport','datatablescontroller@getindex');

this json data posted /getreport page:

{ "draw": 0, "recordstotal": 4, "recordsfiltered": 2, "data": [ { "name": "sfdwseef", "startdate": "2016-02-03", "enddate": "2016-02-23", "venue": "dgegw", "developer": "123", "client": "dgsfdse", "agency": "dgfsdg", "allowance": "567" }, { "name": "dfgdrer3terr", "startdate": "2016-03-07", "enddate": "2016-03-08", "venue": "fhghfghf", "developer": "123", "client": "fhgfhty", "agency": "hrthyj", "allowance": "43" } ], "queries": [ { "query": "select count(*) aggregate (select '1' `row_count` `events`) count_row_table", "bindings": [], "time": 1 }, { "query": "select count(*) aggregate (select '1' `row_count` `events` `developer` = ?) count_row_table", "bindings": [ "123" ], "time": 0 }, { "query": "select `name`, `startdate`, `enddate`, `venue`, `developer`, `client`, `agency`, `allowance` `events` `developer` = ?", "bindings": [ "123" ], "time": 0 } ], "input": { "_token": "ogq4pyptxdgwf7ljf8yub5nox6gqbzwp1n5izizg", "developer": "123" } }

and 1 more thing,if want dropdown display options developer column in event model,how shud change code?


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more