$id_activitat = array();
$nom_activitat = array();
if(!empty($tipus)){
if($tipus_backup != $tipus) $act = 0;
if($tipus != 0 && $act == 0){ // Han pitjat el botó de llista per data
$SQL = "SELECT id_cli, nom_cli, oculta_cli FROM client c WHERE c.tipus_cli=$tipus AND c.oculta_cli=0 ORDER BY nom_cli ";
$tipus_backup = $tipus;
}elseif($tipus != 0 && $act != 0){
$SQL = "SELECT c.id_cli, c.nom_cli, c.oculta_cli, ac.id_cli, ac.id_act FROM (client c INNER JOIN activitat_client ac ON ac.id_cli=c.id_cli AND ac.id_act=$act) WHERE tipus_cli=$tipus AND c.oculta_cli=0 ORDER BY c.nom_cli ";
$tipus_backup = $tipus;
}
$taula = mysql_query($SQL);
if(($num_files = mysql_num_rows($taula)) > 0){
// aixó per a les activitats
while($fila = mysql_fetch_array($taula)){
$SQL_act = "SELECT a.id_act, a.nom_act_$idioma AS nom_act FROM activitat a INNER JOIN activitat_client ac ON a.id_act=ac.id_act AND ac.id_cli=".$fila["id_cli"];
$taula_act = mysql_query($SQL_act);
while($fila_act = mysql_fetch_array($taula_act)){
if (!array_key_exists($fila_act["id_act"], $id_activitat)) {
array_push($id_activitat, $fila_act["id_act"]);
array_push($nom_activitat, $fila_act["nom_act"]);
}
}
}
?>
if($num_pages > 1){
$np_var_name = "np";
$s_var_name = "s";
$var_extra = "&tipus=$tipus&act=$act";
include("includes/paginacio2.inc");
}
}else{
?>
echo $msg_clients_error[$idioma]?>
}
}
?>
|