Example #1
0
 public function __construct($regionID)
 {
     $gremlin = new Gremlin();
     #load region's info from ID
     $sql = "SELECT * FROM regions WHERE reg_id='{$regionID}'";
     $rawData = $gremlin->query($sql);
     extract($rawData);
     $this->regionID = $regionID;
     $this->companyID = $cmp_id;
     $this->name = $name;
     $this->city = $city;
     $this->state = $state;
     loadSites();
 }
Example #2
0
 public function __construct($siteID)
 {
     $gremlin = new Gremlin();
     #load sites's info from ID
     $sql = "SELECT * FROM sites WHERE site_id='{$siteID}'";
     $rawData = $gremlin->query($sql);
     extract($rawData);
     $this->siteID = $siteID;
     $this->active = $actice;
     $this->name = $name;
     $this->address = $address;
     $this->city = $city;
     $this->state = $state;
     $this->zip = $zip;
     $this->fax = $fax;
 }
Example #3
0
 public function __construct($trayID)
 {
     $gremlin = new Gremlin();
     #load tray's info from ID
     $sql = "SELECT * FROM trays WHERE tray_id='{$trayID}'";
     $rawData = $gremlin->query($sql);
     extract($rawData);
     $this->trayID = $trayID;
     $this->name = $name;
     $this->companyID = $cmp_id;
     $this->teamID = $team_id;
     $this->atNow = $atnow;
     $this->userID = $usr_id;
     $this->siteID = $site_id;
     $this->storageID = $stor_id;
     $this->loanTeam = $loan_team;
     loadTags();
     loadContents();
 }
Example #4
0
<?php

# homeList.php
# List view for the Athena homepage
include_once "includes.php";
session_start();
$gremlin = new Gremlin();
$userID = $_SESSION['userID'];
$userType = $_SESSION['userType'];
$user = $gremlin->spawnPage($userID, $userType);
$page = "";
$page .= $gremlin->buildMenu("{$user->uname}" . "'s Home - List", "homeList");
$script = "<script src='js/home.js'></script>";
$colTabRow = "<div class='colTabRow'>";
#open colTabRow
$tabRow = "<div class='tabRowHeader'><h3>Calendar</h3></div>";
#tabRow
$tabRow .= "<div id='tab1Button' onclick='tab1Toggle()' class='tabSelected'>All Events</div><div id='tab2Button' class='tabUnselected' onclick='tab2Toggle()'>My Events</div>";
$tabRow .= "</div>";
#end colTabRow
$colTabRow .= $tabRow;
#menu bar with date selection stuff
$dateMenuBar = "<div class='dateMenuBar'>";
#open dateMenuBar
#this is where we figure out what date to show and display it in the date box
$timeOffset = 0;
# To calculate week range:
# 1. find Sunday's date relative to now.
# 2. calculate number of weeks offset based in GET parameter
# 3. add number of weeks to Sunday
if (isset($_GET['offset'])) {
Example #5
0
<?php

#Index.php
#Main site login page
include_once "includes.php";
$error = "";
#check for login
session_start();
//session_destroy();
if (!empty($_SESSION)) {
    header("Location: home.php");
    die;
}
if (isset($_POST['userName'])) {
    $gremlin = new Gremlin();
    $username = $_POST['userName'];
    $rawPW = $_POST['pwd'];
    #check inputted password
    $userType = User::checkPassword($username, $rawPW);
    if ($userType != "not found") {
        #login successful
        //session_start();
        #find user's ID
        if ($userType == "user") {
            $sql = "SELECT usr_id FROM users WHERE uname='{$username}'";
            echo $sql;
            $rawData = $gremlin->query($sql, true);
            $userID = $rawData['usr_id'];
            $loggedInUser = $userID;
        } else {
            if ($userType == "client") {
Example #6
0
<?php

#home.php
#this is the main screen for logged-in users
#includes calendar screen and, menu bar, notifications, colTabRow, 2 tabs, 2 col[3:1]
#
#Col 1: 2 tabs { "All Events", "My Events" }
# |
# |-"All Events": List of all events relating to user's team.
# |
# |-"My Events": List of all tray events relating directly to user.
#
#Col 2: Notifications
include_once "includes.php";
session_start();
$gremlin = new Gremlin();
$userID = $_SESSION['userID'];
$userType = $_SESSION['userType'];
$user = $gremlin->spawnPage($userID, $userType);
$page = "";
$page .= $gremlin->buildMenu("{$user->uname}" . "'s Home");
#build colTabRow
$colTabRow = "<div class='colTabRow'>";
#open colTabRow
########START DUMMY
$dmyTabRow = "<div class='tabRowHeader'><h3>Calendar</h3></div>";
#dmyTabRow
$dmyTabRow .= "<div id='tab1Button' class='selected'>All Events</div><div id='tab2Button' class='unselected'>My Events</div>";
$dmyTabRow .= "</div>";
#end dmyTabRow
$colTabRow .= $dmyTabRow;
Example #7
0
 public static function checkPassword($username, $rawPW)
 {
     $gremlin = new Gremlin();
     #salting password
     $pass = "******";
     #all passwords should be encoded through md5()
     $pass = md5($pass);
     #first, look to see if person logging in is a user, and check their permissions
     $sql = "SELECT usr_id FROM users WHERE uname='{$username}' AND pwd='{$pass}'";
     $rawResult = $gremlin->query($sql, true);
     if (!empty($rawResult)) {
         #user found!
         return "user";
     } else {
         #user not found, check to see if it's a client
         $sql = "SELECT usr_id FROM clients WHERE uname='{$username}' AND pwd='{$pass}'";
         $rawResult = $gremlin->query($sql, true);
         if (!empty($rawResult)) {
             #client found!
             return "client";
         } else {
             #invalid username/password
             return "not found";
         }
     }
 }
Example #8
0
<?php

#home.php
#this is the main screen for logged-in users
#includes calendar screen and, menu bar, notifications, colTabRow, 2 tabs, 2 col[3:1]
#
#Col 1: 2 tabs { "All Events", "My Events" }
# |
# |-"All Events": List of all events relating to user's team.
# |
# |-"My Events": List of all tray events relating directly to user.
#
#Col 2: Notifications
include_once "includes.php";
session_start();
$gremlin = new Gremlin();
$userID = $_SESSION['userID'];
$userType = $_SESSION['userType'];
$user = $gremlin->spawnPage($userID, $userType);
$page = "";
$page .= $gremlin->buildMenu("{$user->uname}" . "'s Home", "home");
$script = "<script src='js/home.js'></script>";
#build colTabRow
$colTabRow = "<div class='colTabRow'>";
#open colTabRow
$tabRow = "<div class='tabRowHeader'><h3>Calendar</h3></div>";
#tabRow
$tabRow .= "<div id='tab1Button' onclick='tab1Toggle()' class='tabSelected'>All Events</div><div id='tab2Button' class='tabUnselected' onclick='tab2Toggle()'>My Events</div>";
$tabRow .= "</div>";
#end colTabRow
$colTabRow .= $tabRow;