/**
* Logic to import csv files with content item data
*
* @access public
* @return void
* @since 1.5
*/
function importcsv()
{
// Check for request forgeries
if (JRequest::getCmd('task') != 'importcsv') {
JRequest::checkToken() or jexit('Invalid Token');
echo '<link rel="stylesheet" href="' . JURI::base(true) . '/components/com_flexicontent/assets/css/flexicontentbackend.css?' . FLEXI_VERSION . '" />';
$fc_css = JURI::base(true) . '/components/com_flexicontent/assets/css/j3x.css';
echo '<link rel="stylesheet" href="' . $fc_css . '?' . FLEXI_VERSION . '" />';
} else {
// output this before every other output
echo 'success||||' . (FLEXI_J30GE ? JSession::getFormToken() : JUtility::getToken()) . '||||';
}
// Get item model
$itemmodel = $this->getModel('item');
$model = $this->getModel('import');
// Set some variables
$link = 'index.php?option=com_flexicontent&view=import';
// $_SERVER['HTTP_REFERER'];
$task = JRequest::getCmd('task');
$app = JFactory::getApplication();
$db = JFactory::getDBO();
$user = JFactory::getUser();
$session = JFactory::getSession();
$has_zlib = version_compare(PHP_VERSION, '5.4.0', '>=');
$parse_log = "\n\n\n" . '<b>please click</b> <a href="' . $link . '">here</a> to return previous page' . "\n\n\n";
$log_filename = 'importcsv_' . $user->id . '.php';
jimport('joomla.log.log');
JLog::addLogger(array('text_file' => $log_filename));
// *************************
// Execute according to task
// *************************
switch ($task) {
// ***********************************************************************************************
// RESET/CLEAR an already started import task, e.g. import process was interrupted for some reason
// ***********************************************************************************************
case 'clearcsv':
// Clear any import data from session
$conf = $has_zlib ? base64_encode(zlib_encode(serialize(null), -15)) : base64_encode(serialize(null));
$session->set('csvimport_config', $conf, 'flexicontent');
$session->set('csvimport_lineno', 0, 'flexicontent');
// Set a message that import task was cleared and redirect
$app->enqueueMessage('Import task cleared', 'notice');
$this->setRedirect($link);
return;
break;
// ****************************************************
// CONTINUE an already started (multi-step) import task
// ****************************************************
// ****************************************************
// CONTINUE an already started (multi-step) import task
// ****************************************************
case 'importcsv':
$conf = $session->get('csvimport_config', "", 'flexicontent');
$conf = unserialize($conf ? $has_zlib ? zlib_decode(base64_decode($conf)) : base64_decode($conf) : "");
$lineno = $session->get('csvimport_lineno', 999999, 'flexicontent');
if (empty($conf)) {
$app->enqueueMessage('Can not continue import, import task not initialized or already finished', 'error');
$this->setRedirect($link);
return;
}
// CONTINUE to do the import
// ...
break;
// *************************************************************************
// INITIALIZE (prepare) import by getting configuration and reading CSV file
// *************************************************************************
// *************************************************************************
// INITIALIZE (prepare) import by getting configuration and reading CSV file
// *************************************************************************
case 'initcsv':
case 'testcsv':
$conf = array();
$conf['failure_count'] = $conf['success_count'] = 0;
// Retrieve Basic configuration
$conf['type_id'] = JRequest::getInt('type_id', 0);
$conf['language'] = JRequest::getVar('language', '');
$conf['state'] = JRequest::getInt('state', '');
$conf['access'] = JRequest::getInt('access', '');
// Main and secondary categories
$conf['maincat'] = JRequest::getInt('maincat', 0);
$conf['maincat_col'] = JRequest::getInt('maincat_col', 0);
$conf['seccats'] = JRequest::getVar('seccats', array(), 'post', 'array');
$conf['seccats_col'] = JRequest::getInt('seccats_col', 0);
// Tags
$conf['tags_col'] = JRequest::getInt('tags_col', 0);
// Publication: META data
$conf['created_by_col'] = JRequest::getInt('created_by_col', 0);
$conf['modified_by_col'] = JRequest::getInt('modified_by_col', 0);
// Publication: META data
$conf['metadesc_col'] = JRequest::getInt('metadesc_col', 0);
$conf['metakey_col'] = JRequest::getInt('metakey_col', 0);
// Publication: dates
$conf['modified_col'] = JRequest::getInt('modified_col', 0);
$conf['created_col'] = JRequest::getInt('created_col', 0);
$conf['publish_up_col'] = JRequest::getInt('publish_up_col', 0);
$conf['publish_down_col'] = JRequest::getInt('publish_down_col', 0);
// Advanced configuration
$conf['ignore_unused_cols'] = JRequest::getInt('ignore_unused_cols', 0);
$conf['id_col'] = JRequest::getInt('id_col', 0);
$conf['items_per_step'] = JRequest::getInt('items_per_step', 5);
if ($conf['items_per_step'] > 50) {
$conf['items_per_step'] = 50;
}
if (!$conf['items_per_step']) {
$conf['items_per_step'] = 5;
}
// CSV file format
$conf['mval_separator'] = JRequest::getVar('mval_separator');
$conf['mprop_separator'] = JRequest::getVar('mprop_separator');
$conf['field_separator'] = JRequest::getVar('field_separator');
$conf['enclosure_char'] = JRequest::getVar('enclosure_char');
$conf['record_separator'] = JRequest::getVar('record_separator');
$conf['debug_records'] = JRequest::getInt('debug_records', 0);
// Debug, print parsed data without importing
// ********************************************************************************************
// Obligatory form fields, js validation should have prevented form submission but check anyway
// ********************************************************************************************
// Check for the required Content Type Id
if (!$conf['type_id']) {
$app->enqueueMessage('Please select Content Type for the imported items', 'error');
$app->redirect($link);
}
// Check for the required main category
if (!$conf['maincat'] && !$conf['maincat_col']) {
$app->enqueueMessage('Please select main category for the imported items', 'error');
$app->redirect($link);
}
// ********************************************************************************************************************
// Check for (required) CSV file format variables, js validation should have prevented form submission but check anyway
// ********************************************************************************************************************
if ($conf['mval_separator'] == '' || $conf['mprop_separator'] == '') {
$app->enqueueMessage('CSV format not valid, please enter multi-value, and multi-property Separators', 'error');
$app->redirect($link);
}
if ($conf['field_separator'] == '' || $conf['record_separator'] == '') {
$app->enqueueMessage('CSV format not valid, please enter Field Separator and Item Separator', 'error');
$app->redirect($link);
}
// Retrieve the uploaded CSV file
$csvfile = @$_FILES["csvfile"]["tmp_name"];
if (!is_file($csvfile)) {
$app->enqueueMessage('Upload file error!', 'error');
$app->redirect($link);
}
// ******************************************************************************************************
// Retrieve CSV file format variables, EXPANDING the Escape Characters like '\n' ... provided by the form
// ******************************************************************************************************
$pattern = '/(?<!\\\\)(\\\\(?:n|r|t|v|f|[0-7]{1,3}|x[0-9a-f]{1,2}))/i';
$replace = 'eval(\'return "$1";\')';
$conf['mval_separator'] = preg_replace_callback($pattern, function ($matches) {
$r = $matches[1];
eval("\$r = \"{$r}\";");
return $r;
}, $conf['mval_separator']);
$conf['mprop_separator'] = preg_replace_callback($pattern, function ($matches) {
$r = $matches[1];
eval("\$r = \"{$r}\";");
return $r;
}, $conf['mprop_separator']);
$conf['field_separator'] = preg_replace_callback($pattern, function ($matches) {
$r = $matches[1];
eval("\$r = \"{$r}\";");
return $r;
}, $conf['field_separator']);
$conf['enclosure_char'] = preg_replace_callback($pattern, function ($matches) {
$r = $matches[1];
eval("\$r = \"{$r}\";");
return $r;
}, $conf['enclosure_char']);
$conf['record_separator'] = preg_replace_callback($pattern, function ($matches) {
$r = $matches[1];
eval("\$r = \"{$r}\";");
return $r;
}, $conf['record_separator']);
// ****************************************************
// Read & Parse the CSV file according the given format
// ****************************************************
$contents = FLEXIUtilities::csvstring_to_array(file_get_contents($csvfile), $conf['field_separator'], $conf['enclosure_char'], $conf['record_separator']);
// Basic error checking, for empty data
if (!$contents || count($contents[0]) <= 0) {
$app->enqueueMessage('CSV file format is not correct!', 'error');
$app->redirect($link);
}
// ********************************************************************************
// Get field names (from the header line (row 0), and remove it form the data array
// ********************************************************************************
$conf['columns'] = flexicontent_html::arrayTrim($contents[0]);
unset($contents[0]);
$q = 'SELECT id, name, field_type, label FROM #__flexicontent_fields AS fi' . ' JOIN #__flexicontent_fields_type_relations AS ftrel ON ftrel.field_id = fi.id AND ftrel.type_id=' . $conf['type_id'];
$db->setQuery($q);
$conf['thefields'] = $db->loadObjectList('name');
unset($conf['thefields']['tags']);
// Prevent Automated Raw insertion of tags, we will use special code
// ******************************************************************
// Check for REQUIRED columns and decide CORE property columns to use
// ******************************************************************
$core_props = array();
if ($conf['id_col'] && !in_array('id', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'id\'</b> (Item ID)', 'error');
$app->redirect($link);
} else {
if ($conf['id_col']) {
$core_props['id'] = 'Item ID';
}
}
if (!in_array('title', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'title\'</b>', 'error');
$app->redirect($link);
}
$core_props['title'] = 'Title (core)';
$core_props['text'] = 'Description (core)';
$core_props['alias'] = 'Alias (core)';
if (!$conf['language'] && !in_array('language', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'language\'</b>', 'error');
$app->redirect($link);
} else {
if (!$conf['language']) {
$core_props['language'] = 'Language';
}
}
if (!strlen($conf['state']) && !in_array('state', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'state\'</b>', 'error');
$app->redirect($link);
} else {
if (!strlen($conf['state'])) {
$core_props['state'] = 'State';
}
}
if ($conf['access'] === 0 && !in_array('access', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'access\'</b>', 'error');
$app->redirect($link);
} else {
if ($conf['access'] === 0) {
$core_props['access'] = 'Access';
}
}
if ($conf['maincat_col'] && !in_array('catid', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'catid\'</b> (Primary category)', 'error');
$app->redirect($link);
} else {
if ($conf['maincat_col']) {
$core_props['catid'] = 'Primary category';
}
}
if ($conf['seccats_col'] && !in_array('cid', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'cid\'</b> (Secondary categories)', 'error');
$app->redirect($link);
} else {
if ($conf['seccats_col']) {
$core_props['cid'] = 'Secondary categories';
}
}
if ($conf['created_col'] && !in_array('created', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'created\'</b> (Creation date)', 'error');
$app->redirect($link);
} else {
if ($conf['created_col']) {
$core_props['created'] = 'Creation Date';
}
}
if ($conf['created_by_col'] && !in_array('created_by', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'created_by\'</b> (Creator - Author)', 'error');
$app->redirect($link);
} else {
if ($conf['created_by_col']) {
$core_props['created_by'] = 'Creator (Author)';
}
}
if ($conf['modified_col'] && !in_array('modified', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'modified\'</b> (Modification date)', 'error');
$app->redirect($link);
} else {
if ($conf['modified_col']) {
$core_props['modified'] = 'Modification Date';
}
}
if ($conf['modified_by_col'] && !in_array('modified_by', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'modified_by\'</b> (Last modifier)', 'error');
$app->redirect($link);
} else {
if ($conf['modified_by_col']) {
$core_props['modified_by'] = 'Last modifier';
}
}
if ($conf['metadesc_col'] && !in_array('metadesc', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'metadesc\'</b> (META Description)', 'error');
$app->redirect($link);
} else {
if ($conf['metadesc_col']) {
$core_props['metadesc'] = 'META Description';
}
}
if ($conf['metakey_col'] && !in_array('metakey', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'metakey\'</b> (META Keywords)', 'error');
$app->redirect($link);
} else {
if ($conf['metakey_col']) {
$core_props['metakey'] = 'META Keywords';
}
}
if ($conf['publish_up_col'] && !in_array('publish_up', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'publish_up\'</b> (Start publication date)', 'error');
$app->redirect($link);
} else {
if ($conf['publish_up_col']) {
$core_props['publish_up'] = 'Start publication date';
}
}
if ($conf['publish_down_col'] && !in_array('publish_down', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'publish_down\'</b> (End publication Date)', 'error');
$app->redirect($link);
} else {
if ($conf['publish_down_col']) {
$core_props['publish_down'] = 'End publication Date';
}
}
if ($conf['tags_col'] == 1 && !in_array('tags_names', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'tags_names\'</b> (Comma separated list of tag names)', 'error');
$app->redirect($link);
} else {
if ($conf['tags_col'] == 1) {
$core_props['tags_names'] = 'Tag names';
$tags_model = $this->getModel('tags');
}
}
if ($conf['tags_col'] == 2 && !in_array('tags_raw', $conf['columns'])) {
$app->enqueueMessage('CSV file lacks column <b>\'tags_raw\'</b> (Comma separated list of tag ids)', 'error');
$app->redirect($link);
} else {
if ($conf['tags_col'] == 2) {
$core_props['tags_raw'] = 'Tags';
$tags_model = $this->getModel('tags');
}
}
$conf['core_props'] =& $core_props;
// *********************************************************
// Verify that all non core property columns are field names
// *********************************************************
$unused_columns = array();
foreach ($conf['columns'] as $colname) {
if (!isset($conf['core_props'][$colname]) && !isset($conf['thefields'][$colname])) {
$unused_columns[] = $colname;
if ($conf['ignore_unused_cols']) {
JError::raiseNotice(500, "Column '" . $colname . "' : field name NOT FOUND (column will be ignored)");
}
}
}
if (count($unused_columns) && !$conf['ignore_unused_cols']) {
$app->enqueueMessage('
File has unused ' . count($unused_columns) . ' columns: <b>' . implode(', ', $unused_columns) . '</b>' . ' <br/>these field names are not assigned to choosen <b>content type</b>' . ' <br/><br/>please enable option: <b>\'Ignore unused columns\'</b>', 'error');
$app->redirect($link);
}
// **********************************************************
// Verify that custom specified item ids do not already exist
// **********************************************************
if ($conf['id_col']) {
// Get 'id' column no
$id_col_no = 0;
foreach ($conf['columns'] as $col_no => $column) {
if ($conf['columns'][$col_no] == 'id') {
$id_col_no = $col_no;
break;
}
}
// Get custom IDs in csv file
$custom_id_arr = array();
foreach ($contents as $fields) {
$custom_id_arr[] = $fields[$id_col_no];
}
$custom_id_list = "'" . implode("','", $custom_id_arr) . "'";
// Cross check them if they already exist in the DB
$q = "SELECT id FROM #__content WHERE id IN (" . $custom_id_list . ")";
$db->setQuery($q);
$existing_ids = FLEXI_J16GE ? $db->loadColumn() : $db->loadResultArray();
if ($existing_ids && count($existing_ids)) {
$app->enqueueMessage('File has ' . count($existing_ids) . ' item IDs that already exist: \'' . implode("\\' , \\'", $existing_ids) . '\', please fix or set to ignore \'id\' column', 'error');
$app->redirect($link);
}
}
// Trim item's data
foreach ($contents as $fields) {
$fields = flexicontent_html::arrayTrim($fields);
}
// Set csvfile contens and columns information
$conf['contents'] =& $contents;
// ***************************************************************
// Verify that imported files exist in the media/documents folders
// ***************************************************************
// Get fields that use files
$conf['media_folder'] = JRequest::getVar('media_folder');
$conf['docs_folder'] = JRequest::getVar('docs_folder');
$this->checkfiles($conf, $parse_log, $task);
$this->parsevalues($conf, $parse_log, $task);
if ($task == 'initcsv') {
// Set import configuration and file data into session
$session->set('csvimport_config', $has_zlib ? base64_encode(zlib_encode(serialize($conf), -15)) : base64_encode(serialize($conf)), 'flexicontent');
$session->set('csvimport_lineno', 0, 'flexicontent');
// Set a message that import task was prepared and redirect
$app->enqueueMessage('Import task prepared. <br/>' . 'File has ' . count($conf['contents_parsed']) . ' records (content items)' . ' and ' . count($conf['columns']) . ' columns (fields)', 'message');
$this->setRedirect($link);
return;
} else {
// task == 'testcsv'
$conf['debug_records'] = $conf['debug_records'] ? $conf['debug_records'] : 2;
}
break;
// ************************
// UNKNWOWN task, terminate
// ************************
// ************************
// UNKNWOWN task, terminate
// ************************
default:
// Set an error message about unknown task and redirect
$app->enqueueMessage('Unknown task: ' . $task, 'error');
$this->setRedirect($link);
return;
break;
}
// *********************************************************************************
// Handle each row (item) using store() method of the item model to create the items
// *********************************************************************************
if ($conf['tags_col']) {
$tags_model = $this->getModel('tags');
}
$colcount = count($conf['columns']);
$itemcount = count($conf['contents_parsed']);
$items_per_call = JRequest::getInt('items_per_call', 0);
JRequest::setVar('import_media_folder', $conf['media_folder']);
JRequest::setVar('import_docs_folder', $conf['docs_folder']);
$lineno = $task == 'testcsv' ? 1 : $lineno + 1;
$linelim = $items_per_call ? $lineno + $items_per_call - 1 : $itemcount;
$linelim = $linelim > $itemcount ? $itemcount : $linelim;
//echo "lineno: $lineno -- linelim: $linelim<br/>";
for (; $lineno <= $linelim; $lineno++) {
$_d =& $conf['contents_parsed'][$lineno];
$data = array();
$data['type_id'] = $conf['type_id'];
$data['language'] = $conf['language'];
$data['catid'] = $conf['maincat'];
// Default value maybe overriden by column
$data['cid'] = $conf['seccats'];
// Default value maybe overriden by column
$data['vstate'] = 2;
$data['state'] = $conf['state'];
$data['access'] = $conf['access'];
// Prepare request variable used by the item's Model
if ($task != 'testcsv') {
foreach ($_d as $fieldname => $field_values) {
if ($fieldname == 'tags_names') {
if ($conf['tags_col'] == 1) {
// Get tag names from comma separated list, filtering out bad characters
$remove = array("\n", "\r\n", "\r");
$tns_list = str_replace($remove, ' ', $field_values);
$tns_list = strip_tags($tns_list);
$tns_list = preg_replace("/[\"\\\\]/u", "", $tns_list);
// "/[\"'\\\]/u"
$tns = array_unique(preg_split("/\\s*,\\s*/u", $tns_list));
$tns_quoted = array();
foreach ($tns as $tindex => $tname) {
if ($tname) {
$tns_quoted[] = $db->Quote($tname);
}
}
if (count($tns_quoted)) {
$tns_list_quoted = implode(",", $tns_quoted);
$q = "SELECT name FROM #__flexicontent_tags WHERE name IN (" . $tns_list_quoted . ")";
$db->setQuery($q);
$tns_e = FLEXI_J16GE ? $db->loadColumn() : $db->loadResultArray();
$tns_m = array_diff($tns, $tns_e);
if (count($tns_m)) {
// Create a newline separated list of tag names and then import missing tags,
// thus making sure they are inserted into the tags DB table if not already present
$tns_list_m = implode("\n", $tns_m);
$tags_model->importList($tns_list_m);
}
// Get tag ids
$q = "SELECT id FROM #__flexicontent_tags WHERE name IN (" . $tns_list_quoted . ")";
$db->setQuery($q);
$data['tag'] = FLEXI_J16GE ? $db->loadColumn() : $db->loadResultArray();
}
}
} else {
if ($fieldname == 'tags_raw') {
if ($conf['tags_col'] == 2) {
// Get tag ids from comma separated list, filtering out bad characters
$_tis_list = preg_replace("/[\"'\\\\]/u", "", $field_values);
$_tis = array_unique(array_map('intval', $_tis));
$_tis = array_flip($_tis);
// Check to use only existing tag ids
$_tis_list = implode(",", array_keys($_tis));
$q = "SELECT id FROM #__flexicontent_tags WHERE id IN (" . $_tis_list . ")";
$db->setQuery($q);
$data['tag'] = FLEXI_J16GE ? $db->loadColumn() : $db->loadResultArray();
}
} else {
if (isset($conf['core_props'][$fieldname])) {
$data[$fieldname] = $field_values;
} else {
if (FLEXI_J16GE) {
$data['custom'][$fieldname] = $field_values;
}
}
}
}
}
}
// Set/Force id to zero to indicate creation of new item, in case item 'id' column is being used
$c_item_id = @$data['id'];
$data['id'] = 0;
$session->set('csvimport_lineno', $lineno, 'flexicontent');
// If testing format then output some information
if ($task == 'testcsv') {
if ($lineno == 1) {
$parse_log .= '
<span class="fc-mssg fc-info">
Testing file format <br/>
COLUMNS: ' . implode(', ', $conf['columns']) . '<br/>
</span><hr/>
';
}
foreach ($_d as $i => $flddata) {
if (is_string($_d[$i])) {
if (mb_strlen($_d[$i], 'UTF-8') > 80) {
$_d[$i] = mb_substr(strip_tags($_d[$i]), 0, 80, 'UTF-8') . ' ... ';
}
}
}
if ($lineno <= $conf['debug_records']) {
$parse_log .= "<pre><b>Item no {$lineno}:</b>\n" . print_r($_d, true) . "</pre><hr/>";
} else {
$parse_log .= "<b>Item no {$lineno}:</b> <br/>" . "<u>TITLE</u>: " . $_d['title'] . "<br/>" . "<u>TEXT</u>: " . $_d['text'] . "<hr/>";
}
} else {
if (!$itemmodel->store($data)) {
$conf['failure_count']++;
$msg = 'Failed item no: ' . $lineno . ". titled as: '" . $data['title'] . "' : " . $itemmodel->getError();
JLog::add($msg);
echo $msg . "<br/>";
} else {
$conf['success_count']++;
$msg = 'Imported item no: ' . $lineno . ". titled as: '" . $data['title'] . "'";
JLog::add($msg);
echo $msg . "<br/>";
// Try to rename entry if id column is being used
if ($conf['id_col'] && $c_item_id) {
$item_id = $itemmodel->getId();
$q = "UPDATE #__content SET id='" . $c_item_id . "' WHERE id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_items_ext SET item_id='" . $c_item_id . "' WHERE item_id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_items_tmp SET id='" . $c_item_id . "' WHERE id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_tags_item_relations SET itemid='" . $c_item_id . "' WHERE itemid='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_cats_item_relations SET itemid='" . $c_item_id . "' WHERE itemid='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_fields_item_relations SET item_id='" . $c_item_id . "' WHERE item_id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_items_versions SET item_id='" . $c_item_id . "' WHERE item_id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_versions SET item_id='" . $c_item_id . "' WHERE item_id='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
$q = "UPDATE #__flexicontent_favourites SET itemid='" . $c_item_id . "' WHERE itemid='" . $item_id . "'";
$db->setQuery($q);
$db->execute();
if (FLEXI_J16GE) {
$q = "UPDATE #__assets SET id='" . $c_item_id . "' WHERE id='" . $item_id . "'";
} else {
$q = "UPDATE #__flexiaccess_acl SET axo='" . $c_item_id . "'" . " WHERE acosection = " . $db->Quote('com_content') . " AND axosection = " . $db->Quote('item') . " AND axo='" . $item_id . "'";
}
$db->setQuery($q);
$db->execute();
}
}
}
}
//fclose($fp);
// Done nothing more to do
if ($task == 'testcsv') {
echo $parse_log;
echo "\n\n\n" . '<b>please click</b> <a href="' . $link . '">here</a> to return previous page' . "\n\n\n";
jexit();
}
if ($lineno == $itemcount) {
// Clean item's cache
$cache = FLEXIUtilities::getCache($group = '', 0);
$cache->clean('com_flexicontent_items');
$cache->clean('com_flexicontent_filters');
$cache = FLEXIUtilities::getCache($group = '', 1);
$cache->clean('com_flexicontent_items');
$cache->clean('com_flexicontent_filters');
// Set a total results message and redirect
$msg = 'Imported items: ' . $conf['success_count'] . ' , failed items: ' . $conf['failure_count'] . ', please review (in the logs folder) the import log file: ' . $log_filename;
//$app->enqueueMessage($msg, ($conf['failure_count']==0 && $conf['success_count']>0) ? 'message' : 'warning');
//$this->setRedirect($link); // commented out this via AJAX call now
}
jexit();
}
