chinh2597

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use App\Model\Customer;
use App\Model\Orderstate;

$customerIds = array_column(DB::select('select id, (select count(*) from `order` o where o.customer_id = c.id and orderstate_id in(9,10,12,29,67)) as total_order, (select max(created_at) from `order` o where o.customer_id = c.id) as latest_order from `customer` c  having total_order > 2 order by total_order desc, latest_order desc'), 'id');

$spreadsheet = new Spreadsheet();
$activeWorksheet = $spreadsheet->getActiveSheet();
$index = 1;