/**
  * Lists all UsersRegister models.
  * @return mixed
  */
 public function actionDetail()
 {
     $query = UsersRegister::find();
     $pagination = new Pagination(['defaultPageSize' => 1, 'totalCount' => $query->count()]);
     $countries = $query->orderBy('firstname')->offset($pagination->offset)->limit($pagination->limit)->all();
     return $this->render('detail', ['countries' => $countries, 'pagination' => $pagination]);
 }
 /**
  * User profile updated Web Service
  * @return mixed
  */
 public function actionApiUserProfileUpdate()
 {
     $this->layout = false;
     $commonUser = new commonUser();
     $model = new UsersRegister();
     $connection = \Yii::$app->db;
     header('Content-type: application/json');
     $json = file_get_contents('php://input');
     //convert the string of data to an array
     $data['UsersRegister'] = json_decode($json, true);
     //$data['UsersRegister'] = Yii::$app->request->post();
     //   print_r($data);
     //  print_r($_FILES);
     if (isset($data['UsersRegister']['userId'])) {
         $data['UsersRegister']['id'] = $data['UsersRegister']['userId'];
         unset($data['UsersRegister']['userId']);
         $checkUser = UsersRegister::find()->filterWhere(['users_register.id' => $data['UsersRegister']['id']])->asArray()->all();
         if (empty($data['UsersRegister']['user_pic'])) {
             $user_pic_name = $checkUser[0]['user_pic'];
         } else {
             //$user_pic = $_FILES['user_pic'];
             $user_pic_name = $data['UsersRegister']['id'] . '_' . time() . '.jpeg';
             //$file = UploadedFile::getInstance($model, 'user_pic');
             $uploadDir = Yii::getAlias('@upload_DIR');
             //$data_pic = base64_decode(preg_replace('#^data:image/\w+;base64,#i', '', $data['UsersRegister']['user_pic']));
             $this->base64_to_jpeg($data['UsersRegister']['user_pic'], $uploadDir . '/userPic/' . $user_pic_name);
         }
         /**/
         $command = $connection->createCommand('UPDATE users_register SET firstname="' . $data['UsersRegister']['firstname'] . '",lastname="' . $data['UsersRegister']['lastname'] . '",gender="' . $data['UsersRegister']['gender'] . '",date_of_birth="' . $data['UsersRegister']['date_of_birth'] . '",user_pic="' . $user_pic_name . '" WHERE id=' . $data['UsersRegister']['id']);
         if ($model->load($data) && $command->execute()) {
             $checkUserNew = UsersRegister::find()->filterWhere(['users_register.id' => $data['UsersRegister']['id']])->asArray()->all();
             $return['status'] = 1;
             $return['data']['userId'] = $checkUserNew[0]['id'];
             $return['data']['firstname'] = $checkUserNew[0]['firstname'];
             $return['data']['lastname'] = $checkUserNew[0]['lastname'];
             $return['data']['emailID'] = $checkUserNew[0]['emailID'];
             $return['data']['created_date'] = $checkUserNew[0]['created_date'];
             $return['data']['device_token'] = $checkUserNew[0]['device_token'];
             $return['data']['device_type'] = $checkUserNew[0]['device_type'];
             $return['data']['is_notification'] = $checkUserNew[0]['is_notification'];
             $return['data']['gender'] = $checkUserNew[0]['gender'];
             $return['data']['date_of_birth'] = $checkUserNew[0]['date_of_birth'];
             $return['data']['user_pic'] = $checkUserNew[0]['user_pic'];
             $return['message'] = "Profile Updated Successfully.";
             return json_encode($return);
         } else {
             $return['status'] = 0;
             $return['message'] = "Error! Please try again.";
             return json_encode($return);
         }
     } else {
         $return['status'] = 0;
         $return['message'] = "Missing Argument.";
         return json_encode($return);
     }
 }