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>"; // } }
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>"; // } }