$fieldnames = array_keys($row);
for ($i = 0; $i < count($fieldnames); $i++) {
// FIELDS ACCOUNTID FIELD
if ($fieldnames[$i] != 'accountid') {
echo "<tr valign=\"top\">";
echo "<td>" . str_replace(" ", " ", ucwords(str_replace("_", " ", $fieldnames[$i]))) . ":</td>";
echo "<td>";
if ($fieldnames[$i] == "password") {
echo "<input type=\"password\" name=\"" . $fieldnames[$i] . "\" size=\"50\"/>";
} elseif ($fieldnames[$i] == "phone_number" || $fieldnames[$i] == "fax") {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" size=\"50\" onkeyup=\"inputmask(this.value,this,'phone');\" maxlength=\"12\"/>";
} elseif ($fieldnames[$i] == "zip") {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" size=\"50\" onkeyup=\"inputmask(this.value,this,'zip');\" maxlength=\"5\"/>";
} elseif (get_field_type("accounts", $fieldnames[$i]) == "enum") {
echo "<select name=\"" . $fieldnames[$i] . "\">";
$vals = get_enum("accounts", $fieldnames[$i]);
for ($j = 0; $j < count($vals); $j++) {
echo "<option value=\"" . $vals[$j] . "\"";
echo ">" . $vals[$j] . "</option>";
}
echo "</select>";
} else {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" size=\"50\"/>";
}
echo "</td>";
echo "</tr>";
}
}
echo "<tr><td> </td><td><input type='submit' name='submitaccount' value='Create Account'/></td></tr>";
echo "</table>";
echo "<input type='hidden' name='action' value=''/>";
$rs = mysql_query("SELECT name, fileid, ext FROM design_files WHERE quoteid='" . $_GET["quoteid"] . "'");
while ($row = mysql_fetch_array($rs)) {
$file = $_SERVER["DOCUMENT_ROOT"] . "/admin/designfiles/" . $row["name"];
if (!file_exists($file)) {
$file = $_SERVER["DOCUMENT_ROOT"] . "/admin/designfiles/file_" . $row["fileid"] . $row["ext"];
}
chmod($file, 0755);
if (unlink($file)) {
@mysql_unbuffered_query("DELETE FROM design_files WHERE fileid='" . $row["fileid"] . "'");
}
}
@mysql_unbuffered_query("DELETE FROM quotes WHERE quoteid='" . $_GET["quoteid"] . "'");
echo "<p><strong>Quote #" . $_GET["quoteid"] . " was deleted.</p>";
}
$count = 0;
$vals = get_enum("quotes", "status");
//$sql="SELECT quoteid, status, timestamp, project_name, name, phone_number, email, design_file";
//$sql="SELECT quoteid, status, timestamp, project_name, name, design_file";
$sql = "SELECT quoteid, status, timestamp, project_name, name";
$sql .= " FROM quotes";
$sql .= " WHERE status!='incomplete'";
$sql .= " ORDER BY timestamp DESC";
$result = mysql_query($sql);
echo "<form name='quotes' method='post' action='/admin/quotes.php'>";
echo "<table cellpadding='3' cellspacing='0' border='1'>";
while ($row = mysql_fetch_assoc($result)) {
$fieldnames = array_keys($row);
if ($count == 0) {
echo "<tr>";
for ($i = 0; $i < count($fieldnames); $i++) {
if ($fieldnames[$i] == "name" || $fieldnames[$i] == "email") {
$owner = "";
foreach($rows as $val)
{
$users[$val["id"]] = $val["login"];
if($row["user_id"] == $val["id"]) $owner = $val["login"];
}
$xtpl->assign("OWNER", $owner);
$xtpl->assign("ANOTHERS_OWNERS", get_drop_down_list($users, "owner", "", "Select another owner", 0, "", "onchange=\"document.getElementById('act').value='change_owner'; document.getElementById('form1').submit();\""));
$xtpl->assign("TSTATUS", $row["status"]);
$xtpl->assign("TRATE", (isset($row["rate"]))?"{$row['rate']}":"not rated");
$xtpl->assign("TCOMPLAIN", ($row["complain"]=='0000-00-00 00:00:00')?"no":$row["complained"]);
$status = get_enum(T_TICKETS, "status");
$tmp_status = array();
foreach($status as $val) if($val != $row["status"]) $tmp_status[$val] = $val;
$xtpl->assign("ANOTHER_STATUS", get_drop_down_list($tmp_status, "status", "", "Select another status", 0, "", "onchange=\"document.getElementById('act').value='change_status'; document.getElementById('form1').submit();\""));
$priority=get_enum(T_TICKETS,"priority");
$tmp_priority=array();
foreach($priority as $val) $tmp_priority[$val] = $val;
$xtpl->assign("PRIORITY",$row["priority"]);
$xtpl->assign("ANOTHER_PRIORITY", get_drop_down_list($tmp_priority, "priority", "", "Select Priority", 0, "", "onchange=\"document.getElementById('act').value='change_priority'; document.getElementById('form1').submit();\""));
$query = "SELECT DISTINCT g.id, g.name
FROM " . T_USERS_GROUPS . " as ug, " . T_GROUPS . " as g
WHERE ug.user_id=" . $_SESSION["uid"] . "
AND ug.group_id=g.id
AND g.id != " . $row["group_id"];
$rows = SQL_select($query);
$queues = array();
foreach($rows as $val) $queues[$val["id"]] = $val["name"];
$quick_ticket_id = $_SESSION["selected_ticket_id"];
}else $quick_ticket_id = 0;
$prev_ticket_id = $quick_ticket_id-1;
$next_ticket_id = $quick_ticket_id+1;
$xtpl->assign("TICKET_NAV", "<form action='/show_ticket.php' id='quick_ticket_frm' style='display:inline;'><a href='/show_ticket.php?ticket_id={$prev_ticket_id}'>prev</a> <input type='text' name='ticket_id' class='input1' size='7' value='$quick_ticket_id' style='text-align:center'><!--<input type='submit' value='>' style='width:10px;'>--> <a href='/show_ticket.php?ticket_id={$next_ticket_id}'>next</a></form>");
//ticket menu section--
// $xtpl->assign("USERS_STATUS", "<img src=\"" . MAIN_HOST . "images/on-line.gif\" align=\"absmiddle\" alt=\"On-line\"><span class=\"whitetext2\">" . $row["num_users"] . "</span> <img src=\"" . MAIN_HOST . "images/off-line.gif\" align=\"absmiddle\" alt=\"Off-line\"><span class=\"whitetext2\">" . $row1["num_users"] . "</span>");//replaced by ticket menu
if(array_key_exists("website", $_REQUEST))
{
$_SESSION["website_url"] = $_REQUEST["website"];
}elseif(!array_key_exists("website_url", $_SESSION))
{
$def_website = get_enum(T_TICKETS, "website");
$_SESSION["website_url"] = $def_website[0];
}
$xtpl->assign("WEBSITE", get_drop_down_list(array(), "website", T_TICKETS, "", 0, $_SESSION["website_url"], "onchange=\"document.getElementById('website_form').submit();\""));
if ($myDB=="ccss")
{
$xtpl->assign("CURRENT", "External");
$link=$_SERVER['REQUEST_URL'];
$link .="?int=true";
$xtpl->assign("LINKS",$link);
}
else
{
$link=$_SERVER['REQUEST_URL'];
function get_check_boxs($values, $field_name, $table, $cols)
{
$enum = '';
if($table != "") $values = get_enum($table, $field_name);
$i=0;
$enum .= '<TABLE width="60%" border="0">';
$enum .= '<TR>';
foreach($values as $key=>$val)
{
if($table != "") $k = $val;
else $k = $key;
$enum .= '<TD WIDTH="' . ((int) 100/$cols) . '%" class="small2"><INPUT type="checkbox" name="' . $field_name . '[]" value="' . $k . '"';
if(array_key_exists($field_name, $_REQUEST))
{
if(is_array($_REQUEST[$field_name]))
{
if(count($_REQUEST[$field_name]) > 0)
{
foreach($_REQUEST[$field_name] as $v1)
{
if($k == $v1)
{
$enum .= " checked";
break;
}
}
}
}
}
$enum .= '>' . $val . '</TD>';
if (!(++$i % $cols)) $enum .= '</TR><TR>';
}
if ($i++ % $cols) $enum .= "<TD colspan=".(($cols - 1) - (++$i % $cols))."> </TD>";
$enum .= '</TR></TABLE>';
return $enum;
}
}
echo " </td>";
echo "<td>";
if ($fieldnames[$i] == "design_file") {
echo "<input type=\"file\" name=\"" . $fieldnames[$i] . "\"/><br><i>Please review our drawing <a href=\"#\" onclick=\"window.open('/filespecs.php','filespecs','status=0,toolbar=0,location=0,resizeable=1,scrollbars=1,menubar=0,directories=0,height=500,width=600');\">file requirements</a>.</i>";
} elseif ($fieldnames[$i] == "phone_number" || $fieldnames[$i] == "fax") {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($account[$fieldnames[$i]]) . "\" size=\"{$inputsize}\" onkeyup=\"inputmask(this.value,this,'phone');\" maxlength=\"12\"/>";
} elseif ($fieldnames[$i] == "zip") {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($account[$fieldnames[$i]]) . "\" size=\"{$inputsize}\" onkeyup=\"inputmask(this.value,this,'zip');\" maxlength=\"5\"/>";
} elseif (get_field_type("quotes", $fieldnames[$i]) == "text") {
echo "<textarea name=\"" . $fieldnames[$i] . "\" cols=\"40\" rows=\"7\">" . formvalue($account[$fieldnames[$i]]) . "</textarea>";
} elseif (get_field_type("quotes", $fieldnames[$i]) == "int") {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($account[$fieldnames[$i]]) . "\" size=\"{$inputsize}\" maxlength=\"7\" onkeyup=\"inputmask(this.value,this,'int');\"/>";
} elseif (get_field_type("quotes", $fieldnames[$i]) == "enum") {
echo "<select name=\"" . $fieldnames[$i] . "\">";
$vals = get_enum("quotes", $fieldnames[$i]);
for ($j = 0; $j < count($vals); $j++) {
echo "<option value=\"" . $vals[$j] . "\"";
if ($vals[$j] == $account[$fieldnames[$i]]) {
echo " selected=\"selected\"";
}
echo ">" . $vals[$j] . "</option>";
}
echo "</select>";
} else {
echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($account[$fieldnames[$i]]) . "\" size=\"{$inputsize}\"/>";
}
echo "</td></tr>\n";
}
}
echo "<tr><td> </td><td><input type=\"submit\" name=\"mysubmit\" value=\"Request Quote\"/></td></tr>";
