Example #1
0
            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>&nbsp;</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>";
Example #2
0
         $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:&nbsp;" . formvalue($row[$fieldnames[$i]]) . "<br>";
     } elseif ($fieldnames[$i] == "email") {
         echo "Email:&nbsp;<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]]) . "&nbsp;</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) {
Example #3
0
            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>&nbsp;</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>";
?>



Example #4
0
    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>&nbsp;</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>&nbsp;</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>";
}
Example #5
0
                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]])) . "&nbsp;</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) {