public function execute()
{
$sampleIds = array();
$importModel = new ImportModel();
$sampleCsvFiles = array('sample-company' => "companies", 'sample-person' => "people", 'sample-deal' => "deals");
foreach ($sampleCsvFiles as $file => $table) {
$importData = $importModel->readCSVFile(JPATH_COBALT . '/Sample/' . $file . '.csv', $table, false);
switch ($table) {
case "companies":
$model = "company";
break;
case "people":
$model = "people";
break;
case "deals":
$model = "deal";
break;
}
unset($importData['headers']);
$ids = $importModel->importCSVData($importData, $model, true);
$sampleIds[$table] = $ids;
}
$data = array('import_sample' => serialize($sampleIds));
$configModel = new ConfigModel();
$configModel->store($data);
$msg = TextHelper::_('COBALT_SAMPLE_DATA_INSTALLED');
$this->getApplication()->redirect('index.php?view=import', $msg);
}
public function removeSampleData()
{
$sampleIds = unserialize(ConfigHelper::getConfigValue('import_sample'));
$db = $this->container->resolve('db');
$query = $db->getQuery(true);
foreach ($sampleIds as $table => $ids) {
$query->clear()->delete("#__" . $table)->where("id IN(" . implode(',', $ids) . ")");
$db->setQuery($query);
$db->query();
}
$data = array('import_sample' => "0");
$configModel = new ConfigModel();
$configModel->store($data);
$msg = TextHelper::_('COBALT_SAMPLE_DATA_REMOVED');
$this->getApplication()->redirect('index.php?view=import', $msg);
}