}
                        $createdStats[$level][] = $userId;
                    }
                }
                //now check nab
                foreach ($nabLevels as $level) {
                    if (checkLevel($level, $oldStats[$userId]['nab'], $newStats[$userId]['nab'])) {
                        if ($nabStats[$level] == null) {
                            $nabStats[$level] = array();
                        }
                        $nabStats[$level][] = $userId;
                    }
                }
                //now check patrol
                foreach ($patrolLevels as $level) {
                    if (checkLevel($level, $oldStats[$userId]['patrol'], $newStats[$userId]['patrol'])) {
                        if ($patrolStats[$level] == null) {
                            $patrolStats[$level] = array();
                        }
                        $patrolStats[$level][] = $userId;
                    }
                }
            }
            createEmail($editedStats, $createdStats, $nabStats, $patrolStats, $newStats, $startDate, $now);
            echo "\n\nFINISHED UPDATE\n\n";
            return;
        }
    }
}
function createEmail(&$editedStats, &$createdStats, &$nabStats, &$patrolStats, &$stats, $startDate, $endDate)
{
Esempio n. 2
0
function buildHead($cubename_sel, $levels, $ncols, $result)
{
    global $img_sortasc, $img_sortdesc, $img_lev, $img_hier, $img_save, $img_dim;
    $level_ser = implode("-", $levels);
    print "<tr>";
    for ($i = 0; $i < $ncols; $i++) {
        $colname = mysql_fetch_field($result);
        $nome = $colname->name;
        $tabella = $colname->table;
        $pk = $colname->primary_key;
        $v = checkLevel($nome);
        if ($tabella == "") {
            $field = "{$nome}";
        } else {
            $field = "{$tabella}.{$nome}";
        }
        $colonna_ordinamento = "{$tabella}.{$nome}";
        print "<th>";
        print "<a href='#'><img border=0 src='{$img_sortasc}' width=20 height=20 onclick='ordina(\"{$cubename_sel}\",\"{$level_ser}\",\"{$colonna_ordinamento}\",\"asc\")'></a>";
        print "<a href='#'><img border=0 src='{$img_sortdesc}' width=20 height=20 onclick='ordina(\"{$cubename_sel}\",\"{$level_ser}\",\"{$colonna_ordinamento}\",\"desc\")'></a>";
        if ($v == true) {
            print " <a href='#'><img src='{$img_lev}' width=20px height=20px onclick='drill(\"{$cubename_sel}\",\"{$tabella}\",\"{$nome}\")'></a>";
            print " <a href='#'><img src='{$img_hier}' width=20px height=20px onclick='change_hier(\"{$cubename_sel}\",\"{$tabella}\",\"{$nome}\")'></a>";
            print " <a href='#'><img src='{$img_dim}' width=20px height=20px onclick='change_dim(\"{$cubename_sel}\",\"{$tabella}\",\"{$nome}\")'></a>";
        }
        print "<br>{$field}";
        print "</th>";
    }
    print "</tr>";
}