public function apply_promo_code() { $promo_code = Input::get('promo_code'); $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(); $response_array = array('success' => false, 'error' => 'Invalid Input', 'error_code' => 401); $response_code = 200; } else { $request_id = 0; $is_apply_on_trip = 0; $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('owner_id', '=', $owner_id)->where('status', '=', 1)->orderBy('created_at', 'desc')->first(); if ($request) { if (isset($request->id)) { if ($request->promo_id) { $response_array = array('success' => FALSE, 'error' => 'You can not apply multiple code for single trip.', 'error_code' => 411); $response_code = 200; } else { $settings = Settings::where('key', 'promotional_code_activation')->first(); $prom_act = $settings->value; if ($prom_act) { if ($request->payment_mode == 0) { $settings = Settings::where('key', 'get_promotional_profit_on_card_payment')->first(); $prom_act_card = $settings->value; if ($prom_act_card) { /* if ($ledger = PromotionalCodes::where('promo_code', $promo_code)->first()) { */ if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) { if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) { $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available.', 'error_code' => 505); $response_code = 200; } else { /* echo $promos->id; echo $owner_id; $promo_is_used = 0; */ $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); /* $promo_is_used = DB::table('user_promo_used')->where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); */ if ($promo_is_used) { $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512); $response_code = 200; } else { $promo_update_counter = PromoCodes::find($promos->id); $promo_update_counter->uses = $promo_update_counter->uses - 1; $promo_update_counter->save(); $user_promo_entry = new UserPromoUse(); $user_promo_entry->code_id = $promos->id; $user_promo_entry->user_id = $owner_id; $user_promo_entry->save(); $owner = Owner::find($owner_id); $owner->promo_count = $owner->promo_count + 1; $owner->save(); $request = Requests::find($request->id); $request->promo_id = $promos->id; $request->promo_code = $promos->coupon_code; $request->save(); $owner = Owner::find($owner_id); $code_data = Ledger::where('owner_id', '=', $owner->id)->first(); $response_array = array('success' => true, 'error' => 'Promotional code successfully applied.', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count, 'request_id' => $request->id); $response_code = 200; } } } else { $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available.', 'error_code' => 505); $response_code = 200; } } else { $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on card payment.', 'error_code' => 505); $response_code = 200; } } else { if ($request->payment_mode == 1) { $settings = Settings::where('key', 'get_promotional_profit_on_cash_payment')->first(); $prom_act_cash = $settings->value; if ($prom_act_cash) { /* if ($ledger = PromotionalCodes::where('promo_code', $promo_code)->first()) { */ if ($promos = PromoCodes::where('coupon_code', $promo_code)->where('uses', '>', 0)->where('state', '=', 1)->first()) { if (date("Y-m-d H:i:s") >= date("Y-m-d H:i:s", strtotime(trim($promos->expiry))) || date("Y-m-d H:i:s") <= date("Y-m-d H:i:s", strtotime(trim($promos->start_date)))) { $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505); $response_code = 200; } else { /* echo $promos->id; echo $owner_id; $promo_is_used = 0; */ $promo_is_used = UserPromoUse::where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); /* $promo_is_used = DB::table('user_promo_used')->where('user_id', '=', $owner_id)->where('code_id', '=', $promos->id)->count(); */ if ($promo_is_used) { $response_array = array('success' => FALSE, 'error' => 'Promotional code already used.', 'error_code' => 512); $response_code = 200; } else { $promo_update_counter = PromoCodes::find($promos->id); $promo_update_counter->uses = $promo_update_counter->uses - 1; $promo_update_counter->save(); $user_promo_entry = new UserPromoUse(); $user_promo_entry->code_id = $promos->id; $user_promo_entry->user_id = $owner_id; $user_promo_entry->save(); $owner = Owner::find($owner_id); $owner->promo_count = $owner->promo_count + 1; $owner->save(); $request = Requests::find($request->id); $request->promo_id = $promos->id; $request->promo_code = $promos->coupon_code; $request->save(); $owner = Owner::find($owner_id); $code_data = Ledger::where('owner_id', '=', $owner->id)->first(); $response_array = array('success' => true, 'error' => 'Promotional code successfully applied.', 'id' => $owner->id, 'first_name' => $owner->first_name, 'last_name' => $owner->last_name, 'phone' => $owner->phone, 'email' => $owner->email, 'picture' => $owner->picture, 'bio' => $owner->bio, 'address' => $owner->address, 'state' => $owner->state, 'country' => $owner->country, 'zipcode' => $owner->zipcode, 'login_by' => $owner->login_by, 'social_unique_id' => $owner->social_unique_id, 'device_token' => $owner->device_token, 'device_type' => $owner->device_type, 'token' => $owner->token, 'referral_code' => $code_data->referral_code, 'is_referee' => $owner->is_referee, 'promo_count' => $owner->promo_count, 'request_id' => $request->id); $response_code = 200; } } } else { $response_array = array('success' => FALSE, 'error' => 'Promotional code is not available', 'error_code' => 505); $response_code = 200; } } else { $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active on cash payment.', 'error_code' => 505); $response_code = 200; } } else { $response_array = array('success' => FALSE, 'error' => 'Payment mode is paypal', 'error_code' => 505); $response_code = 200; } } } else { $response_array = array('success' => FALSE, 'error' => 'Promotion feature is not active.', 'error_code' => 505); $response_code = 200; } } } else { $response_array = array('success' => FALSE, 'error' => 'You can\'t apply promotional code without creating request.', 'error_code' => 506); $response_code = 200; } } else { $response_array = array('success' => FALSE, 'error' => 'You can\'t apply promotional code without creating request.', 'error_code' => 506); $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 is 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 schedule_request() { /* Cronjob counter */ /* echo asset_url() . "/cron_count.txt"; */ $css_msg = file(asset_url() . "/cron_count.txt"); if ($css_msg[0] > '1000') { $css_msg[0] = 0; } else { $css_msg[0]++; } /* echo $css_msg[0]; */ $t = file_put_contents(public_path() . '/cron_count.txt', $css_msg[0]); $css_msg[0]; /* Cronjob counter END */ $time = date("Y-m-d H:i:s"); $timezone_app = Config::get('app.timezone'); date_default_timezone_set($timezone_app); $timezone_sys = date_default_timezone_get(); $query = "SELECT request.*,TIMESTAMPDIFF(SECOND,request_start_time, '{$time}') as diff from request where status = 0 and is_cancelled = 0"; $results = DB::select(DB::raw($query)); /* SEND REFERRAL & PROMO INFO */ $settings = Settings::where('key', 'referral_code_activation')->first(); $referral_code_activation = $settings->value; if ($referral_code_activation) { $referral_code_activation_txt = "referral on"; } else { $referral_code_activation_txt = "referral off"; } $settings = Settings::where('key', 'promotional_code_activation')->first(); $promotional_code_activation = $settings->value; if ($promotional_code_activation) { $promotional_code_activation_txt = "promo on"; } else { $promotional_code_activation_txt = "promo off"; } /* SEND REFERRAL & PROMO INFO */ $driver_data = ""; foreach ($results as $result) { $settings = Settings::where('key', 'provider_timeout')->first(); $timeout = $settings->value; if ($result->diff >= $timeout) { // Archiving Old Walker RequestMeta::where('request_id', '=', $result->id)->where('walker_id', '=', $result->current_walker)->update(array('status' => 2)); $request = Requests::where('id', $result->id)->first(); $request_meta = RequestMeta::where('request_id', '=', $result->id)->where('status', '=', 0)->orderBy('created_at')->first(); // update request if (isset($request_meta->walker_id)) { // assign new walker Requests::where('id', '=', $result->id)->update(array('current_walker' => $request_meta->walker_id, 'request_start_time' => date("Y-m-d H:i:s"))); // Send Notification $walker = Walker::find($request_meta->walker_id); $settings = Settings::where('key', 'provider_timeout')->first(); $time_left = $settings->value; $owner = Owner::find($result->owner_id); $msg_array = array(); $msg_array['unique_id'] = 1; $msg_array['request_id'] = $request->id; $msg_array['time_left_to_respond'] = $time_left; $msg_array['payment_mode'] = $request->payment_mode; $msg_array['client_profile'] = array(); $msg_array['client_profile']['name'] = $owner->first_name . " " . $owner->last_name; $msg_array['client_profile']['picture'] = $owner->picture; $msg_array['client_profile']['bio'] = $owner->bio; $msg_array['client_profile']['address'] = $owner->address; $msg_array['client_profile']['phone'] = $owner->phone; $owner = Owner::find($result->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; if ($request->d_latitude != NULL) { $request_data['owner']['d_latitude'] = $request->D_latitude; $request_data['owner']['d_longitude'] = $request->D_longitude; } $request_data['owner']['rating'] = $owner->rate; $request_data['owner']['num_rating'] = $owner->rate_count; /* $request_data['owner']['rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->avg('rating') ? : 0; $request_data['owner']['num_rating'] = DB::table('review_dog')->where('owner_id', '=', $owner->id)->count(); */ $msg_array['request_data'] = $request_data; $title = "New Request"; $message = $msg_array; Log::info('New Request = ' . print_r($message, true)); send_notifications($request_meta->walker_id, "walker", $title, $message); $driver_data = array(); $driver_data['unique_id'] = 1; $driver_data['id'] = "" . $walker->id; $driver_data['first_name'] = "" . $walker->first_name; $driver_data['last_name'] = "" . $walker->last_name; $driver_data['phone'] = "" . $walker->phone; /* $driver_data['email'] = "" . $walker->email; */ $driver_data['picture'] = "" . $walker->picture; $driver_data['bio'] = "" . $walker->bio; /* $driver_data['address'] = "" . $walker->address; $driver_data['state'] = "" . $walker->state; $driver_data['country'] = "" . $walker->country; $driver_data['zipcode'] = "" . $walker->zipcode; $driver_data['login_by'] = "" . $walker->login_by; $driver_data['social_unique_id'] = "" . $walker->social_unique_id; $driver_data['is_active'] = "" . $walker->is_active; $driver_data['is_available'] = "" . $walker->is_available; */ $driver_data['latitude'] = "" . $walker->latitude; $driver_data['longitude'] = "" . $walker->longitude; /* $driver_data['is_approved'] = "" . $walker->is_approved; */ $driver_data['type'] = "" . $walker->type; $driver_data['car_model'] = "" . $walker->car_model; $driver_data['car_number'] = "" . $walker->car_number; $driver_data['rating'] = $walker->rate; $driver_data['num_rating'] = $walker->rate_count; /* $driver_data['rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->avg('rating') ? : 0; $driver_data['num_rating'] = DB::table('review_walker')->where('walker_id', '=', $walker->id)->count(); */ $client_push_data = array('success' => true, 'unique_id' => 1, 'is_referral_active' => $referral_code_activation, 'is_referral_active_txt' => $referral_code_activation_txt, 'is_promo_active' => $promotional_code_activation, 'is_promo_active_txt' => $promotional_code_activation_txt, 'request_id' => $result->id, 'walker' => $driver_data); $message1 = $client_push_data; $owner_data = Owner::find($result->owner_id); $title1 = "New Driver assigned"; send_notifications($owner_data->id, "owner", $title1, $message1); } else { $owner = Owner::find($result->owner_id); /* CLIENT PUSH FOR GETTING DRIVER DETAILS */ $client_push_data = array('success' => false, 'unique_id' => 1, 'error' => 'No driver found around you.', 'is_referral_active' => $referral_code_activation, 'is_referral_active_txt' => $referral_code_activation_txt, 'is_promo_active' => $promotional_code_activation, 'is_promo_active_txt' => $promotional_code_activation_txt, 'request_id' => $result->id, 'error_code' => 411, 'walker' => $driver_data); $message1 = $client_push_data; $owner_data = Owner::find($result->owner_id); $title1 = "Now Driver Found."; if ($owner_data->is_deleted == 0) { send_notifications($owner_data->id, "owner", $title1, $message1); } /* CLIENT PUSH FOR GETTING DRIVER DETAILS END */ // request ended if ($result->promo_id) { $promo_update_counter = PromoCodes::find($result->promo_id); $promo_update_counter->uses = $promo_update_counter->uses + 1; $promo_update_counter->save(); UserPromoUse::where('user_id', '=', $result->owner_id)->where('code_id', '=', $result->promo_id)->delete(); $owner = Owner::find($result->owner_id); $owner->promo_count = $owner->promo_count - 1; $owner->save(); $request = Requests::find($result->id); $request->promo_id = 0; $request->promo_code = ""; $request->save(); } Requests::where('id', '=', $result->id)->update(array('current_walker' => 0, 'status' => 1)); /* $driver = Keywords::where('id', 1)->first(); */ $owne = Owner::where('id', $result->owner_id)->first(); /* $driver_keyword = $driver->keyword; */ $driver_keyword = Config::get('app.generic_keywords.Provider'); $owner_data_id = $owne->id; send_notifications($owner_data_id, "owner", 'No ' . $driver_keyword . ' Found', 'No ' . $driver_keyword . ' are available right now in your area. Kindly try after sometime.'); $owner = Owner::find($result->owner_id); $settings = Settings::where('key', 'sms_request_unanswered')->first(); $pattern = $settings->value; $pattern = str_replace('%id%', $result->id, $pattern); $pattern = str_replace('%user%', $owner->first_name, $pattern); $pattern = str_replace('%user_mobile%', $owner->phone, $pattern); sms_notification(1, 'admin', $pattern); // send email /* $settings = Settings::where('key', 'email_request_unanswered')->first(); $pattern = $settings->value; $pattern = str_replace('%id%', $result->id, $pattern); $pattern = str_replace('%url%', web_url() . "/admin/request/map/" . $result->id, $pattern); $subject = "New Request Unanswered"; email_notification(1, 'admin', $pattern, $subject); */ $settings = Settings::where('key', 'admin_email_address')->first(); $admin_email = $settings->value; $follow_url = web_url() . "/user/signin"; $pattern = array('admin_eamil' => $admin_email); $subject = "New Request Unansweres"; email_notification(1, 'admin', $pattern, $subject, 'request_not_answered', null); } } } }