How display category name with item name.

pmmvt

I attempt to read http://www.epesi.org/Utils/RecordBrowse ... _callbacks to implement new Order module but it so hard.

I have Goods list, each Item(field: id, name, category_id) belong to Category(fields: id, name).
In Order module, when user view order items, How to display Category name beside Item name.
Ex:
Categories:
1 Laptop
2. Tablet
3. Phone

Goods:
1. HPP12 belong Laptop
2. Ipad belong Tablet
3. Noika belong Phone

Order view display as:
ItemId | Item Name | Qt | Status
1 | HPP12[Laptop] | 1 | ok
2 | Ipad[Tablet] | 8 | ok

Thank

ajb

In Items recordset class define method display_name or display_item_name (name / item_name - depends on your exact field name - it's a required rule to get magic callbacks to run):

public function display_name($record, $nolink, $desc) {

 $category_id = $record['category'];

 $categories_rs = new CategoriesRS(); // of course replace with your own class name of the categories RS.

 $cat_link = $categories_rs->create_linked_label('name', $category_id, $nolink);

 $item_link = $record->record_link($record->name, $nolink);

 return "$item_link [$cat_link]";

}

During installation your magic callback will be installed, but if you want to enable them without reinstallation of the recordset then run method refresh_magic_callbacks of the recordset. You can do this in the body of your module, where you create an instance of your recordset. Then run your module to run this code, and then you can remove it.

Regards,
Adam

pmmvt

Thank for your reply
I done implemented, it work perfect.

$goods_id = $record->goods; // record is Item

$goods_rs = new Custom_Goods_Recordset();

$goods = $goods_rs->get_record($goods_id);

$goods_link = $goods->record_link($goods->name, $nolink);

		

$category_id = $goods->category;

$category_rs = new Custom_Category_Recordset();

$category_link = $category_rs->create_linked_label('name', $category_id, $nolink);

 

return "$goods_link [$area_link]";

Another question, Is this optimized code? Any way to make faster?

ajb

Faster - probably, but cleaner I don't think.
Within your code I see that you've got a field "goods" which is a select, then you have to format good's name and it's category.
You should know about description_callback. It's a method that will be called to format default linked label.

I assume that your code now is (with function header):

function display_goods($record, $nolink) {

$goods_id = $record->goods; // record is Item

$goods_rs = new Custom_Goods_Recordset();

$goods = $goods_rs->get_record($goods_id);

$goods_link = $goods->record_link($goods->name, $nolink);

      

$category_id = $goods->category;

$category_rs = new Custom_Category_Recordset();

$category_link = $category_rs->create_linked_label('name', $category_id, $nolink);

 

return "$goods_link [$category_link]";

}

You could create a description callback for goods (in Custom_Goods_Recordset class):

static function default_label($record, $nolink) {

$goods_link = $record->record_link($record->name, $nolink);

      

$category_id = $record->category;

$category_rs = new Custom_Category_Recordset();

$category_link = $category_rs->create_linked_label('name', $category_id, $nolink);

 

return "$goods_link [$category_link]";

}



$goods_rs = new Custom_Goods_Recordset();

$goods_rs->install(); // that's what you should have

// that's new

$goods_rs->set_description_callback(array('Custom_Goods_Recordset', 'default_label'));

And now your display callback for the goods field will look like this:

$goods_id = $record->goods; // record is Item

$goods_rs = new Custom_Goods_Recordset();

return $goods_rs->create_default_linked_label($goods_id);

Regards,
Adam 😉

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge