public function getPayments()
{
$to = Input::get('to');
$from = Input::get('from');
if ($from == null || $to == null) {
$today = LocationController::getTime();
$todayFrom = $today['date'] . ' 00:00:00';
$todayTo = $today['date'] . ' 23:59:59';
} else {
$todayFrom = $from . ' 00:00:00';
$todayTo = $to . ' 23:59:59';
}
try {
$results = Payment::where('created_at', '>', $todayFrom)->where('created_at', '<', $todayTo)->get()->toArray();
if (!is_null($results)) {
foreach ($results as $key => $payment) {
$driver = Driver::where('id', '=', $payment['driver_id'])->first()->toArray();
$currency = Currency::find($payment['currency'])->pluck('currency');
$results[$key]['driver_name'] = $driver['first'] . ' ' . $driver['last'];
$results[$key]['currency'] = $currency;
}
}
$queries = DB::getQueryLog();
$last_query = end($queries);
} catch (Exception $ex) {
\Log::error(__METHOD__ . ' | error :' . print_r($ex, 1));
}
//\Log::info(__METHOD__.print_r($results, 1));
return json_encode($results);
}
public function showMyTrips()
{
$userId = Session::get('user_id');
$to = Input::get('to');
$from = Input::get('from');
if ($from == null || $to == null) {
$today = LocationController::getTime();
$todayFrom = $today['date'] . ' 00:00:00';
$todayTo = $today['date'] . ' 23:59:59';
} else {
$todayFrom = $from . ' 00:00:00';
$todayTo = $to . ' 23:59:59';
}
try {
$myTrips = DailyTrips::where('user_id', '=', $userId)->where('departure_date_time', '>', $todayFrom)->where('departure_date_time', '<', $todayTo)->orderBy('departure_date_time', 'desc')->get()->toArray();
$carId = Session::get('car_id');
$car = Cars::find($carId);
if ($myTrips == null) {
$myTrips = array('my_trips' => 'no trips have been recorded for you.');
}
$results = array('success' => true, 'my_trips' => $myTrips, 'car' => $car);
} catch (Exception $ex) {
\Log::error(__METHOD__ . ' | error :' . print_r($ex, 1));
$results = array('success' => false, 'message' => 'an error occurred');
}
return $results;
}
