public function checkout(Request $request)
 {
     $response = new stdClass();
     if ($request->isMethod('post')) {
         $postData = $request->all();
         $userId = $postData['id'];
         $token = $postData['token'];
         $amount = $postData['money'];
         $name = $postData['name'];
         $addrLine1 = $postData['addrLine1'];
         $city = $postData['city'];
         $state = $postData['state'];
         $country = $postData['country'];
         $email = $postData['email'];
         $zipCode = $postData['zipCode'];
         $phoneNumber = $postData['phoneNumber'];
         $authFlag = false;
         if (isset($postData['api_token'])) {
             $apiToken = $postData['api_token'];
             if ($apiToken == $this->API_TOKEN) {
                 $authFlag = true;
             } else {
                 $authFlag = false;
             }
         }
         if ($authFlag) {
             $rules = array('money' => 'required|regex:/^[0-9]+([.][0-9]{0,2}+)?$/', 'name' => 'required', 'addrLine1' => 'required', 'city' => 'required', 'state' => 'required', 'zipCode' => 'required', 'country' => 'required', 'email' => 'required', 'phoneNumber' => 'required');
             $message = array('money.required' => 'Please Enter Amount that you want to add to your wallet', 'money.regex' => 'Please Enter a valid Amount i.e. number or decimal value ', 'name.required' => 'please enter your name', 'addrLine1.required' => 'please enter address', 'city.required' => 'please enter city', 'state.required' => 'please enter state', 'zipCode.required' => 'please provide zip code', 'country.required' => 'please specify country name', 'email.required' => 'please enter your email', 'phoneNumber.required' => 'please enter your phone number');
             $validator = Validator::make($request->all(), $rules, $message);
             if (!$validator->fails()) {
                 \Twocheckout::privateKey('1768AF13-92B6-4B9D-8493-66E884E98FEF');
                 \Twocheckout::sellerId('901311477');
                 \Twocheckout::sandbox(true);
                 #Uncomment to use Sandbox
                 \Twocheckout::verifySSL(false);
                 try {
                     $charge = \Twocheckout_Charge::auth(array("merchantOrderId" => "123", "token" => $token, "currency" => 'USD', "total" => $amount, "billingAddr" => array("name" => $name, "addrLine1" => $addrLine1, "city" => $city, "state" => $state, "zipCode" => $zipCode, "country" => $country, "email" => $email, "phoneNumber" => $phoneNumber)));
                     //                        echo json_encode($charge,true);die;
                     //                        echo '<pre>';
                     //            print_r($charge);die;
                     if ($charge['response']['responseCode'] == 'APPROVED') {
                         //                            echo "Thanks for your Order!";
                         //                            echo "<h3>Return Parameters:</h3>";
                         //                            echo "<pre>";
                         //                            print_r($charge);
                         //                            echo "</pre>";
                         //                            echo die;
                         $transactionId = $charge['response']['transactionId'];
                         $objModelTransaction = new Transaction();
                         $input = array('tx_id' => '', 'tx_type' => '1', 'tx_mode' => '1', 'tx_code' => ' ', 'transaction_id' => $transactionId, 'user_id' => $userId, 'amount' => $amount, 'payment_time' => time() + 19800);
                         $result = $objModelTransaction->addNewTransaction($input);
                         //code for increasing the amount (updating the account bal)
                         // first checking that user has details in usersmeta table or not, if not then acc_bal will be 0 & add users with amount
                         // or if yes then update accountbalance
                         $objModelUsermeta = new Usersmeta();
                         $whereForUpdateUser = array('rawQuery' => 'user_id = ?', 'bindParams' => [$userId]);
                         $isUserAvailable = $objModelUsermeta->getUsermetaWhere($whereForUpdateUser);
                         if ($isUserAvailable) {
                             $accountBal = $isUserAvailable->account_bal;
                             $totalBalance = $accountBal + $amount;
                             $dataForUpdateUser = array('account_bal' => $totalBalance);
                             //                        return $dataForUpdateUser;
                             $updated = $objModelUsermeta->updateUsermetaWhere($dataForUpdateUser, $whereForUpdateUser);
                         } else {
                             $accountBal = 0;
                             $totalBalance = $accountBal + $amount;
                             $addData = array('user_id' => $userId, 'account_bal' => $totalBalance);
                             $addUsermeta = $objModelUsermeta->addUsermeta($addData);
                         }
                         // code for generating NOTIFICATION
                         $objModelNotification = Notification::getInstance();
                         $input = array('notification_id' => '', 'user_id' => $userId, 'notifications_txt' => '$ ' . $amount . ' is successfully credited to your account through 2CO credit card payment');
                         $addNotification = $objModelNotification->addNewNotification($input);
                         $response->code = 200;
                         $response->message = "Payment Approved";
                         $response->data = $totalBalance;
                         echo json_encode($response, true);
                     }
                 } catch (\Twocheckout_Error $e) {
                     echo json_encode($e->getMessage(), true);
                     //                        print_r($e->getMessage());
                 }
             }
         }
     }
 }
 public function updateProfileInfo(Request $request)
 {
     $response = new stdClass();
     if ($request->isMethod('post')) {
         $postData = $request->all();
         $objUserModel = new User();
         $objUsermetaModel = new Usersmeta();
         $userId = isset($postData['user_id']) ? $postData['user_id'] : '';
         $firstname = isset($postData['firstname']) ? $postData['firstname'] : '';
         $lastname = isset($postData['lastname']) ? $postData['lastname'] : '';
         $email = isset($postData['email']) ? $postData['email'] : '';
         $username = isset($postData['username']) ? $postData['username'] : '';
         $skypeUsername = isset($postData['skypeUsername']) ? $postData['skypeUsername'] : '';
         $addressline1 = "";
         if (isset($postData['addressline1'])) {
             $addressline1 = $postData['addressline1'];
         }
         $addressline2 = "";
         if (isset($postData['addressline2'])) {
             $addressline2 = $postData['addressline2'];
         }
         $city = "";
         if (isset($postData['city'])) {
             $city = $postData['city'];
         }
         $state = "";
         if (isset($postData['state'])) {
             $state = $postData['state'];
         }
         $country_id = "";
         if (isset($postData['country_id'])) {
             $country_id = $postData['country_id'];
         }
         $contact_no = "";
         if (isset($postData['contact_no'])) {
             $contact_no = $postData['contact_no'];
         }
         $authFlag = false;
         if (isset($postData['api_token'])) {
             if ($userId != '') {
                 $where = ['rawQuery' => 'id=?', 'bindParams' => [$userId]];
                 $selectColumn = array('login_token');
                 $userCredentials = $objUserModel->getUsercredsWhere($where, $selectColumn);
                 if ($userCredentials) {
                     $apiToken = $postData['api_token'];
                     if ($apiToken == $this->API_TOKEN) {
                         $authFlag = true;
                     } else {
                         if ($apiToken == $userCredentials->login_token) {
                             $authFlag = true;
                         }
                     }
                 }
             }
         }
         if ($authFlag) {
             $rules = array('firstname' => 'required|regex:/^[A-Za-z\\s]+$/|max:255', 'lastname' => 'required|regex:/^[A-Za-z\\s]+$/|max:255', 'username' => 'required|regex:/^[A-Za-z0-9._\\s]+$/|max:255', 'email' => 'required|email|max:255', 'user_id' => 'required');
             $messages = ['firstname.regex' => 'The :attribute cannot contain special characters.', 'lastname.regex' => 'The :attribute cannot contain special characters.', 'username.regex' => 'The :attribute cannot contain special characters.'];
             $validator = Validator::make($request->all(), $rules, $messages);
             if (!$validator->fails()) {
                 $where = ['rawQuery' => 'id =?', 'bindParams' => [$userId]];
                 $currentUserDetails = $objUserModel->getUsercredsWhere($where);
                 $uniqueFlag = false;
                 if ($currentUserDetails->username == $username && $currentUserDetails->username == $email) {
                     $uniqueFlag = true;
                 } else {
                     if ($currentUserDetails->username != $username && $currentUserDetails->username == $email) {
                         $uniqueFlag = true;
                     } else {
                         if ($currentUserDetails->username == $username && $currentUserDetails->username != $email) {
                             $uniqueFlag = true;
                         } else {
                             $rules = array();
                             $validator = Validator::make($request->all(), $rules);
                             if ($validator->fails()) {
                                 $response->code = 100;
                                 $response->message = $validator->messages();
                                 $response->data = null;
                                 echo json_encode($response, true);
                             } else {
                                 $uniqueFlag = true;
                             }
                         }
                     }
                 }
                 if ($uniqueFlag) {
                     $updateUserWhereId = ['rawQuery' => 'id =?', 'bindParams' => [$userId]];
                     $data = array('name' => $firstname, 'lastname' => $lastname, 'username' => $username, 'skype_username' => $skypeUsername, 'email' => $email);
                     $updategeneralinfo = $objUserModel->UpdateUserDetailsbyId($updateUserWhereId, $data);
                     $updateUsermetaWhereUserId = ['rawQuery' => 'user_id =?', 'bindParams' => [$userId]];
                     $updateUsermeta = "";
                     $addUsermeta = "";
                     $isUserAvailable = $objUsermetaModel->getUsermetaWhere($updateUsermetaWhereUserId);
                     if ($isUserAvailable) {
                         $dataUpdate = array('addressline1' => $addressline1, 'addressline2' => $addressline2, 'city' => $city, 'state' => $state, 'country_id' => $country_id, 'contact_no' => $contact_no);
                         $updateUsermeta = $objUsermetaModel->updateUsermetaWhere($updateUsermetaWhereUserId, $dataUpdate);
                     } else {
                         $addData = array('user_id' => $userId, 'addressline1' => $addressline1, 'addressline2' => $addressline2, 'city' => $city, 'state' => $state, 'country_id' => $country_id, 'contact_no' => $contact_no, 'account_bal' => 0.0);
                         $addUsermeta = $objUsermetaModel->addUsermeta($addData);
                     }
                     if ($updategeneralinfo || $updateUsermeta || $addUsermeta) {
                         $response->code = 200;
                         $response->message = "Update Successful";
                         $response->data = $updategeneralinfo;
                         echo json_encode($response, true);
                     } else {
                         $response->code = 400;
                         $response->message = "Information Already updated";
                         $response->data = 1;
                         echo json_encode($response, true);
                     }
                 }
             } else {
                 $response->code = 400;
                 $response->message = $validator->messages();
                 $response->data = null;
                 echo json_encode($response, true);
             }
         } else {
             $response->code = 401;
             $response->message = "Access Denied";
             $response->data = null;
             echo json_encode($response, true);
         }
     } else {
         $response->code = 400;
         $response->message = "Request not allowed";
         $response->data = null;
         echo json_encode($response, true);
     }
 }
 public function checkUserProfileViews($userDetails)
 {
     $instagramScrape = new API\InstagramAPI\Instagram_scrape();
     //        $objInstagramAPI = new API\InstagramAPI\Instagram();
     $instagramUserModel = new Instagram_User();
     $objUsermetaModel = new Usersmeta();
     $objOrderModel = new Order();
     $whereIn = implode(',', array_unique(array_map(function ($v) {
         return $v->ins_user_id;
     }, $userDetails)));
     $insUserStatus = $instagramUserModel->updateUserDetails(['rawQuery' => 'ins_user_id IN(' . $whereIn . ')'], ['cronjob_status' => 0]);
     //replace with 1
     if (!Session::has('FE_in_checkUserProfile')) {
         //FE=Fatal_Error
         $fataErrorData['whereIn'] = $whereIn;
         $fataErrorData['modalObject'] = $instagramUserModel;
         $fataErrorData['functionName'] = 'updateUserDetails';
         $fataErrorData['params'] = 'ins_user_id';
         Session::put('FE_in_checkUserProfile', $fataErrorData);
     }
     try {
         $id = 1;
         foreach ($userDetails as $user) {
             $username = $user->ins_username;
             print_r($id . ' . ');
             print_r($username);
             echo "<br>";
             ++$id;
             $username = $user->ins_username;
             $picsFetchCount = intval($user->pics_fetch_count);
             //            $picsDone = intval($user->pics_done);
             $picLimit = intval($user->pics_limit);
             $dailyPostLimit = intval($user->daily_post_limit);
             $dailyPostDone = intval($user->daily_post_done);
             $lastPostCreatedTime = intval($user->last_post_created_time);
             $firstPost_deliveryTime_day = intval($user->firstpost_delivery_daytime);
             $orderDelay = intval($user->order_delay_flag);
             $endDateTime = intval($user->end_date_time);
             $whereInsUser = ['rawQuery' => 'ins_user_id=?', 'bindParams' => [$user->ins_user_id]];
             // code for reset daily limit every 24 hr. If daily limit cross then stop  autolikes script for next 24 hrs.
             // Daily limit will be automatically reset every 24 hours from the time the user make the first post
             if (intval($user->ig_user_status) == 2 || intval($user->ig_user_status) == 3) {
                 if ($firstPost_deliveryTime_day != 0) {
                     if (time() - $firstPost_deliveryTime_day >= 86400) {
                         //24 hr = 86400 seconds
                         $updatedData23 = ['last_post_created_time' => time(), 'firstpost_delivery_daytime' => time(), 'daily_post_done' => 0, 'ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!'];
                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData23);
                     }
                 } else {
                     if (intval($user->ig_user_status) == 3) {
                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]);
                     }
                 }
             }
             // This script will run when autolikes script was stopped due to in-sufficient balance,
             // This code will automatically reset autolikes running script when user add balance in account.
             if (intval($user->ig_user_status) == 3) {
                 if ($user->last_order_total_price != 0) {
                     $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']);
                     $accountBalance = $accountBalanceDetails->account_bal;
                     if ($accountBalance >= $user->last_order_total_price) {
                         $updatedData3 = ['ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!'];
                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData3);
                     }
                 } else {
                     $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]);
                 }
             }
             $expiredFlag = false;
             if ($endDateTime != 0 && $endDateTime < time()) {
                 if ($user->ig_user_status != 4) {
                     $updatedData = ['ig_user_status' => 4, 'cronjob_status' => 0, 'message' => 'This profile #' . $username . ' has expired. If you wish to continue, increase the end date in edit option. '];
                     $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData);
                 } else {
                     $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['cronjob_status' => 0]);
                 }
                 $expiredFlag = true;
             } else {
                 if ($user->ig_user_status == 4) {
                     $updatedData = ['ig_user_status' => 2, 'cronjob_status' => 0, 'message' => 'The script is waiting for new post. Searching new post in every 5 minutes!'];
                     $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updatedData);
                 }
             }
             if (!$expiredFlag) {
                 if (intval($user->ig_user_status) == 2) {
                     if ($lastPostCreatedTime == 0) {
                         $lastPostCreatedTime = time();
                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, ['last_post_created_time' => time()]);
                     }
                     if ($dailyPostLimit > 0) {
                         if ($picsFetchCount < $picLimit) {
                             if ($dailyPostDone < $dailyPostLimit) {
                                 //scrap all the latest post created after the last post created time
                                 $userDetails = [];
                                 //                                    if (intval($user->plan_type) == 0) {// for likes
                                 ////                                        print_r($username); echo"<br>";
                                 //                                        $username = strtolower($username);
                                 ////                                        $userDetails = $objInstagramAPI->UserDetailsByUsernameWithLastPostCreatedTime($username, $user->last_post_created_time);
                                 //                                        $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, 'image');
                                 //
                                 ////                                        $userProfileData = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, $dailyPostLimit, 'image');
                                 //                                    } else if (intval($user->plan_type) == 4) { // for video
                                 $username = strtolower($username);
                                 $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, 'video');
                                 //                                        $userProfileData = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, $dailyPostLimit, 'video');
                                 //                                    }
                                 //                                dd($userProfileData);
                                 if ($userDetails != null) {
                                     // && $userDetails != "Username does not exist" && $userDetails != "user is private"
                                     $latestPostCreatedTime = 0;
                                     $latestPostCreatedTimeFlag = false;
                                     $latestDeliveryLink = '';
                                     $startTime = time();
                                     $userDetails = array_reverse($userDetails, true);
                                     foreach ($userDetails as $key => $value) {
                                         $startTime = time();
                                         $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime;
                                         //600= 10 minutes delay in next order
                                         // get the latest post link and place that link  for autolikes order
                                         if ($dailyPostDone < $dailyPostLimit && $picsFetchCount < $picLimit) {
                                             //add order in order table and then in order-process table
                                             // This code is for placing  autolikes order only (likes orders)
                                             // check if auto comment is set or not
                                             $autoCommentsPrice = 0;
                                             $autoCommentsData = array();
                                             if ($user->autoComments == "YES") {
                                                 $autoCommentsPrice = $user->price_for_autoComments / 1000 * $user->comments_amount;
                                                 $autoCommentsData['plan_id'] = $user->plan_id_for_autoComments;
                                                 $autoCommentsData['by_user_id'] = $user->by_user_id;
                                                 $autoCommentsData['for_user_id'] = $user->ins_user_id;
                                                 $autoCommentsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                 $autoCommentsData['quantity_total'] = $user->comments_amount;
                                                 $autoCommentsData['comment_id'] = $user->custom_comment_id;
                                                 $autoCommentsData['start_time'] = $startTime;
                                                 $autoCommentsData['added_time'] = time();
                                                 $autoCommentsData['updated_time'] = time();
                                                 $autoCommentsData['auto_order_status'] = 1;
                                                 // 1=autolikes order
                                                 $autoCommentsData['status'] = 0;
                                                 // order is in pending state
                                                 $autoCommentsData['price'] = $autoCommentsPrice;
                                                 $autoCommentsData['orders_per_run'] = 0;
                                                 $autoCommentsData['time_interval'] = 0;
                                                 $autoCommentsData['url_type'] = 0;
                                                 // 0=postLink
                                                 $autoCommentsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!';
                                                 // 0=postLink
                                             }
                                             $autoLikesPrice = $user->charge_per_unit / 1000 * $user->likes_per_pic;
                                             $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']);
                                             $accountBalance = $accountBalanceDetails->account_bal;
                                             $totalPrice = $autoLikesPrice + $autoCommentsPrice;
                                             if ($accountBalance >= $totalPrice) {
                                                 $autoLikesData['plan_id'] = $user->plan_id;
                                                 $autoLikesData['by_user_id'] = $user->by_user_id;
                                                 $autoLikesData['for_user_id'] = $user->ins_user_id;
                                                 //code added and modified by Saurabh
                                                 $autoLikesData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                 $autoLikesData['initial_likes_count'] = $value['likes_count'];
                                                 $autoLikesData['initial_followers_count'] = $value['followers_count'];
                                                 $autoLikesData['initial_comments_count'] = $value['comments_count'];
                                                 $autoLikesData['initial_views_count'] = $value['views_count'];
                                                 $autoLikesData['quantity_total'] = $user->likes_per_pic;
                                                 $autoLikesData['start_time'] = $startTime;
                                                 $autoLikesData['added_time'] = time();
                                                 $autoLikesData['updated_time'] = time();
                                                 $autoLikesData['auto_order_status'] = 1;
                                                 // 1=autolikes order
                                                 $autoLikesData['status'] = 0;
                                                 // order is in pending state
                                                 $autoLikesData['price'] = $autoLikesPrice;
                                                 $autoLikesData['orders_per_run'] = 0;
                                                 $autoLikesData['time_interval'] = 0;
                                                 $autoLikesData['url_type'] = 0;
                                                 // 0=postLink
                                                 $autoLikesData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!';
                                                 // 0=postLink
                                                 $rollback = false;
                                                 DB::beginTransaction();
                                                 DB::table('usersmeta')->where('user_id', '=', $user->by_user_id)->lockForUpdate()->get();
                                                 $autoLikesOrderInsertedStatus = $objOrderModel->insertOrder($autoLikesData);
                                                 $autoCommentsOrderInsertedStatus = 1;
                                                 if ($user->autoComments == "YES") {
                                                     $autoCommentsOrderInsertedStatus = $objOrderModel->insertOrder($autoCommentsData);
                                                 }
                                                 if ($autoLikesOrderInsertedStatus && $autoCommentsOrderInsertedStatus) {
                                                     $current_bal['account_bal'] = $accountBalance - $totalPrice;
                                                     $orderUpdateBalanceStatus = $objUsermetaModel->updateUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], $current_bal);
                                                     if ($orderUpdateBalanceStatus) {
                                                         DB::commit();
                                                     } else {
                                                         $rollback = true;
                                                         DB::rollBack();
                                                     }
                                                 } else {
                                                     $rollback = true;
                                                     DB::rollBack();
                                                 }
                                                 if (!$rollback) {
                                                     //this code runs only when user make the first post (first order is placed).
                                                     if ($firstPost_deliveryTime_day == 0) {
                                                         $data4['firstpost_delivery_daytime'] = time();
                                                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data4);
                                                     }
                                                     ++$picsFetchCount;
                                                     ++$dailyPostDone;
                                                     $latestPostCreatedTime = $value['created_time'];
                                                     $latestDeliveryLink = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                     $latestPostCreatedTimeFlag = true;
                                                     //modified by saurabh
                                                     $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime;
                                                     // for adding 10 MORE minutes delay in next order // if flag is not set than order will place at instant
                                                     //                                                $startTime += 600;//600= 10 minutes delay in next order placing
                                                 }
                                             } else {
                                                 $data5 = ['cronjob_status' => 0, 'ig_user_status' => 3, 'last_order_total_price' => $totalPrice, 'message' => 'Autolikes script has been stopped for # ' . $user->ins_username . ' due to insufficient balance.'];
                                                 $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data5);
                                                 break;
                                             }
                                         }
                                     }
                                     //End of inner foreach loop
                                     // Update details in instagram_users table
                                     if ($latestPostCreatedTimeFlag) {
                                         $data6['pics_fetch_count'] = $picsFetchCount;
                                         $data6['daily_post_done'] = $dailyPostDone;
                                         $data6['last_post_created_time'] = $latestPostCreatedTime;
                                         $data6['last_delivery_link'] = $latestDeliveryLink;
                                         //                                            print_r($data6);
                                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data6);
                                     }
                                 }
                             }
                         }
                     } else {
                         if ($dailyPostLimit == 0) {
                             if ($picsFetchCount < $picLimit) {
                                 //scrap all the latest post created after the first post created time
                                 $userDetails = [];
                                 //                                if ($user->plan_type == 0) {// for likes
                                 ////                                    $objInstagramAPI = new API\InstagramAPI\Instagram();
                                 ////                                    print_r($username); echo "<br>";
                                 //                                    $username = strtolower($username);
                                 ////                                    $userDetails = $objInstagramAPI->UserDetailsByUsernameWithLastPostCreatedTime($username, $user->last_post_created_time);
                                 //                                    $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, "image");
                                 ////                                    dd($userDetails);
                                 ////                                    $userProfileData = (isset($userDetails['instagramUsersData'])) ? $userDetails['instagramUsersData'] : '';
                                 //
                                 //
                                 ////                                    $userDetails = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, 0, 'image');
                                 ////                                    dd($userDetails['instagramUsersData']);
                                 //                                } else if ($user->plan_type == 4) { // for video
                                 $username = strtolower($username);
                                 $userDetails = $instagramScrape->instagramScrape($username, $lastPostCreatedTime, "video");
                                 //                                    $userDetails = $instagramScrape->getInsUserLatestPostDetails($username, $lastPostCreatedTime, 0, 'video');
                                 //                                }
                                 if ($userDetails != null) {
                                     // && $userDetails != "Username does not exist" && $userDetails != "user is private"
                                     $latestPostCreatedTime = 0;
                                     $latestDeliveryLink = '';
                                     $latestPostCreatedTimeFlag = false;
                                     $startTime = time();
                                     $userDetails = array_reverse($userDetails, true);
                                     foreach ($userDetails as $key => $value) {
                                         $startTime = time();
                                         $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime;
                                         //600= 10 minutes delay in next order
                                         // get the latest post link and place that link  for autolikes order
                                         if ($picsFetchCount < $picLimit) {
                                             //add order in order table and then in order-process table
                                             // This code is for placing  autolikes order only (likes orders)
                                             $autoCommentsPrice = 0;
                                             $autoCommentsData = array();
                                             if ($user->autoComments == "YES") {
                                                 $autoCommentsPrice = $user->price_for_autoComments / 1000 * $user->comments_amount;
                                                 $autoCommentsData['plan_id'] = $user->plan_id_for_autoComments;
                                                 $autoCommentsData['by_user_id'] = $user->by_user_id;
                                                 $autoCommentsData['for_user_id'] = $user->ins_user_id;
                                                 $autoCommentsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                 $autoCommentsData['quantity_total'] = $user->comments_amount;
                                                 $autoCommentsData['comment_id'] = $user->custom_comment_id;
                                                 $autoCommentsData['start_time'] = $startTime;
                                                 $autoCommentsData['added_time'] = time();
                                                 $autoCommentsData['updated_time'] = time();
                                                 $autoCommentsData['auto_order_status'] = 1;
                                                 // 1=autolikes order
                                                 $autoCommentsData['status'] = 0;
                                                 // order is in pending state
                                                 $autoCommentsData['price'] = $autoCommentsPrice;
                                                 $autoCommentsData['orders_per_run'] = 0;
                                                 $autoCommentsData['time_interval'] = 0;
                                                 $autoCommentsData['url_type'] = 0;
                                                 // 0=postLink
                                                 $autoCommentsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!';
                                                 // 0=postLink
                                             }
                                             $autoLikesOrViewsPrice = $user->charge_per_unit / 1000 * $user->likes_per_pic;
                                             //likes_per_pic is same as views per pic
                                             $accountBalanceDetails = $objUsermetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], ['account_bal']);
                                             $accountBalance = $accountBalanceDetails->account_bal;
                                             $totalPrice = $autoLikesOrViewsPrice + $autoCommentsPrice;
                                             if ($accountBalance >= $totalPrice) {
                                                 $autoLikesOrViewsData['plan_id'] = $user->plan_id;
                                                 $autoLikesOrViewsData['by_user_id'] = $user->by_user_id;
                                                 $autoLikesOrViewsData['for_user_id'] = $user->ins_user_id;
                                                 $autoLikesOrViewsData['ins_url'] = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                 $autoLikesOrViewsData['initial_likes_count'] = $value['likes_count'];
                                                 $autoLikesOrViewsData['initial_followers_count'] = $value['followers_count'];
                                                 $autoLikesOrViewsData['initial_comments_count'] = $value['comments_count'];
                                                 $autoLikesOrViewsData['initial_views_count'] = $value['views_count'];
                                                 $autoLikesOrViewsData['quantity_total'] = $user->likes_per_pic;
                                                 //likes_per_pic is same as views per pic
                                                 $autoLikesOrViewsData['start_time'] = $startTime;
                                                 $autoLikesOrViewsData['added_time'] = time();
                                                 $autoLikesOrViewsData['updated_time'] = time();
                                                 $autoLikesOrViewsData['auto_order_status'] = 1;
                                                 // 1=autolikes order
                                                 $autoLikesOrViewsData['status'] = 0;
                                                 // order is in pending state
                                                 $autoLikesOrViewsData['price'] = $autoLikesOrViewsPrice;
                                                 $autoLikesOrViewsData['orders_per_run'] = 0;
                                                 $autoLikesOrViewsData['time_interval'] = 0;
                                                 $autoLikesOrViewsData['url_type'] = 0;
                                                 // 0=postLink
                                                 $autoLikesOrViewsData['order_message'] = 'Order has inserted! This order has a schedule time and it will start after (' . $this->getDateDifference($startTime) . ').Please wait to get it started!';
                                                 $rollback = false;
                                                 DB::beginTransaction();
                                                 DB::table('usersmeta')->where('user_id', '=', $user->by_user_id)->lockForUpdate()->get();
                                                 $orderInsertedStatus = $objOrderModel->insertOrder($autoLikesOrViewsData);
                                                 $commentsOrderInsertedStatus = 1;
                                                 if ($user->autoComments == "YES") {
                                                     $commentsOrderInsertedStatus = $objOrderModel->insertOrder($autoCommentsData);
                                                 }
                                                 if ($orderInsertedStatus && $commentsOrderInsertedStatus) {
                                                     $current_bal['account_bal'] = $accountBalance - $totalPrice;
                                                     $orderUpdateBalanceStatus = $objUsermetaModel->updateUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [$user->by_user_id]], $current_bal);
                                                     if ($orderUpdateBalanceStatus) {
                                                         DB::commit();
                                                     } else {
                                                         $rollback = true;
                                                         DB::rollBack();
                                                     }
                                                 } else {
                                                     $rollback = true;
                                                     DB::rollBack();
                                                 }
                                                 if (!$rollback) {
                                                     //                                            // Update details in instagram_users table
                                                     //                                            $whereInsUser = ['rawQuery' => 'ins_user_id=?', 'bindParams' => [$user->ins_user_id]];
                                                     //                                            $updateInsUserData = [
                                                     //                                                'pics_fetch_count' => ++$picsFetchCount,
                                                     //                                                'daily_post_done' => ++$dailyPostDone,
                                                     //                                                'cronjob_status' => 0,
                                                     //                                                'last_check' => time(),
                                                     ////                                            'last_delivery' => time(),
                                                     ////                                            'last_delivery_link' => $value['link'],
                                                     //                                                'last_post_created_time' => $value['created_time']
                                                     //                                            ];
                                                     //                                            $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserData);
                                                     //this code is run only when user make the first post (first order is placed).
                                                     if ($firstPost_deliveryTime_day == 0) {
                                                         $data4['firstpost_delivery_daytime'] = time();
                                                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data4);
                                                     }
                                                     ++$picsFetchCount;
                                                     ++$dailyPostDone;
                                                     $latestPostCreatedTime = $value['created_time'];
                                                     $latestDeliveryLink = "https://www.instagram.com/p/" . $value['link'] . "/";
                                                     $latestPostCreatedTimeFlag = true;
                                                     //modified by saurabh
                                                     // for adding 10 MORE minutes delay in next order, if flag is not set than order will place at instant
                                                     $startTime = $orderDelay == 1 ? $startTime + 600 : $startTime;
                                                     //$startTime += 600;//600= 10 minutes delay in next order placing
                                                 }
                                             } else {
                                                 // insert your custom message here in instagram_users table
                                                 $updateInsUserMessageData = ['cronjob_status' => 0, 'ig_user_status' => 3, 'last_order_total_price' => $totalPrice, 'message' => 'Autolikes script has been stopped for # ' . $user->ins_username . ' due to insufficient balance.'];
                                                 $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserMessageData);
                                                 break;
                                             }
                                         }
                                     }
                                     //End of inner foreach loop
                                     // Update details in instagram_users table
                                     if ($latestPostCreatedTimeFlag) {
                                         $data6['pics_fetch_count'] = $picsFetchCount;
                                         $data6['daily_post_done'] = $dailyPostDone;
                                         $data6['last_post_created_time'] = $latestPostCreatedTime;
                                         $data6['last_delivery_link'] = $latestDeliveryLink;
                                         //                                        print_r($data6);echo "<br>";
                                         $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $data6);
                                     }
                                 }
                             }
                         }
                     }
                     $updateInsUserData = ['cronjob_status' => 0, 'last_check' => time()];
                     $queryResult = $instagramUserModel->updateUserDetails($whereInsUser, $updateInsUserData);
                 }
             }
         }
         //End of Outer foreach loop
     } catch (\Exception $e) {
         echo $e->getMessage();
         $insUserStatus = $instagramUserModel->updateUserDetails(['rawQuery' => 'ins_user_id IN(' . $whereIn . ')'], ['cronjob_status' => 0]);
     }
 }
 public function expressCallback(Request $request)
 {
     //        return 23;
     $response = new stdClass();
     $postData = $request->all();
     $userId = $postData['id'];
     $amount = $postData['amount'];
     $payerid = $postData['PayerID'];
     $token = $postData['token'];
     //        print_r($token);print_r($payerid);die;
     $authFlag = false;
     if (isset($postData['api_token'])) {
         $apiToken = $postData['api_token'];
         if ($apiToken == $this->API_TOKEN) {
             $authFlag = true;
         }
     }
     if ($authFlag) {
         $objpaypal = Paypal::getInstance();
         $result = $objpaypal->ConfirmPayment($amount, $token, $payerid);
         //                echo"<pre>";print_r($result);die;
         //            echo json_encode($result, true);
         if ($result) {
             //                $function_result=$this->myCurlFunction();
             //                return $function_result;
             if ($result['ACK'] == "Success") {
                 //                    $response->code = 200;
                 //                    $response->message = "Amount added to your Wallet Successfully.";
                 $data['transactionId'] = $result['PAYMENTINFO_0_TRANSACTIONID'];
                 $data['acknowledgement'] = $result['ACK'];
                 $data['amount'] = $amount;
                 $data['paymentTime'] = date('Y-m-d H:i:s');
                 $transactionId = $data['transactionId'];
                 $amount = $data['amount'];
                 $paymentTime = $data['paymentTime'];
                 $objModelTransaction = new Transaction();
                 $input = array('tx_id' => '', 'tx_type' => '1', 'tx_mode' => '0', 'tx_code' => ' ', 'transaction_id' => $transactionId, 'user_id' => $userId, 'amount' => $amount, 'payment_time' => strtotime($paymentTime));
                 $result = $objModelTransaction->addNewTransaction($input);
                 //code for increasing the amount (updating the account bal)
                 // first checking that user has details in usersmeta table or not, if not then acc_bal will be 0 & add users with amount
                 // or if yes then update accountbalance
                 $objModelUsermeta = new Usersmeta();
                 $whereForUpdateUser = array('rawQuery' => 'user_id = ?', 'bindParams' => [$userId]);
                 $isUserAvailable = $objModelUsermeta->getUsermetaWhere($whereForUpdateUser);
                 if ($isUserAvailable) {
                     $accountBal = $isUserAvailable->account_bal;
                     $totalBalance = $accountBal + $amount;
                     $dataForUpdateUser = array('account_bal' => $totalBalance);
                     //                        return $dataForUpdateUser;
                     $updated = $objModelUsermeta->updateUsermetaWhere($whereForUpdateUser, $dataForUpdateUser);
                 } else {
                     $accountBal = 0;
                     $totalBalance = $accountBal + $amount;
                     $addData = array('user_id' => $userId, 'account_bal' => $totalBalance);
                     $addUsermeta = $objModelUsermeta->addUsermeta($addData);
                 }
                 // code for generating NOTIFICATION
                 $objModelNotification = Notification::getInstance();
                 $input = array('notification_id' => '', 'user_id' => $userId, 'notifications_txt' => '$ ' . $amount . ' is successfully credited to your account');
                 $addNotification = $objModelNotification->addNewNotification($input);
                 $response->code = 200;
                 $response->message = "Amount added to your Wallet Successfully.";
                 //                    $response->notification="Your Account is Successfully Credited.";
                 $response->data = $totalBalance;
                 //                    echo '<pre>';print_r($response);die;
                 //                    return $response;
                 echo json_encode($response, true);
             } else {
                 if ($result['ACK'] == "SuccessWithWarning") {
                     //                        return 6;
                     $response->code = 07;
                     $response->message = "Amount added to your Wallet Successfully.";
                     $data['transactionId'] = $result['PAYMENTINFO_0_TRANSACTIONID'];
                     $data['acknowledgement'] = $result['ACK'];
                     $data['amount'] = $amount;
                     $data['paymentTime'] = date('Y-m-d H:i:s');
                     $response->data = $data;
                     echo json_encode($response, true);
                     //                        echo'<pre>';print_r($data);die;
                     //                        return $response->data = $data;
                     //                        echo "<pre>";
                     //                        print_r($result);
                     //                        die;
                     //                        return 7;
                 } else {
                     $response->code = 400;
                     $response->message = "Some ERROR OCCURRED.";
                     echo "<pre>";
                     print_r($result);
                     die;
                 }
             }
         }
         //                if ($result['ACK'] == "Success") {
         //                    $response->code = 200;
         //                    $response->message = "Payment model created successfully.";
         //                    $data['transactionId'] = $result['PAYMENTINFO_0_TRANSACTIONID'];
         //                    $data['acknowledgement'] = $result['ACK'];
         //                    $data['amount'] = $amount;
         //                    $data['paymentTime'] = date('Y-m-d H:i:s');
         //                    $response->data = $data;
         //                }
         //                if ($result) {
         //                    $response->code = 200;
         //                    $response->message = "Payment model created successfully.";
         //                    $response->data = 1;
         //                    echo json_encode($response, true);
     } else {
         $response->code = 400;
         $response->message = "Error in getting callback results. auth flag is not set";
         $response->data = null;
         echo json_encode($response, true);
     }
     //
     //        $payerid = $request->input('PayerID');
     //        $token = $request->input('token');
     //
     //        $objpaypal = paypal::getInstance();
     //        $result = $objpaypal->ConfirmPayment($amount, $token, $payerid);
     //
     ////        echo "<pre>";print_r($result);
     ////        die;
     //        if ($result['ACK'] == "Success") {
     //            $data['transactionId'] = $result['PAYMENTINFO_0_TRANSACTIONID'];
     //            $data['acknowledgement'] = $result['ACK'];
     //            $data['amount'] = $amount;
     //            $data['paymentTime'] = date('Y-m-d H:i:s');
     //        } else {
     //            echo "<pre>";
     //            print_r($result);
     //            die;
     //        }
     //        echo "<pre>";
     //        print_r($data);
     //        die;
 }
 public function emailNotifications(Request $request)
 {
     $response = new stdClass();
     if ($request->isMethod('post')) {
         $postData = $request->all();
         $objUserModel = new User();
         $objUsersmetaModel = new Usersmeta();
         $userId = isset($request['user_id']) ? $request['user_id'] : '';
         $authFlag = false;
         if (isset($request['api_token'])) {
             $apiToken = $request['api_token'];
             if ($apiToken == $this->API_TOKEN) {
                 $authFlag = true;
             } else {
                 if ($userId != '') {
                     $where = ['rawQuery' => 'id=?', 'bindParams' => [$userId]];
                     $selectColumn = array('login_token');
                     $userCredentials = $objUserModel->getUsercredsWhere($where, $selectColumn);
                     if ($apiToken == $userCredentials->login_token) {
                         $authFlag = true;
                     }
                 }
             }
         }
         if ($authFlag) {
             $rules = ['notifyBalance' => 'required', 'notifyProfileLikes' => 'required', 'notifyDailySubscription' => "required", 'user_id' => 'required|exists:users,id'];
             $validatePlanId = Validator::make($postData, $rules);
             if (!$validatePlanId->fails()) {
                 $data['notify_bal'] = intval($postData['notifyBalance']);
                 $data['notify_profile_likes'] = intval($postData['notifyProfileLikes']);
                 $data['notify_daily_subscription'] = intval($postData['notifyDailySubscription']);
                 $isUserExistInUsersmeta = $objUsersmetaModel->getUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [intval($postData['user_id'])]]);
                 $queryResult = '';
                 if ($isUserExistInUsersmeta) {
                     $queryResult = $objUsersmetaModel->updateUsermetaWhere(['rawQuery' => 'user_id=?', 'bindParams' => [intval($postData['user_id'])]], $data);
                 } else {
                     $data['user_id'] = intval($postData['user_id']);
                     $data['account_bal'] = 0.0;
                     $queryResult = $objUsersmetaModel->addUsermeta($data);
                 }
                 if ($queryResult != 2) {
                     $response->code = 200;
                     $response->message = "Email Notification successfully updated";
                     $response->data = $data;
                     echo json_encode($response);
                 } else {
                     $response->code = 204;
                     $response->message = "Something went wrong! please try again after sometime.";
                     $response->data = null;
                     echo json_encode($response);
                 }
             } else {
                 $response->code = 204;
                 $response->message = $validatePlanId->messages();
                 $response->data = null;
                 echo json_encode($response);
             }
         } else {
             $response->code = 401;
             $response->message = "Access Denied";
             $response->data = null;
             echo json_encode($response, true);
         }
     } else {
         $response->code = 400;
         $response->message = "Request not allowed";
         $response->data = null;
         echo json_encode($response, true);
     }
 }
 function login(Request $request)
 {
     $response = new stdClass();
     if ($request->isMethod("POST")) {
         $postData = $request->all();
         $apiToken = "";
         if (isset($postData['api_token'])) {
             $apiToken = $postData['api_token'];
         }
         if ($apiToken == $this->API_TOKEN) {
             $rules = array('emailOrUsername' => 'required', 'password' => 'required');
             $messages = ['emailOrUsername.required' => 'Please enter email address or username ', 'password.required' => 'Please enter a password'];
             $validator = Validator::make($request->all(), $rules, $messages);
             if (!$validator->fails()) {
                 $objUserModel = new User();
                 $objUsermetaModel = new Usersmeta();
                 $username = $postData['emailOrUsername'];
                 $password = $postData['password'];
                 $field = 'username';
                 if (strpos($username, '@') !== false) {
                     $field = 'email';
                 }
                 if (Auth::attempt([$field => $username, 'password' => $password])) {
                     $whereForUser = ['rawQuery' => 'id =?', 'bindParams' => [Auth::id()]];
                     $userDetails = $objUserModel->getUsercredsWhere($whereForUser);
                     $whereForUsermeta = ['rawQuery' => 'user_id =?', 'bindParams' => [Auth::id()]];
                     //check if user id is exist in usersmeta if not then insert data in usersmeta table.
                     $isUserAvailable = $objUsermetaModel->getUsermetaWhere($whereForUsermeta, ['account_bal', 'notify_bal', 'notify_profile_likes', 'notify_daily_subscription']);
                     if (!isset($isUserAvailable->account_bal)) {
                         $addUsermeta = $objUsermetaModel->addUsermeta(['user_id' => Auth::id(), 'account_bal' => 0]);
                     } else {
                         $userDetails->account_bal = $isUserAvailable->account_bal;
                         $userDetails->notify_bal = $isUserAvailable->notify_bal;
                         $userDetails->notify_profile_likes = $isUserAvailable->notify_profile_likes;
                         $userDetails->notify_daily_subscription = $isUserAvailable->notify_daily_subscription;
                     }
                     if ($userDetails->status == 1) {
                         if (isset($postData['device_id']) && $postData['device_id'] != "") {
                             $data['device_id'] = $postData['device_id'];
                             $string = $userDetails->id . $postData['device_id'] . $this->API_TOKEN;
                             $token = hash('sha256', $string);
                             $data['login_token'] = $token;
                             $id = $userDetails->id;
                             $whereForUpdate = ['rawQuery' => 'id =?', 'bindParams' => [$id]];
                             $objUserModel->UpdateUserDetailsbyId($whereForUpdate, $data);
                             $userDetails->login_token = $token;
                             $userDetails->device_id = $postData['device_id'];
                         }
                         //                            dd($userDetails);
                         // update the user timezone in user table
                         if (isset($postData['user_timezone'])) {
                             $whereForUpdate = ['rawQuery' => 'id =?', 'bindParams' => [$userDetails->id]];
                             $data['user_timezone'] = $postData['user_timezone'];
                             $queryResult = $objUserModel->UpdateUserDetailsbyId($whereForUpdate, $data);
                         }
                         $response->code = 200;
                         $response->message = "Login successful.";
                         $response->data = $userDetails;
                         echo json_encode($response, true);
                     } else {
                         if ($userDetails->status == 0) {
                             $response->code = 400;
                             $response->message = " Your account is currently pending approval by the site administrator";
                             $response->data = null;
                             echo json_encode($response, true);
                         } else {
                             if ($userDetails->status == 2) {
                                 $response->message = 'This account has not been activated.';
                                 $response->code = 400;
                                 $response->data = null;
                                 echo json_encode($response, true);
                             } else {
                                 if ($userDetails->status == 3) {
                                     $response->message = ' Your account is currently rejected by the site administrator.';
                                     $response->code = 400;
                                     $response->data = null;
                                     echo json_encode($response, true);
                                 } else {
                                     if ($userDetails->status == 4) {
                                         $response->message = 'This account has been deleted.';
                                         $response->code = 400;
                                         $response->data = null;
                                         echo json_encode($response, true);
                                     }
                                 }
                             }
                         }
                     }
                 } else {
                     $response->message = 'Invalid login Credentials';
                     $response->code = 400;
                     $response->data = null;
                     echo json_encode($response, true);
                 }
             } else {
                 $response->code = 100;
                 $response->message = $validator->messages();
                 echo json_encode($response, true);
             }
         } else {
             $response->code = 401;
             $response->message = "Access Denied";
             $response->data = null;
             echo json_encode($response, true);
         }
     } else {
         $response->code = 401;
         $response->message = "Request Not allowed";
         $response->data = null;
         echo json_encode($response);
     }
 }