Codice PHP:
// $zonaOld = 'ND';
$zonaOld = '';
foreach ($queryClienti as $cl) {
$clienteCodice = $cl['cliente'];
$zona = $cl['zona'];
$xls->setActiveSheetIndex(0)
->setCellValue('A' . $row, $zona)
->setCellValue('B' . $row, $clienteCodice)
->setCellValue('C' . $row, $cl['ragsoc'])
->setCellValue('D' . $row, $tmp1Netto)
->setCellValue('E' . $row, $tmp1Lordo)
->setCellValue('F' . $row, $tmp1Qta)
->setCellValue('G' . $row, $tmp2Netto)
->setCellValue('H' . $row, $tmp2Lordo)
->setCellValue('I' . $row, $tmp2Qta)
->setCellValue('J' . $row, $tmp3Netto)
->setCellValue('K' . $row, $tmp3Lordo)
->setCellValue('L' . $row, $tmp3Qta)
->setCellValue('M' . $row, $tmpProp)
->setCellValue('N' . $row, $tmpAgente)
->setCellValue('O' . $row, $tmpNote);
$row++;
// CAMBIO ZONA, PROVO AD INSERIRE RIGA
if ($zonaOld != $zona) {
$zonaOld = $zona;
$xls->setActiveSheetIndex(0)
->setCellValue('A' . $row, $zona)
->setCellValue('B' . $row, 'CLIENTI NUOVI')
->setCellValue('C' . $row, '')
->setCellValue('D' . $row, '')
->setCellValue('E' . $row, '')
->setCellValue('F' . $row, '')
->setCellValue('G' . $row, '')
->setCellValue('H' . $row, '')
->setCellValue('I' . $row, '')
->setCellValue('J' . $row, '')
->setCellValue('K' . $row, '')
->setCellValue('L' . $row, $queryBudgetNuovi[0]['bdgn_num_clienti'])
->setCellValue('M' . $row, $queryBudgetNuovi[0]['bdgn_proposta'])
->setCellValue('N' . $row, $queryBudgetNuovi[0]['bdgn_agente'])
->setCellValue('O' . $row, $queryBudgetNuovi[0]['bdgn_note']);
$row++;
}
}
// se vuoi inserire una riga dopo l'ultimo "record"
$xls->setActiveSheetIndex(0)
->setCellValue('A' . $row, $zona)
->setCellValue('B' . $row, 'CLIENTI NUOVI')
->setCellValue('C' . $row, '')
->setCellValue('D' . $row, '')
->setCellValue('E' . $row, '')
->setCellValue('F' . $row, '')
->setCellValue('G' . $row, '')
->setCellValue('H' . $row, '')
->setCellValue('I' . $row, '')
->setCellValue('J' . $row, '')
->setCellValue('K' . $row, '')
->setCellValue('L' . $row, $queryBudgetNuovi[0]['bdgn_num_clienti'])
->setCellValue('M' . $row, $queryBudgetNuovi[0]['bdgn_proposta'])
->setCellValue('N' . $row, $queryBudgetNuovi[0]['bdgn_agente'])
->setCellValue('O' . $row, $queryBudgetNuovi[0]['bdgn_note']);