$VAR1 = {
          'columnsettings' => 'name,PLU Name

qty,QTY,align:right;

total,Sales total,align:right;total:sum;prefix:R ;number:yes;

ahs,Average Head Spend,total:avg;',
          'selector' => '2',
          'data' => 'select

w.name wname, round(sum(qty)*sum(price),2) total, sum(qty) qty, tods.name,

round(sum(qty) * sum(price) / sum(qty) , 2) ahs

from 

     tillordersdetails tods, waitron w

where tods.waitron_id = w.id

and date(tods.stamp) > \'[sdate] 06:00:00\'

and date(tods.stamp) < \'[edate] 06:00:00\'

and tods.plu > 0

group by tods.name

limit 10;

',
          'description' => 'Show summary of sales per user',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'wname',
          'id' => '14',
          'title' => '* Per user turnover',
          'category' => 'SALES',
          'code' => '14'
        };