Код: Выделить всё
$query = $this->db->select('CONCAT(w.firstName," ",w.lastName) as fullName,w.ID,w.firstName,w.lastName, w.firstname_ar, w.lastname_ar, w.cin , w.tel, w.tel2, w.poste_id, w.gender, w.date_birth, w.address, w.address_ar, w.familySituation, w.socialSecurity, w.typeContract, w.period,w.email,w.status,r.name,w.conge as cng,w.startDateContract, w.pictureProfile, w.endDateContract, w.dateTitulation, w.rib, w.languages, w.passport, w.passport_end_date, w.urgent_phone, w.urgent_phone_name,w.pointage_id as idpointeur, w.shift_start as heure_arr, w.shift_end as heure_dep, w.worker_role as workerRole, r.color as roleColor, r.name as departement, conge_annee, c.name as companyName, c.logo as logoCompany, p.title as poste',FALSE)
->from('Workeforce w')
->join('Role r', 'r.ID = w.RoleID')
->join('Company c', 'c.ID = w.CompanyID')
->join('poste p', 'p.id = w.poste_id', 'left')
->where('w.worker_role
Подробнее здесь: [url]https://stackoverflow.com/questions/59935201/concat-2-columns-in-a-select-call-with-codeigniters-query-builder[/url]