Guide: How to display [(Rate)] [SKU code] - [Description] on the Invoice while selecting the item

How to display [(Rate)] [SKU code] - [Description] on the Invoice while selecting the item

How to display  [(Rate)] - [Description] on the Invoice while selecting the item

public function wh_commodity_code_search ($q, $type, $can_be = '', $search_all = false)

$this->db->select ('rate, id, description as name, long_description as subtext, commodity_code, purchase_price, CONCAT (description, " - (", IFNULL (( SELECT sum (inventory_number)  from '.db_prefix ().'inventory_manage where '.db_prefix ().'items.id = '.db_prefix ().'inventory_manage.commodity_id group by commodity_id), 0),")") as description_iv');

$this->db->group_start ();

$this->db->like ('description', $q);

$this->db->or_like ('long_description', $q);

$this->db->or_like ('commodity_code', $q);

$this->db->or_like ('sku_code', $q);

$this->db->group_end ();

if (new_strlen ($can_be) > 0){

$this->db->where ($can_be, $can_be);

$this->db->where ('active', 1);

if (!$search_all){

$this->db->where ('id not in ( SELECT distinct parent_id from '.db_prefix ().'items WHERE parent_id is not null AND parent_id != "0" )');

$this->db->order_by ('id', 'desc');

$this->db->limit (500);

$items = $this->db->get (db_prefix () . 'items')->result_array ();

foreach ($items as $key => $item) {

$items[$key]['subtext'] = strip_tags (mb_substr ($item['subtext'], 0, 200)) . '...';

if ($type == 'rate'){

$items[$key]['name']    = '(' . app_format_number ($item['rate']) . ') -'. $item['description_iv'];

}else{

$items[$key]['name']    = '(' . app_format_number ($item['purchase_price']) . ') ' .$item['commodity_code'].'-'. $item['description_iv'];

return $items;

How to display SKU Code on the Invoice while selecting the item