$VAR1 = {
          'columnsettings' => 'date,CASHUP DATE

name,WAITRON NAME

total,INVOICE TOTAL

creditcards_total,CREDIT CARD AMOUNT,total:sum;number:yes;align:right;',
          'selector' => '2',
          'data' => 'SELECT

    `dcash`.`date`

    , `waitron`.`name`

    , `dcashinvoices`.`dcinv_turnover_total` AS total

    , `dcashinvoices`.`creditcards_total`

FROM

    `oakdale_1`.`dcash`

    INNER JOIN `oakdale_1`.`dcashitems` 

        ON (`dcash`.`id` = `dcashitems`.`dcash_id`)

    INNER JOIN `oakdale_1`.`dcashinvoices` 

        ON (`dcashitems`.`id` = `dcashinvoices`.`dcashitems_id`)

    INNER JOIN `oakdale_1`.`waitron` 

        ON (`dcashitems`.`waitron_id` = `waitron`.`id`)

        WHERE creditcards_total > 0

        AND dcash.`f_status` = 1

        and dcashinvoices.f_status = 1 AND

        dcash.date >= \'[sdate]\' AND dcash.date <= \'[edate]\';

',
          'description' => 'Credit Card Receipts on Trade',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'date',
          'id' => '58',
          'title' => 'Credit Card Report',
          'category' => 'OAKDALE - REPORTS',
          'code' => '106'
        };