/**
* Save the data from the file to the database
*
* @param string $package Paths to the uploaded package file
*
* @return boolean false on failure
*
**/
protected function save($data, $table)
{
// import the data if there is any
if (DemoHelper::checkArray($data['array'])) {
// get user object
$user = JFactory::getUser();
// remove header if it has headers
$id_key = $data['target_headers']['id'];
$published_key = $data['target_headers']['published'];
$ordering_key = $data['target_headers']['ordering'];
// get the first array set
$firstSet = reset($data['array']);
// check if first array is a header array and remove if true
if ($firstSet[$id_key] == 'id' || $firstSet[$published_key] == 'published' || $firstSet[$ordering_key] == 'ordering') {
array_shift($data['array']);
}
// make sure there is still values in array and that it was not only headers
if (DemoHelper::checkArray($data['array']) && $user->authorise($table . '.import', 'com_demo') && $user->authorise('core.import', 'com_demo')) {
// set target.
$target = array_flip($data['target_headers']);
// Get a db connection.
$db = JFactory::getDbo();
// set some defaults
$todayDate = JFactory::getDate()->toSql();
// get global action permissions
$canDo = DemoHelper::getActions($table);
$canEdit = $canDo->get('core.edit');
$canState = $canDo->get('core.edit.state');
$canCreate = $canDo->get('core.create');
$hasAlias = $this->getAliasesUsed($table);
// prosses the data
foreach ($data['array'] as $row) {
$found = false;
if (isset($row[$id_key]) && is_numeric($row[$id_key]) && $row[$id_key] > 0) {
// raw items import & update!
$query = $db->getQuery(true);
$query->select('version')->from($db->quoteName('#__demo_' . $table))->where($db->quoteName('id') . ' = ' . $db->quote($row[$id_key]));
// Reset the query using our newly populated query object.
$db->setQuery($query);
$db->execute();
$found = $db->getNumRows();
}
if ($found && $canEdit) {
// update item
$id = $row[$id_key];
$version = $db->loadResult();
// reset all buckets
$query = $db->getQuery(true);
$fields = array();
// Fields to update.
foreach ($row as $key => $cell) {
// ignore column
if ('IGNORE' == $target[$key]) {
continue;
}
// update modified
if ('modified_by' == $target[$key]) {
continue;
}
// update modified
if ('modified' == $target[$key]) {
continue;
}
// update version
if ('version' == $target[$key]) {
$cell = (int) $version + 1;
}
// verify publish authority
if ('published' == $target[$key] && !$canState) {
continue;
}
// set to update array
if (in_array($key, $data['target_headers']) && is_numeric($cell)) {
$fields[] = $db->quoteName($target[$key]) . ' = ' . $cell;
} elseif (in_array($key, $data['target_headers']) && is_string($cell)) {
$fields[] = $db->quoteName($target[$key]) . ' = ' . $db->quote($cell);
} elseif (in_array($key, $data['target_headers']) && is_null($cell)) {
// if import data is null then set empty
$fields[] = $db->quoteName($target[$key]) . " = ''";
}
}
// load the defaults
$fields[] = $db->quoteName('modified_by') . ' = ' . $db->quote($user->id);
$fields[] = $db->quoteName('modified') . ' = ' . $db->quote($todayDate);
// Conditions for which records should be updated.
$conditions = array($db->quoteName('id') . ' = ' . $id);
$query->update($db->quoteName('#__demo_' . $table))->set($fields)->where($conditions);
$db->setQuery($query);
$db->execute();
} elseif ($canCreate) {
// insert item
$query = $db->getQuery(true);
// reset all buckets
$columns = array();
$values = array();
$version = false;
// Insert columns. Insert values.
foreach ($row as $key => $cell) {
// ignore column
if ('IGNORE' == $target[$key]) {
continue;
}
// remove id
if ('id' == $target[$key]) {
continue;
}
// update created
if ('created_by' == $target[$key]) {
continue;
}
// update created
if ('created' == $target[$key]) {
continue;
}
// Make sure the alias is incremented
if ('alias' == $target[$key]) {
$cell = $this->getAlias($cell, $table);
}
// update version
if ('version' == $target[$key]) {
$cell = 1;
$version = true;
}
// set to insert array
if (in_array($key, $data['target_headers']) && is_numeric($cell)) {
$columns[] = $target[$key];
$values[] = $cell;
} elseif (in_array($key, $data['target_headers']) && is_string($cell)) {
$columns[] = $target[$key];
$values[] = $db->quote($cell);
} elseif (in_array($key, $data['target_headers']) && is_null($cell)) {
// if import data is null then set empty
$columns[] = $target[$key];
$values[] = "''";
}
}
// load the defaults
$columns[] = 'created_by';
$values[] = $db->quote($user->id);
$columns[] = 'created';
$values[] = $db->quote($todayDate);
if (!$version) {
$columns[] = 'version';
$values[] = 1;
}
// Prepare the insert query.
$query->insert($db->quoteName('#__demo_' . $table))->columns($db->quoteName($columns))->values(implode(',', $values));
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$done = $db->execute();
if ($done) {
$aId = $db->insertid();
// make sure the access of asset is set
DemoHelper::setAsset($aId, $table);
}
} else {
return false;
}
}
return true;
}
}
return false;
}
