Unknown column total when using where

you can not use result colum in the where, you should recalculate it in the where to get the desired result, but try using ‘having’:

 ->having('total', 'like', '%' . $term . '%');