echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($row[$fieldnames[$i]]) . "\" size=\"60\" onkeyup=\"inputmask(this.value,this,'phone');\" maxlength=\"12\"/>"; } elseif ($fieldnames[$i] == "zip") { echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($row[$fieldnames[$i]]) . "\" size=\"60\" 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] . "\""; if ($vals[$j] == $row[$fieldnames[$i]]) { echo " selected=\"selected\""; } echo ">" . $vals[$j] . "</option>"; } echo "</select>"; } else { echo "<input type=\"text\" name=\"" . $fieldnames[$i] . "\" value=\"" . formvalue($row[$fieldnames[$i]]) . "\" size=\"60\"/>"; } echo "</td>"; echo "</tr>"; } } echo "<tr><td> </td><td><input type='submit' name='updateaccount' value='Update Account'/></td></tr>"; echo "</table>"; echo "<input type='hidden' name='action' value=''/>"; echo "</form>"; $result = mysql_query("SELECT quoteid,timestamp FROM quotes WHERE accountid='" . $accountrow["accountid"] . "' AND status!='incomplete' ORDER BY timestamp DESC"); if (mysql_num_rows($result) > 0) { echo "<hr>"; echo "<div class='pagetitle'>Quote History</div>"; echo "<table cellpadding='2' cellspacing='0' border='1'>"; echo "<tr><td align='center'><b>Date</b></td><td align='center'><b>Quote ID</b></td></tr>";
$temp = mysql_fetch_array(mysql_unbuffered_query($sql)); echo "</td>"; } elseif ($fieldnames[$i] == "project_name") { echo "<td>Project: " . formvalue($row[$fieldnames[$i]]) . "<br>"; } elseif ($fieldnames[$i] == "name") { echo "Client: " . formvalue($row[$fieldnames[$i]]) . "</td>"; } elseif ($fieldnames[$i] == "phone_number") { echo "<td>Phone: " . formvalue($row[$fieldnames[$i]]) . "<br>"; } elseif ($fieldnames[$i] == "email") { echo "Email: <a href=\"mailto:" . formvalue($row[$fieldnames[$i]]) . "\">" . formvalue($row[$fieldnames[$i]]) . "</a></td>"; } elseif ($fieldnames[$i] == "timestamp") { echo "<td>" . str_replace(" ", "<br>", date("m-d-y H:i", $row[$fieldnames[$i]])) . "</td>"; } elseif ($fieldnames[$i] == "quoteid") { echo "<td><a href='/admin/quote.php?quoteid=" . $row[$fieldnames[$i]] . "'>" . $row[$fieldnames[$i]] . "</td>"; } else { echo "<td>" . formvalue($row[$fieldnames[$i]]) . " </td>"; } } // FIND DESIGN FILES $sql = "SELECT * FROM design_files WHERE quoteid='" . $row["quoteid"] . "'"; $temp = mysql_unbuffered_query($sql); $files = ""; while ($t = mysql_fetch_array($temp)) { if ($files) { $files .= "<br>"; } $files .= "<a href='/admin/getdoc.php?fileid=" . $t["fileid"] . "' target='_blank'>" . $t["name"] . "</a>"; //$files.="<a href='/admin/designfiles/file_".$t["fileid"].$t["ext"]."' target='_blank'>".$t["name"]."</a>"; //$files.="<a href='/admin/getfile.php?fileid=".$t["fileid"]."' target='_blank'>".$t["name"]."</a>"; } if ($files) {
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>"; echo "</table>"; echo "<input type='hidden' name='MAX_FILE_SIZE' value='5000000'/>"; echo "<input type='hidden' name='action' value=''/>"; echo "<input type='hidden' name='accountid' value='" . $accountrow["accountid"] . "'/>"; echo "</form>"; ?>
echo "<tr><td>Password:</td><td><input type='password' name='password'/></td></tr>"; echo "<tr><td>Name:</td><td><input type='text' name='name'/></td></tr>"; echo "<tr><td>Phone Number:</td><td><input type='text' name='phone_number' onkeyup=\"inputmask(this.value,this,'phone');\" maxlength='12'/></td></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=''/>"; echo "</form>"; include '../footer.php'; exit; } echo "<form name='updateaccount' method='post' action='/account/index.php' onsubmit='return verify_update(this);'>"; echo "<table>"; echo "<tr><td>Email:</td><td><input type='text' name='email' value=\"" . formvalue($accountrow["email"]) . "\"/></td></tr>"; echo "<tr><td>Password:</td><td><input type='password' name='password' value=\"" . formvalue($accountrow["password"]) . "\"/></td></tr>"; echo "<tr><td>Name:</td><td><input type='text' name='name' value=\"" . formvalue($accountrow["name"]) . "\"/></td></tr>"; echo "<tr><td>Phone Number:</td><td><input type='text' name='phone_number' value=\"" . formvalue($accountrow["phone_number"]) . "\" onkeyup=\"inputmask(this.value,this,'phone');\" maxlength='12'/></td></tr>"; echo "<tr><td> </td><td><input type='submit' name='updateaccount' value='Update Account'/></td></tr>"; echo "</table>"; echo "<input type='hidden' name='action' value=''/>"; echo "</form>"; $result = mysql_query("SELECT quoteid,timestamp FROM quotes WHERE accountid='" . $accountrow["accountid"] . "' AND status!='incomplete' ORDER BY timestamp DESC"); if (mysql_num_rows($result) > 0) { echo "<hr>"; echo "<div class='pagetitle'>Quote History</div>"; echo "<table cellpadding='2' cellspacing='0' border='1'>"; echo "<tr><td align='center'><b>Date</b></td><td align='center'><b>Quote ID</b></td></tr>"; while ($row = mysql_fetch_array($result)) { echo "<tr><td align='center'>" . date("m-d-Y", $row["timestamp"]) . "</td><td align='right'><a href='/account/quote.php?quoteid=" . $row["quoteid"] . "'>" . $row["quoteid"] . "</a></td></tr>"; } echo "</table>"; }
echo ">" . $vals[$j] . "</option>"; } } echo "</select></td>"; } elseif ($fieldnames[$i] == "timestamp") { echo "<td>" . date("m-d-y H:i", $row[$fieldnames[$i]]) . "</td>"; } elseif ($fieldnames[$i] == "quoteid") { echo "<td><a href='/admin/quote.php?quoteid=" . $row[$fieldnames[$i]] . "'>" . $row[$fieldnames[$i]] . "</td>"; } elseif (strlike($fieldnames[$i], 'materials_supplied_by_')) { if ($row[$fieldnames[$i]]) { echo "<td>yes</td>"; } else { echo "<td>no</td>"; } } else { echo "<td>" . nl2br(formvalue($row[$fieldnames[$i]])) . " </td>"; } echo "</tr>"; } // DESIGN FILES $sql = "SELECT * FROM design_files WHERE quoteid='" . $row["quoteid"] . "'"; $temp = mysql_unbuffered_query($sql); $files = ""; while ($t = mysql_fetch_array($temp)) { if ($files) { $files .= "<br>"; } $files .= "<a href='/admin/getdoc.php?fileid=" . $t["fileid"] . "' target='_blank'>" . $t["name"] . "</a>"; //$files.="<a href='/admin/designfiles/file_".$t["fileid"].$t["ext"]."' target='_blank'>".$t["name"]."</a>"; } if ($files) {