mysql - search by date range and name in laravel , no data show by default -


i have 2 table "patient" , "booking" table, , there relationship "one many" between them, made search form in index_booking page user can type patient_name on search user name according condition search date range , there no data appear in form till search date , don't know why data show default according condition :

this booking model

class booking extends eloquent {      public function patient()     {       return $this->belongsto('app\patient');      }      public function user()     {       return $this->belongsto('app\user');       } } 

this patient model

class patient extends eloquent {     public function booking()     {       return $this->hasmany('app\booking');      }      public function user()     {       return $this->belongsto('app\user');       } } 

and used code in index page of booking

   <div class="search1">            {!! form::open(['method'=>'get','url'=>'booking','class'=>'navbar-form navbar-left','role'=>'search'])  !!}            <!--<span class="badge">{{$bookings->count()}}</span>-->         </div>   <tr>     <div class="col col-md-3">      <p></span><input type="text" id="end" name="end" placeholder="الي تاريخ"><span class="glyphicon glyphicon-calendar"></p>     </div>     <div class="col col-md-4">      <p><input type="text" id="start" name="start" placeholder="من تاريخ"></p>     </div>     <td class="title search col-md-5">     <div class="input-group custom-search-form">      <input type="text" class="form-control" name="search" placeholder="ابحث بالاسم...">      <span class="input-group-btn">          <button class="btn btn-default-sm" type="submit">             <i class="fa fa-search"> <span class="hiddengrammarerror" pre="" data-mce-bogus="1"></span></i>         </button>     </span>  </div>     </td>     {!! form::close() !!} 

i used code in booking controller show data according condition , search date range:

       public function index(request $request)     {   $search = request::get('search'); $start = request::input('start'); $end = request::input('end');  $bookings = booking::wherehas('patient', function ($query) use ($search, $start, $end) { $query->where('patient_name', 'like', '%' . $search . '%')       ->wherebetween(db::raw('date(booking_date)'), [$start, $end]) ;   })->where('status','=', null)->wherehas('patient', function ($query){   $query->where('company_id','=' ,auth::user()->company_id);   })->orderby("id", "asc")    ->paginate(7);   return view('booking.index')->withbookings($bookings);   }       } 

javascript code in booking index is:

 <script>           $(function(){$("#start").datepicker({             autoclose:!0,             dateformat:"yy-mm-dd",             startdate:new date         }),         $("#end").datepicker({             autoclose:!0,             dateformat:"yy-mm-dd",             enddate:new date         })     });  


Comments

Popular posts from this blog

javascript - Create a stacked percentage column -

Optimising Firebase database by automatically overwriting data -

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -