}
$context['metroCityList']='';//$metroCityList;
$context['metro_heading']=$metro_heading;
$context['remove_faq']=get_field('remove_faq');
 
 
$dumpster_min_max_price=get_transient( 'dumpster_min_max_price' );
$portable_min_max_price=get_transient( 'portable_min_max_price' );
$faq_portable_min_max_price=get_transient( 'faq_portable_min_max_price' );
$faq_dumpster_min_max_price=get_transient( 'faq_dumpster_min_max_price' );
 
if(empty($dumpster_min_max_price) || empty($portable_min_max_price)) {
 
    if($terms_service[0]->name == 'Dumpster') {
        $client = new \Google_Client();
        $client->setApplicationName('Google Sheets and PHP');
        $client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);
        $client->setAccessType('offline');
        $client->setAuthConfig(__DIR__ . '/assets/credentials.json');
        $service = new Google_Service_Sheets($client);
        $spreadsheetId = "1arPyVuYZ8newxS6tlr2y__0oSpuMSoVU42LujKZqqoc"; //It is present in the spreadsheet URL
//Adding the data in your google sheet and get column G to BL data
        $range = 'Dumpster Locations!AS:BR';
        $response = $service->spreadsheets_values->get($spreadsheetId, $range);
        $rows = $response->getValues();
        set_transient('dumpster_min_max_price', $rows, 60 * 60 * 168);
        //********Rang For FAQ *************//
        $rangeFAQ = 'Dumpster Locations!BK:CO';
        $responseFAQ = $service->spreadsheets_values->get($spreadsheetId, $rangeFAQ);
        $rowsFAQ = $responseFAQ->getValues();
        $rangeFAQ = 'Dumpster Locations!BS:DA';
        $responseFAQ = $service->spreadsheets_values->get($spreadsheetId, $rangeFAQ);
        $rowsFAQ = $responseFAQ->getValues();
        set_transient('faq_dumpster_min_max_price', $rowsFAQ, 60 * 60 * 168);
    }
    if($terms_service[0]->name == 'Portable') {
        $client = new \Google_Client();
        $client->setApplicationName('Google Sheets and PHP');
        $client->setScopes([\Google_Service_Sheets::SPREADSHEETS]);

            }
 
            break;
        }
    }
 
    if ( ! $template ) {
        $template = get_index_template();
    }
 
    /**
     * Filters the path of the current template before including it.
     *
     * @since 3.0.0
     *
     * @param string $template The path of the template to include.
     */
    $template = apply_filters( 'template_include', $template );
    if ( $template ) {
        include $template;
    } elseif ( current_user_can( 'switch_themes' ) ) {
        $theme = wp_get_theme();
        if ( $theme->errors() ) {
            wp_die( $theme->errors() );
        }
    }
    return;
}
 

<?php
/**
 * Loads the WordPress environment and template.
 *
 * @package WordPress
 */
 
if ( ! isset( $wp_did_header ) ) {
 
    $wp_did_header = true;
 
    // Load the WordPress library.
    require_once __DIR__ . '/wp-load.php';
 
    // Set up the WordPress query.
    wp();
 
    // Load the theme template.
    require_once ABSPATH . WPINC . '/template-loader.php';
 
}
 

<?php
/**
 * Front to the WordPress application. This file doesn't do anything, but loads
 * wp-blog-header.php which does and tells WordPress to load the theme.
 *
 * @package WordPress
 */
 
/**
 * Tells WordPress to load the WordPress theme and output it.
 *
 * @var bool
 */
define( 'WP_USE_THEMES', true );
 
/** Loads the WordPress Environment and Template */
require __DIR__ . '/wp-blog-header.php';