PHP Requests::where方法代码示例

 public static function retrieve($roleId = null, $reqCode, $type)
 {
     if ($roleId) {
         return Requests::where('role_id', $roleId)->where('type', $type)->orderBy('created_at', 'desc')->get();
     } else {
         return Requests::where('type', $type)->orderBy('created_at', 'desc')->get();
     }
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function fire()
 {
     $this->info('Working');
     $date1 = date('Y-m-d h:i:s');
     $this->info($date1);
     $date = date_create($date1);
     $msgtime = $date->add(new DateInterval('P0Y0M0DT0H30M0S'))->format('Y-m-d H:i:s');
     $requests = Requests::where('later', 1)->where('is_started', 0)->where('request_start_time', '<=', $msgtime)->get();
     if ($requests->count() > 0) {
         $this->info('hola');
         foreach ($requests as $request) {
             $provider = Walker::where('id', $request->confirmed_walker)->first();
             $owner = Owner::where('id', $request->owner_id)->first();
             $message = "You have a ride scheduled in 30 mins from now. Client name is {$owner->first_name} {$owner->last_name} and phone no. is {$owner->phone}";
             $this->info($request->id);
             $this->info($message);
             send_notifications($provider->id, 'provider', 'Ride in 30 min', $message);
             $request->later = 0;
             $request->save();
         }
     }
 }

 public function indexRequests($roleId)
 {
     //get user role
     $user = Sentry::getUser();
     $role = $user->role;
     Input::get('reqCode') ? $reqCode = Input::get('reqCode') : ($reqCode = '');
     if ($role->role != 'All' && $role->id != $roleId) {
         return Redirect::to('/')->with('error', 'Cannot access that EC');
     }
     if ($role->role == 'All' && $role->id == $roleId) {
         $requests = Request::where('request_code', $reqCode)->orderBy('created_at', 'desc')->get();
     } else {
         $requests = Request::where('request_code', $reqCode)->where('role_id', $roleId)->orderBy('created_at', 'desc')->get();
     }
     if ($this->httpRequest->ajax()) {
         //ajax request so return json
         foreach ($requests as $key => $request) {
             $requests[$key]->requester = $request->owner->first_name . " " . $request->owner->last_name;
             $requests[$key]->role = $request->roles->role;
             $requests[$key]->lcnsTypes = $request->licenseTypes;
             if ($requests[$key]->request_code != 'closed') {
                 if ($user->hasAccess('admin') || $user->role->id == $requests[$key]->role_id) {
                     $requests[$key]->actions = "<a href=" . URL::to('request/' . $requests[$key]->id . '/edit') . "><i class='fa fa-pencil icon-white'></i></a>";
                 }
                 if ($user->hasAccess('admin')) {
                     $requests[$key]->actions .= "<a href=" . URL::to('request/' . $request->id . '/approve') . "><i class='fa fa-check icon-white'></i></a>";
                 }
             }
         }
         header('Content-type: application/json');
         return Response::json(array('requests' => $requests, 'isAdmin' => $user->hasAccess('admin'), 'roleId' => $user->role->id), 200);
     } else {
         //html request
         return View::make('backend.requests.index')->with('requests', $requests)->with('user', $user)->with('roleId', $roleId);
     }
 }

                    <td><?php 
    echo $referred;
    ?>
</td>
                    <td>
                        <div class="dropdown">
                            <button class="btn btn-flat btn-info dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown">
                                Actions
                                <span class="caret"></span>
                            </button>
                            <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1">
                                <li role="presentation"><a role="menuitem" tabindex="-1" id="edit" href="{{ URL::Route('AdminUserEdit', $owner->id) }}">Edit {{ trans('customize.User'); }}</a></li>
                                <li role="presentation"><a role="menuitem" tabindex="-1" id="history" href="{{ URL::Route('AdminUserHistory',$owner->id) }}">View History</a></li>
                                <li role="presentation"><a role="menuitem" tabindex="-1" id="coupon" href="{{ URL::Route('AdminUserReferral', $owner->id) }}">Coupon Details</a></li>
                                <?php 
    $check = Requests::where('owner_id', '=', $owner->id)->where('is_cancelled', '<>', '1')->get()->count();
    //print_r($check);
    if ($check == 0) {
        ?>
                                    <li role="presentation"><a role="menuitem" tabindex="-1" id="add_req" href="{{ URL::Route('AdminAddRequest', $owner->id) }}">Add Request</a></li>
    <?php 
    }
    ?>
                                <li role="presentation"><a role="menuitem" tabindex="-1" id="add_req" href="{{ URL::Route('AdminDeleteUser', $owner->id) }}">Delete</a></li>
                            </ul>
                        </div>
                    </td>
                </tr>
<?php 
}
?>

 public function userTrips()
 {
     $owner_id = Session::get('user_id');
     $requests = Requests::where('owner_id', $owner_id)->where('is_completed', 1)->leftJoin('walker', 'walker.id', '=', 'request.confirmed_walker')->leftJoin('walker_type', 'walker_type.id', '=', 'walker.type')->orderBy('request_start_time', 'desc')->select('request.id', 'request_start_time', 'walker.first_name', 'walker.last_name', 'request.total as total', 'walker_type.name as type')->get();
     return View::make('web.userTrips')->with('title', 'My Trips')->with('requests', $requests);
 }

 public function create_manual_request()
 {
     $latitude = Input::get('latitude');
     $longitude = Input::get('longitude');
     $d_latitude = Input::get('d_latitude');
     $d_longitude = Input::get('d_longitude');
     $type = Input::get('type');
     $provider = Input::get('provider');
     $user_id = Session::get('user_id');
     $time = date("Y-m-d H:i:s");
     $provider_details = Walker::where('id', '=', $provider)->first();
     $user = Owner::where('id', '=', $user_id)->first();
     $request = new Requests();
     $request->owner_id = $user_id;
     $request->request_start_time = $time;
     $request->confirmed_walker = $provider;
     if ($d_longitude != '' && $d_latitude != '') {
         $request->D_latitude = $d_latitude;
         $request->D_longitude = $d_longitude;
     }
     $request->current_walker = $provider;
     $request->status = 1;
     $request->save();
     $reqid = $request->id;
     $request_service = new RequestServices();
     $request_service->type = $type;
     $request_service->request_id = $request->id;
     $request_service->save();
     $owner = Owner::find($user_id);
     $owner->latitude = $latitude;
     $owner->longitude = $longitude;
     $owner->save();
     $walkerlocation = new WalkLocation();
     $walkerlocation->request_id = $request->id;
     $walkerlocation->distance = 0.0;
     $walkerlocation->latitude = $latitude;
     $walkerlocation->longitude = $longitude;
     $walkerlocation->save();
     if ($request->save()) {
         $current_request = Requests::where('id', '=', $reqid)->first();
         return Redirect::to('/user/request-trip');
     }
 }

 public function request_in_progress()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id), array('token' => 'required', 'owner_id' => 'required|integer'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 $request = Requests::where('status', '=', 1)->where('is_completed', '=', 0)->where('is_cancelled', '=', 0)->where('owner_id', '=', $owner_id)->orderBy('created_at', 'desc')->first();
                 if ($request) {
                     $request_id = $request->id;
                 } else {
                     $request_id = -1;
                 }
                 $response_array = array('request_id' => $request_id, 'success' => true);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 $response_array = array('success' => false, 'error' => 'Owner ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }

 public function send_eta()
 {
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $phones = Input::get('phone');
     $request_id = Input::get('request_id');
     $eta = Input::get('eta');
     $validator = Validator::make(array('token' => $token, 'owner_id' => $owner_id, 'phones' => $phones, 'eta' => $eta), array('token' => 'required', 'phones' => 'required', 'owner_id' => 'required|integer', 'eta' => 'required'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 // If phones is not an array
                 if (!is_array($phones)) {
                     $phones = explode(',', $phones);
                 }
                 Log::info('phones = ' . print_r($phones, true));
                 foreach ($phones as $key) {
                     $owner = Owner::where('id', $owner_id)->first();
                     $secret = str_random(6);
                     $request = Requests::where('id', $request_id)->first();
                     $request->security_key = $secret;
                     $request->save();
                     $msg = $owner->first_name . ' ' . $owner->last_name . ' ETA : ' . $eta;
                     send_eta($key, $msg);
                     Log::info('Send ETA MSG  = ' . print_r($msg, true));
                 }
                 $response_array = array('success' => true);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $var = Keywords::where('id', 2)->first();
                    $response_array = array('success' => false, 'error' => '' . $var->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.User') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }

 public function get_track_loc($id)
 {
     $request = Requests::where('security_key', $id)->where('is_started', 1)->where('is_completed', 0)->first();
     if ($request) {
         $owner = Owner::where('id', $request->owner_id)->first();
         $user_name = $owner->first_name . " " . $owner->last_name;
         $theme = Theme::all();
         $logo = '/image/logo.png';
         $favicon = '/image/favicon.ico';
         foreach ($theme as $themes) {
             $favicon = '/uploads/' . $themes->favicon;
             $logo = '/uploads/' . $themes->logo;
         }
         if ($logo == '/uploads/') {
             $logo = '/image/logo.png';
         }
         if ($favicon == '/uploads/') {
             $favicon = '/image/favicon.ico';
         }
         $app_name = Config::get('app.website_title');
         // walk location
         $start_loc = WalkLocation::where('request_id', $request->id)->first();
         $reqloc = WalkLocation::where('request_id', $request->id)->orderBy('id', 'desc')->first();
         $title = 'Track ' . $user_name;
         return Response::json(array('success' => true, 'titl' => $title, 'logo' => $logo, 'favicon' => $favicon, 'app_name' => $app_name, 'cur_lat' => $reqloc->latitude, 'cur_lon' => $reqloc->longitude, 'prev_lat' => $start_loc->latitude, 'prev_lon' => $start_loc->longitude, 'track_id' => $id));
     } else {
         return Redirect::to('/');
     }
 }

 public function request_in_progress()
 {
     $token = Input::get('token');
     $walker_id = Input::get('id');
     $validator = Validator::make(array('token' => $token, 'walker_id' => $walker_id), array('token' => 'required', 'walker_id' => 'required|integer'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($walker_data = $this->getWalkerData($walker_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($walker_data->token_expiry) || $is_admin) {
                 $request = Requests::where('status', '=', 1)->where('is_cancelled', '=', 0)->where('is_completed', '=', 0)->where('confirmed_walker', '=', $walker_id)->first();
                 if ($request) {
                     $request_id = $request->id;
                 } else {
                     $request_id = -1;
                 }
                 $txt_approve = "Decline";
                 if ($walker_data->is_approved) {
                     $txt_approve = "Approved";
                 }
                 $response_array = array('request_id' => $request_id, 'is_approved' => $walker_data->is_approved, 'is_available' => $walker_data->is_active, 'is_approved_txt' => $txt_approve, 'success' => true);
                 $response_code = 200;
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 /* $driver = Keywords::where('id', 1)->first();
                    $response_array = array('success' => false, 'error' => '' . $driver->keyword . ' ID not Found', 'error_code' => 410); */
                 $response_array = array('success' => false, 'error' => '' . Config::get('app.generic_keywords.Provider') . ' ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }

 public function user_set_destination()
 {
     $request_id = Input::get('request_id');
     $token = Input::get('token');
     $owner_id = Input::get('id');
     $dest_lat = Input::get('dest_lat');
     $dest_long = Input::get('dest_long');
     $validator = Validator::make(array('request_id' => $request_id, 'token' => $token, 'owner_id' => $owner_id, 'dest_lat' => $dest_lat, 'dest_long' => $dest_long), array('request_id' => 'required|integer', 'token' => 'required', 'owner_id' => 'required|integer', 'dest_lat' => 'required', 'dest_long' => 'required'));
     if ($validator->fails()) {
         $error_messages = $validator->messages()->all();
         $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401, 'error_messages' => $error_messages);
         $response_code = 200;
     } else {
         $is_admin = $this->isAdmin($token);
         if ($owner_data = $this->getOwnerData($owner_id, $token, $is_admin)) {
             // check for token validity
             if (is_token_active($owner_data->token_expiry) || $is_admin) {
                 // Do necessary operations
                 if ($request = Requests::find($request_id)) {
                     if ($request->owner_id == $owner_data->id) {
                         Requests::where('id', $request_id)->update(array('D_latitude' => $dest_lat, 'D_longitude' => $dest_long));
                         if ($request->current_walker) {
                             $msg_array = array();
                             $msg_array['request_id'] = $request_id;
                             $msg_array['unique_id'] = 4;
                             $last_destination = Requests::find($request_id);
                             $owner = Owner::find($owner_id);
                             $request_data = array();
                             $request_data['owner'] = array();
                             $request_data['owner']['name'] = $owner->first_name . " " . $owner->last_name;
                             $request_data['owner']['picture'] = $owner->picture;
                             $request_data['owner']['phone'] = $owner->phone;
                             $request_data['owner']['address'] = $owner->address;
                             $request_data['owner']['latitude'] = $owner->latitude;
                             $request_data['owner']['longitude'] = $owner->longitude;
                             $request_data['owner']['dest_latitude'] = $last_destination->D_latitude;
                             $request_data['owner']['dest_longitude'] = $last_destination->D_longitude;
                             $request_data['owner']['rating'] = $owner->rate;
                             $request_data['owner']['num_rating'] = $owner->rate_count;
                             $request_data['dog'] = array();
                             if ($dog = Dog::find($owner->dog_id)) {
                                 $request_data['dog']['name'] = $dog->name;
                                 $request_data['dog']['age'] = $dog->age;
                                 $request_data['dog']['breed'] = $dog->breed;
                                 $request_data['dog']['likes'] = $dog->likes;
                                 $request_data['dog']['picture'] = $dog->image_url;
                             }
                             $msg_array['request_data'] = $request_data;
                             $title = "Set Destination";
                             $message = $msg_array;
                             if ($request->confirmed_walker == $request->current_walker) {
                                 send_notifications($request->confirmed_walker, "walker", $title, $message);
                             }
                         }
                         $response_array = array('success' => true, 'error' => "Destination Set Successfully");
                         $response_code = 200;
                     } else {
                         $response_array = array('success' => false, 'error' => 'Request ID doesnot matches with Owner ID', 'error_code' => 407);
                         $response_code = 200;
                     }
                 } else {
                     $response_array = array('success' => false, 'error' => 'Request ID Not Found', 'error_code' => 408);
                     $response_code = 200;
                 }
             } else {
                 $response_array = array('success' => false, 'error' => 'Token Expired', 'error_code' => 405);
                 $response_code = 200;
             }
         } else {
             if ($is_admin) {
                 $response_array = array('success' => false, 'error' => 'Owner ID not Found', 'error_code' => 410);
             } else {
                 $response_array = array('success' => false, 'error' => 'Not a valid token', 'error_code' => 406);
             }
             $response_code = 200;
         }
     }
     $response = Response::json($response_array, $response_code);
     return $response;
 }

 public function send_eta_web()
 {
     if ($_POST) {
         $request_id = Input::get('request_id');
         $mail_ids = Input::get('mail_ids');
         $duration = Input::get('duration');
         $destination = Input::get('destination');
         $source = Input::get('source');
         $request = Requests::where('id', $request_id)->first();
         $splits = explode(',', $mail_ids);
         $user_name = Session::get('user_name');
         foreach ($splits as $key) {
             // send email
             $link = "https://maps.google.com/maps?f=d&hl=en&saddr=" . $source . "&daddr=" . $destination . "&ie=UTF8&om=0&output=kml";
             $pattern = "Hello,<br> " . $user_name . " will Reached the Destination in " . $duration . " (Estimated Time) <br><br><br>For More Information---<br>" . $link . "<br>";
             $subject = "ETA from " . $user_name;
             send_eta_email($key, $pattern, $subject);
         }
         return Redirect::to('/user/request-trip')->with('message', "Your ETA Shared Successfully.");
     }
 }

 public function providerTrips()
 {
     $start_date = Input::get('start_date');
     $end_date = Input::get('end_date');
     $submit = Input::get('submit');
     $start_time = date("Y-m-d H:i:s", strtotime($start_date));
     $end_time = date("Y-m-d H:i:s", strtotime($end_date));
     $start_date = date("Y-m-d", strtotime($start_date));
     $end_date = date("Y-m-d", strtotime($end_date));
     if (!Input::get('start_date') && !Input::get('end_date')) {
         $walker_id = Session::get('walker_id');
         $requests = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->leftJoin('walker', 'walker.id', '=', 'request.confirmed_walker')->leftJoin('walker_type', 'walker_type.id', '=', 'walker.type')->leftJoin('owner', 'owner.id', '=', 'request.owner_id')->orderBy('request_start_time', 'desc')->select('request.id', 'request_start_time', 'owner.first_name', 'owner.last_name', 'request.total as total', 'walker_type.name as type', 'request.distance', 'request.time')->get();
         $total_rides = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->count();
         $total_distance = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->sum('distance');
         $settings = Settings::where('key', 'default_distance_unit')->first();
         $unit = $settings->value;
         $total_earnings = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->sum('total');
         $average_rating = DogReview::where('walker_id', $walker_id)->avg('rating');
     } else {
         $walker_id = Session::get('walker_id');
         $requests = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->where('request_start_time', '>=', $start_time)->where('request_start_time', '<=', $end_time)->leftJoin('walker', 'walker.id', '=', 'request.confirmed_walker')->leftJoin('walker_type', 'walker_type.id', '=', 'walker.type')->leftJoin('owner', 'owner.id', '=', 'request.owner_id')->orderBy('request_start_time', 'desc')->select('request.id', 'request_start_time', 'owner.first_name', 'owner.last_name', 'request.total as total', 'walker_type.name as type', 'request.distance', 'request.time')->get();
         $total_rides = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->where('request_start_time', '>=', $start_time)->where('request_start_time', '<=', $end_time)->count();
         $total_distance = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->where('request_start_time', '>=', $start_time)->where('request_start_time', '<=', $end_time)->sum('distance');
         $total_earnings = Requests::where('confirmed_walker', $walker_id)->where('is_completed', 1)->where('request_start_time', '>=', $start_time)->where('request_start_time', '<=', $end_time)->sum('total');
         $average_rating = DogReview::where('walker_id', $walker_id)->where('created_at', '>=', $start_time)->where('created_at', '<=', $end_time)->avg('rating');
     }
     if (!Input::get('submit') || Input::get('submit') == 'filter') {
         return View::make('web.providerTrips')->with('title', 'My Trips')->with('requests', $requests)->with('total_rides', $total_rides)->with('total_distance', $total_distance)->with('total_earnings', $total_earnings)->with('average_rating', $average_rating);
     } else {
         header('Content-Type: text/csv; charset=utf-8');
         header('Content-Disposition: attachment; filename=data.csv');
         $handle = fopen('php://output', 'w');
         fputcsv($handle, array('Date', 'Customer name', 'Type of Service', 'Distance (Miles)', 'Time (Minutes)', 'Earning'));
         foreach ($requests as $request) {
             fputcsv($handle, array(date('l, F d Y h:i A', strtotime($request->request_start_time)), $request->first_name . " " . $request->last_name, $request->type, $request->distance, $request->time, $request->total));
         }
         fputcsv($handle, array());
         fputcsv($handle, array());
         fputcsv($handle, array('Total Rides', $total_rides));
         fputcsv($handle, array('Total Distance Covered (Miles)', $total_distance));
         fputcsv($handle, array('Average Rating', $average_rating));
         fputcsv($handle, array('Total Earning', $total_earnings));
         fclose($handle);
     }
 }