test

//////////////////////
$cm_header = CmHeader::leftJoin('partners','cm_headers.partner_id','=','partners.id')
		->select('cm_headers.partner_id as partner_id',DB::Raw('sum(cm_headers.db_total) as total'),'partners.name as partner_name')
		->whereIn('cm_headers.status',['Approved','Printed'])
		->where('cm_headers.balance','>', 0)
		->where('cm_headers.cb',$cb)
		->where('partners.name','like','%'.$p_name.'%');
		->groupBy('cm_headers.partner_id');
		->orderBy('partners.name','asc');

$dm_header = DmHeader::leftJoin('partners','dm_headers.partner_id','=','partners.id')
		->select('dm_headers.partner_id as partner_id',DB::Raw('sum(dm_headers.db_total) as total'),'partners.name as partner_name')
		->whereIn('dm_headers.status',['Approved','Printed'])
		->where('dm_headers.balance','>', 0)
		->where('dm_headers.cb',$cb)
		->where('partners.name','like','%'.$p_name.'%');
		->groupBy('dm_headers.partner_id');
		->orderBy('partners.name','asc');

$search = $cm_header->unionAll($dm_header)->get();
//////////////////////