[Enew]

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

Attached Thumbnails

• 

[eComLabs]

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);

[Enew]

<p>

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);

Dear, I have change like this: </p>
<div>        }</div>
<div>    }</div>
<div> </div>
<div>$backup_files = fn_sort_array_by_key($backup_files, &#39;create&#39;);</div>
<div>    Registry::get(&#39;view&#39;)->assign(&#39;backup_files&#39;, $backup_files);</div>
<div> </div>
<div>But it s can not sort by recent date, I have clear the cach too,  may be something wrong?</div>
<div> </div>
<div>Thanks</div>

[cscartrocks]

You will need to put your code inside code block here so it will not look messy and hard to debug.

[CS-Market]

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.

[eComLabs]

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);

[Enew]

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);

Dear Ecomlabs

It's work for old > recent, can you show me how to make recent date > old date please?

Thank very much

Franck

[eComLabs]

It's work for old > recent, can you show me how to make recent date > old date please?

Please try:

$backup_files = fn_sort_array_by_key($backup_files, 'date', SORT_DESC);

[Enew]

Please try:

$backup_files = fn_sort_array_by_key($backup_files, 'date', SORT_DESC);

thank very much, it's work now.

[eComLabs]

You are welcome!