<?php

namespace app\controller;

use support\Request;
use support\Db;
use process\TaskGetSale;

class ExchangeController
{
    public function test(Request $request)
    {
        set_time_limit(3600 * 10);
		$rows = Db::table('gsp_new_saledataall_bi')
				->select('transfernewno','custnumber', Db::raw('SUM(quantity) as qty'), Db::raw('MAX(orderdate) as orderdate'))
				->where( 'deliverydate','>=', $yearRegion )
				->groupBy('custnumber','transfernewno')
				->offset($page * $pageSize)
				->limit($pageSize)
				//->toSql();
				->get();
		
		return response(put($data));
    }


}