function drawBottom() { global $_josh, $modules, $helpdeskOptions, $helpdeskStatus, $modulettes, $page; $return = ' </div> <div id="right"> <div id="tools"> <a class="right button" href="/index.php?action=logout">' . getString('log_out') . '</a> ' . getString('hello') . ' <a href="/staff/view.php?id=' . $_SESSION['user_id'] . '"><b>' . $_SESSION['full_name'] . '</b></a>'; //search $return .= '<form name="search" accept-charset="utf-8" method="get" action="/staff/search.php" onsubmit="javascript:return doSearch(this);"> <input type="text" name="q" placeholder="' . getString('staff_search') . '"/> </form>'; //channel or language selectors if (getOption('channels')) { //$return .= draw_form_select('channel_id', 'SELECT id, title' . langExt() . ' title FROM channels WHERE is_active = 1 AND is_private = 0 ORDER BY precedence', $_SESSION['channel_id'], false, 'channels', 'url_query_set(\'channel_id\', this.value)', getString('networks_view_all')); $return .= draw_form_select('channel_id', 'SELECT c.id, c.title' . langExt() . ' title FROM channels c WHERE c.is_active = 1 AND (c.is_private = 0 OR (SELECT COUNT(*) FROM users_to_channels u2c WHERE u2c.channel_id = c.id AND u2c.user_id = ' . user() . ') > 0) ORDER BY precedence', $_SESSION['channel_id'], false, 'channels', 'url_query_set(\'channel_id\', this.value)', getString('networks_view_all')); } if (getOption('languages')) { $return .= draw_form_select('language_id', 'SELECT id, title FROM languages ORDER BY title', $_SESSION['language_id'], true, 'languages', 'url_query_set(\'language_id\', this.value)'); } //links $links = db_table('SELECT title' . langExt() . ' title, url FROM links WHERE is_active = 1 ORDER BY precedence'); foreach ($links as &$l) { $l = draw_link($l['url'], $l['title'], true); } $return .= draw_div('#links', draw_container('h3', getString('links')) . (admin() ? draw_link('/a/admin/links.php', getString('edit'), false, array('class' => 'right button')) : false) . draw_list($links)); $return .= '</div>'; foreach ($modules as $m) { $return .= ' <table class="right ' . $m['folder'] . '" cellspacing="1"> <tr> <td colspan="2" class="head" style="background-color:#' . $m['color'] . ';"> <a href="/' . $m['folder'] . '/" class="left">' . $m['title'] . '</a> ' . draw_img('/images/arrows-new/' . format_boolean($m['is_closed'], 'up|down') . '.png', url_query_add(array('module' => $m['id']), false)) . ' </td> </tr>'; if (!$m['is_closed']) { include DIRECTORY_ROOT . DIRECTORY_SEPARATOR . $m['folder'] . DIRECTORY_SEPARATOR . 'pallet.php'; } $return .= '</table>'; } $return .= '</div> <div id="footer">'; //if (admin()) $return .= 'page rendered in ' . format_time_exec() . '<br/>'; $return .= getString('copyright') . '<br/>'; if (getOption('legal')) { $return .= draw_link('/login/legal.php', getString('legal_title')); } $return .= '</div></div> <div id="subfooter"></div> </body> </html>'; //record pageview if ($page['id'] && user()) { db_query('INSERT INTO pages_views ( page_id, user_id, timestamp ) VALUES ( ' . $page['id'] . ', ' . user('NULL') . ', GETDATE() )'); } return $return; }
} else { ?> F6F6F6<?php } ?> " width="18%"><?php echo $t["name"]; ?> </td> <td> <?php if ($t["fieldTypeID"] == 4) { if (isset($_GET["id"])) { $v = db_grab("SELECT i2t.tagID FROM contacts_instances_to_tags i2t JOIN contacts_tags t ON i2t.tagID = t.id WHERE i2t.instanceID = {$i["id"]} and t.type_id = {$t["tagTypeID"]} AND t.is_active = 1"); } echo draw_form_select("tag_single_" . $t["tagTypeID"], "SELECT id, tag FROM contacts_tags WHERE type_id = {$t["tagTypeID"]} AND is_active = 1 ORDER BY precedence", @$v["tagID"], false, false, !$t["isRequired"]); } elseif ($t["fieldTypeID"] == 5) { ?> <table class="nospacing" cellpadding="0" cellspacing="0" border="0"> <?php if (isset($_GET["id"])) { $values = db_query("SELECT \r\n\t\t\t\t\t\t\t\t\t\tt.id, \r\n\t\t\t\t\t\t\t\t\t\tt.tag, \r\n\t\t\t\t\t\t\t\t\t\t(SELECT count(*) FROM contacts_instances_to_tags i2t WHERE i2t.tagID = t.id AND i2t.instanceID = {$i["id"]}) selected\r\n\t\t\t\t\t\t\t\t\tFROM contacts_tags t\r\n\t\t\t\t\t\t\t\t\tWHERE t.type_id = {$t["tagTypeID"]}\r\n\t\t\t\t\t\t\t\t\t\tAND t.is_active = 1\r\n\t\t\t\t\t\t\t\t\tORDER by t.precedence"); } else { $values = db_query("SELECT \r\n\t\t\t\t\t\t\t\t\t\tt.id, \r\n\t\t\t\t\t\t\t\t\t\tt.tag,\r\n\t\t\t\t\t\t\t\t\t\t0 selected\r\n\t\t\t\t\t\t\t\t\tFROM contacts_tags t\r\n\t\t\t\t\t\t\t\t\tWHERE t.type_id = {$t["tagTypeID"]}\r\n\t\t\t\t\t\t\t\t\t\tAND t.is_active = 1\r\n\t\t\t\t\t\t\t\t\tORDER by t.precedence"); } $oneFound = false; while ($v = db_fetch($values)) { ?> <tr> <td width="16"><input type="checkbox" class="checkbox" name="tag_multiple_<?php echo $v["id"];
<td><?php echo draw_form_text("laptopName", @$r["laptopName"]); ?> </td> </tr> <tr> <td class="left">Model #</td> <td><?php echo draw_form_text("laptopModel", @$r["laptopModel"]); ?> </td> </tr> <tr> <td class="left">Location</td> <td><?php echo draw_form_select("laptopHomeID", "SELECT id, name FROM it_laptops_homes", @$r["laptopHomeID"]); ?> </td> </tr> <tr> <td class="left">Serial #</td> <td><?php echo draw_form_text("laptopSerial", @$r["laptopSerial"]); ?> </td> </tr> <tr> <td class="left">Express Service Code</td> <td><?php echo draw_form_text("laptopExpressServiceCode", @$r["laptopExpressServiceCode"]); ?>
function addRow($field) { global $_josh; extract($field); $return = ""; if ($type == "hidden") { $return .= draw_form_hidden($name, $value); } else { if ($label) { $return .= '<dt class="' . $type . '">' . $label; if ($additional && $type == "checkboxes") { $return .= $additional; } $return .= '</dt>' . $_josh["newline"]; } $return .= '<dd class="' . $type . '">'; if ($type == "checkbox") { $return .= '<div class="checkbox_option">' . draw_form_checkbox($name, $value) . '<span class="option_name" onclick="javascript:form_checkbox_toggle(\'' . $name . '\');">' . $additional . '</span></div>'; } elseif ($type == "checkboxes") { if ($value) { $options = db_query("SELECT o.id, o.name, (SELECT COUNT(*) FROM {$linking_table} l WHERE l.option_id = o.id AND l.object_id = {$value}) checked FROM {$options_table} o ORDER BY o.name"); } else { $options = db_query("SELECT id, name, 0 checked FROM {$options_table} ORDER BY name"); } while ($o = db_fetch($options)) { $name = "chk_" . str_replace("_", "-", $options_table) . "_" . $o["id"]; $return .= '<div class="checkbox_option">' . draw_form_checkbox($name, $o["checked"]) . '<span class="option_name" onclick="javascript:form_checkbox_toggle(\'' . $name . '\');">' . $o["name"] . '</span></div>'; } } elseif ($type == "date") { $return .= draw_form_date($name, $value, false) . $additional; } elseif ($type == "datetime") { $return .= draw_form_date($name, $value, true) . $additional; } elseif ($type == "note") { $return .= "<div class='note'>" . $additional . "</div>"; } elseif ($type == "password") { $return .= draw_form_password($name, $value, $class, 255, false) . $additional; } elseif ($type == "radio") { if (!$options) { if (!$sql) { $sql = "SELECT id, name FROM options_" . str_replace("_id", "", $name); } $options = db_array($sql); } if ($append) { while (list($addkey, $addval) = each($append)) { $options[$addkey] = $addval; } } foreach ($options as $id => $description) { $return .= '<div class="radio_option">' . draw_form_radio($name, $id, $value == $id, $class) . $description . '</div>'; } } elseif ($type == "select") { if (!$options) { if (!$sql) { $sql = "SELECT id, name FROM options_" . str_replace("_id", "", $name); } $options = db_array($sql); } if ($append) { while (list($addkey, $addval) = each($append)) { $options[$addkey] = $addval; } } $return .= draw_form_select($name, $options, $value, $required, $class, $action); } elseif ($type == "submit") { $return .= draw_form_submit($value, $class) . $additional; } elseif ($type == "text") { $return .= draw_form_text($name, $value, $class, $maxlength, false, false) . $additional; } elseif ($type == "textarea") { $return .= draw_form_textarea($name, $value, $class) . $additional; } $return .= '</dd>' . $_josh["newline"]; } return $return; }
function drawTicketRow($r, $mode = "status") { //mode can be status or type global $priorityOptions, $statusOptions, $ownerOptions, $typeOptions, $_josh; $return = ' <tr> <td rowspan="2">' . drawName($r["created_user"], $r["first"] . ' ' . $r["last"], $r["created_date"], true, $r['updated']) . '</td> <td colspan="3"><a href="ticket.php?id=' . $r["id"] . '"><b>' . $r["title"] . '</b></a></td> <td rowspan="2">' . draw_img("/images/icons/delete.png", drawDeleteLink("Delete this ticket?", $r["id"], "delete", "ticketID")) . '</td> </tr> <tr>'; $t = array("ticketID" => $r["id"]); if ($mode == "status") { $return .= '<td>' . draw_form_select("", $priorityOptions, $r["priorityID"], false, "field", "location.href='" . url_query_add($t, false) . "&newPriority=' + this.value") . '</td> <td>' . draw_form_select("", $statusOptions, $r["statusID"], true, "field", "location.href='" . url_query_add($t, false) . "&newStatus=' + this.value") . '</td> <td>' . draw_form_select("", $ownerOptions, $r["ownerID"], false, "field", "location.href='" . url_query_add($t, false) . "&newOwner=' + this.value") . '</td>'; } elseif ($mode == "type") { $return .= '<td colspan="3">' . draw_form_select("", $typeOptions, $r["type_id"], false, "field", "location.href='" . url_query_add($t, false) . "&newType=' + this.value") . '</td>'; } $return .= '</tr>'; return $return; }
</td> </tr> <tr> <td class="left">Program</td> <td><?php echo draw_form_select("cboProgram", "SELECT programID, programDesc FROM funders_programs ORDER BY programDesc", @$r["awardProgramID"]); ?> </td> </tr> <tr> <td class="left">Cross List</td> <td> <table cellpadding="0" cellspacing="0" border="0" class="small"> <tr> <td><?php echo draw_form_select("cboProgram2", "SELECT programID, programDesc FROM funders_programs ORDER BY programDesc", @$r["awardProgramID2"]); ?> </td> <td> <?php echo draw_form_checkbox("noCrossList", @(!@$r["awardProgramID2"])); ?> </td> <td> (no cross-listing)</td> </tr> </table> </td> </tr> <tr> <td class="left">Amount <div style="float:right">$</span></td> <td><input type="text" size="11" class="field" name="txtAmount" value="<?php echo @$r["awardAmount"];
function addRow($type, $title, $name = "", $value = "", $default = "", $required = false, $maxlength = 50, $onchange = false) { global $rows, $js, $months, $month, $today, $year, $_josh; $textlength = $maxlength > 50 ? 50 : $maxlength; $value = trim($value); if ($type == "raw") { $rows .= $title; } else { $rows .= '<tr>'; if ($type != "button" && $type != "submit" && $type != "hidden" && $type != "raw") { $rows .= '<td class="left">' . $title . '</td>'; } if ($type == "text") { //output text, no form element $rows .= '<td>' . $value . '</td>'; } elseif ($type == "date") { $rows .= '<td>' . draw_form_date($name, $value, false, false, $required) . '</td>'; } elseif ($type == "datetime") { $rows .= '<td>' . draw_form_date($name, $value, true) . '</td>'; } elseif ($type == "checkbox") { $rows .= '<td>' . draw_form_checkbox($name, $value) . '</td>'; } elseif ($type == "itext") { $rows .= '<td>' . draw_form_text($name, $value, false, $maxlength) . '</td>'; if ($required) { $js .= "if (!form." . $name . ".value.length) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "phone") { $rows .= '<td>' . draw_form_text($name, $value, 14, $maxlength) . '</td>'; if ($required) { $js .= "if (!form." . $name . ".value.length) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "extension") { $rows .= '<td>' . draw_form_text($name, $value, 4, $maxlength) . '</td>'; if ($required) { $js .= "if (!form." . $name . ".value.length) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "password") { $rows .= '<td>' . draw_form_password($name, $value, $textlength, $maxlength) . '</td>'; if ($required) { $js .= "if (!form." . $name . ".value.length) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "select") { $rows .= '<td>'; $rows .= draw_form_select($name, $value, $default, $required, false, $onchange); $rows .= '</td>'; } elseif ($type == "user") { $result = db_query("SELECT \n\t\t\t\t\t\t\t\t\t\t\tuserID, \n\t\t\t\t\t\t\t\t\t\t\tISNULL(nickname, firstname) first,\n\t\t\t\t\t\t\t\t\t\t\tlastname last \n\t\t\t\t\t\t\t\t\t\tFROM intranet_users\n\t\t\t\t\t\t\t\t\t\tWHERE isActive = 1\n\t\t\t\t\t\t\t\t\t\tORDER by lastname"); while ($r = db_fetch($result)) { $options[$r["userID"]] = $r["first"] . ", " . $r["last"]; } $rows .= '<td>'; $rows .= draw_form_select($name, $options, $default, $required, false, $onchange); $rows .= '</td>'; } elseif ($type == "department") { $rows .= '<td><select name="' . $name . '">'; $result = db_query("SELECT \n\t\t\t\t\t\t\t\t\t\t\tdepartmentID,\n\t\t\t\t\t\t\t\t\t\t\tdepartmentName,\n\t\t\t\t\t\t\t\t\t\t\tquoteLevel\n\t\t\t\t\t\t\t\t\t\tFROM intranet_departments\n\t\t\t\t\t\t\t\t\t\tWHERE isActive = 1\n\t\t\t\t\t\t\t\t\t\tORDER by precedence"); while ($r = db_fetch($result)) { $rows .= '<option value="' . $r["departmentID"] . '"'; if ($r["departmentID"] == $default) { $rows .= ' selected'; } $rows .= '>'; if ($r["quoteLevel"] == 2) { $rows .= " · "; } elseif ($r["quoteLevel"] == 3) { $rows .= " - "; } $rows .= $r["departmentName"] . '</option>'; } $rows .= '</select></td>'; } elseif ($type == "userpic") { $rows .= '<td>' . drawName($name, $value, $default, true, " ") . '</td>'; } elseif ($type == "textarea") { $rows .= '<td>' . draw_form_textarea($name, $value) . '</td>'; $js .= " tinyMCE.triggerSave();" . $_josh["newline"]; if ($required) { $js .= "if (!form." . $name . ".value.length || (form." . $name . ".value == '<p> </p>')) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "textarea-plain") { $rows .= '<td>' . draw_form_textarea($name, $value, "noMceEditor") . '</td>'; if ($required) { $js .= "if (!form." . $name . ".value.length) errors[errors.length] = 'the \\'" . $title . "\\' field is empty';" . $_josh["newline"]; } } elseif ($type == "hidden") { $rows .= draw_form_hidden($name, $value); } elseif ($type == "submit") { $rows .= '<td colspan="2" align="center" class="bottom">' . draw_form_submit($title, "button") . '</td>'; } elseif ($type == "button") { $rows .= '<td colspan="2" align="center" class="bottom">' . draw_form_button($title, $value, "button") . '</td>'; } elseif ($type == "file") { $rows .= '<td>' . draw_form_file($name) . '</td>'; } $rows .= '</tr>' . $_josh["newline"]; } }
</td> </tr> <tr height="30"> <td class="left">Department</td> <td><?php echo draw_form_select("departmentID", "SELECT departmentID, shortName FROM departments WHERE isHelpdesk = 1", $r["departmentID"], true, "field", "location.href='" . $request["path_query"] . "&ticketID=" . $_GET["id"] . "&newDepartment=' + this.value", false); ?> </td> </tr> <tr height="30"> <td class="left">Priority</td> <td><?php if ($page['is_admin'] || $r["is_adminPriority"]) { echo draw_form_select("priorityID", "SELECT id, description FROM helpdesk_tickets_priorities", $r["priorityID"], true, "field", "location.href='" . $request["path_query"] . "&ticketID=" . $_GET["id"] . "&newPriority=' + this.value"); } else { echo draw_form_select("priorityID", "SELECT id, description FROM helpdesk_tickets_priorities WHERE is_admin = 0", $r["priorityID"], true, "field", "location.href='" . $request["path_query"] . "&ticketID=" . $_GET["id"] . "&newPriority=' + this.value"); } ?> </td> </tr> <?php if ($r["ipAddress"]) { ?> <tr height="30"> <td class="left">IP Address</td> <td><?php echo $r["ipAddress"]; ?> </td> </tr> <?php
function draw_form_select_month($name, $start, $default = false, $length = false, $class = false, $js = false, $nullable = false) { //select of months going back to $start mm/yyyy format global $_josh; if (!$class) { $class = $_josh["styles"]["field"]; } list($startMonth, $startYear) = explode("/", $start); $array = array(); $break = false; while ($break == false) { $array[$startMonth . "/" . $startYear] = $_josh["months"][$startMonth - 1] . " " . $startYear; if ($startMonth == $_josh["month"] && $startYear == $_josh["year"]) { $break = true; } elseif ($startMonth == 12) { $startMonth = 1; $startYear++; } else { $startMonth++; } } return draw_form_select($name, array_reverse($array), $default, !$nullable, $class, $js); }
<?php $corners = array('top-left', 'top-right', 'bottom-left', 'bottom-right'); foreach ($corners as $c) { echo draw_div_class($c, draw_img('/images/corners-white/' . $c . '.png')); } echo draw_img(DIRECTORY_WRITE . "/login.png"); $f = new form('login', false, getString('submit')); $f->set_field(array('name' => 'email', 'type' => 'text', 'label' => getString('email'), 'value' => @$_COOKIE["last_email"])); $f->set_field(array('name' => 'password', 'type' => 'password', 'label' => getString('password'))); $f->set_field(array('name' => 'goto', 'type' => 'hidden', 'value' => @$_GET["goto"])); $f->set_focus(@$_COOKIE["last_email"] ? 'password' : 'email'); echo $f->draw(); ?> </div> <div id="grey"> <?php foreach ($corners as $c) { echo draw_div_class($c, draw_img('/images/corners-grey/' . $c . '.png')); } echo getString("app_welcome"); echo draw_nav(array('/login/password_reset.php' => getString("login_forgot_password"), '/login/account_request.php' => getString("login_need_account"), 'mailto:' . $_josh['email_default'] => getString("login_ask_question"))); ?> </div> <?php if (getOption('languages')) { echo draw_div('language', draw_form_select('language_id', 'SELECT id, title FROM languages ORDER BY title', $_SESSION['language_id'], true, 'grey', 'url_query_set(\'language_id\', this.value)')); } ?> </div> </body> </html>
?> '><?php } else { ?> <b><?php } echo format_string($o['title'], 26); ?> </b></a></td> <?php } ?> </tr> </table> <?php } else { echo drawPanel(draw_form_select('foo', $orgs, url_id(), false, false, 'location.href=\'' . $request['path'] . '?id=\' + this.value')); } if (url_id()) { $where = $_GET['id'] == 0 ? ' IS NULL ' : ' = ' . $_GET['id']; $links = $page['is_admin'] ? array('add_edit.php' => getString('add_new')) : false; echo drawStaffList('u.is_active = 1 AND u.organization_id ' . $where, 'This organization has no staff associated with it.', $links, draw_link($request['path_query'], $page['title']) . ' > ' . db_grab('SELECT title FROM organizations WHERE id = ' . $_GET['id'])); } else { $t = new table('foo', drawHeader()); $t->set_column('title', false, getString('title')); foreach ($orgs as &$o) { $o['title'] = draw_link('organizations.php?id=' . $o['id'], $o['title']); } echo $t->draw($orgs); } echo drawBottom();
<td width="82%"><?php echo @draw_form_text("name", $r["name"]); ?> </td> </tr> <tr> <td class="gray"><nobr>Type:</nobr></td> <td><?php echo draw_form_select("cboFunderTypes", "SELECT funderTypeID, funderTypeDesc FROM funders_Types", @$r["funderTypeID"]); ?> </td> </tr> <tr> <td class="gray"><nobr>Status:</nobr></td> <td><?php echo draw_form_select("cboFunderStatuses", "SELECT funderStatusID, funderStatusDesc FROM funders_Statuses", @$r["funderStatusID"]); ?> </td> </tr> <tr> <td class="gray"><nobr>Funder Contact:</nobr></td> <td><?php echo drawSelectUser("cboStaff", @$r["staffID"]); ?> </td> </tr> <tr> <td colspan="2"> <br> <table width="100%"> <tr>