public function __construct($caseID) { $this->gremlin = new Gremlin(); #load case's info from ID $sql = "SELECT * FROM cases WHERE case_id='{$caseID}'"; $rawData = $gremlin->query($sql); extract($rawData); $this->caseID = $caseID; $this->teamID = $team_id; $this->docID = $doc_id; $this->procID = $proc_id; $this->siteID = $site_id; $this->status = $status; $this->dttm = $dttm; $this->cmt = $cmt; loadTypes(); loadActiveAssignments(); }
<?php global $user; include_once '../../php/functions.php'; include_once '../../php/ajax.php'; sec_session_start(); $accountTypes = loadTypes('account_types'); $frequency = loadTypes('frequency'); ob_start(); ?> <form> <p class="dialog-info" class="error"> </p> <table width="100%"> <tbody> <tr class="form-row"> <td><label for="account-name">Account Name:</label></td> <td><input type="text" id="account-name" class="xcp-form-input" name="name" /></td> <td><label for="account-type">Account Type:</label></td> <td><select id="account-type" class="chosen" name="type" data-placeholder="Select Type"> <option/> <?php foreach ($accountTypes as $key => $type) { ?> <option value="<?php echo $key; ?> "><?php echo $type; ?>
function loadTypes($area) { global $db; $tags = array(); try { $tagQuery = $db->prepare("SELECT * FROM tag WHERE area=:area ORDER BY typeName ASC"); $tagQuery->execute(array(':area' => $area)); } catch (PDOException $e) { exit("error in query"); } while ($row = $tagQuery->fetch(PDO::FETCH_ASSOC)) { $tags[] = $row; } return $tags; } $tags = loadTypes($area); // Determine if type has changed so that we can require approval if the type requires it and it has not actually gone through an approval process. if ($type != $_POST['type']) { // Find the correct tag for the old default whiteboard type foreach ($tags as $tag) { if ($tag['typeId'] == $type) { $oldTag = $tag; break; } } // Find the correct tag for the new default whiteboard type foreach ($tags as $tag) { if ($tag['typeId'] == $_POST['type']) { $newTag = $tag['mustApprove']; break; }
<?php include_once 'class-dbconnect.php'; include_once 'config.php'; sec_session_start(); $accountTypes = loadTypes('account_types'); function checkbrute($user_id) { global $dbc; $now = time(); $valid_attempts = $now - 2 * 60 * 60; if ($stmt = $dbc->prepare("SELECT time FROM login_attempts WHERE user_id = ? AND time > '{$valid_attempts}'")) { $stmt->bind_param('i', $user_id); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 5) { return true; } else { return false; } } } function checkLogin() { global $dbc; if (isset($_SESSION['user_id'], $_SESSION['login_string'])) { $user_id = $_SESSION['user_id']; $login_string = $_SESSION['login_string']; $user_browser = $_SERVER['HTTP_USER_AGENT']; if ($stmt = $dbc->prepare("SELECT password FROM users WHERE id = ? LIMIT 1")) { $stmt->bind_param('i', $user_id);
<?php include_once '../../php/functions.php'; include_once '../../php/ajax.php'; sec_session_start(); $random_salt = hash('sha512', uniqid(mt_rand(1, mt_getrandmax()), true)); $_SESSION['cipher'] = $random_salt; $_SESSION['xcp_id'] = hash('sha512', $random_salt, $_SERVER['HTTP_USER_AGENT']); $account = getAccount($_POST['id']); $_SESSION['account_id'] = $account['ID']; $accountTypes = loadTypes('account_types'); $transTypes = loadTypes('trans_types', $account['type']); $formFields = array(array('transaction-ref' => array('class' => 'xcp-form-input', 'type' => 'text', 'label' => 'Confirmation/Ref #:', 'placeholder' => '', 'title' => ''), 'transaction-date' => array('class' => 'xcp-form-input datepicker', 'type' => 'text', 'label' => 'Transaction Date:', 'placeholder' => 'mm/dd/yyyy', 'desciption' => '')), array('transaction-source' => array('class' => 'chosen-select expense', 'type' => 'select', 'label' => 'Transaction Source:', 'data-placeholder' => 'Select Account', 'title' => '', 'options' => loadSources()), 'transaction-amount' => array('class' => 'xcp-form-input', 'type' => 'text', 'label' => 'Transaction Amount:', 'placeholder' => '', 'title' => '', 'style' => $account['due_date'] < date() ? 'color: red; font-weight:bold' : '', 'value' => number_format($account['payment'], 2))), array('transaction-type' => array('class' => 'chosen-select expense', 'type' => 'select', 'label' => 'Transaction Type:', 'data-placeholder' => 'Select Type', 'title' => '', 'options' => $transTypes), 'transaction-memo' => array('class' => 'xcp-form-input xcp-textarea', 'label' => 'Transaction Memo:', 'title' => '', 'type' => 'textarea'))); ob_start(); ?> <form id="add_transaction"> <section id="" class="page-1 top account-detail"> <h2 class="account-name"><?php echo $account['name']; ?> </h2> <table> <tbody> <tr> <td colspan="3"><h3>Account Status: <span id="account-status"></span></td> </tr> <?php $count = 1; $rowCount = 4; unset($account['user']); foreach ($account as $key => $value) {