/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
//return Input::all();
$c = Input::get('collection', 'Entity');
$collection = $this->repository->returnCollectionObjectFor($c);
if (Input::has('createMetrics')) {
exec('/usr/bin/python2.7 ' . base_path() . '/app/lib/generateMetrics.py \'' . Input::get('createMetrics') . '\' \'entity/text/medical/questiontemplate/1\'', $output, $error);
return json_decode($output[0], true);
}
if (Input::has('field')) {
$collection = $this->processFields($collection);
}
if (!array_key_exists('noCache', Input::all())) {
$collection = $collection->remember(1, md5(serialize(array_values(Input::except('pretty')))));
}
$start = (int) Input::get('start', 0);
$limit = (int) Input::get('limit', 100);
$only = Input::get('only', array());
if (Input::has('datatables')) {
$start = (int) Input::get('iDisplayStart', 0);
$limit = (int) Input::get('iDisplayLength', 100);
$sortingColumnIndex = (int) Input::get('iSortCol_0', 0);
$sortingColumnName = Input::get('mDataProp_' . $sortingColumnIndex, '_id');
$sortingDirection = Input::get('sSortDir_0', 'asc');
$sortingColumnName = $sortingColumnName == "_id" ? "natural" : $sortingColumnName;
$iTotalDisplayRecords = new Entity();
$iTotalDisplayRecords = $this->processFields($iTotalDisplayRecords);
$iTotalDisplayRecords = $iTotalDisplayRecords->count();
$collection = $collection->skip($start)->orderBy($sortingColumnName, $sortingDirection)->take($limit)->get($only);
if ($input = Input::get('field')) {
$iTotalRecords = new Entity();
if (isset($input['format'])) {
$iTotalRecords = $iTotalRecords->whereIn('format', array_flatten([$input['format']]));
}
if (isset($input['domain'])) {
$iTotalRecords = $iTotalRecords->whereIn('domain', array_flatten([$input['domain']]));
}
if (isset($input['documentType'])) {
$iTotalRecords = $iTotalRecords->whereIn('documentType', array_flatten([$input['documentType']]));
}
$iTotalRecords = $iTotalRecords->count();
}
return Response::json(["sEcho" => Input::get('sEcho', 10), "iTotalRecords" => $iTotalRecords, "iTotalDisplayRecords" => $iTotalDisplayRecords, "aaData" => $collection->toArray()]);
}
$collection = $collection->skip($start)->take($limit)->get($only);
if (array_key_exists('getQueryLog', Input::all())) {
return Response::json(\DB::getQueryLog());
}
if (array_key_exists('pretty', Input::all())) {
echo "<pre>";
return json_encode($collection->toArray(), JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
}
if (array_key_exists('tocsv', Input::all())) {
$documents = $collection->toArray();
$writer = new Writer(new \SplTempFileObject());
$writer->setNullHandlingMode(Writer::NULL_AS_EMPTY);
foreach ($documents as $documentKey => $documentValue) {
if (!isset($documentValue['content']['sentence']['formatted'])) {
$documentValue['content']['sentence']['formatted'] = " ";
}
$this->recur_ksort($documentValue['content']);
$row['_id'] = $documentValue['_id'];
if (isset($documentValue['parents'])) {
$row['wasDerivedFrom'] = implode(",", $documentValue['parents']);
}
$row['content'] = $documentValue['content'];
$row = $documentValue;
if ($documentKey == 0) {
$writer->insertOne(array_change_key_case(str_replace('.', '_', array_keys(array_dot($row))), CASE_LOWER));
}
$row = array_dot($row);
$csvRow = array();
foreach ($row as $columnKey => $columnValue) {
$csvRow[str_replace('.', '_', $columnKey)] = $columnValue;
}
$writer->insertOne($csvRow);
}
$writer->output('test.csv');
die;
// return array_dot($csv);
}
// if(array_key_exists('tocsv', Input::all()))
// {
// $documents = $collection->toArray();
// $writer = new Writer(new \SplTempFileObject);
// foreach($documents as $documentKey => $documentValue)
// {
// if(!isset($documentValue['content']['sentence']['formatted']))
// {
// $documentValue['content']['sentence']['formatted'] = " ";
// }
// $this->recur_ksort($documentValue['content']);
// $row['_id'] = $documentValue['_id'];
// if(isset($documentValue['parents']))
// {
// $row['wasDerivedFrom'] = implode(",", $documentValue['parents']);
// }
// $row['content'] = $documentValue['content'];
// if($documentKey == 0)
// {
// $writer->insertOne(array_change_key_case(str_replace('.', '_', array_keys(array_dot($row))), CASE_LOWER));
// }
// $writer->insertOne(array_flatten($row));
// }
// $writer->output('test.csv');
// die;
// // return array_dot($csv);
// }
return Response::json($collection);
}
public function getIndex()
{
$c = Input::get('collection', 'Entity');
$collection = $this->repository->returnCollectionObjectFor($c);
// Filter data for projects for which the authenticated user has permissions.
if (Input::has('authkey')) {
$user = \MongoDB\UserAgent::where('api_key', Input::get('authkey'))->first();
if (is_null($user)) {
return ['error' => 'Invalid auth key: ' . Input::get('authkey')];
}
} elseif (Auth::check()) {
$user = Auth::user();
} else {
return ['error' => 'Authentication required. Please supply authkey.'];
}
$projects = ProjectHandler::getUserProjects($user, Permissions::PROJECT_READ);
$projectNames = array_column($projects, 'name');
$collection = $collection->whereIn('project', $projectNames);
if (Input::has('match')) {
$collection = $this->processFields($collection);
}
$start = (int) Input::get('start', 0);
$limit = (int) Input::get('limit', 100);
$only = Input::get('only', array());
if ($orderBy = Input::get('orderBy')) {
foreach ($orderBy as $sortingColumnName => $sortingDirection) {
$collection = $collection->orderBy($sortingColumnName, $sortingDirection);
}
}
$collection = $collection->paginate($limit, $only);
$pagination = $collection->links()->render();
$count = $collection->toArray();
unset($count['data']);
$documents = $collection->toArray()['data'];
if (array_key_exists('tocsv', Input::all())) {
set_time_limit(1200);
$writer = new Writer(new \SplTempFileObject());
$writer->setNullHandlingMode(Writer::NULL_AS_EMPTY);
$headerDotted = array();
foreach ($documents as $line_index => $row) {
unset($row['metrics'], $row['platformJobId'], $row['results'], $row['cache']);
if (isset($row['parents'])) {
$row['wasDerivedFrom'] = implode(",", $row['parents']);
unset($row['parents']);
}
foreach (array_dot($row) as $k => $v) {
array_push($headerDotted, $k);
}
}
$headerDotted = array_unique($headerDotted);
natcasesort($headerDotted);
$csvHeader = array_change_key_case(str_replace('.', '_', array_values($headerDotted)), CASE_LOWER);
$writer->insertOne($csvHeader);
foreach ($documents as $line_index => $row) {
if (isset($row['parents'])) {
$row['wasDerivedFrom'] = implode(",", $row['parents']);
unset($row['parents']);
}
$row = array_dot($row);
foreach ($headerDotted as $column) {
if (isset($row[$column])) {
$csvRow[str_replace('.', '_', $column)] = $row[$column];
} else {
$csvRow[str_replace('.', '_', $column)] = "";
}
}
$writer->insertOne($csvRow);
}
$writer->output(time() . '.csv');
die;
}
return Response::json(["count" => $count, "pagination" => $pagination, "searchQuery" => Input::except('page'), "documents" => $documents]);
}
echo 'Error: ' . $e->getMessage();
exit;
}
echo PHP_EOL;
echo sprintf('%s open and %s closed issues pulled…', (string) count($issues['open']), (string) count($issues['closed']));
// Set up the header rows for the CSV
$toWrite = [['url', 'number', 'title', 'status', 'assignee', 'milestone', 'created_at', 'updated_at', 'body']];
$prCount = 0;
// Set up the data rows for the CSV
foreach ($issues as $states) {
foreach ($states as $issue) {
// Strip out pull requests
if (strpos($issue['html_url'], '/pull/')) {
++$prCount;
continue;
}
$assignee = $issue['assignee'] == null ? '' : $issue['assignee']['login'];
$milestone = $issue['milestone'] == null ? '' : $issue['milestone']['number'] . ': ' . $issue['milestone']['title'];
$toWrite[] = [$issue['html_url'], $issue['number'], $issue['title'], $issue['state'], $assignee, $milestone, $issue['created_at'], $issue['updated_at'], $issue['body']];
}
}
echo PHP_EOL;
echo sprintf('Stripping out %s pull requests…', (string) $prCount);
echo PHP_EOL;
echo 'Writing to CSV…';
// Write the array to the CSV file
$writer = new Writer(sprintf('%s.csv', $repo->owner . '_' . $repo->name), 'ab+');
$writer->setNullHandlingMode(Writer::NULL_AS_EMPTY);
$writer->insertAll($toWrite);
echo PHP_EOL;
echo sprintf('Done! CSV file is %s.csv', $repo->name);
