Example #1
0
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;
}
Example #2
0
    } 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"];
Example #3
0
		<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"]);
?>
Example #4
0
 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;
 }
Example #5
0
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;
}
Example #6
0
</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>&nbsp;<?php 
echo draw_form_checkbox("noCrossList", @(!@$r["awardProgramID2"]));
?>
</td>
					<td>&nbsp;(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"];
Example #7
0
 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 .= "&nbsp;&#183;&nbsp;";
                 } elseif ($r["quoteLevel"] == 3) {
                     $rows .= "&nbsp;&nbsp;&nbsp;-&nbsp;";
                 }
                 $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>&nbsp;</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"];
     }
 }
Example #8
0
		</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 
Example #9
0
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);
}
Example #10
0
				<?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>
Example #11
0
            ?>
'><?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']) . ' &gt; ' . 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();
Example #12
0
		<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>