Hello
Does someone can show me how to sort the database by recent date please?
My website is multivendor with 4.2.3
Thank in advance!
Franck
Please open the app\controllers\backend\database.php file and add this line:
$backup_files = fn_sort_array_by_key($backup_files, 'create');
before this one:
Registry::get('view')->assign('backup_files', $backup_files);
[quote name='eComLabs' timestamp='1429522783' post='212033'] Please open the [b]app\controllers\backend\database.php[/b] file and add this line: ```php $backup_files = fn_sort_array_by_key($backup_files, 'create'); ``` before this one: ```php Registry::get('view')->assign('backup_files', $backup_files); ``` [/quote]Dear, I have change like this:Â
You will need to put your code inside code block here so it will not look messy and hard to debug.
After this code addition backups will be sorted by date. This code doesn't add sort direction to the backup page similar as to the product page.
Sincerely yours,
CS-Market.
Please try the following solution:
Replace:
if (is_array($files)) {
foreach ($files as $file) {
$backup_files[$file]['size'] = filesize(Registry::get('config.dir.database') . $file);
$backup_files[$file]['type'] = strpos($file, '.tgz')===false ? 'sql' : 'tgz';
$backup_files[$file]['create'] = fn_date_format(filemtime(Registry::get('config.dir.database') . $file), $date_format);
}
}
Registry::get('view')->assign('backup_files', $backup_files);
with
if (is_array($files)) {
foreach ($files as $file) {
$backup_files[$file]['size'] = filesize(Registry::get('config.dir.database') . $file);
$backup_files[$file]['type'] = strpos($file, '.tgz')===false ? 'sql' : 'tgz';
$backup_files[$file]['create'] = fn_date_format(filemtime(Registry::get('config.dir.database') . $file), $date_format);
$backup_files[$file]['date'] = filemtime(Registry::get('config.dir.database') . $file);
}
}
$backup_files = fn_sort_array_by_key($backup_files, 'date');
Registry::get('view')->assign('backup_files', $backup_files);
[quote name='eComLabs' timestamp='1429618767' post='212204']
Please try the following solution:
Replace:
if (is_array($files)) {
foreach ($files as $file) {
$backup_files[$file]['size'] = filesize(Registry::get('config.dir.database') . $file);
$backup_files[$file]['type'] = strpos($file, '.tgz')===false ? 'sql' : 'tgz';
$backup_files[$file]['create'] = fn_date_format(filemtime(Registry::get('config.dir.database') . $file), $date_format);
}
}
Registry::get('view')->assign('backup_files', $backup_files);
with
if (is_array($files)) {
foreach ($files as $file) {
$backup_files[$file]['size'] = filesize(Registry::get('config.dir.database') . $file);
$backup_files[$file]['type'] = strpos($file, '.tgz')===false ? 'sql' : 'tgz';
$backup_files[$file]['create'] = fn_date_format(filemtime(Registry::get('config.dir.database') . $file), $date_format);
$backup_files[$file]['date'] = filemtime(Registry::get('config.dir.database') . $file);
}
}
$backup_files = fn_sort_array_by_key($backup_files, 'date');
Registry::get('view')->assign('backup_files', $backup_files);
[/quote]Dear Ecomlabs
It's work for old > recent, can you show me how to make recent date > old date please?
Thank very much
Franck
[quote name='Enew' timestamp='1429638579' post='212278']
It's work for old > recent, can you show me how to make recent date > old date please?
[/quote]
Please try:
$backup_files = fn_sort_array_by_key($backup_files, 'date', SORT_DESC);
[quote name='eComLabs' timestamp='1429692778' post='212339'] Please try: $backup_files = fn_sort_array_by_key($backup_files, 'date', SORT_DESC);
[/quote]thank very much, it's work now.
You are welcome!