public function getConvertcsv()
{
if (($handle = fopen(storage_path() . '/jobs.csv', 'r')) === false) {
die('Error opening file');
}
/* foreach (\QuestionTemplate::get() as $q)
$q->forceDelete();
foreach (\JobConfiguration::get() as $q)
$q->forceDelete();
foreach (\Job::get() as $q)
$q->forceDelete();
*/
\MongoDB\Activity::truncate();
$activity = new \MongoDB\Activity();
$activity->label = "Imported jobs from CSV file.";
//$activity->used = $job->_id;
$activity->softwareAgent_id = 'importer';
$activity->save();
$headers = fgetcsv($handle, 1024, ',');
$count = 0;
$complete = array();
while ($row = fgetcsv($handle, 1024, ',')) {
$c = array_combine($headers, $row);
$c['platform'] = array($c['platform']);
$j = new JobConfiguration();
//$j->_id = "entity/text/medical/jobconf/$count";
$j->type = isset($row['type']) ? $row['type'] : 'todo';
$j->content = $c;
$j->hash = md5(serialize($j->content));
$j->activity_id = $activity->_id;
$j->user_id = 'CrowdWatson';
$j->save();
$job = new Job();
$job->jobConf_id = $j->_id;
$job->activity_id = $activity->_id;
$job->batch_id = "entity/text/medical/batch/{$count}";
$job->type = isset($row['type']) ? $row['type'] : 'todo';
$job->user_id = 'CrowdWatson';
$job->status = 'finished';
$job->save();
$count++;
}
//new MongoDate(strtotime(
fclose($handle);
echo json_encode($complete, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
}
