How To Sort The Database By Date

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

how to sort by date.jpg

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:Â


    }

  }

Â

$backup_files = fn_sort_array_by_key($backup_files, 'create');

  Registry::get('view')->assign('backup_files', $backup_files);

Â

But it s can not sort by recent date, I have clear the cach too, Â may be something wrong?

Â

Thanks

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!