X-Cart forums

[mrerotic]

Is there anyway to add a new sort by option? I want to add sort by (Release Date) which is specified in [extra_field_options] table. Can anyone assist me with this?

Thanks

[mikalou]

You could probably duplicate what I did but substitute the field you want to sort by. I wanted to be able to sort by description. This mod was for X-Cart Gold 4.2.2.

Here is what I did:

Modify: include/search.php
1. Add description into this array. (about line 40) (note: I had to add the lbl_description label in languages)

$sort_fields = array(
	"productcode" 	=> func_get_langvar_by_name("lbl_sku"),
	"title" 		=> func_get_langvar_by_name("lbl_product"),
	"price" 		=> func_get_langvar_by_name("lbl_price"),
        "description" 	=> func_get_langvar_by_name("lbl_description"),
	"orderby"		=> func_get_langvar_by_name("lbl_default")
);

2. Add this new case statement to the switch function for the description field. (about line 600)

case "description":
	$sort_string = "$sql_tbl[products].descr $direction";
	break;

modify: include/func/func.product.php

1. add description to this array(about line 320)

	if (is_null($orderby_rules)) {
		$orderby_rules = array (
			"title" => "product",
			"quantity" => "$sql_tbl[products].avail",
			"orderby" => "$sql_tbl[products_categories].orderby",
			"quantity" => "$sql_tbl[products].avail",
			"price" => "price",
			"description" => "$sql_tbl[products].descr",
			"productcode" => "$sql_tbl[products].productcode");
	}

[mrerotic]

Thanks for the input, but if I'm searching an extra field, for some reason when I add the extra_field table the query breaks.

[mikalou]

Can you post that query statement.

[ADDISON]

What about Sort by Manufacturer?

[mrerotic]

well the problem is I want to orderby release date which comes from table 'extra_field_values' where fieldid="6" order by the 'value' for this extra field. When I add this to the orderby then it does just that orderby, but there is no way of defining the where clause without breaking the mysql query. Any advice? thx

[mikalou]

Not seeing the query statement I'll just take a couple stabs here at possible probs.

If your query statement joins multiple tables and those tables have some identical field names then you'll need to include the table name (ex: table_name.field_name).
or...
You might need to use a "left join" in your query statement.
or...
orderby should be order by.
or...
where clause needs to proceed order by clause.

Can you post your query statement?

[mrerotic]

Correct the where clause needs to proceed the orderby clause. But where do I add the where clause for this to proceed it?

[mikalou]

Try this:

SELECT * FROM $sql_tbl[products] JOIN $sql_tbl[extra_field_values] ON $sql_tbl[extra_field_values].productid = $sql_tbl[products].productid WHERE $sql_tbl[extra_field_values].fieldid='6' ORDER BY $sql_tbl[extra_field_values].value

[ScrapOrchard]

We have a Date Added modification in place, but would like to figure out how to have just one category sort by product name.. is there anyway to alter the code (which is similar to what was posted in previous replies) to have X-Cart sort one category id by product name and all others by date added?