$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>";