How To Display [(Rate)] [SKU Code] - [Description] on The Invoice While Selecting The Item

Inventory Management BuildX

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