Esempio n. 1
0
    function last_names()
    {
        global $dbh, $tree_id, $language, $user, $humo_option, $uri_path;
        /*
        $personqry="SELECT pers_lastname, pers_prefix,
        	CONCAT(pers_prefix,pers_lastname) as long_name, count(pers_lastname) as count_last_names
        	FROM humo_persons
        	WHERE pers_tree_id='".$tree_id."' AND pers_lastname NOT LIKE ''
        	GROUP BY long_name ORDER BY count_last_names DESC LIMIT 0,10";
        $person=$dbh->query($personqry);
        while (@$personDb=$person->fetch(PDO::FETCH_OBJ)){
        	// *** No & character in $_GET, replace to: | !!!
        	$last_names[]=$personDb->pers_lastname;
        	$pers_prefix[]=$personDb->pers_prefix;
        	$count_last_names[]=$personDb->count_last_names;
        }
        //echo __('Most frequent surnames:')."<br>";
        echo '<div id="most_frequent_names">'.__('Most frequent surnames:')."<br>";
        for ($i=0; $i<@count($last_names); $i++){
        	$top_pers_lastname='';
        	if ($pers_prefix[$i]){ $top_pers_lastname=str_replace("_", " ", $pers_prefix[$i]); }
        	$top_pers_lastname.=$last_names[$i];
        
        	if (CMS_SPECIFIC=='Joomla'){
        		$path_tmp='index.php?option=com_humo-gen&amp;task=list&amp;database='.$_SESSION['tree_prefix'];
        	}
        	else{
        		$path_tmp=CMS_ROOTPATH.'list.php?database='.$_SESSION['tree_prefix'];
        	}
        
        	if ($user['group_kindindex']=="j"){
        		echo '<a href="'.$path_tmp.'&amp;pers_lastname='.
        		str_replace("_", " ", $pers_prefix[$i]).str_replace("&", "|", $last_names[$i]);
        	}
        	else{
        		$top_pers_lastname=$last_names[$i];
        		if ($pers_prefix[$i]){ $top_pers_lastname.=', '.str_replace("_", " ", $pers_prefix[$i]); }
        
        		echo '<a href="'.$path_tmp.'&amp;pers_lastname='.
        			str_replace("&", "|", $last_names[$i]);
        		if ($pers_prefix[$i]){
        			//echo '&amp;pers_prefix='.addslashes($pers_prefix[$i]);
        			echo '&amp;pers_prefix='.$pers_prefix[$i];
        		}
        		else{
        			echo '&amp;pers_prefix=EMPTY';
        		}
        	}
        	echo '&amp;part_lastname=equals">'.$top_pers_lastname."</a>";
        
        	echo " (".$count_last_names[$i].")";
        
        	if ($i<count($last_names)-1){ echo ' / '; }
        }
        echo '</div>';
        */
        global $maxcols;
        // MAIN SETTINGS
        $maxcols = 3;
        // number of name&nr colums in table. For example 3 means 3x name col + nr col
        $maxnames = 9;
        //$table2_width="500";
        function tablerow($nr, $lastcol = false)
        {
            // displays one set of name & nr column items in the row
            // $nr is the array number of the name set created in function last_names
            // if $lastcol is set to true, the last right border of the number column will not be made thicker (as the other ones are to distinguish between the name&nr sets)
            global $user, $freq_last_names, $freq_pers_prefix, $freq_count_last_names;
            if (CMS_SPECIFIC == 'Joomla') {
                $path_tmp = 'index.php?option=com_humo-gen&amp;task=list&amp;database=' . $_SESSION['tree_prefix'];
            } else {
                $path_tmp = CMS_ROOTPATH . 'list.php?database=' . $_SESSION['tree_prefix'];
            }
            echo '<td class="namelst">';
            if (isset($freq_last_names[$nr])) {
                $top_pers_lastname = '';
                if ($freq_pers_prefix[$nr]) {
                    $top_pers_lastname = str_replace("_", " ", $freq_pers_prefix[$nr]);
                }
                $top_pers_lastname .= $freq_last_names[$nr];
                if ($user['group_kindindex'] == "j") {
                    echo '<a href="' . $path_tmp . '&amp;pers_lastname=' . str_replace("_", " ", $freq_pers_prefix[$nr]) . str_replace("&", "|", $freq_last_names[$nr]);
                } else {
                    $top_pers_lastname = $freq_last_names[$nr];
                    if ($freq_pers_prefix[$nr]) {
                        $top_pers_lastname .= ', ' . str_replace("_", " ", $freq_pers_prefix[$nr]);
                    }
                    echo '<a href="' . $path_tmp . '&amp;pers_lastname=' . str_replace("&", "|", $freq_last_names[$nr]);
                    if ($freq_pers_prefix[$nr]) {
                        echo '&amp;pers_prefix=' . $freq_pers_prefix[$nr];
                    } else {
                        echo '&amp;pers_prefix=EMPTY';
                    }
                }
                echo '&amp;part_lastname=equals">' . $top_pers_lastname . "</a>";
            } else {
                echo '~';
            }
            echo '</td>';
            if ($lastcol == false) {
                echo '<td class="namenr" style="text-align:center;border-right-width:3px">';
            } else {
                echo '</td><td class="namenr" style="text-align:center">';
            }
            // no thick border
            if (isset($freq_last_names[$nr])) {
                echo $freq_count_last_names[$nr];
            } else {
                echo '~';
            }
            echo '</td>';
        }
        function last_names($max)
        {
            global $dbh, $tree_id, $language, $user, $humo_option, $uri_path, $freq_last_names, $freq_pers_prefix, $freq_count_last_names, $maxcols;
            $personqry = "SELECT pers_lastname, pers_prefix,\n\t\t\t\tCONCAT(pers_prefix,pers_lastname) as long_name, count(pers_lastname) as count_last_names\n\t\t\t\tFROM humo_persons\n\t\t\t\tWHERE pers_tree_id='" . $tree_id . "' AND pers_lastname NOT LIKE ''\n\t\t\t\tGROUP BY long_name ORDER BY count_last_names DESC LIMIT 0," . $max;
            $person = $dbh->query($personqry);
            while (@($personDb = $person->fetch(PDO::FETCH_OBJ))) {
                $freq_last_names[] = $personDb->pers_lastname;
                $freq_pers_prefix[] = $personDb->pers_prefix;
                $freq_count_last_names[] = $personDb->count_last_names;
            }
            $row = round(count($freq_last_names) / $maxcols);
            for ($i = 0; $i < $row; $i++) {
                echo '<tr>';
                for ($n = 0; $n < $maxcols; $n++) {
                    if ($n == $maxcols - 1) {
                        tablerow($i + $row * $n, true);
                        // last col
                    } else {
                        tablerow($i + $row * $n);
                        // other cols
                    }
                }
                echo '</tr>';
            }
            return $freq_count_last_names[0];
        }
        echo __('Most frequent surnames:') . "<br>";
        //echo '<table width=500 class="humo nametbl" align="center">';
        echo '<table width="90%" class="humo nametbl" align="center">';
        echo '<tr class=table_headline>';
        $col_width = round(100 / $maxcols) - 6 . "%";
        for ($x = 1; $x < $maxcols; $x++) {
            echo '<td width="' . $col_width . '"><b>' . __('Name') . '</b></td><td style="border-right-width:3px;width:6%"><b>' . __('Total') . '</b></td>';
        }
        echo '<td width="' . $col_width . '"><b>' . __('Name') . '</b></td><td width:6%"><b>' . __('Total') . '</b></td>';
        echo '</tr>';
        $baseperc = last_names($maxnames);
        // displays the table and sets the $baseperc (= the name with highest frequency that will be 100%)
        //echo '<tr><td colspan="2" style="border-right-width:3px;"><a href="javascript:;" onClick=window.open("frequent_surnames.php","","width=970,height=600,top=40,left=60,scrollbars=yes");>'.__('More frequent surnames').'</a></td>';
        echo '<tr class=table_headline><td colspan="2" style="border-right-width:3px;"><a href="' . CMS_ROOTPATH . 'statistics.php?menu_tab=stats_surnames">' . __('More frequent surnames') . '</a></td>';
        //echo '<td colspan="2" style="border-right-width:3px;"><a href="javascript:;" onClick=window.open("frequent_firstnames.php","","width=1050,height=600,top=50,left=60,scrollbars=yes");>'.
        //__('Frequent first names').'</a></td>';
        echo '<td colspan="2" style="border-right-width:3px;"><a href="' . CMS_ROOTPATH . 'statistics.php?menu_tab=stats_firstnames">' . __('Frequent first names') . '</a></td>';
        echo '<td colspan="2"><a href="' . CMS_ROOTPATH . 'statistics.php">' . __('Statistics') . '</a></td></tr>';
        echo '</table>';
        echo '
		<script>
		var tbl = document.getElementsByClassName("nametbl")[0];
		var rws = tbl.rows; var baseperc = ' . $baseperc . ';
		for(var i = 0; i < rws.length; i ++) {
			var tbs =  rws[i].getElementsByClassName("namenr");
			var nms = rws[i].getElementsByClassName("namelst");
		  for(var x = 0; x < tbs.length; x ++) {
			var percentage = parseInt(tbs[x].innerHTML, 10);
			percentage = (percentage * 100)/baseperc;  
			if(percentage > 0.1) {
			   nms[x].style.backgroundImage= "url(images/lightgray.png)"; 
			   nms[x].style.backgroundSize = percentage + "%" + " 100%";
			   nms[x].style.backgroundRepeat = "no-repeat";
			   nms[x].style.color = "rgb(0, 140, 200)";
			}
		  }
		}
		</script>';
    }
Esempio n. 2
0
echo '</div>';
if (CMS_SPECIFIC == "Joomla") {
    $table2_width = "100%";
} else {
    //$table2_width="900";
    $table2_width = "90%";
}
echo '<br><table width=' . $table2_width . ' class="humo nametbl" align="center">';
echo '<tr class=table_headline>';
$col_width = round(100 / $maxcols) - 6 . "%";
for ($x = 1; $x < $maxcols; $x++) {
    echo '<th width="' . $col_width . '">' . __('Name') . '</th><th style="text-align:center;font-size:90%;border-right-width:3px;width:6%">' . __('Total') . '</th>';
}
echo '<th width="' . $col_width . '">' . __('Name') . '</th><th style="text-align:center;font-size:90%;width:6%">' . __('Total') . '</th>';
echo '</tr>';
$baseperc = last_names($maxnames);
// displays the table and sets the $baseperc (= the name with highest frequency that will be 100%)
echo '</table>';
/*
echo '
<script>
var tbl = document.getElementsByClassName("nametbl")[0];
var rws = tbl.rows; var baseperc = '.$baseperc.';
for(var i = 0; i < rws.length; i ++) {
	var tbs =  rws[i].getElementsByClassName("namenr");
	var nms = rws[i].getElementsByClassName("namelst");
	for(var x = 0; x < tbs.length; x ++) {
		var percentage = parseInt(tbs[x].innerHTML, 10);
		percentage = (percentage * 100)/baseperc;  
		if(percentage > 0.1) {
			nms[x].style.backgroundImage= "url(images/lightgray.png)";