Exemplo n.º 1
0
<?php

require_once __DIR__ . '/../vendor/autoload.php';
require_once __DIR__ . '/csv-to-json.php';
$funcionarios = csvToJson('funcionarios.csv');
$fontes = csvToJson('fontes.csv');
$home = csvToJson('home.csv');
$app = new Silex\Application();
// use the factory to create a Faker\Generator instance
$faker = \Faker\Factory::create();
$app->get('/search', function () use($faker) {
    $listaDemandas = array();
    for ($i = 0; $i <= 50; $i++) {
        $item = array('coordenacaoTi' => 'CEDESSP' . $faker->numberBetween(0, 900), 'criadas' => $faker->numberBetween(100, 900), 'percAtendimento' => $faker->numberBetween(0, 100), 'pfEntregue' => $faker->numberBetween(0, 500), 'backlogInicial' => $faker->numberBetween(0, 100), 'backlogFinal' => $faker->numberBetween(0, 100), 'percVariacaoBacklog' => $faker->numberBetween(0, 100), 'backlogMeta' => $faker->numberBetween(0, 100), 'percBacklogMeta' => $faker->numberBetween(0, 100), 'percDefeitos' => $faker->numberBetween(0, 100), 'pfPorTecnico' => $faker->numberBetween(0, 100), 'pfPerCapita' => $faker->numberBetween(0, 100));
        $listaDemandas[] = $item;
    }
    return json_encode($listaDemandas);
});
$app->get('/', function () use($home) {
    return 'Home - SIGCM - PHP';
});
$app->get('/home', function () use($home) {
    return $home;
});
$app->get('/funcionarios', function () use($funcionarios) {
    return $funcionarios;
});
$app->get('/portfolio-interno', function () use($fontes) {
    return $fontes;
});
//Enable CORS in a RESTFull Silex server
Exemplo n.º 2
0
<?php

$csv = shell_exec('cat /home/snchau/scripts/ucrex_querier/querier_php_output.txt');
function csvToJson($csv)
{
    $rows = explode("\n", trim($csv));
    $csvarr = array_map(function ($row) {
        $keys = array('qname', 'qtime', 'qsite1', 'qsite2', 'qsite3', 'qsite4');
        return array_combine($keys, str_getcsv($row));
    }, $rows);
    $json = json_encode($csvarr);
    return $json;
}
$json = csvToJson($csv);
header('Content-Type: application/json');
header('Cache-Control: no-cache');
echo "{$json}";
?>

Exemplo n.º 3
0
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}
// Allow certain file formats
if ($imageFileType != "csv") {
    echo "Sorry, only CSV files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
    // if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        echo "The file has been uploaded from" . $_FILES["fileToUpload"]["name"] . "to" . $target_file;
        csvToJson($target_file);
        return $target_file;
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
    $csv = file_get_contents($target_file);
    $array = array_map("str_getcsv", explode("\n", $csv));
    //$out = array_values($array);
    //echo json_encode($out);
    $json = json_encode($array);
    //print_r($json);
    //echo json_encode($array);
    //print($json);
}
?>
</body>
Exemplo n.º 4
0
 public function getTimeZoneInCSV($arg)
 {
     //echo display_form(1);
     csvToJson($arg);
 }