getCouchDbData.php

<?php
    //$viewStr = "KPI_applications";
    $viewStr = "";
    $designStr = "";
    $dbStr = "";
    //$levelStr = "";
    
    //$group_levelStr = "group_level=2";
    if (isset($_GET['view'])) {
        $viewStr = $_GET['view'];
        //echo "viewstr: $viewStr<br>";
    //} else {
    //    $viewStr .= "?group_level=2";
    }
    if(isset($_GET['design'])) {
        $designStr = $_GET['design'];
    }
    if(isset($_GET['db'])) {
        $dbStr = $_GET['db'];
        if(isset($_GET['local_dev'])) {
            $dbStr = 'projects_dev';
        }
    }
    if(isset($_GET['reduce'])) {
        $reduceStr = $_GET['reduce'];
    }
    if(isset($_GET['group_level'])) {
        $levelStr = $_GET['group_level'];
    }
    

    //$url = "http://localhost:5984/analysis/_design/process_flow/_view/KPI?group_level=2";
    //$url = "http://tools.scilifelab.se:5984/analysis/_design/process_flow/_view/KPI?group_level=2";
    
    // get user:password from file. File should contain one line on the form username:password
    $fhandle = fopen("user_cred.txt", 'r');
    $user_password = fgets($fhandle);
    $user_password = str_replace("\n", '', $user_password);// in case there is \n at the end of the line
    fclose($fhandle);
    
    // set up curl and call couchDb view

    $base_url = "http://$user_password@tools.scilifelab.se:5984";
    if(isset($_GET['dev'])) {
        $base_url = "http://$user_password@tools-dev.scilifelab.se:5984";
    }
    if(isset($_GET['local']) || isset($_GET['local_dev'])) {
        $base_url = "http://localhost:5984";
    }

    $url = "$base_url/$dbStr/_design/$designStr/_view/$viewStr";
    if(isset($reduceStr)) {
        $url .= "?reduce=$reduceStr";
    }
    if(isset($levelStr)) {
        $url .= "?group_level=$levelStr";
    }
    //echo "url: $url<br>";
    $ch = curl_init($url);
    
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch,  CURLOPT_RETURNTRANSFER, 1);
    
    $result = curl_exec($ch);
    curl_close($ch);
    echo $result;
?>