appreport_gp_api.prg

<?php
/*******************************************************
*file: appreport_gp_server.api
* This file handles api requests to google storage, it goes
through a bucket found on the statistics page of the 
play store and authennticates it with a google service account.
This account has its credentials encrpyted over docker/AWS 
After confirmation it downloads the prompted data to present
in the appreport_gp_client.prg
********************************************************/
$monLibrary= dirname(__FILE__) . "/../library";
$sharedLibrary= dirname(__FILE__) . "/../../shared/library";
$datafolder = dirname(__FILE__) . "/appreportdata";
$tmpdir = "/home/homecu/tmp/appreportdata/";
$playStoreBucket = "pubsite_prod_rev_03651443995346945786";

// Includes necessary files
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");
require_once("$sharedLibrary/hcuCommon.i");
require_once("$sharedLibrary/hcuEnv.i");
require_once("$sharedLibrary/cu_flagconst.i");
require '/var/www/vendor/autoload.php';
use Google\Cloud\Storage\StorageClient;

if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
      header("Location: /hcuadm/hcu_noperm.prg");
      exit;
}

function returnBucket(){  
    global $playStoreBucket;
    //Grabs the Credentials Path for the Android/GP Service Account from hcuENV.i
    $GPStatsCredentialsPath= GetGPStatsCredentialsPath();
    //finds decrypted address of the credentials file from docker
    $credentials_json = GetAwsCertFile($GPStatsCredentialsPath,
                                       HOMECU_ENC_CERT_DIR,
                                       HOMECU_DOCK_CERT_DIR);
    if ($credentials_json == '') {
        throw new Exception("[gpstats] Credentials could not be loaded!");
    }
    //loads storage client with correct credentials
    $config = [
        'keyFilePath' => $credentials_json,
        'projectId' => 'homecu-gpstats',
    ];
    $storage = new StorageClient($config);
    //populates the homecu android play statistics bucket
    $bucket = $storage->bucket($playStoreBucket);
    return $bucket;    
}

function downloadCu($cucode, $date, $report_type, $file_version){
    global $tmpdir;
    $bucket = returnBucket();
    $return_array=array();
    //make sure this key exists in array
    $return_array['error_message']='';
    
    $object = $bucket->object('stats/' . $report_type .'/' . $report_type . '_com.homecu.' . $cucode . "_" . $date . $file_version);
    
    //check if object exists in google storage
    if($object->exists()==false){
        $return_array["success"] = FALSE;
        $return_array["error_message"] = "CU not found in Google database";
        return $return_array;
    }
    
    //check if download directory exists if not create it
    $localdir = $tmpdir . $report_type . $date ."/";
    if (!is_dir($localdir)){
        mkdir($localdir, 2770, true);
    }
    // download csv directly to file
    $object->downloadToFile($localdir . $cucode . ".csv");
    $return_array["success"] = TRUE;
    
    //paranoia check
    clearstatcache();
    if(filesize($localdir . $cucode . ".csv") <= 0 and !isset($return_array["message"])){
        $return_array["success"] == FALSE;
        $return_array["error_message"] = "CSV file not downloaded to file";
    }
    
    return $return_array;
}