Exemple #1
0
function dashInput()
{
    // Preparation {
    if ($_POST["conf"]["date"]) {
        $pulldate = $_POST["conf"]["date"];
        $month = $pulldate["month"];
        $year = $pulldate["year"];
    } else {
        $month = date("m");
        $year = date("Y");
    }
    $currentyear = date("Y");
    $pulldate = mktime(0, 0, 0, $month, 1, $year);
    $greenmilescore = sqlPull(array("table" => "greenmile_scores", "where" => "date=" . $pulldate, "onerow" => 1));
    $onchange = "onchange='dashinputform.action=\"index.php?mode=maxine/index&action=dashinput\"; dashinputform.submit();'";
    // }
    maxineTop("Greenmile Inputs");
    print "<form name='dashinputform' action='index.php?mode=maxine/index&action=commitdashinput' method='post'>";
    openHeader();
    maxineButton("Submit", "dashinputform.submit()");
    maxineButton("Back", "goTo(\"index.php?mode=maxine/index&action=firstmenu\");");
    closeHeader();
    print "<div class='tray'>";
    // Date Select {
    openSubbar(400);
    print "Date";
    closeSubbar();
    print "<table class='standard' style='width:400px;'>";
    print "<tr class='content1'><td align='center'>";
    print "<select name=conf[date][month] " . $onchange . " style='width:50%;'>";
    for ($i = 1; $i < 13; $i++) {
        print "<option value=" . $i . " " . ($month == $i ? "selected" : "") . ">";
        print date("F", mktime(0, 0, 0, $i, 1, $year));
        print "</option>";
    }
    print "</select>";
    print "<select name=conf[date][year] " . $onchange . " style='width:50%;'>";
    for ($i = 0; $i < 6; $i++) {
        $displayyear = $currentyear - $i;
        print "<option " . ($displayyear == $year ? "selected" : "") . ">" . $displayyear . "</option>";
    }
    print "</select>";
    print "</td></tr>";
    print "</table>";
    // }
    // Misc {
    openSubbar(600);
    print "Miscellaneous";
    closeSubbar();
    print "<table class='standard' style='width:600px;'>";
    print "<tr class='content1'><td align='center'>";
    print "Invoice in full";
    print "</td><td width=25%>";
    print "<input name=conf[details][invoicefull] value='" . $greenmilescore["invoicefull"] . "' style='text-align:right;'>";
    print "</td>";
    print "<td align='center' width=25%>";
    print "POD";
    print "</td><td width=25%>";
    print "<input name=conf[details][pods] value='" . $greenmilescore["pods"] . "' style='text-align:right;'>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Invoice Error";
    print "</td><td>";
    print "<input name=conf[details][invoiceerrors] value='" . $greenmilescore["invoiceerrors"] . "' style='text-align:right;'>";
    print "</td>";
    print "<td align='center'>";
    print "Shortages";
    print "</td><td>";
    print "<input name=conf[details][shortages] value='" . $greenmilescore["shortages"] . "' style='text-align:right;'>";
    print "</td>";
    print "<tr class='content1'><td align='center'>";
    print "Complaints";
    print "</td><td>";
    print "<input name=conf[details][complaints] value='" . $greenmilescore["complaints"] . "' style='text-align:right;'>";
    print "</td>";
    print "<td colspan=2>";
    print "</td></tr>";
    print "</table>";
    // }
    // Defects & Opportunities {
    openSubbar(600);
    print "Defects & Opportunities";
    closeSubbar();
    print "<table class='standard' style='width:600px;'>";
    print "<tr class='content1'><td align='center' width=25%>";
    print "Defect";
    print "</td><td width=25%>";
    print "<input name=conf[details][defects] value='" . $greenmilescore["defects"] . "' style='text-align:right;'>";
    print "</td>";
    print "<td align='center' width=25%>";
    print "Opportunities";
    print "</td><td width=25%>";
    print "<input name=conf[details][opportunities] value='" . $greenmilescore["opportunities"] . "' style='text-align:right;'>";
    print "</td></tr>";
    print "</table>";
    // }
    print "</div>";
    closeTrayDiv();
    print "</form>";
    maxineBottom();
}
function editRightsGroup()
{
    // Preparation {
    if ($_POST["conf"]) {
        $conf = $_POST["conf"];
    }
    if ($conf["groupid"] > 0) {
        $group = sqlPull(array("table" => "rights_groups", "where" => "id=" . $conf["groupid"], "onerow" => 1));
    }
    // }
    maxineTop("Access Control");
    print "<form name='editgroupform' action='index.php?mode=maxine/index&action=updaterightsgroup' method='post'>";
    // Buttons {
    openHeader();
    maxineButton("Update", "editgroupform.submit();", 2);
    maxineButton("Back", "goTo(\"index.php?mode=maxine/index&action=rightsgroups\");", 2);
    closeHeader();
    // }
    print "<div class='tray'>";
    // Details {
    openSubbar(600);
    if ($group) {
        print "'" . $group["name"] . "' Rights Group";
        print "<input type='hidden' name=conf[groupid] value=" . $group["id"] . ">";
    } else {
        print "New Right Groups";
    }
    closeSubbar();
    print "<table class='standard' style='width:600px;'>";
    print "<tr class='content1'><td width=30% align='center'>";
    print "Name";
    print "</td><td width=70%>";
    print "<input name=conf[name] value='" . $group["name"] . "' style='width: 100%;'>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Description";
    print "</td><td>";
    print "<textarea name=conf[desc] style='width: 100%;'>" . $group["description"];
    print "</textarea>";
    print "</td></tr>";
    print "</table>";
    // }
    print "</div>";
    closeTrayDiv();
    print "</form>";
    maxineBottom();
}
function listUsers()
{
    // rightscode is 'usr001'.
    $users = new Users();
    // Preparation {
    $access = testRights($_SESSION["userid"], "usr001");
    $editrights = "onclick=goTo('index.php?mode=maxine/index&action=pagerights&code=usr001')";
    if ($_POST["conf"]) {
        $conf = $_POST["conf"];
    }
    // Building the Where string {
    $where = "1=1";
    if ($conf["search"]["firstname"]) {
        $where .= " AND firstname LIKE '%" . $conf["search"]["firstname"] . "%'";
    }
    if ($conf["search"]["lastname"]) {
        $where .= " AND lastname LIKE '%" . $conf["search"]["lastname"] . "%'";
    }
    if ($conf["search"]["dept"] > 0) {
        $where .= " AND deptid=" . $conf["search"]["dept"];
    }
    // }
    // Building the Sort string {
    if ($conf["sortvar"]) {
        $sort = $conf["sortvar"];
    } else {
        $sort = "1";
    }
    if ($sort == 1) {
        $sortstr = "up.firstname ASC, up.lastname ASC";
    } else {
        if ($sort == 2) {
            $sortstr = "up.firstname DESC, up.lastname DESC";
        } else {
            if ($sort == 5) {
                $sortstr = "position ASC";
            } else {
                if ($sort == 6) {
                    $sortstr = "position DESC";
                } else {
                    if ($sort == 7) {
                        $sortstr = "deptid DESC";
                    } else {
                        if ($sort == 8) {
                            $sortstr = "deptid ASC";
                        }
                    }
                }
            }
        }
    }
    // }
    //$userlist = sqlPull(array("table"=>"users", "where"=>"isgeneric=0", "sort"=>$sortstr));
    $userlist = $users->getRowSet(array("sort" => $sortstr, "where" => $where . " and u.deleted=0 and u.personid!=1", "children" => true));
    $deptlist = sqlPull(array("table" => "m3_departments", "where" => "1=1"));
    $reload = "userlistform.action=\"index.php?mode=maxine/index&action=listusers\"; userlistform.submit()'";
    $mouseover = "onmouseover=\"this.style.backgroundImage='url(../../images/new/mainblack.png)';\" onmouseout=\"this.style.backgroundImage='';\"";
    // }
    maxineTop("Users");
    print "<form name='userlistform' id='userlistform' action='index.php?mode=maxine/index&action=edituser' method='post'>";
    // Buttons {
    openHeader();
    if ($_SESSION["isit"] == 1 || $access > 0) {
        maxineButton("Add User", "goTo(\"index.php?mode=maxine/index&action=edituser\");", 2);
        maxineButton("Search", "toggle(\"searchdiv\");", 2);
    }
    maxineButton("Back", "goTo(\"index.php?mode=maxine/index&action=peoplemenu\");", 2);
    closeHeader();
    // }
    print "<div class='tray'>";
    // Search {
    print "<div id='searchdiv' style='display:none'>";
    openSubbar(400);
    print "Search Box";
    closeSubbar();
    print "<table class='standard' style='width:400px;'>";
    print "<tr class='content1'><td align='center' width=40%>";
    print "First Name";
    print "</td><td width=60% align='left'>";
    print "<input name=conf[search][firstname] value='" . $conf["search"]["firstname"] . "' style='width:200px'>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Last Name";
    print "</td><td align='left'>";
    print "<input name=conf[search][lastname] value='" . $conf["search"]["lastname"] . "' style='width:200px;'";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Department";
    print "</td><td>";
    print "<select name='conf[search][dept]' id='deptselect' style='z-index:500; width:180px; color:BLACK;'>";
    print "<option value=0>- Select Department -</option>";
    foreach ($deptlist as $deptkey => $deptval) {
        print "<option value=" . $deptval["id"] . " " . ($conf["search"]["dept"] == $deptval["id"] ? "selected" : "") . ">" . $deptval["name"] . "</option>";
    }
    print "</select>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center' colspan=2>";
    maxineButton("Submit", $reload, 2);
    print "</td></tr>";
    print "</table>";
    print "</div>";
    // }
    if ($_SESSION["isit"] == 1 || $access > 0) {
        if ($userlist) {
            // Hidden data controls {
            print "<input type='hidden' id='sorttype' name='conf[sortvar]' value=" . $conf["sortvar"] . ">";
            print "<input type=hidden id='useridinput' name='conf[personid]'>";
            // This variable is set to the selected users id, and then submitted with the form.
            // }
            openSubbar(800);
            print "<span " . $editrights . ">User List</span>";
            closeSubbar();
            print "<table class='standard' style='width:800px; margin-bottom:25px;'>";
            // Headers {
            print "<tr class='heading'>";
            print "<td align='center' width=45% onClick='sorttype.value=" . ($sort == 1 ? "2" : "1") . "; " . $reload . ">";
            print "Name";
            if ($sort == 1) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 2) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td>";
            print "<td align='center' width=30% onClick='sorttype.value=" . ($sort == 5 ? "6" : "5") . "; " . $reload . ">";
            print "Position";
            if ($sort == 5) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 6) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td>";
            print "<td align='center' width=25% onClick='sorttype.value=" . ($sort == 7 ? "8" : "7") . "; " . $reload . ">";
            print "Department";
            if ($sort == 7) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 8) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td></tr>";
            // }
            $count = 1;
            foreach ($userlist as $userkey => $userval) {
                $bday = date("d", $userval['userdates']['birthday']['date']);
                $bmonth = date("m", $userval['userdates']['birthday']['date']);
                print "<tr class='content1' style='cursor:pointer' onclick='openUser(" . $userval["personid"] . ");' " . $mouseover . "><td align='center'>";
                if ($userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print $userval["firstname"] . " " . $userval["lastname"] . " (" . $userval["username"] . ")";
                } else {
                    print $userval["username"];
                }
                if ($bday == 01 && $bmonth == 01 && $userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print "<img src='" . BASE . "/images/redcross.png'>";
                }
                print "</td><td align='center'>";
                print $userval["position"];
                print "</td><td align='center'>";
                if ($userval["deptid"] == 0 && $userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print "No Department";
                } else {
                    print $userval['department'];
                }
                print "</td></tr>";
                $count++;
            }
            print "</table>";
        } else {
            print "<tr><td align='center'>";
            print "No Users meet search.";
            print "</td></tr>";
        }
    } else {
        print "<tr><td align='center'>";
        print "You do not have access to this page.";
    }
    print "</div>";
    closeTrayDiv();
    print "</form>";
    maxineBottom();
    //$onclick	= "personid.value=".$userval["personid"]."; userlistform.submit();";
    // Javascript {
    print "<script>\n\t\t\t\t\tfunction openUser(userid) {\n\t\t\t\t\t\tdocument.getElementById('useridinput').value\t= userid;\n\t\t\t\t\t\tdocument.getElementById('userlistform').submit();\n\t\t\t\t\t}\n\t\t\t\t\t</script>";
    // }
}
Exemple #4
0
function listUsers()
{
    // rightscode is 'usr001'.
    // Preparation {
    $access = testRights($_SESSION["userid"], "usr001");
    $editrights = "onclick=goTo('/Maxine/?pagerights&code=usr001')";
    if ($_POST["conf"]) {
        $conf = $_POST["conf"];
    }
    //$userlist = sqlPull(array("table"=>"users", "where"=>"isgeneric=0", "sort"=>$sortstr));
    $users = new TableManager("users");
    $users->setQueryFrom(array("left join" => array(0 => array("table" => array("abbr" => "user_profiles", "table" => "user_profiles"), "on" => "`user_profiles`.`id`=`users`.`user_profiles_id`"))));
    $users->setQueryColumns(array("users" => array("personid", "user_profiles_id", "username", "email", "extension", "cell", "isplace", "isgeneric", "deleted"), "user_profiles" => array("firstname", "lastname", "jobtitle", "staffno", "id", "birthday", "department_id", "location", "interests", "family", "aspirations", "goals", "quote", "createDate")));
    // Building the Where string {
    $where = "`users`.`deleted`=0 AND personid!=1";
    if ($conf["search"]["firstname"]) {
        $where .= $users->quoteString(" AND `user_profiles`.`firstname` like ?", "%" . $conf["search"]["firstname"] . "%");
    }
    if ($conf["search"]["lastname"]) {
        $where .= $users->quoteString(" AND `user_profiles`.`lastname` like ?", "%" . $conf["search"]["lastname"] . "%");
    }
    if ($conf["search"]["position"]) {
        $where .= $users->quoteString(" AND `user_profiles`.`jobtitle` like ?", "%" . $conf["search"]["position"] . "%");
    }
    if ($conf["search"]["department"]) {
        $where .= $users->quoteString(" AND `user_profiles`.`department_id`=?", $conf["search"]["department"]);
    }
    // }
    $users->setWhere($where);
    // Building the Sort string {
    if ($conf["sortvar"]) {
        $sort = $conf["sortvar"];
    } else {
        $sort = "1";
    }
    if ($sort == 1) {
        $users->setOrderBy(array("column" => "firstname", "direction" => "ASC"));
    } else {
        if ($sort == 2) {
            $users->setOrderBy(array("column" => "firstname", "direction" => "DESC"));
        } else {
            if ($sort == 5) {
                $users->setOrderBy(array("column" => "jobtitle", "direction" => "ASC"));
            } else {
                if ($sort == 6) {
                    $users->setOrderBy(array("column" => "jobtitle", "direction" => "DESC"));
                } else {
                    if ($sort == 7) {
                        $users->setOrderBy(array("column" => "department_id", "direction" => "DESC"));
                    } else {
                        if ($sort == 8) {
                            $users->setOrderBy(array("column" => "department_id", "direction" => "ASC"));
                        }
                    }
                }
            }
        }
    }
    // }
    $userlist = $users->selectMultiple();
    $deptlist = sqlPull(array("table" => "m3_departments", "where" => "1=1"));
    $reload = "userlistform.action=\"/Maxine/?listusers\"; userlistform.submit()'";
    $mouseover = "onmouseover=\"this.style.backgroundImage='url(../../images/new/mainblack.png)';this.style.color='WHITE';\" onmouseout=\"this.style.backgroundImage='';this.style.color='BLACK';\"";
    // }
    maxineTop("Users");
    print "<form name='userlistform' id='userlistform' action='/Maxine/?edituser' method='post'>";
    // Buttons {
    openHeader();
    if ($_SESSION["isit"] == 1 || $access > 0) {
        maxineButton("Add User", "goTo(\"/Maxine/?edituser\");", 2);
        maxineButton("Search", "toggle(\"searchdiv\");", 2);
    }
    maxineButton("Back", "history.go(-1);", 2);
    closeHeader();
    // }
    print "<div class='tray'>";
    // Search {
    print "<div id='searchdiv' style='display:none'>";
    openSubbar(400);
    print "Search Box";
    closeSubbar();
    print "<table class='standard' style='width:400px;'>";
    print "<tr class='content1'><td align='center' width=40%>";
    print "First Name";
    print "</td><td width=60% align='left'>";
    print "<input name=conf[search][firstname] value='" . $conf["search"]["firstname"] . "' style='width:200px'>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Last Name";
    print "</td><td align='left'>";
    print "<input name=conf[search][lastname] value='" . $conf["search"]["lastname"] . "' style='width:200px;'";
    print "</td></tr>";
    print "<tr class='content1'><td align='center'>";
    print "Department";
    print "</td><td>";
    print "<select name='conf[search][dept]' id='deptselect' style='z-index:500; width:180px; color:BLACK;'>";
    print "<option value=0>- Select Department -</option>";
    foreach ($deptlist as $deptkey => $deptval) {
        print "<option value=" . $deptval["id"] . " " . ($conf["search"]["dept"] == $deptval["id"] ? "selected" : "") . ">" . $deptval["name"] . "</option>";
    }
    print "</select>";
    print "</td></tr>";
    print "<tr class='content1'><td align='center' colspan=2>";
    maxineButton("Submit", $reload, 2);
    print "</td></tr>";
    print "</table>";
    print "</div>";
    // }
    if ($_SESSION["isit"] == 1 || $access > 0) {
        if ($userlist) {
            // Hidden data controls {
            print "<input type='hidden' id='sorttype' name='conf[sortvar]' value=" . $conf["sortvar"] . ">";
            print "<input type=hidden id='useridinput' name='conf[personid]'>";
            // This variable is set to the selected users id, and then submitted with the form.
            // }
            openSubbar(800);
            print "<span " . $editrights . ">User List</span>";
            closeSubbar();
            print "<table class='standard' style='width:800px; margin-bottom:25px;'>";
            // Headers {
            print "<tr class='heading'>";
            print "<td align='center' width=45% onClick='sorttype.value=" . ($sort == 1 ? "2" : "1") . "; " . $reload . ">";
            print "Name";
            if ($sort == 1) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 2) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td>";
            print "<td align='center' width=30% onClick='sorttype.value=" . ($sort == 5 ? "6" : "5") . "; " . $reload . ">";
            print "Position";
            if ($sort == 5) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 6) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td>";
            print "<td align='center' width=25% onClick='sorttype.value=" . ($sort == 7 ? "8" : "7") . "; " . $reload . ">";
            print "Department";
            if ($sort == 7) {
                print "<img src='" . BASE . "/images/downarrow.png'>";
            } else {
                if ($sort == 8) {
                    print "<img src='" . BASE . "/images/uparrow.png'>";
                }
            }
            print "</td></tr>";
            // }
            $count = 1;
            foreach ($userlist as $userkey => $userval) {
                $bday = date("d", $userval['userdates']['birthday']['date']);
                $bmonth = date("m", $userval['userdates']['birthday']['date']);
                print "<tr class='content1' style='cursor:pointer' onclick='openUser(" . $userval["personid"] . ");' " . $mouseover . "><td align='center'>";
                if ($userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print $userval["firstname"] . " " . $userval["lastname"] . " (" . $userval["username"] . ")";
                } else {
                    print $userval["username"];
                }
                if ($userval["user_profiles_id"] == 0 && $userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print "<img src='" . BASE . "/images/redcross.png' title='No Profile'>";
                }
                print "</td><td align='center'>";
                print $userval["jobtitle"];
                print "</td><td align='center'>";
                if ($userval["department_id"] == 0 && $userval["isgeneric"] < 1 && $userval["isplace"] < 1) {
                    print "No Department";
                } else {
                    print $deptlist[$userval["department_id"]]["name"];
                }
                print "</td></tr>";
                $count++;
            }
            print "</table>";
        } else {
            print "<tr><td align='center'>";
            print "No Users meet search.";
            print "</td></tr>";
        }
    } else {
        print "<tr><td align='center'>";
        print "You do not have access to this page.";
    }
    print "</div>";
    closeTrayDiv();
    print "</form>";
    maxineBottom();
    //$onclick	= "personid.value=".$userval["personid"]."; userlistform.submit();";
    // Javascript {
    print "<script>\n\t\t\t\t\tfunction openUser(userid) {\n\t\t\t\t\t\tdocument.getElementById('useridinput').value\t= userid;\n\t\t\t\t\t\tdocument.getElementById('userlistform').submit();\n\t\t\t\t\t}\n\t\t\t\t\t</script>";
    // }
}