$VAR1 = {
          'columnsettings' => 'date,Invoice Date

invoice,Invoice

stock,Stock Item

pprice,Unit Price(Excl)

sprice,Selling Price

spexcl,Selling (Excl)

GP,GP%,total:avg,',
          'selector' => '2',
          'data' => 'SELECT

    `suppliers`.`code`

    , `suppliers`.`name` AS supname

    , `stockitems`.`name` AS stock

    , `suppliers`.`code`

    , `purchases`.`invoice`

    , `purchases`.`date`

    , `purchases`.`org_qty`

    , `purchases`.`org_price`

    , `purchases`.`vat`

    ,	menu.`orgprice` AS sprice

    ,  ROUND(IF(purchases.vat = 1,menu.orgprice/1.15,menu.orgprice),2) AS spexcl

    , `menu`.`useflag`

    ,  ROUND((purchases.org_price/purchases.org_qty),2) AS pprice

    ,  ROUND ((100-(purchases.org_price/purchases.org_qty)/(IF(purchases.vat = 1,menu.orgprice/1.15,menu.orgprice))*100),2) AS GP

    

FROM

    `wcfvm_1`.`menu`

    INNER JOIN `wcfvm_1`.`stockitems` 

        ON (`menu`.`stockid` = `stockitems`.`id`)

    INNER JOIN `wcfvm_1`.`purchases` 

        ON (`stockitems`.`id` = `purchases`.`stockitems_id`)

    INNER JOIN `wcfvm_1`.`suppliers` 

        ON (`purchases`.`supplier_id` = `suppliers`.`id`)

      

      WHERE purchases.date >= \'[sdate]\' 

        AND purchases.date <= \'[edate]\'



        ORDER BY suppliers.name;',
          'description' => 'GP Report New',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'supname',
          'id' => '37',
          'title' => 'GP REPORT',
          'category' => 'PURCHASES',
          'code' => '37'
        };