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);
}
}
}
}
