include ("../common/public.php") ; print_r($_GET + $_POST) ; // exit ; if ($dirToSort == "ASC") $orderByDir = SORT_ASC ; else $orderByDir = SORT_DESC ; /*** * recupero i dati di tutti gli agenti ***/ $q = " select A.* from $tagenti A order by A.Nome " ; list($n, $d) = $db->RecuperaDati($q) ; for ($i=0; $i<$n; $i++) { $arrNomAge[] = $d['Nome'][$i] ; $arrParIva[] = $d['PIva'][$i] ; $arrInd[] = $d['Indirizzo'][$i] ; $arrCap[] = $d['Cap'][$i] ; $arrCit[] = $d['Citta'][$i] ; $arrPro[] = $d['Provincia'][$i] ; $arrTel[] = $d['Telefono'][$i] ; $arrCel[] = $d['Cellulare'][$i] ; $arrFax[] = $d['Fax'][$i] ; $arrPer[] = $d['Percentuale'][$i] ; $arrMan[] = ($d['TipoMandato'][$i] == 1 ? "Pluri" : "Mono") ; $arrEmail[] = $d['Email'][$i] ; $arrNot[] = $d['Note'][$i] ; } switch($colToSort) { case 0: // Nome Agente array_multisort($arrNomAge, $orderByDir, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 1: // Partita Iva array_multisort($arrParIva, $orderByDir, $arrNomAge, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 2: // Indirizzo array_multisort($arrInd, $orderByDir, $arrNomAge, $arrParIva, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 3: // Cap array_multisort($arrCap, $orderByDir, $arrNomAge,$arrParIva, $arrInd, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 4: // Cittą array_multisort($arrCit, $orderByDir, $arrNomAge,$arrParIva, $arrInd, $arrCap, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 5: // Provincia array_multisort($arrPro, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 6: // Telefono array_multisort($arrTel, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 7: // Cellulare array_multisort($arrCel, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrFax, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 8: // Fax array_multisort($arrFax, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrPer, $arrMan, $arrEmail, $arrNot) ; break ; case 9: // Provvigione array_multisort($arrPer, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrMan, $arrEmail, $arrNot) ; break ; case 10: // Mandato array_multisort($arrMan, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrEmail, $arrNot) ; break ; case 11: // Email array_multisort($arrEmail, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrNot) ; break ; case 12: // Note array_multisort($arrNot, $orderByDir, $arrNomAge, $arrParIva, $arrInd, $arrCap, $arrCit, $arrPro, $arrTel, $arrCel, $arrFax, $arrPer, $arrMan, $arrEmail) ; break ; } $arrParGen = array() ; $arrParGen = RecuperaParametriGenerali($arrParGen, $tparametri) ; $nome = $arrParGen['NomeAgenzia'] ; $sede = "Sede operativa: " . $arrParGen['IndirizzoAgenzia'] ; $datisede = "Telefono: " . $arrParGen['TelefonoAgenzia'] . " Fax: " . $arrParGen['FaxAgenzia'] . " -- P.I. " . $arrParGen['PartitaIvaAgenzia'] ; $emailsede = "Email: " . $arrParGen['MailAgenzia'] ; $titolo = "Lista di Tutti gli Agenti" ; ?>
![]() |
echo $sede ?> echo $datisede ?> echo $emailsede ?> |
||
| echo $titolo ?> | |||||||||||||||||||
| al echo Date("d/m/Y") ?> | |||||||||||||||||||
| Nome | Partita Iva | Indirizzo | Cap | Cittą | Prov | Telefono | Cellulare | Fax | Provv | Mandato | Note | ||||||||
| echo htmlspecialchars($arrNomAge[$i]) ?> | echo StampaStr($arrParIva[$i]) ?> | echo StampaStr(htmlspecialchars($arrInd[$i])) ?> | echo StampaStr($arrCap[$i]) ?> | echo StampaStr($arrCit[$i]) ?> | echo StampaStr($arrPro[$i]) ?> | echo StampaStr($arrTel[$i]) ?> | echo StampaStr($arrCel[$i]) ?> | echo StampaStr($arrFax[$i]) ?> | echo nfp($arrPer[$i]) . "%" ?> | echo $arrMan[$i] ?> | echo StampaStr($arrEmail[$i]) ?> | echo StampaStr(htmlspecialchars($arrNot[$i])) ?> | |||||||